2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
2700: cp_n_ci_seq_num IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE) IS
2701: SELECT delete_flag
2702: FROM igs_ps_unit_ofr_pat_all
2703: WHERE unit_cd = cp_c_unit_cd AND
2704: version_number = cp_n_ver_num AND
2705: cal_type = cp_c_cal_type AND
2706: ci_sequence_number = cp_n_ci_seq_num;
2837: END IF;
2838:
2839: IF ( p_usec_rec.status = 'S' ) THEN
2840: IF l_b_uop_deleted THEN
2841: UPDATE igs_ps_unit_ofr_pat_all
2842: SET
2843: waitlist_allowed = p_usec_rec.waitlist_allowed,
2844: max_students_per_waitlist = p_usec_rec.max_students_per_waitlist,
2845: delete_flag = 'N',
2857: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2858: ||p_usec_rec.teach_cal_alternate_code);
2859: END IF;
2860: ELSE
2861: INSERT INTO igs_ps_unit_ofr_pat_all
2862: (unit_cd,
2863: version_number,
2864: cal_type,
2865: ci_sequence_number,
5137: END check_insert_update;
5138:
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5138:
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd
5148: AND version_number = cp_n_ver_num
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,
5144: cp_n_seq_num IN igs_ps_unit_ofr_pat_all.ci_sequence_number%TYPE ) IS
5145: SELECT waitlist_allowed, max_students_per_waitlist
5146: FROM igs_ps_unit_ofr_pat_all
5147: WHERE unit_cd = cp_c_unit_cd
5148: AND version_number = cp_n_ver_num
5149: AND cal_type = cp_c_cal_type
5150: AND ci_sequence_number = cp_n_seq_num ;