DBA Data[Home] [Help]

APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSC_UTIL

Line 2402: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN

2398: END IF;
2399:
2400: -- if PurgeAllFlag is set, purge all rows in msd_dp_scn_entries_denorm
2401: -- and msd_dp_scenario_output_levels for l_ScenarioId, if it is there.
2402: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2403: IF l_IsNewScenario THEN
2404: CreateNewScenario(l_ScenarioId, ScenarioName);
2405: ELSE
2406: PurgeAllFcstData(l_ScenarioId);

Line 2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN

2783: RETURN;
2784: END IF;
2785:
2786: -- if PurgeAllFlag is set, purge all rows in msc_safety_stocks table for l_PlanId.
2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2788: BEGIN
2789: DELETE FROM msc_safety_stocks
2790: WHERE
2791: plan_id = l_PlanId;