APPS.JTF_MENU_PUB SQL Statements

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

Line: 27

	select  a.sub_menu_id , prompt,description,function_id,menu_name
	from 	fnd_menu_entries_vl a, fnd_menus b
	where 	a.menu_id = p_menuid  and b.menu_id(+) = a.sub_menu_id ;

Line: 32

  select  web_host_name, web_agent_name,web_html_call,
      web_encrypt_parameters, web_secured,
      web_icon,function_id, function_name,application_id, creation_date,type,
      user_function_name, description
    from fnd_form_functions_vl
    where function_id = p_functionid;

Line: 58

      select rule_type from fnd_resp_functions where
        application_id = pp_appid and responsibility_id = pp_respid and
        action_id = pp_action_id and rule_type = pp_rule_type;

Line: 150

      select userenv('lang') into t_lang from dual;

Line: 197

      select  b.menu_id, b.menu_name , t.user_menu_name, t.description
      from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
      where b.menu_id = t.menu_id and
	t.language = pp_lang and
	b.menu_id = r.menu_id and
	r.responsibility_id = pp_respid and
	r.application_id = pp_appid;

Line: 214

      select userenv('lang') into t_lang from dual;

Line: 234

      select t.responsibility_name into l_resp_name
        from fnd_responsibility_tl t, fnd_responsibility b
        where b.responsibility_id = t.responsibility_id and
          b.application_id = t.application_id and
          t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;

Line: 266

      select  b.menu_id, b.menu_name , t.user_menu_name, t.description
      from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
      where b.menu_id = t.menu_id and
	t.language = pp_lang and
	b.menu_id = r.menu_id and
	r.responsibility_id = pp_respid and
	r.application_id = pp_appid;

Line: 291

      select userenv('lang') into t_lang from dual;

Line: 309

      select t.responsibility_name into l_resp_name
        from fnd_responsibility_tl t, fnd_responsibility b
        where b.responsibility_id = t.responsibility_id and
          b.application_id = t.application_id and
          t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;

Line: 331

select  a.menu_id, a.menu_name , a.user_menu_name, a.description
from  fnd_menus_vl a , fnd_responsibility b
where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
and   b.application_id = pp_appid;

Line: 356

      select a.responsibility_name into l_resp_name
      from fnd_responsibility_vl a
      where a.responsibility_id  = p_respid and a.application_id = p_appid;

Line: 389

      SELECT
    rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
    B.SUB_MENU_ID, B.FUNCTION_ID,
    B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
      FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
      WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
        and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
        AND T.LANGUAGE = pp_lang
      order by b.entry_sequence;

Line: 401

      select userenv('lang') into t_lang from dual;

Line: 453

      SELECT
    rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
    B.SUB_MENU_ID, B.FUNCTION_ID,
    B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
      FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
      WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
        and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
        AND T.LANGUAGE = pp_lang
      order by b.entry_sequence;

Line: 465

      select userenv('lang') into t_lang from dual;

Line: 509

select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.row_id) menu_entry_rowid
from fnd_menu_entries_vl a, fnd_menus b
where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
order by entry_sequence;

Line: 560

select sub_menu_id, prompt, description, function_id, '' menu_name, rowidtochar(row_id) menu_entry_rowid
  from fnd_menu_entries_vl
    where menu_id = p_mid
    order by entry_sequence;

Line: 612

    SELECT
      T.USER_FUNCTION_NAME
    FROM FND_FORM_FUNCTIONS_TL T, FND_FORM_FUNCTIONS B
    WHERE B.FUNCTION_ID = T.FUNCTION_ID AND T.LANGUAGE = pp_lang and
      b.function_id = p_func_id;

Line: 619

      select userenv('lang') into t_lang from dual;

Line: 638

select user_function_name
from fnd_form_functions_vl
where function_id = p_func_id;

Line: 663

      SELECT T.PROMPT
        FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B
        WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
          AND T.LANGUAGE = pp_lang and
	    b.rowid = chartorowid(p_row_id);

Line: 670

      select userenv('lang') into t_lang from dual;

Line: 689

select prompt
from fnd_menu_entries_vl
--where rowid = chartorowid(p_row_id);

Line: 714

      SELECT T.USER_MENU_NAME
      FROM FND_MENUS_TL T, FND_MENUS B
      WHERE B.MENU_ID = T.MENU_ID AND T.LANGUAGE = pp_lang and
        b.menu_id = p_menu_id;

Line: 733

select user_menu_name
from fnd_menus_vl
where menu_id = p_menu_id;