[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT atyp.examinable_ind
FROM IGS_AS_ASSESSMNT_TYP atyp,
IGS_AS_ASSESSMNT_ITM ai
WHERE ai.ass_id = cp_ass_id AND
ai.assessment_type = atyp.assessment_type;
SELECT course_type
FROM IGS_AS_COURSE_TYPE
WHERE ass_id = cp_ass_id;
SELECT 'x'
FROM IGS_TR_STEP trst
WHERE trst.tracking_id = p_tracking_id AND
trst.s_tracking_step_type = 'ASSIGN-DUE' AND
trst.completion_dt IS NOT NULL;
SELECT suaai.attempt_number
FROM IGS_AS_SU_ATMPT_ITM suaai
WHERE suaai.person_id = p_person_id AND
suaai.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
suaai.uoo_id = p_uoo_id AND
suaai.ass_id = p_ass_id AND
suaai.creation_dt <> p_creation_dt AND
suaai.attempt_number = p_attempt_number AND
suaai.logical_delete_dt IS NULL;
p_suaai_logical_delete_dt IN DATE ,
p_message_name OUT NOCOPY VARCHAR2 ,
-- anilk, 22-Apr-2003, Bug# 2829262
p_uoo_id IN NUMBER DEFAULT NULL )
RETURN BOOLEAN IS
BEGIN -- assp_val_suaai_valid
-- This module validate IGS_AD_PS_APLINSTUNT unit version.
DECLARE
v_logical_del_dt IGS_AS_UNTAS_PATTERN.logical_delete_dt%TYPE;
SELECT uai.logical_delete_dt
FROM
IGS_EN_SU_ATTEMPT sua,
IGS_AS_UNITASS_ITEM uai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
uai.ass_id = p_ass_id AND
sua.unit_cd = uai.unit_cd AND
sua.version_number = uai.version_number AND
sua.cal_type = uai.cal_type AND
sua.ci_sequence_number = uai.ci_sequence_number AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE'
UNION
SELECT psuai.logical_delete_dt
FROM
IGS_EN_SU_ATTEMPT sua,
IGS_PS_UNITASS_ITEM_V psuai
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id = p_uoo_id AND
psuai.ass_id = p_ass_id AND
sua.uoo_id = psuai.uoo_id AND
IGS_AS_VAL_UAI.assp_val_sua_ai_acot(psuai.ass_id,
sua.person_id,
sua.course_cd) = 'TRUE' ;
IF v_suv_rec.logical_delete_dt IS NOT NULL AND
p_suaai_logical_delete_dt IS NULL THEN
-- Item has been logically deleted but the item belonging
-- to student has not been logically deleted, hence it is
-- invalid. Do nothing at this point as there may still
-- be records to process and a valid one is yet to be found.
NULL;
IF (v_suv_rec.logical_delete_dt IS NULL AND
p_suaai_logical_delete_dt IS NULL) OR
(p_suaai_logical_delete_dt IS NOT NULL) THEN
-- The record is valid or a valid item has been found
-- but the student's record has been deleted.
v_rec_found := TRUE;