TRIGGER: APPS.PA_PJI_PROJECTS_T1

Source

Description

"APPS"."PA_PJI_PROJECTS_T1" 
AFTER INSERT
 ON  "PA"."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

       if :NEW.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	      	=> :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 if;

END;