APPS.IGS_PS_VAL_UD dependencies on IGS_PS_UNIT_STAT

Line 61: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

57: ********************************************************************************************** */
58:
59: gv_percent NUMBER;
60: gv_unit_discip_exists CHAR;
61: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
62: CURSOR gc_unit_status IS
63: SELECT US.s_unit_status
64: FROM IGS_PS_UNIT_VER UV,
65: IGS_PS_UNIT_STAT US

Line 65: IGS_PS_UNIT_STAT US

61: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
62: CURSOR gc_unit_status IS
63: SELECT US.s_unit_status
64: FROM IGS_PS_UNIT_VER UV,
65: IGS_PS_UNIT_STAT US
66: WHERE UV.unit_cd = p_unit_cd AND
67: UV.version_number = p_version_number AND
68: UV.unit_status = US.unit_status;
69: CURSOR gc_unit_discip_exists IS

Line 83: -- finding the IGS_PS_UNIT_STAT

79: version_number= p_version_number;
80:
81:
82: BEGIN
83: -- finding the IGS_PS_UNIT_STAT
84: OPEN gc_unit_status;
85: FETCH gc_unit_status INTO gv_unit_status;
86: -- finding unit_responsibility records
87: OPEN gc_unit_discip_exists;

Line 107: -- when the IGS_PS_UNIT_STAT.s_unit_status is PLANNED

103: p_message_name := NULL;
104: RETURN TRUE;
105: ELSE
106: -- when the percentage doesn't total 100 and
107: -- when the IGS_PS_UNIT_STAT.s_unit_status is PLANNED
108: -- and no IGS_PS_UNIT_DSCP records exists
109: IF (gv_unit_status = 'PLANNED' AND gc_unit_discip_exists%NOTFOUND) AND (NOT p_b_lgcy_validator) THEN
110: CLOSE gc_unit_status;
111: CLOSE gc_unit_discip_exists;

Line 116: -- if the IGS_PS_UNIT_STAT.s_unit_status is not PLANNED

112: p_message_name := NULL;
113: RETURN TRUE;
114: ELSE
115: -- when the percentage doesn't total 100 and
116: -- if the IGS_PS_UNIT_STAT.s_unit_status is not PLANNED
117: -- or no IGS_PS_UNIT responsibility records exists
118: CLOSE gc_unit_status;
119: CLOSE gc_unit_discip_exists;
120: p_message_name := 'IGS_PS_UNITDISCP_NOTTOTAL_100';