APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_UTILITIES_PKG

Line 755: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(

751: ELSE
752: l_inv_qty := l_qty_invoiced;
753: END IF;
754:
755: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(
756: (( l_inv_rate - l_po_rate) * l_inv_qty
757: * l_po_price),
758: p_base_currency_code);
759:

Line 762: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(

758: p_base_currency_code);
759:
760: ELSE -- Amount Based Matching
761:
762: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(
763: (( l_inv_rate - l_po_rate) * l_amount),
764: p_base_currency_code);
765:
766: END IF; -- End l_matching_basis. /* Amount Based Matching */

Line 1745: SET quantity_variance = ap_utilities_pkg.ap_round_currency

1741: l_qv_ratio := l_qv_upd/l_amount_upd;
1742: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1743:
1744: UPDATE ap_invoice_distributions_all aid
1745: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1746: (aid.amount * l_qv_ratio, p_inv_currency_code)
1747: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1748: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)
1749: WHERE invoice_id = p_invoice_id

Line 1747: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency

1743:
1744: UPDATE ap_invoice_distributions_all aid
1745: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1746: (aid.amount * l_qv_ratio, p_inv_currency_code)
1747: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1748: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)
1749: WHERE invoice_id = p_invoice_id
1750: AND charge_applicable_to_dist_id = l_inv_dist_id_upd
1751: AND line_type_lookup_code IN ('NONREC_TAX', 'TRV', 'TIPV');

Line 2001: SET amount_variance = ap_utilities_pkg.ap_round_currency

1997: l_av_ratio := l_av_upd/l_amount_upd;
1998: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1999:
2000: UPDATE ap_invoice_distributions_all aid
2001: SET amount_variance = ap_utilities_pkg.ap_round_currency
2002: (aid.amount * l_av_ratio, p_inv_currency_code)
2003: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
2004: (aid.base_amount * l_base_av_ratio, p_base_currency_code)
2005: WHERE invoice_id = p_invoice_id

Line 2003: ,base_amount_variance = ap_utilities_pkg.ap_round_currency

1999:
2000: UPDATE ap_invoice_distributions_all aid
2001: SET amount_variance = ap_utilities_pkg.ap_round_currency
2002: (aid.amount * l_av_ratio, p_inv_currency_code)
2003: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
2004: (aid.base_amount * l_base_av_ratio, p_base_currency_code)
2005: WHERE invoice_id = p_invoice_id
2006: AND charge_applicable_to_dist_id = l_inv_dist_id_upd
2007: AND line_type_lookup_code IN ('NONREC_TAX', 'TRV', 'TIPV');

Line 4972: /* l_total_price_variance := nvl(ap_utilities_pkg.ap_round_currency(

4968: END IF;
4969:
4970: IF (l_sum_qty_invoiced > 0) THEN
4971: /* Start of fix for bug8474680 */
4972: /* l_total_price_variance := nvl(ap_utilities_pkg.ap_round_currency(
4973: l_avg_price -
4974: (p_price_tolerance * p_po_unit_price),
4975: p_invoice_currency_code), 0); */
4976: l_total_price_variance := nvl(l_avg_price -

Line 5967: l_ship_trx_base_amt := AP_UTILITIES_PKG.Ap_Round_Currency(

5963: p_base_curr_code,
5964: l_ship_trx_base_amt,
5965: l_curr_calling_sequence);
5966:
5967: l_ship_trx_base_amt := AP_UTILITIES_PKG.Ap_Round_Currency(
5968: l_ship_trx_base_amt,
5969: p_base_curr_code);
5970:
5971:

Line 6026: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency( p_ship_base_amt_var -l_po_total,p_base_curr_code);

6022: AND L.invoice_id = I.invoice_id --Bug6824860
6023: AND L.line_number = D.invoice_line_number --Bug6824860
6024: AND L.match_type not in ('NOT MATCHED','NOT_MATCHED'); --Bug6824860
6025:
6026: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency( p_ship_base_amt_var -l_po_total,p_base_curr_code);
6027: /*Bug:14726598 Start*/
6028: ELSE /* Bug: 14726598:Following code is added to fetch PO Base Amount for reciept matched invoices based on exchange rate of reciepts for quantity type po match */
6029: SELECT SUM((NVL(RT.quantity, 0)) * p_po_price* DECODE(p_inv_curr_code, p_base_curr_code,1,RT.currency_conversion_rate))
6030: INTO rcv_total

Line 6047: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(p_ship_base_amt_var - rcv_total,p_base_curr_code);

6043: AND L.invoice_id = I.invoice_id --Bug6824860
6044: AND L.line_number = D.invoice_line_number --Bug6824860
6045: AND L.match_type not in ('NOT MATCHED','NOT_MATCHED');
6046:
6047: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(p_ship_base_amt_var - rcv_total,p_base_curr_code);
6048: /*Bug:14726598 End*/
6049: END IF;
6050: ELSE
6051: --match_basis ='AMOUNT'--

Line 6084: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency( p_ship_base_amt_var -l_po_total,p_base_curr_code);

6080: AND L.invoice_id = I.invoice_id --Bug6824860
6081: AND L.line_number = D.invoice_line_number --Bug6824860
6082: AND L.match_type not in ('NOT MATCHED','NOT_MATCHED'); --Bug6824860
6083:
6084: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency( p_ship_base_amt_var -l_po_total,p_base_curr_code);
6085: /*Bug:14726598 Start*/
6086: ELSE /* Bug: 14726598:Following code is added to fetch PO Base Amount for reciept matched invoices based on exchange rate of reciepts for amount type po match */
6087: SELECT SUM((NVL(RT.amount, 0)) * DECODE(p_inv_curr_code, p_base_curr_code,1,RT.currency_conversion_rate))
6088: INTO rcv_total

Line 6105: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(p_ship_base_amt_var - rcv_total,p_base_curr_code);

6101: AND L.invoice_id = I.invoice_id --Bug6824860
6102: AND L.line_number = D.invoice_line_number --Bug6824860
6103: AND L.match_type not in ('NOT MATCHED','NOT_MATCHED');
6104:
6105: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(p_ship_base_amt_var - rcv_total,p_base_curr_code);
6106:
6107: END IF;
6108: /*Bug:14726598 End*/
6109: