APPS.MSC_PHUB_UTIL dependencies on DUAL

Line 361: select systimestamp into t from dual;

357: if (g_log_level < p_level) then
358: return;
359: end if;
360:
361: select systimestamp into t from dual;
362: --dbms_output.put_line(to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message); --xxx
363: fnd_file.put_line(fnd_file.log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
364:
365: if (g_log_file is not null) then

Line 894: select msc_hub_query_s.nextval into l_qid from dual;

890: function get_resource_rn_qid(p_plan_id number, p_plan_run_id number) return number
891: is
892: l_qid number;
893: begin
894: select msc_hub_query_s.nextval into l_qid from dual;
895: insert into msc_hub_query (
896: query_id,
897: last_update_date,
898: last_updated_by,

Line 948: select msc_hub_query_s.nextval into l_qid from dual;

944: function get_item_rn_qid(p_plan_id number, p_plan_run_id number) return number
945: is
946: l_qid number;
947: begin
948: select msc_hub_query_s.nextval into l_qid from dual;
949: insert into msc_hub_query (
950: query_id,
951: last_update_date,
952: last_updated_by,

Line 1016: select msc_hub_query_s.nextval into l_qid_last_date from dual;

1012: function get_reporting_dates(p_plan_start_date date, p_plan_cutoff_date date) return number
1013: is
1014: l_qid_last_date number;
1015: begin
1016: select msc_hub_query_s.nextval into l_qid_last_date from dual;
1017: insert into msc_hub_query (
1018: query_id, date1, date2,
1019: created_by, creation_date,
1020: last_update_date, last_updated_by, last_update_login)