[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- This module validates whether or not inserts and updates can be made to
-- IGS_EN_UNIT_SET
-- detail records (ie; record structures underneath the IGS_EN_UNIT_SET table)
SELECT uss.s_unit_set_status
FROM IGS_EN_UNIT_SET us,
IGS_EN_UNIT_SET_STAT uss
WHERE us.unit_set_cd = p_unit_set_cd AND
us.version_number = p_version_number AND
us.unit_set_status = uss.unit_set_status;
-- 1. Select the IGS_EN_UNIT_SET.IGS_EN_UNIT_SET_STAT for the given p_unit_cd and
-- p_version_number and
-- Select the IGS_EN_UNIT_SET_STAT.s_unit_set_status for the selected
-- IGS_EN_UNIT_SET.IGS_EN_UNIT_SET_STAT.
OPEN c_us;
SELECT 'x'
FROM IGS_PS_OFR_UNIT_SET cous
WHERE cous.course_cd = p_course_cd AND
cous.crv_version_number = p_crv_version_number AND
cous.cal_type = p_cal_type AND
cous.unit_set_cd = cp_unit_set_cd AND
cous.us_version_number = cp_us_version_number;
SELECT cousr.sub_unit_set_cd,
cousr.sub_us_version_number
FROM IGS_PS_OF_UNT_SET_RL cousr
WHERE cousr.course_cd = p_course_cd AND
cousr.crv_version_number = p_crv_version_number AND
cousr.cal_type = p_cal_type AND
cousr.sup_unit_set_cd = cp_sup_unit_set_cd AND
cousr.sup_us_version_number = cp_sup_us_version_number;
SELECT cacus.unit_set_cd
FROM IGS_PS_COO_AD_UNIT_S cacus
WHERE cacus.course_cd = p_course_cd AND
cacus.crv_version_number = p_crv_version_number AND
cacus.cal_type = p_cal_type AND
cacus.unit_set_cd = p_sub_unit_set_cd AND
cacus.us_version_number = p_sub_us_version_number;