PACKAGE: APPS.IGS_PS_FAC_CREDT_WRKLOAD

Source

1 PACKAGE igs_ps_fac_credt_wrkload  AS
2  /* $Header: IGSPS74S.pls 120.0 2005/06/01 22:28:35 appldev noship $
3    CHANGE HISTORY
4    WHO               : ayedubat
5    WHEN              : 24-MAY-2001
6    WHAT              : Added two new Functions ,calc_total_work_load_lab and
7                        calc_total_work_load_lecture */
8 
9   FUNCTION prgp_get_lead_instructor(
10     p_uoo_id IN NUMBER)
11   RETURN VARCHAR2;
12   PRAGMA restrict_references(prgp_get_lead_instructor,wnds);
13 
14   FUNCTION calc_total_credit_point (
15     p_instructor_id IN NUMBER)
16   RETURN NUMBER;
17   PRAGMA restrict_references(calc_total_credit_point,wnds,wnps);
18 
19   FUNCTION calc_total_work_load (
20     p_instructor_id IN NUMBER)
21   RETURN NUMBER;
22   PRAGMA restrict_references(calc_total_work_load,wnds,wnps);
23 
24   FUNCTION calc_total_work_load_lab (
25     p_instructor_id IN NUMBER)
26   RETURN NUMBER;
27   PRAGMA restrict_references(calc_total_work_load_lab,wnds,wnps);
28 
29   FUNCTION calc_total_work_load_lecture (
30     p_instructor_id IN NUMBER)
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
40     );
41 
42   FUNCTION validate_workload(p_n_uoo_id IN NUMBER,
43 			     p_n_tot_wl_lec OUT NOCOPY NUMBER,
44 			     p_n_tot_wl_lab OUT NOCOPY NUMBER,
45 			     p_n_tot_wl OUT NOCOPY NUMBER) RETURN BOOLEAN;
46 
47   FUNCTION get_validation_type(p_c_unit_cd IN VARCHAR2,
48                                p_n_ver_num IN NUMBER) RETURN VARCHAR2;
49 
50 END igs_ps_fac_credt_wrkload;