APPS.IGR_IMP_001 dependencies on IGR_IS_TESTSEG

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