[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT effect_enr_strt_dt_alias
FROM IGS_EN_CAL_CONF
WHERE s_control_num = 1;
SELECT IGS_CA_DA_INST_V.alias_val,
IGS_CA_DA_INST_V.ci_sequence_number
FROM IGS_CA_DA_INST_V,
IGS_CA_INST,
IGS_CA_STAT
WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
IGS_CA_STAT.s_cal_status <> cst_planned
ORDER BY alias_val DESC;
SELECT IGS_EN_STDNT_PS_ATT.cal_type
FROM IGS_EN_STDNT_PS_ATT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd;
SELECT sua.person_id,
sua.course_cd,
sua.unit_cd,
sua.cal_type,
sua.ci_sequence_number,
sua.unit_attempt_status,
sua.override_achievable_cp,
uv.repeatable_ind,
NVL(cps.achievable_credit_points,uv.achievable_credit_points) achievable_credit_points,
NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points,
sua.uoo_id
FROM IGS_EN_SU_ATTEMPT sua,
IGS_PS_UNIT_VER uv,
IGS_PS_USEC_CPS cps,
IGS_CA_INST ci
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status IN(cst_completed,
cst_duplicate) AND
uv.unit_cd = sua.unit_cd AND
uv.version_number = sua.version_number AND
ci.cal_type = sua.cal_type AND
ci.sequence_number = sua.ci_sequence_number AND
sua.uoo_id = cps.uoo_id (+)
ORDER BY sua.unit_cd asc,
sua.ci_end_dt asc;
SELECT rowid
FROM IGS_AS_SU_STMPTOUT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id AND
TRUNC(outcome_dt) = TRUNC(cp_discontinued_dt) AND
s_grade_creation_method_type = 'DISCONTIN';
IGS_AS_SU_STMPTOUT_PKG.DELETE_ROW(l_rowid);
SELECT person_id
FROM IGS_PS_STDNT_UNT_TRN sut
WHERE sut.person_id = p_person_id AND
sut.transfer_course_cd = p_course_cd AND
sut.uoo_id = p_uoo_id;
CURSOR c_sut_delete IS
SELECT rowid,person_id
FROM IGS_PS_STDNT_UNT_TRN sut
WHERE sut.person_id = p_person_id AND
sut.course_cd = p_course_cd AND
sut.uoo_id = p_uoo_id
FOR UPDATE OF sut.person_id NOWAIT;
FOR v_sut_delete_rec IN c_sut_delete LOOP
IGS_PS_STDNT_UNT_TRN_PKG.DELETE_ROW(v_sut_delete_rec.rowid);
IF (c_sut_delete%ISOPEN) THEN
CLOSE c_sut_delete;
IF (c_sut_delete%ISOPEN) THEN
CLOSE c_sut_delete;
CURSOR c_sua_delete IS
SELECT rowid rowid1,person_id
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.uoo_id = p_uoo_id
FOR UPDATE OF sua.person_id NOWAIT;
FOR v_sua_delete_rec IN c_sua_delete
LOOP
-- Delete current record
IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(v_sua_delete_rec.rowid1 );
IF (c_sua_delete%ISOPEN) THEN
CLOSE c_sua_delete;
IF (c_sua_delete%ISOPEN) THEN
CLOSE c_sua_delete;
SELECT susah.rowid,
susah.person_id person_id
FROM IGS_AS_SU_SETATMPT_H susah
WHERE susah.person_id = p_person_id AND
susah.course_cd = p_course_cd AND
susah.unit_set_cd = p_unit_set_cd AND
susah.sequence_number = p_sequence_number
FOR UPDATE OF susah.person_id NOWAIT;
IGS_AS_SU_SETATMPT_H_PKG.DELETE_ROW(
v_susah_rec.rowid
);
CURSOR c_susa_delete IS
SELECT rowid,person_id
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.unit_set_cd = p_unit_set_cd AND
susa.us_version_number = p_us_version_number
FOR UPDATE OF susa.person_id NOWAIT;
FOR v_susa_delete_rec IN c_susa_delete LOOP
-- Delete current record
IGS_AS_SU_SETATMPT_PKG.DELETE_ROW(
v_susa_delete_rec.rowid
);
IF (c_susa_delete%ISOPEN) THEN
CLOSE c_susa_delete;
IF (c_susa_delete%ISOPEN) THEN
CLOSE c_susa_delete;