RaiseError does not always produces pop up window

Question

RaiseError does not always produces pop up window

swede

SSCommitted

Points: 1773
More actions
March 1, 2006 at 8:15 am

#103105

I have a developer that has a RaiseError condition in his trigger that does not always produces a pop up window when the condition occurs. He know it happening, because a rollback does occur. Does anyone have any ideas why the popup doesn't always occur or how to trap the condition?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Are you sure it is the trigger causing it and not so other piece. For instance if you have a unique constraint on the table and break that condition the trigger will not fire because the constraint is evaulated first.

swede SSCommitted Points: 1773 More actions · Answer 2

The only constraint on the table is the primary key. And the developer is sure its not a duplicate key.

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Can you post the DDL of your table and the trigger?

Also, can you provide details o how the inserts are being done, what is the process?

swede SSCommitted Points: 1773 More actions · Answer 4

inserts are being done through a vendor program... but here's the trigger..

-- Trigger Name: BAF_CMSARTICOLI_INSERT_UPDATE

--

-- Description: BAF_CMSARTICOLI_INSERT_UPDATE SQL trigger will Inserted or Updated columns in the CDS Article Master -- Table, CMSARTICOLI.

--

-- Revision Date Author Revision Description

-- 09-Oct-2005 Mark T Coble Trigger Created.

--

-- 20-Dec-2005 Mike Purvis Put in check for ARFLO2 (Control Style). If ARFLO2 is not populated

-- then set the Control Style ML (ARMFO2) to '' otherwise set it to 2M.

--

-- 20-Dec-2005 Mark T Coble Corrected the update of USRCreationDate.

--

-- 28-Dec-2005 Mark T Coble Map USRYarnCategoryTubeColorCode to IGCODK which is in the INFAG00F table

-- for ML 60 and ML 70.

--

-- 28-Dec-2005 Mike Purvis Corrected the code for ML20 & ML30 when LoomBeamStyle is different from

-- the code of the ML20

--

-- 28-Dec-2005 Mark T Coble Set short description to be equal to the first 15 characters of

-- USRYarnDescription and set extended description equal to the first 35

-- characters of the USRYarnDescription for ML60, ML70 and ML80.

--

-- 30-Dec-2005 Mark T Coble To calculate the number of days for ML GT we are changing all

-- Scheduled Dates to be the Trial Date. We will calculate the

-- difference between the Trail date and Actual Dates.

--

-- 30-Dec-2005 Mark T Coble On ML10 and MLFT changed the mapping of ends/inch from USRFinishedEndsInchAvg

-- to ARFICM and picks/inch from USRFinishedPicksInchAvg to ARINFN.

--

-- 02-Jan-2006 Mike Purvis On ML10 if Market (CODICELINEA) = 'GW' Government change prefix of

-- Finishing Routing Code to FG or if Maximum Widteh (ARATMN) > 69 change

-- prefix of Finishing Routing Code to FW.

--

-- 04-Jan-2006 Mark T Coble Added USRFinishEvaluationFormulaCode and USRFinishEvaluationTempHandStandard

-- to ML 10 and ML FT.

--

-- 05-Jan-2006 Mike Purvis Changed to populate DCFLCS Warp Ends in the Bill Of Material Detail.

-- GTEX uses ARFLCT (total warp ends) if DCFLCS is not populated. Also

-- Changed to populate DCCART Picks in the Bill of Material Detail for

-- for fill yarns.

--

-- 06-Jan-2006 Mike Purvis Changed to insert the Control Style into the USRControlStyleTable

-- on the ML 2M if it doesn't already exists.

--

-- 09-Jan-2006 Mike Purvis Changed the code to Delete the BOM Header and Details to include

-- the wildcard character %.

--

-- 09-Jan-2006 Mark T Coble Map USRGreigeSizeFormulaCode from the USRGreigeSizeFormulaTable

-- to ARFL08, to be exported to GTEX.

--

-- 09-Jan-2006 Mike Purvis Changed the code to Delete the BOM Header and Details to only include

-- the first 12 characters of the code.

--

-- 12-Jan-2006 Mark T Coble Map Dents/Inch from USRGreigeDentsInch to ARPTTN for ML 20.

--

-- 16-Jan-2006 Mark T Coble Update USRCutsBatchRoll with INFAG00F.IGCODA.

--

-- 18-Jan-2006 Mike Purvis Changed the ML 10 (Finished Fabric) code for the Finishing Routing.

-- If the Country of Origin is MX and the Primary Vendor is 569000 (Hurt)

-- then use the Hurt version of the Routing.

--

-- 24-Jan-2006 Mike Purvis Changed the ML 20 code for the Greige Routing to use ARFU10 rather

-- than USRCntryOfOrgCode.

--

-- 25-Jan-2006 Mark T Coble Set null values to 0 for ML 10 and ML FT.

--

-- 26-Jan-2006 Mark & Mike Capture Create Date for all MLs on INFAG table. Also Capture Air Space

-- on the ML 20 INFAG Table records.

--

-- 27-Jan-2006 Mike Purvis Check to not create BOM records for ML 10, 20, & 30 products that

-- don't have valid vendors. Also changed the ML20 code to move the

-- selects for capturing the Greige Routing Code before the update of the

-- Article Master and set the field in the ML20 record.

--

-- 02-Feb-2006 Mike Purvis On ML10 if Market (CODICELINEA) = 'GS' Government change prefix of

-- Finishing Routing Code to FG.

--

-- 10-Feb-2006 Mike Purvis Various enhancements for Product Development.

--

-- 15-Feb-2006 Mark T Coble Calculate shrinkage loss for ML 10 and Ml FT.

--

-- 17-Feb-2006 Mike Purvis Fixed divide by zero error

--

-- 20-Feb-2006 Mark T Coble Changed USRFinishEvaluationFormulaCode from a len of 4 to 5.

--

-- 20-Feb-2006 Mark T Coble Calculate finished ends/inch for ML 10 and ML FT.

--

-- 22-Feb-2006 Mike Purvis Changed to default for Ends Per Inch fields to be 1 rather than 0.

--

-- 28-Feb-2006 Mike Purvis Changed to test for Hurt and Casimires with just the first six numbers of vendor.

--

-- 01-Mar-2006 Mark T Coble Only calculate shrinkage loss if USRFinishedPicksInchAvg > 1.

--

CREATE TRIGGER BAF_CMSARTICOLI_INSERT_UPDATE ON CMSARTICOLI

FOR INSERT, UPDATE

AS

-- Declare local variables.

--

Declare

@Mlivarticolo varchar(2)

,@Codicecomponente varchar(28)

,@USRCareCode varchar(5)

,@TRATTAMENTOCANDEGGIO varchar(1) -- Care Code Bleaching

,@TRATTAMENTOLAVAGGIOSECCO varchar(1) -- Care Code Dry Cleaning

,@TRATTAMENTOASCIUGATURA varchar(1) -- Care Code Drying

,@TRATTAMENTOSTIRO varchar(1) -- Care Code Ironing

,@TRATTAMENTOLAVAGGIO varchar(1) -- Care Code Washing

,@ARTAUS varchar(20) -- U.S. Customs Tariff

,@ARFL01 varchar(3) -- Tariffs Category Code

,@UpdateUserID varchar(50)

,@USREndUseProfileCode varchar(4)

,@USRFinishCode varchar(3)

,@USRFinishDesc varchar(25)

,@USRFinishDescriptionOverride varchar(25)

,@ARAGMN float -- Finished Width Min Inches (nn.nn)

,@ARATMN float -- Finished Width Max Inches (nn.nn)

,@ARPSGR float -- Weight Min Oz/Sq Yd (nnn.nn)

,@ARDMAT float -- Weight Mid Oz/Sq Yd (nnn.nn)

,@ARATMX float -- Finished Width Cuttable (nn.nn)

,@USRFillStretchPercentMax float -- (nnn)

,@USRFillStretchPercentMin float -- (nnn)

,@USRFinishedEndsInchMax float -- (nnn)

,@USRFinishedEndsInchMin float -- (nnn)

,@USRFinishedPicksInchMax float -- (nnn)

,@USRFinishedPicksInchMin float -- (nnn)

,@USRMaxWtOzSqYd float -- (nnn.nn)

,@USRWarpStretchPercentMax float -- (nnn)

,@USRWarpStretchPercentMin float -- (nnn)

,@USRMidWidInches float -- (nnnn.nn)

,@USRCutWidCM float -- (nnn)

,@USRMinWidCM float -- (nnn)

,@USRMaxWidCM float -- (nnn)

,@USRMidWidCM float -- (nnn)

,@USRMinWtOzLnYd float -- (nnn.nn)

,@USRMaxWtOzLnYd float -- (nnn.nn)

,@ARPSFI float -- Finished Weight Mid Oz/Ln Yd (nnn.nn)

,@USRMinWtGrSqMtr float -- (nnn)

,@USRMaxWtGrSqMeter float -- (nnn)

,@USRMidWtGrSqMeter float -- (nnn)

,@USRMinWtGrLnMater float -- (nnn)

,@USRMaxWtGrLnMeter float -- (nnn)

,@USRMidWtGrLnMeter float -- (nnn)

,@USRFinishedEndsInchAvg float -- (nnn)

,@USRFinishedPicksInchAvg float -- (nnn)

,@USRFinishedEndsCMMin float -- (nnn)

,@USRFinishedEndsCMMax float -- (nnn)

,@USRFinishedEndsCMAvg float -- (nnn)

,@USRFinishedPicksCMMin float -- (nnn)

,@USRFinishedPicksCMMax float -- (nnn)

,@USRFinishedPicksCMAvg float -- (nnn)

,@USRAverageYarnNumber float -- (nnnnnn)

,@USRYarnCategoryActive varchar(1)

,@ARFG02 varchar(2)

,@USRCntryOfOrgCode varchar(2)

,@Descrizionecomponente varchar(35)

,@USRYarnCategoryDyeCode varchar(5)

,@ARMDMN float -- Min Production Quan

,@USRYarnCategoryEstablishedDate datetime

,@USRYarnCategoryStandardYdsLb float

,@ARDSBR varchar(15) -- Short Description

,@ARTPPD varchar(1) -- Manufactured/Purchased

,@CODICEFORNITORE varchar(8)

,@ARTITL float -- Actal Denier

,@USRCreationDate datetime

,@USRRevisionDate datetime

,@USRPieceDyeStockDye varchar(10)

,@USRFinishLeadTime smallint

,@ARFLO2 varchar(28) -- ARFLO2 is Control Style

,@ARTPTT varchar(10) -- Yarn Unit Count

,@USRYarnCategoryYarnCountUnitEquivalFactor float

,@USRYarnCategoryEquivalSingleCount float

,@ARQU03 float -- lb/Week/Machine

,@USRGreigeEndsCM float

,@ARFICM float -- Ends/Inch

,@USRGreigePicksCM float

,@ARINFN float -- Picks/Inch

,@ARINCM float

,@USRGreigeReedSpreadCM float

,@ARAPTT float -- Reed Spread In Inches

,@USRGreigeCutLengthMinBatchRoll float

,@USRGreigeCutLengthMin float

-- 16-Jan-2006 MtC

,@USRCutsBatchRoll float

,@USRGreigeCutLength float

,@USRBeckLoadInPounds float

,@USRGreigeCutLengthMaxBatchRoll float

,@USRGreigeCutLengthMax float

,@USRGreigeStopsTotal float

,@USRGreigeStopsCatchCord float

,@USRGreigeStopsFill float

,@USRGreigeStopsLeno float

,@USRGreigeStopsOther float

,@USRGreigeStopsWarp float

,@USRGreigePlanningYarnNetFactor float

,@USRGreigePlanningYarnStretchFactor float

,@USRGreigePlanningYarnTakeupFactor float

,@USRGreigePlanningStdSetLength float

,@USRGreigeDentsCM float

,@USRGreigeDentsInch float

,@USRGreigePlanningStdBeamsPerSet float

,@USRGreigePlanningStdLoomBeamLen float

,@ARDSTD float -- ML20 - Cut Len Mid/Batch Roll Yds

-- ML10 - Beck Loading Yards

,@USRGreigeYarnCategoryRevisionStdYdslb float

,@USRGreigeYarnCategoryRevision01 varchar(20)

,@USRGreigeYarnCategoryRevision02 varchar(20)

,@USRGreigeYarnCategoryRevision03 varchar(20)

,@USRGreigeYarnCategoryRevision04 varchar(20)

,@USRGreigeYarnCategoryRevision05 varchar(20)

,@USRGreigeYarnCategoryRevision06 varchar(20)

,@USRGreigeYarnCategoryRevision07 varchar(20)

,@USRGreigeYarnCategoryRevision08 varchar(20)

,@USRGreigeYarnCategoryRevision09 varchar(20)

,@USRGreigeYarnCategoryRevision10 varchar(20)

,@USRGreigeYarnCategoryRevision11 varchar(20)

,@USRGreigeYarnCategoryRevision12 varchar(20)

,@USRGreigeYarnCategoryRevision13 varchar(20)

,@USRGreigeYarnCategoryRevision14 varchar(20)

,@USRGreigeYarnCategoryRevision15 varchar(20)

,@USRGreigeYarnCategoryRevision16 varchar(20)

,@USRGreigeYarnCategoryRevision17 varchar(20)

,@USRGreigeYarnCategoryRevision18 varchar(20)

,@USRGreigeYarnCategoryRevision19 varchar(20)

,@USRGreigeYarnCategoryRevision20 varchar(20)

,@USRGreigeYarnType01 varchar(1)

,@USRGreigeYarnType02 varchar(1)

,@USRGreigeYarnType03 varchar(1)

,@USRGreigeYarnType04 varchar(1)

,@USRGreigeYarnType05 varchar(1)

,@USRGreigeYarnType06 varchar(1)

,@USRGreigeYarnType07 varchar(1)

,@USRGreigeYarnType08 varchar(1)

,@USRGreigeYarnType09 varchar(1)

,@USRGreigeYarnType10 varchar(1)

,@USRGreigeYarnType11 varchar(1)

,@USRGreigeYarnType12 varchar(1)

,@USRGreigeYarnType13 varchar(1)

,@USRGreigeYarnType14 varchar(1)

,@USRGreigeYarnType15 varchar(1)

,@USRGreigeYarnType16 varchar(1)

,@USRGreigeYarnType17 varchar(1)

,@USRGreigeYarnType18 varchar(1)

,@USRGreigeYarnType19 varchar(1)

,@USRGreigeYarnType20 varchar(1)

,@USRGreigeYarnSequence01 varchar(1)

,@USRGreigeYarnSequence02 varchar(1)

,@USRGreigeYarnSequence03 varchar(1)

,@USRGreigeYarnSequence04 varchar(1)

,@USRGreigeYarnSequence05 varchar(1)

,@USRGreigeYarnSequence06 varchar(1)

,@USRGreigeYarnSequence07 varchar(1)

,@USRGreigeYarnSequence08 varchar(1)

,@USRGreigeYarnSequence09 varchar(1)

,@USRGreigeYarnSequence10 varchar(1)

,@USRGreigeYarnSequence11 varchar(1)

,@USRGreigeYarnSequence12 varchar(1)

,@USRGreigeYarnSequence13 varchar(1)

,@USRGreigeYarnSequence14 varchar(1)

,@USRGreigeYarnSequence15 varchar(1)

,@USRGreigeYarnSequence16 varchar(1)

,@USRGreigeYarnSequence17 varchar(1)

,@USRGreigeYarnSequence18 varchar(1)

,@USRGreigeYarnSequence19 varchar(1)

,@USRGreigeYarnSequence20 varchar(1)

,@USRGreigeYarnEndsPicks01 float

,@USRGreigeYarnEndsPicks02 float

,@USRGreigeYarnEndsPicks03 float

,@USRGreigeYarnEndsPicks04 float

,@USRGreigeYarnEndsPicks05 float

,@USRGreigeYarnEndsPicks06 float

,@USRGreigeYarnEndsPicks07 float

,@USRGreigeYarnEndsPicks08 float

,@USRGreigeYarnEndsPicks09 float

,@USRGreigeYarnEndsPicks10 float

,@USRGreigeYarnEndsPicks11 float

,@USRGreigeYarnEndsPicks12 float

,@USRGreigeYarnEndsPicks13 float

,@USRGreigeYarnEndsPicks14 float

,@USRGreigeYarnEndsPicks15 float

,@USRGreigeYarnEndsPicks16 float

,@USRGreigeYarnEndsPicks17 float

,@USRGreigeYarnEndsPicks18 float

,@USRGreigeYarnEndsPicks19 float

,@USRGreigeYarnEndsPicks20 float

,@USRGreigeYarnWt100Yds01 float

,@USRGreigeYarnWt100Yds02 float

,@USRGreigeYarnWt100Yds03 float

,@USRGreigeYarnWt100Yds04 float

,@USRGreigeYarnWt100Yds05 float

,@USRGreigeYarnWt100Yds06 float

,@USRGreigeYarnWt100Yds07 float

,@USRGreigeYarnWt100Yds08 float

,@USRGreigeYarnWt100Yds09 float

,@USRGreigeYarnWt100Yds10 float

,@USRGreigeYarnWt100Yds11 float

,@USRGreigeYarnWt100Yds12 float

,@USRGreigeYarnWt100Yds13 float

,@USRGreigeYarnWt100Yds14 float

,@USRGreigeYarnWt100Yds15 float

,@USRGreigeYarnWt100Yds16 float

,@USRGreigeYarnWt100Yds17 float

,@USRGreigeYarnWt100Yds18 float

,@USRGreigeYarnWt100Yds19 float

,@USRGreigeYarnWt100Yds20 float

,@USRGreigeYarnTotWarpSelvWt100Yds float

,@USRGreigeYarnTotFillWt100Yds float

,@USRGreigeYarnTotWt100Yds float

,@USRGreigeYarnTotWarpSelvEndsPicks float

,@USRGreigeYarnTotFillEndsPicks float

,@USRGreigeBoiloffWarpShrinkagePercent float

,@USRGreigeBoiloffFillShrinkagePercent float

,@USRGreigeBoiloffBeforePicks float

,@USRGreigeBoiloffBeforeWidth float

,@USRGreigeBoiloffAfterPicks float

,@USRGreigeBoiloffAfterWidth float

,@USRGreigeLoomBeamStyleRevision varchar(28)

-- Local variables for ML FT

--

,@ML20CodeFromMLFT varchar(8)

,@ML20FabricDesc varchar(35)

,@ML20ARFL06 varchar(3)

,@ML20TypeWeave varchar(35)

,@ML20Market varchar(2)

,@ML20RDCode varchar(20)

,@ML20FiberContent varchar(3)

,@ML20GreigeYarnCategoryRevision01 varchar(20)

,@ML20GreigeYarnCategoryRevision02 varchar(20)

,@ML20GreigeYarnCategoryRevision03 varchar(20)

,@ML20GreigeYarnCategoryRevision04 varchar(20)

,@ML20GreigeYarnCategoryRevision05 varchar(20)

,@ML20GreigeYarnCategoryRevision06 varchar(20)

,@ML20GreigeYarnCategoryRevision07 varchar(20)

,@ML20GreigeYarnCategoryRevision08 varchar(20)

,@ML20GreigeYarnCategoryRevision09 varchar(20)

,@ML20GreigeYarnCategoryRevision10 varchar(20)

,@ML20GreigeYarnCategoryRevision11 varchar(20)

,@ML20GreigeYarnCategoryRevision12 varchar(20)

,@ML20GreigeYarnCategoryRevision13 varchar(20)

,@ML20GreigeYarnCategoryRevision14 varchar(20)

,@ML20GreigeYarnCategoryRevision15 varchar(20)

,@ML20GreigeYarnCategoryRevision16 varchar(20)

,@ML20GreigeYarnCategoryRevision17 varchar(20)

,@ML20GreigeYarnCategoryRevision18 varchar(20)

,@ML20GreigeYarnCategoryRevision19 varchar(20)

,@ML20GreigeYarnCategoryRevision20 varchar(20)

,@ML20GreigeYarnType01 varchar(1)

,@ML20GreigeYarnType02 varchar(1)

,@ML20GreigeYarnType03 varchar(1)

,@ML20GreigeYarnType04 varchar(1)

,@ML20GreigeYarnType05 varchar(1)

,@ML20GreigeYarnType06 varchar(1)

,@ML20GreigeYarnType07 varchar(1)

,@ML20GreigeYarnType08 varchar(1)

,@ML20GreigeYarnType09 varchar(1)

,@ML20GreigeYarnType10 varchar(1)

,@ML20GreigeYarnType11 varchar(1)

,@ML20GreigeYarnType12 varchar(1)

,@ML20GreigeYarnType13 varchar(1)

,@ML20GreigeYarnType14 varchar(1)

,@ML20GreigeYarnType15 varchar(1)

,@ML20GreigeYarnType16 varchar(1)

,@ML20GreigeYarnType17 varchar(1)

,@ML20GreigeYarnType18 varchar(1)

,@ML20GreigeYarnType19 varchar(1)

,@ML20GreigeYarnType20 varchar(1)

,@ML20GreigeYarnSequence01 varchar(1)

,@ML20GreigeYarnSequence02 varchar(1)

,@ML20GreigeYarnSequence03 varchar(1)

,@ML20GreigeYarnSequence04 varchar(1)

,@ML20GreigeYarnSequence05 varchar(1)

,@ML20GreigeYarnSequence06 varchar(1)

,@ML20GreigeYarnSequence07 varchar(1)

,@ML20GreigeYarnSequence08 varchar(1)

,@ML20GreigeYarnSequence09 varchar(1)

,@ML20GreigeYarnSequence10 varchar(1)

,@ML20GreigeYarnSequence11 varchar(1)

,@ML20GreigeYarnSequence12 varchar(1)

,@ML20GreigeYarnSequence13 varchar(1)

,@ML20GreigeYarnSequence14 varchar(1)

,@ML20GreigeYarnSequence15 varchar(1)

,@ML20GreigeYarnSequence16 varchar(1)

,@ML20GreigeYarnSequence17 varchar(1)

,@ML20GreigeYarnSequence18 varchar(1)

,@ML20GreigeYarnSequence19 varchar(1)

,@ML20GreigeYarnSequence20 varchar(1)

,@ML20GreigeYarnEndsPicks01 float

,@ML20GreigeYarnEndsPicks02 float

,@ML20GreigeYarnEndsPicks03 float

,@ML20GreigeYarnEndsPicks04 float

,@ML20GreigeYarnEndsPicks05 float

,@ML20GreigeYarnEndsPicks06 float

,@ML20GreigeYarnEndsPicks07 float

,@ML20GreigeYarnEndsPicks08 float

,@ML20GreigeYarnEndsPicks09 float

,@ML20GreigeYarnEndsPicks10 float

,@ML20GreigeYarnEndsPicks11 float

,@ML20GreigeYarnEndsPicks12 float

,@ML20GreigeYarnEndsPicks13 float

,@ML20GreigeYarnEndsPicks14 float

,@ML20GreigeYarnEndsPicks15 float

,@ML20GreigeYarnEndsPicks16 float

,@ML20GreigeYarnEndsPicks17 float

,@ML20GreigeYarnEndsPicks18 float

,@ML20GreigeYarnEndsPicks19 float

,@ML20GreigeYarnEndsPicks20 float

,@ML20GreigeYarnWt100Yds01 float

,@ML20GreigeYarnWt100Yds02 float

,@ML20GreigeYarnWt100Yds03 float

,@ML20GreigeYarnWt100Yds04 float

,@ML20GreigeYarnWt100Yds05 float

,@ML20GreigeYarnWt100Yds06 float

,@ML20GreigeYarnWt100Yds07 float

,@ML20GreigeYarnWt100Yds08 float

,@ML20GreigeYarnWt100Yds09 float

,@ML20GreigeYarnWt100Yds10 float

,@ML20GreigeYarnWt100Yds11 float

,@ML20GreigeYarnWt100Yds12 float

,@ML20GreigeYarnWt100Yds13 float

,@ML20GreigeYarnWt100Yds14 float

,@ML20GreigeYarnWt100Yds15 float

,@ML20GreigeYarnWt100Yds16 float

,@ML20GreigeYarnWt100Yds17 float

,@ML20GreigeYarnWt100Yds18 float

,@ML20GreigeYarnWt100Yds19 float

,@ML20GreigeYarnWt100Yds20 float

,@ML20CommerceFabricType varchar(4)

,@ML20ARFG09 varchar(3)

,@ML20DiscountFabricType varchar(3)

,@ML20GreigeCostStatus varchar(10)

,@ARLRKG float

,@USRCalculatedYardsToWeave int

,@USRExperWeaveReqSampleBeckYds int

,@USRGreigeExperWeaveRequestStatus varchar(10)

,@USRPreparationYards int

,@PrepYardsReal real

,@USRRequestedCutsToWeave int

,@USRRequestedYardsToWeave int

,@USRYardsForLab int

,@USRExperWeaveReqActualDateDrawReady datetime

,@USRExperWeaveReqActualDateFill datetime

,@USRExperWeaveReqActualDateInLoom datetime

,@USRExperWeaveReqActualDateOutOfLoom datetime

,@USRExperWeaveReqActualDateShipFirst datetime

,@USRExperWeaveReqActualDateSlashReady datetime

,@USRExperWeaveReqActualDateWarp datetime

,@USRExperWeaveReqActualDateWarpReady datetime

,@USRExperWeaveReqScheDateDrawReady datetime

,@USRExperWeaveReqScheDateFill datetime

,@USRExperWeaveReqScheDateInLoom datetime

,@USRExperWeaveReqScheDateOutOfLoom datetime

,@USRExperWeaveReqScheDateShipFirst datetime

,@USRExperWeaveReqScheDateSlashReady datetime

,@USRExperWeaveReqScheDateWarp datetime

,@USRExperWeaveReqScheDateWarpReady datetime

,@USRExperWeaveReqNumOfDaysDrawReady int

,@USRExperWeaveReqNumOfDaysFill int

,@USRExperWeaveReqNumOfDaysInLoom int

,@USRExperWeaveReqNumOfDaysOutOfLoom int

,@USRExperWeaveReqNumOfDaysShipFirst int

,@USRExperWeaveReqNumOfDaysSlashReady int

,@USRExperWeaveReqNumOfDaysWarp int

,@USRExperWeaveReqNumOfDaysWarpReady int

,@ML30Code varchar(28)

,@CODICEDIVISIONE varchar(2)

,@CODICELINEA varchar(2)

,@TIPOPRODOTTO varchar(3)

,@ARCOMP varchar(3)

,@ARFLCT int

,@ARLGCT real

,@ARHHCT real

,@YarnRecNo float

,@YarnCatRev varchar(20)

,@YarnType varchar(1)

,@YarnWtLb100Yd float -- nn.nn

,@YarnSequence varchar(1)

,@USRGreiDyeFactFiberDyeCategory01 varchar(1)

,@USRGreiDyeFactFiberDyeCategory02 varchar(1)

,@USRGreiDyeFactFiberDyeCategory03 varchar(1)

,@USRGreiDyeFactFiberDyeCategory04 varchar(1)

,@USRGreiDyeFactFiberDyeCategory05 varchar(1)

,@USRGreiDyeFactFiberDyeCategory06 varchar(1)

,@USRGreiDyeFactFiberDyeCategory07 varchar(1)

,@USRGreiDyeFactFiberDyeCategory08 varchar(1)

,@USRGreiDyeFactFiberDyeCategory09 varchar(1)

,@USRGreiDyeFactFiberDyeCategory10 varchar(1)

,@USRGreiDyeFactFiberPercent01 float -- nnn

,@USRGreiDyeFactFiberPercent02 float -- nnn

,@USRGreiDyeFactFiberPercent03 float -- nnn

,@USRGreiDyeFactFiberPercent04 float -- nnn

,@USRGreiDyeFactFiberPercent05 float -- nnn

,@USRGreiDyeFactFiberPercent06 float -- nnn

,@USRGreiDyeFactFiberPercent07 float -- nnn

,@USRGreiDyeFactFiberPercent08 float -- nnn

,@USRGreiDyeFactFiberPercent09 float -- nnn

,@USRGreiDyeFactFiberPercent10 float -- nnn

,@USRGreiDyeFactFiberType01 varchar(5)

,@USRGreiDyeFactFiberType02 varchar(5)

,@USRGreiDyeFactFiberType03 varchar(5)

,@USRGreiDyeFactFiberType04 varchar(5)

,@USRGreiDyeFactFiberType05 varchar(5)

,@USRGreiDyeFactFiberType06 varchar(5)

,@USRGreiDyeFactFiberType07 varchar(5)

,@USRGreiDyeFactFiberType08 varchar(5)

,@USRGreiDyeFactFiberType09 varchar(5)

,@USRGreiDyeFactFiberType10 varchar(5)

,@USRGreiDyeFactFiberTradeName01 varchar(10)

,@USRGreiDyeFactFiberTradeName02 varchar(10)

,@USRGreiDyeFactFiberTradeName03 varchar(10)

,@USRGreiDyeFactFiberTradeName04 varchar(10)

,@USRGreiDyeFactFiberTradeName05 varchar(10)

,@USRGreiDyeFactFiberTradeName06 varchar(10)

,@USRGreiDyeFactFiberTradeName07 varchar(10)

,@USRGreiDyeFactFiberTradeName08 varchar(10)

,@USRGreiDyeFactFiberTradeName09 varchar(10)

,@USRGreiDyeFactFiberTradeName10 varchar(10)

,@USRGreiDyeFactFiberGramsLinearYd01 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd02 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd03 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd04 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd05 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd06 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd07 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd08 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd09 float -- nnn.nn

,@USRGreiDyeFactFiberGramsLinearYd10 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat1 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat2 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat3 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat4 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat5 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat6 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat7 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat8 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat9 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYdByDayCat10 float -- nnn.nn

,@USRGreiDyeFactTotGrLinearYd float -- nnn.nn

,@USRGreiDyeFactTotWt100Yds float -- nnnnn.nn

--

-- Local Variables for BOM Automation

,@Suffissodb varchar(2)

,@SuffissodbInt smallint

,@NUMSEQUENZA int

,@NUMALTERNATIVA int

,@IS_GHOST bit

,@COMPCRIT bit

,@FABBISOGNO real

,@FABBISOGNO01 real

,@FABBISOGNO02 real

,@FABBISOGNO03 real

,@FABBISOGNO04 real

,@FABBISOGNO05 real

,@FABBISOGNO06 real

,@CML2MydsPerML10 real

,@LbsPerYdFill real

,@LbsPerYdWarp real

,@MLIVCOMPONENTE varchar(2)

,@BOMCODICECOMPONENTE varchar(28)

,@MLCode varchar(28)

,@BOMMlivarticolo varchar(2)

,@CODICEARTICOLO varchar(28)

,@DCIDFL varchar(1)

,@DCFLFT varchar(1)

,@Currentdate smalldatetime

,@USRFinishRouting varchar(5)

,@USRGreigeRouting varchar(5)

,@USRLoomBeamRouting varchar(5)

,@USRYarnRouting varchar(5)

,@CODICEDESTINAZIONE varchar(2)

,@ComponentML varchar(2)

,@ComponentMLCode varchar(28)

,@CurDate nvarchar(25)

,@Yarn01ML varchar(2)

,@Yarn01Code varchar(28)

,@Yarn01Ply int

,@Yarn01Denier real

,@Yarn01PlyDenier real

,@Yarn02ML varchar(2)

,@Yarn02Code varchar(28)

,@Yarn02Ply int

,@Yarn02Denier real

,@Yarn02PlyDenier real

,@Yarn03ML varchar(2)

,@Yarn03Code varchar(28)

,@Yarn03Ply int

,@Yarn03Denier real

,@Yarn03PlyDenier real

,@Yarn04ML varchar(2)

,@Yarn04Code varchar(28)

,@Yarn04Ply int

,@Yarn04Denier real

,@Yarn04PlyDenier real

,@Yarn05ML varchar(2)

,@Yarn05Code varchar(28)

,@Yarn05Ply int

,@Yarn05Denier real

,@Yarn05PlyDenier real

,@Yarn06ML varchar(2)

,@Yarn06Code varchar(28)

,@Yarn06Ply int

,@Yarn06Denier real

,@Yarn06PlyDenier real

,@Yarn07ML varchar(2)

,@Yarn07Code varchar(28)

,@Yarn08ML varchar(2)

,@Yarn08Code varchar(28)

,@Yarn09ML varchar(2)

,@Yarn09Code varchar(28)

,@Yarn10ML varchar(2)

,@Yarn10Code varchar(28)

,@Yarn11ML varchar(2)

,@Yarn11Code varchar(28)

,@Yarn12ML varchar(2)

,@Yarn12Code varchar(28)

,@Yarn13ML varchar(2)

,@Yarn13Code varchar(28)

,@Yarn14ML varchar(2)

,@Yarn14Code varchar(28)

,@Yarn15ML varchar(2)

,@Yarn15Code varchar(28)

,@Yarn16ML varchar(2)

,@Yarn16Code varchar(28)

,@Yarn17ML varchar(2)

,@Yarn17Code varchar(28)

,@Yarn18ML varchar(2)

,@Yarn18Code varchar(28)

,@Yarn19ML varchar(2)

,@Yarn19Code varchar(28)

,@Yarn20ML varchar(2)

,@Yarn20Code varchar(28)

,@FillWasteFactor real

,@USRFinishPlanningFactorsTotal float--decimal(3,1)

,@USRGreigePlanningYarnFillWasteFactor decimal(3,1)

,@USRWorstedOrSynthetic varchar(2)

,@YarnML varchar(2)

,@ARFL06 varchar(3) -- ARFL06 is Loom Type

,@USRAutoCreateML60BOMFlag varchar(1)

,@NumberOfComponents smallint

,@TotalDenier real

,@ML70YarnCount real

,@USRYarnCategoryYarnCountDenierFactor real

,@x float

,@y float

,@z float

,@ARNRLI smallint -- ARNRLI is Harness

,@StdNbrSectionBeams int

,@USRWarpStyleGroup varchar(5)

,@USRFinishPlanningShrinkageWorkingLoss float

,@USRFinishPlanningShrinkageLoss float

,@USRFinishPlanningWorkingLoss float

,@USRFinishPlanningSecondsPercentage float

,@USRGreigePlanningGreigeSecondsPercentage float

,@USRGreigeYdsToEstFinishYds float

,@USRYarnDescription varchar(65)

,@USRGreigeYdsToSellableYds float

,@USRControlStyleDescription varchar(35)

,@ARFG10 varchar(3)

,@USRControlStyle varchar(28)

,@ARGGCC float

,@ARMFO2 varchar(2)

,@USRYarnCategoryTubeColorCode varchar(2)

-- 28-Dec-2005

,@Bypass_ML30_BOM varchar(1)

-- 30-Dec-2005 MtC

,@USRTrialDate datetime

-- 04-Jan-2006 MtC

,@USRFinishEvaluationTempHandStandard varchar(9)

,@USRFinishEvaluationFormulaCode varchar(5)

-- 05-Jan-2006 MDP

,@DCFLCS int

,@DCCART decimal(5,2) -- Picks nnnnnn.nn

,@EndsPicks float

-- 09-Jan-2006 MtC

,@ARFL07 varchar(3) -- Greige Size Formula, key on USRGreigeSizeFormulaTable

,@ARFL08 varchar(3) -- Size Formula Code to be exported to GTEX.

,@USRGreigeSizeFormulaCode int -- Size Formula Code is a column on the USRGreigeSizeFormulaTable

-- 12-Jan-2006 MtC

,@ARPTTN varchar(6) -- Dents/Inch

-- 24-Jan-2006 MDP

,@ARFU10 varchar(10)

-- 26-Jan-2006 MtC

,@USRGreigeAirspacePercent float

,@USRControlStyleEstdate datetime

,@Numeric_YYMMDD int

-- 27-Jan-2006 MDP

,@CreateBom varchar(1)

-- 10-Feb-2006 MDP

,@USRFTOriginationDate datetime

-- 15-Feb-2006 MtC

,@TOTAL_PICKS float

-- 20-Feb-2006 MtC

,@TOTAL_ENDS float

-- Set the local variables to be equal to the inserted variables from the record to be inserted or updated by user input.

--

Select @Mlivarticolo = Inserted.Mlivarticolo

,@Codicecomponente = Inserted.Codicecomponente

,@USRCareCode = Inserted.USRCareCode

,@ARTAUS = Inserted.ARTAUS

,@UpdateUserID = Inserted.OPERATORE

,@USREndUseProfileCode = Inserted.USREndUseProfileCode

,@USRFinishCode = SUBSTRING(Inserted.Codicecomponente, 7, 3)

,@USRFinishDescriptionOverride = USRFinishDescriptionOverride

,@ARAGMN = Inserted.ARAGMN

,@ARATMN = Inserted.ARATMN

,@ARPSGR = Inserted.ARPSGR

,@ARDMAT = Inserted.ARDMAT

,@ARATMX = Inserted.ARATMX

,@USRFillStretchPercentMax = Inserted.USRFillStretchPercentMax

,@USRFillStretchPercentMin = Inserted.USRFillStretchPercentMin

,@USRFinishedEndsInchMax = Inserted.USRFinishedEndsInchMax

,@USRFinishedEndsInchMin = Inserted.USRFinishedEndsInchMin

,@USRFinishedPicksInchMax = Inserted.USRFinishedPicksInchMax

,@USRFinishedPicksInchMin = Inserted.USRFinishedPicksInchMin

,@USRMaxWtOzSqYd = Inserted.USRMaxWtOzSqYd

,@USRWarpStretchPercentMax = Inserted.USRWarpStretchPercentMax

,@USRWarpStretchPercentMin = Inserted.USRWarpStretchPercentMin

,@USRMidWidInches = Inserted.USRMidWidInches

,@USRCutWidCM = Inserted.USRCutWidCM

,@USRMinWidCM = Inserted.USRMinWidCM

,@USRMaxWidCM = Inserted.USRMaxWidCM

,@USRMidWidCM = Inserted.USRMidWidCM

,@USRMinWtOzLnYd = Inserted.USRMinWtOzLnYd

,@USRMaxWtOzLnYd = Inserted.USRMaxWtOzLnYd

,@ARPSFI = Inserted.ARPSFI

,@USRMinWtGrSqMtr = Inserted.USRMinWtGrSqMtr

,@USRMaxWtGrSqMeter = Inserted.USRMaxWtGrSqMeter

,@USRMidWtGrSqMeter = Inserted.USRMidWtGrSqMeter

,@USRMinWtGrLnMater = Inserted.USRMinWtGrLnMater

,@USRMaxWtGrLnMeter = Inserted.USRMaxWtGrLnMeter

,@USRMidWtGrLnMeter = Inserted.USRMidWtGrLnMeter

,@USRFinishedEndsInchAvg = Inserted.USRFinishedEndsInchAvg

,@USRFinishedPicksInchAvg = Inserted.USRFinishedPicksInchAvg

,@USRFinishedEndsCMMin = Inserted.USRFinishedEndsCMMin

,@USRFinishedEndsCMMax = Inserted.USRFinishedEndsCMMax

,@USRFinishedEndsCMAvg = Inserted.USRFinishedEndsCMAvg

,@USRFinishedPicksCMMin = Inserted.USRFinishedPicksCMMin

,@USRFinishedPicksCMMax = Inserted.USRFinishedPicksCMMax

,@USRFinishedPicksCMAvg = Inserted.USRFinishedPicksCMAvg

,@USRAverageYarnNumber = Inserted.USRAverageYarnNumber

,@USRYarnCategoryActive = Inserted.USRYarnCategoryActive

,@ARFG02 = Inserted.ARFG02

,@USRCntryOfOrgCode = Inserted.USRCntryOfOrgCode

,@Descrizionecomponente = Inserted.Descrizionecomponente

,@USRYarnCategoryDyeCode = Inserted.USRYarnCategoryDyeCode

,@ARMDMN = Inserted.ARMDMN

,@USRYarnCategoryEstablishedDate = Inserted.USRYarnCategoryEstablishedDate

,@USRYarnCategoryStandardYdsLb = Inserted.USRYarnCategoryStandardYdsLb

,@ARDSBR = Inserted.ARDSBR

,@CODICEFORNITORE = Inserted.CODICEFORNITORE

,@ARTITL = Inserted.ARTITL

,@ARTPTT = Inserted.ARTPTT

,@USRYarnCategoryEquivalSingleCount = Inserted.USRYarnCategoryEquivalSingleCount

,@ARQU03 = Inserted.ARQU03

,@ARFICM = Inserted.ARFICM

,@ARINFN = Inserted.ARINFN

,@ARAPTT = Inserted.ARAPTT

,@USRBeckLoadInPounds = Inserted.USRBeckLoadInPounds

,@USRGreigeStopsCatchCord = Inserted.USRGreigeStopsCatchCord

,@USRGreigeStopsFill = Inserted.USRGreigeStopsFill

,@USRGreigeStopsLeno = Inserted.USRGreigeStopsLeno

,@USRGreigeStopsOther = Inserted.USRGreigeStopsOther

,@USRGreigeStopsWarp = Inserted.USRGreigeStopsWarp

,@USRGreigePlanningYarnStretchFactor = Inserted.USRGreigePlanningYarnStretchFactor

,@USRGreigePlanningYarnTakeupFactor = Inserted.USRGreigePlanningYarnTakeupFactor

,@USRGreigeDentsInch = Inserted.USRGreigeDentsInch

,@USRGreigePlanningStdBeamsPerSet = Inserted.USRGreigePlanningStdBeamsPerSet

,@USRGreigePlanningStdLoomBeamLen = Inserted.USRGreigePlanningStdLoomBeamLen

,@USRGreigeYarnCategoryRevision01 = Inserted.USRGreigeYarnCategoryRevision01

,@USRGreigeYarnCategoryRevision02 = Inserted.USRGreigeYarnCategoryRevision02

,@USRGreigeYarnCategoryRevision03 = Inserted.USRGreigeYarnCategoryRevision03

,@USRGreigeYarnCategoryRevision04 = Inserted.USRGreigeYarnCategoryRevision04

,@USRGreigeYarnCategoryRevision05 = Inserted.USRGreigeYarnCategoryRevision05

,@USRGreigeYarnCategoryRevision06 = Inserted.USRGreigeYarnCategoryRevision06

,@USRGreigeYarnCategoryRevision07 = Inserted.USRGreigeYarnCategoryRevision07

,@USRGreigeYarnCategoryRevision08 = Inserted.USRGreigeYarnCategoryRevision08

,@USRGreigeYarnCategoryRevision09 = Inserted.USRGreigeYarnCategoryRevision09

,@USRGreigeYarnCategoryRevision10 = Inserted.USRGreigeYarnCategoryRevision10

,@USRGreigeYarnCategoryRevision11 = Inserted.USRGreigeYarnCategoryRevision11

,@USRGreigeYarnCategoryRevision12 = Inserted.USRGreigeYarnCategoryRevision12

,@USRGreigeYarnCategoryRevision13 = Inserted.USRGreigeYarnCategoryRevision13

,@USRGreigeYarnCategoryRevision14 = Inserted.USRGreigeYarnCategoryRevision14

,@USRGreigeYarnCategoryRevision15 = Inserted.USRGreigeYarnCategoryRevision15

,@USRGreigeYarnCategoryRevision16 = Inserted.USRGreigeYarnCategoryRevision16

,@USRGreigeYarnCategoryRevision17 = Inserted.USRGreigeYarnCategoryRevision17

,@USRGreigeYarnCategoryRevision18 = Inserted.USRGreigeYarnCategoryRevision18

,@USRGreigeYarnCategoryRevision19 = Inserted.USRGreigeYarnCategoryRevision19

,@USRGreigeYarnCategoryRevision20 = Inserted.USRGreigeYarnCategoryRevision20

,@USRGreigeYarnType01 = Inserted.USRGreigeYarnType01

,@USRGreigeYarnType02 = Inserted.USRGreigeYarnType02

,@USRGreigeYarnType03 = Inserted.USRGreigeYarnType03

,@USRGreigeYarnType04 = Inserted.USRGreigeYarnType04

,@USRGreigeYarnType05 = Inserted.USRGreigeYarnType05

,@USRGreigeYarnType06 = Inserted.USRGreigeYarnType06

,@USRGreigeYarnType07 = Inserted.USRGreigeYarnType07

,@USRGreigeYarnType08 = Inserted.USRGreigeYarnType08

,@USRGreigeYarnType09 = Inserted.USRGreigeYarnType09

,@USRGreigeYarnType10 = Inserted.USRGreigeYarnType10

,@USRGreigeYarnType11 = Inserted.USRGreigeYarnType11

,@USRGreigeYarnType12 = Inserted.USRGreigeYarnType12

,@USRGreigeYarnType13 = Inserted.USRGreigeYarnType13

,@USRGreigeYarnType14 = Inserted.USRGreigeYarnType14

,@USRGreigeYarnType15 = Inserted.USRGreigeYarnType15

,@USRGreigeYarnType16 = Inserted.USRGreigeYarnType16

,@USRGreigeYarnType17 = Inserted.USRGreigeYarnType17

,@USRGreigeYarnType18 = Inserted.USRGreigeYarnType18

,@USRGreigeYarnType19 = Inserted.USRGreigeYarnType19

,@USRGreigeYarnType20 = Inserted.USRGreigeYarnType20

,@USRGreigeYarnSequence01 = Inserted.USRGreigeYarnSequence01

,@USRGreigeYarnSequence02 = Inserted.USRGreigeYarnSequence02

,@USRGreigeYarnSequence03 = Inserted.USRGreigeYarnSequence03

,@USRGreigeYarnSequence04 = Inserted.USRGreigeYarnSequence04

,@USRGreigeYarnSequence05 = Inserted.USRGreigeYarnSequence05

,@USRGreigeYarnSequence06 = Inserted.USRGreigeYarnSequence06

,@USRGreigeYarnSequence07 = Inserted.USRGreigeYarnSequence07

,@USRGreigeYarnSequence08 = Inserted.USRGreigeYarnSequence08

,@USRGreigeYarnSequence09 = Inserted.USRGreigeYarnSequence09

,@USRGreigeYarnSequence10 = Inserted.USRGreigeYarnSequence10

,@USRGreigeYarnSequence11 = Inserted.USRGreigeYarnSequence11

,@USRGreigeYarnSequence12 = Inserted.USRGreigeYarnSequence12

,@USRGreigeYarnSequence13 = Inserted.USRGreigeYarnSequence13

,@USRGreigeYarnSequence14 = Inserted.USRGreigeYarnSequence14

,@USRGreigeYarnSequence15 = Inserted.USRGreigeYarnSequence15

,@USRGreigeYarnSequence16 = Inserted.USRGreigeYarnSequence16

,@USRGreigeYarnSequence17 = Inserted.USRGreigeYarnSequence17

,@USRGreigeYarnSequence18 = Inserted.USRGreigeYarnSequence18

,@USRGreigeYarnSequence19 = Inserted.USRGreigeYarnSequence19

,@USRGreigeYarnSequence20 = Inserted.USRGreigeYarnSequence20

,@USRGreigeYarnEndsPicks01 = Inserted.USRGreigeYarnEndsPicks01

,@USRGreigeYarnEndsPicks02 = Inserted.USRGreigeYarnEndsPicks02

,@USRGreigeYarnEndsPicks03 = Inserted.USRGreigeYarnEndsPicks03

,@USRGreigeYarnEndsPicks04 = Inserted.USRGreigeYarnEndsPicks04

,@USRGreigeYarnEndsPicks05 = Inserted.USRGreigeYarnEndsPicks05

,@USRGreigeYarnEndsPicks06 = Inserted.USRGreigeYarnEndsPicks06

,@USRGreigeYarnEndsPicks07 = Inserted.USRGreigeYarnEndsPicks07

,@USRGreigeYarnEndsPicks08 = Inserted.USRGreigeYarnEndsPicks08

,@USRGreigeYarnEndsPicks09 = Inserted.USRGreigeYarnEndsPicks09

,@USRGreigeYarnEndsPicks10 = Inserted.USRGreigeYarnEndsPicks10

,@USRGreigeYarnEndsPicks11 = Inserted.USRGreigeYarnEndsPicks11

,@USRGreigeYarnEndsPicks12 = Inserted.USRGreigeYarnEndsPicks12

,@USRGreigeYarnEndsPicks13 = Inserted.USRGreigeYarnEndsPicks13

,@USRGreigeYarnEndsPicks14 = Inserted.USRGreigeYarnEndsPicks14

,@USRGreigeYarnEndsPicks15 = Inserted.USRGreigeYarnEndsPicks15

,@USRGreigeYarnEndsPicks16 = Inserted.USRGreigeYarnEndsPicks16

,@USRGreigeYarnEndsPicks17 = Inserted.USRGreigeYarnEndsPicks17

,@USRGreigeYarnEndsPicks18 = Inserted.USRGreigeYarnEndsPicks18

,@USRGreigeYarnEndsPicks19 = Inserted.USRGreigeYarnEndsPicks19

,@USRGreigeYarnEndsPicks20 = Inserted.USRGreigeYarnEndsPicks20

,@USRGreigeBoiloffBeforePicks = Inserted.USRGreigeBoiloffBeforePicks

,@USRGreigeBoiloffBeforeWidth = Inserted.USRGreigeBoiloffBeforeWidth

,@USRGreigeBoiloffAfterPicks = Inserted.USRGreigeBoiloffAfterPicks

,@USRGreigeBoiloffAfterWidth = Inserted.USRGreigeBoiloffAfterWidth

,@USRGreigeLoomBeamStyleRevision = Inserted.USRGreigeLoomBeamStyleRevision

,@USRCalculatedYardsToWeave = Inserted.USRCalculatedYardsToWeave

,@USRExperWeaveReqSampleBeckYds = Inserted.USRExperWeaveReqSampleBeckYds

,@USRGreigeExperWeaveRequestStatus = Inserted.USRGreigeExperWeaveRequestStatus

,@USRPreparationYards = Inserted.USRPreparationYards

,@USRRequestedCutsToWeave = Inserted.USRRequestedCutsToWeave

,@USRRequestedYardsToWeave = Inserted.USRRequestedYardsToWeave

,@USRYardsForLab = Inserted.USRYardsForLab

,@USRExperWeaveReqActualDateDrawReady = Inserted.USRExperWeaveReqActualDateDrawReady

,@USRExperWeaveReqActualDateFill = Inserted.USRExperWeaveReqActualDateFill

,@USRExperWeaveReqActualDateInLoom = Inserted.USRExperWeaveReqActualDateInLoom

,@USRExperWeaveReqActualDateOutOfLoom = Inserted.USRExperWeaveReqActualDateOutOfLoom

,@USRExperWeaveReqActualDateShipFirst = Inserted.USRExperWeaveReqActualDateShipFirst

,@USRExperWeaveReqActualDateSlashReady = Inserted.USRExperWeaveReqActualDateSlashReady

,@USRExperWeaveReqActualDateWarp = Inserted.USRExperWeaveReqActualDateWarp

,@USRExperWeaveReqActualDateWarpReady = Inserted.USRExperWeaveReqActualDateWarpReady

,@USRExperWeaveReqScheDateDrawReady = Inserted.USRExperWeaveReqScheDateDrawReady

,@USRExperWeaveReqScheDateFill = Inserted.USRExperWeaveReqScheDateFill

,@USRExperWeaveReqScheDateInLoom = Inserted.USRExperWeaveReqScheDateInLoom

,@USRExperWeaveReqScheDateOutOfLoom = Inserted.USRExperWeaveReqScheDateOutOfLoom

,@USRExperWeaveReqScheDateShipFirst = Inserted.USRExperWeaveReqScheDateShipFirst

,@USRExperWeaveReqScheDateSlashReady = Inserted.USRExperWeaveReqScheDateSlashReady

,@USRExperWeaveReqScheDateWarp = Inserted.USRExperWeaveReqScheDateWarp

,@USRExperWeaveReqScheDateWarpReady = Inserted.USRExperWeaveReqScheDateWarpReady

,@ARCOMP = inserted.ARCOMP

,@CODICELINEA = inserted.CODICELINEA

,@TIPOPRODOTTO = inserted.TIPOPRODOTTO

,@ARFLO2 = Inserted.ARFLO2

,@USRPieceDyeStockDye = Inserted.USRPieceDyeStockDye

,@ARGGCC = Inserted.ARGGCC

,@USRFinishPlanningFactorsTotal = Inserted.USRFinishPlanningFactorsTotal

,@USRGreigePlanningYarnNetFactor = Inserted.USRGreigePlanningYarnNetFactor

,@USRGreigePlanningYarnFillWasteFactor = Inserted.USRGreigePlanningYarnFillWasteFactor

,@CODICEDIVISIONE = Inserted.CODICEDIVISIONE

,@ARFL06 = Inserted.ARFL06

,@USRAutoCreateML60BOMFlag = Inserted.USRAutoCreateML60BOMFlag

,@Yarn01Ply = Inserted.USRYarnProcessedSinglePlys01

,@Yarn02Ply = Inserted.USRYarnProcessedSinglePlys02

,@Yarn03Ply = Inserted.USRYarnProcessedSinglePlys03

,@Yarn04Ply = Inserted.USRYarnProcessedSinglePlys04

,@Yarn05Ply = Inserted.USRYarnProcessedSinglePlys05

,@Yarn06Ply = Inserted.USRYarnProcessedSinglePlys06

,@ARNRLI = Inserted.ARNRLI

,@StdNbrSectionBeams = Inserted.USRGreigePlanningStdNbrOfSectionBeams

,@USRWarpStyleGroup = Inserted.USRWarpStyleGroup

,@USRFinishPlanningShrinkageLoss = Inserted.USRFinishPlanningShrinkageLoss

,@USRFinishPlanningWorkingLoss = Inserted.USRFinishPlanningWorkingLoss

,@USRFinishPlanningSecondsPercentage = Inserted.USRFinishPlanningSecondsPercentage

,@USRGreigePlanningGreigeSecondsPercentage = Inserted.USRGreigePlanningGreigeSecondsPercentage

,@USRGreigeCutLength = Inserted.USRGreigeCutLength

,@USRYarnDescription = Inserted.USRYarnDescription

,@ARDSTD = Inserted.ARDSTD

,@USRControlStyleDescription = Inserted.USRControlStyleDescription

,@ARFG10 = Inserted.ARFG10

,@USRControlStyle = Inserted.USRControlStyle

,@USRCreationDate = Inserted.USRCreationDate

,@USRYarnCategoryTubeColorCode = Inserted.USRYarnCategoryTubeColorCode

-- 30-Dec-2005 MtC

,@USRTrialDate = Inserted.USRTrialDate

-- 04-Jan-2006 MtC

,@USRFinishEvaluationTempHandStandard = Inserted.USRFinishEvaluationTempHandStandard

,@USRFinishEvaluationFormulaCode = Inserted.USRFinishEvaluationFormulaCode

,@ARINCM = Inserted.ARINCM

-- 09-Jan-2006

,@ARFL07 = Inserted.ARFL07

-- 12-Jan-2006 MtC

,@ARPTTN = Inserted.ARPTTN

-- 16-Jan-2006 MtC

,@USRCutsBatchRoll = Inserted.USRCutsBatchRoll

-- 24-Jan-2006 MDP

,@ARFU10 = Inserted.ARFU10

-- 26-Jan-2006 MtC

,@USRGreigeAirspacePercent = Inserted.USRGreigeAirspacePercent

,@USRControlStyleEstDate = Inserted.USRControlStyleEstDate

-- 10-Feb-2006 MDP

,@USRFTOriginationDate = Inserted.USRFinishTrailOriginationDate

From Inserted

-- If doing an Insert or Copy (which is an insert) bypass the checks for locks, mandatory columns and operator checks.

--

If Update (Mlivarticolo) or Update(Codicecomponente)

GOTO Process

-- If CDS is locking or unlocking the record then do not update.

--

If Update (ID_USER_LOCK_PRODUCT)

GoTo Exit_Trigger

-- If CDS is checking for mandatory fields to be exported to GTEX then do not update.

--

If Update (STATUSXHOST)

GoTo Exit_Trigger

-- If CDS is updating mandatory fields with default values then do not update.

--

If Update (ARALIV) -- Sales Tax Type

GoTo Exit_Trigger

-- If CDS is updating the Operator with the current User ID then don't update.

--

--If Update(OPERATORE)

--GoTo Exit_Trigger

Process:

-- 10-Feb-2006 MDP

-- If Division is not entered then set default for Division as 'BA' for all MacroLevels

--

If @CODICEDIVISIONE is Null or @CODICEDIVISIONE = ''

Set @CODICEDIVISIONE = 'BA'

-- Check Macro Level, Mlivarticolo, to determine processing needs.

--

IF @Mlivarticolo = '80' -- Purchased Yarns

GoTo Process_ML80

Else IF @Mlivarticolo = '70' -- Spun Yarns

GoTo Process_ML70

Else IF @Mlivarticolo = '60' -- Processed Synthetic Yarns

GoTo Process_ML60

Else IF @Mlivarticolo = '30' -- Loom Beams

GoTo Process_ML30

Else IF @Mlivarticolo = '20' -- Greige Style

GoTo Process_ML20

Else IF @Mlivarticolo = 'GT' -- Greige Trial

GoTo Process_MLGT

Else IF @Mlivarticolo = '2M' -- Control Style

GoTo Process_ML2M

Else IF @Mlivarticolo = '10' -- Finish Style

GoTo Process_ML10

Else IF @Mlivarticolo = 'FT' -- Finish Trial

GoTo Process_MLFT

Else

GoTo Exit_Trigger

-----------------------------------------------------------------------------------------------------

Process_ML80: -- Purchased Yarns

-- Perform calculations and data moves for ML 80, Purchased Yarns.

-- Set short description to be equal to the first 15 characters of USRYarnDescription.

-- Set extended description equal to the first 35 characters of the USRYarnDescription.

--

Set @Descrizionecomponente = SUBSTRING (@USRYarnDescription, 1, 35)

Set @ARDSBR = SUBSTRING (@USRYarnDescription, 1, 15)

-- If the manufacture/purchase flag is null then set to 'P'.

--

Select @ARTPPD = USRVendorTable.USRVendorMakeBuyIndicator

From USRVendorTable

Where USRVendorTable.CODICEFORNITORE = @CODICEFORNITORE

If @ARTPPD is Null or @ARTPPD = ''

Set @ARTPPD = 'P'

-- If actual denier is greater than 0 the calculate Standard yards/pound.

--

--If @ARTITL > 0

-- Set @ARMDMN = ROUND (4464600 / @ARTITL, 0)

--Else

-- Set @ARMDMN = 0

If @ARTITL > 0

Set @USRYarnCategoryStandardYdsLb = ROUND (4464600 / @ARTITL, 0)

Else

Set @USRYarnCategoryStandardYdsLb = 0

--If Creation Date is null then set to the current system date.

--

If @USRCreationDate is Null or @USRCreationDate = ''

Set @USRCreationDate = CONVERT(CHAR(12), GETDATE(), 101)

-- If Established Date is null then set to the current system date.

--

If @USRYarnCategoryEstablishedDate is Null or @USRYarnCategoryEstablishedDate = ''

Set @USRYarnCategoryEstablishedDate = CONVERT(CHAR(12), GETDATE(), 101)

-- If doing an Insert or Copy (which is an insert) for ML 80,

-- then check to see if the Yarn Revision entered by the user already exist in the USRGreigeYarnCategoryRevisionTable.

--

If Update (Mlivarticolo) or Update(Codicecomponente)

Begin

-- Check to see if the Yarn Revision entered by the user already exist in the USRGreigeYarnCategoryRevisionTable.

--

If Exists (Select 'Check to see if the yarn revision entered for ML 80 already exist in table USRGreigeYarnCategoryRevisionTable'

From USRGreigeYarnCategoryRevisionTable

Where SUBSTRING (USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevision, 8, 10) =

SUBSTRING (@Codicecomponente, 8, 10)

And SUBSTRING (@Codicecomponente, 8, 10) <> '0000000000'

&nbsp

Begin

RAISERROR ('A duplicate yarn revision was found and a rollback of this transaction will occur.', 11, 1)

ROLLBACK TRANSACTION

GoTo Exit_Trigger

End

Else

-- If a unique Yarn Revision was entered, insert an entry in the USRGreigeYarnCategoryRevisionTable

-- using data from the CMSARTICOLI table for ML 80.

--

Begin

Insert Into USRGreigeYarnCategoryRevisionTable

(USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevision

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionActive

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionApprCode

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionCountryOfOrigin

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionDesc

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionDyeCode

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionStdYdslb

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionEstDate

&nbsp

Select @Codicecomponente

,@USRYarnCategoryActive

,@ARFG02

,@USRCntryOfOrgCode

,@USRYarnDescription

,@USRYarnCategoryDyeCode

,@USRYarnCategoryStandardYdsLb

,@USRYarnCategoryEstablishedDate

From CMSARTICOLI

Where CMSARTICOLI.Mlivarticolo = @Mlivarticolo

and

CMSARTICOLI.Codicecomponente = @Codicecomponente

GoTo Skip_ML80_USRGreigeYarnCategoryRevisionTable_Update

End

-- If the user is modifying a row for ML 80 then perform an update.

--

Update USRGreigeYarnCategoryRevisionTable

Set USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevision = @Codicecomponente

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionActive = @USRYarnCategoryActive

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionApprCode = @ARFG02

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionCountryOfOrigin = @USRCntryOfOrgCode

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionDesc = @USRYarnDescription

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionDyeCode = @USRYarnCategoryDyeCode

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionStdYdslb = @USRYarnCategoryStandardYdsLb

,USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevisionEstDate = @USRYarnCategoryEstablishedDate

Where USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevision = @Codicecomponente

Skip_ML80_USRGreigeYarnCategoryRevisionTable_Update:

Update CMSARTICOLI

Set CMSARTICOLI.ARDSBR = @ARDSBR,

CMSARTICOLI.Descrizionecomponente = @Descrizionecomponente,

CMSARTICOLI.ARTPPD = @ARTPPD,

CMSARTICOLI.USRYarnCategoryStandardYdsLb = @USRYarnCategoryStandardYdsLb,

CMSARTICOLI.USRCreationDate = @USRCreationDate,

CMSARTICOLI.USRYarnCategoryEstablishedDate = @USRYarnCategoryEstablishedDate,

CMSARTICOLI.UM = 'LB'

,CMSARTICOLI.ARCDLV = 800

,CMSARTICOLI.USERCRT = @UpdateUserID

-- 10-Feb-2006 MDP

,CMSARTICOLI.CODICEDIVISIONE = @CODICEDIVISIONE

-- Defaults

,ARALIV = 'NO'

,ARDCLS = 'N'

,ARDISP = 'Y'

,ARESCL = 'N'

,ARFLBC = 'N'

,ARRGLO = 'D'

,ARRGMG = '1'

,ARTPGS = 'P'

,ARTPTT = 'TD'

Where CMSARTICOLI.Mlivarticolo = @Mlivarticolo

and

CMSARTICOLI.Codicecomponente = @Codicecomponente

Set @Numeric_YYMMDD = convert (varchar, @USRYarnCategoryEstablishedDate, 12)

-- Update the needed data in the INFAG00F table if the record already exist.

--

Update INFAG00F

Set INFAG00F.IGTPDC = 'AR'

,INFAG00F.IGCDEL = @Mlivarticolo+@Codicecomponente

,INFAG00F.IGCDP1 = ''

,INFAG00F.IGCDP2 = ''

,INFAG00F.IGTPFM = 'LAI'

,INFAG00F.IGCODB = @Numeric_YYMMDD

Where INFAG00F.IGCDEL = @Mlivarticolo+@Codicecomponente

-- Insert needed data into the INFAG00F table if the record does not exist.

--

Insert Into INFAG00F

(IGTPDC -- always equal to 'AR'

,IGCDEL -- 'ML' + 'Code of the Componente'

,IGCDP1 -- always equal to blank

,IGCDP2 -- always equal to blank

,IGTPFM -- always equal to 'LAI'

,IGCODB -- Established Date of the Componente

&nbsp

Select 'AR'

,MLIVARTICOLO + CODICECOMPONENTE

,''

,'LAI'

,@Numeric_YYMMDD

From CMSARTICOLI

Where CMSARTICOLI.Mlivarticolo = @Mlivarticolo

and

CMSARTICOLI.Codicecomponente = @Codicecomponente

and not exists

(Select ''

From INFAG00F

Where INFAG00F.IGCDEL = @Mlivarticolo+@Codicecomponente

&nbsp

GoTo Exit_Trigger

-----------------------------------------------------------------------------------------------------

Process_ML70: -- Spun Yarns

-- Perform calculations and data moves for ML 70, Purchased Yarns.

-- Set short description to be equal to the first 15 characters of USRYarnDescription.

-- Set extended description equal to the first 35 characters of the USRYarnDescription.

--

Set @Descrizionecomponente = SUBSTRING (@USRYarnDescription, 1, 35)

Set @ARDSBR = SUBSTRING (@USRYarnDescription, 1, 15)

-- If the manufacture/purchase flag is null then set to 'P'.

--

Select @ARTPPD = USRVendorTable.USRVendorMakeBuyIndicator

From USRVendorTable

Where USRVendorTable.CODICEFORNITORE = @CODICEFORNITORE

If @ARTPPD is Null or @ARTPPD = ''

Set @ARTPPD = 'P'

-- Select Yarn Count Unit Equivalence Factor based on the Yarn Count Unit.

-- If Equival Single Count is greater than 0 the calculate Standard yards/pound.

--

Select @USRYarnCategoryYarnCountUnitEquivalFactor = USRYarnCategoryYarnCountUnitTable.USRYarnCategoryYarnCountUnitEquivalFactor

From USRYarnCategoryYarnCountUnitTable

Where USRYarnCategoryYarnCountUnitTable.ARTPTT = @ARTPTT

If @USRYarnCategoryEquivalSingleCount > 0

Set @USRYarnCategoryStandardYdsLb = ROUND (@USRYarnCategoryYarnCountUnitEquivalFactor * @USRYarnCategoryEquivalSingleCount, 0)

Else

Set @USRYarnCategoryStandardYdsLb = 0

--If Creation Date is null then set to the current system date.

--

If @USRCreationDate is Null or @USRCreationDate = ''

Set @USRCreationDate = CONVERT(CHAR(12), GETDATE(), 101)

-- If Established Date is null then set to the current system date.

--

If @USRYarnCategoryEstablishedDate is Null or @USRYarnCategoryEstablishedDate = ''

Set @USRYarnCategoryEstablishedDate = CONVERT(CHAR(12), GETDATE(), 101)

-- If doing an Insert or Copy (which is an insert) for ML 70,

-- then check to see if the Yarn Revision entered by the user already exist in the USRGreigeYarnCategoryRevisionTable.

--

If Update (Mlivarticolo) or Update(Codicecomponente)

Begin

-- Check to see if the Yarn Revision entered by the user already exist in the USRGreigeYarnCategoryRevisionTable.

--

If Exists (Select 'Check to see if the yarn revision entered for ML 70 already exist in table USRGreigeYarnCategoryRevisionTable'

From USRGreigeYarnCategoryRevisionTable

Where SUBSTRING (USRGreigeYarnCategoryRevisionTable.USRGreigeYarnCategoryRevision, 8, 10) =

SUBSTRING (@Codicecomponente, 8, 10)

And SUBSTRING (@Codicecomponente, 8, 10) <> '0000000000'

&nbsp

Begin

RAISERROR ('A duplicate yarn revision was found and a rollback of this transaction will occur.', 11, 1)

ROLLBACK TRANSACTION

GoTo Exit_Trigger

End

Else

-- If a unique Yarn Revision was entered, insert an entry in the USRGreigeYarnCategoryRevisionTable

-- using data from the CMSARTICOLI table for ML 70.