The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = p_person_type_code;
SELECT sua.no_assessment_ind,
sua.unit_attempt_status,
NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) credit_points
FROM igs_en_su_attempt sua,
igs_ps_unit_ver uv ,
igs_ps_usec_cps cps
WHERE sua.person_id = p_person_id
AND sua.course_cd = p_course_cd
AND sua.uoo_id = p_uoo_id
AND sua.unit_cd = uv.unit_cd
AND sua.version_number = uv.version_number
AND sua.uoo_id = cps.uoo_id(+);
SELECT NVL (usec.max_auditors_allowed, NVL(uv.max_auditors_allowed,999999) )
FROM igs_ps_usec_lim_wlst usec,
igs_ps_unit_ver uv,
igs_ps_unit_ofr_opt uoo
WHERE uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uoo.uoo_id = usec.uoo_id (+)
AND uoo.uoo_id = p_uoo_id;
SELECT COUNT(*)
FROM igs_en_su_attempt
WHERE uoo_id=p_uoo_id
AND no_assessment_ind = 'Y' -- For Audit TD Bug 2641864
AND (( p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') ) OR
(p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'));
SELECT 'x'
FROM igs_ps_usec_x_grpmem
WHERE uoo_id = l_uoo_id;
SELECT 'x'
FROM igs_ps_uso_clas_meet
WHERE uoo_id = l_uoo_id;
l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type,
eru.s_rule_call_cd,eru.rul_sequence_number,eru.stud_audit_lim
FROM igs_en_cpd_ext eru, igs_lookups_view lkv
WHERE eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type =
''UNIT'' AND eru.enrolment_cat = :1 AND eru.enr_method_type = :2
AND ( eru.s_student_comm_type = :3 OR eru.s_student_comm_type = ''ALL'')
ORDER BY eru.step_order_num';
l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type,
eru.s_rule_call_cd,eru.rul_sequence_number,eru.stud_audit_lim
FROM igs_en_cpd_ext eru, igs_pe_usr_aval uact, igs_lookups_view lkv
WHERE eru.s_enrolment_step_type =lkv.lookup_code AND
lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type = ''UNIT'' AND
eru.s_enrolment_step_type = uact.validation(+) AND
uact.person_type(+) = :1 AND NVL(uact.override_ind,''N'') = ''N'' AND
eru.enrolment_cat = :2 AND eru.enr_method_type = :3
AND ( eru.s_student_comm_type = :4 OR eru.s_student_comm_type = ''ALL'')
ORDER BY eru.step_order_num';
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = p_person_type_code;
SELECT ss_enrol_ind,unit_class,unit_cd
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT unit_cd,version_number, unit_class
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT uoo.location_cd
FROM igs_ps_ofr_opt coo,
igs_ps_unit_ofr_opt uoo
WHERE coo.coo_id = p_coo_id AND
uoo.uoo_id = p_uoo_id AND
uoo.location_cd = coo.location_cd;
SELECT location_cd
FROM igs_ps_ofr_opt
WHERE coo_id = p_coo_id;
SELECT location_cd, unit_cd, unit_class
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT unit_class,unit_cd
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT attendance_mode
FROM igs_ps_ofr_opt
WHERE coo_id = p_coo_id;
SELECT unit_cd,
unit_class,
version_number,
cal_type,
ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT include_adv_standing_units,max_repeats_for_credit,max_repeats_for_funding,rp.org_unit_id
FROM igs_en_rep_process rp , igs_or_unit ou
WHERE ou.org_unit_cd = cp_org_unit_cd
AND ou.party_id = rp.org_unit_id
AND rp.org_unit_id IS NOT NULL
UNION
SELECT include_adv_standing_units,max_repeats_for_credit,max_repeats_for_funding,org_unit_id
FROM igs_en_rep_process
WHERE org_unit_id IS NULL
ORDER BY org_unit_id;
SELECT sua.unit_cd,
sua.version_number,
sua.cal_type,
sua.ci_sequence_number,
sua.uoo_id,
sua.override_enrolled_cp ,
sua.course_cd
FROM igs_en_su_attempt sua, igs_ps_unit_ver psv
WHERE sua.person_id = p_person_id
AND ( sua.cart IS NOT NULL AND ( p_calling_obj <> 'SWAP' OR (p_calling_obj = 'SWAP' AND sua.uoo_id <> p_uoo_id) ) )
AND ((p_calling_obj <> 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM') )
OR (p_calling_obj = 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM','PLANNED') )
OR (sua.unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
AND sua.unit_cd = psv.unit_cd
AND sua.version_number = psv.version_number
AND ( ( sua.unit_cd = cp_unit_cd AND sua.version_number = cp_version_number)
OR psv.rpt_fmly_id = ( SELECT psu.rpt_fmly_id
FROM igs_ps_unit_ver psu,
igs_ps_rpt_fmly rep
WHERE psu.unit_cd = cp_unit_cd
AND psu.version_number = cp_version_number
AND psu.rpt_fmly_id = rep.rpt_fmly_id
AND NVL(rep.closed_ind,'N') = 'N' )
)
UNION
SELECT adv.unit_cd,
adv.version_number,
NULL cal_type,
TO_NUMBER(NULL) ci_sequence_number,
TO_NUMBER(NULL) uoo_id,
adv.achievable_credit_points override_enrolled_cp ,
adv.as_course_cd course_cd
FROM igs_av_stnd_unit adv, igs_ps_unit_ver psv
WHERE adv.person_id = p_person_id
AND adv.s_adv_stnd_granting_status = 'GRANTED'
AND (adv.s_adv_stnd_recognition_type = 'CREDIT'
AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )
AND cp_include_in_adv_stand = 'Y'
AND adv.unit_cd = psv.unit_cd
AND adv.version_number = psv.version_number
AND ( ( adv.unit_cd = cp_unit_cd AND adv.version_number = cp_version_number )
OR psv.rpt_fmly_id = (SELECT psu.rpt_fmly_id
FROM igs_ps_unit_ver psu,
igs_ps_rpt_fmly rep
WHERE psu.unit_cd = cp_unit_cd
AND psu.version_number = cp_version_number
AND psu.rpt_fmly_id = rep.rpt_fmly_id
AND NVL(rep.closed_ind,'N') = 'N')
);
SELECT repeatable_ind,max_repeats_for_credit, max_repeats_for_funding
FROM igs_ps_unit_ver
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number;
SELECT NVL (usec.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
FROM igs_ps_unit_ofr_opt usec,
igs_ps_unit_ver uv
WHERE usec.uoo_id = p_uoo_id
AND usec.unit_cd = uv.unit_cd
AND usec.version_number = uv.version_number
AND p_uoo_id IS NOT NULL
UNION
SELECT uv.owner_org_unit_cd
FROM igs_ps_unit_ver uv
WHERE uv.unit_cd = p_unit_cd
AND uv.version_number = p_unit_version
AND p_uoo_id IS NULL;
SELECT unit_cd,
unit_class,
version_number,
cal_type,
ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT sua.unit_cd,
sua.version_number,
sua.cal_type,
sua.ci_sequence_number,
sua.uoo_id,
NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) override_enrolled_cp ,
sua.course_cd
FROM igs_en_su_attempt sua,
igs_ps_unit_ver uv,
igs_ps_usec_cps cps
WHERE sua.person_id = p_person_id
AND sua.unit_cd = uv.unit_cd
AND sua.version_number = uv.version_number
AND sua.unit_cd = cp_unit_cd
AND sua.version_number = cp_version_number
AND sua.uoo_id = cps.uoo_id(+)
AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM') )
OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM','PLANNED') )
OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
AND ( sua.cart IS NOT NULL AND ( p_calling_obj <> 'SWAP' OR (p_calling_obj = 'SWAP' AND sua.uoo_id <> p_uoo_id) ) )
UNION
SELECT adv.unit_cd,
adv.version_number,
NULL cal_type,
TO_NUMBER(NULL) ci_sequence_number,
TO_NUMBER(NULL) uoo_id,
adv.achievable_credit_points override_enrolled_cp ,
adv.as_course_cd course_cd
FROM igs_av_stnd_unit adv
WHERE adv.person_id = p_person_id
AND adv.s_adv_stnd_granting_status = 'GRANTED'
AND (adv.s_adv_stnd_recognition_type = 'CREDIT'
AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )
AND adv.unit_cd = cp_unit_cd
AND adv.version_number = cp_version_number;
SELECT not_multiple_section_flag
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT repeatable_ind,same_teach_period_repeats,same_teach_period_repeats_cp,
max_repeats_for_credit,max_repeat_credit_points, same_teaching_period
FROM igs_ps_unit_ver
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number;
SELECT uocr.monday ,
uocr.tuesday ,
uocr.wednesday,
uocr.thursday,
uocr.friday ,
uocr.saturday ,
uocr.sunday ,
uocr.start_time start_time,
uocr.end_time end_time,
uoo.unit_cd,
uoo.unit_class,
NVL (uocr.start_date, NVL (uoo.unit_section_start_date, ci.start_dt)) start_date,
NVL (uocr.end_date, NVL (uoo.unit_section_end_date, ci.end_dt)) end_date
FROM igs_ps_usec_occurs uocr,
igs_ps_unit_ofr_opt uoo,
igs_ca_inst ci
WHERE uoo.uoo_id = cp_uoo_id
AND uoo.uoo_id = uocr.uoo_id
AND uoo.cal_type = ci.cal_type
AND uoo.ci_sequence_number = ci.sequence_number;
SELECT uocur.uoo_id,
uocur.monday,
uocur.tuesday,
uocur.wednesday,
uocur.thursday,
uocur.friday,
uocur.saturday,
uocur.sunday,
uocur.start_time,
uocur.end_time,
uoo.unit_cd,
uoo.unit_class,
NVL (uocur.start_date, NVL (uoo.unit_section_start_date, lt.start_dt)) start_date,
NVL (uocur.end_date, NVL (uoo.unit_section_end_date, lt.end_dt)) end_date
FROM igs_ps_usec_occurs uocur,
igs_en_su_attempt_all ua,
igs_ca_inst lt,
igs_ps_unit_ofr_opt_all uoo
WHERE uocur.uoo_id = ua.uoo_id
AND uoo.uoo_id = ua.uoo_id
AND ua.uoo_id <> p_uoo_id
AND ua.cal_type = lt.cal_type
AND ua.ci_sequence_number = lt.sequence_number
AND ua.person_id = p_person_id
AND (
( p_calling_obj <>'PLAN' AND
( ua.unit_attempt_status IN ( 'ENROLLED','INVALID') OR
( ua.unit_attempt_status = 'WAITLISTED' AND
( EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS WHERE TIME_CONFL_ALWD_WLST_FLAG = 'N' ) OR
( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )
)
)
)
)
OR
( p_calling_obj ='PLAN' AND
(ua.unit_attempt_status IN ( 'ENROLLED','INVALID','PLANNED') OR
(ua.unit_attempt_status = 'WAITLISTED' AND (EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS WHERE TIME_CONFL_ALWD_WLST_FLAG = 'N') ) OR
( NOT EXISTS(SELECT 'X' FROM IGS_EN_INST_WL_STPS ) AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y' )
)
)
)
);
SELECT rul_sequence_number
FROM igs_ps_usec_ru
WHERE uoo_id = p_uoo_id AND
s_rule_call_cd = 'USECPREREQ';
SELECT rul_sequence_number
FROM igs_ps_unit_ver_ru uvr,
igs_ps_unit_ofr_opt uoo
WHERE uvr.unit_cd = uoo.unit_cd AND
uvr.version_number = uoo.version_number AND
uoo_id = p_uoo_id AND
uvr.s_rule_call_cd = 'PREREQ';
SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT rul_sequence_number
FROM igs_ps_usec_ru
WHERE uoo_id = p_uoo_id AND
s_rule_call_cd = 'USECCOREQ';
SELECT rul_sequence_number
FROM igs_ps_unit_ver_ru uvr,
igs_ps_unit_ofr_opt uoo
WHERE uvr.unit_cd = uoo.unit_cd AND
uvr.version_number = uoo.version_number AND
uoo_id = p_uoo_id AND
uvr.s_rule_call_cd = 'COREQ';
SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT rul_sequence_number
FROM igs_ps_unit_ver_ru uvr,
igs_ps_unit_ofr_opt uoo
WHERE uvr.unit_cd = uoo.unit_cd AND
uvr.version_number = uoo.version_number AND
uoo_id = p_uoo_id AND
uvr.s_rule_call_cd = 'INCOMP';
SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT special_permission_ind
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT approval_status
FROM igs_en_spl_perm
WHERE student_person_id = p_person_id AND
uoo_id =p_uoo_id AND
request_type = 'SPL_PERM' AND
approval_status = 'A';
SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number,owner_org_unit_cd , reserved_seating_allowed
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT priority_value, rsv_usec_pri_id priority_id
FROM igs_ps_rsv_usec_pri
WHERE uoo_id = p_uoo_id
ORDER BY priority_order;
SELECT preference_code,preference_version,group_id,percentage_reserved, rsv_usec_prf_id preference_id
FROM igs_ps_rsv_usec_prf
WHERE rsv_usec_pri_id = p_rsv_usec_pri_id
ORDER BY preference_order;
SELECT priority_value, rsv_uop_pri_id priority_id
FROM igs_ps_rsv_uop_pri
WHERE unit_cd = p_unit_cd AND
version_number = p_version_number AND
calender_type = p_cal_type AND
ci_sequence_number = p_ci_sequence_number
ORDER BY priority_order;
SELECT preference_code,preference_version,group_id,percentage_reserved, rsv_uop_prf_id preference_id
FROM igs_ps_rsv_uop_prf
WHERE rsv_uop_pri_id = p_rsv_uop_pri_id
ORDER BY preference_order;
SELECT priority_value, rsv_org_unit_pri_id priority_id
FROM igs_ps_rsv_ogpri
WHERE org_unit_cd = p_org_unit_cd
ORDER BY priority_order;
SELECT preference_code,preference_version,group_id,percentage_reserved, rsv_org_unit_prf_id preference_id
FROM igs_ps_rsv_orgun_prf
WHERE rsv_org_unit_pri_id = p_rsv_org_unit_pri_id
ORDER BY preference_order;
SELECT 'X'
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
version_number = p_version_number;
SELECT 'X'
FROM igs_en_stdnt_ps_att sca,
igs_ps_ver pv
WHERE sca.person_id = p_person_id AND
sca.course_cd = pv.course_cd AND
sca.version_number = pv.version_number AND
pv.responsible_org_unit_cd = p_org_unit_cd;
SELECT 'X'
FROM igs_en_stdnt_ps_att spa,
igs_as_su_setatmpt sus
WHERE spa.person_id = p_person_id AND
sus.person_id = spa.person_id AND
spa.course_cd = sus.course_cd AND
sus.unit_set_cd = p_unit_set_cd AND
sus.us_version_number = p_us_version_number;
SELECT 'X'
FROM igs_pe_prsid_grp_mem pgm
WHERE pgm.person_id = p_person_id AND
pgm.group_id = p_group_id ;
| igs_en_sua_api.update_unit_attempt as part of Waitlist |
| Enhancements Build - Bug# 3052426
|rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
| added as part of Prevent Dropping Core Units. Enh Bug# 3052432
+---------------------------------------------------------------------------------*/
-- cursor to get the enrollment maximum defined at unit section level
CURSOR cur_usec_enr_max IS
SELECT enrollment_maximum
FROM igs_ps_usec_lim_wlst
WHERE uoo_id = p_uoo_id;
SELECT enrollment_maximum
FROM igs_ps_unit_ver uv,
igs_ps_unit_ofr_opt uoo
WHERE uoo.uoo_id = p_uoo_id AND -- p_uoo_id is parameter of container function
uv.unit_cd = uoo.unit_cd AND
uv.version_number = uoo.version_number;
SELECT rsve.ROWID, rsve.*
FROM igs_ps_rsv_ext rsve
WHERE rsve.priority_id = p_priority_id AND
rsve.preference_id = p_preference_id AND
rsve.rsv_level = p_rsv_level AND
rsve.uoo_id = p_uoo_id
FOR UPDATE ; -- p_uoo_id is parameter of container function
SELECT *
FROM igs_en_su_attempt
WHERE person_id = cp_person_id
AND uoo_id = cp_uoo_id
AND course_cd = cp_course_cd ;
igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,
x_rsv_ext_id => cur_rsv_ext_rec.rsv_ext_id,
x_uoo_id => cur_rsv_ext_rec.uoo_id,
x_priority_id => cur_rsv_ext_rec.priority_id,
x_preference_id => cur_rsv_ext_rec.preference_id ,
x_rsv_level => cur_rsv_ext_rec.rsv_level ,
x_actual_seat_enrolled => cur_rsv_ext_rec.actual_seat_enrolled + 1,
x_mode => 'R' );
ELSE -- record is not exist against given priority/preference, so inserting a new record
igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,
x_rsv_ext_id => l_rsv_ext_id,
x_uoo_id => p_uoo_id,
x_priority_id => p_priority_id,
x_preference_id => p_preference_id ,
x_rsv_level => p_rsv_level ,
x_actual_seat_enrolled => 1,
x_mode => 'R');
IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
X_ROWID => l_c_igs_en_su_attempt.row_id ,
X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
X_MODE => 'R' ,
X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
X_CART => l_c_igs_en_su_attempt.cart ,
X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
-- Added the column grading schema as a part of the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
) ;
igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,
x_rsv_ext_id => cur_rsv_ext_rec.rsv_ext_id,
x_uoo_id => cur_rsv_ext_rec.uoo_id,
x_priority_id => cur_rsv_ext_rec.priority_id,
x_preference_id => cur_rsv_ext_rec.preference_id ,
x_rsv_level => cur_rsv_ext_rec.rsv_level ,
x_actual_seat_enrolled => cur_rsv_ext_rec.actual_seat_enrolled + 1,
x_mode => 'R' );
ELSE -- record is not exist against given priority/preference, so inserting a new record
IF 1 > l_resereved_max THEN
--
-- no seat available under the given priority/ preference
CLOSE cur_rsv_ext;
igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,
x_rsv_ext_id => l_rsv_ext_id,
x_uoo_id => p_uoo_id,
x_priority_id => p_priority_id,
x_preference_id => p_preference_id ,
x_rsv_level => p_rsv_level ,
x_actual_seat_enrolled => 1,
x_mode => 'R');
IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
X_ROWID => l_c_igs_en_su_attempt.row_id ,
X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
X_MODE => 'R' ,
X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
X_CART => l_c_igs_en_su_attempt.cart ,
X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
-- Added the column grading schema as a part of the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
) ;
SELECT cal_type, ci_sequence_number, unit_cd, unit_class
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT sci.intermission_type,
sci.start_dt,
sci.approved
FROM igs_en_stdnt_ps_intm sci,
IGS_EN_INTM_TYPES eit,
igs_en_stdnt_ps_att spa
WHERE sci.person_id = cp_person_id
AND sci.course_cd = cp_program_cd
AND sci.approved = eit.appr_reqd_ind
AND eit.intermission_type = sci.intermission_type
AND sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
AND spa.person_id = sci.person_id
AND spa.course_cd = sci.course_cd
AND ((trunc(sysdate) between sci.start_dt and sci.end_dt)
OR
((trunc(sysdate) > sci.end_dt) AND (spa.course_attempt_status = 'INTERMIT'))
);
SELECT cal_type,
ci_sequence_number,unit_cd,unit_class
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT visa_type,
visa_number
FROM igs_pe_visa
WHERE person_id = cp_person_id;
SELECT 'x'
FROM Igs_En_Spl_Perm
WHERE student_person_id = p_person_id
AND uoo_id = p_uoo_id
AND request_type = 'AUDIT_PERM'
AND approval_status = 'A';
SELECT NVL(auditable_ind, 'N')
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT NVL(audit_permission_ind, 'N')
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT count(*)
FROM igs_en_su_attempt
WHERE person_id = p_person_id
AND no_assessment_ind = 'Y'
AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') )
OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
AND (cal_type,ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
FROM igs_ca_load_to_teach_v
WHERE load_cal_type = p_load_cal_type AND
load_ci_sequence_number = p_load_sequence_number);
SELECT unit_cd,unit_class
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = cp_person_type_code;
SELECT 'X'
FROM IGS_PE_USR_AVAL
WHERE PERSON_TYPE = cp_person_type_code
AND validation = 'AWD_CRS_ONLY'
AND OVERRIDE_IND = 'Y';
select NVL(AWARD_COURSE_IND,'N')
from igs_ps_type ct, igs_ps_ver cv
where cv.course_cd = p_course_Cd
and cv.version_number = p_course_version
and cv.course_type = ct.course_type;
SELECT NVL(AWARD_COURSE_ONLY_IND,'N')
FROM igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo
where uv.unit_cd = uoo.unit_cd
and uv.version_number = uoo.version_number
and uoo.uoo_id = p_uoo_id;