DBA Data[Home] [Help]

APPS.IGS_OR_VAL_LR dependencies on IGS_OR_GEN_001

Line 117: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(

113: IF (p_dflt_ind = 'Y') THEN
114: -- 1. Validate system location types are appropriate for setting
115: -- the default indicator
116: -- Fetch system location type for parent location.
117: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
118: p_location_cd);
119: IF (NVL(v_s_location_type, '-1') <> 'CAMPUS') THEN
120: -- The system location type for the parent location must be
121: -- of type 'CAMPUS' when setting the default indicator.

Line 126: v_sub_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(

122: p_message_name := 'IGS_AS_SYS_LOCTYPE_CAMPUS';
123: RETURN FALSE;
124: END IF;
125: -- Fetch system location type for a child locations.
126: v_sub_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
127: p_sub_location_cd);
128: IF (NVL(v_sub_s_location_type, '-1') <> 'EXAM_CTR' AND
129: NVL(v_sub_s_location_type, '-1') <> 'GRD_CTR') THEN
130: -- The system location type for the child location must be

Line 214: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(

210: -- 1. Set the default message number
211: p_message_name := NULL;
212: -- 2. Check system location type for the locations in the relationship
213: -- Fetch system location type for parent IGS_AD_LOCATION.
214: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
215: p_location_cd);
216: -- Fetch system location type for a child locations.
217: v_sub_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
218: p_sub_location_cd);

Line 217: v_sub_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(

213: -- Fetch system location type for parent IGS_AD_LOCATION.
214: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
215: p_location_cd);
216: -- Fetch system location type for a child locations.
217: v_sub_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE(
218: p_sub_location_cd);
219: IF ( (NVL(v_s_location_type, '-1') = 'GRD_CTR' OR
220: NVL(v_s_location_type, '-1') = 'EXAM_CTR') AND
221: NVL(v_sub_s_location_type, '-1') = 'CAMPUS') THEN