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;