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

Line 167: l_user_id := WF_ENGINE.GetItemAttrNumber

163: -- Engine calls SET_CTX just before activity execution
164: ELSIF (funcmode = 'SET_CTX') THEN
165:
166: -- First get the user id, resp id, and appl id
167: l_user_id := WF_ENGINE.GetItemAttrNumber
168: ( itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'USER_ID'
171: );

Line 172: l_resp_id := WF_ENGINE.GetItemAttrNumber

168: ( itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'USER_ID'
171: );
172: l_resp_id := WF_ENGINE.GetItemAttrNumber
173: ( itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'RESP_ID'
176: );

Line 177: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber

173: ( itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'RESP_ID'
176: );
177: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber
178: ( itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'RESP_APPL_ID'
181: );

Line 197: l_user_id := WF_ENGINE.GetItemAttrNumber

193: result := 'COMPLETE';
194:
195: -- Notification Viewer form calls TEST_CTX just before launching a form
196: ELSIF (funcmode = 'TEST_CTX') THEN
197: l_user_id := WF_ENGINE.GetItemAttrNumber
198: ( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'USER_ID'
201: );

Line 202: l_resp_id := WF_ENGINE.GetItemAttrNumber

198: ( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'USER_ID'
201: );
202: l_resp_id := WF_ENGINE.GetItemAttrNumber
203: ( itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'RESP_ID'
206: );

Line 207: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber

203: ( itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'RESP_ID'
206: );
207: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber
208: ( itemtype => itemtype,
209: itemkey => itemkey,
210: aname => 'RESP_APPL_ID'
211: );

Line 313: WF_ENGINE.SetItemAttrDate(

309: OPEN l_ServiceRequest_csr;
310: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
311:
312: -- Initialize item attributes that will remain constant
313: WF_ENGINE.SetItemAttrDate(
314: itemtype => 'SERVEREQ',
315: itemkey => itemkey,
316: aname => 'REQUEST_DATE',
317: avalue => l_ServiceRequest_rec.incident_date );

Line 319: WF_ENGINE.SetItemAttrNumber(

315: itemkey => itemkey,
316: aname => 'REQUEST_DATE',
317: avalue => l_ServiceRequest_rec.incident_date );
318:
319: WF_ENGINE.SetItemAttrNumber(
320: itemtype => 'SERVEREQ',
321: itemkey => itemkey,
322: aname => 'REQUEST_ID',
323: avalue => l_ServiceRequest_rec.incident_id );

Line 325: WF_ENGINE.SetItemAttrText(

321: itemkey => itemkey,
322: aname => 'REQUEST_ID',
323: avalue => l_ServiceRequest_rec.incident_id );
324:
325: WF_ENGINE.SetItemAttrText(
326: itemtype => 'SERVEREQ',
327: itemkey => itemkey,
328: aname => 'REQUEST_NUMBER',
329: avalue => l_ServiceRequest_rec.incident_number );

Line 331: WF_ENGINE.SetItemAttrText(

327: itemkey => itemkey,
328: aname => 'REQUEST_NUMBER',
329: avalue => l_ServiceRequest_rec.incident_number );
330:
331: WF_ENGINE.SetItemAttrText(
332: itemtype => 'SERVEREQ',
333: itemkey => itemkey,
334: aname => 'REQUEST_TYPE',
335: avalue => l_ServiceRequest_rec.incident_type );

Line 365: -- 05/05/2004 RMANABAT Performance . Used Wf_Engine.SetItemAttrArray

361: -- Modification History:
362: --
363: -- Date Name Desc
364: -- -------- ---------- --------------------------------------
365: -- 05/05/2004 RMANABAT Performance . Used Wf_Engine.SetItemAttrArray
366: -- for array processing instead of individual api calls.
367: -- -----------------------------------------------------------------------
368:
369: PROCEDURE Update_Request_Info ( itemtype VARCHAR2,

Line 451: tvarname Wf_Engine.NameTabTyp;

447: WHERE emp.resource_id = l_incident_owner_id;
448:
449: /*** end New 03/17/03. rmanabat ***/
450:
451: tvarname Wf_Engine.NameTabTyp;
452: tvarval Wf_Engine.TextTabTyp;
453:
454: nvarname Wf_Engine.NameTabTyp;
455: nvarval Wf_Engine.NumTabTyp;

Line 452: tvarval Wf_Engine.TextTabTyp;

448:
449: /*** end New 03/17/03. rmanabat ***/
450:
451: tvarname Wf_Engine.NameTabTyp;
452: tvarval Wf_Engine.TextTabTyp;
453:
454: nvarname Wf_Engine.NameTabTyp;
455: nvarval Wf_Engine.NumTabTyp;
456:

Line 454: nvarname Wf_Engine.NameTabTyp;

450:
451: tvarname Wf_Engine.NameTabTyp;
452: tvarval Wf_Engine.TextTabTyp;
453:
454: nvarname Wf_Engine.NameTabTyp;
455: nvarval Wf_Engine.NumTabTyp;
456:
457:
458: BEGIN

Line 455: nvarval Wf_Engine.NumTabTyp;

451: tvarname Wf_Engine.NameTabTyp;
452: tvarval Wf_Engine.TextTabTyp;
453:
454: nvarname Wf_Engine.NameTabTyp;
455: nvarval Wf_Engine.NumTabTyp;
456:
457:
458: BEGIN
459:

Line 463: l_request_id := WF_ENGINE.GetItemAttrNumber(

459:
460: IF (funmode = 'RUN') THEN
461:
462: -- Get the service request ID
463: l_request_id := WF_ENGINE.GetItemAttrNumber(
464: itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'REQUEST_ID' );
467:

Line 533: Wf_Engine.SetItemAttrTextArray(itemtype => 'SERVEREQ',

529: tvarval(8) := l_ServiceRequest_rec.summary;
530: tvarname(9) := 'REQUEST_URGENCY';
531: tvarval(9) := l_ServiceRequest_rec.urgency;
532:
533: Wf_Engine.SetItemAttrTextArray(itemtype => 'SERVEREQ',
534: itemkey => itemkey,
535: aname => tvarname,
536: avalue => tvarval);
537:

Line 545: Wf_Engine.SetItemAttrNumberArray(itemtype => 'SERVEREQ',

541: nvarval(2) := l_ServiceRequest_rec.customer_product_id;
542: nvarname(3) := 'INVENTORY_ITEM_ID';
543: nvarval(3) := l_ServiceRequest_rec.inventory_item_id;
544:
545: Wf_Engine.SetItemAttrNumberArray(itemtype => 'SERVEREQ',
546: itemkey => itemkey,
547: aname => nvarname,
548: avalue => nvarval);
549:

Line 550: WF_ENGINE.SetItemAttrDate(

546: itemkey => itemkey,
547: aname => nvarname,
548: avalue => nvarval);
549:
550: WF_ENGINE.SetItemAttrDate(
551: itemtype => 'SERVEREQ',
552: itemkey => itemkey,
553: aname => 'EXPECTED_RESOLUTION_DATE',
554: avalue => l_ServiceRequest_rec.expected_resolution_date );

Line 658: l_owner_id := WF_ENGINE.GetItemAttrNumber(

654:
655: IF (funmode = 'RUN') THEN
656:
657: -- Get the current owner of the request
658: l_owner_id := WF_ENGINE.GetItemAttrNumber(
659: itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'OWNER_ID' );
662:

Line 664: l_owner_role := WF_ENGINE.GetItemAttrText(

660: itemkey => itemkey,
661: aname => 'OWNER_ID' );
662:
663: -- Fix for Bug# 1810781 rmanabat
664: l_owner_role := WF_ENGINE.GetItemAttrText(
665: itemtype => itemtype,
666: itemkey => itemkey,
667: aname => 'OWNER_ROLE' );
668:

Line 713: WF_ENGINE.SetItemAttrNumber(

709: raise l_API_ERROR;
710: END IF;
711:
712: -- Update the item attributes
713: WF_ENGINE.SetItemAttrNumber(
714: itemtype => itemtype,
715: itemkey => itemkey,
716: aname => 'SUPERVISOR_ID',
717: avalue => l_supervisor_id );

Line 719: WF_ENGINE.SetItemAttrText(

715: itemkey => itemkey,
716: aname => 'SUPERVISOR_ID',
717: avalue => l_supervisor_id );
718:
719: WF_ENGINE.SetItemAttrText(
720: itemtype => itemtype,
721: itemkey => itemkey,
722: aname => 'SUPERVISOR_ROLE',
723: avalue => l_supervisor_role );

Line 725: WF_ENGINE.SetItemAttrText(

721: itemkey => itemkey,
722: aname => 'SUPERVISOR_ROLE',
723: avalue => l_supervisor_role );
724:
725: WF_ENGINE.SetItemAttrText(
726: itemtype => itemtype,
727: itemkey => itemkey,
728: aname => 'SUPERVISOR_NAME',
729: avalue => l_supervisor_name );

Line 819: l_owner_id := WF_ENGINE.GetItemAttrNumber(

815:
816: IF (funmode = 'RUN') THEN
817:
818: -- Get the current owner of the request
819: l_owner_id := WF_ENGINE.GetItemAttrNumber(
820: itemtype => itemtype,
821: itemkey => itemkey,
822: aname => 'OWNER_ID' );
823:

Line 825: l_new_owner_id := WF_ENGINE.GetActivityAttrNumber(

821: itemkey => itemkey,
822: aname => 'OWNER_ID' );
823:
824: -- Get the employee ID of the new owner
825: l_new_owner_id := WF_ENGINE.GetActivityAttrNumber(
826: itemtype => itemtype,
827: itemkey => itemkey,
828: actid => actid,
829: aname => 'NEW_OWNER_ID' );

Line 918: l_resp_id := WF_ENGINE.GetItemAttrNumber(

914: --l_new_owner_id := l_resource_id;
915:
916:
917: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN
918: l_resp_id := WF_ENGINE.GetItemAttrNumber(
919: itemtype => itemtype,
920: itemkey => itemkey,
921: aname => 'RESP_ID' );
922: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(

Line 922: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(

918: l_resp_id := WF_ENGINE.GetItemAttrNumber(
919: itemtype => itemtype,
920: itemkey => itemkey,
921: aname => 'RESP_ID' );
922: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
923: itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'RESP_APPL_ID' );
926: ELSE

Line 971: l_prev_owner_id := WF_ENGINE.GetItemAttrNumber(

967: l_errmsg_name := 'CS_SR_CANT_UPDATE_OWNER';
968: raise l_API_ERROR;
969: END IF;
970:
971: l_prev_owner_id := WF_ENGINE.GetItemAttrNumber(
972: itemtype => itemtype,
973: itemkey => itemkey,
974: aname => 'OWNER_ID' );
975:

Line 976: l_prev_owner_name := WF_ENGINE.GetItemAttrText(

972: itemtype => itemtype,
973: itemkey => itemkey,
974: aname => 'OWNER_ID' );
975:
976: l_prev_owner_name := WF_ENGINE.GetItemAttrText(
977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'OWNER_NAME' );
980:

Line 981: l_prev_owner_role := WF_ENGINE.GetItemAttrText(

977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'OWNER_NAME' );
980:
981: l_prev_owner_role := WF_ENGINE.GetItemAttrText(
982: itemtype => itemtype,
983: itemkey => itemkey,
984: aname => 'OWNER_ROLE' );
985:

Line 986: WF_ENGINE.SetItemAttrNumber(

982: itemtype => itemtype,
983: itemkey => itemkey,
984: aname => 'OWNER_ROLE' );
985:
986: WF_ENGINE.SetItemAttrNumber(
987: itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'PREV_OWNER_ID',
990: avalue => l_prev_owner_id );

Line 992: WF_ENGINE.SetItemAttrText(

988: itemkey => itemkey,
989: aname => 'PREV_OWNER_ID',
990: avalue => l_prev_owner_id );
991:
992: WF_ENGINE.SetItemAttrText(
993: itemtype => itemtype,
994: itemkey => itemkey,
995: aname => 'PREV_OWNER_ROLE',
996: avalue => l_prev_owner_role );

Line 998: WF_ENGINE.SetItemAttrText(

994: itemkey => itemkey,
995: aname => 'PREV_OWNER_ROLE',
996: avalue => l_prev_owner_role );
997:
998: WF_ENGINE.SetItemAttrText(
999: itemtype => itemtype,
1000: itemkey => itemkey,
1001: aname => 'PREV_OWNER_NAME',
1002: avalue => l_prev_owner_name );

Line 1004: WF_ENGINE.SetItemAttrNumber(

1000: itemkey => itemkey,
1001: aname => 'PREV_OWNER_NAME',
1002: avalue => l_prev_owner_name );
1003:
1004: WF_ENGINE.SetItemAttrNumber(
1005: itemtype => itemtype,
1006: itemkey => itemkey,
1007: aname => 'OWNER_ID',
1008: avalue => l_new_owner_id );

Line 1010: WF_ENGINE.SetItemAttrText(

1006: itemkey => itemkey,
1007: aname => 'OWNER_ID',
1008: avalue => l_new_owner_id );
1009:
1010: WF_ENGINE.SetItemAttrText(
1011: itemtype => itemtype,
1012: itemkey => itemkey,
1013: aname => 'OWNER_ROLE',
1014: avalue => l_new_owner_role );

Line 1016: WF_ENGINE.SetItemAttrText(

1012: itemkey => itemkey,
1013: aname => 'OWNER_ROLE',
1014: avalue => l_new_owner_role );
1015:
1016: WF_ENGINE.SetItemAttrText(
1017: itemtype => itemtype,
1018: itemkey => itemkey,
1019: aname => 'OWNER_NAME',
1020: avalue => l_new_owner_name );

Line 1095: l_owner_id := WF_ENGINE.GetItemAttrNumber(

1091:
1092: IF (funmode = 'RUN') THEN
1093:
1094: -- Get the current owner of the request
1095: l_owner_id := WF_ENGINE.GetItemAttrNumber(
1096: itemtype => itemtype,
1097: itemkey => itemkey,
1098: aname => 'OWNER_ID' );
1099:

Line 1203: l_new_status_id := WF_ENGINE.GetActivityAttrNumber(

1199: Null;
1200: end;
1201:
1202: -- Get the new status
1203: l_new_status_id := WF_ENGINE.GetActivityAttrNumber(
1204: itemtype => itemtype,
1205: itemkey => itemkey,
1206: actid => actid,
1207: aname => 'STATUS' );

Line 1280: l_resp_id := WF_ENGINE.GetItemAttrNumber(

1276: -- Added mandatory parameter last_update_program_code .11/19/02 rmanabat
1277: l_service_request_rec.last_update_program_code := 'SUPPORT.WF';
1278:
1279: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN
1280: l_resp_id := WF_ENGINE.GetItemAttrNumber(
1281: itemtype => itemtype,
1282: itemkey => itemkey,
1283: aname => 'RESP_ID' );
1284: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(

Line 1284: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(

1280: l_resp_id := WF_ENGINE.GetItemAttrNumber(
1281: itemtype => itemtype,
1282: itemkey => itemkey,
1283: aname => 'RESP_ID' );
1284: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
1285: itemtype => itemtype,
1286: itemkey => itemkey,
1287: aname => 'RESP_APPL_ID' );
1288: ELSE

Line 1387: WF_ENGINE.SetItemAttrText(

1383: INTO l_new_status
1384: FROM cs_incident_statuses
1385: WHERE incident_status_id = 2;
1386:
1387: WF_ENGINE.SetItemAttrText(
1388: itemtype => itemtype,
1389: itemkey => itemkey,
1390: aname => 'REQUEST_STATUS',
1391: avalue => l_new_status );

Line 1441: l_response_deadline := WF_ENGINE.GetItemAttrDate(

1437: BEGIN
1438: IF (funmode = 'RUN') THEN
1439:
1440: -- Get the response deadline
1441: l_response_deadline := WF_ENGINE.GetItemAttrDate(
1442: itemtype => itemtype,
1443: itemkey => itemkey,
1444: aname => 'RESPONSE_DEADLINE' );
1445:

Line 1481: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

1477: BEGIN
1478: IF (funmode = 'RUN') THEN
1479:
1480: -- Reset the response deadline to NULL
1481: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
1482: itemkey => itemkey,
1483: aname => 'RESPONSE_DEADLINE',
1484: avalue => '' );
1485:

Line 1537: l_error_itemkey := WF_ENGINE.GetItemAttrText(

1533:
1534: --
1535: -- Get the type and the key of the process that errored out
1536: --
1537: l_error_itemkey := WF_ENGINE.GetItemAttrText(
1538: itemtype => itemtype,
1539: itemkey => itemkey,
1540: aname => 'ERROR_ITEM_KEY' );
1541:

Line 1542: l_error_item_type := WF_ENGINE.GetItemAttrText(

1538: itemtype => itemtype,
1539: itemkey => itemkey,
1540: aname => 'ERROR_ITEM_KEY' );
1541:
1542: l_error_item_type := WF_ENGINE.GetItemAttrText(
1543: itemtype => itemtype,
1544: itemkey => itemkey,
1545: aname => 'ERROR_ITEM_TYPE' );
1546:

Line 1550: l_error_name := WF_ENGINE.GetItemAttrText(

1546:
1547: --
1548: -- Get the error message
1549: --
1550: l_error_name := WF_ENGINE.GetItemAttrText(
1551: itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'ERROR_NAME' );
1554:

Line 1563: l_administrator := WF_ENGINE.GetItemAttrText(

1559:
1560: --
1561: -- Get the workflow administrator
1562: --
1563: l_administrator := WF_ENGINE.GetItemAttrText(
1564: itemtype => l_error_item_type,
1565: itemkey => l_error_itemkey,
1566: aname => 'WF_ADMINISTRATOR' );
1567: --

Line 1570: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1566: aname => 'WF_ADMINISTRATOR' );
1567: --
1568: -- Set the item attributes of the error process
1569: --
1570: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1571: itemkey => itemkey,
1572: aname => 'ERROR_MESSAGE',
1573: avalue => l_error_msg );
1574:

Line 1575: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1571: itemkey => itemkey,
1572: aname => 'ERROR_MESSAGE',
1573: avalue => l_error_msg );
1574:
1575: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1576: itemkey => itemkey,
1577: aname => 'SERVEREQ_WF_ADMIN',
1578: avalue => l_administrator );
1579:

Line 1586: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1582: x_item_type => l_error_item_type,
1583: x_item_key => l_error_itemkey,
1584: x_admin_mode => 'YES'
1585: );
1586: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1587: itemkey => itemkey,
1588: aname => 'SERVEREQ_MONITOR_URL',
1589: avalue => l_monitor_url );
1590:

Line 1638: l_user_id := WF_ENGINE.GetItemAttrNumber

1634: -- Engine calls SET_CTX just before activity execution
1635: ELSIF (funcmode = 'SET_CTX') THEN
1636:
1637: -- First get the user id, resp id, and appl id
1638: l_user_id := WF_ENGINE.GetItemAttrNumber
1639: ( itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'USER_ID'
1642: );

Line 1643: l_resp_id := WF_ENGINE.GetItemAttrNumber

1639: ( itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'USER_ID'
1642: );
1643: l_resp_id := WF_ENGINE.GetItemAttrNumber
1644: ( itemtype => itemtype,
1645: itemkey => itemkey,
1646: aname => 'RESP_ID'
1647: );

Line 1648: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber

1644: ( itemtype => itemtype,
1645: itemkey => itemkey,
1646: aname => 'RESP_ID'
1647: );
1648: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber
1649: ( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'RESP_APPL_ID'
1652: );

Line 1747: WF_ENGINE.SetItemAttrNumber

1743: -- Set request ID first, in case if error occur, the workflow
1744: -- administrator can drilldown to the service request form from the error
1745: -- notification
1746: --
1747: WF_ENGINE.SetItemAttrNumber
1748: ( itemtype => itemtype,
1749: itemkey => itemkey,
1750: aname => 'REQUEST_ID',
1751: avalue => l_action_rec.incident_id

Line 1778: WF_ENGINE.SetItemAttrNumber

1774: RAISE l_exc_api_error;
1775: END IF;
1776:
1777: -- Initialize item attributes that will remain constant
1778: WF_ENGINE.SetItemAttrNumber
1779: ( itemtype => itemtype,
1780: itemkey => itemkey,
1781: aname => 'REQUEST_ACTION_ID',
1782: avalue => l_action_rec.incident_action_id

Line 1785: WF_ENGINE.SetItemAttrText

1781: aname => 'REQUEST_ACTION_ID',
1782: avalue => l_action_rec.incident_action_id
1783: );
1784:
1785: WF_ENGINE.SetItemAttrText
1786: ( itemtype => itemtype,
1787: itemkey => itemkey,
1788: aname => 'REQUEST_NUMBER',
1789: avalue => l_action_rec.incident_number

Line 1792: WF_ENGINE.SetItemAttrNumber

1788: aname => 'REQUEST_NUMBER',
1789: avalue => l_action_rec.incident_number
1790: );
1791:
1792: WF_ENGINE.SetItemAttrNumber
1793: ( itemtype => itemtype,
1794: itemkey => itemkey,
1795: aname => 'ACTION_NUMBER',
1796: avalue => l_action_rec.action_number

Line 1799: WF_ENGINE.SetItemAttrDate

1795: aname => 'ACTION_NUMBER',
1796: avalue => l_action_rec.action_number
1797: );
1798:
1799: WF_ENGINE.SetItemAttrDate
1800: ( itemtype => itemtype,
1801: itemkey => itemkey,
1802: aname => 'ACTION_DATE',
1803: avalue => l_action_rec.action_date

Line 1806: WF_ENGINE.SetItemAttrText

1802: aname => 'ACTION_DATE',
1803: avalue => l_action_rec.action_date
1804: );
1805:
1806: WF_ENGINE.SetItemAttrText
1807: ( itemtype => itemtype,
1808: itemkey => itemkey,
1809: aname => 'ACTION_TYPE',
1810: avalue => l_action_rec.action_type

Line 1813: WF_ENGINE.SetItemAttrText

1809: aname => 'ACTION_TYPE',
1810: avalue => l_action_rec.action_type
1811: );
1812:
1813: WF_ENGINE.SetItemAttrText
1814: ( itemtype => itemtype,
1815: itemkey => itemkey,
1816: aname => 'ACTION_STATUS',
1817: avalue => l_action_rec.action_status

Line 1820: WF_ENGINE.SetItemAttrText

1816: aname => 'ACTION_STATUS',
1817: avalue => l_action_rec.action_status
1818: );
1819:
1820: WF_ENGINE.SetItemAttrText
1821: ( itemtype => itemtype,
1822: itemkey => itemkey,
1823: aname => 'ACTION_SEVERITY',
1824: avalue => l_action_rec.action_severity

Line 1827: WF_ENGINE.SetItemAttrNumber

1823: aname => 'ACTION_SEVERITY',
1824: avalue => l_action_rec.action_severity
1825: );
1826:
1827: WF_ENGINE.SetItemAttrNumber
1828: ( itemtype => itemtype,
1829: itemkey => itemkey,
1830: aname => 'ASSIGNEE_ID',
1831: avalue => l_action_rec.action_assignee_id

Line 1834: WF_ENGINE.SetItemAttrText

1830: aname => 'ASSIGNEE_ID',
1831: avalue => l_action_rec.action_assignee_id
1832: );
1833:
1834: WF_ENGINE.SetItemAttrText
1835: ( itemtype => itemtype,
1836: itemkey => itemkey,
1837: aname => 'ASSIGNEE_ROLE',
1838: avalue => l_assignee_role

Line 1841: WF_ENGINE.SetItemAttrText

1837: aname => 'ASSIGNEE_ROLE',
1838: avalue => l_assignee_role
1839: );
1840:
1841: WF_ENGINE.SetItemAttrText
1842: ( itemtype => itemtype,
1843: itemkey => itemkey,
1844: aname => 'ASSIGNEE_NAME',
1845: avalue => l_assignee_name

Line 1848: WF_ENGINE.SetItemAttrText

1844: aname => 'ASSIGNEE_NAME',
1845: avalue => l_assignee_name
1846: );
1847:
1848: WF_ENGINE.SetItemAttrText
1849: ( itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'ACTION_SUMMARY',
1852: avalue => l_action_rec.action_summary

Line 1855: WF_ENGINE.SetItemAttrText

1851: aname => 'ACTION_SUMMARY',
1852: avalue => l_action_rec.action_summary
1853: );
1854:
1855: WF_ENGINE.SetItemAttrText
1856: ( itemtype => itemtype,
1857: itemkey => itemkey,
1858: aname => 'REQUEST_CUSTOMER',
1859: avalue => l_action_rec.incident_customer

Line 1862: WF_ENGINE.SetItemAttrNumber

1858: aname => 'REQUEST_CUSTOMER',
1859: avalue => l_action_rec.incident_customer
1860: );
1861:
1862: WF_ENGINE.SetItemAttrNumber
1863: ( itemtype => itemtype,
1864: itemkey => itemkey,
1865: aname => 'CUSTOMER_PRODUCT_ID',
1866: avalue => l_action_rec.customer_product_id

Line 1869: WF_ENGINE.SetItemAttrNumber

1865: aname => 'CUSTOMER_PRODUCT_ID',
1866: avalue => l_action_rec.customer_product_id
1867: );
1868:
1869: WF_ENGINE.SetItemAttrNumber
1870: ( itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'INVENTORY_ITEM_ID',
1873: avalue => l_action_rec.inventory_item_id

Line 1876: WF_ENGINE.SetItemAttrText

1872: aname => 'INVENTORY_ITEM_ID',
1873: avalue => l_action_rec.inventory_item_id
1874: );
1875:
1876: WF_ENGINE.SetItemAttrText
1877: ( itemtype => itemtype,
1878: itemkey => itemkey,
1879: aname => 'PRODUCT_DESCRIPTION',
1880: avalue => l_action_rec.product_description

Line 1883: WF_ENGINE.SetItemAttrText

1879: aname => 'PRODUCT_DESCRIPTION',
1880: avalue => l_action_rec.product_description
1881: );
1882:
1883: WF_ENGINE.SetItemAttrText
1884: ( itemtype => itemtype,
1885: itemkey => itemkey,
1886: aname => 'REQUEST_LOCATION',
1887: avalue => l_action_rec.incident_location

Line 1890: WF_ENGINE.SetItemAttrText

1886: aname => 'REQUEST_LOCATION',
1887: avalue => l_action_rec.incident_location
1888: );
1889:
1890: WF_ENGINE.SetItemAttrText
1891: ( itemtype => itemtype,
1892: itemkey => itemkey,
1893: aname => 'ACTION_DESCRIPTION',
1894: avalue => l_action_rec.action_description

Line 1897: WF_ENGINE.SetItemAttrDate

1893: aname => 'ACTION_DESCRIPTION',
1894: avalue => l_action_rec.action_description
1895: );
1896:
1897: WF_ENGINE.SetItemAttrDate
1898: ( itemtype => itemtype,
1899: itemkey => itemkey,
1900: aname => 'EXPECTED_RESOLUTION_DATE',
1901: avalue => l_action_rec.expected_resolution_date

Line 1937: l_launched_by_dispatch := WF_ENGINE.GetItemAttrText

1933: IS
1934: l_launched_by_dispatch VARCHAR2(1);
1935: BEGIN
1936: IF (funcmode = 'RUN') THEN
1937: l_launched_by_dispatch := WF_ENGINE.GetItemAttrText
1938: ( itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'LAUNCHED_BY_DISPATCH'
1941: );

Line 1998: l_request_id := WF_ENGINE.GetItemAttrText

1994:
1995: BEGIN
1996: IF (funcmode = 'RUN') THEN
1997: -- Get the service request ID and action number
1998: l_request_id := WF_ENGINE.GetItemAttrText
1999: ( itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'REQUEST_ID'
2002: );

Line 2003: l_action_number := WF_ENGINE.GetItemAttrText

1999: ( itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'REQUEST_ID'
2002: );
2003: l_action_number := WF_ENGINE.GetItemAttrText
2004: ( itemtype => itemtype,
2005: itemkey => itemkey,
2006: aname => 'ACTION_NUMBER'
2007: );

Line 2026: WF_ENGINE.SetItemAttrText

2022: END IF;
2023: CLOSE l_dispatch_csr;
2024:
2025: -- Update service request action item attributes
2026: WF_ENGINE.SetItemAttrText
2027: ( itemtype => itemtype,
2028: itemkey => itemkey,
2029: aname => 'DISPATCHER_ORIG_SYST',
2030: avalue => l_orig_system

Line 2033: WF_ENGINE.SetItemAttrNumber

2029: aname => 'DISPATCHER_ORIG_SYST',
2030: avalue => l_orig_system
2031: );
2032:
2033: WF_ENGINE.SetItemAttrNumber
2034: ( itemtype => itemtype,
2035: itemkey => itemkey,
2036: aname => 'DISPATCHER_ORIG_SYST_ID',
2037: avalue => l_orig_system_id

Line 2040: WF_ENGINE.SetItemAttrText

2036: aname => 'DISPATCHER_ORIG_SYST_ID',
2037: avalue => l_orig_system_id
2038: );
2039:
2040: WF_ENGINE.SetItemAttrText
2041: ( itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'DISPATCHER_ROLE',
2044: avalue => l_role_name

Line 2047: WF_ENGINE.SetItemAttrText

2043: aname => 'DISPATCHER_ROLE',
2044: avalue => l_role_name
2045: );
2046:
2047: WF_ENGINE.SetItemAttrText
2048: ( itemtype => itemtype,
2049: itemkey => itemkey,
2050: aname => 'DISPATCHER_NAME',
2051: avalue => l_display_name

Line 2128: l_request_id := WF_ENGINE.GetItemAttrText (

2124:
2125: BEGIN
2126: IF (funcmode = 'RUN') THEN
2127: -- Get the service request ID and action number
2128: l_request_id := WF_ENGINE.GetItemAttrText (
2129: itemtype => itemtype,
2130: itemkey => itemkey,
2131: aname => 'REQUEST_ID');
2132:

Line 2133: l_action_number := WF_ENGINE.GetItemAttrText (

2129: itemtype => itemtype,
2130: itemkey => itemkey,
2131: aname => 'REQUEST_ID');
2132:
2133: l_action_number := WF_ENGINE.GetItemAttrText (
2134: itemtype => itemtype,
2135: itemkey => itemkey,
2136: aname => 'ACTION_NUMBER');
2137:

Line 2176: l_fs_mode := WF_ENGINE.GetItemAttrText (

2172:
2173: --- This attribute identifies whether to do insert or update
2174: --- on the interface table
2175:
2176: l_fs_mode := WF_ENGINE.GetItemAttrText (
2177: itemtype => itemtype,
2178: itemkey => itemkey,
2179: aname => 'FS_INTERFACE_MODE');
2180: IF (funcmode = 'RUN') THEN

Line 2215: l_incident_id := WF_ENGINE.GetItemAttrNumber (

2211: l_incident_id NUMBER;
2212: l_incident_action_id NUMBER;
2213: l_response VARCHAR2(80) := NULL ;
2214: BEGIN
2215: l_incident_id := WF_ENGINE.GetItemAttrNumber (
2216: itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'REQUEST_ID');
2219:

Line 2220: l_incident_action_id := WF_ENGINE.GetItemAttrNumber (

2216: itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'REQUEST_ID');
2219:
2220: l_incident_action_id := WF_ENGINE.GetItemAttrNumber (
2221: itemtype => itemtype,
2222: itemkey => itemkey,
2223: aname => 'REQUEST_ACTION_ID');
2224:

Line 2407: WF_ENGINE.SetItemAttrText(

2403: action_rec.problem_summary);
2404: -- Set the mode to updated to have the workflow update this record
2405: -- when it loops through next time
2406:
2407: WF_ENGINE.SetItemAttrText(
2408: itemtype => itemtype,
2409: itemkey => itemkey,
2410: aname => 'FS_INTERFACE_MODE',
2411: avalue => 'CREATED');

Line 2413: WF_ENGINE.SetItemAttrNumber(

2409: itemkey => itemkey,
2410: aname => 'FS_INTERFACE_MODE',
2411: avalue => 'CREATED');
2412:
2413: WF_ENGINE.SetItemAttrNumber(
2414: itemtype => itemtype,
2415: itemkey => itemkey,
2416: aname => 'FS_INTERFACE_ID',
2417: avalue => l_fs_interface_id);

Line 2450: l_incident_id := WF_ENGINE.GetItemAttrNumber (

2446: l_incident_id NUMBER;
2447: l_incident_action_id NUMBER;
2448:
2449: BEGIN
2450: l_incident_id := WF_ENGINE.GetItemAttrNumber (
2451: itemtype => itemtype,
2452: itemkey => itemkey,
2453: aname => 'REQUEST_ID');
2454:

Line 2455: l_incident_action_id := WF_ENGINE.GetItemAttrNumber (

2451: itemtype => itemtype,
2452: itemkey => itemkey,
2453: aname => 'REQUEST_ID');
2454:
2455: l_incident_action_id := WF_ENGINE.GetItemAttrNumber (
2456: itemtype => itemtype,
2457: itemkey => itemkey,
2458: aname => 'REQUEST_ACTION_ID');
2459:

Line 2473: l_fs_interface_id := WF_ENGINE.GetItemAttrNumber (

2469: l_errmsg_name := 'CS_WF_SR_ACTION_NOT_FOUND';
2470: RAISE ACTION_NOT_FOUND;
2471: END IF;
2472:
2473: l_fs_interface_id := WF_ENGINE.GetItemAttrNumber (
2474: itemtype => itemtype,
2475: itemkey => itemkey,
2476: aname => 'FS_INTERFACE_ID');
2477:

Line 2535: WF_ENGINE.SetItemAttrText(

2531: CURRENT_SERIAL_NUMBER =action_rec.current_serial_number,
2532: INSTALLATION_DATE =action_rec.installation_date
2533: WHERE FIELD_SERVICE_INTERFACE_ID = l_fs_interface_id;
2534:
2535: WF_ENGINE.SetItemAttrText(
2536: itemtype => itemtype,
2537: itemkey => itemkey,
2538: aname => 'FS_INTERFACE_MODE',
2539: avalue => 'UPDATED');

Line 2594: WF_ENGINE.CompleteActivity (

2590: to_char(p_action_number) || '-' || to_char(l_wf_id) ;
2591: --dbms_output.put_line('ACTIVE ' || l_wf_active || ' ' || l_wf_key);
2592:
2593: IF l_wf_active = 'Y' THEN
2594: WF_ENGINE.CompleteActivity (
2595: itemtype => g_fs_itemtype,
2596: itemkey => l_wf_key,
2597: activity => g_fs_activity,
2598: result => p_response);