SQL-MENU-008: Insert menu category code

Insert a menu category code row.

Classification

Field	Value
SQL ID	SQL-MENU-008
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMenuCategoryCode
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	String	5	Lookup key.
:CodeDescr	Input	String	100	Code description.

Tables

Table	Access	Columns used
MENU_CATEGORY_CODE	INSERT	CODE, CODE_DESCR

Sample SQL

INSERT INTO MENU_CATEGORY_CODE (
  CODE,
  CODE_DESCR)
VALUES (
  :Code,
  :CodeDescr)

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\clsMenuCategoryCode.vb