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

Line 12: -- cp_tsrm_val_to_zx_lines

8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -----------------------------------------------------------------------
11: -- PUBLIC PROCEDURE
12: -- cp_tsrm_val_to_zx_lines
13: --
14: -- DESCRIPTION
15: --
16: -- This procedure is called after determine tax applicability process

Line 24: PROCEDURE cp_tsrm_val_to_zx_lines(

20: -- CALLED BY
21: -- ZX_TDS_APPLICABILITY_DETM_PKG
22: --
23:
24: PROCEDURE cp_tsrm_val_to_zx_lines(
25: p_trx_line_index IN BINARY_INTEGER,
26: p_begin_index IN BINARY_INTEGER,
27: p_end_index IN BINARY_INTEGER,
28: p_return_status OUT NOCOPY VARCHAR2,

Line 40: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.BEGIN',

36: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37:
38: IF (g_level_statement >= g_current_runtime_level ) THEN
39: FND_LOG.STRING(g_level_statement,
40: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.BEGIN',
41: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(+)');
42: END IF;
43:
44: --

Line 41: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(+)');

37:
38: IF (g_level_statement >= g_current_runtime_level ) THEN
39: FND_LOG.STRING(g_level_statement,
40: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.BEGIN',
41: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(+)');
42: END IF;
43:
44: --
45: -- init error buffer and return status

Line 57: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',

53: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
54:
55: IF (g_level_statement >= g_current_runtime_level ) THEN
56: FND_LOG.STRING(g_level_statement,
57: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
58: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||'Begin index or End index is null');
59:
60: END IF;
61: RETURN;

Line 58: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||'Begin index or End index is null');

54:
55: IF (g_level_statement >= g_current_runtime_level ) THEN
56: FND_LOG.STRING(g_level_statement,
57: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
58: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||'Begin index or End index is null');
59:
60: END IF;
61: RETURN;
62: END IF;

Line 519: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',

515:
516: IF (g_level_statement >= g_current_runtime_level ) THEN
517:
518: FND_LOG.STRING(g_level_statement,
519: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
520: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);
521: END IF;
522:
523: EXCEPTION

Line 520: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);

516: IF (g_level_statement >= g_current_runtime_level ) THEN
517:
518: FND_LOG.STRING(g_level_statement,
519: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
520: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);
521: END IF;
522:
523: EXCEPTION
524: WHEN OTHERS THEN

Line 530: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',

526: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
527:
528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
529: FND_LOG.STRING(g_level_unexpected,
530: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',
531: p_error_buffer);
532: END IF;
533:
534: END cp_tsrm_val_to_zx_lines;

Line 534: END cp_tsrm_val_to_zx_lines;

530: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',
531: p_error_buffer);
532: END IF;
533:
534: END cp_tsrm_val_to_zx_lines;
535:
536: -----------------------------------------------------------------------
537: -- PUBLIC PROCEDURE
538: -- populate_tax_line

Line 720: SELECT ZX_LINES_S.nextval

716: --
717: -- populate tax_line_id if it is null
718: --
719: IF p_tax_line_rec.tax_line_id IS NULL THEN
720: SELECT ZX_LINES_S.nextval
721: INTO p_tax_line_rec.tax_line_id
722: FROM dual;
723: END IF;
724:

Line 1206: SELECT ZX_LINES_S.nextval

1202: --
1203: -- populate tax_line_id if it is null
1204: --
1205: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_line_id IS NULL THEN
1206: SELECT ZX_LINES_S.nextval
1207: INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_line_id
1208: FROM dual;
1209: END IF;
1210:

Line 1660: -- This procedure brings all canceled tax lines from zx_lines into

1656: -- PUBLIC PROCEDURE
1657: -- process_cancel_tax_lines
1658: --
1659: -- DESCRIPTION
1660: -- This procedure brings all canceled tax lines from zx_lines into
1661: -- detail tax lines global temp table and marks them as cancel
1662: --
1663: -- CALLED BY
1664: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 2289: FROM ZX_LINES L,

2285: L.adjusted_doc_tax_line_id,
2286: 1,
2287: L.legal_reporting_status,
2288: L.account_source_tax_rate_id
2289: FROM ZX_LINES L,
2290: zx_lines_det_factors G
2291: WHERE G.application_id = p_event_class_rec.application_id AND
2292: G.entity_code = p_event_class_rec.entity_code AND
2293: G.event_class_code = p_event_class_rec.event_class_code AND

Line 2290: zx_lines_det_factors G

2286: 1,
2287: L.legal_reporting_status,
2288: L.account_source_tax_rate_id
2289: FROM ZX_LINES L,
2290: zx_lines_det_factors G
2291: WHERE G.application_id = p_event_class_rec.application_id AND
2292: G.entity_code = p_event_class_rec.entity_code AND
2293: G.event_class_code = p_event_class_rec.event_class_code AND
2294: -- G.trx_id = p_event_class_rec.trx_id AND

Line 2995: FROM zx_lines L,

2991: L.adjusted_doc_tax_line_id,
2992: 1,
2993: legal_reporting_status,
2994: L.account_source_tax_rate_id
2995: FROM zx_lines L,
2996: zx_lines_det_factors G
2997: WHERE G.application_id = p_event_class_rec.application_id
2998: AND G.entity_code = p_event_class_rec.entity_code
2999: AND G.event_class_code = p_event_class_rec.event_class_code

Line 2996: zx_lines_det_factors G

2992: 1,
2993: legal_reporting_status,
2994: L.account_source_tax_rate_id
2995: FROM zx_lines L,
2996: zx_lines_det_factors G
2997: WHERE G.application_id = p_event_class_rec.application_id
2998: AND G.entity_code = p_event_class_rec.entity_code
2999: AND G.event_class_code = p_event_class_rec.event_class_code
3000: AND G.trx_id = p_event_class_rec.trx_id

Line 3030: ( SELECT /+ INDEX(zl ZX_LINES_U1) /

3026: -- bug 6906427: update tax line id if no grouping criteria change
3027: --
3028: UPDATE zx_detail_tax_lines_gt zlgt
3029: SET (tax_line_id, associated_child_frozen_flag, summary_tax_line_id) =
3030: ( SELECT /*+ INDEX(zl ZX_LINES_U1) */
3031: tax_line_id, associated_child_frozen_flag, summary_tax_line_id
3032: FROM zx_lines zl
3033: WHERE zl.application_id = zlgt.application_id
3034: AND zl.entity_code = zlgt.entity_code

Line 3032: FROM zx_lines zl

3028: UPDATE zx_detail_tax_lines_gt zlgt
3029: SET (tax_line_id, associated_child_frozen_flag, summary_tax_line_id) =
3030: ( SELECT /*+ INDEX(zl ZX_LINES_U1) */
3031: tax_line_id, associated_child_frozen_flag, summary_tax_line_id
3032: FROM zx_lines zl
3033: WHERE zl.application_id = zlgt.application_id
3034: AND zl.entity_code = zlgt.entity_code
3035: AND zl.event_class_code = zlgt.event_class_code
3036: AND zl.trx_id = zlgt.trx_id

Line 3098: AND EXISTS (SELECT /+ INDEX(zl ZX_LINES_U1) /

3094: )
3095: WHERE NVL(associated_child_frozen_flag, 'N') ='N'
3096: AND summary_tax_line_id IS NULL
3097: AND NVL(tax_only_line_flag, 'N') = 'N'
3098: AND EXISTS (SELECT /*+ INDEX(zl ZX_LINES_U1) */
3099: tax_line_id, associated_child_frozen_flag
3100: FROM zx_lines zl
3101: WHERE zl.application_id = zlgt.application_id
3102: AND zl.entity_code = zlgt.entity_code

Line 3100: FROM zx_lines zl

3096: AND summary_tax_line_id IS NULL
3097: AND NVL(tax_only_line_flag, 'N') = 'N'
3098: AND EXISTS (SELECT /*+ INDEX(zl ZX_LINES_U1) */
3099: tax_line_id, associated_child_frozen_flag
3100: FROM zx_lines zl
3101: WHERE zl.application_id = zlgt.application_id
3102: AND zl.entity_code = zlgt.entity_code
3103: AND zl.event_class_code = zlgt.event_class_code
3104: AND zl.trx_id = zlgt.trx_id

Line 3787: FROM zx_lines L,

3783: L.adjusted_doc_tax_line_id,
3784: 1,
3785: legal_reporting_status,
3786: L.account_source_tax_rate_id
3787: FROM zx_lines L,
3788: zx_lines_det_factors G
3789: WHERE G.application_id = p_event_class_rec.application_id
3790: AND G.entity_code = p_event_class_rec.entity_code
3791: AND G.event_class_code = p_event_class_rec.event_class_code

Line 3788: zx_lines_det_factors G

3784: 1,
3785: legal_reporting_status,
3786: L.account_source_tax_rate_id
3787: FROM zx_lines L,
3788: zx_lines_det_factors G
3789: WHERE G.application_id = p_event_class_rec.application_id
3790: AND G.entity_code = p_event_class_rec.entity_code
3791: AND G.event_class_code = p_event_class_rec.event_class_code
3792: -- AND G.trx_id = p_event_class_rec.trx_id

Line 3859: -- This procedure brings all discarded tax lines from zx_lines into

3855: -- PUBLIC PROCEDURE
3856: -- process_discard_tax_lines
3857: --
3858: -- DESCRIPTION
3859: -- This procedure brings all discarded tax lines from zx_lines into
3860: -- detail tax lines global temp table
3861: --
3862: -- CALLED BY
3863: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 4490: FROM ZX_LINES L,

4486: L.adjusted_doc_tax_line_id,
4487: 1,
4488: legal_reporting_status,
4489: L.account_source_tax_rate_id
4490: FROM ZX_LINES L,
4491: zx_lines_det_factors G
4492: WHERE G.application_id = p_event_class_rec.application_id AND
4493: G.entity_code = p_event_class_rec.entity_code AND
4494: G.event_class_code = p_event_class_rec.event_class_code AND

Line 4491: zx_lines_det_factors G

4487: 1,
4488: legal_reporting_status,
4489: L.account_source_tax_rate_id
4490: FROM ZX_LINES L,
4491: zx_lines_det_factors G
4492: WHERE G.application_id = p_event_class_rec.application_id AND
4493: G.entity_code = p_event_class_rec.entity_code AND
4494: G.event_class_code = p_event_class_rec.event_class_code AND
4495: -- G.trx_id = p_event_class_rec.trx_id AND

Line 4555: -- It brings all tax lines from zx_lines into detail tax lines global temp table

4551: -- process_cancel_trx_lines
4552: --
4553: -- DESCRIPTION
4554: -- This procedure processes cancelled trx lines (line_level_action='CANCEL')
4555: -- It brings all tax lines from zx_lines into detail tax lines global temp table
4556: -- and mark them as cancelled
4557: --
4558: -- CALLED BY
4559: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 5178: FROM ZX_LINES L,

5174: L.adjusted_doc_tax_line_id,
5175: 1,
5176: L.legal_reporting_status,
5177: L.account_source_tax_rate_id
5178: FROM ZX_LINES L,
5179: zx_lines_det_factors G
5180: WHERE G.application_id = p_event_class_rec.application_id AND
5181: G.entity_code = p_event_class_rec.entity_code AND
5182: G.event_class_code = p_event_class_rec.event_class_code AND

Line 5179: zx_lines_det_factors G

5175: 1,
5176: L.legal_reporting_status,
5177: L.account_source_tax_rate_id
5178: FROM ZX_LINES L,
5179: zx_lines_det_factors G
5180: WHERE G.application_id = p_event_class_rec.application_id AND
5181: G.entity_code = p_event_class_rec.entity_code AND
5182: G.event_class_code = p_event_class_rec.event_class_code AND
5183: -- G.trx_id = p_event_class_rec.trx_id AND

Line 5286: zx_lines_det_factors trx_line

5282: tax_line.tax_id,
5283: tax_line.tax_hold_released_code,
5284: tax_line.Rounding_Rule_Code
5285: FROM ZX_DETAIL_TAX_LINES_GT tax_line,
5286: zx_lines_det_factors trx_line
5287: WHERE tax_line.application_id = p_event_class_rec.application_id
5288: AND tax_line.entity_code = p_event_class_rec.entity_code
5289: AND tax_line.event_class_code = p_event_class_rec.event_class_code
5290: AND tax_line.trx_id = p_event_class_rec.trx_id

Line 5346: FROM zx_lines_det_factors line

5342: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5343: AND gt.mrc_tax_line_flag = 'N'
5344: AND EXISTS
5345: (SELECT 1
5346: FROM zx_lines_det_factors line
5347: WHERE line.application_id = p_event_class_rec.application_id
5348: AND line.entity_code = p_event_class_rec.entity_code
5349: AND line.event_class_code = p_event_class_rec.event_class_code
5350: AND line.event_id = p_event_class_rec.event_id