DBA Data[Home] [Help]

APPS.OTA_INITIALIZATION_WF dependencies on WF_ITEMS

Line 271: p_item_type in wf_items.item_type%type,

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,

Line 272: p_item_key in wf_items.item_key%type);

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,

Line 292: p_item_type in wf_items.item_type%type,

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);

Line 305: p_item_type in wf_items.item_type%type,

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,

Line 320: p_item_type in wf_items.item_type%type,

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,

Line 324: Procedure Init_LP_wf(p_item_type in wf_items.item_type%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,

Line 331: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,

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: );

Line 332: p_item_key in wf_items.item_key%type,

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:

Line 342: Procedure initialize_cert_ntf_wf(p_item_type in wf_items.item_type%type,

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);

Line 366: procedure get_course_eval_status ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

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 );

Line 367: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

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,

Line 376: procedure get_course_eval_del_mode ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

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 );

Line 377: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

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: