DBA Data[Home] [Help]

APPS.JTF_DPF_LOGICAL_FLOWS_PKG dependencies on DUAL

Line 482: select JTF_DPF_LOGICAL_FLOWS_S.nextval into l_new_flow_id from dual;

478: if l_flow_id is null then
479: -- cons up a new flow_id, smaller than 10000
480: l_new_flow_id := null;
481: -- arsingh: prevent use of same id by different threads.
482: select JTF_DPF_LOGICAL_FLOWS_S.nextval into l_new_flow_id from dual;
483: -- select max(logical_flow_id) into l_new_flow_id from
484: -- jtf_dpf_logical_flows_b where logical_flow_id<10000;
485: -- if l_new_flow_id is null then
486: -- l_new_flow_id := 1;

Line 632: select JTF_DPF_LGCL_NXT_RULES_S.nextval into l_lnrid from dual;

628: LAST_UPDATE_LOGIN = 0
629: where logical_next_rule_id = l_lnrid;
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