The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT person_id
FROM IGS_AD_APPL_HIST
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number;
SELECT rowid, aah.*
FROM IGS_AD_APPL_HIST aah
WHERE person_id = cp_adinl_person_id AND
admission_appl_number = cp_adinl_admission_appl_number
FOR UPDATE OF person_id NOWAIT;
IGS_AD_APPL_HIST_PKG.DELETE_ROW (
X_ROWID => v_aah_rec.rowid );
SELECT rowid,acaiuh.*
FROM IGS_AD_PS_APINTUNTHS acaiuh
WHERE acaiuh.person_id = p_person_id AND
acaiuh.admission_appl_number = p_admission_appl_number AND
acaiuh.nominated_course_cd = p_nominated_course_cd AND
acaiuh.acai_sequence_number = p_acai_sequence_number AND
acaiuh.unit_cd = p_unit_cd
FOR UPDATE OF acaiuh.person_id NOWAIT;
IGS_AD_PS_APINTUNTHS_PKG.DELETE_ROW (
X_ROWID => v_acaiuh_rec.rowid );
p_message_name := 'IGS_AD_UNABLE_TO_DELETE';
SELECT rowid, acaih.*
FROM IGS_AD_PS_APLINSTHST acaih
WHERE acaih.person_id = cp_person_id AND
acaih.admission_appl_number = cp_admission_appl_number AND
acaih.nominated_course_cd = cp_nominated_course_cd AND
acaih.sequence_number = cp_sequence_number
FOR UPDATE OF acaih.person_id NOWAIT;
IGS_AD_PS_APLINSTHST_PKG.DELETE_ROW (
X_ROWID => v_del_acaih_rec.rowid );
SELECT ROWID, acah.*
FROM IGS_AD_PS_APPL_HIST acah
WHERE acah.person_id = cp_person_id AND
acah.admission_appl_number = cp_admission_appl_number AND
acah.nominated_course_cd = cp_nominated_course_cd
FOR UPDATE OF acah.person_id NOWAIT;
IGS_AD_PS_APPL_HIST_PKG.DELETE_ROW (
X_ROWID => v_del_acah_rec.rowid );
p_sca_deleted_ind VARCHAR2,
p_log_creation_dt DATE,
p_key VARCHAR2,
p_s_log_type VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
p_sca_deleted_ind || '|' || p_key,
p_message_name,
p_default_msg_txt);
v_delete_sca_ind VARCHAR2(1);
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number,
daiv.cal_type,
daiv.ci_sequence_number
FROM IGS_CA_INST_REL cir,
IGS_CA_DA_INST_V daiv,
IGS_CA_TYPE ct,
IGS_CA_TYPE ct2,
IGS_EN_CAL_CONF secc
WHERE secc.s_control_num = 1 AND
TRUNC(daiv.alias_val) = TRUNC(SYSDATE) AND
daiv.dt_alias = secc.enr_cleanup_dt_alias AND
ct.cal_type = daiv.cal_type AND
ct.s_cal_cat = cst_enrolment AND
cir.sub_cal_type = daiv.cal_type AND
cir.sub_ci_sequence_number = daiv.ci_sequence_number AND
ct2.cal_type = cir.sup_cal_type AND
ct2.s_cal_cat = cst_admission;
SELECT sca.person_id,
sca.course_cd,
sca.course_attempt_status,
sca.fee_cat,
sca.adm_admission_appl_number,
sca.adm_nominated_course_cd,
sca.adm_sequence_number,
acaiv.admission_appl_number,
acaiv.nominated_course_cd,
acaiv.sequence_number,
aa.acad_cal_type,
aa.acad_ci_sequence_number,
acaiv.adm_cal_type,
acaiv.adm_ci_sequence_number,
aa.admission_cat,
aa.s_admission_process_type,
aors.s_adm_offer_resp_status,
aods.s_adm_offer_dfrmnt_status
FROM igs_en_stdnt_ps_att sca,
igs_ad_ps_appl_inst acaiv,
igs_ad_appl aa,
igs_ad_ou_stat aos,
igs_ad_ofr_resp_stat aors,
igs_ad_ofrdfrmt_stat aods
WHERE sca.course_attempt_status = cst_unconfirm AND
sca.person_id = acaiv.person_id AND
sca.adm_admission_appl_number = acaiv.admission_appl_number AND
sca.adm_nominated_course_cd = acaiv.nominated_course_cd AND
sca.adm_sequence_number = acaiv.sequence_number AND
acaiv.adm_cal_type = cp_cal_type AND
acaiv.adm_ci_sequence_number = cp_sequence_number AND
aa.person_id = acaiv.person_id AND
aa.admission_appl_number = acaiv.admission_appl_number AND
aos.adm_outcome_status = acaiv.adm_outcome_status AND
aors.adm_offer_resp_status = acaiv.adm_offer_resp_status AND
aods.adm_offer_dfrmnt_status = acaiv.adm_offer_dfrmnt_status AND
(aos.s_adm_outcome_status IN (
cst_withdrawn,
cst_voided,
cst_rejected) OR
aors.s_adm_offer_resp_status IN (
cst_rejected,
cst_lapsed,
cst_deferral));
SELECT sterm.person_id,sterm.program_cd
FROM IGS_EN_SPA_TERMS sterm
WHERE sterm.person_id = cp_person_id
AND sterm.program_cd = cp_course_cd;
SELECT ROWID, sca.*
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = cp_person_id AND
sca.course_cd = cp_course_cd
FOR UPDATE OF
sca.LAST_UPDATE_DATE NOWAIT;
igs_ge_msg_stack.delete_msg(l_msg_idx_start);
p_sca_deleted_ind => 'N',
p_log_creation_dt => v_log_creation_dt,
p_key => v_key,
p_s_log_type => cst_del_un_sca);
p_sca_deleted_ind => 'N',
p_log_creation_dt => v_log_creation_dt,
p_key => v_key,
p_s_log_type => cst_del_un_sca);
SELECT uoo_id
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd;
SELECT row_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 = cp_uoo_id
FOR UPDATE OF
sua.LAST_UPDATE_DATE NOWAIT;
IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(
X_ROWID => v_sua_del_exists.row_id );
SELECT suah.uoo_id,
suah.hist_start_dt
FROM IGS_EN_SU_ATTEMPT_H suah
WHERE suah.person_id = p_person_id AND
suah.course_cd = p_course_cd ;
SELECT row_id
FROM IGS_EN_SU_ATTEMPT_H suah
WHERE suah.person_id = p_person_id AND
suah.course_cd = p_course_cd AND
suah.uoo_id = cp_uoo_id AND
suah.hist_start_dt = cp_hist_start_dt
FOR UPDATE OF
suah.LAST_UPDATE_DATE NOWAIT;
IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(
X_ROWID => v_suah_del_exists.ROW_ID );
SELECT
susa.unit_set_cd,
susa.sequence_number
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = p_course_cd
START WITH
susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.parent_unit_set_cd IS NULL
CONNECT BY
PRIOR susa.person_id = p_person_id AND
PRIOR susa.course_cd = p_course_cd AND
PRIOR susa.unit_set_cd = susa.parent_unit_set_cd AND
PRIOR susa.sequence_number = susa.parent_sequence_number
ORDER BY LEVEL DESC;
SELECT ROWID, susa.*
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 = cp_unit_set_cd AND
susa.sequence_number = cp_sequence_number
FOR UPDATE OF
susa.LAST_UPDATE_DATE NOWAIT;
SELECT hesa_en_susa_id
FROM IGS_HE_EN_SUSA hes
WHERE hes.person_id = p_person_id AND
hes.course_cd = p_course_cd AND
hes.unit_set_cd = cp_unit_set_cd AND
hes.sequence_number = cp_sequence_number;
SELECT rowid
FROM IGS_HE_EN_SUSA hes
WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
SELECT he_susa_cc_id
FROM IGS_HE_EN_SUSA_CC hesc
WHERE hesc.person_id = p_person_id AND
hesc.course_cd = p_course_cd AND
hesc.unit_set_cd = cp_unit_set_cd AND
hesc.sequence_number = cp_sequence_number;
SELECT rowid
FROM IGS_HE_EN_SUSA_CC hesc
WHERE hesc.he_susa_cc_id = cp_he_susa_cc_id
FOR UPDATE OF hesc.LAST_UPDATE_DATE NOWAIT ;
IGS_GE_S_DSB_TAB_TRG_PKG.INSERT_ROW(
X_ROWID => L_ROWID ,
X_TABLE_NAME =>'ADMP_DEL_SCA_UNCONF',
X_SESSION_ID => userenv('SESSIONID'),
x_mode => 'R'
);
IGS_HE_EN_SUSA_PKG.DELETE_ROW(
X_ROWID => v_hes_del_rec.ROWID );
IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW(
X_ROWID => v_hesc_del_rec.ROWID );
IGS_AS_SU_SETATMPT_PKG.DELETE_ROW (
X_ROWID => V_SUSA_DEL_EXISTS.ROWID );
SELECT scho.start_dt
FROM IGS_EN_STDNTPSHECSOP scho
WHERE scho.person_id = p_person_id AND
scho.course_cd = p_course_cd;
SELECT ROWID, scho.*
FROM IGS_EN_STDNTPSHECSOP scho
WHERE scho.person_id = p_person_id AND
scho.course_cd = p_course_cd AND
scho.start_dt = cp_start_dt
FOR UPDATE OF
scho.LAST_UPDATE_DATE NOWAIT;
IGS_EN_STDNTPSHECSOP_PKG.DELETE_ROW (
X_ROWID => V_SCHO_DEL_EXISTS.ROWID );
SELECT ROWID, scae.*
FROM IGS_AS_SC_ATMPT_ENR scae
WHERE scae.person_id = p_person_id AND
scae.course_cd = p_course_cd
FOR UPDATE OF scae.LAST_UPDATE_DATE NOWAIT;
IGS_AS_SC_ATMPT_ENR_PKG.DELETE_ROW(v_scae_rec.rowid);
SELECT ROWID, scan.*
FROM IGS_AS_SC_ATMPT_NOTE scan
WHERE scan.person_id = p_person_id AND
scan.course_cd = p_course_cd
FOR UPDATE OF scan.reference_number NOWAIT;
IGS_AS_SC_ATMPT_NOTE_PKG.DELETE_ROW(v_scan_rec.rowid);
SELECT rowid, ca.*
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sca_course_cd = p_course_cd AND
ca.acai_admission_appl_number = p_adm_admission_appl_number AND
ca.acai_nominated_course_cd = p_adm_nominated_course_cd AND
ca.acai_sequence_number = p_adm_sequence_number
FOR UPDATE OF ca.sca_course_cd NOWAIT;
IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
X_ROWID => V_CA_REC.ROWID,
X_PERSON_ID => V_CA_REC.PERSON_ID,
X_SEQUENCE_NUMBER => V_CA_REC.SEQUENCE_NUMBER,
X_SCA_COURSE_CD => NULL,
X_ACAI_ADMISSION_APPL_NUMBER => V_CA_REC.ACAI_ADMISSION_APPL_NUMBER,
X_ACAI_NOMINATED_COURSE_CD => V_CA_REC.ACAI_NOMINATED_COURSE_CD,
X_ACAI_SEQUENCE_NUMBER => V_CA_REC.ACAI_SEQUENCE_NUMBER,
X_ATTENDANCE_PERCENTAGE => V_CA_REC.ATTENDANCE_PERCENTAGE,
X_GOVT_TYPE_OF_ACTIVITY_CD => V_CA_REC.GOVT_TYPE_OF_ACTIVITY_CD,
X_MAX_SUBMISSION_DT => V_CA_REC.MAX_SUBMISSION_DT,
X_MIN_SUBMISSION_DT => V_CA_REC.MIN_SUBMISSION_DT,
X_RESEARCH_TOPIC => V_CA_REC.RESEARCH_TOPIC,
X_INDUSTRY_LINKS => V_CA_REC.INDUSTRY_LINKS );
SELECT create_dt
FROM IGS_GR_GRADUAND_ALL gua
WHERE gua.person_id = p_person_id AND
gua.course_cd = p_course_cd;
SELECT rowid
FROM IGS_GR_GRADUAND_ALL gua
WHERE gua.person_id = p_person_id AND
gua.create_dt = cp_create_dt
FOR UPDATE OF gua.LAST_UPDATE_DATE NOWAIT ;
SELECT gach.gach_id
FROM IGS_GR_AWD_CRMN_HIST gach
WHERE gach.person_id = p_person_id AND
gach.create_dt = cp_create_dt;
SELECT rowid
FROM IGS_GR_AWD_CRMN_HIST gach
WHERE gach.gach_id = cp_gach_id
FOR UPDATE OF gach.LAST_UPDATE_DATE NOWAIT ;
SELECT gac.gac_id
FROM IGS_GR_AWD_CRMN gac
WHERE gac.person_id = p_person_id AND
gac.create_dt = cp_create_dt;
SELECT rowid
FROM IGS_GR_AWD_CRMN gac
WHERE gac.gac_id = cp_gac_id
FOR UPDATE OF gac.LAST_UPDATE_DATE NOWAIT ;
IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(
X_ROWID => c_gach_del_rec.ROWID );
IGS_GR_AWD_CRMN_PKG.DELETE_ROW(
X_ROWID => c_gac_del_rec.ROWID );
IGS_GR_GRADUAND_PKG.DELETE_ROW(
X_ROWID => v_gua_del_exists.rowid );
SELECT award_cd,
award_dt
FROM IGS_GR_SPECIAL_AWARD_ALL gsa
WHERE gsa.person_id = p_person_id AND
gsa.course_cd = p_course_cd;
SELECT rowid
FROM IGS_GR_SPECIAL_AWARD_ALL gsa
WHERE gsa.person_id = p_person_id AND
gsa.course_cd = p_course_cd AND
gsa.award_cd = cp_award_cd AND
gsa.award_dt = cp_award_dt
FOR UPDATE OF gsa.LAST_UPDATE_DATE NOWAIT ;
IGS_GR_SPECIAL_AWARD_PKG.DELETE_ROW(
X_ROWID => v_gsa_del_exists.rowid );
SELECT exit_course_cd,
exit_version_number
FROM IGS_PS_STDNT_APV_ALT psaa
WHERE psaa.person_id = p_person_id AND
psaa.course_cd = p_course_cd;
SELECT rowid
FROM IGS_PS_STDNT_APV_ALT psaa
WHERE psaa.person_id = p_person_id AND
psaa.course_cd = p_course_cd AND
psaa.exit_course_cd = cp_exit_course_cd AND
psaa.exit_version_number = cp_exit_version_number
FOR UPDATE OF psaa.LAST_UPDATE_DATE NOWAIT ;
IGS_PS_STDNT_APV_ALT_PKG.DELETE_ROW(
X_ROWID => v_psaa_del_exists.rowid );
SELECT special_requirement_cd,
completed_dt
FROM IGS_PS_STDNT_SPL_REQ pssr
WHERE pssr.person_id = p_person_id AND
pssr.course_cd = p_course_cd;
SELECT rowid
FROM IGS_PS_STDNT_SPL_REQ pssr
WHERE pssr.person_id = p_person_id AND
pssr.course_cd = p_course_cd AND
pssr.special_requirement_cd = cp_special_requirement_cd AND
pssr.completed_dt = cp_completed_dt
FOR UPDATE OF pssr.LAST_UPDATE_DATE NOWAIT ;
IGS_PS_STDNT_SPL_REQ_PKG.DELETE_ROW(
X_ROWID => v_pssr_del_exists.rowid );
SELECT award_cd
FROM IGS_EN_SPA_AWD_AIM esaa
WHERE esaa.person_id = p_person_id AND
esaa.course_cd = p_course_cd;
SELECT rowid
FROM IGS_EN_SPA_AWD_AIM esaa
WHERE esaa.person_id = p_person_id AND
esaa.course_cd = p_course_cd AND
esaa.award_cd = cp_award_cd
FOR UPDATE OF esaa.LAST_UPDATE_DATE NOWAIT ;
IGS_EN_SPA_AWD_AIM_PKG.DELETE_ROW(
X_ROWID => v_esaa_del_exists.rowid );
SELECT hesa_st_spa_id,
person_id,
course_cd
FROM IGS_HE_ST_SPA_ALL hssa
WHERE hssa.person_id = p_person_id AND
hssa.course_cd = p_course_cd;
SELECT rowid
FROM IGS_HE_ST_SPA_ALL hssa
WHERE hssa.hesa_st_spa_id = cp_hesa_st_spa_id
FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;
SELECT hesa_st_spau_id
FROM IGS_HE_ST_SPA_UT_ALL hssua
WHERE hssua.person_id = cp_person_id AND
hssua.course_cd = cp_course_cd ;
SELECT rowid
FROM IGS_HE_ST_SPA_UT_ALL hssua
WHERE hssua.hesa_st_spau_id = cp_hesa_st_spau_id
FOR UPDATE OF hssua.LAST_UPDATE_DATE NOWAIT ;
IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(
X_ROWID => v_hssua_del_rec.ROWID );
IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(
X_ROWID => v_hssa_del_exists.rowid );
SELECT progression_rule_cat,
sequence_number
FROM IGS_PR_RU_APPL_ALL pra
WHERE pra.sca_person_id = p_person_id AND
pra.sca_course_cd = p_course_cd;
SELECT rowid,pra.*
FROM IGS_PR_RU_APPL_ALL pra
WHERE pra.progression_rule_cat = cp_progression_rule_cat AND
pra.sequence_number = cp_sequence_number
FOR UPDATE OF pra.LAST_UPDATE_DATE NOWAIT ;
IGS_PR_RU_APPL_PKG.UPDATE_ROW (
X_ROWID => v_pra_upd_exists.rowid,
X_PROGRESSION_RULE_CAT => v_pra_upd_exists.progression_rule_cat ,
X_SEQUENCE_NUMBER => v_pra_upd_exists.sequence_number,
X_S_RELATION_TYPE => v_pra_upd_exists.s_relation_type,
X_PROGRESSION_RULE_CD => v_pra_upd_exists.progression_rule_cd,
X_REFERENCE_CD => v_pra_upd_exists.reference_cd,
X_RUL_SEQUENCE_NUMBER => v_pra_upd_exists.rul_sequence_number,
X_ATTENDANCE_TYPE => v_pra_upd_exists.attendance_type,
X_OU_ORG_UNIT_CD => v_pra_upd_exists.ou_org_unit_cd,
X_OU_START_DT => v_pra_upd_exists.ou_start_dt,
X_COURSE_TYPE => v_pra_upd_exists.course_type,
X_CRV_COURSE_CD => v_pra_upd_exists.crv_course_cd,
X_CRV_VERSION_NUMBER => v_pra_upd_exists.crv_version_number,
X_SCA_PERSON_ID => v_pra_upd_exists.sca_person_id,
X_SCA_COURSE_CD => v_pra_upd_exists.sca_course_cd,
X_PRO_PROGRESSION_RULE_CAT => v_pra_upd_exists.pro_progression_rule_cat,
X_PRO_PRA_SEQUENCE_NUMBER => v_pra_upd_exists.pro_pra_sequence_number,
X_PRO_SEQUENCE_NUMBER => v_pra_upd_exists.pro_sequence_number,
X_SPO_PERSON_ID => v_pra_upd_exists.spo_person_id,
X_SPO_COURSE_CD => v_pra_upd_exists.spo_course_cd,
X_SPO_SEQUENCE_NUMBER => v_pra_upd_exists.spo_sequence_number,
X_LOGICAL_DELETE_DT => TRUNC(SYSDATE),
X_MESSAGE => v_pra_upd_exists.message,
X_MODE => 'R',
X_MIN_CP => v_pra_upd_exists.min_cp,
X_MAX_CP => v_pra_upd_exists.max_cp,
X_IGS_PR_CLASS_STD_ID => v_pra_upd_exists.igs_pr_class_std_id
) ;
SELECT he_spa_cc_id
FROM IGS_HE_ST_SPA_CC hssc
WHERE hssc.person_id = p_person_id AND
hssc.course_cd = p_course_cd;
SELECT rowid
FROM IGS_HE_ST_SPA_CC hssc
WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;
IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(
X_ROWID => v_hssc_del_exists.ROWID );
v_delete_sca_ind := 'Y';
v_delete_sca_ind);
IF NOT v_process_next AND v_delete_sca_ind = 'Y' THEN
IGS_EN_STDNT_PS_ATT_PKG.DELETE_ROW(v_sca_upd_exists.rowid);
p_sca_deleted_ind => 'Y',
p_log_creation_dt => v_log_creation_dt,
p_key => v_key,
p_s_log_type => cst_del_un_sca);
fnd_file.put_line(fnd_file.log, 'Cannot delete unconfirm Student Program Attempt for Person ID:'|| l_term.person_id||
' and Course Code: '|| l_term.program_cd);
SELECT person_type_code
FROM igs_pe_typ_instances
WHERE person_id = p_person_id
AND sysdate BETWEEN start_date AND NVL(end_date, sysdate);
SELECT 'x'
FROM igs_pe_stup_data_emt
WHERE person_type_code = cp_person_type_code
AND UPPER(data_element) = UPPER(p_data_element)
AND required_ind = 'M';
SELECT 'x'
FROM igs_pe_stup_data_emt
WHERE person_type_code = cp_person_type_code
AND UPPER(data_element) = UPPER(p_data_element)
AND required_ind = 'P';
SELECT 'x'
FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt
WHERE sdt.person_type_code = pt.person_type_code
AND pt.system_type = 'OTHER'
AND UPPER(sdt.data_element) = UPPER(p_data_element)
AND sdt.required_ind = 'M';
SELECT 'x'
FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt
WHERE sdt.person_type_code = pt.person_type_code
AND pt.system_type = 'OTHER'
AND UPPER(sdt.data_element) = UPPER(p_data_element)
AND sdt.required_ind = 'P';
SELECT tl.user_form_name
FROM fnd_form_tl tl,
fnd_form_functions_vl vl
WHERE tl.form_id = vl.form_id
AND tl.language = USERENV ('LANG')
AND tl.application_id = 8405
AND vl.application_id = 8405
AND vl.function_name = p_function_name;