DBA Data[Home] [Help]

PACKAGE BODY: APPS.HRI_DBI_WMV_CHANGES

Source


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;