DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_SITES_INT

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

289: SERVICES_TOLERANCE_ID NUMBER,
290: SERVICES_TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
291: SHIPPING_LOCATION_ID NUMBER,
292: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
293: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
294: -- Bug 7437549 Start
295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,

Line 295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,

291: SHIPPING_LOCATION_ID NUMBER,
292: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
293: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
294: -- Bug 7437549 Start
295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,

Line 296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,

292: VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
293: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
294: -- Bug 7437549 Start
295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,

Line 297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,

293: VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
294: -- Bug 7437549 Start
295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End

Line 298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,

294: -- Bug 7437549 Start
295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End
302: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668

Line 299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,

295: EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End
302: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
303: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443

Line 300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,

296: EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297: EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298: EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End
302: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
303: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
304: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443

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

299: EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End
302: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
303: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
304: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
305: );
306: -- VAT_CODE ADDED TO ABOVE STRUCTURE Bug 6645014
307: -- To Import the VAT Code in Sites.

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

300: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301: -- Bug 7437549 End
302: PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
303: OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
304: AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
305: );
306: -- VAT_CODE ADDED TO ABOVE STRUCTURE Bug 6645014
307: -- To Import the VAT Code in Sites.
308:

Line 906: -- vendor sitess based on AP_SUPPLIER_SITES_INT

902: --
903: -- Notes : Import Vendor Sites,
904: -- called from Import Vendor Sites Conc Program
905: -- This will call vendor sites API to create
906: -- vendor sitess based on AP_SUPPLIER_SITES_INT
907: --
908: -- End of comments
909:
910: PROCEDURE Import_Vendor_Sites