DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORTING_TYPES_B_S

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

327: PROGRAM_LOGIN_ID ,
328: OBJECT_VERSION_NUMBER
329: )
330: VALUES(
331: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
332: 'FISCAL PRINTER' ,--REPORTING_TYPE_CODE
333: 'YES_NO' ,--REPORTING_TYPE_DATATYPE
334: l_tax_regime_code ,--TAX_REGIME_CODE
335: NULL ,--TAX

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

384: PROGRAM_LOGIN_ID ,
385: OBJECT_VERSION_NUMBER
386: )
387: VALUES(
388: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
389: 'CAI NUMBER' ,--REPORTING_TYPE_CODE
390: --'NUMBER' ,--REPORTING_TYPE_DATATYPE
391: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
392: l_tax_regime_code ,--TAX_REGIME_CODE

Line 906: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

902: PROGRAM_LOGIN_ID ,
903: OBJECT_VERSION_NUMBER
904: )
905: VALUES(
906: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
907: p_reporting_type_code ,--REPORTING_TYPE_CODE
908: p_datatype , --REPORTING_TYPE_DATATYPE
909: l_tax_regime_code ,
910: NULL ,--TAX

Line 995: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

991: PROGRAM_LOGIN_ID ,
992: OBJECT_VERSION_NUMBER
993: )
994: VALUES(
995: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
996: p_reporting_type_code ,--REPORTING_TYPE_CODE
997: p_datatype , --REPORTING_TYPE_DATATYPE
998: l_tax_regime_code ,
999: NULL ,--TAX

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

2943: PROGRAM_LOGIN_ID ,
2944: OBJECT_VERSION_NUMBER
2945: )
2946: VALUES(
2947: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
2948: 'PT_LOCATION' ,--REPORTING_TYPE_CODE
2949: 'TEXT' ,--REPORTING_TYPE_DATATYPE
2950: l_tax_regime_code ,
2951: NULL ,--TAX

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

2998: PROGRAM_LOGIN_ID ,
2999: OBJECT_VERSION_NUMBER
3000: )
3001: VALUES(
3002: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
3003: 'PT_PRD_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
3004: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3005: l_tax_regime_code ,
3006: NULL ,--TAX

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

3053: PROGRAM_LOGIN_ID ,
3054: OBJECT_VERSION_NUMBER
3055: )
3056: VALUES(
3057: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3058: 'PT_PRD_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
3059: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3060: l_tax_regime_code ,
3061: NULL ,--TAX

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

3108: PROGRAM_LOGIN_ID ,
3109: OBJECT_VERSION_NUMBER
3110: )
3111: VALUES(
3112: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3113: 'PT_ANL_TTL_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
3114: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3115: l_tax_regime_code ,
3116: NULL ,--TAX

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

3163: PROGRAM_LOGIN_ID ,
3164: OBJECT_VERSION_NUMBER
3165: )
3166: VALUES(
3167: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3168: 'PT_ANL_REC_TAXABLE' ,--REPORTING_TYPE_CODE
3169: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3170: l_tax_regime_code ,
3171: NULL ,--TAX

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

3218: PROGRAM_LOGIN_ID ,
3219: OBJECT_VERSION_NUMBER
3220: )
3221: VALUES(
3222: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3223: 'PT_ANL_NON_REC_TAXABLE' ,--REPORTING_TYPE_CODE
3224: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3225: l_tax_regime_code ,
3226: NULL ,--TAX

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

3273: PROGRAM_LOGIN_ID ,
3274: OBJECT_VERSION_NUMBER
3275: )
3276: VALUES(
3277: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
3278: 'PT_ANL_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
3279: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3280: l_tax_regime_code ,
3281: NULL ,--TAX

Line 3352: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3348: PROGRAM_LOGIN_ID ,
3349: OBJECT_VERSION_NUMBER
3350: )
3351: VALUES(
3352: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3353: 'AR_DGI_TRX_CODE' ,--REPORTING_TYPE_CODE
3354: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3355: l_tax_regime_code ,
3356: NULL ,--TAX

Line 3427: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3423: PROGRAM_LOGIN_ID ,
3424: OBJECT_VERSION_NUMBER
3425: )
3426: VALUES(
3427: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3428: 'CL_TAX_CODE_CLASSIF' ,--REPORTING_TYPE_CODE
3429: 'TEXT' ,--REPORTING_TYPE_DATATYPE
3430: l_tax_regime_code ,
3431: NULL ,--TAX

Line 3865: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

3861: PROGRAM_LOGIN_ID ,
3862: OBJECT_VERSION_NUMBER
3863: )
3864: VALUES(
3865: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
3866: 'KR_BUSINESS_LOCATIONS' ,--REPORTING_TYPE_CODE
3867: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
3868: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
3869: l_tax_regime_code ,--TAX_REGIME_CODE

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

4130: PROGRAM_LOGIN_ID ,
4131: OBJECT_VERSION_NUMBER
4132: )
4133: VALUES(
4134: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s'),--REPORTING_TYPE_ID
4135: 'PT_LOCATION' ,--REPORTING_TYPE_CODE
4136: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4137: l_tax_regime_code ,
4138: NULL ,--TAX

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

4185: PROGRAM_LOGIN_ID ,
4186: OBJECT_VERSION_NUMBER
4187: )
4188: VALUES(
4189: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4190: 'PT_PRD_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
4191: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4192: l_tax_regime_code ,
4193: NULL ,--TAX

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

4240: PROGRAM_LOGIN_ID ,
4241: OBJECT_VERSION_NUMBER
4242: )
4243: VALUES(
4244: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4245: 'PT_PRD_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
4246: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4247: l_tax_regime_code ,
4248: NULL ,--TAX

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

4295: PROGRAM_LOGIN_ID ,
4296: OBJECT_VERSION_NUMBER
4297: )
4298: VALUES(
4299: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4300: 'PT_ANL_TTL_TAXABLE_BOX' ,--REPORTING_TYPE_CODE
4301: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4302: l_tax_regime_code ,
4303: NULL ,--TAX

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

4350: PROGRAM_LOGIN_ID ,
4351: OBJECT_VERSION_NUMBER
4352: )
4353: VALUES(
4354: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4355: 'PT_ANL_REC_TAXABLE' ,--REPORTING_TYPE_CODE
4356: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4357: l_tax_regime_code ,
4358: NULL ,--TAX

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

4405: PROGRAM_LOGIN_ID ,
4406: OBJECT_VERSION_NUMBER
4407: )
4408: VALUES(
4409: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4410: 'PT_ANL_NON_REC_TAXABLE' ,--REPORTING_TYPE_CODE
4411: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4412: l_tax_regime_code ,
4413: NULL ,--TAX

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

4460: PROGRAM_LOGIN_ID ,
4461: OBJECT_VERSION_NUMBER
4462: )
4463: VALUES(
4464: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4465: 'PT_ANL_REC_TAX_BOX' ,--REPORTING_TYPE_CODE
4466: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4467: l_tax_regime_code ,
4468: NULL ,--TAX

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

4532: PROGRAM_LOGIN_ID ,
4533: OBJECT_VERSION_NUMBER
4534: )
4535: VALUES(
4536: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4537: 'AR_DGI_TRX_CODE' ,--REPORTING_TYPE_CODE
4538: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4539: l_tax_regime_code ,
4540: NULL ,--TAX

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

4587: PROGRAM_LOGIN_ID ,
4588: OBJECT_VERSION_NUMBER
4589: )
4590: VALUES(
4591: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4592: 'AR_MUNICIPAL_JUR' ,--REPORTING_TYPE_CODE
4593: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4594: l_tax_regime_code ,
4595: NULL ,--TAX

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

4642: PROGRAM_LOGIN_ID ,
4643: OBJECT_VERSION_NUMBER
4644: )
4645: VALUES(
4646: zx_migrate_util.get_next_seqid('zx_reporting_types_b_s') ,--REPORTING_TYPE_ID
4647: 'AR_TURN_OVER_JUR_CODE' ,--REPORTING_TYPE_CODE
4648: 'TEXT' ,--REPORTING_TYPE_DATATYPE
4649: l_tax_regime_code ,
4650: NULL ,--TAX

Line 4723: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

4719: PROGRAM_LOGIN_ID ,
4720: OBJECT_VERSION_NUMBER
4721: )
4722: VALUES(
4723: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
4724: 'PRINTED_TAX_RATE_NAME' ,--REPORTING_TYPE_CODE
4725: 'VARCHAR' , --REPORTING_TYPE_DATATYPE
4726: l_tax_regime_code ,
4727: NULL ,--TAX

Line 4949: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

4945: PROGRAM_LOGIN_ID ,
4946: OBJECT_VERSION_NUMBER
4947: )
4948: VALUES(
4949: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
4950: 'ZX_ADJ_TAX_CLASSIF_CODE' ,--REPORTING_TYPE_CODE
4951: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
4952: 'TEXT' ,--REPORTING_TYPE_DATATYPE (bug6430516)
4953: l_tax_regime_code ,--TAX_REGIME_CODE

Line 5598: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

5594: PROGRAM_LOGIN_ID ,
5595: OBJECT_VERSION_NUMBER
5596: )
5597: VALUES(
5598: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
5599: 'KR_BUSINESS_LOCATIONS' ,--REPORTING_TYPE_CODE
5600: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
5601: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
5602: l_tax_regime_code ,--TAX_REGIME_CODE

Line 5992: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID

5988: PROGRAM_LOGIN_ID ,
5989: OBJECT_VERSION_NUMBER
5990: )
5991: SELECT
5992: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID
5993: p_reporting_type_code, --REPORTING_TYPE_CODE
5994: p_datatype, --REPORTING_TYPE_DATATYPE
5995: NULL, --TAX REGIME CODE
5996: NULL, --TAX

Line 6090: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID

6086: PROGRAM_LOGIN_ID ,
6087: OBJECT_VERSION_NUMBER
6088: )
6089: SELECT
6090: zx_reporting_types_b_s.nextval, --REPORTING_TYPE_ID
6091: p_reporting_type_code, --REPORTING_TYPE_CODE
6092: p_datatype, --REPORTING_TYPE_DATATYPE
6093: NULL, --TAX REGIME CODE
6094: NULL, --TAX

Line 6981: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

6977: PROGRAM_LOGIN_ID ,
6978: OBJECT_VERSION_NUMBER
6979: )
6980: VALUES(
6981: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
6982: 'EMEA_VAT_REPORTING_TYPE' ,--REPORTING_TYPE_CODE
6983: --'VARCHAR' ,--REPORTING_TYPE_DATATYPE
6984: 'TEXT' ,--REPORTING_TYPE_DATATYPE (Bug6430516)
6985: NULL ,--TAX_REGIME_CODE

Line 7491: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID

7487: PROGRAM_LOGIN_ID ,
7488: OBJECT_VERSION_NUMBER
7489: )
7490: VALUES(
7491: zx_reporting_types_b_s.nextval ,--REPORTING_TYPE_ID
7492: l_reporting_type_code ,--REPORTING_TYPE_CODE
7493: 'YES_NO' ,--REPORTING_TYPE_DATATYPE
7494: l_tax_regime_code ,--TAX_REGIME_CODE
7495: l_tax ,--TAX