APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICES

Line 445: SELECT ap_invoices_interface_s.nextval

441: p_invoice_id OUT NOCOPY NUMBER
442: ) RETURN BOOLEAN IS
443: --------------------------------------------------------------------------------
444: BEGIN
445: SELECT ap_invoices_interface_s.nextval
446: INTO p_invoice_id
447: FROM sys.dual;
448:
449: return TRUE;

Line 967: FROM ap_invoices I,

963: decode(sign(earliest_settlement_date - sysdate),1,0,1),
964: 0)),
965: 0)
966: INTO p_available_prepays
967: FROM ap_invoices I,
968: ap_suppliers PV
969: WHERE (select sum(aid.prepay_amount_remaining)
970: from ap_invoice_distributions aid
971: where aid.invoice_id = I.invoice_id

Line 1031: INSERT INTO AP_INVOICES_INTERFACE

1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: l_payment_priority := NULL;
1030: END;
1031: INSERT INTO AP_INVOICES_INTERFACE
1032: (INVOICE_ID,
1033: INVOICE_NUM,
1034: PARTY_ID,
1035: PARTY_SITE_ID,

Line 1200: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F

1196:
1197: SELECT inv.invoice_amount, inv.exchange_rate,
1198: F.minimum_accountable_unit, F.precision
1199: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1200: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1201: WHERE inv.invoice_id = p_invoiceId
1202: AND inv.set_of_books_id = sp.set_of_books_id
1203: AND F.currency_code = sp.base_currency_code;
1204:

Line 1223: UPDATE AP_INVOICES

1219: FUNCTION SetInvoiceAmount(p_invoiceId IN invAll_id,
1220: p_invoiceAmt IN invAll_invoiceAmount,
1221: p_baseAmt IN invAll_baseAmount) RETURN BOOLEAN IS
1222: BEGIN
1223: UPDATE AP_INVOICES
1224: SET invoice_amount = p_invoiceAmt,
1225: pay_curr_invoice_amount = ap_web_utilities_pkg.oie_round_currency(
1226: p_invoiceAmt * payment_cross_rate,
1227: payment_currency_code),