APPS.HR_EAP_DEL SQL Statements

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

Line: 14

PROCEDURE delete_sso_details (
            p_sso_id   IN number
) IS

l_ext_application_id  NUMBER(15) := NULL;

Line: 21

l_proc     varchar2(72) := g_package || 'delete_sso_details';

Line: 24

select EXT_APPLICATION_ID
from hr_ki_ext_applications
where external_application_id=p_sso_id;

Line: 57

hr_utility.set_location('Calling update SSO:'||l_proc, 20);

Line: 60

   hr_sso_utl.delete_application
   (
   p_appid => p_sso_id
   ,p_error => l_error
   );

Line: 78

END delete_sso_details;

Line: 120

Procedure delete_dml
  (p_rec in hr_eap_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_dml';

Line: 133

  delete from hr_ki_ext_applications
  where ext_application_id = p_rec.ext_application_id;

Line: 149

End delete_dml;

Line: 183

Procedure pre_delete(p_rec in hr_eap_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_delete';

Line: 191

End pre_delete;

Line: 225

Procedure post_delete(p_rec in hr_eap_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 233

    hr_eap_rkd.after_delete
      (p_ext_application_id
      => p_rec.ext_application_id
      ,p_external_application_name_o
      => hr_eap_shd.g_old_rec.external_application_name
      ,p_external_application_id_o
      => hr_eap_shd.g_old_rec.external_application_id
      );

Line: 253

End post_delete;

Line: 275

  hr_eap_bus.delete_validate(p_rec);

Line: 282

  hr_eap_del.pre_delete(p_rec);

Line: 286

  hr_eap_del.delete_dml(p_rec);

Line: 290

  hr_eap_del.post_delete(p_rec);