eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORTING_TYPES_TL

Line 210: | ZX_REPORTING_TYPES_TL |

206: | DESCRIPTION |
207: | This routine inserts data into following zx reporting entities based |
208: | on data in AP_TAX_CODES_ALL GDF attributes. |
209: | ZX_REPORTING_TYPES_B |
210: | ZX_REPORTING_TYPES_TL |
211: | ZX_REPORTING_CODES_B |
212: | ZX_REPORTING_CODES_TL |
213: | ZX_REPORT_TYPES_USAGES |
214: | |

Line 687: INSERT INTO ZX_REPORTING_TYPES_TL(

683: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
684: and T.LANGUAGE = L.LANGUAGE_CODE);
685:
686:
687: INSERT INTO ZX_REPORTING_TYPES_TL(
688: REPORTING_TYPE_ID ,
689: LANGUAGE ,
690: SOURCE_LANG ,
691: REPORTING_TYPE_NAME ,

Line 760: from ZX_REPORTING_TYPES_TL T

756:
757: WHERE REPORTING_TYPE_NAME is not null
758: AND not exists
759: (select NULL
760: from ZX_REPORTING_TYPES_TL T
761: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
762: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
763:
764: --BugFix 3557652 REPORTING CODE_TL IMPL FOR ARGENTINE DGI TRANSACTION CODE

Line 4933: DELETE FROM ZX_REPORTING_TYPES_TL

4929: AND zx_rates.record_type_code = 'MIGRATED';
4930:
4931: --Need to Delete Seeded records if there is a source for reporting type to get created using 11i Migrated Regimes.
4932: IF ( l_exists_cnt > 0 ) THEN
4933: DELETE FROM ZX_REPORTING_TYPES_TL
4934: WHERE reporting_type_id IN ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
4935: WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED' );
4936:
4937: DELETE FROM ZX_REPORT_TYPES_USAGES

Line 5196: INSERT INTO ZX_REPORTING_TYPES_TL(

5192:
5193: --Creation Of Reporting Type Usages for
5194:
5195:
5196: INSERT INTO ZX_REPORTING_TYPES_TL(
5197: REPORTING_TYPE_ID ,
5198: LANGUAGE ,
5199: SOURCE_LANG ,
5200: REPORTING_TYPE_NAME ,

Line 5265: from ZX_REPORTING_TYPES_TL T

5261:
5262: WHERE REPORTING_TYPE_NAME is not null
5263: AND not exists
5264: (select NULL
5265: from ZX_REPORTING_TYPES_TL T
5266: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
5267: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
5268:
5269: -- Creation of records in Reporting_Usages

Line 6147: -- Insert into ZX_REPORTING_TYPES_TL

6143: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6144: where reporting_type_code= p_reporting_type_code
6145: );
6146:
6147: -- Insert into ZX_REPORTING_TYPES_TL
6148:
6149: INSERT INTO ZX_REPORTING_TYPES_TL(
6150: REPORTING_TYPE_ID ,
6151: LANGUAGE ,

Line 6149: INSERT INTO ZX_REPORTING_TYPES_TL(

6145: );
6146:
6147: -- Insert into ZX_REPORTING_TYPES_TL
6148:
6149: INSERT INTO ZX_REPORTING_TYPES_TL(
6150: REPORTING_TYPE_ID ,
6151: LANGUAGE ,
6152: SOURCE_LANG ,
6153: REPORTING_TYPE_NAME ,

Line 6236: from ZX_REPORTING_TYPES_TL T

6232: ) TYPES
6233: WHERE REPORTING_TYPE_NAME is not null
6234: AND not exists
6235: (select NULL
6236: from ZX_REPORTING_TYPES_TL T
6237: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
6238: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
6239:
6240: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

Line 7043: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');

7039: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7040: 'IT','KP','KR','NO','PL','PT','SK', 'IL')
7041: AND zx_rates.record_type_code = 'MIGRATED';
7042:
7043: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7044:
7045: INSERT INTO ZX_REPORTING_TYPES_TL(
7046: REPORTING_TYPE_ID ,
7047: LANGUAGE ,

Line 7045: INSERT INTO ZX_REPORTING_TYPES_TL(

7041: AND zx_rates.record_type_code = 'MIGRATED';
7042:
7043: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7044:
7045: INSERT INTO ZX_REPORTING_TYPES_TL(
7046: REPORTING_TYPE_ID ,
7047: LANGUAGE ,
7048: SOURCE_LANG ,
7049: REPORTING_TYPE_NAME ,

Line 7081: from ZX_REPORTING_TYPES_TL T

7077: ) TYPES
7078:
7079: WHERE not exists
7080: (select NULL
7081: from ZX_REPORTING_TYPES_TL T
7082: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7083: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7084:
7085: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(-)');

Line 7557: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');

7553: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7554: AND rates.record_type_code = 'MIGRATED'
7555: GROUP BY rates.tax_regime_code, rates.tax;
7556:
7557: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');
7558:
7559: INSERT INTO ZX_REPORTING_TYPES_TL(
7560: REPORTING_TYPE_ID ,
7561: LANGUAGE ,

Line 7559: INSERT INTO ZX_REPORTING_TYPES_TL(

7555: GROUP BY rates.tax_regime_code, rates.tax;
7556:
7557: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');
7558:
7559: INSERT INTO ZX_REPORTING_TYPES_TL(
7560: REPORTING_TYPE_ID ,
7561: LANGUAGE ,
7562: SOURCE_LANG ,
7563: REPORTING_TYPE_NAME ,

Line 7594: from ZX_REPORTING_TYPES_TL T

7590: AND L.INSTALLED_FLAG in ('I', 'B')
7591: ) TYPES
7592: WHERE not exists
7593: (select NULL
7594: from ZX_REPORTING_TYPES_TL T
7595: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7596: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7597:
7598: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');

Line 7979: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');

7975: AND vat_tax.LGL_JUSTIFICATION_MSG_CODE IS NOT NULL';
7976:
7977: EXECUTE IMMEDIATE dyn_sql_stmt;
7978:
7979: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7980:
7981: INSERT
7982: INTO ZX_REPORTING_TYPES_TL
7983: (

Line 7982: INTO ZX_REPORTING_TYPES_TL

7978:
7979: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7980:
7981: INSERT
7982: INTO ZX_REPORTING_TYPES_TL
7983: (
7984: REPORTING_TYPE_ID ,
7985: LANGUAGE ,
7986: SOURCE_LANG ,

Line 8019: FROM ZX_REPORTING_TYPES_TL T

8015: )
8016: TYPES
8017: WHERE NOT EXISTS
8018: (SELECT NULL
8019: FROM ZX_REPORTING_TYPES_TL T
8020: WHERE T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
8021: AND T.LANGUAGE = TYPES.LANGUAGE_CODE
8022: );
8023: