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_NON_STD_ART_GRP dependencies on OKC_ARTICLES_ALL

Line 78: lx_article_number okc_articles_all.article_number%TYPE;

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

Line 80: l_article_number okc_articles_all.article_number%TYPE;

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

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

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

Line 94: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art

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