DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on ARPCURR

Line 1453: ARPCURR.functional_amount(

1449: END IF;
1450: /* Bug 2143925 - get the line amount in SOB currency */
1451: l_line_amount_acctd :=
1452: /* Bug 4675438: MOAC/SSA */
1453: ARPCURR.functional_amount(
1454: amount => l_line_amount
1455: , currency_code => arp_global.functional_currency
1456: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1457: , precision => NULL

Line 1642: ARPCURR.functional_amount(

1638: / l_revenue_percent_split, AR_RAAPI_UTIL.g_trx_precision);
1639: /* Bug 2143925 - get the pro rata amount in SOB currency */
1640: /* Bug 4675438: MOAC/SSA */
1641: l_amount_prorata_acctd :=
1642: ARPCURR.functional_amount(
1643: amount => l_amount_prorata
1644: , currency_code => arp_global.functional_currency
1645: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1646: , precision => NULL

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

2537: calculate the correct overall revenue amount to be debited */
2538: /* Bug 4675438: MOAC/SSA */
2539: IF l_assignment_total = 0
2540: THEN
2541: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2542: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE

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

2538: /* Bug 4675438: MOAC/SSA */
2539: IF l_assignment_total = 0
2540: THEN
2541: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2542: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

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

2539: IF l_assignment_total = 0
2540: THEN
2541: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2542: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

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

2540: THEN
2541: l_dist_amount := arpcurr.currround(p_revenue_amount / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
2542: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2548: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);

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

2542: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2548: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2549: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2550: END IF;

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

2543: l_correct_gl_date_amt := arpcurr.currround(p_line_amount / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2548: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2549: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2550: END IF;
2551:

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

2544: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd / l_no_of_assignments ,AR_RAAPI_UTIL.g_trx_currency);
2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2548: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2549: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2550: END IF;
2551:
2552: IF l_ext_amount = 0

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

2545: ELSE
2546: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2547: l_dist_acctd_amount := arpcurr.currround(p_revenue_acctd_amount * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
2548: l_correct_gl_date_amt := arpcurr.currround(p_line_amount * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2549: l_correct_gl_date_acctd_amt := arpcurr.currround(p_line_amount_acctd * c1.amount / l_assignment_total ,AR_RAAPI_UTIL.g_trx_currency);
2550: END IF;
2551:
2552: IF l_ext_amount = 0
2553: THEN

Line 3180: l_dist_amount := arpcurr.currround(

3176: /* Bug 2555736 - use derived salesrep percent */
3177: /* Bug 4675438: MOAC/SSA */
3178: IF l_assignment_total = 0
3179: THEN
3180: l_dist_amount := arpcurr.currround(
3181: p_revenue_amount * l_salesrep_percent
3182: / 100 / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
3183: ELSE
3184: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);

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

3180: l_dist_amount := arpcurr.currround(
3181: p_revenue_amount * l_salesrep_percent
3182: / 100 / l_no_of_assignments , AR_RAAPI_UTIL.g_trx_currency);
3183: ELSE
3184: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 * c1.amount / l_assignment_total , AR_RAAPI_UTIL.g_trx_currency);
3185: END IF;
3186: l_dist_tot := l_dist_tot + l_dist_amount;
3187: IF l_salesrep_count = l_no_of_salesreps AND
3188: l_assignment_count = l_no_of_assignments AND

Line 3221: ARPCURR.functional_amount(

3217: END IF;
3218:
3219: /* Bug 4675438: MOAC/SSA */
3220: l_dist_acctd_amount :=
3221: ARPCURR.functional_amount(
3222: amount => l_dist_amount
3223: , currency_code => arp_global.functional_currency
3224: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3225: , precision => NULL

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

3457: l_salesrep_percent := c1.revenue_percent_split;
3458: END IF;
3459:
3460: /* Bug 4675438: MOAC/SSA */
3461: l_dist_amount := arpcurr.currround(p_revenue_amount * l_salesrep_percent / 100 , AR_RAAPI_UTIL.g_trx_currency);
3462: l_dist_tot := l_dist_tot + l_dist_amount;
3463: l_salesrep_count := l_salesrep_count + 1;
3464: IF l_salesrep_count = l_no_of_salesreps AND
3465: l_dist_tot <> p_revenue_amount

Line 3484: ARPCURR.functional_amount(

3480: * SIGN(l_dist_percent);
3481: END IF;
3482: /* Bug 4675438: MOAC/SSA */
3483: l_dist_acctd_amount :=
3484: ARPCURR.functional_amount(
3485: amount => l_dist_amount
3486: , currency_code => arp_global.functional_currency
3487: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3488: , precision => NULL

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

3730: FOR gld in c_dist LOOP
3731:
3732: /* set amounts for adjustment */ /* bug 5644810 added IF condition */
3733: IF gld.code_combination_id IS NULL THEN
3734: l_dist_amount := arpcurr.currround(p_revenue_amount ,AR_RAAPI_UTIL.g_trx_currency);
3735: ELSE
3736: l_dist_amount := arpcurr.currround(p_revenue_amount * gld.percent / 100,
3737: AR_RAAPI_UTIL.g_trx_currency);
3738: END IF;

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

3732: /* set amounts for adjustment */ /* bug 5644810 added IF condition */
3733: IF gld.code_combination_id IS NULL THEN
3734: l_dist_amount := arpcurr.currround(p_revenue_amount ,AR_RAAPI_UTIL.g_trx_currency);
3735: ELSE
3736: l_dist_amount := arpcurr.currround(p_revenue_amount * gld.percent / 100,
3737: AR_RAAPI_UTIL.g_trx_currency);
3738: END IF;
3739: l_dist_percent := ROUND (((l_dist_amount / gld.extended_amount) * 100), 4);
3740:

Line 3742: ARPCURR.functional_amount(

3738: END IF;
3739: l_dist_percent := ROUND (((l_dist_amount / gld.extended_amount) * 100), 4);
3740:
3741: l_dist_acctd_amount :=
3742: ARPCURR.functional_amount(
3743: amount => l_dist_amount
3744: , currency_code => arp_global.functional_currency
3745: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3746: , precision => NULL

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

4800: CLOSE c_line;
4801:
4802: FOR c1 in c_salesrep LOOP
4803:
4804: l_dist_amount := arpcurr.currround(p_revenue_amount * c1.revenue_percent_split / 100 , AR_RAAPI_UTIL.g_trx_currency);
4805: l_dist_tot := l_dist_tot + l_dist_amount;
4806: l_salesrep_count := l_salesrep_count + 1;
4807: IF l_salesrep_count = l_no_of_salesreps AND
4808: l_dist_tot <> p_revenue_amount

Line 4826: ARPCURR.functional_amount(

4822: l_dist_percent := ROUND ((100 / l_no_of_salesreps), 4)
4823: * SIGN(l_dist_percent);
4824: END IF;
4825: l_dist_acctd_amount :=
4826: ARPCURR.functional_amount(
4827: amount => l_dist_amount
4828: , currency_code => arp_global.functional_currency
4829: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
4830: , precision => NULL