1 PACKAGE hri_bpl_dbi_calc_period AS
2 /* $Header: hribdcrp.pkh 120.6 2005/11/10 01:53:36 jrstewar noship $ */
3
4 PROCEDURE calc_sup_absence(p_supervisor_id IN NUMBER,
5 p_from_date IN DATE,
6 p_to_date IN DATE,
7 p_period_type IN VARCHAR2,
8 p_comparison_type IN VARCHAR2,
9 p_total_type IN VARCHAR2,
10 p_wkth_wktyp_sk_fk IN VARCHAR2,
11 p_total_abs_drtn_days OUT NOCOPY NUMBER,
12 p_total_abs_drtn_hrs OUT NOCOPY NUMBER,
13 p_total_abs_in_period OUT NOCOPY NUMBER,
14 p_total_abs_ntfctn_period OUT NOCOPY NUMBER);
15
16 PROCEDURE calc_sup_wcnt_chg(p_supervisor_id IN NUMBER,
17 p_from_date IN DATE,
18 p_to_date IN DATE,
19 p_period_type IN VARCHAR2,
20 p_comparison_type IN VARCHAR2,
21 p_total_type IN VARCHAR2,
22 p_total_gain_hire OUT NOCOPY NUMBER,
23 p_total_gain_transfer OUT NOCOPY NUMBER,
24 p_total_loss_term OUT NOCOPY NUMBER,
25 p_total_loss_transfer OUT NOCOPY NUMBER);
26
27 PROCEDURE calc_sup_wcnt_chg(p_supervisor_id IN NUMBER,
28 p_from_date IN DATE,
29 p_to_date IN DATE,
30 p_period_type IN VARCHAR2,
31 p_comparison_type IN VARCHAR2,
32 p_total_type IN VARCHAR2,
33 p_wkth_wktyp_sk_fk IN VARCHAR2,
34 p_total_gain_hire OUT NOCOPY NUMBER,
35 p_total_gain_transfer OUT NOCOPY NUMBER,
36 p_total_loss_term OUT NOCOPY NUMBER,
37 p_total_loss_transfer OUT NOCOPY NUMBER);
38
39 PROCEDURE calc_sup_turnover(p_supervisor_id IN NUMBER,
40 p_from_date IN DATE,
41 p_to_date IN DATE,
42 p_period_type IN VARCHAR2,
43 p_comparison_type IN VARCHAR2,
44 p_total_type IN VARCHAR2,
45 p_wkth_wktyp_sk_fk IN VARCHAR2,
46 p_total_trn_vol OUT NOCOPY NUMBER,
47 p_total_trn_invol OUT NOCOPY NUMBER);
48
49 /* Total terminations by supervisor and length of service */
50 /**********************************************************/
51 PROCEDURE calc_sup_term_low_pvt
52 (p_supervisor_id IN NUMBER,
53 p_from_date IN DATE,
54 p_to_date IN DATE,
55 p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
56 p_total_term OUT NOCOPY NUMBER,
57 p_total_term_b1 OUT NOCOPY NUMBER,
58 p_total_term_b2 OUT NOCOPY NUMBER,
59 p_total_term_b3 OUT NOCOPY NUMBER,
60 p_total_term_b4 OUT NOCOPY NUMBER,
61 p_total_term_b5 OUT NOCOPY NUMBER);
62
63 PROCEDURE calc_sup_term_perf_pvt
64 (p_supervisor_id IN NUMBER,
65 p_from_date IN DATE,
66 p_to_date IN DATE,
67 p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
68 p_total_term OUT NOCOPY NUMBER,
69 p_total_term_b1 OUT NOCOPY NUMBER,
70 p_total_term_b2 OUT NOCOPY NUMBER,
71 p_total_term_b3 OUT NOCOPY NUMBER,
72 p_total_term_na OUT NOCOPY NUMBER);
73
74 PROCEDURE calc_sup_term_pvt
75 (p_supervisor_id IN NUMBER,
76 p_from_date IN DATE,
77 p_to_date IN DATE,
78 p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
79 p_total_term_vol OUT NOCOPY NUMBER,
80 p_total_term_invol OUT NOCOPY NUMBER,
81 p_total_term OUT NOCOPY NUMBER);
82
83 /* Get Termination and Hire Date */
84 /*********************************/
85
86 FUNCTION get_term_date(p_assignment_id IN NUMBER
87 ,p_person_id IN NUMBER)
88
89 RETURN DATE;
90
91 END hri_bpl_dbi_calc_period;