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_006 dependencies on IGS_EN_STDNT_PS_ATT

Line 257: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;

253: NO_SECC_RECORD_FOUND EXCEPTION;
254: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
255: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
256: v_daiv_rec_found BOOLEAN;
257: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;
258: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
259: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
260: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
261: v_period_credit_points NUMBER;

Line 267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;
264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS
269: SELECT SCA.cal_type
270: FROM IGS_EN_STDNT_PS_ATT SCA
271: WHERE SCA.person_id = cp_person_id AND

Line 268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS

264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS
269: SELECT SCA.cal_type
270: FROM IGS_EN_STDNT_PS_ATT SCA
271: WHERE SCA.person_id = cp_person_id AND
272: SCA.course_cd = cp_course_cd;

Line 270: FROM IGS_EN_STDNT_PS_ATT SCA

266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS
269: SELECT SCA.cal_type
270: FROM IGS_EN_STDNT_PS_ATT SCA
271: WHERE SCA.person_id = cp_person_id AND
272: SCA.course_cd = cp_course_cd;
273: CURSOR c_s_enr_cal_conf IS
274: SELECT SECC.load_effect_dt_alias

Line 582: -- * A IGS_EN_STDNT_PS_ATT record exists with a course_attempt_status of

578: -- pending and it is not a requirement for it to be satisfied on
579: -- confirmation.
580: -- * Student has research IGS_RE_CANDIDATURE details if the IGS_PS_COURSE attempt is
581: -- defined as a research IGS_PS_COURSE.
582: -- * A IGS_EN_STDNT_PS_ATT record exists with a course_attempt_status of
583: -- INTERMIT and student_intermission record exists with an end_dt within the
584: -- academic period.
585: --
586: -- The routine will return TRUE if the student is eligible to enrol/re-enrol,

Line 608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;

604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status
608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;
609: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
610:
611: v_valid_enrolment BOOLEAN;
612: v_daiv_rec_found BOOLEAN;

Line 609: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status
608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;
609: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
610:
611: v_valid_enrolment BOOLEAN;
612: v_daiv_rec_found BOOLEAN;
613: v_valid_pre_sysdate BOOLEAN;

Line 622: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;

618:
619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;
620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
621: v_cndtnl_off_must_be_stsfd_ind IGS_AD_PS_APPL_INST_APLINST_V.cndtnl_offer_must_be_stsfd_ind%TYPE;
622: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
623: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
624: v_cop_offered_ind IGS_PS_OFR_PAT.offered_ind%TYPE;
625: v_s_adm_cndtnl_offer_status IGS_LOOKUPS_view.lookup_code%TYPE DEFAULT NULL;
626:

Line 623: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;

619: v_acaiv_offer_dt IGS_AD_PS_APPL_INST_APLINST_V.offer_dt%TYPE DEFAULT NULL;
620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
621: v_cndtnl_off_must_be_stsfd_ind IGS_AD_PS_APPL_INST_APLINST_V.cndtnl_offer_must_be_stsfd_ind%TYPE;
622: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
623: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
624: v_cop_offered_ind IGS_PS_OFR_PAT.offered_ind%TYPE;
625: v_s_adm_cndtnl_offer_status IGS_LOOKUPS_view.lookup_code%TYPE DEFAULT NULL;
626:
627: --modified cursor for performance bug 4968380

Line 690: FROM IGS_EN_STDNT_PS_ATT sca

686: SELECT sca.course_attempt_status,
687: sca.discontinued_dt,
688: sca.lapsed_dt,
689: sca.version_number
690: FROM IGS_EN_STDNT_PS_ATT sca
691: WHERE sca.person_id = p_person_id AND
692: sca.course_cd = p_course_cd;
693:
694: CURSOR c_cop(

Line 1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1205: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1206: cst_intermit CONSTANT VARCHAR2(10) := 'INTERMIT';
1207: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1208: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

Line 1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

1206: cst_intermit CONSTANT VARCHAR2(10) := 'INTERMIT';
1207: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1208: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;

Line 1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;

1207: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1208: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;

Line 1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;

1208: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

1209: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;

Line 1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;

1210: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
1218: v_exists_flag VARCHAR2(1);

Line 1226: FROM IGS_EN_STDNT_PS_ATT sca

1222: sca.discontinued_dt,
1223: sca.lapsed_dt,
1224: sca.course_rqrmnt_complete_ind,
1225: sca.logical_delete_dt
1226: FROM IGS_EN_STDNT_PS_ATT sca
1227: WHERE sca.person_id = p_person_id AND
1228: sca.course_cd = p_course_cd;
1229: CURSOR c_sua IS
1230: SELECT 'x'