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_ARTICLES_IMPORT_GRP dependencies on OKC_ARTICLES_GRP

Line 2020: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;

2016: inf_article_version_number_tbl l_inf_article_version_number ;
2017: inf_adoption_type_tbl l_inf_adoption_type;
2018:
2019: artv_article_version_id_tbl list_artv_article_version_id ;
2020: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2021: artv_action_tbl list_artv_action ;
2022: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2023:
2024: I NUMBER := 0;

Line 2022: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;

2018:
2019: artv_article_version_id_tbl list_artv_article_version_id ;
2020: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2021: artv_action_tbl list_artv_action ;
2022: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2023:
2024: I NUMBER := 0;
2025: j NUMBER := 0;
2026: k NUMBER := 0;

Line 2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

2033: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2040: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2041: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;

Line 2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

2034: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2035: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2036: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2037: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2038: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2039: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2040: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2041: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2042: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;

Line 2818: OKC_ARTICLES_GRP.parse_n_replace_text(

2814: --
2815:
2816: DBMS_LOB.TRIM(g_temp_clob_tbl(i), 0);
2817:
2818: OKC_ARTICLES_GRP.parse_n_replace_text(
2819: p_api_version => l_api_version,
2820: p_init_msg_list => l_init_msg_list,
2821: p_article_text => inf_article_text_tbl(i),
2822: p_dest_clob => g_temp_clob_tbl(i),

Line 2883: OKC_ARTICLES_GRP.GET_ARTICLE_SEQ_NUMBER

2879: -- Generate article number based on autonumbering
2880:
2881: -- When article number is not given, then we get number from autonumber API
2882: IF nvl(inf_article_number_tbl(i),'-99') = '-99' THEN
2883: OKC_ARTICLES_GRP.GET_ARTICLE_SEQ_NUMBER
2884: (p_article_number =>inf_article_number_tbl(i),
2885: p_seq_type_info_only => 'N',
2886: p_org_id => G_CURRENT_ORG_ID,
2887: x_article_number => l_article_number,

Line 2972: OKC_ARTICLES_GRP.UPDATE_ARTICLE_VARIABLES (

2968:
2969: -- Find out the variables that need to be added as these are new
2970: -- or those that need to be deleted as they are no longer used.
2971:
2972: OKC_ARTICLES_GRP.UPDATE_ARTICLE_VARIABLES (
2973: p_article_version_id => inf_article_version_id_tbl(i),
2974: p_variable_code_tbl => l_variable_code_tbl,
2975: p_do_dml => 'N', -- indicates not to do dml in the API
2976: x_variables_to_insert_tbl => l_variables_to_insert_tbl,