1 PACKAGE BOMPCMBM AS
2 /* $Header: BOMCMBMS.pls 120.9 2006/05/25 06:24:59 arudresh 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
138
139 /*#
140 * This is an overloaded Procedure called when a component is added to a bom that is commoned by other boms.
141 * This will add the component to the common boms.
142 * @param p_src_bill_seq_id IN Bill Sequence Id of the source BOM
143 * @param p_src_comp_seq_id IN Component Sequence Id of the component added
144 * @rep:scope private
145 * @rep:compatibility S
146 * @rep:displayname Insert Related Components
147 * @rep:lifecycle active
148 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
149 */
150 PROCEDURE Insert_Related_Components (p_src_bill_seq_id IN NUMBER
151 , p_src_comp_seq_id IN NUMBER);
152
153
154
155
156 /*#
157 * This Procedure should be called when a component is updated in a bom that is commoned by other boms.
158 * This will update the component in the common boms.
159 * @param p_src_comp_seq_id IN Component Sequence Id of the component updated
160 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
161 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
162 * @rep:scope private
163 * @rep:compatibility S
164 * @rep:displayname Update Related Components
165 * @rep:lifecycle active
166 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
167 */
168 PROCEDURE Update_Related_Components (p_src_comp_seq_id IN NUMBER
169 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
170 , x_Return_Status IN OUT NOCOPY VARCHAR2);
171
172
173
174
175
176 /*#
177 * This overloaded Procedure should be called from java when a component is updated in a bom that is commoned by other boms.
178 * This will update the component in the common boms.
179 * @param p_src_comp_seq_id IN Component Sequence Id of the component updated
180 * @rep:scope private
181 * @rep:compatibility S
182 * @rep:displayname Update Related Components
183 * @rep:lifecycle active
184 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
185 */
186 PROCEDURE Update_Related_Components (p_src_comp_seq_id IN NUMBER);
187
188
189
190
191 /*#
192 * This Procedure will replicate the ref designators of components of the source BOM as ref desgs of components of the Common BOM.
193 * @param p_component_sequence_id IN Component Sequence Id of the component updated
194 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
195 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
196 * @rep:scope private
197 * @rep:compatibility S
198 * @rep:displayname Replicate Reference Designators
199 * @rep:lifecycle active
200 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
201 */
202 PROCEDURE Replicate_Ref_Desg(p_component_sequence_id IN NUMBER
203 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
204 , x_Return_Status IN OUT NOCOPY VARCHAR2);
205
206
207
208
209 /*#
210 * 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.
211 * @param p_component_sequence_id IN Component Sequence Id of the component updated
212 * @rep:scope private
213 * @rep:compatibility S
214 * @rep:displayname Replicate Reference Designators
215 * @rep:lifecycle active
216 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
217 */
218 PROCEDURE Replicate_Ref_Desg(p_component_sequence_id IN NUMBER);
219
220
221
222
223 /*#
224 * This Procedure is used to add reference designators to the related components of the common boms whenever
225 * reference designator is added to a component of a source bom.
226 * @param p_component_sequence_id IN Component Sequence Id of the component updated
227 * @param p_ref_desg IN Reference Designator added.
228 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
229 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
230 * @rep:scope private
231 * @rep:compatibility S
232 * @rep:displayname Insert Related Reference Designators
233 * @rep:lifecycle active
234 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
235 */
236 PROCEDURE Insert_Related_Ref_Desg(p_component_sequence_id IN NUMBER
237 , p_ref_desg IN VARCHAR2
238 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
239 , x_Return_Status IN OUT NOCOPY VARCHAR2);
240
241
242
243
244 /*#
245 * This overloaded Procedure is called from Java to add reference designators to the related components of the common boms whenever
246 * reference designator is added to a component of a source bom.
247 * @param p_component_sequence_id IN Component Sequence Id of the component updated
248 * @param p_ref_desg IN Reference Designator added.
249 * @rep:scope private
250 * @rep:compatibility S
251 * @rep:displayname Insert Related Reference Designators
252 * @rep:lifecycle active
253 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
254 */
255 PROCEDURE Insert_Related_Ref_Desg(p_component_sequence_id IN NUMBER
256 , p_ref_desg IN VARCHAR2);
257
258
259
260
261
262 /*#
263 * This Procedure is used to update reference designators of the related components of the common boms whenever
264 * reference designator of a component of a source bom is updated.
265 * @param p_component_sequence_id IN Component Sequence Id of the component updated
266 * @param p_old_ref_desg IN Original Reference Designator updated.
267 * @param p_new_ref_desg IN Modified Reference Designator.
268 * @param p_acd_type IN ACD type of the record.
269 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
270 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
271 * @rep:scope private
272 * @rep:compatibility S
273 * @rep:displayname Update Related Reference Designators
274 * @rep:lifecycle active
275 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
276 */
277 PROCEDURE Update_Related_Ref_Desg(p_component_sequence_id IN NUMBER
278 , p_old_ref_desg IN VARCHAR2
279 , p_new_ref_desg IN VARCHAR2
280 , p_acd_type IN NUMBER
281 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
282 , x_Return_Status IN OUT NOCOPY VARCHAR2);
283
284
285
286
287
288 /*#
289 * This overloaded Procedure is called from Java to update reference designators of the related components of the common boms whenever
290 * reference designator of a component of a source bom is updated.
291 * @param p_component_sequence_id IN Component Sequence Id of the component updated
295 * @rep:scope private
292 * @param p_old_ref_desg IN Original Reference Designator updated.
293 * @param p_new_ref_desg IN Modified Reference Designator.
294 * @param p_acd_type IN ACD type of the record.
296 * @rep:compatibility S
297 * @rep:displayname Update Related Reference Designators
298 * @rep:lifecycle active
299 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
300 */
301 PROCEDURE Update_Related_Ref_Desg(p_component_sequence_id IN NUMBER
302 , p_old_ref_desg IN VARCHAR2
303 , p_new_ref_desg IN VARCHAR2
304 , p_acd_type IN NUMBER);
305
306
307
308 /*#
309 * This Procedure will replicate the substitutes of components of the source BOM as susbtitutes of components of the Common BOM.
310 * @param p_component_sequence_id IN Component Sequence Id of the component updated
311 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
312 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
313 * @rep:scope private
314 * @rep:compatibility S
315 * @rep:displayname Replicate Substitute Components
316 * @rep:lifecycle active
317 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
318 */
319 PROCEDURE Replicate_Sub_Comp(p_component_sequence_id IN NUMBER
320 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
321 , x_Return_Status IN OUT NOCOPY VARCHAR2);
322
323
324
325
326
327 /*#
328 * This overloaded Procedure is called from Java to replicate the substitutes of components of the source BOM
329 * as susbtitutes of components of the Common BOM.
330 * @param p_component_sequence_id IN Component Sequence Id of the component updated
331 * @rep:scope private
332 * @rep:compatibility S
333 * @rep:displayname Replicate Substitute Components
334 * @rep:lifecycle active
335 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
336 */
337 PROCEDURE Replicate_Sub_Comp(p_component_sequence_id IN NUMBER);
338
339
340
341 /*#
342 * This Procedure is used to add Substitute Components to the related components of the common boms whenever
343 * a substitute component is added to a component of a source bom.
344 * @param p_component_sequence_id IN Component Sequence Id of the component updated
345 * @param p_sub_comp_item_id IN Substitute Component Id added.
346 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
347 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
348 * @rep:scope private
349 * @rep:compatibility S
350 * @rep:displayname Insert Related Substitute Components
351 * @rep:lifecycle active
352 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
353 */
354 PROCEDURE Insert_Related_Sub_Comp(p_component_sequence_id IN NUMBER
355 , p_sub_comp_item_id IN NUMBER
356 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
357 , x_Return_Status IN OUT NOCOPY VARCHAR2);
358
359
360
361
362 /*#
363 * This overloaded Procedure is called from Java to add Substitute Components to the related components of the common boms whenever
364 * a substitute component is added to a component of a source bom.
365 * @param p_component_sequence_id IN Component Sequence Id of the component updated
366 * @param p_sub_comp_item_id IN Substitute Component Id added.
367 * @rep:scope private
368 * @rep:compatibility S
369 * @rep:displayname Insert Related Substitute Components
370 * @rep:lifecycle active
371 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
372 */
373 PROCEDURE Insert_Related_Sub_Comp(p_component_sequence_id IN NUMBER
374 , p_sub_comp_item_id IN NUMBER);
375
376
377
378
379 /*#
380 * This Procedure is used to update substitutes of the related components of the common boms whenever
381 * substitute of a component of a source bom is updated.
382 * @param p_component_sequence_id IN Component Sequence Id of the component updated
383 * @param p_old_sub_comp_item_id IN Original Substitute Component Id.
384 * @param p_new_sub_comp_item_id IN Substitute Component Id modified.
385 * @param p_acd_type IN ACD type of the record.
386 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
387 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
388 * @rep:scope private
389 * @rep:compatibility S
390 * @rep:displayname Update Related Substitute Components
391 * @rep:lifecycle active
392 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
393 */
394 PROCEDURE Update_Related_Sub_Comp(p_component_sequence_id IN NUMBER
395 , p_old_sub_comp_item_id IN NUMBER
396 , p_new_sub_comp_item_id IN NUMBER
397 , p_acd_type IN NUMBER
398 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
399 , x_Return_Status IN OUT NOCOPY VARCHAR2);
400
401
402
403
404 /*#
405 * This overloaded Procedure is called from Java to update substitutes of the related components of the common boms whenever
406 * substitute of a component of a source bom is updated.
407 * @param p_component_sequence_id IN Component Sequence Id of the component updated
408 * @param p_old_sub_comp_item_id IN Original Substitute Component Id.
409 * @param p_new_sub_comp_item_id IN Substitute Component Id modified.
410 * @param p_acd_type IN ACD type of the record.
411 * @rep:scope private
412 * @rep:compatibility S
413 * @rep:displayname Update Related Substitute Components
414 * @rep:lifecycle active
418 , p_old_sub_comp_item_id IN NUMBER
415 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
416 */
417 PROCEDURE Update_Related_Sub_Comp(p_component_sequence_id IN NUMBER
419 , p_new_sub_comp_item_id IN NUMBER
420 , p_acd_type IN NUMBER);
421
422
423
424 /*#
425 * This Procedure will replicate the component operations of the source BOM as component operations of the Common BOM.
426 * @param p_component_sequence_id IN Component Sequence Id of the component updated
427 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
428 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
429 * @rep:scope private
430 * @rep:compatibility S
431 * @rep:displayname Replicate Component Operations
432 * @rep:lifecycle active
433 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
434 */
435 PROCEDURE Replicate_Comp_Ops(p_component_sequence_id IN NUMBER
439
436 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
437 , x_Return_Status IN OUT NOCOPY VARCHAR2);
438
440
441
442
443 /*#
444 * This overloaded Procedure is called from Java to replicate the component operations of the source BOM
445 * as component operations of the Common BOM.
446 * @param p_component_sequence_id IN Component Sequence Id of the component updated
447 * @rep:scope private
448 * @rep:compatibility S
449 * @rep:displayname Replicate Component Operations
450 * @rep:lifecycle active
451 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
452 */
453 PROCEDURE Replicate_Comp_Ops(p_component_sequence_id IN NUMBER);
454
455
456
457 /*#
458 * This Procedure is used to add Component Operations to the related components of the common boms whenever
459 * a component operation is added to a component of a source bom.
460 * @param p_component_sequence_id IN Component Sequence Id of the component updated
461 * @param p_operation_seq_num IN Component Operation sequence number added.
462 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
463 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
464 * @rep:scope private
465 * @rep:compatibility S
466 * @rep:displayname Insert Related Component Operations
467 * @rep:lifecycle active
468 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
469 */
470 PROCEDURE Insert_Related_Comp_Ops(p_component_sequence_id IN NUMBER
471 , p_operation_seq_num IN NUMBER
472 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
473 , x_Return_Status IN OUT NOCOPY VARCHAR2);
474
475
476
477
478 /*#
479 * This overloaded Procedure is called from Java to add Component Operations to the related components of the common boms whenever
480 * a Component Operation is added to a component of a source bom.
481 * @param p_component_sequence_id IN Component Sequence Id of the component updated
482 * @param p_operation_seq_num IN Operation Sequence added.
483 * @rep:scope private
484 * @rep:compatibility S
485 * @rep:displayname Insert Related Component Operations
486 * @rep:lifecycle active
487 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
488 */
489 PROCEDURE Insert_Related_Comp_Ops(p_component_sequence_id IN NUMBER
490 , p_operation_seq_num IN NUMBER);
491
492
493
494
495 /*#
496 * This Procedure is used to update Component Operations of the related components of the common boms whenever
497 * Component Operations of a source bom is updated.
498 * @param p_component_sequence_id IN Component Sequence Id of the component updated
499 * @param p_old_operation_seq_num IN old Component Operation seq num.
500 * @param p_new_operation_seq_num IN new Component Operation seq num modified.
501 * @param x_Mesg_Token_Tbl IN OUT Message tokens in the error message thrown.
502 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
503 * @rep:scope private
504 * @rep:compatibility S
505 * @rep:displayname Update Related Component Operations
506 * @rep:lifecycle active
507 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
508 */
509 PROCEDURE Update_Related_Comp_Ops(p_component_sequence_id IN NUMBER
510 , p_old_operation_seq_num IN NUMBER
511 , p_new_operation_seq_num IN NUMBER
512 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
513 , x_Return_Status IN OUT NOCOPY VARCHAR2);
514
515
516
517
518 /*#
519 * This overloaded Procedure is called from Java to update Component Operations of the common boms whenever
520 * Component Operations of a source bom is updated.
521 * @param p_component_sequence_id IN Component Sequence Id of the component updated
522 * @param p_old_operation_seq_num IN old Component Operation seq num.
523 * @param p_new_operation_seq_num IN new Component Operation seq num modified.
524 * @rep:scope private
525 * @rep:compatibility S
526 * @rep:displayname Update Related Component Operations
527 * @rep:lifecycle active
528 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
529 */
530 PROCEDURE Update_Related_Comp_Ops(p_component_sequence_id IN NUMBER
531 , p_old_operation_seq_num IN NUMBER
532 , p_new_operation_seq_num IN NUMBER);
533
534
535
536
537 /*#
538 * This Procedure is used to delete related comp ops from the referencing boms when comp ops
539 * from the source bom is deleted.
540 * @param p_src_comp_seq_id IN Component Sequence Id of the source component.
541 * @param p_operation_seq_num IN Operation sequence number of the dest source component.
542 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
543 * @rep:scope private
544 * @rep:compatibility S
545 * @rep:displayname Delete Related Component Operations
546 * @rep:lifecycle active
547 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
548 */
549 PROCEDURE Delete_Related_Comp_Ops(p_src_comp_seq_id IN NUMBER,
550 p_operation_seq_num IN NUMBER,
551 x_Return_Status IN OUT NOCOPY VARCHAR2);
552
553
554 /*#
555 * This Procedure is used to validate the operation sequences of the source bom.
559 * @param p_alt_desg IN Alternate BOM Designator of the BOM
556 * @param p_src_bill_sequence_id IN Bill Sequence Id of the source bom
557 * @param p_assembly_item_id IN Assembly Item Id of the common bom.
558 * @param p_organization_id IN Organization Id of the Commmon BOM
560 * @param x_Return_Status IN OUT Return Status of the api: S(uccess)/E(rror)/U(nexpected) error
561 * @rep:scope private
562 * @rep:compatibility S
563 * @rep:displayname Validate Operation Sequence Id
564 * @rep:lifecycle active
565 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
566 */
567 PROCEDURE Validate_Operation_Sequence_Id(p_src_bill_sequence_id IN NUMBER
568 , p_assembly_item_id IN NUMBER
569 , p_organization_id IN NUMBER
570 , p_alt_desg IN VARCHAR2
571 , x_Return_Status IN OUT NOCOPY VARCHAR2);
572
573
574
575
576 /*#
577 * This Procedure is used to copy the component user attributes from the source bom.
578 * @param p_src_comp_seq_id IN Component Sequence Id of the source source component.
579 * @param p_attr_grp_id IN Attribute Group Id of the source component.
580 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
581 * @rep:scope private
582 * @rep:compatibility S
583 * @rep:displayname Validate Operation Sequence Id
584 * @rep:lifecycle active
585 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
586 */
587 Procedure Propagate_Comp_User_Attributes(p_src_comp_seq_id IN NUMBER
588 , p_attr_grp_id IN NUMBER
589 , x_Return_Status OUT NOCOPY VARCHAR2);
590
591
592 /*#
593 * This Function is used to validate the operation seq num from the source bom
594 * whenever a component is added to it.
595 * @return boolean
596 * @param p_src_bill_seq_id IN Bill Sequence Id of the source bom.
597 * @param p_op_seq IN Operation Sequence number
598 * @rep:scope private
599 * @rep:compatibility S
600 * @rep:displayname Check Operation Sequence Id in Referring BOMs
601 * @rep:lifecycle active
602 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
603 */
604 Function Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id IN NUMBER
605 , p_op_seq IN NUMBER)
606 Return boolean;
607
608
609
610 /*#
611 * This Procedure is used to replicate the component user attributes from the source bom.
612 * @param p_src_bill_seq_id IN Bill Sequence Id of the source component.
613 * @param p_dest_bill_seq_id IN Bill Sequence Id of the dest source component.
614 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
615 * @rep:scope private
616 * @rep:compatibility S
617 * @rep:displayname Replicate Component User Attributes
618 * @rep:lifecycle active
619 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
620 */
621 Procedure Replicate_Comp_User_Attrs(p_src_bill_seq_id IN NUMBER,
622 p_dest_bill_seq_id IN NUMBER,
623 x_Return_Status OUT NOCOPY VARCHAR2);
624
625
626
627 /*#
628 * This Procedure is used to delete related ref desgs from the referencing boms when ref desg
629 * from the source bom is deleted.
630 * @param p_src_comp_seq IN Component Sequence Id of the source component.
631 * @param p_ref_desg IN Ref Desg of the dest source component.
632 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
633 * @rep:scope private
634 * @rep:compatibility S
635 * @rep:displayname Delete Related Reference Designators
636 * @rep:lifecycle active
637 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
638 */
639 Procedure Delete_Related_Ref_Desg(p_src_comp_seq IN NUMBER
640 , p_ref_desg IN VARCHAR2
641 , x_Return_Status IN OUT NOCOPY VARCHAR2);
642
643 /*#
644 * This Procedure is used to delete related sub comps from the referencing boms when sub comps
645 * from the source bom is deleted.
646 * @param p_src_comp_seq IN Component Sequence Id of the source component.
647 * @param p_sub_comp_item_id IN Sub Comp of the dest source component.
648 * @param x_Return_Status OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
649 * @rep:scope private
650 * @rep:compatibility S
651 * @rep:displayname Delete Related Substitute Components
652 * @rep:lifecycle active
653 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
654 */
655 Procedure Delete_Related_Sub_Comp(p_src_comp_seq IN NUMBER
656 , p_sub_comp_item_id IN NUMBER
657 , x_Return_Status IN OUT NOCOPY VARCHAR2);
658
659 /*#
660 * This Function is used to check if the insertion of related records caused overlapping components
661 * @param p_dest_bill_sequence_id IN Bill Sequence Id of the dest component.
662 * @param p_dest_comp_seq_id IN component seq id of the dest component.
663 * @param p_comp_item_id IN component item id
664 * @param p_op_seq_num IN op seq of source component
665 * @param p_change_notice IN change notice opf the source comp
666 * @param p_eff_date IN eff date of component
667 * @param p_disable_date IN disable date of component
668 * @param p_impl_date IN implementation date of component
669 * @param p_rev_item_seq_id IN rev item sequence id of component
670 * @param p_src_bill_seq_id IN source bill seq id
671 * @rep:scope private
672 * @rep:compatibility S
673 * @rep:displayname Delete Related Substitute Components
674 * @rep:lifecycle active
675 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
676 */
680 , p_op_seq_num IN NUMBER
677 Function Check_Component_Overlap(p_dest_bill_sequence_id IN NUMBER
678 , p_dest_comp_seq_id IN NUMBER
679 , p_comp_item_id IN NUMBER
681 , p_change_notice IN VARCHAR2
682 , p_eff_date IN DATE
683 , p_disable_date IN DATE
684 , p_impl_date IN DATE
685 , p_rev_item_seq_id IN NUMBER
686 , p_src_bill_seq_id IN NUMBER
687 )
688 Return Boolean;
689
690
691 /*#
692 * This Procedure is used to delete the unimplemented related components and their child entities.
693 * @param p_src_comp_seq_id IN Comp Sequence Id of the source component.
694 * @param x_Return_Status IN OUT Return Status of the API: S(uccess)/E(rror)/U(nexpected) error
695 * @rep:scope private
696 * @rep:compatibility S
697 * @rep:displayname Delete Related Substitute Components
698 * @rep:lifecycle active
699 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
700 */
701 Procedure Delete_Related_Pending_Comps(p_src_comp_seq_id IN NUMBER
702 , x_Return_Status IN OUT NOCOPY VARCHAR2);
703
704 ------------------------------------------------------------------------
705 -- API name : Copy_Pending_Dest_Components --
706 -- Type : Private --
707 -- Pre-reqs : None. --
708 -- Procedure : Propagates the specified ECO --
709 -- Parameters : --
710 -- IN : p_src_old_comp_seq_id NUMBER Required --
711 -- p_src_comp_seq_id NUMBER Required --
712 -- p_change_notice vARCHAR2 Required --
713 -- p_revised_item_sequence_id NUMBER Required --
714 -- p_effectivity_date NUMBER Required --
715 -- OUT : x_return_status VARCHAR2(1) --
716 -- Version : Current version 1.0 --
717 -- Initial version 1.0 --
718 -- --
719 -- Notes : This API is invoked only when a common bill has --
720 -- pending changes associated for its WIP supply type --
721 -- attributes and the common component in the source --
722 -- bill is being implemented. --
723 -- API Copy_Revised_Item is called and then --
724 -- A copy of all the destination changes are then made --
725 -- to this revised item with the effectivity range of --
726 -- the component being implemented. --
727 ------------------------------------------------------------------------
728
729 PROCEDURE Copy_Pending_Dest_Components (
730 p_src_old_comp_seq_id IN NUMBER
731 , p_src_comp_seq_id IN NUMBER
732 , p_change_notice IN VARCHAR2
733 , p_organization_id IN NUMBER
734 , p_revised_item_sequence_id IN NUMBER
735 , p_effectivity_date IN DATE
736 , x_return_status OUT NOCOPY VARCHAR2
737 ) ;
738
739
740 PROCEDURE check_comp_rev_in_local_org(p_src_bill_seq_id IN NUMBER,
741 p_org_id IN NUMBER,
742 x_return_status OUT NOCOPY VARCHAR2);
743
744 Function get_rev_id_for_local_org(p_rev_id IN NUMBER, p_org_id IN NUMBER)
745 Return NUMBER;
746
747 Function Check_comp_rev_for_Com_Boms(p_rev_id IN NUMBER, p_src_bill_seq_id IN NUMBER)
748 RETURN VARCHAR2;
749
750 END bompcmbm;
[Home] [Help]