PACKAGE: APPS.BOMPBXIN

Source

1 PACKAGE BOMPBXIN AUTHID CURRENT_USER as
2 /* $Header: BOMBXINS.pls 120.1 2005/06/21 03:36:07 appldev ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1993 Oracle Corporation Belmont, California, USA          |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMBXINS.pls                                               |
9 | Description  : This is the bom exploder.				    |
10 | Parameters:   org_id          organization_id				    |
11 |               order_by        1 - Op seq, item seq			    |
12 |                               2 - Item seq, op seq			    |
13 |               grp_id          unique value to identify current explosion  |
14 |                               use value from seq bom_small_expl_temp_s    |
15 |               levels_to_explode					    |
16 |               bom_or_eng      1 - BOM					    |
17 |                               2 - ENG					    |
18 |               impl_flag       1 - implemented only			    |
19 |                               2 - both impl and unimpl		    |
20 |               explode_option  1 - All					    |
21 |                               2 - Current				    |
22 |                               3 - Current and future			    |
23 |		incl_oc_flag	1 - include OC and M under standard item    |
24 |				2 - do not include			    |
25 |               show_rev        1 - obtain current revision of component    |
26 |				2 - don't obtain current revision	    |
27 |		material_ctrl   1 - obtain subinventory locator		    |
28 |				2 - don't obtain subinventory locator	    |
29 |		lead_time	1 - calculate offset percent		    |
30 |				2 - don't calculate offset percent	    |
31 |               max_level       max bom levels permissible for org	    |
32 |               rev_date        explosion date                              |
33 |               err_msg         error message out buffer		    |
34 |               error_code      error code out.  returns sql error code	    |
35 |                               if sql error, 9999 if loop detected.	    |
36 | Revision								    |
37 |		Shreyas Shah	Creation				    |
38 | 02/10/94	Shreyas Shah	added common_bill_Seq_id to cursor	    |
39 |				added multi-org explosion		    |
40 |  08/03/95	Rob Yee		added parameters for 10SC		    |
41 |                                                                           |
42 +==========================================================================*/
43 
44 -- G_SortWidth constant number := 7; -- no more than 9999999 components per level
45 G_SortWidth constant number := Bom_Common_Definitions.G_Bom_SortCode_Width;
46 
47 PROCEDURE bom_exploder(
48 	verify_flag		IN NUMBER DEFAULT 0,
49 	online_flag		IN NUMBER DEFAULT 1,
50 	org_id 			IN NUMBER,
51 	order_by 		IN NUMBER DEFAULT 1,
52 	grp_id			IN NUMBER,
53 	levels_to_explode 	IN NUMBER DEFAULT 1,
54 	bom_or_eng		IN NUMBER DEFAULT 1,
55 	impl_flag		IN NUMBER DEFAULT 1,
56         plan_factor_flag	IN NUMBER DEFAULT 2,
57 	explode_option 		IN NUMBER DEFAULT 2,
58 	std_comp_flag		IN NUMBER DEFAULT 2,
59 	incl_oc_flag		IN NUMBER DEFAULT 1,
60 	max_level		IN NUMBER,
61 	unit_number_from	IN VARCHAR2,
62 	unit_number_to		IN VARCHAR2,
63 	rev_date		IN DATE DEFAULT sysdate,
64         show_rev        	IN NUMBER DEFAULT 2,
65  	material_ctrl   	IN NUMBER DEFAULT 2,
66  	lead_time		IN NUMBER DEFAULT 2,
67 	err_msg		 IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68 	error_code	 IN OUT NOCOPY /* file.sql.39 change */ NUMBER
69 );
70 
71 END BOMPBXIN;