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_K_ARTICLES_B

Line 78: l_amendment_description okc_k_articles_b.amendment_description%TYPE;

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;
82: l_ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE := NULL;

Line 81: l_ref_article_id okc_k_articles_b.ref_article_id%TYPE := NULL;

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;
82: l_ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE := NULL;
83: Cursor l_get_intent_csr IS
84: SELECT intent FROM OKC_BUS_DOC_TYPES_B
85: WHERE DOCUMENT_TYPE=P_DOC_TYPE;

Line 82: l_ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE := NULL;

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;
82: l_ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE := NULL;
83: Cursor l_get_intent_csr IS
84: SELECT intent FROM OKC_BUS_DOC_TYPES_B
85: WHERE DOCUMENT_TYPE=P_DOC_TYPE;
86:

Line 442: FROM OKC_K_ARTICLES_B

438: article_version_id,
439: ref_article_version_id,
440: change_nonstd_yn,
441: object_version_number
442: FROM OKC_K_ARTICLES_B
443: WHERE id=p_cat_id;
444:
445: l_display_name okc_article_versions.display_name%TYPE;
446: l_article_description okc_article_versions.article_description%TYPE;

Line 753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;

749: ) IS
750:
751: l_api_version CONSTANT NUMBER := 1;
752: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;

Line 754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;

750:
751: l_api_version CONSTANT NUMBER := 1;
752: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;

Line 755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;

751: l_api_version CONSTANT NUMBER := 1;
752: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;

Line 756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

752: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
760: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;

Line 757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;

753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
760: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
761: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;

Line 758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;

754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
757: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
758: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
760: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
761: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;
762: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%TYPE;

Line 763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
760: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
761: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;
762: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%TYPE;
763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
764:
765:
766: Cursor l_get_kart_dtl_csr IS
767: SELECT sav_sae_id, scn_id , orig_article_id, display_sequence, object_Version_number,

Line 769: FROM OKC_K_ARTICLES_B

765:
766: Cursor l_get_kart_dtl_csr IS
767: SELECT sav_sae_id, scn_id , orig_article_id, display_sequence, object_Version_number,
768: ref_article_id
769: FROM OKC_K_ARTICLES_B
770: WHERE id=p_k_art_id ;
771:
772: cursor l_get_delete_var IS
773: select variable_code, object_Version_number from okc_k_art_variables

Line 936: /* update okc_k_articles_b

932: );
933:
934: */
935:
936: /* update okc_k_articles_b
937: set sav_sae_id = l_orig_article_id,
938: article_version_id = x_article_version_id
939: where id = p_k_art_id; */
940: OKC_K_ARTICLES_GRP.update_article(