3: ---------------------------------------------------------------------------
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,
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,
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,
15: program_application_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,
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,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%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,
17: attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKL_INDICES.ATTRIBUTE1%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,
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,
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,
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,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM);
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;
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;
39: TYPE idx_tbl_type IS TABLE OF 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;
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;
41: TYPE idxv_rec_type IS RECORD (
38: g_miss_idx_rec idx_rec_type;
39: TYPE idx_tbl_type IS TABLE OF idx_rec_type
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,
39: TYPE idx_tbl_type IS TABLE OF idx_rec_type
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,
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,
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,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
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,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKL_INDICES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
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,
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,
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,
72: last_update_login 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,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_idxv_rec idxv_rec_type;
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;
74: TYPE idxv_tbl_type IS TABLE OF 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;
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;
76: ---------------------------------------------------------------------------
82: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
84: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
85:
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
84: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
85:
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
85:
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85:
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
99: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IDX_PVT';
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
99: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IDX_PVT';
100: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
101: ---------------------------------------------------------------------------
102: -- Procedures and Functions
103: ---------------------------------------------------------------------------
104:
106: PROCEDURE change_version;
107: PROCEDURE api_copy;
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_idxv_rec IN idxv_rec_type,
115: x_idxv_rec OUT NOCOPY idxv_rec_type);
116:
117: PROCEDURE insert_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_idxv_tbl IN idxv_tbl_type,
124: x_idxv_tbl OUT NOCOPY idxv_tbl_type);
125:
126: PROCEDURE lock_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_idxv_rec IN idxv_rec_type);
132: p_idxv_rec IN idxv_rec_type);
133:
134: PROCEDURE lock_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_idxv_tbl IN idxv_tbl_type);
140: p_idxv_tbl IN idxv_tbl_type);
141:
142: PROCEDURE update_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_idxv_rec IN idxv_rec_type,
149: x_idxv_rec OUT NOCOPY idxv_rec_type);
150:
151: PROCEDURE update_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_idxv_tbl IN idxv_tbl_type,
158: x_idxv_tbl OUT NOCOPY idxv_tbl_type);
159:
160: PROCEDURE delete_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_idxv_rec IN idxv_rec_type);
166: p_idxv_rec IN idxv_rec_type);
167:
168: PROCEDURE delete_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_idxv_tbl IN idxv_tbl_type);
174: p_idxv_tbl IN idxv_tbl_type);
175:
176: PROCEDURE validate_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_idxv_rec IN idxv_rec_type);
182: p_idxv_rec IN idxv_rec_type);
183:
184: PROCEDURE validate_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_idxv_tbl IN idxv_tbl_type);