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 759: l_variable_value_id OKC_K_ART_VARIABLES.variable_value_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;
763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;

Line 760: l_variable_value OKC_K_ART_VARIABLES.variable_value%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;
763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
764:

Line 761: l_x_cat_id OKC_K_ART_VARIABLES.cat_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;
763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
764:
765:

Line 762: l_x_variable_code OKC_K_ART_VARIABLES.variable_code%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;
763: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
764:
765:
766: Cursor l_get_kart_dtl_csr IS

Line 773: select variable_code, object_Version_number from okc_k_art_variables

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
774: where variable_code not in (
775: select artvar.variable_code
776: from okc_k_art_variables artvar, okc_article_variables ar
777: where ar.variable_code = artvar.variable_code

Line 776: from okc_k_art_variables artvar, okc_article_variables ar

772: cursor l_get_delete_var IS
773: select variable_code, object_Version_number from okc_k_art_variables
774: where variable_code not in (
775: select artvar.variable_code
776: from okc_k_art_variables artvar, okc_article_variables ar
777: where ar.variable_code = artvar.variable_code
778: and artvar.cat_id = p_k_art_id
779: and ar.article_version_id = x_article_version_id)
780: and cat_id = p_k_art_id;

Line 787: from okc_k_art_variables artvar, okc_article_variables ar

783: select var.variable_code, bus.variable_type,bus.external_yn,bus.value_set_id
784: from okc_article_variables var, okc_bus_variables_b bus
785: where var.variable_code not in (
786: select artvar.variable_code
787: from okc_k_art_variables artvar, okc_article_variables ar
788: where ar.variable_code = artvar.variable_code
789: and artvar.cat_id = p_k_art_id
790: and ar.article_version_id = x_article_version_id
791: )

Line 979: OKC_K_ART_VARIABLES_PVT.Delete_Row(

975: Delete those variables that are not in the Standard Article Version
976: to which we are reverting to
977: */
978: for del_var_csr in l_get_delete_var loop
979: OKC_K_ART_VARIABLES_PVT.Delete_Row(
980: x_return_status => x_return_status,
981: p_cat_id => p_k_art_id,
982: p_variable_code => del_var_csr.variable_code,
983: p_object_version_number => del_var_csr.object_version_number);

Line 1001: OKC_K_ART_VARIABLES_PVT.insert_row(

997: */
998:
999:
1000: for ins_var_csr in l_get_insert_var loop
1001: OKC_K_ART_VARIABLES_PVT.insert_row(
1002: x_return_status => x_return_status,
1003: p_cat_id => p_k_art_id,
1004: p_variable_code => ins_var_csr.variable_code,
1005: p_variable_type => ins_var_csr.variable_type,