DBA Data[Home] [Help]

APPS.FND_FUNCTION_SECURITY dependencies on FND_MENUS_TL

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