[Home] [Help]
PACKAGE: APPS.BOM_RTG_PUB
Source
1 PACKAGE Bom_Rtg_Pub AUTHID CURRENT_USER AS
2 /* $Header: BOMBRTGS.pls 120.6.12020000.2 2012/08/06 22:45:41 umajumde ship $ */
3 /*#
4 * APIs in this package are used to create, update or delete single or multiple
5 * Routings and any of its child entities. In addition, a number of utility
6 * procedures that convert Routing child entities to and from Bill of Materials
7 * child entities are provided. <BR> A Routing is composed of its header and
8 * optionally, a number of related child entities: routing revisions, operations, operation
9 * resources, substitute operation resources and operation networks. <BR>
10 * First, user creates the routing header for an Item. After creating
11 * the Header, user adds or updates or deletes operations and their child entities such as
12 * operation resources, substitute operation resources etc.
13 * This API can be used for processing a single or multiple business entities(Routing and its child entities)
14 * per call. The entities that needs to be processed should belong to the same Routing. How to use this is
15 * explained below through examples.<BR>
16 * Example 1 : To Create a new Routing entity.(Routing Header, Operation, Operation Resource etc).
17 *<li>1.The user should Initialize the Error_Handler so that errors can be logged and retrieved.</li>
18 *<li>2.The user populates the Record Type for each entity like Routing Header that needs to be processed.</li>
19 *<li>3.The record should be created with attribute values as explained in the record type description below.</li>
20 *<li>For example populate the Routing Header record by giving values as follows Routing_Header.transaction_type = 'CREATE'</li>
21 *<li>4.Then Process_Rtg procedure in this package is called with already created record types as paramters.</li>
22 *<li>This procedure processes the records and registers errors in the pl/sql error table, which can be
23 * extracted using Error_Hanlder.get_message procedure.</li>
24 *<li>5.If the Return Status is S then the process has completed sucessfully else error is logged by the Error_Handler.</li>
25 *<li>6.Upon Successful completion the user should commit the data.</li>
26 *
27 * Example-2 To Update the value of an attribute.
28 *<li>1.If the user wants to update the user unique index attributes like Operation Sequence Number for Operation Record Type,
29 * he should give the existing value to pick up the corrrect record and new value to change.</li>
30 *<li>rtg_operation.Operation_Sequence_Number = 10</li>
31 *<li>rtg_operation.New_Operation_Sequence_Number = 20</li>
32 *<li>2.If the user wants to update non-user unique indexes then only the new value is required.</li>
33 *<li>rtg_operation.Operation_Description = 'New Description'</li><BR>
34 *
35 * ----------------------
36 * Routing Header Record
37 * ----------------------
38 *<code><pre>
39 * TYPE Rtg_Header_Rec_Type IS RECORD
40 * (
41 * Assembly_Item_Name VARCHAR2(240)
42 * , Organization_Code VARCHAR2(3)
43 * , Alternate_Routing_Code VARCHAR2(10)
44 * , Eng_Routing_Flag NUMBER
45 * , Common_Assembly_Item_Name VARCHAR2(240)
46 * , Routing_Comment VARCHAR2(240)
47 * , Completion_Subinventory VARCHAR2(10)
48 * , Completion_Location_Name VARCHAR2(81)
49 * , Line_Code VARCHAR2(10)
50 * , CFM_Routing_Flag NUMBER
51 * , Mixed_Model_Map_Flag NUMBER
52 * , Priority NUMBER
53 * , Total_Cycle_Time NUMBER
54 * , CTP_Flag NUMBER
55 * , Attribute_category VARCHAR2(30)
56 * , Attribute1 VARCHAR2(150)
57 * , Attribute2 VARCHAR2(150)
58 * , Attribute3 VARCHAR2(150)
59 * , Attribute4 VARCHAR2(150)
60 * , Attribute5 VARCHAR2(150)
61 * , Attribute6 VARCHAR2(150)
62 * , Attribute7 VARCHAR2(150)
63 * , Attribute8 VARCHAR2(150)
64 * , Attribute9 VARCHAR2(150)
65 * , Attribute10 VARCHAR2(150)
66 * , Attribute11 VARCHAR2(150)
67 * , Attribute12 VARCHAR2(150)
68 * , Attribute13 VARCHAR2(150)
69 * , Attribute14 VARCHAR2(150)
70 * , Attribute15 VARCHAR2(150)
71 * , Original_System_Reference VARCHAR2(50)
72 * , Transaction_Type VARCHAR2(30)
73 * , Return_Status VARCHAR2(1)
74 * , Delete_Group_Name VARCHAR2(10)
75 * , DG_Description VARCHAR2(240)
76 * , Ser_Start_Op_Seq NUMBER
77 * , Row_Identifier NUMBER
78 * ) ;
79 *</pre></code>
80 *
81 * ------------------------------
82 * Parameteres
83 * ------------------------------
84 *
85 *<pre>
86 * Assembly_item_name -- User friendly name of the Item for which the Routing Header is created.
87 * Organization_Code -- Organization Code in which the Item is defined.
88 * Alternate_Routing_Code -- Routing name to be given. If null value is given, then the Routing is Primary.
89 * Eng_Routing_Flag -- For Manufacturing Routing, Eng_Routing_Flag=1. For Engineering Routing, Eng_Routing_Flag=2.
90 * Common_Assembly_Item_Name -- Assembly Item name of common routing.
91 * Routing_Comment -- Comment describing the Routing.
92 * Completion_Subinventory -- Destination Subinventory for the Assembly.
93 * Completion_Location_Name -- Destination Location for the Assembly.
94 * Line_Code -- User friendly name of a Line from WIP Lines used in Flow Manufacturing.
95 * CFM_Routing_Flag -- Flag indicating whether the routing is Continous flow or traditional routing.
96 * Mixed_Model_Map_Flag -- Flag indicating whether to use this routing in Mixed Model Map calculation. (1=Yes, 2=No)
97 * Priority -- Priority
98 * Total_Cycle_Time -- Total time that an assembly takes along the primary path in the operation network, calculated by Flow Manufacturing.
99 * CTP_Flag -- Flag indicating capacity must be checked when item is ordered. (1=Yes, 2=No)
100 * Attribute_category -- Descriptive flexfield structure defining column
101 * Attribute 1 to 15 -- Descriptive flexfield segments
102 * Original_System_Reference -- Original system that data for the current record has come from.
103 * Transaction_Type -- Defined below
104 * Return_Status -- The Routing Header creation status, whether successful or error
105 * Delete_Group_Name -- Delete group name for the entity type you are deleting
106 * DG_Description -- A meaningful description of the delete group
107 * Ser_Start_Op_Seq -- Serialization Starting Operation Sequence Number for standard routings
108 * Row_Identifier -- A unique identifier value for the entity record.
109 *</pre>
110 *
111 *
112 * -------------------------------
113 * Routing Revision Record
114 * -------------------------------
115 *
116 *<code><pre>
117 * TYPE Rtg_Revision_Rec_Type IS RECORD
118 * (
119 * Assembly_Item_Name VARCHAR2(240)
120 * , Organization_Code VARCHAR2(3)
121 * , Alternate_Routing_Code VARCHAR2(10)
122 * , Revision VARCHAR2(3)
123 * , Start_Effective_Date DATE
124 * , Attribute_category VARCHAR2(30)
125 * , Attribute1 VARCHAR2(150)
126 * , Attribute2 VARCHAR2(150)
127 * , Attribute3 VARCHAR2(150)
128 * , Attribute4 VARCHAR2(150)
129 * , Attribute5 VARCHAR2(150)
130 * , Attribute6 VARCHAR2(150)
131 * , Attribute7 VARCHAR2(150)
132 * , Attribute8 VARCHAR2(150)
133 * , Attribute9 VARCHAR2(150)
134 * , Attribute10 VARCHAR2(150)
135 * , Attribute11 VARCHAR2(150)
136 * , Attribute12 VARCHAR2(150)
137 * , Attribute13 VARCHAR2(150)
138 * , Attribute14 VARCHAR2(150)
139 * , Attribute15 VARCHAR2(150)
140 * , Original_System_Reference VARCHAR2(50)
141 * , Transaction_Type VARCHAR2(30)
142 * , Return_Status VARCHAR2(1)
143 * , Row_Identifier NUMBER
144 * )
145 *</pre></code>
146 *
147 * -----------------------
148 * Parameters
149 * -----------------------
150 *
151 *<pre>
152 * Assembly_item_name -- User friendly name of the Item for which the Routing is created.
153 * Organization_Code -- Organization Code in which the Item is defined.
154 * Alternate_Routing_Code -- Routing name, if null then Primary.
155 * Revision -- Routing Revision internal name
156 * Start_Effective_Date -- Start Effectivity Date for the operation
157 * Attribute_category -- Descriptive flexfield structure defining column
158 * Attribute 1 to 15 -- Descriptive flexfield segments
159 * Original_System_Reference -- Original system that data for the current record has come from.
160 * Transaction_Type -- Defined below
161 * Return_Status -- The Routing Header creation status, whether successful or error
162 * Row_Identifier -- A unique identifier value for the entity record.
163 *</pre>
164 *
165 * ----------------------------------
166 * Routing Operation Record
167 * ----------------------------------
168 *
169 *<code><pre>
170 * TYPE Operation_Rec_Type IS RECORD
171 * (
172 * Assembly_Item_Name VARCHAR2(240)
173 * , Organization_Code VARCHAR2(3)
174 * , Alternate_Routing_Code VARCHAR2(10)
175 * , Operation_Sequence_Number NUMBER
176 * , Operation_Type NUMBER
177 * , Start_Effective_Date DATE
178 * , New_Operation_Sequence_Number NUMBER
179 * , New_Start_Effective_Date DATE
180 * , Standard_Operation_Code VARCHAR2(4)
181 * , Department_Code VARCHAR2(10)
182 * , Op_Lead_Time_Percent NUMBER
183 * , Minimum_Transfer_Quantity NUMBER
184 * , Count_Point_Type NUMBER
185 * , Operation_Description VARCHAR2(240)
186 * , Disable_Date DATE
187 * , Backflush_Flag NUMBER
188 * , Option_Dependent_Flag NUMBER
189 * , Reference_Flag NUMBER
190 * , Process_Seq_Number NUMBER
191 * , Process_Code VARCHAR2(4)
192 * , Line_Op_Seq_Number NUMBER
193 * , Line_Op_Code VARCHAR2(4)
194 * , Yield NUMBER
195 * , Cumulative_Yield NUMBER
196 * , Reverse_CUM_Yield NUMBER
197 * , User_Labor_Time NUMBER
198 * , User_Machine_Time NUMBER
199 * , Net_Planning_Percent NUMBER
200 * , Include_In_Rollup NUMBER
201 * , Op_Yield_Enabled_Flag NUMBER
202 * , Shutdown_Type VARCHAR2(30)
203 * , Attribute_category VARCHAR2(30)
204 * , Attribute1 VARCHAR2(150)
205 * , Attribute2 VARCHAR2(150)
206 * , Attribute3 VARCHAR2(150)
207 * , Attribute4 VARCHAR2(150)
208 * , Attribute5 VARCHAR2(150)
209 * , Attribute6 VARCHAR2(150)
210 * , Attribute7 VARCHAR2(150)
211 * , Attribute8 VARCHAR2(150)
212 * , Attribute9 VARCHAR2(150)
213 * , Attribute10 VARCHAR2(150)
214 * , Attribute11 VARCHAR2(150)
215 * , Attribute12 VARCHAR2(150)
216 * , Attribute13 VARCHAR2(150)
217 * , Attribute14 VARCHAR2(150)
218 * , Attribute15 VARCHAR2(150)
219 * , Original_System_Reference VARCHAR2(50)
220 * , Transaction_Type VARCHAR2(30)
221 * , Return_Status VARCHAR2(1)
222 * , Delete_Group_Name VARCHAR2(10)
223 * , DG_Description VARCHAR2(240)
224 * , Long_Description VARCHAR2(4000)
225 * , Row_Identifier NUMBER
226 * );
227 *</pre></code>
228 *
229 * -----------------------------
230 * Parameters
231 * -----------------------------
232 *
233 *<pre>
234 * Assembly_item_name -- User friendly name of the Item for which the Routing is created.
235 * Organization_Code -- Organization Code in which the Item is defined.
236 * Alternate_Routing_Code -- Routing name, if null then Primary.
237 * Operation_Sequence_Number -- Routing Operation Sequence Number
238 * Operation_Type -- Process, Line Operation or Event
239 * Start_Effective_Date -- Start Effectivity Date for the operation
240 * New_Operation_Sequence_Number -- New Operation Sequence Number when existing Operation Sequence Number to be changed.
241 * New_Start_Effective_Date -- New Start Effectivity Date
242 * Standard_Operation_Code -- User friendly name of Standard Operation
243 * Department_Code -- User friendly name of Department where the Operation is defined.
244 * Op_Lead_Time_Percent -- Indicates the amount of overlap this operation's lead time has with the parent's lead time
245 * Minimum_Transfer_Quantity -- Minimum Operation transfer quantity
246 * Count_Point_Type -- 1=Yes - autocharge; 2=No - autocharge; 3=No - direct charge.
247 * Operation_Description -- Meaningful description for the Operation
248 * Disable_Date -- The disable date after which the Operation will not be active
249 * Backflush_Flag -- Indicates whether the Operation requires backflushing (1=Yes, 2=No)
250 * Option_Dependent_Flag -- Indicates whether to use this Operation in all configuration routings, even if no components of the configuration are used in this Operation (1=Yes, 2=No)
251 * Reference_Flag -- If the Standard Operation is referenced or copied then the operation can not be updated. (1=Yes, 2=No)
252 * Process_Seq_Number -- Operation Sequence Number of parent process (applies only to events)
253 * Process_Code -- Operation Sequence Code of parent process (applies only to events)
254 * Line_Op_Seq_Number -- Operation Sequence Number of the parent line operation
255 * Line_Op_Code -- Operation Sequence Code of the parent line operation
256 * Yield -- Process yield at this Operation
257 * Cumulative_Yield -- Cumulative process yield from begining of routing to this operation
258 * Reverse_CUM_Yield -- Cumulative process yield from end of routing to comparable operation
259 * User_Labor_Time -- User calculated run time attributable to labor
260 * User_Machine_Time -- User calculated run time attributable to machines
261 * Net_Planning_Percent -- Cumulative planning percents derived from the operation network
262 * Include_In_Rollup -- Indicates whether operation yield is to be considered in cost rollup (1=Yes, 2=No)
263 * Op_Yield_Enabled_Flag -- Indicates whether operation yield is to be considered during costing (1=Yes, 2=No)
264 * Shutdown_Type -- Shutdown type
265 * Attribute_category -- Descriptive flexfield structure defining column
269 * Return_Status -- The Routing Operation creation status, whether successful or error
266 * Attribute 1 to 15 -- Descriptive flexfield segments
267 * Original_System_Reference -- Original system that data for the current record has come from.
268 * Transaction_Type -- Defined below
270 * Delete_Group_Name -- Delete group name for the entity type you are deleting
271 * DG_Description -- A meaningful description of the delete group
272 * Long_Description -- Long Description for Operation
273 * Row_Identifier -- A unique identifier value for the entity record.
274 *</pre>
275 *
276 * ---------------------------------
277 * Operation Resource Record
278 * ---------------------------------
279 *
280 *<code><pre>
281 * TYPE Op_Resource_Rec_Type IS RECORD
282 * (
283 * Assembly_Item_Name VARCHAR2(240)
284 * , Organization_Code VARCHAR2(3)
285 * , Alternate_Routing_Code VARCHAR2(10)
286 * , Operation_Sequence_Number NUMBER
287 * , Operation_Type NUMBER
288 * , Op_Start_Effective_Date DATE
289 * , Resource_Sequence_Number NUMBER
290 * , Resource_Code VARCHAR2(10)
291 * , Activity VARCHAR2(10)
292 * , Standard_Rate_Flag NUMBER
293 * , Assigned_Units NUMBER
294 * , Usage_Rate_Or_Amount NUMBER
295 * , Usage_Rate_Or_Amount_Inverse NUMBER
296 * , Basis_Type NUMBER
297 * , Schedule_Flag NUMBER
298 * , Resource_Offset_Percent NUMBER
299 * , Autocharge_Type NUMBER
300 * , Substitute_Group_Number NUMBER
301 * , Schedule_Sequence_Number NUMBER
302 * , Principle_Flag NUMBER
303 * , Attribute_category VARCHAR2(30)
304 * , Attribute1 VARCHAR2(150)
305 * , Attribute2 VARCHAR2(150)
306 * , Attribute3 VARCHAR2(150)
307 * , Attribute4 VARCHAR2(150)
308 * , Attribute5 VARCHAR2(150)
309 * , Attribute6 VARCHAR2(150)
310 * , Attribute7 VARCHAR2(150)
311 * , Attribute8 VARCHAR2(150)
312 * , Attribute9 VARCHAR2(150)
313 * , Attribute10 VARCHAR2(150)
314 * , Attribute11 VARCHAR2(150)
315 * , Attribute12 VARCHAR2(150)
316 * , Attribute13 VARCHAR2(150)
317 * , Attribute14 VARCHAR2(150)
318 * , Attribute15 VARCHAR2(150)
319 * , Original_System_Reference VARCHAR2(50)
320 * , Transaction_Type VARCHAR2(30)
321 * , Return_Status VARCHAR2(1)
322 * , Setup_Type VARCHAR2(30)
323 * , Row_Identifier NUMBER
324 * )
325 *</pre></code>
326 *
327 * -----------------------
328 * Parameters
329 * -----------------------
330 *
331 *<pre>
332 * Assembly_item_name -- User friendly name of the Item for which the Routing is created.
333 * Organization_Code -- Organization Code in which the Item is defined.
334 * Alternate_Routing_Code -- Routing name, if null then Primary.
335 * Operation_Sequence_Number -- Routing Operation Sequence Number
336 * Operation_Type -- Process, Line Operation or Event
337 * Op_Start_Effective_Date -- Start Effectivity Date for the operation
338 * Resource_Sequence_Number -- Resource Sequence Number to identify a resource in the Operation
339 * Resource_Code -- User friendly name of the Resource
340 * Activity -- An activity to perform when the Resource is used.
341 * Standard_Rate_Flag -- Indicate whether to use standard rate for shopfloor transactions (1=Yes, 2=No)
342 * Assigned_Units -- Resource Units assigned to the Operation
343 * Usage_Rate_Or_Amount -- Resource usage rate
344 * Usage_Rate_Or_Amount_Inverse -- Resource usage rate inverse
345 * Basis_Type -- Basis type identifier
346 * Schedule_Flag -- Schedule the resource (1=Yes, 2=No, 3=Prior, 4=Next)
347 * Resource_Offset_Percent -- Resource offset percent from the start of the routing
348 * Autocharge_Type -- Autocharge type for shopfloor moves (1=WIP move, 2=Manual, 3=PO receipt, 4=PO move)
349 * Substitute_Group_Number -- Substitute Group Number
350 * Schedule_Sequence_Number -- Scheduling Sequence Number
351 * Principle_Flag -- Principle Flag
352 * Attribute_category -- Descriptive flexfield structure defining column
353 * Attribute 1 to 15 -- Descriptive flexfield segments
354 * Original_System_Reference -- Original system that data for the current record has come from.
355 * Transaction_Type -- Defined Below
356 * Return_Status -- Process Status, whether successful or error
357 * Setup_Type -- Setup Type
358 * Row_Identifier -- A unique identifier value for the entity record.
359 *</pre>
360 *
361 * ------------------------------------------
362 * Substitute Operation Resource Record
363 * ------------------------------------------
364 *
365 *<code><pre>
366 * TYPE Sub_Resource_Rec_Type IS RECORD
367 * (
368 * Assembly_Item_Name VARCHAR2(240)
369 * , Organization_Code VARCHAR2(3)
370 * , Alternate_Routing_Code VARCHAR2(10)
371 * , Operation_Sequence_Number NUMBER
372 * , Operation_Type NUMBER
373 * , Op_Start_Effective_Date DATE
374 * , Sub_Resource_Code VARCHAR2(10)
375 * , New_Sub_Resource_Code VARCHAR2(10)
376 * , Substitute_Group_Number NUMBER
377 * , Schedule_Sequence_Number NUMBER
378 * , Replacement_Group_Number NUMBER
379 * , New_Replacement_Group_Number NUMBER
380 * , Activity VARCHAR2(10)
381 * , Standard_Rate_Flag NUMBER
385 * , Basis_Type NUMBER
382 * , Assigned_Units NUMBER
383 * , Usage_Rate_Or_Amount NUMBER
384 * , Usage_Rate_Or_Amount_Inverse NUMBER
386 * , New_Basis_Type NUMBER
387 * , Schedule_Flag NUMBER
388 * , Resource_Offset_Percent NUMBER
389 * , Autocharge_Type NUMBER
390 * , Principle_Flag NUMBER
391 * , Attribute_category VARCHAR2(30)
392 * , Attribute1 VARCHAR2(150)
393 * , Attribute2 VARCHAR2(150)
394 * , Attribute3 VARCHAR2(150)
395 * , Attribute4 VARCHAR2(150)
396 * , Attribute5 VARCHAR2(150)
397 * , Attribute6 VARCHAR2(150)
398 * , Attribute7 VARCHAR2(150)
399 * , Attribute8 VARCHAR2(150)
400 * , Attribute9 VARCHAR2(150)
401 * , Attribute10 VARCHAR2(150)
402 * , Attribute11 VARCHAR2(150)
403 * , Attribute12 VARCHAR2(150)
404 * , Attribute13 VARCHAR2(150)
405 * , Attribute14 VARCHAR2(150)
406 * , Attribute15 VARCHAR2(150)
407 * , Original_System_Reference VARCHAR2(50)
408 * , Transaction_Type VARCHAR2(30)
409 * , Return_Status VARCHAR2(1)
410 * , Setup_Type VARCHAR2(30)
411 * , Row_Identifier NUMBER
412 * )
413 *</pre></code>
414 *
415 * -----------------------
416 * Parameters
417 * -----------------------
418 *
419 *<pre>
420 * Most of the parameters hold the same meaning as explained in Operation Resource record types. Those which are specific to
421 * this record type are
422 * Sub_Resource_Code -- User friendly name of the Substitute Resource
423 * New_Sub_Resource_Code -- User friendly name of the new Substitute Resource when existing Substitute Resource needs to be changed
424 * Replacement_Group_Number -- Number to group the Substitute Resources
425 * New_Replacement_Group_Number -- New Replacement Group when existing Replacement Group Number needs to be changed
426 * New_Basis_Type -- New Basis Type for updating existing Basis Type
427 *</pre>
428 *
429 * ------------------------------------------
430 * Operation Network Record
431 * ------------------------------------------
432 *
433 *<code><pre>
434 * TYPE Op_Network_Rec_Type IS RECORD
435 * (
436 * Assembly_Item_Name VARCHAR2(240)
437 * , Organization_Code VARCHAR2(3)
438 * , Alternate_Routing_Code VARCHAR2(10)
439 * , Operation_Type NUMBER
440 * , From_Op_Seq_Number NUMBER
441 * , From_X_Coordinate NUMBER
442 * , From_Y_Coordinate NUMBER
443 * , From_Start_Effective_Date DATE
444 * , To_Op_Seq_Number NUMBER
445 * , To_X_Coordinate NUMBER
446 * , To_Y_Coordinate NUMBER
447 * , To_Start_Effective_Date DATE
448 * , New_From_Op_Seq_Number NUMBER
449 * , New_From_Start_Effective_Date DATE
450 * , New_To_Op_Seq_Number NUMBER
451 * , New_To_Start_Effective_Date DATE
452 * , Connection_Type NUMBER
453 * , Planning_Percent NUMBER
454 * , Attribute_category VARCHAR2(30)
455 * , Attribute1 VARCHAR2(150)
456 * , Attribute2 VARCHAR2(150)
457 * , Attribute3 VARCHAR2(150)
458 * , Attribute4 VARCHAR2(150)
459 * , Attribute5 VARCHAR2(150)
460 * , Attribute6 VARCHAR2(150)
461 * , Attribute7 VARCHAR2(150)
462 * , Attribute8 VARCHAR2(150)
463 * , Attribute9 VARCHAR2(150)
464 * , Attribute10 VARCHAR2(150)
465 * , Attribute11 VARCHAR2(150)
466 * , Attribute12 VARCHAR2(150)
467 * , Attribute13 VARCHAR2(150)
468 * , Attribute14 VARCHAR2(150)
469 * , Attribute15 VARCHAR2(150)
470 * , Original_System_Reference VARCHAR2(50)
471 * , Transaction_Type VARCHAR2(30)
472 * , Return_Status VARCHAR2(1)
473 * , Row_Identifier NUMBER
474 *</pre></code>
475 *
476 * -----------------------
477 * Parameters
478 * -----------------------
479 *
480 *<pre>
481 * Assembly_item_name -- User friendly name of the Item for which the Routing is created.
482 * Organization_Code -- Organization Code in which the Item is defined.
483 * Alternate_Routing_Code -- Routing name, if null then Primary.
484 * Operation_Type -- Process, Line Operation or Event
485 * From_Op_Seq_Number -- From Operation Sequence Number for the Network
486 * From_X_Coordinate -- X Co-ordinate for From Operation
487 * From_Y_Coordinate -- Y Co-ordinate for From Operation
488 * From_Start_Effective_Date -- Effectivity Date for From Operation
489 * To_Op_Seq_Number -- To Operation Sequence Number for the Network
490 * To_X_Coordinate -- X Co-ordinate for To Operation
491 * To_Y_Coordinate -- Y Co-ordinate for To Operation
492 * To_Start_Effective_Date -- Effectivity Date for To Operation
493 * New_From_Op_Seq_Number -- New From Operation Sequence Number for changing existing From Operation Sequence Number
494 * New_From_Start_Effective_Date -- New From Effectivity Date for changing existing From Effectivity Date
495 * New_To_Op_Seq_Number -- New To Operation Sequence Number for changing existing To Operation Sequence Number
496 * New_To_Start_Effective_Date -- New To Effectivity Date for changing existing To Effectivity Date
497 * Connection_Type -- Connection Type
498 * Planning_Percent -- Planning Percent
502 * Row_Identifier -- A unique identifier value for the entity record.
499 * Original_System_Reference -- Original system that data for the current record has come from.
500 * Transaction_Type -- Defined Below
501 * Return_Status -- Process Status, whether successful or error
503 *</pre>
504 *
505 * Every entity that needs to be processed must have 'Transaction Type'.
506 * Valid Transaction Types are CREATE, UPDATE, DELETE and SYNC.
507 * The SYNC Transaction Type can be used when the requirement is:
508 * 1.Create an entity, if it does not exist.
509 * 2.Update the entity with the given values, if it exists.
510 *
511 * @rep:scope public
512 * @rep:product BOM
513 * @rep:lifecycle active
514 * @rep:displayname Create, Update or Delete Routing
515 * @rep:compatibility S
516 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
517 */
518
519 /***************************************************************************
520 --
521 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
522 -- All rights reserved.
523 --
524 -- FILENAME
525 --
526 -- BOMBRTGS.pls
527 --
528 -- DESCRIPTION
529 --
530 -- Spec of package Bom_Rtg_Pub
531 --
532 -- NOTES
533 --
534 -- HISTORY
535 --
536 -- 02-AUG-00 Biao Zhang Initial Creation
537 -- 08-AUG-00 Masanori Kimziuka Modify and Add Conversion, Control_Rec_Type
538 --
539 ***************************************************************************/
540
541 --
542 -- Routing Header exposed record definition
543 --
544
545 TYPE Rtg_Header_Rec_Type IS RECORD
546 (
547 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
548 , Organization_Code VARCHAR2(3)
549 , Alternate_Routing_Code VARCHAR2(10)
550 , Eng_Routing_Flag NUMBER
551 , Common_Assembly_Item_Name VARCHAR2(240) -- bug 2947642
552 , Routing_Comment VARCHAR2(240)
553 , Completion_Subinventory VARCHAR2(10)
554 , Completion_Location_Name VARCHAR2(81)
555 , Line_Code VARCHAR2(10)
556 , CFM_Routing_Flag NUMBER
557 , Mixed_Model_Map_Flag NUMBER
558 , Priority NUMBER
559 , Total_Cycle_Time NUMBER
560 , CTP_Flag NUMBER
561 , Attribute_category VARCHAR2(30)
562 , Attribute1 VARCHAR2(150)
563 , Attribute2 VARCHAR2(150)
564 , Attribute3 VARCHAR2(150)
565 , Attribute4 VARCHAR2(150)
566 , Attribute5 VARCHAR2(150)
567 , Attribute6 VARCHAR2(150)
568 , Attribute7 VARCHAR2(150)
569 , Attribute8 VARCHAR2(150)
570 , Attribute9 VARCHAR2(150)
571 , Attribute10 VARCHAR2(150)
572 , Attribute11 VARCHAR2(150)
573 , Attribute12 VARCHAR2(150)
574 , Attribute13 VARCHAR2(150)
575 , Attribute14 VARCHAR2(150)
576 , Attribute15 VARCHAR2(150)
577 , Original_System_Reference VARCHAR2(50)
578 , Transaction_Type VARCHAR2(30)
579 , Return_Status VARCHAR2(1)
580 , Delete_Group_Name VARCHAR2(10)
581 , DG_Description VARCHAR2(240)
582 , Ser_Start_Op_Seq NUMBER -- Added for SSOS
583 , Row_Identifier NUMBER -- Added for Open Interface API
584 ) ;
585 --
586 -- Routing Unexposed Record definition
587 --
588 TYPE Rtg_Header_Unexposed_Rec_Type IS RECORD
589 (
590 Routing_Sequence_Id NUMBER
591 , Assembly_Item_Id NUMBER
592 , Organization_Id NUMBER
593 , Routing_Type NUMBER
594 , Common_Assembly_Item_Id NUMBER
595 , Common_Routing_Sequence_Id NUMBER
596 , Completion_Locator_Id NUMBER
597 , Line_Id NUMBER
598 , DG_Sequence_Id NUMBER
599 , DG_Description VARCHAR2(240)
600 , DG_New BOOLEAN
601 );
602
603 --
604 -- Routing_Revision exposed record definition
605 --
606
607 TYPE Rtg_Revision_Rec_Type IS RECORD
608 (
609 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
610 , Organization_Code VARCHAR2(3)
611 , Alternate_Routing_Code VARCHAR2(10)
612 , Revision VARCHAR2(3)
613 , Start_Effective_Date DATE
614 , Attribute_category VARCHAR2(30)
615 , Attribute1 VARCHAR2(150)
616 , Attribute2 VARCHAR2(150)
617 , Attribute3 VARCHAR2(150)
618 , Attribute4 VARCHAR2(150)
619 , Attribute5 VARCHAR2(150)
620 , Attribute6 VARCHAR2(150)
621 , Attribute7 VARCHAR2(150)
622 , Attribute8 VARCHAR2(150)
623 , Attribute9 VARCHAR2(150)
624 , Attribute10 VARCHAR2(150)
625 , Attribute11 VARCHAR2(150)
626 , Attribute12 VARCHAR2(150)
627 , Attribute13 VARCHAR2(150)
628 , Attribute14 VARCHAR2(150)
629 , Attribute15 VARCHAR2(150)
630 , Original_System_Reference VARCHAR2(50)
631 , Transaction_Type VARCHAR2(30)
632 , Return_Status VARCHAR2(1)
633 , Row_Identifier NUMBER -- Added for Open Interface API
634 ) ;
635
636 TYPE Rtg_Revision_Tbl_Type IS TABLE OF Rtg_Revision_Rec_Type
637 INDEX BY BINARY_INTEGER ;
638
639 --
640 -- Routing_Revison Unexposed Column Record
641 --
642
646 , Assembly_Item_Id NUMBER
643 TYPE Rtg_Rev_Unexposed_Rec_Type IS RECORD
644 (
645 Routing_Sequence_Id NUMBER
647 , Organization_Id NUMBER
648 , Implementation_Date DATE
649 , Change_Notice VARCHAR2(10)
650 ) ;
651
652 -- ECO Uses a different record structure for Operation Seqeunces,
653 -- Operation Resources and Sub Operation Resources than what BOM Routing
654 -- uses. So their two control record definition
655
656
657 TYPE Control_Rec_Type IS RECORD
658 ( controlled_operation BOOLEAN
659 , check_existence BOOLEAN
660 , attribute_defaulting BOOLEAN
661 , entity_defaulting BOOLEAN
662 , entity_validation BOOLEAN
663 , process_entity VARCHAR2(30)
664 , write_to_db BOOLEAN
665 , last_updated_by NUMBER
666 , last_update_login NUMBER
667 , caller_type VARCHAR2(10)
668 -- Set to 'FORM' if a FORM calls the program
669 , validation_controller VARCHAR2(30)
670 -- The name a field that requires specific validation
671 , require_item_rev NUMBER
672 , unit_controlled_item BOOLEAN
673 );
674
675 G_Default_Control_Rec Control_Rec_Type ;
676
677 --
678 -- Routing Operation exposed Column Record
679 --
680
681 TYPE Operation_Rec_Type IS RECORD
682 (
683 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
684 , Organization_Code VARCHAR2(3)
685 , Alternate_Routing_Code VARCHAR2(10)
686 , Operation_Sequence_Number NUMBER
687 , Operation_Type NUMBER
688 , Start_Effective_Date DATE
689 , New_Operation_Sequence_Number NUMBER
690 , New_Start_Effective_Date DATE
691 , Standard_Operation_Code VARCHAR2(4)
692 , Department_Code VARCHAR2(10)
693 , Op_Lead_Time_Percent NUMBER
694 , Minimum_Transfer_Quantity NUMBER
695 , Count_Point_Type NUMBER
696 , Operation_Description VARCHAR2(240)
697 , Disable_Date DATE
698 , Backflush_Flag NUMBER
699 , Option_Dependent_Flag NUMBER
700 , Reference_Flag NUMBER
701 , Process_Seq_Number NUMBER
702 , Process_Code VARCHAR2(4)
703 , Line_Op_Seq_Number NUMBER
704 , Line_Op_Code VARCHAR2(4)
705 , Yield NUMBER
706 , Cumulative_Yield NUMBER
707 , Reverse_CUM_Yield NUMBER
708 , User_Labor_Time NUMBER
709 , User_Machine_Time NUMBER
710 , Net_Planning_Percent NUMBER
711 , Include_In_Rollup NUMBER
712 , Op_Yield_Enabled_Flag NUMBER
713 , Shutdown_Type VARCHAR2(30)
714 , Attribute_category VARCHAR2(30)
715 , Attribute1 VARCHAR2(150)
716 , Attribute2 VARCHAR2(150)
717 , Attribute3 VARCHAR2(150)
718 , Attribute4 VARCHAR2(150)
719 , Attribute5 VARCHAR2(150)
720 , Attribute6 VARCHAR2(150)
721 , Attribute7 VARCHAR2(150)
722 , Attribute8 VARCHAR2(150)
723 , Attribute9 VARCHAR2(150)
724 , Attribute10 VARCHAR2(150)
725 , Attribute11 VARCHAR2(150)
726 , Attribute12 VARCHAR2(150)
727 , Attribute13 VARCHAR2(150)
728 , Attribute14 VARCHAR2(150)
729 , Attribute15 VARCHAR2(150)
730 , Original_System_Reference VARCHAR2(50)
731 , Transaction_Type VARCHAR2(30)
732 , Return_Status VARCHAR2(1)
733 , Delete_Group_Name VARCHAR2(10)
734 , DG_Description VARCHAR2(240)
735 , Long_Description VARCHAR2(4000) -- added for long description
736 , Row_Identifier NUMBER -- Added for Open Interface API
737 );
738 TYPE Operation_Tbl_Type IS TABLE OF Operation_Rec_Type
739 INDEX BY BINARY_INTEGER ;
740
741 --
742 -- Rouitng Operation Unexposed Column Record
743 --
744
745 TYPE Op_Unexposed_Rec_Type IS RECORD
746 (
747 Operation_Sequence_Id NUMBER
748 , Routing_Sequence_Id NUMBER
749 , Assembly_Item_Id NUMBER
750 , Organization_Id NUMBER
751 , Standard_Operation_Id NUMBER
752 , Department_Id NUMBER
753 , Process_Op_Seq_Id NUMBER
754 , Line_Op_Seq_Id NUMBER
755 , User_Elapsed_Time NUMBER
756 , DG_Sequence_Id NUMBER
757 , DG_Description VARCHAR2(240)
758 , DG_New BOOLEAN
759 , Lowest_acceptable_yield NUMBER -- Added for MES Enhancement
760 , Use_org_settings NUMBER
761 , Queue_mandatory_flag NUMBER
762 , Run_mandatory_flag NUMBER
763 , To_move_mandatory_flag NUMBER
764 , Show_next_op_by_default NUMBER
765 , Show_scrap_code NUMBER
766 , Show_lot_attrib NUMBER
767 , Track_multiple_res_usage_dates NUMBER -- End of MES Changes
768 ) ;
769
770
771 --
772 -- Revised Operation exposed Column Record
773 --
774
775 TYPE Rev_Operation_Rec_Type IS RECORD
776 (
777 Eco_Name VARCHAR2(10)
778 , Organization_Code VARCHAR2(3)
779 , Revised_Item_Name VARCHAR2(240) -- bug 2947642
780 , New_Revised_Item_Revision VARCHAR2(3)
781 , From_End_Item_Unit_Number VARCHAR2(30)
782 , New_Routing_Revision VARCHAR2(3)
783 , ACD_Type NUMBER
784 , Alternate_Routing_Code VARCHAR2(10)
785 , Operation_Sequence_Number NUMBER
789 , Old_Operation_Sequence_Number NUMBER
786 , Operation_Type NUMBER
787 , Start_Effective_Date DATE
788 , New_Operation_Sequence_Number NUMBER
790 , Old_Start_Effective_Date DATE
791 , Standard_Operation_Code VARCHAR2(4)
792 , Department_Code VARCHAR2(10)
793 , Op_Lead_Time_Percent NUMBER
794 , Minimum_Transfer_Quantity NUMBER
795 , Count_Point_Type NUMBER
796 , Operation_Description VARCHAR2(240)
797 , Disable_Date DATE
798 , Backflush_Flag NUMBER
799 , Option_Dependent_Flag NUMBER
800 , Reference_Flag NUMBER
801 , Yield NUMBER
802 , Cumulative_Yield NUMBER
803 , Cancel_Comments VARCHAR2(240)
804 , Attribute_category VARCHAR2(30)
805 , Attribute1 VARCHAR2(150)
806 , Attribute2 VARCHAR2(150)
807 , Attribute3 VARCHAR2(150)
808 , Attribute4 VARCHAR2(150)
809 , Attribute5 VARCHAR2(150)
810 , Attribute6 VARCHAR2(150)
811 , Attribute7 VARCHAR2(150)
812 , Attribute8 VARCHAR2(150)
813 , Attribute9 VARCHAR2(150)
814 , Attribute10 VARCHAR2(150)
815 , Attribute11 VARCHAR2(150)
816 , Attribute12 VARCHAR2(150)
817 , Attribute13 VARCHAR2(150)
818 , Attribute14 VARCHAR2(150)
819 , Attribute15 VARCHAR2(150)
820 , Original_System_Reference VARCHAR2(50)
821 , Transaction_Type VARCHAR2(30)
822 , Return_Status VARCHAR2(1)
823 ) ;
824
825 TYPE Rev_Operation_Tbl_Type IS TABLE OF Rev_Operation_Rec_Type
826 INDEX BY BINARY_INTEGER ;
827
828 --
829 -- Revised Operation Unexposed Column Record
830 --
831
832 TYPE Rev_Op_Unexposed_Rec_Type IS RECORD
833 (
834 Revised_Item_Sequence_Id NUMBER
835 , Operation_Sequence_Id NUMBER
836 , Old_Operation_Sequence_Id NUMBER
837 , Routing_Sequence_Id NUMBER
838 , Revised_Item_Id NUMBER
839 , Organization_Id NUMBER
840 , Standard_Operation_Id NUMBER
841 , Department_Id NUMBER
842 ) ;
843
844 --
845 -- Common Operation exposed Column Record
846 --
847
848 TYPE Com_Operation_Rec_Type IS RECORD
849 (
850 Eco_Name VARCHAR2(10)
851 , Organization_Code VARCHAR2(3)
852 , Revised_Item_Name VARCHAR2(240) -- bug 2947642
853 , New_revised_Item_Revision VARCHAR2(3)
854 , From_End_Item_Unit_Number VARCHAR2(30)
855 , New_Routing_Revision VARCHAR2(3)
856 , ACD_Type NUMBER
857 , Alternate_Routing_Code VARCHAR2(10)
858 , Operation_Sequence_Number NUMBER
859 , Operation_Type NUMBER
860 , Start_Effective_Date DATE
861 , New_Operation_Sequence_Number NUMBER
862 , New_Start_Effective_Date DATE
863 , Old_Operation_Sequence_Number NUMBER
864 , Old_Start_Effective_Date DATE
865 , Standard_Operation_Code VARCHAR2(4)
866 , Department_Code VARCHAR2(10)
867 , Op_Lead_Time_Percent NUMBER
868 , Minimum_Transfer_Quantity NUMBER
869 , Count_Point_Type NUMBER
870 , Operation_Description VARCHAR2(240)
871 , Disable_Date DATE
872 , Backflush_Flag NUMBER
873 , Option_Dependent_Flag NUMBER
874 , Reference_Flag NUMBER
875 , Process_Seq_Number NUMBER
876 , Process_Code VARCHAR2(4)
877 , Line_Op_Seq_Number NUMBER
878 , Line_Op_Code VARCHAR2(4)
879 , Yield NUMBER
880 , Cumulative_Yield NUMBER
881 , Reverse_CUM_Yield NUMBER
882 -- , Calculated_Labor_Time NUMBER
883 -- , Calculated_Machine_Time NUMBER
884 -- , Calculated_Elapsed_Time NUMBER
885 , User_Labor_Time NUMBER
886 , User_Machine_Time NUMBER
887 -- , User_Elapsed_Time NUMBER
888 , Net_Planning_Percent NUMBER
889 , Include_In_Rollup NUMBER
890 , Op_Yield_Enabled_Flag NUMBER
891 , Cancel_Comments VARCHAR2(240)
892 -- Added Shutdown_Type for eAM changes by MK on 04/10/2001
893 , Shutdown_Type VARCHAR2(30)
894 , Attribute_category VARCHAR2(30)
895 , Attribute1 VARCHAR2(150)
896 , Attribute2 VARCHAR2(150)
897 , Attribute3 VARCHAR2(150)
898 , Attribute4 VARCHAR2(150)
899 , Attribute5 VARCHAR2(150)
900 , Attribute6 VARCHAR2(150)
901 , Attribute7 VARCHAR2(150)
902 , Attribute8 VARCHAR2(150)
903 , Attribute9 VARCHAR2(150)
904 , Attribute10 VARCHAR2(150)
905 , Attribute11 VARCHAR2(150)
906 , Attribute12 VARCHAR2(150)
907 , Attribute13 VARCHAR2(150)
908 , Attribute14 VARCHAR2(150)
909 , Attribute15 VARCHAR2(150)
910 , Original_System_Reference VARCHAR2(50)
911 , Transaction_Type VARCHAR2(30)
912 , Return_Status VARCHAR2(1)
913 , Delete_Group_Name VARCHAR2(10)
914 , DG_Description VARCHAR2(240)
915 , Long_Description VARCHAR2(4000) -- added for long description
916 ) ;
917
918 TYPE Com_Operation_Tbl_Type IS TABLE OF Rev_Operation_Rec_Type
919 INDEX BY BINARY_INTEGER ;
920
921 --
925 TYPE Com_Op_Unexposed_Rec_Type IS RECORD
922 -- Common Operation Unexposed Column Record
923 --
924
926 (
927 Revised_Item_Sequence_Id NUMBER
928 , Operation_Sequence_Id NUMBER
929 , Old_Operation_Sequence_Id NUMBER
930 , Routing_Sequence_Id NUMBER
931 , Revised_Item_Id NUMBER
932 , Organization_Id NUMBER
933 , Standard_Operation_Id NUMBER
934 , Department_Id NUMBER
935 , Process_Op_Seq_Id NUMBER
936 , Line_Op_Seq_Id NUMBER
937 , User_Elapsed_Time NUMBER
938 , DG_Sequence_Id NUMBER
939 , DG_Description VARCHAR2(240)
940 , DG_New BOOLEAN
941 , Lowest_acceptable_yield NUMBER -- Added for MES Enhancement
942 , Use_org_settings NUMBER
943 , Queue_mandatory_flag NUMBER
944 , Run_mandatory_flag NUMBER
945 , To_move_mandatory_flag NUMBER
946 , Show_next_op_by_default NUMBER
947 , Show_scrap_code NUMBER
948 , Show_lot_attrib NUMBER
949 , Track_multiple_res_usage_dates NUMBER -- End of MES Changes
950 ) ;
951
952
953 --
954 -- Operation Resource record type
955 --
956
957 TYPE Op_Resource_Rec_Type IS RECORD
958 (
959 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
960 , Organization_Code VARCHAR2(3)
961 , Alternate_Routing_Code VARCHAR2(10)
962 , Operation_Sequence_Number NUMBER
963 , Operation_Type NUMBER
964 , Op_Start_Effective_Date DATE
965 , ACD_TYPE NUMBER --14286614
966 , ECO_NAME VARCHAR2(10) --14286614
967 , Resource_Sequence_Number NUMBER
968 , Resource_Code VARCHAR2(10)
969 , Activity VARCHAR2(10)
970 , Standard_Rate_Flag NUMBER
971 , Assigned_Units NUMBER
972 , Usage_Rate_Or_Amount NUMBER
973 , Usage_Rate_Or_Amount_Inverse NUMBER
974 , Basis_Type NUMBER
975 , Schedule_Flag NUMBER
976 , Resource_Offset_Percent NUMBER
977 , Autocharge_Type NUMBER
978 , Substitute_Group_Number NUMBER --added in RBO following changes for 11510
979 , Schedule_Sequence_Number NUMBER
980 , Principle_Flag NUMBER
981 , Attribute_category VARCHAR2(30)
982 , Attribute1 VARCHAR2(150)
983 , Attribute2 VARCHAR2(150)
984 , Attribute3 VARCHAR2(150)
985 , Attribute4 VARCHAR2(150)
986 , Attribute5 VARCHAR2(150)
987 , Attribute6 VARCHAR2(150)
988 , Attribute7 VARCHAR2(150)
989 , Attribute8 VARCHAR2(150)
990 , Attribute9 VARCHAR2(150)
991 , Attribute10 VARCHAR2(150)
992 , Attribute11 VARCHAR2(150)
993 , Attribute12 VARCHAR2(150)
994 , Attribute13 VARCHAR2(150)
995 , Attribute14 VARCHAR2(150)
996 , Attribute15 VARCHAR2(150)
997 , Original_System_Reference VARCHAR2(50)
998 , Transaction_Type VARCHAR2(30)
999 , Return_Status VARCHAR2(1)
1000 , Setup_Type VARCHAR2(30)
1001 , Row_Identifier NUMBER -- Added for Open Interface API
1002 ) ;
1003
1004 TYPE Op_Resource_Tbl_Type IS TABLE OF Op_Resource_Rec_Type
1005 INDEX BY BINARY_INTEGER;
1006
1007 --
1008 -- Operation resource Unexposed Column Record
1009 --
1010
1011 TYPE Op_Res_Unexposed_Rec_Type IS RECORD
1012 (
1013 Operation_Sequence_Id NUMBER
1014 , Routing_Sequence_Id NUMBER
1015 , Assembly_Item_Id NUMBER
1016 , Organization_Id NUMBER
1017 , Substitute_Group_Number NUMBER
1018 , Resource_Id NUMBER
1019 , Activity_Id NUMBER
1020 , Setup_Id NUMBER
1021 );
1022
1023
1024 --
1025 -- Revised Operation Resource record type
1026 --
1027
1028 TYPE Rev_Op_Resource_Rec_Type IS RECORD
1029 (
1030 Eco_Name VARCHAR2(10)
1031 , Organization_Code VARCHAR2(3)
1032 , Revised_Item_Name VARCHAR2(240) -- bug 2947642
1033 , New_Revised_Item_Revision VARCHAR2(3)
1034 , From_End_Item_Unit_Number VARCHAR2(30) -- Added by MK on 11/02/00
1035 , New_Routing_Revision VARCHAR2(3) -- Added by MK on 11/02/00
1036 , ACD_Type NUMBER
1037 , Alternate_Routing_Code VARCHAR2(10)
1038 , Operation_Sequence_Number NUMBER
1039 , Operation_Type NUMBER
1040 , Op_Start_Effective_Date DATE
1041 , Resource_Sequence_Number NUMBER
1042 , Resource_Code VARCHAR2(10)
1043 , Activity VARCHAR2(10)
1044 , Standard_Rate_Flag NUMBER
1045 , Assigned_Units NUMBER
1046 , Usage_Rate_Or_Amount NUMBER
1047 , Usage_Rate_Or_Amount_Inverse NUMBER
1048 , Basis_Type NUMBER
1049 , Schedule_Flag NUMBER
1050 , Resource_Offset_Percent NUMBER
1051 , Autocharge_Type NUMBER
1052 , Substitute_Group_Number NUMBER
1053 , Schedule_Sequence_Number NUMBER
1054 , Principle_Flag NUMBER
1055 , Attribute_category VARCHAR2(30)
1056 , Attribute1 VARCHAR2(150)
1057 , Attribute2 VARCHAR2(150)
1058 , Attribute3 VARCHAR2(150)
1059 , Attribute4 VARCHAR2(150)
1060 , Attribute5 VARCHAR2(150)
1061 , Attribute6 VARCHAR2(150)
1065 , Attribute10 VARCHAR2(150)
1062 , Attribute7 VARCHAR2(150)
1063 , Attribute8 VARCHAR2(150)
1064 , Attribute9 VARCHAR2(150)
1066 , Attribute11 VARCHAR2(150)
1067 , Attribute12 VARCHAR2(150)
1068 , Attribute13 VARCHAR2(150)
1069 , Attribute14 VARCHAR2(150)
1070 , Attribute15 VARCHAR2(150)
1071 , Original_System_Reference VARCHAR2(50)
1072 , Transaction_Type VARCHAR2(30)
1073 , Return_Status VARCHAR2(1)
1074 , Setup_Type VARCHAR2(30)
1075 ) ;
1076
1077 TYPE Rev_Op_Resource_Tbl_Type IS TABLE OF Rev_Op_Resource_Rec_Type
1078 INDEX BY BINARY_INTEGER;
1079
1080 --
1081 -- Revised Operation Resource Unexposed Column Record
1082 --
1083
1084 TYPE Rev_Op_Res_Unexposed_Rec_Type IS RECORD
1085 (
1086 Revised_Item_Sequence_Id NUMBER
1087 , Operation_Sequence_Id NUMBER
1088 , Routing_Sequence_Id NUMBER
1089 , Revised_Item_Id NUMBER
1090 , Organization_Id NUMBER
1091 , Substitute_Group_Number NUMBER
1092 , Resource_Id NUMBER
1093 , Activity_Id NUMBER
1094 , Setup_Id NUMBER
1095 ) ;
1096
1097
1098 --
1099 -- Substitute Operation Resource type
1100 --
1101
1102 TYPE Sub_Resource_Rec_Type IS RECORD
1103 (
1104 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
1105 , Organization_Code VARCHAR2(3)
1106 , Alternate_Routing_Code VARCHAR2(10)
1107 , Operation_Sequence_Number NUMBER
1108 , Operation_Type NUMBER
1109 , Op_Start_Effective_Date DATE
1110 , Sub_Resource_Code VARCHAR2(10)
1111 , New_Sub_Resource_Code VARCHAR2(10)
1112 , Substitute_Group_Number NUMBER
1113 , Schedule_Sequence_Number NUMBER
1114 , Replacement_Group_Number NUMBER
1115 , New_Replacement_Group_Number NUMBER -- bug 3741570
1116 , Activity VARCHAR2(10)
1117 , Standard_Rate_Flag NUMBER
1118 , Assigned_Units NUMBER
1119 , Usage_Rate_Or_Amount NUMBER
1120 , Usage_Rate_Or_Amount_Inverse NUMBER
1121 , Basis_Type NUMBER
1122 , New_Basis_Type NUMBER /* Added for bug 4689856 */
1123 , Schedule_Flag NUMBER
1124 , New_Schedule_Flag NUMBER /* Added for bug 13005178 */
1125 , Resource_Offset_Percent NUMBER
1126 , Autocharge_Type NUMBER
1127 , Principle_Flag NUMBER
1128 , Attribute_category VARCHAR2(30)
1129 , Attribute1 VARCHAR2(150)
1130 , Attribute2 VARCHAR2(150)
1131 , Attribute3 VARCHAR2(150)
1132 , Attribute4 VARCHAR2(150)
1133 , Attribute5 VARCHAR2(150)
1134 , Attribute6 VARCHAR2(150)
1135 , Attribute7 VARCHAR2(150)
1136 , Attribute8 VARCHAR2(150)
1137 , Attribute9 VARCHAR2(150)
1138 , Attribute10 VARCHAR2(150)
1139 , Attribute11 VARCHAR2(150)
1140 , Attribute12 VARCHAR2(150)
1141 , Attribute13 VARCHAR2(150)
1142 , Attribute14 VARCHAR2(150)
1143 , Attribute15 VARCHAR2(150)
1144 , Original_System_Reference VARCHAR2(50)
1145 , Transaction_Type VARCHAR2(30)
1146 , Return_Status VARCHAR2(1)
1147 , Setup_Type VARCHAR2(30)
1148 , Row_Identifier NUMBER -- Added for Open Interface API
1149 ) ;
1150
1151
1152 TYPE Sub_Resource_Tbl_Type IS TABLE OF Sub_Resource_Rec_Type
1153 INDEX BY BINARY_INTEGER ;
1154
1155 --
1156 -- Substitute Operation Resource Unexposed Column Record
1157 --
1158
1159 TYPE Sub_Res_Unexposed_Rec_Type IS RECORD
1160 (
1161 Operation_Sequence_Id NUMBER
1162 , Routing_Sequence_Id NUMBER
1163 , Substitute_Group_Number NUMBER
1164 , Assembly_Item_Id NUMBER
1165 , Organization_Id NUMBER
1166 , Resource_Id NUMBER
1167 , New_Resource_Id NUMBER
1168 , Activity_Id NUMBER
1169 , Setup_Id NUMBER
1170 );
1171
1172
1173
1174 --
1175 -- Revised Substitute Operation Resource type
1176 --
1177
1178 TYPE Rev_Sub_Resource_Rec_Type IS RECORD
1179 (
1180 Eco_Name VARCHAR2(10)
1181 , Organization_Code VARCHAR2(3)
1182 , Revised_Item_Name VARCHAR2(240) -- bug 2947642
1183 , New_Revised_Item_Revision VARCHAR2(3)
1184 , From_End_Item_Unit_Number VARCHAR2(30) -- Added by MK on 11/02/00
1185 , New_Routing_Revision VARCHAR2(3) -- Added by MK on 11/02/00
1186 , ACD_Type NUMBER
1187 , Alternate_Routing_Code VARCHAR2(10)
1188 , Operation_Sequence_Number NUMBER
1189 , Operation_Type NUMBER
1190 , Op_Start_Effective_Date DATE
1191 , Sub_Resource_Code VARCHAR2(10)
1192 , New_Sub_Resource_Code VARCHAR2(10)
1193 , Substitute_Group_Number NUMBER
1194 , Schedule_Sequence_Number NUMBER
1195 , Replacement_Group_Number NUMBER
1196 , New_Replacement_Group_Number NUMBER -- bug 3741570
1197 , Activity VARCHAR2(10)
1198 , Standard_Rate_Flag NUMBER
1199 , Assigned_Units NUMBER
1200 , Usage_Rate_Or_Amount NUMBER
1201 , Usage_Rate_Or_Amount_Inverse NUMBER
1202 , Basis_Type NUMBER
1203 , New_Basis_Type NUMBER /* Added for bug 4689856 */
1204 , Schedule_Flag NUMBER
1208 , Principle_Flag NUMBER
1205 , New_Schedule_Flag NUMBER /* Added for bug 13005178 */
1206 , Resource_Offset_Percent NUMBER
1207 , Autocharge_Type NUMBER
1209 , Attribute_category VARCHAR2(30)
1210 , Attribute1 VARCHAR2(150)
1211 , Attribute2 VARCHAR2(150)
1212 , Attribute3 VARCHAR2(150)
1213 , Attribute4 VARCHAR2(150)
1214 , Attribute5 VARCHAR2(150)
1215 , Attribute6 VARCHAR2(150)
1216 , Attribute7 VARCHAR2(150)
1217 , Attribute8 VARCHAR2(150)
1218 , Attribute9 VARCHAR2(150)
1219 , Attribute10 VARCHAR2(150)
1220 , Attribute11 VARCHAR2(150)
1221 , Attribute12 VARCHAR2(150)
1222 , Attribute13 VARCHAR2(150)
1223 , Attribute14 VARCHAR2(150)
1224 , Attribute15 VARCHAR2(150)
1225 , Original_System_Reference VARCHAR2(50)
1226 , Transaction_Type VARCHAR2(30)
1227 , Return_Status VARCHAR2(1)
1228 , Setup_Type VARCHAR2(30)
1229 ) ;
1230
1231
1232 TYPE Rev_Sub_Resource_Tbl_Type IS TABLE OF Rev_Sub_Resource_Rec_Type
1233 INDEX BY BINARY_INTEGER ;
1234
1235 --
1236 -- Rev Substitute Operation Resource Unexposed Column Record
1237 --
1238
1239 TYPE Rev_Sub_Res_Unexposed_Rec_Type IS RECORD
1240 (
1241 Revised_Item_Sequence_Id NUMBER
1242 , Operation_Sequence_Id NUMBER
1243 , Routing_Sequence_Id NUMBER
1244 , Substitute_Group_Number NUMBER
1245 , Revised_Item_Id NUMBER
1246 , Organization_Id NUMBER
1247 , Resource_Id NUMBER
1248 , New_Resource_Id NUMBER
1249 , Activity_Id NUMBER
1250 , Setup_Id NUMBER
1251 ) ;
1252
1253 --
1254 -- Operation Network Record definition
1255 --
1256 TYPE Op_Network_Rec_Type IS RECORD
1257 (
1258 Assembly_Item_Name VARCHAR2(240) -- bug 2947642
1259 , Organization_Code VARCHAR2(3)
1260 , Alternate_Routing_Code VARCHAR2(10)
1261 , Operation_Type NUMBER
1262 , From_Op_Seq_Number NUMBER
1263 , From_X_Coordinate NUMBER
1264 , From_Y_Coordinate NUMBER
1265 , From_Start_Effective_Date DATE
1266 , To_Op_Seq_Number NUMBER
1267 , To_X_Coordinate NUMBER
1268 , To_Y_Coordinate NUMBER
1269 , To_Start_Effective_Date DATE
1270 , New_From_Op_Seq_Number NUMBER
1271 , New_From_Start_Effective_Date DATE
1272 , New_To_Op_Seq_Number NUMBER
1273 , New_To_Start_Effective_Date DATE
1274 , Connection_Type NUMBER
1275 , Planning_Percent NUMBER
1276 , Attribute_category VARCHAR2(30)
1277 , Attribute1 VARCHAR2(150)
1278 , Attribute2 VARCHAR2(150)
1279 , Attribute3 VARCHAR2(150)
1280 , Attribute4 VARCHAR2(150)
1281 , Attribute5 VARCHAR2(150)
1282 , Attribute6 VARCHAR2(150)
1283 , Attribute7 VARCHAR2(150)
1284 , Attribute8 VARCHAR2(150)
1285 , Attribute9 VARCHAR2(150)
1286 , Attribute10 VARCHAR2(150)
1287 , Attribute11 VARCHAR2(150)
1288 , Attribute12 VARCHAR2(150)
1289 , Attribute13 VARCHAR2(150)
1290 , Attribute14 VARCHAR2(150)
1291 , Attribute15 VARCHAR2(150)
1292 , Original_System_Reference VARCHAR2(50)
1293 , Transaction_Type VARCHAR2(30)
1294 , Return_Status VARCHAR2(1)
1295 , Row_Identifier NUMBER -- Added for Open Interface API
1296 ) ;
1297
1298 TYPE Op_Network_Tbl_Type IS TABLE OF Op_Network_Rec_Type
1299 INDEX BY BINARY_INTEGER;
1300
1301 --
1302 -- Operation_Network Unexposed Record Definition
1303 --
1304
1305 TYPE Op_Network_Unexposed_Rec_Type IS RECORD
1306 (
1307 From_Op_Seq_Id NUMBER
1308 , To_Op_Seq_Id NUMBER
1309 , New_From_Op_Seq_Id NUMBER
1310 , New_To_Op_Seq_Id NUMBER
1311 , Routing_Sequence_Id NUMBER
1312 , CFM_Routing_Flag VARCHAR2(1)
1313 , Assembly_Item_Id NUMBER
1314 , Organization_Id NUMBER
1315 ) ;
1316
1317
1318 --
1319 -- Missing Records for RTG BO
1320 --
1321 G_MISS_RTG_HEADER_REC Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1322 G_MISS_RTG_REVISION_REC Bom_Rtg_Pub.Rtg_Revision_Rec_Type ;
1323 G_MISS_OPERATION_REC Bom_Rtg_Pub.Operation_Rec_Type ;
1324 G_MISS_OP_RESOURCE_REC Bom_Rtg_Pub.Op_Resource_Rec_Type ;
1325 G_MISS_SUB_RESOURCE_REC Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1326 G_MISS_OP_NETWORK_REC Bom_Rtg_Pub.Op_Network_Rec_Type ;
1327
1328 G_MISS_RTG_HEADER_UNEXP_REC Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type ;
1329 G_MISS_RTG_REV_UNEXP_REC Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type ;
1330 G_MISS_OP_UNEXP_REC Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
1331 G_MISS_OP_RES_UNEXP_REC Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
1332
1333 G_MISS_SUB_RES_UNEXP_REC Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1334 G_MISS_OP_NETWORK_UNEXP_REC Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type ;
1335
1336 G_MISS_RTG_REVISION_TBL Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1337 G_MISS_OPERATION_TBL Bom_Rtg_Pub.Operation_Tbl_Type;
1338 G_MISS_OP_RESOURCE_TBL Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1339 G_MISS_SUB_RESOURCE_TBL Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1340 G_MISS_OP_NETWORK_TBL Bom_Rtg_Pub.Op_Network_Tbl_Type;
1341
1342 --
1346 G_MISS_REV_OPERATION_REC Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1343 -- Missing Records for ENG BO
1344 --
1345
1347 G_MISS_REV_OP_RESOURCE_REC Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1348 G_MISS_REV_SUB_RESOURCE_REC Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
1349
1350 G_MISS_REV_OP_UNEXP_REC Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
1351 G_MISS_REV_OP_RES_UNEXP_REC Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1352 G_MISS_REV_SUB_RES_UNEXP_REC Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
1353
1354 G_MISS_REV_OPERATION_TBL Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1355 G_MISS_REV_OP_RESOURCE_TBL Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1356 G_MISS_REV_SUB_RESOURCE_TBL Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1357
1358
1359 --
1360 -- Missing Records for ENG BO
1361 --
1362
1363 G_MISS_COM_OPERATION_REC Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1364 G_MISS_COM_OP_UNEXP_REC Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1365 G_MISS_COM_OPERATION_TBL Bom_Rtg_Pub.Com_Operation_Tbl_Type;
1366
1367
1368 --
1369 -- Conversion from Routing BO Entity to Eco BO Entity
1370 -- Conversion from Eco BO Entity to Routing BO Entity
1371 --
1372
1373 -- Operation Entity
1374
1375 -- From Routing To Common
1376 /*#
1377 * This procedure converts a Routing Operation into a Common Operation.
1378 *
1379 * @param p_rtg_operation_rec IN Routing Operation to be converted.
1380 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type}
1381 * @param p_rtg_op_unexp_rec IN Routing Operation unexposed record.
1382 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
1383 * @param x_com_operation_rec IN OUT NOCOPY Converted Common Operation.
1384 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type}
1385 * @param x_com_op_unexp_rec IN OUT NOCOPY Additional fields for converted Common Operation.
1386 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
1387 *
1388 * @rep:displayname Convert Routing Operation into Common Operation
1389 * @rep:scope private
1390 * @rep:lifecycle active
1391 * @rep:compatibility S
1392 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1393 */
1394 PROCEDURE Convert_RtgOp_To_ComOp
1395 (
1396 p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1397 , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1398 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1399 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1400 ) ;
1401
1402 -- From Common To Routing
1403 /*#
1404 * This procedure converts a Common Operation into a Routing Operation.
1405 *
1406 * @param p_com_operation_rec IN Common Operation to be converted.
1407 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type}
1408 * @param p_com_op_unexp_rec IN Additional fields for Common Operation.
1409 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
1410 * @param x_rtg_operation_rec IN OUT NOCOPY Converted Routing Operation.
1411 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type}
1412 * @param x_rtg_op_unexp_rec IN OUT NOCOPY Additional fields for converted Routing Operation.
1413 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
1414 *
1415 * @rep:displayname Convert Common Operation into Routing Operation
1416 * @rep:scope private
1417 * @rep:lifecycle active
1418 * @rep:compatibility S
1419 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1420 */
1421 PROCEDURE Convert_ComOp_To_RtgOp
1422 (
1423 p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1424 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1425 , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1426 , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1427 ) ;
1428
1429 -- From Eco To Common
1430 /*#
1431 * This procedure converts a revised operation into a common operation.
1432 *
1433 * @param p_rev_operation_rec IN Revised operation to be converted.
1434 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type}
1435 * @param p_rev_op_unexp_rec IN Additional fields for revised operation to be converted.
1436 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
1437 * @param x_com_operation_rec IN OUT NOCOPY Converted common operation.
1438 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type}
1439 * @param x_com_op_unexp_rec IN OUT NOCOPY Additional fields for converted common operation.
1440 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
1441 *
1442 * @rep:displayname Convert Revised Operation into Common Operation
1443 * @rep:scope private
1444 * @rep:lifecycle active
1445 * @rep:compatibility S
1446 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1447 */
1448 PROCEDURE Convert_EcoOp_To_ComOp
1449 (
1450 p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1451 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1452 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1453 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1454 ) ;
1455
1456
1457 -- From Common To Eco
1458 /*#
1459 * This procedure converts a common operation into a revised operation.
1460 *
1461 * @param p_com_operation_rec IN Common operation to be converted.
1462 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type}
1463 * @param p_com_op_unexp_rec IN Additional fields for common operation.
1464 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
1465 * @param x_rev_operation_rec IN OUT NOCOPY Converted Revised operation.
1466 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type}
1467 * @param x_rev_op_unexp_rec IN OUT NOCOPY Additional fields for converted revised operation.
1471 * @rep:scope private
1468 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
1469 *
1470 * @rep:displayname Convert Common Operation into Revised Operation
1472 * @rep:lifecycle active
1473 * @rep:compatibility S
1474 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1475 */
1476 PROCEDURE Convert_ComOp_To_EcoOp
1477 (
1478 p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1479 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1480 , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1481 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1482 ) ;
1483
1484
1485 -- Operation Resource Entity
1486
1487 /*#
1488 * This procedure converts a routing operation resource into a revised operation resource.
1489 *
1490 * @param p_rtg_op_resource_rec IN Routing operation resource to be converted.
1491 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type}
1492 * @param p_rtg_op_res_unexp_rec IN Additional fields for routing operation resource to be converted.
1493 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type}
1494 * @param x_rev_op_resource_rec IN OUT NOCOPY Converted revised operation resource.
1495 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type}
1496 * @param x_rev_op_res_unexp_rec IN OUT NOCOPY Additional fields for converted revised operation resource.
1497 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type}
1498 *
1499 * @rep:displayname Convert Routing Operation Resource into Revised Operation Resource
1500 * @rep:scope private
1501 * @rep:lifecycle active
1502 * @rep:compatibility S
1503 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1504 */
1505 PROCEDURE Convert_RtgRes_To_EcoRes
1506 (
1507 p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
1508 , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
1509 , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1510 , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1511 ) ;
1512
1513 /*#
1514 * This procedure converts a revised operation resource into a routing operation resource.
1515 *
1516 * @param p_rev_op_resource_rec IN Revised operation resource to be converted.
1517 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type}
1518 * @param p_rev_op_res_unexp_rec IN Additional fields for revised operation resource to be converted.
1519 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type}
1520 * @param x_rtg_op_resource_rec IN OUT NOCOPY Converted Routing operation resource.
1521 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type}
1522 * @param x_rtg_op_res_unexp_rec IN OUT NOCOPY Additional fields for converted routing operation.
1523 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type}
1524 *
1525 * @rep:displayname Convert Revised Operation Resource into Routing Operation Resource
1526 * @rep:scope private
1527 * @rep:lifecycle active
1528 * @rep:compatibility S
1529 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1530 */
1531 PROCEDURE Convert_EcoRes_To_RtgRes
1532 (
1533 p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1534 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1535 , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
1536 , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
1537 ) ;
1538
1539 -- Sub Operation Resource Entity
1540
1541 /*#
1542 * This procedure converts a routing substitute resource into a revised substitute resource.
1543 *
1544 * @param p_rtg_sub_resource_rec IN Routing substitute resource to be converted.
1545 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
1546 * @param p_rtg_sub_res_unexp_rec IN Additional fields for routing substitute resource to be converted.
1547 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
1548 * @param x_rev_sub_resource_rec IN OUT NOCOPY Converted revised substitute resource.
1549 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
1550 * @param x_rev_sub_res_unexp_rec IN OUT NOCOPY Additional fields for converted revised substitute resource.
1551 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
1552 *
1553 * @rep:displayname Convert Routing Substitute Resource into Revised Substitute Resource
1554 * @rep:scope private
1555 * @rep:lifecycle active
1556 * @rep:compatibility S
1557 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1558 */
1559 PROCEDURE Convert_RtgSubRes_To_EcoSubRes
1560 (
1561 p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
1562 , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1563 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1564 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1565 ) ;
1566
1567 /*#
1568 * This procedure converts a revised substitute resource into a routing substitute resource.
1569 *
1570 * @param p_rev_sub_resource_rec IN Revised substitute resource to be converted.
1571 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
1572 * @param p_rev_sub_res_unexp_rec IN Additional fields for revised substitute resource to be converted.
1573 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
1574 * @param x_rtg_sub_resource_rec IN OUT NOCOPY Converted Routing substitute resource.
1575 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
1576 * @param x_rtg_sub_res_unexp_rec IN OUT NOCOPY Additional fields for converted routing substitute resource.
1577 * @rep:paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
1578 *
1579 * @rep:displayname Convert Revised Substitute Resource into Routing Substitute Resource
1580 * @rep:scope private
1584 */
1581 * @rep:lifecycle active
1582 * @rep:compatibility S
1583 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1585 PROCEDURE Convert_EcoSubRes_To_RtgSubRes
1586 (
1587 p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1588 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1589 , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
1590 , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1591 ) ;
1592
1593
1594
1595 /*#
1596 * This procedure is used to create, update or delete a routing
1597 * and its child entities:routing revisions, operations, operation
1598 * resources, substitute operation resources and operation networks.
1599 * Each of the records contained in one of the tables
1600 * passed as a parameter contains a <code>TRANSACTION_TYPE</code> field, which
1601 * indicates the operation to be performed on the record, as follows:
1602 * <UL>
1603 * <LI><code><B>TRANSACTION_TYPE = 'CREATE'</B></code> for record creation</LI>
1604 * <LI><code><B>TRANSACTION_TYPE = 'UPDATE'</B></code> for record update</LI>
1605 * <LI><code><B>TRANSACTION_TYPE = 'DELETE'</B></code> for record deletion</LI>
1606 * </UL>
1607 *
1608 * @param p_bo_identifier IN Business Object identifier. Possible values are RTG and ECO.
1609 * @param p_api_version_number IN API version number.
1610 * @param p_init_msg_list IN Use TRUE if you want to initialize the FND_MSG_PUB
1611 * package's message stack on calling the procedure.
1612 * @param p_rtg_header_rec IN Manufacturing routing header, corresponding to the
1613 * business object instance.
1614 * @param p_rtg_revision_tbl IN Manufacturing routing revisions.
1615 * @param p_operation_tbl IN Manufacturing routing operations.
1616 * @param p_op_resource_tbl IN Manufacturing routing operation resources.
1617 * @param p_sub_resource_tbl IN Manufacturing routing substitute operation
1618 * resources.
1619 * @param p_op_network_tbl IN Manufacturing routing operation networks.
1620 * @param x_rtg_header_rec IN OUT NOCOPY Resulting manufacturing routing header.
1621 * @param x_rtg_revision_tbl IN OUT NOCOPY Resulting manufacturing routing revisions.
1622 * @param x_operation_tbl IN OUT NOCOPY Resulting manufacturing routing operations.
1623 * @param x_op_resource_tbl IN OUT NOCOPY Resulting manufacturing routing operation resources.
1624 * @param x_sub_resource_tbl IN OUT NOCOPY Resulting manufacturing routing substitute operation
1625 * resources.
1626 * @param x_op_network_tbl IN OUT NOCOPY Resulting manufacturing routing operation networks.
1627 * @param x_return_status IN OUT NOCOPY Return status: 'S' for success, 'E' for error, 'U' for
1628 * unexpected error.
1629 * @param x_msg_count IN OUT NOCOPY Number of messages produced by the API.
1630 * @param p_debug IN Debuggin is enabled or not
1631 * @param p_output_dir IN Path of the debug output directory
1632 * @param p_debug_filename IN File name of the debug file
1633 *
1634 * @rep:displayname Process Routing
1635 * @rep:scope public
1636 * @rep:lifecycle active
1637 * @rep:compatibility S
1638 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
1639 */
1640 PROCEDURE Process_Rtg
1641 ( p_bo_identifier IN VARCHAR2 := 'RTG'
1642 , p_api_version_number IN NUMBER := 1.0
1643 , p_init_msg_list IN BOOLEAN := FALSE
1644 , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1645 :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1646 , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1647 :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1648 , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1649 := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1650 , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1651 := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1652 , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1653 := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1654 , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1655 := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1656 , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1657 , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1658 , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1659 , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1660 , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1661 , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1662 , x_return_status IN OUT NOCOPY VARCHAR2
1663 , x_msg_count IN OUT NOCOPY NUMBER
1664 , p_debug IN VARCHAR2 := 'N'
1665 , p_output_dir IN VARCHAR2 := NULL
1666 , p_debug_filename IN VARCHAR2 := 'RTG_BO_debug.log'
1667 ) ;
1668
1669 END Bom_Rtg_Pub ;