BOM_BBMI_UNIQUE_ID_T
BEFORE INSERT
ON BOM_BILL_OF_MTLS_INTERFACE
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
l_date DATE := SYSDATE;
BEGIN
:NEW.LAST_UPDATE_DATE := l_date;
:NEW.CREATION_DATE := l_date;
IF :NEW.INTERFACE_TABLE_UNIQUE_ID IS NULL THEN
SELECT EGO_IMPORT_ROW_SEQ_S.NEXTVAL
INTO :NEW.INTERFACE_TABLE_UNIQUE_ID
FROM DUAL;
END IF;
END BOM_BBMI_UNIQUE_ID_T;