[Home] [Help]
370: -- create the code of the procedure get_winning rule
371: PROCEDURE populate_matches (
372: spec_code IN OUT NOCOPY cn_utils.code_type,
373: body_code IN OUT NOCOPY cn_utils.code_type ,
374: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE) IS
375: --
376: procedure_name cn_obj_procedures_v.name%TYPE;
377: procedure_desc cn_obj_procedures_v.description%TYPE;
378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
396: SELECT ra.sca_rule_attribute_id,
397: ra.src_column_name,
398: ra.datatype
399: FROM cn_sca_combinations sc,
400: cn_sca_rule_attributes ra
401: WHERE sc.sca_rule_attribute_id = ra.sca_rule_attribute_id
402: AND sc.org_id = ra.org_id --vensrini
403: AND sc.org_id = g_org_id -- vensrini
404: AND rule_attr_comb_value = l_comb_value
683: RAISE;
684: END populate_matches;
685:
686: FUNCTION create_sca_rules_batch_dyn (
687: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
688: RETURN BOOLEAN IS
689: -- Variables Section
690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
746: p_org_id IN NUMBER,
747: x_return_status OUT NOCOPY VARCHAR2,
748: x_msg_count OUT NOCOPY NUMBER,
749: x_msg_data OUT NOCOPY VARCHAR2,
750: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)IS
751:
752: l_api_name CONSTANT VARCHAR2(30) := 'gen_sca_rules_batch_dyn';
753: l_api_version CONSTANT NUMBER :=1.0;
754: