29: -- ----------------------------------------------------------------------------
30: PROCEDURE copy_competencies
31: (p_activity_version_from in number
32: ,p_activity_version_to in number
33: ,p_competence_type in varchar2 default hr_api.g_varchar2
34: ,p_validate in number default hr_api.g_false_num
35: ,p_return_status out nocopy varchar2
36: );
37: -- ----------------------------------------------------------------------------
30: PROCEDURE copy_competencies
31: (p_activity_version_from in number
32: ,p_activity_version_to in number
33: ,p_competence_type in varchar2 default hr_api.g_varchar2
34: ,p_validate in number default hr_api.g_false_num
35: ,p_return_status out nocopy varchar2
36: );
37: -- ----------------------------------------------------------------------------
38: -- |-----------------------< create_competence_element >----------------------|
57: --
58: -- {End of comments}
59: -- ----------------------------------------------------------------------------
60: PROCEDURE create_competence_element
61: (p_validate in number default hr_api.g_false_num
62: ,p_competence_element_id in number
63: ,p_object_version_number out nocopy number
64: ,p_type in varchar2
65: ,p_business_group_id in number default null
144: --
145: -- {End of comments}
146: -- ----------------------------------------------------------------------------
147: PROCEDURE delete_competence_element
148: (p_validate in number default hr_api.g_false_num
149: ,p_competence_element_id in number
150: ,p_object_version_number in number
151: ,p_return_status out nocopy varchar2
152: );
185: ,p_next_certification_date in date
186: ,p_source_of_proficiency_level in varchar2
187: ,p_comments in varchar2
188: ,p_effective_date in date
189: ,p_validate in number default hr_api.g_false_num
190: ,p_competence_created out nocopy number
191: ,p_return_status out nocopy varchar2
192: );
193: -- ----------------------------------------------------------------------------
218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_competence_element
220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
219: PROCEDURE update_competence_element
220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number
268: ,p_status in varchar2 default null
269: );
270: -- ----------------------------------------------------------------------------
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number
268: ,p_status in varchar2 default null
269: );
270: -- ----------------------------------------------------------------------------
271: -- |------------------------< update_delivered_dates >------------------------|
295: ,p_old_start_date in date
296: ,p_start_date in date
297: ,p_old_end_date in date
298: ,p_end_date in date
299: ,p_validate in number default hr_api.g_false_num
300: ,p_return_status out nocopy varchar2
301: );
302: -- ----------------------------------------------------------------------------
303: -- |---------------------< update_personal_comp_element >---------------------|
324: -- ----------------------------------------------------------------------------
325: PROCEDURE update_personal_comp_element
326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
325: PROCEDURE update_personal_comp_element
326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number
360: ,p_ins_comp_id out nocopy number
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number
360: ,p_ins_comp_id out nocopy number
361: ,p_return_status out nocopy varchar2
362: );
367: -- {Start of comments}
368: --
369: -- Description:
370: -- This procedure is responsible for commiting data from transaction
371: -- table (hr_api_transaction_step_id) to the base table
372: --
373: -- Parameters:
374: -- p_document is the document having the data that needs to be committed
375: -- p_return_status is the return status after committing the date. In case of
385:
386: Procedure process_api
387: ( p_document in CLOB
388: ,p_return_status out nocopy VARCHAR2
389: ,p_validate in number default hr_api.g_false_num
390: ,p_effective_date in date default null
391: );
392:
393: