DBA Data[Home] [Help]

APPS.ARP_CTL_PKG dependencies on ARPCURR

Line 862: ''LINE'', arpcurr.CurrRound(

858: :extended_amount,
859: :ar_number_dummy, ''Amount unchanged'',
860: null
861: ),
862: ''LINE'', arpcurr.CurrRound(
863: DECODE(extended_amount,
864: 0, :extended_amount,
865: :extended_amount *
866: (

Line 5619: /* Bug3658284 arpcurr.CurrRound( */

5615: inv_ctl.revenue_amount original_revenue_amount, -- 6882394 (original)
5616: decode(inv_ctl.line_type,
5617: 'TAX', '',
5618: 'FREIGHT', '',
5619: /* Bug3658284 arpcurr.CurrRound( */
5620: /* Bug-3335466 - Replace the zero amount with 1 */
5621: ( decode(nra.net_amount,0,1,nra.net_amount) /
5622: decode(p_uncredited_amount,
5623: 0, 1,

Line 5639: /* Bug3658284 arpcurr.CurrRound( */

5635: 1
5636: )
5637: ) quantity_credited, /* quantity */
5638: inv_ctl.quantity_invoiced, -- Bug 6990227
5639: /* Bug3658284 arpcurr.CurrRound( */
5640: ( nra.net_amount /
5641: decode(p_uncredited_amount,
5642: 0, 1,
5643: p_uncredited_amount

Line 5654: /* Bug3658284 arpcurr.CurrRound( */

5650: extended_amount , /* extended_amount */
5651: decode(inv_ctl.line_type,
5652: 'TAX', '',
5653: 'FREIGHT', '',
5654: /* Bug3658284 arpcurr.CurrRound( */
5655: ( nra.net_amount /
5656: decode(p_uncredited_amount,
5657: 0, 1,
5658: p_uncredited_amount

Line 5771: l_trx_line_array.extended_amount(i) := arpcurr.CurrRound(l_amt_run_total

5767: | Line 2 -> 20 * 10/100 = 2 (rounded amount) |
5768: | -> 2 - Line 1 (rounded amount) -> 2 - 1 -> 1 |
5769: | Line ... |
5770: +-------------------------------------------------------------------------------+ */
5771: l_trx_line_array.extended_amount(i) := arpcurr.CurrRound(l_amt_run_total
5772: ,p_currency_code) -Nvl(l_amt_prev_run_total,0);
5773: /*------------------------------------------------------------------------------+
5774: | Running total for previous line amount - Revenue in currency |
5775: +------------------------------------------------------------------------------*/

Line 5783: l_trx_line_array.revenue_amount(i) := arpcurr.CurrRound(l_rev_run_total

5779: If l_trx_line_array.line_type(i) = 'LINE' then
5780:
5781: l_rev_run_total := Nvl(l_rev_run_total,0)
5782: + l_trx_line_array.revenue_amount(i);
5783: l_trx_line_array.revenue_amount(i) := arpcurr.CurrRound(l_rev_run_total
5784: ,p_currency_code) -Nvl(l_rev_prev_run_total,0);
5785: l_rev_prev_run_total := Nvl(l_rev_prev_run_total,0)
5786: + l_trx_line_array.revenue_amount(i);
5787:

Line 5805: arpcurr.currround(

5801: l_trx_line_array.revenue_amount(i));
5802: END IF;
5803:
5804: l_trx_line_array.extended_amount(i) :=
5805: arpcurr.currround(
5806: l_trx_line_array.gross_extended_amount(i) *
5807: (l_trx_line_array.extended_amount(i) /
5808: l_trx_line_array.original_extended_amount(i)), p_currency_code);
5809:

Line 5811: arpcurr.currround(

5807: (l_trx_line_array.extended_amount(i) /
5808: l_trx_line_array.original_extended_amount(i)), p_currency_code);
5809:
5810: l_trx_line_array.revenue_amount(i) :=
5811: arpcurr.currround(
5812: l_trx_line_array.gross_extended_amount(i) *
5813: (l_trx_line_array.revenue_amount(i) /
5814: l_trx_line_array.original_revenue_amount(i)), p_currency_code);
5815:

Line 6196: SET extended_amount = arpcurr.CurrRound (extended_amount,

6192: 'Extended Amount :'|| SQL%ROWCOUNT||' rows updated');
6193: END IF;
6194:
6195: UPDATE ra_customer_trx_lines ctl
6196: SET extended_amount = arpcurr.CurrRound (extended_amount,
6197: p_currency_code)
6198: WHERE ctl.customer_trx_id = p_customer_trx_id
6199: AND ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
6200: AND ctl.line_type = p_line_type;