The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
from ota_customer_contacts_v con
where con.customer_id = p_customer_id
and con.contact_id = p_contact_id;
select 'Y'
from ota_customer_addresses_v adr
where adr.customer_id = p_customer_id
and adr.address_id = p_address_id;
select adr.address
from ota_customer_addresses_v adr
where adr.customer_id = p_customer_id
and adr.address_id = p_address_id;
select con.full_name
from ota_customer_contacts_v con
where con.customer_id = p_customer_id
and con.contact_id = p_contact_id;
select 'Y'
from AP_SUPPLIERS PAV,
HZ_PARTIES HP,
AP_SUPPLIER_CONTACTS PVC
where PAV.vendor_id = p_vendor_id
and PVC.VENDOR_CONTACT_ID = p_contact_id
and PAV.PARTY_ID = HP.PARTY_ID;
select 'Y'
from ota_vendor_addresses_v adr
where adr.vendor_id = p_vendor_id
and adr.vendor_site_id = p_address_id;
select 'Exists'
from ota_finance_lines
where finance_header_id = p_finance_header_id;
select 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
from ota_finance_headers
where finance_header_id = p_finance_header_id ;
select 'Y'
from ota_finance_headers tfh
where tfh.superceding_header_id = p_finance_header_id;
select *
from ota_finance_headers tfh
where tfh.finance_header_id = p_finance_header_id;
select 'Y'
from ota_finance_headers tfh
where tfh.finance_header_id = p_superseding_header_id;
Procedure check_update_customer_id
(
p_customer_id in number
,p_address_id in number
,p_contact_id in number
,p_vendor_id in number
) is
--
v_proc varchar2(72) := g_package||'check_update_customer_id';
End check_update_customer_id;
Procedure check_update_vendor_id
(
p_vendor_id in number
,p_address_id in number
,p_contact_id in number
,p_customer_id in number
) is
--
v_proc varchar2(72) := g_package||'check_update_vendor_id';
End check_update_vendor_id;
select 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
from ota_finance_headers tfh
where tfh.finance_header_id = p_finance_header_id;
Function check_update01_header
(
p_rec_old in ota_tfh_api_shd.g_rec_type
,p_rec_new in ota_tfh_api_shd.g_rec_type
) Return Boolean is
--
v_proc varchar2(72) := g_package||'check_update01_header';
End check_update01_header;
Function check_update02_header
(
p_rec_old in ota_tfh_api_shd.g_rec_type
,p_rec_new in ota_tfh_api_shd.g_rec_type
) Return Boolean is
--
v_proc varchar2(72) := g_package||'check_update02_header';
End check_update02_header;
Procedure check_update_header
(
p_rec_old in ota_tfh_api_shd.g_rec_type
,p_rec_new in ota_tfh_api_shd.g_rec_type
,p_transaction_type in varchar2
) is
--
v_proc varchar2(72) := g_package||'check_update_header';
if check_update01_header( p_rec_old, p_rec_new ) or
check_update02_header( p_rec_old, p_rec_new ) or
ota_general.value_changed( p_rec_old.payment_status_flag
, p_rec_new.payment_status_flag) then
--
fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
if check_update01_header( p_rec_old, p_rec_new ) or
check_update02_header( p_rec_old, p_rec_new ) or
ota_general.value_changed(p_rec_old.cancelled_flag
,p_rec_new.cancelled_flag) then
--
fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
if check_update01_header( p_rec_old, p_rec_new ) or
check_update02_header( p_rec_old, p_rec_new ) or
ota_general.value_changed( p_rec_old.payment_status_flag
, p_rec_new.payment_status_flag) or
ota_general.value_changed(p_rec_old.cancelled_flag
,p_rec_new.cancelled_flag) then
--
fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
End check_update_header;
select tfh.transfer_status
, tfh.superceding_header_id
, tfh.type
from ota_finance_headers tfh
where tfh.finance_header_id = p_finance_header_id;
select 'Y'
from ota_finance_lines tfl
where tfl.finance_header_id = p_finance_header_id;
fnd_message.set_name('OTA','OTA_443876_TFH_DELETE_CHK');
select name
from hr_organization_units
where organization_id = p_organization_id;
select user_name
from fnd_user
where user_id = p_fnd_user_id;
select null
from ota_finance_headers
where superceding_header_id = p_finance_header_id;