4: --------------------------------------------------------------------------------------------
5: --ARTICLES
6: --------------------------------------------------------------------------------------------
7: TYPE catv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: --ARTICLES
6: --------------------------------------------------------------------------------------------
7: TYPE catv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
6: --------------------------------------------------------------------------------------------
7: TYPE catv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
7: TYPE catv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
11: cat_id NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
14: sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
15: sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
16: sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
17: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19: fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: -- text ... commented out to treat empty CLOB as an of empty content:
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: -- if need to nullify it then nullify contents, not the pointer
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
35: attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
36: attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
37: attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: g_miss_catv_rec catv_rec_type;
40: attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: g_miss_catv_rec catv_rec_type;
48: TYPE catv_tbl_type IS TABLE OF catv_rec_type
41: cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: g_miss_catv_rec catv_rec_type;
48: TYPE catv_tbl_type IS TABLE OF catv_rec_type
49: INDEX BY BINARY_INTEGER;
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: g_miss_catv_rec catv_rec_type;
48: TYPE catv_tbl_type IS TABLE OF catv_rec_type
49: INDEX BY BINARY_INTEGER;
50:
51: --------------------------------------------------------------------------------------------
52: --RULE GROUPS
53: --------------------------------------------------------------------------------------------
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: --RULE GROUPS
53: --------------------------------------------------------------------------------------------
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: --------------------------------------------------------------------------------------------
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
65: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
75: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
76: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
77: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
78: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
80: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
88: INDEX BY BINARY_INTEGER;
81: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
88: INDEX BY BINARY_INTEGER;
89:
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
88: INDEX BY BINARY_INTEGER;
89:
90: --------------------------------------------------------------------------------------------
106: subtype msg_tbl_type is qa_msg_tbl_type;
107: --------------------------------------------------------------------------------------------
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_catv_rec IN catv_rec_type,
115: x_catv_rec OUT NOCOPY catv_rec_type);
116:
117: PROCEDURE update_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_catv_rec IN catv_rec_type,
124: x_catv_rec OUT NOCOPY catv_rec_type);
125:
126: PROCEDURE delete_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_catv_rec IN catv_rec_type);
134: ----------------------------------------------------------------------------------
135: -- INSERT for OKC_RGP_PVT
136: PROCEDURE insert_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_rgpv_rec IN rgpv_rec_type,
143: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
144: -- UPDATE for OKC_RGP_PVT
145: PROCEDURE update_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_rgpv_rec IN rgpv_rec_type,
152: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
153: -- DELETE for OKC_RGP_PVT
154: PROCEDURE delete_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_rgpv_rec IN rgpv_rec_type);
161: ----------------------------------------------------------------------------------
162: -- QA CHECK LIST
163: PROCEDURE execute_qa_check_list(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_qcl_id IN NUMBER,