APPS.IGR_IMP_001 dependencies on IGR_IS_TEST

Line 193: CURSOR inq_per_test_cur(l_person_id igr_is_test.inq_person_id%TYPE) IS

189: enabled_flag = 'Y';
190:
191: l_sub_interest_type_code igs_ad_excurr_int.sub_interest_type_code%TYPE;
192:
193: CURSOR inq_per_test_cur(l_person_id igr_is_test.inq_person_id%TYPE) IS
194: SELECT
195: inq_test_id,
196: admission_test_type,
197: comp_test_score,

Line 201: igr_is_test

197: comp_test_score,
198: test_date,
199: test_source_id
200: FROM
201: igr_is_test
202: WHERE
203: inq_person_id = l_person_id AND
204: status IN (inserted,updated);
205:

Line 206: CURSOR inq_per_testseg_cur(l_test_id igr_is_testseg.inq_test_id%TYPE) IS

202: WHERE
203: inq_person_id = l_person_id AND
204: status IN (inserted,updated);
205:
206: CURSOR inq_per_testseg_cur(l_test_id igr_is_testseg.inq_test_id%TYPE) IS
207: SELECT
208: test_segment_id,
209: test_score
210: FROM

Line 211: igr_is_testseg

207: SELECT
208: test_segment_id,
209: test_score
210: FROM
211: igr_is_testseg
212: WHERE
213: inq_test_id = l_test_id AND
214: status IN (inserted,updated);
215:

Line 1595: UPDATE igr_is_test SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

1591: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_INT failed '||SQLERRM);
1592: RAISE;
1593: END;
1594:
1595: UPDATE igr_is_test SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1596: ELSE /* l_status = 0 i.e Validation failed*/
1597: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1598: fnd_message.set_token('TABLE_NAME','igs_ad_test_int');
1599: fnd_message.set_token('COL_NAMES',l_tokenstr);

Line 1672: UPDATE igr_is_testseg SET status = 'T' WHERE inq_test_id = inq_per_test_rec.inq_test_id;

1668: RAISE;
1669: END;
1670:
1671: /* After Successful Insertion Update the corresponding Self Service table with STATUS as 'T' */
1672: UPDATE igr_is_testseg SET status = 'T' WHERE inq_test_id = inq_per_test_rec.inq_test_id;
1673: ELSE /* l_status = 0 i.e Validation failed*/
1674: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1675: fnd_message.set_token('TABLE_NAME','igs_ad_test_segs_int');
1676: fnd_message.set_token('COL_NAMES',l_tokenstr);