SAIF.Business.Menu SQL catalog

This page indexes all SQL statements in this library, grouped by CRUD type. All statements target Oracle using inline SQL; no stored procedures are used.

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Generate next MENU_FAVORITE_SEQ value	MENU_FAVORITE_SEQ	DUAL	clsMenuFavorite
SQL-002	Generate next MENU_ITEM_SEQ value	MENU_ITEM_SEQ	DUAL	clsMenuItem
SQL-003	Generate next MENU_PAGE_SEQ value	MENU_PAGE_SEQ	DUAL	clsMenuPage
SQL-004	Generate next MENU_SECURITY_SEQ value	MENU_SECURITY_SEQ	DUAL	clsMenuSecurity

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-005	Insert application code	Inline	BUSONLINE_APPS_CODE	clsApplicationCode
SQL-006	Insert menu category code	Inline	MENU_CATEGORY_CODE	clsMenuCategoryCode
SQL-007	Insert menu favorite	Inline	MENU_FAVORITE	clsMenuFavorite
SQL-008	Insert menu item	Inline	MENU_ITEM	clsMenuItem
SQL-009	Insert menu page	Inline (StringBuilder)	MENU_PAGE	clsMenuPage
SQL-010	Insert menu security	Inline	MENU_SECURITY	clsMenuSecurity
SQL-011	Insert menu security user	Inline	MENU_SECURITY_USER	clsMenuSecurityUser

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-012	Retrieve application code by key	Inline	BUSONLINE_APPS_CODE	clsApplicationCode
SQL-013	Retrieve active application codes	Inline	BUSONLINE_APPS_CODE	clsApplicationCodeCollection
SQL-014	Retrieve all application codes	Inline	BUSONLINE_APPS_CODE	clsApplicationCodeCollection
SQL-015	Retrieve all authorized menu items (UNION query)	Inline (StringBuilder)	MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE	clsMenuAuthorizedItemCollection
SQL-016	Retrieve authorized menu items for a user (UNION query)	Inline (StringBuilder)	MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE, MENU_FAVORITE	clsMenuAuthorizedItemCollection
SQL-017	Retrieve menu category code by key	Inline	MENU_CATEGORY_CODE	clsMenuCategoryCode
SQL-018	Retrieve all menu category codes	Inline	MENU_CATEGORY_CODE	clsMenuCategoryCodeCollection
SQL-019	Retrieve menu favorite by key	Inline	MENU_FAVORITE	clsMenuFavorite
SQL-020	Retrieve favorites by user ID	Inline	MENU_FAVORITE	clsMenuFavoriteCollection
SQL-021	Retrieve all menu favorites	Inline	MENU_FAVORITE	clsMenuFavoriteCollection
SQL-022	Retrieve menu item by key	Inline	MENU_ITEM	clsMenuItem
SQL-023	Retrieve all menu items	Inline	MENU_ITEM	clsMenuItemCollection
SQL-024	Retrieve menu page by key	Inline	MENU_PAGE	clsMenuPage
SQL-025	Retrieve all menu pages	Inline	MENU_PAGE	clsMenuPageCollection
SQL-026	Retrieve menu security by key	Inline	MENU_SECURITY	clsMenuSecurity
SQL-027	Retrieve menu security records by menu item	Inline	MENU_SECURITY	clsMenuSecurityCollection
SQL-028	Retrieve all menu security records	Inline	MENU_SECURITY	clsMenuSecurityCollection
SQL-029	Retrieve security users by MenuUser	Inline	MENU_SECURITY_USER	clsMenuSecurityUserCollection
SQL-030	Retrieve all menu security users	Inline	MENU_SECURITY_USER	clsMenuSecurityUserCollection

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-031	Inline update used by clsApplicationCode	Inline	BUSONLINE_APPS_CODE	clsApplicationCode
SQL-032	Inline update used by clsMenuCategoryCode	Inline	MENU_CATEGORY_CODE	clsMenuCategoryCode
SQL-033	Inline update used by clsMenuFavorite	Inline	MENU_FAVORITE	clsMenuFavorite
SQL-034	Inline update used by clsMenuItem	Inline	MENU_ITEM	clsMenuItem
SQL-035	Inline (StringBuilder) update used by clsMenuPage	Inline (StringBuilder)	MENU_PAGE	clsMenuPage
SQL-036	Inline update used by clsMenuSecurity	Inline	MENU_SECURITY	clsMenuSecurity
SQL-037	Inline update used by clsMenuSecurityUser	Inline	MENU_SECURITY_USER	clsMenuSecurityUser

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-038	Inline delete used by clsApplicationCode	Inline	BUSONLINE_APPS_CODE	clsApplicationCode
SQL-039	Inline delete used by clsMenuCategoryCode	Inline	MENU_CATEGORY_CODE	clsMenuCategoryCode
SQL-040	Inline delete used by clsMenuFavorite	Inline	MENU_FAVORITE	clsMenuFavorite
SQL-041	Inline delete used by clsMenuItem	Inline	MENU_ITEM	clsMenuItem
SQL-042	Inline delete used by clsMenuPage	Inline	MENU_PAGE	clsMenuPage
SQL-043	Inline delete used by clsMenuSecurity	Inline	MENU_SECURITY	clsMenuSecurity
SQL-044	Inline delete used by clsMenuSecurityUser	Inline	MENU_SECURITY_USER	clsMenuSecurityUser

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

Sources

• Business\SAIF.Business.Menu\clsApplicationCode.vb
• Business\SAIF.Business.Menu\clsApplicationCodeCollection.vb
• Business\SAIF.Business.Menu\clsMenuAuthorizedItemCollection.vb
• Business\SAIF.Business.Menu\clsMenuCategoryCode.vb
• Business\SAIF.Business.Menu\clsMenuCategoryCodeCollection.vb
• Business\SAIF.Business.Menu\clsMenuFavorite.vb
• Business\SAIF.Business.Menu\clsMenuFavoriteCollection.vb
• Business\SAIF.Business.Menu\clsMenuItem.vb
• Business\SAIF.Business.Menu\clsMenuItemCollection.vb
• Business\SAIF.Business.Menu\clsMenuPage.vb
• Business\SAIF.Business.Menu\clsMenuPageCollection.vb
• Business\SAIF.Business.Menu\clsMenuSecurity.vb
• Business\SAIF.Business.Menu\clsMenuSecurityCollection.vb
• Business\SAIF.Business.Menu\clsMenuSecurityUser.vb
• Business\SAIF.Business.Menu\clsMenuSecurityUserCollection.vb