1 Package per_cel_rku AUTHID CURRENT_USER as
2 /* $Header: pecelrhi.pkh 120.2 2008/02/29 12:09:39 rsykam ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update (
9 p_competence_element_id in number,
10 p_object_version_number in number,
11 p_type in varchar2,
12 p_business_group_id in number,
13 p_enterprise_id in number,
14 p_competence_id in number,
15 -- p_member_competence_set_id in number,
16 p_proficiency_level_id in number,
17 p_high_proficiency_level_id in number,
18 p_weighting_level_id in number,
19 p_rating_level_id in number,
20 p_person_id in number,
21 p_job_id in number,
22 p_valid_grade_id in number,
23 p_position_id in number,
24 p_organization_id in number,
25 -- p_work_item_id in number,
26 -- p_competence_set_id in number,
27 p_parent_competence_element_id in number,
28 p_activity_version_id in number,
29 p_assessment_id in number,
30 p_assessment_type_id in number,
31 p_mandatory in varchar2,
32 p_effective_date_from in date,
33 p_effective_date_to in date,
34 p_group_competence_type in varchar2,
35 p_competence_type in varchar2,
36 p_normal_elapse_duration in number,
37 p_normal_elapse_duration_unit in varchar2,
38 p_sequence_number in number,
39 p_source_of_proficiency_level in varchar2,
40 p_line_score in number,
41 p_certification_date in date,
42 p_certification_method in varchar2,
43 p_next_certification_date in date,
44 p_comments in varchar2,
45 p_attribute_category in varchar2,
46 p_attribute1 in varchar2,
47 p_attribute2 in varchar2,
48 p_attribute3 in varchar2,
49 p_attribute4 in varchar2,
50 p_attribute5 in varchar2,
51 p_attribute6 in varchar2,
52 p_attribute7 in varchar2,
53 p_attribute8 in varchar2,
54 p_attribute9 in varchar2,
55 p_attribute10 in varchar2,
56 p_attribute11 in varchar2,
57 p_attribute12 in varchar2,
58 p_attribute13 in varchar2,
59 p_attribute14 in varchar2,
60 p_attribute15 in varchar2,
61 p_attribute16 in varchar2,
62 p_attribute17 in varchar2,
63 p_attribute18 in varchar2,
64 p_attribute19 in varchar2,
65 p_attribute20 in varchar2,
66 p_object_id in number,
67 p_object_name in varchar2,
68 p_party_id in number, -- HR/TCA merge
69 -- BUG3356369
70 p_qualification_type_id in number,
71 p_unit_standard_type in varchar2,
72 p_status in varchar2,
73 p_information_category in varchar2,
74 p_information1 in varchar2,
75 p_information2 in varchar2,
76 p_information3 in varchar2,
77 p_information4 in varchar2,
78 p_information5 in varchar2,
79 p_information6 in varchar2,
80 p_information7 in varchar2,
81 p_information8 in varchar2,
82 p_information9 in varchar2,
83 p_information10 in varchar2,
84 p_information11 in varchar2,
85 p_information12 in varchar2,
86 p_information13 in varchar2,
87 p_information14 in varchar2,
88 p_information15 in varchar2,
89 p_information16 in varchar2,
90 p_information17 in varchar2,
91 p_information18 in varchar2,
92 p_information19 in varchar2,
93 p_information20 in varchar2,
94 p_achieved_date in date,
95 p_appr_line_score in number,
96 p_object_version_number_o in number,
97 p_type_o in varchar2,
98 p_business_group_id_o in number,
99 p_enterprise_id_o in number,
100 p_competence_id_o in number,
101 -- p_member_competence_set_id_o in number,
102 p_proficiency_level_id_o in number,
103 p_high_proficiency_level_id_o in number,
104 p_weighting_level_id_o in number,
105 p_rating_level_id_o in number,
106 p_person_id_o in number,
107 p_job_id_o in number,
108 p_valid_grade_id_o in number,
109 p_position_id_o in number,
110 p_organization_id_o in number,
111 -- p_work_item_id_o in number,
112 -- p_competence_set_id_o in number,
113 p_parent_competence_element_o in number,
114 p_activity_version_id_o in number,
115 p_assessment_id_o in number,
116 p_assessment_type_id_o in number,
117 p_mandatory_o in varchar2,
118 p_effective_date_from_o in date,
119 p_effective_date_to_o in date,
120 p_group_competence_type_o in varchar2,
121 p_competence_type_o in varchar2,
122 p_normal_elapse_duration_o in number,
123 p_normal_elapse_duration_uni_o in varchar2,
124 p_sequence_number_o in number,
125 p_source_of_proficiency_leve_o in varchar2,
126 p_line_score_o in number,
127 p_certification_date_o in date,
128 p_certification_method_o in varchar2,
129 p_next_certification_date_o in date,
130 p_comments_o in varchar2,
131 p_attribute_category_o in varchar2,
132 p_attribute1_o in varchar2,
133 p_attribute2_o in varchar2,
134 p_attribute3_o in varchar2,
135 p_attribute4_o in varchar2,
136 p_attribute5_o in varchar2,
137 p_attribute6_o in varchar2,
138 p_attribute7_o in varchar2,
139 p_attribute8_o in varchar2,
140 p_attribute9_o in varchar2,
141 p_attribute10_o in varchar2,
142 p_attribute11_o in varchar2,
143 p_attribute12_o in varchar2,
144 p_attribute13_o in varchar2,
145 p_attribute14_o in varchar2,
146 p_attribute15_o in varchar2,
147 p_attribute16_o in varchar2,
148 p_attribute17_o in varchar2,
149 p_attribute18_o in varchar2,
150 p_attribute19_o in varchar2,
151 p_attribute20_o in varchar2,
152 p_object_id_o in number,
153 p_object_name_o in varchar2,
154 p_party_id_o in number -- HR/TCA merge
155 -- BUG3356369
156 ,p_qualification_type_id_o in number
157 ,p_unit_standard_type_o in varchar2
158 ,p_status_o in varchar2
159 ,p_information_category_o in varchar2
160 ,p_information1_o in varchar2
161 ,p_information2_o in varchar2
162 ,p_information3_o in varchar2
163 ,p_information4_o in varchar2
164 ,p_information5_o in varchar2
165 ,p_information6_o in varchar2
166 ,p_information7_o in varchar2
167 ,p_information8_o in varchar2
168 ,p_information9_o in varchar2
169 ,p_information10_o in varchar2
170 ,p_information11_o in varchar2
171 ,p_information12_o in varchar2
172 ,p_information13_o in varchar2
173 ,p_information14_o in varchar2
174 ,p_information15_o in varchar2
175 ,p_information16_o in varchar2
176 ,p_information17_o in varchar2
177 ,p_information18_o in varchar2
178 ,p_information19_o in varchar2
179 ,p_information20_o in varchar2
180 ,p_achieved_date_o in date
181 ,p_appr_line_score_o in number
182 );
183
184 end per_cel_rku;