1 package IBE_CCTBOM_PVT AUTHID CURRENT_USER as
2 /* $Header: IBEVCBMS.pls 115.4 2002/12/16 21:36:00 gzhang ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CCTBOM_PVT';
5
6
7 TYPE IBE_BOM_EXPLOSION_REC IS RECORD
8 (
9 component_item_id NUMBER,
10 plan_level NUMBER,
11 optional NUMBER,
12 parent_bom_item_type NUMBER,
13 bom_item_type NUMBER,
14 primary_uom_code VARCHAR2(3),
15 COMPONENT_QUANTITY NUMBER,
16 COMPONENT_CODE VARCHAR2(1000)
17 );
18
19 type IBE_CCTBOM_REF_CSR_TYPE is REF CURSOR;
20
21 --FUNCTION Validate_Model_Bundle(p_model_id IN NUMBER, p_org_id IN NUMBER) RETURN VARCHAR2;
22
23 -- Start of comments
24
25 -- API name : Is_Model_Bundle
26 -- Type : Private.
27 -- Function : Given a model item id, returns true if this is a model bundle-- ,otherwise returns false
28 --
29 -- Pre-reqs : None.
30 -- Parameters :
31 -- IN : p_api_version IN NUMBER Required
32 -- p_init_msg_list IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_validation_level IN NUMBER Optional
35 -- Default = FND_API.G_VALID_LEVEL_FULL
36 --
37 -- p_model_id IN NUMBER Required
38 -- p_orgnization_id IN NUMBER, Required
39 --
40 --
41 --
42 --
43 --
44 -- Version : Current version 1.0
45 --
46 -- previous version None
47 --
48 -- Initial version 1.0
49 -- Initial version 1.0
50
51 --
52
53 -- Notes : Note text
54
55 --
56
57 -- End of comments
58
59 Function Is_Model_Bundle
60 (p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_model_id IN NUMBER,
64 p_organization_id IN NUMBER
65 ) RETURN VARCHAR2;
66
67
68
69 -- Start of comments
70 -- API name : Load_Components
71 -- Type : Private.
72 -- Function : Given a model item id, retrieve all the component item ids of this model item
73 --
74 -- Pre-reqs : None.
75 -- Parameters :
76 -- IN : p_api_version IN NUMBER Required
77 -- p_init_msg_list IN VARCHAR2 Optional
78 -- Default = FND_API.G_FALSE
79 -- p_validation_level IN NUMBER Optional
80 -- Default = FND_API.G_VALID_LEVEL_FULL
81 --
82 -- p_model_id IN NUMBER Required
83 --
84 -- OUT : x_return_status OUT VARCHAR2(1)
85 -- x_msg_count OUT NUMBER
86 -- x_msg_data OUT VARCHAR2(2000)
87 -- x_model_bundle OUT VARCHAR2(1)
88 -- x_item_csr OUT IBE_CCTBOM_REF_CSR_TYPE
89 -- Record type = IBE_BOM_EXPLOSION_REC
90 --
91 --
92 --
93 --
94 -- Version : Current version 1.0
95 --
96 -- previous version None
97 --
98 -- Initial version 1.0
99 --
100 -- Notes : Note text
101 --
102 -- End of comments
103 procedure Load_Components
104
105 (p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111
112 p_model_id IN NUMBER,
113 p_organization_id IN NUMBER,
114 x_item_csr OUT NOCOPY IBE_CCTBOM_REF_CSR_TYPE
115 );
116
117 /*----------------------------------------------------------------------
118 Procedure Name : Explode
119 Description :
120 -----------------------------------------------------------------------*/
121 Procedure Explode
122 ( p_validation_org IN NUMBER
123 , p_group_id IN NUMBER := NULL
124 , p_session_id IN NUMBER := NULL
125 , p_levels IN NUMBER := 60
126 , p_stdcompflag IN VARCHAR2 := 'ALL'
127 , p_exp_quantity IN NUMBER := NULL
128 , p_top_item_id IN NUMBER
129 , p_revdate IN DATE
130 , p_component_code IN VARCHAR2 := NULL
131 , x_msg_data OUT NOCOPY VARCHAR2
132 , x_error_code OUT NOCOPY NUMBER
133 , x_return_status OUT NOCOPY VARCHAR2);
134
135
136
137 end IBE_CCTBOM_PVT;