1 PACKAGE BOMPCMBM AUTHID CURRENT_USER AS
2 /* $Header: BOMCMBMS.pls 120.13 2011/05/05 10:08:54 rambkond ship $ */
3 /*#
4 * This package contains all the procedures required for creating and maintaining common Boms.
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:lifecycle active
8 * @rep:displayname Create, Add or Update Bill of Material Business Entities
9 * @rep:compatibility S
10 */
11
12
13 /*==========================================================================+
14 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
15 | All rights reserved. |
16 +===========================================================================+
17 | |
18 | File Name : BOMCMBMS.pls |
19 | DESCRIPTION : This file is a packaged specification for creating
20 | common bill for the following organization scope :
21 | a) Single organization
22 | b) Organization Hierarchy
23 | c) All Organizations
24 | Parameters: scope 1 - Single Organization, 2-Org Hierarchy
25 | 3 - All Orgs
26 | org_hierarchy Organization Hierarchy
27 | Current_org_id Organization from where the concprogram launch
28 | Common_item_from Item from which commoning to be done
29 | alternate alternate bom designator of the commonitemfrom
30 | common_item_to Item to which commoning to be done for scope=1
31 | common_org_to Org to which commoning to be done for scope=1
32 | error_code error code
33 | error_msg error message
34 |History :
35 |29-SEP-00 Shailendra CREATED
36 |06-May-05 Abhishek Rudresh Common BOM Attrs update.
37 +==========================================================================*/
38 /*#
39 * This Procedure is used to create common bills.
40 * @param ERRBUF OUT VARCHAR2
41 * @param RETCODE OUT VARCHAR2
42 * @param scope IN NUMBER
43 * @param org_hierarchy IN VARCHAR2
44 * @param current_org_id IN NUMBER
45 * @param common_item_from IN NUMBER
46 * @param alternate IN VARCHAR2
47 * @param common_org_to IN NUMBER
48 * @param common_item_to IN NUMBER
49 * @param enable_attrs_update IN VARCHAR2
50 * @rep:scope private
51 * @rep:compatibility S
52 * @rep:displayname Enable Attributes Update on Common Bom
53 * @rep:lifecycle active
54 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
55 */
56 PROCEDURE create_common_bills(
57 ERRBUF IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58 RETCODE IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 scope IN NUMBER DEFAULT 1,
60 org_hierarchy IN VARCHAR2 DEFAULT NULL,
61 current_org_id IN NUMBER,
62 common_item_from IN NUMBER,
63 alternate IN VARCHAR2 DEFAULT NULL,
64 common_org_to IN NUMBER DEFAULT NULL,
65 common_item_to IN NUMBER DEFAULT NULL
66 , enable_attrs_update IN VARCHAR2 DEFAULT NULL
67 ) ;
68
69
70
71 /*#
72 * This Procedure will modify the bill header attributes of a common BOM to make it updateable.
73 * @param p_bill_sequence_id IN Bill Sequence Id of the common BOM
74 * @rep:scope private
75 * @rep:compatibility S
76 * @rep:displayname Enable Attributes Update on Common Bom
77 * @rep:lifecycle active
78 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
79 */
80 PROCEDURE Dereference_Header(p_bill_sequence_id IN NUMBER);
81
82
83 /*#
84 * This Procedure will replicate the components of the source BOM as components of the Common BOM.
85 * @param p_src_bill_sequence_id IN Bill Sequence Id of the source BOM
86 * @param p_dest_bill_sequence_id IN Bill Sequence Id of the common BOM
87 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
88 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
89 * @rep:scope private
90 * @rep:compatibility S
91 * @rep:displayname Replicate Components
92 * @rep:lifecycle active
93 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
94 */
95 PROCEDURE Replicate_Components (p_src_bill_sequence_id IN NUMBER
96 , p_dest_bill_sequence_id IN NUMBER
97 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98 , x_Return_Status IN OUT NOCOPY VARCHAR2);
99
100
101
102
103 /*#
104 * This is an overloaded Procedure to replicate the components of the source BOM as components of the Common BOM.
105 * @param p_src_bill_sequence_id IN Bill Sequence Id of the source BOM
106 * @param p_dest_bill_sequence_id IN Bill Sequence Id of the common BOM
107 * @rep:scope private
108 * @rep:compatibility S
109 * @rep:displayname Replicate Components
110 * @rep:lifecycle active
111 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
112 */
113 PROCEDURE Replicate_Components (p_src_bill_sequence_id IN NUMBER
114 , p_dest_bill_sequence_id IN NUMBER);
115
116
117
118 /*#
119 * This Procedure should be called when a component is added to a bom that is commoned by other boms.
120 * This will add the component to the common boms.
121 * @param p_src_bill_seq_id IN Bill Sequence Id of the source BOM
122 * @param p_src_comp_seq_id IN Component Sequence Id of the component added
123 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
124 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
125 * @rep:scope private
126 * @rep:compatibility S
127 * @rep:displayname Insert Related Components
128 * @rep:lifecycle active
129 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
130 */
131 PROCEDURE Insert_Related_Components (p_src_bill_seq_id IN NUMBER
132 , p_src_comp_seq_id IN NUMBER
133 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
134 , x_Return_Status IN OUT NOCOPY VARCHAR2);
135
136
137 --Bug 9356298 Start
138 Procedure Delete_Related_Components(p_src_comp_seq IN NUMBER);
139 --Bug 9356298 End
140
141 /*#
142 * This is an overloaded Procedure called when a component is added to a bom that is commoned by other boms.
143 * This will add the component to the common boms.
144 * @param p_src_bill_seq_id IN Bill Sequence Id of the source BOM
145 * @param p_src_comp_seq_id IN Component Sequence Id of the component added
146 * @rep:scope private
147 * @rep:compatibility S
148 * @rep:displayname Insert Related Components
149 * @rep:lifecycle active
150 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
151 */
152 PROCEDURE Insert_Related_Components (p_src_bill_seq_id IN NUMBER
153 , p_src_comp_seq_id IN NUMBER);
154
155 --Bug 9238945 begin
156 PROCEDURE Update_Impl_Rel_Comp(p_src_comp_seq_id IN NUMBER);
157 --Bug 9238945 end
158
159 /*#
160 * This Procedure should be called when a component is updated in a bom that is commoned by other boms.
161 * This will update the component in the common boms.
162 * @param p_src_comp_seq_id IN Component Sequence Id of the component updated
163 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
164 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
165 * @rep:scope private
166 * @rep:compatibility S
167 * @rep:displayname Update Related Components
168 * @rep:lifecycle active
169 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
170 */
171 PROCEDURE Update_Related_Components (p_src_comp_seq_id IN NUMBER
172 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
173 , x_Return_Status IN OUT NOCOPY VARCHAR2);
174
175
176
177
178
179 /*#
180 * This overloaded Procedure should be called from java when a component is updated in a bom that is commoned by other boms.
181 * This will update the component in the common boms.
182 * @param p_src_comp_seq_id IN Component Sequence Id of the component updated
183 * @rep:scope private
184 * @rep:compatibility S
185 * @rep:displayname Update Related Components
186 * @rep:lifecycle active
187 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
188 */
189 PROCEDURE Update_Related_Components (p_src_comp_seq_id IN NUMBER);
190
191
192
193
194 /*#
195 * This Procedure will replicate the ref designators of components of the source BOM as ref desgs of components of the Common BOM.
196 * @param p_component_sequence_id IN Component Sequence Id of the component updated
197 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
198 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
199 * @rep:scope private
200 * @rep:compatibility S
201 * @rep:displayname Replicate Reference Designators
202 * @rep:lifecycle active
203 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
204 */
205 PROCEDURE Replicate_Ref_Desg(p_component_sequence_id IN NUMBER
206 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
207 , x_Return_Status IN OUT NOCOPY VARCHAR2);
208
209
210
211
212 /*#
213 * This overloaded Procedure should be called from java to replicate the ref designators of components of the source BOM as ref desgs of components of the Common BOM.
214 * @param p_component_sequence_id IN Component Sequence Id of the component updated
215 * @rep:scope private
216 * @rep:compatibility S
217 * @rep:displayname Replicate Reference Designators
218 * @rep:lifecycle active
219 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
220 */
221 PROCEDURE Replicate_Ref_Desg(p_component_sequence_id IN NUMBER);
222
223
224
225
226 /*#
227 * This Procedure is used to add reference designators to the related components of the common boms whenever
228 * reference designator is added to a component of a source bom.
229 * @param p_component_sequence_id IN Component Sequence Id of the component updated
230 * @param p_ref_desg IN Reference Designator added.
231 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
232 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
233 * @rep:scope private
234 * @rep:compatibility S
235 * @rep:displayname Insert Related Reference Designators
236 * @rep:lifecycle active
237 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
238 */
239 PROCEDURE Insert_Related_Ref_Desg(p_component_sequence_id IN NUMBER
240 , p_ref_desg IN VARCHAR2
241 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242 , x_Return_Status IN OUT NOCOPY VARCHAR2);
243
244
245
246
247 /*#
248 * This overloaded Procedure is called from Java to add reference designators to the related components of the common boms whenever
249 * reference designator is added to a component of a source bom.
250 * @param p_component_sequence_id IN Component Sequence Id of the component updated
251 * @param p_ref_desg IN Reference Designator added.
252 * @rep:scope private
253 * @rep:compatibility S
254 * @rep:displayname Insert Related Reference Designators
255 * @rep:lifecycle active
256 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
257 */
258 PROCEDURE Insert_Related_Ref_Desg(p_component_sequence_id IN NUMBER
259 , p_ref_desg IN VARCHAR2);
260
261
262
263
264
265 /*#
266 * This Procedure is used to update reference designators of the related components of the common boms whenever
267 * reference designator of a component of a source bom is updated.
268 * @param p_component_sequence_id IN Component Sequence Id of the component updated
269 * @param p_old_ref_desg IN Original Reference Designator updated.
270 * @param p_new_ref_desg IN Modified Reference Designator.
271 * @param p_acd_type IN ACD type of the record.
272 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
273 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
274 * @rep:scope private
275 * @rep:compatibility S
276 * @rep:displayname Update Related Reference Designators
277 * @rep:lifecycle active
278 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
279 */
280 PROCEDURE Update_Related_Ref_Desg(p_component_sequence_id IN NUMBER
281 , p_old_ref_desg IN VARCHAR2
282 , p_new_ref_desg IN VARCHAR2
283 , p_acd_type IN NUMBER
284 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
285 , x_Return_Status IN OUT NOCOPY VARCHAR2);
286
287
288
289
290
291 /*#
292 * This overloaded Procedure is called from Java to update reference designators of the related components of the common boms whenever
293 * reference designator of a component of a source bom is updated.
294 * @param p_component_sequence_id IN Component Sequence Id of the component updated
295 * @param p_old_ref_desg IN Original Reference Designator updated.
296 * @param p_new_ref_desg IN Modified Reference Designator.
297 * @param p_acd_type IN ACD type of the record.
298 * @rep:scope private
299 * @rep:compatibility S
300 * @rep:displayname Update Related Reference Designators
301 * @rep:lifecycle active
302 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
303 */
304 PROCEDURE Update_Related_Ref_Desg(p_component_sequence_id IN NUMBER
305 , p_old_ref_desg IN VARCHAR2
306 , p_new_ref_desg IN VARCHAR2
307 , p_acd_type IN NUMBER);
308
309
310
311 /*#
312 * This Procedure will replicate the substitutes of components of the source BOM as susbtitutes of components of the Common BOM.
313 * @param p_component_sequence_id IN Component Sequence Id of the component updated
314 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
315 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
316 * @rep:scope private
317 * @rep:compatibility S
318 * @rep:displayname Replicate Substitute Components
319 * @rep:lifecycle active
320 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
321 */
325
322 PROCEDURE Replicate_Sub_Comp(p_component_sequence_id IN NUMBER
323 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
324 , x_Return_Status IN OUT NOCOPY VARCHAR2);
326
327
328
329
330 /*#
331 * This overloaded Procedure is called from Java to replicate the substitutes of components of the source BOM
332 * as susbtitutes of components of the Common BOM.
333 * @param p_component_sequence_id IN Component Sequence Id of the component updated
334 * @rep:scope private
335 * @rep:compatibility S
336 * @rep:displayname Replicate Substitute Components
337 * @rep:lifecycle active
338 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
339 */
340 PROCEDURE Replicate_Sub_Comp(p_component_sequence_id IN NUMBER);
341
342
343
344 /*#
345 * This Procedure is used to add Substitute Components to the related components of the common boms whenever
346 * a substitute component is added to a component of a source bom.
347 * @param p_component_sequence_id IN Component Sequence Id of the component updated
348 * @param p_sub_comp_item_id IN Substitute Component Id added.
349 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
350 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
351 * @rep:scope private
352 * @rep:compatibility S
353 * @rep:displayname Insert Related Substitute Components
354 * @rep:lifecycle active
355 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
356 */
357 PROCEDURE Insert_Related_Sub_Comp(p_component_sequence_id IN NUMBER
358 , p_sub_comp_item_id IN NUMBER
359 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
360 , x_Return_Status IN OUT NOCOPY VARCHAR2);
361
362
363
364
365 /*#
366 * This overloaded Procedure is called from Java to add Substitute Components to the related components of the common boms whenever
367 * a substitute component is added to a component of a source bom.
368 * @param p_component_sequence_id IN Component Sequence Id of the component updated
369 * @param p_sub_comp_item_id IN Substitute Component Id added.
370 * @rep:scope private
371 * @rep:compatibility S
372 * @rep:displayname Insert Related Substitute Components
373 * @rep:lifecycle active
374 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
375 */
376 PROCEDURE Insert_Related_Sub_Comp(p_component_sequence_id IN NUMBER
377 , p_sub_comp_item_id IN NUMBER);
378
379
380
381
382 /*#
383 * This Procedure is used to update substitutes of the related components of the common boms whenever
384 * substitute of a component of a source bom is updated.
385 * @param p_component_sequence_id IN Component Sequence Id of the component updated
386 * @param p_old_sub_comp_item_id IN Original Substitute Component Id.
387 * @param p_new_sub_comp_item_id IN Substitute Component Id modified.
388 * @param p_acd_type IN ACD type of the record.
389 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
390 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
391 * @rep:scope private
392 * @rep:compatibility S
393 * @rep:displayname Update Related Substitute Components
394 * @rep:lifecycle active
395 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
396 */
397 PROCEDURE Update_Related_Sub_Comp(p_component_sequence_id IN NUMBER
398 , p_old_sub_comp_item_id IN NUMBER
399 , p_new_sub_comp_item_id IN NUMBER
400 , p_acd_type IN NUMBER
401 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
402 , x_Return_Status IN OUT NOCOPY VARCHAR2);
403
404
405
406
407 /*#
408 * This overloaded Procedure is called from Java to update substitutes of the related components of the common boms whenever
409 * substitute of a component of a source bom is updated.
410 * @param p_component_sequence_id IN Component Sequence Id of the component updated
411 * @param p_old_sub_comp_item_id IN Original Substitute Component Id.
412 * @param p_new_sub_comp_item_id IN Substitute Component Id modified.
413 * @param p_acd_type IN ACD type of the record.
414 * @rep:scope private
415 * @rep:compatibility S
416 * @rep:displayname Update Related Substitute Components
417 * @rep:lifecycle active
418 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
419 */
420 PROCEDURE Update_Related_Sub_Comp(p_component_sequence_id IN NUMBER
421 , p_old_sub_comp_item_id IN NUMBER
422 , p_new_sub_comp_item_id IN NUMBER
423 , p_acd_type IN NUMBER);
424
425
426
427 /*#
428 * This Procedure will replicate the component operations of the source BOM as component operations of the Common BOM.
429 * @param p_component_sequence_id IN Component Sequence Id of the component updated
430 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
431 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
432 * @rep:scope private
433 * @rep:compatibility S
434 * @rep:displayname Replicate Component Operations
435 * @rep:lifecycle active
436 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
437 */
438 PROCEDURE Replicate_Comp_Ops(p_component_sequence_id IN NUMBER
439 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
440 , x_Return_Status IN OUT NOCOPY VARCHAR2);
441
442
443
444
445
446 /*#
450 * @rep:scope private
447 * This overloaded Procedure is called from Java to replicate the component operations of the source BOM
448 * as component operations of the Common BOM.
449 * @param p_component_sequence_id IN Component Sequence Id of the component updated
451 * @rep:compatibility S
452 * @rep:displayname Replicate Component Operations
453 * @rep:lifecycle active
454 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
455 */
456 PROCEDURE Replicate_Comp_Ops(p_component_sequence_id IN NUMBER);
457
458
459
460 /*#
461 * This Procedure is used to add Component Operations to the related components of the common boms whenever
462 * a component operation is added to a component of a source bom.
463 * @param p_component_sequence_id IN Component Sequence Id of the component updated
464 * @param p_operation_seq_num IN Component Operation sequence number added.
465 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
466 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
467 * @rep:scope private
468 * @rep:compatibility S
469 * @rep:displayname Insert Related Component Operations
470 * @rep:lifecycle active
471 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
472 */
473 PROCEDURE Insert_Related_Comp_Ops(p_component_sequence_id IN NUMBER
474 , p_operation_seq_num IN NUMBER
475 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
476 , x_Return_Status IN OUT NOCOPY VARCHAR2);
477
478
479
480
481 /*#
482 * This overloaded Procedure is called from Java to add Component Operations to the related components of the common boms whenever
483 * a Component Operation is added to a component of a source bom.
484 * @param p_component_sequence_id IN Component Sequence Id of the component updated
485 * @param p_operation_seq_num IN Operation Sequence added.
486 * @rep:scope private
487 * @rep:compatibility S
488 * @rep:displayname Insert Related Component Operations
489 * @rep:lifecycle active
490 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
491 */
492 PROCEDURE Insert_Related_Comp_Ops(p_component_sequence_id IN NUMBER
493 , p_operation_seq_num IN NUMBER);
494
495
496
497
498 /*#
499 * This Procedure is used to update Component Operations of the related components of the common boms whenever
500 * Component Operations of a source bom is updated.
501 * @param p_component_sequence_id IN Component Sequence Id of the component updated
502 * @param p_old_operation_seq_num IN old Component Operation seq num.
503 * @param p_new_operation_seq_num IN new Component Operation seq num modified.
504 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
505 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
506 * @rep:scope private
507 * @rep:compatibility S
508 * @rep:displayname Update Related Component Operations
509 * @rep:lifecycle active
510 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
511 */
512 PROCEDURE Update_Related_Comp_Ops(p_component_sequence_id IN NUMBER
513 , p_old_operation_seq_num IN NUMBER
514 , p_new_operation_seq_num IN NUMBER
515 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
516 , x_Return_Status IN OUT NOCOPY VARCHAR2);
517
518
519
520
521 /*#
522 * This overloaded Procedure is called from Java to update Component Operations of the common boms whenever
523 * Component Operations of a source bom is updated.
524 * @param p_component_sequence_id IN Component Sequence Id of the component updated
525 * @param p_old_operation_seq_num IN old Component Operation seq num.
526 * @param p_new_operation_seq_num IN new Component Operation seq num modified.
527 * @rep:scope private
528 * @rep:compatibility S
529 * @rep:displayname Update Related Component Operations
530 * @rep:lifecycle active
531 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
532 */
533 PROCEDURE Update_Related_Comp_Ops(p_component_sequence_id IN NUMBER
534 , p_old_operation_seq_num IN NUMBER
535 , p_new_operation_seq_num IN NUMBER);
536
537
538
539
540 /*#
541 * This Procedure is used to delete related comp ops from the referencing boms when comp ops
542 * from the source bom is deleted.
543 * @param p_src_comp_seq_id IN Component Sequence Id of the source component.
544 * @param p_operation_seq_num IN Operation sequence number of the dest source component.
545 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
546 * @rep:scope private
547 * @rep:compatibility S
548 * @rep:displayname Delete Related Component Operations
549 * @rep:lifecycle active
550 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
551 */
552 PROCEDURE Delete_Related_Comp_Ops(p_src_comp_seq_id IN NUMBER,
553 p_operation_seq_num IN NUMBER,
554 x_Return_Status IN OUT NOCOPY VARCHAR2);
555
556
557 /*#
558 * This Procedure is used to validate the operation sequences of the source bom.
559 * @param p_src_bill_sequence_id IN Bill Sequence Id of the source bom
560 * @param p_assembly_item_id IN Assembly Item Id of the common bom.
561 * @param p_organization_id IN Organization Id of the Commmon BOM
562 * @param p_alt_desg IN Alternate BOM Designator of the BOM
563 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
564 * @rep:scope private
565 * @rep:compatibility S
566 * @rep:displayname Validate Operation Sequence Id
567 * @rep:lifecycle active
571 , p_assembly_item_id IN NUMBER
568 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
569 */
570 PROCEDURE Validate_Operation_Sequence_Id(p_src_bill_sequence_id IN NUMBER
572 , p_organization_id IN NUMBER
573 , p_alt_desg IN VARCHAR2
574 , x_Return_Status IN OUT NOCOPY VARCHAR2);
575
576
577
578
579 /*#
580 * This Procedure is used to copy the component user attributes from the source bom.
581 * @param p_src_comp_seq_id IN Component Sequence Id of the source source component.
582 * @param p_attr_grp_id IN Attribute Group Id of the source component.
583 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
584 * @rep:scope private
585 * @rep:compatibility S
586 * @rep:displayname Validate Operation Sequence Id
587 * @rep:lifecycle active
588 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
589 */
590 Procedure Propagate_Comp_User_Attributes(p_src_comp_seq_id IN NUMBER
591 , p_attr_grp_id IN NUMBER
592 , x_Return_Status OUT NOCOPY VARCHAR2);
593
594
595 /*#
596 * This Function is used to validate the operation seq num from the source bom
597 * whenever a component is added to it.
598 * @return boolean
599 * @param p_src_bill_seq_id IN Bill Sequence Id of the source bom.
600 * @param p_op_seq IN Operation Sequence number
601 * @rep:scope private
602 * @rep:compatibility S
603 * @rep:displayname Check Operation Sequence Id in Referring BOMs
604 * @rep:lifecycle active
605 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
606 */
607 Function Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id IN NUMBER
608 , p_op_seq IN NUMBER)
609 Return boolean;
610
611
612
613 /*#
614 * This Procedure is used to replicate the component user attributes from the source bom.
615 * @param p_src_bill_seq_id IN Bill Sequence Id of the source component.
616 * @param p_dest_bill_seq_id IN Bill Sequence Id of the dest source component.
617 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
618 * @rep:scope private
619 * @rep:compatibility S
620 * @rep:displayname Replicate Component User Attributes
621 * @rep:lifecycle active
622 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
623 */
624 Procedure Replicate_Comp_User_Attrs(p_src_bill_seq_id IN NUMBER,
625 p_dest_bill_seq_id IN NUMBER,
626 x_Return_Status OUT NOCOPY VARCHAR2);
627
628
629
630 /*#
631 * This Procedure is used to delete related ref desgs from the referencing boms when ref desg
632 * from the source bom is deleted.
633 * @param p_src_comp_seq IN Component Sequence Id of the source component.
634 * @param p_ref_desg IN Ref Desg of the dest source component.
635 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
636 * @rep:scope private
637 * @rep:compatibility S
638 * @rep:displayname Delete Related Reference Designators
639 * @rep:lifecycle active
640 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
641 */
642 Procedure Delete_Related_Ref_Desg(p_src_comp_seq IN NUMBER
643 , p_ref_desg IN VARCHAR2
644 , x_Return_Status IN OUT NOCOPY VARCHAR2);
645
646 /*#
647 * This Procedure is used to delete related sub comps from the referencing boms when sub comps
648 * from the source bom is deleted.
649 * @param p_src_comp_seq IN Component Sequence Id of the source component.
650 * @param p_sub_comp_item_id IN Sub Comp of the dest source component.
651 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
652 * @rep:scope private
653 * @rep:compatibility S
654 * @rep:displayname Delete Related Substitute Components
655 * @rep:lifecycle active
656 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
657 */
658 Procedure Delete_Related_Sub_Comp(p_src_comp_seq IN NUMBER
659 , p_sub_comp_item_id IN NUMBER
660 , x_Return_Status IN OUT NOCOPY VARCHAR2);
661
662 /*#
663 * This Function is used to check if the insertion of related records caused overlapping components
664 * @param p_dest_bill_sequence_id IN Bill Sequence Id of the dest component.
665 * @param p_dest_comp_seq_id IN component seq id of the dest component.
666 * @param p_comp_item_id IN component item id
667 * @param p_op_seq_num IN op seq of source component
668 * @param p_change_notice IN change notice opf the source comp
669 * @param p_eff_date IN eff date of component
670 * @param p_disable_date IN disable date of component
671 * @param p_impl_date IN implementation date of component
672 * @param p_rev_item_seq_id IN rev item sequence id of component
673 * @param p_src_bill_seq_id IN source bill seq id
674 * @rep:scope private
675 * @rep:compatibility S
676 * @rep:displayname Delete Related Substitute Components
677 * @rep:lifecycle active
678 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
679 */
680 Function Check_Component_Overlap(p_dest_bill_sequence_id IN NUMBER
681 , p_dest_comp_seq_id IN NUMBER
682 , p_comp_item_id IN NUMBER
683 , p_op_seq_num IN NUMBER
684 , p_change_notice IN VARCHAR2
685 , p_eff_date IN DATE
686 , p_disable_date IN DATE
687 , p_impl_date IN DATE
688 , p_rev_item_seq_id IN NUMBER
692
689 , p_src_bill_seq_id IN NUMBER
690 )
691 Return Boolean;
693
694 /*#
695 * This Procedure is used to delete the unimplemented related components and their child entities.
696 * @param p_src_comp_seq_id IN Comp Sequence Id of the source component.
697 * @param x_Return_Status IN OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
698 * @rep:scope private
699 * @rep:compatibility S
700 * @rep:displayname Delete Related Substitute Components
701 * @rep:lifecycle active
702 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
703 */
704 Procedure Delete_Related_Pending_Comps(p_src_comp_seq_id IN NUMBER
705 , x_Return_Status IN OUT NOCOPY VARCHAR2);
706
707 ------------------------------------------------------------------------
708 -- API name : Copy_Pending_Dest_Components --
709 -- Type : Private --
710 -- Pre-reqs : None. --
711 -- Procedure : Propagates the specified ECO --
712 -- Parameters : --
713 -- IN : p_src_old_comp_seq_id NUMBER Required --
714 -- p_src_comp_seq_id NUMBER Required --
715 -- p_change_notice vARCHAR2 Required --
716 -- p_revised_item_sequence_id NUMBER Required --
717 -- p_effectivity_date NUMBER Required --
718 -- OUT : x_return_status VARCHAR2(1) --
719 -- Version : Current version 1.0 --
720 -- Initial version 1.0 --
721 -- --
722 -- Notes : This API is invoked only when a common bill has --
723 -- pending changes associated for its WIP supply type --
724 -- attributes and the common component in the source --
725 -- bill is being implemented. --
726 -- API Copy_Revised_Item is called and then --
727 -- A copy of all the destination changes are then made --
728 -- to this revised item with the effectivity range of --
729 -- the component being implemented. --
730 ------------------------------------------------------------------------
731
732 PROCEDURE Copy_Pending_Dest_Components (
733 p_src_old_comp_seq_id IN NUMBER
734 , p_src_comp_seq_id IN NUMBER
735 , p_change_notice IN VARCHAR2
736 , p_organization_id IN NUMBER
737 , p_revised_item_sequence_id IN NUMBER
738 , p_effectivity_date IN DATE
739 , x_return_status OUT NOCOPY VARCHAR2
740 ) ;
741
742
743 PROCEDURE check_comp_rev_in_local_org(p_src_bill_seq_id IN NUMBER,
744 p_org_id IN NUMBER,
745 x_return_status OUT NOCOPY VARCHAR2);
746
747 Function get_rev_id_for_local_org(p_rev_id IN NUMBER, p_org_id IN NUMBER)
748 Return NUMBER;
749
750 Function Check_comp_rev_for_Com_Boms(p_rev_id IN NUMBER, p_src_bill_seq_id IN NUMBER)
751 RETURN VARCHAR2;
752
753 END bompcmbm;