APPS.JTF_DPF_LOGICAL_PAGES_PKG dependencies on JTF_DPF_LGCL_PHY_RULES

Line 342: from jtf_dpf_lgcl_phy_rules

338: -- default l2p row in lgcl_phy table
339: if not l_do_it then
340: begin
341: select last_updated_by into l_owner_of_l2p
342: from jtf_dpf_lgcl_phy_rules
343: where logical_page_id = l_logical_page_id and
344: default_page_flag = 'T';
345: if l_owner_of_l2p = l_user then l_do_it := true; end if;
346: exception when no_data_found then return;

Line 353: delete from jtf_dpf_lgcl_phy_rules

349:
350: -- if we've decided to do it,...
351: if l_do_it then
352: -- delete the rows, if any...
353: delete from jtf_dpf_lgcl_phy_rules
354: where logical_page_id = l_logical_page_id and
355: default_page_flag = 'F' and
356: rule_eval_sequence > x_num_non_def_rules;
357: end if;

Line 474: from jtf_dpf_lgcl_phy_rules

470: l_owner_of_l2p number;
471: l_do_it boolean := false;
472: cursor another_default(p_logical_page_id number) is
473: select logical_physical_id
474: from jtf_dpf_lgcl_phy_rules
475: where logical_page_id=p_logical_page_id and
476: default_page_flag='T';
477: cursor another_non_default(p_logical_page_id number, p_seq number) is
478: select logical_physical_id

Line 479: from jtf_dpf_lgcl_phy_rules

475: where logical_page_id=p_logical_page_id and
476: default_page_flag='T';
477: cursor another_non_default(p_logical_page_id number, p_seq number) is
478: select logical_physical_id
479: from jtf_dpf_lgcl_phy_rules
480: where logical_page_id=p_logical_page_id and
481: default_page_flag='F' and
482: rule_eval_sequence = p_seq;
483: begin

Line 501: from jtf_dpf_lgcl_phy_rules

497: -- default l2p row in lgcl_phy table
498: if not l_do_it then
499: begin
500: select last_updated_by into l_owner_of_l2p
501: from jtf_dpf_lgcl_phy_rules
502: where logical_page_id = l_logical_id and
503: default_page_flag = 'T';
504: if l_owner_of_l2p = l_user_id then l_do_it := true; end if;
505: exception when no_data_found then l_do_it := true;

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 535: -- from jtf_dpf_lgcl_phy_rules where logical_physical_id < 10000;

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;
538: -- else
539: -- t_new_lpid := t_new_lpid + 1;

Line 543: insert into jtf_dpf_lgcl_phy_rules(

539: -- t_new_lpid := t_new_lpid + 1;
540: -- end if;
541: -- insert a new row
542:
543: insert into jtf_dpf_lgcl_phy_rules(
544: logical_physical_id,
545: logical_page_id,
546: rule_eval_sequence,
547: default_page_flag,

Line 573: from jtf_dpf_lgcl_phy_rules

569: else
570: -- if there is such as row, and we either own it, or FORCE_UPDATE_FLAG
571: -- is true, then update it. else do nothing
572: select last_updated_by into l_last_updated_by
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

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,