APPS.OTA_AP_DELETE SQL Statements

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

Line: 6

Procedure check_delete(p_vendor_id number default null
                      ,p_contact_id number default null
                      ,p_vendor_site_id number default null) is
--
  l_proc 	varchar2(72) := g_package||'check_delete';

Line: 14

  select null
  from  ota_events
  where vendor_id = p_vendor_id;

Line: 19

  select null
  from   ota_activity_versions
  where  vendor_id = p_vendor_id;

Line: 24

  select null
  from   ota_suppliable_resources
  where  vendor_id = p_vendor_id;

Line: 29

  select null
  from   ota_finance_headers
  where  vendor_id = p_vendor_id;

Line: 34

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

Line: 40

  select null
  from   ota_finance_headers
  where  address_id = p_vendor_site_id
  and    vendor_id is not null;

Line: 55

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

Line: 67

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

Line: 79

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

Line: 91

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

Line: 105

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

Line: 119

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