APPS.IGS_OR_VAL_LR dependencies on IGS_AD_LOCATION_TYPE

Line 107: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

103: -- Can only set the default indicator when:
104: -- parent location has an s_location_type = CAMPUS and
105: -- child location has an s_location_type = EXAM_CTR or GRD_CTR
106: DECLARE
107: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
108: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
109: v_message_name VARCHAR2(30);
110: BEGIN
111: -- 1. Set the default message number

Line 108: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

104: -- parent location has an s_location_type = CAMPUS and
105: -- child location has an s_location_type = EXAM_CTR or GRD_CTR
106: DECLARE
107: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
108: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
109: v_message_name VARCHAR2(30);
110: BEGIN
111: -- 1. Set the default message number
112: p_message_name := NULL;

Line 165: IGS_AD_LOCATION_TYPE lot

161: CURSOR c_lr IS
162: SELECT 'x'
163: FROM IGS_AD_LOCATION_REL lr,
164: IGS_AD_LOCATION loc,
165: IGS_AD_LOCATION_TYPE lot
166: WHERE lr.location_cd = p_location_cd AND
167: lr.sub_location_cd <> p_sub_location_cd AND
168: lr.dflt_ind = 'Y' AND
169: lr.sub_location_cd = loc.location_cd AND

Line 207: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

203: BEGIN -- assp_val_lr_lr
204: -- Can not make a location with a system location type of CAMPUS
205: -- a child of a location with a system location type of EXAM_CTR or GRD_CTR
206: DECLARE
207: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
208: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
209: BEGIN
210: -- 1. Set the default message number
211: p_message_name := NULL;

Line 208: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

204: -- Can not make a location with a system location type of CAMPUS
205: -- a child of a location with a system location type of EXAM_CTR or GRD_CTR
206: DECLARE
207: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
208: v_sub_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
209: BEGIN
210: -- 1. Set the default message number
211: p_message_name := NULL;
212: -- 2. Check system location type for the locations in the relationship