DBA Data[Home] [Help]

APPS.CUG_GENERIC_WF_PKG dependencies on WF_ENGINE

Line 80: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

76:
77: BEGIN
78:
79: IF (funmode = 'RUN') THEN
80: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
81: itemkey => itemkey,
82: aname => 'REQUEST_ID');
83:
84: OPEN l_CheckIfSRAttrPresent_csr;

Line 173: WF_ENGINE.SetItemAttrText(

169: CLOSE l_ServiceRequest_csr;
170:
171: -- End of changes by ANEEMUCH date 09-May-2002
172:
173: WF_ENGINE.SetItemAttrText(
174: itemtype => 'SERVEREQ',
175: itemkey => itemkey,
176: aname => 'CUG_INCIDENT_ADDRESS',
177: avalue => l_incident_address );

Line 281: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

277:
278: BEGIN
279: IF (funmode = 'RUN') THEN
280:
281: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'REQUEST_ID');
284:
285: select INCIDENT_TYPE_ID into l_incident_type_id FROM

Line 362: WF_ENGINE.SetItemAttrText(

358: END IF; --end of the entire if-then-else block
359: */
360:
361:
362: WF_ENGINE.SetItemAttrText(
363: itemtype => 'SERVEREQ',
364: itemkey => itemkey,
365: aname => 'OWNER_NAME',
366: avalue => l_owner_role );

Line 369: WF_ENGINE.SetItemAttrText(

365: aname => 'OWNER_NAME',
366: avalue => l_owner_role );
367:
368: /*
369: WF_ENGINE.SetItemAttrText(
370: itemtype => 'SERVEREQ',
371: itemkey => itemkey,
372: aname => 'OWNER_NAME',
373: avalue => l_GetResourceName_rec.resource_name );

Line 376: WF_ENGINE.SetItemAttrText(

372: aname => 'OWNER_NAME',
373: avalue => l_GetResourceName_rec.resource_name );
374:
375:
376: WF_ENGINE.SetItemAttrText(
377: itemtype => 'SERVEREQ',
378: itemkey => itemkey,
379: aname => 'OWNER_ROLE',
380: avalue => l_owner_role );

Line 430: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

426: BEGIN
427:
428: IF (funmode = 'RUN') THEN
429:
430: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
431: itemkey => itemkey,
432: aname => 'REQUEST_ID');
433:
434: OPEN c_GetOverrideFlag_csr;

Line 488: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

484:
485: BEGIN
486: IF (funmode = 'RUN') THEN
487:
488: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'REQUEST_ID');
491:
492: select INCIDENT_TYPE_ID into l_request_type_id from CS_INCIDENTS_ALL_VL

Line 683: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

679:
680: l_attr_counter := 0;
681: l_incident_counter := 1;
682:
683: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'REQUEST_ID');
686:
687: l_owner_name := WF_Engine.GetItemAttrText(itemtype => itemtype,

Line 687: l_owner_name := WF_Engine.GetItemAttrText(itemtype => itemtype,

683: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'REQUEST_ID');
686:
687: l_owner_name := WF_Engine.GetItemAttrText(itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'OWNER_NAME');
690:
691: -- Beging of changes by ANEEMUCH date 10-May-2002

Line 794: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

790: CLOSE l_DuplicateCheckAttrs_csr;
791:
792: IF (l_match_found = 1) THEN
793: result := 'Y';
794: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
795: itemkey => itemkey,
796: aname => 'CUG_PARENT_REQUEST_ID',
797: avalue => l_IncidentId_rec.Incident_Id);
798: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 798: Wf_Engine.SetItemAttrText(itemtype => itemtype,

794: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
795: itemkey => itemkey,
796: aname => 'CUG_PARENT_REQUEST_ID',
797: avalue => l_IncidentId_rec.Incident_Id);
798: Wf_Engine.SetItemAttrText(itemtype => itemtype,
799: itemkey => itemkey,
800: aname => 'CUG_PARENT_REQUEST_NUMBER',
801: avalue => l_IncidentId_rec.Incident_Number);
802: return;

Line 860: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

856: CLOSE l_DuplicateCheckAttrs_csr;
857:
858: IF (l_match_found = 1) THEN
859: result := 'Y';
860: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'CUG_PARENT_REQUEST_ID',
863: avalue => l_IncidentId_noLoc_rec.Incident_Id);
864: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 864: Wf_Engine.SetItemAttrText(itemtype => itemtype,

860: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'CUG_PARENT_REQUEST_ID',
863: avalue => l_IncidentId_noLoc_rec.Incident_Id);
864: Wf_Engine.SetItemAttrText(itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'CUG_PARENT_REQUEST_NUMBER',
867: avalue => l_IncidentId_noLoc_rec.Incident_Number);
868: return;

Line 934: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

930: BEGIN
931:
932: IF (funmode = 'RUN') THEN
933:
934: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
935: itemkey => itemkey,
936: aname => 'REQUEST_ID');
937:
938: select INCIDENT_TYPE_ID into l_request_type_id FROM

Line 994: l_note_context_type_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

990:
991: OPEN c_SR_Attr_Note_csr;
992: FETCH c_SR_Attr_Note_csr into l_note_id;
993:
994: l_note_context_type_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
995: itemkey => itemkey,
996: aname => 'CUG_PARENT_REQUEST_ID');
997:
998:

Line 1127: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

1123:
1124:
1125: IF (funmode = 'RUN') THEN
1126:
1127: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'REQUEST_ID');
1130: /* Begin - 09/24/2001 - change made to accomodate Rahul's problem with update_task API */
1131: l_request_number := WF_Engine.GetItemAttrText(itemtype => itemtype,

Line 1131: l_request_number := WF_Engine.GetItemAttrText(itemtype => itemtype,

1127: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'REQUEST_ID');
1130: /* Begin - 09/24/2001 - change made to accomodate Rahul's problem with update_task API */
1131: l_request_number := WF_Engine.GetItemAttrText(itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'REQUEST_NUMBER');
1134: /* End - 09/24/2001 - change made to accomodate Rahul's problem with update_task API */
1135:

Line 1412: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,

1408: -- set result = 'failed task status' and return
1409:
1410: IF (funmode = 'RUN') THEN
1411:
1412: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
1413: itemkey => itemkey,
1414: aname => 'REQUEST_ID');
1415:
1416: SELECT incident_type_id into l_request_type_id from CS_INCIDENTS_ALL_B where incident_id = l_request_id;

Line 1430: WF_Engine.SetItemAttrText(itemtype => itemtype,

1426: -- FOR l_SRTasks_rec IN c_SRTasks_csr LOOP
1427: l_task_type_id := l_SRTasks_rec.task_type_id;
1428:
1429: IF (l_SRTasks_rec.name = FND_PROFILE.Value('CUG_TASK_FAILED_STATUS')) THEN
1430: WF_Engine.SetItemAttrText(itemtype => itemtype,
1431: itemkey => itemkey,
1432: aname => 'CUG_ERROR_TYPE',
1433: avalue => 'failed task');
1434:

Line 1435: WF_Engine.SetItemAttrText(itemtype => itemtype,

1431: itemkey => itemkey,
1432: aname => 'CUG_ERROR_TYPE',
1433: avalue => 'failed task');
1434:
1435: WF_Engine.SetItemAttrText(itemtype => itemtype,
1436: itemkey => itemkey,
1437: aname => 'CUG_TASK_NUMBER',
1438: avalue => l_SRTasks_rec.task_number);
1439:

Line 1473: WF_Engine.SetItemAttrText(itemtype => itemtype,

1469: END IF;
1470: --
1471: -- End of changes by ANEEMUCH date 23-May-2002
1472:
1473: WF_Engine.SetItemAttrText(itemtype => itemtype,
1474: itemkey => itemkey,
1475: aname => 'CUG_TASK_OWNER_NAME',
1476: avalue => l_resource_name);
1477:

Line 1478: WF_Engine.SetItemAttrNumber(itemtype => itemtype,

1474: itemkey => itemkey,
1475: aname => 'CUG_TASK_OWNER_NAME',
1476: avalue => l_resource_name);
1477:
1478: WF_Engine.SetItemAttrNumber(itemtype => itemtype,
1479: itemkey => itemkey,
1480: aname => 'CUG_TASK_ID',
1481: avalue => l_SRTasks_rec.task_id);
1482:

Line 1717: wf_engine.createprocess (

1713: END IF;
1714: CLOSE c_task_details;
1715:
1716:
1717: wf_engine.createprocess (
1718: itemtype => 'JTFTASK',
1719: itemkey => l_itemkey,
1720: process => p_wf_process
1721: );

Line 1724: wf_engine.setitemuserkey (

1720: process => p_wf_process
1721: );
1722:
1723:
1724: wf_engine.setitemuserkey (
1725: itemtype => 'JTFTASK',
1726: itemkey => l_itemkey,
1727: userkey => l_task_name
1728: );

Line 1730: wf_engine.setitemattrtext (

1726: itemkey => l_itemkey,
1727: userkey => l_task_name
1728: );
1729:
1730: wf_engine.setitemattrtext (
1731: itemtype => 'JTFTASK',
1732: itemkey => l_itemkey,
1733: aname => 'TASK_NAME',
1734: avalue => l_task_name

Line 1738: wf_engine.setitemattrtext (

1734: avalue => l_task_name
1735: );
1736:
1737:
1738: wf_engine.setitemattrtext (
1739: itemtype => 'JTFTASK',
1740: itemkey => l_itemkey,
1741: aname => 'TASK_DESC',
1742: avalue => l_description

Line 1745: wf_engine.setitemattrtext (

1741: aname => 'TASK_DESC',
1742: avalue => l_description
1743: );
1744:
1745: wf_engine.setitemattrtext (
1746: itemtype => 'JTFTASK',
1747: itemkey => l_itemkey,
1748: aname => 'TASK_NUMBER',
1749: avalue => l_task_number

Line 1757: wf_engine.setitemattrtext (

1753: into l_task_status_name, l_task_priority_name , l_task_type_name
1754: from jtf_tasks_v where task_id = p_task_id ;
1755:
1756:
1757: wf_engine.setitemattrtext (
1758: itemtype => 'JTFTASK',
1759: itemkey => l_itemkey,
1760: aname => 'TASK_STATUS_NAME',
1761: avalue => l_task_status_name

Line 1764: wf_engine.setitemattrtext (

1760: aname => 'TASK_STATUS_NAME',
1761: avalue => l_task_status_name
1762: );
1763:
1764: wf_engine.setitemattrtext (
1765: itemtype => 'JTFTASK',
1766: itemkey => l_itemkey,
1767: aname => 'TASK_PRIORITY_NAME',
1768: avalue => l_task_priority_name

Line 1771: wf_engine.setitemattrtext (

1767: aname => 'TASK_PRIORITY_NAME',
1768: avalue => l_task_priority_name
1769: );
1770:
1771: wf_engine.setitemattrtext (
1772: itemtype => 'JTFTASK',
1773: itemkey => l_itemkey,
1774: aname => 'TASK_TYPE_NAME',
1775: avalue => l_task_type_name

Line 1791: wf_engine.setitemattrtext (

1787: end if ;
1788: End Roopa */
1789:
1790:
1791: wf_engine.setitemattrtext (
1792: itemtype => 'JTFTASK',
1793: itemkey => l_itemkey,
1794: aname => 'OWNER_ID',
1795: avalue => l_owner_user_name

Line 1800: wf_engine.setitemattrtext (

1796: );
1797:
1798:
1799: /* Roopa
1800: wf_engine.setitemattrtext (
1801: itemtype => 'JTFTASK',
1802: itemkey => l_itemkey,
1803: aname => 'OWNER_NAME',
1804: -- avalue => wf_directory.getroledisplayname (l_owner_user_name)

Line 1809: wf_engine.setitemattrtext (

1805: avalue => jtf_task_utl.get_owner(l_owner_code, l_owner_id)
1806: );
1807: End Roopa */
1808:
1809: wf_engine.setitemattrtext (
1810: itemtype => 'JTFTASK',
1811: itemkey => l_itemkey,
1812: aname => 'TASK_DESC',
1813: avalue => l_description

Line 1817: wf_engine.setitemattrnumber (

1813: avalue => l_description
1814: );
1815:
1816:
1817: wf_engine.setitemattrnumber (
1818: itemtype => 'JTFTASK',
1819: itemkey => l_itemkey,
1820: aname => 'CUG_TASK_DEP_ID',
1821: avalue => l_task_dep_id

Line 1824: wf_engine.startprocess (

1820: aname => 'CUG_TASK_DEP_ID',
1821: avalue => l_task_dep_id
1822: );
1823:
1824: wf_engine.startprocess (
1825: itemtype => 'JTFTASK',
1826: itemkey => l_itemkey
1827: );
1828:

Line 1916: WF_ENGINE.SetItemAttrText(

1912: p_return_status := 'S';
1913: SELECT name into l_task_name
1914: FROM jtf_task_types_vl
1915: WHERE task_type_id = p_task_type_id;
1916: WF_ENGINE.SetItemAttrText(
1917: itemtype => 'SERVEREQ',
1918: itemkey => p_itemkey,
1919: aname => 'CUG_TASK_TYPE',
1920: avalue => l_task_name);

Line 1990: l_request_id := WF_ENGINE.GetItemAttrNumber(

1986:
1987: IF (funmode = 'RUN') THEN
1988:
1989: -- Get the service request ID
1990: l_request_id := WF_ENGINE.GetItemAttrNumber(
1991: itemtype => itemtype,
1992: itemkey => itemkey,
1993: aname => 'REQUEST_ID' );
1994:

Line 2024: WF_ENGINE.SetItemAttrNumber(

2020: raise l_API_ERROR;
2021: END IF;
2022:
2023: -- Update service request item attributes
2024: WF_ENGINE.SetItemAttrNumber(
2025: itemtype => 'SERVEREQ',
2026: itemkey => itemkey,
2027: aname => 'OWNER_ID',
2028: avalue => l_ServiceRequest_rec.incident_owner_id );

Line 2030: WF_ENGINE.SetItemAttrText(

2026: itemkey => itemkey,
2027: aname => 'OWNER_ID',
2028: avalue => l_ServiceRequest_rec.incident_owner_id );
2029:
2030: WF_ENGINE.SetItemAttrText(
2031: itemtype => 'SERVEREQ',
2032: itemkey => itemkey,
2033: aname => 'OWNER_ROLE',
2034: avalue => l_owner_role );

Line 2036: WF_ENGINE.SetItemAttrText(

2032: itemkey => itemkey,
2033: aname => 'OWNER_ROLE',
2034: avalue => l_owner_role );
2035:
2036: WF_ENGINE.SetItemAttrText(
2037: itemtype => 'SERVEREQ',
2038: itemkey => itemkey,
2039: aname => 'OWNER_NAME',
2040: avalue => l_owner_name );

Line 2044: WF_ENGINE.SetItemAttrNumber(

2040: avalue => l_owner_name );
2041: END IF; -- fix for bug 2576759
2042:
2043:
2044: WF_ENGINE.SetItemAttrNumber(
2045: itemtype => 'SERVEREQ',
2046: itemkey => itemkey,
2047: aname => 'CUSTOMER_PRODUCT_ID',
2048: avalue => l_ServiceRequest_rec.customer_product_id );

Line 2050: WF_ENGINE.SetItemAttrDate(

2046: itemkey => itemkey,
2047: aname => 'CUSTOMER_PRODUCT_ID',
2048: avalue => l_ServiceRequest_rec.customer_product_id );
2049:
2050: WF_ENGINE.SetItemAttrDate(
2051: itemtype => 'SERVEREQ',
2052: itemkey => itemkey,
2053: aname => 'EXPECTED_RESOLUTION_DATE',
2054: avalue => l_ServiceRequest_rec.expected_resolution_date );

Line 2056: WF_ENGINE.SetItemAttrNumber(

2052: itemkey => itemkey,
2053: aname => 'EXPECTED_RESOLUTION_DATE',
2054: avalue => l_ServiceRequest_rec.expected_resolution_date );
2055:
2056: WF_ENGINE.SetItemAttrNumber(
2057: itemtype => 'SERVEREQ',
2058: itemkey => itemkey,
2059: aname => 'INVENTORY_ITEM_ID',
2060: avalue => l_ServiceRequest_rec.inventory_item_id );

Line 2062: WF_ENGINE.SetItemAttrText(

2058: itemkey => itemkey,
2059: aname => 'INVENTORY_ITEM_ID',
2060: avalue => l_ServiceRequest_rec.inventory_item_id );
2061:
2062: WF_ENGINE.SetItemAttrText(
2063: itemtype => 'SERVEREQ',
2064: itemkey => itemkey,
2065: aname => 'REQUEST_SUMMARY',
2066: avalue => l_ServiceRequest_rec.summary );

Line 2146: WF_ENGINE.SetItemAttrDate(

2142: OPEN l_ServiceRequest_csr;
2143: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
2144:
2145: -- Initialize item attributes that will remain constant
2146: WF_ENGINE.SetItemAttrDate(
2147: itemtype => 'SERVEREQ',
2148: itemkey => itemkey,
2149: aname => 'REQUEST_DATE',
2150: avalue => l_ServiceRequest_rec.incident_date );

Line 2152: WF_ENGINE.SetItemAttrNumber(

2148: itemkey => itemkey,
2149: aname => 'REQUEST_DATE',
2150: avalue => l_ServiceRequest_rec.incident_date );
2151:
2152: WF_ENGINE.SetItemAttrNumber(
2153: itemtype => 'SERVEREQ',
2154: itemkey => itemkey,
2155: aname => 'REQUEST_ID',
2156: avalue => l_ServiceRequest_rec.incident_id );

Line 2158: WF_ENGINE.SetItemAttrText(

2154: itemkey => itemkey,
2155: aname => 'REQUEST_ID',
2156: avalue => l_ServiceRequest_rec.incident_id );
2157:
2158: WF_ENGINE.SetItemAttrText(
2159: itemtype => 'SERVEREQ',
2160: itemkey => itemkey,
2161: aname => 'REQUEST_NUMBER',
2162: avalue => l_ServiceRequest_rec.incident_number );

Line 2165: WF_ENGINE.SetItemAttrText(

2161: aname => 'REQUEST_NUMBER',
2162: avalue => l_ServiceRequest_rec.incident_number );
2163:
2164: /*
2165: WF_ENGINE.SetItemAttrText(
2166: itemtype => 'SERVEREQ',
2167: itemkey => itemkey,
2168: aname => 'REQUEST_TYPE',
2169: avalue => l_ServiceRequest_rec.incident_type );