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_SS_EN_WRAPPERS dependencies on IGS_EN_CPD_EXT

Line 4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,

4111: SELECT NVL(auditable_ind, 'N'), unit_cd, unit_class, NVL(audit_permission_ind, 'N')
4112: FROM igs_ps_unit_ofr_opt
4113: WHERE uoo_id = p_uoo_id;
4114:
4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,
4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,
4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS
4119: SELECT eru.stud_audit_lim

Line 4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,

4112: FROM igs_ps_unit_ofr_opt
4113: WHERE uoo_id = p_uoo_id;
4114:
4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,
4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,
4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS
4119: SELECT eru.stud_audit_lim
4120: FROM igs_en_cpd_ext eru, igs_lookups_view lkv

Line 4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,

4113: WHERE uoo_id = p_uoo_id;
4114:
4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,
4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,
4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS
4119: SELECT eru.stud_audit_lim
4120: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
4121: WHERE eru.s_enrolment_step_type =lkv.lookup_code

Line 4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS

4114:
4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,
4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,
4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS
4119: SELECT eru.stud_audit_lim
4120: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
4121: WHERE eru.s_enrolment_step_type =lkv.lookup_code
4122: AND lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'

Line 4120: FROM igs_en_cpd_ext eru, igs_lookups_view lkv

4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,
4117: cp_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
4118: cp_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE) IS
4119: SELECT eru.stud_audit_lim
4120: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
4121: WHERE eru.s_enrolment_step_type =lkv.lookup_code
4122: AND lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
4123: AND lkv.step_group_type = 'UNIT'
4124: AND eru.enrolment_cat = cp_enr_cat

Line 4145: l_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE;

4141: WHERE person_id = cp_person_id
4142: AND course_cd = cp_course_cd
4143: AND uoo_id = cp_uoo_id;
4144:
4145: l_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE;
4146: l_cur_per_typ cur_per_typ%ROWTYPE;
4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;
4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

Line 4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

4145: l_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE;
4146: l_cur_per_typ cur_per_typ%ROWTYPE;
4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;
4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;

Line 4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;

4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;
4162: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4163: l_stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE;
4164: l_crs_ver igs_en_stdnt_ps_att.version_number%TYPE;
4165: l_data cur_grading%ROWTYPE;

Line 4163: l_stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE;

4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;
4162: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4163: l_stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE;
4164: l_crs_ver igs_en_stdnt_ps_att.version_number%TYPE;
4165: l_data cur_grading%ROWTYPE;
4166: l_enrollment_category VARCHAR2(200);
4167: l_audit_sua NUMBER;