38: security_group_id NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_cat_rec cat_rec_type;
40: TYPE cat_tbl_type IS TABLE OF cat_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE okc_k_articles_tl_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: TYPE cat_tbl_type IS TABLE OF cat_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE okc_k_articles_tl_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
41: INDEX BY BINARY_INTEGER;
42: TYPE okc_k_articles_tl_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: TYPE okc_k_articles_tl_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
51: -- text ... commented out to treat empty CLOB as an of empty content:
52: -- if need to nullify it then nullify contents, not the pointer
45: source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
51: -- text ... commented out to treat empty CLOB as an of empty content:
52: -- if need to nullify it then nullify contents, not the pointer
53: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
46: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
48: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
51: -- text ... commented out to treat empty CLOB as an of empty content:
52: -- if need to nullify it then nullify contents, not the pointer
53: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
54: --+Hand code start
49: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
51: -- text ... commented out to treat empty CLOB as an of empty content:
52: -- if need to nullify it then nullify contents, not the pointer
53: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
54: --+Hand code start
55: -- text OKC_K_ARTICLES_TL.TEXT%TYPE,
56: --+Hand code end
57: created_by NUMBER := OKC_API.G_MISS_NUM,
51: -- text ... commented out to treat empty CLOB as an of empty content:
52: -- if need to nullify it then nullify contents, not the pointer
53: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
54: --+Hand code start
55: -- text OKC_K_ARTICLES_TL.TEXT%TYPE,
56: --+Hand code end
57: created_by NUMBER := OKC_API.G_MISS_NUM,
58: creation_date OKC_K_ARTICLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
54: --+Hand code start
55: -- text OKC_K_ARTICLES_TL.TEXT%TYPE,
56: --+Hand code end
57: created_by NUMBER := OKC_API.G_MISS_NUM,
58: creation_date OKC_K_ARTICLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60: last_update_date OKC_K_ARTICLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: security_group_id NUMBER := OKC_API.G_MISS_NUM,
56: --+Hand code end
57: created_by NUMBER := OKC_API.G_MISS_NUM,
58: creation_date OKC_K_ARTICLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60: last_update_date OKC_K_ARTICLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: security_group_id NUMBER := OKC_API.G_MISS_NUM,
63: sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
59: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60: last_update_date OKC_K_ARTICLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: security_group_id NUMBER := OKC_API.G_MISS_NUM,
63: sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
65: TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE catv_rec_type IS RECORD (
60: last_update_date OKC_K_ARTICLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: security_group_id NUMBER := OKC_API.G_MISS_NUM,
63: sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
65: TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE catv_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
61: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: security_group_id NUMBER := OKC_API.G_MISS_NUM,
63: sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
65: TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE catv_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: chr_id NUMBER := OKC_API.G_MISS_NUM,