4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE idx_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_INDICES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: idx_type OKL_INDICES.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
10: idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE idx_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_INDICES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: idx_type OKL_INDICES.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
10: idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE idx_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_INDICES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: idx_type OKL_INDICES.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
10: idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_INDICES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: idx_type OKL_INDICES.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
10: idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
16: program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
26: attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
27: attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
28: attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKL_INDICES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKL_INDICES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: g_miss_idx_rec idx_rec_type;
32: attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKL_INDICES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: g_miss_idx_rec idx_rec_type;
39: TYPE idx_tbl_type IS TABLE OF idx_rec_type
40: INDEX BY BINARY_INTEGER;
40: INDEX BY BINARY_INTEGER;
41: TYPE idxv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
41: TYPE idxv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
44: name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
46: attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
58: attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: program_application_id NUMBER := OKC_API.G_MISS_NUM,
59: attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: program_application_id NUMBER := OKC_API.G_MISS_NUM,
67: program_update_date OKL_INDICES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: program_application_id NUMBER := OKC_API.G_MISS_NUM,
67: program_update_date OKL_INDICES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKL_INDICES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKL_INDICES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: program_application_id NUMBER := OKC_API.G_MISS_NUM,
67: program_update_date OKL_INDICES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKL_INDICES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKL_INDICES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_idxv_rec idxv_rec_type;
67: program_update_date OKL_INDICES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKL_INDICES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKL_INDICES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_idxv_rec idxv_rec_type;
74: TYPE idxv_tbl_type IS TABLE OF idxv_rec_type
75: INDEX BY BINARY_INTEGER;