APPS.JTF_DPF dependencies on DUAL

Line 467: select userenv('LANG') into l_lang_ret from dual;

463: phys_atts out NOCOPY physical_attribs_tbl) is
464: l_lang_use fnd_languages.language_code%type;
465: l_lang_ret fnd_languages.language_code%type;
466: begin
467: select userenv('LANG') into l_lang_ret from dual;
468: if p_lang is null then
469: l_lang_use := l_lang_ret;
470: else
471: l_lang_use := p_lang;

Line 575: select jtf_dpf_rules_s.nextval into t_ruleid from dual;

571:
572: if existential <> 0 then return 2; end if;
573:
574: -- create a new rule
575: select jtf_dpf_rules_s.nextval into t_ruleid from dual;
576:
577: JTF_DPF_RULES_PKG.INSERT_ROW(
578: X_ROWID => t_rowid,
579: X_RULE_ID => t_ruleid,

Line 799: select jtf_dpf_physical_pages_s.nextval into t_phys_id from dual;

795: -- where application_id = t_appid and
796: -- physical_page_name = p_name;
797: -- if existential > 0 then return 2; end if;
798:
799: select jtf_dpf_physical_pages_s.nextval into t_phys_id from dual;
800:
801: JTF_DPF_PHYSICAL_PAGES_PKG.insert_row(
802: X_ROWID => t_rowid,
803: X_PHYSICAL_PAGE_ID => t_phys_id,

Line 1024: select jtf_dpf_logical_flows_s.nextval into log_id from dual;

1020: logical_flow_name = p_new_name;
1021:
1022: if existential <> 0 then return 2; end if;
1023:
1024: select jtf_dpf_logical_flows_s.nextval into log_id from dual;
1025:
1026: jtf_dpf_logical_flows_pkg.INSERT_ROW(
1027: X_ROWID => t_rowid,
1028: X_LOGICAL_FLOW_ID => log_id,

Line 1125: select jtf_dpf_logical_flows_s.nextval into new_flow_id from dual;

1121: -- insert a single row into jtf_dpf_logical_flows_b and the
1122: -- same number of rows that're already in jtf_dpf_logical_flows_tl
1123: -- for the old p_flow_id.
1124:
1125: select jtf_dpf_logical_flows_s.nextval into new_flow_id from dual;
1126:
1127: p_new_flow_id := new_flow_id;
1128:
1129: insert into jtf_dpf_logical_flows_b(

Line 1413: from dual;

1409:
1410: if existential <> 0 then return 2; end if;
1411:
1412: select jtf_dpf_logical_pages_s.nextval into t_new_logical_page_id
1413: from dual;
1414:
1415: JTF_DPF_LOGICAL_PAGES_PKG.INSERT_ROW(
1416: X_ROWID => t_rowid,
1417: X_LOGICAL_PAGE_ID => t_new_logical_page_id,