egdb3_12_9
.asset
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
acp_status_changed()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF NEW.status <> OLD.status AND NOT (NEW.status = 0 AND OLD.status = 7) THEN NEW.status_changed_time := now(); IF NEW.active_date IS NULL AND NEW.status IN (SELECT id FROM config.copy_status WHERE copy_active = true) THEN NEW.active_date := now(); END IF; END IF; RETURN NEW; END;