1 PACKAGE HR_RATE_VALUES_SWI AUTHID CURRENT_USER AS
2 /* $Header: hrpgrswi.pkh 115.3 2004/02/29 02:37:25 svittal noship $ */
3 g_asg_rate_table HR_ASG_RATE_TABLE;
4
5 g_update_only VARCHAR2(15) := 'UPDATE_ONLY';
6 g_update_delete VARCHAR2(15) := 'UPDATE_DELETE';
7 g_insert_only VARCHAR2(15) := 'INSERT_ONLY';
8 g_insert_delete VARCHAR2(15) := 'INSERT_DELETE';
9 g_delete_only VARCHAR2(15) := 'DELETE_ONLY';
10 g_no_change VARCHAR2(15) := 'NO_CHANGE';
11
12
13 -- ----------------------------------------------------------------------------
14 -- |---------------------< create_assignment_rate_value >---------------------|
15 -- ----------------------------------------------------------------------------
16 -- {Start of comments}
17 --
18 -- Description:
19 -- This procedure is the self-service wrapper procedure to the following
20 -- API: hr_rate_values_api.create_assignment_rate_value
21 --
22 -- Pre-requisites
23 -- All 'IN' parameters to this procedure have been appropriately derived.
24 --
25 -- Post Success:
26 -- p_return_status will return value indicating success.
27 --
28 -- Post Failure:
29 -- p_return_status will return value indication failure.
30 --
31 -- Access Status:
32 -- Internal Development use only.
33 --
34 -- {End of comments}
35 -- ----------------------------------------------------------------------------
36 PROCEDURE create_assignment_rate_value
37 (p_validate in boolean default false
38 ,p_effective_date in date
39 ,p_business_group_id in number
40 ,p_rate_id in number
41 ,p_assignment_id in number
42 ,p_rate_type in varchar2
43 ,p_currency_code in varchar2
44 ,p_value in varchar2
45 ,p_grade_rule_id in out nocopy number
46 ,p_object_version_number out nocopy number
47 ,p_effective_start_date out nocopy date
48 ,p_effective_end_date out nocopy date
49 ,p_return_status out nocopy varchar2
50 );
51 -- ----------------------------------------------------------------------------
52 -- |---------------------------< create_rate_value >--------------------------|
53 -- ----------------------------------------------------------------------------
54 -- {Start of comments}
55 --
56 -- Description:
57 -- This procedure is the self-service wrapper procedure to the following
58 -- API: hr_rate_values_api.create_rate_value
59 --
60 -- Pre-requisites
61 -- All 'IN' parameters to this procedure have been appropriately derived.
62 --
63 -- Post Success:
64 -- p_return_status will return value indicating success.
65 --
66 -- Post Failure:
67 -- p_return_status will return value indication failure.
68 --
69 -- Access Status:
70 -- Internal Development use only.
71 --
72 -- {End of comments}
73 -- ----------------------------------------------------------------------------
74 PROCEDURE create_rate_value
75 (p_validate in number default hr_api.g_false_num
76 ,p_effective_date in date
77 ,p_business_group_id in number
78 ,p_rate_id in number
79 ,p_grade_or_spinal_point_id in number
80 ,p_rate_type in varchar2
81 ,p_currency_code in varchar2 default null
82 ,p_maximum in varchar2 default null
83 ,p_mid_value in varchar2 default null
84 ,p_minimum in varchar2 default null
85 ,p_sequence in number default null
86 ,p_value in varchar2 default null
87 ,p_grade_rule_id out nocopy number
88 ,p_object_version_number out nocopy number
89 ,p_effective_start_date out nocopy date
90 ,p_effective_end_date out nocopy date
91 ,p_return_status out nocopy varchar2
92 );
93 --
94 --
95 -- ----------------------------------------------------------------------------
96 -- |---------------------< update_assignment_rate_value >---------------------|
97 -- ----------------------------------------------------------------------------
98 -- {Start of comments}
99 --
100 -- Description:
101 -- This procedure is the self-service wrapper procedure to the following
102 -- API: hr_rate_values_api.update_assignment_rate_value
103 --
104 -- Pre-requisites
105 -- All 'IN' parameters to this procedure have been appropriately derived.
106 --
107 -- Post Success:
108 -- p_return_status will return value indicating success.
109 --
110 -- Post Failure:
111 -- p_return_status will return value indication failure.
112 --
113 -- Access Status:
114 -- Internal Development use only.
115 --
116 -- {End of comments}
117 -- ----------------------------------------------------------------------------
118 PROCEDURE update_assignment_rate_value
119 (p_validate in boolean default false
120 ,p_grade_rule_id in number
121 ,p_effective_date in date
122 ,p_datetrack_mode in varchar2
123 ,p_currency_code in varchar2 default hr_api.g_varchar2
124 ,p_value in varchar2 default hr_api.g_varchar2
125 ,p_object_version_number in out nocopy number
126 ,p_effective_start_date out nocopy date
127 ,p_effective_end_date out nocopy date
128 ,p_return_status out nocopy varchar2
129 );
130 -- ----------------------------------------------------------------------------
131 -- |---------------------------< update_rate_value >--------------------------|
132 -- ----------------------------------------------------------------------------
133 -- {Start of comments}
134 --
135 -- Description:
136 -- This procedure is the self-service wrapper procedure to the following
137 -- API: hr_rate_values_api.update_rate_value
138 --
139 -- Pre-requisites
140 -- All 'IN' parameters to this procedure have been appropriately derived.
141 --
142 -- Post Success:
143 -- p_return_status will return value indicating success.
144 --
145 -- Post Failure:
146 -- p_return_status will return value indication failure.
147 --
148 -- Access Status:
149 -- Internal Development use only.
150 --
151 -- {End of comments}
152 -- ----------------------------------------------------------------------------
153 PROCEDURE update_rate_value
154 (p_validate in number default hr_api.g_false_num
155 ,p_grade_rule_id in number
156 ,p_effective_date in date
157 ,p_datetrack_mode in varchar2
158 ,p_currency_code in varchar2 default hr_api.g_varchar2
159 ,p_maximum in varchar2 default hr_api.g_varchar2
160 ,p_mid_value in varchar2 default hr_api.g_varchar2
161 ,p_minimum in varchar2 default hr_api.g_varchar2
162 ,p_sequence in number default hr_api.g_number
163 ,p_value in varchar2 default hr_api.g_varchar2
164 ,p_object_version_number in out nocopy number
165 ,p_effective_start_date out nocopy date
166 ,p_effective_end_date out nocopy date
167 ,p_return_status out nocopy varchar2
168 );
169 -- ----------------------------------------------------------------------------
170 -- |---------------------------< delete_rate_value >--------------------------|
171 -- ----------------------------------------------------------------------------
172 -- {Start of comments}
173 --
174 -- Description:
175 -- This procedure is the self-service wrapper procedure to the following
176 -- API: hr_rate_values_api.delete_rate_value
177 --
178 -- Pre-requisites
179 -- All 'IN' parameters to this procedure have been appropriately derived.
180 --
181 -- Post Success:
182 -- p_return_status will return value indicating success.
183 --
184 -- Post Failure:
185 -- p_return_status will return value indication failure.
186 --
187 -- Access Status:
188 -- Internal Development use only.
189 --
190 -- {End of comments}
191 -- ----------------------------------------------------------------------------
192 PROCEDURE delete_rate_value
193 (p_validate in boolean default false
194 ,p_grade_rule_id in number
195 ,p_datetrack_mode in varchar2
196 ,p_effective_date in date
197 ,p_object_version_number in out nocopy number
198 ,p_effective_start_date out nocopy date
199 ,p_effective_end_date out nocopy date
200 ,p_return_status out nocopy varchar2
201 );
202 -- ----------------------------------------------------------------------------
203 -- |---------------------------< delete_rate_value >--------------------------|
204 -- ----------------------------------------------------------------------------
205 -- {Start of comments}
206 --
207 -- Description:
208 -- This procedure is the self-service wrapper procedure to the following
209 -- API: hr_rate_values_api.delete_rate_value
210 --
211 -- Pre-requisites
212 -- All 'IN' parameters to this procedure have been appropriately derived.
213 --
214 -- Post Success:
215 -- p_return_status will return value indicating success.
216 --
217 -- Post Failure:
218 -- p_return_status will return value indication failure.
219 --
220 -- Access Status:
221 -- Internal Development use only.
222 --
223 -- {End of comments}
224 -- ----------------------------------------------------------------------------
225 PROCEDURE delete_rate_value
226 (p_validate in number default hr_api.g_false_num
227 ,p_grade_rule_id in number
228 ,p_datetrack_mode in varchar2
229 ,p_effective_date in date
230 ,p_object_version_number in out nocopy number
231 ,p_effective_start_date out nocopy date
232 ,p_effective_end_date out nocopy date
233 ,p_return_status out nocopy varchar2
234 );
235 -- ----------------------------------------------------------------------------
236 -- |----------------------------------< lck >---------------------------------|
237 -- ----------------------------------------------------------------------------
238 -- {Start of comments}
239 --
240 -- Description:
241 -- This procedure is the self-service wrapper procedure to the following
242 -- API: hr_rate_values_api.lck
243 --
244 -- Pre-requisites
245 -- All 'IN' parameters to this procedure have been appropriately derived.
246 --
247 -- Post Success:
248 -- p_return_status will return value indicating success.
249 --
250 -- Post Failure:
251 -- p_return_status will return value indication failure.
252 --
253 -- Access Status:
254 -- Internal Development use only.
255 --
256 -- {End of comments}
257 -- ----------------------------------------------------------------------------
258 PROCEDURE lck
259 (p_grade_rule_id in number
260 ,p_object_version_number in number
261 ,p_effective_date in date
262 ,p_datetrack_mode in varchar2
263 ,p_validation_start_date out nocopy date
264 ,p_validation_end_date out nocopy date
265 ,p_return_status out nocopy varchar2
266 );
267 -- ---------------------------------------------------------------------------
268 -- ---------------------------- < process_api > ------------------------------
269 -- ---------------------------------------------------------------------------
270 -- Purpose: This procedure is used by the WF procedures to commit or validate
271 -- the transaction step with HRMS system
272 -- ---------------------------------------------------------------------------
273 PROCEDURE process_api
274 (p_validate in boolean default false
275 ,p_transaction_step_id in number default null
276 ,p_effective_date in varchar2 default null
277 );
278
279 PROCEDURE process_save
280 (p_mode in VARCHAR2 default '#'
281 ,p_flow_mode in VARCHAR2 default NULL
282 ,p_item_type in VARCHAR2 default hr_api.g_varchar2
283 ,p_item_key in VARCHAR2 default hr_api.g_varchar2
284 ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
285 ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
286 ,p_asg_rate_tab in HR_ASG_RATE_TABLE
287 ,p_return_status out nocopy VARCHAR2
288 ,p_transaction_step_id out nocopy NUMBER
289 );
290
291 PROCEDURE get_transaction_rownum
292 (p_item_type in VARCHAR2
293 ,p_item_key in VARCHAR2
294 ,p_assignment_id in VARCHAR2
295 ,p_business_gp_id in VARCHAR2
296 ,p_row_num out nocopy VARCHAR2
297 );
298
299 PROCEDURE get_transaction_details
300 (p_asg_rate_table in out nocopy HR_ASG_RATE_TABLE
301 );
302
303 PROCEDURE populate_transaction_details
304 (p_item_type in VARCHAR2
305 ,p_item_key in VARCHAR2
306 ,p_assignment_id in VARCHAR2
307 ,p_business_gp_id in VARCHAR2
308 );
309
310 PROCEDURE validate_record
311 (p_validate in boolean Default true
312 ,p_asg_rate_rec in HR_ASG_RATE_TYPE
313 ,p_record_status in VARCHAR2
314 ,p_effective_date in date
315 ,p_return_status out nocopy VARCHAR2
316 );
317
318 PROCEDURE delete_transaction_step
319 (p_transaction_step_id in VARCHAR2
320 );
321
322 FUNCTION is_date_change_required
323 (p_new_date in DATE
324 ,p_old_date in DATE
325 ) return boolean;
326
327 PROCEDURE po_process_save
328 (p_mode in VARCHAR2 default '#'
329 ,p_flow_mode in VARCHAR2 default NULL
330 ,p_item_type in VARCHAR2 default hr_api.g_varchar2
331 ,p_item_key in VARCHAR2 default hr_api.g_varchar2
332 ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
333 ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
334 ,p_po_line_id in NUMBER
335 ,p_return_status out nocopy VARCHAR2
336 ,p_transaction_step_id out nocopy NUMBER
337 );
338
339 end hr_rate_values_swi;