1565:
1566: FOR invoice IN get_invoice_lines(salesreps.salesrep_id)
1567: LOOP
1568:
1569: -- Create a record in ap_invoices_interface
1570: -- for each Payment Transaction line in OSC (for the invoice)
1571:
1572: -- Need to change the inv import later to pass the liability
1573: -- and expense accounts for the invoice
1580: ELSE
1581: l_lookup_type := 'STANDARD';
1582: END IF;
1583:
1584: INSERT INTO ap_invoices_interface
1585: (invoice_id,
1586: org_id,
1587: invoice_num,
1588: invoice_date,
1599: LAST_UPDATE_DATE,
1600: LAST_UPDATED_BY,
1601: LAST_UPDATE_LOGIN)
1602: VALUES
1603: (ap_invoices_interface_s.NEXTVAL,
1604: l_org_id,
1605: invoice.payment_transaction_id,
1606: l_pay_date,
1607: l_supplier_id,
1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY,
1636: LAST_UPDATE_LOGIN)
1637: VALUES
1638: (ap_invoices_interface_s.CURRVAL,
1639: ap_invoice_lines_interface_s.NEXTVAL,
1640: 1,
1641: invoice.payment_amount,
1642: invoice.expense_ccid,