[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_resource_booking
(p_resource_booking_id in number
,p_object_version_number in number
,p_validate in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_resource_booking';
savepoint delete_resource_booking_swi;
ota_resource_booking_api.delete_resource_booking
(p_resource_booking_id => p_resource_booking_id
,p_object_version_number => p_object_version_number
,p_validate => l_validate
);
rollback to delete_resource_booking_swi;
rollback to delete_resource_booking_swi;
end delete_resource_booking;
PROCEDURE update_resource_booking
(p_effective_date in date
,p_supplied_resource_id in number
,p_date_booking_placed in date
,p_status in varchar2
,p_event_id in number default hr_api.g_number
,p_absolute_price in number default hr_api.g_number
,p_booking_person_id in number default hr_api.g_number
,p_comments in varchar2 default hr_api.g_varchar2
,p_contact_name in varchar2 default hr_api.g_varchar2
,p_contact_phone_number in varchar2 default hr_api.g_varchar2
,p_delegates_per_unit in number default hr_api.g_number
,p_quantity in number default hr_api.g_number
,p_required_date_from in date default hr_api.g_date
,p_required_date_to in date default hr_api.g_date
,p_required_end_time in varchar2 default hr_api.g_varchar2
,p_required_start_time in varchar2 default hr_api.g_varchar2
,p_deliver_to in varchar2 default hr_api.g_varchar2
,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
,p_role_to_play in varchar2 default hr_api.g_varchar2
,p_trb_information_category in varchar2 default hr_api.g_varchar2
,p_trb_information1 in varchar2 default hr_api.g_varchar2
,p_trb_information2 in varchar2 default hr_api.g_varchar2
,p_trb_information3 in varchar2 default hr_api.g_varchar2
,p_trb_information4 in varchar2 default hr_api.g_varchar2
,p_trb_information5 in varchar2 default hr_api.g_varchar2
,p_trb_information6 in varchar2 default hr_api.g_varchar2
,p_trb_information7 in varchar2 default hr_api.g_varchar2
,p_trb_information8 in varchar2 default hr_api.g_varchar2
,p_trb_information9 in varchar2 default hr_api.g_varchar2
,p_trb_information10 in varchar2 default hr_api.g_varchar2
,p_trb_information11 in varchar2 default hr_api.g_varchar2
,p_trb_information12 in varchar2 default hr_api.g_varchar2
,p_trb_information13 in varchar2 default hr_api.g_varchar2
,p_trb_information14 in varchar2 default hr_api.g_varchar2
,p_trb_information15 in varchar2 default hr_api.g_varchar2
,p_trb_information16 in varchar2 default hr_api.g_varchar2
,p_trb_information17 in varchar2 default hr_api.g_varchar2
,p_trb_information18 in varchar2 default hr_api.g_varchar2
,p_trb_information19 in varchar2 default hr_api.g_varchar2
,p_trb_information20 in varchar2 default hr_api.g_varchar2
,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
-- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
,p_chat_id in number
,p_forum_id in number
,p_validate in number
,p_resource_booking_id in number
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
,p_finance_header_id in number default null
,p_currency_code in varchar2 default null
,p_money_amount in number default null
,p_finance_line_id in out nocopy number
,p_finance_line_transfer in varchar2 default null
,p_finance_line_ovn in out nocopy number
,p_cancel_finance_line in varchar2 default null
,p_finance_change_flag in varchar2 default 'N'
,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_resource_booking';
savepoint update_resource_booking_swi;
ota_resource_booking_api.update_resource_booking
(p_effective_date => p_effective_date
,p_supplied_resource_id => p_supplied_resource_id
,p_date_booking_placed => p_date_booking_placed
,p_status => p_status
,p_event_id => p_event_id
,p_absolute_price => p_absolute_price
,p_booking_person_id => p_booking_person_id
,p_comments => p_comments
,p_contact_name => p_contact_name
,p_contact_phone_number => p_contact_phone_number
,p_delegates_per_unit => p_delegates_per_unit
,p_quantity => p_quantity
,p_required_date_from => p_required_date_from
,p_required_date_to => p_required_date_to
,p_required_end_time => p_required_end_time
,p_required_start_time => p_required_start_time
,p_deliver_to => p_deliver_to
,p_primary_venue_flag => p_primary_venue_flag
,p_role_to_play => p_role_to_play
,p_trb_information_category => p_trb_information_category
,p_trb_information1 => p_trb_information1
,p_trb_information2 => p_trb_information2
,p_trb_information3 => p_trb_information3
,p_trb_information4 => p_trb_information4
,p_trb_information5 => p_trb_information5
,p_trb_information6 => p_trb_information6
,p_trb_information7 => p_trb_information7
,p_trb_information8 => p_trb_information8
,p_trb_information9 => p_trb_information9
,p_trb_information10 => p_trb_information10
,p_trb_information11 => p_trb_information11
,p_trb_information12 => p_trb_information12
,p_trb_information13 => p_trb_information13
,p_trb_information14 => p_trb_information14
,p_trb_information15 => p_trb_information15
,p_trb_information16 => p_trb_information16
,p_trb_information17 => p_trb_information17
,p_trb_information18 => p_trb_information18
,p_trb_information19 => p_trb_information19
,p_trb_information20 => p_trb_information20
,p_display_to_learner_flag => p_display_to_learner_flag
,p_book_entire_period_flag => p_book_entire_period_flag
-- ,p_unbook_request_flag => p_unbook_request_flag
,p_chat_id => p_chat_id
,p_forum_id => p_forum_id
,p_validate => l_validate
,p_resource_booking_id => p_resource_booking_id
,p_object_version_number => p_object_version_number
,p_timezone_code => p_timezone_code
);
rollback to update_resource_booking_swi;
rollback to update_resource_booking_swi;
end update_resource_booking;