DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_UTILITIES_PKG

Line 1977: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity*l_match_unit_price,

1973: l_match_quantity := l_total_match_quantity;
1974:
1975: END IF;
1976:
1977: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity*l_match_unit_price,
1978: l_invoice_currency_code);
1979:
1980: l_total_match_quantity := l_total_match_quantity - l_match_quantity;
1981: l_total_match_amount := l_total_match_amount - l_match_amount;

Line 2119: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2115: IF ((l_ordered_qty - l_cancelled_qty - l_billed_qty) > 0) THEN
2116:
2117: IF (l_total_match_quantity >= (l_ordered_qty - l_cancelled_qty - l_billed_qty)) THEN
2118: l_match_quantity := l_ordered_qty - l_cancelled_qty - l_billed_qty;
2119: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2120: ELSE
2121: l_match_quantity := l_total_match_quantity;
2122: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2123: END IF;

Line 2122: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2118: l_match_quantity := l_ordered_qty - l_cancelled_qty - l_billed_qty;
2119: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2120: ELSE
2121: l_match_quantity := l_total_match_quantity;
2122: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2123: END IF;
2124:
2125: /* For overbill cases, for positive invoices we go off of ordered qty*/
2126: ELSE

Line 2130: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2126: ELSE
2127:
2128: IF (l_total_match_quantity >= l_ordered_qty - l_cancelled_qty) THEN
2129: l_match_quantity := l_ordered_qty - l_cancelled_qty;
2130: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2131: ELSE
2132: l_match_quantity := l_total_match_quantity;
2133: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2134: END IF;

Line 2133: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2129: l_match_quantity := l_ordered_qty - l_cancelled_qty;
2130: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2131: ELSE
2132: l_match_quantity := l_total_match_quantity;
2133: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2134: END IF;
2135:
2136: END IF;
2137:

Line 2142: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2138: ELSE /*For Credit/Debit memos */
2139:
2140: IF (l_total_match_quantity >= l_billed_qty) THEN
2141: l_match_quantity := -1*l_billed_qty;
2142: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2143: ELSE
2144: l_match_quantity := l_total_match_quantity;
2145: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2146: END IF;

Line 2145: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);

2141: l_match_quantity := -1*l_billed_qty;
2142: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2143: ELSE
2144: l_match_quantity := l_total_match_quantity;
2145: l_match_amount := ap_utilities_pkg.ap_round_currency(l_match_quantity * l_match_unit_price,l_invoice_currency_code);
2146: END IF;
2147:
2148: END IF;
2149:

Line 2503: ap_utilities_pkg.ap_round_currency(

2499: L_FULL_AMT NUMBER;
2500:
2501: BEGIN
2502: SELECT
2503: ap_utilities_pkg.ap_round_currency(
2504: NVL(DECODE(MATCHING_BASIS,
2505: 'QUANTITY',
2506: (QUANTITY - NVL(QUANTITY_CANCELLED,0))*PRICE_OVERRIDE,
2507: (AMOUNT - NVL(AMOUNT_CANCELLED,0))),0),