The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure check_delete(p_customer_id number default null
,p_contact_id number default null
,p_address_id number default null) is
--
l_proc varchar2(72) := g_package||'check_delete';
select null
from ota_booking_deals
where customer_id = p_customer_id;
select null
from ota_delegate_bookings
where customer_id = p_customer_id;
select null
from ota_delegate_bookings
where third_party_customer_id = p_customer_id;
select null
from ota_delegate_bookings
where contact_id = p_contact_id;
select null
from ota_delegate_bookings
where third_party_contact_id = p_contact_id;
select null
from ota_delegate_bookings
where delegate_contact_id = p_contact_id;
select null
from ota_delegate_bookings
where contact_address_id = p_address_id;
select null
from ota_delegate_bookings
where third_party_address_id = p_address_id;
select null
from ota_event_associations
where customer_id = p_customer_id;
select null
from ota_finance_headers
where customer_id = p_customer_id;
select null
from ota_finance_headers
where contact_id = p_contact_id
and customer_id is not null;
select null
from ota_finance_headers
where address_id = p_address_id
and customer_id is not null;
fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');