APPS.OM_SETUP_VALID_PKG dependencies on FND_RESPONSIBILITY

Line 261: FROM FND_RESPONSIBILITY;

257: prof_opt_val VARCHAR2(255);
258: resps NUMARRAY:= NUMARRAY();
259: CURSOR resp_cursor IS
260: SELECT RESPONSIBILITY_ID
261: FROM FND_RESPONSIBILITY;
262: resp resp_cursor%ROWTYPE;
263: indx NUMBER;
264: BEGIN
265: indx := 1;

Line 367: FROM FND_RESPONSIBILITY_TL

363: BEGIN
364: BEGIN
365: SELECT RESPONSIBILITY_NAME
366: INTO resp_name
367: FROM FND_RESPONSIBILITY_TL
368: WHERE RESPONSIBILITY_ID = resp_id
369: AND LANGUAGE=USERENV('LANG');
370: RETURN resp_name;
371: EXCEPTION

Line 496: FROM FND_RESPONSIBILITY;

492: /***********************************************************************************************/
493: FUNCTION getRespListFromMenus ( menus SARRAY ) RETURN SARRAY AS
494: CURSOR resp_get IS
495: SELECT MENU_ID, RESPONSIBILITY_ID
496: FROM FND_RESPONSIBILITY;
497: rget resp_get%ROWTYPE;
498: ind NUMBER := 1;
499: counter NUMBER := 1;
500: ctr NUMBER := 1;

Line 808: FROM FND_RESPONSIBILITY

804: /***********************************************************************************************/
805: FUNCTION GENERATE_LIST_APPS RETURN SARRAY AS
806: CURSOR ALL_APPS(resp_id IN NUMBER) IS
807: SELECT APPLICATION_ID
808: FROM FND_RESPONSIBILITY
809: WHERE RESPONSIBILITY_ID=resp_id;
810: ctr NUMBER := 1;
811: j NUMBER := 1;
812: apps_all ALL_APPS%ROWTYPE;

Line 1687: FROM FND_RESPONSIBILITY

1683: FOR k IN 1..APPS_LIST.COUNT
1684: LOOP
1685: SELECT COUNT(APPLICATION_ID)
1686: INTO appcount
1687: FROM FND_RESPONSIBILITY
1688: WHERE RESPONSIBILITY_ID = RESP_LIST(j)
1689: AND APPLICATION_ID = APPS_LIST(k);
1690: IF ( appcount>0 ) THEN
1691: sobgl:=getProfileOptionValue(10002, APPS_LIST(k), 1202);