The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT unit_cd , version_number , uoo.cal_type ,
uoo.ci_sequence_number , location_cd , unit_class , start_dt ,
end_dt , uoo.row_id , uoo.ivrs_available_ind ,
uoo.call_number , uoo.unit_section_status , uoo.unit_section_start_date ,
uoo.unit_section_end_date , uoo.enrollment_actual , uoo.waitlist_actual ,
uoo.offered_ind , uoo.state_financial_aid , uoo.grading_schema_prcdnce_ind ,
uoo.federal_financial_aid , uoo.unit_quota , uoo.unit_quota_reserved_places ,
uoo.institutional_financial_aid , uoo.unit_contact , uoo.grading_schema_cd ,
uoo.gs_version_number , uoo.owner_org_unit_cd , uoo.attendance_required_ind ,
uoo.reserved_seating_allowed , uoo.special_permission_ind , uoo.ss_display_ind ,
uoo.ss_enrol_ind , uoo.dir_enrollment , uoo.enr_from_wlst ,
uoo.inq_not_wlst , uoo.anon_unit_grading_ind , uoo.anon_assess_grading_ind ,
uoo.rev_account_cd , uoo.non_std_usec_ind , uoo.auditable_ind ,
uoo.audit_permission_ind
FROM igs_ps_unit_ofr_opt uoo, igs_ca_inst ci
WHERE uoo.cal_type = ci.cal_type
AND uoo.ci_sequence_number = ci.sequence_number
AND uoo_id = cp_uoo_id ;
SELECT party_id
FROM hz_parties
WHERE party_number = cp_person_number ;
SELECT rowid , rsv_ext_id , uoo_id , priority_id ,
preference_id , rsv_level , actual_seat_enrolled , created_by ,
creation_date , last_updated_by , last_update_date , last_update_login
FROM igs_ps_rsv_ext
WHERE rsv_ext_id = cp_rsv_ext_id ;
SELECT su.*
FROM igs_en_su_attempt_all su
WHERE su.rowid = cp_rowid ;
SELECT person_type_code
FROM igs_pe_person_types
WHERE system_type = 'OTHER';
SELECT system_type
FROM igs_pe_person_types
WHERE person_type_code = cp_person_type_code;
igs_en_su_attempt_pkg.insert_row (
X_ROWID => l_rowid ,
X_PERSON_ID => l_person_id ,
X_COURSE_CD => p_course_cd ,
X_UNIT_CD => l_c_igs_ps_unit_ofr_opt.unit_cd ,
X_CAL_TYPE => l_c_igs_ps_unit_ofr_opt.cal_type ,
X_CI_SEQUENCE_NUMBER => l_c_igs_ps_unit_ofr_opt.ci_sequence_number ,
X_VERSION_NUMBER => l_c_igs_ps_unit_ofr_opt.version_number ,
X_LOCATION_CD => l_c_igs_ps_unit_ofr_opt.location_cd ,
X_UNIT_CLASS => l_c_igs_ps_unit_ofr_opt.unit_class ,
X_CI_START_DT => l_c_igs_ps_unit_ofr_opt.start_dt ,
X_CI_END_DT => l_c_igs_ps_unit_ofr_opt.end_dt ,
X_UOO_ID => p_uoo_id ,
X_ENROLLED_DT => NULL ,
X_UNIT_ATTEMPT_STATUS => l_cst_unconfirm ,
X_ADMINISTRATIVE_UNIT_STATUS => NULL ,
X_DISCONTINUED_DT => NULL ,
X_RULE_WAIVED_DT => NULL ,
X_RULE_WAIVED_PERSON_ID => NULL ,
X_NO_ASSESSMENT_IND => NVL(p_audit_requested,'N') , -- value passed to indicate that audit is requeted or not
X_SUP_UNIT_CD => NULL ,
X_SUP_VERSION_NUMBER => NULL ,
X_EXAM_LOCATION_CD => NULL ,
X_ALTERNATIVE_TITLE => p_subtitle ,
X_OVERRIDE_ENROLLED_CP => p_override_cp ,
X_OVERRIDE_EFTSU => NULL ,
X_OVERRIDE_ACHIEVABLE_CP => l_override_achievable_cp , -- selective values passed based on whether audit is requeted or not
X_OVERRIDE_OUTCOME_DUE_DT => NULL ,
X_OVERRIDE_CREDIT_REASON => NULL ,
X_ADMINISTRATIVE_PRIORITY => NULL ,
X_WAITLIST_DT => NULL ,
X_DCNT_REASON_CD => NULL ,
X_MODE => 'R' ,
X_ORG_ID => TO_NUMBER(FND_PROFILE.VALUE('ORG_ID')) ,
X_GS_VERSION_NUMBER => p_gs_version_num ,
X_ENR_METHOD_TYPE => p_enr_method_type ,
X_FAILED_UNIT_RULE => NULL ,
X_CART => NULL ,
X_RSV_SEAT_EXT_ID => NULL ,
X_ORG_UNIT_CD => NULL ,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => p_session_id,
-- Added the column grading schema as a part pf the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => p_gradsch_cd ,
--Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208) - pradhakr
X_DEG_AUD_DETAIL_ID => NULL,
X_STUDENT_CAREER_TRANSCRIPT => NULL ,
X_STUDENT_CAREER_STATISTICS => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ATTRIBUTE16 => NULL,
X_ATTRIBUTE17 => NULL,
X_ATTRIBUTE18 => NULL,
X_ATTRIBUTE19 => NULL,
X_ATTRIBUTE20 => NULL,
X_WAITLIST_MANUAL_IND => 'N', --Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
X_WLST_PRIORITY_WEIGHT_NUM => NULL,
X_WLST_PREFERENCE_WEIGHT_NUM => NULL,
X_CORE_INDICATOR_CODE => p_core_indicator_code,
X_UPD_AUDIT_FLAG => 'N',
X_SS_SOURCE_IND => l_ss_src_ind
);
igs_en_su_attempt_pkg.update_row (
X_ROWID => l_rowid ,
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 => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_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 pf the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
--Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
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 Mini Waitlist Build.,
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,
X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
) ;
igs_en_sua_api.upd_enrollment_counts('UPDATE',
old_references,
new_references);
igs_en_su_attempt_pkg.update_row (
X_ROWID => l_rowid ,
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_cst_waitlisted ,
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 => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
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 => 'N' ,
X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_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 pf the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
--Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
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 Mini Waitlist Build.
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,
X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
) ;
igs_en_sua_api.upd_enrollment_counts( 'UPDATE',
old_references,
new_references);
igs_ps_rsv_ext_pkg.update_row(
x_rowid => l_c_igs_ps_rsv_ext.rowid ,
x_rsv_ext_id => l_c_igs_ps_rsv_ext.rsv_ext_id ,
x_uoo_id => l_c_igs_ps_rsv_ext.uoo_id ,
x_priority_id => l_c_igs_ps_rsv_ext.priority_id ,
x_preference_id => l_c_igs_ps_rsv_ext.preference_id ,
x_rsv_level => l_c_igs_ps_rsv_ext.rsv_level ,
x_actual_seat_enrolled => NVL(l_c_igs_ps_rsv_ext.actual_seat_enrolled,0) - 1 ,
x_mode => 'R'
);