[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ota_tdb_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ota_delegate_bookings
set
booking_id = p_rec.booking_id,
booking_status_type_id = p_rec.booking_status_type_id,
delegate_person_id = p_rec.delegate_person_id,
contact_id = p_rec.contact_id,
business_group_id = p_rec.business_group_id,
event_id = p_rec.event_id,
customer_id = p_rec.customer_id,
authorizer_person_id = p_rec.authorizer_person_id,
date_booking_placed = p_rec.date_booking_placed,
corespondent = p_rec.corespondent,
internal_booking_flag = p_rec.internal_booking_flag,
number_of_places = p_rec.number_of_places,
object_version_number = p_rec.object_version_number,
administrator = p_rec.administrator,
booking_priority = p_rec.booking_priority,
comments = p_rec.comments,
contact_address_id = p_rec.contact_address_id,
delegate_contact_phone = p_rec.delegate_contact_phone,
delegate_contact_fax = p_rec.delegate_contact_fax,
third_party_customer_id = p_rec.third_party_customer_id,
third_party_contact_id = p_rec.third_party_contact_id,
third_party_address_id = p_rec.third_party_address_id,
third_party_contact_phone = p_rec.third_party_contact_phone,
third_party_contact_fax = p_rec.third_party_contact_fax,
date_status_changed = p_rec.date_status_changed,
failure_reason = p_rec.failure_reason,
attendance_result = p_rec.attendance_result,
language_id = p_rec.language_id,
source_of_booking = p_rec.source_of_booking,
special_booking_instructions = p_rec.special_booking_instructions,
successful_attendance_flag = p_rec.successful_attendance_flag,
tdb_information_category = p_rec.tdb_information_category,
tdb_information1 = p_rec.tdb_information1,
tdb_information2 = p_rec.tdb_information2,
tdb_information3 = p_rec.tdb_information3,
tdb_information4 = p_rec.tdb_information4,
tdb_information5 = p_rec.tdb_information5,
tdb_information6 = p_rec.tdb_information6,
tdb_information7 = p_rec.tdb_information7,
tdb_information8 = p_rec.tdb_information8,
tdb_information9 = p_rec.tdb_information9,
tdb_information10 = p_rec.tdb_information10,
tdb_information11 = p_rec.tdb_information11,
tdb_information12 = p_rec.tdb_information12,
tdb_information13 = p_rec.tdb_information13,
tdb_information14 = p_rec.tdb_information14,
tdb_information15 = p_rec.tdb_information15,
tdb_information16 = p_rec.tdb_information16,
tdb_information17 = p_rec.tdb_information17,
tdb_information18 = p_rec.tdb_information18,
tdb_information19 = p_rec.tdb_information19,
tdb_information20 = p_rec.tdb_information20,
organization_id = p_rec.organization_id,
sponsor_person_id = p_rec.sponsor_person_id,
sponsor_assignment_id = p_rec.sponsor_assignment_id,
person_address_id = p_rec.person_address_id,
delegate_assignment_id = p_rec.delegate_assignment_id,
delegate_contact_id = p_rec.delegate_contact_id,
delegate_contact_email = p_rec.delegate_contact_email,
third_party_email = p_rec.third_party_email,
person_address_type = p_rec.person_address_type,
line_id = p_rec.line_id,
org_id = p_rec.org_id,
daemon_flag = p_rec.daemon_flag,
daemon_type = p_rec.daemon_type,
old_event_id = p_rec.old_event_id,
quote_line_id = p_rec.quote_line_id,
interface_source = p_rec.interface_source,
total_training_time = p_rec.total_training_time,
content_player_status = p_rec.content_player_status,
score = p_rec.score,
completed_content = p_rec.completed_content,
total_content = p_rec.total_content,
booking_justification_id = p_rec.booking_justification_id,
is_history_flag = p_rec.is_history_flag,
sign_eval_status = p_rec.sign_eval_status
where booking_id = p_rec.booking_id;
End update_dml;
Procedure pre_update(p_rec in ota_tdb_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in ota_tdb_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
p_update_finance_line in varchar2,
p_tfl_object_version_number in out nocopy number,
p_finance_header_id in number,
p_finance_line_id in out nocopy number,
p_standard_amount in number,
p_unitary_amount in number,
p_money_amount in number,
p_currency_code in varchar2,
p_booking_deal_type in varchar2,
p_booking_deal_id in number,
p_enrollment_type in varchar2,
p_validate in boolean
) is
--
l_proc varchar2(72) := g_package||'upd';
ota_tdb_bus.update_validate(convert_defs(p_rec),p_enrollment_type);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
p_update_finance_line in varchar2 ,
p_tfl_object_version_number in out nocopy number,
p_finance_header_id in number ,
p_finance_line_id in out nocopy number,
p_standard_amount in number ,
p_unitary_amount in number ,
p_money_amount in number ,
p_currency_code in varchar2 ,
p_booking_deal_type in varchar2 ,
p_booking_deal_id in number ,
p_enrollment_type in varchar2 ,
p_validate in boolean ,
p_organization_id in number ,
p_sponsor_person_id in number ,
p_sponsor_assignment_id in number ,
p_person_address_id in number ,
p_delegate_assignment_id in number ,
p_delegate_contact_id in number ,
p_delegate_contact_email in varchar2 ,
p_third_party_email in varchar2 ,
p_person_address_type in varchar2 ,
p_line_id in number ,
p_org_id in number ,
p_daemon_flag in varchar2 ,
p_daemon_type in varchar2 ,
p_old_event_id in number ,
p_quote_line_id in number ,
p_interface_source in varchar2 ,
p_total_training_time in varchar2 ,
p_content_player_status in varchar2 ,
p_score in number ,
p_completed_content in number ,
p_total_content in number ,
p_booking_justification_id in number,
p_is_history_flag in varchar2,
p_sign_eval_status in varchar2
) is
--
l_rec ota_tdb_shd.g_rec_type;
p_update_finance_line,
p_tfl_object_version_number,
p_finance_header_id,
p_finance_line_id ,
p_standard_amount,
p_unitary_amount ,
p_money_amount ,
p_currency_code,
p_booking_deal_type,
p_booking_deal_id,
p_enrollment_type,
p_validate
);