1 Package hr_competence_element_bk2 as
2 /* $Header: pecelapi.pkh 120.2 2006/02/13 14:05:47 vbala noship $ */
3 --
4 --
5 -- update_competence_element_b
6 --
7 Procedure update_competence_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_high_proficiency_level_id in number ,
12 p_weighting_level_id in number ,
13 p_rating_level_id in number ,
14 p_mandatory in varchar2 ,
15 p_effective_date_from in date ,
16 p_effective_date_to in date ,
17 p_group_competence_type in varchar2 ,
18 p_competence_type in varchar2 ,
19 p_normal_elapse_duration in number ,
20 p_normal_elapse_duration_unit in varchar2 ,
21 p_sequence_number in number ,
22 p_source_of_proficiency_level in varchar2 ,
23 p_line_score in number ,
24 p_certification_date in date ,
25 p_certification_method in varchar2 ,
26 p_next_certification_date in date ,
27 p_comments in varchar2 ,
28 p_attribute_category in varchar2 ,
29 p_attribute1 in varchar2 ,
30 p_attribute2 in varchar2 ,
31 p_attribute3 in varchar2 ,
32 p_attribute4 in varchar2 ,
33 p_attribute5 in varchar2 ,
34 p_attribute6 in varchar2 ,
35 p_attribute7 in varchar2 ,
36 p_attribute8 in varchar2 ,
37 p_attribute9 in varchar2 ,
38 p_attribute10 in varchar2 ,
39 p_attribute11 in varchar2 ,
40 p_attribute12 in varchar2 ,
41 p_attribute13 in varchar2 ,
42 p_attribute14 in varchar2 ,
43 p_attribute15 in varchar2 ,
44 p_attribute16 in varchar2 ,
45 p_attribute17 in varchar2 ,
46 p_attribute18 in varchar2 ,
47 p_attribute19 in varchar2 ,
48 p_attribute20 in varchar2 ,
49 p_effective_date in Date ,
50 p_qualification_type_id in number,
51 p_unit_standard_type in varchar2,
52 p_status in varchar2,
53 p_information_category in varchar2,
54 p_information1 in varchar2,
55 p_information2 in varchar2,
56 p_information3 in varchar2,
57 p_information4 in varchar2,
58 p_information5 in varchar2,
59 p_information6 in varchar2,
60 p_information7 in varchar2,
61 p_information8 in varchar2,
62 p_information9 in varchar2,
63 p_information10 in varchar2,
64 p_information11 in varchar2,
65 p_information12 in varchar2,
66 p_information13 in varchar2,
67 p_information14 in varchar2,
68 p_information15 in varchar2,
69 p_information16 in varchar2,
70 p_information17 in varchar2,
71 p_information18 in varchar2,
72 p_information19 in varchar2,
73 p_information20 in varchar2,
74 p_achieved_date in date,
75 p_appr_line_score in number
76 );
77
78 --
79 -- update_competence_element_a
80 --
81 Procedure update_competence_element_a (
82 p_competence_element_id in number ,
83 p_object_version_number in number ,
84 p_proficiency_level_id in number ,
85 p_high_proficiency_level_id in number ,
86 p_weighting_level_id in number ,
87 p_rating_level_id in number ,
88 p_mandatory in varchar2 ,
89 p_effective_date_from in date ,
90 p_effective_date_to in date ,
91 p_group_competence_type in varchar2 ,
92 p_competence_type in varchar2 ,
93 p_normal_elapse_duration in number ,
94 p_normal_elapse_duration_unit in varchar2 ,
95 p_sequence_number in number ,
96 p_source_of_proficiency_level in varchar2 ,
97 p_line_score in number ,
98 p_certification_date in date ,
99 p_certification_method in varchar2 ,
100 p_next_certification_date in date ,
101 p_comments in varchar2 ,
102 p_attribute_category in varchar2 ,
103 p_attribute1 in varchar2 ,
104 p_attribute2 in varchar2 ,
105 p_attribute3 in varchar2 ,
106 p_attribute4 in varchar2 ,
107 p_attribute5 in varchar2 ,
108 p_attribute6 in varchar2 ,
109 p_attribute7 in varchar2 ,
110 p_attribute8 in varchar2 ,
111 p_attribute9 in varchar2 ,
112 p_attribute10 in varchar2 ,
113 p_attribute11 in varchar2 ,
114 p_attribute12 in varchar2 ,
115 p_attribute13 in varchar2 ,
116 p_attribute14 in varchar2 ,
117 p_attribute15 in varchar2 ,
118 p_attribute16 in varchar2 ,
119 p_attribute17 in varchar2 ,
120 p_attribute18 in varchar2 ,
121 p_attribute19 in varchar2 ,
122 p_attribute20 in varchar2 ,
123 p_effective_date in Date,
124 p_qualification_type_id in number,
125 p_unit_standard_type in varchar2,
126 p_status in varchar2,
127 p_information_category in varchar2,
128 p_information1 in varchar2,
129 p_information2 in varchar2,
130 p_information3 in varchar2,
131 p_information4 in varchar2,
132 p_information5 in varchar2,
133 p_information6 in varchar2,
134 p_information7 in varchar2,
135 p_information8 in varchar2,
136 p_information9 in varchar2,
137 p_information10 in varchar2,
138 p_information11 in varchar2,
139 p_information12 in varchar2,
140 p_information13 in varchar2,
141 p_information14 in varchar2,
142 p_information15 in varchar2,
143 p_information16 in varchar2,
144 p_information17 in varchar2,
145 p_information18 in varchar2,
146 p_information19 in varchar2,
147 p_information20 in varchar2,
148 p_achieved_date in date,
149 p_appr_line_score in number
150 );
151 end hr_competence_element_bk2;