eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_K_ARTICLE_PUB dependencies on OKC_K_ARTICLES_V

Line 32: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE,

28: chr_id NUMBER,
29: cle_id NUMBER,
30: cat_id NUMBER,
31: object_version_number NUMBER,
32: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE,
33: sav_sae_id NUMBER,
34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,
35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,

Line 34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,

30: cat_id NUMBER,
31: object_version_number NUMBER,
32: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE,
33: sav_sae_id NUMBER,
34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,
35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,

Line 35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,

31: object_version_number NUMBER,
32: sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE,
33: sav_sae_id NUMBER,
34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,
35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,
39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,

Line 37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,

33: sav_sae_id NUMBER,
34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,
35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,
39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:

Line 38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,

34: sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE,
35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,
39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer

Line 39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,

35: sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE,
36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,
39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer
43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,

Line 40: name OKC_K_ARTICLES_V.NAME%TYPE,

36: dnz_chr_id NUMBER,
37: comments OKC_K_ARTICLES_V.COMMENTS%TYPE,
38: fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE,
39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer
43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
44: --+Hand code start

Line 43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,

39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer
43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
44: --+Hand code start
45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,

Line 45: text OKC_K_ARTICLES_V.TEXT%TYPE,

41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer
43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
44: --+Hand code start
45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,

Line 47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,

43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
44: --+Hand code start
45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,

Line 48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,

44: --+Hand code start
45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,

Line 49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,

45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,

Line 50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,

46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,

Line 51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,

47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,
48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,

Line 52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,

48: attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE,
49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,

Line 53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,

49: attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE,
50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,

Line 54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,

50: attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE,
51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,

Line 55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,

51: attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE,
52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,

Line 56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,

52: attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE,
53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,

Line 57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,

53: attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE,
54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,

Line 58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,

54: attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE,
55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,

Line 59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,

55: attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE,
56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,

Line 60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,

56: attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE,
57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,

Line 61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,

57: attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE,
58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,
65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,

Line 62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,

58: attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE,
59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,
65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,
66: last_updated_by NUMBER,

Line 63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,

59: attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE,
60: attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE,
61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,
65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,
66: last_updated_by NUMBER,
67: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE,

Line 65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,

61: attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE,
62: attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE,
63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,
65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,
66: last_updated_by NUMBER,
67: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE,
68: last_update_login NUMBER,
69: -- new 11i10 columns

Line 67: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE,

63: cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE,
64: created_by NUMBER,
65: creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE,
66: last_updated_by NUMBER,
67: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE,
68: last_update_login NUMBER,
69: -- new 11i10 columns
70: -- defaulted during insert based on App_Id
71: document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE,

Line 199: -- FUNCTION get_rec for: OKC_K_ARTICLES_V

195: Print( ' cat_type=['||p_catv_rec.cat_type||']');
196: END;
197:
198: ---------------------------------------------------------------------------
199: -- FUNCTION get_rec for: OKC_K_ARTICLES_V
200: ---------------------------------------------------------------------------
201: FUNCTION get_rec (
202: p_id IN NUMBER,
203: p_major_version IN NUMBER := NULL,

Line 245: FROM Okc_K_Articles_V

241: CREATION_DATE,
242: LAST_UPDATED_BY,
243: LAST_UPDATE_DATE,
244: LAST_UPDATE_LOGIN
245: FROM Okc_K_Articles_V
246: WHERE id = p_id;
247: CURSOR okc_catv_h_pk_csr (p_id IN NUMBER, p_major_version NUMBER) IS
248: SELECT
249: ID,