The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MAX(daiv.alias_val) INTO v_alias_val
FROM igs_ca_da_inst_v daiv
WHERE daiv.dt_alias = lp_dt_alias
AND daiv.cal_type = lp_teach_cal_type
AND daiv.ci_sequence_number = lp_teach_ci_sequence_number;
SELECT 'X'
FROM igs_en_su_attempt sua,
igs_en_stdnt_ps_att spa
WHERE sua.uoo_id = lp_uoo_id
AND sua.person_id = spa.person_id
AND sua.course_cd = spa.course_cd
AND (EXISTS (SELECT 'X'
FROM igs_as_gpc_programs gpr
WHERE gpr.course_cd = spa.course_cd
AND gpr.course_version_number = spa.version_number
AND gpr.grading_period_cd = lp_grading_period_cd)
OR EXISTS (SELECT 'X'
FROM igs_as_gpc_aca_stndg gas
WHERE spa.progression_status = gas.progression_status
AND gas.grading_period_cd = lp_grading_period_cd)
OR EXISTS (SELECT 'X'
FROM igs_pe_prsid_grp_mem pigm,
igs_as_gpc_pe_id_grp gpg
WHERE spa.person_id = pigm.person_id
AND pigm.group_id = gpg.group_id
AND gpg.grading_period_cd = lp_grading_period_cd)
OR EXISTS (SELECT 'X'
FROM igs_as_su_setatmpt susa,
igs_as_gpc_unit_sets gus
WHERE susa.person_id = spa.person_id
AND susa.course_cd = spa.course_cd
AND (susa.end_dt is NULL
OR susa.rqrmnts_complete_ind = 'Y')
AND susa.unit_set_cd = gus.unit_set_cd
AND gus.grading_period_cd = lp_grading_period_cd));
SELECT 'X'
FROM igs_en_su_attempt sua,
igs_en_stdnt_ps_att spa
WHERE sua.uoo_id = lp_uoo_id
AND sua.person_id = spa.person_id
AND sua.course_cd = spa.course_cd
AND EXISTS (SELECT 'X'
FROM igs_as_gpc_cls_stndg gcs
WHERE gcs.grading_period_cd = lp_grading_period_cd
AND gcs.class_standing = IGS_PR_GET_CLASS_STD.Get_Class_Standing(spa.person_id,spa.course_cd,'N',SYSDATE,lp_load_cal_type,lp_load_ci_sequence_number));
SELECT 'X'
FROM igs_as_notify_be nbe
WHERE nbe.uoo_id = lp_uoo_id
AND nbe.internal_name = lp_internal_name;
igs_as_notify_be_pkg.insert_row (x_rowid =>l_rowid,
x_uoo_id =>lp_uoo_id,
x_internal_name => lp_internal_name,
x_mode =>'R'
);
SELECT ttl.teach_cal_type,
ttl.teach_ci_sequence_number,
ttl.teach_description,
ttl.load_description
FROM igs_ca_teach_to_load_v ttl,
igs_ca_inst ci,
igs_ca_stat cs
WHERE ttl.load_cal_type = l_ld_cal_type
AND ttl.load_ci_sequence_number = l_ld_sequence_number
AND ttl.teach_cal_type = ci.cal_type
AND ttl.teach_ci_sequence_number = ci.sequence_number
AND ci.cal_status = cs.cal_status
AND cs.s_cal_status = 'ACTIVE';
SELECT uoo.uoo_id,
uoo.unit_cd,
uoo.unit_class,
uoo.location_cd,
loc.description location_description,
uoo.call_number,
uoo.unit_section_start_date,
uoo.unit_section_end_date,
uoo.attendance_required_ind,
uv.title,
uv.short_title,
utr.instructor_id
FROM igs_ps_unit_ofr_opt uoo,
igs_ps_unit_ver uv,
igs_ps_usec_tch_resp utr,
igs_ad_location loc
WHERE uoo.cal_type = cp_teach_cal_type
AND uoo.ci_sequence_number = cp_teach_ci_sequence_number
AND uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uoo.location_cd = loc.location_cd
AND uoo.uoo_id = utr.uoo_id (+)
AND utr.lead_instructor_flag (+) = 'Y' ;
SELECT 'X'
FROM igs_as_gaa_sub_hist gash
WHERE gash.uoo_id = cp_uoo_id
AND gash.submission_type = 'ATTENDANCE'
AND gash.submission_status = 'COMPLETE'
AND gash.submitted_date = (
SELECT MAX(gash2.submitted_date)
FROM igs_as_gaa_sub_hist gash2
WHERE gash2.uoo_id = cp_uoo_id
AND gash2.submission_type = 'ATTENDANCE');
SELECT 'X'
FROM igs_as_gaa_sub_hist gash
WHERE gash.uoo_id = cp_uoo_id
AND gash.submission_type = 'GRADE'
AND gash.grading_period_cd = 'MIDTERM'
AND gash.submission_status = 'COMPLETE'
AND gash.submitted_date = (
SELECT MAX(gash2.submitted_date)
FROM igs_as_gaa_sub_hist gash2
WHERE gash2.uoo_id = cp_uoo_id
AND gash2.submission_type = 'GRADE'
AND gash2.grading_period_cd = 'MIDTERM');
SELECT 'X'
FROM igs_as_gaa_sub_hist gash
WHERE gash.uoo_id = cp_uoo_id
AND gash.submission_type = 'GRADE'
AND gash.grading_period_cd = 'EARLY_FINAL'
AND gash.submission_status = 'COMPLETE'
AND gash.submitted_date = (
SELECT MAX(gash2.submitted_date)
FROM igs_as_gaa_sub_hist gash2
WHERE gash2.uoo_id = cp_uoo_id
AND gash2.submission_type = 'GRADE'
AND gash2.grading_period_cd = 'EARLY_FINAL');
SELECT 'X'
FROM igs_as_gaa_sub_hist gash
WHERE gash.uoo_id = cp_uoo_id
AND gash.submission_type = 'GRADE'
AND gash.grading_period_cd = 'FINAL'
AND gash.submission_status = 'COMPLETE'
AND gash.submitted_date = (
SELECT MAX(gash2.submitted_date)
FROM igs_as_gaa_sub_hist gash2
WHERE gash2.uoo_id = cp_uoo_id
AND gash2.submission_type = 'GRADE'
AND gash2.grading_period_cd = 'FINAL');
SELECT acc.mid_mgs_start_dt_alias,
acc.mid_mgs_end_dt_alias,
acc.efinal_mgs_start_dt_alias,
acc.efinal_mgs_end_dt_alias,
acc.final_mgs_start_dt_alias,
acc.final_mgs_end_dt_alias
INTO
v_mid_mgs_start_dt_alias,
v_mid_mgs_end_dt_alias,
v_efinal_mgs_start_dt_alias,
v_efinal_mgs_end_dt_alias,
v_final_mgs_start_dt_alias,
v_final_mgs_end_dt_alias
FROM igs_as_cal_conf acc
WHERE s_control_num = 1;
SELECT IGS_AS_WF_BESUAREFCDS_S.nextval
FROM DUAL;
if (P_ACTION = 'UPDATE') then
WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.update',
p_event_key => 'SUA_REF'||ln_seq_val,
p_parameters => l_parameter_list_t);
if (P_ACTION = 'INSERT') then
WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.insert',
p_event_key => 'SUA_REF'||ln_seq_val,
p_parameters => l_parameter_list_t);