APPS.IGS_AS_VAL_VE dependencies on IGS_AD_LOCATION

Line 11: -- Validate IGS_AD_LOCATION closed indicator.

7: -- the reference to igs_as_val_ve.orgp_val_loc_closed is
8: -- changed to igs_as_val_els.orgp_val_loc_closed
9: -------------------------------------------------------------------------------------------
10: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
11: -- Validate IGS_AD_LOCATION closed indicator.
12: -- Retrofitted
13: FUNCTION assp_val_ve_lot(
14: p_exam_location_cd IGS_GR_VENUE_ALL.exam_location_cd%TYPE ,
15: p_message_name OUT NOCOPY VARCHAR2)

Line 23: FROM IGS_AD_LOCATION_TYPE lot,

19: -- Validate s_loc_type = EXAM_CTR or GRD_CTR
20: DECLARE
21: CURSOR c_lot IS
22: SELECT 'x'
23: FROM IGS_AD_LOCATION_TYPE lot,
24: IGS_AD_LOCATION loc
25: WHERE lot.location_type = loc.location_type AND
26: loc.location_cd = p_exam_location_cd AND
27: lot.s_location_type = 'EXAM_CTR' OR

Line 24: IGS_AD_LOCATION loc

20: DECLARE
21: CURSOR c_lot IS
22: SELECT 'x'
23: FROM IGS_AD_LOCATION_TYPE lot,
24: IGS_AD_LOCATION loc
25: WHERE lot.location_type = loc.location_type AND
26: loc.location_cd = p_exam_location_cd AND
27: lot.s_location_type = 'EXAM_CTR' OR
28: lot.s_location_type = 'GRD_CTR';

Line 37: -- The system IGS_AD_LOCATION type must be specified as EXAM_CTR or GRD_CTR

33: OPEN c_lot;
34: FETCH c_lot INTO v_lot_exists;
35: IF (c_lot%NOTFOUND) THEN
36: CLOSE c_lot;
37: -- The system IGS_AD_LOCATION type must be specified as EXAM_CTR or GRD_CTR
38: p_message_name := 'IGS_AS_SYS_LOCTYPE_EXAM_CTR';
39: RETURN FALSE;
40: END IF;
41: CLOSE c_lot;

Line 60: -- Cannot re-open a IGS_GR_VENUE when the IGS_AD_LOCATION is closed.

56: p_message_name OUT NOCOPY VARCHAR2)
57: RETURN BOOLEAN IS
58: gv_other_detail VARCHAR2(255);
59: BEGIN -- assp_val_ve_reopen
60: -- Cannot re-open a IGS_GR_VENUE when the IGS_AD_LOCATION is closed.
61: DECLARE
62: v_message_name varchar2(30);
63: BEGIN
64: -- Set the default message number