eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_FBT_SETTLEMENT_P dependencies on AP_INVOICES_INTERFACE

Line 133: -- This procedure is to ap_invoices_interface,

129: -- Insert_Interface_Table Private
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

Line 166: -- insert into ap_invoices_interface

162: , 'Enter procedure'
163: );
164: END IF; --l_proc_level>=l_dbg_level
165:
166: -- insert into ap_invoices_interface
167: INSERT INTO ap_invoices_interface
168: ( invoice_id
169: , invoice_num
170: , invoice_date

Line 167: INSERT INTO ap_invoices_interface

163: );
164: END IF; --l_proc_level>=l_dbg_level
165:
166: -- insert into ap_invoices_interface
167: INSERT INTO ap_invoices_interface
168: ( invoice_id
169: , invoice_num
170: , invoice_date
171: , vendor_id

Line 313: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;

309: ln_settlement_id NUMBER;
310: ln_consolidated_amount NUMBER;
311: ln_invoice_amout NUMBER;
312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;
313: ln_invoice_id ap_invoices_interface.invoice_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;

Line 314: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;

310: ln_consolidated_amount NUMBER;
311: ln_invoice_amout NUMBER;
312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;
313: ln_invoice_id ap_invoices_interface.invoice_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;

Line 315: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;

311: ln_invoice_amout NUMBER;
312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;
313: ln_invoice_id ap_invoices_interface.invoice_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;

Line 316: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;

312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;
313: ln_invoice_id ap_invoices_interface.invoice_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;

Line 317: lv_payment_method_code ap_invoices_interface.payment_method_lookup_code%TYPE;

313: ln_invoice_id ap_invoices_interface.invoice_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;

Line 469: -- insert the data into the table ap_invoices_interface and

465: WHERE legal_entity_id = pn_legal_entity_id
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

Line 472: SELECT ap_invoices_interface_s.nextval

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;
475:
476: -- get invoice num