APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_AD_TEST_RESULTS

Line 95: 1. IGS_AD_TEST_RESULTS ( Test results system table)

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: */
98: --
99: -- DLD_adsr_Test_Scores

Line 122: FROM IGS_AD_TEST_RESULTS

118: FROM IGS_AD_TEST_SEGMENTS
119: WHERE INCLUDE_IN_COMP_SCORE ='Y'
120: AND ADMISSION_TEST_TYPE IN
121: ( SELECT distinct admission_test_type
122: FROM IGS_AD_TEST_RESULTS
123: WHERE person_id = p_person_id));
124: --
125: -- DLD_adsr_Test_Scores
126: -- 6. Get the corresponding SCORE_TYPE for the C_TST_CUR.TEST_TYPE and

Line 143: -- in the table IGS_AD_TEST_RESULTS.

139: --
140: -- DLD_adsr_Test_Scores
141: -- IF X_ACTIVE_IND is Y THEN
142: -- Make all other Test Types which is same as the test type C_TST_CUR.TEST_TYPE to Active N
143: -- in the table IGS_AD_TEST_RESULTS.
144: -- Use the following query
145: --
146: CURSOR c_other_test_cur ( cp_test_type VARCHAR2, cp_test_results_id NUMBER) IS
147: SELECT

Line 150: igs_ad_test_results a

146: CURSOR c_other_test_cur ( cp_test_type VARCHAR2, cp_test_results_id NUMBER) IS
147: SELECT
148: a.rowid, a.*
149: FROM
150: igs_ad_test_results a
151: WHERE
152: person_id = p_person_id AND
153: admission_test_type = cp_test_type AND
154: active_ind = 'Y' AND

Line 269: -- 7. Call IGS_AD_TEST_RESULTS.INSERT_ROW(

265: -- Insert master begin
266: BEGIN
267: --
268: -- DLD_adsr_Test_Scores
269: -- 7. Call IGS_AD_TEST_RESULTS.INSERT_ROW(
270: --
271: igs_ad_test_results_pkg.insert_row
272: (
273: X_ROWID => l_tst_rowid,

Line 271: igs_ad_test_results_pkg.insert_row

267: --
268: -- DLD_adsr_Test_Scores
269: -- 7. Call IGS_AD_TEST_RESULTS.INSERT_ROW(
270: --
271: igs_ad_test_results_pkg.insert_row
272: (
273: X_ROWID => l_tst_rowid,
274: X_TEST_RESULTS_ID => l_test_results_id,
275: X_PERSON_ID => c_tst_rec.person_id,

Line 329: igs_ad_test_results_pkg.update_row

325: IF c_tst_rec.active_ind = 'Y' THEN
326: FOR c_other_test_rec IN c_other_test_cur ( c_tst_rec.test_type, l_test_results_id) LOOP
327: -- Update Active Ind Begin
328: BEGIN
329: igs_ad_test_results_pkg.update_row
330: (
331: X_ROWID => c_other_test_rec.rowid,
332: X_TEST_RESULTS_ID => c_other_test_rec.test_results_id,
333: X_PERSON_ID => c_other_test_rec.person_id,