eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on WF_ENGINE

Line 195: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

191: -- ********
192: -- Get the Attribute values
193: -- ********
194:
195: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
196: itemtype => p_itemtype,
197: itemkey => p_itemkey,
198: aname => 'OKL_CONTRACT_NUMBER');
199:

Line 200: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

196: itemtype => p_itemtype,
197: itemkey => p_itemkey,
198: aname => 'OKL_CONTRACT_NUMBER');
199:
200: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
201: itemtype => p_itemtype,
202: itemkey => p_itemkey,
203: aname => 'OKS_CONTRACT_NUMBER');
204:

Line 205: l_dispose_date := WF_ENGINE.GetItemAttrDate(

201: itemtype => p_itemtype,
202: itemkey => p_itemkey,
203: aname => 'OKS_CONTRACT_NUMBER');
204:
205: l_dispose_date := WF_ENGINE.GetItemAttrDate(
206: itemtype => p_itemtype,
207: itemkey => p_itemkey,
208: aname => 'DISPOSAL_DATE');
209:

Line 210: l_return_date := WF_ENGINE.GetItemAttrDate(

206: itemtype => p_itemtype,
207: itemkey => p_itemkey,
208: aname => 'DISPOSAL_DATE');
209:
210: l_return_date := WF_ENGINE.GetItemAttrDate(
211: itemtype => p_itemtype,
212: itemkey => p_itemkey,
213: aname => 'RETURN_DATE');
214:

Line 216: l_term_date := WF_ENGINE.GetItemAttrDate(

212: itemkey => p_itemkey,
213: aname => 'RETURN_DATE');
214:
215:
216: l_term_date := WF_ENGINE.GetItemAttrDate(
217: itemtype => p_itemtype,
218: itemkey => p_itemkey,
219: aname => 'TERMINATION_DATE');
220:

Line 840: l_source := WF_ENGINE.GetItemAttrText(

836: -- ********
837: -- Get the attribute values which are set
838: -- ********
839:
840: l_source := WF_ENGINE.GetItemAttrText(
841: itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'SOURCE');
844:

Line 846: l_transaction_id := WF_ENGINE.GetItemAttrText(

842: itemkey => itemkey,
843: aname => 'SOURCE');
844:
845:
846: l_transaction_id := WF_ENGINE.GetItemAttrText(
847: itemtype => itemtype,
848: itemkey => itemkey,
849: aname => 'TRANSACTION_ID');
850:

Line 851: l_quote_id := WF_ENGINE.GetItemAttrText(

847: itemtype => itemtype,
848: itemkey => itemkey,
849: aname => 'TRANSACTION_ID');
850:
851: l_quote_id := WF_ENGINE.GetItemAttrText(
852: itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'QUOTE_ID');
855:

Line 856: l_transaction_date := WF_ENGINE.GetItemAttrText(

852: itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'QUOTE_ID');
855:
856: l_transaction_date := WF_ENGINE.GetItemAttrText(
857: itemtype => itemtype,
858: itemkey => itemkey,
859: aname => 'TRANSACTION_DATE');
860:

Line 862: l_oks_chr_id := WF_ENGINE.GetItemAttrText(

858: itemkey => itemkey,
859: aname => 'TRANSACTION_DATE');
860:
861: -- RMUNJULU 23-DEC-03 SERVICE K UPDATES
862: l_oks_chr_id := WF_ENGINE.GetItemAttrText(
863: itemtype => itemtype,
864: itemkey => itemkey,
865: aname => 'OKS_CONTRACT_ID');
866:

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

874: IF l_oks_agent IS NULL THEN
875: l_oks_agent := 'SYSADMIN';
876: END IF;
877:
878: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
879: itemkey => itemkey,
880: aname => 'OKS_PERFORMING_AGENT',
881: avalue => l_oks_agent);
882:

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

886: IF l_okl_agent IS NULL THEN
887: l_okl_agent := 'SYSADMIN';
888: END IF;
889:
890: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
891: itemkey => itemkey,
892: aname => 'OKL_PERFORMING_AGENT',
893: avalue => l_okl_agent);
894:

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

1020: -- *********
1021: -- Set Attributes needed
1022: -- *********
1023:
1024: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'OKL_CONTRACT_ID',
1027: avalue => l_okl_chr_id);
1028:

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

1025: itemkey => itemkey,
1026: aname => 'OKL_CONTRACT_ID',
1027: avalue => l_okl_chr_id);
1028:
1029: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => 'OKL_CONTRACT_NUMBER',
1032: avalue => l_okl_contract_number);
1033:

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

1030: itemkey => itemkey,
1031: aname => 'OKL_CONTRACT_NUMBER',
1032: avalue => l_okl_contract_number);
1033:
1034: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1035: itemkey => itemkey,
1036: aname => 'OKS_CONTRACT_ID',
1037: avalue => l_oks_chr_id);
1038:

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

1035: itemkey => itemkey,
1036: aname => 'OKS_CONTRACT_ID',
1037: avalue => l_oks_chr_id);
1038:
1039: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1040: itemkey => itemkey,
1041: aname => 'OKS_CONTRACT_NUMBER',
1042: avalue => l_oks_contract_number);
1043:

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

1040: itemkey => itemkey,
1041: aname => 'OKS_CONTRACT_NUMBER',
1042: avalue => l_oks_contract_number);
1043:
1044: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,
1045: itemkey => itemkey,
1046: aname => 'TERMINATION_DATE',
1047: avalue => TO_DATE(l_termination_date,'DD/MM/RRRR'));
1048:

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

1045: itemkey => itemkey,
1046: aname => 'TERMINATION_DATE',
1047: avalue => TO_DATE(l_termination_date,'DD/MM/RRRR'));
1048:
1049: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'NOTIFICATION_DATE',
1052: avalue => TO_DATE(SYSDATE,'DD/MM/RRRR'));
1053:

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

1050: itemkey => itemkey,
1051: aname => 'NOTIFICATION_DATE',
1052: avalue => TO_DATE(SYSDATE,'DD/MM/RRRR'));
1053:
1054: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1055: itemkey => itemkey,
1056: aname => 'ASSET_ID',
1057: avalue => l_asset_id);
1058:

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

1055: itemkey => itemkey,
1056: aname => 'ASSET_ID',
1057: avalue => l_asset_id);
1058:
1059: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,
1060: itemkey => itemkey,
1061: aname => 'RETURN_DATE',
1062: avalue => TO_DATE(l_asset_return_date,'DD/MM/RRRR'));
1063:

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

1060: itemkey => itemkey,
1061: aname => 'RETURN_DATE',
1062: avalue => TO_DATE(l_asset_return_date,'DD/MM/RRRR'));
1063:
1064: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'DISPOSAL_DATE',
1067: avalue => TO_DATE(l_asset_disposal_date,'DD/MM/RRRR'));
1068:

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

1065: itemkey => itemkey,
1066: aname => 'DISPOSAL_DATE',
1067: avalue => TO_DATE(l_asset_disposal_date,'DD/MM/RRRR'));
1068:
1069: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
1070: itemkey => itemkey,
1071: aname => 'MESSAGE_SUBJECT',
1072: avalue => l_message_subject);
1073:

Line 1165: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1161: -- ********
1162: -- Get the Attribute values
1163: -- ********
1164:
1165: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1166: itemtype => l_item_type,
1167: itemkey => l_item_key,
1168: aname => 'OKL_CONTRACT_NUMBER');
1169:

Line 1170: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1166: itemtype => l_item_type,
1167: itemkey => l_item_key,
1168: aname => 'OKL_CONTRACT_NUMBER');
1169:
1170: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1171: itemtype => l_item_type,
1172: itemkey => l_item_key,
1173: aname => 'OKS_CONTRACT_NUMBER');
1174:

Line 1175: l_dispose_date := WF_ENGINE.GetItemAttrDate(

1171: itemtype => l_item_type,
1172: itemkey => l_item_key,
1173: aname => 'OKS_CONTRACT_NUMBER');
1174:
1175: l_dispose_date := WF_ENGINE.GetItemAttrDate(
1176: itemtype => l_item_type,
1177: itemkey => l_item_key,
1178: aname => 'DISPOSAL_DATE');
1179:

Line 1180: l_dispose_asset_id := WF_ENGINE.GetItemAttrText(

1176: itemtype => l_item_type,
1177: itemkey => l_item_key,
1178: aname => 'DISPOSAL_DATE');
1179:
1180: l_dispose_asset_id := WF_ENGINE.GetItemAttrText(
1181: itemtype => l_item_type,
1182: itemkey => l_item_key,
1183: aname => 'ASSET_ID');
1184:

Line 1382: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1378: -- ********
1379: -- Get the Attribute values
1380: -- ********
1381:
1382: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1383: itemtype => l_item_type,
1384: itemkey => l_item_key,
1385: aname => 'OKL_CONTRACT_NUMBER');
1386:

Line 1387: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1383: itemtype => l_item_type,
1384: itemkey => l_item_key,
1385: aname => 'OKL_CONTRACT_NUMBER');
1386:
1387: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1388: itemtype => l_item_type,
1389: itemkey => l_item_key,
1390: aname => 'OKS_CONTRACT_NUMBER');
1391:

Line 1392: l_return_date := WF_ENGINE.GetItemAttrDate(

1388: itemtype => l_item_type,
1389: itemkey => l_item_key,
1390: aname => 'OKS_CONTRACT_NUMBER');
1391:
1392: l_return_date := WF_ENGINE.GetItemAttrDate(
1393: itemtype => l_item_type,
1394: itemkey => l_item_key,
1395: aname => 'RETURN_DATE');
1396:

Line 1397: l_return_asset_id := WF_ENGINE.GetItemAttrText(

1393: itemtype => l_item_type,
1394: itemkey => l_item_key,
1395: aname => 'RETURN_DATE');
1396:
1397: l_return_asset_id := WF_ENGINE.GetItemAttrText(
1398: itemtype => l_item_type,
1399: itemkey => l_item_key,
1400: aname => 'ASSET_ID');
1401:

Line 1590: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1586: -- ********
1587: -- Get the Attribute values
1588: -- ********
1589:
1590: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1591: itemtype => l_item_type,
1592: itemkey => l_item_key,
1593: aname => 'OKL_CONTRACT_ID');
1594:

Line 1595: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1591: itemtype => l_item_type,
1592: itemkey => l_item_key,
1593: aname => 'OKL_CONTRACT_ID');
1594:
1595: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1596: itemtype => l_item_type,
1597: itemkey => l_item_key,
1598: aname => 'OKL_CONTRACT_NUMBER');
1599:

Line 1600: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1596: itemtype => l_item_type,
1597: itemkey => l_item_key,
1598: aname => 'OKL_CONTRACT_NUMBER');
1599:
1600: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1601: itemtype => l_item_type,
1602: itemkey => l_item_key,
1603: aname => 'OKS_CONTRACT_NUMBER');
1604:

Line 1605: l_termination_date := WF_ENGINE.GetItemAttrDate(

1601: itemtype => l_item_type,
1602: itemkey => l_item_key,
1603: aname => 'OKS_CONTRACT_NUMBER');
1604:
1605: l_termination_date := WF_ENGINE.GetItemAttrDate(
1606: itemtype => l_item_type,
1607: itemkey => l_item_key,
1608: aname => 'TERMINATION_DATE');
1609:

Line 1610: l_quote_id := WF_ENGINE.GetItemAttrText(

1606: itemtype => l_item_type,
1607: itemkey => l_item_key,
1608: aname => 'TERMINATION_DATE');
1609:
1610: l_quote_id := WF_ENGINE.GetItemAttrText(
1611: itemtype => l_item_type,
1612: itemkey => l_item_key,
1613: aname => 'QUOTE_ID');
1614:

Line 1803: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1799: -- ********
1800: -- Get the Attribute values
1801: -- ********
1802:
1803: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1804: itemtype => l_item_type,
1805: itemkey => l_item_key,
1806: aname => 'OKL_CONTRACT_ID');
1807:

Line 1808: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1804: itemtype => l_item_type,
1805: itemkey => l_item_key,
1806: aname => 'OKL_CONTRACT_ID');
1807:
1808: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1809: itemtype => l_item_type,
1810: itemkey => l_item_key,
1811: aname => 'OKL_CONTRACT_NUMBER');
1812:

Line 1813: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1809: itemtype => l_item_type,
1810: itemkey => l_item_key,
1811: aname => 'OKL_CONTRACT_NUMBER');
1812:
1813: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1814: itemtype => l_item_type,
1815: itemkey => l_item_key,
1816: aname => 'OKS_CONTRACT_NUMBER');
1817:

Line 1818: l_termination_date := WF_ENGINE.GetItemAttrDate(

1814: itemtype => l_item_type,
1815: itemkey => l_item_key,
1816: aname => 'OKS_CONTRACT_NUMBER');
1817:
1818: l_termination_date := WF_ENGINE.GetItemAttrDate(
1819: itemtype => l_item_type,
1820: itemkey => l_item_key,
1821: aname => 'TERMINATION_DATE');
1822:

Line 1823: l_quote_id := WF_ENGINE.GetItemAttrText(

1819: itemtype => l_item_type,
1820: itemkey => l_item_key,
1821: aname => 'TERMINATION_DATE');
1822:
1823: l_quote_id := WF_ENGINE.GetItemAttrText(
1824: itemtype => l_item_type,
1825: itemkey => l_item_key,
1826: aname => 'QUOTE_ID');
1827:

Line 1989: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1985: -- ********
1986: -- Get the Attribute values
1987: -- ********
1988:
1989: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1990: itemtype => l_item_type,
1991: itemkey => l_item_key,
1992: aname => 'OKL_CONTRACT_ID');
1993:

Line 1994: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1990: itemtype => l_item_type,
1991: itemkey => l_item_key,
1992: aname => 'OKL_CONTRACT_ID');
1993:
1994: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1995: itemtype => l_item_type,
1996: itemkey => l_item_key,
1997: aname => 'OKL_CONTRACT_NUMBER');
1998:

Line 1999: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1995: itemtype => l_item_type,
1996: itemkey => l_item_key,
1997: aname => 'OKL_CONTRACT_NUMBER');
1998:
1999: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
2000: itemtype => l_item_type,
2001: itemkey => l_item_key,
2002: aname => 'OKS_CONTRACT_NUMBER');
2003:

Line 2004: l_termination_date := WF_ENGINE.GetItemAttrDate(

2000: itemtype => l_item_type,
2001: itemkey => l_item_key,
2002: aname => 'OKS_CONTRACT_NUMBER');
2003:
2004: l_termination_date := WF_ENGINE.GetItemAttrDate(
2005: itemtype => l_item_type,
2006: itemkey => l_item_key,
2007: aname => 'TERMINATION_DATE');
2008:

Line 2009: l_quote_id := WF_ENGINE.GetItemAttrText(

2005: itemtype => l_item_type,
2006: itemkey => l_item_key,
2007: aname => 'TERMINATION_DATE');
2008:
2009: l_quote_id := WF_ENGINE.GetItemAttrText(
2010: itemtype => l_item_type,
2011: itemkey => l_item_key,
2012: aname => 'QUOTE_ID');
2013:

Line 2171: l_source := WF_ENGINE.GetItemAttrText(

2167: -- ********
2168: -- Get the values
2169: -- ********
2170:
2171: l_source := WF_ENGINE.GetItemAttrText(
2172: itemtype => itemtype,
2173: itemkey => itemkey,
2174: aname => 'SOURCE');
2175:

Line 2182: WF_ENGINE.SetItemAttrText(

2178: -- ********
2179:
2180: IF l_source = 'SUCCESS' THEN -- From termination, de-link was successful
2181:
2182: WF_ENGINE.SetItemAttrText(
2183: itemtype => itemtype,
2184: itemkey => itemkey,
2185: aname => 'MESSAGE_DOC',
2186: avalue =>

Line 2193: WF_ENGINE.SetItemAttrText(

2189: resultout := 'COMPLETE:SOURCE_SUCCESS';
2190:
2191: ELSIF l_source = 'ERROR' THEN -- From termination, de-link failed
2192:
2193: WF_ENGINE.SetItemAttrText(
2194: itemtype => itemtype,
2195: itemkey => itemkey,
2196: aname => 'MESSAGE_DOC',
2197: avalue =>

Line 2204: WF_ENGINE.SetItemAttrText(

2200: resultout := 'COMPLETE:SOURCE_ERROR';
2201:
2202: ELSIF l_source = 'TERMINATION' THEN -- From termination, de-link not needed
2203:
2204: WF_ENGINE.SetItemAttrText(
2205: itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'MESSAGE_DOC',
2208: avalue =>

Line 2215: WF_ENGINE.SetItemAttrText(

2211: resultout := 'COMPLETE:SOURCE_TERMINATION';
2212:
2213: ELSIF l_source = 'DISPOSE' THEN -- From Asset Dispose
2214:
2215: WF_ENGINE.SetItemAttrText(
2216: itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'MESSAGE_DOC',
2219: avalue =>

Line 2226: WF_ENGINE.SetItemAttrText(

2222: resultout := 'COMPLETE:SOURCE_DISPOSE';
2223:
2224: ELSIF l_source = 'RETURN' THEN -- From Asset Return
2225:
2226: WF_ENGINE.SetItemAttrText(
2227: itemtype => itemtype,
2228: itemkey => itemkey,
2229: aname => 'MESSAGE_DOC',
2230: avalue =>