APPS.ICX_LOGIN SQL Statements

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

Line: 43

select  sub_menu_id
from    fnd_menu_entries
where   menu_id = p_sub_menu_id
and     sub_menu_id is not null
order by entry_sequence;

Line: 52

    select menu_id, entry_sequence
    into   l_menu_id, l_entry_sequence
    from   fnd_form_functions a,
           fnd_menu_entries b
    where b.menu_id = p_sub_menu_id
    and   b.function_id = a.function_id
    and   a.function_name = 'ICX_NAVIGATE_PLUG';

Line: 98

select  a.responsibility_id,
        a.menu_id
from    fnd_responsibility_vl a,
        FND_USER_RESP_GROUPS b
where   b.user_id = p_user_id
and     b.start_date <= sysdate
and     (b.end_date is null or b.end_date > sysdate)
and     b.RESPONSIBILITY_application_id = a.responsibility_id
and     a.version = 'W'
and     a.start_date <= sysdate
and     (a.end_date is null or a.end_date > sysdate)
order by responsibility_name;

Line: 114

    select min(PAGE_ID)
    into   l_page_id
    from   icx_pages
    where user_id = p_user_id
    and PAGE_TYPE = 'USER';

Line: 127

    select icx_pages_s.nextval, icx_page_plugs_s.nextval
    into   l_page_id,l_plug_id
    from sys.dual;

Line: 131

    select nvl(max(sequence_number),1)
      into l_sequence_number
      from icx_pages
     where user_id = icx_sec.g_user_id;

Line: 143

    ICX_PAGES_PKG.INSERT_ROW(
                x_rowid                 => l_rowid,
		x_page_id		=> l_page_id,
		x_page_code		=>  'ICX_PAGE_' || l_page_id,
		x_main_region_id	=> l_main_region_id,
		x_sequence_number	=> l_sequence_number + 1,
		x_page_type		=> 'USER',
		x_user_id		=> icx_sec.g_user_id,
		x_refresh_rate		=> 0,
		x_page_name		=> substrb(wf_core.translate('ICX_MY_HOME'),1,80),
		x_page_description	=> p_user_id,
                x_creation_date		=> sysdate,
		x_created_by		=> p_user_id,
		x_last_update_date	=> sysdate,
		x_last_updated_by	=> 1,
		x_last_update_login	=> 1);

Line: 182

    select count(*) into l_count
    from icx_page_color_scheme
    where user_id = p_user_id;

Line: 186

      insert into icx_page_color_scheme
      (user_id,
       toolbar_color,
       heading_color,
       banner_color,
       background_color,
       color_scheme,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by,
       last_update_login)
       values
      (p_user_id,
       '#0000CC',
       '#99CCFF',
       '#99CCFF',
       '#FFFFFF',
       'BL',
       sysdate,1,sysdate,1,1);

Line: 222

    select function_id, user_function_name
    into   l_function_id, l_display_name
    from   fnd_form_functions_vl
    where  function_name = 'ICX_NAVIGATE_PLUG';

Line: 227

    insert into icx_page_plugs
    (plug_id,
     page_id,
     display_sequence,
     responsibility_id,
     menu_id,
     entry_sequence,
     display_name,
     region_id,
     creation_date,
     created_by,
     last_update_date,
     last_updated_by,
     last_update_login)
    values
    (l_plug_id,
     l_page_id,
     0,
     -1,
     -1,
     l_function_id,
     l_display_name,
     l_main_region_id,
     sysdate,1,sysdate,1,1);

Line: 258

  select MIN(page_id)
  into   l_page_id
  from   ICX_PAGES
  where user_id = p_user_id
  and   page_type = 'USER';