eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_015 dependencies on IGS_AD_TEST_SEGS_INT

Line 296: UPDATE igs_ad_test_segs_int

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
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

Line 305: tabname => 'IGS_AD_TEST_SEGS_INT',

301: AND status IN ('1','2','4'));
302:
303: -- Gather statistics of the table
304: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
305: tabname => 'IGS_AD_TEST_SEGS_INT',
306: cascade => TRUE);
307:
308: -- Call category entity import procedure
309: igs_ad_imp_016.prc_tst_rslts (p_interface_run_id => p_interface_run_id,

Line 935: l_category_entity_ad_table(09).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(09).entity_name := 'IGS_AD_TEST_SEGS_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';
939: l_category_entity_ad_table(13).category_name := 'APPLICATION'; l_category_entity_ad_table(13).entity_name := 'IGS_AD_APL_INT';

Line 1127: DELETE FROM igs_ad_test_segs_int

1123: COMMIT;
1124: END IF; -- g_transcript_dtls_inc
1125:
1126: IF g_test_result_inc THEN
1127: DELETE FROM igs_ad_test_segs_int
1128: WHERE status = '1'
1129: AND interface_run_id = p_interface_run_id;
1130: COMMIT;
1131: