APPS.HR_INT_BUS SQL Statements

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

Line: 42

Procedure chk_non_updateable_args
  (p_rec in hr_int_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 75

End chk_non_updateable_args;

Line: 106

         select null
           from hr_ki_integrations
          where  integration_key = p_integration_key;

Line: 307

    p_insert in varchar2
   ,p_ext_application_id in number
   ,p_application_name in varchar2
   ,p_application_type in varchar2
   ,p_application_url  in varchar2
   ,p_logout_url       in varchar2
   ,p_user_field       in varchar2
   ,p_password_field   in varchar2
   ,p_authentication_needed in varchar2
   ,p_integration_id in number
  ) IS
--
  l_proc        varchar2(72) := g_package || 'CHK_SSO_DETAILS';

Line: 325

         select null
           from hr_ki_integrations
          where
          application_name=p_application_name
          and application_type=p_application_type
          and application_url=p_application_url
          and logout_url=p_logout_url
          and user_field=p_user_field
          and password_field=p_password_field
          and authentication_needed=p_authentication_needed;

Line: 337

         select null
           from hr_ki_integrations
          where
          application_name=p_application_name
          and application_type=p_application_type
          and application_url=p_application_url
          and logout_url=p_logout_url
          and user_field=p_user_field
          and password_field=p_password_field
          and authentication_needed=p_authentication_needed
          and integration_id<>p_integration_id;

Line: 363

          if(p_insert ='insert') then
                if(p_ext_application_id is not null) then
                fnd_message.set_name('PER','PER_449976_INT_SSO_ID_INVALID');

Line: 412

           if(p_insert ='insert') then
                    open csr_sso;

Line: 485

         select null
          from hr_ki_ext_applications
          where  ext_application_id = p_ext_application_id;

Line: 489

         select null
          from hr_ki_integrations
          where  ext_application_id = p_ext_application_id
          and integration_id<>p_integration_id;

Line: 601

         select null
           from hr_ki_integrations
          where party_type=p_party_type
          and party_name=p_party_name
          and party_site_name=p_party_site_name
          and transaction_type=p_transaction_type
          and transaction_subtype=p_transaction_subtype
          and standard_code=p_standard_code
          and ext_trans_type=p_ext_trans_type
          and ext_trans_subtype=p_ext_trans_subtype
          and trans_direction=p_trans_direction;

Line: 614

         select null
           from hr_ki_integrations
          where party_type=p_party_type
          and party_name=p_party_name
          and party_site_name=p_party_site_name
          and transaction_type=p_transaction_type
          and transaction_subtype=p_transaction_subtype
          and standard_code=p_standard_code
          and ext_trans_type=p_ext_trans_type
          and ext_trans_subtype=p_ext_trans_subtype
          and trans_direction=p_trans_direction
          and integration_id<>p_integration_id;

Line: 950

procedure chk_delete
  (p_integration_id                        in number
  )
  is
  --
  -- Declare local variables
  --
  l_proc              varchar2(72) :=  g_package||'chk_delete';

Line: 966

    select null
      from hr_ki_options
     where integration_id = p_integration_id;

Line: 971

    select null
      from hr_ki_topic_integrations
     where integration_id = p_integration_id;

Line: 976

    select null
      from hr_ki_integrations_tl
     where integration_id = p_integration_id;

Line: 981

     select null from hr_ki_integrations inte,hr_ki_ext_applications ext
      where inte.integration_id=p_integration_id
        and  inte.ext_application_id=ext.ext_application_id;

Line: 1041

end chk_delete;

Line: 1048

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

Line: 1094

   p_insert                 => 'insert'
  ,p_ext_application_id     => p_rec.ext_application_id
  ,p_application_name       => p_rec.application_name
  ,p_application_type       => p_rec.application_type
  ,p_application_url        => p_rec.application_url
  ,p_logout_url             => p_rec.logout_url
  ,p_user_field             => p_rec.user_field
  ,p_password_field         => p_rec.password_field
  ,p_authentication_needed  =>  p_rec.authentication_needed
  ,p_integration_id         => null
  );

Line: 1127

End insert_validate;

Line: 1132

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

Line: 1149

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1181

   p_insert                 => 'update'
  ,p_ext_application_id     => p_rec.ext_application_id
  ,p_application_name       => p_rec.application_name
  ,p_application_type       => p_rec.application_type
  ,p_application_url        => p_rec.application_url
  ,p_logout_url             => p_rec.logout_url
  ,p_user_field             => p_rec.user_field
  ,p_password_field         => p_rec.password_field
  ,p_authentication_needed  =>  p_rec.authentication_needed
  ,p_integration_id         => p_rec.integration_id
  );

Line: 1216

End update_validate;

Line: 1221

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

Line: 1232

  CHK_DELETE
  (
  p_integration_id =>p_rec.integration_id
  );

Line: 1237

End delete_validate;