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_EN_SPA_LGCY_PUB dependencies on IGS_RE_CANDIDATURE_ALL

Line 909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;

905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;
908: l_catalog_end_dt DATE;
909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;
910: l_status VARCHAR2(20);
911: l_sca_re_rec SCA_RE_REC_TYPE;
912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;

Line 1302: INSERT INTO igs_re_candidature_all(person_id,

1298: l_sequence_number:= NULL;
1299: OPEN cur_re_seq;
1300: FETCH cur_re_seq INTO l_sequence_number;
1301: CLOSE cur_re_seq;
1302: INSERT INTO igs_re_candidature_all(person_id,
1303: sequence_number,
1304: sca_course_cd,
1305: acai_admission_appl_number,
1306: acai_nominated_course_cd,