[Home] [Help]
PACKAGE: APPS.AHL_RA_SETUPS_PVT
Source
1 PACKAGE AHL_RA_SETUPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRASS.pls 120.1 2005/07/05 03:43 sagarwal noship $*/
3
4 -------------------------------------------------------------------
5 -- Define Record Type for AHL_RA_SETUPS --
6 -------------------------------------------------------------------
7 TYPE RA_SETUP_DATA_REC_TYPE IS RECORD (
8 RA_SETUP_ID AHL_RA_SETUPS.RA_SETUP_ID%TYPE,
9 SETUP_CODE AHL_RA_SETUPS.SETUP_CODE%TYPE,
10 STATUS_ID AHL_RA_SETUPS.STATUS_ID%TYPE,
11 REMOVAL_CODE AHL_RA_SETUPS.REMOVAL_CODE%TYPE,
12 OPERATION_FLAG VARCHAR2(1),
13 OBJECT_VERSION_NUMBER AHL_RA_SETUPS.OBJECT_VERSION_NUMBER%TYPE,
14 SECURITY_GROUP_ID AHL_RA_SETUPS.SECURITY_GROUP_ID%TYPE,
15 CREATION_DATE AHL_RA_SETUPS.CREATION_DATE%TYPE,
16 CREATED_BY AHL_RA_SETUPS.CREATED_BY%TYPE,
17 LAST_UPDATE_DATE AHL_RA_SETUPS.LAST_UPDATE_DATE%TYPE,
18 LAST_UPDATED_BY AHL_RA_SETUPS.LAST_UPDATED_BY%TYPE,
19 LAST_UPDATE_LOGIN AHL_RA_SETUPS.LAST_UPDATE_LOGIN%TYPE,
20 ATTRIBUTE_CATEGORY AHL_RA_SETUPS.ATTRIBUTE_CATEGORY%TYPE,
21 ATTRIBUTE1 AHL_RA_SETUPS.ATTRIBUTE1%TYPE,
22 ATTRIBUTE2 AHL_RA_SETUPS.ATTRIBUTE2%TYPE,
23 ATTRIBUTE3 AHL_RA_SETUPS.ATTRIBUTE3%TYPE,
24 ATTRIBUTE4 AHL_RA_SETUPS.ATTRIBUTE4%TYPE,
25 ATTRIBUTE5 AHL_RA_SETUPS.ATTRIBUTE5%TYPE,
26 ATTRIBUTE6 AHL_RA_SETUPS.ATTRIBUTE6%TYPE,
27 ATTRIBUTE7 AHL_RA_SETUPS.ATTRIBUTE7%TYPE,
28 ATTRIBUTE8 AHL_RA_SETUPS.ATTRIBUTE8%TYPE,
29 ATTRIBUTE9 AHL_RA_SETUPS.ATTRIBUTE9%TYPE,
30 ATTRIBUTE10 AHL_RA_SETUPS.ATTRIBUTE10%TYPE,
31 ATTRIBUTE11 AHL_RA_SETUPS.ATTRIBUTE11%TYPE,
32 ATTRIBUTE12 AHL_RA_SETUPS.ATTRIBUTE12%TYPE,
33 ATTRIBUTE13 AHL_RA_SETUPS.ATTRIBUTE13%TYPE,
34 ATTRIBUTE14 AHL_RA_SETUPS.ATTRIBUTE14%TYPE,
35 ATTRIBUTE15 AHL_RA_SETUPS.ATTRIBUTE15%TYPE
36 );
37
38
39 -------------------------------------------------------------------
40 -- Define Record Type for AHL_RA_DEFINITION_HDR --
41 -------------------------------------------------------------------
42 TYPE RA_DEFINITION_HDR_REC_TYPE IS RECORD (
43 RA_DEFINITION_HDR_ID AHL_RA_DEFINITION_HDR.RA_DEFINITION_HDR_ID%TYPE,
44 MC_HEADER_ID AHL_RA_DEFINITION_HDR.MC_HEADER_ID%TYPE,
45 INVENTORY_ITEM_ID AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID%TYPE,
46 INVENTORY_ORG_ID AHL_RA_DEFINITION_HDR.INVENTORY_ORG_ID%TYPE,
47 ITEM_REVISION AHL_RA_DEFINITION_HDR.ITEM_REVISION%TYPE,
48 RELATIONSHIP_ID AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE,
49 OPERATION_FLAG VARCHAR2(1),
50 OBJECT_VERSION_NUMBER AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE,
51 SECURITY_GROUP_ID AHL_RA_DEFINITION_HDR.SECURITY_GROUP_ID%TYPE,
52 CREATION_DATE AHL_RA_DEFINITION_HDR.CREATION_DATE%TYPE,
53 CREATED_BY AHL_RA_DEFINITION_HDR.CREATED_BY%TYPE,
54 LAST_UPDATE_DATE AHL_RA_DEFINITION_HDR.LAST_UPDATE_DATE%TYPE,
55 LAST_UPDATED_BY AHL_RA_DEFINITION_HDR.LAST_UPDATED_BY%TYPE,
56 LAST_UPDATE_LOGIN AHL_RA_DEFINITION_HDR.LAST_UPDATE_LOGIN%TYPE,
57 ATTRIBUTE_CATEGORY AHL_RA_DEFINITION_HDR.ATTRIBUTE_CATEGORY%TYPE,
58 ATTRIBUTE1 AHL_RA_DEFINITION_HDR.ATTRIBUTE1%TYPE,
59 ATTRIBUTE2 AHL_RA_DEFINITION_HDR.ATTRIBUTE2%TYPE,
60 ATTRIBUTE3 AHL_RA_DEFINITION_HDR.ATTRIBUTE3%TYPE,
61 ATTRIBUTE4 AHL_RA_DEFINITION_HDR.ATTRIBUTE4%TYPE,
62 ATTRIBUTE5 AHL_RA_DEFINITION_HDR.ATTRIBUTE5%TYPE,
63 ATTRIBUTE6 AHL_RA_DEFINITION_HDR.ATTRIBUTE6%TYPE,
64 ATTRIBUTE7 AHL_RA_DEFINITION_HDR.ATTRIBUTE7%TYPE,
65 ATTRIBUTE8 AHL_RA_DEFINITION_HDR.ATTRIBUTE8%TYPE,
66 ATTRIBUTE9 AHL_RA_DEFINITION_HDR.ATTRIBUTE9%TYPE,
67 ATTRIBUTE10 AHL_RA_DEFINITION_HDR.ATTRIBUTE10%TYPE,
68 ATTRIBUTE11 AHL_RA_DEFINITION_HDR.ATTRIBUTE11%TYPE,
69 ATTRIBUTE12 AHL_RA_DEFINITION_HDR.ATTRIBUTE12%TYPE,
70 ATTRIBUTE13 AHL_RA_DEFINITION_HDR.ATTRIBUTE13%TYPE,
71 ATTRIBUTE14 AHL_RA_DEFINITION_HDR.ATTRIBUTE14%TYPE,
72 ATTRIBUTE15 AHL_RA_DEFINITION_HDR.ATTRIBUTE15%TYPE
73 );
74
75
76 -------------------------------------------------------------------
77 -- Define Record Type for AHL_RA_DEFINITION_DTLS --
78 -------------------------------------------------------------------
79 TYPE RA_DEFINITION_DTLS_REC_TYPE IS RECORD (
80 RA_DEFINITION_DTL_ID AHL_RA_DEFINITION_DTLS.RA_DEFINITION_DTL_ID%TYPE,
81 RA_DEFINITION_HDR_ID AHL_RA_DEFINITION_DTLS.RA_DEFINITION_HDR_ID%TYPE,
82 COUNTER_ID AHL_RA_DEFINITION_DTLS.COUNTER_ID%TYPE,
83 MTBF_VALUE AHL_RA_DEFINITION_DTLS.MTBF_VALUE%TYPE,
84 OPERATION_FLAG VARCHAR2(1),
85 OBJECT_VERSION_NUMBER AHL_RA_DEFINITION_DTLS.OBJECT_VERSION_NUMBER%TYPE,
86 SECURITY_GROUP_ID AHL_RA_DEFINITION_DTLS.SECURITY_GROUP_ID%TYPE,
87 CREATION_DATE AHL_RA_DEFINITION_DTLS.CREATION_DATE%TYPE,
88 CREATED_BY AHL_RA_DEFINITION_DTLS.CREATED_BY%TYPE,
89 LAST_UPDATE_DATE AHL_RA_DEFINITION_DTLS.LAST_UPDATE_DATE%TYPE,
90 LAST_UPDATED_BY AHL_RA_DEFINITION_DTLS.LAST_UPDATED_BY%TYPE,
91 LAST_UPDATE_LOGIN AHL_RA_DEFINITION_DTLS.LAST_UPDATE_LOGIN%TYPE,
92 ATTRIBUTE_CATEGORY AHL_RA_DEFINITION_DTLS.ATTRIBUTE_CATEGORY%TYPE,
93 ATTRIBUTE1 AHL_RA_DEFINITION_DTLS.ATTRIBUTE1%TYPE,
94 ATTRIBUTE2 AHL_RA_DEFINITION_DTLS.ATTRIBUTE2%TYPE,
95 ATTRIBUTE3 AHL_RA_DEFINITION_DTLS.ATTRIBUTE3%TYPE,
96 ATTRIBUTE4 AHL_RA_DEFINITION_DTLS.ATTRIBUTE4%TYPE,
97 ATTRIBUTE5 AHL_RA_DEFINITION_DTLS.ATTRIBUTE5%TYPE,
98 ATTRIBUTE6 AHL_RA_DEFINITION_DTLS.ATTRIBUTE6%TYPE,
99 ATTRIBUTE7 AHL_RA_DEFINITION_DTLS.ATTRIBUTE7%TYPE,
100 ATTRIBUTE8 AHL_RA_DEFINITION_DTLS.ATTRIBUTE8%TYPE,
101 ATTRIBUTE9 AHL_RA_DEFINITION_DTLS.ATTRIBUTE9%TYPE,
102 ATTRIBUTE10 AHL_RA_DEFINITION_DTLS.ATTRIBUTE10%TYPE,
103 ATTRIBUTE11 AHL_RA_DEFINITION_DTLS.ATTRIBUTE11%TYPE,
104 ATTRIBUTE12 AHL_RA_DEFINITION_DTLS.ATTRIBUTE12%TYPE,
105 ATTRIBUTE13 AHL_RA_DEFINITION_DTLS.ATTRIBUTE13%TYPE,
106 ATTRIBUTE14 AHL_RA_DEFINITION_DTLS.ATTRIBUTE14%TYPE,
107 ATTRIBUTE15 AHL_RA_DEFINITION_DTLS.ATTRIBUTE15%TYPE
108 );
109
110
111 -------------------------------------------------------------------
112 -- Define Record Type for AHL_RA_CTR_ASSOCIATIONS --
113 -------------------------------------------------------------------
114 TYPE RA_COUNTER_ASSOC_REC_TYPE IS RECORD (
115 RA_COUNTER_ASSOCIATION_ID AHL_RA_CTR_ASSOCIATIONS.RA_COUNTER_ASSOCIATION_ID%TYPE,
116 SINCE_NEW_COUNTER_ID AHL_RA_CTR_ASSOCIATIONS.SINCE_NEW_COUNTER_ID%TYPE,
117 SINCE_OVERHAUL_COUNTER_ID AHL_RA_CTR_ASSOCIATIONS.SINCE_OVERHAUL_COUNTER_ID%TYPE,
118 DESCRIPTION AHL_RA_CTR_ASSOCIATIONS.DESCRIPTION%TYPE,
119 OPERATION_FLAG VARCHAR2(1),
120 OBJECT_VERSION_NUMBER AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE,
121 SECURITY_GROUP_ID AHL_RA_CTR_ASSOCIATIONS.SECURITY_GROUP_ID%TYPE,
122 CREATION_DATE AHL_RA_CTR_ASSOCIATIONS.CREATION_DATE%TYPE,
123 CREATED_BY AHL_RA_CTR_ASSOCIATIONS.CREATED_BY%TYPE,
124 LAST_UPDATE_DATE AHL_RA_CTR_ASSOCIATIONS.LAST_UPDATE_DATE%TYPE,
125 LAST_UPDATED_BY AHL_RA_CTR_ASSOCIATIONS.LAST_UPDATED_BY%TYPE,
126 LAST_UPDATE_LOGIN AHL_RA_CTR_ASSOCIATIONS.LAST_UPDATE_LOGIN%TYPE,
127 ATTRIBUTE_CATEGORY AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE_CATEGORY%TYPE,
128 ATTRIBUTE1 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE1%TYPE,
129 ATTRIBUTE2 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE2%TYPE,
130 ATTRIBUTE3 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE3%TYPE,
131 ATTRIBUTE4 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE4%TYPE,
132 ATTRIBUTE5 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE5%TYPE,
133 ATTRIBUTE6 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE6%TYPE,
134 ATTRIBUTE7 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE7%TYPE,
135 ATTRIBUTE8 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE8%TYPE,
136 ATTRIBUTE9 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE9%TYPE,
137 ATTRIBUTE10 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE10%TYPE,
138 ATTRIBUTE11 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE11%TYPE,
139 ATTRIBUTE12 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE12%TYPE,
140 ATTRIBUTE13 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE13%TYPE,
141 ATTRIBUTE14 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE14%TYPE,
142 ATTRIBUTE15 AHL_RA_CTR_ASSOCIATIONS.ATTRIBUTE15%TYPE
143 );
144
145
146 -------------------------------------------------------------------
147 -- Define Record Type for AHL_RA_FCT_ASSOCIATIONS --
148 -------------------------------------------------------------------
149 TYPE RA_FCT_ASSOC_REC_TYPE IS RECORD (
150 RA_FCT_ASSOCIATION_ID AHL_RA_FCT_ASSOCIATIONS.RA_FCT_ASSOCIATION_ID%TYPE,
151 FORECAST_DESIGNATOR AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,
152 ASSOCIATION_TYPE_CODE AHL_RA_FCT_ASSOCIATIONS.ASSOCIATION_TYPE_CODE%TYPE,
153 ORGANIZATION_ID AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE,
154 PROBABILITY_FROM AHL_RA_FCT_ASSOCIATIONS.PROBABILITY_FROM%TYPE,
155 PROBABILITY_TO AHL_RA_FCT_ASSOCIATIONS.PROBABILITY_TO%TYPE,
156 OPERATION_FLAG VARCHAR2(1),
157 OBJECT_VERSION_NUMBER AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE,
158 SECURITY_GROUP_ID AHL_RA_FCT_ASSOCIATIONS.SECURITY_GROUP_ID%TYPE,
159 CREATION_DATE AHL_RA_FCT_ASSOCIATIONS.CREATION_DATE%TYPE,
160 CREATED_BY AHL_RA_FCT_ASSOCIATIONS.CREATED_BY%TYPE,
161 LAST_UPDATE_DATE AHL_RA_FCT_ASSOCIATIONS.LAST_UPDATE_DATE%TYPE,
162 LAST_UPDATED_BY AHL_RA_FCT_ASSOCIATIONS.LAST_UPDATED_BY%TYPE,
163 LAST_UPDATE_LOGIN AHL_RA_FCT_ASSOCIATIONS.LAST_UPDATE_LOGIN%TYPE,
164 ATTRIBUTE_CATEGORY AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE_CATEGORY%TYPE,
165 ATTRIBUTE1 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE1%TYPE,
166 ATTRIBUTE2 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE2%TYPE,
167 ATTRIBUTE3 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE3%TYPE,
168 ATTRIBUTE4 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE4%TYPE,
169 ATTRIBUTE5 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE5%TYPE,
170 ATTRIBUTE6 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE6%TYPE,
171 ATTRIBUTE7 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE7%TYPE,
172 ATTRIBUTE8 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE8%TYPE,
173 ATTRIBUTE9 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE9%TYPE,
174 ATTRIBUTE10 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE10%TYPE,
175 ATTRIBUTE11 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE11%TYPE,
176 ATTRIBUTE12 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE12%TYPE,
177 ATTRIBUTE13 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE13%TYPE,
178 ATTRIBUTE14 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE14%TYPE,
179 ATTRIBUTE15 AHL_RA_FCT_ASSOCIATIONS.ATTRIBUTE15%TYPE
180 );
181
182
183
184 -- Start of Comments --
185 --
186 -- Procedure name : CREATE_SETUP_DATA
187 -- Type : Private
188 -- Function : This API would create the setup data for Reliability Framework in AHL_RA_SETUPS table
189 -- Pre-reqs :
190 --
191 -- Standard IN Parameters :
192 -- p_api_version IN NUMBER Required
193 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
194 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
195 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
196 --
197 -- Standard OUT Parameters :
198 -- x_return_status OUT VARCHAR2 Required
199 -- x_msg_count OUT NUMBER Required
200 -- x_msg_data OUT VARCHAR2 Required
201 --
202 -- CREATE_SETUP_DATA Parameters :
203 -- p_x_setup_data_rec IN OUT RA_SETUP_DATA_REC_TYPE Required
204 --
205 -- Version :
206 -- Initial Version 1.0
207 --
208 -- End of Comments --
209 PROCEDURE CREATE_SETUP_DATA (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 p_module_type IN VARCHAR2,
218 p_x_setup_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE);
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
219
220
221
222 -- Start of Comments --
223 --
224 -- Procedure name : DELETE_SETUP_DATA
225 -- Type : Private
226 -- Function : This API would dalete the setup data for Reliability Framework in AHL_RA_SETUPS table
227 -- Pre-reqs :
228 --
229 -- Standard IN Parameters :
230 -- p_api_version IN NUMBER Required
231 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
232 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
233 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
234 --
235 -- Standard OUT Parameters :
236 -- x_return_status OUT VARCHAR2 Required
237 -- x_msg_count OUT NUMBER Required
238 -- x_msg_data OUT VARCHAR2 Required
239 --
240 -- DELETE_SETUP_DATA Parameters :
241 -- p_setup_data_rec IN RA_SETUP_DATA_REC_TYPE Required
242 --
243 -- Version :
244 -- Initial Version 1.0
245 --
246 -- End of Comments --
247 PROCEDURE DELETE_SETUP_DATA (
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252 p_module_type IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_setup_data_rec IN AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE);
257
258
259
260
261 -- Start of Comments --
262 --
263 -- Procedure name : CREATE_RELIABILITY_DATA
264 -- Type : Private
265 -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
266 -- Pre-reqs :
267 --
268 -- Standard IN Parameters :
269 -- p_api_version IN NUMBER Required
270 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
271 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
272 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
273 --
274 -- Standard OUT Parameters :
275 -- x_return_status OUT VARCHAR2 Required
276 -- x_msg_count OUT NUMBER Required
277 -- x_msg_data OUT VARCHAR2 Required
278 --
279 -- CREATE_RELIABILITY_DATA Parameters :
280 -- p_x_reliability_data_rec IN OUT RA_DEFINITION_HDR_REC_TYPE Required
281 --
282 -- Version :
283 -- Initial Version 1.0
284 --
285 -- End of Comments --
286 PROCEDURE CREATE_RELIABILITY_DATA (
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289 p_commit IN VARCHAR2 := FND_API.G_FALSE,
290 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291 p_module_type IN VARCHAR2,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE);
296
297
298 -- Start of Comments --
299 --
300 -- Procedure name : DELETE_RELIABILITY_DATA
301 -- Type : Private
302 -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
303 -- Pre-reqs :
304 --
305 -- Standard IN Parameters :
306 -- p_api_version IN NUMBER Required
307 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
308 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
309 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
310 --
311 -- Standard OUT Parameters :
312 -- x_return_status OUT VARCHAR2 Required
313 -- x_msg_count OUT NUMBER Required
314 -- x_msg_data OUT VARCHAR2 Required
315 --
316 -- DELETE_RELIABILITY_DATA Parameters :
317 -- p_reliability_data_rec IN OUT RA_DEFINITION_HDR_REC_TYPE Required
318 --
319 -- Version :
320 -- Initial Version 1.0
321 --
322 -- End of Comments --
323 PROCEDURE DELETE_RELIABILITY_DATA (
327 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
324 p_api_version IN NUMBER,
325 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326 p_commit IN VARCHAR2 := FND_API.G_FALSE,
328 p_module_type IN VARCHAR2,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 p_reliability_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE);
333
334
335 -- Start of Comments --
336 --
337 -- Procedure name : CREATE_MTBF_DATA
338 -- Type : Private
339 -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
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_MTBF_DATA Parameters :
354 -- p_x_mtbf_data_rec IN OUT RA_DEFINITION_DTLS_REC_TYPE Required
355 --
356 -- Version :
357 -- Initial Version 1.0
358 --
359 -- End of Comments --
360 PROCEDURE CREATE_MTBF_DATA (
361 p_api_version IN NUMBER,
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,
365 p_module_type IN VARCHAR2,
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_count OUT NOCOPY NUMBER,
368 x_msg_data OUT NOCOPY VARCHAR2,
369 p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
370 p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);
371
372
373
374 -- Start of Comments --
375 --
376 -- Procedure name : UPDATE_MTBF_DATA
377 -- Type : Private
378 -- Function : This API would update the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
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 -- UPDATE_MTBF_DATA Parameters :
393 -- p_x_mtbf_data_rec IN OUT RA_DEFINITION_DTLS_REC_TYPE Required
394 --
395 -- Version :
396 -- Initial Version 1.0
397 --
398 -- End of Comments --
399 PROCEDURE UPDATE_MTBF_DATA (
400 p_api_version IN NUMBER,
401 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
402 p_commit IN VARCHAR2 := FND_API.G_FALSE,
403 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404 p_module_type IN VARCHAR2,
405 x_return_status OUT NOCOPY VARCHAR2,
406 x_msg_count OUT NOCOPY NUMBER,
407 x_msg_data OUT NOCOPY VARCHAR2,
408 p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
409 p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);
410
411
412
413 -- Start of Comments --
414 --
415 -- Procedure name : DELETE_MTBF_DATA
416 -- Type : Private
417 -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
418 -- Pre-reqs :
419 --
420 -- Standard IN Parameters :
421 -- p_api_version IN NUMBER Required
422 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
423 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
424 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
428 -- x_msg_count OUT NUMBER Required
425 --
426 -- Standard OUT Parameters :
427 -- x_return_status OUT VARCHAR2 Required
429 -- x_msg_data OUT VARCHAR2 Required
430 --
431 -- DELETE_MTBF_DATA Parameters :
432 -- p_mtbf_data_rec IN OUT RA_DEFINITION_DTLS_REC_TYPE Required
433 --
434 -- Version :
435 -- Initial Version 1.0
436 --
437 -- End of Comments --
438 PROCEDURE DELETE_MTBF_DATA (
439 p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441 p_commit IN VARCHAR2 := FND_API.G_FALSE,
442 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443 p_module_type IN VARCHAR2,
444 x_return_status OUT NOCOPY VARCHAR2,
445 x_msg_count OUT NOCOPY NUMBER,
446 x_msg_data OUT NOCOPY VARCHAR2,
447 p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
448 p_mtbf_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);
449
450 -- Start of Comments --
451 --
452 -- Procedure name : CREATE_COUNTER_ASSOC
453 -- Type : Private
454 -- Function : This API would create the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
455 -- Pre-reqs :
456 --
457 -- Standard IN Parameters :
458 -- p_api_version IN NUMBER Required
459 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
460 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
461 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
462 --
463 -- Standard OUT Parameters :
464 -- x_return_status OUT VARCHAR2 Required
465 -- x_msg_count OUT NUMBER Required
466 -- x_msg_data OUT VARCHAR2 Required
467 --
468 -- CREATE_COUNTER_ASSOC Parameters :
469 -- p_x_counter_assoc_rec IN OUT RA_COUNTER_ASSOC_REC_TYPE Required
470 --
471 -- Version :
472 -- Initial Version 1.0
473 --
474 -- End of Comments --
475 PROCEDURE CREATE_COUNTER_ASSOC (
476 p_api_version IN NUMBER,
477 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478 p_commit IN VARCHAR2 := FND_API.G_FALSE,
479 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480 p_module_type IN VARCHAR2,
481 x_return_status OUT NOCOPY VARCHAR2,
482 x_msg_count OUT NOCOPY NUMBER,
483 x_msg_data OUT NOCOPY VARCHAR2,
484 p_x_counter_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE);
485
486
487
488 -- Start of Comments --
489 --
490 -- Procedure name : DELETE_COUNTER_ASSOC
491 -- Type : Private
492 -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
493 -- Pre-reqs :
494 --
495 -- Standard IN Parameters :
496 -- p_api_version IN NUMBER Required
497 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
498 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
499 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
500 --
501 -- Standard OUT Parameters :
502 -- x_return_status OUT VARCHAR2 Required
503 -- x_msg_count OUT NUMBER Required
504 -- x_msg_data OUT VARCHAR2 Required
505 --
506 -- DELETE_COUNTER_ASSOC Parameters :
507 -- p_counter_assoc_rec IN OUT RA_COUNTER_ASSOC_REC_TYPE Required
508 --
509 -- Version :
510 -- Initial Version 1.0
511 --
512 -- End of Comments --
513 PROCEDURE DELETE_COUNTER_ASSOC (
514 p_api_version IN NUMBER,
515 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516 p_commit IN VARCHAR2 := FND_API.G_FALSE,
517 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518 p_module_type IN VARCHAR2,
519 x_return_status OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 p_counter_assoc_rec IN AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE);
523
524
525
526 -- Start of Comments --
527 --
528 -- Procedure name : CREATE_FCT_ASSOC_DATA
529 -- Type : Private
533 -- Standard IN Parameters :
530 -- Function : This API would create the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
531 -- Pre-reqs :
532 --
534 -- p_api_version IN NUMBER Required
535 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
536 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
537 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
538 --
539 -- Standard OUT Parameters :
540 -- x_return_status OUT VARCHAR2 Required
541 -- x_msg_count OUT NUMBER Required
542 -- x_msg_data OUT VARCHAR2 Required
543 --
544 -- CREATE_FCT_ASSOC_DATA Parameters :
545 -- p_x_fct_assoc_rec IN OUT RA_FCT_ASSOC_REC_TYPE Required
546 --
547 -- Version :
548 -- Initial Version 1.0
549 --
550 -- End of Comments --
551 PROCEDURE CREATE_FCT_ASSOC_DATA (
552 p_api_version IN NUMBER,
553 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554 p_commit IN VARCHAR2 := FND_API.G_FALSE,
555 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556 p_module_type IN VARCHAR2,
557 x_return_status OUT NOCOPY VARCHAR2,
558 x_msg_count OUT NOCOPY NUMBER,
559 x_msg_data OUT NOCOPY VARCHAR2,
560 p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);
561
562
563
564 -- Start of Comments --
565 --
566 -- Procedure name : UPDATE_FCT_ASSOC_DATA
567 -- Type : Private
568 -- Function : This API would update the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
569 -- Pre-reqs :
570 --
571 -- Standard IN Parameters :
572 -- p_api_version IN NUMBER Required
573 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
574 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
575 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
576 --
577 -- Standard OUT Parameters :
578 -- x_return_status OUT VARCHAR2 Required
579 -- x_msg_count OUT NUMBER Required
580 -- x_msg_data OUT VARCHAR2 Required
581 --
582 -- UPDATE_FCT_ASSOC_DATA Parameters :
583 -- p_x_fct_assoc_rec IN OUT RA_FCT_ASSOC_REC_TYPE Required
584 --
585 -- Version :
586 -- Initial Version 1.0
587 --
588 -- End of Comments --
589 PROCEDURE UPDATE_FCT_ASSOC_DATA (
590 p_api_version IN NUMBER,
591 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592 p_commit IN VARCHAR2 := FND_API.G_FALSE,
593 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594 p_module_type IN VARCHAR2,
595 x_return_status OUT NOCOPY VARCHAR2,
596 x_msg_count OUT NOCOPY NUMBER,
597 x_msg_data OUT NOCOPY VARCHAR2,
598 p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);
599
600
601
602 -- Start of Comments --
603 --
604 -- Procedure name : DELETE_FCT_ASSOC_DATA
605 -- Type : Private
606 -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
607 -- Pre-reqs :
608 --
609 -- Standard IN Parameters :
610 -- p_api_version IN NUMBER Required
611 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
612 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
613 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
614 --
615 -- Standard OUT Parameters :
616 -- x_return_status OUT VARCHAR2 Required
617 -- x_msg_count OUT NUMBER Required
618 -- x_msg_data OUT VARCHAR2 Required
619 --
620 -- DELETE_FCT_ASSOC_DATA Parameters :
621 -- p_fct_assoc_rec IN OUT RA_FCT_ASSOC_REC_TYPE Required
622 --
623 -- Version :
624 -- Initial Version 1.0
625 --
626 -- End of Comments --
627 PROCEDURE DELETE_FCT_ASSOC_DATA (
628 p_api_version IN NUMBER,
629 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
630 p_commit IN VARCHAR2 := FND_API.G_FALSE,
631 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632 p_module_type IN VARCHAR2,
633 x_return_status OUT NOCOPY VARCHAR2,
634 x_msg_count OUT NOCOPY NUMBER,
638 END AHL_RA_SETUPS_PVT;
635 x_msg_data OUT NOCOPY VARCHAR2,
636 p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);
637