APPS.IGR_IMP_002 dependencies on IGR_I_PKG_INT

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

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

Line 206: UPDATE igr_i_pkg_int a

202: p_token_value => l_meaning);
203: END IF;
204:
205: -- Populating the interface table with the interface_run_id value
206: UPDATE igr_i_pkg_int a
207: SET interface_run_id = p_interface_run_id,
208: (person_id,enquiry_appl_number,sales_lead_id)
209: = (SELECT person_id,enquiry_appl_number,sales_lead_id
210: FROM igr_i_appl_int

Line 219: tabname => 'IGR_I_PKG_INT',

215: AND status IN ('1','4'));
216:
217: -- Gather statistics of the table
218: FND_STATS.GATHER_TABLE_STATS(ownname => p_schema,
219: tabname => 'IGR_I_PKG_INT',
220: cascade => TRUE);
221:
222: -- Call category entity import procedure
223: igr_imp_004.prc_inq_pkg (p_interface_run_id => p_interface_run_id,

Line 320: DELETE FROM igr_i_pkg_int

316: COMMIT;
317: END IF; -- g_inquiry_acad_int_inc
318:
319: IF g_inquiry_pkg_itm_inc THEN
320: DELETE FROM igr_i_pkg_int
321: WHERE status = '1'
322: AND interface_run_id = p_interface_run_id;
323: COMMIT;
324: END IF; -- g_inquiry_pkg_itm_inc