eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RA_SETUPS_PVT dependencies on AHL_RA_SETUPS

Line 1: PACKAGE AHL_RA_SETUPS_PVT AS

1: PACKAGE AHL_RA_SETUPS_PVT AS
2: /* $Header: AHLVRASS.pls 120.1 2005/07/05 03:43 sagarwal noship $*/
3:
4: -------------------------------------------------------------------
5: -- Define Record Type for AHL_RA_SETUPS --

Line 5: -- Define Record Type for AHL_RA_SETUPS --

1: PACKAGE AHL_RA_SETUPS_PVT 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,

Line 8: RA_SETUP_ID AHL_RA_SETUPS.RA_SETUP_ID%TYPE,

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),

Line 9: SETUP_CODE AHL_RA_SETUPS.SETUP_CODE%TYPE,

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,

Line 10: STATUS_ID AHL_RA_SETUPS.STATUS_ID%TYPE,

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,

Line 11: REMOVAL_CODE AHL_RA_SETUPS.REMOVAL_CODE%TYPE,

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,

Line 13: OBJECT_VERSION_NUMBER AHL_RA_SETUPS.OBJECT_VERSION_NUMBER%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,

Line 14: SECURITY_GROUP_ID AHL_RA_SETUPS.SECURITY_GROUP_ID%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,

Line 15: CREATION_DATE AHL_RA_SETUPS.CREATION_DATE%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,

Line 16: CREATED_BY AHL_RA_SETUPS.CREATED_BY%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,

Line 17: LAST_UPDATE_DATE AHL_RA_SETUPS.LAST_UPDATE_DATE%TYPE,

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,

Line 18: LAST_UPDATED_BY AHL_RA_SETUPS.LAST_UPDATED_BY%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,

Line 19: LAST_UPDATE_LOGIN AHL_RA_SETUPS.LAST_UPDATE_LOGIN%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,

Line 20: ATTRIBUTE_CATEGORY AHL_RA_SETUPS.ATTRIBUTE_CATEGORY%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,

Line 21: ATTRIBUTE1 AHL_RA_SETUPS.ATTRIBUTE1%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,

Line 22: ATTRIBUTE2 AHL_RA_SETUPS.ATTRIBUTE2%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,

Line 23: ATTRIBUTE3 AHL_RA_SETUPS.ATTRIBUTE3%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,

Line 24: ATTRIBUTE4 AHL_RA_SETUPS.ATTRIBUTE4%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,

Line 25: ATTRIBUTE5 AHL_RA_SETUPS.ATTRIBUTE5%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,

Line 26: ATTRIBUTE6 AHL_RA_SETUPS.ATTRIBUTE6%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,

Line 27: ATTRIBUTE7 AHL_RA_SETUPS.ATTRIBUTE7%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,

Line 28: ATTRIBUTE8 AHL_RA_SETUPS.ATTRIBUTE8%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,

Line 29: ATTRIBUTE9 AHL_RA_SETUPS.ATTRIBUTE9%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,

Line 30: ATTRIBUTE10 AHL_RA_SETUPS.ATTRIBUTE10%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,

Line 31: ATTRIBUTE11 AHL_RA_SETUPS.ATTRIBUTE11%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

Line 32: ATTRIBUTE12 AHL_RA_SETUPS.ATTRIBUTE12%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: );

Line 33: ATTRIBUTE13 AHL_RA_SETUPS.ATTRIBUTE13%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:

Line 34: ATTRIBUTE14 AHL_RA_SETUPS.ATTRIBUTE14%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:

Line 35: ATTRIBUTE15 AHL_RA_SETUPS.ATTRIBUTE15%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: -------------------------------------------------------------------

Line 188: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_SETUPS table

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

Line 218: p_x_setup_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE);

214: p_module_type IN VARCHAR2,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_x_setup_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE);
219:
220:
221:
222: -- Start of Comments --

Line 226: -- Function : This API would dalete the setup data for Reliability Framework in AHL_RA_SETUPS table

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

Line 256: p_setup_data_rec IN AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE);

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:

Line 295: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE);

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: --

Line 332: p_reliability_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE);

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: --

Line 369: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

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:

Line 370: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);

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 --

Line 408: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

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:

Line 409: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);

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 --

Line 447: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

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: --

Line 448: p_mtbf_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE);

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

Line 484: p_x_counter_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE);

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 --

Line 522: p_counter_assoc_rec IN AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE);

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 --

Line 560: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);

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 --

Line 598: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);

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 --

Line 636: p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);

632: p_module_type IN VARCHAR2,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);
637:
638: END AHL_RA_SETUPS_PVT;

Line 638: END AHL_RA_SETUPS_PVT;

634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE);
637:
638: END AHL_RA_SETUPS_PVT;