96: Procedure upd
97: (p_effective_date in date
98: ,p_competence_language_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_competence_id in number default hr_api.g_number
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
97: (p_effective_date in date
98: ,p_competence_language_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_competence_id in number default hr_api.g_number
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
98: ,p_competence_language_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_competence_id in number default hr_api.g_number
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
99: ,p_object_version_number in out nocopy number
100: ,p_competence_id in number default hr_api.g_number
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
100: ,p_competence_id in number default hr_api.g_number
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
101: ,p_language_code in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
102: ,p_business_group_id in number default hr_api.g_number
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
103: ,p_min_proficiency_level_id in number default hr_api.g_number
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
104: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
105: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
106: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
107: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
108: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
109: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
110: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
111: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
112: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
113: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
114: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
115: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
116: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
124: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
117: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
124: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
125: );
118: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
124: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
125: );
126: --
119: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
124: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
125: );
126: --
127: end ota_ocl_upd;
120: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
121: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
122: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
123: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
124: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
125: );
126: --
127: end ota_ocl_upd;