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_FUNDING_WF dependencies on WF_ENGINE

Line 1270: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1266:
1267: -- "RUN"
1268: IF (funcmode = 'RUN') THEN
1269: --l_user_id := fnd_profile.value('OKL_LEASE_FUNDING_APPROVER');
1270: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1271: itemkey => itemkey,
1272: aname => G_WF_ITM_REQUESTER_ID);
1273:
1274: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1274: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1270: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1271: itemkey => itemkey,
1272: aname => G_WF_ITM_REQUESTER_ID);
1273:
1274: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1275: itemkey => itemkey,
1276: aname => G_WF_ITM_FUNDING_NUMBER);
1277:
1278: resultout := 'COMPLETE:NOT_FOUND'; -- default

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

1278: resultout := 'COMPLETE:NOT_FOUND'; -- default
1279: IF l_user_id IS NOT NULL THEN
1280: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
1281: LOOP
1282: wf_engine.SetItemAttrText (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => G_WF_ITM_APPROVER,
1285: avalue => l_fnd_users_rec.user_name);
1286:

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

1284: aname => G_WF_ITM_APPROVER,
1285: avalue => l_fnd_users_rec.user_name);
1286:
1287:
1288: wf_engine.SetItemAttrText (itemtype => itemtype,
1289: itemkey => itemkey,
1290: aname => G_WF_ITM_MESSAGE_SUBJECT,
1291: avalue =>
1292: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));

Line 1339: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,

1335: BEGIN
1336: SAVEPOINT set_atts;
1337: IF (funcmode = 'RUN') THEN
1338: -- Get current approval status
1339: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
1340: itemkey => itemkey,
1341: aname => G_WF_ITM_RESULT);
1342:
1343: l_parent_key := wf_engine.GetItemAttrText

Line 1343: l_parent_key := wf_engine.GetItemAttrText

1339: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
1340: itemkey => itemkey,
1341: aname => G_WF_ITM_RESULT);
1342:
1343: l_parent_key := wf_engine.GetItemAttrText
1344: (itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => G_WF_ITM_PARENT_ITEM_KEY);
1347:

Line 1348: l_parent_type := wf_engine.GetItemAttrText

1344: (itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => G_WF_ITM_PARENT_ITEM_KEY);
1347:
1348: l_parent_type := wf_engine.GetItemAttrText
1349: (itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => G_WF_ITM_PARENT_ITEM_TYPE);
1352:

Line 1353: l_funding_number := wf_engine.GetItemAttrText

1349: (itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => G_WF_ITM_PARENT_ITEM_TYPE);
1352:
1353: l_funding_number := wf_engine.GetItemAttrText
1354: (itemtype => itemtype,
1355: itemkey => itemkey,
1356: aname => G_WF_ITM_FUNDING_NUMBER);
1357: IF l_result = G_WF_ITM_RESULT_APPROVED THEN

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

1355: itemkey => itemkey,
1356: aname => G_WF_ITM_FUNDING_NUMBER);
1357: IF l_result = G_WF_ITM_RESULT_APPROVED THEN
1358: l_approved_yn := G_WF_ITM_APPROVED_YN_YES;
1359: wf_engine.SetItemAttrText (itemtype => itemtype,
1360: itemkey => itemkey,
1361: aname => G_WF_ITM_MESSAGE_SUBJECT,
1362: avalue =>
1363: -- Fixed incorrect message token 12-05-2003 cklee

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

1363: -- Fixed incorrect message token 12-05-2003 cklee
1364: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));
1365: ELSE
1366: l_approved_yn := G_WF_ITM_APPROVED_YN_NO;
1367: wf_engine.SetItemAttrText (itemtype => itemtype,
1368: itemkey => itemkey,
1369: aname => G_WF_ITM_MESSAGE_SUBJECT,
1370: avalue =>
1371: get_message('OKL_LLA_FUND_REQ_REJECTED_SUB',l_funding_number));

Line 1374: wf_engine.SetItemAttrText(itemtype => l_parent_type,

1370: avalue =>
1371: get_message('OKL_LLA_FUND_REQ_REJECTED_SUB',l_funding_number));
1372: END IF;
1373:
1374: wf_engine.SetItemAttrText(itemtype => l_parent_type,
1375: itemkey => l_parent_key,
1376: aname => G_WF_ITM_APPROVED_YN,
1377: avalue => l_approved_yn);
1378: resultout := 'COMPLETE:';

Line 1453: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1449:
1450:
1451: BEGIN
1452: -- We getting the contract_Id from WF
1453: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1454: itemkey => itemkey,
1455: aname => G_WF_ITM_FUNDING_ID);
1456:
1457: --Run Mode

Line 1459: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,

1455: aname => G_WF_ITM_FUNDING_ID);
1456:
1457: --Run Mode
1458: IF funcmode = 'RUN' THEN
1459: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => G_WF_ITM_APPROVED_YN);
1462:
1463: IF l_approved_yn = G_WF_ITM_APPROVED_YN_YES THEN

Line 1499: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1495: END IF;
1496: END IF;
1497:
1498: -- trx's trx_number IS ame's trx_id
1499: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => G_WF_ITM_TRANSACTION_ID);
1502:
1503: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

Line 1530: resultout := wf_engine.eng_null;

1526: RETURN;
1527: END IF;
1528: --Transfer Mode
1529: IF funcmode = 'TRANSFER' THEN
1530: resultout := wf_engine.eng_null;
1531: RETURN;
1532: END IF;
1533: -- CANCEL mode
1534: IF (funcmode = 'CANCEL') THEN

Line 1594: l_funding_id := wf_engine.GetItemAttrText (

1590: l_message VARCHAR2(4000);
1591: l_funding_id NUMBER;
1592: BEGIN
1593:
1594: l_funding_id := wf_engine.GetItemAttrText (
1595: itemtype => G_ITEM_TYPE_WF,
1596: itemkey => document_id,
1597: aname => G_WF_ITM_FUNDING_ID);
1598:

Line 1630: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1626:
1627: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
1628: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN
1629:
1630: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1631: itemkey => itemkey,
1632: aname => G_WF_ITM_FUNDING_ID);
1633:
1634: l_funding_number := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1634: l_funding_number := wf_engine.GetItemAttrText(itemtype => itemtype,

1630: l_funding_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1631: itemkey => itemkey,
1632: aname => G_WF_ITM_FUNDING_ID);
1633:
1634: l_funding_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1635: itemkey => itemkey,
1636: aname => G_WF_ITM_FUNDING_NUMBER);
1637: wf_engine.SetItemAttrText (itemtype => itemtype,
1638: itemkey => itemkey,

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

1633:
1634: l_funding_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1635: itemkey => itemkey,
1636: aname => G_WF_ITM_FUNDING_NUMBER);
1637: wf_engine.SetItemAttrText (itemtype => itemtype,
1638: itemkey => itemkey,
1639: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1640: avalue => compile_message(l_funding_id));
1641:

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

1638: itemkey => itemkey,
1639: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1640: avalue => compile_message(l_funding_id));
1641:
1642: wf_engine.SetItemAttrText (itemtype => itemtype,
1643: itemkey => itemkey,
1644: aname => G_WF_ITM_APP_REQUEST_SUB,
1645: avalue =>
1646: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));

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

1644: aname => G_WF_ITM_APP_REQUEST_SUB,
1645: avalue =>
1646: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));
1647:
1648: wf_engine.SetItemAttrText (itemtype => itemtype,
1649: itemkey => itemkey,
1650: aname => G_WF_ITM_APP_REMINDER_SUB,
1651: avalue =>
1652: get_message('OKL_LLA_FUND_REQ_APPR_SUB_REMD',l_funding_number));

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

1650: aname => G_WF_ITM_APP_REMINDER_SUB,
1651: avalue =>
1652: get_message('OKL_LLA_FUND_REQ_APPR_SUB_REMD',l_funding_number));
1653:
1654: wf_engine.SetItemAttrText (itemtype => itemtype,
1655: itemkey => itemkey,
1656: aname => G_WF_ITM_APP_APPROVED_SUB,
1657: avalue =>
1658: -- Fixed incorrect message token 12-05-2003 cklee

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

1657: avalue =>
1658: -- Fixed incorrect message token 12-05-2003 cklee
1659: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));
1660:
1661: wf_engine.SetItemAttrText (itemtype => itemtype,
1662: itemkey => itemkey,
1663: aname => G_WF_ITM_APP_REJECTED_SUB,
1664: avalue =>
1665: get_message('OKL_LLA_FUND_REQ_REJECTED_SUB',l_funding_number));

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

1663: aname => G_WF_ITM_APP_REJECTED_SUB,
1664: avalue =>
1665: get_message('OKL_LLA_FUND_REQ_REJECTED_SUB',l_funding_number));
1666:
1667: wf_engine.SetItemAttrText (itemtype => itemtype,
1668: itemkey => itemkey,
1669: aname => G_WF_ITM_APP_REMINDER_HEAD,
1670: avalue =>
1671: get_message('OKL_LLA_FUND_REQ_APPROVAL_REMD',l_funding_number));

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

1669: aname => G_WF_ITM_APP_REMINDER_HEAD,
1670: avalue =>
1671: get_message('OKL_LLA_FUND_REQ_APPROVAL_REMD',l_funding_number));
1672:
1673: wf_engine.SetItemAttrText (itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => G_WF_ITM_APP_APPROVED_HEAD,
1676: avalue =>
1677: -- Fixed incorrect message token 12-05-2003 cklee

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

1676: avalue =>
1677: -- Fixed incorrect message token 12-05-2003 cklee
1678: get_message('OKL_LLA_FUND_REQ_APPROVAL_SUB',l_funding_number));
1679:
1680: wf_engine.SetItemAttrText (itemtype => itemtype,
1681: itemkey => itemkey,
1682: aname => G_WF_ITM_APP_REJECTED_HEAD,
1683: avalue =>
1684: get_message('OKL_LLA_FUND_REQ_REJECTED_SUB',l_funding_number));

Line 1753: wf_engine.CreateProcess(itemtype => l_item_type,

1749: CLOSE l_wf_item_key_csr;
1750:
1751: IF (funcmode = 'RUN') THEN
1752:
1753: wf_engine.CreateProcess(itemtype => l_item_type,
1754: itemkey => l_key,
1755: process => l_process);
1756:
1757: wf_engine.SetItemParent(itemtype => l_item_type,

Line 1757: wf_engine.SetItemParent(itemtype => l_item_type,

1753: wf_engine.CreateProcess(itemtype => l_item_type,
1754: itemkey => l_key,
1755: process => l_process);
1756:
1757: wf_engine.SetItemParent(itemtype => l_item_type,
1758: itemkey => l_key,
1759: parent_itemtype => itemtype,
1760: parent_itemkey => itemkey,
1761: parent_context => G_WF_ITM_MASTER);

Line 1763: wf_engine.SetItemAttrText (

1759: parent_itemtype => itemtype,
1760: parent_itemkey => itemkey,
1761: parent_context => G_WF_ITM_MASTER);
1762:
1763: wf_engine.SetItemAttrText (
1764: itemtype => l_item_type,
1765: itemkey => l_key,
1766: aname => G_WF_ITM_PARENT_ITEM_KEY,
1767: avalue => itemkey);

Line 1769: wf_engine.SetItemAttrText (

1765: itemkey => l_key,
1766: aname => G_WF_ITM_PARENT_ITEM_KEY,
1767: avalue => itemkey);
1768:
1769: wf_engine.SetItemAttrText (
1770: itemtype => l_item_type,
1771: itemkey => l_key,
1772: aname => G_WF_ITM_PARENT_ITEM_TYPE,
1773: avalue => itemtype);

Line 1777: l_funding_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1773: avalue => itemtype);
1774:
1775: -- Re populate Item Attributes for the Detail Process
1776:
1777: l_funding_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1778: itemkey => itemkey,
1779: aname => G_WF_ITM_FUNDING_ID);
1780:
1781: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1781: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1777: l_funding_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1778: itemkey => itemkey,
1779: aname => G_WF_ITM_FUNDING_ID);
1780:
1781: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => G_WF_ITM_FUNDING_NUMBER);
1784:
1785: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1785: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,

1781: l_funding_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => G_WF_ITM_FUNDING_NUMBER);
1784:
1785: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1786: itemkey => itemkey,
1787: aname => G_WF_ITM_REQUESTER);
1788:
1789: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1789: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1785: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1786: itemkey => itemkey,
1787: aname => G_WF_ITM_REQUESTER);
1788:
1789: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1790: itemkey => itemkey,
1791: aname => G_WF_ITM_REQUESTER_ID);
1792:
1793: wf_engine.SetItemAttrText (

Line 1793: wf_engine.SetItemAttrText (

1789: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1790: itemkey => itemkey,
1791: aname => G_WF_ITM_REQUESTER_ID);
1792:
1793: wf_engine.SetItemAttrText (
1794: itemtype => l_item_type,
1795: itemkey => l_key,
1796: aname => G_WF_ITM_FUNDING_ID,
1797: avalue => l_funding_id);

Line 1799: wf_engine.SetItemAttrText (

1795: itemkey => l_key,
1796: aname => G_WF_ITM_FUNDING_ID,
1797: avalue => l_funding_id);
1798:
1799: wf_engine.SetItemAttrText (
1800: itemtype => l_item_type,
1801: itemkey => l_key,
1802: aname => G_WF_ITM_FUNDING_NUMBER,
1803: avalue => l_funding_number);

Line 1805: wf_engine.SetItemAttrText (

1801: itemkey => l_key,
1802: aname => G_WF_ITM_FUNDING_NUMBER,
1803: avalue => l_funding_number);
1804:
1805: wf_engine.SetItemAttrText (
1806: itemtype => l_item_type,
1807: itemkey => l_key,
1808: aname => G_WF_ITM_REQUESTER,
1809: avalue => l_requester);

Line 1810: wf_engine.SetItemAttrText (

1806: itemtype => l_item_type,
1807: itemkey => l_key,
1808: aname => G_WF_ITM_REQUESTER,
1809: avalue => l_requester);
1810: wf_engine.SetItemAttrText (
1811: itemtype => l_item_type,
1812: itemkey => l_key,
1813: aname => G_WF_ITM_REQUESTER_ID,
1814: avalue => l_requester_id);

Line 1817: wf_engine.SetItemAttrText (itemtype => l_item_type,

1813: aname => G_WF_ITM_REQUESTER_ID,
1814: avalue => l_requester_id);
1815:
1816: -- Set the Message Document
1817: wf_engine.SetItemAttrText (itemtype => l_item_type,
1818: itemkey => l_key,
1819: aname => G_WF_ITM_MESSAGE_DOC,
1820: avalue => 'plsql:OKL_FUNDING_WF.pop_approval_doc/'||l_key);
1821:

Line 1823: wf_engine.StartProcess(itemtype => l_item_type,

1819: aname => G_WF_ITM_MESSAGE_DOC,
1820: avalue => 'plsql:OKL_FUNDING_WF.pop_approval_doc/'||l_key);
1821:
1822: -- Now, Start the Detail Process
1823: wf_engine.StartProcess(itemtype => l_item_type,
1824: itemkey => l_key);
1825:
1826: resultout := 'COMPLETE:';
1827: RETURN;