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
12: ,index_number NUMBER := OKC_API.G_MISS_NUM
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
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
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
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
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
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
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
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
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
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
18: ,days_in_period 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
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
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
22: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%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
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
24: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%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
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
41: ,rate 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
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
43: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
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
43: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
44: GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
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
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
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
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;
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
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
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
52: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
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
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
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
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
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
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
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
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
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
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
59: ,days_in_period 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
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
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
63: ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%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
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
65: ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%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
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
82: ,rate 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
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
84: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
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
84: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
85: G_MISS_srl_rec srl_rec_type;
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
84: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
85: G_MISS_srl_rec srl_rec_type;
86: TYPE srl_tbl_type IS TABLE OF srl_rec_type
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
84: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
85: G_MISS_srl_rec srl_rec_type;
86: TYPE srl_tbl_type IS TABLE OF srl_rec_type
87: INDEX BY BINARY_INTEGER;
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
84: ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
85: G_MISS_srl_rec srl_rec_type;
86: TYPE srl_tbl_type IS TABLE OF srl_rec_type
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
102: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
102: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
103: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
102: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
103: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
104:
110: ---------------------------------------------------------------------------
111: -- GLOBAL VARIABLES
112: ---------------------------------------------------------------------------
113: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SRL_PVT';
114: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
115: ---------------------------------------------------------------------------
116: -- Procedures and Functions
117: ---------------------------------------------------------------------------
118:
120: PROCEDURE change_version;
121: PROCEDURE api_copy;
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
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,
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,
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,
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,
142: x_return_status OUT NOCOPY VARCHAR2,
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,
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,
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,
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);
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,
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,
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,
165: x_return_status 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,
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);
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,
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,
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,
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,
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,
189: x_return_status OUT NOCOPY VARCHAR2,
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,
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,
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,
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);
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,
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,
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,
212: x_return_status 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,
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);
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,
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);
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,
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,
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,
234: x_return_status 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,
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);