APPS.HR_SESSION_UTILITIES SQL Statements

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

Line: 57

PROCEDURE insert_session_row
            (p_effective_date in date)
IS
--
  l_proc	VARCHAR2 (72) := g_package || 'insert_session_row';

Line: 86

END insert_session_row;

Line: 96

PROCEDURE insert_session_row
            (p_effective_date in varchar2)
IS
--
  l_date       date;

Line: 102

  l_proc	VARCHAR2 (72) := g_package || 'insert_session_row';

Line: 130

END insert_session_row;

Line: 151

  delete from fnd_sessions
  where session_id = userenv('sessionid');

Line: 178

    select fpi.status
    from   fnd_product_installations fpi
    where  fpi.application_id = p_application_id;

Line: 227

   ,p_icx_update   in     boolean  default true      -- 10/15/97 Changed
   ,p_icx_commit   in     boolean  default false) IS -- 10/15/97 Changed
--
  l_web_username  varchar2(80) default null;

Line: 245

              ,p_icx_update   => p_icx_update           -- 10/15/97 Changed
              ,p_icx_commit   => p_icx_commit);         -- 10/15/97 Changed

Line: 273

   ,p_icx_update   in     boolean  default true         -- 10/15/97 Changed
   ,p_icx_commit   in     boolean  default false) IS    -- 10/15/97 Changed
--

  l_web_user_id   number;

Line: 302

  IF NOT(icx_sec.validateSession(c_update => p_icx_update        --10/15/97 Chg
                                ,c_commit => p_icx_commit)) then --10/15/97 Chg
    RAISE g_fatal_error;