2: /* $Header: OKLSSRLS.pls 120.1.12020000.2 2013/02/20 11:15:53 racheruv ship $ */
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
42: ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,rate NUMBER := OKC_API.G_MISS_NUM
42: ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
43: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
44: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
45: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
46: INDEX BY BINARY_INTEGER;
47: -- OKL_SIF_RET_LEVELS Record Spec
48: TYPE srl_rec_type IS RECORD (
41: ,rate NUMBER := OKC_API.G_MISS_NUM
42: ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
43: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
44: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
45: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
46: INDEX BY BINARY_INTEGER;
47: -- OKL_SIF_RET_LEVELS Record Spec
48: TYPE srl_rec_type IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM
43: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
44: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
45: TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
46: INDEX BY BINARY_INTEGER;
47: -- OKL_SIF_RET_LEVELS Record Spec
48: TYPE srl_rec_type IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM
50: ,sir_id NUMBER := OKC_API.G_MISS_NUM
51: ,index_number NUMBER := OKC_API.G_MISS_NUM
50: ,sir_id NUMBER := OKC_API.G_MISS_NUM
51: ,index_number NUMBER := OKC_API.G_MISS_NUM
52: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
54: ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,amount NUMBER := OKC_API.G_MISS_NUM
56: ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57: ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
52: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
54: ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,amount NUMBER := OKC_API.G_MISS_NUM
56: ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57: ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
54: ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,amount NUMBER := OKC_API.G_MISS_NUM
56: ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57: ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,amount NUMBER := OKC_API.G_MISS_NUM
56: ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57: ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
56: ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57: ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
58: ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59: ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60: ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62: ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64: ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66: ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67: ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68: ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69: ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
71: ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
73: ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74: ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
75: ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76: ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77: ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
82: ,rate NUMBER := OKC_API.G_MISS_NUM
83: ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
129: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
130: PROCEDURE insert_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
129: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
130: PROCEDURE insert_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
137: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
138: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139: PROCEDURE insert_row(
140: p_api_version IN NUMBER,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
137: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
138: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139: PROCEDURE insert_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
146: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
147: PROCEDURE lock_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
146: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
147: PROCEDURE lock_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
154: PROCEDURE lock_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
161: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
162: PROCEDURE lock_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
169: PROCEDURE update_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
176: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
177: PROCEDURE update_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
176: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
177: PROCEDURE update_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
184: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
185: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
186: PROCEDURE update_row(
187: p_api_version IN NUMBER,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
184: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
185: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
186: PROCEDURE update_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
193: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
193: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
208: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
209: PROCEDURE delete_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
223: PROCEDURE validate_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
230: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
231: PROCEDURE validate_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
238: END OKL_SRL_PVT;