eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_CA_INST

Line 676: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

672: l_person_type igs_pe_person_types.person_type_code%TYPE;
673: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
674: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
675: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
676: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
677: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
678: l_step_override_limit NUMBER;
679: l_message VARCHAR2(100);
680: l_ret_status VARCHAR2(10);

Line 677: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

673: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
674: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
675: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
676: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
677: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
678: l_step_override_limit NUMBER;
679: l_message VARCHAR2(100);
680: l_ret_status VARCHAR2(10);
681: l_en_cal_type igs_ca_inst.cal_type%TYPE;

Line 681: l_en_cal_type igs_ca_inst.cal_type%TYPE;

677: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
678: l_step_override_limit NUMBER;
679: l_message VARCHAR2(100);
680: l_ret_status VARCHAR2(10);
681: l_en_cal_type igs_ca_inst.cal_type%TYPE;
682: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
683: l_dummy VARCHAR2(200);
684:
685: BEGIN

Line 682: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;

678: l_step_override_limit NUMBER;
679: l_message VARCHAR2(100);
680: l_ret_status VARCHAR2(10);
681: l_en_cal_type igs_ca_inst.cal_type%TYPE;
682: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
683: l_dummy VARCHAR2(200);
684:
685: BEGIN
686: IF NVL(fnd_profile.value('IGS_EN_CORE_VAL'),'N') = 'N' THEN

Line 953: l_alternate_code igs_ca_inst.alternate_code%TYPE;

949: l_end_index NUMBER;
950: -- l_sub VARCHAR2(1); -- indicate whether the current unit section is subordinate or not.
951:
952: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
953: l_alternate_code igs_ca_inst.alternate_code%TYPE;
954: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
955: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
956: l_acad_start_dt DATE;
957: l_acad_end_dt DATE;

Line 954: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

950: -- l_sub VARCHAR2(1); -- indicate whether the current unit section is subordinate or not.
951:
952: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
953: l_alternate_code igs_ca_inst.alternate_code%TYPE;
954: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
955: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
956: l_acad_start_dt DATE;
957: l_acad_end_dt DATE;
958:

Line 955: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

951:
952: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
953: l_alternate_code igs_ca_inst.alternate_code%TYPE;
954: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
955: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
956: l_acad_start_dt DATE;
957: l_acad_end_dt DATE;
958:
959: l_enr_cat igs_ps_type.enrolment_cat%TYPE;

Line 960: l_enr_cal_type IGS_CA_INST.cal_type%TYPE;

956: l_acad_start_dt DATE;
957: l_acad_end_dt DATE;
958:
959: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
960: l_enr_cal_type IGS_CA_INST.cal_type%TYPE;
961: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;
962: l_enr_categories VARCHAR2(255);
963: l_enr_comm VARCHAR2(1000);
964:

Line 961: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;

957: l_acad_end_dt DATE;
958:
959: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
960: l_enr_cal_type IGS_CA_INST.cal_type%TYPE;
961: l_enr_ci_seq IGS_CA_INST.sequence_number%TYPE;
962: l_enr_categories VARCHAR2(255);
963: l_enr_comm VARCHAR2(1000);
964:
965: l_deny_warn_min_cp VARCHAR2(10);

Line 1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1720: AND version_number = p_unit_ver_num;
1721:
1722: --Check if there exist any user level deadline
1723: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE,
1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1725: IS
1726: SELECT dai.alias_val alias_val
1727: FROM igs_ca_da_inst_v dai,igs_pe_usr_arg_all pua
1728: WHERE pua.person_type = cp_person_type

Line 1744: CURSOR cur_en_cal_conf(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1740: AND uoo_id = p_uoo_id
1741: ORDER BY 1;
1742:
1743: --Check if deadline has passed for cp change at institution level
1744: CURSOR cur_en_cal_conf(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1745: IS
1746: SELECT dai.alias_val alias_val
1747: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc
1748: WHERE dai.cal_type = cp_cal_type