Tuesday, 28 August 2012

SUPPLIER API FOR CONTACT

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

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...