APPS.FND_AOLJ_UTIL SQL Statements

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

Line: 146

     SELECT object_name
     from user_objects
     WHERE object_type = 'JAVA CLASS'
     ORDER BY dbms_java.longname(object_name);

Line: 170

            p_update               in boolean,
            p_responsibility_id    in number,
            p_function_id          in number,
            p_resp_appl_id         in number,
            p_security_group_id    in number,
            p_home_url             in varchar2,
            p_proxy_user           in number,
 	    mode_code   	   in out nocopy varchar2,
            session_id             out nocopy number,
            transaction_id         out nocopy number,
            user_id                out nocopy number,
            responsibility_id      out nocopy number,
            resp_appl_id           out nocopy number,
            security_group_id      out nocopy number,
            language_code          out nocopy varchar2,
            nls_language           out nocopy varchar2,
            date_format_mask       out nocopy varchar2,
            nls_date_language      out nocopy varchar2,
            nls_numeric_characters out nocopy varchar2,
            nls_sort               out nocopy varchar2,
            nls_territory          out nocopy varchar2,
            login_id               out nocopy number,
            xsid                   out nocopy varchar2
  ) return VARCHAR2 is
l_session_id  number;

Line: 201

  select user_id into l_user_id from fnd_user
  where user_id = p_user_id and
        (start_date <= sysdate) and
        (end_date is null or end_date>sysdate);

Line: 216

   select decode(l_sso,
	       'SSWA', '115P',
               'SSWA_SSO', '115J',
	       '115X') into mode_code from dual;

Line: 246

          p_update,
          p_responsibility_id,
          p_function_id,
          p_resp_appl_id,
          p_security_group_id,
          'N',
          NULL,
          session_id,
          transaction_id,
	  user_id,
	  responsibility_id,
	  resp_appl_id,
	  security_group_id,
	  language_code,
	  nls_language,
	  date_format_mask,
	  nls_date_language,
	  nls_numeric_characters,
	  nls_sort,
	  nls_territory,
	  login_id,
          true);

Line: 283

            p_update               in boolean,
            p_responsibility_id    in number,
            p_function_id          in number,
            p_resp_appl_id         in number,
            p_security_group_id    in number,
            p_home_url             in varchar2,
            p_mode_code            in out nocopy varchar2,
            session_id             out nocopy number,
            transaction_id         out nocopy number,
            user_id                out nocopy number,
            responsibility_id      out nocopy number,
            resp_appl_id           out nocopy number,
            security_group_id      out nocopy number,
            language_code          out nocopy varchar2,
            nls_language           out nocopy varchar2,
            date_format_mask       out nocopy varchar2,
            nls_date_language      out nocopy varchar2,
            nls_numeric_characters out nocopy varchar2,
            nls_sort               out nocopy varchar2,
            nls_territory          out nocopy varchar2,
            login_id               out nocopy number
  ) return VARCHAR2 is
l_convert_result varchar2(1);

Line: 334

          p_update,
          p_responsibility_id,
          p_function_id,
          p_resp_appl_id,
          p_security_group_id,
          'N',
          NULL,
          session_id,
          transaction_id,
	  user_id,
	  responsibility_id,
	  resp_appl_id,
	  security_group_id,
	  language_code,
	  nls_language,
	  date_format_mask,
	  nls_date_language,
	  nls_numeric_characters,
	  nls_sort,
	  nls_territory,
	  login_id,
          true);

Line: 377

            p_update               in boolean,
            p_responsibility_id    in number,
            p_function_id          in number,
            p_resp_appl_id         in number,
            p_security_group_id    in number,
            p_validate_mode_on     in varchar2,
            p_transaction_id       in varchar2,
            session_id             out nocopy number,
            transaction_id         out nocopy number,
            user_id                out nocopy number,
            responsibility_id      out nocopy number,
            resp_appl_id           out nocopy number,
            security_group_id      out nocopy number,
            language_code          out nocopy varchar2,
            nls_language           out nocopy varchar2,
            date_format_mask       out nocopy varchar2,
            nls_date_language      out nocopy varchar2,
            nls_numeric_characters out nocopy varchar2,
            nls_sort               out nocopy varchar2,
            nls_territory          out nocopy varchar2,
            login_id               out nocopy number,
            p_isEncrypt         in boolean ) return varchar2 is

l_result                    varchar2(30);

Line: 437

                 c_update                   =>  p_update,
                 c_responsibility_id        =>  p_responsibility_id,
                 c_function_id              =>  p_function_id,
                 c_resp_appl_id             =>  p_resp_appl_id,
                 c_security_group_id        =>  p_security_group_id,
                 c_validate_mode_on         =>  p_validate_mode_on,
                 c_xtid                     =>  l_encrypted_tranx_id,
                 session_id                 =>  session_id,
                 transaction_id             =>  transaction_id,
                 user_id                    =>  user_id,
                 responsibility_id          =>  responsibility_id,
                 resp_appl_id               =>  resp_appl_id,
                 security_group_id          =>  security_group_id,
                 language_code              =>  language_code,
                 nls_language               =>  nls_language,
                 date_format_mask           =>  date_format_mask,
                 nls_date_language          =>  nls_date_language,
                 nls_numeric_characters     =>  nls_numeric_characters,
                 nls_sort                   =>  nls_sort,
                 nls_territory              =>  nls_territory);