3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE cat_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
8: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
9: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
10: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
13: cat_id NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
17: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
20: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
22: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
38: security_group_id NUMBER := OKC_API.G_MISS_NUM);
31: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
38: security_group_id NUMBER := OKC_API.G_MISS_NUM);
39: g_miss_cat_rec cat_rec_type;
32: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
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
33: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
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;
34: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
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 (
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,
47: object_version_number NUMBER := OKC_API.G_MISS_NUM,
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,
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,
51: -- text ... commented out to treat empty CLOB as an of empty content:
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,
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,
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,
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,
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,
63: sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
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;
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;
65: TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
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;
65: TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
66: INDEX BY BINARY_INTEGER;
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 (
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,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
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,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
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,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
67: TYPE catv_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: chr_id NUMBER := OKC_API.G_MISS_NUM,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
68: id NUMBER := OKC_API.G_MISS_NUM,
69: chr_id NUMBER := OKC_API.G_MISS_NUM,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: chr_id NUMBER := OKC_API.G_MISS_NUM,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
70: cle_id NUMBER := OKC_API.G_MISS_NUM,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
71: cat_id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
74: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82: -- text ... commented out to treat empty CLOB as an of empty content:
75: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82: -- text ... commented out to treat empty CLOB as an of empty content:
83: -- if need to nullify it then nullify contents, not the pointer
76: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82: -- text ... commented out to treat empty CLOB as an of empty content:
83: -- if need to nullify it then nullify contents, not the pointer
84: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
77: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78: comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82: -- text ... commented out to treat empty CLOB as an of empty content:
83: -- if need to nullify it then nullify contents, not the pointer
84: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
85: --+Hand code start
80: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81: name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82: -- text ... commented out to treat empty CLOB as an of empty content:
83: -- if need to nullify it then nullify contents, not the pointer
84: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
85: --+Hand code start
86: -- text OKC_K_ARTICLES_V.TEXT%TYPE,
87: --+Hand code end
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
85: --+Hand code start
86: -- text OKC_K_ARTICLES_V.TEXT%TYPE,
87: --+Hand code end
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
85: --+Hand code start
86: -- text OKC_K_ARTICLES_V.TEXT%TYPE,
87: --+Hand code end
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
86: -- text OKC_K_ARTICLES_V.TEXT%TYPE,
87: --+Hand code end
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
87: --+Hand code end
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
88: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
89: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
90: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
91: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
92: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
93: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
94: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
95: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
96: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
97: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
98: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
100: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
101: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
102: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_catv_rec catv_rec_type;
103: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_catv_rec catv_rec_type;
111: TYPE catv_tbl_type IS TABLE OF catv_rec_type
104: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_catv_rec catv_rec_type;
111: TYPE catv_tbl_type IS TABLE OF catv_rec_type
112: INDEX BY BINARY_INTEGER;
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_catv_rec catv_rec_type;
111: TYPE catv_tbl_type IS TABLE OF catv_rec_type
112: INDEX BY BINARY_INTEGER;
113: ---------------------------------------------------------------------------
112: INDEX BY BINARY_INTEGER;
113: ---------------------------------------------------------------------------
114: -- GLOBAL MESSAGE CONSTANTS
115: ---------------------------------------------------------------------------
116: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113: ---------------------------------------------------------------------------
114: -- GLOBAL MESSAGE CONSTANTS
115: ---------------------------------------------------------------------------
116: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
114: -- GLOBAL MESSAGE CONSTANTS
115: ---------------------------------------------------------------------------
116: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
115: ---------------------------------------------------------------------------
116: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
116: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL VARIABLES
120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL VARIABLES
128: ---------------------------------------------------------------------------
121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126: ---------------------------------------------------------------------------
127: -- GLOBAL VARIABLES
128: ---------------------------------------------------------------------------
129: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CAT_PVT';
126: ---------------------------------------------------------------------------
127: -- GLOBAL VARIABLES
128: ---------------------------------------------------------------------------
129: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CAT_PVT';
130: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
131: ---------------------------------------------------------------------------
132: -- Procedures and Functions
133: ---------------------------------------------------------------------------
134:
137: PROCEDURE api_copy;
138: PROCEDURE add_language;
139: PROCEDURE insert_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_catv_rec IN catv_rec_type,
146: x_catv_rec OUT NOCOPY catv_rec_type);
147:
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_catv_tbl IN catv_tbl_type,
155: x_catv_tbl OUT NOCOPY catv_tbl_type);
156:
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_catv_rec IN catv_rec_type);
163: p_catv_rec IN catv_rec_type);
164:
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_catv_tbl IN catv_tbl_type);
171: p_catv_tbl IN catv_tbl_type);
172:
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_catv_rec IN catv_rec_type,
180: x_catv_rec OUT NOCOPY catv_rec_type);
181:
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_catv_tbl IN catv_tbl_type,
189: x_catv_tbl OUT NOCOPY catv_tbl_type);
190:
191: PROCEDURE delete_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_catv_rec IN catv_rec_type);
197: p_catv_rec IN catv_rec_type);
198:
199: PROCEDURE delete_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_catv_tbl IN catv_tbl_type);
205: p_catv_tbl IN catv_tbl_type);
206:
207: PROCEDURE validate_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_catv_rec IN catv_rec_type);
213: p_catv_rec IN catv_rec_type);
214:
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_catv_tbl IN catv_tbl_type);