1 Package hr_competence_element_swi As
2 /* $Header: hrcelswi.pkh 120.3.12010000.1 2008/07/28 03:07:26 appldev ship $ */
3
4 g_session_id number;
5 g_competence_element_id number;
6
7 -- ----------------------------------------------------------------------------
8 -- |---------------------------< copy_competencies >--------------------------|
9 -- ----------------------------------------------------------------------------
10 -- {Start of comments}
11 --
12 -- Description:
13 -- This procedure is the self-service wrapper procedure to the following
14 -- API: hr_competence_element_api.copy_competencies
15 --
16 -- Pre-requisites
17 -- All 'IN' parameters to this procedure have been appropriately derived.
18 --
19 -- Post Success:
20 -- p_return_status will return value indicating success.
21 --
22 -- Post Failure:
23 -- p_return_status will return value indication failure.
24 --
25 -- Access Status:
26 -- Internal Development use only.
27 --
28 -- {End of comments}
29 -- ----------------------------------------------------------------------------
30 PROCEDURE copy_competencies
31 (p_activity_version_from in number
32 ,p_activity_version_to in number
33 ,p_competence_type in varchar2 default hr_api.g_varchar2
34 ,p_validate in number default hr_api.g_false_num
35 ,p_return_status out nocopy varchar2
36 );
37 -- ----------------------------------------------------------------------------
38 -- |-----------------------< create_competence_element >----------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start of comments}
41 --
42 -- Description:
43 -- This procedure is the self-service wrapper procedure to the following
44 -- API: hr_competence_element_api.create_competence_element
45 --
46 -- Pre-requisites
47 -- All 'IN' parameters to this procedure have been appropriately derived.
48 --
49 -- Post Success:
50 -- p_return_status will return value indicating success.
51 --
52 -- Post Failure:
53 -- p_return_status will return value indication failure.
54 --
55 -- Access Status:
56 -- Internal Development use only.
57 --
58 -- {End of comments}
59 -- ----------------------------------------------------------------------------
60 PROCEDURE create_competence_element
61 (p_validate in number default hr_api.g_false_num
62 ,p_competence_element_id in number
63 ,p_object_version_number out nocopy number
64 ,p_type in varchar2
65 ,p_business_group_id in number default null
66 ,p_enterprise_id in number default null
67 ,p_competence_id in number default null
68 ,p_proficiency_level_id in number default null
69 ,p_high_proficiency_level_id in number default null
70 ,p_weighting_level_id in number default null
71 ,p_rating_level_id in number default null
72 ,p_person_id in number default null
73 ,p_job_id in number default null
74 ,p_valid_grade_id in number default null
75 ,p_position_id in number default null
76 ,p_organization_id in number default null
77 ,p_parent_competence_element_id in number default null
78 ,p_activity_version_id in number default null
79 ,p_assessment_id in number default null
80 ,p_assessment_type_id in number default null
81 ,p_mandatory in varchar2 default null
82 ,p_effective_date_from in date default null
83 ,p_effective_date_to in date default null
84 ,p_group_competence_type in varchar2 default null
85 ,p_competence_type in varchar2 default null
86 ,p_normal_elapse_duration in number default null
87 ,p_normal_elapse_duration_unit in varchar2 default null
88 ,p_sequence_number in number default null
89 ,p_source_of_proficiency_level in varchar2 default null
90 ,p_line_score in number default null
91 ,p_certification_date in date default null
92 ,p_certification_method in varchar2 default null
93 ,p_next_certification_date in date default null
94 ,p_comments in varchar2 default null
95 ,p_attribute_category in varchar2 default null
96 ,p_attribute1 in varchar2 default null
97 ,p_attribute2 in varchar2 default null
98 ,p_attribute3 in varchar2 default null
99 ,p_attribute4 in varchar2 default null
100 ,p_attribute5 in varchar2 default null
101 ,p_attribute6 in varchar2 default null
102 ,p_attribute7 in varchar2 default null
103 ,p_attribute8 in varchar2 default null
104 ,p_attribute9 in varchar2 default null
105 ,p_attribute10 in varchar2 default null
106 ,p_attribute11 in varchar2 default null
107 ,p_attribute12 in varchar2 default null
108 ,p_attribute13 in varchar2 default null
109 ,p_attribute14 in varchar2 default null
110 ,p_attribute15 in varchar2 default null
111 ,p_attribute16 in varchar2 default null
112 ,p_attribute17 in varchar2 default null
113 ,p_attribute18 in varchar2 default null
114 ,p_attribute19 in varchar2 default null
115 ,p_attribute20 in varchar2 default null
116 ,p_effective_date in date
117 ,p_object_id in number default null
118 ,p_object_name in varchar2 default null
119 ,p_party_id in number default null
120 ,p_return_status out nocopy varchar2
121 ,p_appr_line_score in number default null
122 ,p_status in varchar2 default null
123 );
124 -- ----------------------------------------------------------------------------
125 -- |-----------------------< delete_competence_element >----------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start of comments}
128 --
129 -- Description:
130 -- This procedure is the self-service wrapper procedure to the following
131 -- API: hr_competence_element_api.delete_competence_element
132 --
133 -- Pre-requisites
134 -- All 'IN' parameters to this procedure have been appropriately derived.
135 --
136 -- Post Success:
137 -- p_return_status will return value indicating success.
138 --
139 -- Post Failure:
140 -- p_return_status will return value indication failure.
141 --
142 -- Access Status:
143 -- Internal Development use only.
144 --
145 -- {End of comments}
146 -- ----------------------------------------------------------------------------
147 PROCEDURE delete_competence_element
148 (p_validate in number default hr_api.g_false_num
149 ,p_competence_element_id in number
150 ,p_object_version_number in number
151 ,p_return_status out nocopy varchar2
152 );
153 -- ----------------------------------------------------------------------------
154 -- |---------------------< maintain_student_comp_element >--------------------|
155 -- ----------------------------------------------------------------------------
156 -- {Start of comments}
157 --
158 -- Description:
159 -- This procedure is the self-service wrapper procedure to the following
160 -- API: hr_competence_element_api.maintain_student_comp_element
161 --
162 -- Pre-requisites
163 -- All 'IN' parameters to this procedure have been appropriately derived.
164 --
165 -- Post Success:
166 -- p_return_status will return value indicating success.
167 --
168 -- Post Failure:
169 -- p_return_status will return value indication failure.
170 --
171 -- Access Status:
172 -- Internal Development use only.
173 --
174 -- {End of comments}
175 -- ----------------------------------------------------------------------------
176 PROCEDURE maintain_student_comp_element
177 (p_person_id in number
178 ,p_competence_id in number
179 ,p_proficiency_level_id in number
180 ,p_business_group_id in number
181 ,p_effective_date_from in date
182 ,p_effective_date_to in date
183 ,p_certification_date in date
184 ,p_certification_method in varchar2
185 ,p_next_certification_date in date
186 ,p_source_of_proficiency_level in varchar2
187 ,p_comments in varchar2
188 ,p_effective_date in date
189 ,p_validate in number default hr_api.g_false_num
190 ,p_competence_created out nocopy number
191 ,p_return_status out nocopy varchar2
192 );
193 -- ----------------------------------------------------------------------------
194 -- |-----------------------< update_competence_element >----------------------|
195 -- ----------------------------------------------------------------------------
196 -- {Start of comments}
197 --
198 -- Description:
199 -- This procedure is the self-service wrapper procedure to the following
200 -- API: hr_competence_element_api.update_competence_element
201 --
202 -- We allow competence_id to be updated in this call by calling delete then
203 -- insert internally
204 --
205 -- Pre-requisites
206 -- All 'IN' parameters to this procedure have been appropriately derived.
207 --
208 -- Post Success:
209 -- p_return_status will return value indicating success.
210 --
211 -- Post Failure:
212 -- p_return_status will return value indication failure.
213 --
214 -- Access Status:
215 -- Internal Development use only.
216 --
217 -- {End of comments}
218 -- ----------------------------------------------------------------------------
219 PROCEDURE update_competence_element
220 (p_competence_element_id in number
221 ,p_object_version_number in out nocopy number
222 ,p_competence_id in number default hr_api.g_number
223 ,p_proficiency_level_id in number default hr_api.g_number
224 ,p_high_proficiency_level_id in number default hr_api.g_number
225 ,p_weighting_level_id in number default hr_api.g_number
226 ,p_rating_level_id in number default hr_api.g_number
227 ,p_mandatory in varchar2 default hr_api.g_varchar2
228 ,p_effective_date_from in date default hr_api.g_date
229 ,p_effective_date_to in date default hr_api.g_date
230 ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231 ,p_competence_type in varchar2 default hr_api.g_varchar2
232 ,p_normal_elapse_duration in number default hr_api.g_number
233 ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234 ,p_sequence_number in number default hr_api.g_number
235 ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236 ,p_line_score in number default hr_api.g_number
237 ,p_certification_date in date default hr_api.g_date
238 ,p_certification_method in varchar2 default hr_api.g_varchar2
239 ,p_next_certification_date in date default hr_api.g_date
240 ,p_comments in varchar2 default hr_api.g_varchar2
241 ,p_attribute_category in varchar2 default hr_api.g_varchar2
242 ,p_attribute1 in varchar2 default hr_api.g_varchar2
243 ,p_attribute2 in varchar2 default hr_api.g_varchar2
244 ,p_attribute3 in varchar2 default hr_api.g_varchar2
245 ,p_attribute4 in varchar2 default hr_api.g_varchar2
246 ,p_attribute5 in varchar2 default hr_api.g_varchar2
247 ,p_attribute6 in varchar2 default hr_api.g_varchar2
248 ,p_attribute7 in varchar2 default hr_api.g_varchar2
249 ,p_attribute8 in varchar2 default hr_api.g_varchar2
250 ,p_attribute9 in varchar2 default hr_api.g_varchar2
251 ,p_attribute10 in varchar2 default hr_api.g_varchar2
252 ,p_attribute11 in varchar2 default hr_api.g_varchar2
253 ,p_attribute12 in varchar2 default hr_api.g_varchar2
254 ,p_attribute13 in varchar2 default hr_api.g_varchar2
255 ,p_attribute14 in varchar2 default hr_api.g_varchar2
256 ,p_attribute15 in varchar2 default hr_api.g_varchar2
257 ,p_attribute16 in varchar2 default hr_api.g_varchar2
258 ,p_attribute17 in varchar2 default hr_api.g_varchar2
259 ,p_attribute18 in varchar2 default hr_api.g_varchar2
260 ,p_attribute19 in varchar2 default hr_api.g_varchar2
261 ,p_attribute20 in varchar2 default hr_api.g_varchar2
262 ,p_effective_date in date
263 ,p_validate in number default hr_api.g_false_num
264 ,p_party_id in number
265 ,p_return_status out nocopy varchar2
266 ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267 ,p_appr_line_score in number default hr_api.g_number
268 ,p_status in varchar2 default null
269 );
270 -- ----------------------------------------------------------------------------
271 -- |------------------------< update_delivered_dates >------------------------|
272 -- ----------------------------------------------------------------------------
273 -- {Start of comments}
274 --
275 -- Description:
276 -- This procedure is the self-service wrapper procedure to the following
277 -- API: hr_competence_element_api.update_delivered_dates
278 --
279 -- Pre-requisites
280 -- All 'IN' parameters to this procedure have been appropriately derived.
281 --
282 -- Post Success:
283 -- p_return_status will return value indicating success.
284 --
285 -- Post Failure:
289 -- Internal Development use only.
286 -- p_return_status will return value indication failure.
287 --
288 -- Access Status:
290 --
291 -- {End of comments}
292 -- ----------------------------------------------------------------------------
293 PROCEDURE update_delivered_dates
294 (p_activity_version_id in number
295 ,p_old_start_date in date
296 ,p_start_date in date
297 ,p_old_end_date in date
298 ,p_end_date in date
299 ,p_validate in number default hr_api.g_false_num
300 ,p_return_status out nocopy varchar2
301 );
302 -- ----------------------------------------------------------------------------
303 -- |---------------------< update_personal_comp_element >---------------------|
304 -- ----------------------------------------------------------------------------
305 -- {Start of comments}
306 --
307 -- Description:
308 -- This procedure is the self-service wrapper procedure to the following
309 -- API: hr_competence_element_api.update_personal_comp_element
310 --
311 -- Pre-requisites
312 -- All 'IN' parameters to this procedure have been appropriately derived.
313 --
314 -- Post Success:
315 -- p_return_status will return value indicating success.
316 --
317 -- Post Failure:
318 -- p_return_status will return value indication failure.
319 --
320 -- Access Status:
321 -- Internal Development use only.
322 --
323 -- {End of comments}
324 -- ----------------------------------------------------------------------------
325 PROCEDURE update_personal_comp_element
326 (p_competence_element_id in number
327 ,p_object_version_number in out nocopy number
328 ,p_proficiency_level_id in number default hr_api.g_number
329 ,p_effective_date_from in date default hr_api.g_date
330 ,p_effective_date_to in date default hr_api.g_date
331 ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332 ,p_certification_date in date default hr_api.g_date
333 ,p_certification_method in varchar2 default hr_api.g_varchar2
334 ,p_next_certification_date in date default hr_api.g_date
335 ,p_comments in varchar2 default hr_api.g_varchar2
336 ,p_attribute_category in varchar2 default hr_api.g_varchar2
337 ,p_attribute1 in varchar2 default hr_api.g_varchar2
338 ,p_attribute2 in varchar2 default hr_api.g_varchar2
339 ,p_attribute3 in varchar2 default hr_api.g_varchar2
340 ,p_attribute4 in varchar2 default hr_api.g_varchar2
341 ,p_attribute5 in varchar2 default hr_api.g_varchar2
342 ,p_attribute6 in varchar2 default hr_api.g_varchar2
343 ,p_attribute7 in varchar2 default hr_api.g_varchar2
344 ,p_attribute8 in varchar2 default hr_api.g_varchar2
345 ,p_attribute9 in varchar2 default hr_api.g_varchar2
346 ,p_attribute10 in varchar2 default hr_api.g_varchar2
347 ,p_attribute11 in varchar2 default hr_api.g_varchar2
348 ,p_attribute12 in varchar2 default hr_api.g_varchar2
349 ,p_attribute13 in varchar2 default hr_api.g_varchar2
350 ,p_attribute14 in varchar2 default hr_api.g_varchar2
351 ,p_attribute15 in varchar2 default hr_api.g_varchar2
352 ,p_attribute16 in varchar2 default hr_api.g_varchar2
353 ,p_attribute17 in varchar2 default hr_api.g_varchar2
354 ,p_attribute18 in varchar2 default hr_api.g_varchar2
355 ,p_attribute19 in varchar2 default hr_api.g_varchar2
356 ,p_attribute20 in varchar2 default hr_api.g_varchar2
357 ,p_effective_date in date
358 ,p_validate in number default hr_api.g_false_num
359 ,p_ins_ovn out nocopy number
360 ,p_ins_comp_id out nocopy number
361 ,p_return_status out nocopy varchar2
362 );
363
364 -- ----------------------------------------------------------------------------
365 -- |---------------------------< process_api >--------------------------------|
366 -- ----------------------------------------------------------------------------
367 -- {Start of comments}
368 --
369 -- Description:
370 -- This procedure is responsible for commiting data from transaction
371 -- table (hr_api_transaction_step_id) to the base table
372 --
373 -- Parameters:
374 -- p_document is the document having the data that needs to be committed
375 -- p_return_status is the return status after committing the date. In case of
376 -- any errors/warnings the p_return_status is populated with 'E' or 'W'
377 -- p_validate is the flag to indicate whether to rollback data or not
378 -- p_effective_date is the current effective date
379 --
380 -- Access Status:
381 -- Internal Development use only.
382 --
383 -- {End of comments}
384 -- ----------------------------------------------------------------------------
385
386 Procedure process_api
387 ( p_document in CLOB
388 ,p_return_status out nocopy VARCHAR2
389 ,p_validate in number default hr_api.g_false_num
390 ,p_effective_date in date default null
391 );
392
393
394
395 end hr_competence_element_swi;