APPS.IGR_IMP_002 dependencies on IGR_I_CHAR_INT

Line 50: OR EXISTS (SELECT 1 FROM igr_i_char_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_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:
54: -- Based upon person child

Line 272: UPDATE igr_i_char_int a

268: p_token_value => l_meaning);
269: END IF;
270:
271: -- Populating the interface table with the interface_run_id value
272: UPDATE igr_i_char_int a
273: SET interface_run_id = p_interface_run_id,
274: (person_id,enquiry_appl_number)
275: = (SELECT person_id,enquiry_appl_number
276: FROM igr_i_appl_int

Line 285: tabname => 'IGR_I_CHAR_INT',

281: AND status IN ('1','4'));
282:
283: -- Gather statistics of the table
284: FND_STATS.GATHER_TABLE_STATS(ownname => p_schema,
285: tabname => 'IGR_I_CHAR_INT',
286: cascade => TRUE);
287:
288: -- Call category entity import procedure
289: igr_imp_004.prc_inq_char (p_interface_run_id => p_interface_run_id,

Line 334: DELETE FROM igr_i_char_int

330: COMMIT;
331: END IF; -- g_inquiry_info_type_inc
332:
333: IF g_inquiry_char_inc THEN
334: DELETE FROM igr_i_char_int
335: WHERE status = '1'
336: AND interface_run_id = p_interface_run_id;
337: COMMIT;
338: END IF; -- g_inquiry_char_inc