[Home] [Help]
83: ||l_msg_data||Fnd_Global.local_chr(10) ;
84: l_cnt := l_cnt + 1 ;
85: END LOOP ;
86: x_error_msg := l_final_data;
87: Wf_Engine.SetItemAttrText
88: (itemtype => p_itemtype,
89: itemkey => p_itemkey ,
90: aname => p_attr_name,
91: avalue => l_final_data );
343: p_msg_data => 'Update_Note: Exiting sucessfully'); */
344:
345: EXCEPTION
346: WHEN OTHERS THEN
347: -- wf_engine.threshold := l_save_threshold ;
348: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type
349: ,p_activity_id , 'Unexpected Error in Update_Note' );
350: RAISE;
351:
439: p_msg_data => 'Update_Note: Exiting sucessfully'); */
440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: -- wf_engine.threshold := l_save_threshold ;
444: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type
445: ,p_activity_id , 'Unexpected Error in Update_Note' );
446: RAISE;
447:
484: END IF;
485: CLOSE c_resource ;
486: EXCEPTION
487: WHEN OTHERS THEN
488: -- wf_engine.threshold := l_save_threshold ;
489: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Name',p_user_id,
490: 'Unexpected Error IN Get_User_Name');
491: RAISE;
492:
544: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
545:
546: BEGIN
547:
548: l_forward_nid := Wf_Engine.GetItemAttrNumber(
549: itemtype => itemtype,
550: itemkey => itemkey,
551: aname => 'AMS_FORWARD_NID');
552:
561:
562: IF l_return_status = Fnd_Api.G_RET_STS_SUCCESS THEN
563:
564: -- Set the WF Attributes
565: wf_engine.SetItemAttrText( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'AMS_APPR_USERNAME',
568: avalue => l_responder);
569:
567: aname => 'AMS_APPR_USERNAME',
568: avalue => l_responder);
569:
570:
571: wf_engine.SetItemAttrNumber(itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'AMS_APPROVER_ID',
574: avalue => l_approver_id);
575:
573: aname => 'AMS_APPROVER_ID',
574: avalue => l_approver_id);
575:
576:
577: wf_engine.SetItemAttrText( itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'AMS_APPR_DISPLAY_NAME',
580: avalue => l_appr_display_name);
581:
583: END IF;
584: -- Reset the forward_nid wf attribute to null
585: -- This is a must
586:
587: wf_engine.SetItemAttrNumber(itemtype => itemtype,
588: itemkey => itemkey,
589: aname => 'AMS_FORWARD_NID',
590: avalue => null);
591:
665: END IF;
666: END IF;
667: EXCEPTION
668: WHEN OTHERS THEN
669: -- wf_engine.threshold := l_save_threshold ;
670: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Role',p_user_id
671: ,'Unexpected Error IN Get_User_Role' );
672: RAISE;
673: END Get_User_Role;
927: END IF;
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: -- wf_engine.threshold := l_save_threshold ;
932: Wf_Core.context ('ams_approval_pvt', 'Get_Activity_Details',p_activity_type
933: ,p_activity_id ,'Unexpected Error In Get_Activity_Details');
934: RAISE;
935:
1225: END IF;
1226: CLOSE c_approver_info;
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: -- wf_engine.threshold := l_save_threshold ;
1230:
1231: Wf_Core.context ('Ams_Approval_Pvt', 'Get_Approver_Info',p_approval_detail_id
1232: ,p_current_seq ,'Unexpected Error IN Get_Approver_Info');
1233: RAISE;
1685: l_msg_data VARCHAR2(4000);
1686: l_error_msg VARCHAR2(4000);
1687: x_resource_id NUMBER;
1688:
1689: l_save_threshold NUMBER := Wf_Engine.threshold;
1690:
1691: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;
1692:
1693: -- [BEGIN OF BUG2741039 FIXING by vmodur 09-Jan-2003]
1727:
1728: Ams_Utility_Pvt.debug_message('START :Item TYPE : '||itemtype
1729: ||' Item KEY : '||itemkey);
1730:
1731: -- wf_engine.threshold := -1;
1732: Wf_Engine.CreateProcess (itemtype => itemtype,
1733: itemkey => itemkey ,
1734: process => p_workflowprocess);
1735:
1728: Ams_Utility_Pvt.debug_message('START :Item TYPE : '||itemtype
1729: ||' Item KEY : '||itemkey);
1730:
1731: -- wf_engine.threshold := -1;
1732: Wf_Engine.CreateProcess (itemtype => itemtype,
1733: itemkey => itemkey ,
1734: process => p_workflowprocess);
1735:
1736: Wf_Engine.SetItemUserkey(itemtype => itemtype,
1732: Wf_Engine.CreateProcess (itemtype => itemtype,
1733: itemkey => itemkey ,
1734: process => p_workflowprocess);
1735:
1736: Wf_Engine.SetItemUserkey(itemtype => itemtype,
1737: itemkey => itemkey ,
1738: userkey => itemuserkey);
1739:
1740: -- 09-Jan-2003 VMODUR Fix for BUG 2741039 - add pl/sql global context into
1746: l_resp_id := FND_GLOBAL.resp_id;
1747: l_appl_id := FND_GLOBAL.resp_appl_id;
1748: l_security_group_id := FND_GLOBAL.security_group_id;
1749:
1750: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1751: itemkey => itemkey,
1752: aname => 'USER_ID',
1753: avalue => l_user_id
1754: );
1752: aname => 'USER_ID',
1753: avalue => l_user_id
1754: );
1755:
1756: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1757: itemkey => itemkey,
1758: aname => 'RESPONSIBILITY_ID',
1759: avalue => l_resp_id
1760: );
1758: aname => 'RESPONSIBILITY_ID',
1759: avalue => l_resp_id
1760: );
1761:
1762: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1763: itemkey => itemkey,
1764: aname => 'APPLICATION_ID',
1765: avalue => l_appl_id
1766: );
1764: aname => 'APPLICATION_ID',
1765: avalue => l_appl_id
1766: );
1767:
1768: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1769: itemkey => itemkey,
1770: aname => 'SECURITY_GROUP_ID',
1771: avalue => l_security_group_id
1772: );
1776: Initialize Workflow Item Attributes
1777: *****************************************************************/
1778:
1779: -- Activity Type (Some of valid values are 'CAMP','DELV','EVEH','EVEO'..);
1780: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
1781: itemkey => itemkey,
1782: aname => 'AMS_ACTIVITY_TYPE',
1783: avalue => p_activity_type );
1784:
1782: aname => 'AMS_ACTIVITY_TYPE',
1783: avalue => p_activity_type );
1784:
1785: -- Activity ID (primary Id of Activity Object)
1786: Wf_Engine.SetItemAttrNumber(itemtype => itemtype ,
1787: itemkey => itemkey,
1788: aname => 'AMS_ACTIVITY_ID',
1789: avalue => p_activity_id );
1790:
1790:
1791:
1792: -- Original Status Id (If error occurs we have to revert back to this
1793: -- status )
1794: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1795: itemkey => itemkey,
1796: aname => 'AMS_ORIG_STAT_ID',
1797: avalue => p_orig_stat_id );
1798:
1797: avalue => p_orig_stat_id );
1798:
1799: -- New Status Id (If activity is approved status of activity is updated
1800: -- by this status )
1801: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1802: itemkey => itemkey,
1803: aname => 'AMS_NEW_STAT_ID',
1804: avalue => p_new_stat_id );
1805:
1804: avalue => p_new_stat_id );
1805:
1806: -- Reject Status Id (If activity is approved status of activity is rejected
1807: -- by this status )
1808: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1809: itemkey => itemkey,
1810: aname => 'AMS_REJECT_STAT_ID',
1811: avalue => p_reject_stat_id );
1812:
1811: avalue => p_reject_stat_id );
1812:
1813:
1814: -- Object Version Number
1815: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1816: itemkey => itemkey,
1817: aname => 'AMS_OBJECT_VERSION_NUMBER',
1818: avalue => p_object_version_number );
1819:
1817: aname => 'AMS_OBJECT_VERSION_NUMBER',
1818: avalue => p_object_version_number );
1819:
1820: -- Notes from the requester
1821: Wf_Engine.SetItemAttrText(itemtype => itemtype,
1822: itemkey => itemkey,
1823: aname => 'AMS_NOTES_FROM_REQUESTER',
1824: avalue => NVL(p_notes_from_requester,'') );
1825:
1827: OPEN c_resource ;
1828: FETCH c_resource INTO l_requester_id ,l_person_id ;
1829: CLOSE c_resource ; */
1830:
1831: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1832: itemkey => itemkey,
1833: aname => 'AMS_REQUESTER_ID',
1834: avalue => p_requester_userid );
1835:
1847: RAISE Fnd_Api.G_EXC_ERROR;
1848: END IF;
1849:
1850: -- set description of activity
1851: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
1852: itemkey => itemkey,
1853: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1854: avalue => l_appr_meaning );
1855:
1852: itemkey => itemkey,
1853: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1854: avalue => l_appr_meaning );
1855:
1856: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
1857: itemkey => itemkey,
1858: aname => 'AMS_APPROVAL_TYPE',
1859: avalue => p_approval_type );
1860:
1868: RAISE Fnd_Api.G_EXC_ERROR;
1869: END IF;
1870:
1871:
1872: Wf_Engine.SetItemAttrText(itemtype => itemtype,
1873: itemkey => itemkey,
1874: aname => 'AMS_REQUESTER',
1875: avalue => l_requester_role );
1876:
1875: avalue => l_requester_role );
1876:
1877:
1878:
1879: Wf_Engine.SetItemOwner(itemtype => itemtype,
1880: itemkey => itemkey,
1881: owner => l_requester_role);
1882:
1883:
1881: owner => l_requester_role);
1882:
1883:
1884: -- Start the Process
1885: Wf_Engine.StartProcess (itemtype => itemtype,
1886: itemkey => itemkey);
1887:
1888:
1889: /* 11.5.9 Approval Details Enhancement */
1915: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1916: RAISE Fnd_Api.G_EXC_ERROR;
1917: END IF;
1918:
1919: -- wf_engine.threshold := l_save_threshold ;
1920:
1921: EXCEPTION
1922: WHEN Fnd_Api.G_EXC_ERROR THEN
1923: -- wf_engine.threshold := l_save_threshold ;
1919: -- wf_engine.threshold := l_save_threshold ;
1920:
1921: EXCEPTION
1922: WHEN Fnd_Api.G_EXC_ERROR THEN
1923: -- wf_engine.threshold := l_save_threshold ;
1924: Fnd_Msg_Pub.Count_And_Get (
1925: p_encoded => Fnd_Api.G_FALSE,
1926: p_count => l_msg_count,
1927: p_data => l_msg_data);
1935: Wf_Core.context ('Ams_Approval_Pvt', 'StartProcess',p_activity_type
1936: ,p_activity_id ,l_error_msg);
1937: RAISE;
1938: WHEN OTHERS THEN
1939: -- wf_engine.threshold := l_save_threshold ;
1940: Fnd_Msg_Pub.Count_And_Get (
1941: p_encoded => Fnd_Api.G_FALSE,
1942: p_count => l_msg_count,
1943: p_data => l_msg_data);
1996: BEGIN
1997: Fnd_Msg_Pub.initialize();
1998: IF (funcmode = 'RUN') THEN
1999: -- get the acitvity id
2000: l_activity_id := Wf_Engine.GetItemAttrNumber(
2001: itemtype => itemtype,
2002: itemkey => itemkey,
2003: aname => 'AMS_ACTIVITY_ID' );
2004:
2002: itemkey => itemkey,
2003: aname => 'AMS_ACTIVITY_ID' );
2004:
2005: -- get the activity type
2006: l_activity_type := Wf_Engine.GetItemAttrText(
2007: itemtype => itemtype,
2008: itemkey => itemkey,
2009: aname => 'AMS_ACTIVITY_TYPE' );
2010:
2007: itemtype => itemtype,
2008: itemkey => itemkey,
2009: aname => 'AMS_ACTIVITY_TYPE' );
2010:
2011: l_approval_type := Wf_Engine.GetItemAttrText(
2012: itemtype => itemtype,
2013: itemkey => itemkey,
2014: aname => 'AMS_APPROVAL_TYPE' );
2015:
2047: */
2048: l_dtail_url := 'JSP:/OA_HTML/OA.jsp?OAFunc='||l_func_name||'&'||'objId='||l_activity_id;
2049: l_dtail_url := l_dtail_url||'&'||'addBreadCrumb=Y';
2050:
2051: wf_engine.SetItemAttrText( itemtype => itemtype,
2052: itemkey => itemkey,
2053: aname => 'AMS_ACTIVITY_URL',
2054: avalue => l_dtail_url );
2055:
2054: avalue => l_dtail_url );
2055:
2056: END IF;
2057:
2058: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2059: itemkey => itemkey,
2060: aname => 'AMS_ACT_NAME',
2061: avalue => l_dtail_url);
2062:
2059: itemkey => itemkey,
2060: aname => 'AMS_ACT_NAME',
2061: avalue => l_dtail_url);
2062:
2063: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2064: itemkey => itemkey,
2065: aname => 'AMS_ACT_NAME',
2066: avalue => l_object_details.name);
2067:
2064: itemkey => itemkey,
2065: aname => 'AMS_ACT_NAME',
2066: avalue => l_object_details.name);
2067:
2068: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2069: itemkey => itemkey,
2070: aname => 'AMS_ACTIVITY_DETAIL_ID',
2071: avalue => l_approval_detail_id);
2072: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2068: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2069: itemkey => itemkey,
2070: aname => 'AMS_ACTIVITY_DETAIL_ID',
2071: avalue => l_approval_detail_id);
2072: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2073: itemkey => itemkey,
2074: aname => 'AMS_START_DATE',
2075: avalue => l_object_details.start_date);
2076: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2072: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2073: itemkey => itemkey,
2074: aname => 'AMS_START_DATE',
2075: avalue => l_object_details.start_date);
2076: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2077: itemkey => itemkey,
2078: aname => 'AMS_END_DATE',
2079: avalue => l_object_details.end_date);
2080: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2076: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
2077: itemkey => itemkey,
2078: aname => 'AMS_END_DATE',
2079: avalue => l_object_details.end_date);
2080: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2081: itemkey => itemkey,
2082: aname => 'AMS_ACTIVITY_DESCRIPTION',
2083: avalue => l_object_details.description);
2084: -- Changed Priority code to meaning
2081: itemkey => itemkey,
2082: aname => 'AMS_ACTIVITY_DESCRIPTION',
2083: avalue => l_object_details.description);
2084: -- Changed Priority code to meaning
2085: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2086: itemkey => itemkey,
2087: aname => 'AMS_PRIORITY',
2088: avalue => l_object_details.priority_desc);
2089: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2085: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2086: itemkey => itemkey,
2087: aname => 'AMS_PRIORITY',
2088: avalue => l_object_details.priority_desc);
2089: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2090: itemkey => itemkey,
2091: aname => 'AMS_ACTIVITY_CURRENCY',
2092: avalue => l_object_details.currency);
2093: --
2090: itemkey => itemkey,
2091: aname => 'AMS_ACTIVITY_CURRENCY',
2092: avalue => l_object_details.currency);
2093: --
2094: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2095: itemkey => itemkey,
2096: aname => 'AMS_APPROVER_SEQ',
2097: avalue => l_approver_seq);
2098: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2094: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2095: itemkey => itemkey,
2096: aname => 'AMS_APPROVER_SEQ',
2097: avalue => l_approver_seq);
2098: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2099: itemkey => itemkey,
2100: aname => 'AMS_ACTIVITY_AMOUNT',
2101: avalue =>
2102: l_object_details.total_header_amount);
2101: avalue =>
2102: l_object_details.total_header_amount);
2103: --insert into ams.test_murali (text) values ('source_code ' || l_object_details.source_code);
2104: -- Fix for Bug 2031309. AMS_CURRENCY was being set to source_code
2105: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2106: itemkey => itemkey,
2107: aname => 'AMS_CURRENCY',
2108: avalue => l_object_details.currency);
2109:
2106: itemkey => itemkey,
2107: aname => 'AMS_CURRENCY',
2108: avalue => l_object_details.currency);
2109:
2110: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2111: itemkey => itemkey,
2112: aname => 'AMS_SOURCE_CODE',
2113: avalue => l_object_details.source_code);
2114:
2111: itemkey => itemkey,
2112: aname => 'AMS_SOURCE_CODE',
2113: avalue => l_object_details.source_code);
2114:
2115: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2116: itemkey => itemkey,
2117: aname => 'AMS_PARENT_SOURCE_CODE',
2118: avalue => l_object_details.parent_source_code);
2119:
2116: itemkey => itemkey,
2117: aname => 'AMS_PARENT_SOURCE_CODE',
2118: avalue => l_object_details.parent_source_code);
2119:
2120: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2121: itemkey => itemkey,
2122: aname => 'AMS_PARENT_OBJECT',
2123: avalue => l_object_details.parent_name);
2124:
2146: resultout := 'COMPLETE:ERROR';
2147: RETURN;
2148: END IF;
2149:
2150: Wf_Engine.SetItemAttrText(itemtype => itemtype,
2151: itemkey => itemkey,
2152: aname => 'AMS_ACTIVITY_OWNER',
2153: avalue => l_full_name );
2154:
2265: -- RUN mode
2266: --
2267: IF (funcmode = 'RUN') THEN
2268: -- get the acitvity id
2269: l_activity_id := Wf_Engine.GetItemAttrNumber(
2270: itemtype => itemtype,
2271: itemkey => itemkey,
2272: aname => 'AMS_ACTIVITY_ID' );
2273:
2271: itemkey => itemkey,
2272: aname => 'AMS_ACTIVITY_ID' );
2273:
2274: -- get the activity type
2275: l_activity_type := Wf_Engine.GetItemAttrText(
2276: itemtype => itemtype,
2277: itemkey => itemkey,
2278: aname => 'AMS_ACTIVITY_TYPE' );
2279:
2404: l_approved_flag VARCHAR2(1);
2405: l_msg_count NUMBER;
2406: l_msg_data VARCHAR2(4000);
2407: l_error_msg VARCHAR2(4000);
2408: l_save_threshold NUMBER := Wf_Engine.threshold;
2409: BEGIN
2410: Fnd_Msg_Pub.initialize();
2411: IF (funcmode = 'RUN') THEN
2412: Wf_Engine.threshold := -1;
2408: l_save_threshold NUMBER := Wf_Engine.threshold;
2409: BEGIN
2410: Fnd_Msg_Pub.initialize();
2411: IF (funcmode = 'RUN') THEN
2412: Wf_Engine.threshold := -1;
2413: -- get the acitvity id
2414: l_activity_id := Wf_Engine.GetItemAttrNumber(
2415: itemtype => itemtype,
2416: itemkey => itemkey,
2410: Fnd_Msg_Pub.initialize();
2411: IF (funcmode = 'RUN') THEN
2412: Wf_Engine.threshold := -1;
2413: -- get the acitvity id
2414: l_activity_id := Wf_Engine.GetItemAttrNumber(
2415: itemtype => itemtype,
2416: itemkey => itemkey,
2417: aname => 'AMS_ACTIVITY_ID' );
2418:
2416: itemkey => itemkey,
2417: aname => 'AMS_ACTIVITY_ID' );
2418:
2419: -- get the activity type
2420: l_activity_type := Wf_Engine.GetItemAttrText(
2421: itemtype => itemtype,
2422: itemkey => itemkey,
2423: aname => 'AMS_ACTIVITY_TYPE' );
2424:
2421: itemtype => itemtype,
2422: itemkey => itemkey,
2423: aname => 'AMS_ACTIVITY_TYPE' );
2424:
2425: l_activity_amount := Wf_Engine.GetItemAttrNumber(
2426: itemtype => itemtype,
2427: itemkey => itemkey,
2428: aname => 'AMS_ACTIVITY_AMOUNT' );
2429:
2449: x_error_msg => l_error_msg
2450: ) ;
2451: resultout := 'COMPLETE:FAILURE';
2452: END IF;
2453: Wf_Engine.threshold := l_save_threshold ;
2454:
2455: END IF;
2456:
2457: --
2582: AND TRUNC(NVL(end_date_active,SYSDATE + 1));
2583: BEGIN
2584: Fnd_Msg_Pub.initialize();
2585: IF (funcmode = 'RUN') THEN
2586: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
2587: itemtype => itemtype,
2588: itemkey => itemkey,
2589: aname => 'AMS_ACTIVITY_DETAIL_ID' );
2590:
2587: itemtype => itemtype,
2588: itemkey => itemkey,
2589: aname => 'AMS_ACTIVITY_DETAIL_ID' );
2590:
2591: l_current_seq := Wf_Engine.GetItemAttrText(
2592: itemtype => itemtype,
2593: itemkey => itemkey,
2594: aname => 'AMS_APPROVER_SEQ' );
2595: -- 11.5.9
2593: itemkey => itemkey,
2594: aname => 'AMS_APPROVER_SEQ' );
2595: -- 11.5.9
2596:
2597: l_activity_id := Wf_Engine.GetItemAttrNumber(
2598: itemtype => itemtype,
2599: itemkey => itemkey,
2600: aname => 'AMS_ACTIVITY_ID' );
2601:
2598: itemtype => itemtype,
2599: itemkey => itemkey,
2600: aname => 'AMS_ACTIVITY_ID' );
2601:
2602: l_activity_type := Wf_Engine.GetItemAttrText(
2603: itemtype => itemtype,
2604: itemkey => itemkey,
2605: aname => 'AMS_ACTIVITY_TYPE' );
2606:
2603: itemtype => itemtype,
2604: itemkey => itemkey,
2605: aname => 'AMS_ACTIVITY_TYPE' );
2606:
2607: l_version := Wf_Engine.GetItemAttrNumber(
2608: itemtype => itemtype,
2609: itemkey => itemkey,
2610: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2611:
2608: itemtype => itemtype,
2609: itemkey => itemkey,
2610: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2611:
2612: l_approval_type := Wf_Engine.GetItemAttrText(
2613: itemtype => itemtype,
2614: itemkey => itemkey,
2615: aname => 'AMS_APPROVAL_TYPE' );
2616:
2724: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2725: RAISE Fnd_Api.G_EXC_ERROR;
2726: END IF;
2727:
2728: l_prev_approver := Wf_Engine.GetItemAttrText(
2729: itemtype => itemtype,
2730: itemkey => itemkey,
2731: aname => 'AMS_APPR_USERNAME' );
2732:
2730: itemkey => itemkey,
2731: aname => 'AMS_APPR_USERNAME' );
2732:
2733: /*
2734: wf_engine.SetItemAttrText( itemtype => itemtype,
2735: itemkey => itemkey,
2736: aname => 'AMS_PREV_APPR_USERNAME',
2737: avalue => l_prev_approver); */
2738:
2735: itemkey => itemkey,
2736: aname => 'AMS_PREV_APPR_USERNAME',
2737: avalue => l_prev_approver); */
2738:
2739: Wf_Engine.SetItemAttrText( itemtype => itemtype,
2740: itemkey => itemkey,
2741: aname => 'AMS_APPR_USERNAME',
2742: avalue => l_approver);
2743:
2740: itemkey => itemkey,
2741: aname => 'AMS_APPR_USERNAME',
2742: avalue => l_approver);
2743:
2744: Wf_Engine.SetItemAttrText( itemtype => itemtype,
2745: itemkey => itemkey,
2746: aname => 'AMS_APPR_DISPLAY_NAME',
2747: avalue => l_approver_display_name);
2748:
2745: itemkey => itemkey,
2746: aname => 'AMS_APPR_DISPLAY_NAME',
2747: avalue => l_approver_display_name);
2748:
2749: l_prev_role_name := Wf_Engine.GetItemAttrText(
2750: itemtype => itemtype,
2751: itemkey => itemkey,
2752: aname => 'AMS_APPROVAL_ROLE' );
2753:
2750: itemtype => itemtype,
2751: itemkey => itemkey,
2752: aname => 'AMS_APPROVAL_ROLE' );
2753:
2754: Wf_Engine.SetItemAttrText( itemtype => itemtype,
2755: itemkey => itemkey,
2756: aname => 'AMS_APPROVAL_ROLE',
2757: avalue => l_role_name);
2758:
2756: aname => 'AMS_APPROVAL_ROLE',
2757: avalue => l_role_name);
2758:
2759: /*
2760: wf_engine.SetItemAttrText( itemtype => itemtype,
2761: itemkey => itemkey,
2762: aname => 'AMS_PREV_APPROVER_ROLE',
2763: avalue => l_prev_role_name);
2764: */
2762: aname => 'AMS_PREV_APPROVER_ROLE',
2763: avalue => l_prev_role_name);
2764: */
2765:
2766: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2767: itemkey => itemkey,
2768: aname => 'AMS_APPROVER_ID',
2769: avalue => l_object_approver_id);
2770:
2768: aname => 'AMS_APPROVER_ID',
2769: avalue => l_object_approver_id);
2770:
2771:
2772: Wf_Engine.SetItemAttrText( itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'AMS_NOTIFICATION_TYPE',
2775: avalue => l_notification_type);
2776:
2773: itemkey => itemkey,
2774: aname => 'AMS_NOTIFICATION_TYPE',
2775: avalue => l_notification_type);
2776:
2777: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
2778: itemkey => itemkey,
2779: aname => 'AMS_NOTIFICATION_TIMEOUT',
2780: avalue => l_notification_timeout);
2781:
2899: l_new_approver_id NUMBER;
2900: BEGIN
2901: Fnd_Msg_Pub.initialize();
2902: IF (funcmode = 'RUN') THEN
2903: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
2904: itemtype => itemtype,
2905: itemkey => itemkey,
2906: aname => 'AMS_ACTIVITY_DETAIL_ID' );
2907:
2904: itemtype => itemtype,
2905: itemkey => itemkey,
2906: aname => 'AMS_ACTIVITY_DETAIL_ID' );
2907:
2908: l_current_seq := Wf_Engine.GetItemAttrText(
2909: itemtype => itemtype,
2910: itemkey => itemkey,
2911: aname => 'AMS_APPROVER_SEQ' );
2912: -- get the activity note
2909: itemtype => itemtype,
2910: itemkey => itemkey,
2911: aname => 'AMS_APPROVER_SEQ' );
2912: -- get the activity note
2913: l_note := Wf_Engine.GetItemAttrText(
2914: itemtype => itemtype,
2915: itemkey => itemkey,
2916: aname => 'AMS_NOTE' );
2917:
2914: itemtype => itemtype,
2915: itemkey => itemkey,
2916: aname => 'AMS_NOTE' );
2917:
2918: l_approver_id := Wf_Engine.GetItemAttrNumber(
2919: itemtype => itemtype,
2920: itemkey => itemkey,
2921: aname => 'AMS_APPROVER_ID' );
2922:
2919: itemtype => itemtype,
2920: itemkey => itemkey,
2921: aname => 'AMS_APPROVER_ID' );
2922:
2923: l_activity_id := Wf_Engine.GetItemAttrNumber(
2924: itemtype => itemtype,
2925: itemkey => itemkey,
2926: aname => 'AMS_ACTIVITY_ID' );
2927:
2924: itemtype => itemtype,
2925: itemkey => itemkey,
2926: aname => 'AMS_ACTIVITY_ID' );
2927:
2928: l_activity_type := Wf_Engine.GetItemAttrText(
2929: itemtype => itemtype,
2930: itemkey => itemkey,
2931: aname => 'AMS_ACTIVITY_TYPE' );
2932:
2944: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2945: RAISE Fnd_Api.G_EXC_ERROR;
2946: END IF;
2947: -- Added for 11.5.9
2948: l_version := Wf_Engine.GetItemAttrNumber(
2949: itemtype => itemtype,
2950: itemkey => itemkey,
2951: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2952:
2949: itemtype => itemtype,
2950: itemkey => itemkey,
2951: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2952:
2953: l_approval_type := Wf_Engine.GetItemAttrText(
2954: itemtype => itemtype,
2955: itemkey => itemkey,
2956: aname => 'AMS_APPROVAL_TYPE' );
2957: -- Commented for Bug 3150550
3009:
3010: END IF;
3011:
3012: -- get all the activity notes
3013: l_all_note := Wf_Engine.GetItemAttrText(
3014: itemtype => itemtype,
3015: itemkey => itemkey,
3016: aname => 'AMS_ALL_NOTE' );
3017:
3019: -- issue : cannot distinguish from notes created by activities or budget lines
3020: -- option : can insert a carriage return when concatenating notes
3021: l_all_note := l_all_note ||l_note;
3022:
3023: Wf_Engine.SetItemAttrText(
3024: itemtype => itemtype,
3025: itemkey => itemkey,
3026: aname => 'AMS_ALL_NOTE' ,
3027: avalue => l_all_note ) ;
3027: avalue => l_all_note ) ;
3028:
3029: -- set the note to null
3030: l_note := NULL;
3031: Wf_Engine.SetItemAttrText(
3032: itemtype => itemtype,
3033: itemkey => itemkey,
3034: aname => 'AMS_NOTE' ,
3035: avalue => l_note ) ;
3040: x_next_seq => l_next_seq,
3041: x_required_flag => l_required_flag);
3042:
3043: IF l_next_seq IS NOT NULL THEN
3044: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
3045: itemkey => itemkey,
3046: aname => 'AMS_APPROVER_SEQ',
3047: avalue => l_next_seq);
3048: resultout := 'COMPLETE:Y';
3134: -- RUN mode
3135: --
3136: IF (funcmode = 'RUN') THEN
3137: -- get the acitvity id
3138: l_activity_id := Wf_Engine.GetItemAttrNumber(
3139: itemtype => itemtype,
3140: itemkey => itemkey,
3141: aname => 'AMS_ACTIVITY_ID' );
3142:
3140: itemkey => itemkey,
3141: aname => 'AMS_ACTIVITY_ID' );
3142:
3143: -- get the activity type
3144: l_activity_type := Wf_Engine.GetItemAttrText(
3145: itemtype => itemtype,
3146: itemkey => itemkey,
3147: aname => 'AMS_ACTIVITY_TYPE' );
3148:
3145: itemtype => itemtype,
3146: itemkey => itemkey,
3147: aname => 'AMS_ACTIVITY_TYPE' );
3148:
3149: l_orig_status_id := Wf_Engine.GetItemAttrNumber(
3150: itemtype => itemtype,
3151: itemkey => itemkey,
3152: aname => 'AMS_ORIG_STAT_ID' );
3153:
3152: aname => 'AMS_ORIG_STAT_ID' );
3153:
3154:
3155: -- 11.5.9 addition
3156: l_version := Wf_Engine.GetItemAttrNumber(
3157: itemtype => itemtype,
3158: itemkey => itemkey,
3159: aname => 'AMS_OBJECT_VERSION_NUMBER' );
3160:
3157: itemtype => itemtype,
3158: itemkey => itemkey,
3159: aname => 'AMS_OBJECT_VERSION_NUMBER' );
3160:
3161: l_approval_type := Wf_Engine.GetItemAttrText(
3162: itemtype => itemtype,
3163: itemkey => itemkey,
3164: aname => 'AMS_APPROVAL_TYPE' );
3165:
3283: --
3284: IF (funcmode = 'RUN') THEN
3285: -- get the acitvity id
3286:
3287: l_activity_id := Wf_Engine.GetItemAttrNumber(
3288: itemtype => itemtype,
3289: itemkey => itemkey,
3290: aname => 'AMS_ACTIVITY_ID' );
3291:
3289: itemkey => itemkey,
3290: aname => 'AMS_ACTIVITY_ID' );
3291:
3292: -- get the activity type
3293: l_activity_type := Wf_Engine.GetItemAttrText(
3294: itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'AMS_ACTIVITY_TYPE' );
3297:
3294: itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'AMS_ACTIVITY_TYPE' );
3297:
3298: l_orig_status_id := Wf_Engine.GetItemAttrNumber(
3299: itemtype => itemtype,
3300: itemkey => itemkey,
3301: aname => 'AMS_NEW_STAT_ID' );
3302:
3303:
3304: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_activity_type : '|| l_activity_type);
3305:
3306: IF (l_activity_type = 'OFFR') THEN
3307: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
3308: , itemkey => itemkey
3309: , aname => 'USER_ID'
3310: );
3311:
3308: , itemkey => itemkey
3309: , aname => 'USER_ID'
3310: );
3311:
3312: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
3313: , itemkey => itemkey
3314: , aname => 'RESPONSIBILITY_ID'
3315: );
3316:
3313: , itemkey => itemkey
3314: , aname => 'RESPONSIBILITY_ID'
3315: );
3316:
3317: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
3318: , itemkey => itemkey
3319: , aname => 'APPLICATION_ID'
3320: );
3321:
3448: -- RUN mode
3449: --
3450: IF (funcmode = 'RUN') THEN
3451: -- get the acitvity id
3452: l_activity_id := Wf_Engine.GetItemAttrNumber(
3453: itemtype => itemtype,
3454: itemkey => itemkey,
3455: aname => 'AMS_ACTIVITY_ID' );
3456:
3454: itemkey => itemkey,
3455: aname => 'AMS_ACTIVITY_ID' );
3456:
3457: -- get the activity type
3458: l_activity_type := Wf_Engine.GetItemAttrText(
3459: itemtype => itemtype,
3460: itemkey => itemkey,
3461: aname => 'AMS_ACTIVITY_TYPE' );
3462:
3459: itemtype => itemtype,
3460: itemkey => itemkey,
3461: aname => 'AMS_ACTIVITY_TYPE' );
3462:
3463: l_orig_status_id := Wf_Engine.GetItemAttrNumber(
3464: itemtype => itemtype,
3465: itemkey => itemkey,
3466: aname => 'AMS_REJECT_STAT_ID' );
3467:
3465: itemkey => itemkey,
3466: aname => 'AMS_REJECT_STAT_ID' );
3467:
3468: -- Added by VM for 11.5.9
3469: l_approver_seq := Wf_Engine.GetItemAttrNumber(
3470: itemtype => itemtype,
3471: itemkey => itemkey,
3472: aname => 'AMS_APPROVER_SEQ' );
3473: l_version := Wf_Engine.GetItemAttrNumber(
3469: l_approver_seq := Wf_Engine.GetItemAttrNumber(
3470: itemtype => itemtype,
3471: itemkey => itemkey,
3472: aname => 'AMS_APPROVER_SEQ' );
3473: l_version := Wf_Engine.GetItemAttrNumber(
3474: itemtype => itemtype,
3475: itemkey => itemkey,
3476: aname => 'AMS_OBJECT_VERSION_NUMBER' );
3477:
3474: itemtype => itemtype,
3475: itemkey => itemkey,
3476: aname => 'AMS_OBJECT_VERSION_NUMBER' );
3477:
3478: l_approver_id := Wf_Engine.GetItemAttrNumber(
3479: itemtype => itemtype,
3480: itemkey => itemkey,
3481: aname => 'AMS_APPROVER_ID' );
3482:
3479: itemtype => itemtype,
3480: itemkey => itemkey,
3481: aname => 'AMS_APPROVER_ID' );
3482:
3483: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
3484: itemtype => itemtype,
3485: itemkey => itemkey,
3486: aname => 'AMS_ACTIVITY_DETAIL_ID' );
3487:
3484: itemtype => itemtype,
3485: itemkey => itemkey,
3486: aname => 'AMS_ACTIVITY_DETAIL_ID' );
3487:
3488: l_approval_type := Wf_Engine.GetItemAttrText(
3489: itemtype => itemtype,
3490: itemkey => itemkey,
3491: aname => 'AMS_APPROVAL_TYPE' );
3492: -- End 11.5.9
3650: itemkey VARCHAR2(30) := p_itemkey ;
3651: itemtype VARCHAR2(30) := NVL(p_itemtype,'AMS_APPROVAL') ;
3652: BEGIN
3653: Ams_Utility_Pvt.debug_message('Process ABORT Process');
3654: Wf_Engine.AbortProcess (itemtype => itemtype,
3655: itemkey => itemkey ,
3656: process => p_workflowprocess);
3657: EXCEPTION
3658: WHEN OTHERS THEN
3940: END IF;
3941:
3942: -- create a new process
3943: --
3944: Wf_Engine.CreateProcess(ItemType => l_itemtype,
3945: ItemKey => l_itemkey,
3946: process => l_process );
3947:
3948: -- set the user key for process
3946: process => l_process );
3947:
3948: -- set the user key for process
3949: --
3950: Wf_Engine.SetItemUserKey(ItemType => l_itemtype,
3951: ItemKey => l_itemkey,
3952: UserKey => l_itemuserkey);
3953:
3954: -- 09-Jan-2003 VMODUR Fix for BUG 2741039 - add pl/sql global context into
3964: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_user_id : '|| l_user_id);
3965: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_resp_id : '|| l_resp_id);
3966: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_appl_id : '|| l_appl_id);
3967:
3968: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3969: itemkey => l_itemkey,
3970: aname => 'USER_ID',
3971: avalue => l_user_id
3972: );
3970: aname => 'USER_ID',
3971: avalue => l_user_id
3972: );
3973:
3974: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3975: itemkey => l_itemkey,
3976: aname => 'RESPONSIBILITY_ID',
3977: avalue => l_resp_id
3978: );
3976: aname => 'RESPONSIBILITY_ID',
3977: avalue => l_resp_id
3978: );
3979:
3980: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3981: itemkey => l_itemkey,
3982: aname => 'APPLICATION_ID',
3983: avalue => l_appl_id
3984: );
3982: aname => 'APPLICATION_ID',
3983: avalue => l_appl_id
3984: );
3985:
3986: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3987: itemkey => l_itemkey,
3988: aname => 'SECURITY_GROUP_ID',
3989: avalue => l_security_group_id
3990: );
3993: -- set the parent item
3994: --
3995: IF p_parent_process_flag = Fnd_Api.G_TRUE THEN
3996: -- set parent
3997: Wf_Engine.SetItemParent(itemtype =>l_itemtype,
3998: itemkey => l_itemkey,
3999: parent_itemtype => l_itemtype,
4000: parent_itemkey => p_parent_process_key,
4001: parent_context => p_parent_context );
4000: parent_itemkey => p_parent_process_key,
4001: parent_context => p_parent_context );
4002:
4003: -- get parent amount
4004: l_parent_amount := Wf_Engine.GetItemAttrNumber(
4005: itemtype => l_itemtype,
4006: itemkey => p_parent_process_key,
4007: aname => 'AMS_ACTIVITY_AMOUNT' );
4008:
4006: itemkey => p_parent_process_key,
4007: aname => 'AMS_ACTIVITY_AMOUNT' );
4008:
4009: --
4010: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4011: itemkey => l_itemkey,
4012: aname => 'AMS_ACTIVITY_AMOUNT',
4013: avalue => l_parent_amount);
4014:
4017: OPEN justification_text_csr(p_act_budget_id);
4018: FETCH justification_text_csr INTO l_justification_text;
4019: CLOSE justification_text_csr;
4020:
4021: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4022: itemkey => l_itemkey,
4023: aname => 'AMS_JUSTIFICATION',
4024: avalue => l_justification_text);
4025:
4030: x_return_status => l_return_status);
4031: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4032: RAISE Fnd_Api.G_EXC_ERROR;
4033: END IF;
4034: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4035: itemkey => l_itemkey,
4036: aname => 'AMS_ACT_NAME',
4037: avalue => l_parent_object_details.name);
4038:
4035: itemkey => l_itemkey,
4036: aname => 'AMS_ACT_NAME',
4037: avalue => l_parent_object_details.name);
4038:
4039: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4040: itemkey => l_itemkey,
4041: aname => 'AMS_START_DATE',
4042: avalue => l_parent_object_details.start_date);
4043:
4041: aname => 'AMS_START_DATE',
4042: avalue => l_parent_object_details.start_date);
4043:
4044:
4045: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4046: itemkey => l_itemkey,
4047: aname => 'AMS_END_DATE',
4048: avalue => l_parent_object_details.end_date);
4049: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4045: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4046: itemkey => l_itemkey,
4047: aname => 'AMS_END_DATE',
4048: avalue => l_parent_object_details.end_date);
4049: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4050: itemkey => l_itemkey,
4051: aname => 'AMS_ACTIVITY_DESCRIPTION',
4052: avalue => l_parent_object_details.description);
4053: -- Changed Priority code to meaning
4050: itemkey => l_itemkey,
4051: aname => 'AMS_ACTIVITY_DESCRIPTION',
4052: avalue => l_parent_object_details.description);
4053: -- Changed Priority code to meaning
4054: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4055: itemkey =>l_itemkey,
4056: aname => 'AMS_PRIORITY',
4057: avalue => l_parent_object_details.priority_desc);
4058: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4054: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4055: itemkey =>l_itemkey,
4056: aname => 'AMS_PRIORITY',
4057: avalue => l_parent_object_details.priority_desc);
4058: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4059: itemkey => l_itemkey,
4060: aname => 'AMS_ACTIVITY_CURRENCY',
4061: avalue => l_parent_object_details.currency);
4062: --
4060: aname => 'AMS_ACTIVITY_CURRENCY',
4061: avalue => l_parent_object_details.currency);
4062: --
4063: --
4064: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4065: itemkey => l_itemkey,
4066: aname => 'AMS_ACTIVITY_AMOUNT',
4067: avalue =>
4068: l_parent_object_details.total_header_amount);
4066: aname => 'AMS_ACTIVITY_AMOUNT',
4067: avalue =>
4068: l_parent_object_details.total_header_amount);
4069: --Version Number Added for 11.5.9
4070: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4071: itemkey => l_itemkey,
4072: aname => 'AMS_OBJECT_VERSION_NUMBER',
4073: avalue => l_version);
4074: -- End add of addition
4071: itemkey => l_itemkey,
4072: aname => 'AMS_OBJECT_VERSION_NUMBER',
4073: avalue => l_version);
4074: -- End add of addition
4075: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4076: itemkey => l_itemkey,
4077: aname => 'AMS_SOURCE_CODE',
4078: avalue => l_parent_object_details.source_code);
4079:
4076: itemkey => l_itemkey,
4077: aname => 'AMS_SOURCE_CODE',
4078: avalue => l_parent_object_details.source_code);
4079:
4080: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4081: itemkey => l_itemkey,
4082: aname => 'AMS_PARENT_SOURCE_CODE',
4083: avalue => l_parent_object_details.parent_source_code);
4084:
4081: itemkey => l_itemkey,
4082: aname => 'AMS_PARENT_SOURCE_CODE',
4083: avalue => l_parent_object_details.parent_source_code);
4084:
4085: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4086: itemkey => l_itemkey,
4087: aname => 'AMS_PARENT_OBJECT',
4088: avalue => l_parent_object_details.parent_name);
4089:
4092: l_return_status,
4093: l_appr_meaning);
4094:
4095: -- check for description of activity
4096: Wf_Engine.SetItemAttrText(itemtype => l_itemtype ,
4097: itemkey => l_itemkey,
4098: aname => 'AMS_APPROVAL_OBJECT_MEANING',
4099: avalue => l_appr_meaning );
4100: Get_User_Name
4101: ( p_user_id => l_parent_object_details.owner_id,
4102: x_full_name => l_full_name,
4103: x_return_status => l_return_status );
4104:
4105: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4106: itemkey => l_itemkey,
4107: aname => 'AMS_ACTIVITY_OWNER',
4108: avalue => l_full_name );
4109:
4108: avalue => l_full_name );
4109:
4110: IF p_parent_approval_flag = Fnd_Api.G_TRUE THEN
4111: --
4112: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4113: itemkey => l_itemkey,
4114: aname => 'AMS_CONTINUEFLOW',
4115: avalue => 'CONTINUEFLOW-1');
4116: END IF;
4116: END IF;
4117:
4118: -- set othet attributes required for lines approval
4119: --
4120: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4121: itemkey => l_itemkey,
4122: aname => 'AMS_ACT_BUDGET_ID',
4123: avalue => p_act_budget_id);
4124: --
4121: itemkey => l_itemkey,
4122: aname => 'AMS_ACT_BUDGET_ID',
4123: avalue => p_act_budget_id);
4124: --
4125: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4126: itemkey => l_itemkey,
4127: aname => 'AMS_LINE_ORIG_STAT_ID',
4128: avalue => p_orig_stat_id);
4129: --
4126: itemkey => l_itemkey,
4127: aname => 'AMS_LINE_ORIG_STAT_ID',
4128: avalue => p_orig_stat_id);
4129: --
4130: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4131: itemkey => l_itemkey,
4132: aname => 'AMS_LINE_NEW_STAT_ID',
4133: avalue => p_new_stat_id);
4134: --
4131: itemkey => l_itemkey,
4132: aname => 'AMS_LINE_NEW_STAT_ID',
4133: avalue => p_new_stat_id);
4134: --
4135: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4136: itemkey => l_itemkey,
4137: aname => 'AMS_LINE_REJECT_STAT_ID',
4138: avalue => p_rejected_stat_id);
4139: --
4136: itemkey => l_itemkey,
4137: aname => 'AMS_LINE_REJECT_STAT_ID',
4138: avalue => p_rejected_stat_id);
4139: --
4140: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4141: itemkey => l_itemkey,
4142: aname => 'AMS_ACTIVITY_ID',
4143: avalue => l_activity_id);
4144: --
4141: itemkey => l_itemkey,
4142: aname => 'AMS_ACTIVITY_ID',
4143: avalue => l_activity_id);
4144: --
4145: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4146: itemkey => l_itemkey,
4147: aname => 'AMS_ACTIVITY_TYPE',
4148: avalue => l_activity_type);
4149: --
4146: itemkey => l_itemkey,
4147: aname => 'AMS_ACTIVITY_TYPE',
4148: avalue => l_activity_type);
4149: --
4150: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4151: itemkey => l_itemkey,
4152: aname => 'AMS_BUDGET_ID',
4153: avalue => l_budget_id);
4154: --
4151: itemkey => l_itemkey,
4152: aname => 'AMS_BUDGET_ID',
4153: avalue => l_budget_id);
4154: --
4155: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4156: itemkey => l_itemkey,
4157: aname => 'AMS_BUDGET_TYPE',
4158: avalue => l_budget_type);
4159: --
4156: itemkey => l_itemkey,
4157: aname => 'AMS_BUDGET_TYPE',
4158: avalue => l_budget_type);
4159: --
4160: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4161: itemkey => l_itemkey,
4162: aname => 'AMS_PARENT_WAITING',
4163: avalue => p_parent_process_flag);
4164: --
4161: itemkey => l_itemkey,
4162: aname => 'AMS_PARENT_WAITING',
4163: avalue => p_parent_process_flag);
4164: --
4165: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4166: itemkey => l_itemkey,
4167: aname => 'AMS_PARENT_ITEMKEY',
4168: avalue => p_parent_process_key);
4169: --
4166: itemkey => l_itemkey,
4167: aname => 'AMS_PARENT_ITEMKEY',
4168: avalue => p_parent_process_key);
4169: --
4170: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4171: itemkey => l_itemkey,
4172: aname => 'AMS_PARENT_APPROVED',
4173: avalue => p_parent_approval_flag);
4174:
4172: aname => 'AMS_PARENT_APPROVED',
4173: avalue => p_parent_approval_flag);
4174:
4175: --
4176: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4177: itemkey => l_itemkey,
4178: aname => 'AMS_CONTINUE_FLOW',
4179: avalue => p_continue_flow);
4180:
4187: RAISE Fnd_Api.G_EXC_ERROR;
4188: END IF;
4189:
4190: --
4191: Wf_Engine.SetItemAttrNumber( itemtype => l_itemtype,
4192: itemkey => l_itemkey,
4193: aname => 'AMS_REQUESTER_ID',
4194: avalue => p_requestor_id);
4195:
4193: aname => 'AMS_REQUESTER_ID',
4194: avalue => p_requestor_id);
4195:
4196: --
4197: Wf_Engine.SetItemAttrText( itemtype => l_itemtype,
4198: itemkey => l_itemkey,
4199: aname => 'AMS_REQUESTER',
4200: avalue => l_requestor_name);
4201:
4244: END IF;
4245:
4246: --
4247: /*
4248: wf_engine.SetItemAttrText(itemtype => l_itemtype,
4249: itemkey => l_itemkey,
4250: aname => 'AMS_ACT_NAME',
4251: avalue => l_approver_obj.name);
4252: */
4250: aname => 'AMS_ACT_NAME',
4251: avalue => l_approver_obj.name);
4252: */
4253:
4254: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4255: itemkey => l_itemkey,
4256: aname => 'AMS_BUDGET_NAME',
4257: avalue => l_object_details.name);
4258:
4260: ( p_user_id => l_object_details.owner_id,
4261: x_full_name => l_full_name,
4262: x_return_status => l_return_status );
4263:
4264: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4265: itemkey => l_itemkey,
4266: aname => 'AMS_BUDGET_OWNER',
4267: avalue => l_full_name );
4268:
4265: itemkey => l_itemkey,
4266: aname => 'AMS_BUDGET_OWNER',
4267: avalue => l_full_name );
4268:
4269: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4270: itemkey => l_itemkey,
4271: aname => 'AMS_BUDGET_CURRENCY',
4272: avalue => l_budget_currency);
4273:
4270: itemkey => l_itemkey,
4271: aname => 'AMS_BUDGET_CURRENCY',
4272: avalue => l_budget_currency);
4273:
4274: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4275: itemkey => l_itemkey,
4276: aname => 'AMS_BUDGET_AMOUNT',
4277: avalue => l_request_amount);
4278: --
4275: itemkey => l_itemkey,
4276: aname => 'AMS_BUDGET_AMOUNT',
4277: avalue => l_request_amount);
4278: --
4279: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4280: itemkey => l_itemkey,
4281: aname => 'AMS_BUDGET_AMOUNT_CONV',
4282: avalue => l_budget_amount);
4283:
4281: aname => 'AMS_BUDGET_AMOUNT_CONV',
4282: avalue => l_budget_amount);
4283:
4284: --
4285: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4286: itemkey => l_itemkey,
4287: aname => 'AMS_APPROVED_LINE_AMOUNT',
4288: avalue => l_budget_amount);
4289:
4287: aname => 'AMS_APPROVED_LINE_AMOUNT',
4288: avalue => l_budget_amount);
4289:
4290: --
4291: Wf_Engine.SetItemAttrText(itemtype => l_itemtype,
4292: itemkey => l_itemkey,
4293: aname => 'AMS_CURRENCY',
4294: avalue => l_budget_currency);
4295:
4293: aname => 'AMS_CURRENCY',
4294: avalue => l_budget_currency);
4295:
4296: --
4297: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4298: itemkey => l_itemkey,
4299: aname => 'AMS_APPROVER_SEQ',
4300: avalue => l_approver_seq);
4301:
4299: aname => 'AMS_APPROVER_SEQ',
4300: avalue => l_approver_seq);
4301:
4302: --
4303: Wf_Engine.SetItemAttrNumber(itemtype => l_itemtype,
4304: itemkey => l_itemkey,
4305: aname => 'AMS_ACTIVITY_DETAIL_ID',
4306: avalue => l_activity_detail_id);
4307:
4311: l_return_status,
4312: l_appr_meaning);
4313:
4314: -- check for description of activity
4315: wf_engine.SetItemAttrText(itemtype => l_itemtype ,
4316: itemkey => l_itemkey,
4317: aname => 'AMS_APPROVAL_OBJECT_MEANING',
4318: avalue => l_appr_meaning );
4319: */
4317: aname => 'AMS_APPROVAL_OBJECT_MEANING',
4318: avalue => l_appr_meaning );
4319: */
4320:
4321: Wf_Engine.SetItemAttrText(itemtype => l_itemtype ,
4322: itemkey => l_itemkey,
4323: aname => 'AMS_APPROVAL_TYPE',
4324: avalue => 'BUDGET' );
4325:
4327: --
4328: -- owner of the process
4329: l_owner := l_requestor_name;
4330:
4331: Wf_Engine.SetItemOwner(itemtype =>l_itemtype,
4332: itemkey => l_itemkey,
4333: owner => l_owner );
4334:
4335: -- start the process
4333: owner => l_owner );
4334:
4335: -- start the process
4336: --
4337: Wf_Engine.StartProcess(itemtype => l_itemtype,
4338: itemkey => l_itemkey );
4339:
4340:
4341: l_appr_hist_rec.object_id := p_act_budget_id;
4618: IF (funcmode = 'RUN') THEN
4619: --resultout := 'COMPLETE:ERROR';
4620:
4621: -- get the activity id
4622: l_approval_amount := Wf_Engine.GetItemAttrNumber(
4623: itemtype => itemtype,
4624: itemkey => itemkey,
4625: aname => 'AMS_ACTIVITY_AMOUNT' );
4626:
4624: itemkey => itemkey,
4625: aname => 'AMS_ACTIVITY_AMOUNT' );
4626:
4627: -- get the activity id
4628: l_activity_id := Wf_Engine.GetItemAttrNumber(
4629: itemtype => itemtype,
4630: itemkey => itemkey,
4631: aname => 'AMS_ACTIVITY_ID' );
4632:
4630: itemkey => itemkey,
4631: aname => 'AMS_ACTIVITY_ID' );
4632:
4633: -- get the activity type
4634: l_activity_type := Wf_Engine.GetItemAttrText(
4635: itemtype => itemtype,
4636: itemkey => itemkey,
4637: aname => 'AMS_ACTIVITY_TYPE' );
4638:
4636: itemkey => itemkey,
4637: aname => 'AMS_ACTIVITY_TYPE' );
4638:
4639: -- get the requestor id
4640: l_requestor_id := Wf_Engine.GetItemAttrNumber(
4641: itemtype => itemtype,
4642: itemkey => itemkey,
4643: aname => 'AMS_REQUESTER_ID' );
4644:
4873: -- RUN mode
4874: --
4875: IF (funcmode = 'RUN') THEN
4876: -- get the approval detail id
4877: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
4878: itemtype => itemtype,
4879: itemkey => itemkey,
4880: aname => 'AMS_ACTIVITY_DETAIL_ID'
4881: );
4879: itemkey => itemkey,
4880: aname => 'AMS_ACTIVITY_DETAIL_ID'
4881: );
4882: -- get the budget type
4883: l_current_seq := Wf_Engine.GetItemAttrNumber(
4884: itemtype => itemtype,
4885: itemkey => itemkey,
4886: aname => 'AMS_APPROVER_SEQ'
4887: );
4916: END IF;
4917:
4918: -- 11.5.9
4919: -- Get the Activity Budget Id
4920: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
4921: itemtype => itemtype,
4922: itemkey => itemkey,
4923: aname => 'AMS_ACT_BUDGET_ID'
4924: );
4922: itemkey => itemkey,
4923: aname => 'AMS_ACT_BUDGET_ID'
4924: );
4925:
4926: l_version := Wf_Engine.GetItemAttrNumber(
4927: itemtype => itemtype,
4928: itemkey => itemkey,
4929: aname => 'AMS_OBJECT_VERSION_NUMBER'
4930: );
5018: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5019: RAISE Fnd_Api.G_EXC_ERROR;
5020: END IF;
5021:
5022: l_prev_role_name := Wf_Engine.GetItemAttrText(
5023: itemtype => itemtype,
5024: itemkey => itemkey,
5025: aname => 'AMS_APPROVAL_ROLE' );
5026:
5023: itemtype => itemtype,
5024: itemkey => itemkey,
5025: aname => 'AMS_APPROVAL_ROLE' );
5026:
5027: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5028: itemkey => itemkey,
5029: aname => 'AMS_APPROVAL_ROLE',
5030: avalue => l_role_name);
5031:
5029: aname => 'AMS_APPROVAL_ROLE',
5030: avalue => l_role_name);
5031:
5032: -- get the activity id
5033: l_activity_id := Wf_Engine.GetItemAttrNumber(
5034: itemtype => itemtype,
5035: itemkey => itemkey,
5036: aname => 'AMS_ACTIVITY_ID' );
5037:
5035: itemkey => itemkey,
5036: aname => 'AMS_ACTIVITY_ID' );
5037:
5038: -- get the activity type
5039: l_activity_type := Wf_Engine.GetItemAttrText(
5040: itemtype => itemtype,
5041: itemkey => itemkey,
5042: aname => 'AMS_ACTIVITY_TYPE' );
5043:
5041: itemkey => itemkey,
5042: aname => 'AMS_ACTIVITY_TYPE' );
5043:
5044: -- get the activity note
5045: l_note := Wf_Engine.GetItemAttrText(
5046: itemtype => itemtype,
5047: itemkey => itemkey,
5048: aname => 'AMS_NOTE' );
5049:
5062: RAISE Fnd_Api.G_EXC_ERROR;
5063: END IF;
5064:
5065: -- get all the budget line notes
5066: l_all_note := Wf_Engine.GetItemAttrText(
5067: itemtype => itemtype,
5068: itemkey => itemkey,
5069: aname => 'AMS_ALL_NOTE' );
5070:
5072: -- issue : cannot distinguish from notes created by activities or budget lines
5073: -- option : can insert a carriage return when concaniting notes
5074: l_all_note := l_all_note || l_note;
5075:
5076: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5077: itemkey => itemkey,
5078: aname => 'AMS_ALL_NOTE' ,
5079: avalue => l_all_note ) ;
5080:
5079: avalue => l_all_note ) ;
5080:
5081: -- set the note to null
5082: l_note := NULL;
5083: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5084: itemkey => itemkey,
5085: aname => 'AMS_NOTE' ,
5086: avalue => l_note ) ;
5087:
5084: itemkey => itemkey,
5085: aname => 'AMS_NOTE' ,
5086: avalue => l_note ) ;
5087:
5088: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
5089: itemkey => itemkey,
5090: aname => 'AMS_APPROVER_ID',
5091: avalue => l_object_approver_id);
5092: --avalue => l_object_approver);
5092: --avalue => l_object_approver);
5093:
5094: -- Changed by VMODUR from l_approver to l_approver_display_name
5095: -- Unchanged
5096: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5097: itemkey => itemkey,
5098: aname => 'AMS_APPR_USERNAME',
5099: avalue => l_approver);
5100:
5097: itemkey => itemkey,
5098: aname => 'AMS_APPR_USERNAME',
5099: avalue => l_approver);
5100:
5101: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5102: itemkey => itemkey,
5103: aname => 'AMS_APPR_DISPLAY_NAME',
5104: avalue => l_approver_display_name);
5105:
5102: itemkey => itemkey,
5103: aname => 'AMS_APPR_DISPLAY_NAME',
5104: avalue => l_approver_display_name);
5105:
5106: Wf_Engine.SetItemAttrText( itemtype => itemtype,
5107: itemkey => itemkey,
5108: aname => 'AMS_NOTIFICATION_TYPE',
5109: avalue => l_notification_type);
5110:
5107: itemkey => itemkey,
5108: aname => 'AMS_NOTIFICATION_TYPE',
5109: avalue => l_notification_type);
5110:
5111: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
5112: itemkey => itemkey,
5113: aname => 'AMS_NOTIFICATION_TIMEOUT',
5114: avalue => l_notification_timeout);
5115:
5247: --
5248: IF (funcmode = 'RUN') THEN
5249:
5250: -- get the approval detail id
5251: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
5252: itemtype => itemtype,
5253: itemkey => itemkey,
5254: aname => 'AMS_ACTIVITY_DETAIL_ID' );
5255:
5253: itemkey => itemkey,
5254: aname => 'AMS_ACTIVITY_DETAIL_ID' );
5255:
5256: -- get the budget type
5257: l_current_seq := Wf_Engine.GetItemAttrNumber(
5258: itemtype => itemtype,
5259: itemkey => itemkey,
5260: aname => 'AMS_APPROVER_SEQ' );
5261:
5265: x_next_seq => l_next_seq,
5266: x_required_flag => l_required_flag);
5267:
5268: -- Added for 11.5.9
5269: l_version := Wf_Engine.GetItemAttrNumber(
5270: itemtype => itemtype,
5271: itemkey => itemkey,
5272: aname => 'AMS_OBJECT_VERSION_NUMBER' );
5273:
5270: itemtype => itemtype,
5271: itemkey => itemkey,
5272: aname => 'AMS_OBJECT_VERSION_NUMBER' );
5273:
5274: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
5275: itemtype => itemtype,
5276: itemkey => itemkey,
5277: aname => 'AMS_ACT_BUDGET_ID' );
5278:
5275: itemtype => itemtype,
5276: itemkey => itemkey,
5277: aname => 'AMS_ACT_BUDGET_ID' );
5278:
5279: l_approver_id := Wf_Engine.GetItemAttrNumber(
5280: itemtype => itemtype,
5281: itemkey => itemkey,
5282: aname => 'AMS_APPROVER_ID');
5283:
5280: itemtype => itemtype,
5281: itemkey => itemkey,
5282: aname => 'AMS_APPROVER_ID');
5283:
5284: l_note := Wf_Engine.GetItemAttrText(
5285: itemtype => itemtype,
5286: itemkey => itemkey,
5287: aname => 'AMS_NOTE' );
5288:
5350:
5351: --IF l_required_flag = FND_API.G_TRUE THEN
5352: IF l_next_seq IS NOT NULL THEN
5353: --
5354: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
5355: itemkey => itemkey,
5356: aname => 'AMS_APPROVER_SEQ',
5357: avalue => l_next_seq);
5358:
5474: -- RUN mode
5475: --
5476: IF (funcmode = 'RUN') THEN
5477: -- get the budget id
5478: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
5479: itemtype => itemtype,
5480: itemkey => itemkey,
5481: aname => 'AMS_ACT_BUDGET_ID' );
5482:
5480: itemkey => itemkey,
5481: aname => 'AMS_ACT_BUDGET_ID' );
5482:
5483: -- get the approved id
5484: l_approver_id := Wf_Engine.GetItemAttrNumber(
5485: itemtype => itemtype,
5486: itemkey => itemkey,
5487: aname => 'AMS_APPROVER_ID' );
5488:
5486: itemkey => itemkey,
5487: aname => 'AMS_APPROVER_ID' );
5488:
5489: -- get the approved amount
5490: l_approved_amount := Wf_Engine.GetItemAttrNumber(
5491: itemtype => itemtype,
5492: itemkey => itemkey,
5493: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5494:
5492: itemkey => itemkey,
5493: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5494:
5495: -- get the approved currency
5496: l_approved_currency := Wf_Engine.GetItemAttrText(
5497: itemtype => itemtype,
5498: itemkey => itemkey,
5499: aname => 'AMS_CURRENCY' );
5500:
5498: itemkey => itemkey,
5499: aname => 'AMS_CURRENCY' );
5500:
5501: -- get the approved status id
5502: l_approved_status_id := Wf_Engine.GetItemAttrNumber(
5503: itemtype => itemtype,
5504: itemkey => itemkey,
5505: aname => 'AMS_LINE_NEW_STAT_ID' );
5506:
5503: itemtype => itemtype,
5504: itemkey => itemkey,
5505: aname => 'AMS_LINE_NEW_STAT_ID' );
5506:
5507: l_comment := Wf_Engine.GetItemAttrText(
5508: itemtype => itemtype,
5509: itemkey => itemkey,
5510: aname => 'AMS_NOTE' );
5511:
5508: itemtype => itemtype,
5509: itemkey => itemkey,
5510: aname => 'AMS_NOTE' );
5511:
5512: l_approver := wf_engine.GetItemAttrText(
5513: itemtype => itemtype,
5514: itemkey => itemkey,
5515: aname => 'AMS_APPR_USERNAME');
5516:
5513: itemtype => itemtype,
5514: itemkey => itemkey,
5515: aname => 'AMS_APPR_USERNAME');
5516:
5517: l_budget_amount := wf_engine.GetItemAttrNumber(
5518: itemtype => itemtype,
5519: itemkey => itemkey,
5520: aname => 'AMS_BUDGET_AMOUNT_CONV');
5521:
5684: -- RUN mode
5685: --
5686: IF (funcmode = 'RUN') THEN
5687: -- get the budget id
5688: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
5689: itemtype => itemtype,
5690: itemkey => itemkey,
5691: aname => 'AMS_ACT_BUDGET_ID' );
5692:
5690: itemkey => itemkey,
5691: aname => 'AMS_ACT_BUDGET_ID' );
5692:
5693: -- get the approved id
5694: l_approver_id := Wf_Engine.GetItemAttrNumber(
5695: itemtype => itemtype,
5696: itemkey => itemkey,
5697: aname => 'AMS_APPROVER_ID' );
5698:
5696: itemkey => itemkey,
5697: aname => 'AMS_APPROVER_ID' );
5698:
5699: -- get the approved amount
5700: l_approved_amount := Wf_Engine.GetItemAttrNumber(
5701: itemtype => itemtype,
5702: itemkey => itemkey,
5703: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5704:
5702: itemkey => itemkey,
5703: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5704:
5705: -- get the approved currency
5706: l_approved_currency := Wf_Engine.GetItemAttrText(
5707: itemtype => itemtype,
5708: itemkey => itemkey,
5709: aname => 'AMS_CURRENCY' );
5710:
5708: itemkey => itemkey,
5709: aname => 'AMS_CURRENCY' );
5710:
5711: -- get the rejected status id
5712: l_rejected_status_id := Wf_Engine.GetItemAttrNumber(
5713: itemtype => itemtype,
5714: itemkey => itemkey,
5715: aname => 'AMS_LINE_REJECT_STAT_ID' );
5716:
5713: itemtype => itemtype,
5714: itemkey => itemkey,
5715: aname => 'AMS_LINE_REJECT_STAT_ID' );
5716:
5717: l_comment := Wf_Engine.GetItemAttrText(
5718: itemtype => itemtype,
5719: itemkey => itemkey,
5720: aname => 'AMS_NOTE' );
5721:
5718: itemtype => itemtype,
5719: itemkey => itemkey,
5720: aname => 'AMS_NOTE' );
5721:
5722: l_approver := wf_engine.GetItemAttrText(
5723: itemtype => itemtype,
5724: itemkey => itemkey,
5725: aname => 'AMS_APPR_USERNAME');
5726:
5723: itemtype => itemtype,
5724: itemkey => itemkey,
5725: aname => 'AMS_APPR_USERNAME');
5726:
5727: l_budget_amount := wf_engine.GetItemAttrNumber(
5728: itemtype => itemtype,
5729: itemkey => itemkey,
5730: aname => 'AMS_BUDGET_AMOUNT_CONV');
5731:
5729: itemkey => itemkey,
5730: aname => 'AMS_BUDGET_AMOUNT_CONV');
5731:
5732: -- 11.5.9 version sequence and note
5733: l_version := Wf_Engine.GetItemAttrNumber(
5734: itemtype => itemtype,
5735: itemkey => itemkey,
5736: aname => 'AMS_OBJECT_VERSION_NUMBER' );
5737:
5734: itemtype => itemtype,
5735: itemkey => itemkey,
5736: aname => 'AMS_OBJECT_VERSION_NUMBER' );
5737:
5738: l_approver_seq := Wf_Engine.GetItemAttrNumber(
5739: itemtype => itemtype,
5740: itemkey => itemkey,
5741: aname => 'AMS_APPROVER_SEQ' );
5742:
5740: itemkey => itemkey,
5741: aname => 'AMS_APPROVER_SEQ' );
5742:
5743: -- get the note
5744: l_note := Wf_Engine.GetItemAttrText(
5745: itemtype => itemtype,
5746: itemkey => itemkey,
5747: aname => 'AMS_NOTE' );
5748:
5966: -- RUN mode
5967: --
5968: IF (funcmode = 'RUN') THEN
5969: -- get the budget id
5970: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
5971: itemtype => itemtype,
5972: itemkey => itemkey,
5973: aname => 'AMS_ACT_BUDGET_ID' );
5974:
5972: itemkey => itemkey,
5973: aname => 'AMS_ACT_BUDGET_ID' );
5974:
5975: -- get the approved id
5976: l_approver_id := Wf_Engine.GetItemAttrNumber(
5977: itemtype => itemtype,
5978: itemkey => itemkey,
5979: aname => 'AMS_APPROVER_ID' );
5980:
5978: itemkey => itemkey,
5979: aname => 'AMS_APPROVER_ID' );
5980:
5981: -- get the approved amount
5982: l_approved_amount := Wf_Engine.GetItemAttrNumber(
5983: itemtype => itemtype,
5984: itemkey => itemkey,
5985: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5986:
5984: itemkey => itemkey,
5985: aname => 'AMS_APPROVED_LINE_AMOUNT' );
5986:
5987: -- get the approved currency
5988: l_approved_currency := Wf_Engine.GetItemAttrText(
5989: itemtype => itemtype,
5990: itemkey => itemkey,
5991: aname => 'AMS_CURRENCY' );
5992:
5990: itemkey => itemkey,
5991: aname => 'AMS_CURRENCY' );
5992:
5993: -- get the rejected status id
5994: l_rejected_status_id := Wf_Engine.GetItemAttrNumber(
5995: itemtype => itemtype,
5996: itemkey => itemkey,
5997: aname => 'AMS_LINE_REJECT_STAT_ID' );
5998:
5995: itemtype => itemtype,
5996: itemkey => itemkey,
5997: aname => 'AMS_LINE_REJECT_STAT_ID' );
5998:
5999: l_comment := Wf_Engine.GetItemAttrText(
6000: itemtype => itemtype,
6001: itemkey => itemkey,
6002: aname => 'AMS_NOTE' );
6003: BEGIN
6051: RAISE Fnd_Api.G_EXC_ERROR;
6052: END;
6053:
6054: -- 11.5.9 addition
6055: l_version := Wf_Engine.GetItemAttrNumber(
6056: itemtype => itemtype,
6057: itemkey => itemkey,
6058: aname => 'AMS_OBJECT_VERSION_NUMBER' );
6059:
6172: -- RUN mode
6173: --
6174: IF (funcmode = 'RUN') THEN
6175:
6176: l_parent_waiting_flag := Wf_Engine.GetItemAttrText(
6177: itemtype => itemtype,
6178: itemkey => itemkey,
6179: aname => 'AMS_PARENT_WAITING' );
6180:
6271: -- RUN mode
6272: --
6273: IF (funcmode = 'RUN') THEN
6274: -- get the approval amount
6275: l_approval_amount := Wf_Engine.GetItemAttrNumber(
6276: itemtype => itemtype,
6277: itemkey => itemkey,
6278: aname => 'AMS_ACTIVITY_AMOUNT' );
6279:
6277: itemkey => itemkey,
6278: aname => 'AMS_ACTIVITY_AMOUNT' );
6279:
6280: -- get the activity id
6281: l_activity_id := Wf_Engine.GetItemAttrNumber(
6282: itemtype => itemtype,
6283: itemkey => itemkey,
6284: aname => 'AMS_ACTIVITY_ID' );
6285:
6283: itemkey => itemkey,
6284: aname => 'AMS_ACTIVITY_ID' );
6285:
6286: -- get the activity type
6287: l_activity_type := Wf_Engine.GetItemAttrText(
6288: itemtype => itemtype,
6289: itemkey => itemkey,
6290: aname => 'AMS_ACTIVITY_TYPE' );
6291:
6289: itemkey => itemkey,
6290: aname => 'AMS_ACTIVITY_TYPE' );
6291:
6292: -- get parent process approved flag
6293: l_parent_approval_flag := Wf_Engine.GetItemAttrText(
6294: itemtype => itemtype,
6295: itemkey => itemkey,
6296: aname => 'AMS_PARENT_APPROVED' );
6297:
6296: aname => 'AMS_PARENT_APPROVED' );
6297:
6298: -- set the continue flow (if continues) to second continue flow
6299: --
6300: Wf_Engine.SetItemAttrText(itemtype => itemtype,
6301: itemkey => itemkey,
6302: aname => 'AMS_CONTINUEFLOW',
6303: avalue => 'CONTINUEFLOW');
6304:
6313: IF l_approval_flag = Fnd_Api.G_TRUE THEN
6314: -- set continue to true
6315: l_continue_flag := Fnd_Api.G_TRUE;
6316:
6317: Wf_Engine.SetItemAttrText(itemtype => itemtype,
6318: itemkey => itemkey,
6319: aname => 'AMS_CONTINUE_FLOW',
6320: avalue => l_continue_flag);
6321:
6425: --
6426: IF (funcmode = 'RUN') THEN
6427:
6428: -- get the activity id
6429: l_activity_id := Wf_Engine.GetItemAttrNumber(
6430: itemtype => itemtype,
6431: itemkey => itemkey,
6432: aname => 'AMS_ACTIVITY_ID' );
6433:
6431: itemkey => itemkey,
6432: aname => 'AMS_ACTIVITY_ID' );
6433:
6434: -- get the activity type
6435: l_activity_type := Wf_Engine.GetItemAttrText(
6436: itemtype => itemtype,
6437: itemkey => itemkey,
6438: aname => 'AMS_ACTIVITY_TYPE' );
6439:
6452: IF l_remaining_flag = Fnd_Api.G_FALSE THEN
6453: -- set continue to true
6454: l_continue_flag := Fnd_Api.G_TRUE;
6455:
6456: Wf_Engine.SetItemAttrText(itemtype => itemtype,
6457: itemkey => itemkey,
6458: aname => 'AMS_CONTINUE_FLOW',
6459: avalue => l_continue_flag);
6460: resultout := 'COMPLETE:N';
6558: -- RUN mode
6559: --
6560: IF (funcmode = 'RUN') THEN
6561:
6562: l_continue_flag := Wf_Engine.GetItemAttrText(
6563: itemtype => itemtype,
6564: itemkey => itemkey,
6565: aname => 'AMS_CONTINUE_FLOW' );
6566:
6565: aname => 'AMS_CONTINUE_FLOW' );
6566:
6567: IF l_continue_flag = Fnd_Api.G_TRUE THEN
6568: -- get the activity id
6569: l_activity_id := Wf_Engine.GetItemAttrNumber(
6570: itemtype => itemtype,
6571: itemkey => itemkey,
6572: aname => 'AMS_ACTIVITY_ID' );
6573:
6571: itemkey => itemkey,
6572: aname => 'AMS_ACTIVITY_ID' );
6573:
6574: -- get the activity id
6575: l_activity_type := Wf_Engine.GetItemAttrText(
6576: itemtype => itemtype,
6577: itemkey => itemkey,
6578: aname => 'AMS_ACTIVITY_TYPE' );
6579:
6577: itemkey => itemkey,
6578: aname => 'AMS_ACTIVITY_TYPE' );
6579:
6580: -- get the activity type
6581: l_parent_itemkey := Wf_Engine.GetItemAttrText(
6582: itemtype => itemtype,
6583: itemkey => itemkey,
6584: aname => 'AMS_PARENT_ITEMKEY' );
6585:
6595:
6596: -- derive the itemkeys that were set while creating them
6597: l_itemkey := l_line_id||'_'||l_parent_itemkey;
6598:
6599: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
6600: itemkey => l_itemkey,
6601: aname => 'AMS_CONTINUE_FLOW',
6602: avalue => l_continue_flag);
6603:
6600: itemkey => l_itemkey,
6601: aname => 'AMS_CONTINUE_FLOW',
6602: avalue => l_continue_flag);
6603:
6604: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
6605: itemkey => l_itemkey,
6606: aname => 'AMS_PARENT_APPROVED',
6607: avalue => l_parent_approved);
6608: END LOOP;
6695: -- RUN mode
6696: --
6697: IF (funcmode = 'RUN') THEN
6698: -- get the activity type
6699: l_parent_itemkey := Wf_Engine.GetItemAttrText(
6700: itemtype => itemtype,
6701: itemkey => itemkey,
6702: aname => 'AMS_PARENT_ITEMKEY' );
6703:
6702: aname => 'AMS_PARENT_ITEMKEY' );
6703:
6704: BEGIN
6705: /* Added for zero budget Approval */
6706: Wf_Engine.BeginActivity(itemtype => g_itemtype,
6707: itemkey => l_parent_itemkey,
6708: activity => l_parent_process||':'||l_activity_label
6709: );
6710: Wf_Engine.CompleteActivity(itemtype => g_itemtype,
6706: Wf_Engine.BeginActivity(itemtype => g_itemtype,
6707: itemkey => l_parent_itemkey,
6708: activity => l_parent_process||':'||l_activity_label
6709: );
6710: Wf_Engine.CompleteActivity(itemtype => g_itemtype,
6711: itemkey => l_parent_itemkey,
6712: activity => l_parent_process||':'||l_activity_label,
6713: result => 'COMPLETE:');
6714: EXCEPTION
6811:
6812: Ams_Utility_Pvt.debug_message('Start :Item Type : '||itemtype
6813: ||' Item key : '||itemkey);
6814:
6815: Wf_Engine.CreateProcess (itemtype => itemtype,
6816: itemkey => itemkey ,
6817: process => p_workflowprocess);
6818:
6819: Wf_Engine.SetItemUserkey(itemtype => itemtype,
6815: Wf_Engine.CreateProcess (itemtype => itemtype,
6816: itemkey => itemkey ,
6817: process => p_workflowprocess);
6818:
6819: Wf_Engine.SetItemUserkey(itemtype => itemtype,
6820: itemkey => itemkey ,
6821: userkey => itemuserkey);
6822:
6823:
6825: Initialize Workflow Item Attributes
6826: *****************************************************************/
6827:
6828:
6829: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
6830: itemkey => itemkey,
6831: aname => 'AMS_DELV_NAME',
6832: avalue => p_deliverable_name );
6833:
6830: itemkey => itemkey,
6831: aname => 'AMS_DELV_NAME',
6832: avalue => p_deliverable_name );
6833:
6834: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
6835: itemkey => itemkey,
6836: aname => 'AMS_DELV_USEDBY_NAME',
6837: avalue => p_usedby_object_name );
6838:
6835: itemkey => itemkey,
6836: aname => 'AMS_DELV_USEDBY_NAME',
6837: avalue => p_usedby_object_name );
6838:
6839: Wf_Engine.SetItemAttrText(itemtype => itemtype ,
6840: itemkey => itemkey,
6841: aname => 'AMS_DELV_USEDBY_TYPE',
6842: avalue => p_usedby_object_type_name );
6843:
6857: RAISE Fnd_Api.G_EXC_ERROR;
6858: END IF;
6859:
6860:
6861: Wf_Engine.SetItemAttrText(itemtype => itemtype,
6862: itemkey => itemkey,
6863: aname => 'AMS_DELV_USER',
6864: avalue => l_delv_user_role );
6865:
6872: RAISE Fnd_Api.G_EXC_ERROR;
6873: END IF;
6874:
6875:
6876: Wf_Engine.SetItemOwner(itemtype => itemtype,
6877: itemkey => itemkey,
6878: owner => l_requester_role);
6879:
6880:
6878: owner => l_requester_role);
6879:
6880:
6881: -- Start the Process
6882: Wf_Engine.StartProcess (itemtype => itemtype,
6883: itemkey => itemkey);
6884:
6885:
6886: EXCEPTION
6918: AND parent_item_key = item_key_in
6919: AND END_DATE IS NULL;
6920:
6921: BEGIN
6922: l_activity_id := Wf_Engine.GetItemAttrNumber(
6923: itemtype => itemtype,
6924: itemkey => itemkey,
6925: aname => 'AMS_ACTIVITY_ID' );
6926:
6924: itemkey => itemkey,
6925: aname => 'AMS_ACTIVITY_ID' );
6926:
6927: -- get the activity type
6928: l_activity_type := Wf_Engine.GetItemAttrText(
6929: itemtype => itemtype,
6930: itemkey => itemkey,
6931: aname => 'AMS_ACTIVITY_TYPE' );
6932:
6929: itemtype => itemtype,
6930: itemkey => itemkey,
6931: aname => 'AMS_ACTIVITY_TYPE' );
6932:
6933: l_approved_currency := Wf_Engine.GetItemAttrText(
6934: itemtype => itemtype,
6935: itemkey => itemkey,
6936: aname => 'AMS_CURRENCY' );
6937:
6966: CLOSE c_find_child;
6967: END IF;
6968: EXCEPTION
6969: WHEN Fnd_Api.G_EXC_ERROR THEN
6970: -- wf_engine.threshold := l_save_threshold ;
6971: Fnd_Msg_Pub.Count_And_Get (
6972: p_encoded => Fnd_Api.G_FALSE,
6973: p_count => l_msg_count,
6974: p_data => l_msg_data);
7008: -- RUN mode
7009: --
7010: IF (funcmode = 'RUN') THEN
7011: -- get the acitvity id
7012: l_activity_id := Wf_Engine.GetItemAttrNumber(
7013: itemtype => itemtype,
7014: itemkey => itemkey,
7015: aname => 'AMS_ACTIVITY_ID' );
7016:
7014: itemkey => itemkey,
7015: aname => 'AMS_ACTIVITY_ID' );
7016:
7017: -- get the activity type
7018: l_activity_type := Wf_Engine.GetItemAttrText(
7019: itemtype => itemtype,
7020: itemkey => itemkey,
7021: aname => 'AMS_ACTIVITY_TYPE' );
7022:
7021: aname => 'AMS_ACTIVITY_TYPE' );
7022:
7023: IF l_activity_type = 'OFFR' THEN
7024:
7025: l_act_budget_id := Wf_Engine.GetItemAttrText(
7026: itemtype => itemtype,
7027: itemkey => itemkey,
7028: aname => 'AMS_ACT_BUDGET_ID' );
7029:
7151: --
7152: IF (funcmode = 'RUN') THEN
7153:
7154: -- Get the Requestor
7155: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
7156: itemkey => itemkey,
7157: aname => 'AMS_REQUESTER_ID');
7158:
7159: -- Get the Approver
7156: itemkey => itemkey,
7157: aname => 'AMS_REQUESTER_ID');
7158:
7159: -- Get the Approver
7160: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
7161: itemkey => itemkey,
7162: aname => 'AMS_APPROVER_ID');
7163:
7164: IF l_requestor = l_approver THEN
7226: IF (funcmode = 'RUN') THEN
7227: Fnd_Msg_Pub.initialize();
7228:
7229: -- Get the Approver Id
7230: l_approver_id := Wf_Engine.GetItemAttrNumber( itemtype => itemtype,
7231: itemkey => itemkey,
7232: aname => 'AMS_APPROVER_ID' );
7233: -- Get the user id
7234: OPEN res_user_csr (l_approver_id);
7242: IF l_auto_amount > 0 THEN
7243:
7244: -- Get the Budget ID
7245:
7246: l_act_budget_id := Wf_Engine.GetItemAttrNumber( itemtype => itemtype,
7247: itemkey => itemkey,
7248: aname => 'AMS_ACT_BUDGET_ID' );
7249:
7250: IF l_act_budget_id IS NOT NULL THEN
7250: IF l_act_budget_id IS NOT NULL THEN
7251: -- It is a budget line
7252:
7253: -- get the approved line amount that is seen by approver
7254: l_appr_line_amount := Wf_Engine.GetItemAttrNumber( itemtype => itemtype,
7255: itemkey => itemkey,
7256: aname => 'AMS_APPROVED_LINE_AMOUNT');
7257:
7258: IF l_appr_line_amount <= l_auto_amount THEN
7268: ELSE
7269: -- It is not a budget line
7270:
7271: -- Get the Activity Amount
7272: l_activity_amount := Wf_Engine.GetItemAttrNumber( itemtype => itemtype,
7273: itemkey => itemkey,
7274: aname => 'AMS_ACTIVITY_AMOUNT');
7275: IF l_activity_amount > 0 THEN
7276: IF l_activity_amount <= l_auto_amount THEN
7382:
7383: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
7384:
7385: BEGIN
7386: l_nid := wf_engine.context_nid;
7387:
7388: IF (funcmode = 'RESPOND') THEN
7389:
7390: l_result := upper(wf_notification.GETATTRTEXT(l_nid, 'RESULT'));
7399:
7400: -- Set the forwarded/transferred notification id so that
7401: -- we can use it later to see actual approver
7402:
7403: l_assignee := WF_ENGINE.context_text;
7404:
7405: -- ams_forward_nid is not really needed.
7406: wf_engine.SetItemAttrNumber(itemtype => itemtype,
7407: itemkey => itemkey,
7402:
7403: l_assignee := WF_ENGINE.context_text;
7404:
7405: -- ams_forward_nid is not really needed.
7406: wf_engine.SetItemAttrNumber(itemtype => itemtype,
7407: itemkey => itemkey,
7408: aname => 'AMS_FORWARD_NID',
7409: avalue => l_nid);
7410:
7417: RAISE Fnd_Api.G_EXC_ERROR;
7418: END IF;
7419:
7420: -- Set the WF Attributes
7421: wf_engine.SetItemAttrText( itemtype => itemtype,
7422: itemkey => itemkey,
7423: aname => 'AMS_APPR_USERNAME',
7424: avalue => l_assignee);
7425:
7422: itemkey => itemkey,
7423: aname => 'AMS_APPR_USERNAME',
7424: avalue => l_assignee);
7425:
7426: wf_engine.SetItemAttrNumber(itemtype => itemtype,
7427: itemkey => itemkey,
7428: aname => 'AMS_APPROVER_ID',
7429: avalue => l_new_approver_id);
7430:
7427: itemkey => itemkey,
7428: aname => 'AMS_APPROVER_ID',
7429: avalue => l_new_approver_id);
7430:
7431: wf_engine.SetItemAttrText( itemtype => itemtype,
7432: itemkey => itemkey,
7433: aname => 'AMS_APPR_DISPLAY_NAME',
7434: avalue => l_appr_display_name);
7435:
7434: avalue => l_appr_display_name);
7435:
7436: -- Update the approver details here
7437:
7438: l_activity_type := Wf_Engine.GetItemAttrText(
7439: itemtype => itemtype,
7440: itemkey => itemkey,
7441: aname => 'AMS_ACTIVITY_TYPE' );
7442:
7439: itemtype => itemtype,
7440: itemkey => itemkey,
7441: aname => 'AMS_ACTIVITY_TYPE' );
7442:
7443: l_act_budget_id := Wf_Engine.GetItemAttrNumber(
7444: itemtype => itemtype,
7445: itemkey => itemkey,
7446: aname => 'AMS_ACT_BUDGET_ID'
7447: );
7445: itemkey => itemkey,
7446: aname => 'AMS_ACT_BUDGET_ID'
7447: );
7448:
7449: l_version := Wf_Engine.GetItemAttrNumber(
7450: itemtype => itemtype,
7451: itemkey => itemkey,
7452: aname => 'AMS_OBJECT_VERSION_NUMBER'
7453: );
7451: itemkey => itemkey,
7452: aname => 'AMS_OBJECT_VERSION_NUMBER'
7453: );
7454:
7455: l_activity_id := Wf_Engine.GetItemAttrNumber(
7456: itemtype => itemtype,
7457: itemkey => itemkey,
7458: aname => 'AMS_ACTIVITY_ID' );
7459:
7456: itemtype => itemtype,
7457: itemkey => itemkey,
7458: aname => 'AMS_ACTIVITY_ID' );
7459:
7460: l_current_seq := Wf_Engine.GetItemAttrText(
7461: itemtype => itemtype,
7462: itemkey => itemkey,
7463: aname => 'AMS_APPROVER_SEQ' );
7464:
7461: itemtype => itemtype,
7462: itemkey => itemkey,
7463: aname => 'AMS_APPROVER_SEQ' );
7464:
7465: l_approval_type := Wf_Engine.GetItemAttrText(
7466: itemtype => itemtype,
7467: itemkey => itemkey,
7468: aname => 'AMS_APPROVAL_TYPE' );
7469:
7546: -- RUN mode
7547: --
7548: IF (funcmode = 'RUN') THEN
7549: -- get the acitvity id
7550: l_activity_id := Wf_Engine.GetItemAttrNumber(
7551: itemtype => itemtype,
7552: itemkey => itemkey,
7553: aname => 'AMS_ACTIVITY_ID' );
7554:
7552: itemkey => itemkey,
7553: aname => 'AMS_ACTIVITY_ID' );
7554:
7555: -- get the activity type
7556: l_activity_type := Wf_Engine.GetItemAttrText(
7557: itemtype => itemtype,
7558: itemkey => itemkey,
7559: aname => 'AMS_ACTIVITY_TYPE' );
7560:
7559: aname => 'AMS_ACTIVITY_TYPE' );
7560:
7561: IF l_activity_type = 'OFFR' THEN
7562:
7563: -- l_act_budget_id := Wf_Engine.GetItemAttrText(
7564: -- itemtype => itemtype,
7565: -- itemkey => itemkey,
7566: -- aname => 'AMS_ACT_BUDGET_ID' );
7567:
7679: IF (funcmode = 'RUN') THEN
7680:
7681: resultout := 'COMPLETE:N';
7682: -- get the activity type
7683: l_activity_type := Wf_Engine.GetItemAttrText(
7684: itemtype => itemtype,
7685: itemkey => itemkey,
7686: aname => 'AMS_ACTIVITY_TYPE' );
7687: IF l_activity_type = 'OFFR' THEN
7686: aname => 'AMS_ACTIVITY_TYPE' );
7687: IF l_activity_type = 'OFFR' THEN
7688:
7689: -- Get the Activity Id
7690: l_activity_id := Wf_Engine.GetItemAttrNumber(
7691: itemtype => itemtype,
7692: itemkey => itemkey,
7693: aname => 'AMS_ACTIVITY_ID' );
7694:
7834: l_process_type varchar2(80);
7835: l_activity_type varchar2(80);
7836: BEGIN
7837:
7838: l_activity_type := wf_engine.GetItemAttrText(
7839: itemtype => itemtype,
7840: itemkey => itemkey,
7841: aname => 'AMS_ACTIVITY_TYPE' );
7842: