DBA Data[Home] [Help]

APPS.IGS_PS_USEC_CPS_PKG dependencies on IGS_PS_USEC_TCH_RESP_V

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