1 Package hr_competence_element_bk1 as
2 /* $Header: pecelapi.pkh 120.2 2006/02/13 14:05:47 vbala noship $ */
3 --
4 --
5 -- create_competence_element_b
6 --
7 Procedure create_competence_element_b (
8 p_type in varchar2,
9 p_business_group_id in number ,
10 p_enterprise_id in number ,
11 p_competence_id in number ,
12 p_proficiency_level_id in number ,
13 p_high_proficiency_level_id in number ,
14 p_weighting_level_id in number ,
15 p_rating_level_id in number ,
16 p_person_id in number ,
17 p_job_id in number ,
18 p_valid_grade_id in number ,
19 p_position_id in number ,
20 p_organization_id in number ,
21 p_parent_competence_element_id in number ,
22 p_activity_version_id in number ,
23 p_assessment_id in number ,
24 p_assessment_type_id in number ,
25 p_mandatory in varchar2,
26 p_effective_date_from in date ,
27 p_effective_date_to in date ,
28 p_group_competence_type in varchar2,
29 p_competence_type in varchar2,
30 p_normal_elapse_duration in number ,
31 p_normal_elapse_duration_unit in varchar2,
32 p_sequence_number in number ,
33 p_source_of_proficiency_level in varchar2,
34 p_line_score in number ,
35 p_certification_date in date ,
36 p_certification_method in varchar2,
37 p_next_certification_date in date ,
38 p_comments in varchar2,
39 p_attribute_category in varchar2,
40 p_attribute1 in varchar2,
41 p_attribute2 in varchar2,
42 p_attribute3 in varchar2,
43 p_attribute4 in varchar2,
44 p_attribute5 in varchar2,
45 p_attribute6 in varchar2,
46 p_attribute7 in varchar2,
47 p_attribute8 in varchar2,
48 p_attribute9 in varchar2,
49 p_attribute10 in varchar2,
50 p_attribute11 in varchar2,
51 p_attribute12 in varchar2,
52 p_attribute13 in varchar2,
53 p_attribute14 in varchar2,
54 p_attribute15 in varchar2,
55 p_attribute16 in varchar2,
56 p_attribute17 in varchar2,
57 p_attribute18 in varchar2,
58 p_attribute19 in varchar2,
59 p_attribute20 in varchar2,
60 p_effective_date in Date,
61 p_object_id in number,
62 p_object_name in varchar2,
63 p_party_id in number, -- HR/TCA merge
64 p_qualification_type_id in number,
65 p_unit_standard_type in varchar2,
66 p_status in varchar2,
67 p_information_category in varchar2,
68 p_information1 in varchar2,
69 p_information2 in varchar2,
70 p_information3 in varchar2,
71 p_information4 in varchar2,
72 p_information5 in varchar2,
73 p_information6 in varchar2,
74 p_information7 in varchar2,
75 p_information8 in varchar2,
76 p_information9 in varchar2,
77 p_information10 in varchar2,
78 p_information11 in varchar2,
79 p_information12 in varchar2,
80 p_information13 in varchar2,
81 p_information14 in varchar2,
82 p_information15 in varchar2,
83 p_information16 in varchar2,
84 p_information17 in varchar2,
85 p_information18 in varchar2,
86 p_information19 in varchar2,
87 p_information20 in varchar2,
88 p_achieved_date in date,
89 p_appr_line_score in number
90 );
91 --
92 -- create_competence_element_a
93 --
94 Procedure create_competence_element_a (
95 p_competence_element_id in number ,
96 p_object_version_number in number ,
97 p_type in varchar2,
98 p_business_group_id in number ,
99 p_enterprise_id in number ,
100 p_competence_id in number ,
101 p_proficiency_level_id in number ,
102 p_high_proficiency_level_id in number ,
103 p_weighting_level_id in number ,
104 p_rating_level_id in number ,
105 p_person_id in number ,
106 p_job_id in number ,
107 p_valid_grade_id in number ,
108 p_position_id in number ,
109 p_organization_id in number ,
110 p_parent_competence_element_id in number ,
111 p_activity_version_id in number ,
112 p_assessment_id in number ,
113 p_assessment_type_id in number ,
114 p_mandatory in varchar2,
115 p_effective_date_from in date ,
116 p_effective_date_to in date ,
117 p_group_competence_type in varchar2,
118 p_competence_type in varchar2,
119 p_normal_elapse_duration in number ,
120 p_normal_elapse_duration_unit in varchar2,
121 p_sequence_number in number ,
122 p_source_of_proficiency_level in varchar2,
123 p_line_score in number ,
124 p_certification_date in date ,
125 p_certification_method in varchar2,
126 p_next_certification_date in date ,
127 p_comments in varchar2,
128 p_attribute_category in varchar2,
129 p_attribute1 in varchar2,
130 p_attribute2 in varchar2,
131 p_attribute3 in varchar2,
132 p_attribute4 in varchar2,
133 p_attribute5 in varchar2,
134 p_attribute6 in varchar2,
135 p_attribute7 in varchar2,
136 p_attribute8 in varchar2,
137 p_attribute9 in varchar2,
138 p_attribute10 in varchar2,
139 p_attribute11 in varchar2,
140 p_attribute12 in varchar2,
141 p_attribute13 in varchar2,
142 p_attribute14 in varchar2,
143 p_attribute15 in varchar2,
144 p_attribute16 in varchar2,
145 p_attribute17 in varchar2,
146 p_attribute18 in varchar2,
147 p_attribute19 in varchar2,
148 p_attribute20 in varchar2,
149 p_effective_date in Date,
150 p_object_id in number,
151 p_object_name in varchar2,
152 p_party_id in number, -- HR/TCA merge
153 p_qualification_type_id in number,
154 p_unit_standard_type in varchar2,
155 p_status in varchar2,
156 p_information_category in varchar2,
157 p_information1 in varchar2,
158 p_information2 in varchar2,
159 p_information3 in varchar2,
160 p_information4 in varchar2,
161 p_information5 in varchar2,
162 p_information6 in varchar2,
163 p_information7 in varchar2,
164 p_information8 in varchar2,
165 p_information9 in varchar2,
166 p_information10 in varchar2,
167 p_information11 in varchar2,
168 p_information12 in varchar2,
169 p_information13 in varchar2,
170 p_information14 in varchar2,
171 p_information15 in varchar2,
172 p_information16 in varchar2,
173 p_information17 in varchar2,
174 p_information18 in varchar2,
175 p_information19 in varchar2,
176 p_information20 in varchar2,
177 p_achieved_date in date,
178 p_appr_line_score in number
179 );
180 end hr_competence_element_bk1;