APPS.JL_AR_AUTOINV_PKG dependencies on RA_INTERFACE_LINES

Line 39: FROM ra_interface_lines

35: orig_system_bill_address_id) orig_system_address_id,
36: batch_source_name,
37: trx_date,
38: nvl(org_id, -99) org_id --bug 16471013
39: FROM ra_interface_lines
40: WHERE nvl(interface_status, '~') <> 'P'
41: AND ((nvl(trx_date,sysdate-1) BETWEEN
42: nvl(p_invoice_date_from,nvl(trx_date,sysdate)) AND
43: nvl(p_invoice_date_to, nvl(trx_date,sysdate)))

Line 335: UPDATE ra_interface_lines

331:
332: END;
333:
334: IF nvl(l_new_batch_source_name,trx_lines_rec.batch_source_name) <> trx_lines_rec.batch_source_name THEN
335: UPDATE ra_interface_lines
336: SET batch_source_name = l_new_batch_source_name
337: WHERE rowid = trx_lines_rec.rowid;
338: INSERT INTO JL_AUTOINV_INT_LINES(INTERFACE_LINE_REF, MESSAGE_TEXT, INVALID_VALUE, ORG_ID)
339: VALUES(trx_lines_rec.interface_line_attribute1,

Line 430: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,

426: p_low_gl_date IN VARCHAR2 ,
427: p_high_gl_date IN VARCHAR2 ,
428: p_low_ship_date IN VARCHAR2,
429: p_high_ship_date IN VARCHAR2,
430: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
431: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
432: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
433: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
434: p_low_invoice_date IN VARCHAR2 ,

Line 431: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,

427: p_high_gl_date IN VARCHAR2 ,
428: p_low_ship_date IN VARCHAR2,
429: p_high_ship_date IN VARCHAR2,
430: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
431: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
432: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
433: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
434: p_low_invoice_date IN VARCHAR2 ,
435: p_high_invoice_date IN VARCHAR2 ,

Line 432: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,

428: p_low_ship_date IN VARCHAR2,
429: p_high_ship_date IN VARCHAR2,
430: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
431: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
432: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
433: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
434: p_low_invoice_date IN VARCHAR2 ,
435: p_high_invoice_date IN VARCHAR2 ,
436: p_low_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,

Line 433: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,

429: p_high_ship_date IN VARCHAR2,
430: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
431: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
432: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
433: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
434: p_low_invoice_date IN VARCHAR2 ,
435: p_high_invoice_date IN VARCHAR2 ,
436: p_low_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
437: p_high_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,