eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_MENU_PUB dependencies on FND_RESPONSIBILITY

Line 198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

194: cnt number := 0;
195: l_resp_name varchar2(256);
196: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
197: select b.menu_id, b.menu_name , t.user_menu_name, t.description
198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
199: where b.menu_id = t.menu_id and
200: t.language = pp_lang and
201: b.menu_id = r.menu_id and
202: r.responsibility_id = pp_respid and

Line 207: -- from fnd_responsibility_tl t, fnd_responsibility b

203: r.application_id = pp_appid;
204:
205: -- cursor get_responsibilities(pp_menuid number, pp_lang varchar2) is
206: -- select b.responsibility_id, t.responsibility_name
207: -- from fnd_responsibility_tl t, fnd_responsibility b
208: -- where b.responsibility_id = t.responsibility_id and
209: -- b.application_id = t.application_id and
210: -- t.language = pp_lang and
211: -- b.menu_id = pp_menuid;

Line 235: from fnd_responsibility_tl t, fnd_responsibility b

231: --p_responsibility_table(cnt).responsibility_name := c1.responsibility_name;
232: cnt := cnt + 1;
233: p_responsibility_table(cnt).responsibility_id := p_respid;
234: select t.responsibility_name into l_resp_name
235: from fnd_responsibility_tl t, fnd_responsibility b
236: where b.responsibility_id = t.responsibility_id and
237: b.application_id = t.application_id and
238: t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
239: p_responsibility_table(cnt).responsibility_name := l_resp_name;

Line 260: --from fnd_menus_vl a , fnd_responsibility b

256: -- here's the old cursor definition, which assumed userenv('lang')
257: -- was set correctly:
258: -- cursor root_menu(pp_respid number, pp_appid number) is
259: --select a.menu_id, a.menu_name , a.user_menu_name, a.description
260: --from fnd_menus_vl a , fnd_responsibility b
261: --where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
262: --and b.application_id = pp_appid;
263:
264: -- here's the new one, which assumes we use pp_lang instead

Line 267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

263:
264: -- here's the new one, which assumes we use pp_lang instead
265: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
266: select b.menu_id, b.menu_name , t.user_menu_name, t.description
267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
268: where b.menu_id = t.menu_id and
269: t.language = pp_lang and
270: b.menu_id = r.menu_id and
271: r.responsibility_id = pp_respid and

Line 278: -- from fnd_responsibility_vl a

274: -- here's the old cursor definition, which assumed userenv('lang')
275: -- was set correctly:
276: -- cursor get_responsibilities(pp_menuid number) is
277: -- select a.responsibility_id, a.responsibility_name
278: -- from fnd_responsibility_vl a
279: -- where a.menu_id = pp_menuid;
280:
281: -- here's the new one, which assumes we use pp_lang instead
282: -- cursor get_responsibilities(pp_menuid number, pp_lang varchar2) is

Line 284: -- from fnd_responsibility_tl t, fnd_responsibility b

280:
281: -- here's the new one, which assumes we use pp_lang instead
282: -- cursor get_responsibilities(pp_menuid number, pp_lang varchar2) is
283: -- select b.responsibility_id, t.responsibility_name
284: -- from fnd_responsibility_tl t, fnd_responsibility b
285: -- where b.responsibility_id = t.responsibility_id and
286: -- b.application_id = t.application_id and
287: -- t.language = pp_lang and
288: -- b.menu_id = pp_menuid;

Line 310: from fnd_responsibility_tl t, fnd_responsibility b

306: --p_responsibility_table(cnt).responsibility_name := c1.responsibility_name;
307: cnt := cnt + 1;
308: p_responsibility_table(cnt).responsibility_id := p_respid;
309: select t.responsibility_name into l_resp_name
310: from fnd_responsibility_tl t, fnd_responsibility b
311: where b.responsibility_id = t.responsibility_id and
312: b.application_id = t.application_id and
313: t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
314: p_responsibility_table(cnt).responsibility_name := l_resp_name;

Line 332: from fnd_menus_vl a , fnd_responsibility b

328: cnt number := 0;
329: l_resp_name varchar2(256);
330: cursor root_menu(pp_respid number, pp_appid number) is
331: select a.menu_id, a.menu_name , a.user_menu_name, a.description
332: from fnd_menus_vl a , fnd_responsibility b
333: where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
334: and b.application_id = pp_appid;
335:
336: --cursor get_responsibilities(pp_menuid number) is

Line 338: --from fnd_responsibility_vl a

334: and b.application_id = pp_appid;
335:
336: --cursor get_responsibilities(pp_menuid number) is
337: --select a.responsibility_id, a.responsibility_name
338: --from fnd_responsibility_vl a
339: --where a.menu_id = pp_menuid;
340:
341: BEGIN
342:

Line 357: from fnd_responsibility_vl a

353: --p_responsibility_table(cnt).responsibility_name := c1.responsibility_name;
354: cnt := cnt + 1;
355: p_responsibility_table(cnt).responsibility_id := p_respid;
356: select a.responsibility_name into l_resp_name
357: from fnd_responsibility_vl a
358: where a.responsibility_id = p_respid and a.application_id = p_appid;
359: p_responsibility_table(cnt).responsibility_name := l_resp_name;
360: --END LOOP;
361: