DBA Data[Home] [Help]

APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_CA_INST

Line 88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

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,

Line 89: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%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,

Line 90: p_load_cal_type IN igs_ca_inst.cal_type%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,
94: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,

Line 91: p_load_sequence_number IN igs_ca_inst.sequence_number%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,

Line 666: p_acad_cal_type IN igs_ca_inst.cal_type%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,

Line 667: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%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,

Line 668: p_load_cal_type IN igs_ca_inst.cal_type%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,
672: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,

Line 669: p_load_sequence_number IN igs_ca_inst.sequence_number%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,

Line 926: p_load_cal_type IN igs_ca_inst.cal_type%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,

Line 927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,

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

Line 1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,

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,

Line 1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%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,

Line 1298: l_alternate_code igs_ca_inst.alternate_code%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;

Line 1299: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

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:

Line 1300: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

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;

Line 1305: l_enr_cal_type IGS_CA_INST.cal_type%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:

Line 1306: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;

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);