APPS.HR_SSO_UTL SQL Statements

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

Line: 25

            'select ' ||
            'wwctx_api.get_sso_schema'
            || ' from dual'
  INTO l_retval;

Line: 64

            'select wwctx_api.get_sso_query_path(:p_url,:p_schema) from dual'
  INTO l_retval using p_url,p_schema;

Line: 99

            'select wwsso_utl.encrypt_ps_password(:p_password) from dual'
  INTO l_retval using p_password;

Line: 134

            'select wwsso_utl.decrypt_ps_password(:p_password) from dual'
  INTO l_retval using p_password;

Line: 169

            'select wwsso_utl.encrypt_ps_username(:p_username) from dual'
  INTO l_retval using p_username;

Line: 204

            'select wwsso_utl.decrypt_ps_username(:p_username) from dual'
  INTO l_retval using p_username;

Line: 236

            'select ' ||
            'wwctx_api.get_user'
            || ' from dual'
  INTO l_retval;

Line: 736

PROCEDURE delete_application(
  p_appid IN  VARCHAR2
, p_error OUT NOCOPY NUMBER
)
IS

l_procedure VARCHAR2(31) := 'delete_application';

Line: 757

  'begin WWSSO_PSTORE_EX.delete_application(' ||
  ':p_appid, :p_error ' ||
  '); end;'

Line: 773

END delete_application;