1 package bom_oe_exploder_pkg AUTHID CURRENT_USER as
2 /* $Header: BOMORXPS.pls 120.0 2005/05/25 02:30:33 appldev noship $ */
3 /*#
4 * This API contains methods for the custom bom exploder for use by Order Entry.
5 * It creates a time independent 'OPTIONAL' or 'INCLUDED' or 'ALL' bom
6 * for the given item in the BOM_EXPLOSIONS table.
7 * @rep:scope public
8 * @rep:product BOM
9 * @rep:displayname Order Entry Exploder
10 * @rep:compatibility S
11 * @rep:lifecycle active
12 */
13
14
15 /*#
16 * This is the driving method for the Explosion
17 * External applications requiring data from explosion table will first invoke
18 * this procedure before selecting directly from the table.
19 * @param arg_org_id organization_id
20 * @param arg_starting_rev_date Starting Revision Date
21 * @param arg_expl_type Exploder Type OPTIONAL or INCLUDED
22 * @param arg_order_by The order by parameter 1-Operation Sequnece,Item Sequence
23 * 2-Item Sequence,Operation Sequence
24 * @param arg_levels_to_explode Number of levels to explode
25 * @param arg_item_id Item Id of assembly to explode
26 * @param arg_comp_code Concatenated Component Code
27 * @param arg_user_id User Id
28 * @param arg_err_msg Error Message Out Buffer
29 * @param arg_error_code Error code out.Returns sql error code
30 * if sql error, 9999 if loop detected.
31 * @param arg_alt_bom_desig Alternate Bom Designator
32 * @rep:scope public
33 * @rep:displayname Exploder
34 * @rep:compatibility S
35 * @rep:lifecycle active
36 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
37 */
38 PROCEDURE be_exploder (
39 arg_org_id IN NUMBER,
40 arg_starting_rev_date IN DATE,
41 arg_expl_type IN VARCHAR2 DEFAULT 'OPTIONAL',
42 arg_order_by IN NUMBER DEFAULT 1,
43 arg_levels_to_explode IN NUMBER DEFAULT 20,
44 arg_item_id IN NUMBER,
45 arg_comp_code IN VARCHAR2 DEFAULT '',
46 arg_user_id IN NUMBER DEFAULT 0,
47 arg_err_msg OUT NOCOPY VARCHAR2,
48 arg_error_code OUT NOCOPY NUMBER,
49 arg_alt_bom_desig IN VARCHAR2 DEFAULT NULL
50 );
51
52 /*#
53 * This method will delete a BOM from BOM_CONFIG_EXPLOSION.It uses Session Id as an arguement to identify the BOM
54 * an delete it.
55 * @param arg_session_id Session Id
56 * @rep:scope private
57 * @rep:displayname Delete Configuration Explosion
58 * @rep:compatibility S
59 * @rep:lifecycle active
60 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
61 */
62
63 PROCEDURE delete_config_exp (
64 arg_session_id IN NUMBER
65 );
66
67
68 END bom_oe_exploder_pkg;