3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE irkv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE irkv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: TYPE irkv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
6: TYPE irkv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
8: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
10: ,date_from OKL_INSURER_RANKINGS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
11: ,date_to OKL_INSURER_RANKINGS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
12: ,isu_id NUMBER := OKC_API.G_MISS_NUM
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
13: ,ic_code OKL_INSURER_RANKINGS_V.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute_category OKL_INSURER_RANKINGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute1 OKL_INSURER_RANKINGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute2 OKL_INSURER_RANKINGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute3 OKL_INSURER_RANKINGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute4 OKL_INSURER_RANKINGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute5 OKL_INSURER_RANKINGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute6 OKL_INSURER_RANKINGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute7 OKL_INSURER_RANKINGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute8 OKL_INSURER_RANKINGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,attribute9 OKL_INSURER_RANKINGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,attribute10 OKL_INSURER_RANKINGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,attribute11 OKL_INSURER_RANKINGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,attribute12 OKL_INSURER_RANKINGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
27: ,attribute13 OKL_INSURER_RANKINGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: G_MISS_irkv_rec irkv_rec_type;
28: ,attribute14 OKL_INSURER_RANKINGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: G_MISS_irkv_rec irkv_rec_type;
36: TYPE irkv_tbl_type IS TABLE OF irkv_rec_type
29: ,attribute15 OKL_INSURER_RANKINGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: G_MISS_irkv_rec irkv_rec_type;
36: TYPE irkv_tbl_type IS TABLE OF irkv_rec_type
37: INDEX BY BINARY_INTEGER;
30: ,created_by NUMBER := OKC_API.G_MISS_NUM
31: ,creation_date OKL_INSURER_RANKINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
33: ,last_update_date OKL_INSURER_RANKINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: G_MISS_irkv_rec irkv_rec_type;
36: TYPE irkv_tbl_type IS TABLE OF irkv_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE irk_rec_type IS RECORD (
35: G_MISS_irkv_rec irkv_rec_type;
36: TYPE irkv_tbl_type IS TABLE OF irkv_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE irk_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
36: TYPE irkv_tbl_type IS TABLE OF irkv_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE irk_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
37: INDEX BY BINARY_INTEGER;
38: TYPE irk_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
38: TYPE irk_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
39: id NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
41: ,ranking_seq NUMBER := OKC_API.G_MISS_NUM
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
42: ,date_from OKL_INSURER_RANKINGS.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
43: ,date_to OKL_INSURER_RANKINGS.DATE_TO%TYPE := OKC_API.G_MISS_DATE
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
44: ,isu_id NUMBER := OKC_API.G_MISS_NUM
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
45: ,ic_code OKL_INSURER_RANKINGS.IC_CODE%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute_category OKL_INSURER_RANKINGS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute1 OKL_INSURER_RANKINGS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute2 OKL_INSURER_RANKINGS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute3 OKL_INSURER_RANKINGS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute4 OKL_INSURER_RANKINGS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute5 OKL_INSURER_RANKINGS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute6 OKL_INSURER_RANKINGS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute7 OKL_INSURER_RANKINGS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute8 OKL_INSURER_RANKINGS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,attribute9 OKL_INSURER_RANKINGS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,attribute10 OKL_INSURER_RANKINGS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,attribute11 OKL_INSURER_RANKINGS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,attribute12 OKL_INSURER_RANKINGS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: ,attribute13 OKL_INSURER_RANKINGS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: G_MISS_irk_rec irk_rec_type;
60: ,attribute14 OKL_INSURER_RANKINGS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: G_MISS_irk_rec irk_rec_type;
68: TYPE irk_tbl_type IS TABLE OF irk_rec_type
61: ,attribute15 OKL_INSURER_RANKINGS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: G_MISS_irk_rec irk_rec_type;
68: TYPE irk_tbl_type IS TABLE OF irk_rec_type
69: INDEX BY BINARY_INTEGER;
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKL_INSURER_RANKINGS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKL_INSURER_RANKINGS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: G_MISS_irk_rec irk_rec_type;
68: TYPE irk_tbl_type IS TABLE OF irk_rec_type
69: INDEX BY BINARY_INTEGER;
70: ---------------------------------------------------------------------------
69: INDEX BY BINARY_INTEGER;
70: ---------------------------------------------------------------------------
71: -- GLOBAL MESSAGE CONSTANTS
72: ---------------------------------------------------------------------------
73: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
79: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
80: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
81: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
82: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87:
80: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
81: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
82: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87:
88:
81: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
82: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87:
88:
89:
82: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
83: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87:
88:
89:
90:
106: PROCEDURE change_version;
107: PROCEDURE api_copy;
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_irkv_rec IN irkv_rec_type,
114: p_irkv_rec IN irkv_rec_type,
115: x_irkv_rec OUT NOCOPY irkv_rec_type);
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_irkv_tbl IN irkv_tbl_type,
123: x_irkv_tbl OUT NOCOPY irkv_tbl_type,
124: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_irkv_tbl IN irkv_tbl_type,
131: p_irkv_tbl IN irkv_tbl_type,
132: x_irkv_tbl OUT NOCOPY irkv_tbl_type);
133: PROCEDURE lock_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_irkv_rec IN irkv_rec_type);
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_irkv_rec IN irkv_rec_type);
140: PROCEDURE lock_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_irkv_tbl IN irkv_tbl_type,
146: p_irkv_tbl IN irkv_tbl_type,
147: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
148: PROCEDURE lock_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_irkv_tbl IN irkv_tbl_type);
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_irkv_tbl IN irkv_tbl_type);
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_irkv_rec IN irkv_rec_type,
161: p_irkv_rec IN irkv_rec_type,
162: x_irkv_rec OUT NOCOPY irkv_rec_type);
163: PROCEDURE update_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_irkv_tbl IN irkv_tbl_type,
170: x_irkv_tbl OUT NOCOPY irkv_tbl_type,
171: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_irkv_tbl IN irkv_tbl_type,
178: p_irkv_tbl IN irkv_tbl_type,
179: x_irkv_tbl OUT NOCOPY irkv_tbl_type);
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_irkv_rec IN irkv_rec_type);
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_irkv_rec IN irkv_rec_type);
187: PROCEDURE delete_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_irkv_tbl IN irkv_tbl_type,
193: p_irkv_tbl IN irkv_tbl_type,
194: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
195: PROCEDURE delete_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_irkv_tbl IN irkv_tbl_type);
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_irkv_tbl IN irkv_tbl_type);
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_irkv_rec IN irkv_rec_type);
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_irkv_rec IN irkv_rec_type);
209: PROCEDURE validate_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_irkv_tbl IN irkv_tbl_type,
215: p_irkv_tbl IN irkv_tbl_type,
216: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_irkv_tbl IN irkv_tbl_type);