[Home] [Help]
PACKAGE: APPS.CSF_SKILLS_PKG
Source
1 PACKAGE csf_skills_pkg AS
2 /* $Header: CSFPSKLS.pls 120.1 2006/03/01 01:59:01 ipananil noship $ */
3
4
5 PROCEDURE load_skill_type
6 ( p_skill_type_id in number
7 , p_rating_scale_id in number
8 , p_start_date_active in date
9 , p_end_date_active in date
10 , p_last_update_date in date
11 , p_seeded_flag in varchar2
12 , p_key_column in varchar2
13 , p_data_column in varchar2
14 , p_name_number_column in varchar2
15 , p_from_clause in varchar2
16 , p_where_clause in varchar2
17 , p_order_by_clause in varchar2
18 , p_object_version_number in number
19 , p_attribute1 in varchar2
20 , p_attribute2 in varchar2
21 , p_attribute3 in varchar2
22 , p_attribute4 in varchar2
23 , p_attribute5 in varchar2
24 , p_attribute6 in varchar2
25 , p_attribute7 in varchar2
26 , p_attribute8 in varchar2
27 , p_attribute9 in varchar2
28 , p_attribute10 in varchar2
29 , p_attribute11 in varchar2
30 , p_attribute12 in varchar2
31 , p_attribute13 in varchar2
32 , p_attribute14 in varchar2
33 , p_attribute15 in varchar2
34 , p_attribute_category in varchar2
35 , p_name in varchar2
36 , p_description in varchar2 );
37
38 PROCEDURE create_skill_type
39 ( x_rowid in out nocopy varchar2
40 , x_skill_type_id in out nocopy number
41 , x_rating_scale_id in number
42 , x_start_date_active in date
43 , x_end_date_active in date
44 , x_seeded_flag in varchar2 default null
45 , x_key_column in varchar2 default null
46 , x_data_column in varchar2 default null
47 , x_name_number_column in varchar2 default null
48 , x_from_clause in varchar2 default null
49 , x_where_clause in varchar2 default null
50 , x_order_by_clause in varchar2 default null
51 , x_object_version_number in out nocopy number
52 , x_attribute1 in varchar2 default null
53 , x_attribute2 in varchar2 default null
54 , x_attribute3 in varchar2 default null
55 , x_attribute4 in varchar2 default null
56 , x_attribute5 in varchar2 default null
57 , x_attribute6 in varchar2 default null
58 , x_attribute7 in varchar2 default null
59 , x_attribute8 in varchar2 default null
60 , x_attribute9 in varchar2 default null
61 , x_attribute10 in varchar2 default null
62 , x_attribute11 in varchar2 default null
63 , x_attribute12 in varchar2 default null
64 , x_attribute13 in varchar2 default null
65 , x_attribute14 in varchar2 default null
66 , x_attribute15 in varchar2 default null
67 , x_attribute_category in varchar2 default null
68 , x_name in varchar2
69 , x_description in varchar2 );
70
71 PROCEDURE lock_skill_type
72 ( x_skill_type_id in number
73 , x_object_version_number in number
74 , x_name in varchar2
75 , x_description in varchar2 );
76
77 PROCEDURE update_skill_type
78 ( x_skill_type_id in number
79 , x_object_version_number in out nocopy number
80 , x_rating_scale_id in number
81 , x_start_date_active in date
82 , x_end_date_active in date
83 , x_seeded_flag in varchar2 default null
84 , x_attribute1 in varchar2 default null
85 , x_attribute2 in varchar2 default null
86 , x_attribute3 in varchar2 default null
87 , x_attribute4 in varchar2 default null
88 , x_attribute5 in varchar2 default null
89 , x_attribute6 in varchar2 default null
90 , x_attribute7 in varchar2 default null
91 , x_attribute8 in varchar2 default null
92 , x_attribute9 in varchar2 default null
93 , x_attribute10 in varchar2 default null
94 , x_attribute11 in varchar2 default null
95 , x_attribute12 in varchar2 default null
96 , x_attribute13 in varchar2 default null
97 , x_attribute14 in varchar2 default null
98 , x_attribute15 in varchar2 default null
99 , x_attribute_category in varchar2 default null
100 , x_name in varchar2
101 , x_description in varchar2 );
102
103 PROCEDURE delete_skill_type ( x_skill_type_id in number );
104
105 PROCEDURE add_skill_type_language;
106
107 PROCEDURE create_skill
108 ( x_rowid in out nocopy varchar2
109 , x_skill_id in out nocopy number
110 , x_skill_type_id in number
111 , x_skill_alias in varchar2
112 , x_start_date_active in date
113 , x_end_date_active in date
114 , x_seeded_flag in varchar2 default null
115 , x_object_version_number in out nocopy number
116 , x_attribute1 in varchar2 default null
117 , x_attribute2 in varchar2 default null
118 , x_attribute3 in varchar2 default null
119 , x_attribute4 in varchar2 default null
120 , x_attribute5 in varchar2 default null
121 , x_attribute6 in varchar2 default null
122 , x_attribute7 in varchar2 default null
123 , x_attribute8 in varchar2 default null
124 , x_attribute9 in varchar2 default null
125 , x_attribute10 in varchar2 default null
126 , x_attribute11 in varchar2 default null
127 , x_attribute12 in varchar2 default null
128 , x_attribute13 in varchar2 default null
129 , x_attribute14 in varchar2 default null
130 , x_attribute15 in varchar2 default null
131 , x_attribute_category in varchar2 default null
132 , x_name in varchar2
133 , x_description in varchar2 );
134
135 PROCEDURE lock_skill
136 ( x_skill_id in number
137 , x_object_version_number in number
138 , x_name in varchar2
139 , x_description in varchar2 );
140
141 PROCEDURE update_skill
142 ( x_skill_id in number
143 , x_object_version_number in out nocopy number
144 , x_skill_type_id in number
145 , x_skill_alias in varchar2
146 , x_start_date_active in date
147 , x_end_date_active in date
148 , x_attribute1 in varchar2 default null
149 , x_attribute2 in varchar2 default null
150 , x_attribute3 in varchar2 default null
151 , x_attribute4 in varchar2 default null
152 , x_attribute5 in varchar2 default null
153 , x_attribute6 in varchar2 default null
154 , x_attribute7 in varchar2 default null
155 , x_attribute8 in varchar2 default null
156 , x_attribute9 in varchar2 default null
157 , x_attribute10 in varchar2 default null
158 , x_attribute11 in varchar2 default null
159 , x_attribute12 in varchar2 default null
160 , x_attribute13 in varchar2 default null
161 , x_attribute14 in varchar2 default null
162 , x_attribute15 in varchar2 default null
163 , x_attribute_category in varchar2 default null
164 , x_name in varchar2
165 , x_description in varchar2 );
166
167 PROCEDURE delete_skill ( x_skill_id in number );
168
169 PROCEDURE add_skill_language;
170
171 PROCEDURE create_rating_scale
172 ( x_rowid in out nocopy varchar2
173 , x_rating_scale_id in out nocopy number
174 , x_start_date_active in date
175 , x_end_date_active in date
176 , x_seeded_flag in varchar2 default null
177 , x_object_version_number in out nocopy number
178 , x_attribute1 in varchar2 default null
179 , x_attribute2 in varchar2 default null
180 , x_attribute3 in varchar2 default null
181 , x_attribute4 in varchar2 default null
182 , x_attribute5 in varchar2 default null
183 , x_attribute6 in varchar2 default null
184 , x_attribute7 in varchar2 default null
185 , x_attribute8 in varchar2 default null
186 , x_attribute9 in varchar2 default null
187 , x_attribute10 in varchar2 default null
188 , x_attribute11 in varchar2 default null
189 , x_attribute12 in varchar2 default null
190 , x_attribute13 in varchar2 default null
191 , x_attribute14 in varchar2 default null
192 , x_attribute15 in varchar2 default null
193 , x_attribute_category in varchar2 default null
194 , x_name in varchar2
195 , x_description in varchar2 );
196
197 PROCEDURE lock_rating_scale
198 ( x_rating_scale_id in number
199 , x_object_version_number in number
200 , x_name in varchar2
201 , x_description in varchar2 );
202
203 PROCEDURE update_rating_scale
204 ( x_rating_scale_id in number
205 , x_object_version_number in out nocopy number
206 , x_start_date_active in date
207 , x_end_date_active in date
208 , x_seeded_flag in varchar2 default null
209 , x_attribute1 in varchar2 default null
210 , x_attribute2 in varchar2 default null
211 , x_attribute3 in varchar2 default null
212 , x_attribute4 in varchar2 default null
213 , x_attribute5 in varchar2 default null
214 , x_attribute6 in varchar2 default null
215 , x_attribute7 in varchar2 default null
216 , x_attribute8 in varchar2 default null
217 , x_attribute9 in varchar2 default null
218 , x_attribute10 in varchar2 default null
219 , x_attribute11 in varchar2 default null
220 , x_attribute12 in varchar2 default null
221 , x_attribute13 in varchar2 default null
222 , x_attribute14 in varchar2 default null
223 , x_attribute15 in varchar2 default null
224 , x_attribute_category in varchar2 default null
225 , x_name in varchar2
226 , x_description in varchar2 );
227
228 PROCEDURE delete_rating_scale ( x_rating_scale_id in number );
229
230 PROCEDURE add_rating_scale_language;
231
232 PROCEDURE create_skill_level
233 ( x_rowid in out nocopy varchar2
234 , x_skill_level_id in out nocopy number
235 , x_rating_scale_id in number
236 , x_step_value in number
237 , x_correction_factor in number
238 , x_start_date_active in date
239 , x_end_date_active in date
240 , x_seeded_flag in varchar2 default null
241 , x_object_version_number in out nocopy number
242 , x_attribute1 in varchar2 default null
243 , x_attribute2 in varchar2 default null
244 , x_attribute3 in varchar2 default null
245 , x_attribute4 in varchar2 default null
246 , x_attribute5 in varchar2 default null
247 , x_attribute6 in varchar2 default null
248 , x_attribute7 in varchar2 default null
249 , x_attribute8 in varchar2 default null
250 , x_attribute9 in varchar2 default null
251 , x_attribute10 in varchar2 default null
252 , x_attribute11 in varchar2 default null
253 , x_attribute12 in varchar2 default null
254 , x_attribute13 in varchar2 default null
255 , x_attribute14 in varchar2 default null
256 , x_attribute15 in varchar2 default null
257 , x_attribute_category in varchar2 default null
258 , x_name in varchar2
259 , x_description in varchar2 );
260
261 PROCEDURE lock_skill_level
262 ( x_skill_level_id in number
263 , x_object_version_number in number
264 , x_name in varchar2
265 , x_description in varchar2 );
266
267 PROCEDURE update_skill_level
268 ( x_skill_level_id in number
269 , x_object_version_number in out nocopy number
270 , x_rating_scale_id in number
271 , x_step_value in number
272 , x_correction_factor in number
273 , x_start_date_active in date
274 , x_end_date_active in date
275 , x_seeded_flag in varchar2 default null
276 , x_attribute1 in varchar2 default null
277 , x_attribute2 in varchar2 default null
278 , x_attribute3 in varchar2 default null
279 , x_attribute4 in varchar2 default null
280 , x_attribute5 in varchar2 default null
281 , x_attribute6 in varchar2 default null
282 , x_attribute7 in varchar2 default null
283 , x_attribute8 in varchar2 default null
284 , x_attribute9 in varchar2 default null
285 , x_attribute10 in varchar2 default null
286 , x_attribute11 in varchar2 default null
287 , x_attribute12 in varchar2 default null
288 , x_attribute13 in varchar2 default null
289 , x_attribute14 in varchar2 default null
290 , x_attribute15 in varchar2 default null
291 , x_attribute_category in varchar2 default null
292 , x_name in varchar2
293 , x_description in varchar2 );
294
295 PROCEDURE delete_skill_level ( x_skill_level_id in number );
296
297 PROCEDURE add_skill_level_language;
298
299 PROCEDURE create_resource_skill
300 ( x_rowid in out nocopy varchar2
301 , x_resource_skill_id in out nocopy number
302 , x_skill_type_id in number
303 , x_skill_id in number
304 , x_resource_type in varchar2
305 , x_resource_id in number
306 , x_skill_level_id in number
307 , x_start_date_active in date
308 , x_end_date_active in date
309 , x_object_version_number in out nocopy number
310 , x_attribute1 in varchar2 default null
311 , x_attribute2 in varchar2 default null
312 , x_attribute3 in varchar2 default null
313 , x_attribute4 in varchar2 default null
314 , x_attribute5 in varchar2 default null
315 , x_attribute6 in varchar2 default null
316 , x_attribute7 in varchar2 default null
317 , x_attribute8 in varchar2 default null
318 , x_attribute9 in varchar2 default null
319 , x_attribute10 in varchar2 default null
320 , x_attribute11 in varchar2 default null
321 , x_attribute12 in varchar2 default null
322 , x_attribute13 in varchar2 default null
323 , x_attribute14 in varchar2 default null
324 , x_attribute15 in varchar2 default null
325 , x_attribute_category in varchar2 default null );
326
327 PROCEDURE lock_resource_skill
328 ( x_resource_skill_id in number
329 , x_object_version_number in number );
330
331 PROCEDURE update_resource_skill
332 ( x_resource_skill_id in number
333 , x_object_version_number in out nocopy number
334 , x_skill_type_id in number
335 , x_skill_id in number
336 , x_resource_type in varchar2
337 , x_resource_id in number
338 , x_skill_level_id in number
339 , x_start_date_active in date
340 , x_end_date_active in date
341 , x_attribute1 in varchar2 default null
342 , x_attribute2 in varchar2 default null
343 , x_attribute3 in varchar2 default null
344 , x_attribute4 in varchar2 default null
345 , x_attribute5 in varchar2 default null
346 , x_attribute6 in varchar2 default null
347 , x_attribute7 in varchar2 default null
348 , x_attribute8 in varchar2 default null
349 , x_attribute9 in varchar2 default null
350 , x_attribute10 in varchar2 default null
351 , x_attribute11 in varchar2 default null
352 , x_attribute12 in varchar2 default null
353 , x_attribute13 in varchar2 default null
354 , x_attribute14 in varchar2 default null
355 , x_attribute15 in varchar2 default null
356 , x_attribute_category in varchar2 default null );
357
358 PROCEDURE delete_resource_skill ( x_resource_skill_id in number );
359
363 , x_skill_type_id in number
360 PROCEDURE create_required_skill
361 ( x_rowid in out nocopy varchar2
362 , x_required_skill_id in out nocopy number
364 , x_skill_id in number
365 , x_has_skill_type in varchar2
366 , x_has_skill_id in number
367 , x_skill_level_id in number
368 , x_skill_required_flag in varchar2
369 , x_level_required_flag in varchar2
370 , x_disabled_flag in varchar2
371 , x_start_date_active in date
372 , x_end_date_active in date
373 , x_object_version_number in out nocopy number
374 , x_attribute1 in varchar2 default null
375 , x_attribute2 in varchar2 default null
376 , x_attribute3 in varchar2 default null
377 , x_attribute4 in varchar2 default null
378 , x_attribute5 in varchar2 default null
379 , x_attribute6 in varchar2 default null
380 , x_attribute7 in varchar2 default null
381 , x_attribute8 in varchar2 default null
382 , x_attribute9 in varchar2 default null
383 , x_attribute10 in varchar2 default null
384 , x_attribute11 in varchar2 default null
385 , x_attribute12 in varchar2 default null
386 , x_attribute13 in varchar2 default null
387 , x_attribute14 in varchar2 default null
388 , x_attribute15 in varchar2 default null
389 , x_attribute_category in varchar2 default null );
390
391 PROCEDURE lock_required_skill
392 ( x_required_skill_id in number
393 , x_object_version_number in number );
394
395 PROCEDURE update_required_skill
396 ( x_required_skill_id in number
397 , x_object_version_number in out nocopy number
398 , x_skill_type_id in number
399 , x_skill_id in number
400 , x_has_skill_type in varchar2
401 , x_has_skill_id in number
402 , x_skill_level_id in number
403 , x_skill_required_flag in varchar2
404 , x_level_required_flag in varchar2
405 , x_disabled_flag in varchar2
406 , x_start_date_active in date
407 , x_end_date_active in date
408 , x_attribute1 in varchar2 default null
409 , x_attribute2 in varchar2 default null
410 , x_attribute3 in varchar2 default null
411 , x_attribute4 in varchar2 default null
412 , x_attribute5 in varchar2 default null
413 , x_attribute6 in varchar2 default null
414 , x_attribute7 in varchar2 default null
415 , x_attribute8 in varchar2 default null
416 , x_attribute9 in varchar2 default null
417 , x_attribute10 in varchar2 default null
418 , x_attribute11 in varchar2 default null
419 , x_attribute12 in varchar2 default null
420 , x_attribute13 in varchar2 default null
421 , x_attribute14 in varchar2 default null
422 , x_attribute15 in varchar2 default null
423 , x_attribute_category in varchar2 default null );
424
425 PROCEDURE delete_required_skill ( x_required_skill_id in number );
426
427 --==============================================================
428 -- PUBLIC Procedures for translation
429 --==============================================================
430 PROCEDURE translate_rating_scale
431 ( p_rating_scale_id in varchar2
432 , p_owner in varchar2
433 , p_name in varchar2
434 , p_description in varchar2) ;
435 PROCEDURE translate_skill
436 ( p_skill_id in varchar2
437 , p_owner in varchar2
438 , p_name in varchar2
439 , p_description in varchar2) ;
440 PROCEDURE translate_skill_level
441 ( p_skill_level_id in varchar2
442 , p_owner in varchar2
443 , p_name in varchar2
444 , p_description in varchar2) ;
445 PROCEDURE translate_skill_type
446 ( p_skill_type_id in varchar2
447 , p_owner in varchar2
448 , p_name in varchar2
449 , p_description in varchar2) ;
450
451
452 END csf_skills_pkg;