[Home] [Help]
2929: AND av.article_version_id = rev.article_version_id
2930: AND ((kart_var.variable_type='U' and kart_var.variable_value is null
2931: and (kart_var.variable_value is null
2932: and (rev_var.variable_value is not null and rev_var.variable_value <> '_________' )
2933: and exists(select 'x' from okc_bus_variables_tl bustl where bustl.variable_code = rev_var.variable_code)) OR
2934: (kart_var.variable_value is not null and rev_var.variable_value <> kart_var.variable_value))
2935: OR (kart_var.variable_type<>'U' and exists
2936: (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
2937: and var_doc.doc_Type = p_document_type))
2941: and nvl(av.insert_by_reference,'N') <> 'Y';
2942:
2943: cursor variables_removed is
2944: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
2945: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
2946: where rev.object_id = kart_var.cat_id
2947: and rev.document_type = p_document_type and rev.document_id = p_document_id
2948: and rev.article_version_id = av.article_version_id
2949: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var