APPS.OTA_HR_DELETE SQL Statements

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

Line: 6

Procedure check_delete(p_person_id       number default null
                      ,p_organization_id number default null
                      ,p_job_id          number default null
                      ,p_position_id     number default null
                      ,p_address_id      number default null
                      ,p_analysis_criteria_id number default null
                      ) is
--
  l_proc 	varchar2(72) := g_package||'check_delete';

Line: 18

  select null
  from  ota_activity_versions
  where controlling_person_id = p_person_id;

Line: 23

  select null
  from  ota_activity_versions
  where developer_organization_id = p_organization_id;

Line: 28

  select null
  from   ota_delegate_bookings
  where  delegate_person_id = p_person_id;

Line: 33

  select null
  from   ota_delegate_bookings
  where  sponsor_person_id = p_person_id;

Line: 38

  select null
  from   ota_delegate_bookings
  where  organization_id = p_organization_id;

Line: 43

  select null
  from   ota_delegate_bookings
  where  person_address_id = p_address_id;

Line: 48

  select null
  from   ota_events
  where  organization_id = p_organization_id;

Line: 53

  select null
  from   ota_event_associations
  where  organization_id = p_organization_id;

Line: 58

  select null
  from   ota_event_associations
  where  job_id = p_job_id;

Line: 63

  select null
  from   ota_event_associations
  where  position_id = p_position_id;

Line: 68

  select null
  from   ota_finance_headers
  where  organization_id = p_organization_id;

Line: 73

  select null
  from   ota_skill_provisions
  where  analysis_criteria_id = p_analysis_criteria_id;

Line: 87

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

Line: 99

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

Line: 111

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

Line: 125

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

Line: 137

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

Line: 149

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

Line: 161

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

Line: 173

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

Line: 187

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

Line: 201

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

Line: 215

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

Line: 229

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