DBA Data[Home] [Help]

APPS.AP_APXINHIS_XMLP_PKG dependencies on AP_UTILITIES_PKG

Line 236: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT

232: FUNCTION C_PREPAY_AMT_FFORMULA(C_INVOICE_ID1 IN NUMBER) RETURN NUMBER IS
233: PREPAY_AMT_F NUMBER;
234: BEGIN
235: SELECT
236: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT
237: ,0) * I2.PAYMENT_CROSS_RATE
238: ,I2.PAYMENT_CURRENCY_CODE)
239: ,0))
240: INTO

Line 259: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT

255: FUNCTION T_PREPAY_AMT_FFORMULA(T_INVOICE_ID IN NUMBER) RETURN NUMBER IS
256: T_PREPAY_AMT_F NUMBER;
257: BEGIN
258: SELECT
259: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT
260: ,0) * I2.PAYMENT_CROSS_RATE
261: ,I2.PAYMENT_CURRENCY_CODE)
262: ,0))
263: INTO

Line 282: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT

278: FUNCTION T_PREPAY_AMT_F1FORMULA(T_INVOICE_ID1 IN NUMBER) RETURN NUMBER IS
279: T1_PREPAY_AMT_F NUMBER;
280: BEGIN
281: SELECT
282: SUM(NVL(AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(AID1.AMOUNT
283: ,0) * I2.PAYMENT_CROSS_RATE
284: ,I2.PAYMENT_CURRENCY_CODE)
285: ,0))
286: INTO