46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --
122: Procedure upd
123: (
124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
123: (
124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --
199: end per_cel_upd;
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --
199: end per_cel_upd;