Showing posts with label R12. Show all posts
Showing posts with label R12. Show all posts

Wednesday, April 23, 2014

New API's for Suppliers in R12

Name of Package: AP_VENDOR_PUB_PKG (apvndrs.pls and apvndrb.pls) 

AP_VENDOR_PUB_PKG.Create_Vendor

This is used to create new vendors in R12

AP_VENDOR_PUB_PKG.r_vendor_rec_type
If the TCA Party ID is provided in record type, the system will validate and create the new record in AP_SUPPLIERS else system calls TCA API to create API then create records in AP_Suppliers

AP_VENDOR_PUB_PKG.Update_Vendor_Public
Use to update vendor in R12


 AP_VENDOR_PUB_PKG.Create_Vendor_Site
 This is the new API to create new vendor sites in Release 12.


AP_VENDOR_PUB_PKG.Update_Vendor_Site_Public
        This is the new API to update Vendor Sites in Release 12.

AP_VENDOR_PUB_PKG.Create_Vendor_Contact
        This is the new API to create new vendor site contacts in Release 12. 

AP_VENDOR_PUB_PKG.Update_Vendor_Contact_Public
        This is the new API to update Vendor Contacts in Release 12.

 

CONCURRENT PROGRAMS IN R12 SUPPLIERS

       APXSUIMP - SUPPLIER OPEN INTERFACE IMPORT 

Supplier Open Interface Import program is extended to create Parties in TCA when creating the suppliers based on the information in AP_SUPPLIERS_INT. If records are populated in the IBY External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts.


 APXSSIMP -- Supplier Sites Open Interface Import Supplier Sites Open Interface Import program is extended to create Locations, Party Sites, and Party Site Uses in TCA based on the information provided in AP_SUPPLIER_SITES_INT. If records are populated in the Payments External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts for the site. 

APXSCIMP -- Supplier Site Contacts Open Interface Import Supplier Sites Contacts Open Interface Import program is extended to create Person Parties, Contact Relationships, Org Contacts, Contact Party Sites, and Contact Points in TCA based on the information provided in AP_SUPPLIER_SITES_INT. 



New Tables in R12 Suppliers

AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS
AP_SUPPLIER_INT_REJECTIONS