[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT elgb_override_id
FROM igs_en_elgb_ovr
WHERE person_id = p_person_id AND
cal_type = p_cal_type AND
ci_sequence_number = p_ci_seq_number;
SELECT DISTINCT(sca.person_id) person_id
FROM igs_en_stdnt_ps_att sca
WHERE (p_person_id IS NULL OR
sca.person_id = p_person_id) AND
(p_person_id_group IS NULL OR
EXISTS ( SELECT 'x'
FROM igs_pe_prsid_grp_mem pig
WHERE pig.group_id = p_person_id_group AND
pig.person_id = sca.person_id)) AND
sca.course_cd LIKE NVL(p_course_cd,'%') AND
igs_en_gen_011.match_term_sca_params (
sca.person_id,
sca.course_cd,
sca.version_number,
sca.attendance_type,
sca.attendance_mode,
sca.location_cd,
p_course_cd,
p_course_version,
p_attendance_type,
p_attendance_mode,
p_location_cd,
p_load_cal_type,
p_load_cal_seq) = 'Y'
AND
sca.course_attempt_status LIKE NVL(p_program_attempt_status,'%') AND
(p_unit_cd_comb IS NULL OR
EXISTS (SELECT 'X'
FROM igs_en_su_attempt sua
WHERE sua.person_id = sca.person_id AND
sua.course_cd = sca.course_cd AND
sua.unit_cd = p_unit_cd AND
sua.version_number = p_unit_version)) AND
(p_unit_set_comb IS NULL OR
EXISTS (SELECT 'X'
FROM igs_as_su_setatmpt
WHERE unit_set_cd = p_unit_set_cd AND
us_version_number = p_unit_set_version AND
person_id = sca.person_id AND
course_cd = sca.course_cd )) AND
/* (p_class_stand IS NULL OR
NVL(sca.class_standing_override,get_class_standing(sca.person_id,sca.course_cd,'N'))
= p_class_stand ) AND*/
(p_org_unit_cd IS NULL OR
EXISTS (SELECT 'X'
FROM igs_ps_ver ps
WHERE ps.course_cd = sca.course_cd AND
ps.version_number = sca.version_number AND
((ps.responsible_org_unit_cd = p_org_unit_cd AND
ps.responsible_ou_start_dt = p_org_unit_start_dt) OR
igs_or_gen_001.orgp_get_within_ou(ps.responsible_org_unit_cd,
ps.responsible_ou_start_dt,
p_org_unit_cd,
p_org_unit_start_dt,
'N') = 'Y')));
SELECT start_dt
FROM igs_or_unit
WHERE org_unit_cd = p_org_unit_cd;
SELECT PG.GROUP_CD||'-'||PG.GROUP_ID
FROM IGS_PE_PERSID_GROUP PG
WHERE PG.group_id = p_person_id_group;
SELECT PE.party_number person_number
FROM hz_parties PE
WHERE PE.party_id = p_person_id;
SELECT LKV.meaning
FROM IGS_Lookup_values LKV
WHERE lkv.lookup_type = p_lookup_type AND
LKV.lookup_code = p_step;
SELECT s_cal_cat
FROM igs_ca_type
WHERE cal_type = cp_cal_type;
SELECT load_cal_type,load_ci_sequence_number
FROM igs_ca_teach_to_load_v
WHERE teach_cal_type= cp_teach_cal_type
AND teach_ci_sequence_number= cp_teach_ci_sequence_number;
SELECT step_override_limit,
step_override_type
FROM igs_en_elgb_ovr_step eos
WHERE eos.elgb_override_id = cp_elgb_override_id
AND eos.step_override_type = cp_eligibility_step_type;
SELECT party_number
FROM hz_parties
WHERE party_id = p_party_id;
SELECT meaning
FROM igs_lookup_values
WHERE lookup_code = cp_step_Type
AND (LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'
OR LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE');
Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_ovr_step_id => l_elgb_ovr_step_id,
x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
x_step_override_type => p_elgb_step,
x_step_override_dt => TRUNC(SYSDATE),
x_step_override_limit => NULL,
x_mode => 'R');
CURSOR cur_elgb_end_dt IS SELECT end_dt,person_id, ci.cal_type, ci.sequence_number FROM igs_en_elgb_ovr elgb,
igs_ca_inst ci
WHERE elgb.elgb_override_id = p_elgb_override_id
AND elgb.cal_type = ci.cal_type
AND elgb.ci_sequence_number = ci.sequence_number;
SELECT 'X'
FROM igs_pe_typ_instances_all pti,
igs_pe_person_types pt
WHERE pt.person_type_code = pti.person_type_code
AND system_type IN ('NONIMG_STUDENT')
AND person_id = p_person_id
AND NVL(end_date, SYSDATE) >= SYSDATE;
Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_ovr_step_id => l_elgb_ovr_step_id,
x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
x_step_override_type => p_elgb_step,
x_step_override_dt => TRUNC(SYSDATE),
x_step_override_limit => l_step_override_limit,
x_mode => 'R');
SELECT elgb_ovr_step_id
FROM igs_en_elgb_ovr_step eos
WHERE eos.elgb_override_id = p_elgb_override_id
AND eos.step_override_type = p_elgb_step;
SELECT elgb_ovr_step_uoo_id
FROM igs_en_elgb_ovr_uoo eou
WHERE eou.elgb_ovr_step_id = cp_elgb_ovr_step_id
AND ((eou.uoo_id = NVL(p_uoo_id,-1) AND NVL(p_uoo_id,-1) <> -1)
OR (eou.uoo_id = NVL(p_uoo_id,-1) AND NVL(p_uoo_id,-1) = -1 AND eou.unit_cd = p_unit_cd AND eou.version_number = p_version_number));
Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_ovr_step_id => l_elgb_ovr_step_id,
x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
x_step_override_type => p_elgb_step,
x_step_override_dt => TRUNC(SYSDATE),
x_step_override_limit => l_step_override_limit,
x_mode => 'R');
Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_ovr_step_uoo_id => l_elgb_ovr_step_uoo_id,
x_elgb_ovr_step_id => l_elgb_ovr_step_id,
x_unit_cd => p_unit_cd,
x_version_number => p_version_number,
x_uoo_id => p_uoo_id,
x_step_override_limit => l_step_override_limit,
x_mode => 'R');
Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_ovr_step_uoo_id => l_elgb_ovr_step_uoo_id,
x_elgb_ovr_step_id => lr_cur_get_elgb_ovr_step_id,
x_unit_cd => p_unit_cd,
x_version_number => p_version_number,
x_uoo_id => p_uoo_id,
x_step_override_limit => l_step_override_limit,
x_mode => 'R');
Igs_En_Elgb_Ovr_Pkg.insert_row(x_rowid => l_rowid,
x_elgb_override_id => l_elgb_override_id,
x_person_id => cur_criteria_satisfied_rec.person_id,
x_cal_type => l_cal_type,
x_ci_sequence_number => l_ci_seq_number,
x_mode => 'R');