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.CAC_VIEW_WF_PVT dependencies on WF_ENGINE

Line 340: wf_engine.CreateProcess( itemtype => l_item_type

336:
337: /***************************************************************************
338: ** Initialize the workflow
339: ***************************************************************************/
340: wf_engine.CreateProcess( itemtype => l_item_type
341: , itemkey => l_item_key
342: , process => 'REQUEST_SUBSCRIBTION'
343: );
344:

Line 348: wf_engine.SetItemAttrNumber( itemtype => l_item_type

344:
345: /***************************************************************************
346: ** Init Group info
347: ***************************************************************************/
348: wf_engine.SetItemAttrNumber( itemtype => l_item_type
349: , itemkey => l_item_key
350: , aname => 'GROUP_ID'
351: , avalue => p_GROUP_ID
352: );

Line 354: wf_engine.SetItemAttrText( itemtype => l_item_type

350: , aname => 'GROUP_ID'
351: , avalue => p_GROUP_ID
352: );
353:
354: wf_engine.SetItemAttrText( itemtype => l_item_type
355: , itemkey => l_item_key
356: , aname => 'CALENDAR_ADMIN'
357: , avalue => l_cal_admin_role
358: );

Line 360: wf_engine.SetItemAttrText( itemtype => l_item_type

356: , aname => 'CALENDAR_ADMIN'
357: , avalue => l_cal_admin_role
358: );
359:
360: wf_engine.SetItemAttrText( itemtype => l_item_type
361: , itemkey => l_item_key
362: , aname => 'GROUP_NAME'
363: , avalue => p_GROUP_NAME
364: );

Line 367: wf_engine.SetItemAttrText( itemtype => l_item_type

363: , avalue => p_GROUP_NAME
364: );
365:
366:
367: wf_engine.SetItemAttrText( itemtype => l_item_type
368: , itemkey => l_item_key
369: , aname => 'GROUP_DESCRIPTION'
370: , avalue => p_GROUP_DESCRIPTION
371: );

Line 383: wf_engine.SetItemAttrNumber( itemtype => l_item_type

379: , l_requestor_name
380: , l_requestor_emp_number
381: );
382:
383: wf_engine.SetItemAttrNumber( itemtype => l_item_type
384: , itemkey => l_item_key
385: , aname => 'CALENDAR_REQUESTOR'
386: , avalue => p_CALENDAR_REQUESTOR
387: );

Line 389: wf_engine.SetItemAttrText( itemtype => l_item_type

385: , aname => 'CALENDAR_REQUESTOR'
386: , avalue => p_CALENDAR_REQUESTOR
387: );
388:
389: wf_engine.SetItemAttrText( itemtype => l_item_type
390: , itemkey => l_item_key
391: , aname => 'CALENDAR_REQUESTOR_NAME'
392: , avalue => l_requestor_name
393: );

Line 395: wf_engine.SetItemAttrText( itemtype => l_item_type

391: , aname => 'CALENDAR_REQUESTOR_NAME'
392: , avalue => l_requestor_name
393: );
394:
395: wf_engine.SetItemAttrText( itemtype => l_item_type
396: , itemkey => l_item_key
397: , aname => 'CALENDAR_REQUESTOR_ROLE'
398: , avalue => l_requestor_role
399: );

Line 425: wf_engine.SetItemAttrNumber( itemtype => l_item_type

421: , l_admin_name
422: , l_admin_emp_number
423: );
424:
425: wf_engine.SetItemAttrNumber( itemtype => l_item_type
426: , itemkey => l_item_key
427: , aname => 'GROUP_CALENDAR_ADMIN'
428: , avalue => r_Admin.ResourceID
429: );

Line 448: wf_engine.SetItemAttrText( itemtype => l_item_type

444: role_orig_system_id => 0,
445: validateUserRole => FALSE);
446: END;*/
447: END LOOP ADMINS;
448: wf_engine.SetItemAttrText( itemtype => l_item_type
449: , itemkey => l_item_key
450: , aname => 'GROUP_CALENDAR_ADMIN_ROLE'
451: , avalue => l_adhoc_role
452: );

Line 454: wf_engine.SetItemAttrText( itemtype => l_item_type

450: , aname => 'GROUP_CALENDAR_ADMIN_ROLE'
451: , avalue => l_adhoc_role
452: );
453:
454: wf_engine.SetItemAttrText( itemtype => l_item_type
455: , itemkey => l_item_key
456: , aname => 'GROUP_CALENDAR_ADMIN_NAME'
457: , avalue => l_adhoc_role
458: );

Line 463: wf_engine.StartProcess( itemtype => l_item_type

459:
460: /***************************************************************************
461: ** Start the workflow
462: ***************************************************************************/
463: wf_engine.StartProcess( itemtype => l_item_type
464: , itemkey => l_item_key
465: );
466:
467:

Line 632: wf_engine.CreateProcess( itemtype => l_item_type

628:
629: /***************************************************************************
630: ** Initialize the workflow
631: ***************************************************************************/
632: wf_engine.CreateProcess( itemtype => l_item_type
633: , itemkey => l_item_key
634: , process => 'PROCESS_INVITATION'
635: );
636: wf_engine.SetItemAttrNumber

Line 636: wf_engine.SetItemAttrNumber

632: wf_engine.CreateProcess( itemtype => l_item_type
633: , itemkey => l_item_key
634: , process => 'PROCESS_INVITATION'
635: );
636: wf_engine.SetItemAttrNumber
637: ( itemtype => l_item_type
638: , itemkey => l_item_key
639: , aname => 'TASK_ID'
640: , avalue => l_invitor.task_id

Line 643: wf_engine.SetItemAttrNumber

639: , aname => 'TASK_ID'
640: , avalue => l_invitor.task_id
641: );
642:
643: wf_engine.SetItemAttrNumber
644: ( itemtype => l_item_type
645: , itemkey => l_item_key
646: , aname => 'ASSIGNMENT_STATUS_ID'
647: , avalue => p_assignment_status_id

Line 649: wf_engine.SetItemAttrText

645: , itemkey => l_item_key
646: , aname => 'ASSIGNMENT_STATUS_ID'
647: , avalue => p_assignment_status_id
648: );
649: wf_engine.SetItemAttrText
650: ( itemtype => l_item_type
651: , itemkey => l_item_key
652: , aname => 'TASK_DESCRIPTION'
653: , avalue => l_invitor.description

Line 655: wf_engine.SetItemAttrText

651: , itemkey => l_item_key
652: , aname => 'TASK_DESCRIPTION'
653: , avalue => l_invitor.description
654: );
655: wf_engine.SetItemAttrText
656: ( itemtype => l_item_type
657: , itemkey => l_item_key
658: , aname => 'TASK_NAME'
659: , avalue => l_invitor.task_name

Line 662: wf_engine.SetItemAttrDate

658: , aname => 'TASK_NAME'
659: , avalue => l_invitor.task_name
660: );
661:
662: wf_engine.SetItemAttrDate
663: ( itemtype => l_item_type
664: , itemkey => l_item_key
665: , aname => 'START_DATE'
666: , avalue => l_invitor.startDate

Line 668: wf_engine.SetItemAttrText

664: , itemkey => l_item_key
665: , aname => 'START_DATE'
666: , avalue => l_invitor.startDate
667: );
668: wf_engine.SetItemAttrText
669: ( itemtype => l_item_type
670: , itemkey => l_item_key
671: , aname => 'DURATION'
672: , avalue => get_duration(l_invitor.duration)

Line 674: wf_engine.SetItemAttrNumber( itemtype => l_item_type

670: , itemkey => l_item_key
671: , aname => 'DURATION'
672: , avalue => get_duration(l_invitor.duration)
673: );
674: wf_engine.SetItemAttrNumber( itemtype => l_item_type
675: , itemkey => l_item_key
676: , aname => 'INVITEE'
677: , avalue => p_resource_id
678: );

Line 680: wf_engine.SetItemAttrText( itemtype => l_item_type

676: , aname => 'INVITEE'
677: , avalue => p_resource_id
678: );
679:
680: wf_engine.SetItemAttrText( itemtype => l_item_type
681: , itemkey => l_item_key
682: , aname => 'CALENDAR_ADMIN'
683: , avalue => l_cal_admin_role
684: );

Line 686: wf_engine.SetItemAttrText( itemtype => l_item_type

682: , aname => 'CALENDAR_ADMIN'
683: , avalue => l_cal_admin_role
684: );
685:
686: wf_engine.SetItemAttrText( itemtype => l_item_type
687: , itemkey => l_item_key
688: , aname => 'INVITOR'
689: , avalue => l_invitor.owner_id
690: );

Line 691: wf_engine.SetItemAttrText( itemtype => l_item_type

687: , itemkey => l_item_key
688: , aname => 'INVITOR'
689: , avalue => l_invitor.owner_id
690: );
691: wf_engine.SetItemAttrText( itemtype => l_item_type
692: , itemkey => l_item_key
693: , aname => 'TIMEZONE'
694: , avalue => l_timezone
695: );

Line 696: wf_engine.SetItemAttrText( itemtype => l_item_type

692: , itemkey => l_item_key
693: , aname => 'TIMEZONE'
694: , avalue => l_timezone
695: );
696: wf_engine.SetItemAttrText( itemtype => l_item_type
697: , itemkey => l_item_key
698: , aname => 'TYPE'
699: , avalue => l_task_type_name
700: );

Line 701: wf_engine.SetItemAttrText( itemtype => l_item_type

697: , itemkey => l_item_key
698: , aname => 'TYPE'
699: , avalue => l_task_type_name
700: );
701: wf_engine.SetItemAttrText( itemtype => l_item_type
702: , itemkey => l_item_key
703: , aname => 'PRIORITY'
704: , avalue => l_task_priority_name
705: );

Line 709: wf_engine.StartProcess( itemtype => l_item_type

705: );
706: /***************************************************************************
707: ** Start the workflow
708: ***************************************************************************/
709: wf_engine.StartProcess( itemtype => l_item_type
710: , itemkey => l_item_key
711: );
712: /***************************************************************************
713: ** Standard check of p_commit (WF won't start until commited)

Line 798: l_RequestorID := wf_engine.GetItemAttrNumber

794:
795: /*****************************************************************************
796: ** Get the WF attribute values
797: *****************************************************************************/
798: l_RequestorID := wf_engine.GetItemAttrNumber
799: ( itemtype => itemtype
800: , itemkey => itemkey
801: , aname => 'CALENDAR_REQUESTOR'
802: );

Line 804: l_GroupID := wf_engine.GetItemAttrNumber

800: , itemkey => itemkey
801: , aname => 'CALENDAR_REQUESTOR'
802: );
803:
804: l_GroupID := wf_engine.GetItemAttrNumber
805: ( itemtype => itemtype
806: , itemkey => itemkey
807: , aname => 'GROUP_ID'
808: );

Line 810: l_GroupName := wf_engine.GetItemAttrText

806: , itemkey => itemkey
807: , aname => 'GROUP_ID'
808: );
809:
810: l_GroupName := wf_engine.GetItemAttrText
811: ( itemtype => itemtype
812: , itemkey => itemkey
813: , aname => 'GROUP_NAME'
814: );

Line 816: l_GroupDescription := wf_engine.GetItemAttrText

812: , itemkey => itemkey
813: , aname => 'GROUP_NAME'
814: );
815:
816: l_GroupDescription := wf_engine.GetItemAttrText
817: ( itemtype => itemtype
818: , itemkey => itemkey
819: , aname => 'GROUP_DESCRIPTION'
820: );

Line 822: l_Response := wf_engine.GetItemAttrText

818: , itemkey => itemkey
819: , aname => 'GROUP_DESCRIPTION'
820: );
821:
822: l_Response := wf_engine.GetItemAttrText
823: ( itemtype => itemtype
824: , itemkey => itemkey
825: , aname => 'ACCESS_LEVEL');
826:

Line 894: wf_engine.SetItemAttrText( itemtype => itemtype

890: THEN
891: /*****************************************************************************
892: ** Something went wrong return 'ERROR' and set the ERROR_MESSAGE
893: *****************************************************************************/
894: wf_engine.SetItemAttrText( itemtype => itemtype
895: , itemkey => itemkey
896: , aname => 'ERROR_MESSAGE'
897: , avalue => 'CAC_VIEW_WF_PVT.ProcessSubscription(): ' || to_char(SQLCODE)||':'||SQLERRM
898: );

Line 1009: wf_engine.CreateProcess( itemtype => l_ItemType

1005:
1006: /***************************************************************************
1007: ** Initialize the workflow
1008: ***************************************************************************/
1009: wf_engine.CreateProcess( itemtype => l_ItemType
1010: , itemkey => l_ItemKey
1011: , process => 'REQUEST_CALENDAR'
1012: );
1013:

Line 1014: wf_engine.SetItemAttrText( itemtype => l_itemtype

1010: , itemkey => l_ItemKey
1011: , process => 'REQUEST_CALENDAR'
1012: );
1013:
1014: wf_engine.SetItemAttrText( itemtype => l_itemtype
1015: , itemkey => l_ItemKey
1016: , aname => 'CALENDAR_ADMIN'
1017: , avalue => l_AdminWFRole
1018: );

Line 1020: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1016: , aname => 'CALENDAR_ADMIN'
1017: , avalue => l_AdminWFRole
1018: );
1019:
1020: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1021: , itemkey => l_ItemKey
1022: , aname => 'CALENDAR_REQUESTOR'
1023: , avalue => p_CALENDAR_REQUESTOR
1024: );

Line 1026: wf_engine.SetItemAttrText( itemtype => l_itemtype

1022: , aname => 'CALENDAR_REQUESTOR'
1023: , avalue => p_CALENDAR_REQUESTOR
1024: );
1025:
1026: wf_engine.SetItemAttrText( itemtype => l_itemtype
1027: , itemkey => l_ItemKey
1028: , aname => 'CALENDAR_REQUESTOR_ROLE'
1029: , avalue => l_RequestorWFRole
1030: );

Line 1032: wf_engine.SetItemAttrText( itemtype => l_itemtype

1028: , aname => 'CALENDAR_REQUESTOR_ROLE'
1029: , avalue => l_RequestorWFRole
1030: );
1031:
1032: wf_engine.SetItemAttrText( itemtype => l_itemtype
1033: , itemkey => l_ItemKey
1034: , aname => 'CALENDAR_REQUESTOR_NAME'
1035: , avalue => l_RequestorWFName
1036: );

Line 1038: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1034: , aname => 'CALENDAR_REQUESTOR_NAME'
1035: , avalue => l_RequestorWFName
1036: );
1037:
1038: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1039: , itemkey => l_ItemKey
1040: , aname => 'GROUP_ID'
1041: , avalue => p_GROUP_ID
1042: );

Line 1044: wf_engine.SetItemAttrText( itemtype => l_itemtype

1040: , aname => 'GROUP_ID'
1041: , avalue => p_GROUP_ID
1042: );
1043:
1044: wf_engine.SetItemAttrText( itemtype => l_itemtype
1045: , itemkey => l_ItemKey
1046: , aname => 'GROUP_NAME'
1047: , avalue => p_GROUP_NAME
1048: );

Line 1050: wf_engine.SetItemAttrText( itemtype => l_itemtype

1046: , aname => 'GROUP_NAME'
1047: , avalue => p_GROUP_NAME
1048: );
1049:
1050: wf_engine.SetItemAttrText( itemtype => l_itemtype
1051: , itemkey => l_ItemKey
1052: , aname => 'GROUP_DESCRIPTION'
1053: , avalue => p_GROUP_DESCRIPTION
1054: );

Line 1056: wf_engine.SetItemAttrText( itemtype => l_itemtype

1052: , aname => 'GROUP_DESCRIPTION'
1053: , avalue => p_GROUP_DESCRIPTION
1054: );
1055:
1056: wf_engine.SetItemAttrText( itemtype => l_itemtype
1057: , itemkey => l_ItemKey
1058: , aname => 'PUBLIC'
1059: , avalue => p_PUBLIC
1060: );

Line 1065: wf_engine.StartProcess( itemtype => l_itemtype

1061:
1062: /***************************************************************************
1063: ** Start the workflow
1064: ***************************************************************************/
1065: wf_engine.StartProcess( itemtype => l_itemtype
1066: , itemkey => l_ItemKey
1067: );
1068:
1069: /***************************************************************************

Line 1197: l_RequestorID := wf_engine.GetItemAttrNumber

1193:
1194: /*****************************************************************************
1195: ** Get the WF attribute values
1196: *****************************************************************************/
1197: l_RequestorID := wf_engine.GetItemAttrNumber
1198: ( itemtype => itemtype
1199: , itemkey => itemkey
1200: , aname => 'CALENDAR_REQUESTOR'
1201: );

Line 1203: l_GroupID := wf_engine.GetItemAttrNumber

1199: , itemkey => itemkey
1200: , aname => 'CALENDAR_REQUESTOR'
1201: );
1202:
1203: l_GroupID := wf_engine.GetItemAttrNumber
1204: ( itemtype => itemtype
1205: , itemkey => itemkey
1206: , aname => 'GROUP_ID'
1207: );

Line 1209: l_GroupName := wf_engine.GetItemAttrText

1205: , itemkey => itemkey
1206: , aname => 'GROUP_ID'
1207: );
1208:
1209: l_GroupName := wf_engine.GetItemAttrText
1210: ( itemtype => itemtype
1211: , itemkey => itemkey
1212: , aname => 'GROUP_NAME'
1213: );

Line 1215: l_GroupDescription := wf_engine.GetItemAttrText

1211: , itemkey => itemkey
1212: , aname => 'GROUP_NAME'
1213: );
1214:
1215: l_GroupDescription := wf_engine.GetItemAttrText
1216: ( itemtype => itemtype
1217: , itemkey => itemkey
1218: , aname => 'GROUP_DESCRIPTION'
1219: );

Line 1221: l_PublicFlag := wf_engine.GetItemAttrText

1217: , itemkey => itemkey
1218: , aname => 'GROUP_DESCRIPTION'
1219: );
1220:
1221: l_PublicFlag := wf_engine.GetItemAttrText
1222: ( itemtype => itemtype
1223: , itemkey => itemkey
1224: , aname => 'PUBLIC'
1225: );

Line 1413: wf_engine.SetItemAttrText( itemtype => itemtype

1409:
1410: /*****************************************************************************
1411: ** Something went wrong return 'ERROR' and set the ERROR_MESSAGE
1412: *****************************************************************************/
1413: wf_engine.SetItemAttrText( itemtype => itemtype
1414: , itemkey => itemkey
1415: , aname => 'ERROR_MESSAGE'
1416: , avalue => 'CAC_VIEW_WF_PVT.ProcessRequest(): ' || to_char(SQLCODE)||':'||SQLERRM
1417: );

Line 1540: wf_engine.CreateProcess( itemtype => l_ItemType

1536: ***************************************************************************/
1537: l_task_type_name := get_type_name(r_Task.TYPE_ID);
1538: l_task_priority_name := get_priority_name(r_Task.PRIORITY_ID);
1539: l_timezone := GetTimezone(p_timezone_id => r_Task.TIMEZONE_ID);
1540: wf_engine.CreateProcess( itemtype => l_ItemType
1541: , itemkey => r_Task.ItemKey
1542: , process => 'SEND_INVITATION'
1543: );
1544:

Line 1545: wf_engine.SetItemAttrText( itemtype => l_itemtype

1541: , itemkey => r_Task.ItemKey
1542: , process => 'SEND_INVITATION'
1543: );
1544:
1545: wf_engine.SetItemAttrText( itemtype => l_itemtype
1546: , itemkey => r_Task.ItemKey
1547: , aname => 'CALENDAR_ADMIN'
1548: , avalue => l_AdminWFRole
1549: );

Line 1551: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1547: , aname => 'CALENDAR_ADMIN'
1548: , avalue => l_AdminWFRole
1549: );
1550:
1551: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1552: , itemkey => r_Task.ItemKey
1553: , aname => 'INVITEE'
1554: , avalue => r_Task.INVITEE
1555: );

Line 1558: wf_engine.SetItemAttrText( itemtype => l_itemtype

1554: , avalue => r_Task.INVITEE
1555: );
1556: ---Enh # 3443999, amigupta, Setting new attribute value INVITEE_CODE for handling Resource_type_Code also
1557:
1558: wf_engine.SetItemAttrText( itemtype => l_itemtype
1559: , itemkey => r_Task.ItemKey
1560: , aname => 'INVITEE_CODE'
1561: , avalue => r_Task.INVITEE_CODE
1562: );

Line 1564: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1560: , aname => 'INVITEE_CODE'
1561: , avalue => r_Task.INVITEE_CODE
1562: );
1563:
1564: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1565: , itemkey => r_Task.ItemKey
1566: , aname => 'TASK_ASSIGNMENT_ID'
1567: , avalue => r_Task.TASK_ASSIGNMENT_ID
1568: );

Line 1570: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1566: , aname => 'TASK_ASSIGNMENT_ID'
1567: , avalue => r_Task.TASK_ASSIGNMENT_ID
1568: );
1569:
1570: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1571: , itemkey => r_Task.ItemKey
1572: , aname => 'INVITOR'
1573: , avalue => p_INVITOR
1574: );

Line 1576: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1572: , aname => 'INVITOR'
1573: , avalue => p_INVITOR
1574: );
1575:
1576: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1577: , itemkey => r_Task.ItemKey
1578: , aname => 'TASK_ID'
1579: , avalue => p_TaskID
1580: );

Line 1582: wf_engine.SetItemAttrText( itemtype => l_itemtype

1578: , aname => 'TASK_ID'
1579: , avalue => p_TaskID
1580: );
1581:
1582: wf_engine.SetItemAttrText( itemtype => l_itemtype
1583: , itemkey => r_Task.ItemKey
1584: , aname => 'TASK_NAME'
1585: , avalue => r_Task.TASK_NAME
1586: );

Line 1588: wf_engine.SetItemAttrText( itemtype => l_itemtype

1584: , aname => 'TASK_NAME'
1585: , avalue => r_Task.TASK_NAME
1586: );
1587:
1588: wf_engine.SetItemAttrText( itemtype => l_itemtype
1589: , itemkey => r_Task.ItemKey
1590: , aname => 'TASK_DESCRIPTION'
1591: , avalue => r_Task.TASK_DESCRIPTION
1592: );

Line 1594: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1590: , aname => 'TASK_DESCRIPTION'
1591: , avalue => r_Task.TASK_DESCRIPTION
1592: );
1593:
1594: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1595: , itemkey => r_Task.ItemKey
1596: , aname => 'START_DATE'
1597: , avalue => r_Task.START_DATE
1598: );

Line 1600: wf_engine.SetItemAttrText( itemtype => l_itemtype

1596: , aname => 'START_DATE'
1597: , avalue => r_Task.START_DATE
1598: );
1599:
1600: wf_engine.SetItemAttrText( itemtype => l_itemtype
1601: , itemkey => r_Task.ItemKey
1602: , aname => 'TYPE'
1603: , avalue => l_task_type_name
1604: );

Line 1605: wf_engine.SetItemAttrText( itemtype => l_itemtype

1601: , itemkey => r_Task.ItemKey
1602: , aname => 'TYPE'
1603: , avalue => l_task_type_name
1604: );
1605: wf_engine.SetItemAttrText( itemtype => l_itemtype
1606: , itemkey => r_Task.ItemKey
1607: , aname => 'PRIORITY'
1608: , avalue => l_task_priority_name
1609: );

Line 1610: wf_engine.SetItemAttrText( itemtype => l_itemtype

1606: , itemkey => r_Task.ItemKey
1607: , aname => 'PRIORITY'
1608: , avalue => l_task_priority_name
1609: );
1610: wf_engine.SetItemAttrText( itemtype => l_itemtype
1611: , itemkey => r_Task.ItemKey
1612: , aname => 'DURATION'
1613: , avalue => get_duration(r_Task.DURATION)
1614: );

Line 1615: wf_engine.SetItemAttrText( itemtype => l_itemtype

1611: , itemkey => r_Task.ItemKey
1612: , aname => 'DURATION'
1613: , avalue => get_duration(r_Task.DURATION)
1614: );
1615: wf_engine.SetItemAttrText( itemtype => l_itemtype
1616: , itemkey => r_Task.ItemKey
1617: , aname => 'TIMEZONE'
1618: , avalue => l_timezone
1619: );

Line 1624: wf_engine.StartProcess( itemtype => l_itemtype

1620:
1621: /***************************************************************************
1622: ** Start the workflow
1623: ***************************************************************************/
1624: wf_engine.StartProcess( itemtype => l_itemtype
1625: , itemkey => r_Task.ItemKey
1626: );
1627:
1628:

Line 1789: wf_engine.CreateProcess( itemtype => l_ItemType

1785: ***************************************************************************/
1786: l_task_type_name := get_type_name(r_Task.TYPE_ID);
1787: l_task_priority_name := get_priority_name(r_Task.PRIORITY_ID);
1788: l_timezone := GetTimezone(p_timezone_id => r_Task.TIMEZONE_ID);
1789: wf_engine.CreateProcess( itemtype => l_ItemType
1790: , itemkey => r_Task.ItemKey
1791: , process => 'SEND_INVITATION'
1792: );
1793:

Line 1794: wf_engine.SetItemAttrText( itemtype => l_itemtype

1790: , itemkey => r_Task.ItemKey
1791: , process => 'SEND_INVITATION'
1792: );
1793:
1794: wf_engine.SetItemAttrText( itemtype => l_itemtype
1795: , itemkey => r_Task.ItemKey
1796: , aname => 'CALENDAR_ADMIN'
1797: , avalue => l_AdminWFRole
1798: );

Line 1800: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1796: , aname => 'CALENDAR_ADMIN'
1797: , avalue => l_AdminWFRole
1798: );
1799:
1800: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1801: , itemkey => r_Task.ItemKey
1802: , aname => 'INVITEE'
1803: , avalue => r_Task.INVITEE
1804: );

Line 1807: wf_engine.SetItemAttrText( itemtype => l_itemtype

1803: , avalue => r_Task.INVITEE
1804: );
1805: ---Enh # 3443999, amigupta, Setting new attribute value INVITEE_CODE for handling Resource_type_Code also
1806:
1807: wf_engine.SetItemAttrText( itemtype => l_itemtype
1808: , itemkey => r_Task.ItemKey
1809: , aname => 'INVITEE_CODE'
1810: , avalue => r_Task.INVITEE_CODE
1811: );

Line 1813: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1809: , aname => 'INVITEE_CODE'
1810: , avalue => r_Task.INVITEE_CODE
1811: );
1812:
1813: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1814: , itemkey => r_Task.ItemKey
1815: , aname => 'TASK_ASSIGNMENT_ID'
1816: , avalue => r_Task.TASK_ASSIGNMENT_ID
1817: );

Line 1819: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1815: , aname => 'TASK_ASSIGNMENT_ID'
1816: , avalue => r_Task.TASK_ASSIGNMENT_ID
1817: );
1818:
1819: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1820: , itemkey => r_Task.ItemKey
1821: , aname => 'INVITOR'
1822: , avalue => p_INVITOR
1823: );

Line 1825: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1821: , aname => 'INVITOR'
1822: , avalue => p_INVITOR
1823: );
1824:
1825: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1826: , itemkey => r_Task.ItemKey
1827: , aname => 'TASK_ID'
1828: , avalue => p_TaskID
1829: );

Line 1831: wf_engine.SetItemAttrText( itemtype => l_itemtype

1827: , aname => 'TASK_ID'
1828: , avalue => p_TaskID
1829: );
1830:
1831: wf_engine.SetItemAttrText( itemtype => l_itemtype
1832: , itemkey => r_Task.ItemKey
1833: , aname => 'TASK_NAME'
1834: , avalue => r_Task.TASK_NAME
1835: );

Line 1837: wf_engine.SetItemAttrText( itemtype => l_itemtype

1833: , aname => 'TASK_NAME'
1834: , avalue => r_Task.TASK_NAME
1835: );
1836:
1837: wf_engine.SetItemAttrText( itemtype => l_itemtype
1838: , itemkey => r_Task.ItemKey
1839: , aname => 'TASK_DESCRIPTION'
1840: , avalue => r_Task.TASK_DESCRIPTION
1841: );

Line 1843: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1839: , aname => 'TASK_DESCRIPTION'
1840: , avalue => r_Task.TASK_DESCRIPTION
1841: );
1842:
1843: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1844: , itemkey => r_Task.ItemKey
1845: , aname => 'START_DATE'
1846: , avalue => r_Task.START_DATE
1847: );

Line 1849: wf_engine.SetItemAttrText( itemtype => l_itemtype

1845: , aname => 'START_DATE'
1846: , avalue => r_Task.START_DATE
1847: );
1848:
1849: wf_engine.SetItemAttrText( itemtype => l_itemtype
1850: , itemkey => r_Task.ItemKey
1851: , aname => 'TYPE'
1852: , avalue => l_task_type_name
1853: );

Line 1854: wf_engine.SetItemAttrText( itemtype => l_itemtype

1850: , itemkey => r_Task.ItemKey
1851: , aname => 'TYPE'
1852: , avalue => l_task_type_name
1853: );
1854: wf_engine.SetItemAttrText( itemtype => l_itemtype
1855: , itemkey => r_Task.ItemKey
1856: , aname => 'PRIORITY'
1857: , avalue => l_task_priority_name
1858: );

Line 1859: wf_engine.SetItemAttrText( itemtype => l_itemtype

1855: , itemkey => r_Task.ItemKey
1856: , aname => 'PRIORITY'
1857: , avalue => l_task_priority_name
1858: );
1859: wf_engine.SetItemAttrText( itemtype => l_itemtype
1860: , itemkey => r_Task.ItemKey
1861: , aname => 'DURATION'
1862: , avalue => get_duration(r_Task.DURATION)
1863: );

Line 1864: wf_engine.SetItemAttrText( itemtype => l_itemtype

1860: , itemkey => r_Task.ItemKey
1861: , aname => 'DURATION'
1862: , avalue => get_duration(r_Task.DURATION)
1863: );
1864: wf_engine.SetItemAttrText( itemtype => l_itemtype
1865: , itemkey => r_Task.ItemKey
1866: , aname => 'TIMEZONE'
1867: , avalue => l_timezone
1868: );

Line 1873: wf_engine.StartProcess( itemtype => l_itemtype

1869:
1870: /***************************************************************************
1871: ** Start the workflow
1872: ***************************************************************************/
1873: wf_engine.StartProcess( itemtype => l_itemtype
1874: , itemkey => r_Task.ItemKey
1875: );
1876:
1877:

Line 1964: l_result := wf_engine.getItemAttrText

1960:
1961: /***************************************************************************
1962: ** Pick up the resource ID of the INVITEE
1963: ***************************************************************************/
1964: l_result := wf_engine.getItemAttrText
1965: ( itemtype => itemtype
1966: , itemkey => itemkey
1967: , aname => 'RESULT'
1968: );

Line 1970: l_InviteeResourceID := wf_engine.GetItemAttrNumber

1966: , itemkey => itemkey
1967: , aname => 'RESULT'
1968: );
1969:
1970: l_InviteeResourceID := wf_engine.GetItemAttrNumber
1971: ( itemtype => itemtype
1972: , itemkey => itemkey
1973: , aname => 'INVITEE'
1974: );

Line 1976: l_TaskID := wf_engine.GetItemAttrNumber

1972: , itemkey => itemkey
1973: , aname => 'INVITEE'
1974: );
1975:
1976: l_TaskID := wf_engine.GetItemAttrNumber
1977: ( itemtype => itemtype
1978: , itemkey => itemkey
1979: , aname => 'TASK_ID'
1980: );

Line 1982: l_resource_type := wf_engine.getItemAttrText( itemtype => itemtype

1978: , itemkey => itemkey
1979: , aname => 'TASK_ID'
1980: );
1981:
1982: l_resource_type := wf_engine.getItemAttrText( itemtype => itemtype
1983: , itemkey => itemkey
1984: , aname => 'INVITEE_CODE'
1985: );
1986:

Line 1987: l_task_assignment_id := wf_engine.GetItemAttrNumber

1983: , itemkey => itemkey
1984: , aname => 'INVITEE_CODE'
1985: );
1986:
1987: l_task_assignment_id := wf_engine.GetItemAttrNumber
1988: ( itemtype => itemtype
1989: , itemkey => itemkey
1990: , aname => 'TASK_ASSIGNMENT_ID'
1991: );

Line 2106: l_InvitorResourceID := wf_engine.GetItemAttrNumber

2102:
2103: /***************************************************************************
2104: ** Pick up the resource ID of the INVITOR
2105: ***************************************************************************/
2106: l_InvitorResourceID := wf_engine.GetItemAttrNumber
2107: ( itemtype => itemtype
2108: , itemkey => itemkey
2109: , aname => 'INVITOR'
2110: );

Line 2115: l_InviteeResourceID := wf_engine.GetItemAttrNumber

2111:
2112: /***************************************************************************
2113: ** Pick up the resource ID of the INVITEE
2114: ***************************************************************************/
2115: l_InviteeResourceID := wf_engine.GetItemAttrNumber
2116: ( itemtype => itemtype
2117: , itemkey => itemkey
2118: , aname => 'INVITEE'
2119: );

Line 2126: l_InviteeCode := wf_engine.GetItemAttrText

2122:
2123: /***************************************************************************
2124: ** Pick up the resource Type Code of the INVITEE
2125: ***************************************************************************/
2126: l_InviteeCode := wf_engine.GetItemAttrText
2127: ( itemtype => itemtype
2128: , itemkey => itemkey
2129: , aname => 'INVITEE_CODE'
2130: );

Line 2156: WF_ENGINE.SetItemAttrText( itemtype => itemtype

2152: ELSE
2153: /*************************************************************************
2154: ** Found INVITOR, set WF Attributes
2155: *************************************************************************/
2156: WF_ENGINE.SetItemAttrText( itemtype => itemtype
2157: , itemkey => itemkey
2158: , aname => 'WF_INVITOR_ROLE'
2159: , avalue => l_InvitorWFRole
2160: );

Line 2162: WF_ENGINE.SetItemAttrText( itemtype => itemtype

2158: , aname => 'WF_INVITOR_ROLE'
2159: , avalue => l_InvitorWFRole
2160: );
2161:
2162: WF_ENGINE.SetItemAttrText( itemtype => itemtype
2163: , itemkey => itemkey
2164: , aname => 'WF_INVITOR_NAME'
2165: , avalue => l_InvitorWFName
2166: );

Line 2191: WF_ENGINE.SetItemAttrText( itemtype => itemtype

2187: ELSE
2188: /***********************************************************************
2189: ** Found INVITEE, set WF Attributes
2190: ***********************************************************************/
2191: WF_ENGINE.SetItemAttrText( itemtype => itemtype
2192: , itemkey => itemkey
2193: , aname => 'WF_INVITEE_ROLE'
2194: , avalue => l_InviteeWFRole
2195: );

Line 2197: WF_ENGINE.SetItemAttrText( itemtype => itemtype

2193: , aname => 'WF_INVITEE_ROLE'
2194: , avalue => l_InviteeWFRole
2195: );
2196:
2197: WF_ENGINE.SetItemAttrText( itemtype => itemtype
2198: , itemkey => itemkey
2199: , aname => 'WF_INVITEE_NAME'
2200: , avalue => l_InviteeWFName
2201: );

Line 2232: wf_engine.SetItemAttrText( itemtype => itemtype

2228: THEN
2229: /*****************************************************************************
2230: ** Something went wrong return 'ERROR' and set the ERROR_MESSAGE
2231: *****************************************************************************/
2232: wf_engine.SetItemAttrText( itemtype => itemtype
2233: , itemkey => itemkey
2234: , aname => 'ERROR_MESSAGE'
2235: , avalue => 'CAC_VIEW_WF_PVT.DetermineWFRole(): ' || to_char(SQLCODE)||':'||SQLERRM
2236: );

Line 2326: wf_engine.CreateProcess( itemtype => l_ItemType

2322: FROM DUAL;
2323: /***************************************************************************
2324: ** Initialize the workflow
2325: ***************************************************************************/
2326: wf_engine.CreateProcess( itemtype => l_ItemType
2327: , itemkey => l_ItemKey
2328: , process => 'DELAYSTARTREMINDER'
2329: );
2330:

Line 2331: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

2327: , itemkey => l_ItemKey
2328: , process => 'DELAYSTARTREMINDER'
2329: );
2330:
2331: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
2332: , itemkey => l_ItemKey
2333: , aname => 'TASK_ID'
2334: , avalue => p_TaskID
2335: );

Line 2337: wf_engine.SetItemAttrDate( itemtype => l_itemtype

2333: , aname => 'TASK_ID'
2334: , avalue => p_TaskID
2335: );
2336:
2337: wf_engine.SetItemAttrDate( itemtype => l_itemtype
2338: , itemkey => l_ItemKey
2339: , aname => 'REMIND_DATE'
2340: , avalue => p_RemindDate
2341: );

Line 2343: wf_engine.SetItemAttrText( itemtype => l_itemtype

2339: , aname => 'REMIND_DATE'
2340: , avalue => p_RemindDate
2341: );
2342:
2343: wf_engine.SetItemAttrText( itemtype => l_itemtype
2344: , itemkey => l_ItemKey
2345: , aname => 'CALENDAR_ADMIN'
2346: , avalue => l_AdminWFRole
2347: );

Line 2349: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

2345: , aname => 'CALENDAR_ADMIN'
2346: , avalue => l_AdminWFRole
2347: );
2348:
2349: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
2350: , itemkey => l_ItemKey
2351: , aname => 'INVITOR'
2352: , avalue => p_INVITOR
2353: );

Line 2358: wf_engine.StartProcess( itemtype => l_itemtype

2354:
2355: /***************************************************************************
2356: ** Start the workflow
2357: ***************************************************************************/
2358: wf_engine.StartProcess( itemtype => l_itemtype
2359: , itemkey => l_ItemKey
2360: );
2361:
2362: /***************************************************************************

Line 2482: l_AdminWFRole := wf_engine.GetItemAttrNumber( itemtype => itemtype

2478: BEGIN
2479: /*****************************************************************************
2480: ** Retrieve the globals that where set
2481: *****************************************************************************/
2482: l_AdminWFRole := wf_engine.GetItemAttrNumber( itemtype => itemtype
2483: , itemkey => itemkey
2484: , aname => 'CALENDAR_ADMIN'
2485: );
2486:

Line 2487: l_TaskID := wf_engine.GetItemAttrNumber( itemtype => itemtype

2483: , itemkey => itemkey
2484: , aname => 'CALENDAR_ADMIN'
2485: );
2486:
2487: l_TaskID := wf_engine.GetItemAttrNumber( itemtype => itemtype
2488: , itemkey => itemkey
2489: , aname => 'TASK_ID'
2490: );
2491:

Line 2492: l_INVITOR:= wf_engine.GetItemAttrNumber( itemtype => itemtype

2488: , itemkey => itemkey
2489: , aname => 'TASK_ID'
2490: );
2491:
2492: l_INVITOR:= wf_engine.GetItemAttrNumber( itemtype => itemtype
2493: , itemkey => itemKey
2494: , aname => 'INVITOR'
2495: );
2496:

Line 2506: wf_engine.CreateProcess( itemtype => l_ItemType

2502: LOOP <>
2503: /***************************************************************************
2504: ** Initialize the workflow
2505: ***************************************************************************/
2506: wf_engine.CreateProcess( itemtype => l_ItemType
2507: , itemkey => r_Task.ItemKey
2508: , process => 'JTF_TASK_REMINDER'
2509: );
2510:

Line 2511: wf_engine.SetItemAttrText( itemtype => l_itemtype

2507: , itemkey => r_Task.ItemKey
2508: , process => 'JTF_TASK_REMINDER'
2509: );
2510:
2511: wf_engine.SetItemAttrText( itemtype => l_itemtype
2512: , itemkey => r_Task.ItemKey
2513: , aname => 'CALENDAR_ADMIN'
2514: , avalue => l_AdminWFRole
2515: );

Line 2517: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

2513: , aname => 'CALENDAR_ADMIN'
2514: , avalue => l_AdminWFRole
2515: );
2516:
2517: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
2518: , itemkey => r_Task.ItemKey
2519: , aname => 'INVITEE'
2520: , avalue => r_Task.INVITEE
2521: );

Line 2524: wf_engine.SetItemAttrText( itemtype => l_itemtype

2520: , avalue => r_Task.INVITEE
2521: );
2522: ---Bug # 4089393, amigupta, Setting new attribute value INVITEE_CODE
2523:
2524: wf_engine.SetItemAttrText( itemtype => l_itemtype
2525: , itemkey => r_Task.ItemKey
2526: , aname => 'INVITEE_CODE'
2527: , avalue => r_Task.INVITEE_CODE
2528: );

Line 2531: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

2527: , avalue => r_Task.INVITEE_CODE
2528: );
2529:
2530:
2531: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
2532: , itemkey => r_Task.ItemKey
2533: , aname => 'INVITOR'
2534: , avalue => l_INVITOR
2535: );

Line 2537: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

2533: , aname => 'INVITOR'
2534: , avalue => l_INVITOR
2535: );
2536:
2537: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
2538: , itemkey => r_Task.ItemKey
2539: , aname => 'TASK_ID'
2540: , avalue => l_TaskID
2541: );

Line 2543: wf_engine.SetItemAttrText( itemtype => l_itemtype

2539: , aname => 'TASK_ID'
2540: , avalue => l_TaskID
2541: );
2542:
2543: wf_engine.SetItemAttrText( itemtype => l_itemtype
2544: , itemkey => r_Task.ItemKey
2545: , aname => 'TASK_NAME'
2546: , avalue => r_Task.TASK_NAME
2547: );

Line 2549: wf_engine.SetItemAttrText( itemtype => l_itemtype

2545: , aname => 'TASK_NAME'
2546: , avalue => r_Task.TASK_NAME
2547: );
2548:
2549: wf_engine.SetItemAttrText( itemtype => l_itemtype
2550: , itemkey => r_Task.ItemKey
2551: , aname => 'TASK_DESCRIPTION'
2552: , avalue => r_Task.TASK_DESCRIPTION
2553: );

Line 2590: wf_engine.SetItemAttrDate( itemtype => l_itemtype

2586: , x_dest_day_time => l_EndDateCorrected
2587: );
2588:
2589:
2590: wf_engine.SetItemAttrDate( itemtype => l_itemtype
2591: , itemkey => r_Task.ItemKey
2592: , aname => 'START_DATE'
2593: , avalue => l_StartDateCorrected
2594: );

Line 2596: wf_engine.SetItemAttrDate( itemtype => l_itemtype

2592: , aname => 'START_DATE'
2593: , avalue => l_StartDateCorrected
2594: );
2595:
2596: wf_engine.SetItemAttrDate( itemtype => l_itemtype
2597: , itemkey => r_Task.ItemKey
2598: , aname => 'END_DATE'
2599: , avalue => l_EndDateCorrected
2600: );

Line 2605: wf_engine.StartProcess( itemtype => l_itemtype

2601:
2602: /***************************************************************************
2603: ** Start the workflow
2604: ***************************************************************************/
2605: wf_engine.StartProcess( itemtype => l_itemtype
2606: , itemkey => r_Task.ItemKey
2607: );
2608:
2609: END LOOP ASSIGNEES;

Line 2626: wf_engine.SetItemAttrText( itemtype => itemtype

2622: END IF;
2623: /*****************************************************************************
2624: ** Something went wrong return 'ERROR' and set the ERROR_MESSAGE
2625: *****************************************************************************/
2626: wf_engine.SetItemAttrText( itemtype => itemtype
2627: , itemkey => itemkey
2628: , aname => 'ERROR_MESSAGE'
2629: , avalue => 'CAC_VIEW_WF_PVT.SendReminders(): ' || to_char(SQLCODE)||':'||SQLERRM
2630: );

Line 2764: wf_engine.AbortProcess( itemtype => r_Task.ReminderWFItemType

2760: );
2761: IF (l_status = 'ACTIVE')
2762: THEN
2763: -- abort the existing process
2764: wf_engine.AbortProcess( itemtype => r_Task.ReminderWFItemType
2765: , itemkey => r_Task.ReminderWFItemKey
2766: , process => 'DELAYSTARTREMINDER'
2767: , result => 'COMPLETE'
2768: );

Line 2992: wf_engine.CreateProcess( itemtype => l_ItemType

2988: l_task_type_name := get_type_name(r_Task.TYPE_ID);
2989: l_task_priority_name := get_priority_name(r_Task.PRIORITY_ID);
2990: l_timezone := GetTimezone(p_timezone_id => r_Task.timezone_id);
2991:
2992: wf_engine.CreateProcess( itemtype => l_ItemType
2993: , itemkey => r_Task.ItemKey
2994: , process => 'UPDATE_INVITATION'
2995: );
2996:

Line 2997: wf_engine.SetItemAttrText( itemtype => l_itemtype

2993: , itemkey => r_Task.ItemKey
2994: , process => 'UPDATE_INVITATION'
2995: );
2996:
2997: wf_engine.SetItemAttrText( itemtype => l_itemtype
2998: , itemkey => r_Task.ItemKey
2999: , aname => 'CALENDAR_ADMIN'
3000: , avalue => l_AdminWFRole
3001: );

Line 3003: wf_engine.SetItemAttrText( itemtype => l_itemtype

2999: , aname => 'CALENDAR_ADMIN'
3000: , avalue => l_AdminWFRole
3001: );
3002:
3003: wf_engine.SetItemAttrText( itemtype => l_itemtype
3004: , itemkey => r_Task.ItemKey
3005: , aname => 'INVITOR'
3006: , avalue => l_invitor.owner_id
3007: );

Line 3009: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3005: , aname => 'INVITOR'
3006: , avalue => l_invitor.owner_id
3007: );
3008:
3009: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3010: , itemkey => r_Task.ItemKey
3011: , aname => 'INVITEE'
3012: , avalue => r_Task.INVITEE
3013: );

Line 3015: wf_engine.SetItemAttrText( itemtype => l_itemtype

3011: , aname => 'INVITEE'
3012: , avalue => r_Task.INVITEE
3013: );
3014:
3015: wf_engine.SetItemAttrText( itemtype => l_itemtype
3016: , itemkey => r_Task.ItemKey
3017: , aname => 'INVITEE_CODE'
3018: , avalue => r_Task.INVITEE_CODE
3019: );

Line 3021: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3017: , aname => 'INVITEE_CODE'
3018: , avalue => r_Task.INVITEE_CODE
3019: );
3020:
3021: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3022: , itemkey => r_Task.ItemKey
3023: , aname => 'TASK_ASSIGNMENT_ID'
3024: , avalue => r_Task.TASK_ASSIGNMENT_ID
3025: );

Line 3027: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3023: , aname => 'TASK_ASSIGNMENT_ID'
3024: , avalue => r_Task.TASK_ASSIGNMENT_ID
3025: );
3026:
3027: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3028: , itemkey => r_Task.ItemKey
3029: , aname => 'TASK_ID'
3030: , avalue => p_TaskID
3031: );

Line 3033: wf_engine.SetItemAttrText( itemtype => l_itemtype

3029: , aname => 'TASK_ID'
3030: , avalue => p_TaskID
3031: );
3032:
3033: wf_engine.SetItemAttrText( itemtype => l_itemtype
3034: , itemkey => r_Task.ItemKey
3035: , aname => 'TASK_NAME'
3036: , avalue => r_Task.TASK_NAME
3037: );

Line 3039: wf_engine.SetItemAttrText( itemtype => l_itemtype

3035: , aname => 'TASK_NAME'
3036: , avalue => r_Task.TASK_NAME
3037: );
3038:
3039: wf_engine.SetItemAttrText( itemtype => l_itemtype
3040: , itemkey => r_Task.ItemKey
3041: , aname => 'TASK_DESCRIPTION'
3042: , avalue => r_Task.TASK_DESCRIPTION
3043: );

Line 3045: wf_engine.SetItemAttrDate( itemtype => l_itemtype

3041: , aname => 'TASK_DESCRIPTION'
3042: , avalue => r_Task.TASK_DESCRIPTION
3043: );
3044:
3045: wf_engine.SetItemAttrDate( itemtype => l_itemtype
3046: , itemkey => r_Task.ItemKey
3047: , aname => 'START_DATE'
3048: , avalue => r_Task.START_DATE
3049: );

Line 3051: wf_engine.SetItemAttrText( itemtype => l_itemtype

3047: , aname => 'START_DATE'
3048: , avalue => r_Task.START_DATE
3049: );
3050:
3051: wf_engine.SetItemAttrText( itemtype => l_itemtype
3052: , itemkey => r_Task.ItemKey
3053: , aname => 'TYPE'
3054: , avalue => l_task_type_name
3055: );

Line 3056: wf_engine.SetItemAttrText( itemtype => l_itemtype

3052: , itemkey => r_Task.ItemKey
3053: , aname => 'TYPE'
3054: , avalue => l_task_type_name
3055: );
3056: wf_engine.SetItemAttrText( itemtype => l_itemtype
3057: , itemkey => r_Task.ItemKey
3058: , aname => 'PRIORITY'
3059: , avalue => l_task_priority_name
3060: );

Line 3061: wf_engine.SetItemAttrText( itemtype => l_itemtype

3057: , itemkey => r_Task.ItemKey
3058: , aname => 'PRIORITY'
3059: , avalue => l_task_priority_name
3060: );
3061: wf_engine.SetItemAttrText( itemtype => l_itemtype
3062: , itemkey => r_Task.ItemKey
3063: , aname => 'DURATION'
3064: , avalue => get_duration(r_Task.DURATION)
3065: );

Line 3066: wf_engine.SetItemAttrText( itemtype => l_itemtype

3062: , itemkey => r_Task.ItemKey
3063: , aname => 'DURATION'
3064: , avalue => get_duration(r_Task.DURATION)
3065: );
3066: wf_engine.SetItemAttrText( itemtype => l_itemtype
3067: , itemkey => r_Task.ItemKey
3068: , aname => 'TIMEZONE'
3069: , avalue => l_timezone
3070: );

Line 3076: wf_engine.StartProcess( itemtype => l_itemtype

3072: /***************************************************************************
3073: ** Start the workflow
3074: ***************************************************************************/
3075:
3076: wf_engine.StartProcess( itemtype => l_itemtype
3077: , itemkey => r_Task.ItemKey
3078: );
3079:
3080:

Line 3451: wf_engine.CreateProcess( itemtype => l_ItemType

3447: l_task_type_name := get_type_name(r_Task.TYPE_ID);
3448: l_task_priority_name := get_priority_name(r_Task.PRIORITY_ID);
3449: l_timezone := GetTimezone(p_timezone_id => r_Task.timezone_id);
3450:
3451: wf_engine.CreateProcess( itemtype => l_ItemType
3452: , itemkey => r_Task.ItemKey
3453: , process => 'DELETE_INVITATION'
3454: );
3455:

Line 3456: wf_engine.SetItemAttrText( itemtype => l_itemtype

3452: , itemkey => r_Task.ItemKey
3453: , process => 'DELETE_INVITATION'
3454: );
3455:
3456: wf_engine.SetItemAttrText( itemtype => l_itemtype
3457: , itemkey => r_Task.ItemKey
3458: , aname => 'CALENDAR_ADMIN'
3459: , avalue => l_AdminWFRole
3460: );

Line 3462: wf_engine.SetItemAttrText( itemtype => l_itemtype

3458: , aname => 'CALENDAR_ADMIN'
3459: , avalue => l_AdminWFRole
3460: );
3461:
3462: wf_engine.SetItemAttrText( itemtype => l_itemtype
3463: , itemkey => r_Task.ItemKey
3464: , aname => 'INVITOR'
3465: , avalue => l_invitor.owner_id
3466: );

Line 3468: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3464: , aname => 'INVITOR'
3465: , avalue => l_invitor.owner_id
3466: );
3467:
3468: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3469: , itemkey => r_Task.ItemKey
3470: , aname => 'INVITEE'
3471: , avalue => r_Task.INVITEE
3472: );

Line 3474: wf_engine.SetItemAttrText( itemtype => l_itemtype

3470: , aname => 'INVITEE'
3471: , avalue => r_Task.INVITEE
3472: );
3473:
3474: wf_engine.SetItemAttrText( itemtype => l_itemtype
3475: , itemkey => r_Task.ItemKey
3476: , aname => 'INVITEE_CODE'
3477: , avalue => r_Task.INVITEE_CODE
3478: );

Line 3480: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3476: , aname => 'INVITEE_CODE'
3477: , avalue => r_Task.INVITEE_CODE
3478: );
3479:
3480: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3481: , itemkey => r_Task.ItemKey
3482: , aname => 'TASK_ASSIGNMENT_ID'
3483: , avalue => r_Task.TASK_ASSIGNMENT_ID
3484: );

Line 3486: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

3482: , aname => 'TASK_ASSIGNMENT_ID'
3483: , avalue => r_Task.TASK_ASSIGNMENT_ID
3484: );
3485:
3486: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
3487: , itemkey => r_Task.ItemKey
3488: , aname => 'TASK_ID'
3489: , avalue => p_TaskID
3490: );

Line 3492: wf_engine.SetItemAttrText( itemtype => l_itemtype

3488: , aname => 'TASK_ID'
3489: , avalue => p_TaskID
3490: );
3491:
3492: wf_engine.SetItemAttrText( itemtype => l_itemtype
3493: , itemkey => r_Task.ItemKey
3494: , aname => 'TASK_NAME'
3495: , avalue => r_Task.TASK_NAME
3496: );

Line 3498: wf_engine.SetItemAttrText( itemtype => l_itemtype

3494: , aname => 'TASK_NAME'
3495: , avalue => r_Task.TASK_NAME
3496: );
3497:
3498: wf_engine.SetItemAttrText( itemtype => l_itemtype
3499: , itemkey => r_Task.ItemKey
3500: , aname => 'TASK_DESCRIPTION'
3501: , avalue => r_Task.TASK_DESCRIPTION
3502: );

Line 3504: wf_engine.SetItemAttrDate( itemtype => l_itemtype

3500: , aname => 'TASK_DESCRIPTION'
3501: , avalue => r_Task.TASK_DESCRIPTION
3502: );
3503:
3504: wf_engine.SetItemAttrDate( itemtype => l_itemtype
3505: , itemkey => r_Task.ItemKey
3506: , aname => 'START_DATE'
3507: , avalue => r_Task.START_DATE
3508: );

Line 3510: wf_engine.SetItemAttrText( itemtype => l_itemtype

3506: , aname => 'START_DATE'
3507: , avalue => r_Task.START_DATE
3508: );
3509:
3510: wf_engine.SetItemAttrText( itemtype => l_itemtype
3511: , itemkey => r_Task.ItemKey
3512: , aname => 'TYPE'
3513: , avalue => l_task_type_name
3514: );

Line 3515: wf_engine.SetItemAttrText( itemtype => l_itemtype

3511: , itemkey => r_Task.ItemKey
3512: , aname => 'TYPE'
3513: , avalue => l_task_type_name
3514: );
3515: wf_engine.SetItemAttrText( itemtype => l_itemtype
3516: , itemkey => r_Task.ItemKey
3517: , aname => 'PRIORITY'
3518: , avalue => l_task_priority_name
3519: );

Line 3520: wf_engine.SetItemAttrText( itemtype => l_itemtype

3516: , itemkey => r_Task.ItemKey
3517: , aname => 'PRIORITY'
3518: , avalue => l_task_priority_name
3519: );
3520: wf_engine.SetItemAttrText( itemtype => l_itemtype
3521: , itemkey => r_Task.ItemKey
3522: , aname => 'DURATION'
3523: , avalue => get_duration(r_Task.DURATION)
3524: );

Line 3525: wf_engine.SetItemAttrText( itemtype => l_itemtype

3521: , itemkey => r_Task.ItemKey
3522: , aname => 'DURATION'
3523: , avalue => get_duration(r_Task.DURATION)
3524: );
3525: wf_engine.SetItemAttrText( itemtype => l_itemtype
3526: , itemkey => r_Task.ItemKey
3527: , aname => 'TIMEZONE'
3528: , avalue => l_timezone
3529: );

Line 3535: wf_engine.StartProcess( itemtype => l_itemtype

3531: /***************************************************************************
3532: ** Start the workflow
3533: ***************************************************************************/
3534:
3535: wf_engine.StartProcess( itemtype => l_itemtype
3536: , itemkey => r_Task.ItemKey
3537: );
3538:
3539:

Line 3668: l_TaskID := wf_engine.GetItemAttrNumber

3664:
3665: /***************************************************************************
3666: ** Pick up the Task ID Attribute
3667: ***************************************************************************/
3668: l_TaskID := wf_engine.GetItemAttrNumber
3669: ( itemtype => itemtype
3670: , itemkey => itemkey
3671: , aname => 'TASK_ID'
3672: );

Line 3682: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype

3678: FETCH c_rule INTO r_rule;
3679: IF (c_rule%FOUND)
3680: THEN
3681:
3682: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype
3683: , itemkey => itemkey
3684: , aname => 'OCCURS_EVERY'
3685: , avalue => r_rule.occurs_every
3686: );

Line 3687: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3683: , itemkey => itemkey
3684: , aname => 'OCCURS_EVERY'
3685: , avalue => r_rule.occurs_every
3686: );
3687: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3688: , itemkey => itemkey
3689: , aname => 'DURATION'
3690: , avalue => get_duration(r_rule.duration)
3691: );

Line 3692: WF_ENGINE.SetItemAttrDate( itemtype => itemtype

3688: , itemkey => itemkey
3689: , aname => 'DURATION'
3690: , avalue => get_duration(r_rule.duration)
3691: );
3692: WF_ENGINE.SetItemAttrDate( itemtype => itemtype
3693: , itemkey => itemkey
3694: , aname => 'REPEAT_END_DATE'
3695: , avalue => r_rule.end_date_active
3696: );

Line 3711: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3707: l_DayNumber := GetDayNumber(p_DayNumber => r_rule.date_of_month);
3708: l_which := GetDayNumber(p_DayNumber => r_rule.occurs_which);
3709: l_timezone := GetTimezone(p_timezone_id => r_rule.timezone_id);
3710:
3711: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3712: , itemkey => itemkey
3713: , aname => 'DAYSOFWEEK'
3714: , avalue => l_days
3715: );

Line 3717: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3713: , aname => 'DAYSOFWEEK'
3714: , avalue => l_days
3715: );
3716:
3717: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3718: , itemkey => itemkey
3719: , aname => 'DATE_OF_MONTH'
3720: , avalue => l_DayNumber
3721: );

Line 3723: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3719: , aname => 'DATE_OF_MONTH'
3720: , avalue => l_DayNumber
3721: );
3722:
3723: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3724: , itemkey => itemkey
3725: , aname => 'OCCURS_WHICH'
3726: , avalue => l_which
3727: );

Line 3729: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3725: , aname => 'OCCURS_WHICH'
3726: , avalue => l_which
3727: );
3728:
3729: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3730: , itemkey => itemkey
3731: , aname => 'TIMEZONE'
3732: , avalue => l_timezone
3733: );

Line 3797: wf_engine.SetItemAttrText( itemtype => itemtype

3793: THEN
3794: CLOSE c_rule;
3795: END IF;
3796:
3797: wf_engine.SetItemAttrText( itemtype => itemtype
3798: , itemkey => itemkey
3799: , aname => 'ERROR_MESSAGE'
3800: , avalue => 'CAC_VIEW_WF_PVT.GetRepeatingRule(): ' || to_char(SQLCODE)||':'||SQLERRM
3801: );

Line 3850: l_assignment_status_id := wf_engine.GetItemAttrNumber

3846:
3847: /***************************************************************************
3848: ** Pick up the Task ID Attribute
3849: ***************************************************************************/
3850: l_assignment_status_id := wf_engine.GetItemAttrNumber
3851: ( itemtype => itemtype
3852: , itemkey => itemkey
3853: , aname => 'ASSIGNMENT_STATUS_ID'
3854: );

Line 3882: wf_engine.SetItemAttrText( itemtype => itemtype

3878: EXCEPTION
3879: WHEN OTHERS
3880: THEN
3881:
3882: wf_engine.SetItemAttrText( itemtype => itemtype
3883: , itemkey => itemkey
3884: , aname => 'ERROR_MESSAGE'
3885: , avalue => 'CAC_VIEW_WF_PVT.GetInvitationStatus(): ' || to_char(SQLCODE)||':'||SQLERRM
3886: );