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_ART_VARIABLES

Line 775: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_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;
779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

Line 776: l_variable_value OKC_K_ART_VARIABLES.variable_value%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;
779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
780:

Line 777: l_x_cat_id OKC_K_ART_VARIABLES.cat_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;
779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
780:
781:

Line 778: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%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;
779: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
780:
781:
782: Cursor l_get_kart_dtl_csr IS

Line 789: select variable_code, object_Version_number from okc_k_art_variables

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
790: where variable_code not in (
791: select artvar.variable_code
792: from okc_k_art_variables artvar, okc_article_variables ar
793: where ar.variable_code = artvar.variable_code

Line 792: from okc_k_art_variables artvar, okc_article_variables ar

788: cursor l_get_delete_var IS
789: select variable_code, object_Version_number from okc_k_art_variables
790: where variable_code not in (
791: select artvar.variable_code
792: from okc_k_art_variables artvar, okc_article_variables ar
793: where ar.variable_code = artvar.variable_code
794: and artvar.cat_id = p_k_art_id
795: and ar.article_version_id = x_article_version_id)
796: and cat_id = p_k_art_id;

Line 803: from okc_k_art_variables artvar, okc_article_variables ar

799: select var.variable_code, bus.variable_type,bus.external_yn,bus.value_set_id
800: from okc_article_variables var, okc_bus_variables_b bus
801: where var.variable_code not in (
802: select artvar.variable_code
803: from okc_k_art_variables artvar, okc_article_variables ar
804: where ar.variable_code = artvar.variable_code
805: and artvar.cat_id = p_k_art_id
806: and ar.article_version_id = x_article_version_id
807: )

Line 996: OKC_K_ART_VARIABLES_PVT.Delete_Row(

992: Delete those variables that are not in the Standard Article Version
993: to which we are reverting to
994: */
995: for del_var_csr in l_get_delete_var loop
996: OKC_K_ART_VARIABLES_PVT.Delete_Row(
997: x_return_status => x_return_status,
998: p_cat_id => p_k_art_id,
999: p_variable_code => del_var_csr.variable_code,
1000: p_object_version_number => del_var_csr.object_version_number);

Line 1018: OKC_K_ART_VARIABLES_PVT.insert_row(

1014: */
1015:
1016:
1017: for ins_var_csr in l_get_insert_var loop
1018: OKC_K_ART_VARIABLES_PVT.insert_row(
1019: x_return_status => x_return_status,
1020: p_cat_id => p_k_art_id,
1021: p_variable_code => ins_var_csr.variable_code,
1022: p_variable_type => ins_var_csr.variable_type,