DBA Data[Home] [Help]

APPS.ZX_PTP_CUST_MIG_PKG dependencies on ZX_PARTY_TAX_PROFILE_S

Line 100: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

96: ,OBJECT_VERSION_NUMBER
97: )
98: VALUES
99: (
100: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
101: ,PARTY_ID -- Party ID
102: ,TAX_REFERENCE -- Rep Registration Number
103: ,NULL -- Registration Type
104: ,COUNTRY_CODE -- Country Code

Line 234: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

230: ,PROGRAM_LOGIN_ID
231: ,OBJECT_VERSION_NUMBER
232: )
233: SELECT
234: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
235: ,HZPS.PARTY_SITE_ID -- Party ID
236: ,PTP.Rep_Registration_Number --- Rep Registration
237: ,NULL
238: ,PTP.COUNTRY_CODE

Line 508: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20000';

504:
505: PROCEDURE ZX_PTP_CUST_MIG IS
506: BEGIN
507:
508: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20000';
509:
510: arp_util_tax.debug(' ZX_PTP_CUST_MIG... (+) ' );
511:
512: arp_util_tax.debug(' Calling CREATE_LOOKUPS.. ' );

Line 524: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20';

520: arp_util_tax.debug(' Calling CUSTOMER_SITE_MIGRATE.. ' );
521:
522: --ZX_PTP_CUST_MIG_PKG.CUSTOMER_SITE_MIGRATE;
523:
524: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20';
525:
526: END ZX_PTP_CUST_MIG;
527:
528: