[Home] [Help]
PACKAGE: APPS.AHL_MC_ITEMGROUP_PVT
Source
1 PACKAGE AHL_MC_ITEMGROUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVIGPS.pls 115.11 2003/10/23 11:41:35 tamdas noship $ */
3
4
5 ---------------------------------------
6 -- Define Record Type for Item Group --
7 ---------------------------------------
8 TYPE Item_group_Rec_Type IS RECORD (
9 ITEM_GROUP_ID NUMBER ,
10 NAME VARCHAR2(80) ,
11 SOURCE_ITEM_GROUP_ID NUMBER,
12 STATUS_CODE VARCHAR2(30),
13 STATUS_MEANING VARCHAR2(80) ,
14 TYPE_CODE VARCHAR2(30),
15 TYPE_MEANING VARCHAR2(80) ,
16 DESCRIPTION VARCHAR2(240) ,
17 OBJECT_VERSION_NUMBER NUMBER ,
18 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
19 ATTRIBUTE1 VARCHAR2(150) ,
20 ATTRIBUTE2 VARCHAR2(150) ,
21 ATTRIBUTE3 VARCHAR2(150) ,
22 ATTRIBUTE4 VARCHAR2(150) ,
23 ATTRIBUTE5 VARCHAR2(150) ,
24 ATTRIBUTE6 VARCHAR2(150) ,
25 ATTRIBUTE7 VARCHAR2(150) ,
26 ATTRIBUTE8 VARCHAR2(150) ,
27 ATTRIBUTE9 VARCHAR2(150) ,
28 ATTRIBUTE10 VARCHAR2(150) ,
29 ATTRIBUTE11 VARCHAR2(150) ,
30 ATTRIBUTE12 VARCHAR2(150) ,
31 ATTRIBUTE13 VARCHAR2(150) ,
32 ATTRIBUTE14 VARCHAR2(150) ,
33 ATTRIBUTE15 VARCHAR2(150) ,
34 OPERATION_FLAG VARCHAR2(1)
35 );
36
37
38
39 ----------------------------------------------
40 -- Define Record Type for Item Associations --
41 ----------------------------------------------
42 TYPE Item_Association_Rec_Type IS RECORD (
43 ITEM_ASSOCIATION_ID NUMBER ,
44 ITEM_GROUP_NAME VARCHAR2(80) ,
45 ITEM_GROUP_ID NUMBER ,
46 SOURCE_ITEM_ASSOCIATION_ID NUMBER ,
47 INVENTORY_ORG_CODE VARCHAR2(3) ,
48 INVENTORY_ORG_ID NUMBER ,
49 INVENTORY_ITEM_NAME VARCHAR2(2000) ,
50 INVENTORY_ITEM_ID NUMBER ,
51 REVISION VARCHAR2(3) ,
52 PRIORITY NUMBER ,
53 UOM_CODE VARCHAR2(3) ,
54 QUANTITY NUMBER ,
55 INTERCHANGE_TYPE_MEANING VARCHAR2(80) ,
56 INTERCHANGE_TYPE_CODE VARCHAR2(30) ,
57 INTERCHANGE_REASON VARCHAR2(2000),
58 OBJECT_VERSION_NUMBER NUMBER ,
59 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
60 ATTRIBUTE1 VARCHAR2(150) ,
61 ATTRIBUTE2 VARCHAR2(150) ,
62 ATTRIBUTE3 VARCHAR2(150) ,
63 ATTRIBUTE4 VARCHAR2(150) ,
64 ATTRIBUTE5 VARCHAR2(150) ,
65 ATTRIBUTE6 VARCHAR2(150) ,
66 ATTRIBUTE7 VARCHAR2(150) ,
67 ATTRIBUTE8 VARCHAR2(150) ,
68 ATTRIBUTE9 VARCHAR2(150) ,
69 ATTRIBUTE10 VARCHAR2(150) ,
70 ATTRIBUTE11 VARCHAR2(150) ,
71 ATTRIBUTE12 VARCHAR2(150) ,
72 ATTRIBUTE13 VARCHAR2(150) ,
73 ATTRIBUTE14 VARCHAR2(150) ,
74 ATTRIBUTE15 VARCHAR2(150) ,
75 OPERATION_FLAG VARCHAR2(1) := NULL
76 );
77
78 ----------------------------------------------
79 -- Define Table Type for Item Associations --
80 ----------------------------------------------
81
82 TYPE Item_Association_Tbl_Type IS TABLE OF Item_Association_Rec_Type INDEX BY BINARY_INTEGER;
83
84
85 -----------------------------------------
86 -- Declare Procedures for Item Groups --
87 -----------------------------------------
88
89 -- Start of Comments --
90 -- Procedure name : Create_Item_group
91 -- Type : Private
92 -- Function : Creates Item Group for Master Configuration in ahl_item_groups_b and TL tables.
93 -- Also creates item-group association in ahl_item_associations table.
94 -- Pre-reqs :
95 -- Parameters :
96 -- Standard IN Parameters :
97 -- p_api_version IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101 --
102 -- Standard OUT Parameters :
103 -- x_return_status OUT VARCHAR2 Required
104 -- x_msg_count OUT NUMBER Required
105 -- x_msg_data OUT VARCHAR2 Required
106 -- Item Group Record :
107 -- Name Required.
108 -- Language Required.
109 -- Source Language Required.
110 -- Item Associations Record :
111 -- Inventory_item_id Required and present and trackable in mtl_system_items_b.
112 -- priority Required.
113 -- Operation_code Required to be 'C'.(Create)
114 -- End of Comments --
115
116
117 PROCEDURE Create_Item_group (p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
124 p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
125 );
126
127
128
129 -- Start of Comments --
130 -- Procedure name : Modify_Item_group
131 -- Type : Private
132 -- Function : Modifies Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates/deletes/modifies item-group association in ahl_item_associations table.
133 -- Pre-reqs :
134 -- Parameters :
135 -- Standard IN Parameters :
136 -- p_api_version IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
138 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
140 --
141 -- Standard OUT Parameters :
142 -- x_return_status OUT VARCHAR2 Required
143 -- x_msg_count OUT NUMBER Required
144 -- x_msg_data OUT VARCHAR2 Required
145 -- Item Group Record :
146 -- Item_Group_id Required.
147 -- Name Required.
148 -- Language Required.
149 -- Source Language Required.
150 -- Item Associations Record :
151 -- Item_association_id Required.
152 -- Item_group_id Required.
153 -- Inventory_item_id Required and present in mtl_system_items_b.
154 -- priority Required.
155 -- Operation_flag Required. (C = Create, M = Modify, D = Delete).
156 -- End of Comments --
157
158 PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160 --p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
166 p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
167 );
168
169
170 -- Start of Comments --
171 -- Procedure name : Remove_Item_group
172 -- Type : Private
173 -- Function : Deletes an Item Group from ahl_item_groups_b/ahl_item_groups_tl and all the associated
174 -- item associations from ahl_item_associations_b/TL tables.
175 -- Pre-reqs :
176 -- Parameters :
177 -- Standard IN Parameters :
178 -- p_api_version IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182 --
183 -- Standard OUT Parameters :
184 -- x_return_status OUT VARCHAR2 Required
185 -- x_msg_count OUT NUMBER Required
186 -- x_msg_data OUT VARCHAR2 Required
187 -- Item Group Record :
188 -- Item_Group_id Required.
189 -- Object_version_number Required.
190 -- Name Optional.
191 --
192 -- End of Comments --
193
194 PROCEDURE Remove_Item_group (p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type
201 );
202
203
204
205 -- Start of Comments --
209 -- Version : Added for 115.10
206 -- Procedure name : Initiate_Itemgroup_Appr
207 -- Type : Private
208 -- Function : Intiates Approval Process for Item groups
210 --
211 -- Pre-reqs :
212 -- Parameters :
213 -- Standard IN Parameters :
214 -- p_api_version IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
216 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
218 --
219 -- Standard OUT Parameters :
220 -- x_return_status OUT VARCHAR2 Required
221 -- x_msg_count OUT NUMBER Required
222 -- x_msg_data OUT VARCHAR2 Required
223 --
224 -- Source_Item_Group_id Required.
225 -- Object_version_number Required.
226 -- Approval type Required.
227 --
228 --
229 -- End of Comments --
230
231 PROCEDURE Initiate_Itemgroup_Appr (
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234 p_commit IN VARCHAR2 := FND_API.G_FALSE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236 P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
237 P_MODULE_TYPE IN VARCHAR2,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_source_item_group_id IN NUMBER,
242 p_object_version_number IN NUMBER,
243 P_Approval_Type IN VARCHAR2
244 );
245
246
247 -- Start of Comments --
248 -- Procedure name : Create_ItemGroup_Revision
249 -- Type : Private
250 -- Function : To create a New Revision of Item group
251 -- Version : Added for 115.10
252 --
253 -- Pre-reqs :
254 -- Parameters :
255 -- Standard IN Parameters :
256 -- p_api_version IN NUMBER Required
257 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260 --
261 -- Standard OUT Parameters :
262 -- x_return_status OUT VARCHAR2 Required
263 -- x_msg_count OUT NUMBER Required
264 -- x_msg_data OUT VARCHAR2 Required
265
266 -- Source_Item_Group_id Required.
267 -- Object_version_number Required.
268 --
269 --
270 -- End of Comments --
271
272
273 PROCEDURE Create_ItemGroup_Revision (
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276 p_commit IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278 P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
279 P_MODULE_TYPE IN VARCHAR2,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_source_ItemGroup_id IN NUMBER,
284 p_object_version_number IN NUMBER,
285 x_ItemGroup_id OUT NOCOPY NUMBER
286 );
287
288
289 -- Start of Comments --
290 -- Procedure name : Approve_ItemGroups
291 -- Type : Private
292 -- Function : To Approve Item group will be called by approval package
293 -- Version : Added for 115.10
294 --
295 -- Pre-reqs :
296 -- Parameters :
297 -- Standard IN Parameters :
298 -- p_api_version IN NUMBER Required
299 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
300 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
301 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
302 --
303 -- Standard OUT Parameters :
304 -- x_return_status OUT VARCHAR2 Required
305 -- x_msg_count OUT NUMBER Required
306 -- x_msg_data OUT VARCHAR2 Required
307
308 -- P_appr_status Required.
309 -- Item_Group_id Required.
310 -- Object_version_number Required.
311 --
312 --
313 -- End of Comments --
314
315
316 PROCEDURE Approve_ItemGroups (
317 p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319 p_commit IN VARCHAR2 := FND_API.G_FALSE,
320 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321 P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
322 P_MODULE_TYPE IN VARCHAR2,
323 x_return_status OUT NOCOPY VARCHAR2,
324 x_msg_count OUT NOCOPY NUMBER,
325 x_msg_data OUT NOCOPY VARCHAR2,
326 p_appr_status IN VARCHAR2,
327 p_ItemGroups_id IN NUMBER,
328 p_object_version_number IN NUMBER);
329
330
331 PROCEDURE Modify_Position_Assos
332 (
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335 p_commit IN VARCHAR2 := FND_API.G_FALSE,
336 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337 p_module_type IN VARCHAR2,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_item_group_id IN NUMBER,
342 p_object_version_number IN NUMBER,
343 p_nodes_tbl IN AHL_MC_Node_PVT.Node_Tbl_Type
344 );
345
346 FUNCTION Fork_Or_Merge
347 (
348 p_item_group_id in number
349 )
350 RETURN NUMBER;
351
352
353
354 End AHL_MC_ITEMGROUP_PVT;