1 Package hr_sp_placement_api AUTHID CURRENT_USER as
2 /* $Header: pesppapi.pkh 120.3 2006/05/04 03:44:57 snukala noship $ */
3 /*#
4 * This package contains APIs that create and maintain the grade step
5 * information for an employee's assignment.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Grade Step Placement
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |--------------------------------< create_spp >----------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API puts a grade step onto an employee assignment.
18 *
19 * A grade step placement holds information about which step the 'Increment
20 * Progression Points' process should put onto the assignment the next time you
21 * run it. An employee assignment can be linked to only one grade step at any
22 * point in time.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * An employee assignment and a grade scale with valid steps must all exist on
29 * the effective date before a grade step placement can be created.
30 *
31 * <p><b>Post Success</b><br>
32 * A grade step placement will be created.
33 *
34 * <p><b>Post Failure</b><br>
35 * A grade step placement will not be created and an error will be raised.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Determines when the DateTrack operation comes into
40 * force
41 * @param p_business_group_id Uniquely identifies the business group in which
42 * the grade step placement takes place. Must match the business group of the
43 * employee assignment.
44 * @param p_assignment_id Uniquely identifies the assignment for which the
45 * grade step placement should be created. Assignment must be of type
46 * 'Employee'.
47 * @param p_step_id Uniquely identifies the grade step to place on the employee
48 * assignment.
49 * @param p_auto_increment_flag Indicates whether the 'Increment Progression
50 * Points' process should change the grade step placement the next time you run
51 * it. Valid values are 'Y' or 'N'.
52 * @param p_reason The reason you put this grade step onto the employee
53 * assignment.
54 * @param p_request_id When the API is executed from a concurrent program set
55 * to the concurrent request identifier.
56 * @param p_program_application_id When the API is executed from a concurrent
57 * program set to the program's Application.
58 * @param p_program_id When the API is executed from a concurrent program set
59 * to the program's identifier.
60 * @param p_program_update_date When the API is executed from a concurrent
61 * program set to when the program was ran.
62 * @param p_increment_number The number of grade steps the employee assignment
63 * should move up the grade scale the next time you run the 'Increment
64 * Progression Points' process. This value affects the process only if you set
65 * the p_auto_increment_flag to 'Y'.
66 * @param p_information1 Developer descriptive flexfield segment.
67 * @param p_information2 Developer descriptive flexfield segment.
68 * @param p_information3 Developer descriptive flexfield segment.
69 * @param p_information4 Developer descriptive flexfield segment.
70 * @param p_information5 Developer descriptive flexfield segment.
71 * @param p_information6 Developer descriptive flexfield segment.
72 * @param p_information7 Developer descriptive flexfield segment.
73 * @param p_information8 Developer descriptive flexfield segment.
74 * @param p_information9 Developer descriptive flexfield segment.
75 * @param p_information10 Developer descriptive flexfield segment.
76 * @param p_information11 Developer descriptive flexfield segment.
77 * @param p_information12 Developer descriptive flexfield segment.
78 * @param p_information13 Developer descriptive flexfield segment.
79 * @param p_information14 Developer descriptive flexfield segment.
80 * @param p_information15 Developer descriptive flexfield segment.
81 * @param p_information16 Developer descriptive flexfield segment.
82 * @param p_information17 Developer descriptive flexfield segment.
83 * @param p_information18 Developer descriptive flexfield segment.
84 * @param p_information19 Developer descriptive flexfield segment.
85 * @param p_information20 Developer descriptive flexfield segment.
86 * @param p_information21 Developer descriptive flexfield segment.
87 * @param p_information22 Developer descriptive flexfield segment.
88 * @param p_information23 Developer descriptive flexfield segment.
89 * @param p_information24 Developer descriptive flexfield segment.
90 * @param p_information25 Developer descriptive flexfield segment.
91 * @param p_information26 Developer descriptive flexfield segment.
92 * @param p_information27 Developer descriptive flexfield segment.
93 * @param p_information28 Developer descriptive flexfield segment.
94 * @param p_information29 Developer descriptive flexfield segment.
95 * @param p_information30 Developer descriptive flexfield segment.
96 * @param p_information_category This context value determines which flexfield
97 * structure to use with the developer descriptive flexfield segments.
98 * @param p_placement_id If p_validate is false, uniquely identifies the grade
99 * step placement created. If p_validate is true, set to null.
100 * @param p_object_version_number If p_validate is false, then set to the
101 * version number of the created grade step placement. If p_validate is true,
102 * then the value will be null.
103 * @param p_effective_start_date If p_validate is false, then set to the
104 * earliest effective start date for the created grade step placement. If
105 * p_validate is true, then set to null
106 * @param p_effective_end_date If p_validate is false, then set to the
107 * effective end date for the created grade step placement. If p_validate is
108 * true, then set to null.
109 * @param p_replace_future_spp If there are any future placements existing
110 * then set this parameter to true, otherwise set to false.
111 * @rep:displayname Create Grade Step Placement
112 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
113 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
114 * @rep:scope public
115 * @rep:lifecycle active
116 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
117 */
118 --
119 -- {End Of Comments}
120 --
121 procedure create_spp
122 (p_validate in boolean default false
123 ,p_effective_date in date
124 ,p_business_group_id in number
125 ,p_assignment_id in number
126 ,p_step_id in number
127 ,p_auto_increment_flag in varchar2 default 'N'
128 -- ,p_parent_spine_id in number
129 ,p_reason in varchar2 default null
130 ,p_request_id in number default null
131 ,p_program_application_id in number default null
132 ,p_program_id in number default null
133 ,p_program_update_date in date default null
134 ,p_increment_number in number default null
135 ,p_information1 in varchar2 default null
136 ,p_information2 in varchar2 default null
137 ,p_information3 in varchar2 default null
138 ,p_information4 in varchar2 default null
139 ,p_information5 in varchar2 default null
140 ,p_information6 in varchar2 default null
141 ,p_information7 in varchar2 default null
142 ,p_information8 in varchar2 default null
143 ,p_information9 in varchar2 default null
144 ,p_information10 in varchar2 default null
145 ,p_information11 in varchar2 default null
146 ,p_information12 in varchar2 default null
147 ,p_information13 in varchar2 default null
148 ,p_information14 in varchar2 default null
149 ,p_information15 in varchar2 default null
150 ,p_information16 in varchar2 default null
151 ,p_information17 in varchar2 default null
152 ,p_information18 in varchar2 default null
153 ,p_information19 in varchar2 default null
154 ,p_information20 in varchar2 default null
155 ,p_information21 in varchar2 default null
156 ,p_information22 in varchar2 default null
157 ,p_information23 in varchar2 default null
158 ,p_information24 in varchar2 default null
159 ,p_information25 in varchar2 default null
160 ,p_information26 in varchar2 default null
161 ,p_information27 in varchar2 default null
162 ,p_information28 in varchar2 default null
163 ,p_information29 in varchar2 default null
164 ,p_information30 in varchar2 default null
165 ,p_information_category in varchar2 default null
166 ,p_placement_id out nocopy number
167 ,p_object_version_number out nocopy number
168 ,p_effective_start_date out nocopy date
169 ,p_effective_end_date out nocopy date
170 ,p_replace_future_spp in boolean default false --bug 2977842.
171 );
172 --
173 -- ----------------------------------------------------------------------------
174 -- |--------------------------------< create_spp >----------------------------|
175 -- ----------------------------------------------------------------------------
176 --
177 -- This version of the API is now out-of-date however it has been provided to
178 -- you for backward compatibility support and will be removed in the future.
179 -- Oracle recommends you to modify existing calling programs in advance of the
180 -- support being withdrawn thus avoiding any potential disruption.
181 --
182 procedure create_spp
183 (p_validate in boolean default false
184 ,p_effective_date in date
185 ,p_business_group_id in number
186 ,p_assignment_id in number
187 ,p_step_id in number
188 ,p_auto_increment_flag in varchar2 default 'N'
189 -- ,p_parent_spine_id in number
190 ,p_reason in varchar2 default null
191 ,p_request_id in number default null
192 ,p_program_application_id in number default null
193 ,p_program_id in number default null
194 ,p_program_update_date in date default null
195 ,p_increment_number in number default null
196 ,p_information1 in varchar2 default null
197 ,p_information2 in varchar2 default null
198 ,p_information3 in varchar2 default null
199 ,p_information4 in varchar2 default null
200 ,p_information5 in varchar2 default null
201 ,p_information6 in varchar2 default null
202 ,p_information7 in varchar2 default null
203 ,p_information8 in varchar2 default null
204 ,p_information9 in varchar2 default null
205 ,p_information10 in varchar2 default null
206 ,p_information11 in varchar2 default null
207 ,p_information12 in varchar2 default null
208 ,p_information13 in varchar2 default null
209 ,p_information14 in varchar2 default null
210 ,p_information15 in varchar2 default null
211 ,p_information16 in varchar2 default null
212 ,p_information17 in varchar2 default null
213 ,p_information18 in varchar2 default null
214 ,p_information19 in varchar2 default null
215 ,p_information20 in varchar2 default null
216 ,p_information21 in varchar2 default null
217 ,p_information22 in varchar2 default null
218 ,p_information23 in varchar2 default null
219 ,p_information24 in varchar2 default null
220 ,p_information25 in varchar2 default null
221 ,p_information26 in varchar2 default null
222 ,p_information27 in varchar2 default null
223 ,p_information28 in varchar2 default null
224 ,p_information29 in varchar2 default null
225 ,p_information30 in varchar2 default null
226 ,p_information_category in varchar2 default null
227 ,p_placement_id out nocopy number
228 ,p_object_version_number out nocopy number
229 ,p_effective_start_date out nocopy date
230 ,p_effective_end_date out nocopy date
231 ,p_replace_future_spp in boolean default false --bug 2977842.
232 ,p_gsp_post_process_warning out nocopy varchar2
233 );
234 --
235 -- ----------------------------------------------------------------------------
236 -- |--------------------------------< update_spp >----------------------------|
237 -- ----------------------------------------------------------------------------
238 --
239 -- {Start Of Comments}
240 /*#
241 * This API updates the employee assignment's grade step information.
242 *
243 * A grade step placement holds information about which step the 'Increment
244 * Progression Points' process should put onto the assignment the next time you
245 * run it. An employee assignment can be linked to only one grade step at any
246 * point in time.
247 *
248 * <p><b>Licensing</b><br>
249 * This API is licensed for use with Human Resources.
250 *
251 * <p><b>Prerequisites</b><br>
252 * A grade step placement must exist on the effective date of the update.
253 *
254 * <p><b>Post Success</b><br>
255 * The grade step placement will be updated.
256 *
257 * <p><b>Post Failure</b><br>
258 * The grade step placement will not be updated and an error will be raised.
259 * @param p_validate If true, then validation alone will be performed and the
260 * database will remain unchanged. If false and all validation checks pass,
261 * then the database will be modified.
262 * @param p_effective_date Determines when the DateTrack operation comes into
263 * force
264 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
265 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
266 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
267 * depend on the dates of previous record changes and the effective date of
268 * this change.
269 * @param p_placement_id Uniquely identifies the grade step placement record to
270 * be updated.
271 * @param p_object_version_number Pass in the current version number of the
272 * grade step placement to be updated. When the API completes if p_validate is
273 * false, will be set to the new version number of the updated grade step
274 * placement. If p_validate is true will be set to the same value which was
275 * passed in.
276 * @param p_step_id Uniquely identifies the grade step to place on the employee
277 * assignment.
278 * @param p_auto_increment_flag Indicates whether the 'Increment Progression
279 * Points' process should change the grade step placement the next time you run
280 * it. Valid values are 'Y' or 'N'.
281 * @param p_reason The reason you put this grade step onto the employee
282 * assignment.
283 * @param p_request_id When the API is executed from a concurrent program set
284 * to the concurrent request identifier.
285 * @param p_program_application_id When the API is executed from a concurrent
286 * program set to the program's Application.
287 * @param p_program_id When the API is executed from a concurrent program set
288 * to the program's identifier.
289 * @param p_program_update_date When the API is executed from a concurrent
290 * program set to when the program was ran.
291 * @param p_increment_number The number of grade steps the employee assignment
292 * should move up the grade scale the next time you run the 'Increment
293 * Progression Points' process. This value affects the process only if you set
294 * the p_auto_increment_flag to 'Y'.
295 * @param p_information1 Developer descriptive flexfield segment.
296 * @param p_information2 Developer descriptive flexfield segment.
297 * @param p_information3 Developer descriptive flexfield segment.
298 * @param p_information4 Developer descriptive flexfield segment.
299 * @param p_information5 Developer descriptive flexfield segment.
300 * @param p_information6 Developer descriptive flexfield segment.
301 * @param p_information7 Developer descriptive flexfield segment.
302 * @param p_information8 Developer descriptive flexfield segment.
303 * @param p_information9 Developer descriptive flexfield segment.
304 * @param p_information10 Developer descriptive flexfield segment.
305 * @param p_information11 Developer descriptive flexfield segment.
306 * @param p_information12 Developer descriptive flexfield segment.
307 * @param p_information13 Developer descriptive flexfield segment.
308 * @param p_information14 Developer descriptive flexfield segment.
309 * @param p_information15 Developer descriptive flexfield segment.
310 * @param p_information16 Developer descriptive flexfield segment.
311 * @param p_information17 Developer descriptive flexfield segment.
312 * @param p_information18 Developer descriptive flexfield segment.
313 * @param p_information19 Developer descriptive flexfield segment.
314 * @param p_information20 Developer descriptive flexfield segment.
315 * @param p_information21 Developer descriptive flexfield segment.
316 * @param p_information22 Developer descriptive flexfield segment.
317 * @param p_information23 Developer descriptive flexfield segment.
318 * @param p_information24 Developer descriptive flexfield segment.
319 * @param p_information25 Developer descriptive flexfield segment.
320 * @param p_information26 Developer descriptive flexfield segment.
321 * @param p_information27 Developer descriptive flexfield segment.
322 * @param p_information28 Developer descriptive flexfield segment.
323 * @param p_information29 Developer descriptive flexfield segment.
324 * @param p_information30 Developer descriptive flexfield segment.
325 * @param p_information_category This context value determines which flexfield
326 * structure to use with the developer descriptive flexfield segments.
327 * @param p_effective_start_date If p_validate is false, then set to the
328 * effective start date on the updated grade step placement row which now
329 * exists as of the effective date. If p_validate is true, then set to null.
330 * @param p_effective_end_date If p_validate is false, then set to the
331 * effective end date on the updated grade step placement row which now exists
332 * as of the effective date. If p_validate is true, then set to null.
333 * @rep:displayname Update Grade Step Placement
334 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
335 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
336 * @rep:scope public
337 * @rep:lifecycle active
338 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
339 */
340 --
341 -- {End Of Comments}
342 --
343 procedure update_spp
344 (p_validate in boolean default false
345 ,p_effective_date in date
346 ,p_datetrack_mode in varchar2 default hr_api.g_update
347 ,p_placement_id in number
348 ,p_object_version_number in out nocopy number
349 -- ,p_business_group_id in number default hr_api.g_number
350 -- ,p_assignment_id in number default hr_api.g_number
351 ,p_step_id in number default hr_api.g_number
352 ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
353 ,p_reason in varchar2 default hr_api.g_varchar2
354 ,p_request_id in number default hr_api.g_number
355 ,p_program_application_id in number default hr_api.g_number
356 ,p_program_id in number default hr_api.g_number
357 ,p_program_update_date in date default hr_api.g_date
358 ,p_increment_number in number default hr_api.g_number
359 ,p_information1 in varchar2 default hr_api.g_varchar2
360 ,p_information2 in varchar2 default hr_api.g_varchar2
361 ,p_information3 in varchar2 default hr_api.g_varchar2
362 ,p_information4 in varchar2 default hr_api.g_varchar2
363 ,p_information5 in varchar2 default hr_api.g_varchar2
364 ,p_information6 in varchar2 default hr_api.g_varchar2
365 ,p_information7 in varchar2 default hr_api.g_varchar2
366 ,p_information8 in varchar2 default hr_api.g_varchar2
367 ,p_information9 in varchar2 default hr_api.g_varchar2
368 ,p_information10 in varchar2 default hr_api.g_varchar2
369 ,p_information11 in varchar2 default hr_api.g_varchar2
370 ,p_information12 in varchar2 default hr_api.g_varchar2
371 ,p_information13 in varchar2 default hr_api.g_varchar2
372 ,p_information14 in varchar2 default hr_api.g_varchar2
373 ,p_information15 in varchar2 default hr_api.g_varchar2
374 ,p_information16 in varchar2 default hr_api.g_varchar2
375 ,p_information17 in varchar2 default hr_api.g_varchar2
376 ,p_information18 in varchar2 default hr_api.g_varchar2
377 ,p_information19 in varchar2 default hr_api.g_varchar2
378 ,p_information20 in varchar2 default hr_api.g_varchar2
379 ,p_information21 in varchar2 default hr_api.g_varchar2
380 ,p_information22 in varchar2 default hr_api.g_varchar2
381 ,p_information23 in varchar2 default hr_api.g_varchar2
382 ,p_information24 in varchar2 default hr_api.g_varchar2
383 ,p_information25 in varchar2 default hr_api.g_varchar2
384 ,p_information26 in varchar2 default hr_api.g_varchar2
385 ,p_information27 in varchar2 default hr_api.g_varchar2
386 ,p_information28 in varchar2 default hr_api.g_varchar2
387 ,p_information29 in varchar2 default hr_api.g_varchar2
388 ,p_information30 in varchar2 default hr_api.g_varchar2
389 ,p_information_category in varchar2 default hr_api.g_varchar2
390 ,p_effective_start_date in out nocopy date
391 ,p_effective_end_date in out nocopy date
392 );
393 --
394 -- ----------------------------------------------------------------------------
395 -- |--------------------------------< update_spp >----------------------------|
396 -- ----------------------------------------------------------------------------
397 --
398 -- This version of the API is now out-of-date however it has been provided to
399 -- you for backward compatibility support and will be removed in the future.
400 -- Oracle recommends you to modify existing calling programs in advance of the
401 -- support being withdrawn thus avoiding any potential disruption.
402 --
403 procedure update_spp
404 (p_validate in boolean default false
405 ,p_effective_date in date
406 ,p_datetrack_mode in varchar2 default hr_api.g_update
407 ,p_placement_id in number
408 ,p_object_version_number in out nocopy number
409 -- ,p_business_group_id in number default hr_api.g_number
410 -- ,p_assignment_id in number default hr_api.g_number
411 ,p_step_id in number default hr_api.g_number
412 ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
413 ,p_reason in varchar2 default hr_api.g_varchar2
414 ,p_request_id in number default hr_api.g_number
415 ,p_program_application_id in number default hr_api.g_number
416 ,p_program_id in number default hr_api.g_number
417 ,p_program_update_date in date default hr_api.g_date
418 ,p_increment_number in number default hr_api.g_number
419 ,p_information1 in varchar2 default hr_api.g_varchar2
420 ,p_information2 in varchar2 default hr_api.g_varchar2
421 ,p_information3 in varchar2 default hr_api.g_varchar2
422 ,p_information4 in varchar2 default hr_api.g_varchar2
423 ,p_information5 in varchar2 default hr_api.g_varchar2
424 ,p_information6 in varchar2 default hr_api.g_varchar2
425 ,p_information7 in varchar2 default hr_api.g_varchar2
426 ,p_information8 in varchar2 default hr_api.g_varchar2
427 ,p_information9 in varchar2 default hr_api.g_varchar2
428 ,p_information10 in varchar2 default hr_api.g_varchar2
429 ,p_information11 in varchar2 default hr_api.g_varchar2
430 ,p_information12 in varchar2 default hr_api.g_varchar2
431 ,p_information13 in varchar2 default hr_api.g_varchar2
432 ,p_information14 in varchar2 default hr_api.g_varchar2
433 ,p_information15 in varchar2 default hr_api.g_varchar2
434 ,p_information16 in varchar2 default hr_api.g_varchar2
435 ,p_information17 in varchar2 default hr_api.g_varchar2
436 ,p_information18 in varchar2 default hr_api.g_varchar2
437 ,p_information19 in varchar2 default hr_api.g_varchar2
438 ,p_information20 in varchar2 default hr_api.g_varchar2
439 ,p_information21 in varchar2 default hr_api.g_varchar2
440 ,p_information22 in varchar2 default hr_api.g_varchar2
441 ,p_information23 in varchar2 default hr_api.g_varchar2
442 ,p_information24 in varchar2 default hr_api.g_varchar2
443 ,p_information25 in varchar2 default hr_api.g_varchar2
444 ,p_information26 in varchar2 default hr_api.g_varchar2
445 ,p_information27 in varchar2 default hr_api.g_varchar2
446 ,p_information28 in varchar2 default hr_api.g_varchar2
447 ,p_information29 in varchar2 default hr_api.g_varchar2
448 ,p_information30 in varchar2 default hr_api.g_varchar2
449 ,p_information_category in varchar2 default hr_api.g_varchar2
450 ,p_effective_start_date in out nocopy date
451 ,p_effective_end_date in out nocopy date
452 ,p_gsp_post_process_warning out nocopy varchar2
453 );
454 --
455 -- ----------------------------------------------------------------------------
456 -- |--------------------------------< delete_spp >----------------------------|
457 -- ----------------------------------------------------------------------------
458 --
459 -- {Start Of Comments}
460 /*#
461 * This API removes a grade step from an employee assignment.
462 *
463 * A grade step placement holds information about which step the 'Increment
464 * Progression Points' process should put onto the assignment the next time you
465 * run it. An employee assignment can be linked to only one grade step at any
466 * point in time.
467 *
468 * <p><b>Licensing</b><br>
469 * This API is licensed for use with Human Resources.
470 *
471 * <p><b>Prerequisites</b><br>
472 * The grade step placement record must exist on the date it is to be deleted.
473 *
474 * <p><b>Post Success</b><br>
475 * The grade step placement will be deleted.
476 *
477 * <p><b>Post Failure</b><br>
478 * The grade step placement will not be deleted and an error will be raised.
479 * @param p_validate If true, then validation alone will be performed and the
480 * database will remain unchanged. If false and all validation checks pass,
481 * then the database will be modified.
482 * @param p_effective_date Determines when the DateTrack operation comes into
483 * force.
484 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
485 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
486 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
487 * on the dates of previous record changes and the effective date of this
488 * change.
489 * @param p_placement_id Uniquely identifies the grade step placement record to
490 * be deleted.
491 * @param p_object_version_number Current version number of the grade step
492 * placement to be deleted.
493 * @param p_effective_start_date If p_validate is false, then set to the
494 * effective start date for the deleted grade step placement row which now
495 * exists as of the effective date. If p_validate is true or all row instances
496 * have been deleted then set to null.
497 * @param p_effective_end_date If p_validate is false, then set to the
498 * effective end date for the deleted grade step placement row which now exists
499 * as of the effective date. If p_validate is true or all row instances have
500 * been deleted then set to null.
501 * @rep:displayname Delete Grade Step Placement
502 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
503 * @rep:scope public
504 * @rep:lifecycle active
505 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
506 */
507 --
508 -- {End Of Comments}
509 --
510 procedure delete_spp
511 (p_validate in boolean default false
512 ,p_effective_date in date
513 ,p_datetrack_mode in varchar2 default hr_api.g_delete
514 ,p_placement_id in number
515 ,p_object_version_number in out nocopy number
516 ,p_effective_start_date out nocopy date
517 ,p_effective_end_date out nocopy date
518 );
519 --
520 end hr_sp_placement_api;