DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on ARPCURR

Line 1385: arpcurr.functional_amount(nvl(ctl.taxable_amount,0) ,

1381: nvl(line.location_segment_id,line.vat_tax_id))),
1382: '') ae_tax_group_code_id,
1383: nvl(ctl.location_segment_id,ctl.vat_tax_id) ae_tax_id,
1384: ctl.taxable_amount ae_taxable_amount,
1385: arpcurr.functional_amount(nvl(ctl.taxable_amount,0) ,
1386: g_ae_sys_rec.base_currency ,
1387: g_cust_inv_rec.exchange_rate,
1388: g_ae_sys_rec.base_precision ,
1389: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

Line 1614: arpcurr.functional_amount(nvl(det.amount,0) ,

1610: nvl(ctl.location_segment_id,ctl.vat_tax_id) ae_tax_id,
1611: --'' ae_tax_group_code_id,
1612: --'' ae_tax_id,
1613: det.amount ae_taxable_amount,
1614: arpcurr.functional_amount(nvl(det.amount,0) ,
1615: g_ae_sys_rec.base_currency ,
1616: g_cust_inv_rec.exchange_rate,
1617: g_ae_sys_rec.base_precision ,
1618: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

Line 2229: arpcurr.functional_amount(nvl(det.amount,0) ,

2225: '' ae_acctd_amount,
2226: '' ae_tax_group_code_id,
2227: '' ae_tax_id,
2228: det.amount ae_taxable_amount,
2229: arpcurr.functional_amount(nvl(det.amount,0) ,
2230: g_ae_sys_rec.base_currency ,
2231: g_cust_inv_rec.exchange_rate,
2232: g_ae_sys_rec.base_precision ,
2233: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

Line 4038: l_acctd_amount := arpcurr.functional_amount(p_amount ,

4034: IF PG_DEBUG in ('Y', 'C') THEN
4035: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
4036: END IF;
4037:
4038: l_acctd_amount := arpcurr.functional_amount(p_amount ,
4039: g_ae_sys_rec.base_currency ,
4040: g_cust_inv_rec.exchange_rate ,
4041: g_ae_sys_rec.base_precision ,
4042: g_ae_sys_rec.base_min_acc_unit );

Line 4206: | The arpcurr round function is used to round to precision for curency of |

4202:
4203: /*------------------------------------------------------------------------------+
4204: | Set tax applied and accounted and allocate over tax, this is done using a |
4205: | RATE which is determined based on the total deferred tax over the actual tax |
4206: | The arpcurr round function is used to round to precision for curency of |
4207: | Invoice and functional currency. |
4208: +------------------------------------------------------------------------------*/
4209: IF ((g_ae_def_tax) AND (NOT g_done_def_tax) AND (p_type_acct = 'PAY'))
4210: AND l_process_tax THEN

Line 4214: l_tax_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_amt_alloc *

4210: AND l_process_tax THEN
4211:
4212: IF g_ae_rule_rec.tax_amt <> 0 THEN --prevent zero divide
4213:
4214: l_tax_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_amt_alloc *
4215: g_ae_rule_rec.def_tax_amt/g_ae_rule_rec.tax_amt,
4216: g_cust_inv_rec.invoice_currency_code);
4217: END IF; --amt not zero
4218:

Line 4221: l_tax_acctd_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_acctd_amt_alloc *

4217: END IF; --amt not zero
4218:
4219: IF g_ae_rule_rec.tax_acctd_amt <> 0 THEN --prevent zero divide
4220:
4221: l_tax_acctd_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_acctd_amt_alloc *
4222: g_ae_rule_rec.def_tax_acctd_amt/g_ae_rule_rec.tax_acctd_amt,
4223: g_ae_sys_rec.base_currency);
4224: END IF; --accounted amt not zero
4225:

Line 4296: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt * g_ae_rule_rec.line_amt_alloc,

4292: | Process line amounts |
4293: +------------------------------------------------------------------------------*/
4294: IF l_process_rev THEN
4295: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) :=
4296: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt * g_ae_rule_rec.line_amt_alloc,
4297: g_cust_inv_rec.invoice_currency_code) - l_rev_run_pro_amt_tot;
4298:
4299: IF PG_DEBUG in ('Y', 'C') THEN
4300: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_amt = '||

Line 4316: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt *

4312: | Process Freight and charges |
4313: +------------------------------------------------------------------------------*/
4314: IF l_process_frt THEN
4315: g_ae_alloc_rev_tax_tbl.ae_pro_frt_chrg_amt(i) :=
4316: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt *
4317: (g_ae_rule_rec.freight_amt_alloc + g_ae_rule_rec.charges_amt_alloc),
4318: g_cust_inv_rec.invoice_currency_code) - l_frt_run_pro_amt_tot;
4319:
4320: IF PG_DEBUG in ('Y', 'C') THEN

Line 4344: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt

4340: | Process Line accounted amounts |
4341: +------------------------------------------------------------------------------*/
4342: IF l_process_rev THEN
4343: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) :=
4344: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt
4345: * g_ae_rule_rec.line_acctd_amt_alloc, g_ae_sys_rec.base_currency)
4346: - l_rev_run_pro_acctd_amt_tot;
4347:
4348: IF PG_DEBUG in ('Y', 'C') THEN

Line 4364: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt

4360: | Process Freight and charges |
4361: +------------------------------------------------------------------------------*/
4362: IF l_process_frt THEN
4363: g_ae_alloc_rev_tax_tbl.ae_pro_frt_chrg_acctd_amt(i) :=
4364: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt
4365: * (g_ae_rule_rec.freight_acctd_amt_alloc + g_ae_rule_rec.charges_acctd_amt_alloc),
4366: g_ae_sys_rec.base_currency) - l_frt_run_pro_acctd_amt_tot;
4367:
4368: IF PG_DEBUG in ('Y', 'C') THEN

Line 4412: arpcurr.CurrRound(l_tax_run_amt_tot / g_ae_rule_rec.tax_amt * g_ae_rule_rec.tax_amt_alloc,

4408: | Line ..... |
4409: +------------------------------------------------------------------------------*/
4410:
4411: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) :=
4412: arpcurr.CurrRound(l_tax_run_amt_tot / g_ae_rule_rec.tax_amt * g_ae_rule_rec.tax_amt_alloc,
4413: g_cust_inv_rec.invoice_currency_code) - l_tax_run_pro_amt_tot;
4414:
4415: IF PG_DEBUG in ('Y', 'C') THEN
4416: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_amt = '||

Line 4432: arpcurr.CurrRound(l_tax_run_acctd_amt_tot / g_ae_rule_rec.tax_acctd_amt

4428: /*------------------------------------------------------------------------------+
4429: | Calculate accounted amount for tax amount allocated to each tax line |
4430: +------------------------------------------------------------------------------*/
4431: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) :=
4432: arpcurr.CurrRound(l_tax_run_acctd_amt_tot / g_ae_rule_rec.tax_acctd_amt
4433: * g_ae_rule_rec.tax_acctd_amt_alloc, g_ae_sys_rec.base_currency)
4434: - l_tax_run_pro_acctd_amt_tot;
4435:
4436: IF PG_DEBUG in ('Y', 'C') THEN

Line 4458: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_amount(i) *

4454:
4455: IF g_ae_alloc_rev_tax_tbl.ae_amount(i) <> 0 THEN
4456:
4457: g_ae_alloc_rev_tax_tbl.ae_pro_taxable_amt(i) :=
4458: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_amount(i) *
4459: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) / g_ae_alloc_rev_tax_tbl.ae_amount(i),
4460: g_cust_inv_rec.invoice_currency_code);
4461:
4462: IF PG_DEBUG in ('Y', 'C') THEN

Line 4475: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_acctd_amount(i) *

4471: +------------------------------------------------------------------------------*/
4472: IF g_ae_alloc_rev_tax_tbl.ae_acctd_amount(i) <> 0 THEN
4473:
4474: g_ae_alloc_rev_tax_tbl.ae_pro_taxable_acctd_amt(i) :=
4475: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_acctd_amount(i) *
4476: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) / g_ae_alloc_rev_tax_tbl.ae_acctd_amount(i),
4477: g_ae_sys_rec.base_currency);
4478:
4479: IF PG_DEBUG in ('Y', 'C') THEN

Line 4509: arpcurr.CurrRound(l_def_tax_run_amt_tot / g_ae_rule_rec.def_tax_amt * l_tax_applied,

4505: +---------------------------------------------------------------------------------*/
4506: IF g_ae_rule_rec.def_tax_amt <> 0 THEN
4507:
4508: g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_amt(i) :=
4509: arpcurr.CurrRound(l_def_tax_run_amt_tot / g_ae_rule_rec.def_tax_amt * l_tax_applied,
4510: g_cust_inv_rec.invoice_currency_code) - l_pro_def_tax_run_amt;
4511:
4512: IF PG_DEBUG in ('Y', 'C') THEN
4513: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_amt = '||

Line 4531: arpcurr.CurrRound(l_def_tax_run_acctd_amt_tot / g_ae_rule_rec.def_tax_acctd_amt

4527: +------------------------------------------------------------------------------*/
4528: IF g_ae_rule_rec.def_tax_acctd_amt <> 0 THEN
4529:
4530: g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_acctd_amt(i) :=
4531: arpcurr.CurrRound(l_def_tax_run_acctd_amt_tot / g_ae_rule_rec.def_tax_acctd_amt
4532: * l_tax_acctd_applied, g_ae_sys_rec.base_currency)
4533: - l_pro_def_tax_run_acctd_amt;
4534:
4535: IF PG_DEBUG in ('Y', 'C') THEN

Line 5238: l_tax_amt_pro_rev := arpcurr.CurrRound(l_rev_run_amt_tot / l_base_amt

5234: +------------------------------------------------------------------------------*/
5235: l_rev_run_amt_tot := l_rev_run_amt_tot + l_weight_amt;
5236: l_rev_run_acctd_amt_tot := l_rev_run_acctd_amt_tot + l_weight_acctd_amt;
5237:
5238: l_tax_amt_pro_rev := arpcurr.CurrRound(l_rev_run_amt_tot / l_base_amt
5239: * g_ae_alloc_tax_tbl.ae_pro_amt,
5240: g_cust_inv_rec.invoice_currency_code) - l_rev_run_pro_amt_tot ;
5241:
5242: IF PG_DEBUG in ('Y', 'C') THEN

Line 5254: l_tax_acctd_amt_pro_rev := arpcurr.CurrRound(l_rev_run_acctd_amt_tot /

5250:
5251: /*------------------------------------------------------------------------------+
5252: | Calculate accounted amount for revenue amount allocated to each revenue line |
5253: +------------------------------------------------------------------------------*/
5254: l_tax_acctd_amt_pro_rev := arpcurr.CurrRound(l_rev_run_acctd_amt_tot /
5255: l_base_acctd_amt
5256: * g_ae_alloc_tax_tbl.ae_pro_acctd_amt,
5257: g_ae_sys_rec.base_currency) - l_rev_run_pro_acctd_amt_tot ;
5258: IF PG_DEBUG in ('Y', 'C') THEN