eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ACTIVITY_VERSION_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

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

Line 100: hr_api.constant_to_boolean

96: --
97: -- Convert constant values to their corresponding boolean value
98: --
99: l_validate :=
100: hr_api.constant_to_boolean
101: (p_constant_value => p_validate);
102: --
103: -- Register Surrogate ID or user key values
104: --

Line 228: ,p_validate in number default hr_api.g_false_num

224: -- ----------------------------------------------------------------------------
225: PROCEDURE delete_activity_version
226: (p_activity_version_id in number
227: ,p_object_version_number in number
228: ,p_validate in number default hr_api.g_false_num
229: ,p_return_status out nocopy varchar2
230: ) is
231: --
232: -- Variables for API Boolean parameters

Line 256: hr_api.constant_to_boolean

252: --
253: -- Convert constant values to their corresponding boolean value
254: --
255: l_validate :=
256: hr_api.constant_to_boolean
257: (p_constant_value => p_validate);
258: --
259: -- Register Surrogate ID or user key values
260: --

Line 322: ,p_activity_id in number default hr_api.g_number

318: -- ----------------------------------------------------------------------------
319: PROCEDURE update_activity_version
320: (p_effective_date in date
321: ,p_activity_version_id in number
322: ,p_activity_id in number default hr_api.g_number
323: ,p_superseded_by_act_version_id in number default hr_api.g_number
324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number

Line 323: ,p_superseded_by_act_version_id in number default hr_api.g_number

319: PROCEDURE update_activity_version
320: (p_effective_date in date
321: ,p_activity_version_id in number
322: ,p_activity_id in number default hr_api.g_number
323: ,p_superseded_by_act_version_id in number default hr_api.g_number
324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2

Line 324: ,p_developer_organization_id in number default hr_api.g_number

320: (p_effective_date in date
321: ,p_activity_version_id in number
322: ,p_activity_id in number default hr_api.g_number
323: ,p_superseded_by_act_version_id in number default hr_api.g_number
324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2

Line 325: ,p_controlling_person_id in number default hr_api.g_number

321: ,p_activity_version_id in number
322: ,p_activity_id in number default hr_api.g_number
323: ,p_superseded_by_act_version_id in number default hr_api.g_number
324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2

Line 327: ,p_version_name in varchar2 default hr_api.g_varchar2

323: ,p_superseded_by_act_version_id in number default hr_api.g_number
324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 328: ,p_comments in varchar2 default hr_api.g_varchar2

324: ,p_developer_organization_id in number default hr_api.g_number
325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date

Line 329: ,p_description in varchar2 default hr_api.g_varchar2

325: ,p_controlling_person_id in number default hr_api.g_number
326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2

Line 330: ,p_duration in number default hr_api.g_number

326: ,p_object_version_number in out nocopy number
327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number

Line 331: ,p_duration_units in varchar2 default hr_api.g_varchar2

327: ,p_version_name in varchar2 default hr_api.g_varchar2
328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number

Line 332: ,p_end_date in date default hr_api.g_date

328: ,p_comments in varchar2 default hr_api.g_varchar2
329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number

Line 333: ,p_intended_audience in varchar2 default hr_api.g_varchar2

329: ,p_description in varchar2 default hr_api.g_varchar2
330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2

Line 334: ,p_language_id in number default hr_api.g_number

330: ,p_duration in number default hr_api.g_number
331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date

Line 335: ,p_maximum_attendees in number default hr_api.g_number

331: ,p_duration_units in varchar2 default hr_api.g_varchar2
332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2

Line 336: ,p_minimum_attendees in number default hr_api.g_number

332: ,p_end_date in date default hr_api.g_date
333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2

Line 337: ,p_objectives in varchar2 default hr_api.g_varchar2

333: ,p_intended_audience in varchar2 default hr_api.g_varchar2
334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number

Line 338: ,p_start_date in date default hr_api.g_date

334: ,p_language_id in number default hr_api.g_number
335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number

Line 339: ,p_success_criteria in varchar2 default hr_api.g_varchar2

335: ,p_maximum_attendees in number default hr_api.g_number
336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number

Line 340: ,p_user_status in varchar2 default hr_api.g_varchar2

336: ,p_minimum_attendees in number default hr_api.g_number
337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

Line 341: ,p_vendor_id in number default hr_api.g_number

337: ,p_objectives in varchar2 default hr_api.g_varchar2
338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2

Line 342: ,p_actual_cost in number default hr_api.g_number

338: ,p_start_date in date default hr_api.g_date
339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2

Line 343: ,p_budget_cost in number default hr_api.g_number

339: ,p_success_criteria in varchar2 default hr_api.g_varchar2
340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number

Line 344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

340: ,p_user_status in varchar2 default hr_api.g_varchar2
341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number

Line 345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2

341: ,p_vendor_id in number default hr_api.g_number
342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2

Line 346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2

342: ,p_actual_cost in number default hr_api.g_number
343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2

Line 347: ,p_professional_credits in number default hr_api.g_number

343: ,p_budget_cost in number default hr_api.g_number
344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2

Line 348: ,p_maximum_internal_attendees in number default hr_api.g_number

344: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2

Line 349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2

345: ,p_expenses_allowed in varchar2 default hr_api.g_varchar2
346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2

Line 350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2

346: ,p_professional_credit_type in varchar2 default hr_api.g_varchar2
347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2

Line 351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2

347: ,p_professional_credits in number default hr_api.g_number
348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2

Line 352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2

348: ,p_maximum_internal_attendees in number default hr_api.g_number
349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2

Line 353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2

349: ,p_tav_information_category in varchar2 default hr_api.g_varchar2
350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2

Line 354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2

350: ,p_tav_information1 in varchar2 default hr_api.g_varchar2
351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2

Line 355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2

351: ,p_tav_information2 in varchar2 default hr_api.g_varchar2
352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2

Line 356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2

352: ,p_tav_information3 in varchar2 default hr_api.g_varchar2
353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2

Line 357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2

353: ,p_tav_information4 in varchar2 default hr_api.g_varchar2
354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2

Line 358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2

354: ,p_tav_information5 in varchar2 default hr_api.g_varchar2
355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2

Line 359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2

355: ,p_tav_information6 in varchar2 default hr_api.g_varchar2
356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2

Line 360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2

356: ,p_tav_information7 in varchar2 default hr_api.g_varchar2
357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2

Line 361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2

357: ,p_tav_information8 in varchar2 default hr_api.g_varchar2
358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2

Line 362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2

358: ,p_tav_information9 in varchar2 default hr_api.g_varchar2
359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2

Line 363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2

359: ,p_tav_information10 in varchar2 default hr_api.g_varchar2
360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2

Line 364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2

360: ,p_tav_information11 in varchar2 default hr_api.g_varchar2
361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2

Line 365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2

361: ,p_tav_information12 in varchar2 default hr_api.g_varchar2
362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2

Line 366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2

362: ,p_tav_information13 in varchar2 default hr_api.g_varchar2
363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number

Line 367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2

363: ,p_tav_information14 in varchar2 default hr_api.g_varchar2
364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number

Line 368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2

364: ,p_tav_information15 in varchar2 default hr_api.g_varchar2
365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number

Line 369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2

365: ,p_tav_information16 in varchar2 default hr_api.g_varchar2
366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2

Line 370: ,p_inventory_item_id in number default hr_api.g_number

366: ,p_tav_information17 in varchar2 default hr_api.g_varchar2
367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 371: ,p_organization_id in number default hr_api.g_number

367: ,p_tav_information18 in varchar2 default hr_api.g_varchar2
368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number

Line 372: ,p_rco_id in number default hr_api.g_number

368: ,p_tav_information19 in varchar2 default hr_api.g_varchar2
369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num

Line 373: ,p_version_code in varchar2 default hr_api.g_varchar2

369: ,p_tav_information20 in varchar2 default hr_api.g_varchar2
370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2

Line 374: ,p_keywords in varchar2 default hr_api.g_varchar2

370: ,p_inventory_item_id in number default hr_api.g_number
371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2

Line 375: ,p_business_group_id in number default hr_api.g_number

371: ,p_organization_id in number default hr_api.g_number
372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2
379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

Line 376: ,p_validate in number default hr_api.g_false_num

372: ,p_rco_id in number default hr_api.g_number
373: ,p_version_code in varchar2 default hr_api.g_varchar2
374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2
379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
380: ,p_eres_enabled in varchar2 default hr_api.g_varchar2

Line 378: ,p_data_source in varchar2 default hr_api.g_varchar2

374: ,p_keywords in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2
379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
380: ,p_eres_enabled in varchar2 default hr_api.g_varchar2
381: ) is
382: --

Line 379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

375: ,p_business_group_id in number default hr_api.g_number
376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2
379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
380: ,p_eres_enabled in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: -- Variables for API Boolean parameters

Line 380: ,p_eres_enabled in varchar2 default hr_api.g_varchar2

376: ,p_validate in number default hr_api.g_false_num
377: ,p_return_status out nocopy varchar2
378: ,p_data_source in varchar2 default hr_api.g_varchar2
379: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
380: ,p_eres_enabled in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: -- Variables for API Boolean parameters
384: l_validate boolean;

Line 409: hr_api.constant_to_boolean

405: --
406: -- Convert constant values to their corresponding boolean value
407: --
408: l_validate :=
409: hr_api.constant_to_boolean
410: (p_constant_value => p_validate);
411: --
412: -- Register Surrogate ID or user key values
413: --