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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'COMPLETION_DATE', l_end_date);

Line 896: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
897: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1030: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrText(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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrText(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.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrText(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.setitemattrText(p_item_type, l_item_key, 'TARGET_DATE', l_start_date);
1074: WF_ENGINE.setitemattrText(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 1390: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);

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

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

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

Line 1404: WF_ENGINE.setitemattrtext(p_item_type,

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

Line 1413: WF_ENGINE.setitemattrtext(p_item_type,

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

Line 1420: WF_ENGINE.setitemattrtext(p_item_type,

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

Line 1424: WF_ENGINE.setitemattrtext(p_item_type,

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

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

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

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

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

Line 1448: wf_engine.setitemattrtext

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

Line 1455: wf_engine.setitemattrtext

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

Line 1461: wf_engine.setitemattrnumber

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

Line 1476: WF_ENGINE.SetItemOwner(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1868: wf_engine.setitemattrtext(l_item_type,l_item_key, 'COURSE_NAME' ,p_Forum_message_id);
1869: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1870: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1871:
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1874:
1875: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1876:

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

1869: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_TITLE' ,l_subject);
1870: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1871:
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1874:
1875: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1876:
1877: end loop;

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

1871:
1872: wf_engine.setitemattrtext(l_item_type,l_item_key, 'LP_CREATOR_NAME' ,l_author_name);
1873: wf_engine.setitemattrtext(l_item_type,l_item_key, 'SECTION_NAME' ,l_message_body);
1874:
1875: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1876:
1877: end loop;
1878:
1879: hr_utility.set_location('Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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