eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_SITES_INT

Line 303: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036

299: SERVICES_TOLERANCE_ID NUMBER,
300: SERVICES_TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
301: SHIPPING_LOCATION_ID NUMBER,
302: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
303: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,

Line 304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389

300: SERVICES_TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
301: SHIPPING_LOCATION_ID NUMBER,
302: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
303: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,

Line 306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,

302: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
303: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,

Line 307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,

303: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,

Line 308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,

304: REMITTANCE_EMAIL AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End

Line 309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,

305: -- Bug 7437549 Start
306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668

Line 310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,

306: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443

Line 311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,

307: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443

Line 314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443

310: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
316: ,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE -- Bug 8422781
317: ,REMIT_ADVICE_FAX AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088
318: -- starting the Changes for CLM reference data management bug#9499174

Line 315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443

311: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
316: ,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE -- Bug 8422781
317: ,REMIT_ADVICE_FAX AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088
318: -- starting the Changes for CLM reference data management bug#9499174
319: ,CAGE_CODE AP_SUPPLIER_SITES_ALL.CAGE_CODE%TYPE ,

Line 316: ,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE -- Bug 8422781

312: -- Bug 7437549 End
313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
316: ,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE -- Bug 8422781
317: ,REMIT_ADVICE_FAX AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088
318: -- starting the Changes for CLM reference data management bug#9499174
319: ,CAGE_CODE AP_SUPPLIER_SITES_ALL.CAGE_CODE%TYPE ,
320: LEGAL_BUSINESS_NAME AP_SUPPLIER_SITES_ALL.LEGAL_BUSINESS_NAME%TYPE ,

Line 317: ,REMIT_ADVICE_FAX AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088

313: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
316: ,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE -- Bug 8422781
317: ,REMIT_ADVICE_FAX AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088
318: -- starting the Changes for CLM reference data management bug#9499174
319: ,CAGE_CODE AP_SUPPLIER_SITES_ALL.CAGE_CODE%TYPE ,
320: LEGAL_BUSINESS_NAME AP_SUPPLIER_SITES_ALL.LEGAL_BUSINESS_NAME%TYPE ,
321: DOING_BUS_AS_NAME AP_SUPPLIER_SITES_ALL.DOING_BUS_AS_NAME%TYPE ,

Line 931: -- vendor sitess based on AP_SUPPLIER_SITES_INT

927: --
928: -- Notes : Import Vendor Sites,
929: -- called from Import Vendor Sites Conc Program
930: -- This will call vendor sites API to create
931: -- vendor sitess based on AP_SUPPLIER_SITES_INT
932: --
933: -- End of comments
934:
935: PROCEDURE Import_Vendor_Sites