APPS.IGS_PS_VAL_CFOS dependencies on IGS_PS_STAT

Line 43: gv_course_status IGS_PS_STAT.s_course_status%TYPE;

39: -- who when What
40: --sarakshi 23-dec-2002 Bug#2689625,removed the when other part of the exception
41: --skpandey 10-Jul-2006 Bug#5343912,Modified cursor gc_percent and the code logic.
42: gv_course_f_o_s CHAR;
43: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
44: CURSOR gc_course_status IS
45: SELECT CS.s_course_status
46: FROM IGS_PS_VER CV,
47: IGS_PS_STAT CS

Line 47: IGS_PS_STAT CS

43: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
44: CURSOR gc_course_status IS
45: SELECT CS.s_course_status
46: FROM IGS_PS_VER CV,
47: IGS_PS_STAT CS
48: WHERE CV.course_cd = p_course_cd AND
49: CV.version_number = p_version_number AND
50: CV.course_status = CS.course_status;
51: CURSOR gc_course_f_o_s_exists IS

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

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

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_FIELD_STUDY records exist
101: CLOSE gc_percent;
102: CLOSE gc_course_status;
103: CLOSE gc_course_f_o_s_exists;

Line 123: v_course_status IGS_PS_STAT.s_course_status%TYPE;

119: --skpandey 10-Jul-2006 Bug#5343912, Modified cursor c_course_field_of_study and the code logic.
120: BEGIN
121: DECLARE
122: -- v_course_field_of_study_rec IGS_PS_FIELD_STUDY%ROWTYPE;
123: v_course_status IGS_PS_STAT.s_course_status%TYPE;
124: v_count_records NUMBER;
125: CURSOR c_course_status IS
126: SELECT CS.s_course_status
127: FROM IGS_PS_VER CV,

Line 128: IGS_PS_STAT CS

124: v_count_records NUMBER;
125: CURSOR c_course_status IS
126: SELECT CS.s_course_status
127: FROM IGS_PS_VER CV,
128: IGS_PS_STAT CS
129: WHERE CV.course_cd = p_course_cd AND
130: CV.version_number = p_version_number AND
131: CV.course_status = CS.course_status;
132:

Line 182: -- and the IGS_PS_STAT.s_unit_status is PLANNED

178: p_message_name := NULL;
179: RETURN TRUE;
180: ELSE
181: -- when no records are selected for the given IGS_PS_VER
182: -- and the IGS_PS_STAT.s_unit_status is PLANNED
183: IF (v_course_status = 'PLANNED' AND v_count_records = 0) THEN
184: CLOSE c_course_status;
185: CLOSE c_course_field_of_study;
186: p_message_name := NULL;

Line 191: -- major_field_ind = 'Y' and the IGS_PS_STAT.s_unit_status

187: RETURN TRUE;
188: ELSE
189: -- when none/more than one IGS_PS_FIELD_STUDY
190: -- record is selected for the given IGS_PS_VER with a
191: -- major_field_ind = 'Y' and the IGS_PS_STAT.s_unit_status
192: -- is not PLANNED
193: CLOSE c_course_status;
194: CLOSE c_course_field_of_study;
195: p_message_name := 'IGS_PS_ONLYONE_FOS_MAJORPRG';