APPS.HR_EAP_UPD SQL Statements

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

Line: 15

PROCEDURE update_sso_details (
            p_ext_application_id   IN number,
            p_app_code             IN VARCHAR2,
            p_apptype              IN VARCHAR2,
            p_appurl               IN VARCHAR2,
            p_logout_url           IN VARCHAR2,
            p_userfld              IN VARCHAR2,
            p_pwdfld               IN VARCHAR2,
            p_authused             IN VARCHAR2,
            p_fname1               IN VARCHAR2 DEFAULT NULL,
            p_fval1                IN VARCHAR2 DEFAULT NULL,
            p_fname2               IN VARCHAR2 DEFAULT NULL,
            p_fval2                IN VARCHAR2 DEFAULT NULL,
            p_fname3               IN VARCHAR2 DEFAULT NULL,
            p_fval3                IN VARCHAR2 DEFAULT NULL,
            p_fname4               IN VARCHAR2 DEFAULT NULL,
            p_fval4                IN VARCHAR2 DEFAULT NULL,
            p_fname5               IN VARCHAR2 DEFAULT NULL,
            p_fval5                IN VARCHAR2 DEFAULT NULL,
            p_fname6               IN VARCHAR2 DEFAULT NULL,
            p_fval6                IN VARCHAR2 DEFAULT NULL,
            p_fname7               IN VARCHAR2 DEFAULT NULL,
            p_fval7                IN VARCHAR2 DEFAULT NULL,
            p_fname8               IN VARCHAR2 DEFAULT NULL,
            p_fval8                IN VARCHAR2 DEFAULT NULL,
            p_fname9               IN VARCHAR2 DEFAULT NULL,
            p_fval9                IN VARCHAR2 DEFAULT NULL) IS

l_app_id  NUMBER(15) := NULL;

Line: 45

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

Line: 48

select external_application_id
from hr_ki_ext_applications
where ext_application_id=p_ext_application_id;

Line: 81

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

Line: 124

END update_sso_details;

Line: 172

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

Line: 186

  update hr_ki_ext_applications
    set
     ext_application_id              = p_rec.ext_application_id
    ,external_application_name       = p_rec.external_application_name

    where ext_application_id = p_rec.ext_application_id;

Line: 216

End update_dml;

Line: 250

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

Line: 260

End pre_update;

Line: 294

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

Line: 304

    hr_eap_rku.after_update
      (p_ext_application_id
      => p_rec.ext_application_id
      ,p_external_application_name
      => p_rec.external_application_name
      ,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: 326

End post_update;

Line: 418

  hr_eap_bus.update_validate
     (p_rec
     );

Line: 427

  hr_eap_upd.pre_update(p_rec);

Line: 431

  hr_eap_upd.update_dml(p_rec);

Line: 435

  hr_eap_upd.post_update
     (p_rec
     );