Account Payable (AP) Important Tables
Table Name Description 1 AP_SUPPLIERS This table replaces the old PO_VENDORS table It stores information about your supplier level attributes Each row includes the
Category: EBS Payable Supplier API
Rarely Used Account Payables APIs
These APIs are handful when you want to do Insert, Update or Delete in some AP Base tables i.e. AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_PAYMENTS and AP_CHECKS_ALL
API to Create Party Site for Bank Branch with Location in Oracle Apps R12
DECLAREp_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;x_party_site_id NUMBER;x_party_site_number VARCHAR2(2000);x_return_status VARCHAR2(2000);x_msg_count
Create Bank Account using API in Oracle Apps R12
DECLAREp_count NUMBER;p_init_msg_list VARCHAR2(200);p_acct_rec apps.ce_bank_pub.bankacct_rec_type;x_acct_id NUMBER;x_msg_count NUMBER;x_msg_data
Create Bank Account in IBY using API in Oracle Apps R12
DECLAREp_api_version NUMBER := 1.0;p_init_msg_list VARCHAR2(1) := ‘F’;p_count
Create Address for Bank Branch API in Oracle Apps R12
DECLAREp_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;x_location_id NUMBER;x_return_status VARCHAR2(2000);x_msg_count NUMBER;x_msg_data VARCHAR2(2000); BEGINp_location_rec.country
Create Internal Bank Branch API in Oracle Apps R12
DECLAREp_init_msg_list VARCHAR2(200);p_branch_name VARCHAR2(200);p_branch_number
Create External Bank Branch API in Oracle Apps R12
DECLAREp_api_version NUMBER := 1.0;p_init_msg_list VARCHAR2(1) := ‘F’; v_bank_id NUMBER := 530705;x_return_status VARCHAR2(2000);x_msg_count
Create External Bank API in Oracle Apps R12
DECLARElc_output VARCHAR2(3000);lc_msg_dummy VARCHAR2(3000);lc_return_status VARCHAR2(3000);lc_msg_data VARCHAR2(3000);ln_bank_id NUMBER;ln_msg_count NUMBER;lr_extbank_rec apps.iby_ext_bankacct_pub.extbank_rec_type;lr_response_rec apps.iby_fndcpt_common_pub.result_rec_type; BEGINlc_return_status := ”;ln_msg_count
Create Supplier Site using API in Oracle Apps R12
DECLAREl_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;lc_return_status VARCHAR2(10);ln_msg_count NUMBER;lc_msg_data VARCHAR2(1000);ln_vendor_site_id NUMBER;ln_party_site_id NUMBER;ln_location_id NUMBER; BEGIN — Requiredl_vendor_site_rec.vendor_id