3: ---------------------------------------------------------------------------
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,
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,
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,
13: created_by 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,
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,
15: last_updated_by 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,
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,
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,
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,
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,
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,
19: scn_id 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,
19: scn_id NUMBER := OKC_API.G_MISS_NUM,
20: attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
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,
21: attribute1 OKC_SECTIONS_B.ATTRIBUTE1%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,
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,
23: attribute3 OKC_SECTIONS_B.ATTRIBUTE3%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 (
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 (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
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 (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
38: INDEX BY BINARY_INTEGER;
39: TYPE okc_sections_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: TYPE okc_sections_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
43: sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
51: TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
44: heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
51: TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
52: INDEX BY BINARY_INTEGER;
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
51: TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE scnv_rec_type IS RECORD (
50: g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
51: TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE scnv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
51: TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE scnv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
52: INDEX BY BINARY_INTEGER;
53: TYPE scnv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
53: TYPE scnv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
54: id NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: chr_id NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
57: sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
58: section_sequence NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
59: label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
60: heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
61: scn_id NUMBER := OKC_API.G_MISS_NUM,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: object_version_number NUMBER := OKC_API.G_MISS_NUM,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: created_by NUMBER := OKC_API.G_MISS_NUM,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84: attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
77: attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84: attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
85: g_miss_scnv_rec scnv_rec_type;
78: attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84: attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
85: g_miss_scnv_rec scnv_rec_type;
86: TYPE scnv_tbl_type IS TABLE OF scnv_rec_type
79: attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84: attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
85: g_miss_scnv_rec scnv_rec_type;
86: TYPE scnv_tbl_type IS TABLE OF scnv_rec_type
87: INDEX BY BINARY_INTEGER;
80: attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81: attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82: attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83: attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84: attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
85: g_miss_scnv_rec scnv_rec_type;
86: TYPE scnv_tbl_type IS TABLE OF scnv_rec_type
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
102: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
102: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
103: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
102: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
103: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
104: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
108: ---------------------------------------------------------------------------
109: -- GLOBAL VARIABLES
110: ---------------------------------------------------------------------------
111: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SCN_PVT';
112: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
113: ---------------------------------------------------------------------------
114: -- Procedures and Functions
115: ---------------------------------------------------------------------------
116:
116:
117: PROCEDURE add_language;
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_scnv_rec IN scnv_rec_type,
125: x_scnv_rec OUT NOCOPY scnv_rec_type);
126:
127: PROCEDURE insert_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_scnv_tbl IN scnv_tbl_type,
134: x_scnv_tbl OUT NOCOPY scnv_tbl_type);
135:
136: PROCEDURE lock_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_scnv_rec IN scnv_rec_type);
142: p_scnv_rec IN scnv_rec_type);
143:
144: PROCEDURE lock_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_scnv_tbl IN scnv_tbl_type);
150: p_scnv_tbl IN scnv_tbl_type);
151:
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_scnv_rec IN scnv_rec_type,
159: x_scnv_rec OUT NOCOPY scnv_rec_type);
160:
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_scnv_tbl IN scnv_tbl_type,
168: x_scnv_tbl OUT NOCOPY scnv_tbl_type);
169:
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_scnv_rec IN scnv_rec_type);
176: p_scnv_rec IN scnv_rec_type);
177:
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_scnv_tbl IN scnv_tbl_type);
184: p_scnv_tbl IN scnv_tbl_type);
185:
186: PROCEDURE validate_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_scnv_rec IN scnv_rec_type);
192: p_scnv_rec IN scnv_rec_type);
193:
194: PROCEDURE validate_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_scnv_tbl IN scnv_tbl_type);