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_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_TDS_UTILITIES_PKG

Line 475: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

471: p_rec_nrec_dist_tbl(l_new_index).reverse_flag := 'N';
472: p_rec_nrec_dist_tbl(l_new_index).posting_flag := NULL;
473:
474: -- Start : Code changes for Bug#10072294 --
475: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
476: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,
477: p_return_status => p_return_status,
478: p_error_buffer => p_error_buffer);
479:

Line 485: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()'||p_return_status);

481: IF (g_level_statement >= g_current_runtime_level ) THEN
482: FND_LOG.STRING(g_level_statement,
483: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
484: 'Incorrect return_status after calling ' ||
485: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()'||p_return_status);
486: END IF;
487: RETURN;
488: END IF;
489:

Line 494: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'

490: IF (NVL(p_rec_nrec_dist_tbl(l_new_index).historical_flag, 'N') <> 'Y') AND
491: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL) AND
492: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL OR
493: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NOT NULL AND
494: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
495: )
496: )
497: THEN
498: p_rec_nrec_dist_tbl(l_new_index).recovery_rate_id := NULL;

Line 1227: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(

1223: -- prd_total_tax_amt_tax_curr, prd_total_tax_amt_funcl_curr from zx_lines
1224: --
1225: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL THEN
1226:
1227: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(
1228: p_tax_line_index).tax_id) then
1229:
1230: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1231: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,

Line 1230: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

1226:
1227: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(
1228: p_tax_line_index).tax_id) then
1229:
1230: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1231: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,
1232: p_return_status => p_return_status,
1233: p_error_buffer => p_error_buffer);
1234: END IF;

Line 1237: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(

1233: p_error_buffer => p_error_buffer);
1234: END IF;
1235:
1236:
1237: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(
1238: p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
1239: THEN
1240: p_rec_nrec_dist_tbl(i).prd_total_tax_amt :=
1241: p_detail_tax_line_tbl(p_tax_line_index).prd_total_tax_amt;

Line 1804: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(l_tax_id) then

1800: g_tax_recovery_info_tbl(l_tax_id).tax_id := l_tax_id;
1801:
1802: END IF;
1803:
1804: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(l_tax_id) then
1805: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1806: p_tax_id => l_tax_id,
1807: p_return_status => p_return_status,
1808: p_error_buffer => p_error_buffer);

Line 1805: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

1801:
1802: END IF;
1803:
1804: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(l_tax_id) then
1805: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1806: p_tax_id => l_tax_id,
1807: p_return_status => p_return_status,
1808: p_error_buffer => p_error_buffer);
1809: END IF;

Line 1827: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag ='P')

1823: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1824: p_trx_line_dist_index) IS NOT NULL OR
1825: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1826: p_trx_line_dist_index) IS NOT NULL AND
1827: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag ='P')
1828: THEN
1829:
1830: IF (g_level_procedure >= g_current_runtime_level ) THEN
1831:

Line 2807: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='R'

2803:
2804: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL
2805: THEN
2806: l_tax_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_id;
2807: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='R'
2808: THEN
2809: -- call round_and_adjust_prd_tax_amts to round and adjust prd_tax_amt,
2810: -- prd_tax_amt_tax_curr, and prd_tax_amt_funcl_curr
2811: --

Line 2835: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='P'

2831: END IF;
2832: RETURN;
2833: END IF;
2834:
2835: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='P'
2836: THEN
2837: -- copy rec_nrec_tax_amt, rec_nrec_tax_amt_tax_curr,
2838: -- rec_nrec_tax_amt_funcl_curr to prd_tax_amt, prd_tax_amt_tax_curr,
2839: -- prd_tax_amt_funcl_curr.

Line 3670: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

3666: -- get l_min_acct_unit_tax_curr l_precision_tax_curr and
3667: -- l_rounding_rule_tax_curr
3668: --
3669: l_tax_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_id;
3670: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3671: p_tax_id => l_tax_id,
3672: p_return_status => p_return_status,
3673: p_error_buffer => p_error_buffer);
3674: l_precision_tax_curr :=

Line 3675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;

3671: p_tax_id => l_tax_id,
3672: p_return_status => p_return_status,
3673: p_error_buffer => p_error_buffer);
3674: l_precision_tax_curr :=
3675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
3676: l_min_acct_unit_tax_curr :=
3677: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3678: POWER(10,l_precision_tax_curr*(-1)));
3679:

Line 3677: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,

3673: p_error_buffer => p_error_buffer);
3674: l_precision_tax_curr :=
3675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
3676: l_min_acct_unit_tax_curr :=
3677: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3678: POWER(10,l_precision_tax_curr*(-1)));
3679:
3680: -- l_rounding_rule_tax_curr :=
3681: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code;

Line 3681: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code;

3677: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3678: POWER(10,l_precision_tax_curr*(-1)));
3679:
3680: -- l_rounding_rule_tax_curr :=
3681: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code;
3682:
3683: FOR i IN p_rnd_begin_index .. p_rnd_end_index LOOP
3684:
3685: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag,'N') = 'N' THEN

Line 4303: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN

4299: -- get l_min_acct_unit and l_precision and l_funcl_currency_code
4300: --
4301: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
4302:
4303: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
4304:
4305: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
4306: p_ledger_id => l_ledger_id,
4307: p_return_status => p_return_status,

Line 4305: ZX_TDS_UTILITIES_PKG.populate_currency_cache (

4301: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
4302:
4303: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
4304:
4305: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
4306: p_ledger_id => l_ledger_id,
4307: p_return_status => p_return_status,
4308: p_error_buffer => p_error_buffer);
4309:

Line 4316: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');

4312: IF (g_level_error >= g_current_runtime_level ) THEN
4313: FND_LOG.STRING(g_level_error,
4314: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
4315: 'Incorrect return_status after calling ' ||
4316: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
4317: FND_LOG.STRING(g_level_error,
4318: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
4319: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
4320: END IF;

Line 4325: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

4321: RETURN;
4322: END IF;
4323: END IF;
4324:
4325: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4326: l_ledger_id).currency_code;
4327: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4328: l_ledger_id).precision;
4329: l_min_acct_unit_funcl_curr :=

Line 4327: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

4323: END IF;
4324:
4325: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4326: l_ledger_id).currency_code;
4327: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4328: l_ledger_id).precision;
4329: l_min_acct_unit_funcl_curr :=
4330: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4331: l_ledger_id).minimum_accountable_unit,

Line 4330: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

4326: l_ledger_id).currency_code;
4327: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4328: l_ledger_id).precision;
4329: l_min_acct_unit_funcl_curr :=
4330: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
4331: l_ledger_id).minimum_accountable_unit,
4332: POWER(10,l_precision_funcl_curr*(-1)));
4333:
4334: IF l_funcl_currency_code =

Line 5221: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

5217:
5218: p_rnd_end_index := p_rnd_begin_index -1;
5219: l_rec_nrec_tax_dist_number:= 0;
5220:
5221: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
5222: p_tax_id => p_tax_id,
5223: p_return_status => p_return_status,
5224: p_error_buffer => p_error_buffer);
5225:

Line 5316: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

5312: -- applied document. recovery_rate_id and rec_nrec_rate are determined
5313: -- in the current document. Tax distributions are recalculated based on
5314: -- the rec_nrec_ratein the current document.
5315: --
5316: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
5317: p_tax_id).applied_amt_handling_flag = 'P' THEN
5318: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_code :=
5319: tax_dist_rec.recovery_rate_code;
5320: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_id :=

Line 5332: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

5328: tax_dist_rec.def_rec_settlement_option_code;
5329: p_rec_nrec_dist_tbl(p_rnd_end_index).account_source_tax_rate_id :=
5330: tax_dist_rec.account_source_tax_rate_id;
5331:
5332: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
5333: p_tax_id).applied_amt_handling_flag = 'R' THEN
5334: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_code :=
5335: tax_dist_rec.recovery_rate_code;
5336:

Line 5448: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

5444: p_rnd_end_index := p_rnd_begin_index - 1;
5445:
5446: l_rec_nrec_tax_dist_number := 0;
5447:
5448: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
5449: p_tax_id => p_tax_id,
5450: p_return_status => p_return_status,
5451: p_error_buffer => p_error_buffer);
5452:

Line 5683: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

5679: l_tax_id := p_detail_tax_line_tbl(p_tax_line_index).tax_id;
5680: l_tax := p_detail_tax_line_tbl(p_tax_line_index).tax;
5681: l_tax_regime_code := p_detail_tax_line_tbl(p_tax_line_index).tax_regime_code;
5682:
5683: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
5684: p_tax_id => l_tax_id,
5685: p_return_status => p_return_status,
5686: p_error_buffer => p_error_buffer);
5687:

Line 5906: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');

5902: IF (g_level_error >= g_current_runtime_level ) THEN
5903: FND_LOG.STRING(g_level_error,
5904: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5905: 'Incorrect return_status after calling ' ||
5906: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');
5907: FND_LOG.STRING(g_level_error,
5908: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5909: 'RETURN_STATUS = ' || p_return_status);
5910: FND_LOG.STRING(g_level_error,

Line 6006: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN

6002: -- get minimum_accountable_unit and precision in functional currency
6003: --
6004: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
6005: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id IS NOT NULL THEN
6006: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
6007:
6008: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
6009: p_ledger_id => l_ledger_id,
6010: p_return_status => p_return_status,

Line 6008: ZX_TDS_UTILITIES_PKG.populate_currency_cache (

6004: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
6005: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id IS NOT NULL THEN
6006: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
6007:
6008: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
6009: p_ledger_id => l_ledger_id,
6010: p_return_status => p_return_status,
6011: p_error_buffer => p_error_buffer);
6012:

Line 6019: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');

6015: IF (g_level_error >= g_current_runtime_level ) THEN
6016: FND_LOG.STRING(g_level_error,
6017: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6018: 'Incorrect return_status after calling ' ||
6019: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
6020: FND_LOG.STRING(g_level_error,
6021: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
6022: 'RETURN_STATUS = ' || p_return_status);
6023: FND_LOG.STRING(g_level_error,

Line 6031: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

6027: RETURN;
6028: END IF;
6029: END IF;
6030:
6031: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
6032: l_ledger_id).minimum_accountable_unit;
6033: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
6034: l_ledger_id).precision;
6035: END IF;

Line 6033: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

6029: END IF;
6030:
6031: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
6032: l_ledger_id).minimum_accountable_unit;
6033: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
6034: l_ledger_id).precision;
6035: END IF;
6036:
6037: FOR i IN p_rnd_begin_index .. p_rnd_end_index LOOP

Line 6045: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;

6041:
6042: -- get l_min_acct_unit_tax_curr and l_precision_tax_curr from g_tax_rec_tbl
6043: --
6044: l_min_acct_unit_tax_curr :=
6045: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
6046: l_precision_tax_curr :=
6047: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
6048:
6049: -- round prd_tax_amt

Line 6047: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;

6043: --
6044: l_min_acct_unit_tax_curr :=
6045: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
6046: l_precision_tax_curr :=
6047: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
6048:
6049: -- round prd_tax_amt
6050: --
6051: p_rec_nrec_dist_tbl(i).prd_tax_amt :=