APPS.IGS_PS_VAL_CAO dependencies on IGS_PS_STAT

Line 47: gv_course_status IGS_PS_STAT.s_course_status%TYPE;

43: p_award_cd IN VARCHAR2 ,
44: p_message_name OUT NOCOPY VARCHAR2)
45: RETURN BOOLEAN AS
46: gv_course_award_own CHAR;
47: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
48: CURSOR gc_course_status IS
49: SELECT CS.s_course_status
50: FROM IGS_PS_VER CV,
51: IGS_PS_STAT CS

Line 51: IGS_PS_STAT CS

47: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
48: CURSOR gc_course_status IS
49: SELECT CS.s_course_status
50: FROM IGS_PS_VER CV,
51: IGS_PS_STAT CS
52: WHERE CV.course_cd = p_course_cd AND
53: CV.version_number = p_version_number AND
54: CV.course_status = CS.course_status;
55: CURSOR gc_course_award_own_exists IS

Line 90: -- when the IGS_PS_STAT.s_unit_status is PLANNED

86: p_message_name := NULL;
87: RETURN TRUE;
88: ELSE
89: -- when the percentage doesn't total 100 and
90: -- when the IGS_PS_STAT.s_unit_status is PLANNED
91: -- and no IGS_PS_AWD_OWN records exist
92: IF (gv_course_status = 'PLANNED' AND gc_course_award_own_exists%NOTFOUND) THEN
93: CLOSE gc_course_status;
94: CLOSE gc_course_award_own_exists;

Line 99: -- when the IGS_PS_STAT.s_unit_status is not PLANNED

95: p_message_name := NULL;
96: RETURN TRUE;
97: ELSE
98: -- when the percentage doesn't total 100 and
99: -- when the IGS_PS_STAT.s_unit_status is not PLANNED
100: -- or IGS_PS_AWD_OWN records exist
101: CLOSE gc_course_status;
102: CLOSE gc_course_award_own_exists;
103: p_message_name := 'IGS_PS_PRCALLOC_PRGAWARD_100';