SQL-031: Update an application code¶

This statement is the UpdateSQL implementation of clsApplicationCode.Criteria, executed from BeforeUpdate against BUSONLINE_APPS_CODE. Update an application code.

Classification¶

Field	Value
SQL ID	SQL-031
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]`**
Command type	Text
Business object	`clsApplicationCode`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ApplicaitonPath`	Not bound	String	N/A	Misspelled placeholder in the SQL text (`ApplicaitonPath`); `BeforeUpdate` binds `ApplicationPath` instead, so this placeholder is never satisfied*
`:ActiveFlag`	Input	String	5	Active flag as `Y`/`N`; bound with max length 5 here versus 1 on insert*
`:Code`	Input	String	5	Application code key

Tables¶

Table	Access	Columns used
BUSONLINE_APPS_CODE	UPDATE	CODE_DESCR, ACTIVE_CODE (SET); CODE (WHERE)

Sample SQL¶

-- Update an application code
Update
  BUSONLINE_APPS_CODE
Set
  CODE_DESCR = :ApplicaitonPath,
  ACTIVE_CODE = :ActiveFlag
Where
  CODE = :Code

Operations and processes¶

Update or delete a maintained object

Business rules¶

BR-MENU-020: Single-row write verification

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Business.Menu/clsApplicationCode.vb