APPS.IGS_AV_VAL_ASULE dependencies on IGS_PS_UNIT_LEVEL

Line 19: -- Validate the IGS_PS_UNIT level closed indicator.

15: -------------------------------------------------------------------------------------------
16: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
17:
18: --
19: -- Validate the IGS_PS_UNIT level closed indicator.
20: FUNCTION advp_val_ule_closed(
21: p_unit_level IN VARCHAR2 ,
22: p_message_name OUT NOCOPY VARCHAR2)
23: RETURN BOOLEAN IS

Line 30: FROM IGS_PS_UNIT_LEVEL

26: v_other_detail VARCHAR2(255);
27: v_closed_ind CHAR;
28: CURSOR c_unit_level IS
29: SELECT closed_ind
30: FROM IGS_PS_UNIT_LEVEL
31: WHERE unit_level = p_unit_level;
32: BEGIN
33: -- Check if the IGS_PS_UNIT level is closed
34: p_message_name := null;

Line 33: -- Check if the IGS_PS_UNIT level is closed

29: SELECT closed_ind
30: FROM IGS_PS_UNIT_LEVEL
31: WHERE unit_level = p_unit_level;
32: BEGIN
33: -- Check if the IGS_PS_UNIT level is closed
34: p_message_name := null;
35: OPEN c_unit_level;
36: FETCH c_unit_level INTO v_closed_ind;
37: IF (c_unit_level%NOTFOUND) THEN