DBA Data[Home] [Help]

APPS.OKC_ARTICLES_IMPORT_GRP dependencies on OKC_ARTICLES_GRP

Line 2033: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;

2029: --clm
2030: -- inf_variable_code_tbl l_inf_variable_code;
2031:
2032: artv_article_version_id_tbl list_artv_article_version_id ;
2033: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2034: artv_action_tbl list_artv_action ;
2035: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2036:
2037: I NUMBER := 0;

Line 2035: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;

2031:
2032: artv_article_version_id_tbl list_artv_article_version_id ;
2033: artv_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2034: artv_action_tbl list_artv_action ;
2035: l_variable_code_tbl OKC_ARTICLES_GRP.variable_code_tbl_type ;
2036:
2037: I NUMBER := 0;
2038: j NUMBER := 0;
2039: k NUMBER := 0;

Line 2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

2047: l_earlier_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;

Line 2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;

2048: l_earlier_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2049: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
2050: l_article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE;
2051: l_variables_to_insert_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2052: l_variables_to_delete_tbl OKC_ARTICLES_GRP.variable_code_tbl_type;
2053: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
2054: l_program_id OKC_ART_INTERFACE_ALL.PROGRAM_ID%TYPE;
2055: l_program_login_id OKC_ART_INTERFACE_ALL.PROGRAM_LOGIN_ID%TYPE;
2056: l_program_appl_id OKC_ART_INTERFACE_ALL.PROGRAM_APPLICATION_ID%TYPE;

Line 2869: OKC_ARTICLES_GRP.parse_n_replace_text(

2865: --
2866:
2867: DBMS_LOB.TRIM(g_temp_clob_tbl(i), 0);
2868:
2869: OKC_ARTICLES_GRP.parse_n_replace_text(
2870: p_api_version => l_api_version,
2871: p_init_msg_list => l_init_msg_list,
2872: p_article_text => inf_article_text_tbl(i),
2873: p_dest_clob => g_temp_clob_tbl(i),

Line 2934: OKC_ARTICLES_GRP.GET_ARTICLE_SEQ_NUMBER

2930: -- Generate article number based on autonumbering
2931:
2932: -- When article number is not given, then we get number from autonumber API
2933: IF nvl(inf_article_number_tbl(i),'-99') = '-99' THEN
2934: OKC_ARTICLES_GRP.GET_ARTICLE_SEQ_NUMBER
2935: (p_article_number =>inf_article_number_tbl(i),
2936: p_seq_type_info_only => 'N',
2937: p_org_id => G_CURRENT_ORG_ID,
2938: x_article_number => l_article_number,

Line 3023: OKC_ARTICLES_GRP.UPDATE_ARTICLE_VARIABLES (

3019:
3020: -- Find out the variables that need to be added as these are new
3021: -- or those that need to be deleted as they are no longer used.
3022:
3023: OKC_ARTICLES_GRP.UPDATE_ARTICLE_VARIABLES (
3024: p_article_version_id => inf_article_version_id_tbl(i),
3025: p_variable_code_tbl => l_variable_code_tbl,
3026: p_do_dml => 'N', -- indicates not to do dml in the API
3027: x_variables_to_insert_tbl => l_variables_to_insert_tbl,