DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORTING_TYPES_B_S

Line 346: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

342: PROGRAM_LOGIN_ID ,
343: OBJECT_VERSION_NUMBER
344: )
345: VALUES(
346: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
347: 'FISCAL PRINTER' ,--REPORTING_TYPE_CODE
348: 'YES_NO' ,--REPORTING_TYPE_DATATYPE
349: l_tax_regime_code ,--TAX_REGIME_CODE
350: NULL ,--TAX

Line 403: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

399: PROGRAM_LOGIN_ID ,
400: OBJECT_VERSION_NUMBER
401: )
402: VALUES(
403: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
404: 'CAI NUMBER' ,--REPORTING_TYPE_CODE
405: --'NUMBER' ,--REPORTING_TYPE_DATATYPE
406: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
407: l_tax_regime_code ,--TAX_REGIME_CODE

Line 921: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

917: PROGRAM_LOGIN_ID ,
918: OBJECT_VERSION_NUMBER
919: )
920: VALUES(
921: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
922: p_reporting_type_code ,--REPORTING_TYPE_CODE
923: p_datatype , --REPORTING_TYPE_DATATYPE
924: l_tax_regime_code ,
925: NULL ,--TAX

Line 1010: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

1006: PROGRAM_LOGIN_ID ,
1007: OBJECT_VERSION_NUMBER
1008: )
1009: VALUES(
1010: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
1011: p_reporting_type_code ,--REPORTING_TYPE_CODE
1012: p_datatype , --REPORTING_TYPE_DATATYPE
1013: l_tax_regime_code ,
1014: NULL ,--TAX

Line 2974: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

2970: PROGRAM_LOGIN_ID ,
2971: OBJECT_VERSION_NUMBER
2972: )
2973: VALUES(
2974: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
2975: 'PT_LOCATION' ,--REPORTING_TYPE_CODE
2976: 'TEXT' ,--REPORTING_TYPE_DATATYPE
2977: l_tax_regime_code ,
2978: NULL ,--TAX

Line 3029: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

3025: PROGRAM_LOGIN_ID ,
3026: OBJECT_VERSION_NUMBER
3027: )
3028: VALUES(
3029: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
3030: 'PT_PRD_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
3031: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3032: l_tax_regime_code ,
3033: NULL ,--TAX

Line 3084: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

3080: PROGRAM_LOGIN_ID ,
3081: OBJECT_VERSION_NUMBER
3082: )
3083: VALUES(
3084: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3085: 'PT_PRD_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
3086: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3087: l_tax_regime_code ,
3088: NULL ,--TAX

Line 3139: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

3135: PROGRAM_LOGIN_ID ,
3136: OBJECT_VERSION_NUMBER
3137: )
3138: VALUES(
3139: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3140: 'PT_ANL_TTL_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
3141: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3142: l_tax_regime_code ,
3143: NULL ,--TAX

Line 3194: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

3190: PROGRAM_LOGIN_ID ,
3191: OBJECT_VERSION_NUMBER
3192: )
3193: VALUES(
3194: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3195: 'PT_ANL_REC_TAXABLE' ,--REPORTING_TYPE_CODE
3196: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3197: l_tax_regime_code ,
3198: NULL ,--TAX

Line 3249: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

3245: PROGRAM_LOGIN_ID ,
3246: OBJECT_VERSION_NUMBER
3247: )
3248: VALUES(
3249: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3250: 'PT_ANL_NON_REC_TAXABLE' ,--REPORTING_TYPE_CODE
3251: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3252: l_tax_regime_code ,
3253: NULL ,--TAX

Line 3304: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

3300: PROGRAM_LOGIN_ID ,
3301: OBJECT_VERSION_NUMBER
3302: )
3303: VALUES(
3304: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3305: 'PT_ANL_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
3306: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3307: l_tax_regime_code ,
3308: NULL ,--TAX

Line 3379: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3375: PROGRAM_LOGIN_ID ,
3376: OBJECT_VERSION_NUMBER
3377: )
3378: VALUES(
3379: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3380: 'AR_DGI_TRX_CODE' ,--REPORTING_TYPE_CODE
3381: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3382: l_tax_regime_code ,
3383: NULL ,--TAX

Line 3454: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3450: PROGRAM_LOGIN_ID ,
3451: OBJECT_VERSION_NUMBER
3452: )
3453: VALUES(
3454: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3455: 'CL_TAX_CODE_CLASSIF' ,--REPORTING_TYPE_CODE
3456: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3457: l_tax_regime_code ,
3458: NULL ,--TAX

Line 3892: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3888: PROGRAM_LOGIN_ID ,
3889: OBJECT_VERSION_NUMBER
3890: )
3891: VALUES(
3892: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3893: 'KR_BUSINESS_LOCATIONS' ,--REPORTING_TYPE_CODE
3894: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
3895: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
3896: l_tax_regime_code ,--TAX_REGIME_CODE

Line 4161: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID

4157: PROGRAM_LOGIN_ID ,
4158: OBJECT_VERSION_NUMBER
4159: )
4160: VALUES(
4161: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
4162: 'PT_LOCATION' ,--REPORTING_TYPE_CODE
4163: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4164: l_tax_regime_code ,
4165: NULL ,--TAX

Line 4216: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4212: PROGRAM_LOGIN_ID ,
4213: OBJECT_VERSION_NUMBER
4214: )
4215: VALUES(
4216: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4217: 'PT_PRD_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
4218: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4219: l_tax_regime_code ,
4220: NULL ,--TAX

Line 4271: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4267: PROGRAM_LOGIN_ID ,
4268: OBJECT_VERSION_NUMBER
4269: )
4270: VALUES(
4271: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4272: 'PT_PRD_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
4273: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4274: l_tax_regime_code ,
4275: NULL ,--TAX

Line 4326: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4322: PROGRAM_LOGIN_ID ,
4323: OBJECT_VERSION_NUMBER
4324: )
4325: VALUES(
4326: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4327: 'PT_ANL_TTL_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
4328: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4329: l_tax_regime_code ,
4330: NULL ,--TAX

Line 4381: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4377: PROGRAM_LOGIN_ID ,
4378: OBJECT_VERSION_NUMBER
4379: )
4380: VALUES(
4381: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4382: 'PT_ANL_REC_TAXABLE' ,--REPORTING_TYPE_CODE
4383: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4384: l_tax_regime_code ,
4385: NULL ,--TAX

Line 4436: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4432: PROGRAM_LOGIN_ID ,
4433: OBJECT_VERSION_NUMBER
4434: )
4435: VALUES(
4436: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4437: 'PT_ANL_NON_REC_TAXABLE' ,--REPORTING_TYPE_CODE
4438: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4439: l_tax_regime_code ,
4440: NULL ,--TAX

Line 4491: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4487: PROGRAM_LOGIN_ID ,
4488: OBJECT_VERSION_NUMBER
4489: )
4490: VALUES(
4491: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4492: 'PT_ANL_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
4493: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4494: l_tax_regime_code ,
4495: NULL ,--TAX

Line 4563: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4559: PROGRAM_LOGIN_ID ,
4560: OBJECT_VERSION_NUMBER
4561: )
4562: VALUES(
4563: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4564: 'AR_DGI_TRX_CODE' ,--REPORTING_TYPE_CODE
4565: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4566: l_tax_regime_code ,
4567: NULL ,--TAX

Line 4618: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4614: PROGRAM_LOGIN_ID ,
4615: OBJECT_VERSION_NUMBER
4616: )
4617: VALUES(
4618: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4619: 'AR_MUNICIPAL_JUR' ,--REPORTING_TYPE_CODE
4620: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4621: l_tax_regime_code ,
4622: NULL ,--TAX

Line 4673: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID

4669: PROGRAM_LOGIN_ID ,
4670: OBJECT_VERSION_NUMBER
4671: )
4672: VALUES(
4673: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4674: 'AR_TURN_OVER_JUR_CODE' ,--REPORTING_TYPE_CODE
4675: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4676: l_tax_regime_code ,
4677: NULL ,--TAX

Line 4750: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

4746: PROGRAM_LOGIN_ID ,
4747: OBJECT_VERSION_NUMBER
4748: )
4749: VALUES(
4750: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
4751: 'PRINTED_TAX_RATE_NAME' ,--REPORTING_TYPE_CODE
4752: 'VARCHAR' , --REPORTING_TYPE_DATATYPE
4753: l_tax_regime_code ,
4754: NULL ,--TAX

Line 4976: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

4972: PROGRAM_LOGIN_ID ,
4973: OBJECT_VERSION_NUMBER
4974: )
4975: VALUES(
4976: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
4977: 'ZX_ADJ_TAX_CLASSIF_CODE' ,--REPORTING_TYPE_CODE
4978: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
4979: 'TEXT' ,--REPORTING_TYPE_DATATYPE (bug6430516)
4980: l_tax_regime_code ,--TAX_REGIME_CODE

Line 5627: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

5623: PROGRAM_LOGIN_ID ,
5624: OBJECT_VERSION_NUMBER
5625: )
5626: VALUES(
5627: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
5628: 'KR_BUSINESS_LOCATIONS' ,--REPORTING_TYPE_CODE
5629: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
5630: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
5631: l_tax_regime_code ,--TAX_REGIME_CODE

Line 6021: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID

6017: PROGRAM_LOGIN_ID ,
6018: OBJECT_VERSION_NUMBER
6019: )
6020: SELECT
6021: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID
6022: p_reporting_type_code, --REPORTING_TYPE_CODE
6023: p_datatype, --REPORTING_TYPE_DATATYPE
6024: NULL, --TAX REGIME CODE
6025: NULL, --TAX

Line 6119: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID

6115: PROGRAM_LOGIN_ID ,
6116: OBJECT_VERSION_NUMBER
6117: )
6118: SELECT
6119: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID
6120: p_reporting_type_code, --REPORTING_TYPE_CODE
6121: p_datatype, --REPORTING_TYPE_DATATYPE
6122: NULL, --TAX REGIME CODE
6123: NULL, --TAX

Line 7010: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

7006: PROGRAM_LOGIN_ID ,
7007: OBJECT_VERSION_NUMBER
7008: )
7009: VALUES(
7010: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
7011: 'EMEA_VAT_REPORTING_TYPE' ,--REPORTING_TYPE_CODE
7012: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
7013: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
7014: NULL ,--TAX_REGIME_CODE

Line 7521: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

7517: PROGRAM_LOGIN_ID ,
7518: OBJECT_VERSION_NUMBER
7519: )
7520: VALUES(
7521: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
7522: l_reporting_type_code ,--REPORTING_TYPE_CODE
7523: 'YES_NO' ,--REPORTING_TYPE_DATATYPE
7524: l_tax_regime_code ,--TAX_REGIME_CODE
7525: l_tax ,--TAX

Line 7878: (zx_reporting_types_b_s.nextval,

7874: PROGRAM_LOGIN_ID,
7875: OBJECT_VERSION_NUMBER
7876: )
7877: VALUES
7878: (zx_reporting_types_b_s.nextval,
7879: ''ZX_INTRA_EU_TRX_TYPE'',
7880: ''TEXT'',
7881: NULL,
7882: NULL,

Line 7946: (zx_reporting_types_b_s.nextval,

7942: PROGRAM_LOGIN_ID,
7943: OBJECT_VERSION_NUMBER
7944: )
7945: VALUES
7946: (zx_reporting_types_b_s.nextval,
7947: ''ZX_LGL_JUSTIFICATN_MSG_TYPE'',
7948: ''TEXT'',
7949: NULL,
7950: NULL,