6: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
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,
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
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,
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
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,
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,
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,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
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,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by 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,
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,
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,
24: last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
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,
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,
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,
27: attribute1 OKC_SPAN.ATTRIBUTE1%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,
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,
29: attribute3 OKC_SPAN.ATTRIBUTE3%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 (
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 (
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,
43: TYPE spn_tbl_type IS TABLE OF spn_rec_type
44: INDEX BY BINARY_INTEGER;
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,
44: INDEX BY BINARY_INTEGER;
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,
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,
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,
54: attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%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,
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,
56: attribute2 OKC_SPAN_V.ATTRIBUTE2%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,
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,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
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;
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;
76: TYPE spnv_tbl_type IS TABLE OF 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;
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;
78: ---------------------------------------------------------------------------
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: ---------------------------------------------------------------------------
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: ---------------------------------------------------------------------------
92: -- GLOBAL VARIABLES
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: ---------------------------------------------------------------------------
92: -- GLOBAL VARIABLES
93: ---------------------------------------------------------------------------
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: ---------------------------------------------------------------------------
92: -- GLOBAL VARIABLES
93: ---------------------------------------------------------------------------
94: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SPN_PVT';
91: ---------------------------------------------------------------------------
92: -- GLOBAL VARIABLES
93: ---------------------------------------------------------------------------
94: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SPN_PVT';
95: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
96: ---------------------------------------------------------------------------
97: -- Procedures and Functions
98: ---------------------------------------------------------------------------
99:
101: PROCEDURE change_version;
102: PROCEDURE api_copy;
103: PROCEDURE insert_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_spnv_rec IN spnv_rec_type,
110: x_spnv_rec OUT NOCOPY spnv_rec_type);
111:
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_spnv_tbl IN spnv_tbl_type,
119: x_spnv_tbl OUT NOCOPY spnv_tbl_type);
120:
121: PROCEDURE lock_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_spnv_rec IN spnv_rec_type);
127: p_spnv_rec IN spnv_rec_type);
128:
129: PROCEDURE lock_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_spnv_tbl IN spnv_tbl_type);
135: p_spnv_tbl IN spnv_tbl_type);
136:
137: PROCEDURE update_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_spnv_rec IN spnv_rec_type,
144: x_spnv_rec OUT NOCOPY spnv_rec_type);
145:
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_spnv_tbl IN spnv_tbl_type,
153: x_spnv_tbl OUT NOCOPY spnv_tbl_type);
154:
155: PROCEDURE delete_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_spnv_rec IN spnv_rec_type);
161: p_spnv_rec IN spnv_rec_type);
162:
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_spnv_tbl IN spnv_tbl_type);
169: p_spnv_tbl IN spnv_tbl_type);
170:
171: PROCEDURE validate_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_spnv_rec IN spnv_rec_type);
177: p_spnv_rec IN spnv_rec_type);
178:
179: PROCEDURE validate_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_spnv_tbl IN spnv_tbl_type);