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.OKE_CHG_REQUESTS_BRIU
Source
Description
OKE_CHG_REQUESTS_BRIU
/* $Header: OKETCRQ1.sql 115.7 2002/12/02 21:04:12 alaw ship $ */
BEFORE INSERT OR UPDATE ON OKE_CHG_REQUESTS
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT OR UPDATE
Column
When
NVL( OLD.CHG_STATUS_CODE , '@' ) <> NVL( NEW.CHG_STATUS_CODE , '@' )
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
OKE_CHG_REQ_UTILS.Status_Change
( 'TRIGGER'
, :NEW.K_Header_ID
, :NEW.Chg_Request_ID
, :NEW.Chg_Request_Num
, :NEW.Requested_By_Person_ID
, :NEW.Effective_Date
, :OLD.Chg_Status_Code
, :NEW.Chg_Status_Code
, :NEW.Chg_Type_Code
, :NEW.Chg_Reason_Code
, :NEW.Impact_Funding_Flag
, :NEW.Description
, :NEW.Chg_Text
, :NEW.Last_Updated_By
, :NEW.Last_Update_Date
, :NEW.Last_Update_Login
, :NEW.Last_Chg_Log_ID
, :NEW.Approve_Date
, :NEW.Implement_Date
);
END;