APPS.IGS_AD_IMP_015 dependencies on IGS_AD_TEST_INT

Line 271: UPDATE igs_ad_test_int a

267: p_token_value => l_meaning);
268: END IF;
269:
270: -- Populating the interface table with the interface_run_id value
271: UPDATE igs_ad_test_int a
272: SET interface_run_id = p_interface_run_id,
273: person_id = (SELECT person_id
274: FROM igs_ad_interface
275: WHERE interface_id = a.interface_id)

Line 283: UPDATE igs_ad_test_int

279: AND status IN ('1','4'));
280:
281: -- If record failed only due to child record failure
282: -- then set status back to 1 and nullify error code/text
283: UPDATE igs_ad_test_int
284: SET error_code = NULL,
285: error_text = NULL,
286: status = '1'
287: WHERE interface_run_id = p_interface_run_id

Line 293: tabname => 'IGS_AD_TEST_INT',

289: AND status = '4';
290:
291: -- Gather statistics of the table
292: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
293: tabname => 'IGS_AD_TEST_INT',
294: cascade => TRUE);
295:
296: UPDATE igs_ad_test_segs_int
297: SET interface_run_id = p_interface_run_id

Line 299: FROM igs_ad_test_int

295:
296: UPDATE igs_ad_test_segs_int
297: SET interface_run_id = p_interface_run_id
298: WHERE interface_test_id IN (SELECT interface_test_id
299: FROM igs_ad_test_int
300: WHERE interface_run_id = p_interface_run_id
301: AND status IN ('1','2','4'));
302:
303: -- Gather statistics of the table

Line 934: l_category_entity_ad_table(08).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(08).entity_name := 'IGS_AD_TEST_INT';

930: l_category_entity_ad_table(04).category_name := 'INQUIRY_ACADEMIC_INTEREST'; l_category_entity_ad_table(04).entity_name := 'IGR_I_LINES_INT';
931: l_category_entity_ad_table(05).category_name := 'INQUIRY_PACKAGE_ITEMS'; l_category_entity_ad_table(05).entity_name := 'IGR_I_PKG_INT';
932: l_category_entity_ad_table(06).category_name := 'INQUIRY_INFORMATION_TYPES'; l_category_entity_ad_table(06).entity_name := 'IGR_I_INFO_INT';
933: l_category_entity_ad_table(07).category_name := 'INQUIRY_CHARACTERISTICS'; l_category_entity_ad_table(07).entity_name := 'IGR_I_CHAR_INT';
934: l_category_entity_ad_table(08).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(08).entity_name := 'IGS_AD_TEST_INT';
935: l_category_entity_ad_table(09).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(09).entity_name := 'IGS_AD_TEST_SEGS_INT';
936: l_category_entity_ad_table(10).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(10).entity_name := 'IGS_AD_TXCPT_INT';
937: l_category_entity_ad_table(11).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(11).entity_name := 'IGS_AD_TRMDT_INT';
938: l_category_entity_ad_table(12).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(12).entity_name := 'IGS_AD_TUNDT_INT';

Line 1132: DELETE FROM igs_ad_test_int

1128: WHERE status = '1'
1129: AND interface_run_id = p_interface_run_id;
1130: COMMIT;
1131:
1132: DELETE FROM igs_ad_test_int
1133: WHERE status = '1'
1134: AND interface_run_id = p_interface_run_id;
1135: COMMIT;
1136: END IF; -- g_test_result_inc