APPS.ICX_PORTLET SQL Statements

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

Line: 11

      select  fr.RESPONSIBILITY_NAME,
              fr.APPLICATION_ID,
              fr.RESPONSIBILITY_ID,
              furg.SECURITY_GROUP_ID
      from    FND_MENU_ENTRIES fme,
              FND_RESPONSIBILITY_VL fr,
              FND_USER_RESP_GROUPS furg
      where   furg.USER_ID = icx_sec.g_user_id
      and     furg.RESPONSIBILITY_APPLICATION_ID = fr.APPLICATION_ID
      and     furg.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
      and     fr.MENU_ID = fme.MENU_ID
      and     fme.FUNCTION_ID = p_portlet_id;

Line: 38

      select security_group_name
      into l_security_group_name
      from fnd_security_groups_vl
      where security_group_id = f.security_group_id;

Line: 277

select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;

Line: 282

update icx_portlet_customizations
set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key, '0')) + 1)
where  user_id = l_user_id;

Line: 295

select function_id
into l_function_id
from fnd_form_functions
where function_name = p_function_name;

Line: 300

update icx_portlet_customizations
set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key, '0')) + 1)
where  function_id = l_function_id;

Line: 306

procedure updateCacheByUserFunc(p_user_name varchar2, p_function_name varchar2)
is

l_function_id number;

Line: 314

select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;

Line: 319

select function_id
into l_function_id
from fnd_form_functions
where function_name = p_function_name;

Line: 324

update icx_portlet_customizations
set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key, '0')) + 1)
where  function_id = l_function_id
and    user_id = l_user_id;

Line: 335

select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;

Line: 342

update icx_portlet_customizations
set caching_key = l_caching_key_value
where  user_id = l_user_id;

Line: 355

select function_id
into l_function_id
from fnd_form_functions
where function_name = p_function_name;

Line: 362

update icx_portlet_customizations
set caching_key = l_caching_key_value
where  function_id = l_function_id;

Line: 369

procedure updateCacheKeyValueByUserFunc(p_user_name varchar2, p_function_name varchar2, p_caching_key_value varchar2) is

l_function_id number;

Line: 377

select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;

Line: 382

select function_id
into l_function_id
from fnd_form_functions
where function_name = p_function_name;

Line: 389

update icx_portlet_customizations
set caching_key = l_caching_key_value
where  function_id = l_function_id
and    user_id = l_user_id;

Line: 405

update icx_portlet_customizations
set caching_key = l_caching_key_value
where reference_path = l_reference_path;

Line: 444

      SELECT SECURITY_GROUP_ID
      INTO l_security_group_id
      FROM fnd_security_groups
      WHERE security_group_key = p_security_group_key;

Line: 458

      SELECT application_id
      INTO l_application_id
      FROM fnd_application
      WHERE application_short_name = p_application_short_name;

Line: 463

      SELECT responsibility_id
      INTO l_responsibility_id
      FROM fnd_responsibility
      WHERE responsibility_key = p_responsibility_key
      AND application_id = l_application_id;

Line: 469

      SELECT function_id
      INTO l_function_id
      FROM fnd_form_functions
      WHERE function_name = p_function_name;

Line: 552

  select caching_key into cachingKey
  from icx_portlet_customizations
  where reference_path = p_reference_path;