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
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
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.. ' );
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: