DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUP_SITE_CONTACT_INT

Line 383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,

379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
381: VENDOR_CONTACT_INTERFACE_ID NUMBER,
382: VENDOR_INTERFACE_ID NUMBER,
383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384: ORG_ID NUMBER,
385: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
386: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
387: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,

Line 385: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,

381: VENDOR_CONTACT_INTERFACE_ID NUMBER,
382: VENDOR_INTERFACE_ID NUMBER,
383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384: ORG_ID NUMBER,
385: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
386: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
387: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
388: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
389: );

Line 386: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,

382: VENDOR_INTERFACE_ID NUMBER,
383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384: ORG_ID NUMBER,
385: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
386: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
387: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
388: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
389: );
390:

Line 387: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,

383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384: ORG_ID NUMBER,
385: OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
386: PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
387: CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
388: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
389: );
390:
391:

Line 973: -- contacts based on AP_SUP_SITE_CONTACT_INT

969: --
970: -- Notes : Import Vendor Contacts,
971: -- called from Import Vendor Contacts Conc Program
972: -- This will call vendor sites API to create vendor
973: -- contacts based on AP_SUP_SITE_CONTACT_INT
974: --
975: -- End of comments
976:
977: PROCEDURE Import_Vendor_Contacts