[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ota_tea_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ota_event_associations
set
event_association_id = p_rec.event_association_id,
event_id = p_rec.event_id,
customer_id = p_rec.customer_id,
organization_id = p_rec.organization_id,
job_id = p_rec.job_id,
position_id = p_rec.position_id,
comments = p_rec.comments,
tea_information_category = p_rec.tea_information_category,
tea_information1 = p_rec.tea_information1,
tea_information2 = p_rec.tea_information2,
tea_information3 = p_rec.tea_information3,
tea_information4 = p_rec.tea_information4,
tea_information5 = p_rec.tea_information5,
tea_information6 = p_rec.tea_information6,
tea_information7 = p_rec.tea_information7,
tea_information8 = p_rec.tea_information8,
tea_information9 = p_rec.tea_information9,
tea_information10 = p_rec.tea_information10,
tea_information11 = p_rec.tea_information11,
tea_information12 = p_rec.tea_information12,
tea_information13 = p_rec.tea_information13,
tea_information14 = p_rec.tea_information14,
tea_information15 = p_rec.tea_information15,
tea_information16 = p_rec.tea_information16,
tea_information17 = p_rec.tea_information17,
tea_information18 = p_rec.tea_information18,
tea_information19 = p_rec.tea_information19,
tea_information20 = p_rec.tea_information20
where event_association_id = p_rec.event_association_id;
End update_dml;
Procedure pre_update(p_rec in ota_tea_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update ( p_business_group_id in number
,p_validate in boolean
,p_price_basis in varchar2
,p_event_id in number
,p_customer_id in number
,p_booking_id in out nocopy number
,p_tdb_object_version_number in out nocopy number
,p_booking_status_type_id in number
,p_date_status_changed in date
,p_status_change_comments in varchar2
,p_booking_contact_id in number
,p_contact_address_id in number
,p_delegate_contact_phone in varchar2
,p_delegate_contact_fax in varchar2
,p_internal_booking_flag in varchar2
,p_source_of_booking in varchar2
,p_number_of_places in number
,p_date_booking_placed in date
,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||'post_update';
if p_update_finance_line in ('C','Y') then
l_cancel_finance_line := (p_update_finance_line = 'C');
,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_delegate_contact_email => p_delegate_contact_email
);
End post_update;
,p_update_finance_line in varchar2
,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||'upd';
ota_tea_bus.update_validate(convert_defs(p_rec)
,p_association_type);
pre_update(p_rec);
update_dml(p_rec);
post_update(
p_business_group_id
,p_validate
,p_price_basis
,p_rec.event_id
,p_rec.customer_id
,p_booking_id
,p_tdb_object_version_number
,p_booking_status_type_id
,p_date_status_changed
,p_status_change_comments
,p_booking_contact_id
,p_contact_address_id
,p_delegate_contact_phone
,p_delegate_contact_fax
,p_internal_booking_flag
,p_source_of_booking
,p_number_of_places
,p_date_booking_placed
,p_update_finance_line
,p_tfl_object_version_number
,p_finance_header_id
,p_currency_code
,p_standard_amount
,p_unitary_amount
,p_money_amount
,p_booking_deal_id
,p_booking_deal_type
,p_finance_line_id
,p_delegate_contact_email
);
,p_update_finance_line in varchar2 default null
,p_finance_header_id in number default null
,p_currency_code in varchar2 default null
,p_standard_amount in number default null
,p_unitary_amount in number default null
,p_money_amount in number default null
,p_booking_deal_id in number default null
,p_booking_deal_type in varchar2 default null
,p_finance_line_id in out nocopy number
,p_delegate_contact_email in varchar2
) is
--
l_rec ota_tea_shd.g_rec_type;
,p_update_finance_line
,p_finance_header_id
,p_currency_code
,p_standard_amount
,p_unitary_amount
,p_money_amount
,p_booking_deal_id
,p_booking_deal_type
,p_finance_line_id
,p_delegate_contact_email
);
,p_update_finance_line in varchar2
,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
begin
upd(
p_event_association_id => p_event_association_id
,p_event_id => p_event_id
,p_customer_id => p_customer_id
,p_organization_id => null
,p_job_id => null
,p_position_id => null
,p_comments => p_comments
,p_tea_information_category => p_tea_information_category
,p_tea_information1 => p_tea_information1
,p_tea_information2 => p_tea_information2
,p_tea_information3 => p_tea_information3
,p_tea_information4 => p_tea_information4
,p_tea_information5 => p_tea_information5
,p_tea_information6 => p_tea_information6
,p_tea_information7 => p_tea_information7
,p_tea_information8 => p_tea_information8
,p_tea_information9 => p_tea_information9
,p_tea_information10 => p_tea_information10
,p_tea_information11 => p_tea_information11
,p_tea_information12 => p_tea_information12
,p_tea_information13 => p_tea_information13
,p_tea_information14 => p_tea_information14
,p_tea_information15 => p_tea_information15
,p_tea_information16 => p_tea_information16
,p_tea_information17 => p_tea_information17
,p_tea_information18 => p_tea_information18
,p_tea_information19 => p_tea_information19
,p_tea_information20 => p_tea_information20
,p_validate => p_validate
,p_association_type => 'C'
,p_business_group_id => p_business_group_id
,p_price_basis => p_price_basis
,p_booking_id => p_booking_id
,p_tdb_object_version_number => p_tdb_object_version_number
,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_booking_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_internal_booking_flag => p_internal_booking_flag
,p_source_of_booking => p_source_of_booking
,p_number_of_places => p_number_of_places
,p_date_booking_placed => p_date_booking_placed
,p_tfl_object_version_number => p_tfl_object_version_number
,p_update_finance_line => p_update_finance_line
,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_delegate_contact_email => p_delegate_contact_email
);
,p_update_finance_line => null
,p_finance_header_id => null
,p_currency_code => null
,p_standard_amount => null
,p_unitary_amount => null
,p_money_amount => null
,p_booking_deal_id => null
,p_booking_deal_type => null
,p_finance_line_id => l_finance_line_id
,p_delegate_contact_email => null
);