[Home] [Help]
TRIGGER: APPS.GML_OP_ORDR_TYP_T2
Source
Description
GML_OP_ORDR_TYP_T2
instead of update on OP_ORDR_TYP_VL
referencing old as OP_ORDR_TYP
for each row
Type
INSTEAD OF
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OP_ORDR_TYP
Body
begin
GML_OP_ORDR_TYP_PKG.UPDATE_ROW(
X_ORDER_TYPE => :OP_ORDR_TYP.ORDER_TYPE,
X_LANG_CODE => :OP_ORDR_TYP.LANG_CODE,
X_INVEN_TRANS_TYPE => :OP_ORDR_TYP.INVEN_TRANS_TYPE,
X_SHIPMENT_IND => :OP_ORDR_TYP.SHIPMENT_IND,
X_INVOICE_IND => :OP_ORDR_TYP.INVOICE_IND,
X_PICKINGLST_IND => :OP_ORDR_TYP.PICKINGLST_IND,
X_EXPORTDOC_IND => :OP_ORDR_TYP.EXPORTDOC_IND,
X_TOTALORD_IND => :OP_ORDR_TYP.TOTALORD_IND,
X_UPDATE_SALESHIST => :OP_ORDR_TYP.UPDATE_SALESHIST,
X_CREDITCHK_TYPE => :OP_ORDR_TYP.CREDITCHK_TYPE,
X_PRICE_ORDER => :OP_ORDR_TYP.PRICE_ORDER,
X_CALC_COMM_IND => :OP_ORDR_TYP.CALC_COMM_IND,
X_CALC_TAX_IND => :OP_ORDR_TYP.CALC_TAX_IND,
X_PRODORDR_IND => :OP_ORDR_TYP.PRODORDR_IND,
X_SHIPTO_REQUIRED => :OP_ORDR_TYP.SHIPTO_REQUIRED,
X_UPDATE_AUDITTRAIL => :OP_ORDR_TYP.UPDATE_AUDITTRAIL,
X_ORDER_LEADTIME => :OP_ORDR_TYP.ORDER_LEADTIME,
X_TRANS_CNT => :OP_ORDR_TYP.TRANS_CNT,
X_TEXT_CODE => :OP_ORDR_TYP.TEXT_CODE,
X_DELETE_MARK => :OP_ORDR_TYP.DELETE_MARK,
X_ORDER_TYPE_CODE => :OP_ORDR_TYP.ORDER_TYPE_CODE,
X_ORDER_TYPE_DESC => :OP_ORDR_TYP.ORDER_TYPE_DESC,
X_LAST_UPDATE_DATE => :OP_ORDR_TYP.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => :OP_ORDR_TYP.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => :OP_ORDR_TYP.LAST_UPDATE_LOGIN);
end UPDATE_ROW;