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 | Parameter Notes |
---|---|---|---|---|
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 |