APPS.OTA_AR_DELETE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

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';

Line: 14

  select null
  from  ota_booking_deals
  where customer_id = p_customer_id;

Line: 19

  select null
  from   ota_delegate_bookings
  where  customer_id = p_customer_id;

Line: 24

  select null
  from   ota_delegate_bookings
  where  third_party_customer_id = p_customer_id;

Line: 29

  select null
  from   ota_delegate_bookings
  where  contact_id = p_contact_id;

Line: 34

  select null
  from   ota_delegate_bookings
  where  third_party_contact_id = p_contact_id;

Line: 39

  select null
  from   ota_delegate_bookings
  where  delegate_contact_id = p_contact_id;

Line: 44

  select null
  from   ota_delegate_bookings
  where  contact_address_id = p_address_id;

Line: 49

  select null
  from   ota_delegate_bookings
  where  third_party_address_id = p_address_id;

Line: 54

  select null
  from   ota_event_associations
  where  customer_id = p_customer_id;

Line: 59

  select null
  from   ota_finance_headers
  where  customer_id = p_customer_id;

Line: 64

  select null
  from   ota_finance_headers
  where  contact_id = p_contact_id
  and    customer_id is not null;

Line: 70

  select null
  from   ota_finance_headers
  where  address_id = p_address_id
  and    customer_id is not null;

Line: 85

        fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

Line: 97

        fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

Line: 109

        fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

Line: 121

        fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

Line: 133

        fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

Line: 147

        fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

Line: 159

        fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

Line: 171

        fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

Line: 183

        fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

Line: 197

        fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');

Line: 209

        fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');

Line: 221

        fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');