[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_WO_PUB
Source
1 PACKAGE EAM_PROCESS_WO_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPWOPS.pls 120.17.12020000.5 2013/03/28 08:12:38 shengywa ship $ */
3 /*#
4 * This package is used for creation of asset maintenance work order (Single/Multiple)
5 * @rep:scope public
6 * @rep:product EAM
7 * @rep:displayname Asset Maintenance Work Order Creation
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY EAM_WORK_ORDER
10 */
11
12 /***************************************************************************
13 --
14 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
15 -- All rights reserved.
16 --
17 -- FILENAME
18 --
19 -- EAMPWOPS.pls
20 --
21 -- DESCRIPTION
22 --
23 -- Spec of package EAM_PROCESS_WO_PUB
24 --
25 -- NOTES
26 --
27 -- HISTORY
28 --
29 -- 30-JUN-2002 Kenichi Nagumo Initial Creation
30 ***************************************************************************/
31
32 g_debug_flag VARCHAR2(1) := 'N';
33
34 -- Copied over the following 4 global variables from the eam_process_wo_pvt package.
35 G_OPR_SYNC CONSTANT NUMBER := 0;
36 G_OPR_CREATE CONSTANT NUMBER := 1;
37 G_OPR_UPDATE CONSTANT NUMBER := 2;
38 G_OPR_DELETE CONSTANT NUMBER := 3;
39 G_OPR_COMPLETE CONSTANT NUMBER := 4;
40 G_OPR_UNCOMPLETE CONSTANT NUMBER := 5;
41 G_WF_OPR_UPDATE CONSTANT NUMBER := 6;
42
43
44 Type eam_wo_relations_rec_type is record
45 ( BATCH_ID NUMBER :=null,
46 WO_RELATIONSHIP_ID NUMBER :=null,
47 PARENT_OBJECT_ID NUMBER :=null,
48 PARENT_OBJECT_TYPE_ID NUMBER :=null,
49 PARENT_HEADER_ID NUMBER :=null,
50 CHILD_OBJECT_ID NUMBER :=null,
51 CHILD_OBJECT_TYPE_ID NUMBER :=null,
52 CHILD_HEADER_ID NUMBER :=null,
53 PARENT_RELATIONSHIP_TYPE NUMBER :=null,
54 RELATIONSHIP_STATUS NUMBER :=null,
55 TOP_LEVEL_OBJECT_ID NUMBER :=null,
56 TOP_LEVEL_OBJECT_TYPE_ID NUMBER :=null,
57 TOP_LEVEL_HEADER_ID NUMBER :=null,
58 ADJUST_PARENT VARCHAR2(1) :=null,
59 RETURN_STATUS VARCHAR2(1) :=null,
60 TRANSACTION_TYPE NUMBER :=null,
61 ROW_ID NUMBER :=null
62 );
63
64 Type header_id_rec_type is record
65 ( HEADER_ID NUMBER :=null
66 );
67
68 failure_entry_record_typ_null eam_process_failure_entry_pub.eam_failure_entry_record_typ;
69 /* Failure Entry Project */
70
71
72
73 Type eam_wo_rec_type is record
74 ( HEADER_ID NUMBER :=null,
75 BATCH_ID NUMBER :=null,
76 ROW_ID NUMBER :=null,
77 WIP_ENTITY_NAME VARCHAR2(240) :=null,
78 WIP_ENTITY_ID NUMBER :=null,
79 ORGANIZATION_ID NUMBER :=null,
80 DESCRIPTION VARCHAR2(240) :=null,
81 ASSET_NUMBER VARCHAR2(30) :=null,
82 ASSET_GROUP_ID NUMBER :=null,
83 REBUILD_ITEM_ID NUMBER :=null,
84 REBUILD_SERIAL_NUMBER VARCHAR2(30) :=null,
85 MAINTENANCE_OBJECT_ID NUMBER :=null,
86 MAINTENANCE_OBJECT_TYPE NUMBER :=null,
87 MAINTENANCE_OBJECT_SOURCE NUMBER :=null,
88 EAM_LINEAR_LOCATION_ID NUMBER :=null,
89 CLASS_CODE VARCHAR2(10) :=null,
90 ASSET_ACTIVITY_ID NUMBER :=null,
91 ACTIVITY_TYPE VARCHAR2(30) :=null,
92 ACTIVITY_CAUSE VARCHAR2(30) :=null,
93 ACTIVITY_SOURCE VARCHAR2(30) :=null,
94 WORK_ORDER_TYPE VARCHAR2(30) :=null,
95 STATUS_TYPE NUMBER :=null,
96 JOB_QUANTITY NUMBER :=null,
97 DATE_RELEASED DATE :=null,
98 OWNING_DEPARTMENT NUMBER :=null,
99 PRIORITY NUMBER :=null,
100 REQUESTED_START_DATE DATE :=null,
101 DUE_DATE DATE :=null,
102 SHUTDOWN_TYPE VARCHAR2(30) :=null,
103 PLANNER_TYPE VARCHAR2(30) :=null, --added for 16048441
104 FIRM_PLANNED_FLAG NUMBER :=null,
105 NOTIFICATION_REQUIRED VARCHAR2(1) :=null,
106 TAGOUT_REQUIRED VARCHAR2(1) :=null,
107 PLAN_MAINTENANCE VARCHAR2(1) :=null,
108 PROJECT_ID NUMBER :=null,
109 TASK_ID NUMBER :=null,
110 --PROJECT_COSTED NUMBER :=null,
111 END_ITEM_UNIT_NUMBER VARCHAR2(30) :=null,
112 SCHEDULE_GROUP_ID NUMBER :=null,
113 BOM_REVISION_DATE DATE :=null,
114 ROUTING_REVISION_DATE DATE :=null,
115 ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) :=null,
116 ALTERNATE_BOM_DESIGNATOR VARCHAR2(10) :=null,
117 ROUTING_REVISION VARCHAR2(3) :=null,
118 BOM_REVISION VARCHAR2(3) :=null,
119 PARENT_WIP_ENTITY_ID NUMBER :=null,
120 MANUAL_REBUILD_FLAG VARCHAR2(1) :=null,
121 PM_SCHEDULE_ID NUMBER :=null,
122 WIP_SUPPLY_TYPE NUMBER :=null,
123 MATERIAL_ACCOUNT NUMBER :=null,
124 MATERIAL_OVERHEAD_ACCOUNT NUMBER :=null,
125 RESOURCE_ACCOUNT NUMBER :=null,
126 OUTSIDE_PROCESSING_ACCOUNT NUMBER :=null,
127 MATERIAL_VARIANCE_ACCOUNT NUMBER :=null,
128 RESOURCE_VARIANCE_ACCOUNT NUMBER :=null,
129 OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER :=null,
130 STD_COST_ADJUSTMENT_ACCOUNT NUMBER :=null,
131 OVERHEAD_ACCOUNT NUMBER :=null,
132 OVERHEAD_VARIANCE_ACCOUNT NUMBER :=null,
133 SCHEDULED_START_DATE DATE :=null,
134 SCHEDULED_COMPLETION_DATE DATE :=null,
135 PM_SUGGESTED_START_DATE DATE :=null,
136 PM_SUGGESTED_END_DATE DATE :=null,
137 PM_BASE_METER_READING NUMBER :=null,
138 PM_BASE_METER NUMBER :=null,
139 COMMON_BOM_SEQUENCE_ID NUMBER :=null,
140 COMMON_ROUTING_SEQUENCE_ID NUMBER :=null,
141 PO_CREATION_TIME NUMBER :=null,
142 GEN_OBJECT_ID NUMBER :=null,
143 USER_DEFINED_STATUS_ID NUMBER :=null,
144 PENDING_FLAG VARCHAR2(1) :=null,
145 MATERIAL_SHORTAGE_CHECK_DATE DATE :=null,
146 MATERIAL_SHORTAGE_FLAG NUMBER :=null,
147 WORKFLOW_TYPE NUMBER :=null,
148 WARRANTY_CLAIM_STATUS NUMBER :=null,
149 CYCLE_ID NUMBER :=null,
150 SEQ_ID NUMBER :=null,
151 DS_SCHEDULED_FLAG VARCHAR2(1) :=null,
152 WARRANTY_ACTIVE NUMBER :=null,
153 ASSIGNMENT_COMPLETE VARCHAR2(1) :=null,
154 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
155 ATTRIBUTE1 VARCHAR2(150) :=null,
156 ATTRIBUTE2 VARCHAR2(150) :=null,
157 ATTRIBUTE3 VARCHAR2(150) :=null,
158 ATTRIBUTE4 VARCHAR2(150) :=null,
159 ATTRIBUTE5 VARCHAR2(150) :=null,
160 ATTRIBUTE6 VARCHAR2(150) :=null,
161 ATTRIBUTE7 VARCHAR2(150) :=null,
162 ATTRIBUTE8 VARCHAR2(150) :=null,
163 ATTRIBUTE9 VARCHAR2(150) :=null,
164 ATTRIBUTE10 VARCHAR2(150) :=null,
165 ATTRIBUTE11 VARCHAR2(150) :=null,
166 ATTRIBUTE12 VARCHAR2(150) :=null,
167 ATTRIBUTE13 VARCHAR2(150) :=null,
168 ATTRIBUTE14 VARCHAR2(150) :=null,
169 ATTRIBUTE15 VARCHAR2(150) :=null,
170 MATERIAL_ISSUE_BY_MO VARCHAR2(1) :=null,
171 ISSUE_ZERO_COST_FLAG VARCHAR2(1) :=null,
172 REPORT_TYPE NUMBER := null,
173 ACTUAL_CLOSE_DATE DATE := null,
174 SUBMISSION_DATE DATE := null,
175 USER_ID NUMBER :=null,
176 RESPONSIBILITY_ID NUMBER :=null,
177 REQUEST_ID NUMBER :=null,
178 PROGRAM_ID NUMBER :=null,
179 PROGRAM_APPLICATION_ID NUMBER :=null,
180 SOURCE_LINE_ID NUMBER :=null,
181 SOURCE_CODE VARCHAR2(30) :=null,
182 VALIDATE_STRUCTURE VARCHAR2(1) :='N', -- added for bug# 3544860
183 RETURN_STATUS VARCHAR2(1) :=null,
184 TRANSACTION_TYPE NUMBER :=null,
185 FAILURE_CODE_REQUIRED VARCHAR2(1) :=null,
186 eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ,
187 eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
188 );
189
190
191 Type eam_op_rec_type is record
192 ( HEADER_ID NUMBER :=null,
193 BATCH_ID NUMBER :=null,
194 ROW_ID NUMBER :=null,
195 WIP_ENTITY_ID NUMBER :=null,
196 ORGANIZATION_ID NUMBER :=null,
197 OPERATION_SEQ_NUM NUMBER :=null,
198 STANDARD_OPERATION_ID NUMBER :=null,
199 DEPARTMENT_ID NUMBER :=null,
200 OPERATION_SEQUENCE_ID NUMBER :=null,
201 DESCRIPTION VARCHAR2(240) :=null,
202 MINIMUM_TRANSFER_QUANTITY NUMBER :=null,
203 COUNT_POINT_TYPE NUMBER :=null,
204 BACKFLUSH_FLAG NUMBER :=null,
205 SHUTDOWN_TYPE VARCHAR2(30) :=null,
206 START_DATE DATE :=null,
207 COMPLETION_DATE DATE :=null,
208 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
209 ATTRIBUTE1 VARCHAR2(150) :=null,
210 ATTRIBUTE2 VARCHAR2(150) :=null,
211 ATTRIBUTE3 VARCHAR2(150) :=null,
212 ATTRIBUTE4 VARCHAR2(150) :=null,
213 ATTRIBUTE5 VARCHAR2(150) :=null,
214 ATTRIBUTE6 VARCHAR2(150) :=null,
215 ATTRIBUTE7 VARCHAR2(150) :=null,
216 ATTRIBUTE8 VARCHAR2(150) :=null,
217 ATTRIBUTE9 VARCHAR2(150) :=null,
218 ATTRIBUTE10 VARCHAR2(150) :=null,
219 ATTRIBUTE11 VARCHAR2(150) :=null,
220 ATTRIBUTE12 VARCHAR2(150) :=null,
221 ATTRIBUTE13 VARCHAR2(150) :=null,
222 ATTRIBUTE14 VARCHAR2(150) :=null,
223 ATTRIBUTE15 VARCHAR2(150) :=null,
224 LONG_DESCRIPTION VARCHAR2(4000) :=null,
225 REQUEST_ID NUMBER :=null,
226 PROGRAM_APPLICATION_ID NUMBER :=null,
227 PROGRAM_ID NUMBER :=null,
228 RETURN_STATUS VARCHAR2(1) :=null,
229 TRANSACTION_TYPE NUMBER :=null ,
230 X_POS NUMBER :=null, --Added X_POS and Y_POS for bug#4615678
231 Y_POS NUMBER :=null
232 );
233
234
235 Type eam_op_network_rec_type is record
236 ( HEADER_ID NUMBER :=null,
237 BATCH_ID NUMBER :=null,
238 ROW_ID NUMBER :=null,
239 WIP_ENTITY_ID NUMBER :=null,
240 ORGANIZATION_ID NUMBER :=null,
241 PRIOR_OPERATION NUMBER :=null,
242 NEXT_OPERATION NUMBER :=null,
243 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
244 ATTRIBUTE1 VARCHAR2(150) :=null,
245 ATTRIBUTE2 VARCHAR2(150) :=null,
246 ATTRIBUTE3 VARCHAR2(150) :=null,
247 ATTRIBUTE4 VARCHAR2(150) :=null,
248 ATTRIBUTE5 VARCHAR2(150) :=null,
249 ATTRIBUTE6 VARCHAR2(150) :=null,
250 ATTRIBUTE7 VARCHAR2(150) :=null,
251 ATTRIBUTE8 VARCHAR2(150) :=null,
252 ATTRIBUTE9 VARCHAR2(150) :=null,
253 ATTRIBUTE10 VARCHAR2(150) :=null,
254 ATTRIBUTE11 VARCHAR2(150) :=null,
255 ATTRIBUTE12 VARCHAR2(150) :=null,
256 ATTRIBUTE13 VARCHAR2(150) :=null,
257 ATTRIBUTE14 VARCHAR2(150) :=null,
258 ATTRIBUTE15 VARCHAR2(150) :=null,
259 RETURN_STATUS VARCHAR2(1) :=null,
260 TRANSACTION_TYPE NUMBER :=null
261 );
262
263
264 Type eam_res_rec_type is record
265 ( HEADER_ID NUMBER :=null,
266 BATCH_ID NUMBER :=null,
267 ROW_ID NUMBER :=null,
268 WIP_ENTITY_ID NUMBER :=null,
269 ORGANIZATION_ID NUMBER :=null,
270 OPERATION_SEQ_NUM NUMBER :=null,
271 RESOURCE_SEQ_NUM NUMBER :=null,
272 RESOURCE_ID NUMBER :=null,
273 UOM_CODE VARCHAR2(3) :=null,
274 BASIS_TYPE NUMBER :=null,
275 USAGE_RATE_OR_AMOUNT NUMBER :=null,
276 ACTIVITY_ID NUMBER :=null,
277 SCHEDULED_FLAG NUMBER :=null,
278 FIRM_FLAG NUMBER :=null,
279 ASSIGNED_UNITS NUMBER :=null,
280 MAXIMUM_ASSIGNED_UNITS NUMBER :=null,
281 AUTOCHARGE_TYPE NUMBER :=null,
282 STANDARD_RATE_FLAG NUMBER :=null,
283 APPLIED_RESOURCE_UNITS NUMBER :=null,
284 APPLIED_RESOURCE_VALUE NUMBER :=null,
285 START_DATE DATE :=null,
286 COMPLETION_DATE DATE :=null,
287 SCHEDULE_SEQ_NUM NUMBER :=null,
288 SUBSTITUTE_GROUP_NUM NUMBER :=null,
289 REPLACEMENT_GROUP_NUM NUMBER :=null,
290 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
291 ATTRIBUTE1 VARCHAR2(150) :=null,
292 ATTRIBUTE2 VARCHAR2(150) :=null,
293 ATTRIBUTE3 VARCHAR2(150) :=null,
294 ATTRIBUTE4 VARCHAR2(150) :=null,
295 ATTRIBUTE5 VARCHAR2(150) :=null,
296 ATTRIBUTE6 VARCHAR2(150) :=null,
297 ATTRIBUTE7 VARCHAR2(150) :=null,
298 ATTRIBUTE8 VARCHAR2(150) :=null,
299 ATTRIBUTE9 VARCHAR2(150) :=null,
300 ATTRIBUTE10 VARCHAR2(150) :=null,
301 ATTRIBUTE11 VARCHAR2(150) :=null,
302 ATTRIBUTE12 VARCHAR2(150) :=null,
303 ATTRIBUTE13 VARCHAR2(150) :=null,
304 ATTRIBUTE14 VARCHAR2(150) :=null,
305 ATTRIBUTE15 VARCHAR2(150) :=null,
306 DEPARTMENT_ID NUMBER :=null,
307 REQUEST_ID NUMBER :=null,
308 PROGRAM_APPLICATION_ID NUMBER :=null,
309 PROGRAM_ID NUMBER :=null,
310 PROGRAM_UPDATE_DATE DATE :=null,
311 RETURN_STATUS VARCHAR2(1) :=null,
312 TRANSACTION_TYPE NUMBER :=null
313 );
314
315 Type eam_res_inst_rec_type is record
316 ( HEADER_ID NUMBER :=null,
317 BATCH_ID NUMBER :=null,
318 ROW_ID NUMBER :=null,
319 WIP_ENTITY_ID NUMBER :=null,
320 ORGANIZATION_ID NUMBER :=null,
321 OPERATION_SEQ_NUM NUMBER :=null,
322 RESOURCE_SEQ_NUM NUMBER :=null,
323 INSTANCE_ID NUMBER :=null,
324 SERIAL_NUMBER VARCHAR2(30) :=null,
325 START_DATE DATE :=null,
326 COMPLETION_DATE DATE :=null,
327 TOP_LEVEL_BATCH_ID NUMBER :=null,
328 RETURN_STATUS VARCHAR2(1) :=null,
329 TRANSACTION_TYPE NUMBER :=null
330 );
331
332
333 Type eam_sub_res_rec_type is record
334 ( HEADER_ID NUMBER :=null,
335 BATCH_ID NUMBER :=null,
336 ROW_ID NUMBER :=null,
337 WIP_ENTITY_ID NUMBER :=null,
338 ORGANIZATION_ID NUMBER :=null,
339 OPERATION_SEQ_NUM NUMBER :=null,
340 RESOURCE_SEQ_NUM NUMBER :=null,
341 RESOURCE_ID NUMBER :=null,
342 UOM_CODE VARCHAR2(3) :=null,
343 BASIS_TYPE NUMBER :=null,
344 USAGE_RATE_OR_AMOUNT NUMBER :=null,
345 ACTIVITY_ID NUMBER :=null,
346 SCHEDULED_FLAG NUMBER :=null,
347 ASSIGNED_UNITS NUMBER :=null,
348 AUTOCHARGE_TYPE NUMBER :=null,
349 STANDARD_RATE_FLAG NUMBER :=null,
350 APPLIED_RESOURCE_UNITS NUMBER :=null,
351 APPLIED_RESOURCE_VALUE NUMBER :=null,
352 START_DATE DATE :=null,
353 COMPLETION_DATE DATE :=null,
354 SCHEDULE_SEQ_NUM NUMBER :=null,
355 SUBSTITUTE_GROUP_NUM NUMBER :=null,
356 REPLACEMENT_GROUP_NUM NUMBER :=null,
357 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
358 ATTRIBUTE1 VARCHAR2(150) :=null,
359 ATTRIBUTE2 VARCHAR2(150) :=null,
360 ATTRIBUTE3 VARCHAR2(150) :=null,
361 ATTRIBUTE4 VARCHAR2(150) :=null,
362 ATTRIBUTE5 VARCHAR2(150) :=null,
363 ATTRIBUTE6 VARCHAR2(150) :=null,
364 ATTRIBUTE7 VARCHAR2(150) :=null,
365 ATTRIBUTE8 VARCHAR2(150) :=null,
366 ATTRIBUTE9 VARCHAR2(150) :=null,
367 ATTRIBUTE10 VARCHAR2(150) :=null,
368 ATTRIBUTE11 VARCHAR2(150) :=null,
369 ATTRIBUTE12 VARCHAR2(150) :=null,
370 ATTRIBUTE13 VARCHAR2(150) :=null,
371 ATTRIBUTE14 VARCHAR2(150) :=null,
372 ATTRIBUTE15 VARCHAR2(150) :=null,
373 DEPARTMENT_ID NUMBER :=null,
374 REQUEST_ID NUMBER :=null,
375 PROGRAM_APPLICATION_ID NUMBER :=null,
376 PROGRAM_ID NUMBER :=null,
377 PROGRAM_UPDATE_DATE DATE :=null,
378 RETURN_STATUS VARCHAR2(1) :=null,
379 TRANSACTION_TYPE NUMBER :=null
380 );
381
382 Type eam_res_usage_rec_type is record
383 ( HEADER_ID NUMBER :=null,
384 BATCH_ID NUMBER :=null,
385 ROW_ID NUMBER :=null,
386 WIP_ENTITY_ID NUMBER :=null,
387 OPERATION_SEQ_NUM NUMBER :=null,
388 RESOURCE_SEQ_NUM NUMBER :=null,
389 ORGANIZATION_ID NUMBER :=null,
390 START_DATE DATE :=null,
391 COMPLETION_DATE DATE :=null,
392 OLD_START_DATE DATE :=null,
393 OLD_COMPLETION_DATE DATE :=null,
394 ASSIGNED_UNITS NUMBER :=null,
395 REQUEST_ID NUMBER :=null,
396 PROGRAM_APPLICATION_ID NUMBER :=null,
397 PROGRAM_ID NUMBER :=null,
398 PROGRAM_UPDATE_DATE DATE :=null,
399 INSTANCE_ID NUMBER :=null,
400 SERIAL_NUMBER VARCHAR2(30) :=null,
401 RETURN_STATUS VARCHAR2(1) :=null,
402 TRANSACTION_TYPE NUMBER :=null
403 );
404
405
406 Type eam_mat_req_rec_type is record
407 ( HEADER_ID NUMBER :=null,
408 BATCH_ID NUMBER :=null,
409 ROW_ID NUMBER :=null,
410 WIP_ENTITY_ID NUMBER :=null,
411 ORGANIZATION_ID NUMBER :=null,
412 OPERATION_SEQ_NUM NUMBER :=null,
413 INVENTORY_ITEM_ID NUMBER :=null,
414 QUANTITY_PER_ASSEMBLY NUMBER :=null,
415 DEPARTMENT_ID NUMBER :=null,
416 WIP_SUPPLY_TYPE NUMBER :=null,
417 DATE_REQUIRED DATE :=null,
418 REQUIRED_QUANTITY NUMBER :=null,
419 --fix for 3550864.added the following column
420 REQUESTED_QUANTITY NUMBER :=null,
421 --fix for 3572280
422 RELEASED_QUANTITY NUMBER := null,
423 QUANTITY_ISSUED NUMBER :=null,
424 SUPPLY_SUBINVENTORY VARCHAR2(10) :=null,
425 SUPPLY_LOCATOR_ID NUMBER :=null,
426 MRP_NET_FLAG NUMBER :=null,
427 MPS_REQUIRED_QUANTITY NUMBER :=null,
428 MPS_DATE_REQUIRED DATE :=null,
429 COMPONENT_SEQUENCE_ID NUMBER :=null,
430 COMMENTS VARCHAR2(240) :=null,
431 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
432 ATTRIBUTE1 VARCHAR2(150) :=null,
433 ATTRIBUTE2 VARCHAR2(150) :=null,
434 ATTRIBUTE3 VARCHAR2(150) :=null,
435 ATTRIBUTE4 VARCHAR2(150) :=null,
436 ATTRIBUTE5 VARCHAR2(150) :=null,
437 ATTRIBUTE6 VARCHAR2(150) :=null,
438 ATTRIBUTE7 VARCHAR2(150) :=null,
439 ATTRIBUTE8 VARCHAR2(150) :=null,
440 ATTRIBUTE9 VARCHAR2(150) :=null,
441 ATTRIBUTE10 VARCHAR2(150) :=null,
442 ATTRIBUTE11 VARCHAR2(150) :=null,
443 ATTRIBUTE12 VARCHAR2(150) :=null,
444 ATTRIBUTE13 VARCHAR2(150) :=null,
445 ATTRIBUTE14 VARCHAR2(150) :=null,
446 ATTRIBUTE15 VARCHAR2(150) :=null,
447 AUTO_REQUEST_MATERIAL VARCHAR2(1) :=null,
448 SUGGESTED_VENDOR_NAME VARCHAR2(240) :=null,
449 VENDOR_ID NUMBER :=null,
450 UNIT_PRICE NUMBER :=null,
451 REQUEST_ID NUMBER :=null,
452 PROGRAM_APPLICATION_ID NUMBER :=null,
453 PROGRAM_ID NUMBER :=null,
454 PROGRAM_UPDATE_DATE DATE :=null,
455 RETURN_STATUS VARCHAR2(1) :=null,
456 TRANSACTION_TYPE NUMBER :=null,
457 INVOKE_ALLOCATIONS_API VARCHAR2(1) := null
458 );
459
460
461
462 Type eam_direct_items_rec_type is record
463 (
464 HEADER_ID NUMBER :=null,
465 BATCH_ID NUMBER :=null,
466 ROW_ID NUMBER :=null,
467 DESCRIPTION VARCHAR2(240) :=null,
468 PURCHASING_CATEGORY_ID NUMBER :=null,
469 DIRECT_ITEM_SEQUENCE_ID NUMBER :=null,
470 OPERATION_SEQ_NUM NUMBER :=null,
471 DEPARTMENT_ID NUMBER :=null,
472 WIP_ENTITY_ID NUMBER :=null,
473 ORGANIZATION_ID NUMBER :=null,
474 SUGGESTED_VENDOR_NAME VARCHAR2(240) :=null,
475 SUGGESTED_VENDOR_ID NUMBER :=null,
476 SUGGESTED_VENDOR_SITE VARCHAR2(15) :=null,
477 SUGGESTED_VENDOR_SITE_ID NUMBER :=null,
478 SUGGESTED_VENDOR_CONTACT VARCHAR2(80) :=null,
479 SUGGESTED_VENDOR_CONTACT_ID NUMBER :=null,
480 SUGGESTED_VENDOR_PHONE VARCHAR2(20) :=null,
481 SUGGESTED_VENDOR_ITEM_NUM VARCHAR2(25) :=null,
482 UNIT_PRICE NUMBER :=null,
483 AUTO_REQUEST_MATERIAL VARCHAR2(1) :=null,
484 REQUIRED_QUANTITY NUMBER :=null,
485 --fix for 3550864.added the following column
486 REQUESTED_QUANTITY NUMBER :=null,
487 UOM VARCHAR2(3) :=null,
488 NEED_BY_DATE DATE :=null,
489 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
490 ATTRIBUTE1 VARCHAR2(150) :=null,
491 ATTRIBUTE2 VARCHAR2(150) :=null,
492 ATTRIBUTE3 VARCHAR2(150) :=null,
493 ATTRIBUTE4 VARCHAR2(150) :=null,
494 ATTRIBUTE5 VARCHAR2(150) :=null,
495 ATTRIBUTE6 VARCHAR2(150) :=null,
496 ATTRIBUTE7 VARCHAR2(150) :=null,
497 ATTRIBUTE8 VARCHAR2(150) :=null,
498 ATTRIBUTE9 VARCHAR2(150) :=null,
499 ATTRIBUTE10 VARCHAR2(150) :=null,
500 ATTRIBUTE11 VARCHAR2(150) :=null,
501 ATTRIBUTE12 VARCHAR2(150) :=null,
502 ATTRIBUTE13 VARCHAR2(150) :=null,
503 ATTRIBUTE14 VARCHAR2(150) :=null,
504 ATTRIBUTE15 VARCHAR2(150) :=null,
505 PROGRAM_APPLICATION_ID NUMBER :=null,
506 PROGRAM_ID NUMBER :=null,
507 PROGRAM_UPDATE_DATE DATE :=null,
508 REQUEST_ID NUMBER :=null,
509 RETURN_STATUS VARCHAR2(1) :=null,
510 TRANSACTION_TYPE NUMBER :=null
511 );
512
513 Type eam_wo_comp_rec_type is record
514 (
515 HEADER_ID NUMBER :=null,
516 BATCH_ID NUMBER :=null,
517 ROW_ID NUMBER :=null,
518 TRANSACTION_ID NUMBER :=null,
519 TRANSACTION_DATE DATE :=null,
520 WIP_ENTITY_ID NUMBER :=null,
521 USER_STATUS_ID NUMBER :=null,
522 WIP_ENTITY_NAME VARCHAR2(240) :=null,
523 ORGANIZATION_ID NUMBER :=null,
524 PARENT_WIP_ENTITY_ID NUMBER :=null,
525 REFERENCE VARCHAR2(240) :=null,
526 RECONCILIATION_CODE VARCHAR2(30) :=null,
527 ACCT_PERIOD_ID NUMBER :=null,
528 QA_COLLECTION_ID NUMBER :=null,
529 ACTUAL_START_DATE DATE :=null,
530 ACTUAL_END_DATE DATE :=null,
531 ACTUAL_DURATION NUMBER :=null,
532 PRIMARY_ITEM_ID NUMBER :=null,
533 ASSET_GROUP_ID NUMBER :=null,
534 REBUILD_ITEM_ID NUMBER :=null,
535 ASSET_NUMBER VARCHAR2(30) :=null,
536 REBUILD_SERIAL_NUMBER VARCHAR2(30) :=null,
537 MANUAL_REBUILD_FLAG VARCHAR2(1) :=null,
538 REBUILD_JOB VARCHAR2(1) :=null,
539 COMPLETION_SUBINVENTORY VARCHAR2(10) :=null,
540 COMPLETION_LOCATOR_ID NUMBER :=null,
541 LOT_NUMBER VARCHAR2(80) :=null,
542 SHUTDOWN_START_DATE DATE :=null,
543 SHUTDOWN_END_DATE DATE :=null,
544 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
545 ATTRIBUTE1 VARCHAR2(150) :=null,
546 ATTRIBUTE2 VARCHAR2(150) :=null,
547 ATTRIBUTE3 VARCHAR2(150) :=null,
548 ATTRIBUTE4 VARCHAR2(150) :=null,
549 ATTRIBUTE5 VARCHAR2(150) :=null,
550 ATTRIBUTE6 VARCHAR2(150) :=null,
551 ATTRIBUTE7 VARCHAR2(150) :=null,
552 ATTRIBUTE8 VARCHAR2(150) :=null,
553 ATTRIBUTE9 VARCHAR2(150) :=null,
554 ATTRIBUTE10 VARCHAR2(150) :=null,
555 ATTRIBUTE11 VARCHAR2(150) :=null,
556 ATTRIBUTE12 VARCHAR2(150) :=null,
557 ATTRIBUTE13 VARCHAR2(150) :=null,
558 ATTRIBUTE14 VARCHAR2(150) :=null,
559 ATTRIBUTE15 VARCHAR2(150) :=null,
560 REQUEST_ID NUMBER :=null,
561 PROGRAM_UPDATE_DATE DATE :=null,
562 PROGRAM_APPLICATION_ID NUMBER :=null,
563 PROGRAM_ID NUMBER :=null,
564 RETURN_STATUS VARCHAR2(1) :=null,
565 TRANSACTION_TYPE NUMBER :=null,
566 eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ,
567 eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ
568
569 );
570
571 Type eam_op_comp_rec_type is record
572 (
573 HEADER_ID NUMBER :=null,
574 BATCH_ID NUMBER :=null,
575 ROW_ID NUMBER :=null,
576 TRANSACTION_ID NUMBER :=null,
577 TRANSACTION_DATE DATE :=null,
578 WIP_ENTITY_ID NUMBER :=null,
579 ORGANIZATION_ID NUMBER :=null,
580 OPERATION_SEQ_NUM NUMBER :=null,
581 DEPARTMENT_ID NUMBER :=null,
582 REFERENCE VARCHAR2(240) :=null,
583 RECONCILIATION_CODE VARCHAR2(30) :=null,
584 ACCT_PERIOD_ID NUMBER :=null,
585 QA_COLLECTION_ID NUMBER :=null,
586 ACTUAL_START_DATE DATE :=null,
587 ACTUAL_END_DATE DATE :=null,
588 ACTUAL_DURATION NUMBER :=null,
589 SHUTDOWN_START_DATE DATE :=null,
590 SHUTDOWN_END_DATE DATE :=null,
591 HANDOVER_OPERATION_SEQ_NUM NUMBER :=null,
592 REASON_ID NUMBER :=null,
593 VENDOR_CONTACT_ID NUMBER :=null,
594 VENDOR_ID NUMBER :=null,
595 VENDOR_SITE_ID NUMBER :=null,
596 TRANSACTION_REFERENCE VARCHAR2(240) :=null,
597 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
598 ATTRIBUTE1 VARCHAR2(150) :=null,
599 ATTRIBUTE2 VARCHAR2(150) :=null,
600 ATTRIBUTE3 VARCHAR2(150) :=null,
601 ATTRIBUTE4 VARCHAR2(150) :=null,
602 ATTRIBUTE5 VARCHAR2(150) :=null,
603 ATTRIBUTE6 VARCHAR2(150) :=null,
604 ATTRIBUTE7 VARCHAR2(150) :=null,
605 ATTRIBUTE8 VARCHAR2(150) :=null,
606 ATTRIBUTE9 VARCHAR2(150) :=null,
607 ATTRIBUTE10 VARCHAR2(150) :=null,
608 ATTRIBUTE11 VARCHAR2(150) :=null,
609 ATTRIBUTE12 VARCHAR2(150) :=null,
610 ATTRIBUTE13 VARCHAR2(150) :=null,
611 ATTRIBUTE14 VARCHAR2(150) :=null,
612 ATTRIBUTE15 VARCHAR2(150) :=null,
613 REQUEST_ID NUMBER :=null,
614 PROGRAM_UPDATE_DATE DATE :=null,
615 PROGRAM_APPLICATION_ID NUMBER :=null,
616 PROGRAM_ID NUMBER :=null,
617 RETURN_STATUS VARCHAR2(1) :=null,
618 TRANSACTION_TYPE NUMBER :=null
619 );
620
621 Type eam_wo_quality_rec_type is record
622 (
623 HEADER_ID NUMBER :=null,
624 BATCH_ID NUMBER :=null,
625 ROW_ID NUMBER :=null,
626 WIP_ENTITY_ID NUMBER :=null,
627 ORGANIZATION_ID NUMBER :=null,
628 OPERATION_SEQ_NUMBER NUMBER :=null,
629 PLAN_ID NUMBER :=null,
630 SPEC_ID NUMBER :=null,
631 P_ENABLE_FLAG NUMBER :=null,
632 ELEMENT_ID NUMBER :=null,
633 ELEMENT_VALUE VARCHAR2(2000) :=null,
634 ELEMENT_VALIDATION_FLAG VARCHAR2(100) :=null,
635 TRANSACTION_NUMBER NUMBER :=null,
636 COLLECTION_ID NUMBER :=null,
637 OCCURRENCE NUMBER :=null,
638 RETURN_STATUS VARCHAR2(1) :=null,
639 TRANSACTION_TYPE NUMBER :=null
640 );
641
642 Type eam_meter_reading_rec_type is record
643 (
644 HEADER_ID NUMBER :=null,
645 BATCH_ID NUMBER :=null,
646 ROW_ID NUMBER :=null,
647 WIP_ENTITY_ID NUMBER :=null,
648 -- WIP_ENTITY_NAME VARCHAR2(240) :=null, ??
649 -- METER_NAME VARCHAR2(50) :=null, ??
650 METER_ID NUMBER :=null,
651 METER_READING_ID NUMBER :=null,
652 CURRENT_READING NUMBER :=null,
653 current_reading_date DATE :=null,
654 -- LIFE_TO_DATE_READING DATE :=null, -- ??
655 WO_END_DATE DATE :=null, -- ??
656 RESET_FLAG VARCHAR2(1) :=null,
657 VALUE_BEFORE_RESET NUMBER :=null,
658 IGNORE_METER_WARNINGS VARCHAR2(1) :=null,
659 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
660 ATTRIBUTE1 VARCHAR2(150) :=null,
661 ATTRIBUTE2 VARCHAR2(150) :=null,
662 ATTRIBUTE3 VARCHAR2(150) :=null,
663 ATTRIBUTE4 VARCHAR2(150) :=null,
664 ATTRIBUTE5 VARCHAR2(150) :=null,
665 ATTRIBUTE6 VARCHAR2(150) :=null,
666 ATTRIBUTE7 VARCHAR2(150) :=null,
667 ATTRIBUTE8 VARCHAR2(150) :=null,
668 ATTRIBUTE9 VARCHAR2(150) :=null,
669 ATTRIBUTE10 VARCHAR2(150) :=null,
670 ATTRIBUTE11 VARCHAR2(150) :=null,
671 ATTRIBUTE12 VARCHAR2(150) :=null,
672 ATTRIBUTE13 VARCHAR2(150) :=null,
673 ATTRIBUTE14 VARCHAR2(150) :=null,
674 ATTRIBUTE15 VARCHAR2(150) :=null,
675 ATTRIBUTE16 VARCHAR2(150) :=null,
676 ATTRIBUTE17 VARCHAR2(150) :=null,
677 ATTRIBUTE18 VARCHAR2(150) :=null,
678 ATTRIBUTE19 VARCHAR2(150) :=null,
679 ATTRIBUTE20 VARCHAR2(150) :=null,
680 ATTRIBUTE21 VARCHAR2(150) :=null,
681 ATTRIBUTE22 VARCHAR2(150) :=null,
682 ATTRIBUTE23 VARCHAR2(150) :=null,
683 ATTRIBUTE24 VARCHAR2(150) :=null,
684 ATTRIBUTE25 VARCHAR2(150) :=null,
685 ATTRIBUTE26 VARCHAR2(150) :=null,
686 ATTRIBUTE27 VARCHAR2(150) :=null,
687 ATTRIBUTE28 VARCHAR2(150) :=null,
688 ATTRIBUTE29 VARCHAR2(150) :=null,
689 ATTRIBUTE30 VARCHAR2(150) :=null,
690
691 SOURCE_LINE_ID NUMBER :=null,
692 SOURCE_CODE VARCHAR2(30) :=null,
693 WO_ENTRY_FAKE_FLAG VARCHAR2(1) :=null,
694 RETURN_STATUS VARCHAR2(1) :=null,
695 TRANSACTION_TYPE NUMBER :=null
696 );
697
698 Type eam_counter_prop_rec_type is record
699 (
700 HEADER_ID NUMBER :=null,
701 BATCH_ID NUMBER :=null,
702 ROW_ID NUMBER :=null,
703 WIP_ENTITY_ID NUMBER :=null,
704 COUNTER_ID NUMBER :=null,
705 PROPERTY_ID NUMBER :=null,
706 PROPERTY_VALUE VARCHAR2(240) :=null,
707 VALUE_TIMESTAMP DATE :=null,
708 --??
709 MIGRATED_FLAG VARCHAR2(1) :=null,
710 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
711 ATTRIBUTE1 VARCHAR2(150) :=null,
712 ATTRIBUTE2 VARCHAR2(150) :=null,
713 ATTRIBUTE3 VARCHAR2(150) :=null,
714 ATTRIBUTE4 VARCHAR2(150) :=null,
715 ATTRIBUTE5 VARCHAR2(150) :=null,
716 ATTRIBUTE6 VARCHAR2(150) :=null,
717 ATTRIBUTE7 VARCHAR2(150) :=null,
718 ATTRIBUTE8 VARCHAR2(150) :=null,
719 ATTRIBUTE9 VARCHAR2(150) :=null,
720 ATTRIBUTE10 VARCHAR2(150) :=null,
721 ATTRIBUTE11 VARCHAR2(150) :=null,
722 ATTRIBUTE12 VARCHAR2(150) :=null,
723 ATTRIBUTE13 VARCHAR2(150) :=null,
724 ATTRIBUTE14 VARCHAR2(150) :=null,
725 ATTRIBUTE15 VARCHAR2(150) :=null,
726 RETURN_STATUS VARCHAR2(1) :=null,
727 TRANSACTION_TYPE NUMBER :=null
728 );
729
730 Type eam_wo_comp_rebuild_rec_type is record
731 (
732 HEADER_ID NUMBER :=null,
733 BATCH_ID NUMBER :=null,
734 ROW_ID NUMBER :=null,
735 WIP_ENTITY_ID NUMBER :=null,
736 REBUILD_WIP_ENTITY_ID NUMBER :=null,
737 ORGANIZATION_ID NUMBER :=null,
738 -- SERIAL_NO_ISSUED VARCHAR2(30) :=null,
739 ITEM_REMOVED NUMBER :=null,
740 -- SERIAL_INST_REMOVED VARCHAR2(30) :=null,
741 INSTANCE_ID_REMOVED NUMBER :=null,
742 UNINST_SERIAL_REMOVED VARCHAR2(30) :=null,
743 ACTIVITY_ID NUMBER :=null,
744 RETURN_STATUS VARCHAR2(1) :=null,
745 TRANSACTION_TYPE NUMBER :=null
746 );
747
748 Type eam_wo_comp_mr_read_rec_type is record
749 (
750 HEADER_ID NUMBER :=null,
751 BATCH_ID NUMBER :=null,
752 ROW_ID NUMBER :=null,
753 WIP_ENTITY_ID NUMBER :=null,
754 ORGANIZATION_ID NUMBER :=null,
755 INSTANCE_ID_ISSUED VARCHAR2(30) :=null,
756 -- SERIAL_ITEM_REMOVED NUMBER :=null,
757 -- SERIAL_NO_REMOVED VARCHAR2(30) :=null,
758 METER_ISSUED_SERIAL NUMBER :=null,
759 SOURCE_METER NUMBER :=null,
760 RETURN_STATUS VARCHAR2(1) :=null,
761 TRANSACTION_TYPE NUMBER :=null
762 );
763
764 Type eam_request_rec_type is record
765 (
766 HEADER_ID NUMBER :=null,
767 BATCH_ID NUMBER :=null,
768 ROW_ID NUMBER :=null,
769 WIP_ENTITY_ID NUMBER :=null,
770 WIP_ENTITY_NAME VARCHAR2(240) :=null,
771 ORGANIZATION_ID NUMBER :=null,
772 ORGANIZATION_CODE VARCHAR2(3) :=null,
773 REQUEST_TYPE NUMBER :=null,
774 REQUEST_ID NUMBER :=null,
775 REQUEST_NUMBER VARCHAR2(240) :=null,
776 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
777 ATTRIBUTE1 VARCHAR2(150) :=null,
778 ATTRIBUTE2 VARCHAR2(150) :=null,
779 ATTRIBUTE3 VARCHAR2(150) :=null,
780 ATTRIBUTE4 VARCHAR2(150) :=null,
781 ATTRIBUTE5 VARCHAR2(150) :=null,
782 ATTRIBUTE6 VARCHAR2(150) :=null,
783 ATTRIBUTE7 VARCHAR2(150) :=null,
784 ATTRIBUTE8 VARCHAR2(150) :=null,
785 ATTRIBUTE9 VARCHAR2(150) :=null,
786 ATTRIBUTE10 VARCHAR2(150) :=null,
787 ATTRIBUTE11 VARCHAR2(150) :=null,
788 ATTRIBUTE12 VARCHAR2(150) :=null,
789 ATTRIBUTE13 VARCHAR2(150) :=null,
790 ATTRIBUTE14 VARCHAR2(150) :=null,
791 ATTRIBUTE15 VARCHAR2(150) :=null,
792 PROGRAM_ID NUMBER :=null,
793 PROGRAM_REQUEST_ID NUMBER :=null,
794 PROGRAM_UPDATE_DATE DATE :=null,
795 PROGRAM_APPLICATION_ID NUMBER :=null,
796 WORK_REQUEST_STATUS_ID NUMBER :=null,
797 SERVICE_ASSOC_ID NUMBER :=null,
798 RETURN_STATUS VARCHAR2(1) :=null,
799 TRANSACTION_TYPE NUMBER :=null
800 );
801
802 Type eam_wo_relations_tbl_type is table of eam_wo_relations_rec_type
803 INDEX BY BINARY_INTEGER;
804
805 Type header_id_tbl_type is table of header_id_rec_type
806 INDEX BY BINARY_INTEGER;
807
808 Type eam_wo_tbl_type is table of eam_wo_rec_type
809 INDEX BY BINARY_INTEGER;
810
811 Type eam_op_tbl_type is table of eam_op_rec_type
812 INDEX BY BINARY_INTEGER;
813
814 Type eam_op_network_tbl_type is table of eam_op_network_rec_type
815 INDEX BY BINARY_INTEGER;
816
817 Type eam_res_tbl_type is table of eam_res_rec_type
818 INDEX BY BINARY_INTEGER;
819
820 Type eam_res_inst_tbl_type is table of eam_res_inst_rec_type
821 INDEX BY BINARY_INTEGER;
822
823 Type eam_sub_res_tbl_type is table of eam_sub_res_rec_type
824 INDEX BY BINARY_INTEGER;
825
826 Type eam_res_usage_tbl_type is table of eam_res_usage_rec_type
827 INDEX BY BINARY_INTEGER;
828
829 Type eam_mat_req_tbl_type is table of eam_mat_req_rec_type
830 INDEX BY BINARY_INTEGER;
831
832 Type eam_direct_items_tbl_type is table of eam_direct_items_rec_type
833 INDEX BY BINARY_INTEGER;
834
835 Type eam_wo_comp_tbl_type is table of eam_wo_comp_rec_type
836 INDEX BY BINARY_INTEGER;
837
838 Type eam_op_comp_tbl_type is table of eam_op_comp_rec_type
839 INDEX BY BINARY_INTEGER;
840
841 Type eam_meter_reading_tbl_type is table of eam_meter_reading_rec_type
842 INDEX BY BINARY_INTEGER;
843
844 Type eam_counter_prop_tbl_type is table of eam_counter_prop_rec_type
845 INDEX BY BINARY_INTEGER;
846
847 Type eam_wo_quality_tbl_type is table of eam_wo_quality_rec_type
848 INDEX BY BINARY_INTEGER;
849
850 Type eam_wo_comp_rebuild_tbl_type is table of eam_wo_comp_rebuild_rec_type
851 INDEX BY BINARY_INTEGER;
852
853 Type eam_wo_comp_mr_read_tbl_type is table of eam_wo_comp_mr_read_rec_type
854 INDEX BY BINARY_INTEGER;
855
856 Type eam_request_tbl_type is table of eam_request_rec_type
857 INDEX BY BINARY_INTEGER;
858
859 TYPE wo_relationship_exc_tbl_type is TABLE OF varchar2(1000) INDEX BY BINARY_INTEGER;
860
861
862 PROCEDURE PROCESS_WO
863 ( p_bo_identifier IN VARCHAR2 := 'EAM'
864 , p_api_version_number IN NUMBER := 1.0
865 , p_init_msg_list IN BOOLEAN := FALSE
866 , p_commit IN VARCHAR2 := 'N'
867 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
868 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
869 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
870 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
871 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
872 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
873 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
874 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
875 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
876 , p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
877 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
878 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
879 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
880 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
881 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
882 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
883 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
884 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
885 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
886 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
887 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
888 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
889 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
890 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
891 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
892 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
893 , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
894 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
895 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
896 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
897 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
898 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
899 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
900 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
901 , x_return_status OUT NOCOPY VARCHAR2
902 , x_msg_count OUT NOCOPY NUMBER
903 , p_debug IN VARCHAR2 := 'N'
904 , p_output_dir IN VARCHAR2 := NULL
905 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
906 , p_debug_file_mode IN VARCHAR2 := 'w'
907 );
908
909 PROCEDURE PROCESS_MASTER_CHILD_WO
910 ( p_bo_identifier IN VARCHAR2 := 'EAM'
911 , p_api_version_number IN NUMBER := 1.0
912 , p_init_msg_list IN BOOLEAN := FALSE
913 , p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
914 , p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type
915 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
916 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
917 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
918 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
919 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
920 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
921 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
922 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
923 , p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type
924 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
925 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
926 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
927 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
928 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
929 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
930 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
931 , x_eam_wo_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type
932 , x_eam_wo_relations_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
933 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
934 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
935 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
936 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
937 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
938 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
939 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
940 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
941 , x_eam_wo_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type
942 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
943 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
944 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
945 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
946 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
947 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
948 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
949 , x_return_status OUT NOCOPY VARCHAR2
950 , x_msg_count OUT NOCOPY NUMBER
951 , p_commit IN VARCHAR2 := 'N'
952 , p_debug IN VARCHAR2 := 'N'
953 , p_output_dir IN VARCHAR2 := NULL
954 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
955 , p_debug_file_mode IN VARCHAR2 := 'w'
956 );
957
958 /*#
959 * This procedure is used to create/update a single Maintenance Work Order.
960 * It can also be used to create/update/delete the work order operations,operation networks ,materials,direct items, resources, resource usage and resource instances.
961 * This procedure calls the required business processes such as scheduling the work order,material allocation , requisition generation for Direct items and for OSP items,cost re-estimation of work order.
962 * The API requires that you enter only the minimum necessary business information that defines your maintenance work order. The API will do the required defaulting for columns not filled in by users.
963 * The user can optionally provide the activity BOM and the activity routing in order to use the explosion feature of the API
964 * when you create Maintenance work order.
965 * In case of error ,API reports detailed and translatable error messages.
966 * @param p_bo_identifier Business Object Identifier
967 * @param p_api_version_number API Version Number
968 * @param p_init_msg_list 'TRUE' Clear the existing messages / 'FALSE' Retain the existing messages
969 * @param p_commit 'Y' Commit the api / 'N' Do not commit the api
970 * @param p_eam_wo_rec Maintenance Work order Record
971 * @param p_eam_op_tbl pl/sql table of Work order Operations
972 * @param p_eam_op_network_tbl pl/sql table of Work order Operation Network
973 * @param p_eam_res_tbl pl/sql table of Work order Resources
974 * @param p_eam_res_inst_tbl pl/sql table of Work order Resource Instances
975 * @param p_eam_sub_res_tbl pl/sql table of Work order Substitute Resources
976 * @param p_eam_res_usage_tbl pl/sql table of Work order Resource Usage
977 * @param p_eam_mat_req_tbl pl/sql table of Work order Material Requirements
978 * @param p_eam_direct_items_tbl pl/sql table of Work order Direct Items
979 * @param x_eam_wo_rec Changed Maintenance Work order Record
980 * @param x_eam_op_tbl Changed pl/sql table of Work order Operations
981 * @param x_eam_op_network_tbl Changed pl/sql table of Work order Operation Network
982 * @param x_eam_res_tbl Changed pl/sql table of Work order Resources
983 * @param x_eam_res_inst_tbl Changed pl/sql table of Work order Resource Instances
984 * @param x_eam_sub_res_tbl Changed pl/sql table of Work order Substitute Resources
985 * @param x_eam_res_usage_tbl Changed pl/sql table of Work order Resource Usage
986 * @param x_eam_mat_req_tbl Changed pl/sql table of Work order Material Requirements
987 * @param x_eam_direct_items_tbl Changed pl/sql table of Work order Direct Items
988 * @param x_return_status Return status of work order creation 'S' Success /'E' Error /'F' Fatal Error /'U' Unexpected Error
989 * @param x_msg_count Error message count count=0 indicates no error
990 * @param p_debug 'Y' Log debug messages / 'N' Do not log debug messages
991 * @param p_output_dir Directory for the debug file
992 * @param p_debug_filename Name of the debug file
993 * @param p_debug_file_mode 'w' Write / 'a' Append
994 * @rep:scope public
995 * @rep:lifecycle active
996 * @rep:displayname Asset Maintenance Single Work Order Creation
997 */
998
999
1000
1001
1002 PROCEDURE PROCESS_WO
1003 ( p_bo_identifier IN VARCHAR2 := 'EAM'
1004 , p_api_version_number IN NUMBER := 1.0
1005 , p_init_msg_list IN BOOLEAN := FALSE
1006 , p_commit IN VARCHAR2 := 'N'
1007 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1008 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1009 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1010 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1011 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1012 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1013 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1014 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1015 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1016 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1017 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1018 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1019 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1020 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1021 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1022 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1023 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1024 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1025 , x_return_status OUT NOCOPY VARCHAR2
1026 , x_msg_count OUT NOCOPY NUMBER
1027 , p_debug IN VARCHAR2 := 'N'
1028 , p_output_dir IN VARCHAR2 := NULL
1029 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
1030 , p_debug_file_mode IN VARCHAR2 := 'w'
1031 );
1032
1033
1034 -- overloaded for safety permit project(permits)
1035
1036 PROCEDURE PROCESS_WO
1037 ( p_bo_identifier IN VARCHAR2 := 'EAM'
1038 , p_api_version_number IN NUMBER := 1.0
1039 , p_init_msg_list IN BOOLEAN := FALSE
1040 , p_commit IN VARCHAR2 := 'N'
1041 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1042 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1043 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1044 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1045 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1046 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1047 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1048 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1049 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1050 , p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1051 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1052 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1053 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1054 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1055 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1056 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1057 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
1058 , p_eam_permit_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_tbl_type -- new param for safety permit
1059 , p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type -- new param for safety permit
1060 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1061 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1062 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1063 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1064 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1065 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1066 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1067 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1068 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1069 , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1070 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1071 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1072 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1073 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1074 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1075 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1076 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
1077 , x_return_status OUT NOCOPY VARCHAR2
1078 , x_msg_count OUT NOCOPY NUMBER
1079 , p_debug IN VARCHAR2 := 'N'
1080 , p_output_dir IN VARCHAR2 := NULL
1081 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
1082 , p_debug_file_mode IN VARCHAR2 := 'w'
1083 );
1084
1085 -- overloaded for safety permit project(permits and wc)
1086
1087 PROCEDURE PROCESS_WO
1088 ( p_bo_identifier IN VARCHAR2 := 'EAM'
1089 , p_api_version_number IN NUMBER := 1.0
1090 , p_init_msg_list IN BOOLEAN := FALSE
1091 , p_commit IN VARCHAR2 := 'N'
1092 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1093 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1094 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1095 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1096 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1097 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1098 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1099 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1100 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1101 , p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1102 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1103 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1104 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1105 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1106 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1107 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1108 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
1109 ,p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type
1110 ,p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
1111 ,p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type
1112 ,p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
1113 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1114 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1115 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1116 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1117 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1118 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1119 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1120 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1121 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1122 , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1123 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1124 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1125 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1126 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1127 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1128 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1129 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
1130 , x_return_status OUT NOCOPY VARCHAR2
1131 , x_msg_count OUT NOCOPY NUMBER
1132 , p_debug IN VARCHAR2 := 'N'
1133 , p_output_dir IN VARCHAR2 := NULL
1134 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
1135 , p_debug_file_mode IN VARCHAR2 := 'w'
1136 );
1137
1138 /*#
1139 * This procedure is used to create/update multiple Maintenance Work Orders.
1140 * User can create/update/delete the relationship between the work orders.
1141 * For all the work orders ,user can create /update /delete, the work order operations,operation networks ,materials,direct items, resources, resource usage and resource instances.
1142 * The API calls the required business processes such as scheduling the work order,material allocation , requisition generation for Direct items and for OSP items,cost re-estimation of work order.
1143 * The API requires you to enter only the minimum necessary business information that defines your maintenance work order. The API will do the required defaulting for columns not filled in by users.
1144 * The user can optionally provide the activity BOM and the activity routing in order to use the explosion feature of the API
1145 * when you create Maintenance work order.
1146 * In case of error ,API reports detailed and translatable error messages .
1147 * @param p_bo_identifier Business Object Identifier
1148 * @param p_api_version_number API Version Number
1149 * @param p_init_msg_list 'TRUE' Clear the existing messages / 'FALSE' Retain the existing messages
1150 * @param p_eam_wo_relations_tbl pl/sql table of Work order Relationships
1151 * @param p_eam_wo_tbl pl/sql table of Maintenance Work orders
1152 * @param p_eam_op_tbl pl/sql table of Work order Operations
1153 * @param p_eam_op_network_tbl pl/sql table of Work order Operation Network
1154 * @param p_eam_res_tbl pl/sql table of Work order Resources
1155 * @param p_eam_res_inst_tbl pl/sql table of Work order Resource Instances
1156 * @param p_eam_sub_res_tbl pl/sql table of Work order Substitute Resources
1157 * @param p_eam_mat_req_tbl pl/sql table of Work order Material Requirements
1158 * @param p_eam_direct_items_tbl pl/sql table of Work order Direct Items
1159 * @param x_eam_wo_tbl Changed pl/sql table of Maintenance Work orders
1160 * @param x_eam_wo_relations_tbl Changed pl/sql table of Work order Relationships
1161 * @param x_eam_op_tbl Changed pl/sql table of Work order Operations
1162 * @param x_eam_op_network_tbl Changed pl/sql table of Work order Operation Network
1163 * @param x_eam_res_tbl Changed pl/sql table of Work order Resources
1164 * @param x_eam_res_inst_tbl Changed pl/sql table of Work order Resource Instances
1165 * @param x_eam_sub_res_tbl Changed pl/sql table of Work order Substitute Resources
1166 * @param x_eam_mat_req_tbl Changed pl/sql table of Work order Material Requirements
1167 * @param x_eam_direct_items_tbl Changed pl/sql table of Work order Direct Items
1168 * @param x_return_status Return status of work order creation 'S' Success /'E' Error /'F' Fatal Error /'U' Unexpected Error / 'N' Not Processed
1169 * @param x_msg_count Error message count count=0 indicates no error
1170 * @param p_commit 'Y' Commit the api / 'N' Do not commit the api
1171 * @param p_debug 'Y' Log debug messages / 'N' Do not log debug messages
1172 * @param p_output_dir Directory for the debug file
1173 * @param p_debug_filename Name of the debug file
1174 * @param p_debug_file_mode 'w' Write / 'a' Append
1175 * @rep:scope public
1176 * @rep:lifecycle active
1177 * @rep:displayname Asset Maintenance Multiple Work Orders Creation
1178 */
1179
1180 PROCEDURE PROCESS_MASTER_CHILD_WO
1181 ( p_bo_identifier IN VARCHAR2 := 'EAM'
1182 , p_api_version_number IN NUMBER := 1.0
1183 , p_init_msg_list IN BOOLEAN := FALSE
1184 , p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
1185 , p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type
1186 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1187 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1188 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1189 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1190 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1191 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1192 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1193 , x_eam_wo_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type
1194 , x_eam_wo_relations_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
1195 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1196 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1197 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1198 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1199 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1200 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1201 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1202 , x_return_status OUT NOCOPY VARCHAR2
1203 , x_msg_count OUT NOCOPY NUMBER
1204 , p_commit IN VARCHAR2 := 'N'
1205 , p_debug IN VARCHAR2 := 'N'
1206 , p_output_dir IN VARCHAR2 := NULL
1207 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
1208 , p_debug_file_mode IN VARCHAR2 := 'w'
1209 );
1210
1211
1212
1213
1214 PROCEDURE DELETE_RELATIONSHIP
1215 ( p_api_version IN NUMBER
1216 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1217 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1218 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1219
1220 , p_parent_object_id IN NUMBER
1221 , p_parent_object_type_id IN NUMBER
1222 , p_child_object_id IN NUMBER
1223 , p_child_object_type_id IN NUMBER
1224 , p_new_parent_object_id IN NUMBER
1225 , p_new_parent_object_type_id IN NUMBER
1226
1227 , x_return_status OUT NOCOPY VARCHAR2
1228 , x_msg_count OUT NOCOPY NUMBER
1229 , x_msg_data OUT NOCOPY VARCHAR2
1230 );
1231
1232 G_MISS_EAM_WO_REC EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1233 G_MISS_EAM_OP_REC EAM_PROCESS_WO_PUB.eam_op_rec_type;
1234 G_MISS_EAM_OP_TBL EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1235 G_MISS_EAM_OP_NETWORK_REC EAM_PROCESS_WO_PUB.eam_op_network_rec_type;
1236 G_MISS_EAM_OP_NETWORK_TBL EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1237 G_MISS_EAM_RES_REC EAM_PROCESS_WO_PUB.eam_res_rec_type;
1238 G_MISS_EAM_RES_TBL EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1239 G_MISS_EAM_RES_INST_REC EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
1240 G_MISS_EAM_RES_INST_TBL EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1241 G_MISS_EAM_SUB_RES_REC EAM_PROCESS_WO_PUB.eam_sub_res_rec_type;
1242 G_MISS_EAM_SUB_RES_TBL EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1243 G_MISS_EAM_RES_USAGE_REC EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
1244 G_MISS_EAM_RES_USAGE_TBL EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1245 G_MISS_EAM_MAT_REQ_REC EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
1246 G_MISS_EAM_MAT_REQ_TBL EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1247 G_MISS_EAM_DIRECT_ITEMS_TBL EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1248 G_MISS_EAM_WO_COMP_REC EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1249 G_MISS_EAM_OP_COMP_REC EAM_PROCESS_WO_PUB.eam_op_comp_rec_type;
1250
1251 G_MISS_EAM_COMP_WO_REC EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
1252 G_MISS_EAM_WO_QUALITY_TBL EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1253 G_MISS_EAM_METER_READING_TBL EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1254 G_MISS_EAM_COUNTER_PROP_TBL EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1255 G_MISS_EAM_WO_COMP_REBUILD_TBL EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1256 G_MISS_EAM_WO_COMP_MR_READ_TBL EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1257 G_MISS_EAM_OP_COMP_TBL EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1258 G_MISS_EAM_REQUEST_TBL EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1259
1260
1261
1262 PROCEDURE EXPLODE_ACTIVITY
1263 ( p_api_version IN NUMBER := 1.0
1264 , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1265 , p_commit IN VARCHAR2 := fnd_api.g_false
1266 , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1267 , p_organization_id IN NUMBER
1268 , p_asset_activity_id IN NUMBER
1269 , p_wip_entity_id IN NUMBER
1270 , p_start_date IN DATE
1271 , p_completion_date IN DATE
1272 , p_rev_datetime IN DATE := SYSDATE
1273 , p_entity_type IN NUMBER := 6
1274 , x_return_status OUT NOCOPY VARCHAR2
1275 , x_msg_count OUT NOCOPY NUMBER
1276 , x_msg_data OUT NOCOPY VARCHAR2
1277 );
1278
1279
1280 PROCEDURE CHECK_BO_RECORD
1281 ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1282 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1283 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1284 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1285 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1286 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1287 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1288 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1289 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1290 , p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
1291 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1292 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1293 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1294 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1295 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1296 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1297 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
1298 , x_return_status OUT NOCOPY VARCHAR2
1299 );
1300
1301
1302 PROCEDURE CHECK_BO_NETWORK
1303 ( p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type
1304 , p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
1305 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
1306 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1307 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
1308 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1309 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1310 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1311 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1312 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1313 , p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type
1314 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1315 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1316 , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1317 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1318 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1319 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1320 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
1321 , x_eam_wo_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_tbl_type
1322 , x_eam_wo_relations_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type
1323 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1324 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1325 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1326 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1327 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
1328 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1329 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1330 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1331 , x_eam_wo_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type
1332 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
1333 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
1334 , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
1335 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
1336 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
1337 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
1338 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
1339 , x_batch_id OUT NOCOPY NUMBER
1340 , x_header_id_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.header_id_tbl_type
1341 , x_return_status OUT NOCOPY VARCHAR2
1342 );
1343
1344 PROCEDURE COPY_WORKORDER
1345 ( p_bo_identifier IN VARCHAR2 := 'EAM'
1346 , p_api_version_number IN NUMBER := 1.0
1347 , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1348 , p_commit IN VARCHAR2 := fnd_api.g_false
1349 , p_wip_entity_id IN NUMBER
1350 , p_organization_id IN NUMBER
1351 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1352 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
1353 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
1354 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
1355 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
1356 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
1357 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
1358 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
1359 , x_return_status OUT NOCOPY VARCHAR2
1360 , x_msg_count OUT NOCOPY NUMBER
1361 );
1362
1363 /* Added for bug#4563210 to add work order creation confirmation message,
1364 * while work order scheduling relationship creation fails */
1365 Type eam_wo_list_type is table of varchar2(240) INDEX BY BINARY_INTEGER;
1366 l_eam_wo_list eam_wo_list_type;
1367
1368
1369 /* This procedure is used to make an entry in wip_eam_direct_items
1370 when a Purchase Requisition/Purchase Order is created for description direct items in
1371 Purchasing using forms.
1372 Bug 8450377
1373 */
1374
1375 PROCEDURE UPDATE_WO_ADD_DES_DIR_ITEM
1376 ( p_wip_entity_id IN NUMBER
1377 , p_operation_seq_num IN NUMBER
1378 , p_inventory_item_id IN NUMBER
1379 , p_description IN VARCHAR2
1380 , p_organization_id IN NUMBER
1381 , p_purchasing_category_id IN NUMBER
1382 , p_suggested_vendor_name IN VARCHAR2 := NULL
1383 , p_suggested_vendor_id IN NUMBER := NULL
1384 , p_suggested_vendor_site IN VARCHAR2 := NULL
1385 , p_suggested_vendor_site_id IN NUMBER := NULL
1386 , p_suggested_vendor_contact IN VARCHAR2 := NULL
1387 , p_suggested_vendor_contact_id IN NUMBER := NULL
1388 , p_suggested_vendor_phone IN VARCHAR2 := NULL
1389 , p_suggested_vendor_item_num IN VARCHAR2 := NULL
1390 , p_required_quantity IN NUMBER
1391 , p_unit_price IN NUMBER
1392 , p_uom IN VARCHAR2
1393 , p_need_by_date IN DATE
1394 , p_amount IN NUMBER
1395 , p_order_type_lookup_code IN VARCHAR2
1396 , x_direct_item_sequence_id IN OUT NOCOPY NUMBER
1397 , x_return_status OUT NOCOPY VARCHAR2
1398 );
1399
1400 END EAM_PROCESS_WO_PUB;