APPS.JTF_DPF_LOGICAL_PAGES_PKG dependencies on DUAL

Line 390: select JTF_DPF_LOGICAL_PAGES_S.nextval into t_new_logical_id from dual;

386: close get_logical_id;
387:
388: -- get a new pseudo-sequence number
389: -- arsingh: prevent use of same id by different threads.
390: select JTF_DPF_LOGICAL_PAGES_S.nextval into t_new_logical_id from dual;
391: -- select max(logical_page_id) into t_new_logical_id
392: -- from jtf_dpf_logical_pages_b
393: -- where logical_page_id < 10000;
394: -- if t_new_logical_id is null then

Line 533: select JTF_DPF_LGCL_PHY_RULES_S.nextval into t_new_lpid from dual;

529:
530: if l_lpid is null then
531: -- get a new logical_physical_id (pseudo-sequence)
532: -- arsingh: prevent use of same id by different threads.
533: select JTF_DPF_LGCL_PHY_RULES_S.nextval into t_new_lpid from dual;
534: -- select max(logical_physical_id) into t_new_lpid
535: -- from jtf_dpf_lgcl_phy_rules where logical_physical_id < 10000;
536: -- if t_new_lpid is null then
537: -- t_new_lpid := 1;