1 PACKAGE hri_dbi_wmv_changes AS
2 /* $Header: hriwvch.pkh 120.0 2005/05/29 06:57:10 appldev noship $ */
3 --
4 -- Total Gain function returns total workforce gain by a supervisor
5 -- in a reporting period
6 --
7 FUNCTION calc_total_gain(p_supervisor_id IN NUMBER
8 ,p_effective_start_date IN DATE
9 ,p_effective_end_date IN DATE) RETURN NUMBER;
10 --
11 -- Total Gain function returns total workforce gain by a supervisor
12 -- in a reporting period
13 --
14 FUNCTION calc_total_gain_hire(p_supervisor_id IN NUMBER
15 ,p_effective_start_date IN DATE
16 ,p_effective_end_date IN DATE) RETURN NUMBER;
17 --
18 -- Total Gain function returns total workforce gain by a supervisor
19 -- in a reporting period
20 --
21 FUNCTION calc_total_gain_transfer(p_supervisor_id IN NUMBER
22 ,p_effective_start_date IN DATE
23 ,p_effective_end_date IN DATE) RETURN NUMBER;
24 --
25 -- Total Loss function returns total workforce loss by a supervisor
26 -- in a reporting period
27 --
28 FUNCTION calc_total_loss(p_supervisor_id IN NUMBER
29 ,p_effective_start_date IN DATE
30 ,p_effective_end_date IN DATE) RETURN NUMBER;
31 --
32 -- Total Loss function returns total workforce loss by a supervisor
33 -- in a reporting period
34 --
35 FUNCTION calc_total_loss_term(p_supervisor_id IN NUMBER
36 ,p_effective_start_date IN DATE
37 ,p_effective_end_date IN DATE) RETURN NUMBER;
38
39 FUNCTION calc_total_loss_term_vol(p_supervisor_id IN NUMBER
40 ,p_effective_start_date IN DATE
41 ,p_effective_end_date IN DATE)
42 RETURN NUMBER;
43
44 FUNCTION calc_total_loss_term_invol(p_supervisor_id IN NUMBER
45 ,p_effective_start_date IN DATE
46 ,p_effective_end_date IN DATE)
47 RETURN NUMBER;
48 --
49 -- Total Loss function returns total workforce loss by a supervisor
50 -- in a reporting period
51 --
52 FUNCTION calc_total_loss_transfer(p_supervisor_id IN NUMBER
53 ,p_effective_start_date IN DATE
54 ,p_effective_end_date IN DATE) RETURN NUMBER;
55 --
56 -- Total Net function returns total workforce gain-loss by a supervisor
57 -- in a reporting period
58 --
59 FUNCTION calc_total_net(p_supervisor_id IN NUMBER
60 ,p_effective_start_date IN DATE
61 ,p_effective_end_date IN DATE) RETURN NUMBER;
62 --
63 -- Full refresh procedure deletes and collects all data
64 --
65 PROCEDURE full_refresh(errbuf OUT NOCOPY VARCHAR2
66 ,retcode OUT NOCOPY VARCHAR2);
67 --
68 -- Refresh from deltas procedure collects data incrementally
69 --
70 PROCEDURE refresh_from_deltas(errbuf OUT NOCOPY VARCHAR2
71 ,retcode OUT NOCOPY VARCHAR2);
72
73 PROCEDURE refresh_from_deltas(errbuf OUT NOCOPY VARCHAR2
74 ,retcode OUT NOCOPY VARCHAR2
75 ,p_start_date IN VARCHAR2
76 ,p_end_date IN VARCHAR2);
77 --
78 END hri_dbi_wmv_changes;