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