APPS.FRM_SECURITY_PKG dependencies on FRM_MENU_USER_MAPPINGS

Line 94: FROM FRM_MENU_USER_MAPPINGS MAP

90: -- Get Menu Access List Record Count
91:
92: SELECT COUNT(DISTINCT MAP.NODE_ID)
93: INTO VN_RECORD_CNT1
94: FROM FRM_MENU_USER_MAPPINGS MAP
95: WHERE UPPER(MAP.NODE_TYPE) = UPPER(P_MENU_TYPE)
96: AND MAP.NODE_ID = P_MENU_ID;
97:
98: -- Get Menu Parents Access List Record Count

Line 102: FROM FRM_MENU_USER_MAPPINGS MAP

98: -- Get Menu Parents Access List Record Count
99:
100: SELECT COUNT(DISTINCT MAP.NODE_ID)
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

Line 144: FROM FRM_MENU_USER_MAPPINGS MAP

140: -- Menu is secured and user is in menu access list.
141:
142: SELECT COUNT(1)
143: INTO VN_RECORD_CNT1
144: FROM FRM_MENU_USER_MAPPINGS MAP
145: WHERE UPPER(MAP.NODE_TYPE) = UPPER(P_MENU_TYPE)
146: AND MAP.NODE_ID = P_MENU_ID
147: AND MAP.USER_ID = P_USER_ID;
148:

Line 193: FROM FRM_MENU_USER_MAPPINGS MAP

189: -- If not Root Folder then check if the folder is secured
190:
191: SELECT COUNT(DISTINCT MAP.NODE_ID)
192: INTO VN_RECORD_CNT3
193: FROM FRM_MENU_USER_MAPPINGS MAP
194: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
195: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY';
196:
197: IF NOT VN_RECORD_CNT3 = 0 THEN

Line 203: FROM FRM_MENU_USER_MAPPINGS MAP

199: -- If folder is secured then check if the folder is accessible by user.
200:
201: SELECT COUNT(DISTINCT MAP.NODE_ID)
202: INTO VN_RECORD_CNT3
203: FROM FRM_MENU_USER_MAPPINGS MAP
204: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
205: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY'
206: AND MAP.USER_ID = P_USER_ID;
207:

Line 222: FROM FRM_MENU_USER_MAPPINGS MAP

218: -- Folder is secured and accessible by user then verify the RECURSIVE flag.
219:
220: SELECT DISTINCT UPPER(NVL(MAP.RECURSIVE, 'N'))
221: INTO VN_RECURSE_FLAG
222: FROM FRM_MENU_USER_MAPPINGS MAP
223: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
224: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY'
225: AND MAP.USER_ID = P_USER_ID
226: AND ROWNUM = 1;

Line 348: FROM FRM_MENU_USER_MAPPINGS MAP

344: -- Get Menu Access List Record Count
345:
346: SELECT COUNT(DISTINCT MAP.NODE_ID)
347: INTO VN_RECORD_CNT1
348: FROM FRM_MENU_USER_MAPPINGS MAP
349: WHERE UPPER(MAP.NODE_TYPE) = UPPER(P_MENU_TYPE)
350: AND MAP.NODE_ID = P_MENU_ID;
351:
352: -- Get Menu Parents Access List Record Count

Line 356: FROM FRM_MENU_USER_MAPPINGS MAP

352: -- Get Menu Parents Access List Record Count
353:
354: SELECT COUNT(DISTINCT MAP.NODE_ID)
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

Line 400: FROM FRM_MENU_USER_MAPPINGS MAP

396: -- Menu is secured and user is in menu access list with owner permission.
397:
398: SELECT COUNT(1)
399: INTO VN_RECORD_CNT1
400: FROM FRM_MENU_USER_MAPPINGS MAP
401: WHERE UPPER(MAP.NODE_TYPE) = UPPER(P_MENU_TYPE)
402: AND MAP.NODE_ID = P_MENU_ID
403: AND MAP.USER_ID = P_USER_ID;
404:

Line 410: FROM FRM_MENU_USER_MAPPINGS MAP

406: IF VN_RECORD_CNT1 > 0 THEN
407:
408: SELECT UPPER(MAP.PERMISSION_CODE)
409: INTO VN_MENU_OWNER
410: FROM FRM_MENU_USER_MAPPINGS MAP
411: WHERE UPPER(MAP.NODE_TYPE) = UPPER(P_MENU_TYPE)
412: AND MAP.NODE_ID = P_MENU_ID
413: AND MAP.USER_ID = P_USER_ID
414: AND ROWNUM = 1;

Line 482: FROM FRM_MENU_USER_MAPPINGS MAP

478: -- If not Root Folder then check if the folder is secured
479:
480: SELECT COUNT(DISTINCT MAP.NODE_ID)
481: INTO VN_RECORD_CNT3
482: FROM FRM_MENU_USER_MAPPINGS MAP
483: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
484: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY';
485:
486: IF NOT VN_RECORD_CNT3 = 0 THEN

Line 492: FROM FRM_MENU_USER_MAPPINGS MAP

488: -- If folder is secured then check if the folder is accessible by user.
489:
490: SELECT COUNT(DISTINCT MAP.NODE_ID)
491: INTO VN_RECORD_CNT3
492: FROM FRM_MENU_USER_MAPPINGS MAP
493: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
494: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY'
495: AND MAP.USER_ID = P_USER_ID;
496:

Line 514: FROM FRM_MENU_USER_MAPPINGS MAP

510: SELECT UPPER(MAP.PERMISSION_CODE),
511: UPPER(NVL(MAP.RECURSIVE, 'N'))
512: INTO VN_PARNT_OWNER,
513: VN_RECURSE_FLAG
514: FROM FRM_MENU_USER_MAPPINGS MAP
515: WHERE MAP.NODE_ID = VN_PARNT_DIR_ID
516: AND UPPER(MAP.NODE_TYPE) = 'DIRECTORY'
517: AND MAP.USER_ID = P_USER_ID
518: AND ROWNUM = 1;