APPS.IGR_IMP_002 dependencies on IGR_I_INFO_INT

Line 49: OR EXISTS (SELECT 1 FROM igr_i_info_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)

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: );
52: COMMIT;
53:

Line 239: UPDATE igr_i_info_int a

235: p_token_value => l_meaning);
236: END IF;
237:
238: -- Populating the interface table with the interface_run_id value
239: UPDATE igr_i_info_int a
240: SET interface_run_id = p_interface_run_id,
241: (person_id,enquiry_appl_number)
242: = (SELECT person_id,enquiry_appl_number
243: FROM igr_i_appl_int

Line 252: tabname => 'IGR_I_INFO_INT',

248: AND status IN ('1','4'));
249:
250: -- Gather statistics of the table
251: FND_STATS.GATHER_TABLE_STATS(ownname => p_schema,
252: tabname => 'IGR_I_INFO_INT',
253: cascade => TRUE);
254:
255: -- Call category entity import procedure
256: igr_imp_004.prc_inq_info (p_interface_run_id => p_interface_run_id,

Line 327: DELETE FROM igr_i_info_int

323: COMMIT;
324: END IF; -- g_inquiry_pkg_itm_inc
325:
326: IF g_inquiry_info_type_inc THEN
327: DELETE FROM igr_i_info_int
328: WHERE status = '1'
329: AND interface_run_id = p_interface_run_id;
330: COMMIT;
331: END IF; -- g_inquiry_info_type_inc