[Home] [Help]
PACKAGE: APPS.ENG_ECO_PUB
Source
1 PACKAGE ENG_Eco_PUB AS
2 /* $Header: ENGBECOS.pls 120.2 2006/07/07 13:41:24 pdutta noship $ */
3 /*#
4 * API for processing of a single or multiple business object per call.
5 * The entities in a business object should belong to the same Change.
6 * A single change business object is considered as a Change ENG Header
7 * and all its child entities such as, revisions, revised items, components,
8 * reference designators, substitute components, operations, their resources, etc.
9 * Every business object entity must have a transaction type.
10 * Valid Transaction Types are Create,Update
11 * This package performs integrity check and validation through the Process_Eco procedure.
12 * If the validations are successful,it populates the base production-tables.
13 * In case of validation failure it populates the interface tables with proper error messages.
14 * @rep:scope public
15 * @rep:product ENG
16 * @rep:lifecycle active
17 * @rep:displayname Create or Update Change
18 * @rep:compatibility S
19 * @rep:category BUSINESS_ENTITY ENG_CHANGE_ORDER
20 */
21
22
23 -- Eco record type
24
25 TYPE Eco_Rec_Type IS RECORD
26 ( Eco_Name VARCHAR2(10)
27 , Change_Notice_Prefix VARCHAR2(10)
28 , Change_Notice_Number NUMBER
29 , Organization_Code VARCHAR2(3)
30 , Change_Name VARCHAR2(240)
31 , Description VARCHAR2(2000)
32 , Cancellation_Comments VARCHAR2(240)
33 , Status_Name VARCHAR2(30)
34 , Priority_Code VARCHAR2(10)
35 , Reason_Code VARCHAR2(10)
36 , Eng_Implementation_Cost NUMBER
37 , Mfg_implementation_Cost NUMBER
38 , Requestor VARCHAR2(100)
39 , Attribute_category VARCHAR2(30)
40 , Attribute1 VARCHAR2(150)
41 , Attribute2 VARCHAR2(150)
42 , Attribute3 VARCHAR2(150)
43 , Attribute4 VARCHAR2(150)
44 , Attribute5 VARCHAR2(150)
45 , Attribute6 VARCHAR2(150)
46 , Attribute8 VARCHAR2(150)
47 , Attribute7 VARCHAR2(150)
48 , Attribute9 VARCHAR2(150)
49 , Attribute10 VARCHAR2(150)
50 , Attribute11 VARCHAR2(150)
51 , Attribute12 VARCHAR2(150)
52 , Attribute13 VARCHAR2(150)
53 , Attribute14 VARCHAR2(150)
54 , Attribute15 VARCHAR2(150)
55 , Ddf_Context VARCHAR2(30)
56 , Approval_List_Name VARCHAR2(10)
57 , Approval_Status_Name VARCHAR2(80)
58 , Approval_Date DATE
59 , Approval_Request_Date DATE
60 , Change_Type_Code VARCHAR2(80)
61 , Change_Management_Type VARCHAR2(45)
62 , Original_System_Reference VARCHAR2(50)
63 , Organization_Hierarchy VARCHAR2(30)
64 , Assignee VARCHAR2(360)
65 , Project_Name VARCHAR2(30)
66 , Task_Number VARCHAR2(25)
67 , Source_Type VARCHAR2(80)
68 , Source_Name VARCHAR2(80)
69 , Need_By_Date DATE
70 , Effort NUMBER
71 , Eco_Department_Name VARCHAR2(240)--Bug 2925982
72 , Transaction_Id NUMBER
73 , Transaction_Type VARCHAR2(10)
74 , Internal_Use_Only VARCHAR2(1)
75 , Return_Status VARCHAR2(1)
76 , plm_or_erp_change VARCHAR2(3) --11.5.10 to differentiate between ERP/PLM records
77 --11.5.10 subject for header
78 , pk1_name VARCHAR2(240)
79 , pk2_name VARCHAR2(240)
80 , pk3_name VARCHAR2(240)
81 --11.5.10
82 , Employee_Number per_people_f.EMPLOYEE_NUMBER%type --* Added for Bug 4402842
83 );
84
85
86 TYPE Eco_Tbl_Type IS TABLE OF Eco_Rec_Type
87 INDEX BY BINARY_INTEGER;
88
89 -- Eco Record of unexposed columns
90 TYPE Eco_Unexposed_Rec_Type IS RECORD
91 ( Organization_Id NUMBER
92 , Initiation_Date DATE
93 , Implementation_Date DATE
94 , Cancellation_Date DATE
95 , Requestor_Id NUMBER
96 , Approval_List_Id NUMBER
97 , Change_Order_Type_Id NUMBER
98 , Change_Mgmt_Type_Code VARCHAR2(30)
99 , Assignee_Id NUMBER
100 , Assignee_Type VARCHAR2(10)
101 , Source_Type_Code VARCHAR2(30)
102 , Source_Id NUMBER
103 , Status_Type NUMBER
104 , Approval_Status_Type NUMBER
105 , Project_Id NUMBER
106 , Task_Id NUMBER
107 , Responsible_Org_Id NUMBER
108 , Responsible_Org_Code VARCHAR2(3)
109 , Change_Id NUMBER
110 , Hierarchy_Id NUMBER
111 , Status_Code NUMBER
112
113 );
114
115 -- Eco_Revision record type
116
117 TYPE Eco_Revision_Rec_Type IS RECORD
118 ( Eco_Name VARCHAR2(10)
119 , Organization_code VARCHAR2(3)
120 , Revision VARCHAR2(10)
121 , New_Revision VARCHAR2(10)
122 , Comments VARCHAR2(240)
123 , Attribute_category VARCHAR2(30)
124 , Attribute1 VARCHAR2(150)
125 , Attribute2 VARCHAR2(150)
126 , Attribute3 VARCHAR2(150)
127 , Attribute4 VARCHAR2(150)
128 , Attribute5 VARCHAR2(150)
129 , Attribute6 VARCHAR2(150)
130 , Attribute7 VARCHAR2(150)
131 , Attribute8 VARCHAR2(150)
132 , Attribute9 VARCHAR2(150)
133 , Attribute10 VARCHAR2(150)
134 , Attribute11 VARCHAR2(150)
135 , Attribute12 VARCHAR2(150)
136 , Attribute13 VARCHAR2(150)
137 , Attribute14 VARCHAR2(150)
138 , Attribute15 VARCHAR2(150)
139 , Change_Management_Type VARCHAR2(45)
140 , Original_System_Reference VARCHAR2(50)
141 , Return_Status VARCHAR2(1)
142 , Transaction_Type VARCHAR2(30)
143 , Transaction_Id NUMBER
144 );
145
146 TYPE Eco_Revision_Tbl_Type IS TABLE OF Eco_Revision_Rec_Type
147 INDEX BY BINARY_INTEGER;
148
149 -- Eco Revision record of unexposed columns
150 TYPE Eco_Rev_Unexposed_Rec_Type IS RECORD
151 ( Organization_Id NUMBER
152 , Revision_Id NUMBER
153 , Change_Mgmt_Type_Code VARCHAR2(30)
154 , Change_Id NUMBER
155 );
156
157 -- Revised_Item record type
158
159 TYPE Revised_Item_Rec_Type IS RECORD
160 ( Eco_Name VARCHAR2(10)
161 , Organization_Code VARCHAR2(3)
162 , Revised_Item_Name VARCHAR2(700)
163 , New_Revised_Item_Revision VARCHAR2(3)
164 , New_Revised_Item_Rev_Desc VARCHAR2(240)
165 , Updated_Revised_Item_Revision VARCHAR2(3)
166 , Start_Effective_Date DATE
167 , New_Effective_Date DATE
168 , Alternate_Bom_Code VARCHAR2(10)
169 , Status_Type NUMBER
170 , Mrp_Active NUMBER
171 , Earliest_Effective_Date DATE
172 , Use_Up_Item_Name VARCHAR2(700)
173 , Use_Up_Plan_Name VARCHAR2(10)
174 , Requestor VARCHAR2(30)
175 , Disposition_Type NUMBER
176 , Update_Wip NUMBER
177 , Cancel_Comments VARCHAR2(240)
178 , Change_Description VARCHAR2(240)
179 , Attribute_category VARCHAR2(30)
180 , Attribute1 VARCHAR2(150)
181 , Attribute2 VARCHAR2(150)
182 , Attribute3 VARCHAR2(150)
183 , Attribute4 VARCHAR2(150)
184 , Attribute5 VARCHAR2(150)
185 , Attribute6 VARCHAR2(150)
186 , Attribute7 VARCHAR2(150)
187 , Attribute8 VARCHAR2(150)
188 , Attribute9 VARCHAR2(150)
189 , Attribute10 VARCHAR2(150)
190 , Attribute11 VARCHAR2(150)
191 , Attribute12 VARCHAR2(150)
192 , Attribute13 VARCHAR2(150)
193 , Attribute14 VARCHAR2(150)
194 , Attribute15 VARCHAR2(150)
195 , From_End_Item_Unit_Number VARCHAR2(30)
196 , New_From_End_Item_Unit_Number VARCHAR2(30)
197 , Original_System_Reference VARCHAR2(50)
198 , Return_Status VARCHAR2(1)
199 , Transaction_Type VARCHAR2(30)
200 , Transaction_Id NUMBER
201 , From_Work_Order VARCHAR2(150)
202 , To_Work_Order VARCHAR2(150)
203 , From_Cumulative_Quantity NUMBER
204 , Lot_Number VARCHAR2(30)
205 , Completion_Subinventory VARCHAR2(10)
206 , Completion_Location_Name VARCHAR2(81)
207 , Priority NUMBER
208 , Ctp_Flag NUMBER
209 , New_Routing_Revision VARCHAR2(3)
210 , Updated_Routing_Revision VARCHAR2(3)
211 , Routing_Comment VARCHAR2(240)
212 , Eco_For_Production NUMBER
213 , Change_Management_Type VARCHAR2(45)
214 , Transfer_Or_Copy VARCHAR2(1)
215 , Transfer_OR_Copy_Item NUMBER
216 , Transfer_OR_Copy_Bill NUMBER
217 , Transfer_OR_Copy_Routing NUMBER
218 , Copy_To_Item VARCHAR2(2000)
219 , Copy_To_Item_Desc VARCHAR2(240)
220 , parent_revised_item_name VARCHAR2(240)
221 , parent_alternate_name VARCHAR2(240)
222 , selection_option NUMBER
223 , selection_date DATE
224 , selection_unit_number VARCHAR2(30)
225 , current_lifecycle_phase_name VARCHAR2(240)
226 , new_lifecycle_phase_name VARCHAR2(240)
227 , from_end_item_revision VARCHAR2(3)
228 , from_end_item_strc_rev VARCHAR2(80)
229 , enable_item_in_local_org VARCHAR2(1)
230 , create_bom_in_local_org VARCHAR2(1)
231 , new_structure_revision VARCHAR2(80)
232 , plan_level NUMBER
233 , from_end_item_name VARCHAR2(700)
234 , FROM_END_ITEM_ALTERNATE VARCHAR2(10)
235 , current_structure_rev_name VARCHAR2(80)
236 , reschedule_comments VARCHAR2(240) -- Bug 3589974
237 , From_Item_Revision VARCHAR2(3) -- 11.5.10E
238 , New_Revision_Label VARCHAR2(80)
239 , New_Revision_Reason VARCHAR2(80)
240 , Structure_Type_Name VARCHAR2(80)
241 );
242
243 TYPE Revised_Item_Tbl_Type IS TABLE OF Revised_Item_Rec_Type
244 INDEX BY BINARY_INTEGER;
245
246 -- Revised Item Record of unexposed columns
247 TYPE Rev_Item_Unexposed_Rec_Type IS RECORD
248 ( Organization_Id NUMBER
249 , Revised_Item_Id NUMBER
250 , Implementation_Date DATE
251 , Auto_Implement_Date DATE
252 , Cancellation_Date DATE
253 , Bill_Sequence_Id NUMBER
254 , Use_Up_Item_Id NUMBER
255 , Use_Up NUMBER
256 , Requestor_id NUMBER
257 , Revised_Item_Sequence_Id NUMBER
258 , Routing_Sequence_Id NUMBER
259 , From_Wip_Entity_Id NUMBER
260 , To_Wip_Entity_Id NUMBER
261 , CFM_Routing_Flag NUMBER
262 , Completion_Locator_Id NUMBER
263 , Change_Mgmt_Type_Code VARCHAR2(30)
264 , Change_Id NUMBER
265 , parent_revised_item_seq_id NUMBER
266 , new_item_revision_id NUMBER
267 , current_item_revision_id NUMBER
268 , current_lifecycle_state_id NUMBER
269 , new_lifecycle_state_id NUMBER
270 , from_end_item_revision_id NUMBER
271 , from_end_item_struct_rev_id NUMBER
272 , current_structure_rev_id NUMBER
273 , from_end_item_id NUMBER
274 , status_code NUMBER -- Added for bug 3618676
275 , from_item_revision_id NUMBER -- 11.5.10E
276 , new_revision_reason_code VARCHAR2(30)
277 , Structure_Type_Id NUMBER
278 );
279
280 TYPE Change_Subject_Unexp_Rec_Type IS RECORD
281 ( Change_Id NUMBER
282 , Change_Line_Id NUMBER
283 , Change_Subject_Id NUMBER
284 , Entity_Name VARCHAR2(30)
285 , Pk1_Value VARCHAR2(100)
286 , Pk2_Value VARCHAR2(100)
287 , Pk3_Value VARCHAR2(100)
288 , Pk4_Value VARCHAR2(100)
289 , Pk5_Value VARCHAR2(100)
290 , Subject_Level NUMBER
291 ,Lifecycle_state_Id NUMBER
292 );
293
294
295
296
297
298
299 -- Change Line record type
300 TYPE Change_Line_Rec_Type IS RECORD
301 ( Eco_Name VARCHAR2(10)
302 , Organization_Code VARCHAR2(3)
303 , Change_Management_Type VARCHAR2(45)
304 --, Change_Type_Code VARCHAR2(10)
305 --Bug No: 3463472
306 --Issue: DEF-1694
307 --Description: Increased the length of the column to 80.
308 , Change_Type_Code VARCHAR2(80)
309 , Name VARCHAR2(240)
310 , Description VARCHAR2(2000)
311 , Sequence_Number NUMBER
312 , Status_Name VARCHAR2(80)
313 --, Item_Name VARCHAR2(700)
314 --, Item_Revision VARCHAR2(3)
315 , Object_Display_Name VARCHAR2(240)
316 , Pk1_Name VARCHAR2(240)
317 , Pk2_Name VARCHAR2(240)
318 , Pk3_Name VARCHAR2(240)
319 , Pk4_Name VARCHAR2(240)
320 , Pk5_Name VARCHAR2(240)
321 , Assignee_Name VARCHAR2(360)
322 , Scheduled_Date DATE
323 , Need_By_Date DATE
324 , Implementation_Date DATE
325 , Cancelation_Date DATE
326 , Original_System_Reference VARCHAR2(50)
327 , Return_Status VARCHAR2(1)
328 , Transaction_Type VARCHAR2(30)
329 , Required_Flag VARCHAR2(1)
330 , Complete_Before_Status_Code NUMBER
331 , Start_After_Status_Code NUMBER
332 ) ;
333
334 TYPE Change_Line_Tbl_Type IS TABLE OF Change_Line_Rec_Type
335 INDEX BY BINARY_INTEGER;
336
337 -- Change Line unexposed record type
338 TYPE Change_Line_Unexposed_Rec_Type IS RECORD
339 ( Organization_Id NUMBER
340 , Change_Line_Id NUMBER
341 , Change_Type_Id NUMBER
342 , Status_Code VARCHAR2(30)
343 --, Item_Id NUMBER
344 --, Item_Revision_Id NUMBER
345 , Object_Id NUMBER
346 , Object_Name VARCHAR2(430)--bug no 4146289
347 , Pk1_Value VARCHAR2(100)
348 , Pk2_Value VARCHAR2(100)
349 , Pk3_Value VARCHAR2(100)
350 , Pk4_Value VARCHAR2(100)
351 , Pk5_Value VARCHAR2(100)
352 , Assignee_Id NUMBER
353 , Change_Id NUMBER
354 , Approval_Status_Type NUMBER --Added as it is mandatory
355 );
356
357 -- Variables representing missing records
358 G_MISS_ECO_REC Eco_Rec_Type;
359 G_MISS_ECO_REVISION_REC Eco_Revision_Rec_Type;
360 G_MISS_ECO_REVISION_TBL Eco_Revision_Tbl_Type;
361 G_MISS_REVISED_ITEM_REC Revised_Item_Rec_Type;
362 G_MISS_REVISED_ITEM_TBL Revised_Item_Tbl_Type;
363 G_MISS_REV_COMPONENT_REC Bom_Bo_Pub.Rev_Component_Rec_Type;
364 G_MISS_REV_COMPONENT_TBL Bom_Bo_Pub.Rev_Component_Tbl_Type;
365 G_MISS_REF_DESIGNATOR_REC Bom_Bo_Pub.Ref_Designator_Rec_Type;
366 G_MISS_REF_DESIGNATOR_TBL Bom_Bo_Pub.Ref_Designator_Tbl_Type;
367 G_MISS_SUB_COMPONENT_REC Bom_Bo_Pub.Sub_Component_Rec_Type;
368 G_MISS_SUB_COMPONENT_TBL Bom_Bo_Pub.Sub_Component_Tbl_Type;
369 --L1
370 G_MISS_REV_OPERATION_TBL Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
371 G_MISS_REV_OP_RESOURCE_TBL Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
372 G_MISS_REV_SUB_RESOURCE_TBL Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
373
374 G_MISS_REV_OPERATION_REC Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
375 G_MISS_REV_OP_RESOURCE_REC Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
376 G_MISS_REV_SUB_RESOURCE_REC Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
377 G_MISS_REV_OP_UNEXP_REC Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
378 G_MISS_REV_OP_RES_UNEXP_REC Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
379 G_MISS_REV_SUB_RES_UNEXP_REC Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
380 --L1
381
382 -- Eng Change
383 G_MISS_CHANGE_LINE_REC Change_Line_Rec_Type ;
384 G_MISS_CHANGE_LINE_TBL Change_Line_Tbl_Type ;
385 G_MISS_CHANGE_LINE_UNEXP_REC Change_Line_Unexposed_Rec_Type ;
386
387
388 -- Start of Comments
389 -- API name Process_Eco
390 -- Type Public
391 -- Function
392 --
393 -- Pre-reqs
394 --
395 -- Parameters
396 --
397 -- Version Current version = 1.0
398 -- Initial version = 1.0
399 --
400 -- Notes
401 --
402 -- End of Comments
403
404 /*#
405 * This procedure is used to create,update Engineering Change Order (ECO)
406 * It verifies the integrity of the
407 * ECO business object and calls the private API which
408 * further drives the business object to perform business
409 * logic validations.
410 * @param p_api_version_number API Version Number
411 * @param p_init_msg_list Message List Initializer
412 * @param x_return_status Status of the Business Object
413 * @param x_msg_count Number of messages in the API message stack
414 * @param p_bo_identifier Business Object Identifier
415 * @param p_ECO_rec ECO Header exposed column record
416 * @param p_eco_revision_tbl Eco Revision exposed Column Table
417 * @param p_revised_item_tbl Eng Revised Items exposed column table
418 * @param p_rev_component_tbl Eng Revised Components exposed column table
419 * @param p_ref_designator_tbl Reference Designator exposed column table
420 * @param p_sub_component_tbl Substitute Component exposed Column table
421 * @param p_rev_operation_tbl Eng Revised Operations exposed column table
422 * @param p_rev_op_resource_tbl Eng Revised operation resources exposed Column table
423 * @param p_rev_sub_resource_tbl Eng Revised Sub Resources exposed Column table
424 * @param x_ECO_rec processed ECO Header exposed column record
425 * @param x_eco_revision_tbl processed Eco Revision exposed Column Table
426 * @param x_revised_item_tbl processed Eng Revised Items exposed column table
427 * @param x_rev_component_tbl processed Eng Revised Components exposed column table
428 * @param x_ref_designator_tbl processed Reference Designator exposed column table
429 * @param x_sub_component_tbl processed Substitute Component exposed Column table
430 * @param x_rev_operation_tbl processed Eng Revised Operations exposed column table
431 * @param x_rev_op_resource_tbl processed Eng Revised operation resources exposed Column table
432 * @param x_rev_sub_resource_tbl processed Eng Revised Sub Resources exposed Column table
433 * @param p_debug Debug Flag
434 * @param p_output_dir Output Directory
435 * @param p_debug_filename Debug File Name
436 * @rep:scope public
437 * @rep:lifecycle active
438 * @rep:displayname Process Change
439 */
440 PROCEDURE Process_Eco
441 ( p_api_version_number IN NUMBER := 1.0
442 , p_init_msg_list IN BOOLEAN := FALSE
443 , x_return_status OUT NOCOPY VARCHAR2
444 , x_msg_count OUT NOCOPY NUMBER
445 , p_bo_identifier IN VARCHAR2 := 'ECO'
446 , p_ECO_rec IN Eco_Rec_Type :=
447 G_MISS_ECO_REC
448 , p_eco_revision_tbl IN Eco_Revision_Tbl_Type :=
449 G_MISS_ECO_REVISION_TBL
450 , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
451 G_MISS_REVISED_ITEM_TBL
452 , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
453 G_MISS_REV_COMPONENT_TBL
454 , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
455 G_MISS_REF_DESIGNATOR_TBL
456 , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
457 G_MISS_SUB_COMPONENT_TBL
458 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
459 Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
460 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
461 Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
462 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
463 Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
464 , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
465 , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
466 , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
467 , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
468 , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
469 , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
470 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
471 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
472 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
473 , p_debug IN VARCHAR2 := 'N'
474 , p_output_dir IN VARCHAR2 := NULL
475 , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
476 );
477
478
479 -- Start of Comments
480 -- API name Process_Eco
481 -- Type Public
482 -- Function
483 --
484 -- Pre-reqs
485 --
486 -- Parameters
487 --
488 -- Version Current version = 1.0
489 -- Initial version = 1.0
490 --
491 -- Notes
492 -- Eng Change Enhancement: New Process Eco with new entities
493 -- End of Comments
494
495 /*#
496 * This procedure is used to create, update issues, change request, and Engineering Change Order (ECO) \n\
497 * in Product Lifecycle Management.It verifies the integrity of the
498 * ECO business object and calls the private API which
499 * further drives the business object to perform business
500 * logic validations.This is overloaded API which processes Change Lines for Change header
501 * along with other child entities like revisions,revised items, components, reference designators,
502 * substitute components,operations and their resources,etc.
503 * @param p_api_version_number API Version Number
504 * @param p_init_msg_list Message List Initializer
505 * @param x_return_status Status of the Business Object
506 * @param x_msg_count Number of messages in the API message stack
507 * @param p_bo_identifier Business Object Identifier
508 * @param p_ECO_rec ECO Header exposed column record
509 * @param p_eco_revision_tbl Eco Revision exposed Column Table
510 * @param p_change_line_tbl Eng Change Line exposed Column Table
511 * @param p_revised_item_tbl Eng Revised Items exposed column table
512 * @param p_rev_component_tbl Eng Revised Components exposed column table
513 * @param p_ref_designator_tbl Reference Designator exposed column table
514 * @param p_sub_component_tbl Substitute Component exposed Column table
515 * @param p_rev_operation_tbl Eng Revised Operations exposed column table
516 * @param p_rev_op_resource_tbl Eng Revised operation resources exposed Column table
517 * @param p_rev_sub_resource_tbl Eng Revised Sub Resources exposed Column table
518 * @param x_ECO_rec processed ECO Header exposed column record
519 * @param x_eco_revision_tbl processed Eco Revision exposed Column Table
520 * @param x_change_line_tbl processed Eng Change Line exposed Column Table
521 * @param x_revised_item_tbl processed Eng Revised Items exposed column table
522 * @param x_rev_component_tbl processed Eng Revised Components exposed column table
523 * @param x_ref_designator_tbl processed Reference Designator exposed column table
524 * @param x_sub_component_tbl processed Substitute Component exposed Column table
525 * @param x_rev_operation_tbl processed Eng Revised Operations exposed column table
526 * @param x_rev_op_resource_tbl processed Eng Revised operation resources exposed Column table
527 * @param x_rev_sub_resource_tbl processed Eng Revised Sub Resources exposed Column table
528 * @param p_debug Debug Flag
529 * @param p_output_dir Output Directory
530 * @param p_debug_filename Debug File Name
531 * @rep:scope public
532 * @rep:lifecycle active
533 * @rep:displayname Process Change
534 */
535 PROCEDURE Process_Eco
536 ( p_api_version_number IN NUMBER := 1.0
537 , p_init_msg_list IN BOOLEAN := FALSE
538 , x_return_status OUT NOCOPY VARCHAR2
539 , x_msg_count OUT NOCOPY NUMBER
540 , p_bo_identifier IN VARCHAR2 := 'ECO'
541 , p_ECO_rec IN Eco_Rec_Type :=
542 G_MISS_ECO_REC
543 , p_eco_revision_tbl IN Eco_Revision_Tbl_Type :=
544 G_MISS_ECO_REVISION_TBL
545 , p_change_line_tbl IN Change_Line_Tbl_Type := -- Eng Change
546 G_MISS_CHANGE_LINE_TBL
547 , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
548 G_MISS_REVISED_ITEM_TBL
549 , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
550 G_MISS_REV_COMPONENT_TBL
551 , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
552 G_MISS_REF_DESIGNATOR_TBL
553 , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
554 G_MISS_SUB_COMPONENT_TBL
555 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
556 Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
557 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
558 Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
559 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
560 Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
561 , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
562 , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
563 , x_change_line_tbl IN OUT NOCOPY Change_Line_Tbl_Type -- Eng Change
564 , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
565 , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
566 , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
567 , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
568 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
569 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
570 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
571 , p_debug IN VARCHAR2 := 'N'
572 , p_output_dir IN VARCHAR2 := NULL
573 , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
574 );
575
576
577
578 END ENG_Eco_PUB;