4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE opt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPTIONS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE opt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPTIONS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_OPTIONS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
8: name OKL_OPTIONS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
10: description OKL_OPTIONS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_OPTIONS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
12: to_date OKL_OPTIONS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
13: attribute_category OKL_OPTIONS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
14: attribute1 OKL_OPTIONS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
15: attribute2 OKL_OPTIONS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
16: attribute3 OKL_OPTIONS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
17: attribute4 OKL_OPTIONS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
18: attribute5 OKL_OPTIONS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
19: attribute6 OKL_OPTIONS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
20: attribute7 OKL_OPTIONS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
21: attribute8 OKL_OPTIONS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
22: attribute9 OKL_OPTIONS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKL_OPTIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: attribute10 OKL_OPTIONS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKL_OPTIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: attribute11 OKL_OPTIONS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute12 OKL_OPTIONS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKL_OPTIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKL_OPTIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: attribute13 OKL_OPTIONS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute14 OKL_OPTIONS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKL_OPTIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKL_OPTIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM);
34: g_miss_opt_rec opt_rec_type;
28: attribute15 OKL_OPTIONS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKL_OPTIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKL_OPTIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM);
34: g_miss_opt_rec opt_rec_type;
35: TYPE opt_tbl_type IS TABLE OF opt_rec_type
36: INDEX BY BINARY_INTEGER;
36: INDEX BY BINARY_INTEGER;
37: TYPE optv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: object_version_number NUMBER := OKC_API.G_MISS_NUM,
40: name OKL_OPTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
37: TYPE optv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: object_version_number NUMBER := OKC_API.G_MISS_NUM,
40: name OKL_OPTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
38: id NUMBER := OKC_API.G_MISS_NUM,
39: object_version_number NUMBER := OKC_API.G_MISS_NUM,
40: name OKL_OPTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
39: object_version_number NUMBER := OKC_API.G_MISS_NUM,
40: name OKL_OPTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
40: name OKL_OPTIONS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
41: description OKL_OPTIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
42: from_date OKL_OPTIONS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
43: to_date OKL_OPTIONS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
44: attribute_category OKL_OPTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
45: attribute1 OKL_OPTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
46: attribute2 OKL_OPTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
47: attribute3 OKL_OPTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
48: attribute4 OKL_OPTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
49: attribute5 OKL_OPTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
50: attribute6 OKL_OPTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
51: attribute7 OKL_OPTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
52: attribute8 OKL_OPTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
53: attribute9 OKL_OPTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKL_OPTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: attribute10 OKL_OPTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKL_OPTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: attribute11 OKL_OPTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute12 OKL_OPTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKL_OPTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKL_OPTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
57: attribute13 OKL_OPTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute14 OKL_OPTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKL_OPTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKL_OPTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_update_login NUMBER := OKC_API.G_MISS_NUM);
65: g_miss_optv_rec optv_rec_type;
59: attribute15 OKL_OPTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKL_OPTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKL_OPTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_update_login NUMBER := OKC_API.G_MISS_NUM);
65: g_miss_optv_rec optv_rec_type;
66: TYPE optv_tbl_type IS TABLE OF optv_rec_type
67: INDEX BY BINARY_INTEGER;