APPS.ARP_PROCESS_LOCKBOX dependencies on ARPCURR

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

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

Line 2907: l_calc_tot_amount_app := ARPCURR.CurrRound(

2903: IF PG_DEBUG in ('Y', 'C') THEN
2904: arp_util.debug('First priority : Line Amount ');
2905: arp_util.debug('Line Amount has taken precedence over the amount applied ');
2906: END IF;
2907: l_calc_tot_amount_app := ARPCURR.CurrRound(
2908: ( cur_var2.line_amount
2909: / l_calc_per_line
2910: )
2911: ,l_inv_currency_code);

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

2908: ( cur_var2.line_amount
2909: / l_calc_per_line
2910: )
2911: ,l_inv_currency_code);
2912: l_calc_line_amount := ARPCURR.CurrRound(cur_var2.line_amount
2913: ,l_inv_currency_code);
2914:
2915: -- Calculate Line amount based on the Amount Applied.
2916: Elsif cur_var2.amount_applied IS NOT NULL

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

2918: IF PG_DEBUG in ('Y', 'C') THEN
2919: arp_util.debug('Considered the Amount Applied value ');
2920: End If;
2921:
2922: l_calc_tot_amount_app := ARPCURR.CurrRound(cur_var2.amount_applied
2923: ,l_inv_currency_code);
2924: l_calc_line_amount := ARPCURR.CurrRound((l_calc_tot_amount_app
2925: * l_calc_per_line),l_inv_currency_code);
2926: End If;

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

2920: End If;
2921:
2922: l_calc_tot_amount_app := ARPCURR.CurrRound(cur_var2.amount_applied
2923: ,l_inv_currency_code);
2924: l_calc_line_amount := ARPCURR.CurrRound((l_calc_tot_amount_app
2925: * l_calc_per_line),l_inv_currency_code);
2926: End If;
2927:
2928: IF PG_DEBUG in ('Y', 'C') THEN

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

2935: THEN
2936: IF PG_DEBUG in ('Y', 'C') THEN
2937: arp_util.debug('Tax Amount has taken precedence over the amount applied ');
2938: End If;
2939: l_calc_tax_amount := ARPCURR.CurrRound(cur_var2.tax
2940: ,l_inv_currency_code);
2941:
2942: l_calc_tot_amount_app := l_calc_line_amount +
2943: l_calc_tax_amount;

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

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

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

2964:
2965: IF l_inv_currency_code <> l_currency_code THEN
2966: UPDATE ar_pmts_interface_line_details line_details
2967: SET allocated_receipt_amount
2968: = ARPCURR.CurrRound( amount_applied * l_trans_to_receipt_rate,
2969: l_inv_currency_code)
2970: WHERE amount_applied IS NOT NULL
2971: AND allocated_receipt_amount IS NULL
2972: AND transmission_request_id = p_trans_req_id

Line 3591: prorated_frgt_chrg_amt := ARPCURR.CurrRound(

3587: remaining_frgt_chrg_amt_frm := nvl(det_line.allocated_receipt_amount, 0);
3588:
3589: FOR line IN frgt_chrg_prorate(p_customer_trx_id, det_line.apply_to) LOOP
3590:
3591: prorated_frgt_chrg_amt := ARPCURR.CurrRound(
3592: remaining_frgt_chrg_amt*
3593: (line.amount_due_remaining/tot_frgt_chrg_amt),
3594: l_inv_currency_code);
3595:

Line 3597: prorated_frgt_chrg_amt_frm := ARPCURR.CurrRound(

3593: (line.amount_due_remaining/tot_frgt_chrg_amt),
3594: l_inv_currency_code);
3595:
3596: IF l_currency_code <> l_inv_currency_code THEN
3597: prorated_frgt_chrg_amt_frm := ARPCURR.CurrRound(
3598: remaining_frgt_chrg_amt_frm*
3599: (line.amount_due_remaining/tot_frgt_chrg_amt),
3600: l_currency_code);
3601: END IF;