1 PACKAGE MTH_UPDATE_ERR_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthuerrs.pls 120.0.12020000.3 2012/10/08 12:33:55 sasuren noship $*/
3
4 PROCEDURE UPD_ASSET_ERR (
5 p_err_code IN VARCHAR2,
6 p_reprocess_ready_yn IN VARCHAR2,
7 p_asset_pk IN VARCHAR2,
8 p_asset_number IN VARCHAR2,
9 p_asset_group IN VARCHAR2,
10 p_maintenance_org_code IN VARCHAR2,
11 p_asset_group_id IN NUMBER,
12 p_system_fk IN VARCHAR2,
13 p_asset_description IN VARCHAR2,
14 p_serial_number IN VARCHAR2,
15 p_asset_category IN VARCHAR2,
16 p_owning_department IN VARCHAR2,
17 p_asset_criticality IN VARCHAR2,
18 p_active_flag IN VARCHAR2,
19 p_maintainable_flag IN VARCHAR2,
20 p_mttr IN NUMBER,
21 p_mtbf IN NUMBER,
22 p_asset_location IN VARCHAR2,
23 p_user_attr1 IN VARCHAR2,
24 p_user_attr2 IN VARCHAR2,
25 p_user_attr3 IN VARCHAR2,
26 p_user_attr4 IN VARCHAR2,
27 p_user_attr5 IN VARCHAR2,
28 p_user_measure1 IN NUMBER,
29 p_user_measure2 IN NUMBER,
30 p_user_measure3 IN NUMBER,
31 p_user_measure4 IN NUMBER,
32 p_user_measure5 IN NUMBER,
33 p_rowid IN ROWID
34 );
35
36 PROCEDURE UPD_DAY_ERR (
37 p_err_code IN VARCHAR2,
38 p_reprocess_ready_yn IN VARCHAR2,
39 p_report_date IN VARCHAR2,
40 p_user_attr1 IN VARCHAR2,
41 p_user_attr2 IN VARCHAR2,
42 p_user_attr3 IN VARCHAR2,
43 p_user_attr4 IN VARCHAR2,
44 p_user_attr5 IN VARCHAR2,
45 p_user_measure1 IN NUMBER,
46 p_user_measure2 IN NUMBER,
47 p_user_measure3 IN NUMBER,
48 p_user_measure4 IN NUMBER,
49 p_user_measure5 IN NUMBER,
50 p_system_fk IN VARCHAR2,
51 p_rowid IN ROWID
52 );
53
54 PROCEDURE UPD_DIM_HIERARCHY_ERR (
55 p_err_code IN VARCHAR2,
56 p_reprocess_ready_yn IN VARCHAR2,
57 p_dimension_name IN VARCHAR2,
58 p_hierarchy_name IN VARCHAR2,
59 p_category_set_name IN VARCHAR2,
60 p_hierarchy_display_name IN VARCHAR2,
61 p_number_of_level IN NUMBER,
62 p_processing_flag IN NUMBER,
63 p_rowid IN ROWID
64 );
65
66 PROCEDURE UPD_DIM_LEVEL_LOOKUP_ERR (
67 p_err_code IN VARCHAR2,
68 p_reprocess_ready_yn IN VARCHAR2,
69 p_hierarchy_name IN VARCHAR2,
70 p_dimension_name IN VARCHAR2,
71 p_level_num IN NUMBER,
72 p_level_type IN VARCHAR2,
73 p_level_name IN VARCHAR2,
74 p_rowid IN ROWID
75 );
76
77 PROCEDURE UPD_ENTITY_PLANNED_USAGE_ERR (
78 p_err_code IN VARCHAR2,
79 p_reprocess_ready_yn IN VARCHAR2,
80 p_entity_fk IN VARCHAR2,
81 p_sustain_aspect_fk IN VARCHAR2,
82 p_period_of_usage IN VARCHAR2,
83 p_entity_type IN VARCHAR2,
84 p_planned_usage IN NUMBER,
85 p_rowid IN ROWID
86 );
87
88 PROCEDURE UPD_EQUIPMENTS_ERR (
89 p_err_code IN VARCHAR2,
90 p_reprocess_ready_yn IN VARCHAR2,
91 p_equipment_pk IN VARCHAR2,
92 p_ebs_organization_id IN NUMBER,
93 p_ebs_equipment_id IN NUMBER,
94 p_system_fk IN VARCHAR2,
95 p_user_attr1 IN VARCHAR2,
96 p_user_attr2 IN VARCHAR2,
97 p_user_attr3 IN VARCHAR2,
98 p_user_attr4 IN VARCHAR2,
99 p_user_attr5 IN VARCHAR2,
100 p_user_measure1 IN NUMBER,
101 p_user_measure2 IN NUMBER,
102 p_user_measure3 IN NUMBER,
103 p_user_measure4 IN NUMBER,
104 p_user_measure5 IN NUMBER,
105 p_fixed_asset_value IN NUMBER,
106 p_equipment_name IN VARCHAR2,
107 p_equipment_description IN VARCHAR2,
108 p_source_org_code IN VARCHAR2,
109 p_std_utilization IN NUMBER,
110 p_std_efficiency IN NUMBER,
111 p_equipment_criticality IN VARCHAR2,
112 p_serial_number IN VARCHAR2,
113 p_production_equipment IN VARCHAR2,
114 p_equipment_manufacturer IN VARCHAR2,
115 p_model_number IN VARCHAR2,
116 p_installation_date IN VARCHAR2,
117 p_last_calibrated IN VARCHAR2,
118 p_power_rating IN NUMBER,
119 p_standard_capacity IN NUMBER,
120 p_std_cycle_time IN NUMBER,
121 p_status IN VARCHAR2,
122 p_location IN VARCHAR2,
123 p_rowid IN ROWID
124 );
125
126 PROCEDURE UPD_EQUIPMENT_REASON_SETUP_ERR (
127 p_err_code IN VARCHAR2,
128 p_reprocess_ready_yn IN VARCHAR2,
129 p_equipment_fk IN VARCHAR2,
130 p_reason_type IN NUMBER,
131 p_reason_code IN VARCHAR2,
132 p_expected_up_time IN NUMBER,
133 p_rowid IN ROWID
134 );
135
136 PROCEDURE UPD_EQUIPMENT_SHIFTS_ERR (
137 p_err_code IN VARCHAR2,
138 p_reprocess_ready_yn IN VARCHAR2,
139 p_entity_pk IN VARCHAR2,
140 p_entity_type IN VARCHAR2,
141 p_line_num IN NUMBER,
142 p_from_date IN VARCHAR2,
143 p_to_date IN VARCHAR2,
144 p_shift_workday_fk IN VARCHAR2,
145 p_availability_flag IN VARCHAR2,
146 p_reason IN VARCHAR2,
147 p_rowid IN ROWID
148 );
149
150 PROCEDURE UPD_EQUIP_ENTITIES_ERR (
151 p_err_code IN VARCHAR2,
152 p_reprocess_ready_yn IN VARCHAR2,
153 p_entity_pk IN VARCHAR2,
154 p_entity_name IN VARCHAR2,
155 p_entity_type IN VARCHAR2,
156 p_system_fk IN VARCHAR2,
157 p_source_org_code IN VARCHAR2,
158 p_production_entity IN VARCHAR2,
159 p_business_function IN VARCHAR2,
160 p_description IN VARCHAR2,
161 p_status IN VARCHAR2,
162 p_area IN NUMBER,
163 p_head_count IN NUMBER,
164 p_effective_date IN VARCHAR2,
165 p_user_attr1 IN VARCHAR2,
166 p_user_attr2 IN VARCHAR2,
167 p_user_attr3 IN VARCHAR2,
168 p_user_attr4 IN VARCHAR2,
169 p_user_attr5 IN VARCHAR2,
170 p_user_measure1 IN NUMBER,
171 p_user_measure2 IN NUMBER,
172 p_user_measure3 IN NUMBER,
173 p_user_measure4 IN NUMBER,
174 p_user_measure5 IN NUMBER,
175 p_rowid IN ROWID
176 );
177
178 PROCEDURE UPD_EQUIP_HIERARCHY_ERR (
179 p_err_code IN VARCHAR2,
180 p_reprocess_ready_yn IN VARCHAR2,
181 p_hierarchy_name IN VARCHAR2,
182 p_level_num IN NUMBER,
183 p_level_fk IN VARCHAR2,
184 p_parent_fk IN VARCHAR2,
185 p_system_fk IN VARCHAR2,
186 p_effective_date IN VARCHAR2,
187 p_rowid IN ROWID
188 );
189
190 PROCEDURE UPD_EQUIP_OUTPUT_ERR (
191 p_err_code IN VARCHAR2,
192 p_reprocess_ready_yn IN VARCHAR2,
193 p_equipment_fk IN VARCHAR2,
194 p_item_fk IN VARCHAR2,
195 p_shift_workday_fk IN VARCHAR2,
196 p_workorder_fk IN VARCHAR2,
197 p_reading_time IN VARCHAR2,
198 p_qty_completed IN NUMBER,
199 p_qty_scrap IN NUMBER,
200 p_qty_rejected IN NUMBER,
201 p_qty_rework IN NUMBER,
202 p_qty_uom IN VARCHAR2,
203 p_qty_good IN NUMBER,
204 p_qty_output IN NUMBER,
205 p_system_fk IN VARCHAR2,
206 p_user_dim1_fk IN VARCHAR2,
207 p_user_dim2_fk IN VARCHAR2,
208 p_user_dim3_fk IN VARCHAR2,
209 p_user_dim4_fk IN VARCHAR2,
210 p_user_dim5_fk IN VARCHAR2,
211 p_user_attr1 IN VARCHAR2,
212 p_user_attr2 IN VARCHAR2,
213 p_user_attr3 IN VARCHAR2,
214 p_user_attr4 IN VARCHAR2,
215 p_user_attr5 IN VARCHAR2,
216 p_user_measure1 IN NUMBER,
217 p_user_measure2 IN NUMBER,
218 p_user_measure3 IN NUMBER,
219 p_user_measure4 IN NUMBER,
220 p_user_measure5 IN NUMBER,
221 p_recipe_num IN VARCHAR2,
222 p_recipe_version IN VARCHAR2,
223 p_segment_fk IN VARCHAR2,
224 p_scrap_reason_code IN VARCHAR2,
225 p_rowid IN ROWID
226 );
227
228 PROCEDURE UPD_EQUIP_PROD_SCHEDULE_ERR (
229 p_err_code IN VARCHAR2,
230 p_reprocess_ready_yn IN VARCHAR2,
231 p_equip_schedule_pk IN VARCHAR2,
232 p_equipment_fk IN VARCHAR2,
233 p_workorder_fk IN VARCHAR2,
234 p_segment_fk IN VARCHAR2,
235 p_shift_workday_fk IN VARCHAR2,
236 p_item_fk IN VARCHAR2,
237 p_schedule_from_date IN VARCHAR2,
241 p_primary_uom IN VARCHAR2,
238 p_schedule_to_date IN VARCHAR2,
239 p_planned_qty_g IN NUMBER,
240 p_planned_qty_sg IN NUMBER,
242 p_secondary_uom IN VARCHAR2,
243 p_system_fk IN VARCHAR2,
244 p_user_dim1_fk IN VARCHAR2,
245 p_user_dim2_fk IN VARCHAR2,
246 p_user_dim3_fk IN VARCHAR2,
247 p_user_dim4_fk IN VARCHAR2,
248 p_user_dim5_fk IN VARCHAR2,
249 p_user_attr1 IN VARCHAR2,
250 p_user_attr2 IN VARCHAR2,
251 p_user_attr3 IN VARCHAR2,
252 p_user_attr4 IN VARCHAR2,
253 p_user_attr5 IN VARCHAR2,
254 p_user_measure1 IN NUMBER,
255 p_user_measure2 IN NUMBER,
256 p_user_measure3 IN NUMBER,
257 p_user_measure4 IN NUMBER,
258 p_user_measure5 IN NUMBER,
259 p_rowid IN ROWID
260 );
261
262 PROCEDURE UPD_EQUIP_STANDARD_RATES_ERR (
263 p_err_code IN VARCHAR2,
264 p_reprocess_ready_yn IN VARCHAR2,
265 p_equipment_fk IN VARCHAR2,
266 p_shift_workday_fk IN VARCHAR2,
267 p_item_fk IN VARCHAR2,
268 p_standard_rate_1 IN NUMBER,
269 p_standard_rate_2 IN NUMBER,
270 p_standard_rate_3 IN NUMBER,
271 p_source_org_code IN VARCHAR2,
272 p_system_fk IN VARCHAR2,
273 p_user_dim1_fk IN VARCHAR2,
274 p_user_dim2_fk IN VARCHAR2,
275 p_user_dim3_fk IN VARCHAR2,
276 p_user_dim4_fk IN VARCHAR2,
277 p_user_dim5_fk IN VARCHAR2,
278 p_user_attr1 IN VARCHAR2,
279 p_user_attr2 IN VARCHAR2,
280 p_user_attr3 IN VARCHAR2,
281 p_user_attr4 IN VARCHAR2,
282 p_user_attr5 IN VARCHAR2,
283 p_user_measure1 IN NUMBER,
284 p_user_measure2 IN NUMBER,
285 p_user_measure3 IN NUMBER,
286 p_user_measure4 IN NUMBER,
287 p_user_measure5 IN NUMBER,
288 p_recipe_num IN VARCHAR2,
289 p_recipe_version IN VARCHAR2,
290 p_rowid IN ROWID
291 );
292
293 PROCEDURE UPD_EQUIP_STATUSES_ERR (
294 p_err_code IN VARCHAR2,
295 p_reprocess_ready_yn IN VARCHAR2,
296 p_equipment_fk IN VARCHAR2,
297 p_shift_workday_fk IN VARCHAR2,
298 p_from_date IN VARCHAR2,
299 p_to_date IN VARCHAR2,
300 p_status IN VARCHAR2,
301 p_system_fk IN VARCHAR2,
302 p_user_dim1_fk IN VARCHAR2,
303 p_user_dim2_fk IN VARCHAR2,
304 p_user_dim3_fk IN VARCHAR2,
305 p_user_dim4_fk IN VARCHAR2,
306 p_user_dim5_fk IN VARCHAR2,
307 p_user_attr1 IN VARCHAR2,
308 p_user_attr2 IN VARCHAR2,
309 p_user_attr3 IN VARCHAR2,
310 p_user_attr4 IN VARCHAR2,
311 p_user_attr5 IN VARCHAR2,
312 p_user_measure1 IN NUMBER,
313 p_user_measure2 IN NUMBER,
314 p_user_measure3 IN NUMBER,
315 p_user_measure4 IN NUMBER,
316 p_user_measure5 IN NUMBER,
317 p_downtime_reason_code IN VARCHAR2,
318 p_rowid IN ROWID
319 );
320
321 PROCEDURE UPD_EVENT_ACTION_SETUP_ERR (
322 p_err_code IN VARCHAR2,
323 p_reprocess_ready_yn IN VARCHAR2,
324 p_equipment_fk IN VARCHAR2,
325 p_event_type_code IN VARCHAR2,
326 p_reason_code IN VARCHAR2,
327 p_action_type_code IN VARCHAR2,
328 p_personnel_fk IN VARCHAR2,
329 p_action_handler_code IN VARCHAR2,
330 p_email_notification IN VARCHAR2,
331 p_mobile_notification IN VARCHAR2,
332 p_domain_name IN VARCHAR2,
333 p_rowid IN ROWID
334 );
335
336 PROCEDURE UPD_ITEMS_ERR (
337 p_err_code IN VARCHAR2,
338 p_reprocess_ready_yn IN VARCHAR2,
339 p_item_pk IN VARCHAR2,
340 p_system_fk IN VARCHAR2,
341 p_source_org_code IN VARCHAR2,
342 p_item_name IN VARCHAR2,
343 p_primary_uom IN VARCHAR2,
344 p_secondary_uom IN VARCHAR2,
345 p_ebs_item_id IN NUMBER,
346 p_ebs_org_id IN NUMBER,
347 p_description IN VARCHAR2,
351 p_volume_uom IN VARCHAR2,
348 p_unit_weight IN NUMBER,
349 p_weight_uom IN VARCHAR2,
350 p_unit_volume IN NUMBER,
352 p_base_item IN VARCHAR2,
353 p_user_attr1 IN VARCHAR2,
354 p_user_attr2 IN VARCHAR2,
355 p_user_attr3 IN VARCHAR2,
356 p_user_attr4 IN VARCHAR2,
357 p_user_attr5 IN VARCHAR2,
358 p_user_attr6 IN VARCHAR2,
359 p_user_attr7 IN VARCHAR2,
360 p_user_attr8 IN VARCHAR2,
361 p_user_attr9 IN VARCHAR2,
362 p_user_attr10 IN VARCHAR2,
363 p_user_attr11 IN VARCHAR2,
364 p_user_attr12 IN VARCHAR2,
365 p_user_attr13 IN VARCHAR2,
366 p_user_attr14 IN VARCHAR2,
367 p_user_attr15 IN VARCHAR2,
368 p_user_attr16 IN VARCHAR2,
369 p_user_attr17 IN VARCHAR2,
370 p_user_attr18 IN VARCHAR2,
371 p_user_attr19 IN VARCHAR2,
372 p_user_attr20 IN VARCHAR2,
373 p_user_measure1 IN NUMBER,
374 p_user_measure2 IN NUMBER,
375 p_user_measure3 IN NUMBER,
376 p_user_measure4 IN NUMBER,
377 p_user_measure5 IN NUMBER,
378 p_user_attr21 IN VARCHAR2,
379 p_user_attr22 IN VARCHAR2,
380 p_user_attr23 IN VARCHAR2,
381 p_user_attr24 IN VARCHAR2,
382 p_user_attr25 IN VARCHAR2,
383 p_user_attr26 IN VARCHAR2,
384 p_user_attr27 IN VARCHAR2,
385 p_user_attr28 IN VARCHAR2,
386 p_user_attr29 IN VARCHAR2,
387 p_user_attr30 IN VARCHAR2,
388 p_rowid IN ROWID
389 );
390
391 PROCEDURE UPD_ITEM_CATEGORIES_ERR (
392 p_err_code IN VARCHAR2,
393 p_reprocess_ready_yn IN VARCHAR2,
394 p_category_pk IN VARCHAR2,
395 p_system_fk IN VARCHAR2,
396 p_category_name IN VARCHAR2,
397 p_description IN VARCHAR2,
398 p_ebs_category_id IN NUMBER,
399 p_user_attr1 IN VARCHAR2,
400 p_user_attr2 IN VARCHAR2,
401 p_user_attr3 IN VARCHAR2,
402 p_user_attr4 IN VARCHAR2,
403 p_user_attr5 IN VARCHAR2,
404 p_user_measure1 IN NUMBER,
405 p_user_measure2 IN NUMBER,
406 p_user_measure3 IN NUMBER,
407 p_user_measure4 IN NUMBER,
408 p_user_measure5 IN NUMBER,
409 p_segment1 IN VARCHAR2,
410 p_segment2 IN VARCHAR2,
411 p_segment3 IN VARCHAR2,
412 p_segment4 IN VARCHAR2,
413 p_segment5 IN VARCHAR2,
414 p_segment6 IN VARCHAR2,
415 p_segment7 IN VARCHAR2,
416 p_segment8 IN VARCHAR2,
417 p_segment9 IN VARCHAR2,
418 p_segment10 IN VARCHAR2,
419 p_segment11 IN VARCHAR2,
420 p_segment12 IN VARCHAR2,
421 p_segment13 IN VARCHAR2,
422 p_segment14 IN VARCHAR2,
423 p_segment15 IN VARCHAR2,
424 p_segment16 IN VARCHAR2,
425 p_segment17 IN VARCHAR2,
426 p_segment18 IN VARCHAR2,
427 p_segment19 IN VARCHAR2,
428 p_segment20 IN VARCHAR2,
429 p_rowid IN ROWID
430 );
431
432 PROCEDURE UPD_ITEM_COST_ERR (
433 p_err_code IN VARCHAR2,
434 p_reprocess_ready_yn IN VARCHAR2,
435 p_system_fk IN VARCHAR2,
436 p_item_fk IN VARCHAR2,
437 p_item_cost IN NUMBER,
438 p_from_date IN VARCHAR2,
439 p_to_date IN VARCHAR2,
440 p_cost_element IN VARCHAR2,
441 p_user_attr1 IN VARCHAR2,
442 p_user_attr2 IN VARCHAR2,
443 p_user_attr3 IN VARCHAR2,
444 p_user_attr4 IN VARCHAR2,
445 p_user_attr5 IN VARCHAR2,
446 p_rowid IN ROWID
447 );
448
449 PROCEDURE UPD_ITEM_HIERARCHY_ERR (
450 p_err_code IN VARCHAR2,
451 p_reprocess_ready_yn IN VARCHAR2,
452 p_level_fk IN VARCHAR2,
453 p_parent_fk IN VARCHAR2,
454 p_hierarchy_name IN VARCHAR2,
455 p_level_num IN NUMBER,
459
456 p_system_fk IN VARCHAR2,
457 p_rowid IN ROWID
458 );
460 PROCEDURE UPD_METER_READINGS_ERR (
461 p_err_code IN VARCHAR2,
462 p_reprocess_ready_yn IN VARCHAR2,
463 p_meter_readings_err_pk_key IN NUMBER,
464 p_meter_code IN VARCHAR2,
465 p_from_time IN VARCHAR2,
466 p_to_time IN VARCHAR2,
467 p_usage_value IN NUMBER,
468 p_tag_code IN VARCHAR2,
469 p_err_source IN NUMBER,
470 p_creation_date IN VARCHAR2,
471 p_last_update_date IN VARCHAR2,
472 p_rowid IN ROWID
473 );
474
475 PROCEDURE UPD_MTL_CONSUMED_TXN_LOT_ERR (
476 p_err_code IN VARCHAR2,
477 p_reprocess_ready_yn IN VARCHAR2,
478 p_wo_mat_txn_fk IN VARCHAR2,
479 p_product_lot IN VARCHAR2,
480 p_product_sublot IN VARCHAR2,
481 p_product_serial_no IN VARCHAR2,
482 p_transaction_qty IN NUMBER,
483 p_transaction_qty_g IN NUMBER,
484 p_transaction_qty_sg IN NUMBER,
485 p_transaction_uom IN VARCHAR2,
486 p_primary_uom IN VARCHAR2,
487 p_secondary_uom IN VARCHAR2,
488 p_material_lot IN VARCHAR2,
489 p_material_sublot IN VARCHAR2,
490 p_material_serial_no IN VARCHAR2,
491 p_system_fk IN VARCHAR2,
492 p_user_dim1_fk IN VARCHAR2,
493 p_user_dim2_fk IN VARCHAR2,
494 p_user_dim3_fk IN VARCHAR2,
495 p_user_dim4_fk IN VARCHAR2,
496 p_user_dim5_fk IN VARCHAR2,
497 p_user_attr1 IN VARCHAR2,
498 p_user_attr2 IN VARCHAR2,
499 p_user_attr3 IN VARCHAR2,
500 p_user_attr4 IN VARCHAR2,
501 p_user_attr5 IN VARCHAR2,
502 p_user_measure1 IN NUMBER,
503 p_user_measure2 IN NUMBER,
504 p_user_measure3 IN NUMBER,
505 p_user_measure4 IN NUMBER,
506 p_user_measure5 IN NUMBER,
507 p_grade IN VARCHAR2,
508 p_rowid IN ROWID
509 );
510
511 PROCEDURE UPD_MTL_PRODUCED_TXN_LOT_ERR (
512 p_err_code IN VARCHAR2,
513 p_reprocess_ready_yn IN VARCHAR2,
514 p_wo_comp_fk IN VARCHAR2,
515 p_transaction_qty IN NUMBER,
516 p_transaction_qty_g IN NUMBER,
517 p_transaction_qty_sg IN NUMBER,
518 p_product_lot IN VARCHAR2,
519 p_product_sublot IN VARCHAR2,
520 p_product_serial_no IN VARCHAR2,
521 p_transaction_uom IN VARCHAR2,
522 p_primary_uom IN VARCHAR2,
523 p_secondary_uom IN VARCHAR2,
524 p_system_fk IN VARCHAR2,
525 p_user_dim1_fk IN VARCHAR2,
526 p_user_dim2_fk IN VARCHAR2,
527 p_user_dim3_fk IN VARCHAR2,
528 p_user_dim4_fk IN VARCHAR2,
529 p_user_dim5_fk IN VARCHAR2,
530 p_user_attr1 IN VARCHAR2,
531 p_user_attr2 IN VARCHAR2,
532 p_user_attr3 IN VARCHAR2,
533 p_user_attr4 IN VARCHAR2,
534 p_user_attr5 IN VARCHAR2,
535 p_user_measure1 IN NUMBER,
536 p_user_measure2 IN NUMBER,
537 p_user_measure3 IN NUMBER,
538 p_user_measure4 IN NUMBER,
539 p_user_measure5 IN NUMBER,
540 p_grade IN VARCHAR2,
541 p_rowid IN ROWID
542 );
543
544 PROCEDURE UPD_PERIOD_ERR (
545 p_err_code IN VARCHAR2,
546 p_reprocess_ready_yn IN VARCHAR2,
547 p_hierarchy_name IN VARCHAR2,
548 p_name IN VARCHAR2,
549 p_user_attr1 IN VARCHAR2,
550 p_user_attr2 IN VARCHAR2,
551 p_user_attr3 IN VARCHAR2,
552 p_user_attr4 IN VARCHAR2,
553 p_user_attr5 IN VARCHAR2,
554 p_user_measure1 IN NUMBER,
555 p_user_measure2 IN NUMBER,
556 p_user_measure3 IN NUMBER,
557 p_user_measure4 IN NUMBER,
558 p_user_measure5 IN NUMBER,
559 p_system_fk IN VARCHAR2,
560 p_end_date IN VARCHAR2,
561 p_start_date IN VARCHAR2,
562 p_rowid IN ROWID
563 );
564
565 PROCEDURE UPD_PERSONNEL_ERR (
566 p_err_code IN VARCHAR2,
567 p_reprocess_ready_yn IN VARCHAR2,
571 p_first_name IN VARCHAR2,
568 p_personnel_pk IN VARCHAR2,
569 p_ebs_personnel_id IN NUMBER,
570 p_ebs_organization_id IN NUMBER,
572 p_last_name IN VARCHAR2,
573 p_system_fk IN VARCHAR2,
574 p_resource_fk IN VARCHAR2,
575 p_personnel_description IN VARCHAR2,
576 p_user_attr1 IN VARCHAR2,
577 p_user_attr2 IN VARCHAR2,
578 p_user_attr3 IN VARCHAR2,
579 p_user_attr4 IN VARCHAR2,
580 p_user_attr5 IN VARCHAR2,
581 p_user_measure1 IN NUMBER,
582 p_user_measure2 IN NUMBER,
583 p_user_measure3 IN NUMBER,
584 p_user_measure4 IN NUMBER,
585 p_user_measure5 IN NUMBER,
586 p_source_org_code IN VARCHAR2,
587 p_middle_name IN VARCHAR2,
588 p_known_as IN VARCHAR2,
589 p_full_name IN VARCHAR2,
590 p_title IN VARCHAR2,
591 p_sex IN VARCHAR2,
592 p_email_address IN VARCHAR2,
593 p_work_telephone IN VARCHAR2,
594 p_mobile_phone_number IN VARCHAR2,
595 p_effective_start_date IN VARCHAR2,
596 p_effective_end_date IN VARCHAR2,
597 p_rowid IN ROWID
598 );
599
600 PROCEDURE UPD_PRODUCTION_SCHEDULES_ERR (
601 p_err_code IN VARCHAR2,
602 p_reprocess_ready_yn IN VARCHAR2,
603 p_workorder_pk IN VARCHAR2,
604 p_system_fk IN VARCHAR2,
605 p_workorder_type IN NUMBER,
606 p_status IN VARCHAR2,
607 p_planned_start_date IN VARCHAR2,
608 p_planned_completion_date IN VARCHAR2,
609 p_actual_start_date IN VARCHAR2,
610 p_actual_completion_date IN VARCHAR2,
611 p_date_released IN VARCHAR2,
612 p_erp_actual_start_date IN VARCHAR2,
613 p_erp_actual_completion_date IN VARCHAR2,
614 p_ebs_entity_id IN NUMBER,
615 p_ebs_organization_id IN NUMBER,
616 p_bom_revision IN VARCHAR2,
617 p_routing_revision IN VARCHAR2,
618 p_bom_revision_date IN VARCHAR2,
619 p_routing_revision_date IN VARCHAR2,
620 p_alternate_bom_designator IN VARCHAR2,
621 p_alternate_routing_designator IN VARCHAR2,
622 p_completion_subinventory IN VARCHAR2,
623 p_completion_locator_id IN NUMBER,
624 p_demand_class IN VARCHAR2,
625 p_schedule_group_id IN NUMBER,
626 p_build_sequence IN NUMBER,
627 p_workorder_name IN VARCHAR2,
628 p_demand_source_header_id IN NUMBER,
629 p_demand_source_line IN VARCHAR2,
630 p_demand_source_delivery IN VARCHAR2,
631 p_demand_source_type IN NUMBER,
632 p_kanban_card_id IN NUMBER,
633 p_line_code IN VARCHAR2,
634 p_parent_workorder_id IN VARCHAR2,
635 p_parent_operation_seq_num IN NUMBER,
636 p_source_org_code IN VARCHAR2,
637 p_user_dim1_fk IN VARCHAR2,
638 p_user_dim2_fk IN VARCHAR2,
639 p_user_dim3_fk IN VARCHAR2,
640 p_user_dim4_fk IN VARCHAR2,
641 p_user_dim5_fk IN VARCHAR2,
642 p_user_attr1 IN VARCHAR2,
643 p_user_attr2 IN VARCHAR2,
644 p_user_attr3 IN VARCHAR2,
645 p_user_attr4 IN VARCHAR2,
646 p_user_attr5 IN VARCHAR2,
647 p_user_attr6 IN VARCHAR2,
648 p_user_attr7 IN VARCHAR2,
649 p_user_attr8 IN VARCHAR2,
650 p_user_attr9 IN VARCHAR2,
651 p_user_attr10 IN VARCHAR2,
652 p_user_attr11 IN VARCHAR2,
653 p_user_attr12 IN VARCHAR2,
654 p_user_attr13 IN VARCHAR2,
655 p_user_attr14 IN VARCHAR2,
656 p_user_attr15 IN VARCHAR2,
657 p_user_attr16 IN VARCHAR2,
658 p_user_attr17 IN VARCHAR2,
659 p_user_attr18 IN VARCHAR2,
660 p_user_attr19 IN VARCHAR2,
661 p_user_attr20 IN VARCHAR2,
662 p_user_measure1 IN NUMBER,
663 p_user_measure2 IN NUMBER,
664 p_user_measure3 IN NUMBER,
665 p_user_measure4 IN NUMBER,
666 p_user_measure5 IN NUMBER,
667 p_recipe_num IN VARCHAR2,
668 p_recipe_version IN VARCHAR2,
669 p_formula_num IN VARCHAR2,
670 p_formula_version IN VARCHAR2,
671 p_req_completion_date IN VARCHAR2,
672 p_batch_type IN VARCHAR2,
676
673 p_terminated_ind IN NUMBER,
674 p_rowid IN ROWID
675 );
677 PROCEDURE UPD_PRODUCTION_SEGMENTS_ERR (
678 p_err_code IN VARCHAR2,
679 p_reprocess_ready_yn IN VARCHAR2,
680 p_workorder_fk IN VARCHAR2,
681 p_segment_pk IN VARCHAR2,
682 p_item_fk IN VARCHAR2,
683 p_start_quantity_g IN NUMBER,
684 p_start_quantity_sg IN NUMBER,
685 p_primary_uom IN VARCHAR2,
686 p_secondary_uom IN VARCHAR2,
687 p_actual_comp_qty_g IN NUMBER,
688 p_actual_comp_qty_sg IN NUMBER,
689 p_actual_rejected_qty_g IN NUMBER,
690 p_actual_reworked_qty_g IN NUMBER,
691 p_actual_scrap_qty_g IN NUMBER,
692 p_actual_rejected_qty_sg IN NUMBER,
693 p_actual_reworked_qty_sg IN NUMBER,
694 p_actual_scrap_qty_sg IN NUMBER,
695 p_actual_start_date IN VARCHAR2,
696 p_actual_completion_date IN VARCHAR2,
697 p_system_fk IN VARCHAR2,
698 p_user_dim1_fk IN VARCHAR2,
699 p_user_dim2_fk IN VARCHAR2,
700 p_user_dim3_fk IN VARCHAR2,
701 p_user_dim4_fk IN VARCHAR2,
702 p_user_dim5_fk IN VARCHAR2,
703 p_user_attr1 IN VARCHAR2,
704 p_user_attr2 IN VARCHAR2,
705 p_user_attr3 IN VARCHAR2,
706 p_user_attr4 IN VARCHAR2,
707 p_user_attr5 IN VARCHAR2,
708 p_user_measure1 IN NUMBER,
709 p_user_measure2 IN NUMBER,
710 p_user_measure3 IN NUMBER,
711 p_user_measure4 IN NUMBER,
712 p_user_measure5 IN NUMBER,
713 p_segment_status IN VARCHAR2,
714 p_planned_start_date IN VARCHAR2,
715 p_planned_completion_date IN VARCHAR2,
716 p_req_completion_date IN VARCHAR2,
717 p_rowid IN ROWID
718 );
719
720 PROCEDURE UPD_PROD_MTL_CONSUMED_ERR (
721 p_err_code IN VARCHAR2,
722 p_reprocess_ready_yn IN VARCHAR2,
723 p_wo_mat_req_pk IN VARCHAR2,
724 p_product_fk IN VARCHAR2,
725 p_material_fk IN VARCHAR2,
726 p_segment_fk IN VARCHAR2,
727 p_primary_uom IN VARCHAR2,
728 p_secondary_uom IN VARCHAR2,
729 p_required_qty_g IN NUMBER,
730 p_required_qty_sg IN NUMBER,
731 p_actual_qty_g IN NUMBER,
732 p_actual_qty_sg IN NUMBER,
733 p_unit_standard_qty_g IN NUMBER,
734 p_unit_standard_qty_sg IN NUMBER,
735 p_required_by_date IN VARCHAR2,
736 p_source_org_code IN VARCHAR2,
737 p_system_fk IN VARCHAR2,
738 p_user_dim1_fk IN VARCHAR2,
739 p_user_dim2_fk IN VARCHAR2,
740 p_user_dim3_fk IN VARCHAR2,
741 p_user_dim4_fk IN VARCHAR2,
742 p_user_dim5_fk IN VARCHAR2,
743 p_user_attr1 IN VARCHAR2,
744 p_user_attr2 IN VARCHAR2,
745 p_user_attr3 IN VARCHAR2,
746 p_user_attr4 IN VARCHAR2,
747 p_user_attr5 IN VARCHAR2,
748 p_user_measure1 IN NUMBER,
749 p_user_measure2 IN NUMBER,
750 p_user_measure3 IN NUMBER,
751 p_user_measure4 IN NUMBER,
752 p_user_measure5 IN NUMBER,
753 p_workorder_fk IN VARCHAR2,
754 p_mat_scrap_qty_g IN NUMBER,
755 p_mat_scrap_qty_sg IN NUMBER,
756 p_rowid IN ROWID
757 );
758
759 PROCEDURE UPD_PROD_MTL_CONSUMED_TXN_ERR (
760 p_err_code IN VARCHAR2,
761 p_reprocess_ready_yn IN VARCHAR2,
762 p_wo_mat_txn_pk IN VARCHAR2,
763 p_workorder_fk IN VARCHAR2,
764 p_product_fk IN VARCHAR2,
765 p_material_fk IN VARCHAR2,
766 p_segment_fk IN VARCHAR2,
767 p_transaction_qty IN NUMBER,
768 p_transaction_qty_g IN NUMBER,
769 p_transaction_qty_sg IN NUMBER,
770 p_transaction_uom IN VARCHAR2,
771 p_primary_uom IN VARCHAR2,
772 p_secondary_uom IN VARCHAR2,
773 p_transaction_date IN VARCHAR2,
774 p_system_fk IN VARCHAR2,
775 p_source_org_code IN VARCHAR2,
776 p_user_dim1_fk IN VARCHAR2,
777 p_user_dim2_fk IN VARCHAR2,
778 p_user_dim3_fk IN VARCHAR2,
779 p_user_dim4_fk IN VARCHAR2,
780 p_user_dim5_fk IN VARCHAR2,
781 p_user_attr1 IN VARCHAR2,
785 p_user_attr5 IN VARCHAR2,
782 p_user_attr2 IN VARCHAR2,
783 p_user_attr3 IN VARCHAR2,
784 p_user_attr4 IN VARCHAR2,
786 p_user_measure1 IN NUMBER,
787 p_user_measure2 IN NUMBER,
788 p_user_measure3 IN NUMBER,
789 p_user_measure4 IN NUMBER,
790 p_user_measure5 IN NUMBER,
791 p_rowid IN ROWID
792 );
793
794 PROCEDURE UPD_PROD_MTL_PRODUCED_ERR (
795 p_err_code IN VARCHAR2,
796 p_reprocess_ready_yn IN VARCHAR2,
797 p_workorder_fk IN VARCHAR2,
798 p_item_fk IN VARCHAR2,
799 p_start_quantity_g IN NUMBER,
800 p_system_fk IN VARCHAR2,
801 p_start_quantity_sg IN NUMBER,
802 p_expected_yield IN NUMBER,
803 p_primary_uom IN VARCHAR2,
804 p_secondary_uom IN VARCHAR2,
805 p_actual_comp_qty_g IN NUMBER,
806 p_actual_comp_qty_sg IN NUMBER,
807 p_actual_rejected_qty_g IN NUMBER,
808 p_actual_rejected_qty_sg IN NUMBER,
809 p_actual_reworked_qty_g IN NUMBER,
810 p_actual_reworked_qty_sg IN NUMBER,
811 p_actual_scrap_qty_g IN NUMBER,
812 p_actual_scrap_qty_sg IN NUMBER,
813 p_item_type_code IN VARCHAR2,
814 p_user_dim1_fk IN VARCHAR2,
815 p_user_dim2_fk IN VARCHAR2,
816 p_user_dim3_fk IN VARCHAR2,
817 p_user_dim4_fk IN VARCHAR2,
818 p_user_dim5_fk IN VARCHAR2,
819 p_user_attr1 IN VARCHAR2,
820 p_user_attr2 IN VARCHAR2,
821 p_user_attr3 IN VARCHAR2,
822 p_user_attr4 IN VARCHAR2,
823 p_user_attr5 IN VARCHAR2,
824 p_user_measure1 IN NUMBER,
825 p_user_measure2 IN NUMBER,
826 p_user_measure3 IN NUMBER,
827 p_user_measure4 IN NUMBER,
828 p_user_measure5 IN NUMBER,
829 p_wip_plan_qty_g IN NUMBER,
830 p_wip_plan_qty_sg IN NUMBER,
831 p_contribute_yield_flag IN VARCHAR2,
832 p_rowid IN ROWID
833 );
834
835 PROCEDURE UPD_PROD_MTL_PRODUCED_TXN_ERR (
836 p_err_code IN VARCHAR2,
837 p_reprocess_ready_yn IN VARCHAR2,
838 p_wo_comp_pk IN VARCHAR2,
839 p_workorder_fk IN VARCHAR2,
840 p_item_fk IN VARCHAR2,
841 p_segment_fk IN VARCHAR2,
842 p_transaction_type IN VARCHAR2,
843 p_transaction_qty IN NUMBER,
844 p_transaction_qty_g IN NUMBER,
845 p_transaction_qty_sg IN NUMBER,
846 p_transaction_uom IN VARCHAR2,
847 p_primary_uom IN VARCHAR2,
848 p_secondary_uom IN VARCHAR2,
849 p_transaction_date IN VARCHAR2,
850 p_source_org_code IN VARCHAR2,
851 p_system_fk IN VARCHAR2,
852 p_user_dim1_fk IN VARCHAR2,
853 p_user_dim2_fk IN VARCHAR2,
854 p_user_dim3_fk IN VARCHAR2,
855 p_user_dim4_fk IN VARCHAR2,
856 p_user_dim5_fk IN VARCHAR2,
857 p_user_attr1 IN VARCHAR2,
858 p_user_attr2 IN VARCHAR2,
859 p_user_attr3 IN VARCHAR2,
860 p_user_attr4 IN VARCHAR2,
861 p_user_attr5 IN VARCHAR2,
862 p_user_measure1 IN NUMBER,
863 p_user_measure2 IN NUMBER,
864 p_user_measure3 IN NUMBER,
865 p_user_measure4 IN NUMBER,
866 p_user_measure5 IN NUMBER,
867 p_rowid IN ROWID
868 );
869
870 PROCEDURE UPD_PROD_SEGMENTS_TXN_ERR (
871 p_err_code IN VARCHAR2,
872 p_reprocess_ready_yn IN VARCHAR2,
873 p_workorder_fk IN VARCHAR2,
874 p_from_segment_fk IN VARCHAR2,
875 p_to_segment_fk IN VARCHAR2,
876 p_item_fk IN VARCHAR2,
877 p_system_fk IN VARCHAR2,
878 p_transaction_date IN VARCHAR2,
879 p_transaction_qty IN NUMBER,
880 p_transaction_qty_g IN NUMBER,
881 p_transaction_qty_sg IN NUMBER,
882 p_primary_uom IN VARCHAR2,
883 p_secondary_uom IN VARCHAR2,
884 p_transaction_uom IN VARCHAR2,
885 p_from_step_type IN VARCHAR2,
886 p_to_step_type IN VARCHAR2,
887 p_user_dim1_fk IN VARCHAR2,
888 p_user_dim2_fk IN VARCHAR2,
889 p_user_dim3_fk IN VARCHAR2,
890 p_user_dim4_fk IN VARCHAR2,
894 p_user_attr3 IN VARCHAR2,
891 p_user_dim5_fk IN VARCHAR2,
892 p_user_attr1 IN VARCHAR2,
893 p_user_attr2 IN VARCHAR2,
895 p_user_attr4 IN VARCHAR2,
896 p_user_attr5 IN VARCHAR2,
897 p_user_measure1 IN NUMBER,
898 p_user_measure2 IN NUMBER,
899 p_user_measure3 IN NUMBER,
900 p_user_measure4 IN NUMBER,
901 p_user_measure5 IN NUMBER,
902 p_sub_segment_fk IN VARCHAR2,
903 p_rowid IN ROWID
904 );
905
906 PROCEDURE UPD_PROD_SUB_SEGMENTS_ERR (
907 p_err_code IN VARCHAR2,
908 p_reprocess_ready_yn IN VARCHAR2,
909 p_sub_segment_pk IN VARCHAR2,
910 p_segment_fk IN VARCHAR2,
911 p_system_fk IN VARCHAR2,
912 p_description IN VARCHAR2,
913 p_actual_start_date IN VARCHAR2,
914 p_actual_completion_date IN VARCHAR2,
915 p_planned_start_date IN VARCHAR2,
916 p_planned_completion_date IN VARCHAR2,
917 p_user_attr1 IN VARCHAR2,
918 p_user_attr2 IN VARCHAR2,
919 p_user_attr3 IN VARCHAR2,
920 p_user_attr4 IN VARCHAR2,
921 p_user_attr5 IN VARCHAR2,
922 p_user_measure1 IN NUMBER,
923 p_user_measure2 IN NUMBER,
924 p_user_measure3 IN NUMBER,
925 p_user_measure4 IN NUMBER,
926 p_user_measure5 IN NUMBER,
927 p_rowid IN ROWID
928 );
929
930 PROCEDURE UPD_QUARTER_ERR (
931 p_err_code IN VARCHAR2,
932 p_reprocess_ready_yn IN VARCHAR2,
933 p_hierarchy_name IN VARCHAR2,
934 p_name IN VARCHAR2,
935 p_user_attr1 IN VARCHAR2,
936 p_user_attr2 IN VARCHAR2,
937 p_user_attr3 IN VARCHAR2,
938 p_user_attr4 IN VARCHAR2,
939 p_user_attr5 IN VARCHAR2,
940 p_user_measure1 IN NUMBER,
941 p_user_measure2 IN NUMBER,
942 p_user_measure3 IN NUMBER,
943 p_user_measure4 IN NUMBER,
944 p_user_measure5 IN NUMBER,
945 p_system_fk IN VARCHAR2,
946 p_end_date IN VARCHAR2,
947 p_start_date IN VARCHAR2,
948 p_rowid IN ROWID
949 );
950
951 PROCEDURE UPD_RESOURCES_ERR (
952 p_err_code IN VARCHAR2,
953 p_reprocess_ready_yn IN VARCHAR2,
954 p_resource_pk IN VARCHAR2,
955 p_resource_type IN VARCHAR2,
956 p_ebs_resource_id IN NUMBER,
957 p_ebs_department_id IN NUMBER,
958 p_ebs_organization_id IN NUMBER,
959 p_usage_uom IN VARCHAR2,
960 p_capacity_units IN NUMBER,
961 p_available_24_hour_flag IN VARCHAR2,
962 p_system_fk IN VARCHAR2,
963 p_disable_date IN VARCHAR2,
964 p_resource_name IN VARCHAR2,
965 p_user_attr1 IN VARCHAR2,
966 p_user_attr2 IN VARCHAR2,
967 p_user_attr3 IN VARCHAR2,
968 p_user_attr4 IN VARCHAR2,
969 p_user_attr5 IN VARCHAR2,
970 p_user_attr6 IN VARCHAR2,
971 p_user_attr7 IN VARCHAR2,
972 p_user_attr8 IN VARCHAR2,
973 p_user_attr9 IN VARCHAR2,
974 p_user_attr10 IN VARCHAR2,
975 p_user_attr11 IN VARCHAR2,
976 p_user_attr12 IN VARCHAR2,
977 p_user_attr13 IN VARCHAR2,
978 p_user_attr14 IN VARCHAR2,
979 p_user_attr15 IN VARCHAR2,
980 p_user_attr16 IN VARCHAR2,
981 p_user_attr17 IN VARCHAR2,
982 p_user_attr18 IN VARCHAR2,
983 p_user_attr19 IN VARCHAR2,
984 p_user_attr20 IN VARCHAR2,
985 p_user_measure1 IN NUMBER,
986 p_user_measure2 IN NUMBER,
987 p_user_measure3 IN NUMBER,
988 p_user_measure4 IN NUMBER,
989 p_user_measure5 IN NUMBER,
990 p_source_org_code IN VARCHAR2,
991 p_resource_description IN VARCHAR2,
992 p_std_utilization IN NUMBER,
993 p_std_efficiency IN NUMBER,
994 p_production_resource IN VARCHAR2,
995 p_status IN VARCHAR2,
996 p_business_function IN VARCHAR2,
997 p_rowid IN ROWID
998 );
999
1000 PROCEDURE UPD_RESOURCE_COST_ERR (
1001 p_err_code IN VARCHAR2,
1005 p_to_date IN VARCHAR2,
1002 p_reprocess_ready_yn IN VARCHAR2,
1003 p_resource_fk IN VARCHAR2,
1004 p_from_date IN VARCHAR2,
1006 p_cost_element IN VARCHAR2,
1007 p_cost IN NUMBER,
1008 p_system_fk IN VARCHAR2,
1009 p_user_attr1 IN VARCHAR2,
1010 p_user_attr2 IN VARCHAR2,
1011 p_user_attr3 IN VARCHAR2,
1012 p_user_attr4 IN VARCHAR2,
1013 p_user_attr5 IN VARCHAR2,
1014 p_rowid IN ROWID
1015 );
1016
1017 PROCEDURE UPD_RESOURCE_REQUIREMENTS_ERR (
1018 p_err_code IN VARCHAR2,
1019 p_reprocess_ready_yn IN VARCHAR2,
1020 p_workorder_fk IN VARCHAR2,
1021 p_product_fk IN VARCHAR2,
1022 p_resource_fk IN VARCHAR2,
1023 p_segment_fk IN VARCHAR2,
1024 p_planned_usage_qty IN NUMBER,
1025 p_usage_uom IN VARCHAR2,
1026 p_unit_standard_qty IN NUMBER,
1027 p_source_org_code IN VARCHAR2,
1028 p_system_fk IN VARCHAR2,
1029 p_user_dim1_fk IN VARCHAR2,
1030 p_user_dim2_fk IN VARCHAR2,
1031 p_user_dim3_fk IN VARCHAR2,
1032 p_user_dim4_fk IN VARCHAR2,
1033 p_user_dim5_fk IN VARCHAR2,
1034 p_user_attr1 IN VARCHAR2,
1035 p_user_attr2 IN VARCHAR2,
1036 p_user_attr3 IN VARCHAR2,
1037 p_user_attr4 IN VARCHAR2,
1038 p_user_attr5 IN VARCHAR2,
1039 p_user_measure1 IN NUMBER,
1040 p_user_measure2 IN NUMBER,
1041 p_user_measure3 IN NUMBER,
1042 p_user_measure4 IN NUMBER,
1043 p_user_measure5 IN NUMBER,
1044 p_sub_segment_fk IN VARCHAR2,
1045 p_rowid IN ROWID
1046 );
1047
1048 PROCEDURE UPD_RESOURCE_TXN_ERR (
1049 p_err_code IN VARCHAR2,
1050 p_reprocess_ready_yn IN VARCHAR2,
1051 p_workorder_fk IN VARCHAR2,
1052 p_resource_fk IN VARCHAR2,
1053 p_product_fk IN VARCHAR2,
1054 p_segment_fk IN VARCHAR2,
1055 p_usage_qty IN NUMBER,
1056 p_usage_uom IN VARCHAR2,
1057 p_transaction_date IN VARCHAR2,
1058 p_source_org_code IN VARCHAR2,
1059 p_system_fk IN VARCHAR2,
1060 p_user_dim1_fk IN VARCHAR2,
1061 p_user_dim2_fk IN VARCHAR2,
1062 p_user_dim3_fk IN VARCHAR2,
1063 p_user_dim4_fk IN VARCHAR2,
1064 p_user_dim5_fk IN VARCHAR2,
1065 p_user_attr1 IN VARCHAR2,
1066 p_user_attr2 IN VARCHAR2,
1067 p_user_attr3 IN VARCHAR2,
1068 p_user_attr4 IN VARCHAR2,
1069 p_user_attr5 IN VARCHAR2,
1070 p_user_measure1 IN NUMBER,
1071 p_user_measure2 IN NUMBER,
1072 p_user_measure3 IN NUMBER,
1073 p_user_measure4 IN NUMBER,
1074 p_user_measure5 IN NUMBER,
1075 p_sub_segment_fk IN VARCHAR2,
1076 p_rowid IN ROWID
1077 );
1078
1079 PROCEDURE UPD_TAG_MASTER_ERR (
1080 p_err_code IN VARCHAR2,
1081 p_reprocess_ready_yn IN VARCHAR2,
1082 p_status IN VARCHAR2,
1083 p_data_type IN VARCHAR2,
1084 p_order_type IN VARCHAR2,
1085 p_reading_type IN VARCHAR2,
1086 p_initial_value IN NUMBER,
1087 p_tag_data_source_name IN VARCHAR2,
1088 p_tag_code IN VARCHAR2,
1089 p_tag_type IN NUMBER,
1090 p_plant_fk_key IN NUMBER,
1091 p_plc_identifier IN VARCHAR2,
1092 p_tag_alias IN VARCHAR2,
1093 p_equipment_fk_key IN NUMBER,
1094 p_description IN VARCHAR2,
1095 p_uom IN VARCHAR2,
1096 p_is_cumulative IN VARCHAR2,
1097 p_max_reset_value IN NUMBER,
1098 p_frequency_in_minutes IN NUMBER,
1099 p_user_attr1 IN VARCHAR2,
1100 p_user_attr2 IN VARCHAR2,
1101 p_user_attr3 IN VARCHAR2,
1102 p_user_attr4 IN VARCHAR2,
1103 p_user_attr5 IN VARCHAR2,
1104 p_reset_after_job IN VARCHAR2,
1105 p_rowid IN ROWID
1106 );
1107
1108 PROCEDURE UPD_TIME_HIERARCHY_ERR (
1109 p_err_code IN VARCHAR2,
1110 p_reprocess_ready_yn IN VARCHAR2,
1111 p_hierarchy_name IN VARCHAR2,
1115 p_system_fk IN VARCHAR2,
1112 p_child_fk IN VARCHAR2,
1113 p_parent_fk IN VARCHAR2,
1114 p_level_number_of_child IN NUMBER,
1116 p_rowid IN ROWID
1117 );
1118
1119 PROCEDURE UPD_USER_DIM_ENTITIES_ERR (
1120 p_err_code IN VARCHAR2,
1121 p_reprocess_ready_yn IN VARCHAR2,
1122 p_dimension_name IN VARCHAR2,
1123 p_entity_pk IN VARCHAR2,
1124 p_entity_name IN VARCHAR2,
1125 p_entity_type IN VARCHAR2,
1126 p_user_attr1 IN VARCHAR2,
1127 p_user_attr2 IN VARCHAR2,
1128 p_user_attr3 IN VARCHAR2,
1129 p_user_attr4 IN VARCHAR2,
1130 p_user_attr5 IN VARCHAR2,
1131 p_user_measure1 IN NUMBER,
1132 p_user_measure2 IN NUMBER,
1133 p_user_measure3 IN NUMBER,
1134 p_user_measure4 IN NUMBER,
1135 p_user_measure5 IN NUMBER,
1136 p_system_fk IN VARCHAR2,
1137 p_rowid IN ROWID
1138 );
1139
1140 PROCEDURE UPD_USER_DIM_HIERARCHY_ERR (
1141 p_err_code IN VARCHAR2,
1142 p_reprocess_ready_yn IN VARCHAR2,
1143 p_dimension_name IN VARCHAR2,
1144 p_hierarchy_name IN VARCHAR2,
1145 p_level_num IN NUMBER,
1146 p_level_fk IN VARCHAR2,
1147 p_parent_fk IN VARCHAR2,
1148 p_system_fk IN VARCHAR2,
1149 p_rowid IN ROWID
1150 );
1151
1152 PROCEDURE UPD_WEEK_ERR (
1153 p_err_code IN VARCHAR2,
1154 p_reprocess_ready_yn IN VARCHAR2,
1155 p_hierarchy_name IN VARCHAR2,
1156 p_name IN VARCHAR2,
1157 p_user_attr1 IN VARCHAR2,
1158 p_user_attr2 IN VARCHAR2,
1159 p_user_attr3 IN VARCHAR2,
1160 p_user_attr4 IN VARCHAR2,
1161 p_user_attr5 IN VARCHAR2,
1162 p_user_measure1 IN NUMBER,
1163 p_user_measure2 IN NUMBER,
1164 p_user_measure3 IN NUMBER,
1165 p_user_measure4 IN NUMBER,
1166 p_user_measure5 IN NUMBER,
1167 p_system_fk IN VARCHAR2,
1168 p_end_date IN VARCHAR2,
1169 p_start_date IN VARCHAR2,
1170 p_rowid IN ROWID
1171 );
1172
1173 PROCEDURE UPD_WORKDAY_SHIFTS_ERR (
1174 p_err_code IN VARCHAR2,
1175 p_reprocess_ready_yn IN VARCHAR2,
1176 p_shift_date IN VARCHAR2,
1177 p_source_org_code IN VARCHAR2,
1178 p_user_attr1 IN VARCHAR2,
1179 p_user_attr2 IN VARCHAR2,
1180 p_user_attr3 IN VARCHAR2,
1181 p_user_attr4 IN VARCHAR2,
1182 p_user_attr5 IN VARCHAR2,
1183 p_user_measure1 IN NUMBER,
1184 p_user_measure2 IN NUMBER,
1185 p_user_measure3 IN NUMBER,
1186 p_user_measure4 IN NUMBER,
1187 p_user_measure5 IN NUMBER,
1188 p_shift_workday_pk IN VARCHAR2,
1189 p_system_fk IN VARCHAR2,
1190 p_from_date IN VARCHAR2,
1191 p_to_date IN VARCHAR2,
1192 p_shift_num IN NUMBER,
1193 p_shift_name IN VARCHAR2,
1194 p_shift_type IN VARCHAR2,
1195 p_graveyard_shift IN VARCHAR2,
1196 p_rowid IN ROWID
1197 );
1198
1199 PROCEDURE UPD_WO_SALES_ORDERS_ERR (
1200 p_err_code IN VARCHAR2,
1201 p_reprocess_ready_yn IN VARCHAR2,
1202 p_workorder_fk IN VARCHAR2,
1203 p_salesorder_number IN VARCHAR2,
1204 p_salesorder_lnumber IN VARCHAR2,
1205 p_customer IN VARCHAR2,
1206 p_requested_date IN VARCHAR2,
1207 p_promised_date IN VARCHAR2,
1208 p_scheduled_ship_date IN VARCHAR2,
1209 p_system_fk IN VARCHAR2,
1210 p_quantity_g IN NUMBER,
1211 p_primary_uom IN VARCHAR2,
1212 p_product_fk IN VARCHAR2,
1213 p_user_dim1_fk IN VARCHAR2,
1214 p_user_dim2_fk IN VARCHAR2,
1215 p_user_dim3_fk IN VARCHAR2,
1216 p_user_dim4_fk IN VARCHAR2,
1217 p_user_dim5_fk IN VARCHAR2,
1218 p_user_attr1 IN VARCHAR2,
1219 p_user_attr2 IN VARCHAR2,
1220 p_user_attr3 IN VARCHAR2,
1221 p_user_attr4 IN VARCHAR2,
1222 p_user_attr5 IN VARCHAR2,
1223 p_user_measure1 IN NUMBER,
1227 p_user_measure5 IN NUMBER,
1224 p_user_measure2 IN NUMBER,
1225 p_user_measure3 IN NUMBER,
1226 p_user_measure4 IN NUMBER,
1228 p_reservation_pk IN VARCHAR2,
1229 p_rowid IN ROWID
1230 );
1231
1232 PROCEDURE UPD_YEAR_ERR (
1233 p_err_code IN VARCHAR2,
1234 p_reprocess_ready_yn IN VARCHAR2,
1235 p_hierarchy_name IN VARCHAR2,
1236 p_name IN VARCHAR2,
1237 p_user_attr1 IN VARCHAR2,
1238 p_user_attr2 IN VARCHAR2,
1239 p_user_attr3 IN VARCHAR2,
1240 p_user_attr4 IN VARCHAR2,
1241 p_user_attr5 IN VARCHAR2,
1242 p_user_measure1 IN NUMBER,
1243 p_user_measure2 IN NUMBER,
1244 p_user_measure3 IN NUMBER,
1245 p_user_measure4 IN NUMBER,
1246 p_user_measure5 IN NUMBER,
1247 p_system_fk IN VARCHAR2,
1248 p_end_date IN VARCHAR2,
1249 p_start_date IN VARCHAR2,
1250 p_rowid IN ROWID
1251 );
1252
1253 END MTH_UPDATE_ERR_PKG;
[Home] [Help]