[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION grdp_val_gac_insert(
p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
p_message_name OUT NOCOPY VARCHAR2 )
RETURN BOOLEAN AS
BEGIN -- grdp_val_gac_insert
-- Description: This routine validates inserting a graduand_award_ceremony
-- record based on the graduand details.
DECLARE
v_gr_rec IGS_GR_GRADUAND.s_graduand_type%TYPE;
SELECT 'X'
FROM IGS_GR_GRADUAND gr
WHERE gr.person_id = p_person_id AND
gr.create_dt = p_create_dt AND
gr.s_graduand_type NOT IN (cst_unknown,
cst_attending,
cst_inabsentia);
END grdp_val_gac_insert;
-- Validate that the insert or update of a graduand_award_ceremony record
-- does not fall outside the graduation_ceremony update window.
DECLARE
CURSOR c_crd IS
SELECT crd.start_dt_alias,
crd.start_dai_sequence_number,
crd.end_dt_alias,
crd.end_dai_sequence_number
FROM IGS_GR_CRMN_ROUND crd
WHERE crd.grd_cal_type = p_grd_cal_type AND
crd.grd_ci_sequence_number = p_grd_ci_sequence_number;
SELECT gc.ceremony_dt_alias,
gc.ceremony_dai_sequence_number,
gc.closing_dt_alias,
gc.closing_dai_sequence_number
FROM IGS_GR_CRMN gc
WHERE gc.grd_cal_type = p_grd_cal_type AND
gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
gc.ceremony_number = p_ceremony_number;
SELECT 'x'
FROM IGS_GR_AWD_CRMN gac
WHERE gac.grd_cal_type = p_grd_cal_type AND
gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
gac.ceremony_number = p_ceremony_number AND
gac.person_id <> p_person_id AND
gac.graduand_seat_number = p_graduand_seat_number;
SELECT gr.course_cd,
gr.graduand_status
FROM IGS_GR_GRADUAND gr
WHERE gr.person_id = p_person_id AND
gr.create_dt = p_create_dt;
SELECT acus.unit_set_cd,
acus.us_version_number
FROM IGS_GR_AWD_CRM_UT_ST acus
WHERE acus.grd_cal_type = p_grd_cal_type AND
acus.grd_ci_sequence_number = p_grd_ci_sequence_number AND
acus.ceremony_number = p_ceremony_number AND
acus.award_course_cd = p_award_course_cd AND
acus.award_crs_version_number = p_award_crs_version_number AND
acus.award_cd = p_award_cd AND
acus.us_group_number = p_us_group_number;
SELECT susa.rqrmnts_complete_ind
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = cp_course_cd AND
susa.unit_set_cd = cp_unit_set_cd AND
susa.us_version_number = cp_us_version_number AND
susa.student_confirmed_ind = 'Y' AND
susa.primary_set_ind = 'Y' AND
susa.end_dt IS NULL;
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = cp_graduand_status;
SELECT 'x'
FROM IGS_CA_INST ci,
IGS_CA_STAT cs
WHERE ci.cal_type = p_grd_cal_type AND
ci.sequence_number = p_grd_ci_sequence_number AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status = 'ACTIVE';
SELECT 'X'
FROM IGS_GR_AWD_CRMN
WHERE grd_cal_type = p_grd_cal_type AND
grd_ci_sequence_number = p_grd_ci_sequence_number AND
ceremony_number = p_ceremony_number AND
person_id <> p_person_id AND
order_in_presentation = p_order_in_presentation;
SELECT acusg.closed_ind
FROM IGS_GR_AWD_CRM_US_GP acusg
WHERE acusg.grd_cal_type = p_grd_cal_type and
acusg.grd_ci_sequence_number = p_grd_ci_sequence_number and
acusg.ceremony_number = p_ceremony_number and
acusg.award_course_cd = p_award_course_cd and
acusg.award_crs_version_number =p_award_crs_version_number and
acusg.award_cd = p_award_cd and
acusg.us_group_number = p_us_group_number and
acusg.closed_ind ='Y';
SELECT 'X'
FROM IGS_GE_MEASUREMENT msr
WHERE msr.measurement_cd = p_measurement_cd AND
msr.closed_ind = 'Y';