DBA Data[Home] [Help]

APPS.JTF_DPF_LOGICAL_PAGES_PKG dependencies on JTF_DPF_LGCL_PHY_RULES_S

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;

Line 577: update jtf_dpf_lgcl_phy_rules set

573: from jtf_dpf_lgcl_phy_rules
574: where logical_physical_id = l_lpid;
575: if l_last_updated_by = l_user_id or
576: x_force_update_flag = 'TRUE' then
577: update jtf_dpf_lgcl_phy_rules set
578: physical_page_id = l_physical_id,
579: rule_id = l_rule_id,
580: object_version_number = object_version_number +1,
581: last_update_date = sysdate,