84: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
85: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
86: p_start_uoo_id IN NUMBER,
87: p_drop_alluoo_ids IN VARCHAR2,
88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
89: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
90: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
91: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
92: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
85: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
86: p_start_uoo_id IN NUMBER,
87: p_drop_alluoo_ids IN VARCHAR2,
88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
89: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
90: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
91: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
92: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
93: p_enr_comm IN VARCHAR2,
86: p_start_uoo_id IN NUMBER,
87: p_drop_alluoo_ids IN VARCHAR2,
88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
89: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
90: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
91: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
92: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
93: p_enr_comm IN VARCHAR2,
94: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
87: p_drop_alluoo_ids IN VARCHAR2,
88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
89: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
90: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
91: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
92: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
93: p_enr_comm IN VARCHAR2,
94: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
95: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,
662: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
663: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
664: p_start_uoo_id IN NUMBER,
665: p_drop_uoo_ids IN VARCHAR2,
666: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
667: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
668: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
670: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
663: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
664: p_start_uoo_id IN NUMBER,
665: p_drop_uoo_ids IN VARCHAR2,
666: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
667: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
668: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
670: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
671: p_enr_comm IN VARCHAR2,
664: p_start_uoo_id IN NUMBER,
665: p_drop_uoo_ids IN VARCHAR2,
666: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
667: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
668: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
670: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
671: p_enr_comm IN VARCHAR2,
672: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
665: p_drop_uoo_ids IN VARCHAR2,
666: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
667: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
668: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
670: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
671: p_enr_comm IN VARCHAR2,
672: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
673: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,
922: PROCEDURE reorder_drop_units(
923: p_person_id IN igs_en_su_attempt.person_id%TYPE,
924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
926: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
928: p_selected_uoo_ids IN VARCHAR2,
929: p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,
930: p_ret_sub_uoo_ids OUT NOCOPY VARCHAR2,
923: p_person_id IN igs_en_su_attempt.person_id%TYPE,
924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
926: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
928: p_selected_uoo_ids IN VARCHAR2,
929: p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,
930: p_ret_sub_uoo_ids OUT NOCOPY VARCHAR2,
931: p_ret_nonsub_uoo_ids OUT NOCOPY VARCHAR2
1072:
1073: PROCEDURE create_ss_warning (
1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1073: PROCEDURE create_ss_warning (
1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1294:
1295:
1296: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
1297:
1298: l_alternate_code igs_ca_inst.alternate_code%TYPE;
1299: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1300: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1301: l_acad_start_dt DATE;
1302: l_acad_end_dt DATE;
1295:
1296: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
1297:
1298: l_alternate_code igs_ca_inst.alternate_code%TYPE;
1299: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1300: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1301: l_acad_start_dt DATE;
1302: l_acad_end_dt DATE;
1303:
1296: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
1297:
1298: l_alternate_code igs_ca_inst.alternate_code%TYPE;
1299: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1300: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1301: l_acad_start_dt DATE;
1302: l_acad_end_dt DATE;
1303:
1304: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
1301: l_acad_start_dt DATE;
1302: l_acad_end_dt DATE;
1303:
1304: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
1305: l_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1306: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;
1307: l_enr_categories VARCHAR2(255);
1308: l_enr_comm VARCHAR2(1000);
1309:
1302: l_acad_end_dt DATE;
1303:
1304: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
1305: l_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1306: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;
1307: l_enr_categories VARCHAR2(255);
1308: l_enr_comm VARCHAR2(1000);
1309:
1310: l_deny_warn_min_cp VARCHAR2(10);