APPS.IGS_OR_VAL_LOC dependencies on IGS_OR_GEN_001

Line 45: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(

41: BEGIN
42: -- Set the default message number
43: p_message_name := NULL;
44: -- Fetch system location type.
45: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(
46: p_location_type);
47: IF (NVL(v_s_location_type, '-1') = 'EXAM_CTR') THEN
48: IF (p_coord_person_id IS NULL) THEN
49: -- The co-ordinator must be set for an examination location.

Line 88: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(

84: -- Set the default message number
85: p_message_name := NULL;
86: IF (p_closed_ind = 'Y') THEN
87: -- Fetch system location type.
88: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(
89: p_location_type);
90: IF (NVL(v_s_location_type, '-1') = 'EXAM_CTR') THEN
91: OPEN c_ve;
92: FETCH c_ve INTO v_ve_exists;

Line 135: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(

131: BEGIN
132: -- Set the default message number
133: p_message_name := NULL;
134: -- Fetch system location type for p_new_location_type.
135: v_s_location_type := IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2(
136: p_new_location_type);
137: IF (NVL(v_s_location_type, '-1') <> cst_exam_ctr) THEN
138: OPEN c_ve;
139: FETCH c_ve INTO v_ve_exists;