SQL-MENU-020: Insert menu page¶

Insert a menu page row.

Classification¶

Field	Value
SQL ID	SQL-MENU-020
Operation type	Create
Execution method	StringBuilder-assembled
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsMenuPage`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:MenuPageSeqNum`	Input	Decimal	N/A	Menu page key.
`:PageName`	Input	String	100	Page name.
`:FavoriteName`	Input	String	100	Favorite display name.
`:PageLink`	Input	String	1000	Page link text.
`:ApplicationCode`	Input	String	5	Application lookup code.
`:SavePreferencesFlag`	Input	String	1	Y/N page flag.
`:PrintFlag`	Input	String	1	Y/N page flag.
`:DownloadFlag`	Input	String	1	Y/N page flag.
`:HelpFlag`	Input	String	1	Y/N page flag.
`:SaveFlag`	Input	String	1	Y/N page flag.
`:InsertFlag`	Input	String	1	Y/N page flag.
`:DeleteFlag`	Input	String	1	Y/N page flag.
`:PrintTip`	Input	String	1000	Print tooltip.
`:DownloadTip`	Input	String	1000	Download tooltip.
`:SaveTip`	Input	String	1000	Save tooltip.
`:InsertTip`	Input	String	1000	Insert tooltip.
`:DeleteTip`	Input	String	1000	Delete tooltip.
`:UserId`	Input	String	30	Audit user.

Tables¶

Table	Access	Columns used
MENU_PAGE	INSERT	`MENU_PAGE_SEQ_NUM`, `PAGE_LINK_TXT`, `APPLICATION_CODE`

Sample SQL¶

INSERT INTO MENU_PAGE (
  MENU_PAGE_SEQ_NUM,
  PAGE_NAME,
  FAVORITE_NAME,
  PAGE_LINK_TXT,
  APPLICATION_CODE,
  SAVE_PREFERENCES_FLAG,
  PRINT_FLAG,
  DOWNLOAD_FLAG,
  HELP_FLAG,
  SAVE_FLAG,
  INSERT_FLAG,
  DELETE_FLAG,
  PRINT_TIP_TXT,
  DOWNLOAD_TIP_TXT,
  SAVE_TOOLTIP_TXT,
  INSERT_TOOLTIP_TXT,
  DELETE_TOOLTIP_TXT,
  UPDATE_DATE,
  UPDATE_USER)
VALUES (
  :MenuPageSeqNum,
  :PageName,
  :FavoriteName,
  :PageLink,
  :ApplicationCode,
  :SavePreferencesFlag,
  :PrintFlag,
  :DownloadFlag,
  :HelpFlag,
  :SaveFlag,
  :InsertFlag,
  :DeleteFlag,
  :PrintTip,
  :DownloadTip,
  :SaveTip,
  :InsertTip,
  :DeleteTip,
  SYSDATE,
  :UserId)

Operations and processes¶

Maintain reference data

Business rules¶

BR-MENU-001: Optimistic contention on write

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Business.Menu\clsMenuPage.vb