eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_INITIALIZATION_WF dependencies on WF_ITEMS

Line 58: l_itemkey wf_items.item_key%type := to_char(p_line_id);

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;
62: l_email_address per_people_f.email_address%type;

Line 221: l_item_key wf_items.item_key%TYPE;

217: l_order_number oe_order_headers.order_number%type;
218: l_header_id oe_order_headers.header_id%type;
219: l_proc varchar2(72) := g_package||'initialize_cancel_event';
220: l_wf_date VARCHAR2(30);
221: l_item_key wf_items.item_key%TYPE;
222: l_line_number oe_order_lines_all.line_number%type;
223:
224: BEGIN
225: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: l_itemkey wf_items.item_key%type;

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';
389:

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

557: hr_utility.set_location('leaving:'||l_proc, 20);
558:
559: END;
560:
561: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
562: p_item_key in wf_items.item_key%type,
563: p_eventid in ota_events.event_id%type,
564: p_from in varchar2 default null
565: )

Line 562: p_item_key in wf_items.item_key%type,

558:
559: END;
560:
561: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
562: p_item_key in wf_items.item_key%type,
563: p_eventid in ota_events.event_id%type,
564: p_from in varchar2 default null
565: )
566:

Line 668: p_item_type in wf_items.item_type%type,

664:
665: end set_addnl_attributes;
666:
667: Procedure Initialize_instructor_wf(
668: p_item_type in wf_items.item_type%type,
669: p_eventid in ota_events.event_id%type,
670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,
671: p_start_date in varchar2,
672: p_end_date in varchar2,

Line 684: l_item_key wf_items.item_key%type;

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);
688: l_end_date varchar2(100);

Line 940: p_item_type in wf_items.item_type%type,

936:
937: end Initialize_instructor_wf;
938:
939: Procedure Initialize_wf(p_process in wf_process_activities.process_name%type,
940: p_item_type in wf_items.item_type%type,
941: p_person_id in number ,
942: p_eventid in ota_Events.event_id%type,
943: p_event_fired in varchar2)
944:

Line 949: l_item_key wf_items.item_key%type;

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);
953: l_end_date varchar2(100);

Line 1103: p_item_type in wf_items.item_type%type,

1099: end initialize_wf;
1100:
1101:
1102: Procedure Initialize_auto_wf(p_process in wf_process_activities.process_name%type,
1103: p_item_type in wf_items.item_type%type,
1104: p_event_fired in varchar2,
1105: p_event_id in ota_events.event_id%type default null)
1106: is
1107: l_proc varchar2(72) := g_package||'Initialize_auto_wf';

Line 1215: Procedure Init_LP_wf(p_item_type in wf_items.item_type%type,

1211:
1212: hr_utility.set_location('Leaving:'||l_proc, 5);
1213: end Initialize_auto_wf;
1214:
1215: Procedure Init_LP_wf(p_item_type in wf_items.item_type%type,
1216: p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type,
1217: p_event_fired in varchar2)
1218: is
1219:

Line 1233: l_item_key wf_items.item_key%type;

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:
1237: begin

Line 1305: p_item_type in wf_items.item_type%type,

1301: end get_event_fired;
1302:
1303:
1304: procedure set_wf_item_attr(p_person_id in number,
1305: p_item_type in wf_items.item_type%type,
1306: p_item_key in wf_items.item_key%type)
1307: is
1308:
1309: l_proc varchar2(72) := g_package||'set_wf_item_attr';

Line 1306: p_item_key in wf_items.item_key%type)

1302:
1303:
1304: procedure set_wf_item_attr(p_person_id in number,
1305: p_item_type in wf_items.item_type%type,
1306: p_item_key in wf_items.item_key%type)
1307: is
1308:
1309: l_proc varchar2(72) := g_package||'set_wf_item_attr';
1310:

Line 1503: l_item_key wf_items.item_key%type;

1499: -- and oa.attempt_id = op.attempt_id
1500: and oa.attempt_id =p_attempt_id;
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;

Line 1504: l_item_type wf_items.item_type%type := 'OTWF';

1500: and oa.attempt_id =p_attempt_id;
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);

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

1571:
1572: -- This wf would be used for OTA_CERTIFICATION_NTF_JSP_PRC
1573: -- Called from alert
1574:
1575: Procedure initialize_cert_ntf_wf(p_item_type in wf_items.item_type%type,
1576: p_person_id in number default null,
1577: p_certification_id in ota_certifications_b.certification_id%type,
1578: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1579: p_cert_ntf_type in varchar2) is

Line 1598: l_item_key wf_items.item_key%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:
1602: open get_certification_info;

Line 1806: l_item_key wf_items.item_key%type;

1802: is
1803:
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

Line 1807: l_item_type wf_items.item_type%type := 'OTWF';

1803:
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

Line 1923: l_item_key wf_items.item_key%type;

1919: procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type) is
1920:
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;

Line 1924: l_item_type wf_items.item_type%type := 'OTWF';

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

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

1954: hr_utility.set_location('Leaving:'||l_proc, 10);
1955:
1956: end init_course_eval_notif;
1957:
1958: procedure get_course_eval_status ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1959: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1960: actid IN NUMBER,
1961: funcmode IN VARCHAR2,
1962: resultout OUT nocopy VARCHAR2 ) is

Line 1959: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1955:
1956: end init_course_eval_notif;
1957:
1958: procedure get_course_eval_status ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1959: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1960: actid IN NUMBER,
1961: funcmode IN VARCHAR2,
1962: resultout OUT nocopy VARCHAR2 ) is
1963:

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

1978: end if;
1979:
1980: end get_course_eval_status;
1981:
1982: procedure get_course_eval_del_mode ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1983: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1984: actid IN NUMBER,
1985: funcmode IN VARCHAR2,
1986: resultout OUT nocopy VARCHAR2 ) is

Line 1983: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1979:
1980: end get_course_eval_status;
1981:
1982: procedure get_course_eval_del_mode ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1983: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1984: actid IN NUMBER,
1985: funcmode IN VARCHAR2,
1986: resultout OUT nocopy VARCHAR2 ) is
1987:

Line 2047: l_item_key wf_items.item_key%type;

2043: )
2044: is
2045: l_proc varchar2(72) := g_package||'RAISE_BUSINESS_EVENT';
2046:
2047: l_item_key wf_items.item_key%type;
2048:
2049: l_title ota_events_tl.title%type;
2050: l_start_date varchar2(100);
2051: l_end_date varchar2(100);