9: -- |------------------------< create_activity_version >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_activity_version
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_activity_id in number
15: ,p_superseded_by_act_version_id in number default null
16: ,p_developer_organization_id in number
17: ,p_controlling_person_id in number default null
95: --
96: -- Convert constant values to their corresponding boolean value
97: --
98: l_validate :=
99: hr_api.constant_to_boolean
100: (p_constant_value => p_validate);
101: --
102: -- Register Surrogate ID or user key values
103: --
223: -- ----------------------------------------------------------------------------
224: PROCEDURE delete_activity_version
225: (p_activity_version_id in number
226: ,p_object_version_number in number
227: ,p_validate in number default hr_api.g_false_num
228: ,p_return_status out nocopy varchar2
229: ) is
230: --
231: -- Variables for API Boolean parameters
251: --
252: -- Convert constant values to their corresponding boolean value
253: --
254: l_validate :=
255: hr_api.constant_to_boolean
256: (p_constant_value => p_validate);
257: --
258: -- Register Surrogate ID or user key values
259: --
317: -- ----------------------------------------------------------------------------
318: PROCEDURE update_activity_version
319: (p_effective_date in date
320: ,p_activity_version_id in number
321: ,p_activity_id in number default hr_api.g_number
322: ,p_superseded_by_act_version_id in number default hr_api.g_number
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
318: PROCEDURE update_activity_version
319: (p_effective_date in date
320: ,p_activity_version_id in number
321: ,p_activity_id in number default hr_api.g_number
322: ,p_superseded_by_act_version_id in number default hr_api.g_number
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
319: (p_effective_date in date
320: ,p_activity_version_id in number
321: ,p_activity_id in number default hr_api.g_number
322: ,p_superseded_by_act_version_id in number default hr_api.g_number
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
320: ,p_activity_version_id in number
321: ,p_activity_id in number default hr_api.g_number
322: ,p_superseded_by_act_version_id in number default hr_api.g_number
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_superseded_by_act_version_id in number default hr_api.g_number
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
323: ,p_developer_organization_id in number default hr_api.g_number
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
324: ,p_controlling_person_id in number default hr_api.g_number
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
325: ,p_object_version_number in out nocopy number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
326: ,p_version_name in varchar2 default hr_api.g_varchar2
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
327: ,p_comments in varchar2 default hr_api.g_varchar2
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
328: ,p_description in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
329: ,p_duration in number default hr_api.g_number
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
330: ,p_duration_units in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
331: ,p_end_date in date default hr_api.g_date
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
332: ,p_intended_audience in varchar2 default hr_api.g_varchar2
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
333: ,p_language_id in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
334: ,p_maximum_attendees in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
335: ,p_minimum_attendees in number default hr_api.g_number
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
336: ,p_objectives in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
337: ,p_start_date in date default hr_api.g_date
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
338: ,p_success_criteria in varchar2 default hr_api.g_varchar2
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
339: ,p_user_status in varchar2 default hr_api.g_varchar2
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
340: ,p_vendor_id in number default hr_api.g_number
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
341: ,p_actual_cost in number default hr_api.g_number
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
342: ,p_budget_cost in number default hr_api.g_number
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
343: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
344: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
345: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
346: ,p_professional_credits in number default hr_api.g_number
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
347: ,p_maximum_internal_attendees in number default hr_api.g_number
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
348: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
349: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
350: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
362: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
363: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
364: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
365: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
366: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
367: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
368: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
369: ,p_inventory_item_id in number default hr_api.g_number
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
377: ,p_data_source in varchar2 default hr_api.g_varchar2
370: ,p_organization_id in number default hr_api.g_number
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
377: ,p_data_source in varchar2 default hr_api.g_varchar2
378: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
371: ,p_rco_id in number default hr_api.g_number
372: ,p_version_code in varchar2 default hr_api.g_varchar2
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
377: ,p_data_source in varchar2 default hr_api.g_varchar2
378: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
379:
373: ,p_keywords in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
377: ,p_data_source in varchar2 default hr_api.g_varchar2
378: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
379:
380: ) is
381: --
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_validate in number default hr_api.g_false_num
376: ,p_return_status out nocopy varchar2
377: ,p_data_source in varchar2 default hr_api.g_varchar2
378: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
379:
380: ) is
381: --
382: -- Variables for API Boolean parameters
404: --
405: -- Convert constant values to their corresponding boolean value
406: --
407: l_validate :=
408: hr_api.constant_to_boolean
409: (p_constant_value => p_validate);
410: --
411: -- Register Surrogate ID or user key values
412: --