DBA Data[Home] [Help]

APPS.JAI_FBT_PAYMENT_P dependencies on AP_INVOICES_INTERFACE

Line 139: -- This procedure is to ap_invoices_interface,

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

Line 172: -- insert into ap_invoices_interface

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

Line 173: INSERT INTO ap_invoices_interface

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

Line 315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;

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;

Line 316: ln_invoice_num ap_invoices_interface.invoice_num%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;

Line 317: lv_currency_code ap_invoices_interface.invoice_currency_code%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;

Line 318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%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;

Line 319: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%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;

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 410: ap_invoices_interface_s.nextval

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: