trig_b_u_syst_hierarchies_validate_state_change()

Checks that a Hierarchy record’s state may be changed while ensuring that such a change doesn’t allow for data inconsistencies with either of the Hierarchy or the data of Hierarchy implementing Components.

Trigger Function Details:

• Supported Timing: BEFORE

• Supported Operations: UPDATE

General Usage

Setting the Hierarchy to an “active” state requires that the Hierarchy and its associated Hierarchy Items are complete and fully self-consistent. For the “inactive” check, the Hierarchy may not be in use which is defined as being referenced in the data of Hierarchy implementing Components.