[Home] [Help]
414: --Fetches the relevant load calendars depending upon the teach alt codes specified
415: --int the interface table. The person and program attempt are in the context.
416: CURSOR c_bulk_load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
417: cp_person_number igs_pe_person.person_number%TYPE,
418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number
421: seq_num, ttol.load_alternate_code alt_cd,ttol.load_start_dt
422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol
445:
446: --Fetches the induvidual sua records from the interface table
447: CURSOR c_bulk_suas (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
448: cp_person_number igs_pe_person.person_number%TYPE,
449: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
450: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE,
451: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
452: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
453: cp_teach_alternate_cd igs_ca_inst.alternate_code%TYPE
479:
480:
481: --Used to check if the student has the relevant program attempt
482: CURSOR c_stdnt_ps_att (cp_person_id igs_pe_person.person_id%TYPE,
483: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
484: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
485: SELECT course_attempt_status, primary_program_type FROM igs_en_stdnt_ps_att
486: WHERE person_id = cp_person_id
487: AND course_cd = cp_program_cd
488: AND version_number= cp_program_ver_num;
489:
490: --Checks if the student has already attempted the specified uoo
491: CURSOR c_sua_exists (cp_person_id igs_pe_person.person_id%TYPE,
492: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
493: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
494: SELECT 'Y' FROM igs_en_su_attempt
495: WHERE person_id =cp_person_id
496: AND course_cd = cp_program_cd