APPS.IGS_PS_VAL_COW dependencies on IGS_PS_STAT

Line 13: gv_course_status IGS_PS_STAT.s_course_status%TYPE;

9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN AS
11: -- gv_percent NUMBER;
12: gv_course_ownership CHAR;
13: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
14: CURSOR gc_course_status IS
15: SELECT CS.s_course_status
16: FROM IGS_PS_VER CV,
17: IGS_PS_STAT CS

Line 17: IGS_PS_STAT CS

13: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
14: CURSOR gc_course_status IS
15: SELECT CS.s_course_status
16: FROM IGS_PS_VER CV,
17: IGS_PS_STAT CS
18: WHERE CV.course_cd = p_course_cd AND
19: CV.version_number = p_version_number AND
20: CV.course_status = CS.course_status;
21: CURSOR gc_course_ownership_exists IS

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

55: p_message_name := NULL;
56: RETURN TRUE;
57: ELSE
58: -- when the percentage doesn't total 100 and
59: -- when the IGS_PS_STAT.s_unit_status is PLANNED
60: -- and no IGS_PS_OWN records exist
61: IF (gv_course_status = 'PLANNED' AND gc_course_ownership_exists%NOTFOUND) THEN
62: CLOSE gc_course_status;
63: CLOSE gc_course_ownership_exists;

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

64: p_message_name := NULL;
65: RETURN TRUE;
66: ELSE
67: -- when the percentage doesn't total 100 and
68: -- when the IGS_PS_STAT.s_unit_status is not PLANNED
69: -- or IGS_PS_OWN records exist
70: CLOSE gc_course_status;
71: CLOSE gc_course_ownership_exists;
72: p_message_name := 'IGS_PS_PRCALLOC_PRGOWN_100';