Tuesday, 28 August 2012

SUPPLIER API

Procedure : AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR

Parameter for this API  as given below
P_VENDOR_NAME                                     VARCHAR2                IN
P_VENDOR_TYPE_LOOKUP_CODE         VARCHAR2                IN
P_TAXPAYER_ID                                         VARCHAR2                IN                        
P_TAX_REGISTRATION_ID                       VARCHAR2                IN     
P_WOMEN_OWNED_FLAG                        VARCHAR2                IN    
P_SMALL_BUSINESS_FLAG                       VARCHAR2                IN   
P_MINORITY_GROUP_LOOKUP_CODE   VARCHAR2                IN
P_SUPPLIER_NUMBER                              NUMBER                    OUT      
X_VENDOR_ID                                           VARCHAR2                OUT            
X_STATUS                                                   VARCHAR2                OUT
X_EXCEPTION_MSG                                  VARCHAR2                IN
P_SOURCE                                                     VARCHAR2                IN
P_WHAT_TO_IMPORT                                VARCHAR2                IN
P_COMMIT_SIZE                                          VARCHAR2                IN

No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...