[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ota_tfh_api_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ota_finance_headers
set
finance_header_id = p_rec.finance_header_id,
superceding_header_id = p_rec.superceding_header_id,
authorizer_person_id = p_rec.authorizer_person_id,
organization_id = p_rec.organization_id,
administrator = p_rec.administrator,
cancelled_flag = p_rec.cancelled_flag,
currency_code = p_rec.currency_code,
date_raised = p_rec.date_raised,
object_version_number = p_rec.object_version_number,
payment_status_flag = p_rec.payment_status_flag,
transfer_status = p_rec.transfer_status,
comments = p_rec.comments,
external_reference = p_rec.external_reference,
invoice_address = p_rec.invoice_address,
invoice_contact = p_rec.invoice_contact,
payment_method = p_rec.payment_method,
pym_attribute1 = p_rec.pym_attribute1,
pym_attribute10 = p_rec.pym_attribute10,
pym_attribute11 = p_rec.pym_attribute11,
pym_attribute12 = p_rec.pym_attribute12,
pym_attribute13 = p_rec.pym_attribute13,
pym_attribute14 = p_rec.pym_attribute14,
pym_attribute15 = p_rec.pym_attribute15,
pym_attribute16 = p_rec.pym_attribute16,
pym_attribute17 = p_rec.pym_attribute17,
pym_attribute18 = p_rec.pym_attribute18,
pym_attribute19 = p_rec.pym_attribute19,
pym_attribute2 = p_rec.pym_attribute2,
pym_attribute20 = p_rec.pym_attribute20,
pym_attribute3 = p_rec.pym_attribute3,
pym_attribute4 = p_rec.pym_attribute4,
pym_attribute5 = p_rec.pym_attribute5,
pym_attribute6 = p_rec.pym_attribute6,
pym_attribute7 = p_rec.pym_attribute7,
pym_attribute8 = p_rec.pym_attribute8,
pym_attribute9 = p_rec.pym_attribute9,
pym_information_category = p_rec.pym_information_category,
transfer_date = p_rec.transfer_date,
transfer_message = p_rec.transfer_message,
vendor_id = p_rec.vendor_id,
contact_id = p_rec.contact_id,
address_id = p_rec.address_id,
customer_id = p_rec.customer_id,
tfh_information_category = p_rec.tfh_information_category,
tfh_information1 = p_rec.tfh_information1,
tfh_information2 = p_rec.tfh_information2,
tfh_information3 = p_rec.tfh_information3,
tfh_information4 = p_rec.tfh_information4,
tfh_information5 = p_rec.tfh_information5,
tfh_information6 = p_rec.tfh_information6,
tfh_information7 = p_rec.tfh_information7,
tfh_information8 = p_rec.tfh_information8,
tfh_information9 = p_rec.tfh_information9,
tfh_information10 = p_rec.tfh_information10,
tfh_information11 = p_rec.tfh_information11,
tfh_information12 = p_rec.tfh_information12,
tfh_information13 = p_rec.tfh_information13,
tfh_information14 = p_rec.tfh_information14,
tfh_information15 = p_rec.tfh_information15,
tfh_information16 = p_rec.tfh_information16,
tfh_information17 = p_rec.tfh_information17,
tfh_information18 = p_rec.tfh_information18,
tfh_information19 = p_rec.tfh_information19,
tfh_information20 = p_rec.tfh_information20,
paying_cost_center = p_rec.paying_cost_center,
receiving_cost_center = p_rec.receiving_cost_center,
transfer_from_set_of_books_id = p_rec.transfer_from_set_of_book_id,
transfer_to_set_of_books_id = p_rec.transfer_to_set_of_book_id,
from_segment1 = p_rec.from_segment1,
from_segment2 = p_rec.from_segment2,
from_segment3 = p_rec.from_segment3,
from_segment4 = p_rec.from_segment4,
from_segment5 = p_rec.from_segment5,
from_segment6 = p_rec.from_segment6,
from_segment7 = p_rec.from_segment7,
from_segment8 = p_rec.from_segment8,
from_segment9 = p_rec.from_segment9,
from_segment10 = p_rec.from_segment10,
from_segment11 = p_rec.from_segment11,
from_segment12 = p_rec.from_segment12,
from_segment13 = p_rec.from_segment13,
from_segment14 = p_rec.from_segment14,
from_segment15 = p_rec.from_segment15,
from_segment16 = p_rec.from_segment16,
from_segment17 = p_rec.from_segment17,
from_segment18 = p_rec.from_segment18,
from_segment19 = p_rec.from_segment19,
from_segment20 = p_rec.from_segment20,
from_segment21 = p_rec.from_segment21,
from_segment22 = p_rec.from_segment22,
from_segment23 = p_rec.from_segment23,
from_segment24 = p_rec.from_segment24,
from_segment25 = p_rec.from_segment25,
from_segment26 = p_rec.from_segment26,
from_segment27 = p_rec.from_segment27,
from_segment28 = p_rec.from_segment28,
from_segment29 = p_rec.from_segment29,
from_segment30 = p_rec.from_segment30,
to_segment1 = p_rec.to_segment1,
to_segment2 = p_rec.to_segment2,
to_segment3 = p_rec.to_segment3,
to_segment4 = p_rec.to_segment4,
to_segment5 = p_rec.to_segment5,
to_segment6 = p_rec.to_segment6,
to_segment7 = p_rec.to_segment7,
to_segment8 = p_rec.to_segment8,
to_segment9 = p_rec.to_segment9,
to_segment10 = p_rec.to_segment10,
to_segment11 = p_rec.to_segment11,
to_segment12 = p_rec.to_segment12,
to_segment13 = p_rec.to_segment13,
to_segment14 = p_rec.to_segment14,
to_segment15 = p_rec.to_segment15,
to_segment16 = p_rec.to_segment16,
to_segment17 = p_rec.to_segment17,
to_segment18 = p_rec.to_segment18,
to_segment19 = p_rec.to_segment19,
to_segment20 = p_rec.to_segment20,
to_segment21 = p_rec.to_segment21,
to_segment22 = p_rec.to_segment22,
to_segment23 = p_rec.to_segment23,
to_segment24 = p_rec.to_segment24,
to_segment25 = p_rec.to_segment25,
to_segment26 = p_rec.to_segment26,
to_segment27 = p_rec.to_segment27,
to_segment28 = p_rec.to_segment28,
to_segment29 = p_rec.to_segment29,
to_segment30 = p_rec.to_segment30,
transfer_from_cc_id = p_rec.transfer_from_cc_id,
transfer_to_cc_id = p_rec.transfer_to_cc_id
where finance_header_id = p_rec.finance_header_id;
End update_dml;
Procedure pre_update(p_rec in ota_tfh_api_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ota_tfh_api_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
p_transaction_type in varchar2 default 'UPDATE'
) is
--
l_proc varchar2(72) := g_package||'upd';
ota_tfh_api_bus.update_validate(temp_var
,p_transaction_type);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
ota_tfh_api_business_rules2.update_finance_lines (p_rec);
p_transaction_type in varchar2 default 'UPDATE'
) is
--
l_rec ota_tfh_api_shd.g_rec_type;