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_GEN_015 dependencies on IGS_EN_CAT_PRC_DTL

Line 2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;

2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

Line 2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;

2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 2322: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,

2318: WHERE person_type_code = cp_person_type;
2319:
2320:
2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2322: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2323: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2324: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2325: ) IS
2326: SELECT

Line 2323: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,

2319:
2320:
2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2322: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2323: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2324: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2325: ) IS
2326: SELECT
2327: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant

Line 2324: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE

2320:
2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2322: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2323: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2324: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2325: ) IS
2326: SELECT
2327: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2328: FROM

Line 2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,

2339: ORDER BY eru.step_order_num;
2340:
2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,
2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2346: ) IS
2347: SELECT

Line 2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,

2340:
2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,
2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2346: ) IS
2347: SELECT
2348: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant

Line 2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE

2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,
2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2346: ) IS
2347: SELECT
2348: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2349: FROM