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_FINALIZE_GRADE dependencies on IGS_AS_SU_STMPTOUT

Line 37: v_best_prev_ci_end_dt igs_as_su_stmptout_all.ci_end_dt%TYPE;

33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;
34: v_translated_dt DATE;
35: v_rowid VARCHAR2 (25);
36: v_best_prev_rank igs_as_grd_sch_grade.RANK%TYPE;
37: v_best_prev_ci_end_dt igs_as_su_stmptout_all.ci_end_dt%TYPE;
38:
39: CURSOR c_rp IS
40: SELECT uv.repeatable_ind,
41: rp_org.use_most_recent_unit_attempt,

Line 124: FROM igs_as_su_stmptout_all suao,

120: suao.mark_capped_flag,
121: suao.release_date,
122: suao.manual_override_flag,
123: suao.show_on_academic_histry_flag
124: FROM igs_as_su_stmptout_all suao,
125: igs_as_grd_sch_grade gsg
126: WHERE suao.uoo_id = p_uoo_id
127: AND suao.finalised_outcome_ind = 'N'
128: AND suao.grading_period_cd = 'FINAL'

Line 134: FROM igs_as_su_stmptout_all suao1

130: AND suao.version_number = gsg.version_number
131: AND suao.grade = gsg.grade
132: AND NVL(gsg.closed_ind,'N') = 'N'
133: AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
134: FROM igs_as_su_stmptout_all suao1
135: WHERE suao1.person_id = suao.person_id
136: AND suao1.course_cd = suao.course_cd
137: AND suao1.uoo_id = suao.uoo_id
138: AND suao1.grading_period_cd = suao.grading_period_cd);

Line 189: FROM igs_as_su_stmptout_all suao,

185: suao.mark_capped_flag,
186: suao.release_date,
187: suao.manual_override_flag,
188: suao.show_on_academic_histry_flag
189: FROM igs_as_su_stmptout_all suao,
190: igs_as_grd_sch_grade gsg
191: WHERE suao.person_id = p_person_id
192: AND suao.course_cd = p_course_cd
193: AND suao.uoo_id = p_uoo_id

Line 201: FROM igs_as_su_stmptout_all suao1

197: AND suao.version_number = gsg.version_number
198: AND suao.grade = gsg.grade
199: AND NVL(gsg.closed_ind,'N') = 'N'
200: AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
201: FROM igs_as_su_stmptout_all suao1
202: WHERE suao1.person_id = suao.person_id
203: AND suao1.course_cd = suao.course_cd
204: AND suao1.uoo_id = suao.uoo_id
205: AND suao1.grading_period_cd = suao.grading_period_cd);

Line 208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,

204: AND suao1.uoo_id = suao.uoo_id
205: AND suao1.grading_period_cd = suao.grading_period_cd);
206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE

Line 209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,

205: AND suao1.grading_period_cd = suao.grading_period_cd);
206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS

Line 210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,

206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,

Line 211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,

207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,
215: sua.course_cd,

Line 212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE

208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,
215: sua.course_cd,
216: sua.unit_cd,

Line 263: igs_as_su_stmptout_all suao,

259: suao.release_date,
260: suao.manual_override_flag,
261: suao.show_on_academic_histry_flag
262: FROM igs_en_su_attempt sua,
263: igs_as_su_stmptout_all suao,
264: igs_as_grd_sch_grade gsg
265: WHERE sua.person_id = cp_person_id
266: AND sua.unit_cd = cp_unit_cd
267: AND (sua.course_cd <> cp_course_cd

Line 283: FROM igs_as_su_stmptout

279: AND suao.grade = gsg.grade
280: AND gsg.incl_in_repeat_process_ind = 'Y'
281: AND NVL(gsg.closed_ind,'N') = 'N'
282: AND suao.outcome_dt IN (SELECT MAX (outcome_dt)
283: FROM igs_as_su_stmptout
284: WHERE person_id = suao.person_id
285: AND course_cd = suao.course_cd
286: AND uoo_id = suao.uoo_id
287: AND grading_period_cd = suao.grading_period_cd)

Line 362: igs_as_su_stmptout_pkg.insert_row (

358: );
359: --
360: -- Insert new outcome with repeat grade
361: --
362: igs_as_su_stmptout_pkg.insert_row (
363: x_rowid => v_rowid,
364: x_org_id => NULL,
365: x_person_id => v_prev_suao_rec.person_id,
366: x_course_cd => v_prev_suao_rec.course_cd,

Line 468: igs_as_su_stmptout_pkg.insert_row (

464: );
465: --
466: -- Insert new outcome with repeat grade
467: --
468: igs_as_su_stmptout_pkg.insert_row (
469: x_rowid => v_rowid,
470: x_org_id => NULL,
471: x_person_id => v_prev_suao_rec.person_id,
472: x_course_cd => v_prev_suao_rec.course_cd,

Line 549: igs_as_su_stmptout_pkg.insert_row (

545: );
546: --
547: -- Insert new outcome with repeat grade
548: --
549: igs_as_su_stmptout_pkg.insert_row (
550: x_rowid => v_rowid,
551: x_org_id => NULL,
552: x_person_id => v_suao_rec.person_id,
553: x_course_cd => v_suao_rec.course_cd,

Line 638: igs_as_su_stmptout_pkg.update_row (

634: );
635: --
636: -- Update the current outcome to finlise and set translated grade
637: --
638: igs_as_su_stmptout_pkg.update_row (
639: x_rowid => v_suao_rec.ROWID,
640: x_person_id => v_suao_rec.person_id,
641: x_course_cd => v_suao_rec.course_cd,
642: x_unit_cd => v_suao_rec.unit_cd,

Line 757: igs_as_su_stmptout_pkg.insert_row (

753: );
754: --
755: -- Insert new outcome with repeat grade
756: --
757: igs_as_su_stmptout_pkg.insert_row (
758: x_rowid => v_rowid,
759: x_org_id => NULL,
760: x_person_id => v_prev_suao_rec.person_id,
761: x_course_cd => v_prev_suao_rec.course_cd,

Line 863: igs_as_su_stmptout_pkg.insert_row (

859: );
860: --
861: -- Insert new outcome with repeat grade
862: --
863: igs_as_su_stmptout_pkg.insert_row (
864: x_rowid => v_rowid,
865: x_org_id => NULL,
866: x_person_id => v_prev_suao_rec.person_id,
867: x_course_cd => v_prev_suao_rec.course_cd,

Line 944: igs_as_su_stmptout_pkg.insert_row (

940: );
941: --
942: -- Insert new outcome with repeat grade
943: --
944: igs_as_su_stmptout_pkg.insert_row (
945: x_rowid => v_rowid,
946: x_org_id => NULL,
947: x_person_id => v_suao_rec.person_id,
948: x_course_cd => v_suao_rec.course_cd,

Line 1033: igs_as_su_stmptout_pkg.update_row (

1029: );
1030: --
1031: -- Update the current outcome to finlise and set translated grade
1032: --
1033: igs_as_su_stmptout_pkg.update_row (
1034: x_rowid => v_suao_rec.ROWID,
1035: x_person_id => v_suao_rec.person_id,
1036: x_course_cd => v_suao_rec.course_cd,
1037: x_unit_cd => v_suao_rec.unit_cd,