APPS.JAI_FBT_PAYMENT_P dependencies on AP_INVOICE_LINES_INTERFACE

Line 140: -- ap_invoice_lines_interface tables

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
144: -- p_inv_lines_interface inv_lines_interface_rec_type record type

Line 211: -- insert into ap_invoice_lines_interface

207: , p_inv_interface.last_update_date
208: , p_inv_interface.last_update_login
209: );
210:
211: -- insert into ap_invoice_lines_interface
212: INSERT INTO ap_invoice_lines_interface
213: ( invoice_id
214: , invoice_line_id
215: , line_number

Line 212: INSERT INTO ap_invoice_lines_interface

208: , p_inv_interface.last_update_login
209: );
210:
211: -- insert into ap_invoice_lines_interface
212: INSERT INTO ap_invoice_lines_interface
213: ( invoice_id
214: , invoice_line_id
215: , line_number
216: , line_type_lookup_code

Line 320: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_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;
324: ln_login_id NUMBER := fnd_global.login_id;

Line 377: ln_fbt_acct_ccid ap_invoice_lines_interface.dist_code_combination_id%TYPE;

373: */
374: -----------------------------------------------------------------------------------
375: --modified by eric for R12.1 21-Oct-2008,end
376:
377: ln_fbt_acct_ccid ap_invoice_lines_interface.dist_code_combination_id%TYPE;
378:
379: CURSOR get_fbt_account_ccid_cur
380: IS
381: SELECT fbt_account_ccid

Line 407: -- get invoice_id for ap_invoices_interface,ap_invoice_lines_interface

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

Line 514: -- ap_invoice_lines_interface

510: inv_interface_rec.last_updated_by := ln_user_id;
511: inv_interface_rec.last_update_login := ln_login_id;
512:
513:
514: -- ap_invoice_lines_interface
515: -- get invoice line id
516: SELECT ap_invoice_lines_interface_s.nextval
517: INTO ln_invoice_line_id
518: FROM dual;

Line 516: SELECT ap_invoice_lines_interface_s.nextval

512:
513:
514: -- ap_invoice_lines_interface
515: -- get invoice line id
516: SELECT ap_invoice_lines_interface_s.nextval
517: INTO ln_invoice_line_id
518: FROM dual;
519:
520: --added by eric ma for bug 7325833 on 18-Aug-2008,begin