APPS.JTF_DPF_LOGICAL_FLOWS_PKG dependencies on JTF_DPF_LGCL_NEXT_RULES

Line 566: from jtf_dpf_lgcl_next_rules

562: l_lnrid number;
563: l_last_updated_by number;
564: cursor another_default(x_flow_id number, x_logical_id number) is
565: select logical_next_rule_id
566: from jtf_dpf_lgcl_next_rules
567: where logical_flow_id = x_flow_id and
568: logical_page_id = x_logical_id and
569: default_next_flag='T';
570: cursor another_non_default(x_flow_id number, x_logical_id number,

Line 573: from jtf_dpf_lgcl_next_rules

569: default_next_flag='T';
570: cursor another_non_default(x_flow_id number, x_logical_id number,
571: x_seq number) is
572: select logical_next_rule_id
573: from jtf_dpf_lgcl_next_rules
574: where logical_flow_id = x_flow_id and
575: logical_page_id = x_logical_id and
576: default_next_flag='F' and
577: rule_eval_seq = x_seq;

Line 604: -- JTF_DPF_LGCL_NEXT_RULES.

600:
601: -- try to find a row which matches this one (to see whether we should
602: -- do an UPDATE rather than an INSERT). If there's such a row, then
603: -- l_lnrid will be the LOGICAL_NEXT_RULE_ID from table
604: -- JTF_DPF_LGCL_NEXT_RULES.
605: if 'T' = x_default_next_flag then
606: -- if there's already a default...
607: open another_default(l_flow_id, l_logical_id);
608: fetch another_default into l_lnrid;

Line 618: update jtf_dpf_lgcl_next_rules set

614: close another_non_default;
615: end if;
616:
617: if l_lnrid is not null then
618: update jtf_dpf_lgcl_next_rules set
619: LOGICAL_PAGE_ID = l_logical_id,
620: LOGICAL_NEXT_PAGE_ID = l_next_logical_id,
621: DEFAULT_NEXT_FLAG = x_default_next_flag,
622: RULE_EVAL_SEQ = x_rule_eval_seq,

Line 634: -- from jtf_dpf_lgcl_next_rules where

630: else
631: -- arsingh: prevent use of same id by different threads.
632: select JTF_DPF_LGCL_NXT_RULES_S.nextval into l_lnrid from dual;
633: -- select max(logical_next_rule_id) into l_lnrid
634: -- from jtf_dpf_lgcl_next_rules where
635: -- logical_next_rule_id < 10000;
636: -- if l_lnrid is null then
637: -- l_lnrid := 1;
638: -- else

Line 642: insert into jtf_dpf_lgcl_next_rules (

638: -- else
639: -- l_lnrid := l_lnrid + 1;
640: -- end if;
641:
642: insert into jtf_dpf_lgcl_next_rules (
643: LOGICAL_NEXT_RULE_ID,
644: LOGICAL_PAGE_ID,
645: LOGICAL_NEXT_PAGE_ID,
646: DEFAULT_NEXT_FLAG,