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.JTF_CAL_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 => 'JTF_CAL_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 => 'JTF_CAL_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_type_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_type_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 2155: WF_ENGINE.SetItemAttrText( itemtype => itemtype

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

Line 2161: WF_ENGINE.SetItemAttrText( itemtype => itemtype

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

Line 2190: WF_ENGINE.SetItemAttrText( itemtype => itemtype

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

Line 2196: WF_ENGINE.SetItemAttrText( itemtype => itemtype

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

Line 2230: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 2323: wf_engine.CreateProcess( itemtype => l_ItemType

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

Line 2328: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

Line 2334: wf_engine.SetItemAttrDate( itemtype => l_itemtype

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

Line 2340: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 2346: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

Line 2355: wf_engine.StartProcess( itemtype => l_itemtype

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

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

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

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

2480: , itemkey => itemkey
2481: , aname => 'CALENDAR_ADMIN'
2482: );
2483:
2484: l_TaskID := wf_engine.GetItemAttrNumber( itemtype => itemtype
2485: , itemkey => itemkey
2486: , aname => 'TASK_ID'
2487: );
2488:

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

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

Line 2503: wf_engine.CreateProcess( itemtype => l_ItemType

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

Line 2508: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 2514: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

Line 2521: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 2528: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

Line 2534: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

Line 2540: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 2546: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 2587: wf_engine.SetItemAttrDate( itemtype => l_itemtype

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

Line 2593: wf_engine.SetItemAttrDate( itemtype => l_itemtype

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

Line 2602: wf_engine.StartProcess( itemtype => l_itemtype

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

Line 2623: wf_engine.SetItemAttrText( itemtype => itemtype

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

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

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

Line 3062: l_TaskID := wf_engine.GetItemAttrNumber

3058:
3059: /***************************************************************************
3060: ** Pick up the Task ID Attribute
3061: ***************************************************************************/
3062: l_TaskID := wf_engine.GetItemAttrNumber
3063: ( itemtype => itemtype
3064: , itemkey => itemkey
3065: , aname => 'TASK_ID'
3066: );

Line 3076: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype

3072: FETCH c_rule INTO r_rule;
3073: IF (c_rule%FOUND)
3074: THEN
3075:
3076: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype
3077: , itemkey => itemkey
3078: , aname => 'OCCURS_EVERY'
3079: , avalue => r_rule.occurs_every
3080: );

Line 3081: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3077: , itemkey => itemkey
3078: , aname => 'OCCURS_EVERY'
3079: , avalue => r_rule.occurs_every
3080: );
3081: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3082: , itemkey => itemkey
3083: , aname => 'DURATION'
3084: , avalue => get_duration(r_rule.duration)
3085: );

Line 3086: WF_ENGINE.SetItemAttrDate( itemtype => itemtype

3082: , itemkey => itemkey
3083: , aname => 'DURATION'
3084: , avalue => get_duration(r_rule.duration)
3085: );
3086: WF_ENGINE.SetItemAttrDate( itemtype => itemtype
3087: , itemkey => itemkey
3088: , aname => 'REPEAT_END_DATE'
3089: , avalue => r_rule.end_date_active
3090: );

Line 3105: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3101: l_DayNumber := GetDayNumber(p_DayNumber => r_rule.date_of_month);
3102: l_which := GetDayNumber(p_DayNumber => r_rule.occurs_which);
3103: l_timezone := GetTimezone(p_timezone_id => r_rule.timezone_id);
3104:
3105: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3106: , itemkey => itemkey
3107: , aname => 'DAYSOFWEEK'
3108: , avalue => l_days
3109: );

Line 3111: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3107: , aname => 'DAYSOFWEEK'
3108: , avalue => l_days
3109: );
3110:
3111: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3112: , itemkey => itemkey
3113: , aname => 'DATE_OF_MONTH'
3114: , avalue => l_DayNumber
3115: );

Line 3117: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3113: , aname => 'DATE_OF_MONTH'
3114: , avalue => l_DayNumber
3115: );
3116:
3117: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3118: , itemkey => itemkey
3119: , aname => 'OCCURS_WHICH'
3120: , avalue => l_which
3121: );

Line 3123: WF_ENGINE.SetItemAttrText( itemtype => itemtype

3119: , aname => 'OCCURS_WHICH'
3120: , avalue => l_which
3121: );
3122:
3123: WF_ENGINE.SetItemAttrText( itemtype => itemtype
3124: , itemkey => itemkey
3125: , aname => 'TIMEZONE'
3126: , avalue => l_timezone
3127: );

Line 3191: wf_engine.SetItemAttrText( itemtype => itemtype

3187: THEN
3188: CLOSE c_rule;
3189: END IF;
3190:
3191: wf_engine.SetItemAttrText( itemtype => itemtype
3192: , itemkey => itemkey
3193: , aname => 'ERROR_MESSAGE'
3194: , avalue => 'JTF_CAL_WF_PVT.GetRepeatingRule(): ' || to_char(SQLCODE)||':'||SQLERRM
3195: );

Line 3244: l_assignment_status_id := wf_engine.GetItemAttrNumber

3240:
3241: /***************************************************************************
3242: ** Pick up the Task ID Attribute
3243: ***************************************************************************/
3244: l_assignment_status_id := wf_engine.GetItemAttrNumber
3245: ( itemtype => itemtype
3246: , itemkey => itemkey
3247: , aname => 'ASSIGNMENT_STATUS_ID'
3248: );

Line 3276: wf_engine.SetItemAttrText( itemtype => itemtype

3272: EXCEPTION
3273: WHEN OTHERS
3274: THEN
3275:
3276: wf_engine.SetItemAttrText( itemtype => itemtype
3277: , itemkey => itemkey
3278: , aname => 'ERROR_MESSAGE'
3279: , avalue => 'JTF_CAL_WF_PVT.GetInvitationStatus(): ' || to_char(SQLCODE)||':'||SQLERRM
3280: );