APPS.ARP_PROCESS_LOCKBOX dependencies on ARPCURR

Line 2861: SET amount_applied = ARPCURR.CurrRound( allocated_receipt_amount/l_trans_to_receipt_rate,

2857: AND invoice_number = l_invoice_number
2858: AND transmission_request_id = p_trans_req_id ;
2859:
2860: UPDATE ar_pmts_interface_line_details
2861: SET amount_applied = ARPCURR.CurrRound( allocated_receipt_amount/l_trans_to_receipt_rate,
2862: l_currency_code),
2863: line_amount = NULL,
2864: tax = NULL
2865: WHERE allocated_receipt_amount IS NOT NULL

Line 2917: l_calc_tot_amount_app := ARPCURR.CurrRound(

2913: IF PG_DEBUG in ('Y', 'C') THEN
2914: arp_util.debug('First priority : Line Amount ');
2915: arp_util.debug('Line Amount has taken precedence over the amount applied ');
2916: END IF;
2917: l_calc_tot_amount_app := ARPCURR.CurrRound(
2918: ( cur_var2.line_amount
2919: / l_calc_per_line
2920: )
2921: ,l_inv_currency_code);

Line 2922: l_calc_line_amount := ARPCURR.CurrRound(cur_var2.line_amount

2918: ( cur_var2.line_amount
2919: / l_calc_per_line
2920: )
2921: ,l_inv_currency_code);
2922: l_calc_line_amount := ARPCURR.CurrRound(cur_var2.line_amount
2923: ,l_inv_currency_code);
2924:
2925: -- Calculate Line amount based on the Amount Applied.
2926: Elsif cur_var2.amount_applied IS NOT NULL

Line 2932: l_calc_tot_amount_app := ARPCURR.CurrRound(cur_var2.amount_applied

2928: IF PG_DEBUG in ('Y', 'C') THEN
2929: arp_util.debug('Considered the Amount Applied value ');
2930: End If;
2931:
2932: l_calc_tot_amount_app := ARPCURR.CurrRound(cur_var2.amount_applied
2933: ,l_inv_currency_code);
2934: l_calc_line_amount := ARPCURR.CurrRound((l_calc_tot_amount_app
2935: * l_calc_per_line),l_inv_currency_code);
2936: End If;

Line 2934: l_calc_line_amount := ARPCURR.CurrRound((l_calc_tot_amount_app

2930: End If;
2931:
2932: l_calc_tot_amount_app := ARPCURR.CurrRound(cur_var2.amount_applied
2933: ,l_inv_currency_code);
2934: l_calc_line_amount := ARPCURR.CurrRound((l_calc_tot_amount_app
2935: * l_calc_per_line),l_inv_currency_code);
2936: End If;
2937:
2938: IF PG_DEBUG in ('Y', 'C') THEN

Line 2949: l_calc_tax_amount := ARPCURR.CurrRound(cur_var2.tax

2945: THEN
2946: IF PG_DEBUG in ('Y', 'C') THEN
2947: arp_util.debug('Tax Amount has taken precedence over the amount applied ');
2948: End If;
2949: l_calc_tax_amount := ARPCURR.CurrRound(cur_var2.tax
2950: ,l_inv_currency_code);
2951:
2952: l_calc_tot_amount_app := l_calc_line_amount +
2953: l_calc_tax_amount;

Line 2959: l_calc_tax_amount := ARPCURR.CurrRound((Nvl(l_calc_tot_amount_app,0)

2955: IF PG_DEBUG in ('Y', 'C') THEN
2956: arp_util.debug('Amount Applied has taken precedence over the Tax Amount');
2957: End If;
2958: -- Amount applied has taken precedence over the tax amount
2959: l_calc_tax_amount := ARPCURR.CurrRound((Nvl(l_calc_tot_amount_app,0)
2960: - Nvl(l_calc_line_amount,0))
2961: ,l_inv_currency_code);
2962: End If;
2963:

Line 2978: = ARPCURR.CurrRound( amount_applied * l_trans_to_receipt_rate,

2974:
2975: IF l_inv_currency_code <> l_currency_code THEN
2976: UPDATE ar_pmts_interface_line_details line_details
2977: SET allocated_receipt_amount
2978: = ARPCURR.CurrRound( amount_applied * l_trans_to_receipt_rate,
2979: l_inv_currency_code)
2980: WHERE amount_applied IS NOT NULL
2981: AND allocated_receipt_amount IS NULL
2982: AND transmission_request_id = p_trans_req_id

Line 3610: prorated_frgt_chrg_amt := ARPCURR.CurrRound(

3606: remaining_frgt_chrg_amt_frm := nvl(det_line.allocated_receipt_amount, 0);
3607:
3608: FOR line IN frgt_chrg_prorate(p_customer_trx_id, det_line.apply_to) LOOP
3609:
3610: prorated_frgt_chrg_amt := ARPCURR.CurrRound(
3611: remaining_frgt_chrg_amt*
3612: (line.amount_due_remaining/tot_frgt_chrg_amt),
3613: l_inv_currency_code);
3614:

Line 3616: prorated_frgt_chrg_amt_frm := ARPCURR.CurrRound(

3612: (line.amount_due_remaining/tot_frgt_chrg_amt),
3613: l_inv_currency_code);
3614:
3615: IF l_currency_code <> l_inv_currency_code THEN
3616: prorated_frgt_chrg_amt_frm := ARPCURR.CurrRound(
3617: remaining_frgt_chrg_amt_frm*
3618: (line.amount_due_remaining/tot_frgt_chrg_amt),
3619: l_currency_code);
3620: END IF;