trig_b_i_syst_enum_functional_type_validate_new_allowed()

Checks to see if this is the first functional type being added for the enumeration and, if so, that no syst_enum_items records already exist.

Trigger Function Details:

• Supported Timing: BEFORE

• Supported Operations: INSERT

General Usage

Adding a first functional type for an enumeration which already has defined enumeration items implies that the enumeration items must be assigned a functional type in the same operation to keep data consistency. In practice, this would be difficult since there would almost certainly have to be multiple functional types available in order to avoid making bogus assignments; it would be much more difficult to manage such a process as compared to simply disallowing the scenario.