[Home] [Help]
PACKAGE: APPS.OTA_WF
Source
1 Package ota_wf AUTHID CURRENT_USER as
2 /* $Header: ottomiwf.pkh 120.0.12020000.4 2012/10/12 10:31:03 jaysridh ship $ */
3
4
5
6 -- ----------------------------------------------------------------------------
7 -- |---------------------------------< CANCEL_ORDER >-------------------------|
8 -- ----------------------------------------------------------------------------
9 -- {Start Of Comments}
10 --
11 -- Description:
12 -- This procedure will be use to cancel an order.
13 --
14 --
15 -- Pre Conditions:
16 -- None.
17 --
18 -- In Arguments:
19 -- itemtype,
20 -- itemkey
21 --
22 -- Post Success:
23 -- Processing continues.
24 --
25 --
26 -- Post Failure:
27 -- None.
28 --
29 -- Access Status:
30 -- Public.
31 --
32 -- {End Of Comments}
33 ----------------------------------------------------------------------------
34
35 PROCEDURE CANCEL_ORDER (
36 itemtype IN VARCHAR2
37 ,itemkey IN VARCHAR2
38 ,actid IN NUMBER
39 ,funcmode IN VARCHAR2
40 ,resultout OUT NOCOPY VARCHAR2
41
42 );
43
44
45 -- ----------------------------------------------------------------------------
46 -- |---------------------------------< CREATE_RMA >----------------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start Of Comments}
49 --
50 -- Description:
51 -- This procedure will be used to create RMA.
52 --
53 --
54 -- Pre Conditions:
55 -- None.
56 --
57 -- In Arguments:
58 -- itemtype,
59 -- itemkey
60 --
61 -- Post Success:
62 -- Processing continues.
63 --
64 --
65 -- Post Failure:
66 -- None.
67 --
68 -- Access Status:
69 -- Public.
70 --
71 -- {End Of Comments}
72 ----------------------------------------------------------------------------
73
74 PROCEDURE CREATE_RMA (
75 itemtype IN VARCHAR2
76 ,itemkey IN VARCHAR2
77 ,actid IN NUMBER
78 ,funcmode IN VARCHAR2
79 ,resultout OUT NOCOPY VARCHAR2
80 );
81 -- ----------------------------------------------------------------------------
82 -- |--------------------------< UPDATE_FULFILL_DATE >-------------------------|
83 -- ----------------------------------------------------------------------------
84 -- {Start Of Comments}
85 --
86 -- Description:
87 -- This procedure will be used to update Order Line Fulfillment Date.
88 --
89 --
90 -- Pre Conditions:
91 -- None.
92 --
93 -- In Arguments:
94 -- itemtype,
95 -- itemkey
96 --
97 -- Post Success:
98 -- Processing continues.
99 --
100 --
101 -- Post Failure:
102 -- None.
103 --
104 -- Access Status:
105 -- Public.
106 --
107 -- {End Of Comments}
108 ----------------------------------------------------------------------------
109 PROCEDURE UPDATE_FULFILL_DATE (
110 itemtype IN VARCHAR2
111 ,itemkey IN VARCHAR2
112 ,actid IN NUMBER
113 ,funcmode IN VARCHAR2
114 ,resultout OUT NOCOPY VARCHAR2
115
116 );
117
118 -- ----------------------------------------------------------------------------
119 -- |----------------------------< CHK_INVOICE_EXISTS >-------------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 -- This procedure will be used to check whethet the Order Line has been
125 -- invoiced or not.
126 --
127 --
128 -- Pre Conditions:
129 -- None.
130 --
131 -- In Arguments:
132 -- itemtype,
133 -- itemkey
134 --
135 -- Out Arguments:
136 -- resultout
137 --
138 --
139 -- Post Success:
140 -- Processing continues.
141 --
142 --
143 -- Post Failure:
144 -- None.
145 --
146 -- Access Status:
147 -- Public.
148 --
149 -- {End Of Comments}
150 ----------------------------------------------------------------------------
151
152 PROCEDURE CHK_INVOICE_EXISTS (
153 itemtype IN VARCHAR2
154 ,itemkey IN VARCHAR2
155 ,actid IN NUMBER
156 ,funcmode IN VARCHAR2
157 ,resultout OUT NOCOPY VARCHAR2
158 );
159
160 -- ----------------------------------------------------------------------------
161 -- |------------------------------------< CHECK_UOM>-------------------------|
162 -- ----------------------------------------------------------------------------
163 -- {Start Of Comments}
164 --
165 -- Description:
166 -- This procedure will be used to check the uom of the order line.
167 -- It will be called by the workflow activity.
168 --
169 --
170 -- Pre Conditions:
171 -- None.
172 --
173 -- In Arguments:
174 -- itemtype,
175 -- itemkey
176 -- Out Arguments:
177 -- resultout
178 --
179 -- Post Success:
180 -- Processing continues.
181 --
182 --
183 -- Post Failure:
184 -- None.
185 --
186 -- Access Status:
187 -- Public.
188 --
189 -- {End Of Comments}
190 ----------------------------------------------------------------------------
191 PROCEDURE CHECK_UOM(
192 Itemtype IN VARCHAR2
193 ,Itemkey IN VARCHAR2
194 ,actid IN NUMBER
195 ,funcmode IN VARCHAR2
196 ,resultout OUT NOCOPY VARCHAR2
197 );
198
199 -- ----------------------------------------------------------------------------
200 -- |------------------------------------< CHECK_CREATION>------------------|
201 -- ----------------------------------------------------------------------------
202 -- {Start Of Comments}
203 --
204 -- Description:
205 -- This procedure will be a concurrent process which run in the background.
206 --
207 -- This procedure will only be used for OTA and OM integration. Basically this
208 -- procedure will select all delegate booking data that has daemon_flag='Y' and
209 -- Daemon_type is not nul. If the enrollment got canceled and there is a
210 -- waitlisted student then the automatic waitlist processing will be called.
211 --
212 -- Pre Conditions:
213 -- None.
214 --
215 -- In Arguments:
216 -- p_user_id,
217 -- p_login_id
218 --
219 -- Post Success:
220 -- Processing continues.
221 --
222 --
223 -- Post Failure:
224 -- None.
225 --
226 -- Access Status:
227 -- Public.
228 --
229 -- {End Of Comments}
230 ----------------------------------------------------------------------------
231 PROCEDURE CHECK_CREATION(
232 Itemtype IN VARCHAR2
233 ,Itemkey IN VARCHAR2
234 ,actid IN NUMBER
235 ,funcmode IN VARCHAR2
236 ,resultout OUT NOCOPY VARCHAR2
237 );
238
239 -- ----------------------------------------------------------------------------
240 -- |------------------------< CHK_ENROLL_STATUS_ADV >-------------------------|
241 -- ----------------------------------------------------------------------------
242 -- {Start Of Comments}
243 --
244 -- Description:
245 -- This procedure will be used to check the status of the Enrollment.
246 -- It will be called by the workflow activity.
247 --
248 --
249 -- Pre Conditions:
250 -- None.
251 --
252 -- In Arguments:
253 -- itemtype,
254 -- itemkey
255 -- Out Arguments:
256 -- resultout
257 --
258 -- Post Success:
259 -- Processing continues.
260 --
261 --
262 -- Post Failure:
263 -- None.
264 --
265 -- Access Status:
266 -- Public.
267 --
268 -- {End Of Comments}
269 ----------------------------------------------------------------------------
270
271 PROCEDURE CHK_ENROLL_STATUS_ADV (
272 Itemtype IN VARCHAR2
273 ,Itemkey IN VARCHAR2
274 ,actid IN NUMBER
275 ,funcmode IN VARCHAR2
276 ,resultout OUT NOCOPY VARCHAR2) ;
277 --
278 -- ----------------------------------------------------------------------------
279 -- |------------------------< CHK_ENROLL_STATUS_ARR >-------------------------|
280 -- ----------------------------------------------------------------------------
281 -- {Start Of Comments}
282 --
283 -- Description:
284 -- This procedure will be used to check the Status for Enrollment.This is for
285 -- Invoicing Rule in arrear.
286 -- It will be called by the workflow activity.
287 --
288 --
289 -- Pre Conditions:
290 -- None.
291 --
292 -- In Arguments:
293 -- itemtype,
294 -- itemkey
295 -- Out Arguments:
296 -- resultout
297 --
298 -- Post Success:
299 -- Processing continues.
300 --
301 --
302 -- Post Failure:
303 -- None.
304 --
305 -- Access Status:
306 -- Public.
307 --
308 -- {End Of Comments}
309 ----------------------------------------------------------------------------
310 PROCEDURE CHK_ENROLL_STATUS_ARR (
311 Itemtype IN VARCHAR2
312 ,Itemkey IN VARCHAR2
313 ,actid IN NUMBER
314 ,funcmode IN VARCHAR2
315 ,resultout OUT NOCOPY VARCHAR2);
316
317 --
318 -- ----------------------------------------------------------------------------
319 -- |----------------------------< CHECK_INVOICE_RULE >--------------------------|
320 -- ----------------------------------------------------------------------------
321 -- {Start Of Comments}
322 --
323 -- Description:
324 -- This procedure will be used to check invoicing rule of the order line.
325 -- It will be called by the workflow activity.
326 --
327 --
328 -- Pre Conditions:
329 -- None.
330 --
331 -- In Arguments:
332 -- itemtype,
333 -- itemkey
334 --
335 -- Out Arguments:
336 -- resultout
337 --
338 -- Post Success:
339 -- Processing continues.
340 --
341 --
342 -- Post Failure:
343 -- None.
344 --
345 -- Access Status:
346 -- Public.
347 --
348 -- {End Of Comments}
349 ----------------------------------------------------------------------------
350
351 PROCEDURE CHECK_INVOICE_RULE (
352 Itemtype IN VARCHAR2
353 ,Itemkey IN VARCHAR2
354 ,actid IN NUMBER
355 ,funcmode IN VARCHAR2
356 ,resultout OUT NOCOPY VARCHAR2);
357
358
359 -- ----------------------------------------------------------------------------
360 -- |----------------------------< CANCEL_ENROLLMENT>--------------------------|
361 -- ----------------------------------------------------------------------------
362 -- {Start Of Comments}
363 --
364 -- Description:
365 -- This procedure will be used to cancel an enrollment.
366 --
367 --
368 -- Pre Conditions:
369 -- None.
370 --
371 -- In Arguments:
372 -- itemtype,
373 -- itemkey
374 -- actid
375 -- funcmode
376 --
377 -- Out Arguments:
378 -- resultout
379 --
380 -- Post Success:
381 -- Processing continues.
382 --
383 --
384 -- Post Failure:
385 -- None.
386 --
387 -- Access Status:
388 -- Public.
389 --
390 -- {End Of Comments}
391 ----------------------------------------------------------------------------
392
393 PROCEDURE CANCEL_ENROLLMENT(
394 Itemtype IN VARCHAR2
395 ,Itemkey IN VARCHAR2
396 ,actid IN NUMBER
397 ,funcmode IN VARCHAR2
398 ,resultout OUT NOCOPY VARCHAR2);
399
400
401 --
402 -- ----------------------------------------------------------------------------
403 -- |-------------------------< UPDATE_OWNER_EMAIL >--------------------------|
404 -- ----------------------------------------------------------------------------
405 -- {Start Of Comments}
406 --
407 -- Description:
408 -- This procedure will be used to check the invoicing rule of the order line.
409 -- It will be called by the workflow activity.
410 --
411 --
412 -- Pre Conditions:
413 -- None.
414 --
415 -- IN
416 -- itemtype - type of the current item
417 -- itemkey - key of the current item
418 -- actid - process activity instance id
419 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
420 -- OUT
421 -- result
422 -- - COMPLETE[:<result>]
423 -- activity has completed with the indicated result
424 -- - WAITING
425 -- activity is waiting for additional transitions
426 -- - DEFERED
427 -- execution should be defered to background
428 -- - NOTIFIED[:<notification_id>:<assigned_user>]
429 -- activity has notified an external entity that this
430 -- step must be performed. A call to wf_engine.CompleteActivty
431 -- will signal when this step is complete. Optional
432 -- return of notification ID and assigned user.
433 -- - ERROR[:<error_code>]
434 -- function encountered an err--
435 --
436 --
437 -- Post Success:
438 -- Processing continues.
439 --
440 --
441 -- Post Failure:
442 -- None.
443 --
444 -- Access Status:
445 -- Public.
446 --
447 -- {End Of Comments}
448 ----------------------------------------------------------------------------
449
450 PROCEDURE UPDATE_OWNER_EMAIL (
451 Itemtype IN VARCHAR2
452 ,Itemkey IN VARCHAR2
453 ,actid IN NUMBER
454 ,funcmode IN VARCHAR2
455 ,resultout OUT NOCOPY VARCHAR2);
456
457
458 -- ----------------------------------------------------------------------------
459 -- |------------------------< CHK_EVENT_ENROLL_STATUS >-----------------------|
460 -- ----------------------------------------------------------------------------
461 -- {Start Of Comments}
462 --
463 -- Description:
464 -- This procedure will be used to check the Status for Enrollment.This is for
465 -- Invoicing Rule in arrear.
466 -- It will be called by the workflow activity.
467 --
468 --
469 -- Pre Conditions:
470 -- None.
471 --
472 -- In Arguments:
473 -- itemtype,
474 -- itemkey
475 -- Out Arguments:
476 -- resultout
477 --
478 -- Post Success:
479 -- Processing continues.
480 --
481 --
482 -- Post Failure:
483 -- None.
484 --
485 -- Access Status:
486 -- Public.
487 --
488 -- {End Of Comments}
489 ----------------------------------------------------------------------------
490 PROCEDURE CHK_EVENT_ENROLL_STATUS (
491 Itemtype IN VARCHAR2
492 ,Itemkey IN VARCHAR2
493 ,actid IN NUMBER
494 ,funcmode IN VARCHAR2
495 ,resultout OUT NOCOPY VARCHAR2);
496
497
498 -- ----------------------------------------------------------------------------
499 -- |------------------------< SEND_NOTIFICATION >-----------------------|
500 -- ----------------------------------------------------------------------------
501 -- {Start Of Comments}
502 --
503 -- Description:
504 -- This procedure is used to send email notifications to the email ids
505 -- specified in the argument.
506 --
507 --
508 -- Pre Conditions:
509 -- None.
510 --
511 -- In Arguments:
512 -- p_email_addresses
513 -- p_person_ids
514 -- p_subject
515 -- p_html_body
516 -- p_text_body
517 -- p_from_role
518 -- Out Arguments:
519 -- None
520 --
521 -- Post Success:
522 -- Processing continues.
523 --
524 --
525 -- Post Failure:
526 -- None.
527 --
528 -- Access Status:
529 -- Public.
530 --
531 -- {End Of Comments}
532 ----------------------------------------------------------------------------
533 PROCEDURE send_notification
534 ( p_email_addresses IN varchar2
535 , p_person_ids IN varchar2
536 , p_subject IN varchar2
537 , p_html_body IN varchar2 DEFAULT null
538 , p_text_body IN varchar2 DEFAULT null
539 , p_from_role IN varchar2 DEFAULT null
540 );
541
542 -- ----------------------------------------------------------------------------
543 -- |------------------------< SEND_NOTIFICATION >-----------------------|
544 -- ----------------------------------------------------------------------------
545 -- {Start Of Comments}
546 --
547 -- Description:
548 -- This function is used to send email notifications to the
549 -- the user name specified in the argument.
550 --
551 --
552 -- Pre Conditions:
553 -- None.
554 --
555 -- In Arguments:
556 -- p_user_name
557 -- p_subject
558 -- p_html_body
559 -- p_text_body
560 -- p_from_role
561 -- Out Arguments:
562 -- Notification id
563 --
564 -- Post Success:
565 -- Processing continues.
566 --
567 --
568 -- Post Failure:
569 -- None.
570 --
571 -- Access Status:
572 -- Public.
573 --
574 -- {End Of Comments}
575 ----------------------------------------------------------------------------
576 FUNCTION send_notification
577 ( p_user_name IN varchar2
578 , p_subject IN varchar2
579 , p_html_body IN varchar2 DEFAULT null
580 , p_text_body IN varchar2 DEFAULT null
581 , p_from_role IN varchar2 DEFAULT null
582 ) return number;
583
584 -- ----------------------------------------------------------------------------
585 -- |------------------< get_doc >---------------------------------------------|
586 -- ----------------------------------------------------------------------------
587 -- {Start Of Comments}
588 --
589 -- Description:
590 -- This procedure is called from the attribute OTA_DOCUMENT_1
591 -- to OTA_DOCUMENT_8 which is of type Document. This attribute
592 -- is present in message OTA_TEXT_HTML_MSG
593 --
594 -- Pre Conditions:
595 -- None.
596 --
597 -- In Parameters:
598 -- document_id VARCHAR2 A string that uniquely identifies a document.
599 -- display_type VARCHAR2 Display type for the document.
600 -- document VARCHAR2 The outbound text buffer where up to 32K
601 -- of document text is returned.
602 -- document_type VARCHAR2 The outbound text buffer where the document
603 -- content type is returned
604 -- Post Success:
605 -- The value in the attribute HTML_BODY_1 to HTML_BODY_8 will be set
606 -- to OTA_DOCUMENT_1 to OTA_DOCUMENT_8
607 --
608 -- Post Failure:
609 -- None.
610 --
611 -- Developer Implementation Notes:
612 -- Note:
613 --
614 -- Access Status:
615 -- Internal HRMS Development
616 --
617 -- {End Of Comments}
618 procedure get_doc (document_id in varchar2
619 ,display_type in varchar2
620 ,document in out nocopy varchar2
621 ,document_type in out nocopy varchar2);
622
623 end ota_wf;