[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
WHERE pti.person_type_code = pty.person_type_code AND
pty.system_type = 'STUDENT' AND
pti.person_id = cp_person_id AND
sysdate BETWEEN start_date AND NVL(end_date,sysdate);
SELECT DECODE ( cp_column_name,
'VERSION_NUMBER', TO_CHAR(suah.version_number),
'LOCATION_CD', suah.location_cd,
'UNIT_CLASS', suah.unit_class,
'ENROLLED_DT', igs_ge_date.igscharDT(suah.enrolled_dt),
'UNIT_ATTEMPT_STATUS', suah.unit_attempt_status,
'ADMINISTRATIVE_UNIT_STATUS', suah.ADMINISTRATIVE_UNIT_STATUS,
'DISCONTINUED_DT', igs_ge_date.igscharDT(suah.discontinued_dt),
'RULE_WAIVED_DT', igs_ge_date.igscharDT(suah.rule_waived_dt),
'RULE_WAIVED_PERSON_ID', TO_CHAR(suah.rule_waived_person_id),
'NO_ASSESSMENT_IND', suah.no_assessment_ind,
'EXAM_LOCATION_CD', suah.exam_location_cd,
'SUP_VERSION_NUMBER', TO_CHAR(suah.sup_version_number),
'ALTERNATIVE_TITLE', suah.alternative_title,
'OVERRIDE_ENROLLED_CP', TO_CHAR(suah.override_enrolled_cp),
'OVERRIDE_EFTSU', TO_CHAR(suah.override_eftsu),
'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(suah.override_achievable_cp),
'OVERRIDE_OUTCOME_DUE_DT', igs_ge_date.igscharDT(suah.override_outcome_due_dt),
'OVERRIDE_CREDIT_REASON', suah.override_credit_reason)
FROM IGS_EN_SU_ATTEMPT_H suah
WHERE suah.person_id = cp_person_id AND
suah.course_cd = cp_course_cd AND
suah.uoo_id = cp_uoo_id AND
suah.hist_start_dt >= cp_hist_end_dt
ORDER BY
suah.hist_start_dt ASC;
SELECT ci.cal_type,
ci.sequence_number
FROM IGS_CA_INST ci,
IGS_CA_TYPE cat,
IGS_CA_STAT cs
WHERE cat.cal_type = ci.cal_type AND
cat.s_cal_cat = cst_load AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status = cst_active AND
IGS_EN_GEN_014.enrs_get_within_ci (
cp_acad_cal_type,
cp_acad_ci_sequence_number,
ci.cal_type,
ci.sequence_number,
cst_yes) = cst_yes
ORDER BY ci.start_dt;
SELECT no_assessment_ind
FROM igs_en_su_attempt
WHERE person_id = p_person_id
AND course_cd = p_course_cd
AND uoo_id = p_uoo_id;
SELECT unit_attempt_status,
enrolled_dt,
rule_waived_dt,
discontinued_dt
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
uoo_id = p_uoo_id;
SELECT 'x'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM IGS_AS_SU_STMPTOUT
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
uoo_id = p_uoo_id AND
finalised_outcome_ind = cst_yes AND
s_grade_creation_method_type <> cst_discontin AND
grading_period_cd = cst_grading_period_cd
);
SELECT sua.unit_attempt_status
FROM IGS_PS_STDNT_UNT_TRN sut1, IGS_EN_SU_ATTEMPT sua
WHERE sut1.person_id = p_person_id AND
sut1.course_cd = p_course_cd AND
sua.person_id = sut1.person_id AND
sua.course_cd = sut1.transfer_course_cd AND
sua.uoo_id = sut1.uoo_id AND
sut1.uoo_id = p_uoo_id AND
sut1.transfer_dt = ( SELECT max(sut2.transfer_dt)
FROM IGS_PS_STDNT_UNT_TRN sut2
where sut2.person_id = sut1.person_id
and sut2.course_cd = sut1.course_cd
and sut2.uoo_id = sut1.uoo_id)
AND sut1.transfer_dt > (SELECT NVL(max(sut3.transfer_dt),(sut1.transfer_dt-1))
FROM IGS_PS_STDNT_UNT_TRN sut3
where sut3.person_id = sut1.person_id
and sut3.transfer_course_cd = sut1.course_cd
and sut3.uoo_id = sut1.uoo_id);
p_selection_dt IN DATE ,
p_student_confirmed_ind IN VARCHAR2 ,
p_end_dt IN DATE ,
p_rqrmnts_complete_ind IN VARCHAR2 )
RETURN VARCHAR2 AS
BEGIN -- enrp_get_susa_status
-- Get logical status of IGS_AS_SU_SETATMPT, being one of:
-- * UNCONFIRM, ACTIVE, COMPLETED OR ENDED.
DECLARE
cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
p_selection_dt IS NULL THEN
RETURN cst_unconfirm;