8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_external_learning >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_external_learning
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_nota_history_id in number
15: ,p_person_id in number
16: ,p_contact_id in number default null
80: --
81: -- Convert constant values to their corresponding boolean value
82: --
83: l_validate :=
84: hr_api.constant_to_boolean
85: (p_constant_value => p_validate);
86: --
87: -- Register Surrogate ID or user key values
88: ota_nhs_ins.set_base_key_value
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------< update_external_learning >-----------------------|
190: -- ----------------------------------------------------------------------------
191: PROCEDURE update_external_learning
192: (p_validate in number default hr_api.g_false_num
193: ,p_effective_date in date
194: ,p_nota_history_id in number
195: ,p_person_id in number
196: ,p_contact_id in number default hr_api.g_number
192: (p_validate in number default hr_api.g_false_num
193: ,p_effective_date in date
194: ,p_nota_history_id in number
195: ,p_person_id in number
196: ,p_contact_id in number default hr_api.g_number
197: ,p_trng_title in varchar2
198: ,p_provider in varchar2
199: ,p_type in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
195: ,p_person_id in number
196: ,p_contact_id in number default hr_api.g_number
197: ,p_trng_title in varchar2
198: ,p_provider in varchar2
199: ,p_type in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
196: ,p_contact_id in number default hr_api.g_number
197: ,p_trng_title in varchar2
198: ,p_provider in varchar2
199: ,p_type in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
198: ,p_provider in varchar2
199: ,p_type in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
199: ,p_type in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
200: ,p_centre in varchar2 default hr_api.g_varchar2
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
201: ,p_completion_date in date
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
202: ,p_award in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
203: ,p_rating in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
204: ,p_duration in number default hr_api.g_number
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
205: ,p_duration_units in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
206: ,p_activity_version_id in number default hr_api.g_number
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
207: ,p_status in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
208: ,p_verified_by_id in number default hr_api.g_number
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
209: ,p_nth_information_category in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
210: ,p_nth_information1 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
211: ,p_nth_information2 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
212: ,p_nth_information3 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
213: ,p_nth_information4 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
214: ,p_nth_information5 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
215: ,p_nth_information6 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
216: ,p_nth_information7 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
217: ,p_nth_information8 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
218: ,p_nth_information9 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
219: ,p_nth_information10 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
220: ,p_nth_information11 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
221: ,p_nth_information12 in varchar2 default hr_api.g_varchar2
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
222: ,p_nth_information13 in varchar2 default hr_api.g_varchar2
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
223: ,p_nth_information15 in varchar2 default hr_api.g_varchar2
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
224: ,p_nth_information16 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
232: ,p_nth_information14 in varchar2 default hr_api.g_varchar2
225: ,p_nth_information17 in varchar2 default hr_api.g_varchar2
226: ,p_nth_information18 in varchar2 default hr_api.g_varchar2
227: ,p_nth_information19 in varchar2 default hr_api.g_varchar2
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
232: ,p_nth_information14 in varchar2 default hr_api.g_varchar2
233: ,p_customer_id in number default hr_api.g_number
228: ,p_nth_information20 in varchar2 default hr_api.g_varchar2
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
232: ,p_nth_information14 in varchar2 default hr_api.g_varchar2
233: ,p_customer_id in number default hr_api.g_number
234: ,p_organization_id in number default hr_api.g_number
235: ,p_return_status out nocopy varchar2
236: ) is
229: ,p_org_id in number default hr_api.g_number
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
232: ,p_nth_information14 in varchar2 default hr_api.g_varchar2
233: ,p_customer_id in number default hr_api.g_number
234: ,p_organization_id in number default hr_api.g_number
235: ,p_return_status out nocopy varchar2
236: ) is
237: --
230: ,p_object_version_number in out nocopy number
231: ,p_business_group_id in number
232: ,p_nth_information14 in varchar2 default hr_api.g_varchar2
233: ,p_customer_id in number default hr_api.g_number
234: ,p_organization_id in number default hr_api.g_number
235: ,p_return_status out nocopy varchar2
236: ) is
237: --
238: -- Variables for API Boolean parameters
261: --
262: -- Convert constant values to their corresponding boolean value
263: --
264: l_validate :=
265: hr_api.constant_to_boolean
266: (p_constant_value => p_validate);
267: --
268: -- Register Surrogate ID or user key values
269: --
367: -- ----------------------------------------------------------------------------
368: -- |-----------------------< delete_external_learning >-----------------------|
369: -- ----------------------------------------------------------------------------
370: PROCEDURE delete_external_learning
371: (p_validate in number default hr_api.g_false_num
372: ,p_nota_history_id in number
373: ,p_object_version_number in number
374: ,p_return_status out nocopy varchar2
375: ) is
397: --
398: -- Convert constant values to their corresponding boolean value
399: --
400: l_validate :=
401: hr_api.constant_to_boolean
402: (p_constant_value => p_validate);
403: --
404: -- Register Surrogate ID or user key values
405: --