APPS.AMS_WFCMPAPR_PVT dependencies on WF_ENGINE

Line 77: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,

73: p_msg_index_out => l_msg_index ) ;
74: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10) ;
75: l_cnt := l_cnt + 1 ;
76: END LOOP ;
77: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,
78: itemkey => p_itemkey ,
79: aname => p_attr_name,
80: avalue => l_final_data );
81:

Line 847: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,

843: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype||' Item key : '||itemkey);
844: END IF;
845: -- dbms_output.put_line('Start :Item Type : '||itemtype||' Item key : '||itemkey);
846:
847: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,
848: itemkey => itemkey ,
849: process => p_workflowprocess);
850:
851: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

Line 851: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

847: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,
848: itemkey => itemkey ,
849: process => p_workflowprocess);
850:
851: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
852: itemkey => itemkey ,
853: userkey => itemuserkey);
854:
855: -- Initialize Workflow Item Attributes

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

853: userkey => itemuserkey);
854:
855: -- Initialize Workflow Item Attributes
856:
857: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
858: itemkey => itemkey,
859: aname => 'AMS_APPROVAL_FOR_OBJECT',
860: avalue => p_approval_for );
861:

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

858: itemkey => itemkey,
859: aname => 'AMS_APPROVAL_FOR_OBJECT',
860: avalue => p_approval_for );
861:
862: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
863: itemkey => itemkey,
864: aname => 'AMS_ACT_ID',
865: avalue => p_approval_for_id );
866:

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

863: itemkey => itemkey,
864: aname => 'AMS_ACT_ID',
865: avalue => p_approval_for_id );
866:
867: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
868: itemkey => itemkey,
869: aname => 'AMS_ORIG_STAT_ID',
870: avalue => p_orig_stat_id );
871:

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

868: itemkey => itemkey,
869: aname => 'AMS_ORIG_STAT_ID',
870: avalue => p_orig_stat_id );
871:
872: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
873: itemkey => itemkey,
874: aname => 'AMS_NEW_STAT_ID',
875: avalue => p_new_stat_id );
876:

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

873: itemkey => itemkey,
874: aname => 'AMS_NEW_STAT_ID',
875: avalue => p_new_stat_id );
876:
877: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
878: itemkey => itemkey,
879: aname => 'AMS_OBJECT_VERSION_NUMBER',
880: avalue => p_object_version_number );
881:

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

878: itemkey => itemkey,
879: aname => 'AMS_OBJECT_VERSION_NUMBER',
880: avalue => p_object_version_number );
881:
882: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
883: itemkey => itemkey,
884: aname => 'AMS_NOTES_FROM_REQUESTER',
885: avalue => nvl(p_notes_from_requester,'') );
886:

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

887: OPEN c_resource ;
888: FETCH c_resource INTO l_requester_id ,l_person_id ;
889: CLOSE c_resource ;
890:
891: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'AMS_REQUESTER_ID',
894: avalue => l_requester_id );
895:

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

894: avalue => l_requester_id );
895:
896: l_appr_for := Get_Lookup_Meaning('AMS_SYS_ARC_QUALIFIER',p_approval_for);
897:
898: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
899: itemkey => itemkey,
900: aname => 'AMS_APPR_FOR',
901: avalue => l_appr_for );
902:

Line 914: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

910: -- Activity Details
911: -- Find_Manager
912: -- (p_user_id => p_requester_userid,
913: -- x_manager_role => l_manager_role );
914: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
915: -- itemkey => itemkey,
916: -- aname => 'AMS_MANAGER',
917: -- avalue => l_manager_role );
918: --

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

924: AMS_Utility_PVT.debug_message('requester : '||l_requester_role);
925: END IF;
926: -- dbms_output.put_line('requester : '||l_requester_role);
927:
928: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
929: itemkey => itemkey,
930: aname => 'AMS_REQUESTER',
931: avalue => l_requester_role );
932:

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

930: aname => 'AMS_REQUESTER',
931: avalue => l_requester_role );
932:
933:
934: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
935: itemkey => itemkey,
936: aname => 'MONITOR_URL',
937: avalue => wf_monitor.geturl
938: (wf_core.TRANSLATE('WF_WEB_AGENT'), itemtype, itemkey, 'NO')

Line 942: WF_ENGINE.SetItemOwner (itemtype => itemtype,

938: (wf_core.TRANSLATE('WF_WEB_AGENT'), itemtype, itemkey, 'NO')
939: );
940:
941:
942: WF_ENGINE.SetItemOwner (itemtype => itemtype,
943: itemkey => itemkey,
944: owner => l_requester_role);
945:
946:

Line 947: WF_ENGINE.StartProcess (itemtype => itemtype,

943: itemkey => itemkey,
944: owner => l_requester_role);
945:
946:
947: WF_ENGINE.StartProcess (itemtype => itemtype,
948: itemkey => itemkey);
949:
950:
951: EXCEPTION

Line 1799: l_approval_for_object := WF_ENGINE.GetItemAttrText(

1795:
1796: -- RUN mode - Normal Process Execution
1797: IF (funcmode = 'RUN')
1798: THEN
1799: l_approval_for_object := WF_ENGINE.GetItemAttrText(
1800: itemtype => itemtype,
1801: itemkey => itemkey ,
1802: aname => 'AMS_APPROVAL_FOR_OBJECT');
1803:

Line 1804: l_approval_for_objectid := WF_ENGINE.GetItemAttrText(

1800: itemtype => itemtype,
1801: itemkey => itemkey ,
1802: aname => 'AMS_APPROVAL_FOR_OBJECT');
1803:
1804: l_approval_for_objectid := WF_ENGINE.GetItemAttrText(
1805: itemtype => itemtype,
1806: itemkey => itemkey ,
1807: aname => 'AMS_ACT_ID');
1808:

Line 1809: l_orig_stat_id := WF_ENGINE.GetItemAttrText(

1805: itemtype => itemtype,
1806: itemkey => itemkey ,
1807: aname => 'AMS_ACT_ID');
1808:
1809: l_orig_stat_id := WF_ENGINE.GetItemAttrText(
1810: itemtype => itemtype,
1811: itemkey => itemkey ,
1812: aname => 'AMS_ORIG_STAT_ID');
1813:

Line 1814: l_new_stat_id := WF_ENGINE.GetItemAttrText(

1810: itemtype => itemtype,
1811: itemkey => itemkey ,
1812: aname => 'AMS_ORIG_STAT_ID');
1813:
1814: l_new_stat_id := WF_ENGINE.GetItemAttrText(
1815: itemtype => itemtype,
1816: itemkey => itemkey ,
1817: aname => 'AMS_NEW_STAT_ID');
1818:

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

1845: -- dbms_output.put_line('Approval Type : '||l_appr_type);
1846: -- dbms_output.put_line('Approval Required : '||l_appr_req_flag);
1847: IF l_return_status <> FND_API.G_ret_sts_success THEN
1848: -- Approval process is errored out
1849: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1850: itemkey => itemkey,
1851: aname => 'AMS_ERROR_MSG',
1852: avalue => l_err_msg);
1853:

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

1854: result := 'COMPLETE:ERROR' ;
1855: ELSE
1856: IF l_appr_req_flag = 'N' THEN
1857: -- No Need of approval
1858: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1859: itemkey => itemkey,
1860: aname => 'AMS_APPR_REQ_CHECK',
1861: avalue => 'N' );
1862:

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

1862:
1863: result := 'COMPLETE:SUCCESS' ;
1864: ELSE
1865:
1866: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1867: itemkey => itemkey,
1868: aname => 'AMS_APPR_TYPE_LOOKUP',
1869: avalue => l_appr_type );
1870:

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

1867: itemkey => itemkey,
1868: aname => 'AMS_APPR_TYPE_LOOKUP',
1869: avalue => l_appr_type );
1870:
1871: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1872: itemkey => itemkey,
1873: aname => 'AMS_APPR_REQ_CHECK',
1874: avalue => 'Y' );
1875:

Line 1877: l_requester := WF_ENGINE.GetItemAttrText(

1873: aname => 'AMS_APPR_REQ_CHECK',
1874: avalue => 'Y' );
1875:
1876:
1877: l_requester := WF_ENGINE.GetItemAttrText(
1878: itemtype => itemtype,
1879: itemkey => itemkey ,
1880: aname => 'AMS_REQUESTER');
1881:

Line 1882: l_requester_id := WF_ENGINE.GetItemAttrText(

1878: itemtype => itemtype,
1879: itemkey => itemkey ,
1880: aname => 'AMS_REQUESTER');
1881:
1882: l_requester_id := WF_ENGINE.GetItemAttrText(
1883: itemtype => itemtype,
1884: itemkey => itemkey ,
1885: aname => 'AMS_REQUESTER_ID');
1886:

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

1888: Find_Manager
1889: (p_user_id => l_requester_id,
1890: x_manager_role => l_manager );
1891:
1892: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1893: itemkey => itemkey,
1894: aname => 'AMS_MANAGER',
1895: avalue => l_manager );
1896: IF (AMS_DEBUG_HIGH_ON) THEN

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

1913: AMS_Utility_PVT.debug_message('Owner : '||l_owner);
1914:
1915: END IF;
1916: -- dbms_output.put_line('Owner : '||l_owner);
1917: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1918: itemkey => itemkey,
1919: aname => 'AMS_OWNER',
1920: avalue => l_owner );
1921: --

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

1927: x_manager_role => l_fund_manager
1928: ) ;
1929:
1930:
1931: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1932: itemkey => itemkey,
1933: aname => 'AMS_BUD_MANAGER',
1934: avalue => l_fund_manager );
1935: -- dbms_output.put_line('Fund Manager : '||l_owner);

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

1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1954: l_err_msg := FND_MESSAGE.Get;
1955: END IF ;
1956:
1957: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1958: itemkey => itemkey,
1959: aname => 'AMS_ERROR_MSG',
1960: avalue => l_err_msg);
1961:

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

1979: IF l_requester = l_manager AND
1980: l_requester = l_owner AND
1981: l_requester = l_fund_manager
1982: THEN
1983: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1984: itemkey => itemkey,
1985: aname => 'AMS_APPR_REQ_CHECK',
1986: avalue => 'N' );
1987:

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

1986: avalue => 'N' );
1987:
1988: result := 'COMPLETE:SUCCESS' ;
1989: ELSE
1990: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1991: itemkey => itemkey,
1992: aname => 'AMS_APPR_USERNAME',
1993: avalue => l_manager);
1994:

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

1999: IF (l_requester = l_owner AND
2000: l_requester = l_fund_manager)
2001: THEN --(req = Own = Fun_Man) <> Man
2002: -- Theme Approval Require Budget Approval Not Require
2003: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2004: itemkey => itemkey,
2005: aname => 'AMS_BUDGET_APPR_FLAG',
2006: avalue => 'N');
2007: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2003: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2004: itemkey => itemkey,
2005: aname => 'AMS_BUDGET_APPR_FLAG',
2006: avalue => 'N');
2007: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2008: itemkey => itemkey,
2009: aname => 'AMS_TAOWNER_APPR_FLAG',
2010: avalue => 'N');
2011: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2007: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2008: itemkey => itemkey,
2009: aname => 'AMS_TAOWNER_APPR_FLAG',
2010: avalue => 'N');
2011: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2012: itemkey => itemkey,
2013: aname => 'AMS_BAOWNER_APPR_FLAG',
2014: avalue => 'N');
2015: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2011: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2012: itemkey => itemkey,
2013: aname => 'AMS_BAOWNER_APPR_FLAG',
2014: avalue => 'N');
2015: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2016: itemkey => itemkey,
2017: aname => 'AMS_THEME_APPR_FLAG',
2018: avalue => 'Y');
2019: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2015: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2016: itemkey => itemkey,
2017: aname => 'AMS_THEME_APPR_FLAG',
2018: avalue => 'Y');
2019: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2020: itemkey => itemkey,
2021: aname => 'AMS_APPR_DOC_TYPE',
2022: avalue => 'BOTH');
2023:

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

2025: l_requester <> l_fund_manager)
2026: THEN --(req = Own <> Fun_Man) <> Man
2027: IF l_fund_manager = l_manager THEN --(Condi: 3)
2028: -- Theme Approval Require Budget Approval Not Require
2029: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2030: itemkey => itemkey,
2031: aname => 'AMS_BUDGET_APPR_FLAG',
2032: avalue => 'N');
2033: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2029: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2030: itemkey => itemkey,
2031: aname => 'AMS_BUDGET_APPR_FLAG',
2032: avalue => 'N');
2033: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2034: itemkey => itemkey,
2035: aname => 'AMS_TAOWNER_APPR_FLAG',
2036: avalue => 'N');
2037: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2033: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2034: itemkey => itemkey,
2035: aname => 'AMS_TAOWNER_APPR_FLAG',
2036: avalue => 'N');
2037: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2038: itemkey => itemkey,
2039: aname => 'AMS_BAOWNER_APPR_FLAG',
2040: avalue => 'N');
2041: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2037: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2038: itemkey => itemkey,
2039: aname => 'AMS_BAOWNER_APPR_FLAG',
2040: avalue => 'N');
2041: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2042: itemkey => itemkey,
2043: aname => 'AMS_THEME_APPR_FLAG',
2044: avalue => 'Y');
2045: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2041: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2042: itemkey => itemkey,
2043: aname => 'AMS_THEME_APPR_FLAG',
2044: avalue => 'Y');
2045: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2046: itemkey => itemkey,
2047: aname => 'AMS_APPR_DOC_TYPE',
2048: avalue => 'BOTH');
2049: ELSE --(Condi: 4)

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

2046: itemkey => itemkey,
2047: aname => 'AMS_APPR_DOC_TYPE',
2048: avalue => 'BOTH');
2049: ELSE --(Condi: 4)
2050: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2051: itemkey => itemkey,
2052: aname => 'AMS_BUDGET_APPR_FLAG',
2053: avalue => 'Y');
2054: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2050: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2051: itemkey => itemkey,
2052: aname => 'AMS_BUDGET_APPR_FLAG',
2053: avalue => 'Y');
2054: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2055: itemkey => itemkey,
2056: aname => 'AMS_TAOWNER_APPR_FLAG',
2057: avalue => 'N');
2058: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2054: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2055: itemkey => itemkey,
2056: aname => 'AMS_TAOWNER_APPR_FLAG',
2057: avalue => 'N');
2058: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2059: itemkey => itemkey,
2060: aname => 'AMS_BAOWNER_APPR_FLAG',
2061: avalue => 'N');
2062: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2058: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2059: itemkey => itemkey,
2060: aname => 'AMS_BAOWNER_APPR_FLAG',
2061: avalue => 'N');
2062: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2063: itemkey => itemkey,
2064: aname => 'AMS_THEME_APPR_FLAG',
2065: avalue => 'Y');
2066: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2062: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2063: itemkey => itemkey,
2064: aname => 'AMS_THEME_APPR_FLAG',
2065: avalue => 'Y');
2066: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2067: itemkey => itemkey,
2068: aname => 'AMS_APPR_DOC_TYPE',
2069: avalue => 'BOTH');-- Changed on
2070: -- 29Jan from THEME by PTENDULK as Manager will receive Notification for Both Approvals

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

2071: END IF;
2072: ELSE
2073: --(l_requester <> l_owner AND l_requester = l_fund_manager)
2074: IF l_owner = l_manager THEN --(Condi: 5)
2075: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2076: itemkey => itemkey,
2077: aname => 'AMS_BUDGET_APPR_FLAG',
2078: avalue => 'N');
2079: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2075: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2076: itemkey => itemkey,
2077: aname => 'AMS_BUDGET_APPR_FLAG',
2078: avalue => 'N');
2079: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2080: itemkey => itemkey,
2081: aname => 'AMS_TAOWNER_APPR_FLAG',
2082: avalue => 'N');
2083: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2079: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2080: itemkey => itemkey,
2081: aname => 'AMS_TAOWNER_APPR_FLAG',
2082: avalue => 'N');
2083: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2084: itemkey => itemkey,
2085: aname => 'AMS_BAOWNER_APPR_FLAG',
2086: avalue => 'N');
2087: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2083: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2084: itemkey => itemkey,
2085: aname => 'AMS_BAOWNER_APPR_FLAG',
2086: avalue => 'N');
2087: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2088: itemkey => itemkey,
2089: aname => 'AMS_THEME_APPR_FLAG',
2090: avalue => 'Y');
2091: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2087: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2088: itemkey => itemkey,
2089: aname => 'AMS_THEME_APPR_FLAG',
2090: avalue => 'Y');
2091: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2092: itemkey => itemkey,
2093: aname => 'AMS_APPR_DOC_TYPE',
2094: avalue => 'BOTH');-- Changed on
2095: -- 29Jan from THEME by PTENDULK as Manager will receive Notification for Both Approvals

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

2093: aname => 'AMS_APPR_DOC_TYPE',
2094: avalue => 'BOTH');-- Changed on
2095: -- 29Jan from THEME by PTENDULK as Manager will receive Notification for Both Approvals
2096: ELSE --(Condi: 6)
2097: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2098: itemkey => itemkey,
2099: aname => 'AMS_BUDGET_APPR_FLAG',
2100: avalue => 'N');
2101: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2097: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2098: itemkey => itemkey,
2099: aname => 'AMS_BUDGET_APPR_FLAG',
2100: avalue => 'N');
2101: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2102: itemkey => itemkey,
2103: aname => 'AMS_TAOWNER_APPR_FLAG',
2104: avalue => 'Y');
2105: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2101: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2102: itemkey => itemkey,
2103: aname => 'AMS_TAOWNER_APPR_FLAG',
2104: avalue => 'Y');
2105: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2106: itemkey => itemkey,
2107: aname => 'AMS_BAOWNER_APPR_FLAG',
2108: avalue => 'N');
2109: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2105: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2106: itemkey => itemkey,
2107: aname => 'AMS_BAOWNER_APPR_FLAG',
2108: avalue => 'N');
2109: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2110: itemkey => itemkey,
2111: aname => 'AMS_THEME_APPR_FLAG',
2112: avalue => 'Y');
2113: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2109: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2110: itemkey => itemkey,
2111: aname => 'AMS_THEME_APPR_FLAG',
2112: avalue => 'Y');
2113: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2114: itemkey => itemkey,
2115: aname => 'AMS_APPR_DOC_TYPE',
2116: avalue => 'BOTH'); -- Changed on
2117: -- 29Jan from THEME by PTENDULK as Manager will receive Notification for Both Approvals

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

2124: THEN
2125: IF (l_owner = l_manager AND
2126: l_manager = l_fund_manager)
2127: THEN --(Condi: 7)
2128: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2129: itemkey => itemkey,
2130: aname => 'AMS_BUDGET_APPR_FLAG',
2131: avalue => 'N');
2132: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2128: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2129: itemkey => itemkey,
2130: aname => 'AMS_BUDGET_APPR_FLAG',
2131: avalue => 'N');
2132: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2133: itemkey => itemkey,
2134: aname => 'AMS_TAOWNER_APPR_FLAG',
2135: avalue => 'N');
2136: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2132: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2133: itemkey => itemkey,
2134: aname => 'AMS_TAOWNER_APPR_FLAG',
2135: avalue => 'N');
2136: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2137: itemkey => itemkey,
2138: aname => 'AMS_BAOWNER_APPR_FLAG',
2139: avalue => 'N');
2140: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2136: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2137: itemkey => itemkey,
2138: aname => 'AMS_BAOWNER_APPR_FLAG',
2139: avalue => 'N');
2140: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2141: itemkey => itemkey,
2142: aname => 'AMS_THEME_APPR_FLAG',
2143: avalue => 'Y');
2144: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2140: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2141: itemkey => itemkey,
2142: aname => 'AMS_THEME_APPR_FLAG',
2143: avalue => 'Y');
2144: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2145: itemkey => itemkey,
2146: aname => 'AMS_APPR_DOC_TYPE',
2147: avalue => 'BOTH');
2148:

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

2148:
2149: ELSIF (l_owner = l_manager AND
2150: l_owner <> l_fund_manager)
2151: THEN --(Condi: 8)
2152: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2153: itemkey => itemkey,
2154: aname => 'AMS_BUDGET_APPR_FLAG',
2155: avalue => 'Y');
2156: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2152: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2153: itemkey => itemkey,
2154: aname => 'AMS_BUDGET_APPR_FLAG',
2155: avalue => 'Y');
2156: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2157: itemkey => itemkey,
2158: aname => 'AMS_TAOWNER_APPR_FLAG',
2159: avalue => 'N');
2160: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2156: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2157: itemkey => itemkey,
2158: aname => 'AMS_TAOWNER_APPR_FLAG',
2159: avalue => 'N');
2160: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2161: itemkey => itemkey,
2162: aname => 'AMS_BAOWNER_APPR_FLAG',
2163: avalue => 'N');
2164: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2160: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2161: itemkey => itemkey,
2162: aname => 'AMS_BAOWNER_APPR_FLAG',
2163: avalue => 'N');
2164: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2165: itemkey => itemkey,
2166: aname => 'AMS_THEME_APPR_FLAG',
2167: avalue => 'Y');
2168: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2164: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2165: itemkey => itemkey,
2166: aname => 'AMS_THEME_APPR_FLAG',
2167: avalue => 'Y');
2168: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2169: itemkey => itemkey,
2170: aname => 'AMS_APPR_DOC_TYPE',
2171: avalue => 'BOTH');
2172:

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

2171: avalue => 'BOTH');
2172:
2173: ELSE --(Condi: 9)
2174: -- (l_owner <> l_manager AND l_owner = l_fund_manager)
2175: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2176: itemkey => itemkey,
2177: aname => 'AMS_BUDGET_APPR_FLAG',
2178: avalue => 'N');
2179: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2175: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2176: itemkey => itemkey,
2177: aname => 'AMS_BUDGET_APPR_FLAG',
2178: avalue => 'N');
2179: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2180: itemkey => itemkey,
2181: aname => 'AMS_TAOWNER_APPR_FLAG',
2182: avalue => 'Y');
2183: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2179: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2180: itemkey => itemkey,
2181: aname => 'AMS_TAOWNER_APPR_FLAG',
2182: avalue => 'Y');
2183: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2184: itemkey => itemkey,
2185: aname => 'AMS_BAOWNER_APPR_FLAG',
2186: avalue => 'N');
2187: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2183: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2184: itemkey => itemkey,
2185: aname => 'AMS_BAOWNER_APPR_FLAG',
2186: avalue => 'N');
2187: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2188: itemkey => itemkey,
2189: aname => 'AMS_THEME_APPR_FLAG',
2190: avalue => 'Y');
2191: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2187: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2188: itemkey => itemkey,
2189: aname => 'AMS_THEME_APPR_FLAG',
2190: avalue => 'Y');
2191: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2192: itemkey => itemkey,
2193: aname => 'AMS_APPR_DOC_TYPE',
2194: avalue => 'BOTH');
2195: END IF;

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

2195: END IF;
2196: ELSE
2197: IF l_manager = l_fund_manager
2198: THEN --(Condi: 10)
2199: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2200: itemkey => itemkey,
2201: aname => 'AMS_BUDGET_APPR_FLAG',
2202: avalue => 'N');
2203: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2199: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2200: itemkey => itemkey,
2201: aname => 'AMS_BUDGET_APPR_FLAG',
2202: avalue => 'N');
2203: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2204: itemkey => itemkey,
2205: aname => 'AMS_TAOWNER_APPR_FLAG',
2206: avalue => 'Y');
2207: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2203: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2204: itemkey => itemkey,
2205: aname => 'AMS_TAOWNER_APPR_FLAG',
2206: avalue => 'Y');
2207: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2208: itemkey => itemkey,
2209: aname => 'AMS_BAOWNER_APPR_FLAG',
2210: avalue => 'N');
2211: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2207: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2208: itemkey => itemkey,
2209: aname => 'AMS_BAOWNER_APPR_FLAG',
2210: avalue => 'N');
2211: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2212: itemkey => itemkey,
2213: aname => 'AMS_THEME_APPR_FLAG',
2214: avalue => 'Y');
2215: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2211: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2212: itemkey => itemkey,
2213: aname => 'AMS_THEME_APPR_FLAG',
2214: avalue => 'Y');
2215: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2216: itemkey => itemkey,
2217: aname => 'AMS_APPR_DOC_TYPE',
2218: avalue => 'BOTH');
2219: ELSE -- (requester<> owner<> manager<> fund_manager) (Condi 11)

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

2216: itemkey => itemkey,
2217: aname => 'AMS_APPR_DOC_TYPE',
2218: avalue => 'BOTH');
2219: ELSE -- (requester<> owner<> manager<> fund_manager) (Condi 11)
2220: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2221: itemkey => itemkey,
2222: aname => 'AMS_BUDGET_APPR_FLAG',
2223: avalue => 'Y');
2224: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2220: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2221: itemkey => itemkey,
2222: aname => 'AMS_BUDGET_APPR_FLAG',
2223: avalue => 'Y');
2224: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2225: itemkey => itemkey,
2226: aname => 'AMS_TAOWNER_APPR_FLAG',
2227: avalue => 'Y');
2228: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2224: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2225: itemkey => itemkey,
2226: aname => 'AMS_TAOWNER_APPR_FLAG',
2227: avalue => 'Y');
2228: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2229: itemkey => itemkey,
2230: aname => 'AMS_BAOWNER_APPR_FLAG',
2231: avalue => 'N');
2232: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2228: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2229: itemkey => itemkey,
2230: aname => 'AMS_BAOWNER_APPR_FLAG',
2231: avalue => 'N');
2232: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2233: itemkey => itemkey,
2234: aname => 'AMS_THEME_APPR_FLAG',
2235: avalue => 'Y');
2236: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2232: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2233: itemkey => itemkey,
2234: aname => 'AMS_THEME_APPR_FLAG',
2235: avalue => 'Y');
2236: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2237: itemkey => itemkey,
2238: aname => 'AMS_APPR_DOC_TYPE',
2239: avalue => 'BOTH');
2240: END IF ;

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

2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2266: END IF;
2267: l_err_msg := FND_MESSAGE.Get;
2268:
2269: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2270: itemkey => itemkey,
2271: aname => 'AMS_ERROR_MSG',
2272: avalue => l_err_msg);
2273:

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

2276: -- Check if all the Approvers are same
2277: IF l_requester = l_owner AND
2278: l_requester = l_fund_manager
2279: THEN -- Condi : 12
2280: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2281: itemkey => itemkey,
2282: aname => 'AMS_APPR_REQ_CHECK',
2283: avalue => 'N' );
2284: -- dbms_output.put_line('All Appr Same : '||l_fund_manager);

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

2299: END IF;
2300:
2301: IF (l_requester = l_owner ) AND (l_requester <> l_fund_manager )
2302: THEN -- Condi : 13
2303: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2304: itemkey => itemkey,
2305: aname => 'AMS_APPR_USERNAME',
2306: avalue => l_fund_manager);
2307:

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

2304: itemkey => itemkey,
2305: aname => 'AMS_APPR_USERNAME',
2306: avalue => l_fund_manager);
2307:
2308: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2309: itemkey => itemkey,
2310: aname => 'AMS_BUDGET_APPR_FLAG',
2311: avalue => 'Y');
2312: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2308: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2309: itemkey => itemkey,
2310: aname => 'AMS_BUDGET_APPR_FLAG',
2311: avalue => 'Y');
2312: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2313: itemkey => itemkey,
2314: aname => 'AMS_TAOWNER_APPR_FLAG',
2315: avalue => 'N');
2316: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2312: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2313: itemkey => itemkey,
2314: aname => 'AMS_TAOWNER_APPR_FLAG',
2315: avalue => 'N');
2316: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2317: itemkey => itemkey,
2318: aname => 'AMS_BAOWNER_APPR_FLAG',
2319: avalue => 'N');
2320: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2316: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2317: itemkey => itemkey,
2318: aname => 'AMS_BAOWNER_APPR_FLAG',
2319: avalue => 'N');
2320: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2321: itemkey => itemkey,
2322: aname => 'AMS_THEME_APPR_FLAG',
2323: avalue => 'N');
2324: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2320: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2321: itemkey => itemkey,
2322: aname => 'AMS_THEME_APPR_FLAG',
2323: avalue => 'N');
2324: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2325: itemkey => itemkey,
2326: aname => 'AMS_APPR_DOC_TYPE',
2327: avalue => 'BUDGET');
2328: ELSIF (l_requester = l_fund_manager) AND (l_requester <> l_owner )

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

2326: aname => 'AMS_APPR_DOC_TYPE',
2327: avalue => 'BUDGET');
2328: ELSIF (l_requester = l_fund_manager) AND (l_requester <> l_owner )
2329: THEN -- Condi : 14
2330: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2331: itemkey => itemkey,
2332: aname => 'AMS_APPR_USERNAME',
2333: avalue => l_owner);
2334:

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

2331: itemkey => itemkey,
2332: aname => 'AMS_APPR_USERNAME',
2333: avalue => l_owner);
2334:
2335: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2336: itemkey => itemkey,
2337: aname => 'AMS_BUDGET_APPR_FLAG',
2338: avalue => 'Y');
2339: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2335: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2336: itemkey => itemkey,
2337: aname => 'AMS_BUDGET_APPR_FLAG',
2338: avalue => 'Y');
2339: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2340: itemkey => itemkey,
2341: aname => 'AMS_TAOWNER_APPR_FLAG',
2342: avalue => 'N');
2343: -- Here Budget Approval is not required from Owner as it is already taken (Requester = Fund Manager)

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

2340: itemkey => itemkey,
2341: aname => 'AMS_TAOWNER_APPR_FLAG',
2342: avalue => 'N');
2343: -- Here Budget Approval is not required from Owner as it is already taken (Requester = Fund Manager)
2344: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2345: itemkey => itemkey,
2346: aname => 'AMS_BAOWNER_APPR_FLAG',
2347: avalue => 'N');
2348: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2344: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2345: itemkey => itemkey,
2346: aname => 'AMS_BAOWNER_APPR_FLAG',
2347: avalue => 'N');
2348: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2349: itemkey => itemkey,
2350: aname => 'AMS_THEME_APPR_FLAG',
2351: avalue => 'N');
2352: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2348: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2349: itemkey => itemkey,
2350: aname => 'AMS_THEME_APPR_FLAG',
2351: avalue => 'N');
2352: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2353: itemkey => itemkey,
2354: aname => 'AMS_APPR_DOC_TYPE',
2355: avalue => 'BUDGET');
2356: ELSE

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

2356: ELSE
2357: -- dbms_output.put_line('All Appr No Same : '||l_fund_manager);
2358: --(l_requester <> l_fund_manager) AND (l_requester <> l_owner)
2359: IF l_owner = l_fund_manager THEN -- Condi : 15
2360: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2361: itemkey => itemkey,
2362: aname => 'AMS_APPR_USERNAME',
2363: avalue => l_owner);
2364:

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

2361: itemkey => itemkey,
2362: aname => 'AMS_APPR_USERNAME',
2363: avalue => l_owner);
2364:
2365: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2366: itemkey => itemkey,
2367: aname => 'AMS_BUDGET_APPR_FLAG',
2368: avalue => 'Y');
2369: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2365: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2366: itemkey => itemkey,
2367: aname => 'AMS_BUDGET_APPR_FLAG',
2368: avalue => 'Y');
2369: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2370: itemkey => itemkey,
2371: aname => 'AMS_TAOWNER_APPR_FLAG',
2372: avalue => 'N');
2373: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2369: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2370: itemkey => itemkey,
2371: aname => 'AMS_TAOWNER_APPR_FLAG',
2372: avalue => 'N');
2373: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2374: itemkey => itemkey,
2375: aname => 'AMS_BAOWNER_APPR_FLAG',
2376: avalue => 'N');
2377: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2373: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2374: itemkey => itemkey,
2375: aname => 'AMS_BAOWNER_APPR_FLAG',
2376: avalue => 'N');
2377: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2378: itemkey => itemkey,
2379: aname => 'AMS_THEME_APPR_FLAG',
2380: avalue => 'N');
2381: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2377: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2378: itemkey => itemkey,
2379: aname => 'AMS_THEME_APPR_FLAG',
2380: avalue => 'N');
2381: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2382: itemkey => itemkey,
2383: aname => 'AMS_APPR_DOC_TYPE',
2384: avalue => 'BUDGET');
2385: ELSE -- Condi : 16

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

2382: itemkey => itemkey,
2383: aname => 'AMS_APPR_DOC_TYPE',
2384: avalue => 'BUDGET');
2385: ELSE -- Condi : 16
2386: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2387: itemkey => itemkey,
2388: aname => 'AMS_APPR_USERNAME',
2389: avalue => l_fund_manager);
2390:

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

2387: itemkey => itemkey,
2388: aname => 'AMS_APPR_USERNAME',
2389: avalue => l_fund_manager);
2390:
2391: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2392: itemkey => itemkey,
2393: aname => 'AMS_BUDGET_APPR_FLAG',
2394: avalue => 'Y');
2395: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2391: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2392: itemkey => itemkey,
2393: aname => 'AMS_BUDGET_APPR_FLAG',
2394: avalue => 'Y');
2395: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2396: itemkey => itemkey,
2397: aname => 'AMS_TAOWNER_APPR_FLAG',
2398: avalue => 'N');
2399: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2395: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2396: itemkey => itemkey,
2397: aname => 'AMS_TAOWNER_APPR_FLAG',
2398: avalue => 'N');
2399: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2400: itemkey => itemkey,
2401: aname => 'AMS_BAOWNER_APPR_FLAG',
2402: avalue => 'Y');
2403: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2399: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2400: itemkey => itemkey,
2401: aname => 'AMS_BAOWNER_APPR_FLAG',
2402: avalue => 'Y');
2403: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2404: itemkey => itemkey,
2405: aname => 'AMS_THEME_APPR_FLAG',
2406: avalue => 'N');
2407: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2403: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2404: itemkey => itemkey,
2405: aname => 'AMS_THEME_APPR_FLAG',
2406: avalue => 'N');
2407: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2408: itemkey => itemkey,
2409: aname => 'AMS_APPR_DOC_TYPE',
2410: avalue => 'BUDGET');
2411: END IF;

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

2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2428: END IF;
2429: l_err_msg := FND_MESSAGE.Get;
2430:
2431: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2432: itemkey => itemkey,
2433: aname => 'AMS_ERROR_MSG',
2434: avalue => l_err_msg);
2435:

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

2451: -- Check if all the Approvers are same
2452: IF l_requester = l_owner AND
2453: l_requester = l_manager
2454: THEN -- Condi : 17
2455: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2456: itemkey => itemkey,
2457: aname => 'AMS_APPR_REQ_CHECK',
2458: avalue => 'N' );
2459:

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

2462: -- dbms_output.put_line('Theme All Approvals same');
2463: ELSE
2464: IF (l_requester = l_owner )
2465: THEN -- Condi : 18
2466: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2467: itemkey => itemkey,
2468: aname => 'AMS_APPR_USERNAME',
2469: avalue => l_manager);
2470:

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

2467: itemkey => itemkey,
2468: aname => 'AMS_APPR_USERNAME',
2469: avalue => l_manager);
2470:
2471: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2472: itemkey => itemkey,
2473: aname => 'AMS_BUDGET_APPR_FLAG',
2474: avalue => 'N');
2475: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2471: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2472: itemkey => itemkey,
2473: aname => 'AMS_BUDGET_APPR_FLAG',
2474: avalue => 'N');
2475: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2476: itemkey => itemkey,
2477: aname => 'AMS_TAOWNER_APPR_FLAG',
2478: avalue => 'N');
2479: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2475: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2476: itemkey => itemkey,
2477: aname => 'AMS_TAOWNER_APPR_FLAG',
2478: avalue => 'N');
2479: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2480: itemkey => itemkey,
2481: aname => 'AMS_BAOWNER_APPR_FLAG',
2482: avalue => 'N');
2483: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2479: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2480: itemkey => itemkey,
2481: aname => 'AMS_BAOWNER_APPR_FLAG',
2482: avalue => 'N');
2483: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2484: itemkey => itemkey,
2485: aname => 'AMS_THEME_APPR_FLAG',
2486: avalue => 'Y');
2487: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2483: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2484: itemkey => itemkey,
2485: aname => 'AMS_THEME_APPR_FLAG',
2486: avalue => 'Y');
2487: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2488: itemkey => itemkey,
2489: aname => 'AMS_APPR_DOC_TYPE',
2490: avalue => 'THEME');
2491: ELSE --(l_requester <> l_owner)

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

2489: aname => 'AMS_APPR_DOC_TYPE',
2490: avalue => 'THEME');
2491: ELSE --(l_requester <> l_owner)
2492: IF l_owner = l_fund_manager THEN -- Condi : 19
2493: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2494: itemkey => itemkey,
2495: aname => 'AMS_APPR_USERNAME',
2496: avalue => l_owner);
2497:

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

2494: itemkey => itemkey,
2495: aname => 'AMS_APPR_USERNAME',
2496: avalue => l_owner);
2497:
2498: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2499: itemkey => itemkey,
2500: aname => 'AMS_BUDGET_APPR_FLAG',
2501: avalue => 'N');
2502: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2498: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2499: itemkey => itemkey,
2500: aname => 'AMS_BUDGET_APPR_FLAG',
2501: avalue => 'N');
2502: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2503: itemkey => itemkey,
2504: aname => 'AMS_TAOWNER_APPR_FLAG',
2505: avalue => 'N');
2506: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2502: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2503: itemkey => itemkey,
2504: aname => 'AMS_TAOWNER_APPR_FLAG',
2505: avalue => 'N');
2506: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2507: itemkey => itemkey,
2508: aname => 'AMS_BAOWNER_APPR_FLAG',
2509: avalue => 'N');
2510: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2506: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2507: itemkey => itemkey,
2508: aname => 'AMS_BAOWNER_APPR_FLAG',
2509: avalue => 'N');
2510: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2511: itemkey => itemkey,
2512: aname => 'AMS_THEME_APPR_FLAG',
2513: avalue => 'Y');
2514: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2510: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2511: itemkey => itemkey,
2512: aname => 'AMS_THEME_APPR_FLAG',
2513: avalue => 'Y');
2514: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2515: itemkey => itemkey,
2516: aname => 'AMS_APPR_DOC_TYPE',
2517: avalue => 'THEME');
2518: ELSE -- (Condi 20)

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

2515: itemkey => itemkey,
2516: aname => 'AMS_APPR_DOC_TYPE',
2517: avalue => 'THEME');
2518: ELSE -- (Condi 20)
2519: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2520: itemkey => itemkey,
2521: aname => 'AMS_APPR_USERNAME',
2522: avalue => l_manager);
2523:

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

2520: itemkey => itemkey,
2521: aname => 'AMS_APPR_USERNAME',
2522: avalue => l_manager);
2523:
2524: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2525: itemkey => itemkey,
2526: aname => 'AMS_BUDGET_APPR_FLAG',
2527: avalue => 'N');
2528: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2524: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2525: itemkey => itemkey,
2526: aname => 'AMS_BUDGET_APPR_FLAG',
2527: avalue => 'N');
2528: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2529: itemkey => itemkey,
2530: aname => 'AMS_TAOWNER_APPR_FLAG',
2531: avalue => 'Y');
2532: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2528: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2529: itemkey => itemkey,
2530: aname => 'AMS_TAOWNER_APPR_FLAG',
2531: avalue => 'Y');
2532: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2533: itemkey => itemkey,
2534: aname => 'AMS_BAOWNER_APPR_FLAG',
2535: avalue => 'N');
2536: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2532: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2533: itemkey => itemkey,
2534: aname => 'AMS_BAOWNER_APPR_FLAG',
2535: avalue => 'N');
2536: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2537: itemkey => itemkey,
2538: aname => 'AMS_THEME_APPR_FLAG',
2539: avalue => 'Y');
2540: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

2536: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2537: itemkey => itemkey,
2538: aname => 'AMS_THEME_APPR_FLAG',
2539: avalue => 'Y');
2540: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2541: itemkey => itemkey,
2542: aname => 'AMS_APPR_DOC_TYPE',
2543: avalue => 'THEME');
2544: END IF;

Line 2622: l_appr_flag := WF_ENGINE.GetItemAttrText(

2618: -- dbms_output.put_line('Process Appr_Required_Check');
2619: -- RUN mode - Normal Process Execution
2620: IF (funcmode = 'RUN')
2621: THEN
2622: l_appr_flag := WF_ENGINE.GetItemAttrText(
2623: itemtype => itemtype,
2624: itemkey => itemkey ,
2625: aname => 'AMS_APPR_REQ_CHECK');
2626: IF l_appr_flag = 'Y' THEN

Line 2718: l_obj_type := wf_engine.GetItemAttrText(

2714: -- RUN mode - Normal Process Execution
2715: IF (funcmode = 'RUN')
2716: THEN
2717:
2718: l_obj_type := wf_engine.GetItemAttrText(
2719: itemtype => ItemType,
2720: itemkey => ItemKey,
2721: aname => 'AMS_APPROVAL_FOR_OBJECT');
2722:

Line 2723: l_obj_id := wf_engine.GetItemAttrText(

2719: itemtype => ItemType,
2720: itemkey => ItemKey,
2721: aname => 'AMS_APPROVAL_FOR_OBJECT');
2722:
2723: l_obj_id := wf_engine.GetItemAttrText(
2724: itemtype => ItemType,
2725: itemkey => ItemKey,
2726: aname => 'AMS_ACT_ID');
2727: l_obj_version_number := wf_engine.GetItemAttrText(

Line 2727: l_obj_version_number := wf_engine.GetItemAttrText(

2723: l_obj_id := wf_engine.GetItemAttrText(
2724: itemtype => ItemType,
2725: itemkey => ItemKey,
2726: aname => 'AMS_ACT_ID');
2727: l_obj_version_number := wf_engine.GetItemAttrText(
2728: itemtype => ItemType,
2729: itemkey => ItemKey,
2730: aname => 'AMS_OBJECT_VERSION_NUMBER');
2731: l_next_stat_id := wf_engine.GetItemAttrText(

Line 2731: l_next_stat_id := wf_engine.GetItemAttrText(

2727: l_obj_version_number := wf_engine.GetItemAttrText(
2728: itemtype => ItemType,
2729: itemkey => ItemKey,
2730: aname => 'AMS_OBJECT_VERSION_NUMBER');
2731: l_next_stat_id := wf_engine.GetItemAttrText(
2732: itemtype => ItemType,
2733: itemkey => ItemKey,
2734: aname => 'AMS_NEW_STAT_ID');
2735:

Line 2736: l_requester_id := wf_engine.GetItemAttrText(

2732: itemtype => ItemType,
2733: itemkey => ItemKey,
2734: aname => 'AMS_NEW_STAT_ID');
2735:
2736: l_requester_id := wf_engine.GetItemAttrText(
2737: itemtype => ItemType,
2738: itemkey => ItemKey,
2739: aname => 'AMS_REQUESTER_ID');
2740:

Line 2836: l_theme_appr_flag := WF_ENGINE.GetItemAttrText(

2832: -- dbms_output.put_line('Process Fund_Appr_Req_Check');
2833: -- RUN mode - Normal Process Execution
2834: IF (funcmode = 'RUN')
2835: THEN
2836: l_theme_appr_flag := WF_ENGINE.GetItemAttrText(
2837: itemtype => itemtype,
2838: itemkey => itemkey ,
2839: aname => 'AMS_THEME_APPR_FLAG');
2840: IF l_theme_appr_flag = 'Y' THEN

Line 3074: l_approval_for := wf_engine.GetItemAttrText(

3070: ItemType := nvl(substr(document_id, 1, instr(document_id,':')-1),'AMSAPPR');
3071: ItemKey := substr(document_id
3072: , instr(document_id,':')+1);
3073:
3074: l_approval_for := wf_engine.GetItemAttrText(
3075: itemtype => ItemType,
3076: itemkey => ItemKey,
3077: aname => 'AMS_APPROVAL_FOR_OBJECT');
3078:

Line 3079: l_approval_for_id := wf_engine.GetItemAttrText(

3075: itemtype => ItemType,
3076: itemkey => ItemKey,
3077: aname => 'AMS_APPROVAL_FOR_OBJECT');
3078:
3079: l_approval_for_id := wf_engine.GetItemAttrText(
3080: itemtype => ItemType,
3081: itemkey => ItemKey,
3082: aname => 'AMS_ACT_ID');
3083:

Line 3084: l_requester := wf_engine.GetItemAttrText(

3080: itemtype => ItemType,
3081: itemkey => ItemKey,
3082: aname => 'AMS_ACT_ID');
3083:
3084: l_requester := wf_engine.GetItemAttrText(
3085: itemtype => ItemType,
3086: itemkey => ItemKey,
3087: aname => 'AMS_REQUESTER');
3088:

Line 3089: l_requester_note := wf_engine.GetItemAttrText(

3085: itemtype => ItemType,
3086: itemkey => ItemKey,
3087: aname => 'AMS_REQUESTER');
3088:
3089: l_requester_note := wf_engine.GetItemAttrText(
3090: itemtype => ItemType,
3091: itemkey => ItemKey,
3092: aname => 'AMS_NOTES_FROM_REQUESTER');
3093:

Line 3095: l_doc_type := wf_engine.GetItemAttrText(

3091: itemkey => ItemKey,
3092: aname => 'AMS_NOTES_FROM_REQUESTER');
3093:
3094: -- dbms_output.Put_line('Requester Note : '||l_requester_note );
3095: l_doc_type := wf_engine.GetItemAttrText(
3096: itemtype => ItemType,
3097: itemkey => ItemKey,
3098: aname => 'AMS_APPR_DOC_TYPE');
3099:

Line 3100: l_approval_type := wf_engine.GetItemAttrText(

3096: itemtype => ItemType,
3097: itemkey => ItemKey,
3098: aname => 'AMS_APPR_DOC_TYPE');
3099:
3100: l_approval_type := wf_engine.GetItemAttrText(
3101: itemtype => ItemType,
3102: itemkey => ItemKey,
3103: aname => 'AMS_APPROVAL_TYPE');
3104:

Line 3105: l_activity_name := WF_ENGINE.GetItemAttrText

3101: itemtype => ItemType,
3102: itemkey => ItemKey,
3103: aname => 'AMS_APPROVAL_TYPE');
3104:
3105: l_activity_name := WF_ENGINE.GetItemAttrText
3106: (itemtype => itemtype ,
3107: itemkey => itemkey,
3108: aname => 'AMS_ACT_NAME' );
3109:

Line 3110: l_start_dt := WF_ENGINE.GetItemAttrText

3106: (itemtype => itemtype ,
3107: itemkey => itemkey,
3108: aname => 'AMS_ACT_NAME' );
3109:
3110: l_start_dt := WF_ENGINE.GetItemAttrText
3111: (itemtype => itemtype,
3112: itemkey => itemkey ,
3113: aname => 'AMS_ACT_START_DATE');
3114:

Line 3115: l_end_dt := WF_ENGINE.GetItemAttrText

3111: (itemtype => itemtype,
3112: itemkey => itemkey ,
3113: aname => 'AMS_ACT_START_DATE');
3114:
3115: l_end_dt := WF_ENGINE.GetItemAttrText
3116: (itemtype => itemtype,
3117: itemkey => itemkey ,
3118: aname => 'AMS_ACT_END_DATE' );
3119:

Line 3120: l_budget_amount := WF_ENGINE.GetItemAttrText

3116: (itemtype => itemtype,
3117: itemkey => itemkey ,
3118: aname => 'AMS_ACT_END_DATE' );
3119:
3120: l_budget_amount := WF_ENGINE.GetItemAttrText
3121: (itemtype => itemtype ,
3122: itemkey => itemkey,
3123: aname => 'AMS_BUDGET_AMOUNT');
3124: l_desc := WF_ENGINE.GetItemAttrText

Line 3124: l_desc := WF_ENGINE.GetItemAttrText

3120: l_budget_amount := WF_ENGINE.GetItemAttrText
3121: (itemtype => itemtype ,
3122: itemkey => itemkey,
3123: aname => 'AMS_BUDGET_AMOUNT');
3124: l_desc := WF_ENGINE.GetItemAttrText
3125: (itemtype => itemtype,
3126: itemkey => itemkey ,
3127: aname => 'AMS_ACT_DESC');
3128: l_currency := WF_ENGINE.GetItemAttrText

Line 3128: l_currency := WF_ENGINE.GetItemAttrText

3124: l_desc := WF_ENGINE.GetItemAttrText
3125: (itemtype => itemtype,
3126: itemkey => itemkey ,
3127: aname => 'AMS_ACT_DESC');
3128: l_currency := WF_ENGINE.GetItemAttrText
3129: (itemtype => itemtype ,
3130: itemkey => itemkey,
3131: aname => 'AMS_CURRENCY');
3132:

Line 3170: l_camp_theme := WF_ENGINE.GetItemAttrText

3166: FETCH c_camp_owner INTO l_owner ;
3167: CLOSE c_camp_owner ;
3168:
3169:
3170: l_camp_theme := WF_ENGINE.GetItemAttrText
3171: (itemtype => itemtype ,
3172: itemkey => itemkey,
3173: aname => 'AMS_CAMP_THEME');
3174: l_camp_mkt := WF_ENGINE.GetItemAttrText

Line 3174: l_camp_mkt := WF_ENGINE.GetItemAttrText

3170: l_camp_theme := WF_ENGINE.GetItemAttrText
3171: (itemtype => itemtype ,
3172: itemkey => itemkey,
3173: aname => 'AMS_CAMP_THEME');
3174: l_camp_mkt := WF_ENGINE.GetItemAttrText
3175: (itemtype => itemtype,
3176: itemkey => itemkey ,
3177: aname => 'AMS_CAMP_MARKET');
3178: l_camp_geo := WF_ENGINE.GetItemAttrText

Line 3178: l_camp_geo := WF_ENGINE.GetItemAttrText

3174: l_camp_mkt := WF_ENGINE.GetItemAttrText
3175: (itemtype => itemtype,
3176: itemkey => itemkey ,
3177: aname => 'AMS_CAMP_MARKET');
3178: l_camp_geo := WF_ENGINE.GetItemAttrText
3179: (itemtype => itemtype ,
3180: itemkey => itemkey,
3181: aname => 'AMS_CAMP_GEO');
3182:

Line 3238: l_deli_mkt_msg := WF_ENGINE.GetItemAttrText

3234: l_message := FND_MESSAGE.Get;
3235:
3236: END IF;
3237: ELSIF l_approval_for = 'DELV' THEN
3238: l_deli_mkt_msg := WF_ENGINE.GetItemAttrText
3239: (itemtype => itemtype,
3240: itemkey => itemkey ,
3241: aname => 'AMS_DELI_MKT_MESSAGE');
3242:

Line 3243: l_deli_language := WF_ENGINE.GetItemAttrText

3239: (itemtype => itemtype,
3240: itemkey => itemkey ,
3241: aname => 'AMS_DELI_MKT_MESSAGE');
3242:
3243: l_deli_language := WF_ENGINE.GetItemAttrText
3244: (itemtype => itemtype,
3245: itemkey => itemkey ,
3246: aname => 'AMS_DELI_LANGUAGE' );
3247:

Line 3289: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText

3285: l_message := FND_MESSAGE.Get;
3286:
3287: END IF;
3288: ELSIF l_approval_for = 'EVEH' THEN
3289: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText
3290: (itemtype => itemtype,
3291: itemkey => itemkey ,
3292: aname => 'AMS_EVE_MKT_MESSAGE');
3293: OPEN c_eveh_owner(l_approval_for_id) ;

Line 3340: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText

3336:
3337: END IF;
3338: ELSIF l_approval_for = 'EVEO' THEN
3339:
3340: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText
3341: (itemtype => itemtype,
3342: itemkey => itemkey ,
3343: aname => 'AMS_EVE_MKT_MESSAGE');
3344: OPEN c_eveo_owner(l_approval_for_id) ;

Line 3579: l_approval_for := wf_engine.GetItemAttrText(

3575: IF (funcmode = 'RUN')
3576: THEN
3577: -- Create the Notification Document
3578:
3579: l_approval_for := wf_engine.GetItemAttrText(
3580: itemtype => ItemType,
3581: itemkey => ItemKey,
3582: aname => 'AMS_APPROVAL_FOR_OBJECT');
3583:

Line 3584: l_approval_for_id := wf_engine.GetItemAttrText(

3580: itemtype => ItemType,
3581: itemkey => ItemKey,
3582: aname => 'AMS_APPROVAL_FOR_OBJECT');
3583:
3584: l_approval_for_id := wf_engine.GetItemAttrText(
3585: itemtype => ItemType,
3586: itemkey => ItemKey,
3587: aname => 'AMS_ACT_ID');
3588:

Line 3589: l_requester := wf_engine.GetItemAttrText(

3585: itemtype => ItemType,
3586: itemkey => ItemKey,
3587: aname => 'AMS_ACT_ID');
3588:
3589: l_requester := wf_engine.GetItemAttrText(
3590: itemtype => ItemType,
3591: itemkey => ItemKey,
3592: aname => 'AMS_REQUESTER');
3593:

Line 3594: l_doc_type := wf_engine.GetItemAttrText(

3590: itemtype => ItemType,
3591: itemkey => ItemKey,
3592: aname => 'AMS_REQUESTER');
3593:
3594: l_doc_type := wf_engine.GetItemAttrText(
3595: itemtype => ItemType,
3596: itemkey => ItemKey,
3597: aname => 'AMS_APPR_DOC_TYPE');
3598:

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

3597: aname => 'AMS_APPR_DOC_TYPE');
3598:
3599: l_approval_type := Get_Lookup_Meaning('AMS_APPROVAL_TYPE',l_doc_type);
3600:
3601: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3602: itemkey => itemkey,
3603: aname => 'AMS_APPROVAL_TYPE',
3604: avalue => l_approval_type );
3605:

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

3609: x_timeout_days => l_timeout,
3610: x_priority => l_priority) ;
3611:
3612:
3613: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3614: itemkey => itemkey,
3615: aname => 'AMS_TIMEOUT',
3616: avalue => l_timeout );
3617:

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

3614: itemkey => itemkey,
3615: aname => 'AMS_TIMEOUT',
3616: avalue => l_timeout );
3617:
3618: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3619: itemkey => itemkey,
3620: aname => 'AMS_PRIORITY',
3621: avalue => l_priority );
3622:

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

3660: FETCH c_currency INTO l_currency ;
3661: CLOSE c_currency ;
3662:
3663:
3664: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3665: itemkey => itemkey,
3666: aname => 'AMS_ACT_NAME',
3667: avalue => l_activity_name );
3668: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3664: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3665: itemkey => itemkey,
3666: aname => 'AMS_ACT_NAME',
3667: avalue => l_activity_name );
3668: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3669: itemkey => itemkey ,
3670: aname => 'AMS_ACT_START_DATE',
3671: avalue => l_start_dt );
3672: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3668: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3669: itemkey => itemkey ,
3670: aname => 'AMS_ACT_START_DATE',
3671: avalue => l_start_dt );
3672: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3673: itemkey => itemkey ,
3674: aname => 'AMS_ACT_END_DATE',
3675: avalue => l_end_dt );
3676: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3672: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3673: itemkey => itemkey ,
3674: aname => 'AMS_ACT_END_DATE',
3675: avalue => l_end_dt );
3676: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3677: itemkey => itemkey,
3678: aname => 'AMS_CAMP_THEME',
3679: avalue => l_camp_theme );
3680:

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

3677: itemkey => itemkey,
3678: aname => 'AMS_CAMP_THEME',
3679: avalue => l_camp_theme );
3680:
3681: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3682: itemkey => itemkey ,
3683: aname => 'AMS_CAMP_MARKET',
3684: avalue => l_camp_mkt );
3685: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3681: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3682: itemkey => itemkey ,
3683: aname => 'AMS_CAMP_MARKET',
3684: avalue => l_camp_mkt );
3685: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3686: itemkey => itemkey,
3687: aname => 'AMS_CAMP_GEO',
3688: avalue => l_camp_geo );
3689: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3685: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3686: itemkey => itemkey,
3687: aname => 'AMS_CAMP_GEO',
3688: avalue => l_camp_geo );
3689: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3690: itemkey => itemkey,
3691: aname => 'AMS_BUDGET_AMOUNT',
3692: avalue => l_budget_amount );
3693: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3689: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3690: itemkey => itemkey,
3691: aname => 'AMS_BUDGET_AMOUNT',
3692: avalue => l_budget_amount );
3693: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3694: itemkey => itemkey ,
3695: aname => 'AMS_ACT_DESC',
3696: avalue => l_desc );
3697:

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

3694: itemkey => itemkey ,
3695: aname => 'AMS_ACT_DESC',
3696: avalue => l_desc );
3697:
3698: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3699: itemkey => itemkey,
3700: aname => 'AMS_CURRENCY',
3701: avalue => l_currency );
3702:

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

3710: OPEN c_currency(l_currency_code);
3711: FETCH c_currency INTO l_currency ;
3712: CLOSE c_currency ;
3713:
3714: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3715: itemkey => itemkey,
3716: aname => 'AMS_ACT_NAME',
3717: avalue => l_activity_name );
3718: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3714: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3715: itemkey => itemkey,
3716: aname => 'AMS_ACT_NAME',
3717: avalue => l_activity_name );
3718: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3719: itemkey => itemkey ,
3720: aname => 'AMS_ACT_START_DATE',
3721: avalue => l_start_dt );
3722: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3718: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3719: itemkey => itemkey ,
3720: aname => 'AMS_ACT_START_DATE',
3721: avalue => l_start_dt );
3722: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3723: itemkey => itemkey ,
3724: aname => 'AMS_ACT_END_DATE',
3725: avalue => l_end_dt );
3726: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3722: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3723: itemkey => itemkey ,
3724: aname => 'AMS_ACT_END_DATE',
3725: avalue => l_end_dt );
3726: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3727: itemkey => itemkey ,
3728: aname => 'AMS_DELI_LANGUAGE',
3729: avalue => l_deli_language );
3730: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3726: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3727: itemkey => itemkey ,
3728: aname => 'AMS_DELI_LANGUAGE',
3729: avalue => l_deli_language );
3730: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3731: itemkey => itemkey ,
3732: aname => 'AMS_ACT_DESC',
3733: avalue => l_desc );
3734: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3730: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3731: itemkey => itemkey ,
3732: aname => 'AMS_ACT_DESC',
3733: avalue => l_desc );
3734: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3735: itemkey => itemkey,
3736: aname => 'AMS_BUDGET_AMOUNT',
3737: avalue => l_budget_amount );
3738:

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

3735: itemkey => itemkey,
3736: aname => 'AMS_BUDGET_AMOUNT',
3737: avalue => l_budget_amount );
3738:
3739: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3740: itemkey => itemkey,
3741: aname => 'AMS_CURRENCY',
3742: avalue => l_currency );
3743: ELSIF l_approval_for = 'EVEH' THEN

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

3759: l_eve_mkt_msg := l_eve_mkt_msg ||', '||l_tmp_str ;
3760: END LOOP;
3761: CLOSE C_theme ;
3762:
3763: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3764: itemkey => itemkey,
3765: aname => 'AMS_ACT_NAME',
3766: avalue => l_activity_name );
3767: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3763: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3764: itemkey => itemkey,
3765: aname => 'AMS_ACT_NAME',
3766: avalue => l_activity_name );
3767: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3768: itemkey => itemkey ,
3769: aname => 'AMS_ACT_START_DATE',
3770: avalue => l_start_dt );
3771: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3767: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3768: itemkey => itemkey ,
3769: aname => 'AMS_ACT_START_DATE',
3770: avalue => l_start_dt );
3771: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3772: itemkey => itemkey ,
3773: aname => 'AMS_ACT_END_DATE',
3774: avalue => l_end_dt );
3775: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3771: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3772: itemkey => itemkey ,
3773: aname => 'AMS_ACT_END_DATE',
3774: avalue => l_end_dt );
3775: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3776: itemkey => itemkey ,
3777: aname => 'AMS_EVE_MKT_MESSAGE',
3778: avalue => l_eve_mkt_msg );
3779: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3775: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3776: itemkey => itemkey ,
3777: aname => 'AMS_EVE_MKT_MESSAGE',
3778: avalue => l_eve_mkt_msg );
3779: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3780: itemkey => itemkey,
3781: aname => 'AMS_BUDGET_AMOUNT',
3782: avalue => l_budget_amount );
3783: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3779: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3780: itemkey => itemkey,
3781: aname => 'AMS_BUDGET_AMOUNT',
3782: avalue => l_budget_amount );
3783: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3784: itemkey => itemkey ,
3785: aname => 'AMS_ACT_DESC',
3786: avalue => l_desc );
3787: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3783: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3784: itemkey => itemkey ,
3785: aname => 'AMS_ACT_DESC',
3786: avalue => l_desc );
3787: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3788: itemkey => itemkey,
3789: aname => 'AMS_CURRENCY',
3790: avalue => l_currency );
3791: ELSIF l_approval_for = 'EVEO' THEN

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

3808: l_eve_mkt_msg := l_eve_mkt_msg ||', '||l_tmp_str ;
3809: END LOOP;
3810: CLOSE C_theme ;
3811:
3812: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3813: itemkey => itemkey,
3814: aname => 'AMS_ACT_NAME',
3815: avalue => l_activity_name );
3816: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3812: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3813: itemkey => itemkey,
3814: aname => 'AMS_ACT_NAME',
3815: avalue => l_activity_name );
3816: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3817: itemkey => itemkey ,
3818: aname => 'AMS_ACT_START_DATE',
3819: avalue => l_start_dt );
3820: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3816: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3817: itemkey => itemkey ,
3818: aname => 'AMS_ACT_START_DATE',
3819: avalue => l_start_dt );
3820: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3821: itemkey => itemkey ,
3822: aname => 'AMS_ACT_END_DATE',
3823: avalue => l_end_dt );
3824: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3820: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3821: itemkey => itemkey ,
3822: aname => 'AMS_ACT_END_DATE',
3823: avalue => l_end_dt );
3824: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3825: itemkey => itemkey ,
3826: aname => 'AMS_EVE_MKT_MESSAGE',
3827: avalue => l_eve_mkt_msg );
3828: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3824: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3825: itemkey => itemkey ,
3826: aname => 'AMS_EVE_MKT_MESSAGE',
3827: avalue => l_eve_mkt_msg );
3828: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3829: itemkey => itemkey,
3830: aname => 'AMS_BUDGET_AMOUNT',
3831: avalue => l_budget_amount );
3832: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

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

3828: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3829: itemkey => itemkey,
3830: aname => 'AMS_BUDGET_AMOUNT',
3831: avalue => l_budget_amount );
3832: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3833: itemkey => itemkey ,
3834: aname => 'AMS_ACT_DESC',
3835: avalue => l_desc );
3836: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

3832: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3833: itemkey => itemkey ,
3834: aname => 'AMS_ACT_DESC',
3835: avalue => l_desc );
3836: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
3837: itemkey => itemkey,
3838: aname => 'AMS_CURRENCY',
3839: avalue => l_currency );
3840:

Line 3845: wf_engine.SetItemAttrText( itemtype => itemtype,

3841:
3842: END IF;
3843:
3844:
3845: wf_engine.SetItemAttrText( itemtype => itemtype,
3846: itemkey => itemkey,
3847: aname => 'AMS_NOTIF_DOCUMENT',
3848: avalue =>
3849: 'PLSQL:AMS_WFCMPAPR_PVT.Create_Notif_Document/'||

Line 3853: l_doc_type := wf_engine.GetItemAttrText(

3849: 'PLSQL:AMS_WFCMPAPR_PVT.Create_Notif_Document/'||
3850: ItemType||':'||
3851: ItemKey);
3852:
3853: l_doc_type := wf_engine.GetItemAttrText(
3854: itemtype => ItemType,
3855: itemkey => ItemKey,
3856: aname => 'AMS_APPR_DOC_TYPE');
3857:

Line 3859: l_obj_type := wf_engine.GetItemAttrText(

3855: itemkey => ItemKey,
3856: aname => 'AMS_APPR_DOC_TYPE');
3857:
3858:
3859: l_obj_type := wf_engine.GetItemAttrText(
3860: itemtype => ItemType,
3861: itemkey => ItemKey,
3862: aname => 'AMS_APPROVAL_FOR_OBJECT');
3863:

Line 3864: l_obj_id := wf_engine.GetItemAttrText(

3860: itemtype => ItemType,
3861: itemkey => ItemKey,
3862: aname => 'AMS_APPROVAL_FOR_OBJECT');
3863:
3864: l_obj_id := wf_engine.GetItemAttrText(
3865: itemtype => ItemType,
3866: itemkey => ItemKey,
3867: aname => 'AMS_ACT_ID');
3868: l_obj_version_number := wf_engine.GetItemAttrText(

Line 3868: l_obj_version_number := wf_engine.GetItemAttrText(

3864: l_obj_id := wf_engine.GetItemAttrText(
3865: itemtype => ItemType,
3866: itemkey => ItemKey,
3867: aname => 'AMS_ACT_ID');
3868: l_obj_version_number := wf_engine.GetItemAttrText(
3869: itemtype => ItemType,
3870: itemkey => ItemKey,
3871: aname => 'AMS_OBJECT_VERSION_NUMBER');
3872: l_requester_id := wf_engine.GetItemAttrText(

Line 3872: l_requester_id := wf_engine.GetItemAttrText(

3868: l_obj_version_number := wf_engine.GetItemAttrText(
3869: itemtype => ItemType,
3870: itemkey => ItemKey,
3871: aname => 'AMS_OBJECT_VERSION_NUMBER');
3872: l_requester_id := wf_engine.GetItemAttrText(
3873: itemtype => ItemType,
3874: itemkey => ItemKey,
3875: aname => 'AMS_REQUESTER_ID');
3876:

Line 3990: l_ta_appr_flag := WF_ENGINE.GetItemAttrText(

3986: -- dbms_output.put_line('Process Owner_appr_check');
3987: -- RUN mode - Normal Process Execution
3988: IF (funcmode = 'RUN')
3989: THEN
3990: l_ta_appr_flag := WF_ENGINE.GetItemAttrText(
3991: itemtype => itemtype,
3992: itemkey => itemkey ,
3993: aname => 'AMS_TAOWNER_APPR_FLAG');
3994: l_owner := WF_ENGINE.GetItemAttrText(

Line 3994: l_owner := WF_ENGINE.GetItemAttrText(

3990: l_ta_appr_flag := WF_ENGINE.GetItemAttrText(
3991: itemtype => itemtype,
3992: itemkey => itemkey ,
3993: aname => 'AMS_TAOWNER_APPR_FLAG');
3994: l_owner := WF_ENGINE.GetItemAttrText(
3995: itemtype => itemtype,
3996: itemkey => itemkey ,
3997: aname => 'AMS_OWNER');
3998: l_bud_appr_flag := WF_ENGINE.GetItemAttrText(

Line 3998: l_bud_appr_flag := WF_ENGINE.GetItemAttrText(

3994: l_owner := WF_ENGINE.GetItemAttrText(
3995: itemtype => itemtype,
3996: itemkey => itemkey ,
3997: aname => 'AMS_OWNER');
3998: l_bud_appr_flag := WF_ENGINE.GetItemAttrText(
3999: itemtype => itemtype,
4000: itemkey => itemkey ,
4001: aname => 'AMS_BUDGET_APPR_FLAG');
4002:

Line 4003: l_fund_manager := WF_ENGINE.GetItemAttrText(

3999: itemtype => itemtype,
4000: itemkey => itemkey ,
4001: aname => 'AMS_BUDGET_APPR_FLAG');
4002:
4003: l_fund_manager := WF_ENGINE.GetItemAttrText(
4004: itemtype => itemtype,
4005: itemkey => itemkey ,
4006: aname => 'AMS_BUD_MANAGER');
4007:

Line 4008: l_manager := WF_ENGINE.GetItemAttrText(

4004: itemtype => itemtype,
4005: itemkey => itemkey ,
4006: aname => 'AMS_BUD_MANAGER');
4007:
4008: l_manager := WF_ENGINE.GetItemAttrText(
4009: itemtype => itemtype,
4010: itemkey => itemkey ,
4011: aname => 'AMS_MANAGER');
4012:

Line 4013: l_appr_type := WF_ENGINE.GetItemAttrText(

4009: itemtype => itemtype,
4010: itemkey => itemkey ,
4011: aname => 'AMS_MANAGER');
4012:
4013: l_appr_type := WF_ENGINE.GetItemAttrText(
4014: itemtype => itemtype,
4015: itemkey => itemkey ,
4016: aname => 'AMS_APPR_TYPE_LOOKUP');
4017:

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

4016: aname => 'AMS_APPR_TYPE_LOOKUP');
4017:
4018: IF l_ta_appr_flag = 'Y' THEN
4019: IF l_appr_type = 'THEME' THEN
4020: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4021: itemkey => itemkey,
4022: aname => 'AMS_APPR_USERNAME',
4023: avalue => l_owner);
4024: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4020: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4021: itemkey => itemkey,
4022: aname => 'AMS_APPR_USERNAME',
4023: avalue => l_owner);
4024: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4025: itemkey => itemkey,
4026: aname => 'AMS_TAOWNER_APPR_FLAG',
4027: avalue => 'N');
4028: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4024: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4025: itemkey => itemkey,
4026: aname => 'AMS_TAOWNER_APPR_FLAG',
4027: avalue => 'N');
4028: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4029: itemkey => itemkey,
4030: aname => 'AMS_APPR_DOC_TYPE',
4031: avalue => 'THEME');
4032:

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

4031: avalue => 'THEME');
4032:
4033: ELSE -- l_appr_type = 'BOTH' THEN
4034: IF l_fund_manager = l_manager THEN
4035: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4036: itemkey => itemkey,
4037: aname => 'AMS_APPR_USERNAME',
4038: avalue => l_owner);
4039: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4035: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4036: itemkey => itemkey,
4037: aname => 'AMS_APPR_USERNAME',
4038: avalue => l_owner);
4039: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4040: itemkey => itemkey,
4041: aname => 'AMS_TAOWNER_APPR_FLAG',
4042: avalue => 'N');
4043: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4039: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4040: itemkey => itemkey,
4041: aname => 'AMS_TAOWNER_APPR_FLAG',
4042: avalue => 'N');
4043: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4044: itemkey => itemkey,
4045: aname => 'AMS_APPR_DOC_TYPE',
4046: avalue => 'THEME');
4047: ELSIF l_owner = l_fund_manager THEN

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

4044: itemkey => itemkey,
4045: aname => 'AMS_APPR_DOC_TYPE',
4046: avalue => 'THEME');
4047: ELSIF l_owner = l_fund_manager THEN
4048: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4049: itemkey => itemkey,
4050: aname => 'AMS_APPR_USERNAME',
4051: avalue => l_owner);
4052:

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

4049: itemkey => itemkey,
4050: aname => 'AMS_APPR_USERNAME',
4051: avalue => l_owner);
4052:
4053: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4054: itemkey => itemkey,
4055: aname => 'AMS_TAOWNER_APPR_FLAG',
4056: avalue => 'N');
4057: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4053: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4054: itemkey => itemkey,
4055: aname => 'AMS_TAOWNER_APPR_FLAG',
4056: avalue => 'N');
4057: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4058: itemkey => itemkey,
4059: aname => 'AMS_APPR_DOC_TYPE',
4060: avalue => 'BOTH');
4061: ELSE

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

4058: itemkey => itemkey,
4059: aname => 'AMS_APPR_DOC_TYPE',
4060: avalue => 'BOTH');
4061: ELSE
4062: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4063: itemkey => itemkey,
4064: aname => 'AMS_APPR_USERNAME',
4065: avalue => l_owner);
4066:

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

4063: itemkey => itemkey,
4064: aname => 'AMS_APPR_USERNAME',
4065: avalue => l_owner);
4066:
4067: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4068: itemkey => itemkey,
4069: aname => 'AMS_BUDGET_APPR_FLAG',
4070: avalue => 'Y');
4071: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4067: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4068: itemkey => itemkey,
4069: aname => 'AMS_BUDGET_APPR_FLAG',
4070: avalue => 'Y');
4071: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4072: itemkey => itemkey,
4073: aname => 'AMS_TAOWNER_APPR_FLAG',
4074: avalue => 'N');
4075: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4071: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4072: itemkey => itemkey,
4073: aname => 'AMS_TAOWNER_APPR_FLAG',
4074: avalue => 'N');
4075: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4076: itemkey => itemkey,
4077: aname => 'AMS_APPR_DOC_TYPE',
4078: avalue => 'THEME');
4079: END IF ;

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

4080: END IF;
4081: result := 'COMPLETE:Y' ;
4082: ELSE -- IF l_ba_appr_flag = 'N' THEN
4083: IF l_bud_appr_flag = 'Y' THEN
4084: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4085: itemkey => itemkey,
4086: aname => 'AMS_APPR_USERNAME',
4087: avalue => l_fund_manager);
4088: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4084: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4085: itemkey => itemkey,
4086: aname => 'AMS_APPR_USERNAME',
4087: avalue => l_fund_manager);
4088: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4089: itemkey => itemkey,
4090: aname => 'AMS_APPR_DOC_TYPE',
4091: avalue => 'BUDGET');
4092: END IF;

Line 4184: l_bud_appr_flg := wf_engine.GetItemAttrText(

4180: -- dbms_output.put_line('Process Updt_Stat_apprTA');
4181: -- RUN mode - Normal Process Execution
4182: IF (funcmode = 'RUN')
4183: THEN
4184: l_bud_appr_flg := wf_engine.GetItemAttrText(
4185: itemtype => ItemType,
4186: itemkey => ItemKey,
4187: aname => 'AMS_BUDGET_APPR_FLAG');
4188:

Line 4189: l_obj_type := wf_engine.GetItemAttrText(

4185: itemtype => ItemType,
4186: itemkey => ItemKey,
4187: aname => 'AMS_BUDGET_APPR_FLAG');
4188:
4189: l_obj_type := wf_engine.GetItemAttrText(
4190: itemtype => ItemType,
4191: itemkey => ItemKey,
4192: aname => 'AMS_APPROVAL_FOR_OBJECT');
4193:

Line 4194: l_obj_id := wf_engine.GetItemAttrText(

4190: itemtype => ItemType,
4191: itemkey => ItemKey,
4192: aname => 'AMS_APPROVAL_FOR_OBJECT');
4193:
4194: l_obj_id := wf_engine.GetItemAttrText(
4195: itemtype => ItemType,
4196: itemkey => ItemKey,
4197: aname => 'AMS_ACT_ID');
4198: l_obj_version_number := wf_engine.GetItemAttrText(

Line 4198: l_obj_version_number := wf_engine.GetItemAttrText(

4194: l_obj_id := wf_engine.GetItemAttrText(
4195: itemtype => ItemType,
4196: itemkey => ItemKey,
4197: aname => 'AMS_ACT_ID');
4198: l_obj_version_number := wf_engine.GetItemAttrText(
4199: itemtype => ItemType,
4200: itemkey => ItemKey,
4201: aname => 'AMS_OBJECT_VERSION_NUMBER');
4202: l_next_stat_id := wf_engine.GetItemAttrText(

Line 4202: l_next_stat_id := wf_engine.GetItemAttrText(

4198: l_obj_version_number := wf_engine.GetItemAttrText(
4199: itemtype => ItemType,
4200: itemkey => ItemKey,
4201: aname => 'AMS_OBJECT_VERSION_NUMBER');
4202: l_next_stat_id := wf_engine.GetItemAttrText(
4203: itemtype => ItemType,
4204: itemkey => ItemKey,
4205: aname => 'AMS_NEW_STAT_ID');
4206: l_requester_id := wf_engine.GetItemAttrText(

Line 4206: l_requester_id := wf_engine.GetItemAttrText(

4202: l_next_stat_id := wf_engine.GetItemAttrText(
4203: itemtype => ItemType,
4204: itemkey => ItemKey,
4205: aname => 'AMS_NEW_STAT_ID');
4206: l_requester_id := wf_engine.GetItemAttrText(
4207: itemtype => ItemType,
4208: itemkey => ItemKey,
4209: aname => 'AMS_REQUESTER_ID');
4210: l_doc_type := wf_engine.GetItemAttrText(

Line 4210: l_doc_type := wf_engine.GetItemAttrText(

4206: l_requester_id := wf_engine.GetItemAttrText(
4207: itemtype => ItemType,
4208: itemkey => ItemKey,
4209: aname => 'AMS_REQUESTER_ID');
4210: l_doc_type := wf_engine.GetItemAttrText(
4211: itemtype => ItemType,
4212: itemkey => ItemKey,
4213: aname => 'AMS_APPR_DOC_TYPE');
4214:

Line 4215: l_appr_type_lookup := wf_engine.GetItemAttrText(

4211: itemtype => ItemType,
4212: itemkey => ItemKey,
4213: aname => 'AMS_APPR_DOC_TYPE');
4214:
4215: l_appr_type_lookup := wf_engine.GetItemAttrText(
4216: itemtype => ItemType,
4217: itemkey => ItemKey,
4218: aname => 'AMS_APPR_TYPE_LOOKUP');
4219:

Line 4220: l_approver := wf_engine.GetItemAttrText(

4216: itemtype => ItemType,
4217: itemkey => ItemKey,
4218: aname => 'AMS_APPR_TYPE_LOOKUP');
4219:
4220: l_approver := wf_engine.GetItemAttrText(
4221: itemtype => ItemType,
4222: itemkey => ItemKey,
4223: aname => 'AMS_APPR_USERNAME');
4224:

Line 4225: l_note := wf_engine.GetItemAttrText(

4221: itemtype => ItemType,
4222: itemkey => ItemKey,
4223: aname => 'AMS_APPR_USERNAME');
4224:
4225: l_note := wf_engine.GetItemAttrText(
4226: itemtype => ItemType,
4227: itemkey => ItemKey,
4228: aname => 'AMS_NOTE');
4229:

Line 4425: l_doc_type := wf_engine.GetItemAttrText(

4421: -- dbms_output.put_line('Process Update Status_rej');
4422: -- RUN mode - Normal Process Execution
4423: IF (funcmode = 'RUN')
4424: THEN
4425: l_doc_type := wf_engine.GetItemAttrText(
4426: itemtype => ItemType,
4427: itemkey => ItemKey,
4428: aname => 'AMS_APPR_DOC_TYPE');
4429:

Line 4430: l_obj_type := wf_engine.GetItemAttrText(

4426: itemtype => ItemType,
4427: itemkey => ItemKey,
4428: aname => 'AMS_APPR_DOC_TYPE');
4429:
4430: l_obj_type := wf_engine.GetItemAttrText(
4431: itemtype => ItemType,
4432: itemkey => ItemKey,
4433: aname => 'AMS_APPROVAL_FOR_OBJECT');
4434:

Line 4435: l_obj_id := wf_engine.GetItemAttrText(

4431: itemtype => ItemType,
4432: itemkey => ItemKey,
4433: aname => 'AMS_APPROVAL_FOR_OBJECT');
4434:
4435: l_obj_id := wf_engine.GetItemAttrText(
4436: itemtype => ItemType,
4437: itemkey => ItemKey,
4438: aname => 'AMS_ACT_ID');
4439: l_obj_version_number := wf_engine.GetItemAttrText(

Line 4439: l_obj_version_number := wf_engine.GetItemAttrText(

4435: l_obj_id := wf_engine.GetItemAttrText(
4436: itemtype => ItemType,
4437: itemkey => ItemKey,
4438: aname => 'AMS_ACT_ID');
4439: l_obj_version_number := wf_engine.GetItemAttrText(
4440: itemtype => ItemType,
4441: itemkey => ItemKey,
4442: aname => 'AMS_OBJECT_VERSION_NUMBER');
4443: l_requester_id := wf_engine.GetItemAttrText(

Line 4443: l_requester_id := wf_engine.GetItemAttrText(

4439: l_obj_version_number := wf_engine.GetItemAttrText(
4440: itemtype => ItemType,
4441: itemkey => ItemKey,
4442: aname => 'AMS_OBJECT_VERSION_NUMBER');
4443: l_requester_id := wf_engine.GetItemAttrText(
4444: itemtype => ItemType,
4445: itemkey => ItemKey,
4446: aname => 'AMS_REQUESTER_ID');
4447:

Line 4448: l_approver := wf_engine.GetItemAttrText(

4444: itemtype => ItemType,
4445: itemkey => ItemKey,
4446: aname => 'AMS_REQUESTER_ID');
4447:
4448: l_approver := wf_engine.GetItemAttrText(
4449: itemtype => ItemType,
4450: itemkey => ItemKey,
4451: aname => 'AMS_APPR_USERNAME');
4452:

Line 4453: l_note := wf_engine.GetItemAttrText(

4449: itemtype => ItemType,
4450: itemkey => ItemKey,
4451: aname => 'AMS_APPR_USERNAME');
4452:
4453: l_note := wf_engine.GetItemAttrText(
4454: itemtype => ItemType,
4455: itemkey => ItemKey,
4456: aname => 'AMS_NOTE');
4457:

Line 4605: l_obj_type := wf_engine.GetItemAttrText(

4601: -- RUN mode - Normal Process Execution
4602: IF (funcmode = 'RUN')
4603: THEN
4604:
4605: l_obj_type := wf_engine.GetItemAttrText(
4606: itemtype => ItemType,
4607: itemkey => ItemKey,
4608: aname => 'AMS_APPROVAL_FOR_OBJECT');
4609:

Line 4610: l_obj_id := wf_engine.GetItemAttrText(

4606: itemtype => ItemType,
4607: itemkey => ItemKey,
4608: aname => 'AMS_APPROVAL_FOR_OBJECT');
4609:
4610: l_obj_id := wf_engine.GetItemAttrText(
4611: itemtype => ItemType,
4612: itemkey => ItemKey,
4613: aname => 'AMS_ACT_ID');
4614: l_obj_version_number := wf_engine.GetItemAttrText(

Line 4614: l_obj_version_number := wf_engine.GetItemAttrText(

4610: l_obj_id := wf_engine.GetItemAttrText(
4611: itemtype => ItemType,
4612: itemkey => ItemKey,
4613: aname => 'AMS_ACT_ID');
4614: l_obj_version_number := wf_engine.GetItemAttrText(
4615: itemtype => ItemType,
4616: itemkey => ItemKey,
4617: aname => 'AMS_OBJECT_VERSION_NUMBER');
4618:

Line 4619: l_orig_stat_id := wf_engine.GetItemAttrText(

4615: itemtype => ItemType,
4616: itemkey => ItemKey,
4617: aname => 'AMS_OBJECT_VERSION_NUMBER');
4618:
4619: l_orig_stat_id := wf_engine.GetItemAttrText(
4620: itemtype => ItemType,
4621: itemkey => ItemKey,
4622: aname => 'AMS_ORIG_STAT_ID');
4623: l_requester_id := wf_engine.GetItemAttrText(

Line 4623: l_requester_id := wf_engine.GetItemAttrText(

4619: l_orig_stat_id := wf_engine.GetItemAttrText(
4620: itemtype => ItemType,
4621: itemkey => ItemKey,
4622: aname => 'AMS_ORIG_STAT_ID');
4623: l_requester_id := wf_engine.GetItemAttrText(
4624: itemtype => ItemType,
4625: itemkey => ItemKey,
4626: aname => 'AMS_REQUESTER_ID');
4627: l_doc_type := wf_engine.GetItemAttrText(

Line 4627: l_doc_type := wf_engine.GetItemAttrText(

4623: l_requester_id := wf_engine.GetItemAttrText(
4624: itemtype => ItemType,
4625: itemkey => ItemKey,
4626: aname => 'AMS_REQUESTER_ID');
4627: l_doc_type := wf_engine.GetItemAttrText(
4628: itemtype => ItemType,
4629: itemkey => ItemKey,
4630: aname => 'AMS_APPR_DOC_TYPE');
4631:

Line 4632: l_approver := wf_engine.GetItemAttrText(

4628: itemtype => ItemType,
4629: itemkey => ItemKey,
4630: aname => 'AMS_APPR_DOC_TYPE');
4631:
4632: l_approver := wf_engine.GetItemAttrText(
4633: itemtype => ItemType,
4634: itemkey => ItemKey,
4635: aname => 'AMS_APPR_USERNAME');
4636:

Line 4637: l_note := wf_engine.GetItemAttrText(

4633: itemtype => ItemType,
4634: itemkey => ItemKey,
4635: aname => 'AMS_APPR_USERNAME');
4636:
4637: l_note := wf_engine.GetItemAttrText(
4638: itemtype => ItemType,
4639: itemkey => ItemKey,
4640: aname => 'AMS_NOTE');
4641:

Line 4762: l_budget_appr_flag := WF_ENGINE.GetItemAttrText(

4758: -- dbms_output.put_line('Process Fund Appr Req_Check');
4759: -- RUN mode - Normal Process Execution
4760: IF (funcmode = 'RUN')
4761: THEN
4762: l_budget_appr_flag := WF_ENGINE.GetItemAttrText(
4763: itemtype => itemtype,
4764: itemkey => itemkey ,
4765: aname => 'AMS_BUDGET_APPR_FLAG');
4766: IF l_budget_appr_flag = 'Y' THEN

Line 4844: l_ba_appr_flag := WF_ENGINE.GetItemAttrText(

4840: -- dbms_output.put_line('Process BA_OWNER_APPR_CHECK');
4841: -- RUN mode - Normal Process Execution
4842: IF (funcmode = 'RUN')
4843: THEN
4844: l_ba_appr_flag := WF_ENGINE.GetItemAttrText(
4845: itemtype => itemtype,
4846: itemkey => itemkey ,
4847: aname => 'AMS_TAOWNER_APPR_FLAG');
4848: l_owner := WF_ENGINE.GetItemAttrText(

Line 4848: l_owner := WF_ENGINE.GetItemAttrText(

4844: l_ba_appr_flag := WF_ENGINE.GetItemAttrText(
4845: itemtype => itemtype,
4846: itemkey => itemkey ,
4847: aname => 'AMS_TAOWNER_APPR_FLAG');
4848: l_owner := WF_ENGINE.GetItemAttrText(
4849: itemtype => itemtype,
4850: itemkey => itemkey ,
4851: aname => 'AMS_OWNER');
4852:

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

4851: aname => 'AMS_OWNER');
4852:
4853: IF l_ba_appr_flag = 'Y' THEN
4854:
4855: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4856: itemkey => itemkey,
4857: aname => 'AMS_APPR_USERNAME',
4858: avalue => l_owner);
4859:

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

4856: itemkey => itemkey,
4857: aname => 'AMS_APPR_USERNAME',
4858: avalue => l_owner);
4859:
4860: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4861: itemkey => itemkey,
4862: aname => 'AMS_BUDGET_APPR_FLAG',
4863: avalue => 'N');
4864: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4860: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4861: itemkey => itemkey,
4862: aname => 'AMS_BUDGET_APPR_FLAG',
4863: avalue => 'N');
4864: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4865: itemkey => itemkey,
4866: aname => 'AMS_TAOWNER_APPR_FLAG',
4867: avalue => 'N');
4868: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4864: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4865: itemkey => itemkey,
4866: aname => 'AMS_TAOWNER_APPR_FLAG',
4867: avalue => 'N');
4868: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4869: itemkey => itemkey,
4870: aname => 'AMS_BAOWNER_APPR_FLAG',
4871: avalue => 'N');
4872: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4868: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4869: itemkey => itemkey,
4870: aname => 'AMS_BAOWNER_APPR_FLAG',
4871: avalue => 'N');
4872: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4873: itemkey => itemkey,
4874: aname => 'AMS_THEME_APPR_FLAG',
4875: avalue => 'Y');
4876: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

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

4872: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4873: itemkey => itemkey,
4874: aname => 'AMS_THEME_APPR_FLAG',
4875: avalue => 'Y');
4876: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
4877: itemkey => itemkey,
4878: aname => 'AMS_APPR_DOC_TYPE',
4879: avalue => 'BUDGET');
4880:

Line 4973: l_obj_type := wf_engine.GetItemAttrText(

4969: -- RUN mode - Normal Process Execution
4970: IF (funcmode = 'RUN')
4971: THEN
4972:
4973: l_obj_type := wf_engine.GetItemAttrText(
4974: itemtype => ItemType,
4975: itemkey => ItemKey,
4976: aname => 'AMS_APPROVAL_FOR_OBJECT');
4977:

Line 4978: l_obj_id := wf_engine.GetItemAttrText(

4974: itemtype => ItemType,
4975: itemkey => ItemKey,
4976: aname => 'AMS_APPROVAL_FOR_OBJECT');
4977:
4978: l_obj_id := wf_engine.GetItemAttrText(
4979: itemtype => ItemType,
4980: itemkey => ItemKey,
4981: aname => 'AMS_ACT_ID');
4982: l_obj_version_number := wf_engine.GetItemAttrText(

Line 4982: l_obj_version_number := wf_engine.GetItemAttrText(

4978: l_obj_id := wf_engine.GetItemAttrText(
4979: itemtype => ItemType,
4980: itemkey => ItemKey,
4981: aname => 'AMS_ACT_ID');
4982: l_obj_version_number := wf_engine.GetItemAttrText(
4983: itemtype => ItemType,
4984: itemkey => ItemKey,
4985: aname => 'AMS_OBJECT_VERSION_NUMBER');
4986: l_next_stat_id := wf_engine.GetItemAttrText(

Line 4986: l_next_stat_id := wf_engine.GetItemAttrText(

4982: l_obj_version_number := wf_engine.GetItemAttrText(
4983: itemtype => ItemType,
4984: itemkey => ItemKey,
4985: aname => 'AMS_OBJECT_VERSION_NUMBER');
4986: l_next_stat_id := wf_engine.GetItemAttrText(
4987: itemtype => ItemType,
4988: itemkey => ItemKey,
4989: aname => 'AMS_NEW_STAT_ID');
4990: l_requester_id := wf_engine.GetItemAttrText(

Line 4990: l_requester_id := wf_engine.GetItemAttrText(

4986: l_next_stat_id := wf_engine.GetItemAttrText(
4987: itemtype => ItemType,
4988: itemkey => ItemKey,
4989: aname => 'AMS_NEW_STAT_ID');
4990: l_requester_id := wf_engine.GetItemAttrText(
4991: itemtype => ItemType,
4992: itemkey => ItemKey,
4993: aname => 'AMS_REQUESTER_ID');
4994: l_doc_type := wf_engine.GetItemAttrText(

Line 4994: l_doc_type := wf_engine.GetItemAttrText(

4990: l_requester_id := wf_engine.GetItemAttrText(
4991: itemtype => ItemType,
4992: itemkey => ItemKey,
4993: aname => 'AMS_REQUESTER_ID');
4994: l_doc_type := wf_engine.GetItemAttrText(
4995: itemtype => ItemType,
4996: itemkey => ItemKey,
4997: aname => 'AMS_APPR_DOC_TYPE');
4998:

Line 5004: l_approver := wf_engine.GetItemAttrText(

5000: FETCH c_sys_stat INTO l_sys_stat_code ;
5001: CLOSE c_sys_stat ;
5002:
5003:
5004: l_approver := wf_engine.GetItemAttrText(
5005: itemtype => ItemType,
5006: itemkey => ItemKey,
5007: aname => 'AMS_APPR_USERNAME');
5008:

Line 5009: l_note := wf_engine.GetItemAttrText(

5005: itemtype => ItemType,
5006: itemkey => ItemKey,
5007: aname => 'AMS_APPR_USERNAME');
5008:
5009: l_note := wf_engine.GetItemAttrText(
5010: itemtype => ItemType,
5011: itemkey => ItemKey,
5012: aname => 'AMS_NOTE');
5013:

Line 5139: WF_ENGINE.AbortProcess (itemtype => itemtype,

5135: AMS_Utility_PVT.debug_message('Process Abort Process');
5136: END IF;
5137: -- dbms_output.put_line('Process Abort Process');
5138:
5139: WF_ENGINE.AbortProcess (itemtype => itemtype,
5140: itemkey => itemkey ,
5141: process => p_workflowprocess);
5142:
5143: -- dbms_output.put_line('After Aborting Process ');