APPS.OTA_LRNR_ENROLL_UNENROLL_WF dependencies on WF_ITEMS

Line 7: p_itemtype in wf_items.item_type%type,

3:
4: g_package VARCHAR2(33) := 'OTA_LRNR_ENROLL_UNENROLL_WF';
5:
6: Procedure Cert_Enrollment(p_process in wf_process_activities.process_name%type,
7: p_itemtype in wf_items.item_type%type,
8: p_person_id in number ,
9: p_certificationid in ota_certifications_b.certification_id%type)
10:
11: is

Line 14: l_item_type wf_items.item_type%type := upper(p_itemtype);

10:
11: is
12: l_proc varchar2(72) := g_package||'Cert_Enrollment';
13: l_process wf_activities.name%type := upper(p_process);
14: l_item_type wf_items.item_type%type := upper(p_itemtype);
15: l_item_key wf_items.item_key%type;
16:
17:
18: l_cert_name ota_certifications_tl.name%type;

Line 15: l_item_key wf_items.item_key%type;

11: is
12: l_proc varchar2(72) := g_package||'Cert_Enrollment';
13: l_process wf_activities.name%type := upper(p_process);
14: l_item_type wf_items.item_type%type := upper(p_itemtype);
15: l_item_key wf_items.item_key%type;
16:
17:
18: l_cert_name ota_certifications_tl.name%type;
19: l_cert_comp_date ota_certifications_b.initial_completion_date%type;

Line 136: p_itemtype in wf_items.item_type%type,

132: end Cert_Enrollment;
133:
134:
135: Procedure Learner_Enrollment(p_process in wf_process_activities.process_name%type,
136: p_itemtype in wf_items.item_type%type,
137: p_person_id in number ,
138: p_eventid in ota_Events.event_id%type,
139: p_booking_id in number)
140: is

Line 143: l_item_type wf_items.item_type%type := upper(p_itemtype);

139: p_booking_id in number)
140: is
141: l_proc varchar2(72) := g_package||'Learner_Enrollment';
142: l_process wf_activities.name%type := upper(p_process);
143: l_item_type wf_items.item_type%type := upper(p_itemtype);
144: l_item_key wf_items.item_key%type;
145:
146: /*l_supervisor_id per_all_people_f.person_id%Type;
147: l_supervisor_username fnd_user.user_name%TYPE;

Line 144: l_item_key wf_items.item_key%type;

140: is
141: l_proc varchar2(72) := g_package||'Learner_Enrollment';
142: l_process wf_activities.name%type := upper(p_process);
143: l_item_type wf_items.item_type%type := upper(p_itemtype);
144: l_item_key wf_items.item_key%type;
145:
146: /*l_supervisor_id per_all_people_f.person_id%Type;
147: l_supervisor_username fnd_user.user_name%TYPE;
148: l_supervisor_full_name per_all_people_f.full_name%TYPE;

Line 344: p_itemtype in wf_items.item_type%type,

340:
341:
342:
343: Procedure Learner_UnEnrollment(p_process in wf_process_activities.process_name%type,
344: p_itemtype in wf_items.item_type%type,
345: p_person_id in number ,
346: p_eventid in ota_Events.event_id%type)
347:
348: is

Line 351: l_item_type wf_items.item_type%type := upper(p_itemtype);

347:
348: is
349: l_proc varchar2(72) := g_package||'Learner_UnEnrollment';
350: l_process wf_activities.name%type := upper(p_process);
351: l_item_type wf_items.item_type%type := upper(p_itemtype);
352: l_item_key wf_items.item_key%type;
353:
354:
355: l_event_title ota_events.title%type;

Line 352: l_item_key wf_items.item_key%type;

348: is
349: l_proc varchar2(72) := g_package||'Learner_UnEnrollment';
350: l_process wf_activities.name%type := upper(p_process);
351: l_item_type wf_items.item_type%type := upper(p_itemtype);
352: l_item_key wf_items.item_key%type;
353:
354:
355: l_event_title ota_events.title%type;
356: l_course_start_date ota_events.course_start_date%type;