APPS.ICX_PLUG_UTILITIES SQL Statements

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

Line: 12

    select BACKGROUND_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 36

    select BACKGROUND_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 59

    select HEADING_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 79

    select HEADING_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 101

    select BANNER_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 121

     select COLOR_SCHEME
     into   l_color
     from ICX_PAGE_COLOR_SCHEME
     where  USER_ID = icx_sec.g_user_id;

Line: 142

    select BANNER_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 164

    select TOOLBAR_COLOR
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 186

    select COLOR_SCHEME
    into   l_color
    from   ICX_PAGE_COLOR_SCHEME
    where  USER_ID = icx_sec.g_user_id;

Line: 279

select DISPLAY_NAME,MENU_ID,ENTRY_SEQUENCE
into   l_plug_title,l_menu_id,l_entry_sequence
from   ICX_PAGE_PLUGS
where  PLUG_ID = p_plug_id;

Line: 286

    select nvl(PROMPT,DESCRIPTION)
    into   l_plug_title
    from   FND_MENU_ENTRIES_VL
    where  MENU_ID = l_menu_id
    and    ENTRY_SEQUENCE = l_entry_sequence;

Line: 681

    select menu_id
      into l_menu_id
      from icx_sessions
     where session_id = icx_sec.g_session_id;