APPS.IGS_PS_VAL_POS dependencies on IGS_PS_OFR_OPT

Line 132: -- that a IGS_PS_OFR_OPT record exists for the specified option.

128: p_message_name OUT NOCOPY VARCHAR2 )
129: RETURN BOOLEAN AS
130: BEGIN -- crsp_val_pos_coo
131: -- Warn the user if location_cd, IGS_EN_ATD_MODE or IGS_EN_ATD_TYPE are set
132: -- that a IGS_PS_OFR_OPT record exists for the specified option.
133: -- Warning only.
134: DECLARE
135: v_dummy VARCHAR2(1);
136: CURSOR c_coo IS

Line 138: FROM IGS_PS_OFR_OPT

134: DECLARE
135: v_dummy VARCHAR2(1);
136: CURSOR c_coo IS
137: SELECT 'x'
138: FROM IGS_PS_OFR_OPT
139: WHERE course_cd = p_course_cd AND
140: version_number = p_version_number AND
141: cal_type = p_cal_type AND
142: (p_location_cd IS NULL OR

Line 157: -- Check for IGS_PS_OFR_OPT records for the IGS_PS_COURSE offering supplied

153: p_cal_type IS NULL THEN
154: p_message_name := NULL;
155: RETURN TRUE;
156: END IF;
157: -- Check for IGS_PS_OFR_OPT records for the IGS_PS_COURSE offering supplied
158: -- and for IGS_EN_UNIT_SET versions with the uni_set_cd supplied which have a
159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:
160: OPEN c_coo;
161: FETCH c_coo INTO v_dummy;