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_CA_INST

Line 41: l_acad_cal_type igs_ca_inst.cal_type%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;
45: l_effective_dt igs_pr_cs_schdl.start_dt%TYPE;

Line 42: l_acad_ci_sequence_number igs_ca_inst.sequence_number%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;
45: l_effective_dt igs_pr_cs_schdl.start_dt%TYPE;
46: l_earned_cp NUMBER;

Line 43: l_Load_Cal_type igs_ca_inst.cal_type%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;
45: l_effective_dt igs_pr_cs_schdl.start_dt%TYPE;
46: l_earned_cp NUMBER;
47: l_attempted_cp NUMBER;

Line 44: l_Load_Ci_Sequence_Number igs_ca_inst.sequence_number%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;
45: l_effective_dt igs_pr_cs_schdl.start_dt%TYPE;
46: l_earned_cp NUMBER;
47: l_attempted_cp NUMBER;
48: l_return_status VARCHAR2(100);

Line 105: CURSOR C_acad_year (cp_load_cal_type igs_ca_inst.cal_type%TYPE,

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 */
105: CURSOR C_acad_year (cp_load_cal_type igs_ca_inst.cal_type%TYPE,
106: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
107: SELECT COUNT(*)
108: FROM igs_ca_type ct1,
109: igs_ca_inst ci1

Line 106: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

102: AND acad_year IS NOT NULL;
103:
104: /* Cursor to get the academic year method details with load deatils */
105: CURSOR C_acad_year (cp_load_cal_type igs_ca_inst.cal_type%TYPE,
106: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
107: SELECT COUNT(*)
108: FROM igs_ca_type ct1,
109: igs_ca_inst ci1
110: WHERE ct1.s_cal_cat = 'ACADEMIC'

Line 109: igs_ca_inst ci1

105: CURSOR C_acad_year (cp_load_cal_type igs_ca_inst.cal_type%TYPE,
106: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
107: SELECT COUNT(*)
108: FROM igs_ca_type ct1,
109: igs_ca_inst ci1
110: WHERE ct1.s_cal_cat = 'ACADEMIC'
111: AND ct1.cal_type = ci1.cal_type
112: AND 0 < (SELECT COUNT(*)
113: FROM igs_ca_inst ci2a,

Line 113: FROM igs_ca_inst ci2a,

109: igs_ca_inst ci1
110: WHERE ct1.s_cal_cat = 'ACADEMIC'
111: AND ct1.cal_type = ci1.cal_type
112: AND 0 < (SELECT COUNT(*)
113: FROM igs_ca_inst ci2a,
114: igs_ca_inst ci2b,
115: igs_ca_type ct2,
116: igs_ca_inst_rel cir2
117: WHERE ci2a.cal_type = cp_load_cal_type

Line 114: igs_ca_inst ci2b,

110: WHERE ct1.s_cal_cat = 'ACADEMIC'
111: AND ct1.cal_type = ci1.cal_type
112: AND 0 < (SELECT COUNT(*)
113: FROM igs_ca_inst ci2a,
114: igs_ca_inst ci2b,
115: igs_ca_type ct2,
116: igs_ca_inst_rel cir2
117: WHERE ci2a.cal_type = cp_load_cal_type
118: AND ci2a.sequence_number = cp_load_ci_sequence_number

Line 116: igs_ca_inst_rel cir2

112: AND 0 < (SELECT COUNT(*)
113: FROM igs_ca_inst ci2a,
114: igs_ca_inst ci2b,
115: igs_ca_type ct2,
116: igs_ca_inst_rel cir2
117: WHERE ci2a.cal_type = cp_load_cal_type
118: AND ci2a.sequence_number = cp_load_ci_sequence_number
119: AND TRUNC(ci2a.end_dt) >= TRUNC(ci2b.end_dt)
120: AND cir2.sub_cal_type = ci2b.cal_type

Line 128: igs_ca_inst_rel cir3

124: AND ci2b.cal_type = ct2.cal_type
125: AND ct2.s_cal_cat = 'LOAD')
126: AND 0 < (SELECT COUNT(*)
127: FROM igs_en_su_attempt sua3,
128: igs_ca_inst_rel cir3
129: WHERE sua3.person_id = p_person_id
130: AND sua3.course_cd = p_course_cd
131: AND sua3.unit_attempt_status NOT IN
132: ('UNCONFIRM', 'DROPPED','DISCONTIN', 'WAITLISTED')

Line 153: igs_ca_inst ci

149: CURSOR c_load_ci (cp_consider_changes IGS_PR_CS_SCHDL.consider_changes%TYPE) IS
150: SELECT ci.cal_type,
151: ci.sequence_number
152: FROM igs_ca_type ct,
153: igs_ca_inst ci
154: WHERE ct.s_cal_cat = 'LOAD'
155: AND ct.cal_type = ci.cal_type
156: AND ((cp_consider_changes = 'IMMEDIATELY'
157: AND ((TRUNC(ci.start_dt) <= TRUNC(NVL(p_effective_dt, SYSDATE))

Line 171: CURSOR C_Get_acad_cal(cp_load_cal_type igs_ca_inst.cal_type%TYPE,

167: AND TRUNC(ci.end_dt) <= TRUNC(SYSDATE)))))
168: ORDER BY ci.end_dt DESC;
169:
170: /* Cursor to Get the academic calendar superior to the load calendar provided */
171: CURSOR C_Get_acad_cal(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
172: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
173: SELECT sup_cal_type,
174: sup_ci_sequence_number
175: FROM igs_ca_type ct,

Line 172: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

168: ORDER BY ci.end_dt DESC;
169:
170: /* Cursor to Get the academic calendar superior to the load calendar provided */
171: CURSOR C_Get_acad_cal(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
172: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
173: SELECT sup_cal_type,
174: sup_ci_sequence_number
175: FROM igs_ca_type ct,
176: igs_ca_inst_rel cir

Line 176: igs_ca_inst_rel cir

172: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
173: SELECT sup_cal_type,
174: sup_ci_sequence_number
175: FROM igs_ca_type ct,
176: igs_ca_inst_rel cir
177: WHERE cir.sub_cal_type = cp_load_cal_type
178: AND cir.sub_ci_sequence_number = cp_load_ci_sequence_number
179: AND cir.sup_cal_type = ct.cal_type
180: AND ct.s_cal_cat = 'ACADEMIC';