1 PACKAGE BODY hri_dbi_wmv_changes AS
2 /* $Header: hriwvch.pkb 120.0 2005/05/29 06:57:05 appldev noship $ */
3
4 --
5 -- Total Gain function returns total workforce gain by a supervisor
6 -- in a reporting period
7 --
8 FUNCTION calc_total_gain(p_supervisor_id IN NUMBER
9 ,p_effective_start_date IN DATE
10 ,p_effective_end_date IN DATE) RETURN NUMBER
11 IS
12 BEGIN
13 RETURN NULL;
14 END;
15 --
16 -- Total Gain function returns total workforce gain by a supervisor
17 -- in a reporting period
18 --
19 FUNCTION calc_total_gain_hire(p_supervisor_id IN NUMBER
20 ,p_effective_start_date IN DATE
21 ,p_effective_end_date IN DATE) RETURN NUMBER
22 IS
23 BEGIN
24 RETURN NULL;
25 END;
26 --
27 -- Total Gain function returns total workforce gain by a supervisor
28 -- in a reporting period
29 --
30 FUNCTION calc_total_gain_transfer(p_supervisor_id IN NUMBER
31 ,p_effective_start_date IN DATE
32 ,p_effective_end_date IN DATE) RETURN NUMBER
33 IS
34 BEGIN
35 RETURN NULL;
36 END;
37 --
38 -- Total Loss function returns total workforce loss by a supervisor
39 -- in a reporting period
40 --
41 FUNCTION calc_total_loss(p_supervisor_id IN NUMBER
42 ,p_effective_start_date IN DATE
43 ,p_effective_end_date IN DATE) RETURN NUMBER
44 IS
45 BEGIN
46 RETURN NULL;
47 END;
48 --
49 -- Total Loss function returns total workforce loss by a supervisor
50 -- in a reporting period
51 --
52 FUNCTION calc_total_loss_term(p_supervisor_id IN NUMBER
53 ,p_effective_start_date IN DATE
54 ,p_effective_end_date IN DATE) RETURN NUMBER
55 IS
56 BEGIN
57 RETURN NULL;
58 END;
59
60 FUNCTION calc_total_loss_term_vol(p_supervisor_id IN NUMBER
61 ,p_effective_start_date IN DATE
62 ,p_effective_end_date IN DATE)
63 RETURN NUMBER
64 IS
65 BEGIN
66 RETURN NULL;
67 END;
68
69 FUNCTION calc_total_loss_term_invol(p_supervisor_id IN NUMBER
70 ,p_effective_start_date IN DATE
71 ,p_effective_end_date IN DATE)
72 RETURN NUMBER
73 IS
74 BEGIN
75 RETURN NULL;
76 END;
77 --
78 -- Total Loss function returns total workforce loss by a supervisor
79 -- in a reporting period
80 --
81 FUNCTION calc_total_loss_transfer(p_supervisor_id IN NUMBER
82 ,p_effective_start_date IN DATE
83 ,p_effective_end_date IN DATE) RETURN NUMBER
84 IS
85 BEGIN
86 RETURN NULL;
87 END;
88 --
89 -- Total Net function returns total workforce gain-loss by a supervisor
90 -- in a reporting period
91 --
92 FUNCTION calc_total_net(p_supervisor_id IN NUMBER
93 ,p_effective_start_date IN DATE
94 ,p_effective_end_date IN DATE) RETURN NUMBER
95 IS
96 BEGIN
97 RETURN NULL;
98 END;
99 --
100 -- Full refresh procedure deletes and collects all data
101 --
102 PROCEDURE full_refresh(errbuf OUT NOCOPY VARCHAR2
103 ,retcode OUT NOCOPY VARCHAR2)
104 IS
105 BEGIN
106 RETURN;
107 END;
108 --
109 -- Refresh from deltas procedure collects data incrementally
110 --
111 PROCEDURE refresh_from_deltas(errbuf OUT NOCOPY VARCHAR2
112 ,retcode OUT NOCOPY VARCHAR2)
113 IS
114 BEGIN
115 RETURN;
116 END;
117
118 PROCEDURE refresh_from_deltas(errbuf OUT NOCOPY VARCHAR2
119 ,retcode OUT NOCOPY VARCHAR2
120 ,p_start_date IN VARCHAR2
121 ,p_end_date IN VARCHAR2)
122 IS
123 BEGIN
124 RETURN;
125 END;
126 END hri_dbi_wmv_changes;