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_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PS_USEC_TCH_RESP

Line 40: FROM igs_ps_usec_tch_resp utr,

36: ***************************************************************/
37:
38: CURSOR cur_lead_instructor IS
39: SELECT pe.last_name || ', ' || pe.title || ' ' || NVL(pe.known_as,pe.first_name) instructor_name
40: FROM igs_ps_usec_tch_resp utr,
41: igs_pe_person_base_v pe,
42: igs_pe_person_id_typ ppi,
43: igs_pe_alt_pers_id pit
44: WHERE utr.instructor_id = pe.person_id AND

Line 83: FROM igs_ps_usec_tch_resp utr

79: ***************************************************************/
80:
81: CURSOR cur_uoo (cp_instructor_id IN NUMBER) IS
82: SELECT DISTINCT (uoo_id) uoo_id
83: FROM igs_ps_usec_tch_resp utr
84: WHERE instructor_id = cp_instructor_id;
85:
86: CURSOR cur_cp (cp_uoo_id IN VARCHAR2) IS
87: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points

Line 129: FROM igs_ps_usec_tch_resp utr

125: ***************************************************************/
126:
127: CURSOR cur_wl (cp_instructor_id IN NUMBER) IS
128: SELECT SUM(instructional_load) total_work_load
129: FROM igs_ps_usec_tch_resp utr
130: WHERE utr.confirmed_flag='Y'
131: AND utr.instructor_id = cp_instructor_id;
132:
133: lv_total_work_load NUMBER := 0;

Line 159: FROM igs_ps_usec_tch_resp utr

155: ***************************************************************/
156:
157: CURSOR cur_wl_lab (cp_instructor_id IN NUMBER) IS
158: SELECT SUM(instructional_load_lab) total_work_load_lab
159: FROM igs_ps_usec_tch_resp utr
160: WHERE utr.confirmed_flag='Y'
161: AND utr.instructor_id = cp_instructor_id;
162:
163: lv_total_work_load_lab NUMBER := 0;

Line 190: FROM igs_ps_usec_tch_resp utr

186: ***************************************************************/
187:
188: CURSOR cur_wl_lecture (cp_instructor_id IN NUMBER) IS
189: SELECT SUM(instructional_load_lecture) total_work_load_lecture
190: FROM igs_ps_usec_tch_resp utr
191: WHERE utr.confirmed_flag='Y'
192: AND utr.instructor_id = cp_instructor_id;
193:
194: lv_total_work_load_lecture NUMBER DEFAULT 0;

Line 204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,

200: RETURN lv_total_work_load_lecture;
201: END calc_total_work_load_lecture;
202:
203: PROCEDURE calculate_teach_work_load (
204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE

Line 205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,

201: END calc_total_work_load_lecture;
202:
203: PROCEDURE calculate_teach_work_load (
204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
209: ) IS

Line 206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,

202:
203: PROCEDURE calculate_teach_work_load (
204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
209: ) IS
210:

Line 207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,

203: PROCEDURE calculate_teach_work_load (
204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
209: ) IS
210:
211: ------------------------------------------------------------------

Line 208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE

204: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
205: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
206: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
207: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
208: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
209: ) IS
210:
211: ------------------------------------------------------------------
212: --Created by : pradhakr, Oracle IDC

Line 311: FROM igs_ps_usec_tch_resp

307: CURSOR c_tr_workload(cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
308: SELECT NVL(SUM (instructional_load_lecture),-999) lecture_workload,
309: NVL(SUM (instructional_load_lab),-999) laboratory_workload,
310: NVL(SUM (instructional_load),-999) other_workload
311: FROM igs_ps_usec_tch_resp
312: WHERE uoo_id = cp_n_uoo_id
313: AND confirmed_flag = 'Y';
314:
315: rec_tr_workload c_tr_workload%ROWTYPE;