11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE spn_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: tve_id NUMBER := OKC_API.G_MISS_NUM,
15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
14: tve_id NUMBER := OKC_API.G_MISS_NUM,
15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16: spn_id NUMBER := OKC_API.G_MISS_NUM,
17: duration NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
34: attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
35: attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
36: attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
44: INDEX BY BINARY_INTEGER;
37: attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38: attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39: attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40: attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41: attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42: g_miss_spn_rec spn_rec_type;
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
44: INDEX BY BINARY_INTEGER;
45: TYPE spnv_rec_type IS RECORD (
45: TYPE spnv_rec_type IS RECORD (
46: id NUMBER := OKC_API.G_MISS_NUM,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: tve_id NUMBER := OKC_API.G_MISS_NUM,
49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: tve_id NUMBER := OKC_API.G_MISS_NUM,
49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: spn_id NUMBER := OKC_API.G_MISS_NUM,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: duration NUMBER := OKC_API.G_MISS_NUM,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
63: attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_spnv_rec spnv_rec_type;
69: attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_spnv_rec spnv_rec_type;
76: TYPE spnv_tbl_type IS TABLE OF spnv_rec_type
77: INDEX BY BINARY_INTEGER;