[Home] [Help]
PACKAGE: APPS.RLM_WF_SV
Source
1 PACKAGE RLM_WF_SV AUTHID CURRENT_USER as
2 /*$Header: RLMDPWFS.pls 120.1.12000000.1 2007/01/18 18:32:04 appldev ship $*/
3 /*===========================================================================
4 PACKAGE NAME: RLM_WF_SV
5
6 DESCRIPTION: Contains all server side code for the dsp workflow wrapper.
7
8 CLIENT/SERVER: Server
9
10 LIBRARY NAME: None
11
12 OWNER:
13
14 PROCEDURE/FUNCTIONS:
15
16 GLOBALS:
17
18 ===========================================================================*/
19 C_SDEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL19;
20 C_DEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL20;
21 C_TDEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL21;
22
23 g_PROC_SUCCESS CONSTANT NUMBER := 0;
24 g_PROC_WARNING CONSTANT NUMBER := 1;
25 g_PROC_ERROR CONSTANT NUMBER := 2;
26
27 g_ItemType CONSTANT VARCHAR2(8) := 'RLMHDR';
28 g_ProcessName CONSTANT VARCHAR2(8) := 'DSPWF';
29 g_ProcessNameLoop CONSTANT VARCHAR2(8) := 'DSPLOOP';
30
31 g_Sch_rec rlm_interface_headers%ROWTYPE;
32 g_Grp_rec rlm_dp_sv.t_Group_rec;
33
34 g_num_child NUMBER;
35 e_LockH EXCEPTION;
36
37 /*===========================================================================
38 PROCEDURE NAME: StartDSPProcess
39
40 DESCRIPTION: This procedure calls the starts the DSP Workflow process
41
42 PARAMETERS: errbuf OUT NOCOPY VARCHAR2
43 retcode OUT NOCOPY VARCHAR2
44 p_Header_Id IN NUMBER DEFAULT NULL
45 v_Sch_rec IN OUT NOCOPY rlm_interface_headers%ROWTYPE
46 v_num_child IN NUMBER
47
48 DESIGN REFERENCES: rladphld.rtf
49
50 ALGORITHM:
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSED ISSUES:
57
58 CHANGE HISTORY: created mnnaraya 01/12/2000
59 ===========================================================================*/
60 PROCEDURE StartDSPProcess( errbuf OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY VARCHAR2,
62 p_Header_Id IN NUMBER DEFAULT NULL,
63 v_Sch_rec IN OUT NOCOPY rlm_interface_headers%ROWTYPE,
64 v_num_child IN NUMBER);
65
66 /*===========================================================================
67 PROCEDURE NAME: ValidateDemand
68
69 DESCRIPTION: This procedure calls the GroupValidateDemand procedure
70
71 PARAMETERS: itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER,
74 funcmode IN VARCHAR2,
75 resultout OUT NOCOPY VARCHAR2`
76
77 DESIGN REFERENCES: rladphld.rtf
78
79 ALGORITHM:
80
81 NOTES:
82
83 OPEN ISSUES:
84
85 CLOSED ISSUES:
86
87 CHANGE HISTORY: created mnnaraya 01/12/2000
88 ===========================================================================*/
89
90 PROCEDURE ValidateDemand(
91 itemtype IN VARCHAR2,
92 itemkey IN VARCHAR2,
93 actid IN NUMBER,
94 funcmode IN VARCHAR2,
95 resultout OUT NOCOPY VARCHAR2);
96
97 /*===========================================================================
98 PROCEDURE NAME: ManageDemand
99
100 DESCRIPTION: This procedure calls the ManageDemand procedure
101
102 PARAMETERS: itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 funcmode IN VARCHAR2,
106 resultout OUT NOCOPY VARCHAR2`
107
108 DESIGN REFERENCES: rladphld.rtf
109
110 ALGORITHM:
111
112 NOTES:
113
114 OPEN ISSUES:
115
116 CLOSED ISSUES:
117
118 CHANGE HISTORY: created mnnaraya 01/12/2000
119 ===========================================================================*/
120
121 PROCEDURE ManageDemand(
122 itemtype IN VARCHAR2,
123 itemkey IN VARCHAR2,
124 actid IN NUMBER,
125 funcmode IN VARCHAR2,
126 resultout OUT NOCOPY VARCHAR2);
127
128 /*===========================================================================
129 PROCEDURE NAME: ManageForecast
130
131 DESCRIPTION: This procedure calls the ManageForecast procedure
132
133 PARAMETERS: itemtype IN VARCHAR2,
134 itemkey IN VARCHAR2,
135 actid IN NUMBER,
136 funcmode IN VARCHAR2,
137 resultout OUT NOCOPY VARCHAR2`
138
139 DESIGN REFERENCES: rladphld.rtf
140
141 ALGORITHM:
142
143 NOTES:
144
145 OPEN ISSUES:
146
147 CLOSED ISSUES:
148
149 CHANGE HISTORY: created mnnaraya 01/12/2000
150 ===========================================================================*/
151
152 PROCEDURE ManageForecast(
153 itemtype IN VARCHAR2,
154 itemkey IN VARCHAR2,
155 actid IN NUMBER,
156 funcmode IN VARCHAR2,
157 resultout OUT NOCOPY VARCHAR2);
158
159 /*===========================================================================
160 PROCEDURE NAME: ReconcileDemand
161
162 DESCRIPTION: This procedure calls the ReconcileDemand procedure
163
164 PARAMETERS: itemtype IN VARCHAR2,
165 itemkey IN VARCHAR2,
166 actid IN NUMBER,
167 funcmode IN VARCHAR2,
168 resultout OUT NOCOPY VARCHAR2`
169
170 DESIGN REFERENCES: rladphld.rtf
171
172 ALGORITHM:
173
174 NOTES:
175
176 OPEN ISSUES:
177
178 CLOSED ISSUES:
179
180 CHANGE HISTORY: created mnnaraya 01/12/2000
181 ===========================================================================*/
182
183 PROCEDURE ReconcileDemand(
184 itemtype IN VARCHAR2,
185 itemkey IN VARCHAR2,
186 actid IN NUMBER,
187 funcmode IN VARCHAR2,
188 resultout OUT NOCOPY VARCHAR2);
189
190 /*===========================================================================
191 PROCEDURE NAME: PurgeInterface
192
193 DESCRIPTION: This procedure calls the PurgeInterface procedure
194
195 PARAMETERS: itemtype IN VARCHAR2,
196 itemkey IN VARCHAR2,
197 actid IN NUMBER,
198 funcmode IN VARCHAR2,
199 resultout OUT NOCOPY VARCHAR2`
200
201 DESIGN REFERENCES: rladphld.rtf
202
203 ALGORITHM:
204
205 NOTES:
206
207 OPEN ISSUES:
208
209 CLOSED ISSUES:
210
211 CHANGE HISTORY: created mnnaraya 01/12/2000
212 ===========================================================================*/
213
214 PROCEDURE PurgeInterface(
215 itemtype IN VARCHAR2,
216 itemkey IN VARCHAR2,
217 actid IN NUMBER,
218 funcmode IN VARCHAR2,
219 resultout OUT NOCOPY VARCHAR2);
220
221 /*===========================================================================
222 PROCEDURE NAME: RunReport
223
224 DESCRIPTION: This procedure calls the RunReport procedure
225
226 PARAMETERS: itemtype IN VARCHAR2,
227 itemkey IN VARCHAR2,
228 actid IN NUMBER,
229 funcmode IN VARCHAR2,
230 resultout OUT NOCOPY VARCHAR2`
231
232 DESIGN REFERENCES: rladphld.rtf
233
234 ALGORITHM:
235
236 NOTES:
237
238 OPEN ISSUES:
239
240 CLOSED ISSUES:
241
242 CHANGE HISTORY: created mnnaraya 01/12/2000
243 ===========================================================================*/
244
245 PROCEDURE RunReport(
246 itemtype IN VARCHAR2,
247 itemkey IN VARCHAR2,
248 actid IN NUMBER,
249 funcmode IN VARCHAR2,
250 resultout OUT NOCOPY VARCHAR2);
251
252 /*===========================================================================
253 PROCEDURE NAME: CheckErrors
254
255 DESCRIPTION: This procedure checks if errors exist for request_id.
256
257 PARAMETERS: itemtype IN VARCHAR2,
258 itemkey IN VARCHAR2,
259 actid IN NUMBER,
260 funcmode IN VARCHAR2,
261 resultout OUT NOCOPY VARCHAR2`
262
263 DESIGN REFERENCES: rladphld.rtf
264
265 ALGORITHM:
266
267 NOTES:
268
269 OPEN ISSUES:
270
271 CLOSED ISSUES:
272
273 CHANGE HISTORY: created mnnaraya 01/12/2000
274 ===========================================================================*/
275
276 PROCEDURE CheckErrors(
277 itemtype IN VARCHAR2,
278 itemkey IN VARCHAR2,
279 actid IN NUMBER,
280 funcmode IN VARCHAR2,
281 resultout OUT NOCOPY VARCHAR2);
282
283 /*===========================================================================
284 PROCEDURE NAME: GetScheduleDetails
285
286 DESCRIPTION: This procedure gets the schedule reference number and
287 customer name for given header id.
288
289 PARAMETERS: x_Header_Id IN NUMBER
290 x_Schedule_Num OUT NOCOPY VARCHAR2
291 x_Customer_Name OUT NOCOPY VARCHAR2
292 x_Schedule_Gen_Date OUT NOCOPY DATE
293
294 DESIGN REFERENCES: rladphld.rtf
295
296 ALGORITHM:
297
298 NOTES:
299
300 OPEN ISSUES:
301
302 CLOSED ISSUES:
303
304 CHANGE HISTORY: created mnnaraya 01/12/2000
305 Bug#: 3053299 - Added the argument (x_Schedule_Gen_Date) to
306 get Schedule Generation Date
307
308 ===========================================================================*/
309
310 PROCEDURE GetScheduleDetails( x_Header_Id IN NUMBER,
311 x_Schedule_Num OUT NOCOPY VARCHAR2,
312 x_Customer_Name OUT NOCOPY VARCHAR2,
313 x_Schedule_Gen_Date OUT NOCOPY DATE);
314
315 /*===========================================================================
316 PROCEDURE NAME: StartDSPLoop
317
318 DESCRIPTION: This procedure is called to start process DSPLOOP
319
320 PARAMETERS: errbuf OUT NOCOPY VARCHAR2,
321 retcode OUT NOCOPY VARCHAR2,
322 p_Header_Id IN NUMBER DEFAULT NULL
323 p_Line_Id IN NUMBER DEFAULT NULL
324 v_Sch_rec IN rlm_interface_headers%ROWTYPE;
325 v_Grp_rec IN rlm_dp_sv.t_Group_rec;
326
327
328 DESIGN REFERENCES: rladphld.rtf
329
330 ALGORITHM:
331
332 NOTES:
333
334 OPEN ISSUES:
335
336 CLOSED ISSUES:
337
338 CHANGE HISTORY: created bsadri 06/12/2000
339 ===========================================================================*/
340
341 PROCEDURE StartDSPLoop( errbuf OUT NOCOPY VARCHAR2,
342 retcode OUT NOCOPY VARCHAR2,
343 p_Header_Id IN NUMBER DEFAULT NULL,
344 p_Line_Id IN NUMBER DEFAULT NULL,
345 v_Sch_rec IN rlm_interface_headers%ROWTYPE,
346 v_Grp_rec IN rlm_dp_sv.t_Group_rec);
347
348
349
350 /*===========================================================================
351 PROCEDURE NAME: StartDSPLoop
352
353 DESCRIPTION: This procedure is called to create process DSPLOOP
354
355 PARAMETERS: errbuf OUT NOCOPY VARCHAR2,
356 retcode OUT NOCOPY VARCHAR2,
357 p_Header_Id IN NUMBER DEFAULT NULL
358 p_Line_Id IN NUMBER DEFAULT NULL
359
360
361 DESIGN REFERENCES: rladphld.rtf
362
363 ALGORITHM:
364
365 NOTES:
366
367 OPEN ISSUES:
368
369 CLOSED ISSUES:
370
371 CHANGE HISTORY: created bsadri 06/19/2000
372 ===========================================================================*/
373
374
375 PROCEDURE CreateDSPLoop( errbuf OUT NOCOPY VARCHAR2,
376 retcode OUT NOCOPY VARCHAR2,
377 p_Header_Id IN NUMBER DEFAULT NULL,
378 p_Line_Id IN NUMBER DEFAULT NULL);
379
380
381 /*===========================================================================
382 PROCEDURE NAME: UpdateHeaderPS
383
384 DESCRIPTION: This procedure calls rlm_dp_sv.updateHeaderPS.
385
386 PARAMETERS: itemtype IN VARCHAR2,
387 itemkey IN VARCHAR2,
388 actid IN NUMBER,
389 funcmode IN VARCHAR2,
390 resultout OUT NOCOPY VARCHAR2`
391
392 DESIGN REFERENCES: rladphld.rtf
393
394 ALGORITHM:
395
396 NOTES:
397
398 OPEN ISSUES:
399
400 CLOSED ISSUES:
401
402 CHANGE HISTORY: created bsadri 06/22/2000
403 ===========================================================================*/
404
405 PROCEDURE UpdateHeaderPS(
406 itemtype IN VARCHAR2,
407 itemkey IN VARCHAR2,
408 actid IN NUMBER,
409 funcmode IN VARCHAR2,
410 resultout OUT NOCOPY VARCHAR2);
411
412
413 /*===========================================================================
414 PROCEDURE NAME: ProcessGroupDemand
415
416 DESCRIPTION: This procedure calls managedemand, mange_forecast and
417 reconciel demand
418
419 PARAMETERS: itemtype IN VARCHAR2,
420 itemkey IN VARCHAR2,
421 actid IN NUMBER,
422 funcmode IN VARCHAR2,
423 resultout OUT NOCOPY VARCHAR2`
424
425 DESIGN REFERENCES: rladphld.rtf
426
427 ALGORITHM:
428
429 NOTES:
430
431 OPEN ISSUES:
432
433 CLOSED ISSUES:
434
435 CHANGE HISTORY: created bsadri 06/28/2000
436 ===========================================================================*/
437
438 PROCEDURE ProcessGroupDemand(
439 itemtype IN VARCHAR2,
440 itemkey IN VARCHAR2,
441 actid IN NUMBER,
442 funcmode IN VARCHAR2,
443 resultout OUT NOCOPY VARCHAR2);
444
445 /*===========================================================================
446 PROCEDURE NAME: CallProcessGroup
447
448 DESCRIPTION: This procedure calls Creates and starts
449 the child processes for ProcessGroup
450
451 PARAMETERS: itemtype IN VARCHAR2,
452 itemkey IN VARCHAR2,
453 actid IN NUMBER,
454 funcmode IN VARCHAR2,
455 resultout OUT NOCOPY VARCHAR2`
456
457 DESIGN REFERENCES: rladphld.rtf
458
459 ALGORITHM:
460
461 NOTES:
462
463 OPEN ISSUES:
464
465 CLOSED ISSUES:
466
467 CHANGE HISTORY: created bsadri 07/06/2000
468 ===========================================================================*/
469
470 PROCEDURE CallProcessGroup(
471 itemtype IN VARCHAR2,
472 itemkey IN VARCHAR2,
473 actid IN NUMBER,
474 funcmode IN VARCHAR2,
475 resultout OUT NOCOPY VARCHAR2);
476
477
478 /*===========================================================================
479 PROCEDURE NAME: ArchiveDemand
480
481 DESCRIPTION: This procedure archives the Demand
482
483 PARAMETERS: itemtype IN VARCHAR2,
484 itemkey IN VARCHAR2,
485 actid IN NUMBER,
486 funcmode IN VARCHAR2,
487 resultout OUT NOCOPY VARCHAR2`
488
489 DESIGN REFERENCES: rladphld.rtf
490
491 ALGORITHM:
492
493 NOTES:
494
495 OPEN ISSUES:
496
497 CLOSED ISSUES:
498
499 CHANGE HISTORY: created bsadri 07/06/2000
500 ===========================================================================*/
501
502 PROCEDURE ArchiveDemand(
503 itemtype IN VARCHAR2,
504 itemkey IN VARCHAR2,
505 actid IN NUMBER,
506 funcmode IN VARCHAR2,
507 resultout OUT NOCOPY VARCHAR2);
508
509
510
511 /*===========================================================================
512 PROCEDURE NAME: Testschedule
513
514 DESCRIPTION: This procedure checks if the schedule is a Test Schedule or
515 not.
516
517 PARAMETERS: itemtype IN VARCHAR2,
518 itemkey IN VARCHAR2,
519 actid IN NUMBER,
520 funcmode IN VARCHAR2,
521 resultout OUT VARCHAR2`
522
523 DESIGN REFERENCES: Bug 2554058
524
525 ALGORITHM:
526
527 NOTES:
528
529 OPEN ISSUES:
530
531 CLOSED ISSUES:
532
533 CHANGE HISTORY: created anviswan 22/10/2002
534 ===========================================================================*/
535
536 PROCEDURE Testschedule(
537 itemtype IN VARCHAR2,
538 itemkey IN VARCHAR2,
539 actid IN NUMBER,
540 funcmode IN VARCHAR2,
541 resultout OUT NOCOPY VARCHAR2);
542
543 /*===========================================================================
544
545 PROCEDURE NAME: PostValidate
546
547 DESCRIPTION: This procedure does post validation, which is done in
548 DSP wrapper.
549
550 PARAMETERS: itemtype IN VARCHAR2,
551 itemkey IN VARCHAR2,
552 actid IN NUMBER,
553 funcmode IN VARCHAR2,
554 resultout OUT NOCOPY VARCHAR2`
555
556 DESIGN REFERENCES: rladphld.rtf
557
558 ALGORITHM:
559
560 NOTES:
561
562 OPEN ISSUES:
563
564 CLOSED ISSUES:
565
566 CHANGE HISTORY: created bsadri 07/10/2000
567 ===========================================================================*/
568
569 PROCEDURE PostValidate(
570 itemtype IN VARCHAR2,
571 itemkey IN VARCHAR2,
572 actid IN NUMBER,
573 funcmode IN VARCHAR2,
574 resultout OUT NOCOPY VARCHAR2);
575
576
577 /*===========================================================================
578 PROCEDURE NAME: CheckStatus
579
580 DESCRIPTION: This procedure checks if errors exist for request_id.
581
582 PARAMETERS: itemtype IN VARCHAR2,
583 itemkey IN VARCHAR2,
584 actid IN NUMBER,
585 funcmode IN VARCHAR2,
586 resultout OUT NOCOPY VARCHAR2`
587
588 DESIGN REFERENCES: rladphld.rtf
589
590 ALGORITHM:
591
592 NOTES:
593
594 OPEN ISSUES:
595
596 CLOSED ISSUES:
597
598 CHANGE HISTORY: created bsadri 07/19/2000
599 ===========================================================================*/
600
601 PROCEDURE CheckStatus(
602 itemtype IN VARCHAR2,
603 itemkey IN VARCHAR2,
604 actid IN NUMBER,
605 funcmode IN VARCHAR2,
606 resultout OUT NOCOPY VARCHAR2);
607
608 -- Bug#: 3291401
609
610 /*===========================================================================
611 PROCEDURE NAME: GetScheduleStatus
612
613 DESCRIPTION: This procedure checks for the schedule status.
614
615 PARAMETERS: itemtype IN VARCHAR2,
616 itemkey IN VARCHAR2,
617 actid IN NUMBER,
618 funcmode IN VARCHAR2,
619 resultout OUT NOCOPY VARCHAR2`
620
621 CHANGE HISTORY: created vxsharma 12/08/2000
622 ===========================================================================*/
623
624 PROCEDURE GetScheduleStatus(
625 itemtype IN VARCHAR2,
626 itemkey IN VARCHAR2,
627 actid IN NUMBER,
628 funcmode IN VARCHAR2,
629 resultout OUT NOCOPY VARCHAR2);
630
631
632 END RLM_WF_SV;