[Home] [Help]
PACKAGE: APPS.CSP_AUTO_ASLMSL_PVT
Source
1 PACKAGE CSP_AUTO_ASLMSL_PVT as
2 /* $Header: cspvasls.pls 120.0 2005/05/24 19:13:53 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSP_AUTO_ASLMSL_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:CSP_ASLMSL_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- USAGE_DETAILS_ID
19 -- USAGE_HEADER_ID
20 -- USAGE_FORECAST_PERIOD
21 -- DETAILS_DATA_TYPE
22 -- USAGE_FORECAST_QUANTITY
23 --
24 -- Required:
25 -- Defaults:
26 -- Note: This is automatic generated record definition, it includes all columns
27 -- defined in the table, developer must manually add or delete some of the attributes.
28 --
29 -- End of Comments
30
31 TYPE CSP_Date_Rec_Type IS RECORD
32 (
33 TRANSACTION_DATE_START DATE ,
34 TRANSACTION_DATE_END DATE
35 );
36
37 G_MISS_CSP_DATE_REC CSP_Date_Rec_Type;
38
39 TYPE CSP_Supply_Chain_Rec_Type IS RECORD
40 (
41 INVENTORY_ITEM_ID NUMBER ,
42 SOURCE_TYPE NUMBER ,
43 SOURCE_ORGANIZATION NUMBER,
44 SOURCE_SUBINVENTORY VARCHAR2(10),
45 PARENT_SUPPLY_CHAIN_ID NUMBER
46 );
47
48 G_MISS_SUPPLY_CHAIN_REC CSP_Supply_Chain_Rec_Type;
49
50 TYPE CSP_Usage_Key_Rec_Type IS RECORD
51 (
52 INVENTORY_ITEM_ID NUMBER,
53 ORGANIZATION_ID NUMBER,
54 SUBINVENTORY VARCHAR2(10)
55 );
56
57 G_MISS_USAGE_KEY_REC CSP_Supply_Chain_Rec_Type;
58
59 TYPE CSP_Forecast_Rec_Type IS RECORD
60 (
61 PLANNING_PARAMETERS_ID NUMBER ,
62 ORGANIZATION_TYPE VARCHAR2(1) ,
63 FORECAST_RULE_ID NUMBER ,
64 FORECAST_METHOD VARCHAR2(30),
65 FORECAST_PERIODS NUMBER ,
66 HISTORY_PERIODS NUMBER,
67 ACTUAL_HISTORY_PERIODS NUMBER ,
68 PERIOD_TYPE VARCHAR2(30) ,
69 PERIOD_SIZE NUMBER,
70 ALPHA NUMBER,
71 BETA NUMBER ,
72 WEIGHTED_AVG_PERIOD1 NUMBER ,
73 WEIGHTED_AVG_PERIOD2 NUMBER,
74 WEIGHTED_AVG_PERIOD3 NUMBER,
75 WEIGHTED_AVG_PERIOD4 NUMBER,
76 WEIGHTED_AVG_PERIOD5 NUMBER,
77 WEIGHTED_AVG_PERIOD6 NUMBER,
78 WEIGHTED_AVG_PERIOD7 NUMBER,
79 WEIGHTED_AVG_PERIOD8 NUMBER,
80 WEIGHTED_AVG_PERIOD9 NUMBER,
81 WEIGHTED_AVG_PERIOD10 NUMBER,
82 WEIGHTED_AVG_PERIOD11 NUMBER,
83 WEIGHTED_AVG_PERIOD12 NUMBER
84 );
85
86
87 TYPE CSP_Date_Tbl_Type IS TABLE OF CSP_Date_Rec_Type
88 INDEX BY BINARY_INTEGER;
89
90 TYPE CSP_Supply_Chain_Tbl_Type IS TABLE OF CSP_Supply_Chain_Rec_Type
91 INDEX BY BINARY_INTEGER;
92
93 TYPE CSP_Usage_Key_Tbl_Type IS TABLE OF CSP_Usage_Key_Rec_Type;
94
95 TYPE CSP_Qty_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
96
97
98 G_HISTORY_REQUEST_TYPE VARCHAR2(10) := 'HISTORY';
99 G_FORECAST_REQUEST_TYPE VARCHAR2(10) := 'FORECAST';
100 G_USAGE_HISTORIES VARCHAR2(100) := 'CSP_USAGE_HISTORIES';
101 G_USAGE_HEADER VARCHAR2(100) := 'CSP_USAGE_HEADERS';
102 G_SUPPLY_CHAIN VARCHAR2(100) := 'CSP_SUPPLY_CHAIN';
103
104
105 -- *******************************************************
106 -- Start of Comments
107 -- *******************************************************
108 -- API Name: Generate_Recommendations
109 -- Type : Private
110 -- Pre-Req :
111 -- Parameters:
112 -- IN
113 -- P_Api_Version_Number IN NUMBER
114 -- P_level_id IN VARCHAR2 DEFAULT NULL
115 --
116 -- OUT:
117 -- retcode OUT NOCOPY NUMBER
118 -- errbuf OUT NOCOPY VARCHAR2
119 -- Version : Current version 1.0
120 ---
121 ---- End of Comments
122
123 PROCEDURE Generate_Recommendations (
124 retcode OUT NOCOPY NUMBER,
125 errbuf OUT NOCOPY VARCHAR2,
126 P_Api_Version_Number IN NUMBER,
127 p_level_id IN VARCHAR2 DEFAULT NULL);
128
129
130 -- *******************************************************
131 -- Start of Comments
132 -- *******************************************************
133 -- API Name: Purge_Planning_Data
134 -- Type : Private
135 -- Pre-Req :
136 -- Parameters:
137 -- IN
138 -- P_Api_Version_Number IN NUMBER,
139 -- P_Init_Msg_List IN VARCHAR2
140 -- P_Commit IN VARCHAR2
141 -- p_validation_level IN NUMBER
142 --
143 -- OUT:
144 -- x_return_status OUT NOCOPY VARCHAR2
145 -- x_msg_count OUT NOCOPY NUMBER
146 -- x_msg_data OUT NOCOPY VARCHAR2
147 -- Version : Current version 1.0
148 ---
149 ---- End of Comments
150
151 PROCEDURE Purge_Planning_Data (
152 P_Api_Version_Number IN NUMBER,
153 P_Init_Msg_List IN VARCHAR2 ,
154 P_Commit IN VARCHAR2 ,
155 P_validation_level IN NUMBER ,
156 X_Return_Status OUT NOCOPY VARCHAR2,
157 X_Msg_Count OUT NOCOPY NUMBER,
158 X_Msg_Data OUT NOCOPY VARCHAR2);
159
160 -- *******************************************************
161 -- Start of Comments
162 -- *******************************************************
163 -- API Name: Create_Usage
164 -- Type : Private
165 -- Pre-Req :
166 -- Parameters:
167 -- IN
168 -- P_Api_Version_Number IN NUMBER,
169 --
170 -- OUT:
171 -- retcode OUT NOCOPY NUMBER
172 -- errbuf OUT NOCOPY VARCHAR2
173 -- Version : Current version 1.0
174 ---
175 ---- End of Comments
176
177 PROCEDURE Create_Usage (
178 retcode OUT NOCOPY NUMBER,
179 errbuf OUT NOCOPY VARCHAR2,
180 P_Api_Version_Number IN NUMBER);
181
182 -- *******************************************************
183 -- Start of Comments
184 -- *******************************************************
185 -- API Name: Create_Supply_Chain
186 -- Type : Private
187 -- Pre-Req :
188 -- Parameters:
189 -- IN
190 -- P_Api_Version_Number IN NUMBER,
191 -- P_Init_Msg_List IN VARCHAR2
192 -- P_Commit IN VARCHAR2
193 -- p_validation_level IN NUMBER
194 --
195 -- OUT:
196 -- x_return_status OUT NOCOPY VARCHAR2
197 -- x_msg_count OUT NOCOPY NUMBER
198 -- x_msg_data OUT NOCOPY VARCHAR2
199 -- Version : Current version 1.0
200 ---
201 ---- End of Comments
202 PROCEDURE Create_Supply_Chain (
203 P_Api_Version_Number IN NUMBER,
204 P_Init_Msg_List IN VARCHAR2 ,
205 P_Commit IN VARCHAR2 ,
206 P_validation_level IN NUMBER ,
207 X_Return_Status OUT NOCOPY VARCHAR2,
208 X_Msg_Count OUT NOCOPY NUMBER,
209 X_Msg_Data OUT NOCOPY VARCHAR2
210 );
211
212 PROCEDURE Create_Supply_Chain (
213 P_Api_Version_Number IN NUMBER,
214 P_Init_Msg_List IN VARCHAR2 ,
215 P_Commit IN VARCHAR2 ,
216 P_validation_level IN NUMBER ,
217 P_Level_id IN VARCHAR2,
218 X_Return_Status OUT NOCOPY VARCHAR2,
219 X_Msg_Count OUT NOCOPY NUMBER,
220 X_Msg_Data OUT NOCOPY VARCHAR2
221 );
222
223 -- *******************************************************
224 -- Start of Comments
225 -- *******************************************************
226 -- API Name: Create_Usage_History
227 -- Type : Private
228 -- Pre-Req :
229 -- Parameters:
230 -- IN
231 -- p_Api_Version_Number IN NUMBER,
232 -- p_Init_Msg_List IN VARCHAR2
233 -- P_Commit IN VARCHAR2
234 -- p_validation_level IN NUMBER
235 --
236 -- OUT:
237 -- x_return_status OUT NOCOPY VARCHAR2
238 -- x_msg_count OUT NOCOPY NUMBER
239 -- x_msg_data OUT NOCOPY VARCHAR2
240 -- Version : Current version 1.0
241 ---
242 ---- End of Comments
243
244 PROCEDURE Create_Usage_History (
245 P_Api_Version_Number IN NUMBER,
246 P_Init_Msg_List IN VARCHAR2 ,
247 P_Commit IN VARCHAR2 ,
248 p_validation_level IN NUMBER ,
249 X_Return_Status OUT NOCOPY VARCHAR2,
250 X_Msg_Count OUT NOCOPY NUMBER,
251 X_Msg_Data OUT NOCOPY VARCHAR2);
252
253 -- *******************************************************
254 -- Start of Comments
255 -- *******************************************************
256 -- API Name: Create_Usage_rollup
257 -- Type : Private
258 -- Pre-Req :
259 -- Parameters:
260 -- IN
261 -- P_Api_Version_Number IN NUMBER,
262 --
263 -- OUT:
264 -- retcode OUT NOCOPY NUMBER
265 -- errbuf OUT NOCOPY VARCHAR2
266 -- Version : Current version 1.0
267 --
268 -- End of Comments
269
270 PROCEDURE Create_Usage_Rollup (
271 retcode OUT NOCOPY NUMBER,
272 errbuf OUT NOCOPY VARCHAR2,
273 P_Api_Version_Number IN NUMBER);
274
275 -- *******************************************************
276 -- Start of Comments
277 -- *******************************************************
278 -- API Name: Calculate_Forecast
279 -- Type : Private
280 -- Pre-Req :
281 -- Parameters:
282 -- IN
283 -- P_Api_Version_Number IN NUMBER,
284 -- P_Init_Msg_List IN VARCHAR2
285 -- P_Commit IN VARCHAR2
286 -- p_validation_level IN NUMBER
287 -- p_Level_Id IN VARCHAR2
288 --
289 -- OUT:
290 -- x_return_status OUT NOCOPY VARCHAR2
291 -- x_msg_count OUT NOCOPY NUMBER
292 -- x_msg_data OUT NOCOPY VARCHAR2
293 -- Version : Current version 1.0
294 --
295 -- End of Comments
296
297 PROCEDURE Calculate_Forecast (
298 P_Api_Version_Number IN NUMBER,
299 P_Init_Msg_List IN VARCHAR2,
300 P_Commit IN VARCHAR2 ,
301 P_validation_level IN NUMBER,
302 P_Level_Id IN VARCHAR2,
303 P_Reason_Code IN VARCHAR2,
304 X_Return_Status OUT NOCOPY VARCHAR2,
305 X_Msg_Count OUT NOCOPY NUMBER,
306 X_Msg_Data OUT NOCOPY VARCHAR2
307 );
308
309 -- *******************************************************
310 -- Start of Comments
311 -- *******************************************************
312 -- API Name: Calculate_Product_norm
313 -- Type : Private
314 -- Pre-Req :
315 -- Parameters:
316 -- IN
317 -- P_Api_Version_Number IN NUMBER,
318 -- P_Init_Msg_List IN VARCHAR2
319 -- P_Commit IN VARCHAR2
320 -- p_validation_level IN NUMBER
321 -- p_Level_Id IN VARCHAR2
322 --
323 -- OUT:
324 -- x_return_status OUT NOCOPY VARCHAR2
325 -- x_msg_count OUT NOCOPY NUMBER
326 -- x_msg_data OUT NOCOPY VARCHAR2
327 -- Version : Current version 1.0
328 --
329 -- End of Comments
330
331 PROCEDURE Calculate_product_norm (
332 P_Api_Version_Number IN NUMBER,
333 P_Init_Msg_List IN VARCHAR2 ,
334 P_Commit IN VARCHAR2 ,
335 P_validation_level IN NUMBER ,
336 P_Level_Id IN VARCHAR2,
337 X_Return_Status OUT NOCOPY VARCHAR2,
338 X_Msg_Count OUT NOCOPY NUMBER,
339 X_Msg_Data OUT NOCOPY VARCHAR2
340 );
341
342 -- *******************************************************
343 -- Start of Comments
344 -- *******************************************************
345 -- API Name: Calculate_Territory_Norm
346 -- Type : Private
347 -- Pre-Req :
348 -- Parameters:
349 -- IN
350 -- P_Api_Version_Number IN NUMBER,
351 -- P_Init_Msg_List IN VARCHAR2
352 -- P_Commit IN VARCHAR2
353 -- p_validation_level IN NUMBER
354 -- p_Level_Id IN VARCHAR2
355 --
356 -- OUT:
357 -- x_return_status OUT NOCOPY VARCHAR2
358 -- x_msg_count OUT NOCOPY NUMBER
359 -- x_msg_data OUT NOCOPY VARCHAR2
360 -- Version : Current version 1.0
361 --
362 -- End of Comments
363
364 PROCEDURE Calculate_Territory_Norm (
365 P_Api_Version_Number IN NUMBER,
366 P_Init_Msg_List IN VARCHAR2 ,
367 P_Commit IN VARCHAR2,
368 P_validation_level IN NUMBER ,
369 P_Level_Id IN VARCHAR2,
370 X_Return_Status OUT NOCOPY VARCHAR2,
371 X_Msg_Count OUT NOCOPY NUMBER,
372 X_Msg_Data OUT NOCOPY VARCHAR2
373 );
374
375 -- *******************************************************
376 -- Start of Comments
377 -- *******************************************************
378 -- API Name: Calculate_New_Product_Planning
379 -- Type : Private
380 -- Pre-Req :
381 -- Parameters:
382 -- IN
383 -- P_Api_Version_Number IN NUMBER,
384 -- P_Init_Msg_List IN VARCHAR2
385 -- P_Commit IN VARCHAR2
386 -- p_validation_level IN NUMBER
387 -- p_Level_Id IN VARCHAR2
388 --
389 -- OUT:
390 -- x_return_status OUT NOCOPY VARCHAR2
391 -- x_msg_count OUT NOCOPY NUMBER
392 -- x_msg_data OUT NOCOPY VARCHAR2
393 -- Version : Current version 1.0
394 --
395 -- End of Comments
396
397 PROCEDURE Calculate_New_Product_Planning (
398 P_Api_Version_Number IN NUMBER,
399 P_Init_Msg_List IN VARCHAR2 ,
400 P_Commit IN VARCHAR2 ,
401 P_validation_level IN NUMBER ,
402 P_Level_Id IN VARCHAR2,
403 X_Return_Status OUT NOCOPY VARCHAR2,
404 X_Msg_Count OUT NOCOPY NUMBER,
405 X_Msg_Data OUT NOCOPY VARCHAR2
406 );
407
408 -- *******************************************************
409 -- Start of Comments
410 -- *******************************************************
411 -- API Name: Calculate_Needby_date
412 -- Type : Private
413 -- Pre-Req :
414 -- Parameters:
415 -- IN
416 -- P_Api_Version_Number IN NUMBER,
417 -- P_Init_Msg_List IN VARCHAR2
418 -- P_Commit IN VARCHAR2
419 -- p_validation_level IN NUMBER
420 -- p_Level_Id IN VARCHAR2
421 --
422 -- OUT:
423 -- x_needby_date OUT NOCOPY DATE
424 -- x_return_status OUT NOCOPY VARCHAR2
425 -- x_msg_count OUT NOCOPY NUMBER
429 -- End of Comments
426 -- x_msg_data OUT NOCOPY VARCHAR2
427 -- Version : Current version 1.0
428 --
430
431 PROCEDURE Calculate_Needby_date (
432 P_Api_Version_Number IN NUMBER,
433 P_Init_Msg_List IN VARCHAR2,
434 P_Commit IN VARCHAR2,
435 P_validation_level IN NUMBER ,
436 P_inventory_item_id IN NUMBER,
437 P_Organization_id IN NUMBER,
438 P_Onhand_Quantity IN NUMBER,
439 X_Needby_date OUT NOCOPY DATE,
440 X_Return_Status OUT NOCOPY VARCHAR2,
441 X_Msg_Count OUT NOCOPY NUMBER,
442 X_Msg_Data OUT NOCOPY VARCHAR2
443 );
444
445 PROCEDURE Apply_Business_Rules (
446 P_Api_Version_Number IN NUMBER,
447 P_Init_Msg_List IN VARCHAR2,
448 P_Commit IN VARCHAR2,
449 p_validation_level IN NUMBER,
450 X_Return_Status OUT NOCOPY VARCHAR2,
451 X_Msg_Count OUT NOCOPY NUMBER,
452 X_Msg_Data OUT NOCOPY VARCHAR2
453 );
454
455 End CSP_AUTO_ASLMSL_PVT;