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

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

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 1507: l_process wf_activities.name%type := 'OTA_ASSESSMENT_NTF_JSP_PRC';

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

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

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

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

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

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

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