APPS.ORACLESSWA SQL Statements

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

Line: 65

      select TYPE
      into   l_function_type
      from   FND_FORM_FUNCTIONS
      where  FUNCTION_ID = l_function_id;

Line: 72

      select multi_org_flag
      into   l_multi_org_flag
      from   fnd_product_groups
      where  rownum < 2;

Line: 87

      update ICX_SESSIONS
      set    RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
             RESPONSIBILITY_ID = l_responsibility_id,
             SECURITY_GROUP_ID = l_security_group_id,
             ORG_ID = l_org_id,
             FUNCTION_ID = l_function_id,
             FUNCTION_TYPE = l_function_type,
             MENU_ID = l_menu_id
      where SESSION_ID = l_session_id;

Line: 105

                             c_update => FALSE);

Line: 162

        select user_id
        into l_user_id
        from icx_sessions
        where session_id = l_session_id;

Line: 169

        update icx_portlet_customizations
        set responsibility_id = l_responsibility_id,
            application_id    = l_resp_appl_id,
            security_group_id = l_security_group_id,
            caching_key       = caching_key + 1
        where plug_id in (select function_id
                          from fnd_form_functions
                          where function_name = 'FND_NAVIGATE_SCTX_PORTLET')
        and user_id = l_user_id;

Line: 360

      select user_id
      into   l_user_id
      from   fnd_user
      where  user_name = l_sso_user_name
      and (END_DATE is NULL or END_DATE > sysdate);

Line: 371

        SELECT user_id
               INTO c_user_id
               FROM icx_sessions
               WHERE session_id=l_session_id; -- use cookie value to get user_id, defaults to -999 if bogus cookie/user_id.

Line: 387

           SELECT user_id
             INTO l_anon_id
             FROM fnd_user
             WHERE user_name=l_anon_name;

Line: 406

        UPDATE icx_sessions
        SET last_connect  = sysdate,
            first_connect = SYSDATE,
            counter = 1,
            xsid = l_new_xsid
        WHERE session_id = l_session_id;

Line: 436

        UPDATE icx_sessions
            SET user_id = l_user_id,
                nls_language = l_language,
                language_code = l_language_code,
                date_format_mask = l_date_format,
                nls_date_language = l_date_language,
                nls_numeric_characters = l_numeric_characters,
                nls_sort = l_nls_sort,
                nls_territory = l_nls_territory,
                limit_time = l_limit_time,
                limit_connects = l_limit_connects,
                org_id = l_org_id,
                last_connect  = sysdate,
                first_connect = SYSDATE,
                counter = 1,
                xsid = l_new_xsid
            WHERE session_id = l_session_id;

Line: 506

select FUNCTION_ID
into   l_function_id
from   FND_FORM_FUNCTIONS
where  FUNCTION_NAME = 'FND_NAVIGATE_PAGE';

Line: 664

    SELECT function_id
      INTO l_function_id
      FROM fnd_form_functions
      WHERE function_name = F;

Line: 690

   select nls_language into nls_base_lang from fnd_languages_vl
   where installed_flag = 'B';

Line: 697

 	 select nls_language into l_language from fnd_languages_vl
	where LANGUAGE_CODE = L and installed_flag in ('B', 'I');

Line: 718

  select multi_org_flag
  into   l_multi_org_flag
  from   fnd_product_groups
  where  rownum < 2;

Line: 736

  update ICX_SESSIONS
  set 	 RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
         RESPONSIBILITY_ID = l_responsibility_id,
         SECURITY_GROUP_ID = l_security_group_id,
         ORG_ID = l_org_id,
         FUNCTION_ID = l_function_id,
         FUNCTION_TYPE = l_function_type,
         MENU_ID = l_menu_id,
         NLS_LANGUAGE = nvl(l_language,NLS_LANGUAGE),
         LANGUAGE_CODE = nvl(L,LANGUAGE_CODE)
         where	SESSION_ID = l_session_id;

Line: 760

     SELECT user_id
       into l_user_id
       from  fnd_user
       where user_name = l_guest_name;

Line: 821

        SELECT TYPE
        INTO f_type
        FROM fnd_form_functions
        WHERE function_id = l_function_id;

Line: 886

    select USER_NAME
    into   l_user_name
    from   FND_USER fu,
           ICX_SESSIONS i
    where  i.SESSION_ID = l_session_id
    and    i.USER_ID = fu.USER_ID;

Line: 919

     SELECT user_id
       into l_user_id
       from  fnd_user
       where user_name = l_guest_name;

Line: 951

       select multi_org_flag
         into   l_multi_org_flag
         from   fnd_product_groups
         where  rownum < 2;

Line: 962

       update ICX_SESSIONS
          set    RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
                 RESPONSIBILITY_ID = l_responsibility_id,
                 SECURITY_GROUP_ID = l_security_group_id,
                 ORG_ID = l_org_id,
                 FUNCTION_ID = l_function_id,
                 FUNCTION_TYPE = l_function_type
          where SESSION_ID = l_session_id;

Line: 991

     SELECT user_id
       into l_user_id
       from  fnd_user
       where user_name = l_guest_name;

Line: 1022

       select multi_org_flag
         into   l_multi_org_flag
         from   fnd_product_groups
         where  rownum < 2;

Line: 1033

       update ICX_SESSIONS
          set    RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
                 RESPONSIBILITY_ID = l_responsibility_id,
                 SECURITY_GROUP_ID = l_security_group_id,
                 ORG_ID = l_org_id,
                 FUNCTION_ID = l_function_id,
                 FUNCTION_TYPE = l_function_type
          where SESSION_ID = l_session_id;