APPS.JAI_FBT_SETTLEMENT_P dependencies on AP_INVOICE_LINES_INTERFACE

Line 134: -- ap_invoice_lines_interface tables

130: --
131: -- DESCRIPTION:
132: --
133: -- This procedure is to ap_invoices_interface,
134: -- ap_invoice_lines_interface tables
135: --
136: -- PARAMETERS:
137: -- In: p_inv_interface inv_interface_rec_type record type
138: -- p_inv_lines_interface inv_lines_interface_rec_type record type

Line 205: -- insert into ap_invoice_lines_interface

201: , p_inv_interface.last_update_date
202: , p_inv_interface.last_update_login
203: );
204:
205: -- insert into ap_invoice_lines_interface
206: INSERT INTO ap_invoice_lines_interface
207: ( invoice_id
208: , invoice_line_id
209: , line_number

Line 206: INSERT INTO ap_invoice_lines_interface

202: , p_inv_interface.last_update_login
203: );
204:
205: -- insert into ap_invoice_lines_interface
206: INSERT INTO ap_invoice_lines_interface
207: ( invoice_id
208: , invoice_line_id
209: , line_number
210: , line_type_lookup_code

Line 318: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;

314: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
315: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
316: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;
317: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;
318: ln_invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE;
319: inv_interface_rec inv_interface_rec_type;
320: inv_lines_interface_rec inv_lines_interface_rec_type;
321: ln_user_id NUMBER := fnd_global.user_id;
322: ln_login_id NUMBER := fnd_global.login_id;

Line 470: -- ap_invoice_lines_interface

466: AND period_start_date = ld_start_date
467: AND period_end_date = ld_end_date;
468:
469: -- insert the data into the table ap_invoices_interface and
470: -- ap_invoice_lines_interface
471: -- get invoice id
472: SELECT ap_invoices_interface_s.nextval
473: INTO ln_invoice_id
474: FROM dual;

Line 513: -- ap_invoice_lines_interface

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

Line 515: SELECT ap_invoice_lines_interface_s.nextval

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