AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_CONTACT
Parameter for this API as given below:
P_VENDOR_SITE_ID NUMBER IN DEFAULT
P_FIRST_NAME VARCHAR2 IN DEFAULT
P_LAST_NAME VARCHAR2 IN DEFAULT
P_MIDDLE_NAME VARCHAR2 IN DEFAULT
P_PREFIX VARCHAR2 IN DEFAULT
P_TITLE VARCHAR2 IN DEFAULT
P_MAIL_STOP VARCHAR2 IN DEFAULT
P_AREA_CODE VARCHAR2 IN DEFAULT
P_PHONE VARCHAR2 IN DEFAULT
P_ALT_AREA_CODE VARCHAR2 IN DEFAULT
P_ALT_PHONE VARCHAR2 IN DEFAULT
P_FAX_AREA_CODE VARCHAR2 IN DEFAULT
P_FAX VARCHAR2 IN DEFAULT
P_EMAIL_ADDRESS VARCHAR2 IN DEFAULT
P_URL VARCHAR2 IN DEFAULT
X_VENDOR_CONTACT_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
Parameter for this API as given below:
P_VENDOR_SITE_ID NUMBER IN DEFAULT
P_FIRST_NAME VARCHAR2 IN DEFAULT
P_LAST_NAME VARCHAR2 IN DEFAULT
P_MIDDLE_NAME VARCHAR2 IN DEFAULT
P_PREFIX VARCHAR2 IN DEFAULT
P_TITLE VARCHAR2 IN DEFAULT
P_MAIL_STOP VARCHAR2 IN DEFAULT
P_AREA_CODE VARCHAR2 IN DEFAULT
P_PHONE VARCHAR2 IN DEFAULT
P_ALT_AREA_CODE VARCHAR2 IN DEFAULT
P_ALT_PHONE VARCHAR2 IN DEFAULT
P_FAX_AREA_CODE VARCHAR2 IN DEFAULT
P_FAX VARCHAR2 IN DEFAULT
P_EMAIL_ADDRESS VARCHAR2 IN DEFAULT
P_URL VARCHAR2 IN DEFAULT
X_VENDOR_CONTACT_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
No comments:
Post a Comment