1 package bompimpl as
2 /* $Header: BOMIMPLS.pls 120.1 2005/06/21 01:52:47 appldev ship $ */
3 /*#
4 * This API contains methods to implode BOM .It contains two different imploders,
5 * for single level and multi level implosion The procedure imploders calls the
6 * correct imploder based on the number of levels to implode.
7 * @rep:scope public
8 * @rep:product BOM
9 * @rep:displayname Item Where Used
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
12 */
13
14 /*==========================================================================+
15 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
16 | All rights reserved. |
17 +===========================================================================+
18 | |
19 | File Name : BOMPIMPL.sql |
20 | DESCRIPTION : This file is a packaged procedure for the imploders.
21 | This package contains 2 different imploders for the
22 | single level and multi level implosion. The package
23 | imploders calls the correct imploder based on the
24 | # of levels to implode.
25 | Parameters: org_id organization_id
26 | sequence_id unique value to identify current implosion
27 | use value from sequence bom_implosion_temp_s
28 | levels_to_implode
29 | eng_mfg_flag 1 - BOM
30 | 2 - ENG
31 | impl_flag 1 - implemented only
32 | 2 - both impl and unimpl
33 | display_option 1 - All
34 | 2 - Current
35 | 3 - Current and future
36 | item_id item id of asembly to explode
37 | impl_date explosion date dd-mon-yy hh24:mi
38 | err_msg error message out buffer
39 | error_code error code out. returns sql error code
40 | if sql error, 9999 if loop detected.
41 +==========================================================================*/
42
43 /*#
44 * Implode BOM Method. This is used for item whereused search.
45 * @param sequence_id unique value to identify current implosion use value from sequence
46 * bom_implosion_temp_s
47 * @param eng_mfg_flag 1 - BOM , 2 - ENG
48 * @param org_id organization_id
49 * @param impl_flag 1 - implemented only, 2 - both impl and unimpl
50 * @param display_option 1 - All, 2 - Current,3 - Current and future
51 * @param levels_to_implode number of levels to be imploded
52 * @param item_id item id of assembly to implode
53 * @param impl_date implosion date dd-mon-yy hh24:mi
54 * @param err_msg error message out buffer
55 * @param err_code error code out. returns sql error code if sql error, 9999 if loop detected
56 * @rep:scope public
57 * @rep:lifecycle active
58 * @rep:displayname Implode userexit
59 */
60 PROCEDURE imploder_userexit(
61 sequence_id IN NUMBER,
62 eng_mfg_flag IN NUMBER,
63 org_id IN NUMBER,
64 impl_flag IN NUMBER,
65 display_option IN NUMBER,
66 levels_to_implode IN NUMBER,
67 item_id IN NUMBER,
68 impl_date IN VARCHAR2,
69 err_msg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70 err_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER);
71
72 PROCEDURE implosion (
73 sequence_id IN NUMBER,
74 eng_mfg_flag IN NUMBER,
75 org_id IN NUMBER,
76 impl_flag IN NUMBER,
77 display_option IN NUMBER,
78 levels_to_implode IN NUMBER,
79 impl_date IN VARCHAR2,
80 err_msg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
81 err_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER);
82
83 PROCEDURE sl_imploder (
84 sequence_id IN NUMBER,
85 eng_mfg_flag IN NUMBER,
86 org_id IN NUMBER,
87 impl_flag IN NUMBER,
88 display_option IN NUMBER,
89 impl_date IN VARCHAR2,
90 err_msg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91 error_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER);
92
93 PROCEDURE ml_imploder(
94 sequence_id IN NUMBER,
95 eng_mfg_flag IN NUMBER,
96 org_id IN NUMBER,
97 impl_flag IN NUMBER,
98 a_levels_to_implode IN NUMBER,
99 impl_date IN VARCHAR2,
100 err_msg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101 error_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER);
102
103 END bompimpl;