4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE scn_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: scn_type OKC_SECTIONS_B.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: sat_code OKC_SECTIONS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: section_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
6: TYPE scn_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: scn_type OKC_SECTIONS_B.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: sat_code OKC_SECTIONS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: section_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
10: sat_code OKC_SECTIONS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: section_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
18: label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
22: attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
24: attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
25: attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
26: attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
27: attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35: attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
28: attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35: attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
36: g_miss_scn_rec scn_rec_type;
29: attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35: attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
36: g_miss_scn_rec scn_rec_type;
37: TYPE scn_tbl_type IS TABLE OF scn_rec_type
30: attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35: attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
36: g_miss_scn_rec scn_rec_type;
37: TYPE scn_tbl_type IS TABLE OF scn_rec_type
38: INDEX BY BINARY_INTEGER;
31: attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32: attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33: attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34: attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35: attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
36: g_miss_scn_rec scn_rec_type;
37: TYPE scn_tbl_type IS TABLE OF scn_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okc_sections_tl_rec_type IS RECORD (