APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_INVOICES

Line 424: SELECT ap_invoices_interface_s.nextval

420: p_invoice_id OUT NOCOPY NUMBER
421: ) RETURN BOOLEAN IS
422: --------------------------------------------------------------------------------
423: BEGIN
424: SELECT ap_invoices_interface_s.nextval
425: INTO p_invoice_id
426: FROM sys.dual;
427:
428: return TRUE;

Line 941: FROM ap_invoices I,

937: decode(sign(earliest_settlement_date - sysdate),1,0,1),
938: 0)),
939: 0)
940: INTO p_available_prepays
941: FROM ap_invoices I,
942: ap_suppliers PV
943: WHERE (select sum(aid.prepay_amount_remaining)
944: from ap_invoice_distributions aid
945: where aid.invoice_id = I.invoice_id

Line 991: INSERT INTO AP_INVOICES_INTERFACE

987: --------------------------------------------------------------------------------
988: BEGIN
989: -- Bug 6838894
990: -- Bug: 7234744 populate terms-id in the interface table.
991: INSERT INTO AP_INVOICES_INTERFACE
992: (INVOICE_ID,
993: INVOICE_NUM,
994: PARTY_ID,
995: PARTY_SITE_ID,

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

1154:
1155: SELECT inv.invoice_amount, inv.exchange_rate,
1156: F.minimum_accountable_unit, F.precision
1157: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1158: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1159: WHERE inv.invoice_id = p_invoiceId
1160: AND inv.set_of_books_id = sp.set_of_books_id
1161: AND F.currency_code = sp.base_currency_code;
1162:

Line 1181: UPDATE AP_INVOICES

1177: FUNCTION SetInvoiceAmount(p_invoiceId IN invAll_id,
1178: p_invoiceAmt IN invAll_invoiceAmount,
1179: p_baseAmt IN invAll_baseAmount) RETURN BOOLEAN IS
1180: BEGIN
1181: UPDATE AP_INVOICES
1182: SET invoice_amount = p_invoiceAmt,
1183: pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency(
1184: p_invoiceAmt * payment_cross_rate,
1185: payment_currency_code),