246: ELSE
247: l_run_payables_import :='No';
248: END IF;
249:
250: select sysdate into l_init_sysdate from dual;
251:
252: l_request_id := fnd_global.conc_request_id;
253:
254: IF (p_org_id is not null) THEN
548:
549: OPEN c_dist;
550:
551: SELECT ap_invoices_interface_s.nextval INTO l_invoice_id
552: FROM dual;
553:
554: LOOP
555: FETCH c_dist INTO l_d_amount_cr, l_d_amount_dr, l_ccid,
556: l_dist_type, l_l_amount_cr, l_l_amount_dr,
626: l_amount := l_d_amount_cr * (-1);
627: END IF;
628:
629: SELECT ap_invoice_lines_interface_s.nextval into l_inv_line_id
630: FROM dual;
631:
632: INSERT INTO ap_invoice_lines_interface (
633: invoice_id, invoice_line_id, line_number,
634: line_type_lookup_code, amount, accounting_date,