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: ,p_event_availability in varchar2 default null
83: ) is

Line 110: hr_api.constant_to_boolean

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

Line 258: (p_validate in number default hr_api.g_false_num

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

Line 288: hr_api.constant_to_boolean

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

Line 354: ,p_vendor_id in number default hr_api.g_number

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

Line 355: ,p_activity_version_id in number default hr_api.g_number

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

Line 356: ,p_business_group_id in number default hr_api.g_number

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

Line 357: ,p_organization_id in number default hr_api.g_number

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

Line 358: ,p_event_type in varchar2 default hr_api.g_varchar2

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

Line 360: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 361: ,p_budget_cost in number default hr_api.g_number

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

Line 362: ,p_actual_cost in number default hr_api.g_number

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

Line 363: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

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

Line 364: ,p_centre in varchar2 default hr_api.g_varchar2

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

Line 365: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 366: ,p_course_end_date in date default hr_api.g_date

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

Line 367: ,p_course_end_time in varchar2 default hr_api.g_varchar2

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

Line 368: ,p_course_start_date in date default hr_api.g_date

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

Line 369: ,p_course_start_time in varchar2 default hr_api.g_varchar2

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

Line 370: ,p_duration in number default hr_api.g_number

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

Line 371: ,p_duration_units in varchar2 default hr_api.g_varchar2

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

Line 372: ,p_enrolment_end_date in date default hr_api.g_date

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

Line 373: ,p_enrolment_start_date in date default hr_api.g_date

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

Line 374: ,p_language_id in number default hr_api.g_number

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

Line 375: ,p_user_status in varchar2 default hr_api.g_varchar2

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

Line 376: ,p_development_event_type in varchar2 default hr_api.g_varchar2

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

Line 377: ,p_event_status in varchar2 default hr_api.g_varchar2

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

Line 378: ,p_price_basis in varchar2 default hr_api.g_varchar2

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

Line 379: ,p_currency_code in varchar2 default hr_api.g_varchar2

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

Line 380: ,p_maximum_attendees in number default hr_api.g_number

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

Line 381: ,p_maximum_internal_attendees in number default hr_api.g_number

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

Line 382: ,p_minimum_attendees in number default hr_api.g_number

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

Line 383: ,p_standard_price in number default hr_api.g_number

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

Line 384: ,p_category_code in varchar2 default hr_api.g_varchar2

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

Line 385: ,p_parent_event_id in number default hr_api.g_number

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

Line 386: ,p_book_independent_flag in varchar2 default hr_api.g_varchar2

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

Line 387: ,p_public_event_flag in varchar2 default hr_api.g_varchar2

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

Line 388: ,p_secure_event_flag in varchar2 default hr_api.g_varchar2

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

Line 389: ,p_evt_information_category in varchar2 default hr_api.g_varchar2

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

Line 390: ,p_evt_information1 in varchar2 default hr_api.g_varchar2

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

Line 391: ,p_evt_information2 in varchar2 default hr_api.g_varchar2

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

Line 392: ,p_evt_information3 in varchar2 default hr_api.g_varchar2

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

Line 393: ,p_evt_information4 in varchar2 default hr_api.g_varchar2

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

Line 394: ,p_evt_information5 in varchar2 default hr_api.g_varchar2

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

Line 395: ,p_evt_information6 in varchar2 default hr_api.g_varchar2

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

Line 396: ,p_evt_information7 in varchar2 default hr_api.g_varchar2

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

Line 397: ,p_evt_information8 in varchar2 default hr_api.g_varchar2

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

Line 398: ,p_evt_information9 in varchar2 default hr_api.g_varchar2

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

Line 399: ,p_evt_information10 in varchar2 default hr_api.g_varchar2

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

Line 400: ,p_evt_information11 in varchar2 default hr_api.g_varchar2

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

Line 401: ,p_evt_information12 in varchar2 default hr_api.g_varchar2

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

Line 402: ,p_evt_information13 in varchar2 default hr_api.g_varchar2

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

Line 403: ,p_evt_information14 in varchar2 default hr_api.g_varchar2

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

Line 404: ,p_evt_information15 in varchar2 default hr_api.g_varchar2

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

Line 405: ,p_evt_information16 in varchar2 default hr_api.g_varchar2

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

Line 406: ,p_evt_information17 in varchar2 default hr_api.g_varchar2

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

Line 407: ,p_evt_information18 in varchar2 default hr_api.g_varchar2

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

Line 408: ,p_evt_information19 in varchar2 default hr_api.g_varchar2

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

Line 409: ,p_evt_information20 in varchar2 default hr_api.g_varchar2

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

Line 410: ,p_project_id in number default hr_api.g_number

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

Line 411: ,p_owner_id in number default hr_api.g_number

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

Line 412: ,p_line_id in number default hr_api.g_number

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

Line 413: ,p_org_id in number default hr_api.g_number

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

Line 414: ,p_training_center_id in number default hr_api.g_number

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

Line 415: ,p_location_id in number default hr_api.g_number

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

Line 416: ,p_offering_id in number default hr_api.g_number

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

Line 417: ,p_timezone in varchar2 default hr_api.g_varchar2

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

Line 418: ,p_parent_offering_id in number default hr_api.g_number

414: ,p_training_center_id in number default hr_api.g_number
415: ,p_location_id in number default hr_api.g_number
416: ,p_offering_id in number default hr_api.g_number
417: ,p_timezone in varchar2 default hr_api.g_varchar2
418: ,p_parent_offering_id in number default hr_api.g_number
419: ,p_validate in number default hr_api.g_false_num
420: ,p_return_status out nocopy varchar2
421: ,p_data_source in varchar2 default hr_api.g_varchar2
422: ,p_event_availability in varchar2 default null

Line 419: ,p_validate in number default hr_api.g_false_num

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

Line 421: ,p_data_source in varchar2 default hr_api.g_varchar2

417: ,p_timezone in varchar2 default hr_api.g_varchar2
418: ,p_parent_offering_id in number default hr_api.g_number
419: ,p_validate in number default hr_api.g_false_num
420: ,p_return_status out nocopy varchar2
421: ,p_data_source in varchar2 default hr_api.g_varchar2
422: ,p_event_availability in varchar2 default null
423: ) is
424: --
425: -- Variables for API Boolean parameters

Line 451: hr_api.constant_to_boolean

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

Line 665: p_validate in number default hr_api.g_false_num,

661: p_event in varchar2,
662: p_event_id in number,
663: p_object_version_number in out nocopy number,
664: p_event_status in out nocopy varchar2,
665: p_validate in number default hr_api.g_false_num,
666: p_reset_max_attendees in number default hr_api.g_false_num,
667: p_update_finance_line in varchar2 default 'N',
668: p_booking_status_type_id in number default null,
669: p_date_status_changed in date default null,

Line 666: p_reset_max_attendees in number default hr_api.g_false_num,

662: p_event_id in number,
663: p_object_version_number in out nocopy number,
664: p_event_status in out nocopy varchar2,
665: p_validate in number default hr_api.g_false_num,
666: p_reset_max_attendees in number default hr_api.g_false_num,
667: p_update_finance_line in varchar2 default 'N',
668: p_booking_status_type_id in number default null,
669: p_date_status_changed in date default null,
670: p_maximum_attendees in number default null,

Line 749: l_validate := hr_api.constant_to_boolean

745: END IF;
746:
747: end if;
748:
749: l_validate := hr_api.constant_to_boolean
750: (p_constant_value => p_validate);
751:
752: l_reset_max_attendees := hr_api.constant_to_boolean
753: (p_constant_value => p_reset_max_attendees);

Line 752: l_reset_max_attendees := hr_api.constant_to_boolean

748:
749: l_validate := hr_api.constant_to_boolean
750: (p_constant_value => p_validate);
751:
752: l_reset_max_attendees := hr_api.constant_to_boolean
753: (p_constant_value => p_reset_max_attendees);
754:
755: OTA_EVT_API_UPD2.UPDATE_EVENT (
756: P_EVENT => p_event,