135: -- Insert_Interface_Table Private
136: --
137: -- DESCRIPTION:
138: --
139: -- This procedure is to ap_invoices_interface,
140: -- ap_invoice_lines_interface tables
141: --
142: -- PARAMETERS:
143: -- In: p_inv_interface inv_interface_rec_type record type
168: , 'Enter procedure'
169: );
170: END IF; --l_proc_level>=l_dbg_level
171:
172: -- insert into ap_invoices_interface
173: INSERT INTO ap_invoices_interface
174: ( invoice_id
175: , invoice_num
176: , invoice_date
169: );
170: END IF; --l_proc_level>=l_dbg_level
171:
172: -- insert into ap_invoices_interface
173: INSERT INTO ap_invoices_interface
174: ( invoice_id
175: , invoice_num
176: , invoice_date
177: , vendor_id
311: IS
312: --ln_org_id NUMBER;
313: ln_invoice_amout NUMBER;
314: fbt_payment_rec jai_fbt_payment%ROWTYPE;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
312: --ln_org_id NUMBER;
313: ln_invoice_amout NUMBER;
314: fbt_payment_rec jai_fbt_payment%ROWTYPE;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
320: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;
313: ln_invoice_amout NUMBER;
314: fbt_payment_rec jai_fbt_payment%ROWTYPE;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
320: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;
321: inv_interface_rec inv_interface_rec_type;
314: fbt_payment_rec jai_fbt_payment%ROWTYPE;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
320: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;
321: inv_interface_rec inv_interface_rec_type;
322: inv_lines_interface_rec inv_lines_interface_rec_type;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
320: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;
321: inv_interface_rec inv_interface_rec_type;
322: inv_lines_interface_rec inv_lines_interface_rec_type;
323: ln_user_id NUMBER := fnd_global.user_id;
403: , fnd_currencies fc
404: WHERE gsob.set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID')
405: AND gsob.currency_code = fc.currency_code;
406:
407: -- get invoice_id for ap_invoices_interface,ap_invoice_lines_interface
408: -- and JAI_FBT_PAYMENT
409: SELECT
410: ap_invoices_interface_s.nextval
411: INTO
406:
407: -- get invoice_id for ap_invoices_interface,ap_invoice_lines_interface
408: -- and JAI_FBT_PAYMENT
409: SELECT
410: ap_invoices_interface_s.nextval
411: INTO
412: ln_invoice_id
413: FROM dual;
414: