1 PACKAGE BOMPCEXP as
2 /* $Header: BOMCEXPS.pls 120.1 2005/06/21 12:06:07 rfarook noship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMCEXPS.pls |
9 | Description : This is the costing exploder. This exploder needs |
10 | to join to cst_default_cost_view to get the costing |
11 | attributes. |
12 | Parameters: org_id organization_id |
13 | grp_id unique value to identify current explosion |
14 | use value from sequence bom_explosion_temp_s|
15 | cst_type_id cost type id |
16 | err_msg error message out buffer |
17 | error_code error code out. returns sql error code |
18 | History: |
19 | 01-FEB-93 Shreyas Shah Initial coding |
20 | 06-JUN-93 Shreyas Shah Scrapped the costing exploder that joined |
21 | to CST_DEFAULT_COST_VIEW since it was |
22 | very slow. Now just calling bom exploder |
23 | and doing a post explosion update |
24 | 23-JUN-93 Evelyn Tran Add checking of COMPONENT_YIELD_FLAG when |
25 | computing extended quantity |
26 | |
27 +==========================================================================*/
28
29 PROCEDURE cst_exploder(
30 grp_id IN NUMBER,
31 org_id IN NUMBER,
32 cst_type_id IN NUMBER,
33 inq_flag IN NUMBER := 2,
34 err_msg IN OUT NOCOPY VARCHAR2,
35 error_code IN OUT NOCOPY NUMBER
36 );
37 END BOMPCEXP;