[Home] [Help]
PACKAGE: APPS.OTA_INITIALIZATION_WF
Source
1 Package ota_initialization_wf AUTHID CURRENT_USER as
2 /* $Header: ottomint.pkh 120.30 2010/05/25 05:37:48 shwnayak ship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |-------------------< INITIALIZE_CANCEL_ENROLLMENT >-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure will be used to initialize workflow for Enrollment cancellation.
11 --
12 --
13 -- Pre Conditions:
14 -- None.
15 --
16 -- In Arguments:
17 -- p_booking_id
18 -- p_Line_id
19 -- p_org_id
20 -- p_Status
21 -- p_Event_id
22 -- p_Itemtype
23 --
24 -- Post Success:
25 -- Processing continues.
26 --
27 --
28 -- Post Failure:
29 -- None.
30 --
31 -- Access Status:
32 -- Public.
33 --
34 -- {End Of Comments}
35 ----------------------------------------------------------------------------
36
37 PROCEDURE INITIALIZE_CANCEL_ENROLLMENT
38 (
39 p_booking_id IN NUMBER,
40 p_Line_id IN NUMBER,
41 p_org_id IN NUMBER,
42 p_Status IN VARCHAR2,
43 p_Event_id IN NUMBER,
44 p_Itemtype IN VARCHAR2,
45 p_process IN VARCHAR2);
46
47 -- ----------------------------------------------------------------------------
48 -- |---------------------< INITIALIZE_CANCEL_EVENT >-------------------------|
49 -- ----------------------------------------------------------------------------
50 -- {Start Of Comments}
51 --
52 -- Description:
53 -- This procedure will be used to initialize workflow for Event Cancelation.
54 --
55 --
56 -- Pre Conditions:
57 -- None.
58 --
59 -- In Arguments:
60 -- p_event_id
61 -- p_Line_id
62 -- p_Status
63 -- p_Event_title
64 -- p_owner_id
65 --
66 -- Post Success:
67 -- Processing continues.
68 --
69 --
70 -- Post Failure:
71 -- None.
72 --
73 -- Access Status:
74 -- Public.
75 --
76 -- {End Of Comments}
77 ----------------------------------------------------------------------------
78 Procedure INITIALIZE_CANCEL_EVENT
79 (
80 p_event_id IN NUMBER,
81 p_Line_id IN NUMBER,
82 p_Status IN VARCHAR2,
83 p_Event_title IN VARCHAR2 ,
84 p_owner_id IN NUMBER,
85 p_org_id IN NUMBER,
86 p_itemtype IN VARCHAR2
87 );
88
89 -- ----------------------------------------------------------------------------
90 -- |------------------< INITIALIZE_EVENT_DATE_CHANGED>-------------------------|
91 -- ----------------------------------------------------------------------------
92 -- {Start Of Comments}
93 --
94 -- Description:
95 -- This procedure will be used to initialize workflow if when event date changed.
96 --
97 --
98 -- Pre Conditions:
99 -- None.
100 --
101 -- In Arguments:
102 -- p_Line_id
103 -- p_org_id
104 -- p_Event_title
105 -- p_Itemtype
106 -- p_process
107 -- p_emailid
108 -- p_name
109 --
110 -- Post Success:
111 -- Processing continues.
112 --
113 --
114 -- Post Failure:
115 -- None.
116 --
117 -- Access Status:
118 -- Public.
119 --
120 -- {End Of Comments}
121 ----------------------------------------------------------------------------
122
123 PROCEDURE INITIALIZE_EVENT_DATE_CHANGED
124 (
125 p_Line_id IN NUMBER,
126 p_org_id IN NUMBER,
127 p_Event_title IN VARCHAR2,
128 p_Itemtype IN VARCHAR2,
129 p_process IN VARCHAR2,
130 p_emailid IN VARCHAR2,
131 p_name IN VARCHAR2);
132
133 -- ----------------------------------------------------------------------------
134 -- |----------------------< initialize_cancel_order >-------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start Of Comments}
137 --
138 -- Description:
139 -- This procedure will be used to start a workflow if order got cancel from OM.
140 --
141 -- This procedure will only be used for OTA and OM integration.
142 --
143 -- Pre Conditions:
144 -- None.
145 --
146 -- In Arguments:
147 -- p_itemtype
148 -- p_process
149 -- p_Event_title
150 -- p_event_id
151 -- p_email_address
152 -- p_line_id
153 -- p_status
154 -- p_full_name
155 --
156 -- Post Success:
157 -- Processing continues.
158 --
159 --
160 -- Post Failure:
161 -- None.
162 --
163 -- Access Status:
164 -- Public.
165 --
166 -- {End Of Comments}
167 ----------------------------------------------------------------------------
168
169
170 PROCEDURE INITIALIZE_CANCEL_ORDER (
171 p_itemtype IN VARCHAR2,
172 p_process IN VARCHAR2,
173 p_Event_title IN VARCHAR2,
174 p_event_id IN NUMBER,
175 p_user_name IN VARCHAR2,
176 p_line_id IN NUMBER,
177 p_status IN VARCHAR2,
178 p_full_name IN VARCHAR2
179
180 ) ;
181
182
183 -- ----------------------------------------------------------------------------
184 -- |-----------------------------< Manual_waitlist >-------------------------|
185 -- ----------------------------------------------------------------------------
186 -- {Start Of Comments}
187 --
188 -- Description:
189 -- This procedure will be used to start a workflow to notify event owner to
190 -- do manual waitlist enrollment .
191 --
192 --
193 -- Pre Conditions:
194 -- None.
195 --
196 -- In Arguments:
197 -- p_itemtype
198 -- p_process
199 -- p_Event_title
200 -- p_event_id
201 -- p_user_name
202 --
203 -- Post Success:
204 -- Processing continues.
205 --
206 --
207 -- Post Failure:
208 -- None.
209 --
210 -- Access Status:
211 -- Public.
212 --
213 -- {End Of Comments}
214 ----------------------------------------------------------------------------
215
216
217 PROCEDURE MANUAL_WAITLIST (
218 p_itemtype IN VARCHAR2,
219 p_process IN VARCHAR2,
220 p_Event_title IN VARCHAR2,
221 p_event_id IN NUMBER,
222 p_item_key IN VARCHAR2,
223 p_user_name IN VARCHAR2
224 ) ;
225
226 -- ----------------------------------------------------------------------------
227 -- |----------------------< Manual_enroll_waitlist >-------------------------|
228 -- ----------------------------------------------------------------------------
229 -- {Start Of Comments}
230 --
231 -- Description:
232 -- This procedure will be used to start a workflow to notify event owner to
233 -- do manual waitlist enrollment .
234 --
235 --
236 -- Pre Conditions:
237 -- None.
238 --
239 -- In Arguments:
240 -- p_itemtype
241 -- p_process
242 -- p_Event_title
243 -- p_event_id
244 -- p_user_name
245 --
246 -- Post Success:
247 -- Processing continues.
248 --
249 --
250 -- Post Failure:
251 -- None.
252 --
253 -- Access Status:
254 -- Public.
255 --
256 -- {End Of Comments}
257 ----------------------------------------------------------------------------
258
259 PROCEDURE MANUAL_ENROLL_WAITLIST (
260 p_itemtype IN VARCHAR2,
261 p_process IN VARCHAR2,
262 p_Event_title IN VARCHAR2,
263 p_item_key IN VARCHAR2,
264 p_owner_id IN NUMBER
265 ) ;
266
267 -- ----------------------------------------------------------------------------
268 -- |----------------------< set_wf_item_attr >-------------------------|
269 -- ----------------------------------------------------------------------------
270 procedure set_wf_item_attr(p_person_id in number,
271 p_item_type in wf_items.item_type%type,
272 p_item_key in wf_items.item_key%type);
273
274
275 Procedure get_event_fired(itemtype in varchar2,
276 itemkey in varchar2,
277 actid in number,
278 funcmode in varchar2,
279 resultout out nocopy varchar2);
280 -- ----------------------------------------------------------------------------
281 -- |----------------------< Initialize_wf >-------------------------|
282 -- ----------------------------------------------------------------------------
283
284 -- this wf would be used for OTA_ENROLL_STATUS_CHNG_JSP_PRC
285 -- AND OTA_CLASS_CANCEL_JSP_PRC
286 --gets called from ota_evt_upd.upd for class rescheduling or location change
287 --called from alert
288 -- called from ota_evt_api_upd2.process_event
289 --from ota_tdb_api_upd2.update_enrollment
290
291 Procedure Initialize_wf(p_process in wf_process_activities.process_name%type,
292 p_item_type in wf_items.item_type%type,
293 p_person_id in number default null,
294 -- p_booking_id in ota_delegate_bookings.Booking_id%type default null,
295 p_eventid in ota_Events.event_id%type,
296 p_event_fired in varchar2);
297
298 --gets called from ota_evt_upd.upd for class rescheduling or location change
299 -- called from ota_evt_api_upd2.update_event
300 --alert
301 --ota_resource_bookings_api.create/update_resource_booking
302 -- --ota_resource_bookings_api.delete_resource_booking
303
304 Procedure Initialize_instructor_wf(
305 p_item_type in wf_items.item_type%type,
306 p_eventid in ota_events.event_id%type,
307 p_sup_res_id in ota_resource_bookings.supplied_resource_id%type default null,
308 p_start_date in varchar2 default null,
309 p_end_date in varchar2 default null,
310 p_start_time in ota_events.course_start_time%type default null,
311 p_end_time in ota_events.course_start_time%type default null,
312 p_status in varchar2 default null,
313 p_res_book_id in ota_resource_bookings.resource_booking_id%type default null,
314 p_person_id in number default null,
315 p_event_fired in varchar2);
316
317 -- called from alerts
318
319 Procedure Initialize_auto_wf(p_process in wf_process_activities.process_name%type,
320 p_item_type in wf_items.item_type%type,
321 p_event_fired in varchar2,
322 p_event_id in ota_events.event_id%type default null);
323 -- called from ota_lp_enrollment_api.update/create_lp_enrollment
324 Procedure Init_LP_wf(p_item_type in wf_items.item_type%type,
325 p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type,
326 p_event_fired in varchar2);
327
328 procedure init_assessment_wf(p_person_id in number,
329 p_attempt_id in varchar2);
330
331 Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
332 p_item_key in wf_items.item_key%type,
333 p_eventid in ota_events.event_id%type,
334 p_from in varchar2 default null
335 );
336
337 -- ----------------------------------------------------------------------------
338 -- |----------------------< initialize_cert_ntf_wf >-------------------------|
339 -- ----------------------------------------------------------------------------
340 -- This wf would be used for OTA_CERTIFICATION_NTF_JSP_PRC
341 -- Called from alert
342 Procedure initialize_cert_ntf_wf(p_item_type in wf_items.item_type%type,
343 p_person_id in number default null,
344 p_certification_id in ota_certifications_b.certification_id%type,
345 p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
346 p_cert_ntf_type in varchar2);
347
348 Procedure process_cert_alert(
349 ERRBUF OUT NOCOPY VARCHAR2,
350 RETCODE OUT NOCOPY VARCHAR2,
351 p_cert_ntf_type in varchar2);
352
353 Procedure init_forum_notif(p_Forum_id in ota_forum_messages.forum_id%type,
354 p_Forum_message_id in ota_forum_messages.forum_message_id%type);
355
356 Procedure send_event_beginning_ntf(
357 ERRBUF OUT NOCOPY VARCHAR2,
358 RETCODE OUT NOCOPY VARCHAR2) ;
359
360 Procedure send_instructor_reminder_ntf(
361 ERRBUF OUT NOCOPY VARCHAR2,
362 RETCODE OUT NOCOPY VARCHAR2);
363
364 procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type);
365
366 procedure get_course_eval_status ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
367 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
368 actid IN NUMBER,
369 funcmode IN VARCHAR2,
370 resultout OUT nocopy VARCHAR2 );
371 procedure get_class_name(document_id in varchar2,
372 display_type in varchar2,
373 document in out nocopy varchar2,
374 document_type in out nocopy varchar2);
375
376 procedure get_course_eval_del_mode ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
377 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
378 actid IN NUMBER,
379 funcmode IN VARCHAR2,
380 resultout OUT nocopy VARCHAR2 );
381
382
383 procedure RAISE_BUSINESS_EVENT(
384 p_eventid in ota_Events.event_id%type,
385 p_event_fired in varchar2,
386 p_type in varchar2 default null);
387
388 end ota_initialization_wf;