[Home] [Help]
46: /* update the build refresh num if the plans are deleted. */
47:
48: if (nvl(retcode, '0') <> '2') then
49:
50: update msd_demand_plans
51: set dp_build_refresh_num = null,
52: dp_build_error_flag = null
53: where demand_plan_id = PlanID;
54:
62: --
63: -- 1.Checks the state for the plan to be deleted.
64: -- 2.If plan doesn't have Active process
65: -- delets all DPE databases and all obsolete workfdlow data for current plan.
66: -- 3.Removes validation status for this plan (DPE_BUILD field in MSD_DEMAND_PLANS table).
67: -- 4.Populates log file with the process's messages.
68: --
69: -- IN
70: -- number of msd_demand_plans_v columns - PlanID ,
66: -- 3.Removes validation status for this plan (DPE_BUILD field in MSD_DEMAND_PLANS table).
67: -- 4.Populates log file with the process's messages.
68: --
69: -- IN
70: -- number of msd_demand_plans_v columns - PlanID ,
71: -- Shared_DB_Prefix ,
72: -- Code_Location,
73: -- Shared_DB_Location,
74: -- Express_Machine_Port,
483:
484: --
485: -- DeleteBuildDBS (PUBLIC)
486: --
487: -- 1. Selects data from MSD_DEMAND_PLANS_V table for the specific planID.
488: -- 2. Takes selected columns and uses that data to exercise an EPS/SNAPI
489: -- connection to OES and then, if connection is established,
490: -- runs ODPDELPLAN activity to run delete plan functionality.
491:
489: -- connection to OES and then, if connection is established,
490: -- runs ODPDELPLAN activity to run delete plan functionality.
491:
492: -- IN
493: -- number of msd_demand_plans_v columns - PlanID ,
494: -- Demand_Plan_Name,
495: -- Shared_DB_Prefix ,
496: -- Code_Location,
497: -- Shared_DB_Location,