DBA Data[Home] [Help]

TRIGGER: APPS.CR_RSRC_CLS_UL

Source

Description
CR_RSRC_CLS_UL
instead of update on CR_RSRC_CLS_VL
referencing new as CR_RSRC_CLS
for each row
Type
INSTEAD OF
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS CR_RSRC_CLS OLD AS OLD
Body
begin
  CR_RSRC_CLS_PKG.UPDATE_ROW(
    X_RESOURCE_CLASS => :CR_RSRC_CLS.RESOURCE_CLASS,
    X_TRANS_CNT => :CR_RSRC_CLS.TRANS_CNT,
    X_DELETE_MARK => :CR_RSRC_CLS.DELETE_MARK,
    X_TEXT_CODE => :CR_RSRC_CLS.TEXT_CODE,
    X_RESOURCE_CLASS_DESC => :CR_RSRC_CLS.RESOURCE_CLASS_DESC,
    X_LAST_UPDATE_DATE => :CR_RSRC_CLS.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :CR_RSRC_CLS.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :CR_RSRC_CLS.LAST_UPDATE_LOGIN);
end UPDATE_ROW;