Oracle Seeded APIs in Oracle Apps R12
## Price List Creation APIs
QP_PRICE_LIST_PUB.PROCESS_PRICE_LIST
QP_PRICE_FORMULA_PUB.PROCESS_PRICE_FORMULA
## Sales Order Creation APIs
OE_ORDER_PUB.PROCESS_ORDER
OE_HOLD_PUB.APPLY_HOLDS
WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES
WSH_DELIVERIES_PUB.DELIVERY_ACTION
WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES
WSH_FREIGHT_COSTS_PUB.CREATE_UPDATE_FREIGHT_COSTS
WSH_CONTAINER_PUB.AUTO_PACK
## Item Creation API
EGO_ITEM_PUB.PROCESS_ITEM
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY
INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT
INV_LOC_WMS_PUB.CREATE_LOCATOR
## Customer Creation APIs
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
HZ_LOCATION_V2PUB.CREATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUST_PROFILE_AMT
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
HZ_PARTY_V2PUB.CREATE_PERSON
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT
HZ_PARTY_V2PUB.CREATE_ORGANIZATION
## Supplier Creation APIs
AP_VENDOR_PUB.CREATE_VENDOR
AP_VENDOR_PUB.CREATE_VENDOR_SITE
AP_VENDOR_PUB.CREATE_VENDOR_CONTACT
## Banks Creation APIs
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT
— IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee
— IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment
## AR Invoice Creation API
AR_INVOICE_API_PUB.CREATE_INVOICE
## AR CAsh Receipt Creation APIs
AR_RECEIPT_API_PUB.CREATE_CASH
AR_RECEIPT_API_PUB.APPLY
AR_RECEIPT_API_PUB.APPLY_IN_DETAIL
AR_RECEIPT_API_PUB.UNAPPLY
AR_RECEIPT_API_PUB.CREATE_AND_APPLY
AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT
AR_RECEIPT_API_PUB.UNAPPLY_ON_ACCOUNT
AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION
AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION
AR_RECEIPT_API_PUB.CREATE_MISC
AR_RECEIPT_API_PUB.APPLY_OPEN_RECEIPT
AR_RECEIPT_API_PUB.UNAPPLY_OPEN_RECEIPT
## Employee Creations APIs
HR_EMPLOYEE_API.CREATE_EMPLOYEE
HR_PERSON_API.UPDATE_PERSON
HR_CONTACT_REL_API.CREATE_CONTACT
HR_EMPLOYEE_API.HIRE_INTO_JOB
HR_ASSIGNMENT_API.UPDATE_EMP_ASG
HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA
HR_PERSON_ADDRESS_API.CREATE_PERSON_ADDRESS
HR_PERSON_ADDRESS_API.UPDATE_PERSON_ADDRESS
PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY
PAY_ELEMENT_ENTRY_API.DELETE_ELEMENT_ENTRY
HR_EMPLOYEE_API.RE_HIRE_EX_EMPLOYEE
HR_PERSONAL_PAY_METHOD_API.CREATE_PERSONAL_PAY_METHOD
HR_PHONE_API.CREATE_OR_UPDATE_PHONE
HR_MAINTAIN_PROPOSAL_API.CRE_OR_UPD_SALARY_PROPOSAL
## Fnd User Creation APIs
FND_USER_PKG.CREATEUSER
FND_USER_PKG.UPDATEUSER
FND_USER_PKG.ADDRESP
FND_USER_PKG.DELRESP
Interface Tables/Programs in Oracle Apps R12
PO Requisition Creation
=======================================================================
## Interface Tables:
PO_REQUISITIONS_INTERFACE_ALL
## Error Table
PO_INTERRFACE_ERRORS
## Base Tables:
PO_REQUISITIONS_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
## Oracle Seeded Concurrent Program
Requisition Import
=======================================================================
Purchase Orders Creation
=======================================================================
## Interface Tables:
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
## Error Table
PO_INTERRFACE_ERRORS
## Base Tables:
PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
## Oracle Seeded Concurrent Program
Import Standard Purchase Orders
=======================================================================
Sales Orders Creation
=======================================================================
## Interface Tables:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
## Base Tables:
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
## Oracle Seeded Concurrent Program
Order Import
=======================================================================
Price List Creation
=======================================================================
## Interface Tables:
QP_INTERFACE_LIST_HEADERS
QP_INTERFACE_LIST_LINES
QP_INTERFACE_PRICING_ATTRIBS
QP_INTERFACE_ERRORS
## Base Tables:
QP_LIST_HEADERS
QP_LIST_LINES
QP_PRICING_ATTRIBUTES
## Oracle Seeded Concurrent Program
QP: Bulk Import of Price List
=======================================================================
Customers Creation
=======================================================================
## Interface Tables:
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
## Base Tables:
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCOUNTS_ALL
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES
HZ_PARTY_RELATIONSHIPS
HZ_CONTACT_POINTS
HZ_ORG_CONTACTS
## Oracle Seeded Concurrent Program
Customer Interface
=======================================================================
Items Creation
=======================================================================
## Interface Tables:
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
MTL_INTERFACE_ERRORS
## Base Tables:
MTL_SYSTEM_ITEMS_B
MTL_ITEM_REVISIONS_B
MTL_CATEGORIES_B
MTL_CATEGORY_SETS_B
MTL_ITEM_STATUS
MTL_ITEM_TEMPLATES
## Oracle Seeded Concurrent Program
Item Import
=======================================================================
Suppliers Creation
=======================================================================
## Interface Tables:
AP_SUPPILERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACTS_INT
AP_SUPPLIER_INT_REJECTIONS
## Base Tables:
AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS
## Oracle Seeded Concurrent Program
Supplier Open Interface Import
Supplier Sites Open Interface Import
Supplier Site Contacts Open Interface Import
No comments:
Post a Comment