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_TDS_IMPORT_DOCUMENT_PKG dependencies on ZX_LINES

Line 1011: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS

1007:
1008: CURSOR get_key_columns_cur
1009: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
1010: c_tax zx_taxes_b.tax%TYPE,
1011: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
1012: SELECT tax_line_id FROM zx_lines
1013: WHERE application_id =
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1015: AND entity_code =

Line 1012: SELECT tax_line_id FROM zx_lines

1008: CURSOR get_key_columns_cur
1009: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
1010: c_tax zx_taxes_b.tax%TYPE,
1011: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
1012: SELECT tax_line_id FROM zx_lines
1013: WHERE application_id =
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1015: AND entity_code =
1016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)

Line 1047: l_tax_rate zx_lines.tax_rate%TYPE;

1043: l_tax_regime_id ZX_REGIMES_B.tax_regime_id%TYPE;
1044: l_tax_id ZX_TAXES_B.tax_id%TYPE;
1045: l_def_reg_type ZX_TAXES_B.def_registr_party_type_code%TYPE;
1046: l_reg_rule_flg ZX_TAXES_B.registration_type_rule_flag%TYPE;
1047: l_tax_rate zx_lines.tax_rate%TYPE;
1048: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;
1049:
1050: l_adjusted_doc_tax_line_id zx_lines.adjusted_doc_tax_line_id%TYPE;
1051: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;

Line 1050: l_adjusted_doc_tax_line_id zx_lines.adjusted_doc_tax_line_id%TYPE;

1046: l_reg_rule_flg ZX_TAXES_B.registration_type_rule_flag%TYPE;
1047: l_tax_rate zx_lines.tax_rate%TYPE;
1048: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;
1049:
1050: l_adjusted_doc_tax_line_id zx_lines.adjusted_doc_tax_line_id%TYPE;
1051: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;
1052: BEGIN
1053:
1054: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1288: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(

1284: END IF;
1285:
1286: -- copy transaction information
1287: --
1288: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
1289: p_trx_line_index,
1290: l_begin_index,
1291: l_end_index,
1292: x_return_status,

Line 1300: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');

1296: IF (g_level_statement >= g_current_runtime_level ) THEN
1297: FND_LOG.STRING(g_level_statement,
1298: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1299: 'Incorrect return_status after calling '||
1300: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1301: FND_LOG.STRING(g_level_statement,
1302: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1303: 'RETURN_STATUS = ' || x_return_status);
1304: FND_LOG.STRING(g_level_statement,

Line 1984: * SELECT zx_lines_s.NEXTVAL INTO

1980: --
1981: /*
1982: * populate in ZX_TDS_TAX_LINES_POPU_PKG
1983: *
1984: * SELECT zx_lines_s.NEXTVAL INTO
1985: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1986: * p_new_row_num).tax_line_id from dual;
1987: */
1988:

Line 2248: SELECT * FROM zx_lines

2244: x_end_index IN OUT NOCOPY BINARY_INTEGER,
2245: x_return_status OUT NOCOPY VARCHAR2) IS
2246:
2247: CURSOR get_tax_lines_csr IS
2248: SELECT * FROM zx_lines
2249: WHERE application_id =
2250: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2251: AND entity_code =
2252: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 2727: FROM zx_lines_det_factors

2723:
2724: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) = 200 THEN
2725: SELECT line_amt
2726: INTO l_orig_amt
2727: FROM zx_lines_det_factors
2728: WHERE application_id =
2729: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2730: AND entity_code =
2731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 2743: FROM zx_lines_det_factors

2739: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2740:
2741: SELECT sum(line_amt)
2742: INTO l_appl_line_amt
2743: FROM zx_lines_det_factors
2744: WHERE applied_from_application_id =
2745: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2746: AND applied_from_entity_code =
2747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 2759: FROM zx_lines

2755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2756:
2757: SELECT sum(tax_amt)
2758: INTO l_appl_tax_amt
2759: FROM zx_lines
2760: WHERE applied_from_application_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2762: AND applied_from_entity_code =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

Line 2829: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(

2825: END IF;
2826:
2827: -- copy transaction info to new tax lines for new tax_lines created here
2828: --
2829: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
2830: p_trx_line_index ,
2831: -- l_orig_end_index+1,
2832: x_begin_index,
2833: x_end_index,

Line 2842: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');

2838: IF (g_level_statement >= g_current_runtime_level ) THEN
2839: FND_LOG.STRING(g_level_statement,
2840: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2841: 'Incorrect return_status after calling ' ||
2842: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2843: FND_LOG.STRING(g_level_statement,
2844: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2845: 'RETURN_STATUS = ' || x_return_status);
2846: FND_LOG.STRING(g_level_statement,

Line 2909: SELECT * FROM zx_lines

2905: x_end_index IN OUT NOCOPY BINARY_INTEGER,
2906: x_return_status OUT NOCOPY VARCHAR2) IS
2907:
2908: CURSOR get_tax_lines_csr IS
2909: SELECT * FROM zx_lines
2910: WHERE application_id =
2911: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
2912: p_trx_line_index)
2913: AND entity_code =

Line 3458: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(

3454: END IF;
3455:
3456: -- copy transaction info to new tax lines for new tax_lines created here
3457: --
3458: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
3459: p_trx_line_index ,
3460: -- NVL(l_orig_end_index, 0)+1,
3461: x_begin_index,
3462: x_end_index,

Line 3471: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');

3467: IF (g_level_statement >= g_current_runtime_level ) THEN
3468: FND_LOG.STRING(g_level_statement,
3469: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3470: 'Incorrect return_status after calling ' ||
3471: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3472: FND_LOG.STRING(g_level_statement,
3473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3474: 'RETURN_STATUS = ' || x_return_status);
3475: FND_LOG.STRING(g_level_statement,