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