1 Package hr_performance_ratings_api AUTHID CURRENT_USER as
2 /* $Header: peprtapi.pkh 120.2 2006/02/13 14:12:27 vbala noship $ */
3 /*#
4 * This package contains performance ratings APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Performance Rating
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_performance_rating >---------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates performance rating.
17 *
18 * A performance rating is a single evaluation of an objective within an
19 * appraisal.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * An objective and an appraisal must exist.
26 *
27 * <p><b>Post Success</b><br>
28 * Performance rating is created.
29 *
30 * <p><b>Post Failure</b><br>
31 * Performance rating is not created and an error is raised.
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_effective_date Reference date for validating lookup values are
36 * applicable during the start to end active date range. This date does not
37 * determine when the changes take effect.
38 * @param p_appraisal_id Identifies the appraisal record.
39 * @param p_person_id Identifies the person record.
40 * @param p_objective_id Identifies the objective.
41 * @param p_performance_level_id Identifier of the performance rating level.
42 * @param p_comments Comment text.
43 * @param p_attribute_category This context value determines which flexfield
44 * structure to use with the descriptive flexfield segments.
45 * @param p_attribute1 Descriptive flexfield segment.
46 * @param p_attribute2 Descriptive flexfield segment.
47 * @param p_attribute3 Descriptive flexfield segment.
48 * @param p_attribute4 Descriptive flexfield segment.
49 * @param p_attribute5 Descriptive flexfield segment.
50 * @param p_attribute6 Descriptive flexfield segment.
51 * @param p_attribute7 Descriptive flexfield segment.
52 * @param p_attribute8 Descriptive flexfield segment.
53 * @param p_attribute9 Descriptive flexfield segment.
54 * @param p_attribute10 Descriptive flexfield segment.
55 * @param p_attribute11 Descriptive flexfield segment.
56 * @param p_attribute12 Descriptive flexfield segment.
57 * @param p_attribute13 Descriptive flexfield segment.
58 * @param p_attribute14 Descriptive flexfield segment.
59 * @param p_attribute15 Descriptive flexfield segment.
60 * @param p_attribute16 Descriptive flexfield segment.
61 * @param p_attribute17 Descriptive flexfield segment.
62 * @param p_attribute18 Descriptive flexfield segment.
63 * @param p_attribute19 Descriptive flexfield segment.
64 * @param p_attribute20 Descriptive flexfield segment.
65 * @param p_performance_rating_id If p_validate is false, this uniquely
66 * @param p_appr_line_score The score related to an appraisal objective assessment.
67 * identifies the performance rating created. If p_validate is true, set to
68 * null.
69 * @param p_object_version_number If p_validate is false, then set to the
70 * version number of the created performance rating. If p_validate is true,
71 * then the value will be null.
72 * @rep:displayname Create Performance Rating
73 * @rep:category BUSINESS_ENTITY PER_PERFORMANCE_REVIEW
74 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
78 */
75 * @rep:scope public
76 * @rep:lifecycle active
77 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
79 --
80 -- {End Of Comments}
81 --
82 procedure create_performance_rating
83 (p_validate in boolean default false
84 ,p_effective_date in date
85 ,p_appraisal_id in number
86 ,p_person_id in number default null
87 ,p_objective_id in number
88 ,p_performance_level_id in number default null
89 ,p_comments in varchar2 default null
90 ,p_attribute_category in varchar2 default null
91 ,p_attribute1 in varchar2 default null
92 ,p_attribute2 in varchar2 default null
93 ,p_attribute3 in varchar2 default null
94 ,p_attribute4 in varchar2 default null
95 ,p_attribute5 in varchar2 default null
96 ,p_attribute6 in varchar2 default null
97 ,p_attribute7 in varchar2 default null
98 ,p_attribute8 in varchar2 default null
99 ,p_attribute9 in varchar2 default null
100 ,p_attribute10 in varchar2 default null
101 ,p_attribute11 in varchar2 default null
102 ,p_attribute12 in varchar2 default null
103 ,p_attribute13 in varchar2 default null
104 ,p_attribute14 in varchar2 default null
105 ,p_attribute15 in varchar2 default null
106 ,p_attribute16 in varchar2 default null
107 ,p_attribute17 in varchar2 default null
108 ,p_attribute18 in varchar2 default null
109 ,p_attribute19 in varchar2 default null
110 ,p_attribute20 in varchar2 default null
111 ,p_performance_rating_id out nocopy number
112 ,p_object_version_number out nocopy number
113 ,p_appr_line_score in number default null
114 );
115 --
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< update_performance_rating >---------------------|
118 -- ----------------------------------------------------------------------------
119 --
120 -- {Start Of Comments}
121 /*#
122 * This API updates the performance rating.
123 *
124 * A performance rating is a single evaluation of an objective within an
125 * appraisal.
126 *
127 * <p><b>Licensing</b><br>
128 * This API is licensed for use with Human Resources.
129 *
130 * <p><b>Prerequisites</b><br>
131 * A valid performance rating must exist.
132 *
133 * <p><b>Post Success</b><br>
134 * The performance rating is updated.
135 *
136 * <p><b>Post Failure</b><br>
137 * Performance rating is not updated and an error is raised.
138 * @param p_validate If true, then validation alone will be performed and the
139 * database will remain unchanged. If false and all validation checks pass,
140 * then the database will be modified.
141 * @param p_effective_date Reference date for validating lookup values are
142 * applicable during the start to end active date range. This date does not
143 * determine when the changes take effect.
144 * @param p_performance_rating_id Identifies the performance rating to be
145 * updated.
146 * @param p_person_id Identifies the person record.
147 * @param p_object_version_number Pass in the current version number of the
148 * performance rating to be updated. When the API completes if p_validate is
149 * false, will be set to the new version number of the updated performance
150 * rating. If p_validate is true will be set to the same value which was passed
151 * in.
152 * @param p_appraisal_id Identifies the appraisal record.
153 * @param p_objective_id Identifies the objective.
154 * @param p_performance_level_id Identifier of the performance rating level.
155 * @param p_comments Comment text.
156 * @param p_attribute_category This context value determines which flexfield
157 * structure to use with the descriptive flexfield segments.
158 * @param p_attribute1 Descriptive flexfield segment.
159 * @param p_attribute2 Descriptive flexfield segment.
160 * @param p_attribute3 Descriptive flexfield segment.
161 * @param p_attribute4 Descriptive flexfield segment.
162 * @param p_attribute5 Descriptive flexfield segment.
163 * @param p_attribute6 Descriptive flexfield segment.
164 * @param p_attribute7 Descriptive flexfield segment.
165 * @param p_attribute8 Descriptive flexfield segment.
166 * @param p_attribute9 Descriptive flexfield segment.
167 * @param p_attribute10 Descriptive flexfield segment.
168 * @param p_attribute11 Descriptive flexfield segment.
169 * @param p_attribute12 Descriptive flexfield segment.
170 * @param p_attribute13 Descriptive flexfield segment.
171 * @param p_attribute14 Descriptive flexfield segment.
172 * @param p_attribute15 Descriptive flexfield segment.
173 * @param p_attribute16 Descriptive flexfield segment.
174 * @param p_attribute17 Descriptive flexfield segment.
175 * @param p_attribute18 Descriptive flexfield segment.
176 * @param p_attribute19 Descriptive flexfield segment.
177 * @param p_attribute20 Descriptive flexfield segment.
178 * @param p_appr_line_score The score related to an appraisal objective assessment.
179 * @rep:displayname Update Performance Rating
180 * @rep:category BUSINESS_ENTITY PER_PERFORMANCE_REVIEW
181 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
182 * @rep:scope public
183 * @rep:lifecycle active
184 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
185 */
186 --
187 -- {End Of Comments}
188 --
189 procedure update_performance_rating
190 (p_validate in boolean default false
191 ,p_effective_date in date
192 ,p_performance_rating_id in number
193 ,p_person_id in number default null
194 ,p_object_version_number in out nocopy number
195 ,p_appraisal_id in number default hr_api.g_number
196 ,p_objective_id in number default hr_api.g_number
197 ,p_performance_level_id in number default hr_api.g_number
198 ,p_comments in varchar2 default hr_api.g_varchar2
199 ,p_attribute_category in varchar2 default hr_api.g_varchar2
200 ,p_attribute1 in varchar2 default hr_api.g_varchar2
201 ,p_attribute2 in varchar2 default hr_api.g_varchar2
202 ,p_attribute3 in varchar2 default hr_api.g_varchar2
203 ,p_attribute4 in varchar2 default hr_api.g_varchar2
204 ,p_attribute5 in varchar2 default hr_api.g_varchar2
205 ,p_attribute6 in varchar2 default hr_api.g_varchar2
206 ,p_attribute7 in varchar2 default hr_api.g_varchar2
207 ,p_attribute8 in varchar2 default hr_api.g_varchar2
208 ,p_attribute9 in varchar2 default hr_api.g_varchar2
209 ,p_attribute10 in varchar2 default hr_api.g_varchar2
210 ,p_attribute11 in varchar2 default hr_api.g_varchar2
211 ,p_attribute12 in varchar2 default hr_api.g_varchar2
212 ,p_attribute13 in varchar2 default hr_api.g_varchar2
213 ,p_attribute14 in varchar2 default hr_api.g_varchar2
214 ,p_attribute15 in varchar2 default hr_api.g_varchar2
215 ,p_attribute16 in varchar2 default hr_api.g_varchar2
216 ,p_attribute17 in varchar2 default hr_api.g_varchar2
217 ,p_attribute18 in varchar2 default hr_api.g_varchar2
218 ,p_attribute19 in varchar2 default hr_api.g_varchar2
219 ,p_attribute20 in varchar2 default hr_api.g_varchar2
220 ,p_appr_line_score in number default hr_api.g_number
221 );
222 --
223 -- ----------------------------------------------------------------------------
224 -- |------------------------< delete_performance_rating >---------------------|
225 -- ----------------------------------------------------------------------------
226 --
227 -- {Start Of Comments}
228 /*#
229 * This API deletes performance rating.
230 *
231 * A performance rating is a single evaluation of an objective within an
232 * appraisal.
233 *
234 * <p><b>Licensing</b><br>
235 * This API is licensed for use with Human Resources.
236 *
237 * <p><b>Prerequisites</b><br>
238 * A valid performance rating must exist.
239 *
240 * <p><b>Post Success</b><br>
241 * Performance rating is deleted.
242 *
243 * <p><b>Post Failure</b><br>
244 * Performance rating is not deleted and an error is raised.
245 * @param p_validate If true, then validation alone will be performed and the
246 * database will remain unchanged. If false and all validation checks pass,
247 * then the database will be modified.
248 * @param p_performance_rating_id Identifies the performance rating to be
249 * deleted.
250 * @param p_object_version_number Current version number of the performance
251 * rating to be deleted.
252 * @rep:displayname Delete Performance Rating
253 * @rep:category BUSINESS_ENTITY PER_PERFORMANCE_REVIEW
254 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
255 * @rep:scope public
256 * @rep:lifecycle active
257 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
258 */
259 --
260 -- {End Of Comments}
261 --
262 procedure delete_performance_rating
263 (p_validate in boolean default false
264 ,p_performance_rating_id in number
265 ,p_object_version_number in number
266 );
267 end hr_performance_ratings_api;