TRIGGER: APPS.PA_PJI_PROJECTS_T2

Source

Description

PA_PJI_PROJECTS_T2
AFTER UPDATE OF
  -- Columns required for data warehouse
  CARRYING_OUT_ORGANIZATION_ID,
  CLOSED_DATE
ON 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

    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;