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