APPS.IGS_PS_VAL_TR dependencies on IGS_PS_UNIT_STAT

Line 25: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

21: As a part of the Bug # 2696207
22: ********************************************************************************************** */
23:
24: gv_teach_respons CHAR;
25: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
26: CURSOR gc_unit_status IS
27: SELECT US.s_unit_status
28: FROM IGS_PS_UNIT_VER UV,
29: IGS_PS_UNIT_STAT US

Line 29: IGS_PS_UNIT_STAT US

25: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
26: CURSOR gc_unit_status IS
27: SELECT US.s_unit_status
28: FROM IGS_PS_UNIT_VER UV,
29: IGS_PS_UNIT_STAT US
30: WHERE UV.unit_cd = p_unit_cd AND
31: UV.version_number = p_version_number AND
32: UV.unit_status= US.unit_status;
33: CURSOR gc_teach_respons_exists IS

Line 71: -- if the IGS_PS_UNIT_STAT.s_unit_status is PLANNED

67: p_message_name := NULL;
68: RETURN TRUE;
69: ELSE
70: -- when the percentage doesn't total 100 and
71: -- if the IGS_PS_UNIT_STAT.s_unit_status is PLANNED
72: -- and no teaching responsibility records exist
73: IF (gv_unit_status = 'PLANNED' AND gc_teach_respons_exists%NOTFOUND) AND (NOT p_b_lgcy_validator) THEN
74: CLOSE gc_unit_status;
75: CLOSE gc_teach_respons_exists;

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

76: p_message_name := NULL;
77: RETURN TRUE;
78: ELSE
79: -- when the percentage doesn't total 100 and
80: -- if the IGS_PS_UNIT_STAT.s_unit_status is not PLANNED
81: -- or no teaching responsibility records exist
82: CLOSE gc_unit_status;
83: CLOSE gc_teach_respons_exists;
84: p_message_name := 'IGS_PS_TCHRESP_NOTTOTAL_100';