1 Package hr_competence_element_bk3 as
2 /* $Header: pecelapi.pkh 120.2 2006/02/13 14:05:47 vbala noship $ */
3 --
4 --
5 -- update_personal_comp_element_b
6 --
7 Procedure update_personal_comp_element_b (
8 p_competence_element_id in number ,
9 p_object_version_number in number ,
10 p_proficiency_level_id in number ,
11 p_effective_date_from in date ,
12 p_effective_date_to in date ,
13 p_source_of_proficiency_level in varchar2 ,
14 p_certification_date in date ,
15 p_certification_method in varchar2 ,
16 p_next_certification_date in date ,
17 p_comments in varchar2 ,
18 p_attribute_category in varchar2 ,
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_attribute16 in varchar2 ,
35 p_attribute17 in varchar2 ,
36 p_attribute18 in varchar2 ,
37 p_attribute19 in varchar2 ,
38 p_attribute20 in varchar2 ,
39 p_effective_date in Date );
40 --
41 -- update_personal_comp_element_a
42 --
43 Procedure update_personal_comp_element_a (
44 p_competence_element_id in number ,
45 p_object_version_number in number ,
46 p_proficiency_level_id in number ,
47 p_effective_date_from in date ,
48 p_effective_date_to in date ,
49 p_source_of_proficiency_level in varchar2 ,
50 p_certification_date in date ,
51 p_certification_method in varchar2 ,
52 p_next_certification_date in date ,
53 p_comments in varchar2 ,
54 p_attribute_category in varchar2 ,
55 p_attribute1 in varchar2 ,
56 p_attribute2 in varchar2 ,
57 p_attribute3 in varchar2 ,
58 p_attribute4 in varchar2 ,
59 p_attribute5 in varchar2 ,
60 p_attribute6 in varchar2 ,
61 p_attribute7 in varchar2 ,
62 p_attribute8 in varchar2 ,
63 p_attribute9 in varchar2 ,
64 p_attribute10 in varchar2 ,
65 p_attribute11 in varchar2 ,
66 p_attribute12 in varchar2 ,
67 p_attribute13 in varchar2 ,
68 p_attribute14 in varchar2 ,
69 p_attribute15 in varchar2 ,
70 p_attribute16 in varchar2 ,
71 p_attribute17 in varchar2 ,
72 p_attribute18 in varchar2 ,
73 p_attribute19 in varchar2 ,
74 p_attribute20 in varchar2 ,
75 p_effective_date in Date ,
76 p_ins_ovn in number ,
77 p_ins_comp_id in number );
78
79 end hr_competence_element_bk3;