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