TRIGGER: APPS.OP_PRSL_TYP_UL

Source

Description

OP_PRSL_TYP_UL
/* $Header: GMLPR2TG.sql 120.2 2011/03/02 18:19:01 adeshmuk ship $ */
instead of update on OP_PRSL_TYP_VL
referencing old as OP_PRSL_TYP
for each row

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OP_PRSL_TYP

Body

begin
  GML_OP_PRSL_TYP_PKG.UPDATE_ROW(
    X_PRESALES_ORD_TYPE => :OP_PRSL_TYP.PRESALES_ORD_TYPE,
    X_LANG_CODE => :OP_PRSL_TYP.LANG_CODE,
    X_RELEASE_SCHED_REQD => :OP_PRSL_TYP.RELEASE_SCHED_REQD,
    X_PRICELIST_IND => :OP_PRSL_TYP.PRICELIST_IND,
    X_TRANS_CNT => :OP_PRSL_TYP.TRANS_CNT,
    X_TEXT_CODE => :OP_PRSL_TYP.TEXT_CODE,
    X_DELETE_MARK => :OP_PRSL_TYP.DELETE_MARK,
    X_PRESALES_ORD_CODE => :OP_PRSL_TYP.PRESALES_ORD_CODE,
    X_PRESALES_ORD_DESC => :OP_PRSL_TYP.PRESALES_ORD_DESC,
    X_LAST_UPDATE_DATE => :OP_PRSL_TYP.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :OP_PRSL_TYP.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :OP_PRSL_TYP.LAST_UPDATE_LOGIN);
end UPDATE_ROW;