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,
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,
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,
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,
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,
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,
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: ---------------------------------------------------------------------------
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';
105: G_EXCEPTION_HALT_VALIDATION exception;
106: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_SECTIONS_V';
107:
108: ---------------------------------------------------------------------------
109: -- GLOBAL VARIABLES
110: ---------------------------------------------------------------------------