Q35UpdateWorkOrderConditional

Cantara Business Function to update a Work Order and conditionally only updates specific fields. Fields to be updated are preceded in the input data structure with a flag which indicates if that field is to be updated.

Oracle Doc: Setting Processing Options for the Work Order Revisions Program (P17714) (oracle.com)

Explanation: Enter a ‘1’ in the appropriate “EV01_UseProvided__” parameter to update that field on the work order.

Calls

This function calls the following Q35 functions.

Data Structure

Name	Type	Inclusion	Direction
DOCO_mnOrderNumber	INTEGER	OPTIONAL	IN
VERS_szP17714Version	STRING	OPTIONAL	BOTH
EV01_cReserveObject	CHARACTER	OPTIONAL	IN
EV01_cSuppressErrors	CHARACTER	OPTIONAL	IN
DTAI_szErrorMessages	ERRORALIAS	OPTIONAL	OUT
EV01_cUseProvidedACDN	CHARACTER	OPTIONAL	BOTH
ACDN_mnActualDowntimeHours	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedAMLC	CHARACTER	OPTIONAL	BOTH
AMLC_mnEstimatedLaborAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedAMMC	CHARACTER	OPTIONAL	BOTH
AMMC_mnEstimatedMaterialAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedAMOT	CHARACTER	OPTIONAL	BOTH
AMOT_mnEstimatedOtherAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedAMTC	CHARACTER	OPTIONAL	BOTH
AMTC_mnChargeToOriginalAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedAN8	CHARACTER	OPTIONAL	BOTH
AN8_mnCustomerNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedANO	CHARACTER	OPTIONAL	BOTH
ANO_mnOriginatorNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedANP	CHARACTER	OPTIONAL	BOTH
ANP_mnAssignedToAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedANPA	CHARACTER	OPTIONAL	BOTH
ANPA_mnSupervisor	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedANSA	CHARACTER	OPTIONAL	BOTH
ANSA_mnManager	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedANT	CHARACTER	OPTIONAL	BOTH
ANT_mnInspectorNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedAPRT	CHARACTER	OPTIONAL	BOTH
APRT_szApprovalType	STRING	OPTIONAL	BOTH
EV01_cUseProvidedAR1	CHARACTER	OPTIONAL	BOTH
AR1_szPhoneAreaCode1	STRING	OPTIONAL	BOTH
EV01_cUseProvidedCOVGR	CHARACTER	OPTIONAL	BOTH
COVGR_szCoverageGroup	STRING	OPTIONAL	BOTH
EV01_cUseProvidedCRCD	CHARACTER	OPTIONAL	BOTH
CRCD_szCurrencyCodeFrom	UDC	OPTIONAL	BOTH
EV01_cUseProvidedCRDC	CHARACTER	OPTIONAL	BOTH
CRDC_szCurrencyCodeTo	UDC	OPTIONAL	BOTH
EV01_cUseProvidedCRR	CHARACTER	OPTIONAL	BOTH
CRR_mnCurrencyConverRateOv	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedCRRM	CHARACTER	OPTIONAL	BOTH
CRRM_cCurrencyMode	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedCTR	CHARACTER	OPTIONAL	BOTH
CTR_szCountry	STRING	OPTIONAL	BOTH
EV01_cUseProvidedDCTO	CHARACTER	OPTIONAL	BOTH
DCTO_szOrderType	UDC	OPTIONAL	BOTH
EV01_cUseProvidedDL01	CHARACTER	OPTIONAL	BOTH
DL01_szWODescription	STRING	OPTIONAL	BOTH
EV01_cUseProvidedDOC	CHARACTER	OPTIONAL	BOTH
DOC_mnDocVoucherInvoiceE	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedDPL	CHARACTER	OPTIONAL	BOTH
DPL_jdPlannedCompletionDate	DATE	OPTIONAL	BOTH
EV01_cUseProvidedDRQJ	CHARACTER	OPTIONAL	BOTH
DRQJ_jdRequestedDate	DATE	OPTIONAL	BOTH
EV01_cUseProvidedDUAL	CHARACTER	OPTIONAL	BOTH
DUAL_cDualUnitOfMeasureItem	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedENTCK	CHARACTER	OPTIONAL	BOTH
ENTCK_szEntitlementCheck	STRING	OPTIONAL	BOTH
EV01_cUseProvidedESDN	CHARACTER	OPTIONAL	BOTH
ESDN_mnEstimatedDowntimeHours	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedEXR1	CHARACTER	OPTIONAL	BOTH
EXR1_szTaxExplanationCode1	STRING	OPTIONAL	BOTH
EV01_cUseProvidedGLCCV	CHARACTER	OPTIONAL	BOTH
GLCCV_szGLCategoryCovered	STRING	OPTIONAL	BOTH
EV01_cUseProvidedGLCNC	CHARACTER	OPTIONAL	BOTH
GLCNC_szGLCategoryNonCovered	STRING	OPTIONAL	BOTH
EV01_cUseProvidedHRSA	CHARACTER	OPTIONAL	BOTH
HRSA_mnHoursActual	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedHRSO	CHARACTER	OPTIONAL	BOTH
HRSO_mnEstimatedHours	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedISSUE	CHARACTER	OPTIONAL	BOTH
ISSUE_szISSUE	STRING	OPTIONAL	BOTH
EV01_cUseProvidedITM	CHARACTER	OPTIONAL	BOTH
ITM_mnShortItemNumber	SHORTITEM	OPTIONAL	BOTH
EV01_cUseProvidedLBAM	CHARACTER	OPTIONAL	BOTH
LBAM_mnActualLaborAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedLNGP	CHARACTER	OPTIONAL	BOTH
LNGP_szLanguagePreference	STRING	OPTIONAL	BOTH
EV01_cUseProvidedLOCN	CHARACTER	OPTIONAL	BOTH
LOCN_szLocation	LOCATION	OPTIONAL	BOTH
EV01_cUseProvidedLOTN	CHARACTER	OPTIONAL	BOTH
LOTN_szLotNumber	STRING	OPTIONAL	BOTH
EV01_cUseProvidedMCU	CHARACTER	OPTIONAL	BOTH
MCU_szBusinessUnit	BUSINESSUNIT	OPTIONAL	BOTH
EV01_cUseProvidedMCULT	CHARACTER	OPTIONAL	BOTH
MCULT_szWorkCenterLeadCraft	BUSINESSUNIT	OPTIONAL	BOTH
EV01_cUseProvidedMMCU	CHARACTER	OPTIONAL	BOTH
MMCU_szBranchPlant	BUSINESSUNIT	OPTIONAL	BOTH
EV01_cUseProvidedMTAM	CHARACTER	OPTIONAL	BOTH
MTAM_mnActualMaterialAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedMTHPR	CHARACTER	OPTIONAL	BOTH
MTHPR_cMethodofPricing	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedNAN8	CHARACTER	OPTIONAL	BOTH
NAN8_mnNextAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedNUMB	CHARACTER	OPTIONAL	BOTH
NUMB_mnAssetNumber	ASETNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedOTAM	CHARACTER	OPTIONAL	BOTH
OTAM_mnAmountActualOther	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedPARS	CHARACTER	OPTIONAL	BOTH
PARS_szParentOrderNumber	STRING	OPTIONAL	BOTH
EV01_cUseProvidedPC	CHARACTER	OPTIONAL	BOTH
PC_mnPercentComplete	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedPHN1	CHARACTER	OPTIONAL	BOTH
PHN1_szPhoneNumberOne	STRING	OPTIONAL	BOTH
EV01_cUseProvidedPRODF	CHARACTER	OPTIONAL	BOTH
PRODF_szProductFamily	STRING	OPTIONAL	BOTH
EV01_cUseProvidedPRODM	CHARACTER	OPTIONAL	BOTH
PRODM_szProductModel	STRING	OPTIONAL	BOTH
EV01_cUseProvidedPRTS	CHARACTER	OPTIONAL	BOTH
PRTS_cWOPriority	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedPTWO	CHARACTER	OPTIONAL	BOTH
PTWO_mnPegToWorkOrder	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedQTYT	CHARACTER	OPTIONAL	BOTH
QTYT_mnQuantityShippedToDate	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedREGION	CHARACTER	OPTIONAL	BOTH
REGION_szGeographicRegion	STRING	OPTIONAL	BOTH
EV01_cUseProvidedRSTM	CHARACTER	OPTIONAL	BOTH
RSTM_mnResponseTime	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedRYIN	CHARACTER	OPTIONAL	BOTH
RYIN_cPaymentInstrumentA	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedSAID	CHARACTER	OPTIONAL	BOTH
SAID_mnServiceAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
EV01_cUseProvidedSBLI	CHARACTER	OPTIONAL	BOTH
SBLI_cSubledgerInactiveCode	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedSEET	CHARACTER	OPTIONAL	BOTH
SEET_mnRequestedFinishTime	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedSEQN	CHARACTER	OPTIONAL	BOTH
SEQN_mnSequenceNumber2	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSEST	CHARACTER	OPTIONAL	BOTH
SEST_mnTimeScheduledStart	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedSHFT	CHARACTER	OPTIONAL	BOTH
SHFT_cShiftCode	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedSHNO	CHARACTER	OPTIONAL	BOTH
SHNO_szMessageNumber	STRING	OPTIONAL	BOTH
EV01_cUseProvidedSOBK	CHARACTER	OPTIONAL	BOTH
SOBK_mnUnitsQuanBackorHeld	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSOCN	CHARACTER	OPTIONAL	BOTH
SOCN_mnUnitsQuantityCanceled	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSOQS	CHARACTER	OPTIONAL	BOTH
SOQS_mnUnitsQuantityShipped	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSPRT	CHARACTER	OPTIONAL	BOTH
SPRT_cFlashMessage	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedSQOR	CHARACTER	OPTIONAL	BOTH
SQOR_mnUnitsSecondaryQtyOr	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSRST	CHARACTER	OPTIONAL	BOTH
SRST_szWOStatus	STRING	OPTIONAL	BOTH
EV01_cUseProvidedSRYN	CHARACTER	OPTIONAL	BOTH
SRYN_cEligibleSupplierRecovery	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedSSOQ	CHARACTER	OPTIONAL	BOTH
SSOQ_mnSecondaryQtyCompleted	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedSTCM	CHARACTER	OPTIONAL	BOTH
STCM_szStatusComment	STRING	OPTIONAL	BOTH
EV01_cUseProvidedSTRT	CHARACTER	OPTIONAL	BOTH
STRT_jdStartDate	DATE	OPTIONAL	BOTH
EV01_cUseProvidedSTRX	CHARACTER	OPTIONAL	BOTH
STRX_jdCompletionDate	DATE	OPTIONAL	BOTH
EV01_cUseProvidedSUB	CHARACTER	OPTIONAL	BOTH
SUB_szSubsidiary	STRING	OPTIONAL	BOTH
EV01_cUseProvidedTBM	CHARACTER	OPTIONAL	BOTH
TBM_szTypeOfBill	STRING	OPTIONAL	BOTH
EV01_cUseProvidedTIMEZONES	CHARACTER	OPTIONAL	BOTH
TIMEZONES_szTimeZoes	STRING	OPTIONAL	BOTH
EV01_cUseProvidedTMCO	CHARACTER	OPTIONAL	BOTH
TMCO_mnTimeCompleted	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedTRDJ	CHARACTER	OPTIONAL	BOTH
TRDJ_jdDateTransactionJulian	DATE	OPTIONAL	BOTH
EV01_cUseProvidedTRT	CHARACTER	OPTIONAL	BOTH
TRT_szTypeOfRouting	STRING	OPTIONAL	BOTH
EV01_cUseProvidedTXA1	CHARACTER	OPTIONAL	BOTH
TXA1_szTaxArea1	STRING	OPTIONAL	BOTH
EV01_cUseProvidedTYPS	CHARACTER	OPTIONAL	BOTH
TYPS_cWOType	CHARACTER	OPTIONAL	BOTH
EV01_cUseProvidedUOM	CHARACTER	OPTIONAL	BOTH
UOM_szUnitOfMeasure	STRING	OPTIONAL	BOTH
EV01_cUseProvidedUOM2	CHARACTER	OPTIONAL	BOTH
UOM2_szUnitOfMeasureSecondary	STRING	OPTIONAL	BOTH
EV01_cUseProvidedUORG	CHARACTER	OPTIONAL	BOTH
UORG_mnQtyOrdered	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedVR01	CHARACTER	OPTIONAL	BOTH
VR01_szReference	STRING	OPTIONAL	BOTH
EV01_cUseProvidedVR02	CHARACTER	OPTIONAL	BOTH
VR02_szReference2	STRING	OPTIONAL	BOTH
EV01_cUseProvidedWHO2	CHARACTER	OPTIONAL	BOTH
WHO2_szContactName2	STRING	OPTIONAL	BOTH
EV01_cUseProvidedWR01	CHARACTER	OPTIONAL	BOTH
WR01_szWOCategoryCode001	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR02	CHARACTER	OPTIONAL	BOTH
WR02_szWOCategoryCode002	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR03	CHARACTER	OPTIONAL	BOTH
WR03_szWOCategoryCode003	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR04	CHARACTER	OPTIONAL	BOTH
WR04_szWOCategoryCode004	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR05	CHARACTER	OPTIONAL	BOTH
WR05_szWOCategoryCode005	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR06	CHARACTER	OPTIONAL	BOTH
WR06_szWOCategoryCode006	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR07	CHARACTER	OPTIONAL	BOTH
WR07_szWOCategoryCode007	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR08	CHARACTER	OPTIONAL	BOTH
WR08_szWOCategoryCode008	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR09	CHARACTER	OPTIONAL	BOTH
WR09_szWOCategoryCode009	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR10	CHARACTER	OPTIONAL	BOTH
WR10_szWOCategoryCode010	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR11	CHARACTER	OPTIONAL	BOTH
WR11_szECOworkbenchselections	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR12	CHARACTER	OPTIONAL	BOTH
WR12_szCategoriesWorkOrder12	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR13	CHARACTER	OPTIONAL	BOTH
WR13_szCategoriesWorkOrder13	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR14	CHARACTER	OPTIONAL	BOTH
WR14_szCategoriesWorkOrder14	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR15	CHARACTER	OPTIONAL	BOTH
WR15_szCategoriesWorkOrder15	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR16	CHARACTER	OPTIONAL	BOTH
WR16_szCategoriesWorkOrder16	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR17	CHARACTER	OPTIONAL	BOTH
WR17_szCategoriesWorkOrder17	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR18	CHARACTER	OPTIONAL	BOTH
WR18_szCategoriesWorkOrder18	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR19	CHARACTER	OPTIONAL	BOTH
WR19_szCategoriesWorkOrder19	UDC	OPTIONAL	BOTH
EV01_cUseProvidedWR20	CHARACTER	OPTIONAL	BOTH
WR20_szCategoriesWorkOrder20	UDC	OPTIONAL	BOTH
EV01_cUseProvidedPBTM	CHARACTER	OPTIONAL	BOTH
PBTM_mnPlannedFinishTime	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedSETC	CHARACTER	OPTIONAL	BOTH
SETC_mnCrewSize	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedURCD	CHARACTER	OPTIONAL	BOTH
URCD_szUserReservedCode	STRING	OPTIONAL	BOTH
EV01_cUseProvidedURDT	CHARACTER	OPTIONAL	BOTH
URDT_jdUserReservedDate	DATE	OPTIONAL	BOTH
EV01_cUseProvidedURAT	CHARACTER	OPTIONAL	BOTH
URAT_mnUserReservedAmount	FLOAT	OPTIONAL	BOTH
EV01_cUseProvidedURAB	CHARACTER	OPTIONAL	BOTH
URAB_mnUserReservedNumber	INTEGER	OPTIONAL	BOTH
EV01_cUseProvidedURRF	CHARACTER	OPTIONAL	BOTH
URRF_szUserReservedReference	STRING	OPTIONAL	BOTH