[Home] [Help]
207: v_get_record igs_as_ins_grd_entry%ROWTYPE;
208: v_initials igs_pe_person.given_names%TYPE;
209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;
212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'
214: FROM DUAL
215: WHERE EXISTS ( SELECT *
356: sua.version_number
357: FROM igs_ps_unit_ofr_opt uoo,
358: igs_en_su_attempt sua,
359: hz_parties pe,
360: igs_as_unit_class ucl
361: WHERE uoo.unit_cd = p_unit_cd
362: AND uoo.cal_type = p_cal_type
363: AND uoo.ci_sequence_number = TO_CHAR (p_sequence_number)
364: AND uoo.location_cd LIKE v_location_cd
384: sua.version_number
385: FROM igs_ps_unit_ofr_opt uoo,
386: igs_en_su_attempt sua,
387: hz_parties pe,
388: igs_as_unit_class ucl
389: WHERE uoo.unit_cd = p_unit_cd
390: AND uoo.cal_type = p_cal_type
391: AND uoo.ci_sequence_number = TO_CHAR (p_sequence_number)
392: AND uoo.location_cd LIKE v_location_cd
419: sua.version_number
420: FROM igs_ps_unit_ofr_opt uoo,
421: igs_en_su_attempt sua,
422: hz_parties pe,
423: igs_as_unit_class ucl
424: WHERE uoo.unit_cd = cp_unit_cd
425: AND uoo.cal_type = cp_cal_type
426: AND uoo.ci_sequence_number = TO_CHAR (cp_sequence_number)
427: AND uoo.location_cd LIKE cp_location_cd
452: sua.version_number
453: FROM igs_ps_unit_ofr_opt uoo,
454: igs_en_su_attempt sua,
455: hz_parties pe,
456: igs_as_unit_class ucl
457: WHERE uoo.unit_cd = cp_unit_cd
458: AND uoo.cal_type = cp_cal_type
459: AND uoo.ci_sequence_number = TO_CHAR (cp_sequence_number)
460: AND uoo.location_cd LIKE cp_location_cd
732: uop.location_cd,
733: ucl.unit_mode,
734: uop.uoo_id
735: FROM igs_ps_unit_ofr_opt uop,
736: igs_as_unit_class ucl,
737: igs_ca_inst ci,
738: igs_ps_unit_ver uv,
739: igs_ca_stat cs,
740: igs_ps_unit_stat us
823: -- procedure used to mainly insert student records (orderd by
824: -- PERSON_ID/SURNAME) into MSSUA
825: PROCEDURE asspl_ins_mssua_sort (
826: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
827: lp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
828: lp_sort_by IN VARCHAR2,
829: lp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
830: lp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
841: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
842: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
843: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
844: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
845: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
846: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
847: ) IS
848: SELECT sua.person_id,
849: sua.course_cd,
854: ucl.unit_mode,
855: sua.unit_class,
856: unit_attempt_status
857: FROM igs_en_su_attempt sua,
858: igs_as_unit_class ucl
859: WHERE ucl.unit_class = sua.unit_class
860: AND sua.uoo_id = cp_uoo_id
861: AND sua.location_cd = cp_location_cd
862: AND ucl.unit_mode = cp_unit_mode
906: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
907: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
908: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
909: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
910: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
911: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
912: ) IS
913: SELECT pe.person_last_name surname,
914: sua.person_id,
920: ucl.unit_mode,
921: sua.unit_class,
922: unit_attempt_status
923: FROM igs_en_su_attempt sua,
924: igs_as_unit_class ucl,
925: hz_parties pe
926: WHERE sua.person_id = pe.party_id
927: AND ucl.unit_class = sua.unit_class
928: AND ucl.closed_ind = 'N'