[Home] [Help]
TRIGGER: APPS.PA_PJI_PROJECTS_T1
Source
Description
PA_PJI_PROJECTS_T1
AFTER INSERT ON PA_PROJECTS_ALL
FOR EACH ROW
Type
AFTER EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
l_event_id NUMBER;
l_row_id VARCHAR2(18);
BEGIN
PA_PJI_PROJ_EVENTS_LOG_PKG.Insert_Row(
X_ROW_ID => l_row_id,
X_EVENT_ID => l_event_id,
X_EVENT_TYPE => 'Projects',
X_EVENT_OBJECT => :NEW.project_id,
X_OPERATION_TYPE => 'I',
X_STATUS => 'X', --NULL
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => :NEW.CARRYING_OUT_ORGANIZATION_ID,
X_ATTRIBUTE2 => :NEW.CLOSED_DATE,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ATTRIBUTE16 => NULL,
X_ATTRIBUTE17 => NULL,
X_ATTRIBUTE18 => NULL,
X_ATTRIBUTE19 => NULL,
X_ATTRIBUTE20 => NULL
);
END;