14: --
15: function get_rule_set_name (p_rule_set_id in number) return varchar2 is
16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
17: cursor c1 is select rule_set_name
18: from pqh_rule_sets_vl
19: where rule_set_id = p_rule_set_id;
20: begin
21: open c1;
22: fetch c1 into l_rule_set_name;
126: l_dummy varchar2(1);
127: --
128: Cursor csr_rst_name is
129: select null
130: from pqh_rule_sets_vl
131: where rule_set_name = p_rule_set_name;
132: --
133: l_proc varchar2(72) := g_package||'chk_rule_set_name';
134: --
199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is
202: select seeded_rule_flag,rule_set_name,rule_category
203: from pqh_rule_sets_vl
204: where rule_set_id = p_referenced_rule_set_id;
205: --
206: Begin
207: --