[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(sum(number_of_places),0)
from ota_delegate_bookings tdb,
ota_finance_lines fin,
ota_booking_status_types bst,
ota_events evt
where fin.booking_deal_id = p_booking_deal_id
and fin.cancelled_flag = 'N'
and fin.booking_id = tdb.booking_id
and tdb.booking_status_type_id = bst.booking_status_type_id
and bst.type in ('P','A','E')
and tdb.event_id = evt.event_id
and ((evt.price_basis = 'C'
and tdb.delegate_contact_id is null
and tdb.customer_id <> p_customer_id
and tdb.event_id <> p_event_id)
or evt.price_basis = 'S');
select number_of_places
from ota_booking_deals
where booking_deal_id = p_booking_deal_id;
,p_update_finance_line in varchar2
,p_tfl_object_version_number in out nocopy number
,p_finance_header_id in number
,p_currency_code in varchar2
,p_standard_amount in number
,p_unitary_amount in number
,p_money_amount in number
,p_booking_deal_id in number
,p_booking_deal_type in varchar2
,p_finance_line_id in out nocopy number
,p_delegate_contact_email in varchar2
) is
--
l_proc varchar2(72) := g_package||'maintain_delegate_bookings';
select type
from ota_booking_status_types
where booking_status_type_id = p_booking_status_type_id;
ota_tdb_api_upd2.update_enrollment (
p_booking_id => p_booking_id
,p_booking_status_type_id => p_booking_status_type_id
,p_date_status_changed => p_date_status_changed
,p_status_change_comments => p_status_change_comments
,p_contact_id => p_booking_contact_id
,p_contact_address_id => p_contact_address_id
,p_delegate_contact_phone => p_delegate_contact_phone
,p_delegate_contact_fax => p_delegate_contact_fax
,p_business_group_id => p_business_group_id
,p_event_id => p_event_id
,p_customer_id => p_customer_id
,p_internal_booking_flag => p_internal_booking_flag
,p_number_of_places => p_number_of_places
,p_object_version_number => p_tdb_object_version_number
,p_source_of_booking => p_source_of_booking
,p_update_finance_line => p_update_finance_line
,p_tfl_object_version_number => p_tfl_object_version_number
,p_finance_header_id => p_finance_header_id
,p_currency_code => p_currency_code
,p_standard_amount => p_standard_amount
,p_unitary_amount => p_unitary_amount
,p_money_amount => p_money_amount
,p_booking_deal_id => p_booking_deal_id
,p_booking_deal_type => p_booking_deal_type
,p_finance_line_id => p_finance_line_id
,p_enrollment_type => 'C'
,p_validate => p_validate
,p_delegate_contact_email => p_delegate_contact_email
);