APPS.IGS_PS_VAL_UOO dependencies on IGS_AD_LOCATION_TYPE

Line 19: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

15: p_message_name OUT NOCOPY VARCHAR2 )
16: RETURN BOOLEAN AS
17: v_location_closed_ind IGS_AD_LOCATION.closed_ind%TYPE;
18: v_location_type IGS_AD_LOCATION.location_type%TYPE;
19: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
20: CURSOR c_location_cd(
21: cp_location_cd IGS_AD_LOCATION.location_cd%TYPE) IS
22: SELECT IGS_AD_LOCATION.closed_ind,
23: location_type

Line 27: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS

23: location_type
24: FROM IGS_AD_LOCATION
25: WHERE location_cd = cp_location_cd;
26: CURSOR c_location_type(
27: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS
28: SELECT s_location_type
29: FROM IGS_AD_LOCATION_TYPE
30: WHERE location_type = cp_location_type;
31: BEGIN

Line 29: FROM IGS_AD_LOCATION_TYPE

25: WHERE location_cd = cp_location_cd;
26: CURSOR c_location_type(
27: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS
28: SELECT s_location_type
29: FROM IGS_AD_LOCATION_TYPE
30: WHERE location_type = cp_location_type;
31: BEGIN
32: -- This module based on the parameter performs validations
33: -- for for the IGS_AD_LOCATION code within the CS and P subsystem

Line 50: -- Test the value of system IGS_AD_LOCATION type

46: p_message_name := 'IGS_PS_LOC_CODE_CLOSED';
47: RETURN FALSE;
48: END IF;
49: END IF;
50: -- Test the value of system IGS_AD_LOCATION type
51: OPEN c_location_type(
52: v_location_type);
53: FETCH c_location_type INTO v_s_location_type;
54: CLOSE c_location_type;