DBA Data[Home] [Help]

APPS.OTA_RESOURCE_BOOKING_SWI dependencies on HR_API

Line 96: hr_api.constant_to_boolean

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

Line 260: hr_api.constant_to_boolean

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

Line 328: ,p_event_id in number default hr_api.g_number

324: (p_effective_date in date
325: ,p_supplied_resource_id in number
326: ,p_date_booking_placed in date
327: ,p_status in varchar2
328: ,p_event_id in number default hr_api.g_number
329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2

Line 329: ,p_absolute_price in number default hr_api.g_number

325: ,p_supplied_resource_id in number
326: ,p_date_booking_placed in date
327: ,p_status in varchar2
328: ,p_event_id in number default hr_api.g_number
329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2

Line 330: ,p_booking_person_id in number default hr_api.g_number

326: ,p_date_booking_placed in date
327: ,p_status in varchar2
328: ,p_event_id in number default hr_api.g_number
329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number

Line 331: ,p_comments in varchar2 default hr_api.g_varchar2

327: ,p_status in varchar2
328: ,p_event_id in number default hr_api.g_number
329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number

Line 332: ,p_contact_name in varchar2 default hr_api.g_varchar2

328: ,p_event_id in number default hr_api.g_number
329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date

Line 333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2

329: ,p_absolute_price in number default hr_api.g_number
330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date

Line 334: ,p_delegates_per_unit in number default hr_api.g_number

330: ,p_booking_person_id in number default hr_api.g_number
331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2

Line 335: ,p_quantity in number default hr_api.g_number

331: ,p_comments in varchar2 default hr_api.g_varchar2
332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2

Line 336: ,p_required_date_from in date default hr_api.g_date

332: ,p_contact_name in varchar2 default hr_api.g_varchar2
333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2

Line 337: ,p_required_date_to in date default hr_api.g_date

333: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2

Line 338: ,p_required_end_time in varchar2 default hr_api.g_varchar2

334: ,p_delegates_per_unit in number default hr_api.g_number
335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2

Line 339: ,p_required_start_time in varchar2 default hr_api.g_varchar2

335: ,p_quantity in number default hr_api.g_number
336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2

Line 340: ,p_deliver_to in varchar2 default hr_api.g_varchar2

336: ,p_required_date_from in date default hr_api.g_date
337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2

Line 341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2

337: ,p_required_date_to in date default hr_api.g_date
338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2

Line 342: ,p_role_to_play in varchar2 default hr_api.g_varchar2

338: ,p_required_end_time in varchar2 default hr_api.g_varchar2
339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2

Line 343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2

339: ,p_required_start_time in varchar2 default hr_api.g_varchar2
340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2

Line 344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2

340: ,p_deliver_to in varchar2 default hr_api.g_varchar2
341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2

Line 345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2

341: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2

Line 346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2

342: ,p_role_to_play in varchar2 default hr_api.g_varchar2
343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2

Line 347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2

343: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2

Line 348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2

344: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2

Line 349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2

345: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2

Line 350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2

346: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2

Line 351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2

347: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2

Line 352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2

348: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2

Line 353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2

349: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2

Line 354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2

350: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2

Line 355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2

351: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2

Line 356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2

352: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2

Line 357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2

353: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2

Line 358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2

354: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2

Line 359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2

355: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2

Line 360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2

356: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

Line 361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2

357: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2

Line 362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2

358: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2

Line 363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2

359: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
367: ,p_chat_id in number

Line 364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

360: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
367: ,p_chat_id in number
368: ,p_forum_id in number

Line 365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2

361: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
367: ,p_chat_id in number
368: ,p_forum_id in number
369: ,p_validate in number

Line 366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2

362: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
364: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
365: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
366: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
367: ,p_chat_id in number
368: ,p_forum_id in number
369: ,p_validate in number
370: ,p_resource_booking_id in number

Line 381: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

377: ,p_finance_line_transfer in varchar2 default null
378: ,p_finance_line_ovn in out nocopy number
379: ,p_cancel_finance_line in varchar2 default null
380: ,p_finance_change_flag in varchar2 default 'N'
381: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
382: ) is
383: --
384: -- Variables for API Boolean parameters
385: l_validate boolean;

Line 411: hr_api.constant_to_boolean

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

Line 592: l_end_of_time := hr_api.g_eot;

588: Begin
589: --
590: hr_utility.set_location(' Entering:' || l_proc,10);
591: --
592: l_end_of_time := hr_api.g_eot;
593: --
594: ota_trb_api_procedures.check_trainer_competence
595: (p_event_id => p_event_id
596: ,p_supplied_resource_id => p_supplied_resource_id