Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 43.ddi / MENUDEF.SQL < prev next >

Wrap

Text File | 1990-06-07 | 54.2 KB | 3,094 lines

Rem Rem Export of application DEFAULTMENUAPP (generated on tue may 15 15:17 1990) Rem Set termout off Set verify off Set heading off Set echo off Set scan off Column x newline Spool menudef.LIS Select decode(count(*),0,'prompt Importing Application DEFAULTMENUAPP', 'prompt Application DEFAULTMENUAPP already exists !'),decode(count(*),0,'', 'exit') x From menu_b_appl Where application_name = 'DEFAULTMENUAPP' ; Spool off Set termout on @menudef.LIS Set termout off Set echo on Spool menudef.LIS Rem Rem export of table MENU_B_APPL ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_APPL ( APPLICATION_NAME, SHORT_NAME, FILE_NAME, CREATION_DATE, CREATOR, VERSION_RELEASE_NR, LAST_RELEASE_DATE, MENU_DIRECTORY, IDENTIFICATION ) values ( 'DEFAULTMENUAPP', 'Defaultmenuapp', 'menudef', '11-DEC-89', 'scott', ' 1', '', '', 'This is the default menu application' ) ; Commit ; Rem Rem export of table MENU_B_APPL_GRP ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_APPL_GRP ( APPLICATION_NAME, GROUP_NAME ) values ( 'DEFAULTMENUAPP', 'CLERKS' ) ; Insert into MENU_B_APPL_GRP ( APPLICATION_NAME, GROUP_NAME ) values ( 'DEFAULTMENUAPP', 'MANAGERS' ) ; Commit ; Rem Rem export of table MENU_B_INFO ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'ACTION', 'DEFAULTMENUAPP', 'action', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'BLOCK', 'DEFAULTMENUAPP', 'block', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', 'default', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'EDIT', 'DEFAULTMENUAPP', 'edit', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'FIELD', 'DEFAULTMENUAPP', 'field', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'HELP', 'DEFAULTMENUAPP', 'help', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'QUERY', 'DEFAULTMENUAPP', 'query', '...', '...', ' 0' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'RECORD', 'DEFAULTMENUAPP', 'record', '...', '...', ' 0' ) ; Commit ; Rem Rem export of table MENU_B_OPTION ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ACTION', 'DEFAULTMENUAPP', ' 1', 'Rollback', 'N', 'Rollback', ' 0', ' 7', 'do_key(''Clear_form'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ACTION', 'DEFAULTMENUAPP', ' 2', 'Commit', 'N', 'Commit', ' 0', ' 7', 'do_key(''Commit_form'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ACTION', 'DEFAULTMENUAPP', ' 3', 'reFresh', 'N', 'reFresh', ' 0', ' 7', 'redisplay;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ACTION', 'DEFAULTMENUAPP', ' 4', 'Print', 'N', 'Print', ' 0', ' 7', 'do_key(''print'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ACTION', 'DEFAULTMENUAPP', ' 5', 'Exit', 'N', 'Exit', ' 0', ' 7', 'do_key(''Exit_form'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'BLOCK', 'DEFAULTMENUAPP', ' 1', 'Previous', 'N', 'Previous', ' 0', ' 7', 'do_key(''Previous_block'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'BLOCK', 'DEFAULTMENUAPP', ' 2', 'Next', 'N', 'Next', ' 0', ' 7', 'do_key(''Next_block'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'BLOCK', 'DEFAULTMENUAPP', ' 3', 'Clear', 'N', 'Clear', ' 0', ' 7', 'do_key(''Clear_block'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 1', 'Action', 'N', 'Action', ' 0', ' 1', 'action' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 2', 'Edit', 'N', 'Edit', ' 0', ' 1', 'edit' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 3', 'Block', 'N', 'Block', ' 0', ' 1', 'block' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 4', 'Field', 'N', 'Field', ' 0', ' 1', 'field' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 5', 'Record', 'N', 'Record', ' 0', ' 1', 'record' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 6', 'Query', 'N', 'Query', ' 0', ' 1', 'query' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 7', 'Help', 'N', 'Help', ' 0', ' 1', 'help' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'EDIT', 'DEFAULTMENUAPP', ' 1', 'Cut', 'N', 'Cut', ' 0', ' 7', 'Cut_region;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'EDIT', 'DEFAULTMENUAPP', ' 2', 'cOpy', 'N', 'cOpy', ' 0', ' 7', 'Copy_region;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'EDIT', 'DEFAULTMENUAPP', ' 3', 'Paste', 'N', 'Paste', ' 0', ' 7', 'Paste_region;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'EDIT', 'DEFAULTMENUAPP', ' 4', 'Edit', 'N', 'Edit', ' 0', ' 7', 'Edit_field;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'FIELD', 'DEFAULTMENUAPP', ' 1', 'Previous', 'N', 'Previous', ' 0', ' 7', 'do_key(''Previous_field'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'FIELD', 'DEFAULTMENUAPP', ' 2', 'Next', 'N', 'Next', ' 0', ' 7', 'do_key(''Next_field'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'FIELD', 'DEFAULTMENUAPP', ' 3', 'Clear', 'N', 'Clear', ' 0', ' 7', 'Clear_field;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'FIELD', 'DEFAULTMENUAPP', ' 4', 'Duplicate', 'N', 'Duplicate', ' 0', ' 7', 'do_key(''Duplicate_field'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'HELP', 'DEFAULTMENUAPP', ' 1', 'Help', 'N', 'Help', ' 0', ' 7', 'do_key(''help'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'HELP', 'DEFAULTMENUAPP', ' 2', 'Keys', 'N', 'Keys', ' 0', ' 7', 'show_keys;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'HELP', 'DEFAULTMENUAPP', ' 3', 'List', 'N', 'List', ' 0', ' 7', 'do_key(''List_values'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'HELP', 'DEFAULTMENUAPP', ' 4', 'Display error', 'N', 'Display error', ' 0', ' 7', 'display_error;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 1', 'Enter', 'N', 'Enter', ' 0', ' 7', 'enable_disable_query_items;' || ' do_key(''Enter_query'');' || ' enable_disable_regular_items;' || ' ' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 2', 'eXecute', 'N', 'eXecute', ' 0', ' 7', 'do_key(''Execute_query'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 3', 'Last criteria', 'Y', 'Last criteria', ' 0', ' 7', 'do_key(''Enter_query'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 4', 'Cancel', 'Y', 'Cancel', ' 0', ' 7', 'do_key(''Exit_form'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 5', 'count Hits', 'N', 'count Hits', ' 0', ' 7', 'do_key(''Count_query'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'QUERY', 'DEFAULTMENUAPP', ' 6', 'Fetch next set', 'N', 'Fetch next set', ' 0', ' 7', 'do_key(''Next_set'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 1', 'Previous', 'N', 'Previous', ' 0', ' 7', 'do_key(''Previous_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 2', 'Next', 'N', 'Next', ' 0', ' 7', 'do_key(''Next_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 3', 'scroll Up', 'N', 'scroll Up', ' 0', ' 7', 'do_key(''Scroll_up'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 4', 'Scroll down', 'N', 'Scroll down', ' 0', ' 7', 'do_key(''Scroll_down'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 5', 'Clear', 'N', 'Clear', ' 0', ' 7', 'do_key(''Clear_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 6', 'Remove', 'N', 'Remove', ' 0', ' 7', 'do_key(''Delete_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 7', 'Insert', 'N', 'Insert', ' 0', ' 7', 'do_key(''Create_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 8', 'Duplicate', 'N', 'Duplicate', ' 0', ' 7', 'do_key(''Duplicate_record'');' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'RECORD', 'DEFAULTMENUAPP', ' 9', 'Lock', 'N', 'Lock', ' 0', ' 7', 'do_key(''Lock_record'');' ) ; Commit ; Rem Rem export of table MENU_B_PARAM ( Application DEFAULTMENUAPP) Rem Commit ; Rem Rem export of table MENU_B_PARM_XREF ( Application DEFAULTMENUAPP) Rem Commit ; Rem Rem export of table MENU_B_PRIV ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 1', 'MNU', 'DEFAULTMENUAPP', 'ACTION', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 2', 'MNU', 'DEFAULTMENUAPP', 'ACTION', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 3', 'MNU', 'DEFAULTMENUAPP', 'ACTION', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 4', 'MNU', 'DEFAULTMENUAPP', 'ACTION', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 5', 'MNU', 'DEFAULTMENUAPP', 'ACTION', ' 5' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 6', 'MNU', 'DEFAULTMENUAPP', 'BLOCK', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 7', 'MNU', 'DEFAULTMENUAPP', 'BLOCK', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 8', 'MNU', 'DEFAULTMENUAPP', 'BLOCK', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 9', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 10', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 11', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 12', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 13', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 5' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 14', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 6' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 15', 'MNU', 'DEFAULTMENUAPP', 'DEFAULTMENUAPP', ' 7' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 16', 'MNU', 'DEFAULTMENUAPP', 'EDIT', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 17', 'MNU', 'DEFAULTMENUAPP', 'EDIT', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 18', 'MNU', 'DEFAULTMENUAPP', 'EDIT', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 19', 'MNU', 'DEFAULTMENUAPP', 'EDIT', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 20', 'MNU', 'DEFAULTMENUAPP', 'FIELD', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 21', 'MNU', 'DEFAULTMENUAPP', 'FIELD', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 22', 'MNU', 'DEFAULTMENUAPP', 'FIELD', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 23', 'MNU', 'DEFAULTMENUAPP', 'FIELD', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 24', 'MNU', 'DEFAULTMENUAPP', 'HELP', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 25', 'MNU', 'DEFAULTMENUAPP', 'HELP', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 26', 'MNU', 'DEFAULTMENUAPP', 'HELP', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 27', 'MNU', 'DEFAULTMENUAPP', 'HELP', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 28', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 29', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 30', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 31', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 32', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 5' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 33', 'MNU', 'DEFAULTMENUAPP', 'QUERY', ' 6' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 34', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 35', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 36', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 37', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 38', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 5' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 39', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 6' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 40', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 7' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 41', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 8' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 42', 'MNU', 'DEFAULTMENUAPP', 'RECORD', ' 9' ) ; Commit ; Rem Rem export of table MENU_B_REF ( Application DEFAULTMENUAPP) Rem Commit ; Rem Rem export of table MENU_B_PROCEDURE ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_PROCEDURE ( APPLICATION_NAME, PROCEDURE_NAME, OBJECT_TEXT_ID ) values ( 'DEFAULTMENUAPP', 'enable_disable_query_items', ' 1' ) ; Insert into MENU_B_PROCEDURE ( APPLICATION_NAME, PROCEDURE_NAME, OBJECT_TEXT_ID ) values ( 'DEFAULTMENUAPP', 'enable_disable_regular_items', ' 2' ) ; Commit ; Rem Rem export of table MENU_B_OBJ_TEXT ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 1', 'procedure enable_disable_query_items is ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 2', 'begin ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 3', ' enable_item(''Query'',''Last Criteria'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 4', ' enable_item(''Query'',''Cancel'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 5', ' disable_item(''Action'',''Commit'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 6', ' disable_item(''Action'',''Exit'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 7', ' disable_item(''Block'',''Previous'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 8', ' disable_item(''Block'',''Next'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 9', ' disable_item(''Record'',''Previous'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 10', ' disable_item(''Record'',''Next'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 11', ' disable_item(''Record'',''Scroll up'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 12', ' disable_item(''Record'',''Scroll down'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 13', ' disable_item(''Record'',''Insert'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 14', ' disable_item(''Record'',''Duplicate'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 15', ' disable_item(''Record'',''Lock'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 16', 'end;' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 17', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 18', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 19', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 1', ' 20', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 1', 'procedure enable_disable_regular_items is ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 2', 'begin ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 3', ' disable_item(''Query'',''Last criteria'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 4', ' disable_item(''Query'',''Cancel'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 5', ' enable_item(''Action'',''Commit'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 6', ' enable_item(''Action'',''Exit'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 7', ' enable_item(''Block'',''Previous'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 8', ' enable_item(''Block'',''Next'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 9', ' enable_item(''Record'',''Previous'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 10', ' enable_item(''Record'',''Next'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 11', ' enable_item(''Record'',''Scroll up'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 12', ' enable_item(''Record'',''Scroll down'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 13', ' enable_item(''Record'',''Insert'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 14', ' enable_item(''Record'',''Duplicate'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 15', ' enable_item(''Record'',''Lock'');' || ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'DEFAULTMENUAPP', ' 2', ' 16', 'end;' || ' ' ) ; Commit ; Rem Rem export of table MENU_B_GRP_PRIV ( Application DEFAULTMENUAPP) Rem Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 1' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 1' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 2' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 2' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 3' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 3' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 4' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 4' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 5' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 5' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 6' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 6' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 7' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 7' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 8' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 8' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 9' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 9' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 10' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 10' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 11' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 11' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 12' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 12' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 13' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 13' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 14' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 14' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 15' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 15' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 16' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 16' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 17' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 17' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 18' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 18' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 19' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 19' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 20' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 20' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 21' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 21' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 22' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 22' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 23' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 23' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 24' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 24' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 25' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 25' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 26' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 26' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 27' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 27' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 28' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 28' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 29' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 29' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'NOGROUP', ' 30' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'NOGROUP', ' 31' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 32' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 32' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 33' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 33' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 34' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 34' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 35' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 35' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 36' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 36' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 37' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 37' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 38' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 38' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 39' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 39' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 40' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 40' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 41' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 41' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'CLERKS', ' 42' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'DEFAULTMENUAPP', 'MANAGERS', ' 42' ) ; Commit ; Set scan on Set verify on Set heading on Spool off Set termout on