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
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
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;
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;
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
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
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;
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;