AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_SITE
Parameter for this API as given below:
P_VENDOR_SITE_CODE VARCHAR2 IN
P_VENDOR_ID NUMBER IN
P_ORG_ID VARCHAR2 IN
P_ADDRESS_LINE1 VARCHAR2 IN
P_ADDRESS_LINE2 VARCHAR2 IN
P_ADDRESS_LINE3 VARCHAR2 IN
P_ADDRESS_LINE4 VARCHAR2 IN
P_CITY VARCHAR2 IN
P_STATE VARCHAR2 IN
P_ZIP VARCHAR2 IN
P_PROVINCE VARCHAR2 IN
P_COUNTY VARCHAR2 IN
P_COUNTRY VARCHAR2 IN
P_AREA_CODE VARCHAR2 IN
P_PHONE VARCHAR2 IN
P_FAX_AREA_CODE VARCHAR2 IN
P_FAX VARCHAR2 IN
P_EMAIL_ADDRESS VARCHAR2 IN
P_PURCHASING_SITE_FLAG VARCHAR2 IN DEFAULT
P_PAY_SITE_FLAG VARCHAR2 IN DEFAULT
P_RFQ_ONLY_SITE_FLAG VARCHAR2 IN DEFAULT
X_VENDOR_SITE_ID NUMBER OUT
X_STATUS VARCHAR2 OUT
X_EXCEPTION_MSG VARCHAR2 OUT
P_SOURCE VARCHAR2 IN DEFAULT
P_WHAT_TO_IMPORT VARCHAR2 IN DEFAULT
P_COMMIT_SIZE NUMBER IN DEFAULT
P_HOLD_UNVALIDATED_INV_FLAG VARCHAR2 IN DEFAULT
P_HOLD_ALL_PAYMENTS_FLAG VARCHAR2 IN DEFAULT
P_DUNS_NUMBER VARCHAR2 IN DEFAULT
No comments:
Post a Comment