===================Create AR Invoice======================
AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE
===================Update AP Invoice =====================
AP_INVOICES_PKG.UPDATE_ROW
=================Create Supplier Classification================
POS_SUPP_CLASSIFICATION_PKG.ADD_BUS_CLASS_ATTR
=================Create Asset Activity======================
EAM_ITEM_ACTIVITIES_PUB.INSERT_ITEM_ACTIVITIES
=================Create Assets===========================
FA_ADDITION_PUB.DO_ADDITION
==================Assign Item To Child Organization===========
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
==================Create or Update Customer All APIs==================
1) Create
HZ_PARTY_V2PUB.CREATE_PERSON
HZ_PARTY_V2PUB.CREATE_ORGANIZATION
HZ_LOCATION_V2PUB.CREATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
2) Update
HZ_PARTY_V2PUB.UPDATE_PERSON
HZ_PARTY_V2PUB.UPDATE_ORGANIZATION
HZ_LOCATION_V2PUB.UPDATE_LOCATION
HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE
HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_ACCT_SITE
HZ_CONTACT_POINT_V2PUB.UPDATE_CONTACT_POINT
========================Create Precinct=====================
PNT_PROPERTIES_PKG.INSERT_ROW
=========Create Buildings, Floor,Residential and Retail Units==========
PNT_LOCATIONS_PKG.INSERT_ROW
Note :- For All the API is Same only Change in
If Building then
location_type_lookup_code => 'BUILDING'
If Floor then
location_type_lookup_code => 'FLOOR'
If Retail Or Residentioal then
location_type_lookup_code => 'OFFICE'
=======================Create Residential and Retail Lease=============
PN_LEASES_PKG. INSERT_ROW
=======================Supplier All APIs==========================
--Create Supplier
AP_VENDOR_PUB_PKG.CREATE_VENDOR
Create Supplier Site
AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE
--Create Bank
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK
--Branch Create
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
--Create Bank Account
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT
--Bank Account Assign
IBY_DISBURSEMENT_SETUP_PUB.SET_PAYEE_INSTR_ASSIGNMENT
--Create Supplier Contact
AP_VENDOR_PUB_PKG.CREATE_VENDOR_CONTACT
=================Create Competency====================
================Create Position Hierarchy================
AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE
===================Update AP Invoice =====================
AP_INVOICES_PKG.UPDATE_ROW
=================Create Supplier Classification================
POS_SUPP_CLASSIFICATION_PKG.ADD_BUS_CLASS_ATTR
=================Create Asset Activity======================
EAM_ITEM_ACTIVITIES_PUB.INSERT_ITEM_ACTIVITIES
=================Create Assets===========================
FA_ADDITION_PUB.DO_ADDITION
==================Assign Item To Child Organization===========
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
==================Create or Update Customer All APIs==================
1) Create
HZ_PARTY_V2PUB.CREATE_PERSON
HZ_PARTY_V2PUB.CREATE_ORGANIZATION
HZ_LOCATION_V2PUB.CREATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
2) Update
HZ_PARTY_V2PUB.UPDATE_PERSON
HZ_PARTY_V2PUB.UPDATE_ORGANIZATION
HZ_LOCATION_V2PUB.UPDATE_LOCATION
HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE
HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_ACCT_SITE
HZ_CONTACT_POINT_V2PUB.UPDATE_CONTACT_POINT
========================Create Precinct=====================
PNT_PROPERTIES_PKG.INSERT_ROW
=========Create Buildings, Floor,Residential and Retail Units==========
PNT_LOCATIONS_PKG.INSERT_ROW
Note :- For All the API is Same only Change in
If Building then
location_type_lookup_code => 'BUILDING'
If Floor then
location_type_lookup_code => 'FLOOR'
If Retail Or Residentioal then
location_type_lookup_code => 'OFFICE'
=======================Create Residential and Retail Lease=============
PN_LEASES_PKG. INSERT_ROW
=======================Supplier All APIs==========================
--Create Supplier
AP_VENDOR_PUB_PKG.CREATE_VENDOR
Create Supplier Site
AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE
--Create Bank
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK
--Branch Create
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
--Create Bank Account
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT
--Bank Account Assign
IBY_DISBURSEMENT_SETUP_PUB.SET_PAYEE_INSTR_ASSIGNMENT
--Create Supplier Contact
AP_VENDOR_PUB_PKG.CREATE_VENDOR_CONTACT
====================== Create Executable and Concurrent Program======
Executable :- FND_PROGRAM.EXECUTABLE
Concurrent Program :- FND_PROGRAM.REGISTER
=====================Run Concurrent Program With Template ============
FND_REQUEST.ADD_LAYOUT
FND_REQUEST.SUBMIT_REQUEST
====================Delete Data Template , Executable and Concurrent =======
--DATA TEMPLATE
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW (<TEMPLATE_APP_NAME>, <TEMPLATE_CODE>);
COMMIT;
END;
--DATA DEFINITION
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW (<DATA_DEF_APP_NAME>,<DATA_DEF_CODE>);
COMMIT;
END;
--EXECUTABLE PROGRAM
BEGIN
FND_PROGRAM.DELETE_EXECUTABLE(LV_PROG_SHORT_NAME, LV_APPL_SHORT_NAME);
COMMIT;
END;
--CONNCURENT PROGRAM
BEGIN
FND_PROGRAM.DELETE_PROGRAM(LV_PROG_SHORT_NAME, LV_APPL_SHORT_NAME);
COMMIT;
END;
=======================Create Item=============================
EGO_ITEM_PUB.PROCESS_ITEMS
========================Create Locator ============================
INV_LOC_WMS_PUB.CREATE_LOCATOR
===================Create Preventive Maintenance Schedule Oracle EAM====
EAM_PMDEF_PUB.UPDATE_PM_DEF
EAM_PMDEF_PUB.CREATE_PM_DEF
=======================Create Employee=========================
HR_SA_EMPLOYEE_API.CREATE_SA_EMPLOYEE
HR_COMPETENCE_ELEMENT_API.CREATE_COMPETENCE_ELEMENT
=================Create Organization Manager=============
HR_ORGANIZATION_API.CREATE_ORG_MANAGER
HR_POS_HIERARCHY_ELE_API.CREATE_POS_HIERARCHY_ELE
==================Create Responsibility ========================
FND_USER_PKG.ADDRESP
===================Create User=================================
FND_USER_PKG.CREATEUSER