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_LRNR_ENROLL_UNENROLL_WF dependencies on WF_ENGINE

Line 49: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

45: select hr_workflow_item_key_s.nextval
46: into l_item_key
47: from sys.dual;
48:
49: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
50:
51: OPEN get_display_name;
52: FETCH get_display_name INTO l_process_display_name;
53: CLOSE get_display_name;

Line 72: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);

68: -- Set wf attributes
69:
70:
71:
72: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
73: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
74: --hard coded date format required by pqh
75: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
76:

Line 73: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );

69:
70:
71:
72: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
73: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
74: --hard coded date format required by pqh
75: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
76:
77: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

Line 75: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));

71:
72: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
73: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
74: --hard coded date format required by pqh
75: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
76:
77: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
78:
79:

Line 77: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

73: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
74: --hard coded date format required by pqh
75: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
76:
77: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
78:
79:
80:
81: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');

Line 81: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');

77: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
78:
79:
80:
81: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
82: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
83:
84: -- always set to NO for wf launched from pl/sql api
85: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');

Line 82: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);

78:
79:
80:
81: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
82: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
83:
84: -- always set to NO for wf launched from pl/sql api
85: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');
86:

Line 85: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');

81: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
82: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
83:
84: -- always set to NO for wf launched from pl/sql api
85: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');
86:
87:
88: WF_ENGINE.setitemattrnumber(l_item_type,
89: l_item_key,

Line 88: WF_ENGINE.setitemattrnumber(l_item_type,

84: -- always set to NO for wf launched from pl/sql api
85: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');
86:
87:
88: WF_ENGINE.setitemattrnumber(l_item_type,
89: l_item_key,
90: 'BOOKING_ID',
91: p_certificationid);
92:

Line 95: WF_ENGINE.setitemattrtext(l_item_type,

91: p_certificationid);
92:
93:
94:
95: WF_ENGINE.setitemattrtext(l_item_type,
96: l_item_key,
97: 'OTA_ACTIVITY_VERSION_NAME',
98: l_cert_name);
99:

Line 105: WF_ENGINE.setitemattrtext(l_item_type,

101: if l_cert_comp_date is null then
102: l_cert_comp_date := trunc(sysdate)+l_cert_dur;
103: end if;
104:
105: WF_ENGINE.setitemattrtext(l_item_type,
106: l_item_key,
107: 'OTA_COURSE_START_DATE',
108: l_cert_comp_date);
109:

Line 110: WF_ENGINE.setitemattrtext(l_item_type,

106: l_item_key,
107: 'OTA_COURSE_START_DATE',
108: l_cert_comp_date);
109:
110: WF_ENGINE.setitemattrtext(l_item_type,
111: l_item_key,
112: 'OTA_DELIVERY_MODE_NAME',
113: '');
114:

Line 121: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

117:
118:
119:
120:
121: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
122:
123: hr_utility.set_location('leaving:'||l_proc, 20);
124: EXCEPTION
125: WHEN OTHERS THEN

Line 203: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

199: select hr_workflow_item_key_s.nextval
200: into l_item_key
201: from sys.dual;
202:
203: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
204:
205: OPEN get_display_name;
206: FETCH get_display_name INTO l_process_display_name;
207: CLOSE get_display_name;

Line 241: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);

237: -- Set wf attributes
238:
239:
240:
241: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
242: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
243: --hard coded date format required by pqh
244: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
245:

Line 242: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );

238:
239:
240:
241: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
242: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
243: --hard coded date format required by pqh
244: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
245:
246: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

Line 244: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));

240:
241: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_DISPLAY_NAME', l_process_display_name);
242: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
243: --hard coded date format required by pqh
244: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
245:
246: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
247:
248:

Line 246: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));

242: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'PROCESS_NAME',l_process );
243: --hard coded date format required by pqh
244: WF_ENGINE.setitemattrtext(l_item_type, l_item_key,'P_EFFECTIVE_DATE',to_char(trunc(sysdate),'RRRR-MM-DD'));
245:
246: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
247:
248:
249:
250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');

Line 250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');

246: WF_ENGINE.setitemattrDate(l_item_type, l_item_key,'CURRENT_EFFECTIVE_DATE',trunc(sysdate));
247:
248:
249:
250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
251: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
252:
253: -- always set to NO for wf launched from pl/sql api
254: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');

Line 251: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);

247:
248:
249:
250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
251: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
252:
253: -- always set to NO for wf launched from pl/sql api
254: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');
255:

Line 254: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');

250: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
251: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
252:
253: -- always set to NO for wf launched from pl/sql api
254: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'NO');
255:
256: hr_approval_wf.create_item_attrib_if_notexist
257: (p_item_type => l_item_type
258: ,p_item_key => l_item_key

Line 261: WF_ENGINE.setitemattrnumber(l_item_type,

257: (p_item_type => l_item_type
258: ,p_item_key => l_item_key
259: ,p_name => 'OTA_EVENT_ID');
260:
261: WF_ENGINE.setitemattrnumber(l_item_type,
262: l_item_key,
263: 'OTA_EVENT_ID',
264: p_eventid);
265:

Line 268: WF_ENGINE.setitemattrtext(l_item_type,

264: p_eventid);
265:
266:
267:
268: WF_ENGINE.setitemattrtext(l_item_type,
269: l_item_key,
270: 'OTA_ACTIVITY_VERSION_NAME',
271: l_version_name);
272:

Line 275: WF_ENGINE.setitemattrtext(l_item_type,

271: l_version_name);
272:
273:
274:
275: WF_ENGINE.setitemattrtext(l_item_type,
276: l_item_key,
277: 'OTA_EVENT_TITLE',
278: p_eventid); --Enh 5606090: Language support for Event Details.
279:

Line 280: WF_ENGINE.setitemattrtext(l_item_type,

276: l_item_key,
277: 'OTA_EVENT_TITLE',
278: p_eventid); --Enh 5606090: Language support for Event Details.
279:
280: WF_ENGINE.setitemattrtext(l_item_type,
281: l_item_key,
282: 'OTA_COURSE_START_DATE',
283: l_course_start_date);
284:

Line 286: WF_ENGINE.setitemattrtext(l_item_type,

282: 'OTA_COURSE_START_DATE',
283: l_course_start_date);
284:
285:
286: WF_ENGINE.setitemattrtext(l_item_type,
287: l_item_key,
288: 'OTA_COURSE_END_DATE',
289: l_course_end_date);
290:

Line 291: WF_ENGINE.setitemattrtext(l_item_type,

287: l_item_key,
288: 'OTA_COURSE_END_DATE',
289: l_course_end_date);
290:
291: WF_ENGINE.setitemattrtext(l_item_type,
292: l_item_key,
293: 'OTA_CLASS_START_TIME',
294: nvl(l_course_start_time,'00:00'));
295:

Line 296: WF_ENGINE.setitemattrtext(l_item_type,

292: l_item_key,
293: 'OTA_CLASS_START_TIME',
294: nvl(l_course_start_time,'00:00'));
295:
296: WF_ENGINE.setitemattrtext(l_item_type,
297: l_item_key,
298: 'OTA_DELIVERY_MODE_NAME',
299: l_delivery_mode);
300:

Line 301: WF_ENGINE.setitemattrtext(l_item_type,

297: l_item_key,
298: 'OTA_DELIVERY_MODE_NAME',
299: l_delivery_mode);
300:
301: WF_ENGINE.setitemattrtext(l_item_type,
302: l_item_key,
303: 'OTA_LOCATION_ADDRESS',
304: l_event_location);
305:

Line 313: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'ENROLL_IN_A_CLASS_STATUS', l_enrollment_status_name);

309: p_delegate_contact_id => null,
310: p_event_id => p_eventid,
311: p_code =>0);
312:
313: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'ENROLL_IN_A_CLASS_STATUS', l_enrollment_status_name);
314:
315: wf_engine.setItemAttrNumber(itemtype => l_item_type
316: ,itemkey => l_item_key
317: ,aname => 'BOOKING_ID'

Line 315: wf_engine.setItemAttrNumber(itemtype => l_item_type

311: p_code =>0);
312:
313: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'ENROLL_IN_A_CLASS_STATUS', l_enrollment_status_name);
314:
315: wf_engine.setItemAttrNumber(itemtype => l_item_type
316: ,itemkey => l_item_key
317: ,aname => 'BOOKING_ID'
318: ,avalue => p_booking_id);
319: wf_engine.setItemAttrText(l_item_type,l_item_key,'STATE_LIST',l_timezone );

Line 319: wf_engine.setItemAttrText(l_item_type,l_item_key,'STATE_LIST',l_timezone );

315: wf_engine.setItemAttrNumber(itemtype => l_item_type
316: ,itemkey => l_item_key
317: ,aname => 'BOOKING_ID'
318: ,avalue => p_booking_id);
319: wf_engine.setItemAttrText(l_item_type,l_item_key,'STATE_LIST',l_timezone );
320: /* hr_approval_wf.create_item_attrib_if_notexist
321: (p_item_type => l_item_type
322: ,p_item_key => l_item_key
323: ,p_name => 'OTA_CLASS_END_TIME');*/

Line 324: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));

320: /* hr_approval_wf.create_item_attrib_if_notexist
321: (p_item_type => l_item_type
322: ,p_item_key => l_item_key
323: ,p_name => 'OTA_CLASS_END_TIME');*/
324: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));
325:
326: --p_itemkey := l_item_key;
327:
328: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

Line 328: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

324: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));
325:
326: --p_itemkey := l_item_key;
327:
328: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
329:
330: hr_utility.set_location('leaving:'||l_proc, 20);
331: EXCEPTION
332: WHEN OTHERS THEN

Line 383: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

379: select hr_workflow_item_key_s.nextval
380: into l_item_key
381: from sys.dual;
382:
383: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
384:
385: /*OPEN get_display_name;
386: FETCH get_display_name INTO l_process_display_name;
387: CLOSE get_display_name;

Line 407: WF_ENGINE.setitemattrtext(l_item_type,

403: -- Set wf attributes
404:
405:
406:
407: WF_ENGINE.setitemattrtext(l_item_type,
408: l_item_key,
409: 'OTA_ACTIVITY_VERSION_NAME',
410: l_version_name);
411:

Line 414: WF_ENGINE.setitemattrtext(l_item_type,

410: l_version_name);
411:
412:
413:
414: WF_ENGINE.setitemattrtext(l_item_type,
415: l_item_key,
416: 'OTA_EVENT_TITLE',
417: p_eventid); --Enh 5606090: Language support for Event Details.
418:

Line 419: WF_ENGINE.setitemattrtext(l_item_type,

415: l_item_key,
416: 'OTA_EVENT_TITLE',
417: p_eventid); --Enh 5606090: Language support for Event Details.
418:
419: WF_ENGINE.setitemattrtext(l_item_type,
420: l_item_key,
421: 'OTA_COURSE_START_DATE',
422: l_course_start_date);
423:

Line 424: WF_ENGINE.setitemattrtext(l_item_type,

420: l_item_key,
421: 'OTA_COURSE_START_DATE',
422: l_course_start_date);
423:
424: WF_ENGINE.setitemattrtext(l_item_type,
425: l_item_key,
426: 'HR_OAF_NAVIGATION_ATTR',
427: 'N');
428:

Line 430: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

426: 'HR_OAF_NAVIGATION_ATTR',
427: 'N');
428:
429:
430: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
431:
432: hr_utility.set_location('leaving:'||l_proc, 20);
433: EXCEPTION
434: WHEN OTHERS THEN