69: v_u_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
70: v_u_old_location_cd igs_en_stdnt_ps_att.location_cd%TYPE;
71: v_u_old_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE;
72: v_u_old_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
73: v_u_old_sequence_number igs_as_su_setatmpt.sequence_number%TYPE;
74: v_u_new_version_number igs_en_stdnt_ps_att.version_number%TYPE;
75: v_u_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
76: v_u_new_location_cd igs_en_stdnt_ps_att.location_cd%TYPE;
77: v_u_new_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE;
75: v_u_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
76: v_u_new_location_cd igs_en_stdnt_ps_att.location_cd%TYPE;
77: v_u_new_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE;
78: v_u_new_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
79: v_u_new_sequence_number igs_as_su_setatmpt.sequence_number%TYPE;
80:
81: -- Cursor to retrieve unique-key values for passed program_cd which will be used
82: -- to extract single records from other tables.
83: CURSOR c_prg_ukeyrec (cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
93:
94: -- Cursor to retrieve unique-key values for passed unit set attempt which will be used
95: -- to extract single records from other tables.
96: CURSOR c_us_ukeyrec(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
97: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
98: cp_us_version_number igs_as_su_setatmpt.us_version_number%TYPE) IS
99: SELECT max(sequence_number)
100: FROM igs_as_su_setatmpt
101: WHERE person_id = p_person_id AND
94: -- Cursor to retrieve unique-key values for passed unit set attempt which will be used
95: -- to extract single records from other tables.
96: CURSOR c_us_ukeyrec(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
97: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
98: cp_us_version_number igs_as_su_setatmpt.us_version_number%TYPE) IS
99: SELECT max(sequence_number)
100: FROM igs_as_su_setatmpt
101: WHERE person_id = p_person_id AND
102: course_cd = cp_course_cd AND
96: CURSOR c_us_ukeyrec(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
97: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
98: cp_us_version_number igs_as_su_setatmpt.us_version_number%TYPE) IS
99: SELECT max(sequence_number)
100: FROM igs_as_su_setatmpt
101: WHERE person_id = p_person_id AND
102: course_cd = cp_course_cd AND
103: unit_set_cd = cp_unit_set_cd AND
104: us_version_number = cp_us_version_number;