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_AS_PROD_DOC dependencies on IGS_EN_SU_ATTEMPT

Line 124: CURSOR cur_en_su_att (cp_person_id igs_en_su_attempt.person_id%TYPE,

120: TRUNC(pen_start_dt) <= TRUNC(cp_creation_date);
121: rec_cur_hold_eft cur_hold_eft%ROWTYPE;
122:
123: -- Cursor to get the student unit attempts.
124: CURSOR cur_en_su_att (cp_person_id igs_en_su_attempt.person_id%TYPE,
125: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
126: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
127: -- anilk, 22-Apr-2003, Bug# 2829262
128: SELECT course_cd, unit_cd, uoo_id

Line 125: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

121: rec_cur_hold_eft cur_hold_eft%ROWTYPE;
122:
123: -- Cursor to get the student unit attempts.
124: CURSOR cur_en_su_att (cp_person_id igs_en_su_attempt.person_id%TYPE,
125: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
126: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
127: -- anilk, 22-Apr-2003, Bug# 2829262
128: SELECT course_cd, unit_cd, uoo_id
129: FROM igs_en_su_attempt

Line 126: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS

122:
123: -- Cursor to get the student unit attempts.
124: CURSOR cur_en_su_att (cp_person_id igs_en_su_attempt.person_id%TYPE,
125: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
126: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
127: -- anilk, 22-Apr-2003, Bug# 2829262
128: SELECT course_cd, unit_cd, uoo_id
129: FROM igs_en_su_attempt
130: WHERE person_id = cp_person_id AND

Line 129: FROM igs_en_su_attempt

125: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
126: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
127: -- anilk, 22-Apr-2003, Bug# 2829262
128: SELECT course_cd, unit_cd, uoo_id
129: FROM igs_en_su_attempt
130: WHERE person_id = cp_person_id AND
131: unit_attempt_status IN (cst_completed,cst_enrolled) AND
132: cal_type = cp_cal_type AND
133: ci_sequence_number = cp_ci_sequence_number ;

Line 137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,

133: ci_sequence_number = cp_ci_sequence_number ;
134: rec_cur_en_su_att cur_en_su_att%ROWTYPE;
135:
136: -- Cursor to check the finalised outcome for the student unit attempts.
137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,
138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

Line 138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

134: rec_cur_en_su_att cur_en_su_att%ROWTYPE;
135:
136: -- Cursor to check the finalised outcome for the student unit attempts.
137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,
138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
142: -- anilk, 22-Apr-2003, Bug# 2829262

Line 139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

135:
136: -- Cursor to check the finalised outcome for the student unit attempts.
137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,
138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
142: -- anilk, 22-Apr-2003, Bug# 2829262
143: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS

Line 140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

136: -- Cursor to check the finalised outcome for the student unit attempts.
137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,
138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
142: -- anilk, 22-Apr-2003, Bug# 2829262
143: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
144: SELECT finalised_outcome_ind

Line 141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

137: CURSOR cur_as_suaoa(cp_person_id igs_en_su_attempt.person_id%TYPE,
138: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
142: -- anilk, 22-Apr-2003, Bug# 2829262
143: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
144: SELECT finalised_outcome_ind
145: FROM igs_as_suaoa_v

Line 143: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS

139: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
140: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
141: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
142: -- anilk, 22-Apr-2003, Bug# 2829262
143: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
144: SELECT finalised_outcome_ind
145: FROM igs_as_suaoa_v
146: WHERE person_id = cp_person_id AND
147: course_cd = cp_course_cd AND