DBA Data[Home] [Help]

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 1153: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1149: -- ********
1150: -- Get the Attribute values
1151: -- ********
1152:
1153: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1154: itemtype => l_item_type,
1155: itemkey => l_item_key,
1156: aname => 'OKL_CONTRACT_NUMBER');
1157:

Line 1158: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1154: itemtype => l_item_type,
1155: itemkey => l_item_key,
1156: aname => 'OKL_CONTRACT_NUMBER');
1157:
1158: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1159: itemtype => l_item_type,
1160: itemkey => l_item_key,
1161: aname => 'OKS_CONTRACT_NUMBER');
1162:

Line 1163: l_dispose_date := WF_ENGINE.GetItemAttrDate(

1159: itemtype => l_item_type,
1160: itemkey => l_item_key,
1161: aname => 'OKS_CONTRACT_NUMBER');
1162:
1163: l_dispose_date := WF_ENGINE.GetItemAttrDate(
1164: itemtype => l_item_type,
1165: itemkey => l_item_key,
1166: aname => 'DISPOSAL_DATE');
1167:

Line 1168: l_dispose_asset_id := WF_ENGINE.GetItemAttrText(

1164: itemtype => l_item_type,
1165: itemkey => l_item_key,
1166: aname => 'DISPOSAL_DATE');
1167:
1168: l_dispose_asset_id := WF_ENGINE.GetItemAttrText(
1169: itemtype => l_item_type,
1170: itemkey => l_item_key,
1171: aname => 'ASSET_ID');
1172:

Line 1321: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1317: -- ********
1318: -- Get the Attribute values
1319: -- ********
1320:
1321: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1322: itemtype => l_item_type,
1323: itemkey => l_item_key,
1324: aname => 'OKL_CONTRACT_NUMBER');
1325:

Line 1326: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1322: itemtype => l_item_type,
1323: itemkey => l_item_key,
1324: aname => 'OKL_CONTRACT_NUMBER');
1325:
1326: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1327: itemtype => l_item_type,
1328: itemkey => l_item_key,
1329: aname => 'OKS_CONTRACT_NUMBER');
1330:

Line 1331: l_return_date := WF_ENGINE.GetItemAttrDate(

1327: itemtype => l_item_type,
1328: itemkey => l_item_key,
1329: aname => 'OKS_CONTRACT_NUMBER');
1330:
1331: l_return_date := WF_ENGINE.GetItemAttrDate(
1332: itemtype => l_item_type,
1333: itemkey => l_item_key,
1334: aname => 'RETURN_DATE');
1335:

Line 1336: l_return_asset_id := WF_ENGINE.GetItemAttrText(

1332: itemtype => l_item_type,
1333: itemkey => l_item_key,
1334: aname => 'RETURN_DATE');
1335:
1336: l_return_asset_id := WF_ENGINE.GetItemAttrText(
1337: itemtype => l_item_type,
1338: itemkey => l_item_key,
1339: aname => 'ASSET_ID');
1340:

Line 1479: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1475: -- ********
1476: -- Get the Attribute values
1477: -- ********
1478:
1479: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1480: itemtype => l_item_type,
1481: itemkey => l_item_key,
1482: aname => 'OKL_CONTRACT_ID');
1483:

Line 1484: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1480: itemtype => l_item_type,
1481: itemkey => l_item_key,
1482: aname => 'OKL_CONTRACT_ID');
1483:
1484: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1485: itemtype => l_item_type,
1486: itemkey => l_item_key,
1487: aname => 'OKL_CONTRACT_NUMBER');
1488:

Line 1489: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1485: itemtype => l_item_type,
1486: itemkey => l_item_key,
1487: aname => 'OKL_CONTRACT_NUMBER');
1488:
1489: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1490: itemtype => l_item_type,
1491: itemkey => l_item_key,
1492: aname => 'OKS_CONTRACT_NUMBER');
1493:

Line 1494: l_termination_date := WF_ENGINE.GetItemAttrDate(

1490: itemtype => l_item_type,
1491: itemkey => l_item_key,
1492: aname => 'OKS_CONTRACT_NUMBER');
1493:
1494: l_termination_date := WF_ENGINE.GetItemAttrDate(
1495: itemtype => l_item_type,
1496: itemkey => l_item_key,
1497: aname => 'TERMINATION_DATE');
1498:

Line 1499: l_quote_id := WF_ENGINE.GetItemAttrText(

1495: itemtype => l_item_type,
1496: itemkey => l_item_key,
1497: aname => 'TERMINATION_DATE');
1498:
1499: l_quote_id := WF_ENGINE.GetItemAttrText(
1500: itemtype => l_item_type,
1501: itemkey => l_item_key,
1502: aname => 'QUOTE_ID');
1503:

Line 1644: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1640: -- ********
1641: -- Get the Attribute values
1642: -- ********
1643:
1644: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1645: itemtype => l_item_type,
1646: itemkey => l_item_key,
1647: aname => 'OKL_CONTRACT_ID');
1648:

Line 1649: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1645: itemtype => l_item_type,
1646: itemkey => l_item_key,
1647: aname => 'OKL_CONTRACT_ID');
1648:
1649: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1650: itemtype => l_item_type,
1651: itemkey => l_item_key,
1652: aname => 'OKL_CONTRACT_NUMBER');
1653:

Line 1654: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1650: itemtype => l_item_type,
1651: itemkey => l_item_key,
1652: aname => 'OKL_CONTRACT_NUMBER');
1653:
1654: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1655: itemtype => l_item_type,
1656: itemkey => l_item_key,
1657: aname => 'OKS_CONTRACT_NUMBER');
1658:

Line 1659: l_termination_date := WF_ENGINE.GetItemAttrDate(

1655: itemtype => l_item_type,
1656: itemkey => l_item_key,
1657: aname => 'OKS_CONTRACT_NUMBER');
1658:
1659: l_termination_date := WF_ENGINE.GetItemAttrDate(
1660: itemtype => l_item_type,
1661: itemkey => l_item_key,
1662: aname => 'TERMINATION_DATE');
1663:

Line 1664: l_quote_id := WF_ENGINE.GetItemAttrText(

1660: itemtype => l_item_type,
1661: itemkey => l_item_key,
1662: aname => 'TERMINATION_DATE');
1663:
1664: l_quote_id := WF_ENGINE.GetItemAttrText(
1665: itemtype => l_item_type,
1666: itemkey => l_item_key,
1667: aname => 'QUOTE_ID');
1668:

Line 1782: l_okl_chr_id := WF_ENGINE.GetItemAttrText(

1778: -- ********
1779: -- Get the Attribute values
1780: -- ********
1781:
1782: l_okl_chr_id := WF_ENGINE.GetItemAttrText(
1783: itemtype => l_item_type,
1784: itemkey => l_item_key,
1785: aname => 'OKL_CONTRACT_ID');
1786:

Line 1787: l_okl_contract_number := WF_ENGINE.GetItemAttrText(

1783: itemtype => l_item_type,
1784: itemkey => l_item_key,
1785: aname => 'OKL_CONTRACT_ID');
1786:
1787: l_okl_contract_number := WF_ENGINE.GetItemAttrText(
1788: itemtype => l_item_type,
1789: itemkey => l_item_key,
1790: aname => 'OKL_CONTRACT_NUMBER');
1791:

Line 1792: l_oks_contract_number := WF_ENGINE.GetItemAttrText(

1788: itemtype => l_item_type,
1789: itemkey => l_item_key,
1790: aname => 'OKL_CONTRACT_NUMBER');
1791:
1792: l_oks_contract_number := WF_ENGINE.GetItemAttrText(
1793: itemtype => l_item_type,
1794: itemkey => l_item_key,
1795: aname => 'OKS_CONTRACT_NUMBER');
1796:

Line 1797: l_termination_date := WF_ENGINE.GetItemAttrDate(

1793: itemtype => l_item_type,
1794: itemkey => l_item_key,
1795: aname => 'OKS_CONTRACT_NUMBER');
1796:
1797: l_termination_date := WF_ENGINE.GetItemAttrDate(
1798: itemtype => l_item_type,
1799: itemkey => l_item_key,
1800: aname => 'TERMINATION_DATE');
1801:

Line 1802: l_quote_id := WF_ENGINE.GetItemAttrText(

1798: itemtype => l_item_type,
1799: itemkey => l_item_key,
1800: aname => 'TERMINATION_DATE');
1801:
1802: l_quote_id := WF_ENGINE.GetItemAttrText(
1803: itemtype => l_item_type,
1804: itemkey => l_item_key,
1805: aname => 'QUOTE_ID');
1806:

Line 1927: l_source := WF_ENGINE.GetItemAttrText(

1923: -- ********
1924: -- Get the values
1925: -- ********
1926:
1927: l_source := WF_ENGINE.GetItemAttrText(
1928: itemtype => itemtype,
1929: itemkey => itemkey,
1930: aname => 'SOURCE');
1931:

Line 1938: WF_ENGINE.SetItemAttrText(

1934: -- ********
1935:
1936: IF l_source = 'SUCCESS' THEN -- From termination, de-link was successful
1937:
1938: WF_ENGINE.SetItemAttrText(
1939: itemtype => itemtype,
1940: itemkey => itemkey,
1941: aname => 'MESSAGE_DOC',
1942: avalue =>

Line 1949: WF_ENGINE.SetItemAttrText(

1945: resultout := 'COMPLETE:SOURCE_SUCCESS';
1946:
1947: ELSIF l_source = 'ERROR' THEN -- From termination, de-link failed
1948:
1949: WF_ENGINE.SetItemAttrText(
1950: itemtype => itemtype,
1951: itemkey => itemkey,
1952: aname => 'MESSAGE_DOC',
1953: avalue =>

Line 1960: WF_ENGINE.SetItemAttrText(

1956: resultout := 'COMPLETE:SOURCE_ERROR';
1957:
1958: ELSIF l_source = 'TERMINATION' THEN -- From termination, de-link not needed
1959:
1960: WF_ENGINE.SetItemAttrText(
1961: itemtype => itemtype,
1962: itemkey => itemkey,
1963: aname => 'MESSAGE_DOC',
1964: avalue =>

Line 1971: WF_ENGINE.SetItemAttrText(

1967: resultout := 'COMPLETE:SOURCE_TERMINATION';
1968:
1969: ELSIF l_source = 'DISPOSE' THEN -- From Asset Dispose
1970:
1971: WF_ENGINE.SetItemAttrText(
1972: itemtype => itemtype,
1973: itemkey => itemkey,
1974: aname => 'MESSAGE_DOC',
1975: avalue =>

Line 1982: WF_ENGINE.SetItemAttrText(

1978: resultout := 'COMPLETE:SOURCE_DISPOSE';
1979:
1980: ELSIF l_source = 'RETURN' THEN -- From Asset Return
1981:
1982: WF_ENGINE.SetItemAttrText(
1983: itemtype => itemtype,
1984: itemkey => itemkey,
1985: aname => 'MESSAGE_DOC',
1986: avalue =>