SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.ST_RELATIONSHIP_TRANSACTION
Parameters
Name
Type
Mode
Definition
TRIGGER IDM_STAGING.ST_RELATIONSHIP_TRANSACTION BEFORE INSERT ON IDM_STAGING.RELATIONSHIP_TRANSACTION FOR EACH ROW BEGIN :NEW.OBJECT_ID := 'rel' ||TO_CHAR(STAGING_SEQ.nextval,'FMxxxxxxxxxxxxxxxxxx'); IF ( :NEW.RELATIONSHIP_OBJECT_ID IS NULL) THEN :NEW.RELATIONSHIP_OBJECT_ID := :NEW.OBJECT_ID; END IF; END;