846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
856: l_api_version CONSTANT NUMBER := 1.0;