DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORTING_CODES_B_S

Line 265: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

261: REPORTING_TYPE_ID ,
262: OBJECT_VERSION_NUMBER
263: )
264: SELECT
265: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
266: NULL ,--EXCEPTION_CODE
267: report_types.EFFECTIVE_FROM ,
268: NULL ,--EFFECTIVE_TO
269: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 581: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

577: REPORTING_TYPE_ID ,
578: OBJECT_VERSION_NUMBER
579: )
580: SELECT
581: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
582: NULL ,--EXCEPTION_CODE
583: EFFECTIVE_FROM ,
584: NULL ,--EFFECTIVE_TO
585: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 1073: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

1069: REPORTING_TYPE_ID ,
1070: OBJECT_VERSION_NUMBER
1071: )
1072: SELECT
1073: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
1074: NULL ,--EXCEPTION_CODE
1075: EFFECTIVE_FROM ,
1076: NULL ,--EFFECTIVE_TO
1077: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3507: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3503: REPORTING_TYPE_ID ,
3504: OBJECT_VERSION_NUMBER
3505: )
3506: SELECT
3507: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3508: NULL ,--EXCEPTION_CODE
3509: EFFECTIVE_FROM ,
3510: NULL ,--EFFECTIVE_TO
3511: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3579: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3575: REPORTING_TYPE_ID,
3576: OBJECT_VERSION_NUMBER
3577: )
3578: SELECT
3579: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3580: NULL ,--EXCEPTION_CODE
3581: EFFECTIVE_FROM ,
3582: NULL ,--EFFECTIVE_TO
3583: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3652: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3648: REPORTING_TYPE_ID ,
3649: OBJECT_VERSION_NUMBER
3650: )
3651: SELECT
3652: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3653: NULL ,--EXCEPTION_CODE
3654: effective_from ,
3655: NULL ,--EFFECTIVE_TO
3656: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3933: ZX_REPORTING_CODES_B_S.NEXTVAL,

3929: OBJECT_VERSION_NUMBER
3930: )
3931: VALUES
3932: (
3933: ZX_REPORTING_CODES_B_S.NEXTVAL,
3934: NULL,
3935: l_start_date,
3936: NULL,
3937: 'MIGRATED',

Line 4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;

4770: (select vat_tax_id from ar_vat_tax_all_b )
4771:
4772:
4773: LOOP
4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4775:
4776: INSERT ALL
4777: INTO
4778: ZX_REPORTING_CODES_B

Line 5018: ZX_REPORTING_CODES_B_S.NEXTVAL,

5014: OBJECT_VERSION_NUMBER
5015: )
5016: VALUES
5017: (
5018: ZX_REPORTING_CODES_B_S.NEXTVAL,
5019: NULL,
5020: l_start_date,
5021: NULL,
5022: 'MIGRATED',

Line 5082: ZX_REPORTING_CODES_B_S.NEXTVAL,

5078: OBJECT_VERSION_NUMBER
5079: )
5080: VALUES
5081: (
5082: ZX_REPORTING_CODES_B_S.NEXTVAL,
5083: NULL,
5084: l_start_date,
5085: NULL,
5086: 'MIGRATED',

Line 5318: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5314: REPORTING_TYPE_ID ,
5315: OBJECT_VERSION_NUMBER
5316: )
5317: SELECT
5318: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5319: NULL ,--EXCEPTION_CODE
5320: report_types.EFFECTIVE_FROM ,
5321: NULL ,--EFFECTIVE_TO
5322: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 5471: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5467: PROGRAM_LOGIN_ID ,
5468: OBJECT_VERSION_NUMBER
5469: )
5470: SELECT
5471: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5472: global_attribute ,--REPORTING_CODE_CHAR_VALUE
5473: NULL ,--REPORTING_CODE_NUM_VALUE
5474: NULL ,--REPORTING_CODE_DATE_VALUE
5475: reporting_type_id ,--REPORTING_TYPE_ID

Line 5667: ZX_REPORTING_CODES_B_S.NEXTVAL,

5663: OBJECT_VERSION_NUMBER
5664: )
5665: VALUES
5666: (
5667: ZX_REPORTING_CODES_B_S.NEXTVAL,
5668: NULL,
5669: l_start_date,
5670: NULL,
5671: 'MIGRATED',

Line 6271: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6267: REPORTING_TYPE_ID ,
6268: OBJECT_VERSION_NUMBER
6269: )
6270: SELECT
6271: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6272: NULL ,--EXCEPTION_CODE
6273: EFFECTIVE_FROM ,
6274: NULL ,--EFFECTIVE_TO
6275: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6538: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6534: REPORTING_TYPE_ID ,
6535: OBJECT_VERSION_NUMBER
6536: )
6537: SELECT
6538: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6539: NULL ,--EXCEPTION_CODE
6540: report_types.EFFECTIVE_FROM ,
6541: NULL ,--EFFECTIVE_TO
6542: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6691: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6687: REPORTING_TYPE_ID ,
6688: OBJECT_VERSION_NUMBER
6689: )
6690: SELECT
6691: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6692: NULL ,--EXCEPTION_CODE
6693: EFFECTIVE_FROM ,
6694: NULL ,--EFFECTIVE_TO
6695: 'SEEDED' ,--RECORD_TYPE_CODE

Line 7158: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7154: REPORTING_TYPE_ID ,
7155: OBJECT_VERSION_NUMBER
7156: )
7157: SELECT
7158: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7159: NULL ,--EXCEPTION_CODE
7160: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7161: NULL ,--EFFECTIVE_TO
7162: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7626: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7622: REPORTING_TYPE_ID ,
7623: OBJECT_VERSION_NUMBER
7624: )
7625: SELECT
7626: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7627: NULL ,--EXCEPTION_CODE
7628: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7629: NULL ,--EFFECTIVE_TO
7630: 'MIGRATED' ,--RECORD_TYPE_CODE