APPS.FND_FUNCTION_SECURITY dependencies on FND_MENUS

Line 75: FROM fnd_menus f

71: dummy NUMBER;
72: BEGIN
73: SELECT 1
74: INTO dummy
75: FROM fnd_menus f
76: WHERE f.menu_name = menu_exists.menu_name;
77:
78: RETURN TRUE;
79: EXCEPTION

Line 104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f

100: dummy NUMBER;
101: BEGIN
102: SELECT 1
103: INTO dummy
104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f
105: WHERE me.menu_id = m.menu_id
106: AND m.menu_name = menu_entry_exists.menu_name
107: AND me.sub_menu_id = s.menu_id (+)
108: AND nvl(s.menu_name, 'x') = nvl(menu_entry_exists.sub_menu_name, 'x')

Line 153: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_menus m

149: AND f.function_name = security_rule_exists.rule_name;
150: ELSE
151: SELECT 1
152: INTO dummy
153: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_menus m
154: WHERE rf.responsibility_id = r.responsibility_id
155: AND rf.application_id = r.application_id
156: AND r.responsibility_key = security_rule_exists.responsibility_key
157: AND rf.rule_type = 'M'

Line 283: FROM fnd_menus m

279:
280: -- Menu
281: SELECT m.menu_id
282: INTO menu_id
283: FROM fnd_menus m
284: WHERE m.menu_name = responsibility.menu_name;
285:
286: -- Request group, if supplied
287: IF (request_group_name IS NOT NULL) THEN

Line 689: FROM fnd_menus

685:
686: BEGIN
687: SELECT menu_id
688: INTO menu.menu_id
689: FROM fnd_menus
690: WHERE menu_name = menu.menu_name;
691: EXCEPTION
692: WHEN no_data_found THEN
693: menu_id := -1;

Line 723: DELETE FROM fnd_menus

719: RETURN;
720: END;
721: END IF;
722:
723: DELETE FROM fnd_menus
724: WHERE menu_id = menu.menu_id;
725:
726: -- Added for Function Security Cache Invalidation Project.
727: fnd_function_security_cache.delete_menu(menu.menu_id);

Line 729: DELETE FROM fnd_menus_tl

725:
726: -- Added for Function Security Cache Invalidation Project.
727: fnd_function_security_cache.delete_menu(menu.menu_id);
728:
729: DELETE FROM fnd_menus_tl
730: WHERE menu_id = menu.menu_id;
731:
732: -- Cascade delete to menu entries and resp functions
733: DELETE FROM fnd_menu_entries

Line 768: FROM fnd_menus_vl fm

764: namebuf := menu.user_menu_name;
765: LOOP
766: SELECT count(1)
767: INTO dummy
768: FROM fnd_menus_vl fm
769: WHERE fm.user_menu_name = namebuf
770: AND fm.menu_id <> menu.menu_id;
771:
772: EXIT WHEN dummy = 0;

Line 780: SELECT fnd_menus_s.NEXTVAL

776:
777: -- Select to decide if this is insert or update
778: IF (menu_id = -1) THEN
779:
780: SELECT fnd_menus_s.NEXTVAL
781: INTO menu.menu_id
782: FROM dual;
783:
784: -- Insert into base

Line 785: INSERT INTO fnd_menus (

781: INTO menu.menu_id
782: FROM dual;
783:
784: -- Insert into base
785: INSERT INTO fnd_menus (
786: menu_id,
787: menu_name,
788: creation_date,
789: created_by,

Line 808: INSERT INTO fnd_menus_tl (

804: -- Added for Function Security Cache Invalidation Project.
805: fnd_function_security_cache.insert_menu(menu.menu_id);
806:
807: -- Insert into _TL
808: INSERT INTO fnd_menus_tl (
809: LANGUAGE,
810: menu_id,
811: user_menu_name,
812: description,

Line 830: FROM fnd_menus f, fnd_languages l

826: sysdate,
827: 1,
828: 1,
829: userenv('LANG')
830: FROM fnd_menus f, fnd_languages l
831: WHERE f.menu_name = menu.menu_name
832: AND l.installed_flag IN ('I', 'B');
833:
834: RETURN;

Line 840: UPDATE fnd_menus_tl

836:
837: -- Update base -- nothing updatable in base table
838:
839: -- Update TL
840: UPDATE fnd_menus_tl
841: SET user_menu_name = menu.namebuf,
842: description = menu.description,
843: last_update_date = sysdate,
844: last_updated_by = 1,

Line 900: FROM fnd_menus

896:
897: -- Get menu_id
898: SELECT menu_id
899: INTO menu_entry.menu_id
900: FROM fnd_menus
901: WHERE menu_name = menu_entry.menu_name;
902:
903: -- Get sub_menu_id
904: IF (sub_menu_name IS NOT NULL) THEN

Line 907: FROM fnd_menus

903: -- Get sub_menu_id
904: IF (sub_menu_name IS NOT NULL) THEN
905: SELECT menu_id
906: INTO menu_entry.sub_menu_id
907: FROM fnd_menus
908: WHERE menu_name = menu_entry.sub_menu_name;
909: END IF;
910:
911: -- Get function_id

Line 1106: FROM fnd_menus

1102: WHERE function_name = security_rule.rule_name;
1103: ELSE
1104: SELECT menu_id
1105: INTO security_rule.action_id
1106: FROM fnd_menus
1107: WHERE menu_name = security_rule.rule_name;
1108: END IF;
1109:
1110: -- Delete if requested

Line 1334: FROM FND_MENUS

1330: -- Find which menu names have already been changed
1331: BEGIN
1332: SELECT MENU_ID
1333: INTO oldid
1334: FROM FND_MENUS
1335: WHERE MENU_NAME = oldname;
1336: EXCEPTION
1337: WHEN no_data_found THEN
1338: oldid := -1;

Line 1344: FROM FND_MENUS

1340:
1341: BEGIN
1342: SELECT MENU_ID
1343: INTO newid
1344: FROM FND_MENUS
1345: WHERE MENU_NAME = newname;
1346: EXCEPTION
1347: WHEN no_data_found THEN
1348: newid := -1;

Line 1363: UPDATE FND_MENUS

1359: END IF;
1360:
1361: -- If only oldname exists, only update oldname to newname
1362: IF ((oldid <> -1) AND (newid = -1)) THEN
1363: UPDATE FND_MENUS
1364: SET MENU_NAME = newname
1365: WHERE MENU_NAME = oldname;
1366:
1367: -- Added for Function Security Cache Invalidation Project.

Line 1425: DELETE FROM FND_MENUS

1421: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
1422: END LOOP;
1423:
1424: -- 2. Delete new row
1425: DELETE FROM FND_MENUS
1426: WHERE MENU_ID = newid;
1427:
1428: -- Added for Function Security Cache Invalidation Project.
1429: fnd_function_security_cache.update_menu(newid);

Line 1431: DELETE FROM FND_MENUS_TL

1427:
1428: -- Added for Function Security Cache Invalidation Project.
1429: fnd_function_security_cache.update_menu(newid);
1430:
1431: DELETE FROM FND_MENUS_TL
1432: WHERE MENU_ID = newid;
1433:
1434: -- 3. Update oldname to newname in old row
1435: UPDATE FND_MENUS

Line 1435: UPDATE FND_MENUS

1431: DELETE FROM FND_MENUS_TL
1432: WHERE MENU_ID = newid;
1433:
1434: -- 3. Update oldname to newname in old row
1435: UPDATE FND_MENUS
1436: SET MENU_NAME = newname
1437: WHERE MENU_ID = oldid;
1438:
1439: -- Added for Function Security Cache Invalidation Project.