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_EVENT_SWI dependencies on HR_API

Line 79: ,p_validate in number default hr_api.g_false_num

75: ,p_location_id in number default null
76: ,p_offering_id in number default null
77: ,p_timezone in varchar2 default null
78: ,p_parent_offering_id in number
79: ,p_validate in number default hr_api.g_false_num
80: ,p_return_status out nocopy varchar2
81: ,p_data_source in varchar2 default null
82: ) is
83: --

Line 109: hr_api.constant_to_boolean

105: --
106: -- Convert constant values to their corresponding boolean value
107: --
108: l_validate :=
109: hr_api.constant_to_boolean
110: (p_constant_value => p_validate);
111:
112: -- Ignore dff validation
113:

Line 256: (p_validate in number default hr_api.g_false_num

252: -- ----------------------------------------------------------------------------
253: -- |-----------------------------< delete_event >-----------------------------|
254: -- ----------------------------------------------------------------------------
255: PROCEDURE delete_event
256: (p_validate in number default hr_api.g_false_num
257: ,p_event_id in number
258: ,p_object_version_number in number
259: ,p_return_status out nocopy varchar2
260: ) is

Line 286: hr_api.constant_to_boolean

282: --
283: -- Convert constant values to their corresponding boolean value
284: --
285: l_validate :=
286: hr_api.constant_to_boolean
287: (p_constant_value => p_validate);
288: --
289: -- Register Surrogate ID or user key values
290: --

Line 352: ,p_vendor_id in number default hr_api.g_number

348: -- ----------------------------------------------------------------------------
349: PROCEDURE update_event
350: (p_event_id in number
351: ,p_effective_date in date default trunc(sysdate)
352: ,p_vendor_id in number default hr_api.g_number
353: ,p_activity_version_id in number default hr_api.g_number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2

Line 353: ,p_activity_version_id in number default hr_api.g_number

349: PROCEDURE update_event
350: (p_event_id in number
351: ,p_effective_date in date default trunc(sysdate)
352: ,p_vendor_id in number default hr_api.g_number
353: ,p_activity_version_id in number default hr_api.g_number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number

Line 354: ,p_business_group_id in number default hr_api.g_number

350: (p_event_id in number
351: ,p_effective_date in date default trunc(sysdate)
352: ,p_vendor_id in number default hr_api.g_number
353: ,p_activity_version_id in number default hr_api.g_number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2

Line 355: ,p_organization_id in number default hr_api.g_number

351: ,p_effective_date in date default trunc(sysdate)
352: ,p_vendor_id in number default hr_api.g_number
353: ,p_activity_version_id in number default hr_api.g_number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number

Line 356: ,p_event_type in varchar2 default hr_api.g_varchar2

352: ,p_vendor_id in number default hr_api.g_number
353: ,p_activity_version_id in number default hr_api.g_number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number

Line 358: ,p_title in varchar2 default hr_api.g_varchar2

354: ,p_business_group_id in number default hr_api.g_number
355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2

Line 359: ,p_budget_cost in number default hr_api.g_number

355: ,p_organization_id in number default hr_api.g_number
356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2

Line 360: ,p_actual_cost in number default hr_api.g_number

356: ,p_event_type in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date

Line 361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

357: ,p_object_version_number in out nocopy number
358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2

Line 362: ,p_centre in varchar2 default hr_api.g_varchar2

358: ,p_title in varchar2 default hr_api.g_varchar2
359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date

Line 363: ,p_comments in varchar2 default hr_api.g_varchar2

359: ,p_budget_cost in number default hr_api.g_number
360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2

Line 364: ,p_course_end_date in date default hr_api.g_date

360: ,p_actual_cost in number default hr_api.g_number
361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number

Line 365: ,p_course_end_time in varchar2 default hr_api.g_varchar2

361: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 366: ,p_course_start_date in date default hr_api.g_date

362: ,p_centre in varchar2 default hr_api.g_varchar2
363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date

Line 367: ,p_course_start_time in varchar2 default hr_api.g_varchar2

363: ,p_comments in varchar2 default hr_api.g_varchar2
364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date

Line 368: ,p_duration in number default hr_api.g_number

364: ,p_course_end_date in date default hr_api.g_date
365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number

Line 369: ,p_duration_units in varchar2 default hr_api.g_varchar2

365: ,p_course_end_time in varchar2 default hr_api.g_varchar2
366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2

Line 370: ,p_enrolment_end_date in date default hr_api.g_date

366: ,p_course_start_date in date default hr_api.g_date
367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2

Line 371: ,p_enrolment_start_date in date default hr_api.g_date

367: ,p_course_start_time in varchar2 default hr_api.g_varchar2
368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2

Line 372: ,p_language_id in number default hr_api.g_number

368: ,p_duration in number default hr_api.g_number
369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2

Line 373: ,p_user_status in varchar2 default hr_api.g_varchar2

369: ,p_duration_units in varchar2 default hr_api.g_varchar2
370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 374: ,p_development_event_type in varchar2 default hr_api.g_varchar2

370: ,p_enrolment_end_date in date default hr_api.g_date
371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number

Line 375: ,p_event_status in varchar2 default hr_api.g_varchar2

371: ,p_enrolment_start_date in date default hr_api.g_date
372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number

Line 376: ,p_price_basis in varchar2 default hr_api.g_varchar2

372: ,p_language_id in number default hr_api.g_number
373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number

Line 377: ,p_currency_code in varchar2 default hr_api.g_varchar2

373: ,p_user_status in varchar2 default hr_api.g_varchar2
374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number

Line 378: ,p_maximum_attendees in number default hr_api.g_number

374: ,p_development_event_type in varchar2 default hr_api.g_varchar2
375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2

Line 379: ,p_maximum_internal_attendees in number default hr_api.g_number

375: ,p_event_status in varchar2 default hr_api.g_varchar2
376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number

Line 380: ,p_minimum_attendees in number default hr_api.g_number

376: ,p_price_basis in varchar2 default hr_api.g_varchar2
377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2

Line 381: ,p_standard_price in number default hr_api.g_number

377: ,p_currency_code in varchar2 default hr_api.g_varchar2
378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2

Line 382: ,p_category_code in varchar2 default hr_api.g_varchar2

378: ,p_maximum_attendees in number default hr_api.g_number
379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2

Line 383: ,p_parent_event_id in number default hr_api.g_number

379: ,p_maximum_internal_attendees in number default hr_api.g_number
380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2

Line 384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2

380: ,p_minimum_attendees in number default hr_api.g_number
381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2

Line 385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2

381: ,p_standard_price in number default hr_api.g_number
382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2

Line 386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2

382: ,p_category_code in varchar2 default hr_api.g_varchar2
383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2

Line 387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2

383: ,p_parent_event_id in number default hr_api.g_number
384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2

Line 388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2

384: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2
385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2

Line 389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2

385: ,p_public_event_flag in varchar2 default hr_api.g_varchar2
386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2

Line 390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2

386: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2
387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2

Line 391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2

387: ,p_evt_information_category in varchar2 default hr_api.g_varchar2
388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2

Line 392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2

388: ,p_evt_information1 in varchar2 default hr_api.g_varchar2
389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2

Line 393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2

389: ,p_evt_information2 in varchar2 default hr_api.g_varchar2
390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2

Line 394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2

390: ,p_evt_information3 in varchar2 default hr_api.g_varchar2
391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2

Line 395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2

391: ,p_evt_information4 in varchar2 default hr_api.g_varchar2
392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2

Line 396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2

392: ,p_evt_information5 in varchar2 default hr_api.g_varchar2
393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2

Line 397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2

393: ,p_evt_information6 in varchar2 default hr_api.g_varchar2
394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2

Line 398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2

394: ,p_evt_information7 in varchar2 default hr_api.g_varchar2
395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2

Line 399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2

395: ,p_evt_information8 in varchar2 default hr_api.g_varchar2
396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2

Line 400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2

396: ,p_evt_information9 in varchar2 default hr_api.g_varchar2
397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2

Line 401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2

397: ,p_evt_information10 in varchar2 default hr_api.g_varchar2
398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2

Line 402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2

398: ,p_evt_information11 in varchar2 default hr_api.g_varchar2
399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2

Line 403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2

399: ,p_evt_information12 in varchar2 default hr_api.g_varchar2
400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2

Line 404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2

400: ,p_evt_information13 in varchar2 default hr_api.g_varchar2
401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number

Line 405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2

401: ,p_evt_information14 in varchar2 default hr_api.g_varchar2
402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number

Line 406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2

402: ,p_evt_information15 in varchar2 default hr_api.g_varchar2
403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number

Line 407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2

403: ,p_evt_information16 in varchar2 default hr_api.g_varchar2
404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number

Line 408: ,p_project_id in number default hr_api.g_number

404: ,p_evt_information17 in varchar2 default hr_api.g_varchar2
405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number

Line 409: ,p_owner_id in number default hr_api.g_number

405: ,p_evt_information18 in varchar2 default hr_api.g_varchar2
406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number

Line 410: ,p_line_id in number default hr_api.g_number

406: ,p_evt_information19 in varchar2 default hr_api.g_varchar2
407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number

Line 411: ,p_org_id in number default hr_api.g_number

407: ,p_evt_information20 in varchar2 default hr_api.g_varchar2
408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2

Line 412: ,p_training_center_id in number default hr_api.g_number

408: ,p_project_id in number default hr_api.g_number
409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number

Line 413: ,p_location_id in number default hr_api.g_number

409: ,p_owner_id in number default hr_api.g_number
410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num

Line 414: ,p_offering_id in number default hr_api.g_number

410: ,p_line_id in number default hr_api.g_number
411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num
418: ,p_return_status out nocopy varchar2

Line 415: ,p_timezone in varchar2 default hr_api.g_varchar2

411: ,p_org_id in number default hr_api.g_number
412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num
418: ,p_return_status out nocopy varchar2
419: ,p_data_source in varchar2 default hr_api.g_varchar2

Line 416: ,p_parent_offering_id in number default hr_api.g_number

412: ,p_training_center_id in number default hr_api.g_number
413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num
418: ,p_return_status out nocopy varchar2
419: ,p_data_source in varchar2 default hr_api.g_varchar2
420: ) is

Line 417: ,p_validate in number default hr_api.g_false_num

413: ,p_location_id in number default hr_api.g_number
414: ,p_offering_id in number default hr_api.g_number
415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num
418: ,p_return_status out nocopy varchar2
419: ,p_data_source in varchar2 default hr_api.g_varchar2
420: ) is
421: --

Line 419: ,p_data_source in varchar2 default hr_api.g_varchar2

415: ,p_timezone in varchar2 default hr_api.g_varchar2
416: ,p_parent_offering_id in number default hr_api.g_number
417: ,p_validate in number default hr_api.g_false_num
418: ,p_return_status out nocopy varchar2
419: ,p_data_source in varchar2 default hr_api.g_varchar2
420: ) is
421: --
422: -- Variables for API Boolean parameters
423: l_validate boolean;

Line 448: hr_api.constant_to_boolean

444: --
445: -- Convert constant values to their corresponding boolean value
446: --
447: l_validate :=
448: hr_api.constant_to_boolean
449: (p_constant_value => p_validate);
450: --
451: -- Register Surrogate ID or user key values
452: --

Line 661: p_validate in number default hr_api.g_false_num,

657: p_event in varchar2,
658: p_event_id in number,
659: p_object_version_number in out nocopy number,
660: p_event_status in out nocopy varchar2,
661: p_validate in number default hr_api.g_false_num,
662: p_reset_max_attendees in number default hr_api.g_false_num,
663: p_update_finance_line in varchar2 default 'N',
664: p_booking_status_type_id in number default null,
665: p_date_status_changed in date default null,

Line 662: p_reset_max_attendees in number default hr_api.g_false_num,

658: p_event_id in number,
659: p_object_version_number in out nocopy number,
660: p_event_status in out nocopy varchar2,
661: p_validate in number default hr_api.g_false_num,
662: p_reset_max_attendees in number default hr_api.g_false_num,
663: p_update_finance_line in varchar2 default 'N',
664: p_booking_status_type_id in number default null,
665: p_date_status_changed in date default null,
666: p_maximum_attendees in number default null,

Line 745: l_validate := hr_api.constant_to_boolean

741: END IF;
742:
743: end if;
744:
745: l_validate := hr_api.constant_to_boolean
746: (p_constant_value => p_validate);
747:
748: l_reset_max_attendees := hr_api.constant_to_boolean
749: (p_constant_value => p_reset_max_attendees);

Line 748: l_reset_max_attendees := hr_api.constant_to_boolean

744:
745: l_validate := hr_api.constant_to_boolean
746: (p_constant_value => p_validate);
747:
748: l_reset_max_attendees := hr_api.constant_to_boolean
749: (p_constant_value => p_reset_max_attendees);
750:
751: OTA_EVT_API_UPD2.UPDATE_EVENT (
752: P_EVENT => p_event,