1 Package hr_rating_levels_api AUTHID CURRENT_USER as
2 /* $Header: pertlapi.pkh 120.1 2005/11/28 03:22:49 dsaxby noship $ */
3 /*#
4 * This package contains rating level APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Rating Level
8 */
9 --
10 -- package varialbe
11 --
12 g_ignore_df varchar2(1) := 'N'; -- BUG3621261
13 --
14 -- ----------------------------------------------------------------------------
15 -- |------------------------< create_rating_level >---------------------------|
16 -- ----------------------------------------------------------------------------
17 --
18 -- {Start Of Comments}
19 /*#
20 * This API creates a rating level.
21 *
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Oracle Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * The competence or rating scale must exist.
28 *
29 * <p><b>Post Success</b><br>
30 * The rating level will have been created.
31 *
32 * <p><b>Post Failure</b><br>
33 * The rating level will not be created and an error will be raised.
34 *
35 * @param p_language_code Specifies to which language the translation values
36 * apply. You can set to the base or any installed language. The default value
37 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
38 * value.
39 * @param p_validate If true, then validation alone will be performed and the
40 * database will remain unchanged. If false and all validation checks pass,
41 * then the database will be modified.
42 * @param p_effective_date Reference date for validating lookup values are
43 * applicable during the start to end active date range. This date does not
44 * determine when the changes take effect.
45 * @param p_name {@rep:casecolumn PER_RATING_LEVELS.NAME}
46 * @param p_business_group_id {@rep:casecolumn
47 * PER_RATING_LEVELS.BUSINESS_GROUP_ID}
48 * @param p_step_value {@rep:casecolumn PER_RATING_LEVELS.STEP_VALUE}
49 * @param p_behavioural_indicator {@rep:casecolumn
50 * PER_RATING_LEVELS.BEHAVIOURAL_INDICATOR}
51 * @param p_rating_scale_id {@rep:casecolumn PER_RATING_LEVELS.RATING_SCALE_ID}
52 * @param p_competence_id {@rep:casecolumn PER_RATING_LEVELS.COMPETENCE_ID}
53 * @param p_attribute_category This context value determines which flexfield
54 * structure to use with the descriptive flexfield segments.
55 * @param p_attribute1 Descriptive flexfield segment.
56 * @param p_attribute2 Descriptive flexfield segment.
57 * @param p_attribute3 Descriptive flexfield segment.
58 * @param p_attribute4 Descriptive flexfield segment.
59 * @param p_attribute5 Descriptive flexfield segment.
60 * @param p_attribute6 Descriptive flexfield segment.
61 * @param p_attribute7 Descriptive flexfield segment.
62 * @param p_attribute8 Descriptive flexfield segment.
63 * @param p_attribute9 Descriptive flexfield segment.
64 * @param p_attribute10 Descriptive flexfield segment.
65 * @param p_attribute11 Descriptive flexfield segment.
66 * @param p_attribute12 Descriptive flexfield segment.
67 * @param p_attribute13 Descriptive flexfield segment.
68 * @param p_attribute14 Descriptive flexfield segment.
69 * @param p_attribute15 Descriptive flexfield segment.
70 * @param p_attribute16 Descriptive flexfield segment.
71 * @param p_attribute17 Descriptive flexfield segment.
72 * @param p_attribute18 Descriptive flexfield segment.
73 * @param p_attribute19 Descriptive flexfield segment.
74 * @param p_attribute20 Descriptive flexfield segment.
75 * @param p_rating_level_id If p_validate is false, uniquely identifies the
76 * rating level created. If p_validate is true, set to null.
77 * @param p_object_version_number If p_validate is false, then set to the
78 * version number of the created rating level. If p_validate is true, then the
79 * value will be null.
80 * @param p_obj_ver_number_cpn_or_rsc If p_validate is false, set to the
81 * version number of the competence or rating scale. If p_validate is true, set
82 * to null.
83 * @rep:displayname Create Rating Level
84 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
85 * @rep:lifecycle active
86 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
87 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
88 * @rep:scope public
89 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
90 */
91 --
92 -- {End Of Comments}
93 --
94 procedure create_rating_level
95 (p_language_code in varchar2 default hr_api.userenv_lang,
96 p_validate in boolean default false,
97 p_effective_date in date,
98 p_name in varchar2,
99 p_business_group_id in number default null,
100 p_step_value in number,
101 p_behavioural_indicator in varchar2 default null,
102 p_rating_scale_id in number default null,
103 p_competence_id in number default null,
104 p_attribute_category in varchar2 default null,
105 p_attribute1 in varchar2 default null,
106 p_attribute2 in varchar2 default null,
107 p_attribute3 in varchar2 default null,
108 p_attribute4 in varchar2 default null,
109 p_attribute5 in varchar2 default null,
110 p_attribute6 in varchar2 default null,
111 p_attribute7 in varchar2 default null,
112 p_attribute8 in varchar2 default null,
113 p_attribute9 in varchar2 default null,
114 p_attribute10 in varchar2 default null,
115 p_attribute11 in varchar2 default null,
116 p_attribute12 in varchar2 default null,
117 p_attribute13 in varchar2 default null,
118 p_attribute14 in varchar2 default null,
119 p_attribute15 in varchar2 default null,
120 p_attribute16 in varchar2 default null,
121 p_attribute17 in varchar2 default null,
122 p_attribute18 in varchar2 default null,
123 p_attribute19 in varchar2 default null,
124 p_attribute20 in varchar2 default null,
125 p_rating_level_id out nocopy number,
126 p_object_version_number out nocopy number,
127 p_obj_ver_number_cpn_or_rsc out nocopy number
128 );
129 --
130 -- ----------------------------------------------------------------------------
131 -- |------------------------< update_rating_level >--------------------------|
132 -- ----------------------------------------------------------------------------
133 --
134 -- {Start Of Comments}
135 /*#
136 * This API updates the rating level.
137 *
138 *
139 * <p><b>Licensing</b><br>
140 * This API is licensed for use with Oracle Human Resources.
141 *
142 * <p><b>Prerequisites</b><br>
143 * The rating level must exist.
144 *
145 * <p><b>Post Success</b><br>
146 * The rating level will have been updated.
147 *
148 * <p><b>Post Failure</b><br>
149 * The rating level will not be updated and an error will be raised.
150 *
151 * @param p_language_code Specifies to which language the translation values
152 * apply. You can set to the base or any installed language. The default value
153 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
154 * value.
155 * @param p_validate If true, then validation alone will be performed and the
156 * database will remain unchanged. If false and all validation checks pass,
157 * then the database will be modified.
158 * @param p_effective_date Reference date for validating lookup values are
159 * applicable during the start to end active date range. This date does not
160 * determine when the changes take effect.
161 * @param p_rating_level_id {@rep:casecolumn PER_RATING_LEVELS.RATING_LEVEL_ID}
162 * @param p_object_version_number Pass in the current version number of the
163 * rating level to be updated. When the API completes if p_validate is false,
164 * will be set to the new version number of the updated rating level. If
165 * p_validate is true will be set to the same value which was passed in.
166 * @param p_name {@rep:casecolumn PER_RATING_LEVELS.NAME}
167 * @param p_behavioural_indicator REF.PER_RATING_LEVELS.BEHAVIOURAL_INDICATOR
168 * @param p_attribute_category This context value determines which flexfield
169 * structure to use with the descriptive flexfield segments.
170 * @param p_attribute1 Descriptive flexfield segment.
171 * @param p_attribute2 Descriptive flexfield segment.
172 * @param p_attribute3 Descriptive flexfield segment.
173 * @param p_attribute4 Descriptive flexfield segment.
174 * @param p_attribute5 Descriptive flexfield segment.
175 * @param p_attribute6 Descriptive flexfield segment.
176 * @param p_attribute7 Descriptive flexfield segment.
177 * @param p_attribute8 Descriptive flexfield segment.
178 * @param p_attribute9 Descriptive flexfield segment.
179 * @param p_attribute10 Descriptive flexfield segment.
180 * @param p_attribute11 Descriptive flexfield segment.
181 * @param p_attribute12 Descriptive flexfield segment.
182 * @param p_attribute13 Descriptive flexfield segment.
183 * @param p_attribute14 Descriptive flexfield segment.
184 * @param p_attribute15 Descriptive flexfield segment.
185 * @param p_attribute16 Descriptive flexfield segment.
186 * @param p_attribute17 Descriptive flexfield segment.
187 * @param p_attribute18 Descriptive flexfield segment.
188 * @param p_attribute19 Descriptive flexfield segment.
189 * @param p_attribute20 Descriptive flexfield segment.
190 * @rep:displayname Update Rating Level
191 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
192 * @rep:lifecycle active
193 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
194 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
195 * @rep:scope public
196 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
197 */
198 --
199 -- {End Of Comments}
200 --
201 procedure update_rating_level
202 (
203 p_language_code in varchar2 default hr_api.userenv_lang,p_validate in boolean default false,
204 p_effective_date in date,
205 p_rating_level_id in number,
206 p_object_version_number in out nocopy number,
207 p_name in varchar2 default hr_api.g_varchar2,
208 p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
209 p_attribute_category in varchar2 default hr_api.g_varchar2,
210 p_attribute1 in varchar2 default hr_api.g_varchar2,
211 p_attribute2 in varchar2 default hr_api.g_varchar2,
212 p_attribute3 in varchar2 default hr_api.g_varchar2,
213 p_attribute4 in varchar2 default hr_api.g_varchar2,
214 p_attribute5 in varchar2 default hr_api.g_varchar2,
215 p_attribute6 in varchar2 default hr_api.g_varchar2,
216 p_attribute7 in varchar2 default hr_api.g_varchar2,
217 p_attribute8 in varchar2 default hr_api.g_varchar2,
218 p_attribute9 in varchar2 default hr_api.g_varchar2,
219 p_attribute10 in varchar2 default hr_api.g_varchar2,
220 p_attribute11 in varchar2 default hr_api.g_varchar2,
221 p_attribute12 in varchar2 default hr_api.g_varchar2,
222 p_attribute13 in varchar2 default hr_api.g_varchar2,
223 p_attribute14 in varchar2 default hr_api.g_varchar2,
224 p_attribute15 in varchar2 default hr_api.g_varchar2,
225 p_attribute16 in varchar2 default hr_api.g_varchar2,
226 p_attribute17 in varchar2 default hr_api.g_varchar2,
227 p_attribute18 in varchar2 default hr_api.g_varchar2,
228 p_attribute19 in varchar2 default hr_api.g_varchar2,
229 p_attribute20 in varchar2 default hr_api.g_varchar2
230 );
231 --
232 -- ----------------------------------------------------------------------------
233 -- |---------------------------< delete_rating_level >------------------------|
234 -- ----------------------------------------------------------------------------
235 --
236 -- {Start Of Comments}
237 /*#
238 * This API deletes the rating level.
239 *
240 *
241 * <p><b>Licensing</b><br>
242 * This API is licensed for use with Oracle Human Resources.
243 *
244 * <p><b>Prerequisites</b><br>
245 * The rating level must exist.
246 *
247 * <p><b>Post Success</b><br>
248 * The rating level will have been deleted.
249 *
250 * <p><b>Post Failure</b><br>
251 * The rating level will not be deleted and an error will be raised.
252 *
253 * @param p_validate If true, then validation alone will be performed and the
254 * database will remain unchanged. If false and all validation checks pass,
255 * then the database will be modified.
256 * @param p_rating_level_id {@rep:casecolumn PER_RATING_LEVELS.RATING_LEVEL_ID}
257 * @param p_object_version_number Current version number of the rating level to
258 * be deleted.
259 * @param p_obj_ver_number_cpn_or_rsc If p_validate is false, set to the
260 * version number of the competence or rating scale. If p_validate is true, set
261 * to null.
262 * @rep:displayname Delete Rating Level
263 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
264 * @rep:lifecycle active
265 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
266 * @rep:scope public
267 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
268 */
269 --
270 -- {End Of Comments}
271 --
272 procedure delete_rating_level
273 (p_validate in boolean default false,
274 p_rating_level_id in number,
275 p_object_version_number in number,
276 p_obj_ver_number_cpn_or_rsc out nocopy number
277 );
278 --
279 -- ----------------------------------------------------------------------------
280 -- |----------------------< create_or_update_rating_level >-------------------|
281 -- ----------------------------------------------------------------------------
282 --
283 -- {Start Of Comments}
284 /*#
285 * This API creates a rating level if the rating level does not exist or
286 * updates the rating level if the rating level already exists.
287 *
288 * This API is used for skills vendor integration.
289 *
290 * <p><b>Licensing</b><br>
291 * This API is licensed for use with Oracle Human Resources.
292 *
293 * <p><b>Prerequisites</b><br>
294 * The rating level must exist.
295 *
296 * <p><b>Post Success</b><br>
297 * The rating level will have been created or updated.
298 *
299 * <p><b>Post Failure</b><br>
300 * The rating level will not be created or updated and an error will be raised.
301 *
302 * @param p_language_code Specifies to which language the translation values
303 * apply. You can set to the base or any installed language. The default value
304 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
305 * value.
306 * @param p_validate If true, then validation alone will be performed and the
307 * database will remain unchanged. If false and all validation checks pass,
308 * then the database will be modified.
309 * @param p_effective_date Reference date for validating lookup values are
310 * applicable during the start to end active date range. This date does not
311 * determine when the changes take effect.
312 * @param p_name {@rep:casecolumn PER_RATING_LEVELS.NAME}
313 * @param p_step_value {@rep:casecolumn PER_RATING_LEVELS.STEP_VALUE}
314 * @param p_rating_scale_name Rating scale name
315 * @param p_behavioural_indicator {@rep:casecolumn
316 * PER_RATING_LEVELS.BEHAVIOURAL_INDICATOR}
317 * @param p_competence_name Competence name
318 * @param p_translated_language If the name parameter is translated, this is
319 * the language code for the name
320 * @param p_source_rating_level_name This is the name with the source language
321 * code
322 * @rep:displayname Create or Update Rating Level
323 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
324 * @rep:lifecycle active
325 * @rep:scope public
326 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
327 */
328 --
329 -- {End Of Comments}
330 --
331 procedure create_or_update_rating_level
332 (
333 p_language_code in varchar2 default hr_api.userenv_lang
334 ,p_validate in boolean default false
335 ,p_effective_date in date default trunc(sysdate)
336 ,p_name in varchar2 default null
337 ,p_step_value in number default 1
338 ,p_rating_scale_name in varchar2 default null
339 ,p_behavioural_indicator in varchar2 default null
340 ,p_competence_name in varchar2 default null
341 ,p_translated_language in varchar2 default null
342 ,p_source_rating_level_name in varchar2 default null
343 );
344 --
345 end hr_rating_levels_api;