47: INDEX BY BINARY_INTEGER;
48: TYPE saev_rec_type IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: object_version_number NUMBER := OKC_API.G_MISS_NUM,
51: sfwt_flag OKC_STD_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: TYPE saev_rec_type IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: object_version_number NUMBER := OKC_API.G_MISS_NUM,
51: sfwt_flag OKC_STD_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: id NUMBER := OKC_API.G_MISS_NUM,
50: object_version_number NUMBER := OKC_API.G_MISS_NUM,
51: sfwt_flag OKC_STD_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: object_version_number NUMBER := OKC_API.G_MISS_NUM,
51: sfwt_flag OKC_STD_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKC_STD_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: sbt_code OKC_STD_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_STD_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute_category OKC_STD_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute1 OKC_STD_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute2 OKC_STD_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute3 OKC_STD_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute4 OKC_STD_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute5 OKC_STD_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute6 OKC_STD_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute7 OKC_STD_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: attribute8 OKC_STD_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
63: attribute9 OKC_STD_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_STD_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: attribute10 OKC_STD_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_STD_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: attribute11 OKC_STD_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66: attribute12 OKC_STD_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_STD_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_STD_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: attribute13 OKC_STD_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68: attribute14 OKC_STD_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_STD_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_STD_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saev_rec saev_rec_type;
69: attribute15 OKC_STD_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70: created_by NUMBER := OKC_API.G_MISS_NUM,
71: creation_date OKC_STD_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: last_update_date OKC_STD_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: g_miss_saev_rec saev_rec_type;
76: TYPE saev_tbl_type IS TABLE OF saev_rec_type
77: INDEX BY BINARY_INTEGER;
106: G_LEN_CHK CONSTANT varchar2(200) := 'OKC_LENGTH_EXCEEDS';
107: G_CANNOT_DELETE CONSTANT VARCHAR2(200) := 'OKC_SAE_CANNOT_DELETE';
108:
109: --GLOBAL VARIABLES
110: G_VIEW CONSTANT varchar2(30) := 'OKC_STD_ARTICLES_V';
111: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
112:
113: ---------------------------------------------------------------------------
114: --Private Validation Procedures