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_K_ARTICLES_B

Line 81: l_amendment_description okc_k_articles_b.amendment_description%TYPE;

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

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

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

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

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

Line 451: FROM OKC_K_ARTICLES_B

447: article_version_id,
448: ref_article_version_id,
449: change_nonstd_yn,
450: object_version_number
451: FROM OKC_K_ARTICLES_B
452: WHERE id=p_cat_id;
453:
454: l_display_name okc_article_versions.display_name%TYPE;
455: l_article_description okc_article_versions.article_description%TYPE;

Line 769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;

765: ) IS
766:
767: l_api_version CONSTANT NUMBER := 1;
768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;

Line 770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;

766:
767: l_api_version CONSTANT NUMBER := 1;
768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;

Line 771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;

767: l_api_version CONSTANT NUMBER := 1;
768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;

Line 772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
776: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;

Line 773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;

769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
776: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
777: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;

Line 774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;

770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
773: l_display_sequence OKC_K_ARTICLES_B.display_sequence%TYPE;
774: l_ovn OKC_K_ARTICLES_B.object_version_number%TYPE;
775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
776: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
777: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;
778: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%TYPE;

Line 779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_id%TYPE;
776: l_variable_value OKC_K_ART_VARIABLES.variable_value%TYPE;
777: l_x_cat_id OKC_K_ART_VARIABLES.cat_id%TYPE;
778: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%TYPE;
779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
780:
781:
782: Cursor l_get_kart_dtl_csr IS
783: SELECT sav_sae_id, scn_id , orig_article_id, display_sequence, object_Version_number,

Line 785: FROM OKC_K_ARTICLES_B

781:
782: Cursor l_get_kart_dtl_csr IS
783: SELECT sav_sae_id, scn_id , orig_article_id, display_sequence, object_Version_number,
784: ref_article_id
785: FROM OKC_K_ARTICLES_B
786: WHERE id=p_k_art_id ;
787:
788: cursor l_get_delete_var IS
789: select variable_code, object_Version_number from okc_k_art_variables

Line 952: /* update okc_k_articles_b

948: );
949:
950: */
951:
952: /* update okc_k_articles_b
953: set sav_sae_id = l_orig_article_id,
954: article_version_id = x_article_version_id
955: where id = p_k_art_id; */
956: OKC_K_ARTICLES_GRP.update_article(