eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PS_VAL_CFOS dependencies on IGS_PS_FIELD_STUDY

Line 53: FROM IGS_PS_FIELD_STUDY

49: CV.version_number = p_version_number AND
50: CV.course_status = CS.course_status;
51: CURSOR gc_course_f_o_s_exists IS
52: SELECT 'x'
53: FROM IGS_PS_FIELD_STUDY
54: WHERE course_cd = p_course_cd AND
55: version_number = p_version_number;
56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,

Line 57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,

53: FROM IGS_PS_FIELD_STUDY
54: WHERE course_cd = p_course_cd AND
55: version_number = p_version_number;
56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,
58: cp_version_number igs_ps_field_study.version_number%TYPE )IS
59: SELECT NVL(SUM(percentage),0) sum_per,fos_type_code
60: FROM IGS_PS_FIELD_STUDY_V
61: WHERE FOS_TYPE_CODE <> 'CIP'

Line 58: cp_version_number igs_ps_field_study.version_number%TYPE )IS

54: WHERE course_cd = p_course_cd AND
55: version_number = p_version_number;
56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,
58: cp_version_number igs_ps_field_study.version_number%TYPE )IS
59: SELECT NVL(SUM(percentage),0) sum_per,fos_type_code
60: FROM IGS_PS_FIELD_STUDY_V
61: WHERE FOS_TYPE_CODE <> 'CIP'
62: AND course_cd = cp_course_cd

Line 60: FROM IGS_PS_FIELD_STUDY_V

56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,
58: cp_version_number igs_ps_field_study.version_number%TYPE )IS
59: SELECT NVL(SUM(percentage),0) sum_per,fos_type_code
60: FROM IGS_PS_FIELD_STUDY_V
61: WHERE FOS_TYPE_CODE <> 'CIP'
62: AND course_cd = cp_course_cd
63: AND version_number = cp_version_number
64: GROUP BY fos_type_code

Line 74: -- finding IGS_PS_FIELD_STUDY records

70: BEGIN
71: -- finding the s_course_status
72: OPEN gc_course_status;
73: FETCH gc_course_status INTO gv_course_status;
74: -- finding IGS_PS_FIELD_STUDY records
75: OPEN gc_course_f_o_s_exists;
76: FETCH gc_course_f_o_s_exists INTO gv_course_f_o_s;
77: -- Find the sum of all percentages
78: -- when the percentage totals 100

Line 90: -- and no IGS_PS_FIELD_STUDY records exist

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;
94: CLOSE gc_course_f_o_s_exists;

Line 100: -- or IGS_PS_FIELD_STUDY records exist

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;
104: p_message_name := 'IGS_PS_PRCALLOC_PRGFOS_100';

Line 122: -- v_course_field_of_study_rec IGS_PS_FIELD_STUDY%ROWTYPE;

118: --sarakshi 23-dec-2002 Bug#2689625,removed the when other part of the exception
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

Line 133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,

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:
133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,
134: cp_version_number igs_ps_field_study.version_number%TYPE )IS
135: SELECT fos_type_code
136: FROM IGS_PS_FIELD_STUDY_V out_fos
137: WHERE FOS_TYPE_Code <> 'CIP'

Line 134: cp_version_number igs_ps_field_study.version_number%TYPE )IS

130: CV.version_number = p_version_number AND
131: CV.course_status = CS.course_status;
132:
133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,
134: cp_version_number igs_ps_field_study.version_number%TYPE )IS
135: SELECT fos_type_code
136: FROM IGS_PS_FIELD_STUDY_V out_fos
137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd

Line 136: FROM IGS_PS_FIELD_STUDY_V out_fos

132:
133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,
134: cp_version_number igs_ps_field_study.version_number%TYPE )IS
135: SELECT fos_type_code
136: FROM IGS_PS_FIELD_STUDY_V out_fos
137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd
139: AND version_number = cp_version_number
140: AND NOT EXISTS( SELECT in_fos.FOS_TYPE_Code

Line 141: FROM IGS_PS_FIELD_STUDY_V in_fos

137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd
139: AND version_number = cp_version_number
140: AND NOT EXISTS( SELECT in_fos.FOS_TYPE_Code
141: FROM IGS_PS_FIELD_STUDY_V in_fos
142: WHERE in_fos.FOS_TYPE_Code = out_fos.FOS_TYPE_Code
143: AND in_fos.course_cd = out_fos.course_cd
144: AND in_fos.version_number = out_fos.version_number
145: AND major_field_ind = 'Y'

Line 152: FROM IGS_PS_FIELD_STUDY

148: v_course_field_of_study_rec c_course_field_of_study%ROWTYPE;
149:
150: CURSOR c_count_records IS
151: SELECT count(*)
152: FROM IGS_PS_FIELD_STUDY
153: WHERE course_cd = p_course_cd AND
154: version_number = p_version_number;
155: BEGIN
156: -- finding the s_course_status

Line 159: -- counting all IGS_PS_FIELD_STUDY records

155: BEGIN
156: -- finding the s_course_status
157: OPEN c_course_status;
158: FETCH c_course_status INTO v_course_status;
159: -- counting all IGS_PS_FIELD_STUDY records
160: -- based on the course_cd and version_number
161: OPEN c_count_records;
162: FETCH c_count_records INTO v_count_records;
163: IF c_count_records%NOTFOUND THEN

Line 167: -- selecting IGS_PS_FIELD_STUDY records based on course_cd,

163: IF c_count_records%NOTFOUND THEN
164: RAISE no_data_found;
165: END IF;
166: CLOSE c_count_records;
167: -- selecting IGS_PS_FIELD_STUDY records based on course_cd,
168: -- version_number and major_field_ind
169: OPEN c_course_field_of_study(p_course_cd,p_version_number);
170: FETCH c_course_field_of_study INTO v_course_field_of_study_rec;
171: IF c_course_field_of_study%NOTFOUND THEN

Line 174: -- when exactly one IGS_PS_FIELD_STUDY

170: FETCH c_course_field_of_study INTO v_course_field_of_study_rec;
171: IF c_course_field_of_study%NOTFOUND THEN
172:
173:
174: -- when exactly one IGS_PS_FIELD_STUDY
175: -- record is selected with a major_field_ind = 'Y'
176: CLOSE c_course_status;
177: CLOSE c_course_field_of_study;
178: p_message_name := NULL;

Line 189: -- when none/more than one IGS_PS_FIELD_STUDY

185: CLOSE c_course_field_of_study;
186: p_message_name := NULL;
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;

Line 228: FROM IGS_PS_FIELD_STUDY

224: v_cnt_field_of_study_rec NUMBER(5);
225: v_cnt_course_award_rec NUMBER(5);
226: CURSOR c_get_cnt_field_of_study_rec IS
227: SELECT count(*)
228: FROM IGS_PS_FIELD_STUDY
229: WHERE course_cd = p_course_cd AND
230: version_number = p_version_number;
231: CURSOR c_get_cnt_course_award_rec IS
232: SELECT count(*)