APPS.OTA_INITIALIZATION_WF dependencies on WF_ACTIVITIES

Line 57: l_process wf_activities.name%type := upper(p_process);

53: IS
54:
55: l_order_number oe_order_headers.order_number%type;
56: l_header_id oe_order_headers.header_id%type;
57: l_process wf_activities.name%type := upper(p_process);
58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added
61: l_owner_id ota_events.owner_id%type;

Line 384: l_process wf_activities.name%type := upper(p_process);

380: line_id = p_line_id;
381:
382: l_order_number oe_order_headers.order_number%type;
383: l_header_id oe_order_headers.header_id%type;
384: l_process wf_activities.name%type := upper(p_process);
385: l_itemkey wf_items.item_key%type;
386: l_line_number oe_order_lines_all.line_number%type;
387:
388: l_proc varchar2(72) := g_package||'initialize_cancel_order';

Line 465: l_process wf_activities.name%type := upper(p_process);

461: p_user_name IN VARCHAR2
462: ) IS
463:
464: l_proc varchar2(72) := g_package||'manual_waitlist';
465: l_process wf_activities.name%type := upper(p_process);
466:
467: BEGIN
468: hr_utility.set_location('Entering:'||l_proc, 5);
469:

Line 527: l_process wf_activities.name%type := upper(p_process);

523: p_owner_id IN NUMBER
524: ) IS
525:
526: l_proc varchar2(72) := g_package||'manual_enroll_waitlist';
527: l_process wf_activities.name%type := upper(p_process);
528:
529: l_user_name varchar2(80);
530:
531: CURSOR C_USER IS

Line 683: l_process wf_activities.name%type := 'OTA_INSTRUCTOR_NTF_JSP_PRC';

679:
680: is
681: l_proc varchar2(72) := g_package||'Initialize_instructor_wf';
682:
683: l_process wf_activities.name%type := 'OTA_INSTRUCTOR_NTF_JSP_PRC';
684: l_item_key wf_items.item_key%type;
685:
686: l_title ota_events_tl.title%type;
687: l_start_date varchar2(100);

Line 948: l_process wf_activities.name%type := upper(p_process);

944:
945: is
946: l_proc varchar2(72) := g_package||'Initialize_wf';
947:
948: l_process wf_activities.name%type := upper(p_process);
949: l_item_key wf_items.item_key%type;
950:
951: l_title ota_events_tl.title%type;
952: l_start_date varchar2(100);

Line 1232: l_process wf_activities.name%type := 'OTA_LP_JSP_PRC';

1228:
1229: l_person_id per_people_f.person_id%type;
1230: l_LP_name ota_learning_paths_tl.name%type;
1231: l_start_date ota_learning_paths.start_date_active%type;
1232: l_process wf_activities.name%type := 'OTA_LP_JSP_PRC';
1233: l_item_key wf_items.item_key%type;
1234:
1235:
1236:

Line 1505: l_process wf_activities.name%type := 'OTA_ASSESSMENT_NTF_JSP_PRC';

1501:
1502:
1503: l_item_key wf_items.item_key%type;
1504: l_item_type wf_items.item_type%type := 'OTWF';
1505: l_process wf_activities.name%type := 'OTA_ASSESSMENT_NTF_JSP_PRC';
1506:
1507: l_title ota_learning_objects.name%type;
1508: l_score varchar2(100);
1509:

Line 1597: l_process wf_activities.name%type := 'OTA_CERTIFICATION_NTF_JSP_PRC';

1593: l_certification_name ota_certifications_tl.name%type;
1594: l_end_date_comments ota_certifications_tl.end_date_comments%type;
1595: l_end_date_active ota_certifications_b.end_date_active%type;
1596:
1597: l_process wf_activities.name%type := 'OTA_CERTIFICATION_NTF_JSP_PRC';
1598: l_item_key wf_items.item_key%type;
1599:
1600: begin
1601:

Line 1808: l_process wf_activities.name%type := 'OTA_FORUM_NTF_JSP_PRC';

1804: l_proc varchar2(72) := g_package||'init_forum_notif';
1805:
1806: l_item_key wf_items.item_key%type;
1807: l_item_type wf_items.item_type%type := 'OTWF';
1808: l_process wf_activities.name%type := 'OTA_FORUM_NTF_JSP_PRC';
1809:
1810: cursor get_message_details
1811: is
1812: select oft.name,fth.subject,ofm.person_id,ofm.contact_id,

Line 1925: l_process wf_activities.name%type := 'OTA_COURSE_EVAL_PRC';

1921: l_proc varchar2(72) := g_package||'init_course_eval_notif';
1922:
1923: l_item_key wf_items.item_key%type;
1924: l_item_type wf_items.item_type%type := 'OTWF';
1925: l_process wf_activities.name%type := 'OTA_COURSE_EVAL_PRC';
1926:
1927: l_person_id ota_forum_messages.person_id%type;
1928: l_contact_id ota_forum_messages.contact_id%type;
1929: l_event_id ota_events.event_id%type;