1 Package per_cel_rkd as
2 /* $Header: pecelrhi.pkh 120.1.12010000.2 2008/08/06 09:06:10 ubhat ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_delete >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_delete (
9 p_competence_element_id in number,
10 p_object_version_number_o in number,
11 p_type_o in varchar2,
12 p_business_group_id_o in number,
13 p_enterprise_id_o in number,
14 p_competence_id_o in number,
15 -- p_member_competence_set_id_o in number,
16 p_proficiency_level_id_o in number,
17 p_high_proficiency_level_id_o in number,
18 p_weighting_level_id_o in number,
19 p_rating_level_id_o in number,
20 p_person_id_o in number,
21 p_job_id_o in number,
22 p_valid_grade_id_o in number,
23 p_position_id_o in number,
24 p_organization_id_o in number,
25 -- p_work_item_id_o in number,
26 -- p_competence_set_id_o in number,
27 p_parent_competence_element_o in number,
28 p_activity_version_id_o in number,
29 p_assessment_id_o in number,
30 p_assessment_type_id_o in number,
31 p_mandatory_o in varchar2,
32 p_effective_date_from_o in date,
33 p_effective_date_to_o in date,
34 p_group_competence_type_o in varchar2,
35 p_competence_type_o in varchar2,
36 p_normal_elapse_duration_o in number,
37 p_normal_elapse_duration_uni_o in varchar2,
38 p_sequence_number_o in number,
39 p_source_of_proficiency_leve_o in varchar2,
40 p_line_score_o in number,
41 p_certification_date_o in date,
42 p_certification_method_o in varchar2,
43 p_next_certification_date_o in date,
44 p_comments_o in varchar2,
45 p_attribute_category_o in varchar2,
46 p_attribute1_o in varchar2,
47 p_attribute2_o in varchar2,
48 p_attribute3_o in varchar2,
49 p_attribute4_o in varchar2,
50 p_attribute5_o in varchar2,
51 p_attribute6_o in varchar2,
52 p_attribute7_o in varchar2,
53 p_attribute8_o in varchar2,
54 p_attribute9_o in varchar2,
55 p_attribute10_o in varchar2,
56 p_attribute11_o in varchar2,
57 p_attribute12_o in varchar2,
58 p_attribute13_o in varchar2,
59 p_attribute14_o in varchar2,
60 p_attribute15_o in varchar2,
61 p_attribute16_o in varchar2,
62 p_attribute17_o in varchar2,
63 p_attribute18_o in varchar2,
64 p_attribute19_o in varchar2,
65 p_attribute20_o in varchar2,
66 p_object_id_o in number,
67 p_object_name_o in varchar2,
68 p_party_id_o in number -- HR/TCA merge
69 -- BUG3356369
70 ,p_qualification_type_id_o in number
71 ,p_unit_standard_type_o in varchar2
72 ,p_status_o in varchar2
73 ,p_information_category_o in varchar2
74 ,p_information1_o in varchar2
75 ,p_information2_o in varchar2
76 ,p_information3_o in varchar2
77 ,p_information4_o in varchar2
78 ,p_information5_o in varchar2
79 ,p_information6_o in varchar2
80 ,p_information7_o in varchar2
81 ,p_information8_o in varchar2
82 ,p_information9_o in varchar2
83 ,p_information10_o in varchar2
84 ,p_information11_o in varchar2
85 ,p_information12_o in varchar2
86 ,p_information13_o in varchar2
87 ,p_information14_o in varchar2
88 ,p_information15_o in varchar2
89 ,p_information16_o in varchar2
90 ,p_information17_o in varchar2
91 ,p_information18_o in varchar2
92 ,p_information19_o in varchar2
93 ,p_information20_o in varchar2
94 ,p_achieved_date_o in date
95 ,p_appr_line_score_o in number
96 );
97
98 end per_cel_rkd;