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_ENGINE

Line 113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );

109: FETCH c_person INTO l_full_name,l_email_address;
110: CLOSE c_person;*/
111: hr_utility.set_location('Entering:'||l_proc, 20);
112:
113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);

Line 114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);

110: CLOSE c_person;*/
111: hr_utility.set_location('Entering:'||l_proc, 20);
112:
113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);

Line 115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);

111: hr_utility.set_location('Entering:'||l_proc, 20);
112:
113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);

Line 116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);

112:
113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:

Line 117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);

113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);

Line 118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);

114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);
122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);

Line 119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);

115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);
116: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'EVENT_OWNER',l_email_address);
117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);
122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);
123: hr_utility.set_location('Leaving:'||l_proc, 25);

Line 121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);

117: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORDER_NUMBER',l_order_number);
118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);
122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);
123: hr_utility.set_location('Leaving:'||l_proc, 25);
124:
125: EXCEPTION

Line 122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);

118: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'HEADER_ID',l_header_id);
119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);
122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);
123: hr_utility.set_location('Leaving:'||l_proc, 25);
124:
125: EXCEPTION
126: WHEN OTHERS THEN

Line 246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');

242:
243: --Bug#2587983 get line number
244:
245: l_item_key := p_line_id||l_wf_date;
246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');
247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);

Line 247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.

243: --Bug#2587983 get line number
244:
245: l_item_key := p_line_id||l_wf_date;
246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');
247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);

Line 248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);

244:
245: l_item_key := p_line_id||l_wf_date;
246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');
247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);
252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);

Line 249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);

245: l_item_key := p_line_id||l_wf_date;
246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');
247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);
252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
253:

Line 250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);

246: WF_ENGINE.CREATEPROCESS(p_itemtype, l_item_key, 'OTA_EVT_CANCEL');
247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);
252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
253:
254: EXCEPTION

Line 251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);

247: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key,'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);
252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
253:
254: EXCEPTION
255: WHEN OTHERS THEN

Line 252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);

248: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'ORDER_NUMBER',l_order_number);
249: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'EVENT_OWNER',l_user_name);
250: WF_ENGINE.SetItemattrtext(p_itemtype,l_item_key,'STATUS',p_status);
251: WF_ENGINE.SetItemattrnumber(p_itemtype,l_item_key,'LINE_NUMBER',l_line_number);
252: WF_ENGINE.STARTPROCESS(p_itemtype,l_item_key);
253:
254: EXCEPTION
255: WHEN OTHERS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);

401: CLOSE C_ORDER_LINE;
402:
403: --Bug#2587983 get line number
404:
405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);
406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);

Line 406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.

402:
403: --Bug#2587983 get line number
404:
405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);
406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);

Line 407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);

403: --Bug#2587983 get line number
404:
405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);
406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);
411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));

Line 408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);

404:
405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);
406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);
411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));
412:

Line 409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);

405: WF_ENGINE.CREATEPROCESS(p_itemtype, to_char(p_line_id), l_process);
406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);
411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));
412:
413: EXCEPTION

Line 410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);

406: WF_ENGINE.setitemattrtext(p_itemtype, to_char(p_line_id), 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);
411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));
412:
413: EXCEPTION
414: WHEN OTHERS THEN

Line 411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));

407: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'EVENT_OWNER',p_user_name);
408: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id), 'ORDER_NUMBER',l_order_number);
409: WF_ENGINE.SetItemattrtext(p_itemtype,to_char(p_line_id), 'STATUS',p_status);
410: WF_ENGINE.SetItemattrnumber(p_itemtype,to_char(p_line_id),'LINE_NUMBER',l_line_number);
411: WF_ENGINE.STARTPROCESS(p_itemtype,to_char(p_line_id));
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);

469:
470:
471: hr_utility.set_location('Entering:'||l_proc, 10);
472:
473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);
476: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
477:

Line 474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.

470:
471: hr_utility.set_location('Entering:'||l_proc, 10);
472:
473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);
476: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
477:
478: EXCEPTION

Line 475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);

471: hr_utility.set_location('Entering:'||l_proc, 10);
472:
473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);
476: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
477:
478: EXCEPTION
479: WHEN OTHERS THEN

Line 476: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);

472:
473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);
476: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);

545: CLOSE C_USER;
546:
547: hr_utility.set_location('Entering:'||l_proc, 10);
548:
549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);
551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
552: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
553:

Line 550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);

546:
547: hr_utility.set_location('Entering:'||l_proc, 10);
548:
549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);
551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
552: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
553:
554: EXCEPTION

Line 551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);

547: hr_utility.set_location('Entering:'||l_proc, 10);
548:
549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);
551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
552: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
553:
554: EXCEPTION
555: WHEN OTHERS THEN

Line 552: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);

548:
549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);
551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
552: WF_ENGINE.STARTPROCESS(p_itemtype,p_item_key);
553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );

635: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
636:
637: --set wf item attributes
638:
639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
640: wf_engine.setItemAttrText(p_item_type,p_item_key,'COURSE_NAME',l_course_name );
641: wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );
643:

Line 640: wf_engine.setItemAttrText(p_item_type,p_item_key,'COURSE_NAME',l_course_name );

636:
637: --set wf item attributes
638:
639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
640: wf_engine.setItemAttrText(p_item_type,p_item_key,'COURSE_NAME',l_course_name );
641: wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );
643:
644:

Line 641: wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );

637: --set wf item attributes
638:
639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
640: wf_engine.setItemAttrText(p_item_type,p_item_key,'COURSE_NAME',l_course_name );
641: wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );
643:
644:
645: if p_from is null then

Line 642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );

638:
639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
640: wf_engine.setItemAttrText(p_item_type,p_item_key,'COURSE_NAME',l_course_name );
641: wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );
643:
644:
645: if p_from is null then
646: wf_engine.setItemAttrText(p_item_type,p_item_key,'TIMEZONE',l_timezone );

Line 646: wf_engine.setItemAttrText(p_item_type,p_item_key,'TIMEZONE',l_timezone );

642: wf_engine.setItemAttrText(p_item_type,p_item_key,'DELIVERY_METHOD',l_delivery_method );
643:
644:
645: if p_from is null then
646: wf_engine.setItemAttrText(p_item_type,p_item_key,'TIMEZONE',l_timezone );
647: end if;
648:
649: -- get object type
650:

Line 661: WF_ENGINE.setitemattrText(p_item_type, p_item_key, 'SECTION_NAME', l_object_type);

657: l_object_type := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL', 800);
658: end if;
659:
660:
661: WF_ENGINE.setitemattrText(p_item_type, p_item_key, 'SECTION_NAME', l_object_type);
662:
663:
664:
665: end set_addnl_attributes;

Line 770: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

766: from sys.dual;
767:
768:
769: -- get item key for the process
770: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
771:
772: hr_utility.trace ('after Createprocess ' ||l_item_key);
773:
774:

Line 780: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

776: set_wf_item_attr(p_person_id => p_person_id,
777: p_item_type => p_item_type,
778: p_item_key => l_item_key);
779:
780: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
781:
782:
783:
784:

Line 785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

781:
782:
783:
784:
785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);
787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);
788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));
789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));

Line 786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);

782:
783:
784:
785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);
787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);
788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));
789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));
790:

Line 787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);

783:
784:
785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);
787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);
788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));
789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));
790:
791:

Line 788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));

784:
785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);
787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);
788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));
789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));
790:
791:
792:

Line 789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));

785: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
786: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', p_start_date);
787: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', p_end_date);
788: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(p_start_time,'00:00'));
789: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(p_end_time,'23:59'));
790:
791:
792:
793:

Line 796: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

792:
793:
794:
795:
796: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
797:
798:
799:
800: -- get trainer enrollment status

Line 804: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', p_status); --Enh 5606090: Language support for Event Details.

800: -- get trainer enrollment status
801:
802: --l_enrollment_status_name := ota_utility.get_lookup_meaning('RESOURCE_BOOKING_STATUS',p_status, 800); Enh 5606090: Language support for Event Details.
803:
804: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', p_status); --Enh 5606090: Language support for Event Details.
805:
806: set_addnl_attributes(p_item_type => p_item_type,
807: p_item_key => l_item_key,
808: p_eventid => p_eventid

Line 812: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

808: p_eventid => p_eventid
809: );
810:
811:
812: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
813:
814: elsif p_event_fired = 'INSTRUCTOR_REMIND' then
815:
816: open get_resource_info;

Line 826: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

822: from sys.dual;
823:
824: hr_utility.trace ('Before Createprocess ' ||resource_rec.trainer_id );
825: -- get item key for the process
826: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
827:
828: hr_utility.trace ('after Createprocess ' ||l_item_key);
829:
830: set_wf_item_attr(p_person_id => resource_rec.trainer_id,

Line 834: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

830: set_wf_item_attr(p_person_id => resource_rec.trainer_id,
831: p_item_type => p_item_type,
832: p_item_key => l_item_key);
833:
834: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
835:
836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);

Line 836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

832: p_item_key => l_item_key);
833:
834: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
835:
836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));

Line 837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.

833:
834: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
835:
836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));

Line 838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);

834: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
835:
836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );

Line 839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);

835:
836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );
843:

Line 840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));

836: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );
843:
844: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

Line 841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));

837: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', resource_rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );
843:
844: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
845:

Line 842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );

838: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', resource_rec.required_date_from);
839: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', resource_rec.required_date_to);
840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );
843:
844: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
845:
846: -- get trainer enrollment status

Line 844: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

840: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(resource_rec.required_start_time,'00:00'));
841: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(resource_rec.required_end_time,'23:59'));
842: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',resource_rec.timezone );
843:
844: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
845:
846: -- get trainer enrollment status
847:
848: l_enrollment_status_name := ota_utility.get_lookup_meaning('RESOURCE_BOOKING_STATUS',resource_rec.status, 800);

Line 850: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', l_enrollment_status_name);

846: -- get trainer enrollment status
847:
848: l_enrollment_status_name := ota_utility.get_lookup_meaning('RESOURCE_BOOKING_STATUS',resource_rec.status, 800);
849:
850: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', l_enrollment_status_name);
851:
852: set_addnl_attributes(p_item_type => p_item_type,
853: p_item_key => l_item_key,
854: p_eventid => p_eventid,

Line 859: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

855: p_from => 'I'
856: );
857:
858:
859: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
860: end if;
861: close get_resource_info;
862: else
863:

Line 874: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

870: from sys.dual;
871:
872: hr_utility.trace ('Before Createprocess ' ||rec.trainer_id);
873: -- get item key for the process
874: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
875:
876: hr_utility.trace ('after Createprocess ' ||l_item_key);
877:
878:

Line 888: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

884: set_wf_item_attr(p_person_id => rec.trainer_id,
885: p_item_type => p_item_type,
886: p_item_key => l_item_key);
887:
888: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
889:
890:
891:
892: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

Line 892: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

888: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
889:
890:
891:
892: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
893: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
894: if p_event_fired = 'CLASS_CANCEL' or p_event_fired = 'CLASS_RESCHEDULE' then
895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);

Line 893: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', rec.resource_booking_id); --Enh 5606090: Language support for Event Details.

889:
890:
891:
892: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
893: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
894: if p_event_fired = 'CLASS_CANCEL' or p_event_fired = 'CLASS_RESCHEDULE' then
895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);

Line 896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);

892: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
893: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
894: if p_event_fired = 'CLASS_CANCEL' or p_event_fired = 'CLASS_RESCHEDULE' then
895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );

Line 897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);

893: WF_ENGINE.setitemAttrText(p_item_type,l_item_key, 'BOOKING_ID', rec.resource_booking_id); --Enh 5606090: Language support for Event Details.
894: if p_event_fired = 'CLASS_CANCEL' or p_event_fired = 'CLASS_RESCHEDULE' then
895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:

Line 898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));

894: if p_event_fired = 'CLASS_CANCEL' or p_event_fired = 'CLASS_RESCHEDULE' then
895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:
902: else

Line 899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));

895:
896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:
902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);

Line 900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );

896: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
898: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:
902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);

Line 903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);

899: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:
902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);
905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));
906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));
907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );

Line 904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);

900: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',l_timezone );
901:
902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);
905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));
906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));
907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );
908:

Line 905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));

901:
902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);
905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));
906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));
907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );
908:
909: end if;

Line 906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));

902: else
903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);
905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));
906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));
907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );
908:
909: end if;
910:

Line 907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );

903: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', rec.required_date_from);
904: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', rec.required_date_to);
905: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(rec.required_start_time,'00:00'));
906: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(rec.required_end_time,'23:59'));
907: wf_engine.setItemAttrText(p_item_type,l_item_key,'TIMEZONE',rec.timezone );
908:
909: end if;
910:
911:

Line 914: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

910:
911:
912:
913:
914: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
915:
916:
917:
918: -- get trainer enrollment status

Line 922: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', l_enrollment_status_name);

918: -- get trainer enrollment status
919:
920: l_enrollment_status_name := ota_utility.get_lookup_meaning('RESOURCE_BOOKING_STATUS',rec.status, 800);
921:
922: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_ENROLLEE', l_enrollment_status_name);
923:
924: set_addnl_attributes(p_item_type => p_item_type,
925: p_item_key => l_item_key,
926: p_eventid => p_eventid,

Line 931: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

927: p_from => 'I'
928: );
929:
930:
931: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
932: end loop;
933:
934: end if;
935: hr_utility.set_location('Leaving:'||l_proc, 5);

Line 1013: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

1009: select hr_workflow_item_key_s.nextval
1010: into l_item_key
1011: from sys.dual;
1012: -- get item key for the process
1013: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
1014:
1015: -- set creator,current and supervisor name
1016: set_wf_item_attr(p_person_id => p_person_id,
1017: p_item_type => p_item_type,

Line 1024: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

1020: open get_booking_info_class_cancel;
1021: fetch get_booking_info_class_cancel into l_booking_id,l_person_id;
1022: close get_booking_info_class_cancel;
1023:
1024: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1025:
1026:
1027:
1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

Line 1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

1024: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1025:
1026:
1027:
1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));

Line 1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);

1025:
1026:
1027:
1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);

Line 1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);

1026:
1027:
1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);
1034:

Line 1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));

1027:
1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);
1034:
1035: -- get location

Line 1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));

1028: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);
1034:
1035: -- get location
1036: l_location_name := ota_general.get_Location_code(l_location_id);

Line 1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);

1029: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1031: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);
1034:
1035: -- get location
1036: l_location_name := ota_general.get_Location_code(l_location_id);
1037:

Line 1038: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

1034:
1035: -- get location
1036: l_location_name := ota_general.get_Location_code(l_location_id);
1037:
1038: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
1039:
1040: set_addnl_attributes(p_item_type => p_item_type,
1041: p_item_key => l_item_key,
1042: p_eventid => p_eventid

Line 1046: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

1042: p_eventid => p_eventid
1043: );
1044:
1045:
1046: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
1047:
1048:
1049: else
1050:

Line 1059: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

1055: select hr_workflow_item_key_s.nextval
1056: into l_item_key
1057: from sys.dual;
1058: -- get item key for the process
1059: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
1060:
1061: -- set creator,current and supervisor name
1062: set_wf_item_attr(p_person_id => rec.delegate_person_id,
1063: p_item_type => p_item_type,

Line 1068: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

1064: p_item_key => l_item_key);
1065:
1066:
1067:
1068: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1069:
1070:
1071:
1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

Line 1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.

1068: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1069:
1070:
1071:
1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));

Line 1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);

1069:
1070:
1071:
1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1077:

Line 1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);

1070:
1071:
1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1077:
1078: -- get location

Line 1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));

1071:
1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1077:
1078: -- get location
1079: l_location_name := ota_general.get_Location_code(l_location_id);

Line 1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));

1072: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'EVENT_TITLE', p_eventid); --Enh 5606090: Language support for Event Details.
1073: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrdate(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);
1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1077:
1078: -- get location
1079: l_location_name := ota_general.get_Location_code(l_location_id);
1080:

Line 1081: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);

1077:
1078: -- get location
1079: l_location_name := ota_general.get_Location_code(l_location_id);
1080:
1081: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
1082:
1083: -- if l_process = 'OTA_ENROLL_STATUS_CHNG_JSP_PRC' then
1084:
1085: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', rec.booking_id);

Line 1085: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', rec.booking_id);

1081: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
1082:
1083: -- if l_process = 'OTA_ENROLL_STATUS_CHNG_JSP_PRC' then
1084:
1085: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', rec.booking_id);
1086: -- end if;
1087:
1088: set_addnl_attributes(p_item_type => p_item_type,
1089: p_item_key => l_item_key,

Line 1092: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

1088: set_addnl_attributes(p_item_type => p_item_type,
1089: p_item_key => l_item_key,
1090: p_eventid => p_eventid
1091: );
1092: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
1093:
1094: end loop;
1095:
1096: end if;

Line 1248: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

1244: select hr_workflow_item_key_s.nextval
1245: into l_item_key
1246: from sys.dual;
1247: -- get item key for the process
1248: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
1249:
1250: -- set creator,current and supervisor name
1251: set_wf_item_attr(p_person_id => l_person_id,
1252: p_item_type => p_item_type,

Line 1255: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

1251: set_wf_item_attr(p_person_id => l_person_id,
1252: p_item_type => p_item_type,
1253: p_item_key => l_item_key);
1254:
1255: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1256:
1257:
1258: --Enh 5606090: Language support for LP Details.
1259: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', p_lp_enrollment_id);

Line 1259: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', p_lp_enrollment_id);

1255: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1256:
1257:
1258: --Enh 5606090: Language support for LP Details.
1259: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', p_lp_enrollment_id);
1260: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_COURSE_START_DATE', l_start_date);
1261:
1262: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
1263:

Line 1260: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_COURSE_START_DATE', l_start_date);

1256:
1257:
1258: --Enh 5606090: Language support for LP Details.
1259: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', p_lp_enrollment_id);
1260: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_COURSE_START_DATE', l_start_date);
1261:
1262: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
1263:
1264: end init_LP_wf;

Line 1262: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);

1258: --Enh 5606090: Language support for LP Details.
1259: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_ACTIVITY_VERSION_NAME', p_lp_enrollment_id);
1260: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_COURSE_START_DATE', l_start_date);
1261:
1262: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
1263:
1264: end init_LP_wf;
1265:
1266:

Line 1282: l_value := wf_engine.getItemAttrText(itemtype => itemtype

1278: begin
1279: hr_utility.set_location('ENTERING get_event_fired', 10);
1280: IF (funcmode='RUN') THEN
1281:
1282: l_value := wf_engine.getItemAttrText(itemtype => itemtype
1283: ,itemkey => itemkey
1284: , aname => 'OTA_NTF_EVENT_FIRED');
1285: hr_utility.trace ('l_value ' ||l_value);
1286: if l_value is not null then

Line 1392: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);

1388:
1389:
1390:
1391:
1392: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1393: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1394:
1395: hr_utility.trace ('Current username ' ||l_current_username);
1396:

Line 1393: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);

1389:
1390:
1391:
1392: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1393: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1394:
1395: hr_utility.trace ('Current username ' ||l_current_username);
1396:
1397: open csr_person_name(l_creator_person_id);

Line 1406: WF_ENGINE.setitemattrtext(p_item_type,

1402: fetch csr_person_name into l_current_full_name;
1403: close csr_person_name;
1404:
1405:
1406: WF_ENGINE.setitemattrtext(p_item_type,
1407: p_item_key,
1408: 'CURRENT_PERSON_DISPLAY_NAME',
1409: l_current_full_name);
1410:

Line 1415: WF_ENGINE.setitemattrtext(p_item_type,

1411: --for forum notification Login person can be contact
1412: if p_item_type = 'OTWF' and l_creator_full_name is not null then
1413:
1414:
1415: WF_ENGINE.setitemattrtext(p_item_type,
1416: p_item_key,
1417: 'LP_CREATOR_NAME',
1418: l_creator_full_name);
1419:

Line 1422: WF_ENGINE.setitemattrtext(p_item_type,

1418: l_creator_full_name);
1419:
1420: elsif p_item_type <> 'OTWF' then
1421:
1422: WF_ENGINE.setitemattrtext(p_item_type,
1423: p_item_key,
1424: 'CREATOR_PERSON_DISPLAY_NAME',
1425: l_creator_full_name);
1426: WF_ENGINE.setitemattrtext(p_item_type,

Line 1426: WF_ENGINE.setitemattrtext(p_item_type,

1422: WF_ENGINE.setitemattrtext(p_item_type,
1423: p_item_key,
1424: 'CREATOR_PERSON_DISPLAY_NAME',
1425: l_creator_full_name);
1426: WF_ENGINE.setitemattrtext(p_item_type,
1427: p_item_key,
1428: 'APPROVAL_CREATOR_DISPLAY_NAME',
1429: l_creator_full_name);
1430: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_ID', p_person_id);

Line 1430: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_ID', p_person_id);

1426: WF_ENGINE.setitemattrtext(p_item_type,
1427: p_item_key,
1428: 'APPROVAL_CREATOR_DISPLAY_NAME',
1429: l_creator_full_name);
1430: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_ID', p_person_id);
1431: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1432:
1433: end if;
1434:

Line 1431: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);

1427: p_item_key,
1428: 'APPROVAL_CREATOR_DISPLAY_NAME',
1429: l_creator_full_name);
1430: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_ID', p_person_id);
1431: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_ID', l_creator_person_id);
1432:
1433: end if;
1434:
1435:

Line 1450: wf_engine.setitemattrtext

1446:
1447: hr_utility.set_location('after supervisor cursor'||l_proc, 20);
1448:
1449:
1450: wf_engine.setitemattrtext
1451: (p_item_type,
1452: p_item_key,
1453: 'SUPERVISOR_USERNAME',
1454: l_supervisor_username);

Line 1457: wf_engine.setitemattrtext

1453: 'SUPERVISOR_USERNAME',
1454: l_supervisor_username);
1455: hr_utility.set_location('after supervisor username'||l_supervisor_username, 20);
1456: if p_item_type <> 'OTWF' then
1457: wf_engine.setitemattrtext
1458: (p_item_type,
1459: p_item_key,
1460: 'SUPERVISOR_DISPLAY_NAME',
1461: l_supervisor_full_name);

Line 1463: wf_engine.setitemattrnumber

1459: p_item_key,
1460: 'SUPERVISOR_DISPLAY_NAME',
1461: l_supervisor_full_name);
1462:
1463: wf_engine.setitemattrnumber
1464: (p_item_type,
1465: p_item_key,
1466: 'SUPERVISOR_ID',
1467: l_supervisor_id);

Line 1478: WF_ENGINE.SetItemOwner(

1474: p_name =>l_role_name,
1475: p_display_name =>l_role_display_name);
1476:
1477:
1478: WF_ENGINE.SetItemOwner(
1479: itemtype => p_item_type,
1480: itemkey =>p_item_key,
1481: owner =>l_role_name);
1482:

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

1534: select hr_workflow_item_key_s.nextval
1535: into l_item_key
1536: from sys.dual;
1537: -- get item key for the process
1538: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1539: hr_utility.trace ('item key ' ||l_item_key);
1540: -- set creator,current and supervisor name
1541: set_wf_item_attr(p_person_id => p_person_id,
1542: p_item_type => l_item_type,

Line 1547: --WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);

1543: p_item_key => l_item_key);
1544:
1545:
1546:
1547: --WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1548:
1549:
1550: --Enh 5606090: Language support for Assessment Notification.
1551: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'EVENT_TITLE', p_attempt_id);

Line 1551: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'EVENT_TITLE', p_attempt_id);

1547: --WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_event_fired);
1548:
1549:
1550: --Enh 5606090: Language support for Assessment Notification.
1551: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'EVENT_TITLE', p_attempt_id);
1552:
1553: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'LINE_NUMBER', l_score);
1554: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_START_TIME', l_format_time);
1555:

Line 1553: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'LINE_NUMBER', l_score);

1549:
1550: --Enh 5606090: Language support for Assessment Notification.
1551: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'EVENT_TITLE', p_attempt_id);
1552:
1553: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'LINE_NUMBER', l_score);
1554: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_START_TIME', l_format_time);
1555:
1556:
1557: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

Line 1554: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_START_TIME', l_format_time);

1550: --Enh 5606090: Language support for Assessment Notification.
1551: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'EVENT_TITLE', p_attempt_id);
1552:
1553: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'LINE_NUMBER', l_score);
1554: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_START_TIME', l_format_time);
1555:
1556:
1557: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1558:

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

1553: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'LINE_NUMBER', l_score);
1554: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_START_TIME', l_format_time);
1555:
1556:
1557: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1558:
1559:
1560: hr_utility.set_location('Leaving:'||l_proc, 5);
1561:

Line 1618: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

1614: into l_item_key
1615: from sys.dual;
1616:
1617: -- get item key for the process
1618: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
1619:
1620: -- set creator,current and supervisor name
1621: set_wf_item_attr(p_person_id => p_person_id,
1622: p_item_type => p_item_type,

Line 1625: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_cert_ntf_type);

1621: set_wf_item_attr(p_person_id => p_person_id,
1622: p_item_type => p_item_type,
1623: p_item_key => l_item_key);
1624:
1625: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_cert_ntf_type);
1626: --Enh 5606090: Language support for Certification Notification.
1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);

Line 1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);

1623: p_item_key => l_item_key);
1624:
1625: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_cert_ntf_type);
1626: --Enh 5606090: Language support for Certification Notification.
1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);

Line 1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);

1624:
1625: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_cert_ntf_type);
1626: --Enh 5606090: Language support for Certification Notification.
1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);

Line 1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);

1625: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_EVENT_FIRED', p_cert_ntf_type);
1626: --Enh 5606090: Language support for Certification Notification.
1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);
1633:

Line 1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);

1626: --Enh 5606090: Language support for Certification Notification.
1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);
1633:
1634: WF_ENGINE.STARTPROCESS(p_item_type, l_item_key);

Line 1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);

1627: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_NAME', p_certification_id);
1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);
1633:
1634: WF_ENGINE.STARTPROCESS(p_item_type, l_item_key);
1635:

Line 1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);

1628: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', l_end_date_active);
1629: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERTIFICATION_ID', p_certification_id);
1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);
1633:
1634: WF_ENGINE.STARTPROCESS(p_item_type, l_item_key);
1635:
1636: end initialize_cert_ntf_wf;

Line 1634: WF_ENGINE.STARTPROCESS(p_item_type, l_item_key);

1630: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_CERT_PRD_ENROLLMENT_ID', p_cert_prd_enrollment_id);
1631: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'PERSON_ID', p_person_id);
1632: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_NTF_COMMENTS', l_end_date_comments);
1633:
1634: WF_ENGINE.STARTPROCESS(p_item_type, l_item_key);
1635:
1636: end initialize_cert_ntf_wf;
1637:
1638: --

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

1861: select hr_workflow_item_key_s.nextval
1862: into l_item_key
1863: from sys.dual;
1864: -- get item key for the process
1865: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1866:
1867: -- set creator,current and supervisor name
1868: set_wf_item_attr(p_person_id => rec.person_id,
1869: p_item_type => l_item_type,

Line 1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);

1868: set_wf_item_attr(p_person_id => rec.person_id,
1869: p_item_type => l_item_type,
1870: p_item_key => l_item_key);
1871: --Enh 5606090: Language support for Forum Notification.
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);

Line 1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);

1869: p_item_type => l_item_type,
1870: p_item_key => l_item_key);
1871: --Enh 5606090: Language support for Forum Notification.
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);

Line 1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);

1870: p_item_key => l_item_key);
1871: --Enh 5606090: Language support for Forum Notification.
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1878:

Line 1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);

1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1878:
1879: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1880:

Line 1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);

1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1874: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1878:
1879: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1880:
1881: end loop;

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

1875:
1876: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1877: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1878:
1879: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1880:
1881: end loop;
1882:
1883: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1948: close csr_booking_status;
1949:
1950: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
1951:
1952: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1953: set_wf_item_attr(p_person_id => l_person_id, p_item_type => l_item_type, p_item_key => l_item_key);
1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);
1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);
1956: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);

Line 1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);

1950: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
1951:
1952: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1953: set_wf_item_attr(p_person_id => l_person_id, p_item_type => l_item_type, p_item_key => l_item_key);
1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);
1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);
1956: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1957:
1958: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);

1951:
1952: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1953: set_wf_item_attr(p_person_id => l_person_id, p_item_type => l_item_type, p_item_key => l_item_key);
1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);
1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);
1956: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1957:
1958: hr_utility.set_location('Leaving:'||l_proc, 10);
1959:

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

1952: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1953: set_wf_item_attr(p_person_id => l_person_id, p_item_type => l_item_type, p_item_key => l_item_key);
1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);
1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);
1956: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1957:
1958: hr_utility.set_location('Leaving:'||l_proc, 10);
1959:
1960: end init_course_eval_notif;

Line 1971: l_status_type := wf_engine.getItemAttrtext(itemtype => itemtype ,itemkey => itemkey ,aname => 'STATUS');

1967:
1968: l_status_type ota_booking_status_types.type%type;
1969: begin
1970: if(funcmode = 'RUN') then
1971: l_status_type := wf_engine.getItemAttrtext(itemtype => itemtype ,itemkey => itemkey ,aname => 'STATUS');
1972:
1973: If (l_status_type is not null and upper(l_status_type) = 'E') then
1974: resultout := 'COMPLETE:PENDING_EVAL';
1975: else

Line 2007: l_event_id := wf_engine.getItemAttrtext(itemtype => itemtype ,itemkey => itemkey ,aname => 'EVENT_ID');

2003: And OEV.event_id = p_event_id;
2004:
2005: begin
2006: if(funcmode = 'RUN') then
2007: l_event_id := wf_engine.getItemAttrtext(itemtype => itemtype ,itemkey => itemkey ,aname => 'EVENT_ID');
2008:
2009: OPEN delivery_mode(l_event_id);
2010: FETCH delivery_mode INTO l_synchronous_flag, l_online_flag;
2011: CLOSE delivery_mode;