136: ,p_level => C_LEVEL_PROCEDURE
137: ,p_module => l_log_module);
138:
139: trace
140: (p_msg => ' SQL - Select from xla_product_rules_b'
141: ,p_level => C_LEVEL_PROCEDURE
142: ,p_module => l_log_module);
143:
144: END IF;
144: END IF;
145: --
146: SELECT compile_status_code
147: INTO l_status
148: FROM xla_product_rules_b
149: WHERE application_id = p_application_id
150: AND product_rule_code = p_product_rule_code
151: AND product_rule_type_code = p_product_rule_type_code
152: AND nvl(amb_context_code,'@') = nvl(p_amb_context_code,'@')
220: ,p_module => l_log_module);
221:
222: END IF;
223: --
224: UPDATE xla_product_rules_b
225: SET compile_status_code = p_status_new
226: WHERE compile_status_code = NVL(p_status_old, compile_status_code)
227: AND application_id = p_application_id
228: AND product_rule_code = p_product_rule_code