TRIGGER: APPS.FND_PROG_ONSITE_INSERT

Source

Description

"APPS"."FND_PROG_ONSITE_INSERT" 
 AFTER INSERT
 ON  "APPLSYS"."FND_CONCURRENT_PROGRAMS#"     FOR EACH ROW
 

Type

AFTER EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
   -- Insert into fnd_conc_prog_onsite_info table
   -- Not handling any exception. Let it raise that exception.
   insert into fnd_conc_prog_onsite_info
         (Program_Application_Id, Concurrent_Program_Id,
          Last_Update_Date, Last_Updated_By,
          Creation_Date, Created_By, Last_Update_Login,
	  reset_date, On_Failure_Log_Level)
   values
         (:new.Application_Id, :new.Concurrent_Program_Id,
          :new.Last_Update_Date, :new.Last_Updated_By,
          :new.Creation_Date, :new.Created_By, :new.Last_Update_Login,
	  sysdate, 'ERROR');
 END;