1 Package hr_contract_api AUTHID CURRENT_USER as
2 /* $Header: hrctcapi.pkh 120.1 2005/10/02 02:01:33 aroussel $ */
3 /*#
4 * This package contains APIs that maintain contract information for an
5 * employee.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Employment Contract
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------------< create_contract >--------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a new contract for an employee.
18 *
19 * Use this API to create contract information details for an employee. The
20 * contract record stores date information, such as expiration. You can also
21 * track the status of physical documents produced as a result of signing the
22 * contract. There is no restriction on the number of contracts a person can
23 * have at a given time.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with Human Resources.
27 *
28 * <p><b>Prerequisites</b><br>
29 * An employee record must exist. Lookup values must be created for the lookup
30 * types of CONTRACT_STATUS and CONTRACT_TYPE.
31 *
32 * <p><b>Post Success</b><br>
33 * A contract will have been created for the employee
34 *
35 * <p><b>Post Failure</b><br>
36 * The contract will not be created and an error will be raised.
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_contract_id If p_validate is false then this uniquely identifies
41 * the contract created. If p_validate is true, then the the value will be
42 * null.
43 * @param p_effective_start_date If p_validate is false, then set to the
44 * earliest effective start date for the created contract. If p_validate is
45 * true, then set to null.
46 * @param p_effective_end_date If p_validate is false, then set to the
47 * effective end date for the created contract. If p_validate is true, then set
48 * to null.
49 * @param p_object_version_number If p_validate is false, then set to the
50 * version number of the created contract. If p_validate is true, then set to
51 * null.
52 * @param p_person_id Identifies the person for whom you create the contract
53 * record.
54 * @param p_reference Reference code for the contract
55 * @param p_type The type of the contract. Valid values are defined by the
56 * CONTRACT_TYPE lookup type.
57 * @param p_status The status of the contract. Valid values are defined by the
58 * CONTRACT_STATUS lookup type.
59 * @param p_status_reason The reason why the contract has its current status.
60 * Valid values are defined by the CONTRACT_STATUS_REASON lookup type.
61 * @param p_doc_status The status of the physical document associated with the
62 * contract. Valid values are defined by the DOCUMENT_STATUS lookup type.
63 * @param p_doc_status_change_date Date the document status changed.
64 * @param p_description Contract description
65 * @param p_duration The length of time during which the contract is active.
66 * @param p_duration_units Units for contract duration, e.g., Weeks, Months,
67 * Years. Valid values are defined by the QUALIFYING_UNITS lookup type.
68 * @param p_contractual_job_title Contractual job title
69 * @param p_parties Parties to the contract
70 * @param p_start_reason Reason for starting the contract. Valid values are
71 * defined by the CONTRACT_START_REASON lookup type.
72 * @param p_end_reason Reason for ending the contract. Valid values are defined
73 * by the CONTRACT_END_REASON lookup type.
74 * @param p_number_of_extensions How many times the contract has been extended.
75 * @param p_extension_reason Reason for extending the contract
76 * @param p_extension_period How long the contract has been extended.
77 * @param p_extension_period_units Units for extension period, e.g., Weeks,
78 * Months, Years. Valid values are defined by the QUALIFYING_UNITS lookup type.
82 * @param p_ctr_information1 Developer descriptive flexfield segment.
79 * @param p_ctr_information_category This context value determines which
80 * flexfield structure to use with the Developer Descriptive Flexfield
81 * segments.
83 * @param p_ctr_information2 Developer descriptive flexfield segment.
84 * @param p_ctr_information3 Developer descriptive flexfield segment.
85 * @param p_ctr_information4 Developer descriptive flexfield segment.
86 * @param p_ctr_information5 Developer descriptive flexfield segment.
87 * @param p_ctr_information6 Developer descriptive flexfield segment.
88 * @param p_ctr_information7 Developer descriptive flexfield segment.
89 * @param p_ctr_information8 Developer descriptive flexfield segment.
90 * @param p_ctr_information9 Developer descriptive flexfield segment.
91 * @param p_ctr_information10 Developer descriptive flexfield segment.
92 * @param p_ctr_information11 Developer descriptive flexfield segment.
93 * @param p_ctr_information12 Developer descriptive flexfield segment.
94 * @param p_ctr_information13 Developer descriptive flexfield segment.
95 * @param p_ctr_information14 Developer descriptive flexfield segment.
96 * @param p_ctr_information15 Developer descriptive flexfield segment.
97 * @param p_ctr_information16 Developer descriptive flexfield segment.
98 * @param p_ctr_information17 Developer descriptive flexfield segment.
99 * @param p_ctr_information18 Developer descriptive flexfield segment.
100 * @param p_ctr_information19 Developer descriptive flexfield segment.
101 * @param p_ctr_information20 Developer descriptive flexfield segment.
102 * @param p_attribute_category This context value determines which flexfield
103 * structure to use with the descriptive flexfield segments.
104 * @param p_attribute1 Descriptive flexfield segment.
105 * @param p_attribute2 Descriptive flexfield segment.
106 * @param p_attribute3 Descriptive flexfield segment.
107 * @param p_attribute4 Descriptive flexfield segment.
108 * @param p_attribute5 Descriptive flexfield segment.
109 * @param p_attribute6 Descriptive flexfield segment.
110 * @param p_attribute7 Descriptive flexfield segment.
111 * @param p_attribute8 Descriptive flexfield segment.
112 * @param p_attribute9 Descriptive flexfield segment.
113 * @param p_attribute10 Descriptive flexfield segment.
114 * @param p_attribute11 Descriptive flexfield segment.
115 * @param p_attribute12 Descriptive flexfield segment.
116 * @param p_attribute13 Descriptive flexfield segment.
117 * @param p_attribute14 Descriptive flexfield segment.
118 * @param p_attribute15 Descriptive flexfield segment.
119 * @param p_attribute16 Descriptive flexfield segment.
120 * @param p_attribute17 Descriptive flexfield segment.
121 * @param p_attribute18 Descriptive flexfield segment.
122 * @param p_attribute19 Descriptive flexfield segment.
123 * @param p_attribute20 Descriptive flexfield segment.
124 * @param p_effective_date Determines when the DateTrack operation comes into
125 * force.
126 * @rep:displayname Create Employment Contract
127 * @rep:category BUSINESS_ENTITY PER_EMPLOYMENT_CONTRACT
128 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
129 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
130 * @rep:scope public
131 * @rep:lifecycle active
132 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
133 */
134 --
135 -- {End Of Comments}
136 --
137 procedure create_contract
138 (
139 p_validate in boolean default false
140 ,p_contract_id out nocopy number
141 ,p_effective_start_date out nocopy date
142 ,p_effective_end_date out nocopy date
143 ,p_object_version_number out nocopy number
144 ,p_person_id in number
145 ,p_reference in varchar2
146 ,p_type in varchar2
147 ,p_status in varchar2
148 ,p_status_reason in varchar2 default null
149 ,p_doc_status in varchar2 default null
150 ,p_doc_status_change_date in date default null
151 ,p_description in varchar2 default null
152 ,p_duration in number default null
153 ,p_duration_units in varchar2 default null
154 ,p_contractual_job_title in varchar2 default null
155 ,p_parties in varchar2 default null
156 ,p_start_reason in varchar2 default null
157 ,p_end_reason in varchar2 default null
158 ,p_number_of_extensions in number default null
159 ,p_extension_reason in varchar2 default null
160 ,p_extension_period in number default null
161 ,p_extension_period_units in varchar2 default null
162 ,p_ctr_information_category in varchar2 default null
163 ,p_ctr_information1 in varchar2 default null
164 ,p_ctr_information2 in varchar2 default null
165 ,p_ctr_information3 in varchar2 default null
166 ,p_ctr_information4 in varchar2 default null
167 ,p_ctr_information5 in varchar2 default null
168 ,p_ctr_information6 in varchar2 default null
169 ,p_ctr_information7 in varchar2 default null
170 ,p_ctr_information8 in varchar2 default null
171 ,p_ctr_information9 in varchar2 default null
172 ,p_ctr_information10 in varchar2 default null
173 ,p_ctr_information11 in varchar2 default null
174 ,p_ctr_information12 in varchar2 default null
175 ,p_ctr_information13 in varchar2 default null
176 ,p_ctr_information14 in varchar2 default null
177 ,p_ctr_information15 in varchar2 default null
178 ,p_ctr_information16 in varchar2 default null
179 ,p_ctr_information17 in varchar2 default null
180 ,p_ctr_information18 in varchar2 default null
181 ,p_ctr_information19 in varchar2 default null
182 ,p_ctr_information20 in varchar2 default null
183 ,p_attribute_category in varchar2 default null
184 ,p_attribute1 in varchar2 default null
185 ,p_attribute2 in varchar2 default null
186 ,p_attribute3 in varchar2 default null
187 ,p_attribute4 in varchar2 default null
188 ,p_attribute5 in varchar2 default null
189 ,p_attribute6 in varchar2 default null
190 ,p_attribute7 in varchar2 default null
191 ,p_attribute8 in varchar2 default null
192 ,p_attribute9 in varchar2 default null
193 ,p_attribute10 in varchar2 default null
194 ,p_attribute11 in varchar2 default null
195 ,p_attribute12 in varchar2 default null
196 ,p_attribute13 in varchar2 default null
197 ,p_attribute14 in varchar2 default null
198 ,p_attribute15 in varchar2 default null
199 ,p_attribute16 in varchar2 default null
200 ,p_attribute17 in varchar2 default null
201 ,p_attribute18 in varchar2 default null
202 ,p_attribute19 in varchar2 default null
203 ,p_attribute20 in varchar2 default null
204 ,p_effective_date in date
205 );
206 --
207 -- ----------------------------------------------------------------------------
208 -- |-----------------------------< update_contract >--------------------------|
209 -- ----------------------------------------------------------------------------
210 --
211 -- {Start Of Comments}
212 /*#
213 * This API updates an existing contract for an employee.
214 *
215 * Use this API to update contract information details for an employee. The
216 * contract record stores date information, such as expiration. You can also
217 * track the status of physical documents produced as a result of signing the
218 * contract. This is no restriction on how many contracts a person can have at
219 * a given time.
220 *
221 * <p><b>Licensing</b><br>
222 * This API is licensed for use with Human Resources.
223 *
224 * <p><b>Prerequisites</b><br>
225 * A contract must have been created for the employee.
226 *
227 * <p><b>Post Success</b><br>
228 * The contract will have been updated for the employee
229 *
230 * <p><b>Post Failure</b><br>
231 * The API does not update the contract and raises an error.
232 * @param p_validate If true, then validation alone will be performed and the
233 * database will remain unchanged. If false and all validation checks pass,
234 * then the database will be modified.
235 * @param p_contract_id Identifies the contract record to be modified.
236 * @param p_effective_start_date If p_validate is false, then set to the
237 * effective start date in the updated contract row as of the effective date.
238 * If p_validate is true, then set to null.
239 * @param p_effective_end_date If p_validate is false, then set to the
240 * effective end date in the updated contract row as of the effective date. If
241 * p_validate is true, then set to null.
242 * @param p_object_version_number Passes the current version number of the
243 * contract to be updated. If p_validate is false on completion, set to the new
244 * version number of the updated contract. If p_validate is true set to the
245 * input value.
246 * @param p_person_id Identifies the employee for whom the contract was created
247 * @param p_reference Reference code for the contract
248 * @param p_type The type of the contract. Valid values are defined by the
249 * CONTRACT_TYPE lookup type.
250 * @param p_status The status of the contract. Valid values are defined by the
251 * CONTRACT_STATUS lookup type.
252 * @param p_status_reason The reason why the contract has its current status.
253 * Valid values are defined by the CONTRACT_STATUS_REASON lookup type.
254 * @param p_doc_status The status of the physical document associated with the
255 * contract. Valid values are defined by the DOCUMENT_STATUS lookup type.
256 * @param p_doc_status_change_date Date the document status changed.
257 * @param p_description Contract description
258 * @param p_duration The length of time during which the contract is active.
259 * @param p_duration_units Units for contract duration, e.g., Weeks, Months,
260 * Years. Valid values are defined by the QUALIFYING_UNITS lookup type.
261 * @param p_contractual_job_title Contractual job title
262 * @param p_parties Parties to the contract
263 * @param p_start_reason Reason for starting the contract. Valid values are
264 * defined by the CONTRACT_START_REASON lookup type.
265 * @param p_end_reason Reason for ending the contract. Valid values are defined
269 * @param p_extension_period How long the contract has been extended.
266 * by the CONTRACT_END_REASON lookup type.
267 * @param p_number_of_extensions How many times the contract has been extended.
268 * @param p_extension_reason Reason for extending the contract
270 * @param p_extension_period_units Units for extension period, e.g., Weeks,
271 * Months, Years. Valid values are defined by the QUALIFYING_UNITS lookup type.
272 * @param p_ctr_information_category This context value determines which
273 * Flexfield Structure to use with the Developer Descriptive flexfield
274 * segments.
275 * @param p_ctr_information1 Developer descriptive flexfield segment.
276 * @param p_ctr_information2 Developer descriptive flexfield segment.
277 * @param p_ctr_information3 Developer descriptive flexfield segment.
278 * @param p_ctr_information4 Developer descriptive flexfield segment.
279 * @param p_ctr_information5 Developer descriptive flexfield segment.
280 * @param p_ctr_information6 Developer descriptive flexfield segment.
281 * @param p_ctr_information7 Developer descriptive flexfield segment.
282 * @param p_ctr_information8 Developer descriptive flexfield segment.
283 * @param p_ctr_information9 Developer descriptive flexfield segment.
284 * @param p_ctr_information10 Developer descriptive flexfield segment.
285 * @param p_ctr_information11 Developer descriptive flexfield segment.
286 * @param p_ctr_information12 Developer descriptive flexfield segment.
287 * @param p_ctr_information13 Developer descriptive flexfield segment.
288 * @param p_ctr_information14 Developer descriptive flexfield segment.
289 * @param p_ctr_information15 Developer descriptive flexfield segment.
290 * @param p_ctr_information16 Developer descriptive flexfield segment.
291 * @param p_ctr_information17 Developer descriptive flexfield segment.
292 * @param p_ctr_information18 Developer descriptive flexfield segment.
293 * @param p_ctr_information19 Developer descriptive flexfield segment.
294 * @param p_ctr_information20 Developer descriptive flexfield segment.
295 * @param p_attribute_category This context value determines which flexfield
296 * structure to use with the descriptive flexfield segments.
297 * @param p_attribute1 Descriptive flexfield segment.
298 * @param p_attribute2 Descriptive flexfield segment.
299 * @param p_attribute3 Descriptive flexfield segment.
300 * @param p_attribute4 Descriptive flexfield segment.
301 * @param p_attribute5 Descriptive flexfield segment.
302 * @param p_attribute6 Descriptive flexfield segment.
303 * @param p_attribute7 Descriptive flexfield segment.
304 * @param p_attribute8 Descriptive flexfield segment.
305 * @param p_attribute9 Descriptive flexfield segment.
306 * @param p_attribute10 Descriptive flexfield segment.
307 * @param p_attribute11 Descriptive flexfield segment.
308 * @param p_attribute12 Descriptive flexfield segment.
309 * @param p_attribute13 Descriptive flexfield segment.
310 * @param p_attribute14 Descriptive flexfield segment.
311 * @param p_attribute15 Descriptive flexfield segment.
312 * @param p_attribute16 Descriptive flexfield segment.
313 * @param p_attribute17 Descriptive flexfield segment.
314 * @param p_attribute18 Descriptive flexfield segment.
315 * @param p_attribute19 Descriptive flexfield segment.
316 * @param p_attribute20 Descriptive flexfield segment.
317 * @param p_effective_date Determines when the DateTrack operation comes into
318 * force.
319 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
320 * the record. You must set to UPDATE, CORRECTION, UPDATE_OVERRIDE or
321 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
322 * depend on the dates of previous record changes and the effective date of
323 * this change.
324 * @rep:displayname Update Employment Contract
325 * @rep:category BUSINESS_ENTITY PER_EMPLOYMENT_CONTRACT
326 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
327 * @rep:scope public
328 * @rep:lifecycle active
329 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
330 */
331 --
332 -- {End Of Comments}
333 --
334 procedure update_contract
335 (
336 p_validate in boolean default false
337 ,p_contract_id in number
338 ,p_effective_start_date out nocopy date
339 ,p_effective_end_date out nocopy date
340 ,p_object_version_number in out nocopy number
341 ,p_person_id in number
342 ,p_reference in varchar2
343 ,p_type in varchar2
344 ,p_status in varchar2
345 ,p_status_reason in varchar2 default hr_api.g_varchar2
346 ,p_doc_status in varchar2 default hr_api.g_varchar2
347 ,p_doc_status_change_date in date default hr_api.g_date
348 ,p_description in varchar2 default hr_api.g_varchar2
349 ,p_duration in number default hr_api.g_number
350 ,p_duration_units in varchar2 default hr_api.g_varchar2
351 ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
352 ,p_parties in varchar2 default hr_api.g_varchar2
353 ,p_start_reason in varchar2 default hr_api.g_varchar2
354 ,p_end_reason in varchar2 default hr_api.g_varchar2
355 ,p_number_of_extensions in number default hr_api.g_number
356 ,p_extension_reason in varchar2 default hr_api.g_varchar2
357 ,p_extension_period in number default hr_api.g_number
358 ,p_extension_period_units in varchar2 default hr_api.g_varchar2
359 ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
360 ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
361 ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
362 ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
366 ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
363 ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
364 ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
365 ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
367 ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
368 ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
369 ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
370 ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
371 ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
372 ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
373 ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
374 ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
375 ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
376 ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
377 ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
378 ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
379 ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
380 ,p_attribute_category in varchar2 default hr_api.g_varchar2
381 ,p_attribute1 in varchar2 default hr_api.g_varchar2
382 ,p_attribute2 in varchar2 default hr_api.g_varchar2
383 ,p_attribute3 in varchar2 default hr_api.g_varchar2
384 ,p_attribute4 in varchar2 default hr_api.g_varchar2
385 ,p_attribute5 in varchar2 default hr_api.g_varchar2
386 ,p_attribute6 in varchar2 default hr_api.g_varchar2
387 ,p_attribute7 in varchar2 default hr_api.g_varchar2
388 ,p_attribute8 in varchar2 default hr_api.g_varchar2
389 ,p_attribute9 in varchar2 default hr_api.g_varchar2
390 ,p_attribute10 in varchar2 default hr_api.g_varchar2
391 ,p_attribute11 in varchar2 default hr_api.g_varchar2
392 ,p_attribute12 in varchar2 default hr_api.g_varchar2
393 ,p_attribute13 in varchar2 default hr_api.g_varchar2
394 ,p_attribute14 in varchar2 default hr_api.g_varchar2
395 ,p_attribute15 in varchar2 default hr_api.g_varchar2
396 ,p_attribute16 in varchar2 default hr_api.g_varchar2
397 ,p_attribute17 in varchar2 default hr_api.g_varchar2
398 ,p_attribute18 in varchar2 default hr_api.g_varchar2
399 ,p_attribute19 in varchar2 default hr_api.g_varchar2
400 ,p_attribute20 in varchar2 default hr_api.g_varchar2
401 ,p_effective_date in date
402 ,p_datetrack_mode in varchar2
403 );
404 --
405 -- ----------------------------------------------------------------------------
406 -- |-----------------------------< delete_contract >--------------------------|
407 -- ----------------------------------------------------------------------------
408 --
409 -- {Start Of Comments}
410 /*#
411 * This API deletes employee's contract information.
412 *
413 * Use this API to delete contract information for an employee. The contract
414 * record stores date information, such as expiration. You can also track the
415 * status of physical documents produced as a result of signing the contract.
416 * There is no restriction on the number of contracts a person can have at a
417 * given time.
418 *
419 * <p><b>Licensing</b><br>
420 * This API is licensed for use with Human Resources.
421 *
422 * <p><b>Prerequisites</b><br>
423 * A contract must have been created for the employee.
424 *
425 * <p><b>Post Success</b><br>
426 * Depending on the DateTrack mode used, some of all of the contract
427 * information for the employee will be deleted.
428 *
429 * <p><b>Post Failure</b><br>
430 * The API does not delete the contract and raises an error.
431 * @param p_validate If true, then validation alone will be performed and the
432 * database will remain unchanged. If false and all validation checks pass,
433 * then the database will be modified.
434 * @param p_contract_id Identifies the contract record to be deleted
435 * @param p_effective_start_date If p_validate is false, then set to the
436 * effective start date for the deleted contract row which now exists as of the
437 * effective date. If p_validate is true or all row instances have been deleted
438 * then set to null.
439 * @param p_effective_end_date If p_validate is false, then set to the
440 * effective end date for the deleted contract row which now exists as of the
441 * effective date. If p_validate is true or all row instances have been deleted
442 * then set to null.
443 * @param p_object_version_number Current version number of the contract to be
444 * deleted
445 * @param p_effective_date Determines when the DateTrack operation comes into
446 * force
447 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
448 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
449 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
450 * on the dates of previous record changes and the effective date of this
451 * change.
452 * @rep:displayname Delete Employment Contract
453 * @rep:category BUSINESS_ENTITY PER_EMPLOYMENT_CONTRACT
454 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
455 * @rep:scope public
456 * @rep:lifecycle active
457 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
458 */
459 --
460 -- {End Of Comments}
461 --
462 procedure delete_contract
463 (
464 p_validate in boolean default false
465 ,p_contract_id in number
466 ,p_effective_start_date out nocopy date
467 ,p_effective_end_date out nocopy date
468 ,p_object_version_number in out nocopy number
469 ,p_effective_date in date
470 ,p_datetrack_mode in varchar2
471 );
472 --
473 -- ----------------------------------------------------------------------------
474 -- |----------------------------------< lck >---------------------------------|
475 -- ----------------------------------------------------------------------------
476 -- {Start Of Comments}
477 --
478 -- Description:
479 --
480 -- Prerequisites:
481 --
482 --
483 -- In Parameters:
484 -- Name Reqd Type Description
485 -- p_contract_id Yes number PK of record
486 -- p_object_version_number Yes number OVN of record
487 -- p_effective_date Yes date Session Date.
488 -- p_datetrack_mode Yes varchar2 Datetrack mode.
489 --
490 -- Post Success:
491 --
492 -- Name Type Description
493 -- p_validation_start_date Yes Derived Effective Start Date.
494 -- p_validation_end_date Yes Derived Effective End Date.
495 --
496 -- Post Failure:
497 --
498 -- Access Status:
499 -- Public.
500 --
501 -- {End Of Comments}
502 --
503 procedure lck
504 (
505 p_contract_id in number
506 ,p_object_version_number in number
507 ,p_effective_date in date
508 ,p_datetrack_mode in varchar2
509 ,p_validation_start_date out nocopy date
510 ,p_validation_end_date out nocopy date
511 );
512 --
513 procedure maintain_contracts
514 (
515 p_person_id number,
516 p_new_start_date date,
517 p_old_start_date date
518 );
519 --
520 function get_pps_start_date
521 (p_person_id in number,
522 p_active_date in date) return date;
523 -- pragma restrict_references(get_pps_start_date, WNPS, WNDS);
524 --
525 function get_pps_end_date
526 (p_person_id in number,
527 p_active_date in date) return date;
528 pragma restrict_references(get_pps_end_date, WNPS, WNDS);
529 --
530 function get_meaning
531 (p_lookup_code in varchar2,
532 p_lookup_type in varchar2) return varchar2;
533 -- pragma restrict_references(get_meaning, WNPS, WNDS);
534 --
535 function get_active_start_date
536 (p_contract_id in number,
537 p_effective_date in date,
538 p_status in varchar2) return date;
539 pragma restrict_references(get_active_start_date, WNPS, WNDS);
540 --
541 function get_active_end_date
542 (p_contract_id in number,
543 p_effective_date in date,
544 p_status in varchar2) return date;
545 pragma restrict_references(get_active_end_date, WNPS, WNDS);
546 --
547 end hr_contract_api;
[Home] [Help]