APPS.IGS_PS_VAL_COW dependencies on IGS_PS_OWN

Line 23: FROM IGS_PS_OWN

19: CV.version_number = p_version_number AND
20: CV.course_status = CS.course_status;
21: CURSOR gc_course_ownership_exists IS
22: SELECT 'x'
23: FROM IGS_PS_OWN
24: WHERE course_cd = p_course_cd AND
25: version_number = p_version_number;
26: gv_percent IGS_PS_OWN.PERCENTAGE%TYPE;
27:

Line 26: gv_percent IGS_PS_OWN.PERCENTAGE%TYPE;

22: SELECT 'x'
23: FROM IGS_PS_OWN
24: WHERE course_cd = p_course_cd AND
25: version_number = p_version_number;
26: gv_percent IGS_PS_OWN.PERCENTAGE%TYPE;
27:
28: CURSOR cur_user IS
29: SELECT SUM(percentage)
30: FROM IGS_PS_OWN

Line 30: FROM IGS_PS_OWN

26: gv_percent IGS_PS_OWN.PERCENTAGE%TYPE;
27:
28: CURSOR cur_user IS
29: SELECT SUM(percentage)
30: FROM IGS_PS_OWN
31: WHERE course_cd = p_course_cd AND
32: version_number = p_version_number;
33:
34:

Line 39: -- finding IGS_PS_OWN records

35: BEGIN
36: -- finding the s_course_status
37: OPEN gc_course_status;
38: FETCH gc_course_status INTO gv_course_status;
39: -- finding IGS_PS_OWN records
40: OPEN gc_course_ownership_exists;
41: FETCH gc_course_ownership_exists INTO gv_course_ownership;
42: -- Find the sum of all percentages
43:

Line 60: -- and no IGS_PS_OWN records exist

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;
64: p_message_name := NULL;

Line 69: -- or IGS_PS_OWN records exist

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';
73: RETURN FALSE;