APPS.OKC_MRV_UTIL dependencies on OKC_K_ART_VARIABLES

Line 172: UPDATE okc_k_art_variables

168:
169: IF p_type = 'XML'
170: THEN
171: --
172: UPDATE okc_k_art_variables
173: SET mr_variable_xml = l_clob
174: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
175: ELSIF p_type = 'HTML'
176: THEN

Line 177: UPDATE okc_k_art_variables

173: SET mr_variable_xml = l_clob
174: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
175: ELSIF p_type = 'HTML'
176: THEN
177: UPDATE okc_k_art_variables
178: SET mr_variable_html = l_clob
179: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
180: END IF;
181: EXCEPTION

Line 199: FROM okc_k_art_variables

195: IF p_type = 'HTML'
196: THEN
197: SELECT mr_variable_html
198: INTO l_clob
199: FROM okc_k_art_variables
200: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
201:
202: RETURN (okc_word_download_upload.clob_to_blob (l_clob));
203: ELSIF p_type = 'XML'

Line 207: FROM okc_k_art_variables

203: ELSIF p_type = 'XML'
204: THEN
205: SELECT mr_variable_xml
206: INTO l_clob
207: FROM okc_k_art_variables
208: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
209:
210: RETURN (okc_word_download_upload.clob_to_blob (l_clob));
211: END IF;

Line 377: UPDATE okc_k_art_variables

373: END IF; -- mode = AMEND
374:
375:
376:
377: UPDATE okc_k_art_variables
378: SET mr_variable_xml =
379: get_uda_attr_xml (p_cat_id, p_variable_code, p_attr_group_id)
380: WHERE cat_id = p_cat_id AND variable_code = p_variable_code;
381:

Line 438: FROM okc_k_art_variables kvar, okc_bus_variables_b var

434: WHERE document_type = doctype
435: AND document_id = docid
436: AND EXISTS (
437: SELECT 'Y'
438: FROM okc_k_art_variables kvar, okc_bus_variables_b var
439: WHERE 1 = 1
440: AND kvar.cat_id = kart.ID
441: AND kvar.variable_code = var.variable_code
442: AND var.mrv_flag = 'Y')

Line 473: okc_k_art_variables akv

469: COLUMNS "varName" VARCHAR2(30) PATH '//var/@name',
470: "vartype" VARCHAR2(1) PATH '//var/@type',
471: "varMeaning" VARCHAR2(30) PATH '//var/@meaning'
472: ) t2,
473: okc_k_art_variables akv
474: WHERE 1=1
475: AND av.article_version_id = t1."artVersionId"
476: AND akv.variable_code = t2."varName"
477: AND akv.cat_id = t1."catId"

Line 617: WHERE obj_name = 'OKC_K_ART_VARIABLES';

613: BEGIN
614: SELECT object_id
615: INTO l_object_id
616: FROM fnd_objects
617: WHERE obj_name = 'OKC_K_ART_VARIABLES';
618:
619: SELECT data_level_id
620: INTO l_main_data_level_id
621: FROM ego_data_level_b

Line 640: p_object_name => 'OKC_K_ART_VARIABLES',

636: ego_user_attrs_data_pvt.copy_user_attrs_data
637: (p_api_version => 1.0,
638: p_application_id => 510,
639: p_object_id => l_object_id,
640: p_object_name => 'OKC_K_ART_VARIABLES',
641: p_old_pk_col_value_pairs => from_pk_col_value_pairs,
642: p_old_data_level_id => l_main_data_level_id,
643: p_old_dtlevel_col_value_pairs => l_dtlevel_col_value_pairs,
644: p_new_pk_col_value_pairs => to_pk_col_value_pairs,

Line 667: UPDATE okc_k_art_variables

663: )
664: IS
665:
666: BEGIN
667: UPDATE okc_k_art_variables
668: SET mr_variable_xml =
669: get_uda_attr_xml (p_cat_id, p_variable_code, p_attr_group_id)
670: WHERE cat_id = p_cat_id AND variable_code = p_variable_code;
671: EXCEPTION