APPS.JTF_MENU_PUB dependencies on DUAL

Line 150: select userenv('lang') into t_lang from dual;

146: t_kids_menu_data menu_table;
147: t_lang varchar2(25); -- probably '5' was enuf, I don't know the max
148: begin
149: if p_lang is null then
150: select userenv('lang') into t_lang from dual;
151: else
152: t_lang := p_lang;
153: end if;
154:

Line 214: select userenv('lang') into t_lang from dual;

210: -- t.language = pp_lang and
211: -- b.menu_id = pp_menuid;
212: BEGIN
213: if p_lang is null then
214: select userenv('lang') into t_lang from dual;
215: else
216: t_lang := p_lang;
217: end if;
218:

Line 291: select userenv('lang') into t_lang from dual;

287: -- t.language = pp_lang and
288: -- b.menu_id = pp_menuid;
289: BEGIN
290: if p_lang is null then
291: select userenv('lang') into t_lang from dual;
292: else
293: t_lang := p_lang;
294: end if;
295:

Line 401: select userenv('lang') into t_lang from dual;

397: AND T.LANGUAGE = pp_lang
398: order by b.entry_sequence;
399: begin
400: if p_lang is null then
401: select userenv('lang') into t_lang from dual;
402: else
403: t_lang := p_lang;
404: end if;
405:

Line 465: select userenv('lang') into t_lang from dual;

461: AND T.LANGUAGE = pp_lang
462: order by b.entry_sequence;
463: begin
464: if p_lang is null then
465: select userenv('lang') into t_lang from dual;
466: else
467: t_lang := p_lang;
468: end if;
469:

Line 619: select userenv('lang') into t_lang from dual;

615: WHERE B.FUNCTION_ID = T.FUNCTION_ID AND T.LANGUAGE = pp_lang and
616: b.function_id = p_func_id;
617: begin
618: if p_lang is null then
619: select userenv('lang') into t_lang from dual;
620: else
621: t_lang := p_lang;
622: end if;
623:

Line 670: select userenv('lang') into t_lang from dual;

666: AND T.LANGUAGE = pp_lang and
667: b.rowid = chartorowid(p_row_id);
668: begin
669: if p_lang is null then
670: select userenv('lang') into t_lang from dual;
671: else
672: t_lang := p_lang;
673: end if;
674: