31: RETURN NUMBER;
32: PRAGMA restrict_references(calc_total_work_load_lecture,wnds,wnps);
33:
34: PROCEDURE calculate_teach_work_load (
35: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
36: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
37: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
38: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
39: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
32: PRAGMA restrict_references(calc_total_work_load_lecture,wnds,wnps);
33:
34: PROCEDURE calculate_teach_work_load (
35: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
36: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
37: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
38: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
39: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
40: );
33:
34: PROCEDURE calculate_teach_work_load (
35: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
36: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
37: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
38: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
39: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
40: );
41:
34: PROCEDURE calculate_teach_work_load (
35: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
36: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
37: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
38: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
39: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
40: );
41:
42: FUNCTION validate_workload(p_n_uoo_id IN NUMBER,
35: p_uoo_id IN igs_ps_usec_tch_resp_v.uoo_id%TYPE,
36: p_percent_allocation IN igs_ps_usec_tch_resp_v.percentage_allocation%TYPE,
37: p_wl_lab OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE,
38: p_wl_lecture OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE,
39: p_wl_other OUT NOCOPY igs_ps_usec_tch_resp_v.instructional_load%TYPE
40: );
41:
42: FUNCTION validate_workload(p_n_uoo_id IN NUMBER,
43: p_n_tot_wl_lec OUT NOCOPY NUMBER,