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 5522: /* Bug3658284 arpcurr.CurrRound( */

5518: inv_ctl.revenue_amount, -- 6882394 (original)
5519: decode(inv_ctl.line_type,
5520: 'TAX', '',
5521: 'FREIGHT', '',
5522: /* Bug3658284 arpcurr.CurrRound( */
5523: /* Bug-3335466 - Replace the zero amount with 1 */
5524: ( decode(nra.net_amount,0,1,nra.net_amount) /
5525: decode(p_uncredited_amount,
5526: 0, 1,

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

5538: 1
5539: )
5540: ), /* quantity */
5541: inv_ctl.quantity_invoiced, -- Bug 6990227
5542: /* Bug3658284 arpcurr.CurrRound( */
5543: ( nra.net_amount /
5544: decode(p_uncredited_amount,
5545: 0, 1,
5546: p_uncredited_amount

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

5553: , /* extended_amount */
5554: decode(inv_ctl.line_type,
5555: 'TAX', '',
5556: 'FREIGHT', '',
5557: /* Bug3658284 arpcurr.CurrRound( */
5558: ( nra.net_amount /
5559: decode(p_uncredited_amount,
5560: 0, 1,
5561: p_uncredited_amount

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

5728: | Line 2 -> 20 * 10/100 = 2 (rounded amount) |
5729: | -> 2 - Line 1 (rounded amount) -> 2 - 1 -> 1 |
5730: | Line ... |
5731: +-------------------------------------------------------------------------------+ */
5732: l_trx_line_array.extended_amount(i) := arpcurr.CurrRound(l_amt_run_total
5733: ,p_currency_code) -Nvl(l_amt_prev_run_total,0);
5734: /*------------------------------------------------------------------------------+
5735: | Running total for previous line amount - Revenue in currency |
5736: +------------------------------------------------------------------------------*/

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

5740: If l_trx_line_array.line_type(i) = 'LINE' then
5741:
5742: l_rev_run_total := Nvl(l_rev_run_total,0)
5743: + l_trx_line_array.revenue_amount(i);
5744: l_trx_line_array.revenue_amount(i) := arpcurr.CurrRound(l_rev_run_total
5745: ,p_currency_code) -Nvl(l_rev_prev_run_total,0);
5746: l_rev_prev_run_total := Nvl(l_rev_prev_run_total,0)
5747: + l_trx_line_array.revenue_amount(i);
5748:

Line 5766: arpcurr.currround(

5762: l_trx_line_array.revenue_amount(i));
5763: END IF;
5764:
5765: l_trx_line_array.extended_amount(i) :=
5766: arpcurr.currround(
5767: l_trx_line_array.gross_extended_amount(i) *
5768: (l_trx_line_array.extended_amount(i) /
5769: l_trx_line_array.original_extended_amount(i)), p_currency_code);
5770:

Line 5772: arpcurr.currround(

5768: (l_trx_line_array.extended_amount(i) /
5769: l_trx_line_array.original_extended_amount(i)), p_currency_code);
5770:
5771: l_trx_line_array.revenue_amount(i) :=
5772: arpcurr.currround(
5773: l_trx_line_array.gross_extended_amount(i) *
5774: (l_trx_line_array.revenue_amount(i) /
5775: l_trx_line_array.original_revenue_amount(i)), p_currency_code);
5776:

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

6115: 'Extended Amount :'|| SQL%ROWCOUNT||' rows updated');
6116: END IF;
6117:
6118: UPDATE ra_customer_trx_lines ctl
6119: SET extended_amount = arpcurr.CurrRound (extended_amount,
6120: p_currency_code)
6121: WHERE ctl.customer_trx_id = p_customer_trx_id
6122: AND ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
6123: AND ctl.line_type = p_line_type