DBA Data[Home] [Help]

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_TDS_UTILITIES_PKG

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

1138: -- prd_total_tax_amt_tax_curr, prd_total_tax_amt_funcl_curr from zx_lines
1139: --
1140: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL THEN
1141:
1142: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(
1143: p_tax_line_index).tax_id) then
1144:
1145: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1146: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,

Line 1145: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

1141:
1142: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(
1143: p_tax_line_index).tax_id) then
1144:
1145: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1146: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,
1147: p_return_status => p_return_status,
1148: p_error_buffer => p_error_buffer);
1149: END IF;

Line 1152: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(

1148: p_error_buffer => p_error_buffer);
1149: END IF;
1150:
1151:
1152: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(
1153: p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
1154: THEN
1155: p_rec_nrec_dist_tbl(i).prd_total_tax_amt :=
1156: p_detail_tax_line_tbl(p_tax_line_index).prd_total_tax_amt;

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

1696: g_tax_recovery_info_tbl(l_tax_id).tax_id := l_tax_id;
1697:
1698: END IF;
1699:
1700: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(l_tax_id) then
1701:
1702: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1703: p_tax_id => l_tax_id,
1704: p_return_status => p_return_status,

Line 1702: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

1698: END IF;
1699:
1700: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(l_tax_id) then
1701:
1702: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1703: p_tax_id => l_tax_id,
1704: p_return_status => p_return_status,
1705: p_error_buffer => p_error_buffer);
1706: END IF;

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

1719: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1720: p_trx_line_dist_index) IS NOT NULL OR
1721: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1722: p_trx_line_dist_index) IS NOT NULL AND
1723: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag ='P')
1724: THEN
1725:
1726: IF (g_level_procedure >= g_current_runtime_level ) THEN
1727:

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

2534:
2535: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL
2536: THEN
2537: l_tax_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_id;
2538: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='R'
2539: THEN
2540: -- call round_and_adjust_prd_tax_amts to round and adjust prd_tax_amt,
2541: -- prd_tax_amt_tax_curr, and prd_tax_amt_funcl_curr
2542: --

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

2562: END IF;
2563: RETURN;
2564: END IF;
2565:
2566: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag='P'
2567: THEN
2568: -- copy rec_nrec_tax_amt, rec_nrec_tax_amt_tax_curr,
2569: -- rec_nrec_tax_amt_funcl_curr to prd_tax_amt, prd_tax_amt_tax_curr,
2570: -- prd_tax_amt_funcl_curr.

Line 3270: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

3266: -- get l_min_acct_unit_tax_curr l_precision_tax_curr and
3267: -- l_rounding_rule_tax_curr
3268: --
3269: l_tax_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_id;
3270: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3271: p_tax_id => l_tax_id,
3272: p_return_status => p_return_status,
3273: p_error_buffer => p_error_buffer);
3274: l_precision_tax_curr :=

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

3271: p_tax_id => l_tax_id,
3272: p_return_status => p_return_status,
3273: p_error_buffer => p_error_buffer);
3274: l_precision_tax_curr :=
3275: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
3276: l_min_acct_unit_tax_curr :=
3277: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3278: POWER(10,l_precision_tax_curr*(-1)));
3279:

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

3273: p_error_buffer => p_error_buffer);
3274: l_precision_tax_curr :=
3275: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
3276: l_min_acct_unit_tax_curr :=
3277: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3278: POWER(10,l_precision_tax_curr*(-1)));
3279:
3280: -- l_rounding_rule_tax_curr :=
3281: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code;

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

3277: NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit,
3278: POWER(10,l_precision_tax_curr*(-1)));
3279:
3280: -- l_rounding_rule_tax_curr :=
3281: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code;
3282:
3283: FOR i IN p_rnd_begin_index .. p_rnd_end_index LOOP
3284:
3285: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag,'N') = 'N' THEN

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

3899: -- get l_min_acct_unit and l_precision and l_funcl_currency_code
3900: --
3901: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
3902:
3903: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
3904:
3905: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
3906: p_ledger_id => l_ledger_id,
3907: p_return_status => p_return_status,

Line 3905: ZX_TDS_UTILITIES_PKG.populate_currency_cache (

3901: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
3902:
3903: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
3904:
3905: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
3906: p_ledger_id => l_ledger_id,
3907: p_return_status => p_return_status,
3908: p_error_buffer => p_error_buffer);
3909:

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

3912: IF (g_level_error >= g_current_runtime_level ) THEN
3913: FND_LOG.STRING(g_level_error,
3914: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3915: 'Incorrect return_status after calling ' ||
3916: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
3917: FND_LOG.STRING(g_level_error,
3918: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.END',
3919: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(-)'||p_return_status);
3920: END IF;

Line 3925: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

3921: RETURN;
3922: END IF;
3923: END IF;
3924:
3925: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3926: l_ledger_id).currency_code;
3927: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3928: l_ledger_id).precision;
3929: l_min_acct_unit_funcl_curr :=

Line 3927: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

3923: END IF;
3924:
3925: l_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3926: l_ledger_id).currency_code;
3927: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3928: l_ledger_id).precision;
3929: l_min_acct_unit_funcl_curr :=
3930: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3931: l_ledger_id).minimum_accountable_unit,

Line 3930: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

3926: l_ledger_id).currency_code;
3927: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3928: l_ledger_id).precision;
3929: l_min_acct_unit_funcl_curr :=
3930: NVL(ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
3931: l_ledger_id).minimum_accountable_unit,
3932: POWER(10,l_precision_funcl_curr*(-1)));
3933:
3934: IF l_funcl_currency_code =

Line 4816: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

4812:
4813: p_rnd_end_index := p_rnd_begin_index -1;
4814: l_rec_nrec_tax_dist_number:= 0;
4815:
4816: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
4817: p_tax_id => p_tax_id,
4818: p_return_status => p_return_status,
4819: p_error_buffer => p_error_buffer);
4820:

Line 4847: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

4843: -- applied document. recovery_rate_id and rec_nrec_rate are determined
4844: -- in the current document. Tax distributions are recalculated based on
4845: -- the rec_nrec_ratein the current document.
4846: --
4847: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
4848: p_tax_id).applied_amt_handling_flag = 'P' THEN
4849: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_code :=
4850: tax_dist_rec.recovery_rate_code;
4851: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_id :=

Line 4863: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

4859: tax_dist_rec.def_rec_settlement_option_code;
4860: p_rec_nrec_dist_tbl(p_rnd_end_index).account_source_tax_rate_id :=
4861: tax_dist_rec.account_source_tax_rate_id;
4862:
4863: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
4864: p_tax_id).applied_amt_handling_flag = 'R' THEN
4865: p_rec_nrec_dist_tbl(p_rnd_end_index).recovery_rate_code :=
4866: tax_dist_rec.recovery_rate_code;
4867:

Line 5106: ZX_TDS_UTILITIES_PKG.populate_tax_cache (

5102: l_max_tax_dist_number := NVL(l_max_tax_dist_number, 0);
5103:
5104: l_rec_nrec_tax_dist_number:= l_max_tax_dist_number;
5105:
5106: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
5107: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,
5108: p_return_status => p_return_status,
5109: p_error_buffer => p_error_buffer);
5110:

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

5182: IF (g_level_error >= g_current_runtime_level ) THEN
5183: FND_LOG.STRING(g_level_error,
5184: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5185: 'Incorrect return_status after calling ' ||
5186: 'ZX_TDS_UTILITIES_PKG.det_appl_rec_type()');
5187: FND_LOG.STRING(g_level_error,
5188: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',
5189: 'RETURN_STATUS = ' || p_return_status);
5190: FND_LOG.STRING(g_level_error,

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

5280: -- get minimum_accountable_unit and precision in functional currency
5281: --
5282: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
5283: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id IS NOT NULL THEN
5284: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
5285:
5286: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
5287: p_ledger_id => l_ledger_id,
5288: p_return_status => p_return_status,

Line 5286: ZX_TDS_UTILITIES_PKG.populate_currency_cache (

5282: l_ledger_id := p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id;
5283: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).ledger_id IS NOT NULL THEN
5284: IF NOT ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(l_ledger_id) THEN
5285:
5286: ZX_TDS_UTILITIES_PKG.populate_currency_cache (
5287: p_ledger_id => l_ledger_id,
5288: p_return_status => p_return_status,
5289: p_error_buffer => p_error_buffer);
5290:

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

5293: IF (g_level_error >= g_current_runtime_level ) THEN
5294: FND_LOG.STRING(g_level_error,
5295: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
5296: 'Incorrect return_status after calling ' ||
5297: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache()');
5298: FND_LOG.STRING(g_level_error,
5299: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',
5300: 'RETURN_STATUS = ' || p_return_status);
5301: FND_LOG.STRING(g_level_error,

Line 5309: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

5305: RETURN;
5306: END IF;
5307: END IF;
5308:
5309: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
5310: l_ledger_id).minimum_accountable_unit;
5311: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
5312: l_ledger_id).precision;
5313: END IF;

Line 5311: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(

5307: END IF;
5308:
5309: l_min_acct_unit_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
5310: l_ledger_id).minimum_accountable_unit;
5311: l_precision_funcl_curr := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(
5312: l_ledger_id).precision;
5313: END IF;
5314:
5315: FOR i IN p_rnd_begin_index .. p_rnd_end_index LOOP

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

5319:
5320: -- get l_min_acct_unit_tax_curr and l_precision_tax_curr from g_tax_rec_tbl
5321: --
5322: l_min_acct_unit_tax_curr :=
5323: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
5324: l_precision_tax_curr :=
5325: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
5326:
5327: -- round prd_tax_amt

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

5321: --
5322: l_min_acct_unit_tax_curr :=
5323: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
5324: l_precision_tax_curr :=
5325: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
5326:
5327: -- round prd_tax_amt
5328: --
5329: p_rec_nrec_dist_tbl(i).prd_tax_amt :=