CREATE TRIGGER UserAccount_AuditUpdate AFTER UPDATE ON UserAccount FOR EACH ROW     BEGIN                IF :OLD.Name != :NEW.Name THEN             INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;         IF :OLD.Password != :NEW.Password THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Password', :OLD.Password, :NEW.Password, :NEW.UpdatedBy);        END IF;            IF :OLD.FirstName != :NEW.FirstName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'FirstName', :OLD.FirstName, :NEW.FirstName, :NEW.UpdatedBy);        END IF;            IF :OLD.LastName != :NEW.LastName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'LastName', :OLD.LastName, :NEW.LastName, :NEW.UpdatedBy);        END IF;            IF :OLD.DefaultNodeID != :NEW.DefaultNodeID THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'DefaultNodeID', :OLD.DefaultNodeID, :NEW.DefaultNodeID, :NEW.UpdatedBy);        END IF;            IF :OLD.Phone != :NEW.Phone THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Phone', :OLD.Phone, :NEW.Phone, :NEW.UpdatedBy);        END IF;            IF :OLD.Email != :NEW.Email THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Email', :OLD.Email, :NEW.Email, :NEW.UpdatedBy);        END IF;            IF :OLD.LockedOut != :NEW.LockedOut THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'LockedOut', :OLD.LockedOut, :NEW.LockedOut, :NEW.UpdatedBy);        END IF;            IF :OLD.UseADAuthentication != :NEW.UseADAuthentication THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UseADAuthentication', :OLD.UseADAuthentication, :NEW.UseADAuthentication, :NEW.UpdatedBy);        END IF;            IF :OLD.ChangePasswordOn != :NEW.ChangePasswordOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'ChangePasswordOn', TO_CLOB(:OLD.ChangePasswordOn), TO_CLOB(:NEW.ChangePasswordOn), :NEW.UpdatedBy);        END IF;         IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;			            IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;        END;    / CREATE TRIGGER UserAccount_AuditDelete AFTER DELETE ON UserAccount    FOR EACH ROW BEGIN        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Name', :OLD.Name, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Password', :OLD.Password, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'FirstName', :OLD.FirstName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'LastName', :OLD.LastName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'DefaultNodeID', :OLD.DefaultNodeID, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Phone', :OLD.Phone, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'Email', :OLD.Email, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'LockedOut', :OLD.LockedOut, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UseADAuthentication', :OLD.UseADAuthentication, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'ChangePasswordOn', TO_CLOB(:OLD.ChangePasswordOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('UserAccount', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);        END;    / CREATE TRIGGER SecurityGroup_AuditUpdate AFTER UPDATE ON SecurityGroup    FOR EACH ROW BEGIN            IF :OLD.Name != :NEW.Name THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;            IF :OLD.Description != :NEW.Description THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;         IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;         IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;        END;    / CREATE TRIGGER SecurityGroup_AuditDelete AFTER DELETE ON SecurityGroup    FOR EACH ROW BEGIN		        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'Name', :OLD.Name, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'Description', :OLD.Description, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('SecurityGroup', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);    END;    / CREATE TRIGGER ApplicationRole_AuditUpdate AFTER UPDATE ON ApplicationRole    FOR EACH ROW BEGIN         IF :OLD.Name != :NEW.Name THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;            IF :OLD.Description != :NEW.Description THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'Description', :OLD.Description, :NEW.Description, :NEW.UpdatedBy);        END IF;            IF :OLD.NodeID != :NEW.NodeID THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, :NEW.NodeID, :NEW.UpdatedBy);        END IF;         IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;         IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;     END;    / CREATE TRIGGER ApplicationRole_AuditDelete AFTER DELETE ON ApplicationRole    FOR EACH ROW BEGIN	        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'Name', :OLD.Name, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'Description', :OLD.Description, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('ApplicationRole', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);        END;    / CREATE TRIGGER CalcMeasurement_AuditUpdate AFTER UPDATE ON CalculatedMeasurement    FOR EACH ROW BEGIN            IF :OLD.NodeID != :NEW.NodeID THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, :NEW.NodeID, :NEW.UpdatedBy);        END IF;            IF :OLD.Acronym != :NEW.Acronym THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Acronym', :OLD.Acronym, :NEW.Acronym, :NEW.UpdatedBy);        END IF;            IF :OLD.Name != :NEW.Name THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;            IF :OLD.AssemblyName != :NEW.AssemblyName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, :NEW.AssemblyName, :NEW.UpdatedBy);        END IF;            IF :OLD.TypeName != :NEW.TypeName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, :NEW.TypeName, :NEW.UpdatedBy);        END IF;            IF :OLD.ConnectionString != :NEW.ConnectionString THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, :NEW.ConnectionString, :NEW.UpdatedBy);        END IF;            IF :OLD.ConfigSection != :NEW.ConfigSection THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'ConfigSection', :OLD.ConfigSection, :NEW.ConfigSection, :NEW.UpdatedBy);        END IF;            IF :OLD.InputMeasurements != :NEW.InputMeasurements THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'InputMeasurements', :OLD.InputMeasurements, :NEW.InputMeasurements, :NEW.UpdatedBy);        END IF;            IF :OLD.OutputMeasurements != :NEW.OutputMeasurements THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'OutputMeasurements', :OLD.OutputMeasurements, :NEW.OutputMeasurements, :NEW.UpdatedBy);        END IF;            IF :OLD.MinimumMeasurementsToUse != :NEW.MinimumMeasurementsToUse THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'MinimumMeasurementsToUse', :OLD.MinimumMeasurementsToUse, :NEW.MinimumMeasurementsToUse, :NEW.UpdatedBy);        END IF;                IF :OLD.FramesPerSecond != :NEW.FramesPerSecond THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'FramesPerSecond', :OLD.FramesPerSecond, :NEW.FramesPerSecond, :NEW.UpdatedBy);        END IF;            IF :OLD.LagTime != :NEW.LagTime THEN	            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LagTime', :OLD.LagTime, :NEW.LagTime, :NEW.UpdatedBy);        END IF;            IF :OLD.LeadTime != :NEW.LeadTime THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LeadTime', :OLD.LeadTime, :NEW.LeadTime, :NEW.UpdatedBy);        END IF;            IF :OLD.UseLocalClockAsRealTime != :NEW.UseLocalClockAsRealTime THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UseLocalClockAsRealTime', :OLD.UseLocalClockAsRealTime, :NEW.UseLocalClockAsRealTime, :NEW.UpdatedBy);        END IF;            IF :OLD.AllowSortsByArrival != :NEW.AllowSortsByArrival THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AllowSortsByArrival', :OLD.AllowSortsByArrival, :NEW.AllowSortsByArrival, :NEW.UpdatedBy);        END IF;            IF :OLD.IgnoreBadTimestamps != :NEW.IgnoreBadTimestamps THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'IgnoreBadTimestamps', :OLD.IgnoreBadTimestamps, :NEW.IgnoreBadTimestamps, :NEW.UpdatedBy);        END IF;            IF :OLD.TimeResolution != :NEW.TimeResolution THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'TimeResolution', :OLD.TimeResolution, :NEW.TimeResolution, :NEW.UpdatedBy);        END IF;         IF :OLD.AllowPreemptivePublishing != :NEW.AllowPreemptivePublishing THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AllowPreemptivePublishing', :OLD.AllowPreemptivePublishing, :NEW.AllowPreemptivePublishing, :NEW.UpdatedBy);        END IF;            IF :OLD.PerformTimeReasonabilityCheck != :NEW.PerformTimeReasonabilityCheck THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'PerformTimeReasonabilityCheck', :OLD.PerformTimeReasonabilityCheck, :NEW.PerformTimeReasonabilityCheck, :NEW.UpdatedBy);        END IF;            IF :OLD.DownsamplingMethod != :NEW.DownsamplingMethod THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'DownsamplingMethod', :OLD.DownsamplingMethod, :NEW.DownsamplingMethod, :NEW.UpdatedBy);        END IF;            IF :OLD.LoadOrder != :NEW.LoadOrder THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, :NEW.LoadOrder, :NEW.UpdatedBy);        END IF;            IF :OLD.Enabled != :NEW.Enabled THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, :NEW.Enabled, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;         IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;     END;    / CREATE TRIGGER CalcMeasurement_AuditDelete AFTER DELETE ON CalculatedMeasurement    FOR EACH ROW BEGIN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Acronym', :OLD.Acronym, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Name', :OLD.Name, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'ConfigSection', :OLD.ConfigSection, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'InputMeasurements', :OLD.InputMeasurements, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'OutputMeasurements', :OLD.OutputMeasurements, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'MinimumMeasurementsToUse', :OLD.MinimumMeasurementsToUse, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'FramesPerSecond', :OLD.FramesPerSecond, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LagTime', :OLD.LagTime, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LeadTime', :OLD.LeadTime, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UseLocalClockAsRealTime', :OLD.UseLocalClockAsRealTime, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AllowSortsByArrival', :OLD.AllowSortsByArrival, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'IgnoreBadTimestamps', :OLD.IgnoreBadTimestamps, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'TimeResolution', :OLD.TimeResolution, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'AllowPreemptivePublishing', :OLD.AllowPreemptivePublishing, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'PerformTimeReasonabilityCheck', :OLD.PerformTimeReasonabilityCheck, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'DownsamplingMethod', :OLD.DownsamplingMethod, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CalculatedMeasurement', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);     END;    / CREATE TRIGGER Company_AuditUpdate AFTER UPDATE ON Company    FOR EACH ROW BEGIN         IF :OLD.Acronym != :NEW.Acronym THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Acronym', :OLD.Acronym, :NEW.Acronym, :NEW.UpdatedBy);        END IF;            IF :OLD.MapAcronym != :NEW.MapAcronym THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'MapAcronym', :OLD.MapAcronym, :NEW.MapAcronym, :NEW.UpdatedBy);        END IF;         IF :OLD.Name != :NEW.Name THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Name', :OLD.Name, :NEW.Name, :NEW.UpdatedBy);        END IF;            IF :OLD.Url != :NEW.Url THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Url', :OLD.Url, :NEW.Url, :NEW.UpdatedBy);        END IF;         IF :OLD.LoadOrder != :NEW.LoadOrder THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, :NEW.LoadOrder, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;        END;    / CREATE TRIGGER Company_AuditDelete AFTER DELETE ON Company    FOR EACH ROW BEGIN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Acronym', :OLD.Acronym, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'MapAcronym', :OLD.MapAcronym, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Name', :OLD.Name, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'Url', :OLD.Url, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('Company', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);        END;    / CREATE TRIGGER CustomActAdapter_AuditUpdate AFTER UPDATE ON CustomActionAdapter    FOR EACH ROW BEGIN         IF :OLD.NodeID != :NEW.NodeID THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, :NEW.NodeID, :NEW.UpdatedBy);        END IF;         IF :OLD.AdapterName != :NEW.AdapterName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'AdapterName', :OLD.AdapterName, :NEW.AdapterName, :NEW.UpdatedBy);        END IF;            IF :OLD.AssemblyName != :NEW.AssemblyName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, :NEW.AssemblyName, :NEW.UpdatedBy);        END IF;            IF :OLD.TypeName != :NEW.TypeName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, :NEW.TypeName, :NEW.UpdatedBy);        END IF;            IF :OLD.ConnectionString != :NEW.ConnectionString THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, :NEW.ConnectionString, :NEW.UpdatedBy);        END IF;            IF :OLD.LoadOrder != :NEW.LoadOrder THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, :NEW.LoadOrder, :NEW.UpdatedBy);        END IF;            IF :OLD.Enabled != :NEW.Enabled THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, :NEW.Enabled, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;     END;    / CREATE TRIGGER CustomActAdapter_AuditDelete AFTER DELETE ON CustomActionAdapter    FOR EACH ROW BEGIN         INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'AdapterName', :OLD.AdapterName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomActionAdapter', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), NULL, '1', context.get_current_user);        END;    / CREATE TRIGGER CustomInputAdapter_AuditUpdate AFTER UPDATE ON CustomInputAdapter    FOR EACH ROW BEGIN         IF :OLD.NodeID != :NEW.NodeID THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, :NEW.NodeID, :NEW.UpdatedBy);        END IF;         IF :OLD.AdapterName != :NEW.AdapterName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'AdapterName', :OLD.AdapterName, :NEW.AdapterName, :NEW.UpdatedBy);        END IF;            IF :OLD.AssemblyName != :NEW.AssemblyName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, :NEW.AssemblyName, :NEW.UpdatedBy);        END IF;            IF :OLD.TypeName != :NEW.TypeName THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, :NEW.TypeName, :NEW.UpdatedBy);        END IF;            IF :OLD.ConnectionString != :NEW.ConnectionString THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, :NEW.ConnectionString, :NEW.UpdatedBy);        END IF;            IF :OLD.LoadOrder != :NEW.LoadOrder THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, :NEW.LoadOrder, :NEW.UpdatedBy);        END IF;            IF :OLD.Enabled != :NEW.Enabled THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, :NEW.Enabled, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedBy != :NEW.UpdatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, :NEW.UpdatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.UpdatedOn != :NEW.UpdatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'UpdatedOn', TO_CLOB(:OLD.UpdatedOn), TO_CLOB(:NEW.UpdatedOn), :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedBy != :NEW.CreatedBy THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'CreatedBy', :OLD.CreatedBy, :NEW.CreatedBy, :NEW.UpdatedBy);        END IF;            IF :OLD.CreatedOn != :NEW.CreatedOn THEN            INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'CreatedOn', TO_CLOB(:OLD.CreatedOn), TO_CLOB(:NEW.CreatedOn), :NEW.UpdatedBy);        END IF;     END;    / CREATE TRIGGER CustomInputAdapter_AuditDelete AFTER DELETE ON CustomInputAdapter    FOR EACH ROW BEGIN         INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'NodeID', :OLD.NodeID, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'AdapterName', :OLD.AdapterName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'AssemblyName', :OLD.AssemblyName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'TypeName', :OLD.TypeName, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'ConnectionString', :OLD.ConnectionString, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'LoadOrder', :OLD.LoadOrder, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'Enabled', :OLD.Enabled, NULL, '1', context.get_current_user);        INSERT INTO AuditLog (TableName, PrimaryKeyColumn, PrimaryKeyValue, ColumnName, OriginalValue, NewValue, Deleted, UpdatedBy) VALUES ('CustomInputAdapter', 'ID', :OLD.ID, 'UpdatedBy', :OLD.UpdatedBy, NULL, '1', context.get_current_user);

Lines 1–500 of 2018. Load more