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_CLASS_STD

Line 30: l_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE;

26: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
27: )
28: RETURN VARCHAR2 IS
29: /* Define the required local variables */
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;

Line 33: l_class_standing_override igs_pr_class_std.class_standing%TYPE;

29: /* Define the required local variables */
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;

Line 37: l_class_standing igs_pr_class_std.class_standing%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;
41: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 61: SELECT NVL(spat.class_standing_id,spa.igs_pr_class_std_id) igs_pr_class_std_id,

57: l_flag VARCHAR2(1);
58:
59: /* Cursor to get the Student Program Attempt and Class Standing Details */
60: CURSOR c_spa IS
61: SELECT NVL(spat.class_standing_id,spa.igs_pr_class_std_id) igs_pr_class_std_id,
62: css.igs_pr_cs_schdl_id,
63: css.consider_changes
64: FROM IGS_EN_STDNT_PS_ATT spa,
65: IGS_PS_VER pv,

Line 86: CURSOR C_cs_override(cp_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE ) IS

82: AND spat.term_sequence_number(+) = p_load_ci_sequence_number;
83:
84: /* Cursor to get the class standing overriden value */
85:
86: CURSOR C_cs_override(cp_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE ) IS
87: SELECT class_standing
88: FROM igs_pr_class_std
89: WHERE igs_pr_class_std_id = cp_igs_pr_class_std_id;
90:

Line 88: FROM igs_pr_class_std

84: /* Cursor to get the class standing overriden value */
85:
86: CURSOR C_cs_override(cp_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE ) IS
87: SELECT class_standing
88: FROM igs_pr_class_std
89: WHERE igs_pr_class_std_id = cp_igs_pr_class_std_id;
90:
91:
92: /* Cursors to get the class standing calculation method */

Line 89: WHERE igs_pr_class_std_id = cp_igs_pr_class_std_id;

85:
86: CURSOR C_cs_override(cp_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE ) IS
87: SELECT class_standing
88: FROM igs_pr_class_std
89: WHERE igs_pr_class_std_id = cp_igs_pr_class_std_id;
90:
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

Line 143: igs_pr_class_std ipcs

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;
147:

Line 146: AND ipccs.igs_pr_class_std_id = ipcs.igs_pr_class_std_id;

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;
147:
148: /* Cursor to Get the details of the most recent load calendar attempted */
149: CURSOR c_load_ci (cp_consider_changes IGS_PR_CS_SCHDL.consider_changes%TYPE) IS
150: SELECT ci.cal_type,

Line 187: igs_pr_class_std ipcs

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
191: AND ipccs.igs_pr_class_std_id = ipcs.igs_pr_class_std_id;

Line 191: AND ipccs.igs_pr_class_std_id = ipcs.igs_pr_class_std_id;

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
191: AND ipccs.igs_pr_class_std_id = ipcs.igs_pr_class_std_id;
192:
193: BEGIN
194:
195: l_flag := IGS_PR_USER_CLASS_STD.customized_class_standing_flag;

Line 280: FETCH c_spa INTO l_igs_pr_class_std_id,

276: RETURN NULL;
277: END IF;
278: /* Get Student Program Attempt and Program Type details*/
279: OPEN c_spa;
280: FETCH c_spa INTO l_igs_pr_class_std_id,
281: l_igs_pr_cs_schdl_id,
282: l_consider_changes;
283: /**
284: * Logging - l_igs_pr_class_std_id, l_igs_pr_cs_schdl_id, l_consider_changes

Line 284: * Logging - l_igs_pr_class_std_id, l_igs_pr_cs_schdl_id, l_consider_changes

280: FETCH c_spa INTO l_igs_pr_class_std_id,
281: l_igs_pr_cs_schdl_id,
282: l_consider_changes;
283: /**
284: * Logging - l_igs_pr_class_std_id, l_igs_pr_cs_schdl_id, l_consider_changes
285: *
286: */
287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
288: fnd_log.string (fnd_log.level_statement,

Line 291: 'l_igs_pr_class_std_id => '||l_igs_pr_class_std_id||';'||

287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
288: fnd_log.string (fnd_log.level_statement,
289: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
290: 'Student Program Attempt and Program Type details - '||
291: 'l_igs_pr_class_std_id => '||l_igs_pr_class_std_id||';'||
292: 'l_igs_pr_cs_schdl_id => '||l_igs_pr_cs_schdl_id||';'||
293: 'l_onsider_changes => '||l_consider_changes||';'
294: );
295: END IF;

Line 298: IF l_igs_pr_class_std_id IS NOT NULL THEN

294: );
295: END IF;
296: CLOSE c_spa;
297: /* Is the Class Standing Override values set*/
298: IF l_igs_pr_class_std_id IS NOT NULL THEN
299: OPEN C_cs_override(l_igs_pr_class_std_id);
300: FETCH C_cs_override INTO l_class_standing_override;
301: CLOSE C_cs_override;
302: /**

Line 299: OPEN C_cs_override(l_igs_pr_class_std_id);

295: END IF;
296: CLOSE c_spa;
297: /* Is the Class Standing Override values set*/
298: IF l_igs_pr_class_std_id IS NOT NULL THEN
299: OPEN C_cs_override(l_igs_pr_class_std_id);
300: FETCH C_cs_override INTO l_class_standing_override;
301: CLOSE C_cs_override;
302: /**
303: * Logging - l_class_standing_override