DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUP_SITE_CONTACT_INT

Line 358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,

354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359: ORG_ID NUMBER,
360: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
361: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
362: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,

Line 360: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,

356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359: ORG_ID NUMBER,
360: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
361: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
362: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
363: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
364: );

Line 361: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,

357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359: ORG_ID NUMBER,
360: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
361: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
362: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
363: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
364: );
365:

Line 362: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,

358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359: ORG_ID NUMBER,
360: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
361: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
362: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
363: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
364: );
365:
366:

Line 947: -- contacts based on AP_SUP_SITE_CONTACT_INT

943: --
944: -- Notes : Import Vendor Contacts,
945: -- called from Import Vendor Contacts Conc Program
946: -- This will call vendor sites API to create vendor
947: -- contacts based on AP_SUP_SITE_CONTACT_INT
948: --
949: -- End of comments
950:
951: PROCEDURE Import_Vendor_Contacts