APPS.ORACLEMYPAGE SQL Statements

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

Line: 7

  select HSECS into l_hsecs from V$TIMER;

Line: 61

select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
       b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
       b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
       c.DESCRIPTION,a.WEB_HTML_CALL
from   fnd_responsibility e,
       FND_USER_RESP_GROUPS d,
       FND_FORM_FUNCTIONS a,
       FND_MENU_ENTRIES_VL c,
       ICX_PAGE_PLUGS b
where  b.PAGE_ID = l_page_id
and   b.MENU_ID = c.MENU_ID
and    b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
and    c.FUNCTION_ID = a.FUNCTION_ID
and    a.type in ('WWL','WWLG')
and    b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
and    d.user_id = icx_sec.g_user_id
and    d.start_date <= sysdate
and    (d.end_date is null or d.end_date > sysdate)
and    b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
and    e.start_date <= sysdate
and    (e.end_date is null or e.end_date > sysdate)
union all
select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
       b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
       b.MENU_ID,b.ENTRY_SEQUENCE,
       nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) prompt,
       a.DESCRIPTION,a.WEB_HTML_CALL
from   FND_FORM_FUNCTIONS_VL a,
       ICX_PAGE_PLUGS b
where  b.PAGE_ID = l_page_id
and    b.MENU_ID = -1
and    b.ENTRY_SEQUENCE = a.FUNCTION_ID
and    a.type in ('WWL','WWLG')
order by 1;

Line: 97

select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
       b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
       b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
       c.DESCRIPTION,a.WEB_HTML_CALL
from   fnd_responsibility e,
       FND_USER_RESP_GROUPS d,
       FND_FORM_FUNCTIONS a,
       FND_MENU_ENTRIES_VL c,
       ICX_PAGE_PLUGS b
where  b.PAGE_ID = l_page_id
and    b.MENU_ID = c.MENU_ID
and    b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
and    c.FUNCTION_ID = a.FUNCTION_ID
and    a.type in ('WWR','WWRG')
and    b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
and    d.user_id = icx_sec.g_user_id
and    d.start_date <= sysdate
and    (d.end_date is null or d.end_date > sysdate)
and    b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
and    e.start_date <= sysdate
and    (e.end_date is null or e.end_date > sysdate)
order by b.DISPLAY_SEQUENCE;

Line: 122

select HSECS into l_start from V$TIMER;

Line: 128

        select PAGE_ID,REFRESH_RATE
        into   l_page_id,l_refresh_rate
        from   ICX_PAGES
        where  USER_ID = icx_sec.g_user_id;

Line: 217

select HSECS into l_timer from V$TIMER;

Line: 228

select HSECS into l_hsecs from V$TIMER;

Line: 237

select HSECS into l_timer from V$TIMER;

Line: 251

select HSECS into l_hsecs from V$TIMER;

Line: 260

select HSECS into l_timer from V$TIMER;

Line: 271

select HSECS into l_timer from V$TIMER;

Line: 281

procedure updateCurrentPageID(
	p_session_id	in	varchar2,
	p_page_id	in	varchar2
) is
l_session_id	number;

Line: 291

	update icx_sessions
	set page_id = p_page_id
	where session_id = p_session_id;

Line: 301

end updateCurrentPageID;

Line: 310

        select  fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
                fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
                nvl(ipp.DISPLAY_NAME,fme.PROMPT) display, ipp.DISPLAY_SEQUENCE
        from    fnd_responsibility fr, FND_USER_RESP_GROUPS furg,
                fnd_form_functions fff, fnd_menu_entries_vl fme,
                icx_page_plugs ipp
        where   ipp.PAGE_ID = p_page_id and fme.MENU_ID = ipp.MENU_ID
        and     fme.ENTRY_SEQUENCE = ipp.ENTRY_SEQUENCE
        and     fff.FUNCTION_ID = fme.FUNCTION_ID
        and     ipp.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID
        and     ipp.RESPONSIBILITY_APPLICATION_ID = furg.RESPONSIBILITY_APPLICATION_ID
        and     furg.user_id = p_user_id and furg.start_date <= sysdate
        and     (furg.end_date is null or furg.end_date > sysdate)
        and     ipp.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
        and     fr.start_date <= sysdate
        and     (fr.end_date is null or fr.end_date > sysdate)
        union
        select  fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
                fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
                nvl(ipp.DISPLAY_NAME,fff.USER_FUNCTION_NAME),
                ipp.DISPLAY_SEQUENCE
        from    fnd_form_functions_vl fff, icx_page_plugs ipp
        where   ipp.MENU_ID = -1 and ipp.ENTRY_SEQUENCE = fff.FUNCTION_ID
        and     ipp.PAGE_ID = p_page_id
	order by 8;

Line: 481

               c_sec_grp_id IN    VARCHAR2) IS --mputman hosted update

l_user_id     number;

Line: 507

   SELECT user_id
   INTO   l_user_id
   FROM   fnd_user
   WHERE  user_name = upper(i_1);

Line: 556

      SELECT security_group_id
      INTO l_sgid
      FROM fnd_security_groups
      WHERE security_group_key=c_sec_grp_id;

Line: 580

         update ICX_SESSIONS
         set    HOME_URL = l_url
         where  SESSION_ID = l_session_id;

Line: 599

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

Line: 629

         select 'Y'
           into  l_expired
           from  FND_USER
          where  USER_NAME = UPPER(i_1)
            and    (PASSWORD_DATE is NULL or
                   (PASSWORD_LIFESPAN_ACCESSES is not NULL and
                     nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or
                   (PASSWORD_LIFESPAN_DAYS is not NULL and
                   SYSDATE >= PASSWORD_DATE + PASSWORD_LIFESPAN_DAYS));

Line: 685

select  a.responsibility_id,
        a.responsibility_name,
        a.description,
        a.version,
        a.responsibility_key,
        b.responsibility_application_id,
        fsg.SECURITY_GROUP_NAME,
        fsg.SECURITY_GROUP_ID,
        fsg.security_group_key,
        fa.application_short_name
from    FND_SECURITY_GROUPS_VL fsg,
        fnd_responsibility_vl a,
        FND_USER_RESP_GROUPS b,
        FND_APPLICATION fa
where   b.user_id = icx_sec.g_user_id
and     b.start_date <= sysdate
and     (b.end_date is null or b.end_date > sysdate)
and     b.RESPONSIBILITY_id = a.responsibility_id
and     b.RESPONSIBILITY_application_id = a.application_id
and     a.application_id = fa.application_id
and     a.version in ('W')
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
and     b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
order by version desc,responsibility_name;

Line: 714

select  a.responsibility_id,
        a.responsibility_name,
        a.description,
        a.version,
        a.responsibility_key,
        b.responsibility_application_id,
        fsg.SECURITY_GROUP_NAME,
        fsg.SECURITY_GROUP_ID,
        fsg.security_group_key,
        fa.application_short_name
from    FND_SECURITY_GROUPS_VL fsg,
        fnd_responsibility_vl a,
        FND_USER_RESP_GROUPS b,
        FND_APPLICATION fa
where   b.user_id = icx_sec.g_user_id
and     b.start_date <= sysdate
and     (b.end_date is null or b.end_date > sysdate)
and     b.RESPONSIBILITY_id = a.responsibility_id
and     b.RESPONSIBILITY_application_id = a.application_id
and     a.application_id = fa.application_id
and     a.version in ('4')
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
and     b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
      order by version desc,responsibility_name;

Line: 742

	select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
	  from icx_pages ip,
               icx_pages_tl ipt
	 where ip.user_id = p_user_id
           and ipt.language = userenv('LANG')
	   and ip.page_id = ipt.page_id
           and ip.page_type in ('USER', 'MAIN')
	order by ip.page_type desc, ip.sequence_number;

Line: 808

icx_sec.updateSessionContext(p_application_id => '',
                             p_responsibility_id => '',
                             p_security_group_id => '',
                             p_session_id => l_session_id);

Line: 831

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

Line: 858

   select count(*) into l_page_count
       from icx_pages
       where user_id = l_user_id;

Line: 864

      SELECT page_id
        INTO l_page_id
        FROM icx_pages
        WHERE user_id = l_user_id;

Line: 869

      select  count(*)
         INTO l_region_count
         FROM icx_page_plugs
         WHERE page_id=l_page_id;

Line: 879

  select  count(*) INTO l_resps_count
  from    FND_SECURITY_GROUPS_VL fsg,
          FND_RESPONSIBILITY_VL a,
          FND_USER_RESP_GROUPS b
  where   b.user_id = l_user_id
  and     b.start_date <= sysdate
  and     (b.end_date is null or b.end_date > sysdate)
  and     b.RESPONSIBILITY_id = a.responsibility_id
  and     b.RESPONSIBILITY_application_id = a.application_id
  and     a.start_date <= sysdate
  and     (a.end_date is null or a.end_date > sysdate)
  and     b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID;

Line: 908

    select  a.version INTO l_resp_type
from    FND_SECURITY_GROUPS_VL fsg,
        FND_RESPONSIBILITY_VL a,
        FND_USER_RESP_GROUPS b
where   b.user_id = l_user_id
and     b.start_date <= sysdate
and     (b.end_date is null or b.end_date > sysdate)
and     b.RESPONSIBILITY_id = a.responsibility_id
and     b.RESPONSIBILITY_application_id = a.application_id
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
and     b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
order by responsibility_name;

Line: 942

           select count(*)
           INTO l_function_count
           from
            fnd_responsibility_vl a,
            fnd_menu_entries_vl b,
            fnd_form_functions_vl c
            where a.responsibility_id=r.responsibility_id
            and a.menu_id=b.menu_id
            and b.function_id=c.function_id
            AND b.prompt IS NOT NULL
            and c.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP')
            and    nvl(c.FUNCTION_ID,-1) not in   -- menu exclusion support 1911095 mputman
                (select ACTION_ID
                   from   FND_RESP_FUNCTIONS
                   where  RESPONSIBILITY_ID = r.responsibility_id
                   and    APPLICATION_ID    = r.responsibility_application_id);

Line: 960

           SELECT count(*)
             INTO l_menu_count
             FROM fnd_menu_entries_vl c
             WHERE prompt IS NOT NULL
             and menu_id=(SELECT menu_id
                            FROM fnd_responsibility_vl
                            WHERE responsibility_id = r.responsibility_id
                            AND   APPLICATION_ID    = r.responsibility_application_id)
             AND     nvl(c.FUNCTION_ID,-1) not in   -- menu exclusion support 1911095 mputman
                (select ACTION_ID
                   from   FND_RESP_FUNCTIONS
                   where  RESPONSIBILITY_ID = r.responsibility_id
                   and    APPLICATION_ID    = r.responsibility_application_id)
             AND nvl(c.SUB_MENU_ID,-1) not IN -- add support for submenu exclusions 2029055
             (select ACTION_ID
              from   FND_RESP_FUNCTIONS
                   where  RESPONSIBILITY_ID = r.responsibility_id
                   and    APPLICATION_ID    = r.responsibility_application_id);

Line: 984

              SELECT c.function_id, nvl(b.prompt,c.user_function_name) prompt,c.TYPE,a.menu_id
              INTO l_function_code, l_menu_prompt, l_function_type, l_menu_id
           from
            fnd_responsibility_vl a,
            fnd_menu_entries_vl b,
            fnd_form_functions_vl c
            where a.responsibility_id=r.responsibility_id
            and a.menu_id=b.menu_id
            and b.function_id=c.function_id
            and b.prompt is not null -- 3275654 nlbarlow
            and c.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP')
            and nvl(c.FUNCTION_ID,-1) not in -- 3275654 nlbarlow
                  (select ACTION_ID
                   from   FND_RESP_FUNCTIONS
                   where  RESPONSIBILITY_ID = r.responsibility_id
                   and    APPLICATION_ID    = r.responsibility_application_id);

Line: 1026

   select HSECS into l_start from V$TIMER;

Line: 1046

	  update ICX_SESSIONS
	     set HOME_URL = l_home_url
	   where SESSION_ID = l_session_id;

Line: 1053

       select substr(nvl(DESCRIPTION,USER_NAME),1,70)
         into l_known_as
         from FND_USER
        where USER_ID = icx_sec.g_user_id;

Line: 1059

       select page_id into l_active_page_id
         from icx_sessions
        where session_id = l_session_id;

Line: 1079

       select count(*) into l_page_count
       from icx_pages
       where user_id = icx_sec.g_user_id
       and page_type = 'MAIN';

Line: 1220

	select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
	  from icx_pages ip,
               icx_pages_tl ipt
	 where ip.user_id = p_user_id
           and ipt.language = userenv('LANG')
	   and ip.page_id = ipt.page_id
           and ip.page_type in ('USER', 'MAIN')
	order by ip.page_type desc, ip.sequence_number;

Line: 1239

       select substr(nvl(DESCRIPTION,USER_NAME),1,70)
         into l_known_as
         from FND_USER
        where USER_ID = icx_sec.g_user_id;

Line: 1245

       select page_id into l_active_page_id
         from icx_sessions
        where session_id = icx_sec.g_session_id;