APPS.MSC_PHUB_PKG dependencies on MSC_PHUB_CUSTOM_PKG

Line 131: when p_package='msc_phub_custom_pkg' then return true;

127: when p_package='msc_supplier_pkg' then return p_plan_type not in (-1,5);
128: when p_package='msc_phub_budget_pkg' then return p_plan_type in (4);
129: when p_package='msc_item_pkg' then return true;
130: when p_package='msc_phub_excess_pkg' then return p_plan_type not in (-1,5);
131: when p_package='msc_phub_custom_pkg' then return true;
132: else return false;
133: end case;
134: end has_etl;
135:

Line 239: l_custom_req_id := submit_each('msc_phub_custom_pkg', p_plan_id, p_plan_run_id, p_plan_type);

235: msc_wait_for_request(l_budgets_req_id);
236: msc_wait_for_request(l_costs_req_id);
237: msc_wait_for_request(l_excesss_req_id);
238:
239: l_custom_req_id := submit_each('msc_phub_custom_pkg', p_plan_id, p_plan_run_id, p_plan_type);
240: --msc_wait_for_request(l_custom_req_id);
241: return sys_yes;
242:
243: exception

Line 876: msc_phub_custom_pkg.purge_details(p_plan_name, p_plan_run_id);

872: partition_drop, partition_list);
873: end if;
874: end if;
875:
876: msc_phub_custom_pkg.purge_details(p_plan_name, p_plan_run_id);
877: msc_phub_util.log('msc_phub_pkg.purge_details: complete');
878: end purge_details;
879:
880: procedure refresh_mvs(p_refresh_mode varchar2)