eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
TRIGGER: APPS.PA_PJI_PROJECTS_T2
Source
Description
"APPS"."PA_PJI_PROJECTS_T2"
AFTER UPDATE OF
-- Columns required for data warehouse
CARRYING_OUT_ORGANIZATION_ID,
CLOSED_DATE
ON "PA"."PA_PROJECTS_ALL#" FOR EACH ROW
Type
AFTER EACH ROW
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
l_event_id NUMBER;
l_row_id VARCHAR2(18);
BEGIN
if :OLD.template_flag <> 'Y' then --Bug 6603019
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 => :OLD.project_id,
X_OPERATION_TYPE => 'U',
X_STATUS => 'X', --NULL
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => :OLD.CARRYING_OUT_ORGANIZATION_ID,
X_ATTRIBUTE2 => :OLD.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 if;
END;