4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CASH_FLOW_LEVELS_V Record Spec
7: TYPE cflv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_CASH_FLOW_LEVELS_V Record Spec
7: TYPE cflv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
6: -- OKL_CASH_FLOW_LEVELS_V Record Spec
7: TYPE cflv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
14: ,stub_days NUMBER := OKC_API.G_MISS_NUM
7: TYPE cflv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
14: ,stub_days NUMBER := OKC_API.G_MISS_NUM
15: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
14: ,stub_days NUMBER := OKC_API.G_MISS_NUM
15: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKL_CASH_FLOW_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,caf_id NUMBER := OKL_API.G_MISS_NUM
10: ,amount NUMBER := OKL_API.G_MISS_NUM
11: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
12: ,fqy_code OKL_CASH_FLOW_LEVELS_V.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
14: ,stub_days NUMBER := OKC_API.G_MISS_NUM
15: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKL_CASH_FLOW_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,rate NUMBER := OKC_API.G_MISS_NUM
14: ,stub_days NUMBER := OKC_API.G_MISS_NUM
15: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKL_CASH_FLOW_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,rate NUMBER := OKC_API.G_MISS_NUM
18: ,attribute_category OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
15: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKL_CASH_FLOW_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,rate NUMBER := OKC_API.G_MISS_NUM
18: ,attribute_category OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_CASH_FLOW_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,rate NUMBER := OKC_API.G_MISS_NUM
18: ,attribute_category OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
17: ,rate NUMBER := OKC_API.G_MISS_NUM
18: ,attribute_category OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute_category OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
27: ,attribute9 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
28: ,attribute10 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
29: ,attribute11 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,attribute12 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
31: ,attribute13 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
32: ,attribute14 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
40: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS_V.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
33: ,attribute15 OKL_CASH_FLOW_LEVELS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
40: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS_V.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
41: G_MISS_cflv_rec cflv_rec_type;
34: ,created_by NUMBER := OKL_API.G_MISS_NUM
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
40: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS_V.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
41: G_MISS_cflv_rec cflv_rec_type;
42: TYPE cflv_tbl_type IS TABLE OF cflv_rec_type
35: ,creation_date OKL_CASH_FLOW_LEVELS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
40: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS_V.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
41: G_MISS_cflv_rec cflv_rec_type;
42: TYPE cflv_tbl_type IS TABLE OF cflv_rec_type
43: INDEX BY BINARY_INTEGER;
36: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
37: ,last_update_date OKL_CASH_FLOW_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
39: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
40: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS_V.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
41: G_MISS_cflv_rec cflv_rec_type;
42: TYPE cflv_tbl_type IS TABLE OF cflv_rec_type
43: INDEX BY BINARY_INTEGER;
44: -- OKL_CASH_FLOW_LEVELS Record Spec
42: TYPE cflv_tbl_type IS TABLE OF cflv_rec_type
43: INDEX BY BINARY_INTEGER;
44: -- OKL_CASH_FLOW_LEVELS Record Spec
45: TYPE cfl_rec_type IS RECORD (
46: id NUMBER := OKL_API.G_MISS_NUM
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
43: INDEX BY BINARY_INTEGER;
44: -- OKL_CASH_FLOW_LEVELS Record Spec
45: TYPE cfl_rec_type IS RECORD (
46: id NUMBER := OKL_API.G_MISS_NUM
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
44: -- OKL_CASH_FLOW_LEVELS Record Spec
45: TYPE cfl_rec_type IS RECORD (
46: id NUMBER := OKL_API.G_MISS_NUM
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
52: ,stub_days NUMBER := OKC_API.G_MISS_NUM
45: TYPE cfl_rec_type IS RECORD (
46: id NUMBER := OKL_API.G_MISS_NUM
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
52: ,stub_days NUMBER := OKC_API.G_MISS_NUM
53: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
46: id NUMBER := OKL_API.G_MISS_NUM
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
52: ,stub_days NUMBER := OKC_API.G_MISS_NUM
53: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
54: ,start_date OKL_CASH_FLOW_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,caf_id NUMBER := OKL_API.G_MISS_NUM
48: ,amount NUMBER := OKL_API.G_MISS_NUM
49: ,number_of_periods NUMBER := OKL_API.G_MISS_NUM
50: ,fqy_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,level_sequence NUMBER := OKL_API.G_MISS_NUM
52: ,stub_days NUMBER := OKC_API.G_MISS_NUM
53: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
54: ,start_date OKL_CASH_FLOW_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,rate NUMBER := OKC_API.G_MISS_NUM
52: ,stub_days NUMBER := OKC_API.G_MISS_NUM
53: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
54: ,start_date OKL_CASH_FLOW_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,rate NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category OKL_CASH_FLOW_LEVELS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
53: ,stub_amount NUMBER := OKC_API.G_MISS_NUM
54: ,start_date OKL_CASH_FLOW_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,rate NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category OKL_CASH_FLOW_LEVELS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
54: ,start_date OKL_CASH_FLOW_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,rate NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category OKL_CASH_FLOW_LEVELS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
55: ,rate NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category OKL_CASH_FLOW_LEVELS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute_category OKL_CASH_FLOW_LEVELS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CASH_FLOW_LEVELS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CASH_FLOW_LEVELS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CASH_FLOW_LEVELS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CASH_FLOW_LEVELS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CASH_FLOW_LEVELS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CASH_FLOW_LEVELS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CASH_FLOW_LEVELS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CASH_FLOW_LEVELS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
65: ,attribute9 OKL_CASH_FLOW_LEVELS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,attribute10 OKL_CASH_FLOW_LEVELS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
67: ,attribute11 OKL_CASH_FLOW_LEVELS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute12 OKL_CASH_FLOW_LEVELS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
69: ,attribute13 OKL_CASH_FLOW_LEVELS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
70: ,attribute14 OKL_CASH_FLOW_LEVELS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
78: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
71: ,attribute15 OKL_CASH_FLOW_LEVELS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
78: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
79: G_MISS_cfl_rec cfl_rec_type;
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
78: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
79: G_MISS_cfl_rec cfl_rec_type;
80: TYPE cfl_tbl_type IS TABLE OF cfl_rec_type
73: ,creation_date OKL_CASH_FLOW_LEVELS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
78: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
79: G_MISS_cfl_rec cfl_rec_type;
80: TYPE cfl_tbl_type IS TABLE OF cfl_rec_type
81: INDEX BY BINARY_INTEGER;
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CASH_FLOW_LEVELS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
77: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
78: ,missing_pmt_flag OKL_CASH_FLOW_LEVELS.missing_pmt_flag%TYPE := OKL_API.G_MISS_CHAR);
79: G_MISS_cfl_rec cfl_rec_type;
80: TYPE cfl_tbl_type IS TABLE OF cfl_rec_type
81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------
81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
85: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
97: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
95: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
96: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
97: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
98:
107: ---------------------------------------------------------------------------
108: -- GLOBAL VARIABLES
109: ---------------------------------------------------------------------------
110: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CFL_PVT';
111: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
112:
113: --Bug 4299668 PAGARG Included these types, to be used for bulk insert
114: --**START**--
115: TYPE NumberTabTyp IS TABLE OF NUMBER
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_cflv_tbl IN cflv_tbl_type,
155: x_cflv_tbl OUT NOCOPY cflv_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_cflv_tbl IN cflv_tbl_type,
190: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
191: PROCEDURE lock_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2,
194: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_cflv_tbl IN cflv_tbl_type,
213: x_cflv_tbl OUT NOCOPY cflv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE update_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2,
218: x_return_status OUT NOCOPY VARCHAR2,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_cflv_tbl IN cflv_tbl_type,
237: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
238: PROCEDURE delete_row(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2,
241: x_return_status OUT NOCOPY VARCHAR2,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_cflv_tbl IN cflv_tbl_type,
259: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
260: PROCEDURE validate_row(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2,
263: x_return_status OUT NOCOPY VARCHAR2,