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.OKL_SRL_PVT dependencies on OKL_SIF_RET_LEVELS_V

Line 6: -- OKL_SIF_RET_LEVELS_V Record Spec

2: /* $Header: OKLSSRLS.pls 115.3 2003/10/16 07:06:16 smahapat noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_SIF_RET_LEVELS_V Record Spec
7: TYPE okl_sif_ret_levels_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM

Line 7: TYPE okl_sif_ret_levels_v_rec_type IS RECORD (

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_SIF_RET_LEVELS_V Record Spec
7: TYPE okl_sif_ret_levels_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
11: ,sir_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR

9: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
11: ,sir_id NUMBER := OKC_API.G_MISS_NUM
12: ,index_number NUMBER := OKC_API.G_MISS_NUM
13: ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,amount NUMBER := OKC_API.G_MISS_NUM
15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR

11: ,sir_id NUMBER := OKC_API.G_MISS_NUM
12: ,index_number NUMBER := OKC_API.G_MISS_NUM
13: ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,amount NUMBER := OKC_API.G_MISS_NUM
15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR

12: ,index_number NUMBER := OKC_API.G_MISS_NUM
13: ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,amount NUMBER := OKC_API.G_MISS_NUM
15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR

13: ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,amount NUMBER := OKC_API.G_MISS_NUM
15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE

15: ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16: ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

17: ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

18: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

19: ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

20: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

21: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

23: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

25: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

26: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

27: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

28: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

29: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

30: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

31: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

32: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

34: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,rate NUMBER := OKC_API.G_MISS_NUM); --smahapat 10/12/03
42: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;

Line 42: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;

38: ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,rate NUMBER := OKC_API.G_MISS_NUM); --smahapat 10/12/03
42: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
43: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
44: INDEX BY BINARY_INTEGER;
45: -- OKL_SIF_RET_LEVELS Record Spec
46: TYPE srl_rec_type IS RECORD (

Line 43: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type

39: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,rate NUMBER := OKC_API.G_MISS_NUM); --smahapat 10/12/03
42: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
43: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
44: INDEX BY BINARY_INTEGER;
45: -- OKL_SIF_RET_LEVELS Record Spec
46: TYPE srl_rec_type IS RECORD (
47: id NUMBER := OKC_API.G_MISS_NUM

Line 124: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,

120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
125: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 125: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);

121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
125: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,

Line 132: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
133: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
134: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135: PROCEDURE insert_row(
136: p_api_version IN NUMBER,

Line 133: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,

129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
133: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
134: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135: PROCEDURE insert_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 141: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
142: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
143: PROCEDURE lock_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 142: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);

138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
142: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
143: PROCEDURE lock_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,

Line 149: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);

145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
150: PROCEDURE lock_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,

Line 156: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
157: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
158: PROCEDURE lock_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 164: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);

160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
165: PROCEDURE update_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,

Line 171: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,

167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
172: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 172: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);

168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
172: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,

Line 179: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
180: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
181: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,

Line 180: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,

176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
180: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
181: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 188: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
189: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
190: PROCEDURE delete_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 189: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);

185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
189: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
190: PROCEDURE delete_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,

Line 196: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);

192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
197: PROCEDURE delete_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,

Line 203: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
204: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
205: PROCEDURE delete_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 211: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);

207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
212: PROCEDURE validate_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,

Line 218: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);

214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
219: PROCEDURE validate_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,

Line 225: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,

221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
226: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
227: PROCEDURE validate_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 233: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);

229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
234: END OKL_SRL_PVT;