[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT person_number , full_name , email_addr
FROM igs_pe_person
WHERE person_id = cp_person_id ;
SELECT uoo.unit_cd , uv.title , uoo.cal_type ,
ci.alternate_code , al.description location_desc ,
uoo.unit_class
FROM igs_ps_unit_ofr_opt uoo ,
igs_ad_location al ,
igs_ps_unit_ver uv ,
igs_ca_inst ci
WHERE uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uoo.cal_type = ci.cal_type
AND uoo.ci_sequence_number = ci.sequence_number
AND uoo.location_cd = al.location_cd
AND uoo.uoo_id = cp_uoo_id ;
SELECT igs_en_inform_stud_s.NEXTVAL INTO l_key FROM dual;
SELECT IGS_EN_WF_MAILSTUD_S.NEXTVAL INTO l_key FROM dual;
SELECT fnd.USER_ID from fnd_user fnd ,
igs_ps_usec_tch_resp ustr
WHERE
ustr.uoo_id = p_uoo_id AND
ustr.LEAD_INSTRUCTOR_FLAG='Y' AND
ustr.instructor_id = fnd.person_party_id ;
SELECT rg.responsibility_id,
rg.responsibility_application_id
FROM fnd_user_resp_groups rg, fnd_responsibility r
WHERE rg.user_id = cp_user_id
AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date,(SYSDATE+1))
AND r.responsibility_id = rg.responsibility_id
AND r.responsibility_key = 'IGS_SS_FACULTY';
SELECT
person_id,
course_cd,
administrative_priority,
waitlist_manual_ind,
wlst_priority_weight_num,
wlst_preference_weight_num
FROM
igs_en_su_attempt_all sua
WHERE
sua.uoo_id = cp_uoo_id
AND sua.waitlist_manual_ind = 'M'
AND sua.unit_attempt_status = 'WAITLISTED'
FOR UPDATE NOWAIT;
SELECT
person_id,
course_cd,
administrative_priority,
waitlist_manual_ind,
wlst_priority_weight_num,
wlst_preference_weight_num
FROM
igs_en_su_attempt_all sua
WHERE
sua.uoo_id = cp_uoo_id
AND sua.waitlist_manual_ind <> 'M'
AND sua.unit_attempt_status = 'WAITLISTED'
ORDER BY sua.administrative_priority
FOR UPDATE NOWAIT;
SELECT * FROM
igs_en_su_attempt sua
WHERE
sua.uoo_id = cp_uoo_id
AND sua.person_id = cp_person_id
AND sua.course_cd = cp_course_cd
FOR UPDATE NOWAIT;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_person_id;
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id;
igs_en_sua_api.update_unit_attempt (
X_ROWID => cur_sua_rec.ROW_ID,
X_PERSON_ID => cur_sua_rec.PERSON_ID,
X_COURSE_CD => cur_sua_rec.COURSE_CD,
X_UNIT_CD => cur_sua_rec.UNIT_CD,
X_CAL_TYPE => cur_sua_rec.CAL_TYPE,
X_CI_SEQUENCE_NUMBER => cur_sua_rec.CI_SEQUENCE_NUMBER,
X_VERSION_NUMBER => cur_sua_rec.VERSION_NUMBER,
X_LOCATION_CD => cur_sua_rec.LOCATION_CD,
X_UNIT_CLASS => cur_sua_rec.UNIT_CLASS,
X_CI_START_DT => cur_sua_rec.CI_START_DT,
X_CI_END_DT => cur_sua_rec.CI_END_DT,
X_UOO_ID => cur_sua_rec.UOO_ID,
X_ENROLLED_DT => cur_sua_rec.ENROLLED_DT,
X_UNIT_ATTEMPT_STATUS => cur_sua_rec.UNIT_ATTEMPT_STATUS,
X_ADMINISTRATIVE_UNIT_STATUS => cur_sua_rec.ADMINISTRATIVE_UNIT_STATUS,
X_DISCONTINUED_DT => cur_sua_rec.DISCONTINUED_DT,
X_RULE_WAIVED_DT => cur_sua_rec.RULE_WAIVED_DT,
X_RULE_WAIVED_PERSON_ID => cur_sua_rec.RULE_WAIVED_PERSON_ID,
X_NO_ASSESSMENT_IND => cur_sua_rec.NO_ASSESSMENT_IND,
X_SUP_UNIT_CD => cur_sua_rec.SUP_UNIT_CD,
X_SUP_VERSION_NUMBER => cur_sua_rec.SUP_VERSION_NUMBER,
X_EXAM_LOCATION_CD => cur_sua_rec.EXAM_LOCATION_CD,
X_ALTERNATIVE_TITLE => cur_sua_rec.ALTERNATIVE_TITLE,
X_OVERRIDE_ENROLLED_CP => cur_sua_rec.OVERRIDE_ENROLLED_CP,
X_OVERRIDE_EFTSU => cur_sua_rec.OVERRIDE_EFTSU,
X_OVERRIDE_ACHIEVABLE_CP => cur_sua_rec.OVERRIDE_ACHIEVABLE_CP,
X_OVERRIDE_OUTCOME_DUE_DT => cur_sua_rec.OVERRIDE_OUTCOME_DUE_DT,
X_OVERRIDE_CREDIT_REASON => cur_sua_rec.OVERRIDE_CREDIT_REASON,
X_ADMINISTRATIVE_PRIORITY => cur_sua_rec.ADMINISTRATIVE_PRIORITY,
X_WAITLIST_DT => cur_sua_rec.WAITLIST_DT,
X_DCNT_REASON_CD => cur_sua_rec.DCNT_REASON_CD,
X_MODE => 'R',
X_GS_VERSION_NUMBER => cur_sua_rec.GS_VERSION_NUMBER,
X_ENR_METHOD_TYPE => cur_sua_rec.ENR_METHOD_TYPE,
X_FAILED_UNIT_RULE => cur_sua_rec.FAILED_UNIT_RULE,
X_CART => cur_sua_rec.CART,
X_RSV_SEAT_EXT_ID => cur_sua_rec.RSV_SEAT_EXT_ID,
X_ORG_UNIT_CD => cur_sua_rec.ORG_UNIT_CD,
X_GRADING_SCHEMA_CODE => cur_sua_rec.GRADING_SCHEMA_CODE,
X_SUBTITLE => cur_sua_rec.SUBTITLE,
X_SESSION_ID => cur_sua_rec.SESSION_ID,
X_DEG_AUD_DETAIL_ID => cur_sua_rec.DEG_AUD_DETAIL_ID,
X_STUDENT_CAREER_TRANSCRIPT => cur_sua_rec.STUDENT_CAREER_TRANSCRIPT,
X_STUDENT_CAREER_STATISTICS => cur_sua_rec.STUDENT_CAREER_STATISTICS,
X_ATTRIBUTE_CATEGORY => cur_sua_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => cur_sua_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => cur_sua_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => cur_sua_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => cur_sua_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => cur_sua_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => cur_sua_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => cur_sua_rec.ATTRIBUTE7,
X_ATTRIBUTE8 => cur_sua_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => cur_sua_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => cur_sua_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => cur_sua_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => cur_sua_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => cur_sua_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => cur_sua_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => cur_sua_rec.ATTRIBUTE15,
X_ATTRIBUTE16 => cur_sua_rec.ATTRIBUTE16,
X_ATTRIBUTE17 => cur_sua_rec.ATTRIBUTE17,
X_ATTRIBUTE18 => cur_sua_rec.ATTRIBUTE18,
X_ATTRIBUTE19 => cur_sua_rec.ATTRIBUTE19,
X_ATTRIBUTE20 => cur_sua_rec.ATTRIBUTE20,
X_WAITLIST_MANUAL_IND => cur_sua_rec.WAITLIST_MANUAL_IND,
X_WLST_PRIORITY_WEIGHT_NUM => cur_sua_rec.WLST_PRIORITY_WEIGHT_NUM,
X_WLST_PREFERENCE_WEIGHT_NUM => cur_sua_rec.WLST_PREFERENCE_WEIGHT_NUM,
-- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => cur_sua_rec.CORE_INDICATOR_CODE
);
SELECT igs_en_wf_be_en001_s.NEXTVAL INTO l_key FROM dual;
SELECT uoo_id
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id
FOR UPDATE;
SELECT *
FROM igs_en_su_attempt
WHERE uoo_id = cp_uoo_id AND unit_attempt_status = 'WAITLISTED'
ORDER BY wlst_priority_weight_num DESC, wlst_preference_weight_num DESC, administrative_priority
FOR UPDATE;
UPDATE igs_en_su_attempt
SET administrative_priority = l_cnt ,
waitlist_manual_ind = 'N'
WHERE CURRENT OF c_sua_pri_pref;
SELECT uoo_id
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id
FOR UPDATE;
SELECT *
FROM igs_en_su_attempt
WHERE uoo_id = cp_uoo_id AND
(person_id <> cp_person_id OR
course_cd <> cp_program_cd) AND
unit_attempt_status = 'WAITLISTED' AND
administrative_priority >= cp_cur_position
ORDER BY administrative_priority
FOR UPDATE;
UPDATE igs_en_su_attempt
SET administrative_priority = l_cnt ,
waitlist_manual_ind = 'N'
WHERE CURRENT OF c_sua_wl_dt;
SELECT unit_sec_waitlist_priority_id, priority_value, priority_number
FROM igs_ps_usec_wlst_pri
WHERE uoo_id = cp_uoo_id
ORDER BY priority_number;
SELECT preference_code,preference_version
FROM igs_ps_usec_wlst_prf
WHERE unit_sec_waitlist_priority_id = cp_priority_id
ORDER BY preference_order;
SELECT count(unit_sec_waitlist_priority_id)
FROM igs_ps_usec_wlst_pri
WHERE uoo_id = cp_uoo_id;
SELECT count(unit_sec_waitlist_pref_id)
FROM igs_ps_usec_wlst_prf
WHERE unit_sec_waitlist_priority_id IN(SELECT unit_sec_waitlist_priority_id
FROM igs_ps_usec_wlst_pri
WHERE uoo_id = cp_uoo_id);
SELECT unit_cd, version_number, cal_type , ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT unit_ofr_waitlist_priority_id, priority_value, priority_number
FROM igs_ps_uofr_wlst_pri
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number
AND calender_type = cp_cal_type
AND ci_sequence_number = cp_seq_no
ORDER BY priority_number;
SELECT preference_code,preference_version
FROM igs_ps_uofr_wlst_prf
WHERE unit_ofr_waitlist_priority_id = cp_priority_id
ORDER BY preference_order;
SELECT count(unit_ofr_waitlist_priority_id)
FROM igs_ps_uofr_wlst_pri
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number
AND calender_type = cp_cal_type
AND ci_sequence_number = cp_seq_no;
SELECT count(unit_ofr_waitlist_pref_id)
FROM igs_ps_uofr_wlst_prf
WHERE unit_ofr_waitlist_priority_id IN(SELECT unit_ofr_waitlist_priority_id
FROM igs_ps_uofr_wlst_pri
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number
AND calender_type = cp_cal_type
AND ci_sequence_number = cp_seq_no);
SELECT NVL(uoo.owner_org_unit_cd,uv.owner_org_unit_cd)
FROM igs_ps_unit_ofr_opt uoo,
igs_ps_unit_ver uv
WHERE uoo.uoo_id = cp_uoo_id
AND uv.unit_cd= uoo.unit_cd
AND uv.version_number= uoo.version_number;
SELECT load_cal_type
FROM igs_ca_teach_to_load_v
WHERE teach_cal_type = cp_teach_cal_type
AND teach_ci_sequence_number = cp_teach_seq_no
ORDER BY load_start_dt;
SELECT owp.org_unit_wlst_pri_id, owp.priority_value, owp.priority_number
FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
WHERE ouw.org_unit_cd = cp_org_unit_cd
AND ouw.cal_type = cp_cal_type
AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
AND ouw.closed_flag = 'N'
ORDER BY owp.priority_number;
SELECT preference_code,preference_version
FROM igs_en_orun_wlst_prf
WHERE org_unit_wlst_pri_id = cp_priority_id
ORDER BY preference_order;
SELECT count(org_unit_wlst_pri_id)
FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
WHERE ouw.org_unit_cd = cp_org_unit_cd
AND ouw.cal_type = cp_cal_type
AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
AND ouw.closed_flag = 'N';
SELECT count(org_unit_wlst_prf_id)
FROM igs_en_orun_wlst_prf
WHERE org_unit_wlst_pri_id IN(SELECT owp.org_unit_wlst_pri_id
FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
WHERE ouw.org_unit_cd = cp_org_unit_cd
AND ouw.cal_type = cp_cal_type
AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
AND ouw.closed_flag = 'N');
SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd;
SELECT 'X'
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND version_number = cp_version_number;
SELECT 'X'
FROM igs_en_stdnt_ps_att sca,
igs_ps_ver pv
WHERE sca.person_id = cp_person_id
AND sca.course_cd = pv.course_cd
AND sca.version_number = pv.version_number
AND pv.responsible_org_unit_cd = cp_org_unit_cd;
SELECT 'X'
FROM igs_en_stdnt_ps_att spa,
igs_as_su_setatmpt sus
WHERE spa.person_id = cp_person_id
AND sus.person_id = spa.person_id
AND spa.course_cd = sus.course_cd
AND sus.unit_set_cd = cp_unit_set_cd
AND sus.us_version_number = cp_us_version_number;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_person_id;
SELECT description
FROM igs_ca_inst
WHERE cal_type=pc_cal_type
AND sequence_number=pc_seq_num;