APPS.IGR_IMP_002 dependencies on IGR_I_LINES_INT

Line 47: EXISTS (SELECT 1 FROM igr_i_lines_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)

43: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
44: WHERE status = '1'
45: AND interface_run_id = p_interface_run_id
46: AND (
47: EXISTS (SELECT 1 FROM igr_i_lines_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)
48: OR EXISTS (SELECT 1 FROM igr_i_pkg_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)
49: OR EXISTS (SELECT 1 FROM igr_i_info_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)
50: OR EXISTS (SELECT 1 FROM igr_i_char_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)
51: );

Line 173: UPDATE igr_i_lines_int a

169: p_token_value => l_meaning);
170: END IF;
171:
172: -- Populating the interface table with the interface_run_id value
173: UPDATE igr_i_lines_int a
174: SET interface_run_id = p_interface_run_id,
175: (person_id,enquiry_appl_number,inquiry_date,inquiry_source_type,sales_lead_id)
176: = (SELECT person_id,enquiry_appl_number,inquiry_dt,inquiry_source_type,sales_lead_id
177: FROM igr_i_appl_int

Line 186: tabname => 'IGR_I_LINES_INT',

182: AND status IN ('1','4'));
183:
184: -- Gather statistics of the table
185: FND_STATS.GATHER_TABLE_STATS(ownname => p_schema,
186: tabname => 'IGR_I_LINES_INT',
187: cascade => TRUE);
188:
189: -- Call category entity import procedure
190: igr_imp_003.process_inquiry_lines (p_interface_run_id => p_interface_run_id,

Line 313: DELETE FROM igr_i_lines_int

309:
310: BEGIN
311:
312: IF g_inquiry_acad_int_inc THEN
313: DELETE FROM igr_i_lines_int
314: WHERE status = '1'
315: AND interface_run_id = p_interface_run_id;
316: COMMIT;
317: END IF; -- g_inquiry_acad_int_inc