APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_AD_TSTDTL_UH_INT

Line 37: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTDTL_UH_INT', cascade => TRUE);

33: BEGIN
34: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
35:
36: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTRST_UH_INT', cascade => TRUE);
37: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_TSTDTL_UH_INT', cascade => TRUE);
38: EXCEPTION WHEN OTHERS THEN
39: NULL;
40: END;
41:

Line 93: 2. IGS_AD_TSTDTL_UH_INT ( Test Results Details Interface table)

89: ) IS
90: /*
91: This procedure imports the records from the interface tables
92: 1. IGS_AD_TSTRST_UH_INT ( Test Results Interface table)
93: 2. IGS_AD_TSTDTL_UH_INT ( Test Results Details Interface table)
94: into the corresponding OSS tables viz.,
95: 1. IGS_AD_TEST_RESULTS ( Test results system table)
96: 2. IGS_AD_TST_RSLT_DTLS ( Test Results Details system table)
97: */

Line 113: SELECT SUM(B.TEST_SCORE) FROM IGS_AD_TSTRST_UH_INT A,IGS_AD_TSTDTL_UH_INT B

109: SESSION_ID = p_session_id AND
110: STATUS = '2';
111:
112: CURSOR c_test_scores IS
113: SELECT SUM(B.TEST_SCORE) FROM IGS_AD_TSTRST_UH_INT A,IGS_AD_TSTDTL_UH_INT B
114: WHERE A.INTERFACE_TST_ID = B.INTERFACE_TST_ID
115: AND A.PERSON_ID = p_person_id
116: AND A.SESSION_ID = p_session_id
117: AND B.TEST_SEGMENT_ID IN (SELECT TEST_SEGMENT_ID

Line 186: igs_ad_tstdtl_uh_int

182: CURSOR c_tstdtl_cur ( cp_interface_tst_id NUMBER) IS
183: SELECT
184: *
185: FROM
186: igs_ad_tstdtl_uh_int
187: WHERE
188: interface_tst_id = cp_interface_tst_id;
189: BEGIN
190: FOR c_tstdtl_rec IN c_tstdtl_cur ( p_interface_tst_id) LOOP

Line 406: igs_ad_tstdtl_uh_int

402: -- Outer End
403: END;
404: IF l_error_code IS NULL THEN
405: DELETE FROM
406: igs_ad_tstdtl_uh_int
407: WHERE
408: interface_tst_id = c_tst_rec.interface_tst_id;
409:
410: DELETE FROM