[Home] [Help]
PACKAGE BODY: APPS.HRI_DBI_WMV_COUNT
Source
1 PACKAGE BODY HRI_DBI_WMV_COUNT AS
2 /* $Header: hriwmvco.pkb 120.0 2005/05/29 07:49:43 appldev noship $ */
3 --
4 --************************************************************
5 --* Calculate total ABV count as of p_effective_start_date-1 *
6 --************************************************************
7 --
8 PROCEDURE calc_wmv_count(p_effective_start_date IN DATE
9 ,p_effective_end_date IN DATE)
10 IS
11 BEGIN
12 RETURN;
13 END;
14 --
15 --********************
16 --* Calculate events *
17 --********************
18 PROCEDURE calc_events(p_supervisor_id IN NUMBER DEFAULT NULL
19 ,p_location_id IN NUMBER DEFAULT NULL
20 ,p_effective_start_date IN DATE
21 ,p_effective_end_date IN DATE)
22 IS
23 BEGIN
24 RETURN;
25 END;
26 --
27 --************************************
28 --*Calculate new hire + transfers in *
29 --************************************
30 --
31 PROCEDURE calc_new_hire_trans_in
32 IS
33 BEGIN
34 RETURN;
35 END;
36 --
37 --******************************************
38 --* Calculate terminations + transfers out *
39 --******************************************
40 --
41 PROCEDURE calc_term_trans_out
42 IS
43 BEGIN
44 RETURN;
45 END;
46 --
47 --******************************************************************
48 --* Calculate location transfers - no change to supervisors or job *
49 --******************************************************************
50 --
51 PROCEDURE calc_event_loc_transfer (p_effective_start_date IN DATE
52 ,p_effective_end_date IN DATE)
53 IS
54 BEGIN
55 RETURN;
56 END;
57 --
58 --******************************************************************
59 --* Calculate job transfers - no change to supervisors or location *
60 --******************************************************************
61 --
62 PROCEDURE calc_event_job_transfer (p_effective_start_date IN DATE
63 ,p_effective_end_date IN DATE)
64 IS
65 BEGIN
66 RETURN;
67 END;
68 --
69 --***************************************************************
70 --* Calculate job/location transfers - no change to supervisors *
71 --***************************************************************
72 --
73 PROCEDURE calc_event_job_loc_transfer (p_effective_start_date IN DATE
74 ,p_effective_end_date IN DATE)
75 IS
76 BEGIN
77 RETURN;
78 END;
79 --
80 --*********************************************************************
81 --
82 --*****************************
83 --* Calculate distinct events *
84 --*****************************
85 --
86 PROCEDURE calc_distinct_events
87 IS
88 BEGIN
89 RETURN;
90 END;
91 --
92 --************************************
93 --* Remove duplicates from Temp table*
94 --************************************
95 --
96 PROCEDURE calc_remove_duplicate
97 IS
98 BEGIN
99 RETURN;
100 END;
101 --
102 --*************************************
103 --*Print Global Temp Table in Log File*
104 --*************************************
105 --
106 PROCEDURE calc_print_temp_table
107 IS
108 BEGIN
109 RETURN;
110 END;
111 --
112 --****************
113 --* Full refresh *
114 --****************
115 --
116 PROCEDURE full_refresh( errbuf OUT NOCOPY VARCHAR2
117 ,retcode OUT NOCOPY NUMBER
118 ,p_effective_start_date IN VARCHAR2
119 ,p_effective_end_date IN VARCHAR2)
120 IS
121 BEGIN
122 RETURN;
123 END;
124 --
125 --***********************
126 --* Refresh from deltas *
127 --***********************
128 --
129 PROCEDURE refresh_from_deltas( errbuf OUT NOCOPY VARCHAR2
130 ,retcode OUT NOCOPY NUMBER)
131 IS
132 BEGIN
133 RETURN;
134 END;
135 --
136 --*****************************************************************
137 --* This procedure calculates period ago wmv_cout of a supervisor *
138 --*****************************************************************
139 --
140 FUNCTION period_ago_count( p_supervisor_id IN NUMBER
141 ,p_effective_start_date IN DATE
142 ,p_count_type IN VARCHAR2)
143 RETURN NUMBER
144 IS
145 BEGIN
146 RETURN NULL;
147 END;
148 --
149 --******************************************************************************
150 --* This procedure calculate period ago wmv_count of a supervisor by a country *
151 --******************************************************************************
152 FUNCTION period_ago_count_ctr( p_supervisor_id IN NUMBER
153 ,p_effective_start_date IN DATE
154 ,p_country IN VARCHAR2)
155 RETURN NUMBER
156 IS
157 BEGIN
158 RETURN NULL;
159 END;
160 --
161 --********************
162 --*Refresh MV method *
163 --*******************
164 FUNCTION refresh_mv_method RETURN VARCHAR2
165 IS
166 BEGIN
167 RETURN NULL;
168 END;
169 --
170 --****************************
171 --*Refresh materialized views*
172 --****************************
173 --
174 PROCEDURE refresh_mvs( errbuf OUT NOCOPY VARCHAR2
175 ,retcode OUT NOCOPY NUMBER
176 ,complete_refresh IN VARCHAR2 DEFAULT 'Y')
177 IS
178 BEGIN
179 RETURN;
180 END;
181 END hri_dbi_wmv_count;