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_GEN_016 dependencies on IGS_AS_SC_ATMPT_ENR

Line 125: FROM igs_as_sc_atmpt_enr asa , igs_ca_inst ci

121: --cursor to get SUA Administrative details
122: --
123: CURSOR get_as_sc_atmpt_enr (p_start_dt IN DATE , p_end_dt IN DATE , p_person_id IN NUMBER , p_course_cd IN VARCHAR2)IS
124: SELECT asa.ROWID , asa.*
125: FROM igs_as_sc_atmpt_enr asa , igs_ca_inst ci
126: WHERE ci.start_dt >= p_start_dt AND ci.end_dt <= p_end_dt
127: AND asa.cal_type = ci.cal_type
128: AND asa.ci_sequence_number = ci.sequence_number
129: AND asa.course_cd = p_course_cd

Line 726: igs_as_sc_atmpt_enr_pkg .update_row (

722: FOR l_as_sc_atmpt_enr_rec IN get_as_sc_atmpt_enr ( l_acad_cal_Start_dt ,l_acad_cal_end_dt ,l_person_id , l_prgm_dtls_rec.course_cd )
723: LOOP
724:
725: -- Update all Administrative Program Details for the Programs that passed the validations.
726: igs_as_sc_atmpt_enr_pkg .update_row (
727: X_ROWID => l_as_sc_atmpt_enr_rec.ROWID,
728: x_person_id => l_as_sc_atmpt_enr_rec.person_id,
729: x_course_cd => l_as_sc_atmpt_enr_rec.course_cd,
730: x_cal_type => l_as_sc_atmpt_enr_rec.cal_type,