Q35WorkOrderMasterService

Cantara Business function providing a Master Service to create, copy, and update Work Orders as if you were using the standard JDE Application P17714.

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

This function should never be called directly. It is recommended to use the one of the below provided wrapper functions to manipulate the work order data as each wrapper function will handle the validation required for that scenario.

For example, using the Q35UpdateWorkOrderDates function will set the default dates if any date values are blank and will recalculate the planned completion date if required.

If no wrapper function is suitable for your requirements, then you can use the Q35UpdateWorkOrderFull function.

Calls

This function calls the following Q35 functions:

Called By

This function is called by the following Q35 functions:

Data Structure

Name	Type	Inclusion	Direction	Parameter Notes
EV01_cSuppressErrors	CHARACTER	OPTIONAL	IN
DTAI_szErrorMessageDataItem	ERRORALIAS	OPTIONAL	OUT
BEGT_mnStatusUpdateBeginTime	INTEGER	OPTIONAL	IN
EFTB_jdStatusUpdateBeginDate	DATE	OPTIONAL	IN
RMK_szStatusUpdateRemark	STRING	OPTIONAL	IN
VERS_szP17714Version	STRING	OPTIONAL	IN	Will default to “ZJDE0001” if blank
DOCO_mnOrderNumber	INTEGER	OPTIONAL	BOTH	Blank = Add mode W.O.#: = Update mode
DCTO_szOrderType	UDC	OPTIONAL	BOTH
PTWO_mnPegToWorkOrder	INTEGER	OPTIONAL	BOTH
PARS_szParentOrderNumber	STRING	OPTIONAL	BOTH
TYPS_cWOType	UDC	OPTIONAL	BOTH	Will default to P17714 version’s PO if blank
PRTS_cWOPriority	UDC	OPTIONAL	BOTH	UDC 00\|PR
DL01_szWODescription	STRING	OPTIONAL	BOTH
STCM_szStatusComment	STRING	OPTIONAL	BOTH
MCU_szBusinessUnit	BUSINESSUNIT	OPTIONAL	BOTH
MMCU_szBranchPlant	BUSINESSUNIT	OPTIONAL	BOTH
SRST_szWOStatus	UDC	OPTIONAL	BOTH	UDC 00\|SS
SUB_szSubsidiary	STRING	OPTIONAL	BOTH
AN8_mnCustomerNumber	ADDRESSNUMBER	OPTIONAL	BOTH
ANO_mnOriginatorNumber	ADDRESSNUMBER	OPTIONAL	BOTH
ANSA_mnManager	ADDRESSNUMBER	OPTIONAL	BOTH
ANPA_mnSupervisor	ADDRESSNUMBER	OPTIONAL	BOTH
ANP_mnAssignedToAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
DPL_jdPlannedCompletionDate	DATE	OPTIONAL	BOTH
ANT_mnInspectorNumber	ADDRESSNUMBER	OPTIONAL	BOTH
NAN8_mnNextAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
STRT_jdStartDate	DATE	OPTIONAL	BOTH
DRQJ_jdRequestedDate	DATE	OPTIONAL	BOTH
STRX_jdCompletionDate	DATE	OPTIONAL	BOTH
WR01_szWOCategoryCode001	UDC	OPTIONAL	BOTH	UDC 00\|W1
WR02_szWOCategoryCode002	UDC	OPTIONAL	BOTH	UDC 00\|W2
WR03_szWOCategoryCode003	UDC	OPTIONAL	BOTH	UDC 00\|W3
WR04_szWOCategoryCode004	UDC	OPTIONAL	BOTH	UDC 00\|W4
WR05_szWOCategoryCode005	UDC	OPTIONAL	BOTH	UDC 00\|W5
WR06_szWOCategoryCode006	UDC	OPTIONAL	BOTH	UDC 00\|W6
WR07_szWOCategoryCode007	UDC	OPTIONAL	BOTH	UDC 00\|W7
WR08_szWOCategoryCode008	UDC	OPTIONAL	BOTH	UDC 00\|W8
WR09_szWOCategoryCode009	UDC	OPTIONAL	BOTH	UDC 00\|W9
WR10_szWOCategoryCode010	UDC	OPTIONAL	BOTH	UDC 00\|W0
VR01_szReference	STRING	OPTIONAL	BOTH
VR02_szReference2	STRING	OPTIONAL	BOTH
AMTC_mnChargeToOriginalAmount	FLOAT	OPTIONAL	BOTH
HRSO_mnEstimatedHours	FLOAT	OPTIONAL	BOTH
HRSA_mnHoursActual	FLOAT	OPTIONAL	BOTH
ITM_mnShortItemNumber	SHORTITEM	OPTIONAL	BOTH
NUMB_mnAssetNumber	ASSETNUMBER	OPTIONAL	BOTH
UORG_mnQtyOrdered	FLOAT	OPTIONAL	BOTH
UOM_szUnitOfMeasure	UDC	OPTIONAL	BOTH
SHNO_szMessageNumber	STRING	OPTIONAL	BOTH
TBM_szTypeOfBill	UDC	OPTIONAL	BOTH	UDC 40\|TB
TRT_szTypeOfRouting	UDC	OPTIONAL	BOTH	UDC 40\|TR
SPRT_cFlashMessage	UDC	OPTIONAL	BOTH	UDC 00\|WM
PC_mnPercentComplete	FLOAT	OPTIONAL	BOTH
LOTN_szLotNumber	STRING	OPTIONAL	BOTH
SBLI_cSubledgerInactiveCode	UDC	OPTIONAL	BOTH	UDC 00\|SI
ESDN_mnEstimatedDowntimeHours	FLOAT	OPTIONAL	BOTH
ACDN_mnActualDowntimeHours	FLOAT	OPTIONAL	BOTH
SAID_mnServiceAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
APRT_szApprovalType	UDC	OPTIONAL	BOTH	UDC 48\|AP
AMLC_mnEstimatedLaborAmount	FLOAT	OPTIONAL	BOTH
AMMC_mnEstimatedMaterialAmount	FLOAT	OPTIONAL	BOTH
AMOT_mnEstimatedOtherAmount	FLOAT	OPTIONAL	BOTH
LBAM_mnActualLaborAmount	FLOAT	OPTIONAL	BOTH
MTAM_mnActualMaterialAmount	FLOAT	OPTIONAL	BOTH
ISSUE_szISSUE	STRING	OPTIONAL	BOTH
PRODM_szProductModel	UDC	OPTIONAL	BOTH	UDC 17\|PM
WHO2_szContactName2	STRING	OPTIONAL	BOTH
AR1_szPhoneAreaCode1	STRING	OPTIONAL	BOTH
PHN1_szPhoneNumberOne	STRING	OPTIONAL	BOTH
TMCO_mnTimeCompleted	INTEGER	OPTIONAL	BOTH
MTHPR_cMethodofPricing	UDC	OPTIONAL	BOTH	UDC 17\|MP
ENTCK_szEntitlementCheck	UDC	OPTIONAL	BOTH	UDC 17\|ER
RYIN_cPaymentInstrumentA	UDC	OPTIONAL	BOTH	UDC 00\|PY
RSTM_mnResponseTime	FLOAT	OPTIONAL	BOTH
CTR_szCountry	UDC	OPTIONAL	BOTH	UDC 00\|CN
REGION_szGeographicRegion	UDC	OPTIONAL	BOTH	UDC 17\|GR
TXA1_szTaxArea1	STRING	OPTIONAL	BOTH
EXR1_szTaxExplanationCode1	UDC	OPTIONAL	BOTH	UDC 00\|EX
LNGP_szLanguagePreference	UDC	OPTIONAL	BOTH	UDC 01\|LP
GLCCV_szGLCategoryCovered	UDC	OPTIONAL	BOTH	UDC 41\|9
GLCNC_szGLCategoryNonCovered	UDC	OPTIONAL	BOTH	UDC 41\|9
COVGR_szCoverageGroup	UDC	OPTIONAL	BOTH	UDC 17\|CG
TIMEZONES_szTimeZoes	UDC	OPTIONAL	BOTH	UDC H91\|TZ
PRODF_szProductFamily	UDC	OPTIONAL	BOTH	UDC 17\|PA
CRDC_szCurrencyCodeTo	STRING	OPTIONAL	BOTH
CRCD_szCurrencyCodeFrom	STRING	OPTIONAL	BOTH
CRRM_cCurrencyMode	UDC	OPTIONAL	BOTH	UDC H00\|CY
CRR_mnCurrencyConverRateOv	FLOAT	OPTIONAL	BOTH
DOC_mnDocVoucherInvoiceE	INTEGER	OPTIONAL	BOTH
WR11_szECOworkbenchselections	UDC	OPTIONAL	BOTH	UDC 00\|X1
WR12_szCategoriesWorkOrder12	UDC	OPTIONAL	BOTH	UDC 00\|X2
WR13_szCategoriesWorkOrder13	UDC	OPTIONAL	BOTH	UDC 00\|X3
WR14_szCategoriesWorkOrder14	UDC	OPTIONAL	BOTH	UDC 00\|X4
WR15_szCategoriesWorkOrder15	UDC	OPTIONAL	BOTH	UDC 00\|X5
WR16_szCategoriesWorkOrder16	UDC	OPTIONAL	BOTH	UDC 00\|X6
WR17_szCategoriesWorkOrder17	UDC	OPTIONAL	BOTH	UDC 00\|X7
WR18_szCategoriesWorkOrder18	UDC	OPTIONAL	BOTH	UDC 00\|X8
WR19_szCategoriesWorkOrder19	UDC	OPTIONAL	BOTH	UDC 00\|X9
WR20_szCategoriesWorkOrder20	UDC	OPTIONAL	BOTH	UDC 00\|X0
MCULT_szWorkCenterLeadCraft	STRING	OPTIONAL	BOTH
OTAM_mnAmountActualOther	FLOAT	OPTIONAL	BOTH
mnPlannedFinishTime	INTEGER	OPTIONAL	BOTH
EQST_szToEquipmentStatus	UDC	OPTIONAL	IN	UDC 12\|ES
UPLOW_cUpdateChildren	CHARACTER	OPTIONAL	IN
SEST_mnTimeScheduledStart	INTEGER	OPTIONAL	BOTH
mnRequestedFinishTime	INTEGER	OPTIONAL	BOTH
DOCO_mnCopiedFromOrderNumber	INTEGER	OPTIONAL	IN	Populate this field to copy WO
SRYN_cEligibleSupplierRecovery	UDC	OPTIONAL	BOTH	UDC 17\|SR
EV01_cReserveObject	CHARACTER	OPTIONAL	IN