3: ---------------------------------------------------------------------------
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,
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,
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,
13: object_version_number 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,
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,
15: insured_rate 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,
15: insured_rate NUMBER := Okc_Api.G_MISS_NUM,
16: factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
23: attribute3 OKL_INS_RATES.ATTRIBUTE3%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,
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,
40: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
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;
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;
42: TYPE inr_tbl_type IS TABLE OF 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;
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;
44: TYPE inrv_rec_type IS RECORD (
41: g_miss_inr_rec inr_rec_type;
42: TYPE inr_tbl_type IS TABLE OF inr_rec_type
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,
42: TYPE inr_tbl_type IS TABLE OF inr_rec_type
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,
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,
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,
52: factor_range_start 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,
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,
54: factor_range_end 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
61: attribute3 OKL_INS_RATES_V.ATTRIBUTE3%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,
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,
78: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
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;
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;
80: TYPE inrv_tbl_type IS TABLE OF 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;
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;
82: ---------------------------------------------------------------------------
81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'CHILD_TABLE';
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
92: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
95: G_POSITIVE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_POSITIVE_NUMBER';
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100:
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
95: G_POSITIVE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_POSITIVE_NUMBER';
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100:
101:
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
95: G_POSITIVE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_POSITIVE_NUMBER';
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100:
101:
102: ---------------------------------------------------------------------------
95: G_POSITIVE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_POSITIVE_NUMBER';
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100:
101:
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
117: PROCEDURE change_version;
118: PROCEDURE api_copy;
119: PROCEDURE insert_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_inrv_rec IN inrv_rec_type,
126: x_inrv_rec OUT NOCOPY inrv_rec_type);
127:
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_inrv_tbl IN inrv_tbl_type,
135: x_inrv_tbl OUT NOCOPY inrv_tbl_type);
136:
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_inrv_rec IN inrv_rec_type);
143: p_inrv_rec IN inrv_rec_type);
144:
145: PROCEDURE lock_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_inrv_tbl IN inrv_tbl_type);
151: p_inrv_tbl IN inrv_tbl_type);
152:
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_inrv_rec IN inrv_rec_type,
160: x_inrv_rec OUT NOCOPY inrv_rec_type);
161:
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_inrv_tbl IN inrv_tbl_type,
169: x_inrv_tbl OUT NOCOPY inrv_tbl_type);
170:
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_inrv_rec IN inrv_rec_type);
177: p_inrv_rec IN inrv_rec_type);
178:
179: PROCEDURE delete_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_inrv_tbl IN inrv_tbl_type);
185: p_inrv_tbl IN inrv_tbl_type);
186:
187: PROCEDURE validate_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_inrv_rec IN inrv_rec_type);
193: p_inrv_rec IN inrv_rec_type);
194:
195: PROCEDURE validate_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_inrv_tbl IN inrv_tbl_type);