DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on ARPCURR

Line 1530: ARPCURR.functional_amount(

1526: END IF;
1527: /* Bug 2143925 - get the line amount in SOB currency */
1528: l_line_amount_acctd :=
1529: /* Bug 4675438: MOAC/SSA */
1530: ARPCURR.functional_amount(
1531: amount => l_line_amount
1532: , currency_code => arp_global.functional_currency
1533: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1534: , precision => NULL

Line 1719: ARPCURR.functional_amount(

1715: / l_revenue_percent_split, AR_RAAPI_UTIL.g_trx_precision);
1716: /* Bug 2143925 - get the pro rata amount in SOB currency */
1717: /* Bug 4675438: MOAC/SSA */
1718: l_amount_prorata_acctd :=
1719: ARPCURR.functional_amount(
1720: amount => l_amount_prorata
1721: , currency_code => arp_global.functional_currency
1722: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1723: , precision => NULL

Line 2618: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);

2614: calculate the correct overall revenue amount to be debited */
2615: /* Bug 4675438: MOAC/SSA */
2616: IF l_assignment_total = 0
2617: THEN
2618: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE

Line 2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);

2615: /* Bug 4675438: MOAC/SSA */
2616: IF l_assignment_total = 0
2617: THEN
2618: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

Line 2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);

2616: IF l_assignment_total = 0
2617: THEN
2618: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

Line 2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);

2617: THEN
2618: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);

Line 2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

2619: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2626: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2627: END IF;

Line 2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

2620: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2626: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2627: END IF;
2628:

Line 2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);

2621: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2626: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2627: END IF;
2628:
2629: IF l_ext_amount = 0

Line 2626: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);

2622: ELSE
2623: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2624: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2625: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2626: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2627: END IF;
2628:
2629: IF l_ext_amount = 0
2630: THEN

Line 3365: l_dist_amount := arpcurr.currround(

3361: /* Bug 2555736 - use derived salesrep percent */
3362: /* Bug 4675438: MOAC/SSA */
3363: IF l_assignment_total = 0
3364: THEN
3365: l_dist_amount := arpcurr.currround(
3366: p_revenue_amount * l_salesrep_percent
3367: / 100 / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
3368: ELSE
3369: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

Line 3369: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

3365: l_dist_amount := arpcurr.currround(
3366: p_revenue_amount * l_salesrep_percent
3367: / 100 / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
3368: ELSE
3369: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
3370: END IF;
3371: l_dist_tot := l_dist_tot + l_dist_amount;
3372: IF l_salesrep_count = l_no_of_salesreps AND
3373: l_assignment_count = l_no_of_assignments AND

Line 3413: ARPCURR.functional_amount(

3409: END IF;
3410:
3411: /* Bug 4675438: MOAC/SSA */
3412: l_dist_acctd_amount :=
3413: ARPCURR.functional_amount(
3414: amount => l_dist_amount
3415: , currency_code => arp_global.functional_currency
3416: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3417: , precision => NULL

Line 3650: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 , AR_RAAPI_UTIL.g_trx_currency);

3646: l_salesrep_percent := c1.revenue_percent_split;
3647: END IF;
3648:
3649: /* Bug 4675438: MOAC/SSA */
3650: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 , AR_RAAPI_UTIL.g_trx_currency);
3651: l_dist_tot := l_dist_tot + l_dist_amount;
3652: l_salesrep_count := l_salesrep_count + 1;
3653: IF l_salesrep_count = l_no_of_salesreps AND
3654: l_dist_tot <> p_revenue_amount

Line 3685: ARPCURR.functional_amount(

3681: END IF;
3682:
3683: /* Bug 4675438: MOAC/SSA */
3684: l_dist_acctd_amount :=
3685: ARPCURR.functional_amount(
3686: amount => l_dist_amount
3687: , currency_code => arp_global.functional_currency
3688: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3689: , precision => NULL

Line 3936: l_dist_amount := arpcurr.currround(p_revenue_amount ,AR_RAAPI_UTIL.g_trx_currency);

3932: FOR gld in c_dist LOOP
3933:
3934: /* set amounts for adjustment */ /* bug 5644810 added IF condition */
3935: IF gld.code_combination_id IS NULL THEN
3936: l_dist_amount := arpcurr.currround(p_revenue_amount ,AR_RAAPI_UTIL.g_trx_currency);
3937: ELSE
3938: l_dist_amount := arpcurr.currround(p_revenue_amount * gld.percent / 100,
3939: AR_RAAPI_UTIL.g_trx_currency);
3940: END IF;

Line 3938: l_dist_amount := arpcurr.currround(p_revenue_amount * gld.percent / 100,

3934: /* set amounts for adjustment */ /* bug 5644810 added IF condition */
3935: IF gld.code_combination_id IS NULL THEN
3936: l_dist_amount := arpcurr.currround(p_revenue_amount ,AR_RAAPI_UTIL.g_trx_currency);
3937: ELSE
3938: l_dist_amount := arpcurr.currround(p_revenue_amount * gld.percent / 100,
3939: AR_RAAPI_UTIL.g_trx_currency);
3940: END IF;
3941:
3942: IF gld.extended_amount = 0

Line 3957: ARPCURR.functional_amount(

3953: l_dist_percent := l_dist_percent * -1;
3954: END IF;
3955:
3956: l_dist_acctd_amount :=
3957: ARPCURR.functional_amount(
3958: amount => l_dist_amount
3959: , currency_code => arp_global.functional_currency
3960: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3961: , precision => NULL

Line 5029: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.revenue_percent_split / 100 , AR_RAAPI_UTIL.g_trx_currency);

5025: CLOSE c_line;
5026:
5027: FOR c1 in c_salesrep LOOP
5028:
5029: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.revenue_percent_split / 100 , AR_RAAPI_UTIL.g_trx_currency);
5030: l_dist_tot := l_dist_tot + l_dist_amount;
5031: l_salesrep_count := l_salesrep_count + 1;
5032: IF l_salesrep_count = l_no_of_salesreps AND
5033: l_dist_tot <> p_revenue_amount

Line 5051: ARPCURR.functional_amount(

5047: l_dist_percent := ROUND ((100 / l_no_of_salesreps), 4)
5048: * SIGN(l_dist_percent);
5049: END IF;
5050: l_dist_acctd_amount :=
5051: ARPCURR.functional_amount(
5052: amount => l_dist_amount
5053: , currency_code => arp_global.functional_currency
5054: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
5055: , precision => NULL