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.

APPS.IGS_PR_GET_CLASS_STD dependencies on IGS_PR_CSS_CLASS_STD

Line 34: l_min_cp_count igs_pr_css_class_std.min_cp%TYPE;

30: l_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE;
31: l_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE;
32: l_consider_changes igs_pr_cs_schdl.consider_changes%TYPE;
33: l_class_standing_override igs_pr_class_std.class_standing%TYPE;
34: l_min_cp_count igs_pr_css_class_std.min_cp%TYPE;
35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;
36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;

Line 35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;

31: l_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE;
32: l_consider_changes igs_pr_cs_schdl.consider_changes%TYPE;
33: l_class_standing_override igs_pr_class_std.class_standing%TYPE;
34: l_min_cp_count igs_pr_css_class_std.min_cp%TYPE;
35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;
36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;
39: l_dummy igs_pr_css_class_std.min_cp%TYPE;

Line 36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;

32: l_consider_changes igs_pr_cs_schdl.consider_changes%TYPE;
33: l_class_standing_override igs_pr_class_std.class_standing%TYPE;
34: l_min_cp_count igs_pr_css_class_std.min_cp%TYPE;
35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;
36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;
39: l_dummy igs_pr_css_class_std.min_cp%TYPE;
40: l_enrolled_cp igs_pr_css_class_std.min_cp%TYPE;

Line 38: l_cp igs_pr_css_class_std.min_cp%TYPE;

34: l_min_cp_count igs_pr_css_class_std.min_cp%TYPE;
35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;
36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;
39: l_dummy igs_pr_css_class_std.min_cp%TYPE;
40: l_enrolled_cp igs_pr_css_class_std.min_cp%TYPE;
41: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
42: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 39: l_dummy igs_pr_css_class_std.min_cp%TYPE;

35: l_acad_year_count igs_pr_css_class_std.acad_year%TYPE;
36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;
39: l_dummy igs_pr_css_class_std.min_cp%TYPE;
40: l_enrolled_cp igs_pr_css_class_std.min_cp%TYPE;
41: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
42: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
43: l_Load_Cal_type igs_ca_inst.cal_type%TYPE;

Line 40: l_enrolled_cp igs_pr_css_class_std.min_cp%TYPE;

36: l_acad_year igs_pr_css_class_std.acad_year%TYPE;
37: l_class_standing igs_pr_class_std.class_standing%TYPE;
38: l_cp igs_pr_css_class_std.min_cp%TYPE;
39: l_dummy igs_pr_css_class_std.min_cp%TYPE;
40: l_enrolled_cp igs_pr_css_class_std.min_cp%TYPE;
41: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
42: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
43: l_Load_Cal_type igs_ca_inst.cal_type%TYPE;
44: l_Load_Ci_Sequence_Number igs_ca_inst.sequence_number%TYPE;

Line 95: FROM igs_pr_css_class_std

91:
92: /* Cursors to get the class standing calculation method */
93: CURSOR C_cs_min_cp(cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE ) IS
94: SELECT COUNT(*)
95: FROM igs_pr_css_class_std
96: WHERE igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id
97: AND min_cp IS NOT NULL;
98: CURSOR C_cs_acad_yr(cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE ) IS
99: SELECT COUNT(*)

Line 100: FROM igs_pr_css_class_std

96: WHERE igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id
97: AND min_cp IS NOT NULL;
98: CURSOR C_cs_acad_yr(cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE ) IS
99: SELECT COUNT(*)
100: FROM igs_pr_css_class_std
101: WHERE igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id
102: AND acad_year IS NOT NULL;
103:
104: /* Cursor to get the academic year method details with load deatils */

Line 140: cp_acad_year igs_pr_css_class_std.acad_year%TYPE ) IS

136: AND cir3.sup_ci_sequence_number = ci1.sequence_number);
137:
138: /* Cursor to Select Class Standing matching the Period Range */
139: CURSOR C_Get_Cs_for_acad_yr(cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE,
140: cp_acad_year igs_pr_css_class_std.acad_year%TYPE ) IS
141: SELECT ipcs.class_standing
142: FROM igs_pr_css_class_std ipccs,
143: igs_pr_class_std ipcs
144: WHERE ipccs.igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id

Line 142: FROM igs_pr_css_class_std ipccs,

138: /* Cursor to Select Class Standing matching the Period Range */
139: CURSOR C_Get_Cs_for_acad_yr(cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE,
140: cp_acad_year igs_pr_css_class_std.acad_year%TYPE ) IS
141: SELECT ipcs.class_standing
142: FROM igs_pr_css_class_std ipccs,
143: igs_pr_class_std ipcs
144: WHERE ipccs.igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id
145: AND ipccs.acad_year = cp_acad_year
146: AND ipccs.igs_pr_class_std_id = ipcs.igs_pr_class_std_id;

Line 184: cp_cp igs_pr_css_class_std.min_cp%TYPE ) IS

180: AND ct.s_cal_cat = 'ACADEMIC';
181:
182: /*Cursor to SELECT Class Standing matching the CP RANGE */
183: CURSOR C_Get_cs_cp_range( cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE,
184: cp_cp igs_pr_css_class_std.min_cp%TYPE ) IS
185: SELECT ipcs.class_standing
186: FROM igs_pr_css_class_std ipccs,
187: igs_pr_class_std ipcs
188: WHERE ipccs.igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id

Line 186: FROM igs_pr_css_class_std ipccs,

182: /*Cursor to SELECT Class Standing matching the CP RANGE */
183: CURSOR C_Get_cs_cp_range( cp_igs_pr_cs_schdl_id igs_pr_cs_schdl.igs_pr_cs_schdl_id%TYPE,
184: cp_cp igs_pr_css_class_std.min_cp%TYPE ) IS
185: SELECT ipcs.class_standing
186: FROM igs_pr_css_class_std ipccs,
187: igs_pr_class_std ipcs
188: WHERE ipccs.igs_pr_cs_schdl_id = cp_igs_pr_cs_schdl_id
189: AND ipccs.min_cp <= cp_cp
190: AND ipccs.max_cp >= cp_cp