1 PACKAGE MSC_WS_DRP AS
2 /* $Header: MSCWDRPS.pls 120.4 2008/03/20 15:56:23 bnaghi noship $ */
3
4
5 -- =============================================================
6 -- Desc: This procedure is invoke from web services to launch
7 -- DRP plan. It mirrors all the parameters from the Launch
8 -- Plan concurrent program. Some of the child programs
9 -- that gets launched include Memory-Based Snapshot,
10 -- Snapshot Monitor, Snapshot Delete Worker,
11 -- Memory-Based Snapshot Worker, Loader Worker With Direct Load Option,
12 -- Memory-Based Planner, Post Plan Program for UI,
13 -- Refresh One KPI Summary Table The procedure returns
14 -- a status and concurrent program request id.
15 -- Input: enable24x7Atp, can conditionally be
16 -- YES_PURGE - Yes , purge current plan after switch plan
17 -- NO - No
18 -- YES_NOPURGE - Yes , do not purge current plan after switch plan
19 -- launchPlanner, launchSnapshot, releaseReschedules
20 -- can be conditionally be Y or N
21 -- Output: possible output status value include following
22 -- INVALID_PLANID, INVALID_ANCHORDATE, INVALID_LAUNCH_PLANNER,
23 -- INVALID_ENABLE24X7ATP, INVALID_RELEASE_RESCHEDULES,
24 -- INVALID_FND_USERID, INVALID_FND_RESP
25 -- =============================================================
26 PROCEDURE LAUNCH_DRP_BATCH (
27 processId OUT NOCOPY NUMBER,
28 status OUT NOCOPY VARCHAR2,
29 userId IN NUMBER,
30 responsibilityId IN NUMBER,
31 planId IN NUMBER,
32 launchSnapshot IN VARCHAR2,
33 launchPlanner IN VARCHAR2,
34 anchorDate IN DATE,
35 archiveCurrVersPlan IN VARCHAR2,
36 enable24x7Atp IN VARCHAR2 ,
37 releaseReschedules IN VARCHAR2 );
38
39 -- =============================================================
40 -- Desc: This procedure is invoke from web services to launch
41 -- DRP plan. It mirrors all the parameters from the Launch
42 -- Plan concurrent program. Some of the child programs
43 -- that gets launched include Memory-Based Snapshot,
44 -- Snapshot Monitor, Snapshot Delete Worker,
45 -- Memory-Based Snapshot Worker, Loader Worker With Direct Load Option,
46 -- Memory-Based Planner, Post Plan Program for UI,
47 -- Refresh One KPI Summary Table The procedure returns
48 -- a status and concurrent program request id.
49 -- Input: enable24x7Atp, can conditionally be
50 -- YES_PURGE - Yes , purge current plan after switch plan
51 -- NO - No
52 -- YES_NOPURGE - Yes , do not purge current plan after switch plan
53 -- launchPlanner, launchSnapshot, releaseReschedules
54 -- can be conditionally be Y or N
55 -- Output: possible output status value include following
56 -- INVALID_PLANID, INVALID_ANCHORDATE, INVALID_LAUNCH_PLANNER,
57 -- INVALID_ENABLE24X7ATP, INVALID_RELEASE_RESCHEDULES,
58 -- INVALID_USER_NAME, INVALID_RESP_NAME
59 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
60 -- =============================================================
61 PROCEDURE LAUNCH_DRP_BATCH_PUBLIC (
62 processId OUT NOCOPY NUMBER,
63 status OUT NOCOPY VARCHAR2,
64 UserName IN VARCHAR2,
65 RespName IN VARCHAR2,
66 RespApplName IN VARCHAR2,
67 SecurityGroupName IN VARCHAR2,
68 Language IN VARCHAR2,
69 planId IN NUMBER,
70 launchSnapshot IN VARCHAR2,
71 launchPlanner IN VARCHAR2,
72 anchorDate IN DATE,
73 archiveCurrVersPlan IN VARCHAR2,
74 enable24x7Atp IN VARCHAR2,
75 releaseReschedules IN VARCHAR2
76
77 ) ;
78
79 -- =============================================================
80 -- Desc: This procedure is invoke from web services to release PO
81 -- for a pecified plan id
82 -- Input: release_time_fence_anchor_date - value can be PLAN_START_DATE ans CURRENT_DATE
83 --
84 -- Output: possible output status value include following
85 -- INVALID_PLANID, INVALID_RELEASE_TIME_FENCE_ANCHOR_DATE,
86 --
87 -- INVALID_USERID, INVALID_RESP
88 -- =============================================================
89
90 PROCEDURE RELEASE_DRP ( req_id OUT NOCOPY REQTBLTYP,
91 status OUT NOCOPY VARCHAR2,
92 userId IN NUMBER,
93 responsibilityId IN NUMBER,
94 planId IN NUMBER,
95 release_time_fence_anchor_date IN VARCHAR2
96 ) ;
97
98 -- =============================================================
99 -- Desc: This procedure is invoke from web services to release PO
100 -- for a pecified plan id
101 -- Input: release_time_fence_anchor_date - value can be PLAN_START_DATE ans CURRENT_DATE
102 --
103 -- Output: possible output status value include following
104 -- INVALID_PLANID, INVALID_RELEASE_TIME_FENCE_ANCHOR_DATE,
105 --
106 -- INVALID_USER_NAME, INVALID_RESP_NAME
107 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
108 -- =============================================================
109
110
111
112 PROCEDURE RELEASE_DRP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,
113 status OUT NOCOPY VARCHAR2,
114 UserName IN VARCHAR2,
115 RespName IN VARCHAR2,
116 RespApplName IN VARCHAR2,
117 SecurityGroupName IN VARCHAR2,
118 Language IN VARCHAR2,
119 planId IN NUMBER,
120 release_time_fence_anchor_date IN VARCHAR2
121 ) ;
122
123
124 -- =============================================================
125 -- Desc: This procedure is invoked from web service to
126 -- updates Plan Options for DRP plans.
127 -- Input:
128 -- UserId User ID.
129 -- ResponsibilityId Responsibility Id.
130 -- PlanId Plan Id.
131 -- ItemSimulationSet Item Simulation Set.
132 -- Overwrite Overwrite. Expected values are All,
133 -- Outside PTF or None.
134 -- PurgeAllSchsFlag There is no such parameter in UI. Allowed
135 -- input is Y or N. This is a new parameter
136 -- to control how Global Demand Schedules, Local
137 -- Demand Schedules and Local Supply Schedules
138 -- are updated / inserted. If this flag is set, all
139 -- Global Demand Schedules, Local Demand Schedules and
140 -- Local Supply Schedule will be purged before
141 -- update / insert any demand / supply schedules from
142 -- the input parameters. If this flag is not set, no
143 -- demand / supple schedules will be purged, schedules in
144 -- the input parameters will be updated or inserted.
145 -- GlobalDmdSchs Global Demand Schedules. Each demand schedule contains
146 -- the schedule id and ship to consumption level parameters.
147 -- Although this is not a required parameter, we need both
148 -- id and ShpToConsumptionLvl to define a demand schedule,
149 -- so either both parameters are empty or both are entered.
150 -- LocalDmdSchs Local Demand Schedules. List of all local demand schedules.
151 -- Each local demand schedule contains the organization id,
152 -- demand schedule id and ship to consumption level. Similar to
153 -- Global Demand Schedules, these Three parameters have to be
154 -- either all empty or all entered.
155 -- LocalSupSchs Supply Schedules.List of local supply schedules. Each local
156 -- supply schedule contains the organization id and supply
157 -- schedule id. Similar to Global Demand Schedules, these
158 -- two parameters have to be either both empty or both entered
159 --
160 -- Output: Procedure returns a status and conc program req id.
161 -- The possible return statuses are:
162 -- SUCCESS if everything is ok
163 -- ERROR_DUP_GLOBALDMDSCH
164 -- ERROR_DUP_LOCALDMDSCH
165 -- ERROR_DUP_LOCALSUPSCH
166 -- ERROR_UNEXPECTED_##### unexpected error
167 -- INVALID_FND_USERID
168 -- INVALID_FND_RESPONSIBILITYID
169 -- INVALID_PLANID invalid source plan id
170 -- INVALID_PLAN_TYPE non DRP plan
171 -- INVALID_SIMULATION_SET_ID
172 -- INVALID_OVERWRITE Only 'Y' or 'N' is allowed.
173 -- INVALID_GLOBALDMDSCHS_DMD_SCH_NAME
174 -- INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL
175 -- INVALID_LOCALDMDSCHS_ORGID
176 -- INVALID_LOCALDMDSCHS_DMD_SCH_ID
177 -- INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL
178 -- INVALID_LOCALSUPSCHS_ORGID
179 -- INVALID_LOCALSUPSCHS_SUP_SCH_NAME
180 -- =============================================================
181
182 PROCEDURE SET_DRP_PLAN_OPTIONS (
183 Status OUT NOCOPY VARCHAR2,
184 UserId IN NUMBER,
185 ResponsibilityId IN NUMBER,
186 PlanId IN NUMBER,
187 ItemSimulationSetId IN NUMBER default NULL,
188 Overwrite IN VARCHAR2 default 'All',
189 PurgeAllSchsFlag IN VARCHAR2,
190 GlobalDmdSchs IN MscGlbDmdSchTbl default NULL,
191 LocalDmdSchs IN MscLocSRPDmdSchTbl default NULL,
192 LocalSupSchs IN MscLocSupSchTbl default NULL
193 );
194
195
196 -- =============================================================
197 -- Desc: This procedure is invoked from web service to
198 -- updates Plan Options for DRP plans.
199 -- Input:
200 -- UserId User ID.
201 -- ResponsibilityId Responsibility Id.
202 -- PlanId Plan Id.
203 -- ItemSimulationSet Item Simulation Set.
204 -- Overwrite Overwrite. Expected values are All,
205 -- Outside PTF or None.
206 -- PurgeAllSchsFlag There is no such parameter in UI. Allowed
207 -- input is Y or N. This is a new parameter
208 -- to control how Global Demand Schedules, Local
209 -- Demand Schedules and Local Supply Schedules
210 -- are updated / inserted. If this flag is set, all
211 -- Global Demand Schedules, Local Demand Schedules and
212 -- Local Supply Schedule will be purged before
213 -- update / insert any demand / supply schedules from
214 -- the input parameters. If this flag is not set, no
215 -- demand / supple schedules will be purged, schedules in
216 -- the input parameters will be updated or inserted.
217 -- GlobalDmdSchs Global Demand Schedules. Each demand schedule contains
218 -- the schedule id and ship to consumption level parameters.
219 -- Although this is not a required parameter, we need both
220 -- id and ShpToConsumptionLvl to define a demand schedule,
221 -- so either both parameters are empty or both are entered.
222 -- LocalDmdSchs Local Demand Schedules. List of all local demand schedules.
223 -- Each local demand schedule contains the organization id,
224 -- demand schedule id and ship to consumption level. Similar to
225 -- Global Demand Schedules, these Three parameters have to be
226 -- either all empty or all entered.
227 -- LocalSupSchs Supply Schedules.List of local supply schedules. Each local
228 -- supply schedule contains the organization id and supply
229 -- schedule id. Similar to Global Demand Schedules, these
230 -- two parameters have to be either both empty or both entered
231 --
232 -- Output: Procedure returns a status and conc program req id.
233 -- The possible return statuses are:
234 -- SUCCESS if everything is ok
235 -- ERROR_DUP_GLOBALDMDSCH
236 -- ERROR_DUP_LOCALDMDSCH
237 -- ERROR_DUP_LOCALSUPSCH
238 -- ERROR_UNEXPECTED_##### unexpected error
239 -- INVALID_USER_NAME, INVALID_RESP_NAME
240 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
241 -- INVALID_PLANID invalid source plan id
242 -- INVALID_PLAN_TYPE non DRP plan
243 -- INVALID_SIMULATION_SET_ID
244 -- INVALID_OVERWRITE Only 'Y' or 'N' is allowed.
245 -- INVALID_GLOBALDMDSCHS_DMD_SCH_NAME
246 -- INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL
247 -- INVALID_LOCALDMDSCHS_ORGID
248 -- INVALID_LOCALDMDSCHS_DMD_SCH_ID
249 -- INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL
250 -- INVALID_LOCALSUPSCHS_ORGID
251 -- INVALID_LOCALSUPSCHS_SUP_SCH_NAME
252 -- =============================================================
253 PROCEDURE SET_DRP_PLAN_OPTIONS_PUBLIC (
254 Status OUT NOCOPY VARCHAR2,
255 UserName IN VARCHAR2,
256 RespName IN VARCHAR2,
257 RespApplName IN VARCHAR2,
258 SecurityGroupName IN VARCHAR2,
259 Language IN VARCHAR2,
260 PlanId IN NUMBER,
261 ItemSimulationSetId IN NUMBER default NULL,
262 Overwrite IN VARCHAR2 default 'All',
263 PurgeAllSchsFlag IN VARCHAR2,
264 GlobalDmdSchs IN MscGlbDmdSchTbl default NULL,
265 LocalDmdSchs IN MscLocSRPDmdSchTbl default NULL,
266 LocalSupSchs IN MscLocSupSchTbl default NULL
267 );
268
269 END MSC_WS_DRP;
270