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