[Home] [Help]
471: IF (delete_flag <> 'F') THEN
472: BEGIN
473: SELECT 1
474: INTO dummy
475: FROM sys.dual
476: WHERE NOT EXISTS
477: (SELECT 1
478: FROM fnd_menu_entries me
479: WHERE me.function_id = form_function.function_id);
479: WHERE me.function_id = form_function.function_id);
480:
481: SELECT 1
482: INTO dummy
483: FROM sys.dual
484: WHERE NOT EXISTS
485: (SELECT 1
486: FROM fnd_attachment_functions af
487: WHERE af.function_type = 'F'
546: IF (function_id = -1) THEN
547:
548: SELECT fnd_form_functions_s.NEXTVAL
549: INTO form_function.function_id
550: FROM dual;
551:
552: -- Insert into base
553: INSERT INTO fnd_form_functions (
554: function_id,
573: sysdate,
574: 1,
575: 1,
576: form_function.TYPE
577: FROM sys.dual;
578:
579: -- Added for Function Security Cache Invalidation Project.
580: fnd_function_security_cache.insert_function(form_function.function_id);
581:
699: IF (delete_flag <> 'F') THEN
700: BEGIN
701: SELECT 1
702: INTO dummy
703: FROM sys.dual
704: WHERE NOT EXISTS
705: (SELECT 1
706: FROM fnd_menu_entries me
707: WHERE me.sub_menu_id = menu.menu_id);
707: WHERE me.sub_menu_id = menu.menu_id);
708:
709: SELECT 1
710: INTO dummy
711: FROM sys.dual
712: WHERE NOT EXISTS
713: (SELECT 1
714: FROM fnd_responsibility r
715: WHERE r.menu_id = menu.menu_id);
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
785: INSERT INTO fnd_menus (
786: menu_id,
797: 1,
798: sysdate,
799: 1,
800: 1
801: FROM sys.dual;
802:
803:
804: -- Added for Function Security Cache Invalidation Project.
805: fnd_function_security_cache.insert_menu(menu.menu_id);
853: END MENU;
854:
855: --
856: -- MENU_ENTRY
857: -- Insert/update/delete an individual menu entry.
858: --
859: -- IN:
860: -- menu_name (KEY, REQUIRED) - Menu developer key
861: -- entry_sequence - Sequence number (see note below)