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.ARP_ALLOCATION_PKG dependencies on ARPCURR

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

1312: nvl(line.location_segment_id,line.vat_tax_id))),
1313: '') ae_tax_group_code_id,
1314: nvl(ctl.location_segment_id,ctl.vat_tax_id) ae_tax_id,
1315: ctl.taxable_amount ae_taxable_amount,
1316: arpcurr.functional_amount(nvl(ctl.taxable_amount,0) ,
1317: g_ae_sys_rec.base_currency ,
1318: g_cust_inv_rec.exchange_rate,
1319: g_ae_sys_rec.base_precision ,
1320: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

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

1528: '' ae_acctd_amount,
1529: '' ae_tax_group_code_id,
1530: '' ae_tax_id,
1531: det.amount ae_taxable_amount,
1532: arpcurr.functional_amount(nvl(det.amount,0) ,
1533: g_ae_sys_rec.base_currency ,
1534: g_cust_inv_rec.exchange_rate,
1535: g_ae_sys_rec.base_precision ,
1536: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

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

2066: '' ae_acctd_amount,
2067: '' ae_tax_group_code_id,
2068: '' ae_tax_id,
2069: det.amount ae_taxable_amount,
2070: arpcurr.functional_amount(nvl(det.amount,0) ,
2071: g_ae_sys_rec.base_currency ,
2072: g_cust_inv_rec.exchange_rate,
2073: g_ae_sys_rec.base_precision ,
2074: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,

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

3748: IF PG_DEBUG in ('Y', 'C') THEN
3749: arp_standard.debug( 'ARP_ALLOCATION_PKG.Get_Acctd_Amt()-');
3750: END IF;
3751:
3752: l_acctd_amount := arpcurr.functional_amount(p_amount ,
3753: g_ae_sys_rec.base_currency ,
3754: g_cust_inv_rec.exchange_rate ,
3755: g_ae_sys_rec.base_precision ,
3756: g_ae_sys_rec.base_min_acc_unit );

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

3916:
3917: /*------------------------------------------------------------------------------+
3918: | Set tax applied and accounted and allocate over tax, this is done using a |
3919: | RATE which is determined based on the total deferred tax over the actual tax |
3920: | The arpcurr round function is used to round to precision for curency of |
3921: | Invoice and functional currency. |
3922: +------------------------------------------------------------------------------*/
3923: IF ((g_ae_def_tax) AND (NOT g_done_def_tax) AND (p_type_acct = 'PAY'))
3924: AND l_process_tax THEN

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

3924: AND l_process_tax THEN
3925:
3926: IF g_ae_rule_rec.tax_amt <> 0 THEN --prevent zero divide
3927:
3928: l_tax_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_amt_alloc *
3929: g_ae_rule_rec.def_tax_amt/g_ae_rule_rec.tax_amt,
3930: g_cust_inv_rec.invoice_currency_code);
3931: END IF; --amt not zero
3932:

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

3931: END IF; --amt not zero
3932:
3933: IF g_ae_rule_rec.tax_acctd_amt <> 0 THEN --prevent zero divide
3934:
3935: l_tax_acctd_applied := arpcurr.CurrRound(g_ae_rule_rec.tax_acctd_amt_alloc *
3936: g_ae_rule_rec.def_tax_acctd_amt/g_ae_rule_rec.tax_acctd_amt,
3937: g_ae_sys_rec.base_currency);
3938: END IF; --accounted amt not zero
3939:

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

4006: | Process line amounts |
4007: +------------------------------------------------------------------------------*/
4008: IF l_process_rev THEN
4009: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) :=
4010: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt * g_ae_rule_rec.line_amt_alloc,
4011: g_cust_inv_rec.invoice_currency_code) - l_rev_run_pro_amt_tot;
4012:
4013: IF PG_DEBUG in ('Y', 'C') THEN
4014: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_amt = '||

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

4026: | Process Freight and charges |
4027: +------------------------------------------------------------------------------*/
4028: IF l_process_frt THEN
4029: g_ae_alloc_rev_tax_tbl.ae_pro_frt_chrg_amt(i) :=
4030: arpcurr.CurrRound(l_rev_run_amt_tot / g_ae_rule_rec.revenue_amt *
4031: (g_ae_rule_rec.freight_amt_alloc + g_ae_rule_rec.charges_amt_alloc),
4032: g_cust_inv_rec.invoice_currency_code) - l_frt_run_pro_amt_tot;
4033:
4034: IF PG_DEBUG in ('Y', 'C') THEN

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

4054: | Process Line accounted amounts |
4055: +------------------------------------------------------------------------------*/
4056: IF l_process_rev THEN
4057: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) :=
4058: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt
4059: * g_ae_rule_rec.line_acctd_amt_alloc, g_ae_sys_rec.base_currency)
4060: - l_rev_run_pro_acctd_amt_tot;
4061:
4062: IF PG_DEBUG in ('Y', 'C') THEN

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

4074: | Process Freight and charges |
4075: +------------------------------------------------------------------------------*/
4076: IF l_process_frt THEN
4077: g_ae_alloc_rev_tax_tbl.ae_pro_frt_chrg_acctd_amt(i) :=
4078: arpcurr.CurrRound(l_rev_run_acctd_amt_tot / g_ae_rule_rec.revenue_acctd_amt
4079: * (g_ae_rule_rec.freight_acctd_amt_alloc + g_ae_rule_rec.charges_acctd_amt_alloc),
4080: g_ae_sys_rec.base_currency) - l_frt_run_pro_acctd_amt_tot;
4081:
4082: IF PG_DEBUG in ('Y', 'C') THEN

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

4122: | Line ..... |
4123: +------------------------------------------------------------------------------*/
4124:
4125: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) :=
4126: arpcurr.CurrRound(l_tax_run_amt_tot / g_ae_rule_rec.tax_amt * g_ae_rule_rec.tax_amt_alloc,
4127: g_cust_inv_rec.invoice_currency_code) - l_tax_run_pro_amt_tot;
4128:
4129: IF PG_DEBUG in ('Y', 'C') THEN
4130: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_amt = '||

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

4142: /*------------------------------------------------------------------------------+
4143: | Calculate accounted amount for tax amount allocated to each tax line |
4144: +------------------------------------------------------------------------------*/
4145: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) :=
4146: arpcurr.CurrRound(l_tax_run_acctd_amt_tot / g_ae_rule_rec.tax_acctd_amt
4147: * g_ae_rule_rec.tax_acctd_amt_alloc, g_ae_sys_rec.base_currency)
4148: - l_tax_run_pro_acctd_amt_tot;
4149:
4150: IF PG_DEBUG in ('Y', 'C') THEN

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

4168:
4169: IF g_ae_alloc_rev_tax_tbl.ae_amount(i) <> 0 THEN
4170:
4171: g_ae_alloc_rev_tax_tbl.ae_pro_taxable_amt(i) :=
4172: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_amount(i) *
4173: g_ae_alloc_rev_tax_tbl.ae_pro_amt(i) / g_ae_alloc_rev_tax_tbl.ae_amount(i),
4174: g_cust_inv_rec.invoice_currency_code);
4175:
4176: IF PG_DEBUG in ('Y', 'C') THEN

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

4185: +------------------------------------------------------------------------------*/
4186: IF g_ae_alloc_rev_tax_tbl.ae_acctd_amount(i) <> 0 THEN
4187:
4188: g_ae_alloc_rev_tax_tbl.ae_pro_taxable_acctd_amt(i) :=
4189: arpcurr.CurrRound(g_ae_alloc_rev_tax_tbl.ae_taxable_acctd_amount(i) *
4190: g_ae_alloc_rev_tax_tbl.ae_pro_acctd_amt(i) / g_ae_alloc_rev_tax_tbl.ae_acctd_amount(i),
4191: g_ae_sys_rec.base_currency);
4192:
4193: IF PG_DEBUG in ('Y', 'C') THEN

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

4219: +---------------------------------------------------------------------------------*/
4220: IF g_ae_rule_rec.def_tax_amt <> 0 THEN
4221:
4222: g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_amt(i) :=
4223: arpcurr.CurrRound(l_def_tax_run_amt_tot / g_ae_rule_rec.def_tax_amt * l_tax_applied,
4224: g_cust_inv_rec.invoice_currency_code) - l_pro_def_tax_run_amt;
4225:
4226: IF PG_DEBUG in ('Y', 'C') THEN
4227: arp_standard.debug('Alloc_Rev_Tax_Amt: ' || 'g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_amt = '||

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

4241: +------------------------------------------------------------------------------*/
4242: IF g_ae_rule_rec.def_tax_acctd_amt <> 0 THEN
4243:
4244: g_ae_alloc_rev_tax_tbl.ae_pro_def_tax_acctd_amt(i) :=
4245: arpcurr.CurrRound(l_def_tax_run_acctd_amt_tot / g_ae_rule_rec.def_tax_acctd_amt
4246: * l_tax_acctd_applied, g_ae_sys_rec.base_currency)
4247: - l_pro_def_tax_run_acctd_amt;
4248:
4249: IF PG_DEBUG in ('Y', 'C') THEN

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

4948: +------------------------------------------------------------------------------*/
4949: l_rev_run_amt_tot := l_rev_run_amt_tot + l_weight_amt;
4950: l_rev_run_acctd_amt_tot := l_rev_run_acctd_amt_tot + l_weight_acctd_amt;
4951:
4952: l_tax_amt_pro_rev := arpcurr.CurrRound(l_rev_run_amt_tot / l_base_amt
4953: * g_ae_alloc_tax_tbl.ae_pro_amt,
4954: g_cust_inv_rec.invoice_currency_code) - l_rev_run_pro_amt_tot ;
4955:
4956: IF PG_DEBUG in ('Y', 'C') THEN

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

4964:
4965: /*------------------------------------------------------------------------------+
4966: | Calculate accounted amount for revenue amount allocated to each revenue line |
4967: +------------------------------------------------------------------------------*/
4968: l_tax_acctd_amt_pro_rev := arpcurr.CurrRound(l_rev_run_acctd_amt_tot /
4969: l_base_acctd_amt
4970: * g_ae_alloc_tax_tbl.ae_pro_acctd_amt,
4971: g_ae_sys_rec.base_currency) - l_rev_run_pro_acctd_amt_tot ;
4972: IF PG_DEBUG in ('Y', 'C') THEN