DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_UTILITIES_PKG

Line 571: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(

567: ELSE
568: l_inv_qty := l_qty_invoiced;
569: END IF;
570:
571: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(
572: (( l_inv_rate - l_po_rate) * l_inv_qty
573: * l_po_price),
574: p_base_currency_code);
575:

Line 578: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(

574: p_base_currency_code);
575:
576: ELSE -- Amount Based Matching
577:
578: l_po_erv := AP_UTILITIES_PKG.ap_round_currency(
579: (( l_inv_rate - l_po_rate) * l_amount),
580: p_base_currency_code);
581:
582: END IF; -- End l_matching_basis. /* Amount Based Matching */

Line 1517: SET quantity_variance = ap_utilities_pkg.ap_round_currency

1513: l_qv_ratio := l_qv_upd/l_amount_upd;
1514: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1515:
1516: UPDATE ap_invoice_distributions_all aid
1517: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1518: (aid.amount * l_qv_ratio, p_inv_currency_code)
1519: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1520: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)
1521: WHERE invoice_id = p_invoice_id

Line 1519: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency

1515:
1516: UPDATE ap_invoice_distributions_all aid
1517: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1518: (aid.amount * l_qv_ratio, p_inv_currency_code)
1519: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1520: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)
1521: WHERE invoice_id = p_invoice_id
1522: AND charge_applicable_to_dist_id = l_inv_dist_id_upd
1523: AND line_type_lookup_code IN ('NONREC_TAX', 'TRV', 'TIPV');

Line 1773: SET amount_variance = ap_utilities_pkg.ap_round_currency

1769: l_av_ratio := l_av_upd/l_amount_upd;
1770: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1771:
1772: UPDATE ap_invoice_distributions_all aid
1773: SET amount_variance = ap_utilities_pkg.ap_round_currency
1774: (aid.amount * l_av_ratio, p_inv_currency_code)
1775: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
1776: (aid.base_amount * l_base_av_ratio, p_base_currency_code)
1777: WHERE invoice_id = p_invoice_id

Line 1775: ,base_amount_variance = ap_utilities_pkg.ap_round_currency

1771:
1772: UPDATE ap_invoice_distributions_all aid
1773: SET amount_variance = ap_utilities_pkg.ap_round_currency
1774: (aid.amount * l_av_ratio, p_inv_currency_code)
1775: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
1776: (aid.base_amount * l_base_av_ratio, p_base_currency_code)
1777: WHERE invoice_id = p_invoice_id
1778: AND charge_applicable_to_dist_id = l_inv_dist_id_upd
1779: AND line_type_lookup_code IN ('NONREC_TAX', 'TRV', 'TIPV');

Line 4554: l_total_price_variance := nvl(ap_utilities_pkg.ap_round_currency(

4550: p_price_error_exists := 'Y';
4551: END IF;
4552:
4553: IF (l_sum_qty_invoiced > 0) THEN
4554: l_total_price_variance := nvl(ap_utilities_pkg.ap_round_currency(
4555: l_avg_price -
4556: (p_price_tolerance * p_po_unit_price),
4557: p_invoice_currency_code), 0);
4558: ELSE

Line 5542: l_ship_trx_base_amt := AP_UTILITIES_PKG.Ap_Round_Currency(

5538: p_base_curr_code,
5539: l_ship_trx_base_amt,
5540: l_curr_calling_sequence);
5541:
5542: l_ship_trx_base_amt := AP_UTILITIES_PKG.Ap_Round_Currency(
5543: l_ship_trx_base_amt,
5544: p_base_curr_code);
5545:
5546:

Line 5613: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(

5609: AND L.invoice_id = I.invoice_id --Bug6824860
5610: AND L.line_number = D.invoice_line_number --Bug6824860
5611: AND L.match_type not in ('NOT MATCHED','NOT_MATCHED'); --Bug6824860
5612:
5613: p_ship_base_amt_var := AP_UTILITIES_PKG.Ap_Round_Currency(
5614: p_ship_base_amt_var - l_po_total,
5615: p_base_curr_code);
5616:
5617: END IF;