1 PACKAGE MSC_WS_IO AS
2 /* $Header: MSCWIOPS.pls 120.3 2008/03/20 15:57:28 bnaghi noship $ */
3
4 -- =============================================================
5 -- Desc: This procedure is invoke from web services to launch
6 -- IO plan. It mirrors all the parameters from the
7 -- Launch Inventory Planning Process conc prog. The procedure
8 -- returns a status and concurrent program request id.
9 -- Output: possible output status value include following
10 -- INVALID_PLANID, INVALID_ANCHORDATE,
11 -- INVALID_FND_USERID, INVALID_FND_RESP, ERROR_UNEXPECTED
12 -- =============================================================
13 PROCEDURE LAUNCH_IO_BATCH (
14 processId OUT NOCOPY NUMBER,
15 status OUT NOCOPY VARCHAR2,
16 userId IN NUMBER,
17 responsibilityId IN NUMBER,
18 planId IN NUMBER,
19 anchorDate IN DATE,
20 archiveCurrVersPlan IN VARCHAR2) ;
21
22 -- =============================================================
23 -- Desc: This procedure is invoke from web services to launch
24 -- IO plan. It mirrors all the parameters from the
25 -- Launch Inventory Planning Process conc prog. The procedure
26 -- returns a status and concurrent program request id.
27 -- Output: possible output status value include following
28 -- INVALID_PLANID, INVALID_ANCHORDATE,
29 -- INVALID_FND_USERID, INVALID_USER_NAME, INVALID_RESP_NAME
30 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
31 -- =============================================================
32
33 PROCEDURE LAUNCH_IO_BATCH_PUBLIC (
34 processId OUT NOCOPY NUMBER,
35 status OUT NOCOPY VARCHAR2,
36 UserName IN VARCHAR2,
37 RespName IN VARCHAR2,
38 RespApplName IN VARCHAR2,
39 SecurityGroupName IN VARCHAR2,
40 Language IN VARCHAR2,
41 planId IN NUMBER,
42 anchorDate IN DATE ,
43 archiveCurrVersPlan IN VARCHAR2) ;
44
45
46
47 -- =============================================================
48 -- Desc: This procedure is invoked from web service to
49 -- updates Plan Options for IO plans.
50 -- Input:
51 -- UserId User ID.
52 -- ResponsibilityId Responsibility Id.
53 -- PlanId Plan Id.
54 -- ItemSimulationSet Item Simulation Set.
55 -- ServiceLvlSetId Service Level Set Id.
56 -- PurgeAllSchsFlag There is no such parameter in UI. Allowed
57 -- input is Y or N. This is a new parameter
58 -- to control how Global and local Demand Schedules
59 -- are updated / inserted. If this flag is set, all
60 -- Global and Local Demand will be purged before
61 -- update / insert from the input parameters.
62 -- If this flag is not set, no global or local demand
63 -- schedules will be purged, schedules in the input
64 -- parameters will be updated or inserted.
65 -- GlobalDmdSchs Global Demand Schedules. Each global demand schedule
66 -- contains the schedule id, ship to consumption,
67 -- demand variability type, probability and/or
68 -- mean absolue % error parameters.
69 -- LocalDmdSchs Local Demand Schedules. Each local demand schedule
70 -- contains the organization id, schedule id, scenario set id,
71 -- ship to consumption, demand variability type, probability and/or
72 -- mean absolue % error parameters.
73 --
74 -- Output: Procedure returns a status and conc program req id.
75 -- The possible return statuses are:
76 -- SUCCESS if everything is ok
77 -- ERROR_DUP_GLOBALDMDSCH
78 -- ERROR_DUP_LOCBALDMDSCH
79 -- ERROR_UNEXPECTED_##### unexpected error
80 -- INVALID_FND_USERID
81 -- INVALID_FND_RESPONSIBILITYID
82 -- INVALID_PLANID invalid source plan id
83 -- INVALID_PLAN_TYPE non IO plan
84 -- INVALID_SIMULATION_SET_ID
85 -- INVALID_SERVICE_LVL_SET_ID
86 -- INVALID_GLOBALDMDSCHS_DMD_SCH_ID
87 -- INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL
88 -- INVALID_GLOBALDMDSCHS_VARIABILITY_TYPE
89 -- INVALID_GLOBALDMDSCHS_PROBABILITY
90 -- INVALID_GLOBALDMDSCHS_MEAN_ABS_PCT_ERROR
91 -- INVALID_VAR_TYPE_IN_GBL_SCH
92 -- INVALID_GLB_SUM_OF_PROB
93 -- INVALID_LOCALDMDSCHS_ORGID
94 -- INVALID_LOCALDMDSCHS_SCENARIO_SET
95 -- INVALID_LOCALDMDSCHS_DMD_SCH_ID
96 -- INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL
97 -- INVALID_LOCALDMDSCHS_VARIABILITY_TYPE
98 -- INVALID_LOCBALDMDSCHS_PROBABILITY
99 -- INVALID_LOCBALDMDSCHS_MEAN_ABS_PCT_ERROR
100 -- INVALID_VAR_TYPE_IN_SCENARIO_SET
101 -- INVALID_LOC_SUM_OF_PROB
102 -- =============================================================
103 PROCEDURE SET_IO_PLAN_OPTIONS (
104 Status OUT NOCOPY VARCHAR2,
105 UserId IN NUMBER,
106 ResponsibilityId IN NUMBER,
107 PlanId IN NUMBER,
108 ItemSimulationSetId IN NUMBER default NULL,
109 ServiceLvlSetId IN NUMBER default NULL,
110 PurgeAllSchsFlag IN VARCHAR2,
111 GlobalDmdSchs IN MscGlbIODmdSchTbl default NULL,
112 LocalDmdSchs IN MscLocIODmdSchTbl default NULL
113 );
114
115
116 -- =============================================================
117 -- Desc: This procedure is invoked from web service to
118 -- updates Plan Options for IO plans.
119 -- Input:
120 -- UserId User ID.
121 -- ResponsibilityId Responsibility Id.
122 -- PlanId Plan Id.
123 -- ItemSimulationSet Item Simulation Set.
124 -- ServiceLvlSetId Service Level Set Id.
125 -- PurgeAllSchsFlag There is no such parameter in UI. Allowed
126 -- input is Y or N. This is a new parameter
127 -- to control how Global and local Demand Schedules
128 -- are updated / inserted. If this flag is set, all
129 -- Global and Local Demand will be purged before
130 -- update / insert from the input parameters.
131 -- If this flag is not set, no global or local demand
132 -- schedules will be purged, schedules in the input
133 -- parameters will be updated or inserted.
134 -- GlobalDmdSchs Global Demand Schedules. Each global demand schedule
135 -- contains the schedule id, ship to consumption,
136 -- demand variability type, probability and/or
137 -- mean absolue % error parameters.
138 -- LocalDmdSchs Local Demand Schedules. Each local demand schedule
139 -- contains the organization id, schedule id, scenario set id,
140 -- ship to consumption, demand variability type, probability and/or
141 -- mean absolue % error parameters.
142 --
143 -- Output: Procedure returns a status and conc program req id.
144 -- The possible return statuses are:
145 -- SUCCESS if everything is ok
146 -- ERROR_DUP_GLOBALDMDSCH
147 -- ERROR_DUP_LOCBALDMDSCH
148 -- ERROR_UNEXPECTED_##### unexpected error
149 -- INVALID_USER_NAME, INVALID_RESP_NAME
150 -- INVALID_LANGUAGE, INVALID_SECUTITY_GROUP_NAME, INVALID_FUNC_NAME
151 -- INVALID_PLANID invalid source plan id
152 -- INVALID_PLAN_TYPE non IO plan
153 -- INVALID_SIMULATION_SET_ID
154 -- INVALID_SERVICE_LVL_SET_ID
155 -- INVALID_GLOBALDMDSCHS_DMD_SCH_ID
156 -- INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL
157 -- INVALID_GLOBALDMDSCHS_VARIABILITY_TYPE
158 -- INVALID_GLOBALDMDSCHS_PROBABILITY
159 -- INVALID_GLOBALDMDSCHS_MEAN_ABS_PCT_ERROR
160 -- INVALID_VAR_TYPE_IN_GBL_SCH
161 -- INVALID_GLB_SUM_OF_PROB
162 -- INVALID_LOCALDMDSCHS_ORGID
163 -- INVALID_LOCALDMDSCHS_SCENARIO_SET
164 -- INVALID_LOCALDMDSCHS_DMD_SCH_ID
165 -- INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL
166 -- INVALID_LOCALDMDSCHS_VARIABILITY_TYPE
167 -- INVALID_LOCBALDMDSCHS_PROBABILITY
168 -- INVALID_LOCBALDMDSCHS_MEAN_ABS_PCT_ERROR
169 -- INVALID_VAR_TYPE_IN_SCENARIO_SET
170 -- INVALID_LOC_SUM_OF_PROB
171 -- =============================================================
172
173 PROCEDURE SET_IO_PLAN_OPTIONS_PUBLIC (
174 status OUT NOCOPY VARCHAR2,
175 UserName IN VARCHAR2,
176 RespName IN VARCHAR2,
177 RespApplName IN VARCHAR2,
178 SecurityGroupName IN VARCHAR2,
179 Language IN VARCHAR2,
180 PlanId IN NUMBER,
181 ItemSimulationSetId IN NUMBER default NULL,
182 ServiceLvlSetId IN NUMBER default NULL,
183 PurgeAllSchsFlag IN VARCHAR2,
184 GlobalDmdSchs IN MscGlbIODmdSchTbl default NULL,
185 LocalDmdSchs IN MscLocIODmdSchTbl default NULL
186 );
187
188 END MSC_WS_IO;