APPS.JTF_DPF dependencies on JTF_DPF_RULE_PARAMS

Line 247: from jtf_dpf_rules_b r, jtf_dpf_rule_params rp

243: -- r.rule_description,
244: rp.rule_param_name,
245: rp.rule_param_value,
246: rp.rule_param_condition
247: from jtf_dpf_rules_b r, jtf_dpf_rule_params rp
248: where
249: r.rule_id = rp.rule_id and
250: r.application_id =
251: (select application_id from fnd_application fa

Line 499: delete from jtf_dpf_rule_params where rule_id = p_rule_id;

495: -- removes the rule and any rule_params that were stored under it. Has
496: -- no effect if the rule doesn't exist
497: procedure rule_delete(p_rule_id number) is
498: begin
499: delete from jtf_dpf_rule_params where rule_id = p_rule_id;
500: delete from jtf_dpf_rules_b where rule_id=p_rule_id;
501: delete from jtf_dpf_rules_tl where rule_id=p_rule_id;
502: -- commit;
503: end;

Line 647: delete from jtf_dpf_rule_params where rule_id = p_rule_id;

643: procedure rule_set_params(p_rule_id number,
644: rules new_rule_param_tbl) is
645: idx binary_integer;
646: begin
647: delete from jtf_dpf_rule_params where rule_id = p_rule_id;
648: idx := rules.first;
649: while true loop
650: insert into jtf_dpf_rule_params(
651: rule_param_sequence,

Line 650: insert into jtf_dpf_rule_params(

646: begin
647: delete from jtf_dpf_rule_params where rule_id = p_rule_id;
648: idx := rules.first;
649: while true loop
650: insert into jtf_dpf_rule_params(
651: rule_param_sequence,
652: rule_id,
653: rule_param_condition,
654: rule_param_name,