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 524: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',

520:
521: IF (g_level_statement >= g_current_runtime_level ) THEN
522:
523: FND_LOG.STRING(g_level_statement,
524: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
525: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);
526: END IF;
527:
528: EXCEPTION

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

521: IF (g_level_statement >= g_current_runtime_level ) THEN
522:
523: FND_LOG.STRING(g_level_statement,
524: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
525: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);
526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN

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

531: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
532:
533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
534: FND_LOG.STRING(g_level_unexpected,
535: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',
536: p_error_buffer);
537: END IF;
538:
539: END cp_tsrm_val_to_zx_lines;

Line 539: END cp_tsrm_val_to_zx_lines;

535: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',
536: p_error_buffer);
537: END IF;
538:
539: END cp_tsrm_val_to_zx_lines;
540:
541: -----------------------------------------------------------------------
542: -- PUBLIC PROCEDURE
543: -- populate_tax_line

Line 725: SELECT ZX_LINES_S.nextval

721: --
722: -- populate tax_line_id if it is null
723: --
724: IF p_tax_line_rec.tax_line_id IS NULL THEN
725: SELECT ZX_LINES_S.nextval
726: INTO p_tax_line_rec.tax_line_id
727: FROM dual;
728: END IF;
729:

Line 1217: SELECT ZX_LINES_S.nextval

1213: --
1214: -- populate tax_line_id if it is null
1215: --
1216: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_line_id IS NULL THEN
1217: SELECT ZX_LINES_S.nextval
1218: INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_line_id
1219: FROM dual;
1220: END IF;
1221:

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

1716: -- PUBLIC PROCEDURE
1717: -- process_cancel_tax_lines
1718: --
1719: -- DESCRIPTION
1720: -- This procedure brings all canceled tax lines from zx_lines into
1721: -- detail tax lines global temp table and marks them as cancel
1722: --
1723: -- CALLED BY
1724: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 1744: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

1740: END IF;
1741:
1742: p_return_status := FND_API.G_RET_STS_SUCCESS;
1743:
1744: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
1745: INSERT INTO zx_detail_tax_lines_gt
1746: ( tax_line_id,
1747: internal_organization_id,
1748: application_id,

Line 2046: (SELECT /+ leading(G) index(l ZX_LINES_u1 ) /

2042: object_version_number,
2043: legal_reporting_status,
2044: account_source_tax_rate_id
2045: )
2046: (SELECT /*+ leading(G) index(l ZX_LINES_u1 ) */
2047: L.tax_line_id,
2048: L.internal_organization_id,
2049: L.application_id,
2050: L.entity_code,

Line 2350: FROM ZX_LINES L,

2346: L.adjusted_doc_tax_line_id,
2347: 1,
2348: L.legal_reporting_status,
2349: L.account_source_tax_rate_id
2350: FROM ZX_LINES L,
2351: zx_lines_det_factors G
2352: WHERE G.application_id = p_event_class_rec.application_id AND
2353: G.entity_code = p_event_class_rec.entity_code AND
2354: G.event_class_code = p_event_class_rec.event_class_code AND

Line 2351: zx_lines_det_factors G

2347: 1,
2348: L.legal_reporting_status,
2349: L.account_source_tax_rate_id
2350: FROM ZX_LINES L,
2351: zx_lines_det_factors G
2352: WHERE G.application_id = p_event_class_rec.application_id AND
2353: G.entity_code = p_event_class_rec.entity_code AND
2354: G.event_class_code = p_event_class_rec.event_class_code AND
2355: -- G.trx_id = p_event_class_rec.trx_id AND

Line 2453: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

2449:
2450: -- Fetch back canceled tax lines with frozen tax distributions
2451: --
2452:
2453: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
2454: INSERT INTO zx_detail_tax_lines_gt
2455: ( tax_line_id,
2456: internal_organization_id,
2457: application_id,

Line 3057: FROM zx_lines L,

3053: L.adjusted_doc_tax_line_id,
3054: 1,
3055: legal_reporting_status,
3056: L.account_source_tax_rate_id
3057: FROM zx_lines L,
3058: zx_lines_det_factors G
3059: WHERE G.application_id = p_event_class_rec.application_id
3060: AND G.entity_code = p_event_class_rec.entity_code
3061: AND G.event_class_code = p_event_class_rec.event_class_code

Line 3058: zx_lines_det_factors G

3054: 1,
3055: legal_reporting_status,
3056: L.account_source_tax_rate_id
3057: FROM zx_lines L,
3058: zx_lines_det_factors G
3059: WHERE G.application_id = p_event_class_rec.application_id
3060: AND G.entity_code = p_event_class_rec.entity_code
3061: AND G.event_class_code = p_event_class_rec.event_class_code
3062: AND G.trx_id = p_event_class_rec.trx_id

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

3090: --bug8517610
3091:
3092: UPDATE zx_detail_tax_lines_gt zlgt
3093: SET (tax_line_id, associated_child_frozen_flag, summary_tax_line_id,offset_link_to_tax_line_id) =
3094: ( SELECT /*+ INDEX(zl ZX_LINES_U1) */
3095: tax_line_id, associated_child_frozen_flag, summary_tax_line_id,offset_link_to_tax_line_id
3096: FROM zx_lines zl
3097: WHERE zl.application_id = zlgt.application_id
3098: AND zl.entity_code = zlgt.entity_code

Line 3096: FROM zx_lines zl

3092: UPDATE zx_detail_tax_lines_gt zlgt
3093: SET (tax_line_id, associated_child_frozen_flag, summary_tax_line_id,offset_link_to_tax_line_id) =
3094: ( SELECT /*+ INDEX(zl ZX_LINES_U1) */
3095: tax_line_id, associated_child_frozen_flag, summary_tax_line_id,offset_link_to_tax_line_id
3096: FROM zx_lines zl
3097: WHERE zl.application_id = zlgt.application_id
3098: AND zl.entity_code = zlgt.entity_code
3099: AND zl.event_class_code = zlgt.event_class_code
3100: AND zl.trx_id = zlgt.trx_id

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

3159: WHERE NVL(associated_child_frozen_flag, 'N') ='N'
3160: -- Bug 8348107
3161: AND (summary_tax_line_id IS NULL OR nvl(historical_flag,'N') = 'Y')
3162: AND NVL(tax_only_line_flag, 'N') = 'N'
3163: AND EXISTS (SELECT /*+ INDEX(zl ZX_LINES_U1) */
3164: tax_line_id, associated_child_frozen_flag
3165: FROM zx_lines zl
3166: WHERE zl.application_id = zlgt.application_id
3167: AND zl.entity_code = zlgt.entity_code

Line 3165: FROM zx_lines zl

3161: AND (summary_tax_line_id IS NULL OR nvl(historical_flag,'N') = 'Y')
3162: AND NVL(tax_only_line_flag, 'N') = 'N'
3163: AND EXISTS (SELECT /*+ INDEX(zl ZX_LINES_U1) */
3164: tax_line_id, associated_child_frozen_flag
3165: FROM zx_lines zl
3166: WHERE zl.application_id = zlgt.application_id
3167: AND zl.entity_code = zlgt.entity_code
3168: AND zl.event_class_code = zlgt.event_class_code
3169: AND zl.trx_id = zlgt.trx_id

Line 3234: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

3230: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3231: 'Number of Rows Updated: ' || SQL%ROWCOUNT);
3232: END IF;
3233:
3234: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
3235: INSERT INTO zx_detail_tax_lines_gt
3236: ( tax_line_id,
3237: internal_organization_id,
3238: application_id,

Line 3535: (SELECT /+ leading(G) index(l ZX_LINES_u1 ) /

3531: object_version_number,
3532: legal_reporting_status,
3533: account_source_tax_rate_id
3534: )
3535: (SELECT /*+ leading(G) index(l ZX_LINES_u1 ) */
3536: L.tax_line_id,
3537: L.internal_organization_id,
3538: L.application_id,
3539: L.entity_code,

Line 3854: FROM zx_lines L,

3850: 1,
3851: DECODE(L.legal_reporting_status, '111111111111111',
3852: '000000000000000', L.legal_reporting_status),
3853: L.account_source_tax_rate_id
3854: FROM zx_lines L,
3855: zx_lines_det_factors G
3856: WHERE G.application_id = p_event_class_rec.application_id
3857: AND G.entity_code = p_event_class_rec.entity_code
3858: AND G.event_class_code = p_event_class_rec.event_class_code

Line 3855: zx_lines_det_factors G

3851: DECODE(L.legal_reporting_status, '111111111111111',
3852: '000000000000000', L.legal_reporting_status),
3853: L.account_source_tax_rate_id
3854: FROM zx_lines L,
3855: zx_lines_det_factors G
3856: WHERE G.application_id = p_event_class_rec.application_id
3857: AND G.entity_code = p_event_class_rec.entity_code
3858: AND G.event_class_code = p_event_class_rec.event_class_code
3859: -- AND G.trx_id = p_event_class_rec.trx_id

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

3922: -- PUBLIC PROCEDURE
3923: -- process_discard_tax_lines
3924: --
3925: -- DESCRIPTION
3926: -- This procedure brings all discarded tax lines from zx_lines into
3927: -- detail tax lines global temp table
3928: --
3929: -- CALLED BY
3930: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 3950: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

3946: END IF;
3947:
3948: p_return_status := FND_API.G_RET_STS_SUCCESS;
3949:
3950: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
3951: INSERT INTO zx_detail_tax_lines_gt
3952: ( tax_line_id,
3953: internal_organization_id,
3954: application_id,

Line 4559: FROM ZX_LINES L,

4555: 1,
4556: decode(L.legal_reporting_status,'111111111111111',
4557: '000000000000000',L.legal_reporting_status),
4558: L.account_source_tax_rate_id
4559: FROM ZX_LINES L,
4560: zx_lines_det_factors G
4561: WHERE G.application_id = p_event_class_rec.application_id AND
4562: G.entity_code = p_event_class_rec.entity_code AND
4563: G.event_class_code = p_event_class_rec.event_class_code AND

Line 4560: zx_lines_det_factors G

4556: decode(L.legal_reporting_status,'111111111111111',
4557: '000000000000000',L.legal_reporting_status),
4558: L.account_source_tax_rate_id
4559: FROM ZX_LINES L,
4560: zx_lines_det_factors G
4561: WHERE G.application_id = p_event_class_rec.application_id AND
4562: G.entity_code = p_event_class_rec.entity_code AND
4563: G.event_class_code = p_event_class_rec.event_class_code AND
4564: -- G.trx_id = p_event_class_rec.trx_id AND

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

4623: -- process_cancel_trx_lines
4624: --
4625: -- DESCRIPTION
4626: -- This procedure processes cancelled trx lines (line_level_action='CANCEL')
4627: -- It brings all tax lines from zx_lines into detail tax lines global temp table
4628: -- and mark them as cancelled
4629: --
4630: -- CALLED BY
4631: -- ZX_TDS_TAX_LINES_DETM_PKG

Line 4651: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

4647: END IF;
4648:
4649: p_return_status := FND_API.G_RET_STS_SUCCESS;
4650:
4651: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
4652: INSERT INTO zx_detail_tax_lines_gt
4653: ( tax_line_id,
4654: internal_organization_id,
4655: application_id,

Line 5252: FROM ZX_LINES L,

5248: 1,
5249: decode(L.legal_reporting_status, '111111111111111',
5250: '000000000000000', L.legal_reporting_status),
5251: L.account_source_tax_rate_id
5252: FROM ZX_LINES L,
5253: zx_lines_det_factors G
5254: WHERE G.application_id = p_event_class_rec.application_id AND
5255: G.entity_code = p_event_class_rec.entity_code AND
5256: G.event_class_code = p_event_class_rec.event_class_code AND

Line 5253: zx_lines_det_factors G

5249: decode(L.legal_reporting_status, '111111111111111',
5250: '000000000000000', L.legal_reporting_status),
5251: L.account_source_tax_rate_id
5252: FROM ZX_LINES L,
5253: zx_lines_det_factors G
5254: WHERE G.application_id = p_event_class_rec.application_id AND
5255: G.entity_code = p_event_class_rec.entity_code AND
5256: G.event_class_code = p_event_class_rec.event_class_code AND
5257: -- G.trx_id = p_event_class_rec.trx_id AND

Line 5359: zx_lines_det_factors trx_line

5355: tax_line.tax_id,
5356: tax_line.tax_hold_released_code,
5357: tax_line.Rounding_Rule_Code
5358: FROM ZX_DETAIL_TAX_LINES_GT tax_line,
5359: zx_lines_det_factors trx_line
5360: WHERE tax_line.application_id = p_event_class_rec.application_id
5361: AND tax_line.entity_code = p_event_class_rec.entity_code
5362: AND tax_line.event_class_code = p_event_class_rec.event_class_code
5363: AND tax_line.trx_id = p_event_class_rec.trx_id

Line 5417: (SELECT /+ index(LINE ZX_LINES_DET_FACTORS_U1) / 1

5413: AND gt.offset_link_to_tax_line_id IS NULL
5414: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5415: AND gt.mrc_tax_line_flag = 'N'
5416: AND EXISTS
5417: (SELECT /*+ index(LINE ZX_LINES_DET_FACTORS_U1) */ 1
5418: FROM zx_lines_det_factors line
5419: WHERE line.application_id = p_event_class_rec.application_id
5420: AND line.entity_code = p_event_class_rec.entity_code
5421: AND line.event_class_code = p_event_class_rec.event_class_code

Line 5418: FROM zx_lines_det_factors line

5414: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5415: AND gt.mrc_tax_line_flag = 'N'
5416: AND EXISTS
5417: (SELECT /*+ index(LINE ZX_LINES_DET_FACTORS_U1) */ 1
5418: FROM zx_lines_det_factors line
5419: WHERE line.application_id = p_event_class_rec.application_id
5420: AND line.entity_code = p_event_class_rec.entity_code
5421: AND line.event_class_code = p_event_class_rec.event_class_code
5422: AND line.event_id = p_event_class_rec.event_id