APPS.FRM_SECURITY_PKG dependencies on FRM_DIRECTORY_VL

Line 105: FROM FRM_DIRECTORY_VL DIR

101: INTO VN_RECORD_CNT2
102: FROM FRM_MENU_USER_MAPPINGS MAP
103: WHERE MAP.NODE_ID IN
104: (SELECT DIR.PARENT_ID
105: FROM FRM_DIRECTORY_VL DIR
106: START WITH DIR.DIRECTORY_ID = VN_DIRECTORY_ID
107: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
108: AND DIR.PARENT_ID <> -1
109: ) OR MAP.NODE_ID = VN_DIRECTORY_ID

Line 171: FROM FRM_DIRECTORY_VL DIR

167: -- otherwise exit the loop with parent access flag to 'N'
168: -- if all the parent's are accessible and document is also accessible then return 'Y'.
169:
170: OPEN C_PARENT_LIST FOR SELECT * FROM (SELECT DIR.PARENT_ID AS DIRECTORY_ID, LEVEL + 1 AS DIR_LEVEL
171: FROM FRM_DIRECTORY_VL DIR
172: START WITH DIR.DIRECTORY_ID = VN_DIRECTORY_ID
173: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
174: AND DIR.PARENT_ID <> -1
175: UNION

Line 177: FROM FRM_DIRECTORY_VL DIR

173: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
174: AND DIR.PARENT_ID <> -1
175: UNION
176: SELECT DIR.DIRECTORY_ID AS DIRECTORY_ID, 1 AS DIR_LEVEL
177: FROM FRM_DIRECTORY_VL DIR
178: WHERE DIR.DIRECTORY_ID = VN_DIRECTORY_ID)
179: ORDER BY DIR_LEVEL DESC;
180:
181: LOOP

Line 322: FROM FRM_DIRECTORY_VL DIR

318: ELSE
319:
320: SELECT DIR.PARENT_ID
321: INTO VN_DIRECTORY_ID
322: FROM FRM_DIRECTORY_VL DIR
323: WHERE DIR.DIRECTORY_ID = P_MENU_ID
324: AND (DIR.END_DATE IS NULL OR DIR.END_DATE > SYSDATE);
325:
326: END IF;

Line 359: FROM FRM_DIRECTORY_VL DIR

355: INTO VN_RECORD_CNT2
356: FROM FRM_MENU_USER_MAPPINGS MAP
357: WHERE MAP.NODE_ID IN
358: (SELECT DIR.PARENT_ID
359: FROM FRM_DIRECTORY_VL DIR
360: START WITH DIR.DIRECTORY_ID = VN_DIRECTORY_ID
361: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
362: AND DIR.PARENT_ID <> -1
363: ) OR MAP.NODE_ID = VN_DIRECTORY_ID

Line 460: FROM FRM_DIRECTORY_VL DIR

456: -- for all other cases return 'N'
457:
458:
459: OPEN C_PARENT_LIST FOR SELECT * FROM (SELECT DIR.PARENT_ID AS DIRECTORY_ID, LEVEL + 1 AS DIR_LEVEL
460: FROM FRM_DIRECTORY_VL DIR
461: START WITH DIR.DIRECTORY_ID = VN_DIRECTORY_ID
462: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
463: AND DIR.PARENT_ID <> -1
464: UNION

Line 466: FROM FRM_DIRECTORY_VL DIR

462: CONNECT BY PRIOR DIR.PARENT_ID = DIR.DIRECTORY_ID
463: AND DIR.PARENT_ID <> -1
464: UNION
465: SELECT DIR.DIRECTORY_ID AS DIRECTORY_ID, 1 AS DIR_LEVEL
466: FROM FRM_DIRECTORY_VL DIR
467: WHERE DIR.DIRECTORY_ID = VN_DIRECTORY_ID)
468: ORDER BY DIR_LEVEL DESC;
469:
470: LOOP

Line 607: FROM FRM_DIRECTORY_VL DIR

603: ELSE
604:
605: SELECT DIR.DIRECTORY_ID
606: INTO VN_MENU_ID
607: FROM FRM_DIRECTORY_VL DIR
608: WHERE DIR.DIRECTORY_ID = P_MENU_ID
609: AND (DIR.END_DATE IS NULL OR DIR.END_DATE > SYSDATE);
610:
611: END IF;