DBA Data[Home] [Help]

PACKAGE: APPS.HR_APPRAISALS_API

Source


1 Package hr_appraisals_api AUTHID CURRENT_USER as
2 /* $Header: peaprapi.pkh 120.8 2009/08/12 14:17:19 rvagvala ship $*/
3 /*#
4  * This package contains Appraisals APIs.
5  * @rep:scope public
6  * @rep:product per
7  * @rep:displayname Appraisal
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------------< create_appraisal >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16  *  This API creates an appraisal for a person. An appraisal holds the
17  *  evaluation details of a person by others for a performance review and
18  *  can include objective setting etc.
19  *
20  * <p><b>Licensing</b><br>
21  * This API is licensed for use with Human Resources.
22  *
23  * <p><b>Prerequisites</b><br>
24  *  A valid appraisal template must exist. Person records for whom the
25  *  appraisal is being performed and the person who is performing this
26  *  appraisal must exist.
27  *
28  * <p><b>Post Success</b><br>
29  * Appraisal is created.
30  *
31  * <p><b>Post Failure</b><br>
32  * Appraisal is not created and an error is raised.
33  * @param p_validate If true, then validation alone will be performed and the
34  * database will remain unchanged. If false and all validation checks pass,
35  * then the database will be modified.
36  * @param p_effective_date Reference date for validating lookup values are
37  * applicable during the start to end active date range. This date does not
38  * determine when the changes take effect.
39  * @param p_business_group_id Business group to which the appraisal belongs.
40  * @param p_appraisal_template_id Appraisal template to be used for this
41  * appraisal.
45  * @param p_appraisal_date {@rep:casecolumn PER_APPRAISALS.APPRAISAL_DATE}
42  * @param p_appraisee_person_id Person on whom the appraisal is being
43  * performed.
44  * @param p_appraiser_person_id Person who is performing the appraisal.
46  * @param p_appraisal_period_start_date {@rep:casecolumn
47  * PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE}
48  * @param p_appraisal_period_end_date {@rep:casecolumn
49  * PER_APPRAISALS.APPRAISAL_PERIOD_END_DATE}
50  * @param p_type Type of appraisal used. Valid values are defined by the
51  * APPRAISAL_TYPE lookup type.
52  * @param p_next_appraisal_date Proposed date when the next appraisal will be
53  * performed.
54  * @param p_status Status of the appraisal within approval process. Valid
55  * values are defined by the APPRAISAL_ASSESSMENT_STATUS lookup type.
56  * @param p_group_date The date the group was created.
57  * @param p_group_initiator_id Person who created the group.
58  * @param p_comments Comments text.
59  * @param p_overall_performance_level_id Performance rating level of the
60  * appraisee.
61  * @param p_open Indicates whether the appraisal is open for modification.
62  * Valid values are defined by the YES_NO lookup type.
63  * @param p_attribute_category This context value determines which flexfield
64  * structure to use with the descriptive flexfield segments.
65  * @param p_attribute1 Descriptive flexfield segment.
66  * @param p_attribute2 Descriptive flexfield segment.
67  * @param p_attribute3 Descriptive flexfield segment.
68  * @param p_attribute4 Descriptive flexfield segment.
69  * @param p_attribute5 Descriptive flexfield segment.
70  * @param p_attribute6 Descriptive flexfield segment.
71  * @param p_attribute7 Descriptive flexfield segment.
72  * @param p_attribute8 Descriptive flexfield segment.
73  * @param p_attribute9 Descriptive flexfield segment.
74  * @param p_attribute10 Descriptive flexfield segment.
75  * @param p_attribute11 Descriptive flexfield segment.
76  * @param p_attribute12 Descriptive flexfield segment.
77  * @param p_attribute13 Descriptive flexfield segment.
78  * @param p_attribute14 Descriptive flexfield segment.
79  * @param p_attribute15 Descriptive flexfield segment.
80  * @param p_attribute16 Descriptive flexfield segment.
81  * @param p_attribute17 Descriptive flexfield segment.
82  * @param p_attribute18 Descriptive flexfield segment.
83  * @param p_attribute19 Descriptive flexfield segment.
84  * @param p_attribute20 Descriptive flexfield segment.
85  * @param p_system_type Appraisal system type. Indicates the type of person
86  * filling out the appraisal, e.g., manager, peer feedback etc.. Valid values
87  * are defined by the APPRAISAL_SYSTEM_TYPE lookup type
88  * @param p_system_params Different attributes can be put together into this single
89  * parameter. This parameter holds data for many attributes together in a form of
90  * free text. Attribute name and values are separated by an equal '=' sign. If
91  * multiple attributes are used, then these are separated by an ampersand '&'.
92  * Attributes can be of any of the following: SystemType, ItemType, ProcessName,
93  * ApprovalReqd, AMETranType, AMEAppId, TransactionType, FunctionId etc. For a
94  * single attribute the entry will be of the format: SystemType=EMP360. If more
95  * than one attribute is passed then the entry will be of the format:
96  * SystemType=EMP360amp;ItemType=HRSSAamp;ProcessName=HR_APPRAISAL_DETAILS_JSP_PRC
97  * @param p_appraisee_access Determines the information to which the appraisee
98  * has access.
99  * @param p_main_appraiser_id Person who is the main appraiser and gives the
100  * final ratings for the appraisal
101  * @param p_assignment_id Identifies the assignment for which this appraisal is
102  * performed.
103  * @param p_assignment_start_date Start date of the assignment.
104  * @param p_asg_business_group_id Business group of the assignment considered
105  * for the appraisal
106  * @param p_assignment_organization_id Organization of the assignment.
107  * @param p_assignment_job_id Job for this assignment.
108  * @param p_assignment_position_id Position of this assignment.
109  * @param p_assignment_grade_id Grade of this assignment.
110  * @param p_appraisal_id If p_validate is false, uniquely identifies the
111  * appraisal created. If p_validate is true, set to null.
112  * @param p_object_version_number If p_validate is false, then set to the
113  * version number of the created appraisal. If p_validate is true, then the
114  * value will be null.
115  * @param p_appraisal_system_status Current system status of the appraisal
116  * @param p_potential_readiness_level Readiness level. Valid values are defined
117  * in READINESS_LEVEL lookup type.
118  * @param p_potential_short_term_workopp Short term work opportunity identified
119  * for the employee during final ratings. (eg. If the employee is 'Application
120  * Developer' now, then 'Sr. Developer' is the short term opportunity, where as
121  * 'Product Development Manager' can be regarded as long term opportunity.)
122  * @param p_potential_long_term_workopp Long term work opportunities identified
123  * for the employee. (eg. Development Manager/Product Director etc.) given
124  * during final ratings.
125  * @param p_potential_details Details identified by the appraiser about the
126  * potential of the employee during the final appraisal ratings.
127  * @param p_event_id Event recorded for this appraisal
128  * @param p_show_competency_ratings Flag to indicate if appraisee can view main appraiser competency ratings.
129  * @param p_show_objective_ratings Flag to indicate if appraisee can view main appraiser objective ratings.
130  * @param p_show_questionnaire_info Flag to indicate if appraisee can view main appraiser answered questionnaire.
131  * @param p_show_participant_details Flag to indicate if appraisee can view participants details.
132  * @param p_show_participant_ratings Flag to indicate if appraisee can view participants ratings.
133  * @param p_show_participant_names Flag to indicate if appraisee can view participants names.
134  * @param p_show_overall_ratings Flag to indicate if appraisee can view main appraiser overall ratings.
138  * @param p_appraisee_comments Stores appraisee overall feedback on appraisal.
135  * @param p_show_overall_comments Flag to indicate if appraisee can view main appraiser overall comments.
136  * @param p_update_appraisal Flag to indicate if appraisee can update appraisal.
137  * @param p_provide_overall_feedback Flag to indicate if appraisee can provide overall feedback on appraisal.
139  * @param p_plan_id If not null stores the performance management plan identifier.
140  * @param p_offline_status  Indicates the offline status of the appraisal document.
141  * Valid values are defined by the APPRAISAL_OFFLINE_STATUS lookup type.
142  * @rep:displayname Create Appraisal
143  * @rep:category BUSINESS_ENTITY PER_APPRAISAL
144  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
145  * @rep:scope public
146  * @rep:lifecycle active
147  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
148 */
149 --
150 -- {End Of Comments}
151 --
152 procedure create_appraisal
153  (p_validate                     in     boolean  	default false,
154   p_effective_date               in     date,
155   p_business_group_id            in 	number,
156   p_appraisal_template_id        in   	number,
157   p_appraisee_person_id          in 	number,
158   p_appraiser_person_id          in  	number,
159   p_appraisal_date               in  	date		 default null,
160   p_appraisal_period_start_date  in  	date,
161   p_appraisal_period_end_date    in  	date ,
162   p_type                         in    	varchar2	 default null,
163   p_next_appraisal_date          in     date		 default null,
164   p_status                       in    	varchar2 	 default null,
165   p_group_date			 in     date             default null,
166   p_group_initiator_id	  	 in     number           default null,
167   p_comments                     in     varchar2	 default null,
168   p_overall_performance_level_id in     number 		 default null,
169   p_open	 	         in 	varchar2         default 'Y',
170   p_attribute_category           in 	varchar2         default null,
171   p_attribute1                   in 	varchar2         default null,
172   p_attribute2                   in 	varchar2         default null,
173   p_attribute3                   in 	varchar2         default null,
174   p_attribute4                   in 	varchar2         default null,
175   p_attribute5                   in 	varchar2         default null,
176   p_attribute6                   in 	varchar2         default null,
177   p_attribute7                   in 	varchar2         default null,
178   p_attribute8                   in 	varchar2         default null,
179   p_attribute9                   in 	varchar2         default null,
180   p_attribute10                  in 	varchar2         default null,
181   p_attribute11                  in 	varchar2         default null,
182   p_attribute12                  in 	varchar2         default null,
183   p_attribute13                  in 	varchar2         default null,
184   p_attribute14                  in 	varchar2         default null,
185   p_attribute15                  in 	varchar2         default null,
186   p_attribute16                  in 	varchar2         default null,
187   p_attribute17                  in 	varchar2         default null,
188   p_attribute18                  in 	varchar2         default null,
189   p_attribute19                  in 	varchar2         default null,
190   p_attribute20                  in 	varchar2         default null,
191   p_system_type                  in     varchar2         default null,
192   p_system_params                in     varchar2         default null,
193   p_appraisee_access             in     varchar2 	 default null,
194   p_main_appraiser_id            in     number 	 	 default null,
195   p_assignment_id                in     number 		 default null,
196   p_assignment_start_date        in     date  		 default null,
197   p_asg_business_group_id        in     number		 default null,
198   p_assignment_organization_id   in     number		 default null,
199   p_assignment_job_id            in     number		 default null,
200   p_assignment_position_id       in     number		 default null,
201   p_assignment_grade_id          in     number		 default null,
202   p_appraisal_id                 out nocopy    number,
203   p_object_version_number        out nocopy 	number,
204   p_appraisal_system_status      in     varchar2         default null,
205   p_potential_readiness_level    in varchar2         default null,
206   p_potential_short_term_workopp in varchar2         default null,
207   p_potential_long_term_workopp  in varchar2         default null,
208   p_potential_details            in varchar2         default null,
209   p_event_id                     in number           default null,
210   p_show_competency_ratings      in varchar2         default null,
211   p_show_objective_ratings       in varchar2         default null,
212   p_show_questionnaire_info      in varchar2         default null,
213   p_show_participant_details     in varchar2         default null,
214   p_show_participant_ratings     in varchar2         default null,
215   p_show_participant_names       in varchar2         default null,
216   p_show_overall_ratings         in varchar2         default null,
217   p_show_overall_comments        in varchar2         default null,
218   p_update_appraisal             in varchar2         default null,
219   p_provide_overall_feedback     in varchar2         default null,
220   p_appraisee_comments           in varchar2         default null,
221   p_plan_id                      in number           default null,
222   p_offline_status               in varchar2         default null,
223 p_retention_potential          in varchar2           default null,
224 p_show_participant_comments     in varchar2            default null  -- 8651478 bug fix
225   );
226 --
227 -- ----------------------------------------------------------------------------
228 -- |-----------------------------< update_appraisal >-------------------------|
229 -- ----------------------------------------------------------------------------
230 --
231 -- {Start Of Comments}
232 /*#
236  *
233  * This API updates an existing appraisal for a person. An appraisal
234  * holds the evaluation details of a person by others for a performance
235  * review and can include objective setting etc.
237  * <p><b>Licensing</b><br>
238  * This API is licensed for use with Human Resources.
239  *
240  * <p><b>Prerequisites</b><br>
241  * A valid appraisal must exist.
242  *
243  * <p><b>Post Success</b><br>
244  * Appraisal is updated.
245  *
246  * <p><b>Post Failure</b><br>
247  * Appraisal remains unchanged and an error is raised.
248  * @param p_validate If true, then only validation will be performed and the
249  * database remains unchanged. If false, then all validation checks pass the
250  * database will be modified.
251  * @param p_effective_date Reference date for validating lookup values are
252  * applicable during the start to end active date range. This date does not
253  * determine when the changes take effect.
254  * @param p_appraisal_id The appraisal to be updated.
255  * @param p_object_version_number Pass in the current version number of the
256  * appraisal to be updated. When the API completes if p_validate is false, will
257  * be set to the new version number of the updated appraisal. If p_validate is
258  * true will be set to the same value which was passed in.
259  * @param p_appraiser_person_id Person who is performing the appraisal.
260  * @param p_appraisal_date Date when the appraisal is to take place.
261  * @param p_appraisal_period_end_date End date of the appraisal period.
262  * @param p_appraisal_period_start_date The start date of appraisal period.
263  * @param p_type Type of appraisal used. Valid values are defined by the
264  * APPRAISAL_TYPE lookup type.
265  * @param p_next_appraisal_date Proposed date when the next appraisal will be
266  * performed.
267  * @param p_status Indicates the status of this appraisal. Valid values are
268  * defined by the APPRAISAL_ASSESSMENT_STATUS lookup type. (possible values are
269  * ongoing, planned, complete, incomplete, waiting on feedback)
270  * @param p_comments Comments text.
271  * @param p_overall_performance_level_id Performance rating level of the
272  * appraisee.
273  * @param p_open Whether appraisal is open for modification. Valid values are
274  * defined by the YES_NO lookup type.
275  * @param p_attribute_category This context value determines which flexfield
276  * structure to use with the descriptive flexfield segments.
277  * @param p_attribute1 Descriptive flexfield segment.
278  * @param p_attribute2 Descriptive flexfield segment.
279  * @param p_attribute3 Descriptive flexfield segment.
280  * @param p_attribute4 Descriptive flexfield segment.
281  * @param p_attribute5 Descriptive flexfield segment.
282  * @param p_attribute6 Descriptive flexfield segment.
283  * @param p_attribute7 Descriptive flexfield segment.
284  * @param p_attribute8 Descriptive flexfield segment.
285  * @param p_attribute9 Descriptive flexfield segment.
286  * @param p_attribute10 Descriptive flexfield segment.
287  * @param p_attribute11 Descriptive flexfield segment.
288  * @param p_attribute12 Descriptive flexfield segment.
289  * @param p_attribute13 Descriptive flexfield segment.
290  * @param p_attribute14 Descriptive flexfield segment.
291  * @param p_attribute15 Descriptive flexfield segment.
292  * @param p_attribute16 Descriptive flexfield segment.
293  * @param p_attribute17 Descriptive flexfield segment.
294  * @param p_attribute18 Descriptive flexfield segment.
295  * @param p_attribute19 Descriptive flexfield segment.
296  * @param p_attribute20 Descriptive flexfield segment.
297  * @param p_system_type Appraisal system type. Indicates the type of person
298  * filling out the appraisal, e.g., manager, peer feedback etc.. Valid values
299  * are defined by the APPRAISAL_SYSTEM_TYPE lookup type
300  * @param p_system_params Different attributes can be put together into this
301  * single parameter. This parameter holds data for many attributes together in
302  * a form of free text. Attribute name and values are separated by an equal '=' sign.
303  * If multiple attributes are used, then these are separated by an ampersand '&'.
304  * Attributes can be of any of the following: SystemType, ItemType, ProcessName,
305  * ApprovalReqd, AMETranType, AMEAppId, TransactionType, FunctionId etc. For a
306  * single attribute the entry will be of the format: SystemType=EMP360. If
307  * more than one attribute is passed then the entry will be of the format:
308  * SystemType=EMP360amp;ItemType=HRSSAamp;ProcessName=HR_APPRAISAL_DETAILS_JSP_PRC
309  * @param p_appraisee_access Determines the information to which the appraisee
310  * has access.
311  * @param p_main_appraiser_id Person who is the main appraiser and gives the
312  * final ratings for the appraisal
313  * @param p_assignment_id Identifies the assignment for which this appraisal is
314  * performed.
315  * @param p_assignment_start_date Start date of the assignment.
316  * @param p_asg_business_group_id Business group of the assignment considered
317  * for the appraisal
318  * @param p_assignment_organization_id Organization of the assignment.
319  * @param p_assignment_job_id Job for this assignment.
320  * @param p_assignment_position_id Position of this assignment.
321  * @param p_assignment_grade_id Grade of this assignment.
322  * @param p_appraisal_system_status Current system status of the appraisal
323  * @param p_potential_readiness_level Readiness level. Valid values are defined
324  * in READINESS_LEVEL lookup type.
325  * @param p_potential_short_term_workopp Short term work opportunity identified for
326  * the employee during final ratings. (eg. If the employee is 'Application Developer'
327  * now, then 'Sr. Developer' is the short term opportunity, where as 'Product
328  * Development Manager' can be regarded as long term opportunity.)
329  * @param p_potential_long_term_workopp Long term work opportunities identified for
330  * the employee. (eg. Development Manager/Product Director etc.) given during final
331  * ratings.
332  * @param p_potential_details Details identified by the appraiser about the
336  * @param p_show_objective_ratings Flag to indicate if appraisee can view main appraiser objective ratings.
333  * potential of the employee during the final appraisal ratings.
334  * @param p_event_id Event recorded for this appraisal
335  * @param p_show_competency_ratings Flag to indicate if appraisee can view main appraiser competency ratings.
337  * @param p_show_questionnaire_info Flag to indicate if appraisee can view main appraiser answered
338  * questionnaire.
339  * @param p_show_participant_details Flag to indicate if appraisee can view participants details.
340  * @param p_show_participant_ratings Flag to indicate if appraisee can view participants ratings.
341  * @param p_show_participant_names Flag to indicate if appraisee can view participants names.
342  * @param p_show_overall_ratings Flag to indicate if appraisee can view main appraiser overall ratings.
343  * @param p_show_overall_comments Flag to indicate if appraisee can view main appraiser overall comments.
344  * @param p_update_appraisal Flag to indicate if appraisee can update appraisal.
345  * @param p_provide_overall_feedback Flag to indicate if appraisee can provide overall feedback on appraisal.
346  * @param p_appraisee_comments Stores appraisee overall feedback on appraisal.
347  * @param p_plan_id If not null stores the performance management plan identifier.
348  * @param p_offline_status  Indicates the offline status of the appraisal document.
349  * Valid values are defined by the APPRAISAL_OFFLINE_STATUS lookup type.
350  * @rep:displayname Update Appraisal
351  * @rep:category BUSINESS_ENTITY PER_APPRAISAL
352  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
353  * @rep:scope public
354  * @rep:lifecycle active
355  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
356 */
357 --
358 -- {End Of Comments}
359 --
360 procedure update_appraisal
361  (p_validate                     in boolean         default false,
362   p_effective_date               in date,
363   p_appraisal_id                 in number,
364   p_object_version_number        in out nocopy number,
365   p_appraiser_person_id          in number,
366   p_appraisal_date    		 in date             default hr_api.g_date,
367   p_appraisal_period_end_date    in date             default hr_api.g_date,
368   p_appraisal_period_start_date  in date             default hr_api.g_date,
369   p_type                         in varchar2         default hr_api.g_varchar2,
370   p_next_appraisal_date          in date             default hr_api.g_date,
371   p_status                       in varchar2         default hr_api.g_varchar2,
372   p_comments                     in varchar2         default hr_api.g_varchar2,
373   p_overall_performance_level_id in number           default hr_api.g_number,
374   p_open	                 in varchar2         default hr_api.g_varchar2,
375   p_attribute_category           in varchar2         default hr_api.g_varchar2,
376   p_attribute1                   in varchar2         default hr_api.g_varchar2,
377   p_attribute2                   in varchar2         default hr_api.g_varchar2,
378   p_attribute3                   in varchar2         default hr_api.g_varchar2,
379   p_attribute4                   in varchar2         default hr_api.g_varchar2,
380   p_attribute5                   in varchar2         default hr_api.g_varchar2,
381   p_attribute6                   in varchar2         default hr_api.g_varchar2,
382   p_attribute7                   in varchar2         default hr_api.g_varchar2,
383   p_attribute8                   in varchar2         default hr_api.g_varchar2,
384   p_attribute9                   in varchar2         default hr_api.g_varchar2,
385   p_attribute10                  in varchar2         default hr_api.g_varchar2,
386   p_attribute11                  in varchar2         default hr_api.g_varchar2,
387   p_attribute12                  in varchar2         default hr_api.g_varchar2,
388   p_attribute13                  in varchar2         default hr_api.g_varchar2,
389   p_attribute14                  in varchar2         default hr_api.g_varchar2,
390   p_attribute15                  in varchar2         default hr_api.g_varchar2,
391   p_attribute16                  in varchar2         default hr_api.g_varchar2,
392   p_attribute17                  in varchar2         default hr_api.g_varchar2,
393   p_attribute18                  in varchar2         default hr_api.g_varchar2,
394   p_attribute19                  in varchar2         default hr_api.g_varchar2,
395   p_attribute20                  in varchar2         default hr_api.g_varchar2,
396   p_system_type                  in varchar2         default hr_api.g_varchar2,
397   p_system_params                in varchar2         default hr_api.g_varchar2,
398   p_appraisee_access             in varchar2         default hr_api.g_varchar2,
399   p_main_appraiser_id            in number 	     default hr_api.g_number,
400   p_assignment_id                in number 	     default hr_api.g_number,
401   p_assignment_start_date        in date  	     default hr_api.g_date,
402   p_asg_business_group_id        in number	     default hr_api.g_number,
403   p_assignment_organization_id   in number	     default hr_api.g_number,
404   p_assignment_job_id            in number	     default hr_api.g_number,
405   p_assignment_position_id       in number	     default hr_api.g_number,
406   p_assignment_grade_id          in number	     default hr_api.g_number,
407   p_appraisal_system_status      in varchar2         default hr_api.g_varchar2,
408   p_potential_readiness_level    in varchar2         default hr_api.g_varchar2,
409   p_potential_short_term_workopp in varchar2         default hr_api.g_varchar2,
410   p_potential_long_term_workopp  in varchar2         default hr_api.g_varchar2,
411   p_potential_details            in varchar2         default hr_api.g_varchar2,
412   p_event_id                     in number           default hr_api.g_number,
413   p_show_competency_ratings      in varchar2         default hr_api.g_varchar2,
414   p_show_objective_ratings       in varchar2         default hr_api.g_varchar2,
415   p_show_questionnaire_info      in varchar2         default hr_api.g_varchar2,
416   p_show_participant_details     in varchar2         default hr_api.g_varchar2,
420   p_show_overall_comments        in varchar2         default hr_api.g_varchar2,
417   p_show_participant_ratings     in varchar2         default hr_api.g_varchar2,
418   p_show_participant_names       in varchar2         default hr_api.g_varchar2,
419   p_show_overall_ratings         in varchar2         default hr_api.g_varchar2,
421   p_update_appraisal             in varchar2         default hr_api.g_varchar2,
422   p_provide_overall_feedback     in varchar2         default hr_api.g_varchar2,
423   p_appraisee_comments           in varchar2         default hr_api.g_varchar2,
424   p_plan_id                      in number           default hr_api.g_number,
425   p_offline_status               in varchar2         default hr_api.g_varchar2,
426 p_retention_potential                in varchar2         default hr_api.g_varchar2,
427 p_show_participant_comments     in varchar2         default hr_api.g_varchar2  -- 8651478 bug fix
428   );
429 --
430 -- ----------------------------------------------------------------------------
431 -- |-----------------------------< delete_appraisal >-------------------------|
432 -- ----------------------------------------------------------------------------
433 --
434 -- {Start Of Comments}
435 /*#
436  * This API deletes an existing appraisal for a person. An appraisal
437  * holds the evaluation details of a person by others for a performance
438  * review and can include objective setting etc.
439  *
440  * <p><b>Licensing</b><br>
441  * This API is licensed for use with Human Resources.
442  *
443  * <p><b>Prerequisites</b><br>
444  * A valid appraisal must already exist.
445  *
446  * <p><b>Post Success</b><br>
447  * Appraisal is deleted.
448  *
449  * <p><b>Post Failure</b><br>
450  * Appraisal is not deleted and an error is raised.
451  * @param p_validate If true, then only validation will be performed and the
452  * database remains unchanged. If false, then all validation checks pass the
453  * database will be modified.
454  * @param p_appraisal_id Appraisal to be deleted. If p_validate is false,
455  * uniquely identifies the appraisal to be deleted. If p_validate is true, set
456  * to null.
457  * @param p_object_version_number Current version number of the appraisal to be
458  * deleted.
459  * @rep:displayname Delete Appraisal
460  * @rep:category BUSINESS_ENTITY PER_APPRAISAL
461  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
462  * @rep:scope public
463  * @rep:lifecycle active
464  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
465 */
466 --
467 -- {End Of Comments}
468 --
469 procedure delete_appraisal
470 (p_validate                           in boolean default false,
471  p_appraisal_id                       in number,
472  p_object_version_number              in number
473 );
474 --
475 end hr_appraisals_api;