APPS.OKC_CLM_PKG dependencies on OKC_ART_VAR_SECTIONS

Line 828: (SELECT avs.variable_value_id FROM okc_art_var_sections avs

824: SELECT kvar.variable_value_id FROM okc_k_art_variables kvar,okc_k_articles_b kart
825: WHERE kart.id = kvar.cat_id
826: AND kart.document_id = p_doc_id
827: AND kvar.variable_value_id IN
828: (SELECT avs.variable_value_id FROM okc_art_var_sections avs
829: WHERE avs.article_id = p_article_id
830: AND avs.article_version_id = p_article_version_id
831: )
832: AND kvar.variable_value_id IS NOT NULL;

Line 841: FROM okc_art_var_sections

837:
838:
839: CURSOR art_var_dtls_csr(p_article_id NUMBER,p_article_version_id NUMBER) IS
840: SELECT variable_value_id,variable_value,variable_code
841: FROM okc_art_var_sections
842: WHERE article_id = p_article_id
843: AND article_version_id = p_article_version_id;
844:
845: CURSOR get_varcode_from_art(p_article_id NUMBER) IS

Line 852: SELECT avs.scn_CODE FROM okc_art_var_sections avs

848: WHERE article_version_id = p_article_version_id;
849:
850:
851: CURSOR def_scn_code_csr(p_variable_value VARCHAR2,p_article_id NUMBER,p_article_version_id NUMBER) IS
852: SELECT avs.scn_CODE FROM okc_art_var_sections avs
853: WHERE avs.variable_value = p_variable_value
854: AND avs.article_id = p_article_id
855: AND avs.article_version_id = p_article_version_id;
856:

Line 868: FROM okc_art_var_sections

864: AND ROWNUM=1;
865:
866: CURSOR var_value_csr(p_var_value_id NUMBER,p_article_id NUMBER,p_article_version_id NUMBER) IS
867: SELECT variable_value
868: FROM okc_art_var_sections
869: WHERE variable_value_id = p_var_value_id
870: AND article_id = p_article_id
871: AND article_version_id = p_article_version_id;
872:

Line 995: --for results table, get default_scn_code from okc_art_var_sections

991: p_only_doc_variables => FND_API.G_FALSE,
992: x_sys_var_value_tbl => l_sys_var_value_tbl);
993:
994:
995: --for results table, get default_scn_code from okc_art_var_sections
996: FOR i IN l_sys_var_value_tbl.FIRST..l_sys_var_value_tbl.LAST LOOP
997: IF (l_sys_var_value_tbl(i).variable_code = l_var_code) THEN
998: OPEN def_scn_code_csr(l_sys_var_value_tbl(i).variable_value_id,p_article_id,p_article_version_id);
999: FETCH def_scn_code_csr INTO l_def_scn_code;

Line 1019: --for results table, get default_scn_code from okc_art_var_sections

1015: x_msg_data => l_msg_data,
1016: x_msg_count => l_msg_count,
1017: x_udf_var_value_tbl => l_udf_var_value_tbl
1018: );
1019: --for results table, get default_scn_code from okc_art_var_sections
1020: FOR i IN l_udf_var_value_tbl.FIRST..l_udf_var_value_tbl.LAST LOOP
1021: IF (l_udf_var_value_tbl(i).variable_code = l_var_code) THEN
1022: OPEN var_value_csr(l_udf_var_value_tbl(i).variable_value_id,p_article_id,p_article_version_id);
1023: FETCH var_value_csr INTO l_var_value;