9: -- |-------------------------< create_lp_enrollment >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_lp_enrollment
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_learning_path_id in number
15: ,p_person_id in number default null
16: ,p_contact_id in number default null
17: ,p_path_status_code in varchar2
83: --
84: -- Convert constant values to their corresponding boolean value
85: --
86: l_validate :=
87: hr_api.constant_to_boolean
88: (p_constant_value => p_validate);
89: --
90: -- Register Surrogate ID or user key values
91: --
199: PROCEDURE update_lp_enrollment
200: (p_effective_date in date
201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
200: (p_effective_date in date
201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
249: -- Variables for API Boolean parameters
271: --
272: -- Convert constant values to their corresponding boolean value
273: --
274: l_validate :=
275: hr_api.constant_to_boolean
276: (p_constant_value => p_validate);
277: --
278: -- Register Surrogate ID or user key values
279: --
382: -- ----------------------------------------------------------------------------
383: PROCEDURE delete_lp_enrollment
384: (p_lp_enrollment_id in number
385: ,p_object_version_number in number
386: ,p_validate in number default hr_api.g_false_num
387: ,p_return_status out nocopy varchar2
388: ) is
389: --
390: -- Variables for API Boolean parameters
410: --
411: -- Convert constant values to their corresponding boolean value
412: --
413: l_validate :=
414: hr_api.constant_to_boolean
415: (p_constant_value => p_validate);
416: --
417: -- Register Surrogate ID or user key values
418: --
474: -- ----------------------------------------------------------------------------
475: -- |--------------------------< SUBSCRIBE_TO_LEARNING_PATH>-------------------------|
476: -- ----------------------------------------------------------------------------
477: procedure subscribe_to_learning_path
478: (p_validate in number default hr_api.g_false_num
479: ,p_learning_path_id IN NUMBER
480: ,p_person_id IN NUMBER default null
481: ,p_contact_id IN NUMBER default null
482: ,p_enrollment_source_code IN VARCHAR2
495: hr_multi_message.enable_message_list;
496: savepoint create_lp_subscription_swi;
497:
498: l_validate :=
499: hr_api.constant_to_boolean
500: (p_constant_value => p_validate);
501:
502: ota_lp_enrollment_api.subscribe_to_learning_path(
503: p_validate => l_validate
540: p_path_status_code := null;
541: p_return_status := hr_multi_message.get_return_status_disable;
542: hr_utility.set_location(' Leaving:' || l_proc, 30);
543:
544: when hr_api.validate_enabled then
545: --
546: -- As the Validate_Enabled exception has been raised
547: -- we must rollback to the savepoint
548: --