APPS.IGS_OR_VAL_LOC dependencies on IGS_AD_LOCATION_TYPE

Line 4: -- Validate the IGS_AD_LOCATION type.

1: PACKAGE BODY IGS_OR_VAL_LOC AS
2: /* $Header: IGSOR05B.pls 115.7 2002/11/29 01:46:53 nsidana ship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
4: -- Validate the IGS_AD_LOCATION type.
5: FUNCTION orgp_val_loc_type(
6: p_location_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN IS

Line 11: FROM IGS_AD_LOCATION_TYPE

7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN IS
9: CURSOR c_lot IS
10: SELECT closed_ind
11: FROM IGS_AD_LOCATION_TYPE
12: WHERE location_type = p_location_type
13: AND closed_ind = 'Y';
14: v_other_detail VARCHAR2(255);
15: BEGIN

Line 40: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

36: BEGIN -- assp_val_loc_coord
37: -- Validate that the co-ordinator has been specified when the location
38: -- is an examination IGS_AD_LOCATION (ie; the system location type is 'EXAM_CTR').
39: DECLARE
40: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
41: BEGIN
42: -- Set the default message number
43: p_message_name := NULL;
44: -- Fetch system location type.

Line 125: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

121: -- Validate that the exam location can not be changed to a non-exam
122: -- location once venue or other examination related tables are related.
123: DECLARE
124: cst_exam_ctr CONSTANT VARCHAR2(10) := 'EXAM_CTR';
125: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
126: CURSOR c_ve IS
127: SELECT 'x'
128: FROM IGS_GR_VENUE
129: WHERE exam_location_cd = p_location_cd;