1 Package hr_maintain_proposal_swi As
2 /* $Header: hrpypswi.pkh 120.3.12000000.1 2007/01/21 18:14:40 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< approve_salary_proposal >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_maintain_proposal_api.approve_salary_proposal
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE approve_salary_proposal
27 (p_pay_proposal_id in number
28 ,p_change_date in date default hr_api.g_date
29 ,p_proposed_salary_n in number default hr_api.g_number
30 ,p_object_version_number in out nocopy number
31 ,p_validate in number default hr_api.g_false_num
32 ,p_error_text out nocopy varchar2
33 ,p_return_status out nocopy varchar2
34 );
35 -- ----------------------------------------------------------------------------
36 -- |----------------------< cre_or_upd_salary_proposal >----------------------|
37 -- ----------------------------------------------------------------------------
38 -- {Start of comments}
39 --
40 -- Description:
41 -- This procedure is the self-service wrapper procedure to the following
42 -- API: hr_maintain_proposal_api.cre_or_upd_salary_proposal
43 --
44 -- Pre-requisites
45 -- All 'IN' parameters to this procedure have been appropriately derived.
46 --
47 -- Post Success:
48 -- p_return_status will return value indicating success.
49 --
50 -- Post Failure:
51 -- p_return_status will return value indication failure.
52 --
53 -- Access Status:
54 -- Internal Development use only.
55 --
56 -- {End of comments}
57 -- ----------------------------------------------------------------------------
58 PROCEDURE cre_or_upd_salary_proposal
59 (p_validate in number default hr_api.g_false_num
60 ,p_pay_proposal_id in out nocopy number
61 ,p_object_version_number in out nocopy number
62 ,p_business_group_id in number default hr_api.g_number
63 ,p_assignment_id in number default hr_api.g_number
64 ,p_change_date in date default hr_api.g_date
65 ,p_comments in varchar2 default hr_api.g_varchar2
66 ,p_next_sal_review_date in date default hr_api.g_date
67 ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68 ,p_proposed_salary_n in number default hr_api.g_number
69 ,p_forced_ranking in number default hr_api.g_number
70 ,p_date_to in date default hr_api.g_date
71 ,p_performance_review_id in number default hr_api.g_number
72 ,p_attribute_category in varchar2 default hr_api.g_varchar2
73 ,p_attribute1 in varchar2 default hr_api.g_varchar2
74 ,p_attribute2 in varchar2 default hr_api.g_varchar2
75 ,p_attribute3 in varchar2 default hr_api.g_varchar2
76 ,p_attribute4 in varchar2 default hr_api.g_varchar2
77 ,p_attribute5 in varchar2 default hr_api.g_varchar2
78 ,p_attribute6 in varchar2 default hr_api.g_varchar2
79 ,p_attribute7 in varchar2 default hr_api.g_varchar2
80 ,p_attribute8 in varchar2 default hr_api.g_varchar2
81 ,p_attribute9 in varchar2 default hr_api.g_varchar2
82 ,p_attribute10 in varchar2 default hr_api.g_varchar2
83 ,p_attribute11 in varchar2 default hr_api.g_varchar2
84 ,p_attribute12 in varchar2 default hr_api.g_varchar2
85 ,p_attribute13 in varchar2 default hr_api.g_varchar2
86 ,p_attribute14 in varchar2 default hr_api.g_varchar2
87 ,p_attribute15 in varchar2 default hr_api.g_varchar2
88 ,p_attribute16 in varchar2 default hr_api.g_varchar2
89 ,p_attribute17 in varchar2 default hr_api.g_varchar2
90 ,p_attribute18 in varchar2 default hr_api.g_varchar2
91 ,p_attribute19 in varchar2 default hr_api.g_varchar2
92 ,p_attribute20 in varchar2 default hr_api.g_varchar2
93 ,p_multiple_components in varchar2 default hr_api.g_varchar2
94 ,p_approved in varchar2 default hr_api.g_varchar2
95 ,p_return_status out nocopy varchar2
96 );
97 -- ----------------------------------------------------------------------------
98 -- |-----------------------< delete_proposal_component >----------------------|
99 -- ----------------------------------------------------------------------------
100 -- {Start of comments}
101 --
102 -- Description:
103 -- This procedure is the self-service wrapper procedure to the following
104 -- API: hr_maintain_proposal_api.delete_proposal_component
105 --
106 -- Pre-requisites
107 -- All 'IN' parameters to this procedure have been appropriately derived.
108 --
109 -- Post Success:
110 -- p_return_status will return value indicating success.
111 --
112 -- Post Failure:
113 -- p_return_status will return value indication failure.
114 --
115 -- Access Status:
116 -- Internal Development use only.
117 --
118 -- {End of comments}
119 -- ----------------------------------------------------------------------------
120 PROCEDURE delete_proposal_component
121 (p_component_id in number
122 ,p_validation_strength in varchar2 default hr_api.g_varchar2
123 ,p_object_version_number in number
124 ,p_validate in number default hr_api.g_false_num
125 ,p_return_status out nocopy varchar2
126 );
127 -- ----------------------------------------------------------------------------
128 -- |------------------------< delete_salary_proposal >------------------------|
129 -- ----------------------------------------------------------------------------
130 -- {Start of comments}
131 --
132 -- Description:
133 -- This procedure is the self-service wrapper procedure to the following
134 -- API: hr_maintain_proposal_api.delete_salary_proposal
135 --
136 -- Pre-requisites
137 -- All 'IN' parameters to this procedure have been appropriately derived.
138 --
139 -- Post Success:
140 -- p_return_status will return value indicating success.
141 --
142 -- Post Failure:
143 -- p_return_status will return value indication failure.
144 --
145 -- Access Status:
146 -- Internal Development use only.
147 --
148 -- {End of comments}
149 -- ----------------------------------------------------------------------------
150 PROCEDURE delete_salary_proposal
151 (p_pay_proposal_id in number
152 ,p_business_group_id in number
153 ,p_object_version_number in number
154 ,p_validate in number default hr_api.g_false_num
155 ,p_return_status out nocopy varchar2
156 );
157 -- ----------------------------------------------------------------------------
158 -- |-----------------------< insert_proposal_component >----------------------|
159 -- ----------------------------------------------------------------------------
160 -- {Start of comments}
161 --
162 -- Description:
163 -- This procedure is the self-service wrapper procedure to the following
164 -- API: hr_maintain_proposal_api.insert_proposal_component
165 --
166 -- Pre-requisites
167 -- All 'IN' parameters to this procedure have been appropriately derived.
168 --
169 -- Post Success:
170 -- p_return_status will return value indicating success.
171 --
172 -- Post Failure:
173 -- p_return_status will return value indication failure.
174 --
175 -- Access Status:
176 -- Internal Development use only.
177 --
178 -- {End of comments}
179 -- ----------------------------------------------------------------------------
180 PROCEDURE insert_proposal_component
181 (p_component_id out nocopy number
182 ,p_pay_proposal_id in number
183 ,p_business_group_id in number
184 ,p_approved in varchar2
185 ,p_component_reason in varchar2
186 ,p_change_amount_n in number default hr_api.g_number
187 ,p_change_percentage in number default hr_api.g_number
188 ,p_comments in varchar2 default hr_api.g_varchar2
189 ,p_attribute_category in varchar2 default hr_api.g_varchar2
190 ,p_attribute1 in varchar2 default hr_api.g_varchar2
191 ,p_attribute2 in varchar2 default hr_api.g_varchar2
192 ,p_attribute3 in varchar2 default hr_api.g_varchar2
193 ,p_attribute4 in varchar2 default hr_api.g_varchar2
194 ,p_attribute5 in varchar2 default hr_api.g_varchar2
195 ,p_attribute6 in varchar2 default hr_api.g_varchar2
196 ,p_attribute7 in varchar2 default hr_api.g_varchar2
197 ,p_attribute8 in varchar2 default hr_api.g_varchar2
198 ,p_attribute9 in varchar2 default hr_api.g_varchar2
199 ,p_attribute10 in varchar2 default hr_api.g_varchar2
200 ,p_attribute11 in varchar2 default hr_api.g_varchar2
201 ,p_attribute12 in varchar2 default hr_api.g_varchar2
202 ,p_attribute13 in varchar2 default hr_api.g_varchar2
203 ,p_attribute14 in varchar2 default hr_api.g_varchar2
204 ,p_attribute15 in varchar2 default hr_api.g_varchar2
205 ,p_attribute16 in varchar2 default hr_api.g_varchar2
206 ,p_attribute17 in varchar2 default hr_api.g_varchar2
207 ,p_attribute18 in varchar2 default hr_api.g_varchar2
208 ,p_attribute19 in varchar2 default hr_api.g_varchar2
209 ,p_attribute20 in varchar2 default hr_api.g_varchar2
210 ,p_validation_strength in varchar2 default hr_api.g_varchar2
211 ,p_object_version_number out nocopy number
212 ,p_validate in number default hr_api.g_false_num
213 ,p_return_status out nocopy varchar2
214 );
215 -- ----------------------------------------------------------------------------
216 -- |------------------------< insert_salary_proposal >------------------------|
217 -- ----------------------------------------------------------------------------
218 -- {Start of comments}
219 --
220 -- Description:
221 -- This procedure is the self-service wrapper procedure to the following
222 -- API: hr_maintain_proposal_api.insert_salary_proposal
223 --
224 -- Pre-requisites
225 -- All 'IN' parameters to this procedure have been appropriately derived.
226 --
227 -- Post Success:
228 -- p_return_status will return value indicating success.
229 --
230 -- Post Failure:
231 -- p_return_status will return value indication failure.
232 --
233 -- Access Status:
234 -- Internal Development use only.
235 --
236 -- {End of comments}
237 -- ----------------------------------------------------------------------------
238 PROCEDURE insert_salary_proposal
239 (p_pay_proposal_id in number
240 ,p_assignment_id in number
241 ,p_business_group_id in number
242 ,p_change_date in date default hr_api.g_date
243 ,p_comments in varchar2 default hr_api.g_varchar2
244 ,p_next_sal_review_date in date default hr_api.g_date
245 ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246 ,p_proposed_salary_n in number default hr_api.g_number
247 ,p_forced_ranking in number default hr_api.g_number
248 ,p_date_to in date default hr_general.end_of_time
249 ,p_performance_review_id in number default hr_api.g_number
250 ,p_attribute_category in varchar2 default hr_api.g_varchar2
251 ,p_attribute1 in varchar2 default hr_api.g_varchar2
252 ,p_attribute2 in varchar2 default hr_api.g_varchar2
253 ,p_attribute3 in varchar2 default hr_api.g_varchar2
254 ,p_attribute4 in varchar2 default hr_api.g_varchar2
255 ,p_attribute5 in varchar2 default hr_api.g_varchar2
256 ,p_attribute6 in varchar2 default hr_api.g_varchar2
257 ,p_attribute7 in varchar2 default hr_api.g_varchar2
258 ,p_attribute8 in varchar2 default hr_api.g_varchar2
259 ,p_attribute9 in varchar2 default hr_api.g_varchar2
260 ,p_attribute10 in varchar2 default hr_api.g_varchar2
261 ,p_attribute11 in varchar2 default hr_api.g_varchar2
262 ,p_attribute12 in varchar2 default hr_api.g_varchar2
263 ,p_attribute13 in varchar2 default hr_api.g_varchar2
264 ,p_attribute14 in varchar2 default hr_api.g_varchar2
265 ,p_attribute15 in varchar2 default hr_api.g_varchar2
266 ,p_attribute16 in varchar2 default hr_api.g_varchar2
267 ,p_attribute17 in varchar2 default hr_api.g_varchar2
268 ,p_attribute18 in varchar2 default hr_api.g_varchar2
269 ,p_attribute19 in varchar2 default hr_api.g_varchar2
270 ,p_attribute20 in varchar2 default hr_api.g_varchar2
271 ,p_object_version_number out nocopy number
272 ,p_multiple_components in varchar2 default hr_api.g_varchar2
273 ,p_approved in varchar2 default hr_api.g_varchar2
274 ,p_validate in number default hr_api.g_false_num
275 ,p_element_entry_id in out nocopy number
276 ,p_return_status out nocopy varchar2
277 );
278 -- ----------------------------------------------------------------------------
279 -- |-----------------------< update_proposal_component >----------------------|
280 -- ----------------------------------------------------------------------------
281 -- {Start of comments}
282 --
283 -- Description:
284 -- This procedure is the self-service wrapper procedure to the following
285 -- API: hr_maintain_proposal_api.update_proposal_component
286 --
287 -- Pre-requisites
288 -- All 'IN' parameters to this procedure have been appropriately derived.
289 --
290 -- Post Success:
291 -- p_return_status will return value indicating success.
292 --
293 -- Post Failure:
294 -- p_return_status will return value indication failure.
295 --
296 -- Access Status:
297 -- Internal Development use only.
298 --
299 -- {End of comments}
300 -- ----------------------------------------------------------------------------
301 PROCEDURE update_proposal_component
302 (p_component_id in number
303 ,p_approved in varchar2 default hr_api.g_varchar2
304 ,p_component_reason in varchar2 default hr_api.g_varchar2
305 ,p_change_amount_n in number default hr_api.g_number
306 ,p_change_percentage in number default hr_api.g_number
307 ,p_comments in varchar2 default hr_api.g_varchar2
308 ,p_attribute_category in varchar2 default hr_api.g_varchar2
309 ,p_attribute1 in varchar2 default hr_api.g_varchar2
310 ,p_attribute2 in varchar2 default hr_api.g_varchar2
311 ,p_attribute3 in varchar2 default hr_api.g_varchar2
312 ,p_attribute4 in varchar2 default hr_api.g_varchar2
313 ,p_attribute5 in varchar2 default hr_api.g_varchar2
314 ,p_attribute6 in varchar2 default hr_api.g_varchar2
315 ,p_attribute7 in varchar2 default hr_api.g_varchar2
316 ,p_attribute8 in varchar2 default hr_api.g_varchar2
317 ,p_attribute9 in varchar2 default hr_api.g_varchar2
318 ,p_attribute10 in varchar2 default hr_api.g_varchar2
319 ,p_attribute11 in varchar2 default hr_api.g_varchar2
320 ,p_attribute12 in varchar2 default hr_api.g_varchar2
321 ,p_attribute13 in varchar2 default hr_api.g_varchar2
322 ,p_attribute14 in varchar2 default hr_api.g_varchar2
323 ,p_attribute15 in varchar2 default hr_api.g_varchar2
324 ,p_attribute16 in varchar2 default hr_api.g_varchar2
325 ,p_attribute17 in varchar2 default hr_api.g_varchar2
326 ,p_attribute18 in varchar2 default hr_api.g_varchar2
327 ,p_attribute19 in varchar2 default hr_api.g_varchar2
328 ,p_attribute20 in varchar2 default hr_api.g_varchar2
329 ,p_validation_strength in varchar2 default hr_api.g_varchar2
330 ,p_object_version_number in out nocopy number
331 ,p_validate in number default hr_api.g_false_num
332 ,p_return_status out nocopy varchar2
333 );
334 -- ----------------------------------------------------------------------------
335 -- |------------------------< update_salary_proposal >------------------------|
336 -- ----------------------------------------------------------------------------
337 -- {Start of comments}
338 --
339 -- Description:
340 -- This procedure is the self-service wrapper procedure to the following
341 -- API: hr_maintain_proposal_api.update_salary_proposal
342 --
343 -- Pre-requisites
344 -- All 'IN' parameters to this procedure have been appropriately derived.
345 --
346 -- Post Success:
347 -- p_return_status will return value indicating success.
348 --
349 -- Post Failure:
350 -- p_return_status will return value indication failure.
351 --
352 -- Access Status:
353 -- Internal Development use only.
354 --
355 -- {End of comments}
356 -- ----------------------------------------------------------------------------
357 PROCEDURE update_salary_proposal
358 (p_pay_proposal_id in number
359 ,p_change_date in date default hr_api.g_date
360 ,p_comments in varchar2 default hr_api.g_varchar2
361 ,p_next_sal_review_date in date default hr_api.g_date
362 ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363 ,p_proposed_salary_n in number default hr_api.g_number
364 ,p_forced_ranking in number default hr_api.g_number
365 ,p_date_to in date default hr_api.g_date
366 ,p_performance_review_id in number default hr_api.g_number
367 ,p_attribute_category in varchar2 default hr_api.g_varchar2
368 ,p_attribute1 in varchar2 default hr_api.g_varchar2
369 ,p_attribute2 in varchar2 default hr_api.g_varchar2
370 ,p_attribute3 in varchar2 default hr_api.g_varchar2
371 ,p_attribute4 in varchar2 default hr_api.g_varchar2
372 ,p_attribute5 in varchar2 default hr_api.g_varchar2
373 ,p_attribute6 in varchar2 default hr_api.g_varchar2
374 ,p_attribute7 in varchar2 default hr_api.g_varchar2
375 ,p_attribute8 in varchar2 default hr_api.g_varchar2
376 ,p_attribute9 in varchar2 default hr_api.g_varchar2
377 ,p_attribute10 in varchar2 default hr_api.g_varchar2
378 ,p_attribute11 in varchar2 default hr_api.g_varchar2
379 ,p_attribute12 in varchar2 default hr_api.g_varchar2
380 ,p_attribute13 in varchar2 default hr_api.g_varchar2
381 ,p_attribute14 in varchar2 default hr_api.g_varchar2
382 ,p_attribute15 in varchar2 default hr_api.g_varchar2
383 ,p_attribute16 in varchar2 default hr_api.g_varchar2
384 ,p_attribute17 in varchar2 default hr_api.g_varchar2
385 ,p_attribute18 in varchar2 default hr_api.g_varchar2
386 ,p_attribute19 in varchar2 default hr_api.g_varchar2
387 ,p_attribute20 in varchar2 default hr_api.g_varchar2
388 ,p_object_version_number in out nocopy number
389 ,p_multiple_components in varchar2 default hr_api.g_varchar2
390 ,p_approved in varchar2 default hr_api.g_varchar2
391 ,p_validate in number default hr_api.g_false_num
392 ,p_return_status out nocopy varchar2
393 );
394 -- ----------------------------------------------------------------------------
395 -- |----------------------------< process_api >-------------------------------|
396 -- ----------------------------------------------------------------------------
397 procedure process_api
398 (
399 p_document in CLOB
400 ,p_return_status out nocopy VARCHAR2
401 ,p_validate in number default hr_api.g_false_num
402 ,p_effective_date in date default null
403 );
404
405 end hr_maintain_proposal_swi;