DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on MSC_HUB_QUERY_S

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)