APPS.ORACLENAVIGATE SQL Statements

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

Line: 32

    select HSECS into l_hsecs from V$TIMER;

Line: 45

    select count(*)
    into   l_security_group_count
    from   fnd_security_groups
    where  security_group_id >= 0;

Line: 81

select  prompt,
        description,
        sub_menu_id,
	entry_sequence
from    fnd_menu_entries_vl
where   menu_id = p_object.parent_menu_id
and	sub_menu_id is not null
and     function_id is null
and     prompt is not null
  AND nvl(SUB_MENU_ID,-1) not IN -- add support for submenu exclusions 2029055
             (select ACTION_ID
              from   FND_RESP_FUNCTIONS
              where  RESPONSIBILITY_ID = p_object.responsibility_id
              and    APPLICATION_ID    = p_object.resp_appl_id)
order by entry_sequence;

Line: 98

SELECT  b.prompt prompt,    --mputman removed nvl() 1911095
        nvl(b.description,b.prompt) description,
        b.function_id,
        b.entry_sequence,
	a.type,
        a.web_html_call
from    fnd_form_functions_vl a,
	fnd_menu_entries_vl b
where   b.menu_id = p_object.parent_menu_id
AND b.prompt IS NOT NULL -- mputman added 1815466
--AND b.grant_flag='Y'
--removed grant_flag bug 3575253
and	a.function_id = b.function_id
and     a.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP')
and    nvl(a.FUNCTION_ID,-1) not in   -- menu exclusion support 1911095 mputman
             (select ACTION_ID
              from   FND_RESP_FUNCTIONS
              where  RESPONSIBILITY_ID = p_object.responsibility_id
              and    APPLICATION_ID    = p_object.resp_appl_id)
order by entry_sequence;

Line: 141

  select  count(*)
  into    l_count
  from    fnd_form_functions a,
          fnd_menu_entries b
  where   b.menu_id = p_object.parent_menu_id
  and     a.function_id = b.function_id
  and     a.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP')
--AND b.grant_flag='Y'
--removed grant_flag bug 3575253

and    nvl(a.FUNCTION_ID,-1) not in   -- menu exclusion support 1911095 mputman
             (select ACTION_ID
              from   FND_RESP_FUNCTIONS
              where  RESPONSIBILITY_ID = p_object.responsibility_id
              and    APPLICATION_ID    = p_object.resp_appl_id);

Line: 234

select  count(*)
into    l_count
from    fnd_menu_entries
where   menu_id = p_object.parent_menu_id
and     sub_menu_id is not null;

Line: 292

select  prompt,
        description,
        sub_menu_id
into	l_prompt,
	l_description,
	l_sub_menu_id
from    fnd_menu_entries_vl
where   menu_id = p_object.parent_menu_id
and	entry_sequence = p_object.entry_sequence
order by entry_sequence;

Line: 365

select  responsibility_name,
        description,
        menu_id
into    l_responsibility_name,
        l_description,
        l_menu_id
from    fnd_responsibility_vl
where   application_id = p_object.resp_appl_id
and     responsibility_id = p_object.responsibility_id
and     version in ('4','W')
and     start_date <= sysdate
and     (end_date is null or end_date > sysdate);

Line: 527

select distinct b.RESPONSIBILITY_APPLICATION_ID,
        a.RESPONSIBILITY_ID,
        b.SECURITY_GROUP_ID,
        a.RESPONSIBILITY_NAME,
        a.DESCRIPTION,
        fsg.SECURITY_GROUP_NAME,
        m.TYPE,
        m.menu_id
from    FND_SECURITY_GROUPS_VL fsg,
        FND_RESPONSIBILITY_VL a,
        FND_USER_RESP_GROUPS b,
        fnd_menus m
where   b.user_id = icx_sec.g_user_id
AND     a.menu_id = m.menu_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.version IN ('W')
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
AND fsg.SECURITY_GROUP_ID >= 0
AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;

Line: 576

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

Line: 594

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

Line: 675

          select page_id into l_page_id
            from icx_sessions
           where session_id = l_session_id;

Line: 681

              select display_name
		into l_name
		from icx_page_plugs a,
		     icx_pages b
	       where b.user_id = icx_sec.g_user_id
		 and b.page_id = a.page_id
		 and a.page_id = l_page_id
		 and a.responsibility_id = -1
		 and a.menu_id = -1;

Line: 704

   	       select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
	         into l_name
	         from icx_page_plugs ipp,
		      fnd_menu_entries_vl fme,
		      fnd_form_functions fff
	        where ipp.page_id = l_page_id
		  and ipp.menu_id = fme.menu_id
		  and ipp.entry_sequence = fme.entry_sequence
		  and fff.function_id = fme.function_id
		  and fff.function_name = 'ICX_NAVIGATE_PLUG';

Line: 724

	     select DISPLAY_NAME
	       into l_name
	       from ICX_PAGE_PLUGS a,
		    ICX_PAGES b
	      where b.USER_ID = icx_sec.g_user_id
		and b.PAGE_ID = a.PAGE_ID
		and a.RESPONSIBILITY_ID = -1
		and a.MENU_ID = -1
		and b.page_id in (select MIN(page_id)
				    from ICX_PAGES
				   where user_id = icx_sec.g_user_id
				     and PAGE_TYPE = 'USER');

Line: 750

		select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
		  into l_name
		  from icx_page_plugs ipp,
		       fnd_menu_entries_vl fme,
		       fnd_form_functions fff
		 where ipp.menu_id = fme.menu_id
		   and ipp.entry_sequence = fme.entry_sequence
		   and fff.function_id = fme.function_id
		   and fff.function_name = 'ICX_NAVIGATE_PLUG'
		   and ipp.page_id in (select MIN(page_id)
					 from ICX_PAGES
					where user_id = icx_sec.g_user_id
					  and PAGE_TYPE = 'USER');

Line: 773

   SELECT display_name
      INTO l_name
      FROM icx_page_plugs
      WHERE plug_id= D;

Line: 802

    select b.RESPONSIBILITY_APPLICATION_ID,
           b.SECURITY_GROUP_ID,
           a.RESPONSIBILITY_NAME,
           a.DESCRIPTION,
           fsg.SECURITY_GROUP_NAME
    into   l_resp_appl_id,
           l_security_group_id,
           l_responsibility_name,
           l_responsibility_description,
           l_security_group_name
    from   FND_SECURITY_GROUPS_VL fsg,
           FND_RESPONSIBILITY_VL a,
           FND_USER_RESP_GROUPS b
    where  b.USER_ID = icx_sec.g_user_id
    and    a.APPLICATION_ID = b.RESPONSIBILITY_APPLICATION_ID
    and    a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
    and    a.RESPONSIBILITY_ID = l_responsibility_id
    and    b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
    and    fsg.SECURITY_GROUP_ID = l_security_group_id;

Line: 984

           SELECT function_id
             INTO l_function_id
             FROM fnd_menu_entries_vl
             WHERE menu_id=r.menu_id
             AND FUNCTION_ID is not null
             AND ROWNUM=1
             ORDER BY entry_sequence;

Line: 1194

                   p_delete     VARCHAR2) is

l_object		object;

Line: 1209

select distinct a.responsibility_id,
        a.responsibility_name,
        a.description,
        a.responsibility_key,
        b.responsibility_application_id,
        fsg.SECURITY_GROUP_NAME,
        fsg.SECURITY_GROUP_ID,
        fsg.security_group_key,
        fa.application_short_name,
        m.menu_id,
        m.type,
        a.version
from    FND_SECURITY_GROUPS_VL fsg,
        fnd_responsibility_vl a,
        FND_USER_RESP_GROUPS b,
        FND_APPLICATION fa,
        FND_MENUS m
where   b.user_id = icx_sec.g_user_id
AND     m.menu_id = a.menu_id
and     version in ('4','W')
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.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
AND fsg.SECURITY_GROUP_ID >= 0
AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;

Line: 1244

if p_delete = 'Y'
then
  l_agent := l_agent;

Line: 1310

           SELECT function_id
             INTO l_function_id
             FROM fnd_menu_entries_vl
             WHERE menu_id=r.menu_id
             AND FUNCTION_ID is not null
             AND ROWNUM=1
             ORDER BY entry_sequence;

Line: 1342

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

Line: 1407

                   p_delete     varchar2) is

l_object object;

Line: 1417

    select RESPONSIBILITY_APPLICATION_ID,
           RESPONSIBILITY_ID,
           a.SECURITY_GROUP_ID,
           PROMPT,
           DESCRIPTION,
           a.FUNCTION_ID,
           FUNCTION_TYPE,
           URL,
           WEB_HTML_CALL
    from   FND_FORM_FUNCTIONS_VL b,
           ICX_CUSTOM_MENU_ENTRIES a
    where  USER_ID = icx_sec.g_user_id
    and    PLUG_ID = p_plug_id
    and    b.FUNCTION_ID(+) = a.FUNCTION_ID
    and    ( RESPONSIBILITY_ID in
           (select responsibility_id from
              icx_custom_menu_entries
            where USER_ID=icx_sec.g_user_id
            intersect
            select RESPONSIBILITY_ID from fnd_user_resp_groups where
              USER_ID=icx_sec.g_user_id
            and
              start_date <= sysdate
            and
              (end_date is null or end_date > sysdate)
            ) or responsibility_id=0)
            order by DISPLAY_SEQUENCE;

Line: 1446

if p_delete = 'Y'
then
  begin
    delete ICX_CUSTOM_MENU_ENTRIES
    where  USER_ID = icx_sec.g_user_id
    and    PLUG_ID = p_plug_id;

Line: 1685

    htp.p('var temp=parent.opener.parent.document.Favorites.C.selectedIndex;

Line: 1697

        var temp=parent.opener.parent.document.Favorites.C.selectedIndex;

Line: 1792

select distinct a.responsibility_id,
	a.responsibility_name,
        a.application_id,
        b.security_group_id,
        fsg.SECURITY_GROUP_NAME
from    FND_SECURITY_GROUPS_VL fsg,
        fnd_responsibility_vl a,
        FND_USER_RESP_GROUPS b
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.version IN ('W')
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
AND fsg.SECURITY_GROUP_ID >= 0
AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;

Line: 1815

select PROMPT,
       RESPONSIBILITY_APPLICATION_ID,
       RESPONSIBILITY_ID,
       SECURITY_GROUP_ID,
       FUNCTION_ID,
       FUNCTION_TYPE,
       URL
from   ICX_CUSTOM_MENU_ENTRIES
where  USER_ID = icx_sec.g_user_id
and    PLUG_ID = l_plug_id
order by DISPLAY_SEQUENCE;

Line: 1863

        var temp=document.Favorites.A.selectedIndex;

Line: 1916

    fnd_message.set_name('ICX','ICX_OBIS_SELECT_OPTION');

Line: 1919

    htp.p('function selectFrom() {
        alert("'||l_message||'")
        }');

Line: 1924

        var temp=document.Favorites.B.selectedIndex;

Line: 1927

          selectFrom();

Line: 1933

          var resp=document.Favorites.A.selectedIndex;

Line: 1937

          document.Favorites.C.selectedIndex = end;

Line: 1942

    fnd_message.set_name('ICX','ICX_OBIS_SELECT_SELECTION');

Line: 1945

    htp.p('function selectTo() {
        alert("'||l_message||'")
        }');

Line: 1950

        var temp=document.Favorites.C.selectedIndex;

Line: 1956

	  selectTo();

Line: 1963

          document.Favorites.C.selectedIndex = temp-1;

Line: 1968

        var temp=document.Favorites.C.selectedIndex;

Line: 1974

          selectTo();

Line: 1981

          document.Favorites.C.selectedIndex = temp+1;

Line: 1987

    htp.p('function deleteTo() {
        var temp=document.Favorites.C.selectedIndex;

Line: 1991

          selectTo();

Line: 2009

        var temp=document.Favorites.C.selectedIndex;

Line: 2010

        var temp2=document.Favorites.C.options[document.Favorites.C.selectedIndex].value;

Line: 2014

          selectTo();

Line: 2031

            document.updateFavorites.X.value = document.updateFavorites.X.value + "+" + document.Favorites.C.options[i].value + "*" + document.Favorites.C.options[i].text;

Line: 2033

	document.updateFavorites.X.value = document.updateFavorites.X.value + "+";

Line: 2034

	document.updateFavorites.submit();

Line: 2047

    htp.formOpen('OracleNavigate.updateFavorites','POST','','','NAME="updateFavorites"');

Line: 2069

    htp.p('');

Line: 2073

    htp.formSelectOption(cvalue => l_responsibilities(r),
                         cattributes => 'VALUE = "'||l_resp_appl_ids(r)||'*'||l_responsibility_ids(r)||'*'||l_security_group_ids(r)||'"');

Line: 2077

    htp.formSelectOption(cvalue => '',
                         cattributes => 'VALUE = ""');

Line: 2080

    htp.formSelectClose;

Line: 2089

    htp.p('');

    htp.formSelectOption(l_initialize);

    htp.formSelectClose;

    htp.p('');

Line: 2103

      htp.formSelectOption('____________________________________________');

Line: 2112

        htp.formSelectOption(cvalue => f.prompt,
                             cattributes => 'VALUE = '||l_favorite);

Line: 2115

    htp.formSelectClose;

Line: 2131

    icx_plug_utilities.buttonBoth(l_prompts(11),'javascript:deleteTo()');

Line: 2165

procedure updateFavorites(X in varchar2,
                          Y in pls_integer) is

l_plug_id               pls_integer;

Line: 2204

    delete ICX_CUSTOM_MENU_ENTRIES
    where  USER_ID = icx_sec.g_user_id
    and    PLUG_ID = l_plug_id;

Line: 2238

        insert into ICX_CUSTOM_MENU_ENTRIES
	(USER_ID,
         PLUG_ID,
         DISPLAY_SEQUENCE,
         PROMPT,
         RESPONSIBILITY_APPLICATION_ID,
         RESPONSIBILITY_ID,
         SECURITY_GROUP_ID,
         FUNCTION_ID,
         FUNCTION_TYPE,
         URL)
	values
	(icx_sec.g_user_id,
         l_plug_id,
         l_index,
         l_prompt,
         l_resp_appl_id,
         l_responsibility_id,
         l_security_group_id,
         l_function_id,
         l_function_type,
         l_url);

Line: 2312

      SELECT web_html_call
         INTO l_web_call
         FROM fnd_form_functions_vl
         WHERE function_id=p_function_id;