mssub_mcp.ms

Parameters

Name	Type	Mode
		IN

Definition

-- File:        trig_i_u_syst_identities.eex.sql
-- Location:    musebms/database/components/system/mscmp_syst_authn/ms_syst/api_views/syst_identities/trig_i_u_syst_identities.eex.sql
-- Project:     Muse Systems Business Management System
--
-- Copyright © Lima Buttgereit Holdings LLC d/b/a Muse Systems
-- This file may include content copyrighted and licensed from third parties.
--
-- See the LICENSE file in the project root for license terms and conditions.
-- See the NOTICE file in the project root for copyright ownership information.
--
-- muse.information@musesystems.com  :: https://muse.systems

BEGIN

IF
        new.access_account_id     != old.access_account_id OR
        new.identity_type_id      != old.identity_type_id OR
        new.account_identifier    != old.account_identifier OR
        new.validates_identity_id != old.validates_identity_id
    THEN
        RAISE EXCEPTION
            USING
                MESSAGE = 'The requested data update included changes to fields disallowed ' ||
                          'by the business rules of the API View.',
                DETAIL = ms_syst_priv.get_exception_details(
                             p_proc_schema    => 'ms_syst'
                            ,p_proc_name      => 'trig_i_u_syst_identities'
                            ,p_exception_name => 'invalid_api_view_call'
                            ,p_errcode        => 'PM008'
                            ,p_param_data     => jsonb_build_object('new', new, 'old', old)
                            ,p_context_data   =>
                                jsonb_build_object(
                                     'tg_op',         tg_op
                                    ,'tg_when',       tg_when
                                    ,'tg_schema',     tg_table_schema
                                    ,'tg_table_name', tg_table_name)),
                ERRCODE = 'PM008',
                SCHEMA = tg_table_schema,
                TABLE = tg_table_name;
    END IF;

UPDATE ms_syst_data.syst_identities
    SET
        validated            = new.validated
      , validation_requested = new.validation_requested
      , identity_expires     = new.identity_expires
      , external_name        = new.external_name
    WHERE id = new.id
    RETURNING * INTO new;

RETURN new;

END;

trig_i_u_syst_identities()

Description

Parameters

Definition