Supplier Invoice Code
CREATE OR REPLACE PROCEDURE SUPP_AP_INVOICES_PKG( errbuf OUT VARCHAR2, retcode OUT VARCHAR2) AS CURSOR c1 IS SELECT org_id, invoice_type_lookup_code, vendor_num, vendor_name, vendor_site_code, invoice_num, invoice_date, invoice_currency_code, invoice_amount, gl_date, payment_currency_code, terms_date, terms_name, payment_method_lookup_code, description, exchange_rate, exchange_rate_type, exchange_date, doc_category_code, voucher_num, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, SOURCE FROM SUPP_INVOICE_HEADER_STG; cursor c2(p_invoice_num IN VARCHAR2) IS SELECT a.org_id, a.vendor_num, a.invoice_num, a.po_number, a.line_number, a.line_type, a.amount,...