APPS.IGS_PS_USEC_CPS_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 121: FROM igs_ps_usec_tch_resp iputr

117: -- Select the teaching responsibilites record which has only workload percentage defined and not
118: -- other workload values defined.
119: CURSOR c_teach_resp(p_uoo_id NUMBER) IS
120: SELECT rowid,iputr.*
121: FROM igs_ps_usec_tch_resp iputr
122: WHERE iputr.uoo_id = p_uoo_id AND
123: iputr.percentage_allocation IS NOT NULL AND
124: iputr.instructional_load_lab IS NULL AND
125: iputr.instructional_load_lecture IS NULL AND

Line 128: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;

124: iputr.instructional_load_lab IS NULL AND
125: iputr.instructional_load_lecture IS NULL AND
126: iputr.instructional_load IS NULL;
127:
128: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
129: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
130: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
131:
132: BEGIN

Line 129: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;

125: iputr.instructional_load_lecture IS NULL AND
126: iputr.instructional_load IS NULL;
127:
128: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
129: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
130: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
131:
132: BEGIN
133: -- if the workload value are updated

Line 130: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;

126: iputr.instructional_load IS NULL;
127:
128: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
129: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
130: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
131:
132: BEGIN
133: -- if the workload value are updated
134: IF (p_updating = TRUE AND ( NVL(new_references.work_load_other,-1) <> NVL(old_references.work_load_other,-1) OR

Line 143: igs_ps_usec_tch_resp_pkg.update_row (

139:
140: FOR c_teach_resp_rec in c_teach_resp(new_references.uoo_id)
141: LOOP
142: igs_ps_fac_credt_wrkload.calculate_teach_work_load(c_teach_resp_rec.uoo_id,c_teach_resp_rec.percentage_allocation,l_new_lab,l_new_lecture,l_new_other);
143: igs_ps_usec_tch_resp_pkg.update_row (
144: x_mode => 'R',
145: x_rowid => c_teach_resp_rec.rowid,
146: x_unit_section_teach_resp_id => c_teach_resp_rec.unit_section_teach_resp_id,
147: x_instructor_id => c_teach_resp_rec.instructor_id,