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.

[Home] [Help]

APPS.OKC_K_NON_STD_ART_GRP dependencies on OKC_ARTICLES_ALL

Line 75: lx_article_number okc_articles_all.article_number%TYPE;

71: l_api_name CONSTANT VARCHAR2(30) := 'g_create_non_std_article';
72: l_intent VARCHAR2(1);
73: lx_article_id NUMBER;
74: l_std_article_id NUMBER;
75: lx_article_number okc_articles_all.article_number%TYPE;
76: -- Fix for bug# 5158268. Added variable for article_number
77: l_article_number okc_articles_all.article_number%TYPE;
78: l_amendment_description okc_k_articles_b.amendment_description%TYPE;
79: l_kart_tbl OKC_TERMS_MULTIREC_GRP.kart_tbl_type;

Line 77: l_article_number okc_articles_all.article_number%TYPE;

73: lx_article_id NUMBER;
74: l_std_article_id NUMBER;
75: lx_article_number okc_articles_all.article_number%TYPE;
76: -- Fix for bug# 5158268. Added variable for article_number
77: l_article_number okc_articles_all.article_number%TYPE;
78: l_amendment_description okc_k_articles_b.amendment_description%TYPE;
79: l_kart_tbl OKC_TERMS_MULTIREC_GRP.kart_tbl_type;
80: lx_kart_tbl OKC_TERMS_MULTIREC_GRP.kart_tbl_type;
81: l_ref_article_id okc_k_articles_b.ref_article_id%TYPE := NULL;

Line 88: -- Fix for bug# 5158268. Modified the cursor to query okc_articles_all for article_number

84: SELECT intent FROM OKC_BUS_DOC_TYPES_B
85: WHERE DOCUMENT_TYPE=P_DOC_TYPE;
86:
87:
88: -- Fix for bug# 5158268. Modified the cursor to query okc_articles_all for article_number
89: Cursor l_get_std_article IS
90: SELECT ver.article_id,ver.article_version_id, art.article_number
91: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art
92: WHERE ver.ARTICLE_VERSION_ID=p_std_article_version_id

Line 91: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art

87:
88: -- Fix for bug# 5158268. Modified the cursor to query okc_articles_all for article_number
89: Cursor l_get_std_article IS
90: SELECT ver.article_id,ver.article_version_id, art.article_number
91: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art
92: WHERE ver.ARTICLE_VERSION_ID=p_std_article_version_id
93: and art.article_id = ver.article_id;
94:
95: