TRIGGER: APPS.FM_FORM_MST_IL

Source

Description

FM_FORM_MST_IL
/* $Header: gmdfmitg.sql 120.4 2011/03/07 21:22:26 plowe ship $ */
instead of insert on FM_FORM_MST_VL
referencing new as FM_FORM_MST
for each row

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS FM_FORM_MST OLD AS OLD

Body

declare
  row_id rowid;
begin
	FM_FORM_MST_MLS.INSERT_ROW(
	    X_ROWID 			=> row_id,
	    X_FORMULA_ID 		=> :FM_FORM_MST.FORMULA_ID,
	    X_MASTER_FORMULA_ID         => :FM_FORM_MST.MASTER_FORMULA_ID,
	    X_OWNER_ORGANIZATION_ID	=> :FM_FORM_MST.owner_organization_id,
	    X_TOTAL_INPUT_QTY 	        => :FM_FORM_MST.total_input_qty,
            X_TOTAL_OUTPUT_QTY	        => :FM_FORM_MST.total_output_qty,
            X_FORMULA_STATUS   	        => :FM_FORM_MST.formula_status,
            X_YIELD_UOM		        => :FM_FORM_MST.yield_uom,
 	    X_OWNER_ID 			=> :FM_FORM_MST.owner_id,
 	    X_PROJECT_ID 		=> NULL,
	    X_TEXT_CODE 		=> :FM_FORM_MST.TEXT_CODE,
	    X_DELETE_MARK 		=> :FM_FORM_MST.DELETE_MARK,
	    X_FORMULA_NO 		=> :FM_FORM_MST.FORMULA_NO,
	    X_FORMULA_VERS 		=> :FM_FORM_MST.FORMULA_VERS,
	    X_FORMULA_TYPE 		=> :FM_FORM_MST.FORMULA_TYPE,
	    X_IN_USE 			=> :FM_FORM_MST.IN_USE,
	    X_INACTIVE_IND 		=> :FM_FORM_MST.INACTIVE_IND,
	    X_SCALE_TYPE 		=> :FM_FORM_MST.SCALE_TYPE,
	    X_FORMULA_CLASS 	        => :FM_FORM_MST.FORMULA_CLASS,
	    X_FMCONTROL_CLASS 	        => :FM_FORM_MST.FMCONTROL_CLASS,
	    X_ATTRIBUTE_CATEGORY        => :FM_FORM_MST.ATTRIBUTE_CATEGORY,
	    X_ATTRIBUTE1 		=> :FM_FORM_MST.ATTRIBUTE1,
	    X_ATTRIBUTE2 		=> :FM_FORM_MST.ATTRIBUTE2,
	    X_ATTRIBUTE3 		=> :FM_FORM_MST.ATTRIBUTE3,
	    X_ATTRIBUTE4 		=> :FM_FORM_MST.ATTRIBUTE4,
	    X_ATTRIBUTE5 		=> :FM_FORM_MST.ATTRIBUTE5,
	    X_ATTRIBUTE6 		=> :FM_FORM_MST.ATTRIBUTE6,
	    X_ATTRIBUTE7 		=> :FM_FORM_MST.ATTRIBUTE7,
	    X_ATTRIBUTE8 		=> :FM_FORM_MST.ATTRIBUTE8,
	    X_ATTRIBUTE9 		=> :FM_FORM_MST.ATTRIBUTE9,
	    X_ATTRIBUTE10 		=> :FM_FORM_MST.ATTRIBUTE10,
	    X_ATTRIBUTE11 		=> :FM_FORM_MST.ATTRIBUTE11,
	    X_ATTRIBUTE12 		=> :FM_FORM_MST.ATTRIBUTE12,
	    X_ATTRIBUTE13 		=> :FM_FORM_MST.ATTRIBUTE13,
	    X_ATTRIBUTE14 		=> :FM_FORM_MST.ATTRIBUTE14,
	    X_ATTRIBUTE15		 => :FM_FORM_MST.ATTRIBUTE15,
	    X_ATTRIBUTE16 		=> :FM_FORM_MST.ATTRIBUTE16,
	    X_ATTRIBUTE17 		=> :FM_FORM_MST.ATTRIBUTE17,
	    X_ATTRIBUTE18 		=> :FM_FORM_MST.ATTRIBUTE18,
	    X_ATTRIBUTE19 		=> :FM_FORM_MST.ATTRIBUTE19,
	    X_ATTRIBUTE20 		=> :FM_FORM_MST.ATTRIBUTE20,
	    X_ATTRIBUTE21 		=> :FM_FORM_MST.ATTRIBUTE21,
	    X_ATTRIBUTE22 		=> :FM_FORM_MST.ATTRIBUTE22,
	    X_ATTRIBUTE23 		=> :FM_FORM_MST.ATTRIBUTE23,
	    X_ATTRIBUTE24 		=> :FM_FORM_MST.ATTRIBUTE24,
	    X_ATTRIBUTE25 		=> :FM_FORM_MST.ATTRIBUTE25,
	    X_ATTRIBUTE26 		=> :FM_FORM_MST.ATTRIBUTE26,
	    X_ATTRIBUTE27 		=> :FM_FORM_MST.ATTRIBUTE27,
	    X_ATTRIBUTE28 		=> :FM_FORM_MST.ATTRIBUTE28,
	    X_ATTRIBUTE29 		=> :FM_FORM_MST.ATTRIBUTE29,
	    X_ATTRIBUTE30 		=> :FM_FORM_MST.ATTRIBUTE30,
	    X_FORMULA_DESC1 	=> :FM_FORM_MST.FORMULA_DESC1,
	    X_FORMULA_DESC2 	=> :FM_FORM_MST.FORMULA_DESC2,
	    X_CREATION_DATE 	=> :FM_FORM_MST.CREATION_DATE,
	    X_CREATED_BY 		=> :FM_FORM_MST.CREATED_BY,
	    X_LAST_UPDATE_DATE 	=> :FM_FORM_MST.LAST_UPDATE_DATE,
	    X_LAST_UPDATED_BY 	=> :FM_FORM_MST.LAST_UPDATED_BY,
	    X_LAST_UPDATE_LOGIN => :FM_FORM_MST.LAST_UPDATE_LOGIN,
            X_AUTO_PRODUCT_CALC => :FM_FORM_MST.AUTO_PRODUCT_CALC);

end INSERT_ROW;