[Home] [Help]
PACKAGE: APPS.AHL_MC_NODE_PVT
Source
1 PACKAGE AHL_MC_Node_PVT AS
2 /* $Header: AHLVNODS.pls 120.1 2005/07/04 01:59:01 tamdas noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MC_Node_PVT';
5
6 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
7 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
8 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
9 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
10
11 -------------------------------
12 -- Define records and tables --
13 -------------------------------
14 TYPE Node_Rec_Type IS RECORD
15 (
16 RELATIONSHIP_ID NUMBER,
17 MC_HEADER_ID NUMBER,
18 POSITION_KEY NUMBER,
19 POSITION_REF_CODE VARCHAR2(30),
20 POSITION_REF_MEANING VARCHAR2(80),
21 --priyan MEL-CDL
22 ATA_CODE VARCHAR2(30),
23 ATA_MEANING VARCHAR2(80),
24 POSITION_NECESSITY_CODE VARCHAR2(30),
25 POSITION_NECESSITY_MEANING VARCHAR2(80),
26 UOM_CODE VARCHAR2(3) := 'Ea',
27 QUANTITY NUMBER := 1,
28 PARENT_RELATIONSHIP_ID NUMBER := NULL,
29 ITEM_GROUP_ID NUMBER,
30 ITEM_GROUP_NAME VARCHAR2(80),
31 DISPLAY_ORDER NUMBER := 1,
32 ACTIVE_START_DATE DATE,
33 ACTIVE_END_DATE DATE,
34 OBJECT_VERSION_NUMBER NUMBER := 1,
35 SECURITY_GROUP_ID NUMBER,
36 ATTRIBUTE_CATEGORY VARCHAR2(30),
37 ATTRIBUTE1 VARCHAR2(150),
38 ATTRIBUTE2 VARCHAR2(150),
39 ATTRIBUTE3 VARCHAR2(150),
40 ATTRIBUTE4 VARCHAR2(150),
41 ATTRIBUTE5 VARCHAR2(150),
42 ATTRIBUTE6 VARCHAR2(150),
43 ATTRIBUTE7 VARCHAR2(150),
44 ATTRIBUTE8 VARCHAR2(150),
45 ATTRIBUTE9 VARCHAR2(150),
46 ATTRIBUTE10 VARCHAR2(150),
47 ATTRIBUTE11 VARCHAR2(150),
48 ATTRIBUTE12 VARCHAR2(150),
49 ATTRIBUTE13 VARCHAR2(150),
50 ATTRIBUTE14 VARCHAR2(150),
51 ATTRIBUTE15 VARCHAR2(150),
52 OPERATION_FLAG VARCHAR2(1) := NULL,
53 PARENT_NODE_REC_INDEX NUMBER
54 );
55
56 TYPE Node_Tbl_Type IS TABLE OF Node_Rec_Type INDEX BY BINARY_INTEGER;
57
58 TYPE Counter_Rule_Rec_Type IS RECORD
59 (
60 CTR_UPDATE_RULE_ID NUMBER,
61 RELATIONSHIP_ID NUMBER,
62 UOM_CODE VARCHAR2(3),
63 RULE_CODE VARCHAR2(30),
64 RULE_MEANING VARCHAR2(80),
65 RATIO NUMBER,
66 OBJECT_VERSION_NUMBER NUMBER := 1,
67 SECURITY_GROUP_ID NUMBER,
68 ATTRIBUTE_CATEGORY VARCHAR2(30),
69 ATTRIBUTE1 VARCHAR2(150),
70 ATTRIBUTE2 VARCHAR2(150),
71 ATTRIBUTE3 VARCHAR2(150),
72 ATTRIBUTE4 VARCHAR2(150),
73 ATTRIBUTE5 VARCHAR2(150),
74 ATTRIBUTE6 VARCHAR2(150),
75 ATTRIBUTE7 VARCHAR2(150),
76 ATTRIBUTE8 VARCHAR2(150),
77 ATTRIBUTE9 VARCHAR2(150),
78 ATTRIBUTE10 VARCHAR2(150),
79 ATTRIBUTE11 VARCHAR2(150),
80 ATTRIBUTE12 VARCHAR2(150),
81 ATTRIBUTE13 VARCHAR2(150),
82 ATTRIBUTE14 VARCHAR2(150),
83 ATTRIBUTE15 VARCHAR2(150),
84 OPERATION_FLAG VARCHAR2(1) := NULL,
85 NODE_TBL_INDEX NUMBER
86 );
87
88 TYPE Counter_Rules_Tbl_Type IS TABLE OF Counter_Rule_Rec_Type INDEX BY BINARY_INTEGER;
89
90 TYPE Subconfig_Rec_Type IS RECORD
91 (
92 MC_CONFIG_RELATION_ID NUMBER,
93 MC_HEADER_ID NUMBER,
94 NAME VARCHAR2(80),
95 VERSION_NUMBER NUMBER,
96 RELATIONSHIP_ID NUMBER,
97 ACTIVE_START_DATE DATE,
98 ACTIVE_END_DATE DATE,
99 OBJECT_VERSION_NUMBER NUMBER := 1,
100 PRIORITY NUMBER(15),
101 SECURITY_GROUP_ID NUMBER,
102 ATTRIBUTE_CATEGORY VARCHAR2(30),
103 ATTRIBUTE1 VARCHAR2(150),
104 ATTRIBUTE2 VARCHAR2(150),
105 ATTRIBUTE3 VARCHAR2(150),
106 ATTRIBUTE4 VARCHAR2(150),
107 ATTRIBUTE5 VARCHAR2(150),
108 ATTRIBUTE6 VARCHAR2(150),
109 ATTRIBUTE7 VARCHAR2(150),
110 ATTRIBUTE8 VARCHAR2(150),
111 ATTRIBUTE9 VARCHAR2(150),
112 ATTRIBUTE10 VARCHAR2(150),
113 ATTRIBUTE11 VARCHAR2(150),
114 ATTRIBUTE12 VARCHAR2(150),
115 ATTRIBUTE13 VARCHAR2(150),
116 ATTRIBUTE14 VARCHAR2(150),
117 ATTRIBUTE15 VARCHAR2(150),
118 OPERATION_FLAG VARCHAR2(1) := NULL
119 );
120
121 TYPE Subconfig_Tbl_Type IS TABLE OF Subconfig_Rec_Type INDEX BY BINARY_INTEGER;
122
123 -----------------------
124 -- Define procedures --
125 -----------------------
126 -- Start of Comments --
127 --
128 -- Procedure name : Create_Node
129 -- Type : Private
130 -- Function : Creates Master Configuration nodes
131 -- Pre-reqs :
132 --
133 -- Standard IN Parameters :
134 -- p_api_version IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
136 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
137 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138 --
139 -- Standard OUT Parameters :
140 -- x_return_status OUT VARCHAR2 Required
141 -- x_msg_count OUT NUMBER Required
142 -- x_msg_data OUT VARCHAR2 Required
143 --
144 -- Create_Node Parameters :
145 -- p_x_node_rec IN OUT Node_Rec_Type,
146 -- p_x_counter_rules_tbl IN OUT Counter_Rules_Tbl_Type,
147 -- p_x_subconfig_tbl IN OUT SubConfig_Tbl_Type
148 --
149 -- Version :
150 -- Initial Version 1.0
151 --
152 -- End of Comments --
153 PROCEDURE Create_Node
154 (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157 p_commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_x_node_rec IN OUT NOCOPY Node_Rec_Type,
163 p_x_counter_rules_tbl IN OUT NOCOPY Counter_Rules_Tbl_Type,
164 p_x_subconfig_tbl IN OUT NOCOPY SubConfig_Tbl_Type
165 );
166
167 -- Start of Comments --
168 --
169 -- Procedure name : Modify_Node
170 -- Type : Private
171 -- Function : Updates Master Configuration nodes
172 -- Pre-reqs :
173 --
174 -- Standard IN Parameters :
175 -- p_api_version IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
177 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
178 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
179 --
180 -- Standard OUT Parameters :
181 -- x_return_status OUT VARCHAR2 Required
182 -- x_msg_count OUT NUMBER Required
183 -- x_msg_data OUT VARCHAR2 Required
184 --
185 -- Create_Node Parameters :
186 -- p_x_node_rec IN OUT Node_Rec_Type,
187 -- p_x_counter_rules_tbl IN OUT Counter_Rules_Tbl_Type,
188 -- p_x_subconfig_tbl IN OUT SubConfig_Tbl_Type
189 --
190 -- Version :
191 -- Initial Version 1.0
192 --
193 -- End of Comments --
194 PROCEDURE Modify_Node
195 (
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_x_node_rec IN OUT NOCOPY Node_Rec_Type,
204 p_x_counter_rules_tbl IN OUT NOCOPY Counter_Rules_Tbl_Type,
205 p_x_subconfig_tbl IN OUT NOCOPY SubConfig_Tbl_Type
206 );
207
208 -- Start of Comments --
209 --
210 -- Procedure name : Delete_Node
211 -- Type : Private
212 -- Function : Delete Master Configuration nodes
213 -- Pre-reqs :
214 --
215 -- Standard IN Parameters :
216 -- p_api_version IN NUMBER Required
217 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220 --
221 -- Standard OUT Parameters :
222 -- x_return_status OUT VARCHAR2 Required
223 -- x_msg_count OUT NUMBER Required
224 -- x_msg_data OUT VARCHAR2 Required
225 --
226 -- Create_Node Parameters :
227 -- p_relationship_id IN NUMBER,
228 -- p_object_ver_num IN NUMBER
229 --
230 -- Version :
231 -- Initial Version 1.0
232 --
233 -- End of Comments --
234 PROCEDURE Delete_Node
235 (
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE,
239 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_node_id IN NUMBER,
244 p_object_ver_num IN NUMBER
245 );
246
247 -- Start of Comments --
248 --
249 -- Procedure name : Copy_Node
250 -- Type : Private
251 -- Function : Copy existing Master Configuration node to the same or another Master Configuration
252 -- Pre-reqs :
253 --
254 -- Standard IN Parameters :
255 -- p_api_version IN NUMBER Required
256 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
257 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
258 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
259 --
260 -- Standard OUT Parameters :
261 -- x_return_status OUT VARCHAR2 Required
262 -- x_msg_count OUT NUMBER Required
263 -- x_msg_data OUT VARCHAR2 Required
264 --
265 -- Create_Node Parameters :
266 -- p_parent_rel_id IN NUMBER,
267 -- p_parent_obj_ver_num IN NUMBER,
268 -- p_x_node_id IN OUT NUMBER,
269 -- p_x_node_obj_ver_num IN OUT NUMBER
270 --
271 -- Version :
272 -- Initial Version 1.0
273 --
274 -- End of Comments --
275 PROCEDURE Copy_Node
276 (
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279 p_commit IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_parent_rel_id IN NUMBER,
285 p_parent_obj_ver_num IN NUMBER,
286 p_x_node_id IN OUT NOCOPY NUMBER,
287 p_x_node_obj_ver_num IN OUT NOCOPY NUMBER
288
289 );
290
291 -- Start of Comments --
292 --
293 -- Procedure name : Copy_MC_Nodes
294 -- Type : Private
295 -- Function : Copies tree of Master Configuration nodes from one node to another
296 -- Pre-reqs :
297 --
298 -- Standard IN Parameters :
299 -- p_api_version IN NUMBER Required
300 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303 --
304 -- Standard OUT Parameters :
305 -- x_return_status OUT VARCHAR2 Required
306 -- x_msg_count OUT NUMBER Required
307 -- x_msg_data OUT VARCHAR2 Required
308 --
309 -- Create_Node Parameters :
310 -- p_source_rel_id IN NUMBER,
311 -- p_dest_rel_id IN NUMBER,
312 -- p_new_rev_flag IN BOOLEAN Default FALSE
313 --
314 -- Version :
315 -- Initial Version 1.0
316 --
317 -- End of Comments --
318 PROCEDURE Copy_MC_Nodes
319 (
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322 p_commit IN VARCHAR2 := FND_API.G_FALSE,
323 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2,
327 p_source_rel_id IN NUMBER,
328 p_dest_rel_id IN NUMBER,
329 p_new_rev_flag IN BOOLEAN := FALSE,
330 p_node_copy IN BOOLEAN := FALSE
331 );
332
333 -- Start of Comments --
334 --
335 -- Procedure name : Process_Documents
339 --
336 -- Type : Private
337 -- Function : Handles document associations with MC node
338 -- Pre-reqs :
340 -- Standard IN Parameters :
341 -- p_api_version IN NUMBER Required
342 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
343 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
344 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
345 --
346 -- Standard OUT Parameters :
347 -- x_return_status OUT VARCHAR2 Required
348 -- x_msg_count OUT NUMBER Required
349 -- x_msg_data OUT VARCHAR2 Required
350 --
351 -- Create_Node Parameters :
352 -- p_node_rec IN Node_Rec_Type,
353 -- p_x_documents_tbl IN OUT AHL_DI_ASSO_DOC_GEN_PVT.association_tbl
354 --
355 -- Version :
356 -- Initial Version 1.0
357 --
358 -- End of Comments --
359 PROCEDURE Process_Documents
360 (
361 p_api_version IN NUMBER,
365 x_return_status OUT NOCOPY VARCHAR2,
362 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363 p_commit IN VARCHAR2 := FND_API.G_FALSE,
364 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_node_id IN NUMBER,
369 p_x_documents_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl
370 );
371
372 -- Start of Comments --
373 --
374 -- Procedure name : Associate_Item_Group
375 -- Type : Private
376 -- Function : Associates item groups to MC nodes, called by Item Group pages
377 -- Pre-reqs :
378 --
379 -- Standard IN Parameters :
380 -- p_api_version IN NUMBER Required
381 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
382 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
383 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
384 --
385 -- Standard OUT Parameters :
386 -- x_return_status OUT VARCHAR2 Required
387 -- x_msg_count OUT NUMBER Required
388 -- x_msg_data OUT VARCHAR2 Required
389 --
390 -- Create_Node Parameters :
391 -- p_nodes_tbl IN Node_Tbl_Type
392 --
393 -- Version :
394 -- Initial Version 1.0
395 --
396 -- End of Comments --
397 PROCEDURE Associate_Item_Group
398 (
399 p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401 p_commit IN VARCHAR2 := FND_API.G_FALSE,
402 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403 x_return_status OUT NOCOPY VARCHAR2,
404 x_msg_count OUT NOCOPY NUMBER,
405 x_msg_data OUT NOCOPY VARCHAR2,
406 p_nodes_tbl IN Node_Tbl_Type
407 );
408
409 End AHL_MC_Node_PVT;