DBA Data[Home] [Help]

APPS.JTF_MENU_PUB dependencies on FND_RESPONSIBILITY_VL

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 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: