4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE inr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: iac_code OKL_INS_RATES.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
9: ipt_id NUMBER := Okc_Api.G_MISS_NUM,
10: ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR,
11: coverage_max NUMBER := Okc_Api.G_MISS_NUM,
12: deductible NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE inr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: iac_code OKL_INS_RATES.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
9: ipt_id NUMBER := Okc_Api.G_MISS_NUM,
10: ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR,
11: coverage_max NUMBER := Okc_Api.G_MISS_NUM,
12: deductible NUMBER := Okc_Api.G_MISS_NUM,
13: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
14: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
13: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
14: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
15: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
16: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
17: date_from OKL_INS_RATES.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
18: date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
14: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
15: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
16: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
17: date_from OKL_INS_RATES.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
18: date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
16: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
17: date_from OKL_INS_RATES.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
18: date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
17: date_from OKL_INS_RATES.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
18: date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
18: date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
19: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
29: attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
37: creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
30: attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
37: creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
31: attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
37: creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
39: last_update_date OKL_INS_RATES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
33: attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
37: creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
39: last_update_date OKL_INS_RATES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
41: g_miss_inr_rec inr_rec_type;
35: attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36: created_by NUMBER := Okc_Api.G_MISS_NUM,
37: creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
39: last_update_date OKL_INS_RATES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
41: g_miss_inr_rec inr_rec_type;
42: TYPE inr_tbl_type IS TABLE OF inr_rec_type
43: INDEX BY BINARY_INTEGER;
43: INDEX BY BINARY_INTEGER;
44: TYPE inrv_rec_type IS RECORD (
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
47: ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR ,
48: ipt_id NUMBER := Okc_Api.G_MISS_NUM,
49: iac_code OKL_INS_RATES_V.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
50: coverage_max NUMBER := Okc_Api.G_MISS_NUM,
51: deductible NUMBER := Okc_Api.G_MISS_NUM,
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
47: ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR ,
48: ipt_id NUMBER := Okc_Api.G_MISS_NUM,
49: iac_code OKL_INS_RATES_V.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
50: coverage_max NUMBER := Okc_Api.G_MISS_NUM,
51: deductible NUMBER := Okc_Api.G_MISS_NUM,
52: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
53: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
51: deductible NUMBER := Okc_Api.G_MISS_NUM,
52: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
53: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
54: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
55: date_from OKL_INS_RATES_V.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
56: date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
52: factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
53: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
54: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
55: date_from OKL_INS_RATES_V.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
56: date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
54: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
55: date_from OKL_INS_RATES_V.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
56: date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
55: date_from OKL_INS_RATES_V.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
56: date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
56: date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
57: insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
67: attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
68: attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
69: attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70: attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_INS_RATES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72: attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_INS_RATES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
79: g_miss_inrv_rec inrv_rec_type;
73: attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74: created_by NUMBER := Okc_Api.G_MISS_NUM,
75: creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77: last_update_date OKL_INS_RATES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
79: g_miss_inrv_rec inrv_rec_type;
80: TYPE inrv_tbl_type IS TABLE OF inrv_rec_type
81: INDEX BY BINARY_INTEGER;