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

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