110: --
111: -- Return process to run
112: --
113: l_resultout :=
114: wf_engine.getitemattrtext (
115: itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'TASK_EVENT'
118: );
287: RAISE fnd_api.g_exc_unexpected_error;
288: END IF;
289:
290: CLOSE c_task_details;
291: wf_engine.createprocess (
292: itemtype => 'JTFTASK',
293: itemkey => l_itemkey,
294: process => p_wf_process
295: );
292: itemtype => 'JTFTASK',
293: itemkey => l_itemkey,
294: process => p_wf_process
295: );
296: wf_engine.setitemuserkey (
297: itemtype => 'JTFTASK',
298: itemkey => l_itemkey,
299: userkey => l_task_name
300: );
298: itemkey => l_itemkey,
299: userkey => l_task_name
300: );
301:
302: wf_engine.setitemattrtext (
303: itemtype => 'JTFTASK',
304: itemkey => l_itemkey,
305: aname => 'TASK_NAME',
306: avalue => l_task_name
304: itemkey => l_itemkey,
305: aname => 'TASK_NAME',
306: avalue => l_task_name
307: );
308: wf_engine.setitemattrtext (
309: itemtype => 'JTFTASK',
310: itemkey => l_itemkey,
311: aname => 'TASK_DESC',
312: avalue => l_description
311: aname => 'TASK_DESC',
312: avalue => l_description
313: );
314:
315: wf_engine.setitemattrtext (
316: itemtype => 'JTFTASK',
317: itemkey => l_itemkey,
318: aname => 'TASK_NUMBER',
319: avalue => l_task_number
340: and b.language=userenv('lang')
341: and c.language=userenv('lang')
342: and d.language=userenv('lang');
343:
344: wf_engine.setitemattrtext (
345: itemtype => 'JTFTASK',
346: itemkey => l_itemkey,
347: aname => 'TASK_STATUS_NAME',
348: avalue => l_task_status_name
347: aname => 'TASK_STATUS_NAME',
348: avalue => l_task_status_name
349: );
350:
351: wf_engine.setitemattrtext (
352: itemtype => 'JTFTASK',
353: itemkey => l_itemkey,
354: aname => 'TASK_PRIORITY_NAME',
355: avalue => l_task_priority_name
354: aname => 'TASK_PRIORITY_NAME',
355: avalue => l_task_priority_name
356: );
357:
358: wf_engine.setitemattrtext (
359: itemtype => 'JTFTASK',
360: itemkey => l_itemkey,
361: aname => 'TASK_TYPE_NAME',
362: avalue => l_task_type_name
370: if l_owner_user_name is null then
371: raise fnd_api.g_exc_unexpected_error;
372: end if ;
373:
374: wf_engine.setitemattrtext (
375: itemtype => 'JTFTASK',
376: itemkey => l_itemkey,
377: aname => 'OWNER_ID',
378: avalue => l_owner_user_name
376: itemkey => l_itemkey,
377: aname => 'OWNER_ID',
378: avalue => l_owner_user_name
379: );
380: wf_engine.setitemattrtext (
381: itemtype => 'JTFTASK',
382: itemkey => l_itemkey,
383: aname => 'OWNER_NAME',
384: -- avalue => wf_directory.getroledisplayname (l_owner_user_name)
383: aname => 'OWNER_NAME',
384: -- avalue => wf_directory.getroledisplayname (l_owner_user_name)
385: avalue => jtf_task_utl.get_owner(l_owner_code, l_owner_id)
386: );
387: wf_engine.setitemattrtext (
388: itemtype => 'JTFTASK',
389: itemkey => l_itemkey,
390: aname => 'TASK_DESC',
391: avalue => l_description
412:
413:
414:
415:
416: wf_engine.setitemattrtext (
417: itemtype => 'JTFTASK',
418: itemkey => l_itemkey,
419: aname => 'TASK_EVENT',
420: avalue => 'NOTIFY_NEW_ASSIGNEE'
419: aname => 'TASK_EVENT',
420: avalue => 'NOTIFY_NEW_ASSIGNEE'
421: );
422:
423: wf_engine.setitemattrtext (
424: itemtype => 'JTFTASK',
425: itemkey => l_itemkey,
426: aname => 'NEW_TASK_ASSIGNEE_ID',
427: avalue => l_new_assigned_user_name
428: );
429:
430:
431:
432: wf_engine.setitemattrtext (
433: itemtype => 'JTFTASK',
434: itemkey => l_itemkey,
435: aname => 'NEW_TASK_ASSIGNEE_NAME',
436: avalue => wf_directory.getroledisplayname (
470: raise fnd_api.g_exc_unexpected_error;
471: end if ;
472:
473:
474: wf_engine.setitemattrtext (
475: itemtype => 'JTFTASK',
476: itemkey => l_itemkey,
477: aname => 'TASK_EVENT',
478: avalue => 'CHANGE_ASSIGNEE'
477: aname => 'TASK_EVENT',
478: avalue => 'CHANGE_ASSIGNEE'
479: );
480:
481: wf_engine.setitemattrtext (
482: itemtype => 'JTFTASK',
483: itemkey => l_itemkey,
484: aname => 'NEW_TASK_ASSIGNEE_ID',
485: avalue => l_new_assigned_user_name
487:
488:
489:
490:
491: wf_engine.setitemattrtext (
492: itemtype => 'JTFTASK',
493: itemkey => l_itemkey,
494: aname => 'NEW_TASK_ASSIGNEE_NAME',
495: avalue => wf_directory.getroledisplayname (
496: l_new_assigned_user_name
497: )
498: );
499:
500: wf_engine.setitemattrtext (
501: itemtype => 'JTFTASK',
502: itemkey => l_itemkey,
503: aname => 'OLD_TASK_ASSIGNEE_ID',
504: avalue => l_old_assigned_user_name
505: );
506:
507:
508:
509: wf_engine.setitemattrtext (
510: itemtype => 'JTFTASK',
511: itemkey => l_itemkey,
512: aname => 'OLD_TASK_ASSIGNEE_NAME',
513: avalue => wf_directory.getroledisplayname (
533:
534: if l_old_assigned_user_name is null then
535: raise fnd_api.g_exc_unexpected_error;
536: end if ;
537: wf_engine.setitemattrtext (
538: itemtype => 'JTFTASK',
539: itemkey => l_itemkey,
540: aname => 'TASK_EVENT',
541: avalue => 'ASSIGNEE_REMOVAL'
539: itemkey => l_itemkey,
540: aname => 'TASK_EVENT',
541: avalue => 'ASSIGNEE_REMOVAL'
542: );
543: wf_engine.setitemattrtext (
544: itemtype => 'JTFTASK',
545: itemkey => l_itemkey,
546: aname => 'OLD_TASK_ASSIGNEE_ID',
547: avalue => l_old_assigned_user_name
545: itemkey => l_itemkey,
546: aname => 'OLD_TASK_ASSIGNEE_ID',
547: avalue => l_old_assigned_user_name
548: );
549: wf_engine.setitemattrtext (
550: itemtype => 'JTFTASK',
551: itemkey => l_itemkey,
552: aname => 'OLD_TASK_ASSIGNEE_NAME',
553: avalue => wf_directory.getroledisplayname (
580: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_owner_id );
581: if l_old_assigned_user_name is null then
582: raise fnd_api.g_exc_unexpected_error;
583: end if ;
584: wf_engine.setitemattrtext (
585: itemtype => 'JTFTASK',
586: itemkey => l_itemkey,
587: aname => 'TASK_EVENT',
588: avalue => 'CHANGE_OWNER'
586: itemkey => l_itemkey,
587: aname => 'TASK_EVENT',
588: avalue => 'CHANGE_OWNER'
589: );
590: wf_engine.setitemattrtext (
591: itemtype => 'JTFTASK',
592: itemkey => l_itemkey,
593: aname => 'OLD_TASK_OWNER_ID',
594: avalue => l_old_assigned_user_name
592: itemkey => l_itemkey,
593: aname => 'OLD_TASK_OWNER_ID',
594: avalue => l_old_assigned_user_name
595: );
596: wf_engine.setitemattrtext (
597: itemtype => 'JTFTASK',
598: itemkey => l_itemkey,
599: aname => 'OLD_TASK_OWNER_NAME',
600: avalue => wf_directory.getroledisplayname (
600: avalue => wf_directory.getroledisplayname (
601: l_old_assigned_user_name
602: )
603: );
604: wf_engine.setitemattrtext (
605: itemtype => 'JTFTASK',
606: itemkey => l_itemkey,
607: aname => 'NEW_TASK_OWNER_ID',
608: avalue => l_new_assigned_user_name
606: itemkey => l_itemkey,
607: aname => 'NEW_TASK_OWNER_ID',
608: avalue => l_new_assigned_user_name
609: );
610: wf_engine.setitemattrtext (
611: itemtype => 'JTFTASK',
612: itemkey => l_itemkey,
613: aname => 'NEW_TASK_OWNER_NAME',
614: avalue => wf_directory.getroledisplayname (
620:
621:
622: IF p_event = 'CHANGE_TASK_DETAILS'
623: THEN
624: wf_engine.setitemattrtext (
625: itemtype => 'JTFTASK',
626: itemkey => l_itemkey,
627: aname => 'TASK_EVENT',
628: avalue => 'CHANGE_TASK_DETAILS'
651: fnd_message.set_name ('JTF', 'JTF_TASK_NO_ATTRIBUTES_PASSED');
652: fnd_msg_pub.add;
653: END IF;
654:
655: wf_engine.setitemattrtext (
656: itemtype => 'JTFTASK',
657: itemkey => l_itemkey,
658: aname => 'TASK_TEXT',
659: avalue => source_text
661: END IF;
662:
663:
664:
665: wf_engine.startprocess (
666: itemtype => 'JTFTASK',
667: itemkey => l_itemkey
668: );
669:
795: raise fnd_api.g_exc_unexpected_error;
796: end if ;
797:
798:
799: wf_engine.abortprocess (
800: itemtype => 'JTFTASK',
801: itemkey => l_itemkey
802: );
803: l_context := 'JTFTASK' ||
809: wf_notification.send (
810: role => l_task_owner_name,
811: msg_type => 'JTFTASK',
812: msg_name => 'ABORT_MSG',
813: callback => 'WF_ENGINE.CB',
814: context => l_context
815: );
816: wf_engine.setitemattrtext (
817: itemtype => 'JTFTASK',
812: msg_name => 'ABORT_MSG',
813: callback => 'WF_ENGINE.CB',
814: context => l_context
815: );
816: wf_engine.setitemattrtext (
817: itemtype => 'JTFTASK',
818: itemkey => l_itemkey,
819: aname => 'ABORTED_BY_NAME',
820: avalue => wf_directory.getroledisplayname (l_aborted_by_user_name)
823: nid => l_notification_id,
824: aname => 'ABORTED_BY',
825: avalue => l_aborted_by_user_name
826: );
827: wf_engine.setitemattrtext (
828: itemtype => 'JTFTASK',
829: itemkey => l_itemkey,
830: aname => 'TASK_NAME',
831: avalue => l_task_name
829: itemkey => l_itemkey,
830: aname => 'TASK_NAME',
831: avalue => l_task_name
832: );
833: wf_engine.setitemattrtext (
834: itemtype => 'JTFTASK',
835: itemkey => l_itemkey,
836: aname => 'TASK_DESC',
837: avalue => l_description