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.OKS_WF_K_PROCESS_PVT dependencies on WF_ENGINE

Line 692: l_irr_flag := wf_engine.GetItemAttrText(

688: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
689: 'Item Key: ' ||l_item_key);
690: END IF;
691:
692: l_irr_flag := wf_engine.GetItemAttrText(
693: itemtype => G_ITEM_TYPE,
694: itemkey => l_item_key,
695: aname => 'IRR_FLAG');
696:

Line 909: l_publish_manually := wf_engine.GetItemAttrText(

905: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
906: 'Item Key found '||l_item_key);
907: END IF;
908:
909: l_publish_manually := wf_engine.GetItemAttrText(
910: itemtype => G_ITEM_TYPE,
911: itemkey => l_item_key,
912: aname => 'PUBLISH_MAN_YN');
913: IF NVL(l_publish_manually,'N') = 'Y' THEN

Line 916: l_process_type := wf_engine.GetItemAttrText(

912: aname => 'PUBLISH_MAN_YN');
913: IF NVL(l_publish_manually,'N') = 'Y' THEN
914: x_online_yn := 'Y';
915: ELSE
916: l_process_type := wf_engine.GetItemAttrText(
917: itemtype => G_ITEM_TYPE,
918: itemkey => l_item_key,
919: aname => 'PROCESS_TYPE');
920: -- bug fix 5661529

Line 1051: wf_engine.completeactivityinternalname

1047: 'Completing Activity '||G_PKG_NAME ||'.'||l_api_name);
1048: END IF;
1049:
1050: -- Call the wf complete activity
1051: wf_engine.completeactivityinternalname
1052: (
1053: itemtype => G_ITEM_TYPE,
1054: itemkey => l_item_key,
1055: activity => p_activity_name,

Line 1493: wf_engine.SetItemAttrText

1489: l_item_key := p_notif_attr.ITEM_KEY;
1490: END IF;
1491:
1492: IF p_notif_attr.REQ_ASSIST_ROLE IS NOT NULL THEN
1493: wf_engine.SetItemAttrText
1494: (
1495: itemtype => G_ITEM_TYPE,
1496: itemkey => l_item_key,
1497: aname => 'REQ_ASSIST_ROLE',

Line 1503: wf_engine.SetItemAttrText

1499: );
1500: END IF;
1501:
1502: IF p_notif_attr.PERFORMER IS NOT NULL THEN
1503: wf_engine.SetItemAttrText
1504: (
1505: itemtype => G_ITEM_TYPE,
1506: itemkey => l_item_key,
1507: aname => 'PERFORMER',

Line 1541: wf_engine.SetItemAttrText

1537: END IF;
1538: IF x_return_status <> G_RET_STS_SUCCESS THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: END IF;
1541: wf_engine.SetItemAttrText
1542: (
1543: itemtype => G_ITEM_TYPE,
1544: itemkey => l_item_key,
1545: aname => 'PERFORMER',

Line 1550: wf_engine.SetItemAttrText

1546: avalue => NVL(l_salesrep_name,G_DEFAULT_NTF_PERFORMER)
1547: );
1548: END IF;
1549:
1550: wf_engine.SetItemAttrText
1551: (
1552: itemtype => G_ITEM_TYPE,
1553: itemkey => l_item_key,
1554: aname => 'OPERATING_UNIT',

Line 1558: wf_engine.SetItemAttrText

1554: aname => 'OPERATING_UNIT',
1555: avalue => l_kdetails_rec.name
1556: );
1557:
1558: wf_engine.SetItemAttrText
1559: (
1560: itemtype => G_ITEM_TYPE,
1561: itemkey => l_item_key,
1562: aname => 'K_DESCRIPTION',

Line 1566: wf_engine.SetItemAttrText

1562: aname => 'K_DESCRIPTION',
1563: avalue => l_kdetails_rec.short_description
1564: );
1565:
1566: wf_engine.SetItemAttrText
1567: (
1568: itemtype => G_ITEM_TYPE,
1569: itemkey => l_item_key,
1570: aname => 'CONCAT_K_NUMBER',

Line 1578: wf_engine.SetItemAttrText

1574: OPEN l_contact_name_csr(l_salesrep_name);
1575: FETCH l_contact_name_csr INTO l_vc_name;
1576: CLOSE l_contact_name_csr;
1577:
1578: wf_engine.SetItemAttrText
1579: (
1580: itemtype => G_ITEM_TYPE,
1581: itemkey => l_item_key,
1582: aname => 'VC_NAME',

Line 1592: wf_engine.SetItemAttrText

1588: IF p_notif_attr.NTF_TYPE = G_NTF_TYPE_MESSAGE THEN
1589: OPEN l_qto_name_csr(p_notif_attr.CONTRACT_ID);
1590: FETCH l_qto_name_csr INTO l_from_role;
1591: CLOSE l_qto_name_csr;
1592: wf_engine.SetItemAttrText
1593: (
1594: itemtype => G_ITEM_TYPE,
1595: itemkey => l_item_key,
1596: aname => 'FROM',

Line 1600: wf_engine.SetItemAttrText

1596: aname => 'FROM',
1597: avalue => l_from_role
1598: );
1599: ELSE
1600: wf_engine.SetItemAttrText
1601: (
1602: itemtype => G_ITEM_TYPE,
1603: itemkey => l_item_key,
1604: aname => 'FROM',

Line 1609: wf_engine.SetItemAttrText

1605: avalue => l_salesrep_name
1606: );
1607: END IF;
1608:
1609: wf_engine.SetItemAttrText
1610: (
1611: itemtype => G_ITEM_TYPE,
1612: itemkey => l_item_key,
1613: aname => 'NTF_TYPE',

Line 1617: wf_engine.SetItemAttrText

1613: aname => 'NTF_TYPE',
1614: avalue => p_notif_attr.NTF_TYPE
1615: );
1616:
1617: wf_engine.SetItemAttrText
1618: (
1619: itemtype => G_ITEM_TYPE,
1620: itemkey => l_item_key,
1621: aname => 'SUBJECT',

Line 1649: wf_engine.SetItemAttrText

1645:
1646: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_RENEWED THEN
1647: -- Reset notification type since notification doesn't have any special region
1648: -- to be rendered.
1649: wf_engine.SetItemAttrText
1650: (
1651: itemtype => G_ITEM_TYPE,
1652: itemkey => l_item_key,
1653: aname => 'NTF_TYPE',

Line 1699: wf_engine.SetItemAttrText

1695:
1696: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QUOTE_PB THEN
1697: -- Reset notification type since notification doesn't have any special region
1698: -- to be rendered.
1699: wf_engine.SetItemAttrText
1700: (
1701: itemtype => G_ITEM_TYPE,
1702: itemkey => l_item_key,
1703: aname => 'NTF_TYPE',

Line 1717: wf_engine.SetItemAttrText

1713:
1714: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACTIVE THEN
1715: -- Reset notification type since notification doesn't have any special region
1716: -- to be rendered.
1717: wf_engine.SetItemAttrText
1718: (
1719: itemtype => G_ITEM_TYPE,
1720: itemkey => l_item_key,
1721: aname => 'NTF_TYPE',

Line 1736: wf_engine.SetItemAttrText

1732: ELSE
1733: RAISE FND_API.G_EXC_ERROR;
1734: END IF;
1735:
1736: wf_engine.SetItemAttrText
1737: (
1738: itemtype => G_ITEM_TYPE,
1739: itemkey => l_item_key,
1740: aname => 'NTF_SUBJECT',

Line 1747: wf_engine.SetItemAttrText

1743:
1744: -- Initialize all message attributes to Null other than in QA Failure case
1745: IF p_notif_attr.NTF_TYPE <> G_NTF_TYPE_QA_FAIL THEN
1746: FOR l_counter IN 1 .. 10 LOOP
1747: wf_engine.SetItemAttrText
1748: (
1749: itemtype => G_ITEM_TYPE,
1750: itemkey => l_item_key,
1751: aname => 'MESSAGE' || l_counter,

Line 1773: wf_engine.SetItemAttrText

1769: p_data => l_msg_data,
1770: p_msg_index_out => l_msg_index_out
1771: );
1772:
1773: wf_engine.SetItemAttrText
1774: (
1775: itemtype => G_ITEM_TYPE,
1776: itemkey => l_item_key,
1777: aname => 'MESSAGE' || l_counter,

Line 1786: wf_engine.SetItemAttrText

1782: END IF;
1783: -- Messages are passed so assign them to wf message attibutes.
1784: ELSE
1785: IF p_notif_attr.MESSAGE1 IS NOT NULL THEN
1786: wf_engine.SetItemAttrText
1787: (
1788: itemtype => G_ITEM_TYPE,
1789: itemkey => l_item_key,
1790: aname => 'MESSAGE1',

Line 1796: wf_engine.SetItemAttrText

1792: );
1793: END IF;
1794:
1795: IF p_notif_attr.MESSAGE2 IS NOT NULL THEN
1796: wf_engine.SetItemAttrText
1797: (
1798: itemtype => G_ITEM_TYPE,
1799: itemkey => l_item_key,
1800: aname => 'MESSAGE2',

Line 1806: wf_engine.SetItemAttrText

1802: );
1803: END IF;
1804:
1805: IF p_notif_attr.MESSAGE3 IS NOT NULL THEN
1806: wf_engine.SetItemAttrText
1807: (
1808: itemtype => G_ITEM_TYPE,
1809: itemkey => l_item_key,
1810: aname => 'MESSAGE3',

Line 1816: wf_engine.SetItemAttrText

1812: );
1813: END IF;
1814:
1815: IF p_notif_attr.MESSAGE4 IS NOT NULL THEN
1816: wf_engine.SetItemAttrText
1817: (
1818: itemtype => G_ITEM_TYPE,
1819: itemkey => l_item_key,
1820: aname => 'MESSAGE4',

Line 1826: wf_engine.SetItemAttrText

1822: );
1823: END IF;
1824:
1825: IF p_notif_attr.MESSAGE5 IS NOT NULL THEN
1826: wf_engine.SetItemAttrText
1827: (
1828: itemtype => G_ITEM_TYPE,
1829: itemkey => l_item_key,
1830: aname => 'MESSAGE5',

Line 1836: wf_engine.SetItemAttrText

1832: );
1833: END IF;
1834:
1835: IF p_notif_attr.MESSAGE6 IS NOT NULL THEN
1836: wf_engine.SetItemAttrText
1837: (
1838: itemtype => G_ITEM_TYPE,
1839: itemkey => l_item_key,
1840: aname => 'MESSAGE6',

Line 1846: wf_engine.SetItemAttrText

1842: );
1843: END IF;
1844:
1845: IF p_notif_attr.MESSAGE7 IS NOT NULL THEN
1846: wf_engine.SetItemAttrText
1847: (
1848: itemtype => G_ITEM_TYPE,
1849: itemkey => l_item_key,
1850: aname => 'MESSAGE7',

Line 1856: wf_engine.SetItemAttrText

1852: );
1853: END IF;
1854:
1855: IF p_notif_attr.MESSAGE8 IS NOT NULL THEN
1856: wf_engine.SetItemAttrText
1857: (
1858: itemtype => G_ITEM_TYPE,
1859: itemkey => l_item_key,
1860: aname => 'MESSAGE8',

Line 1866: wf_engine.SetItemAttrText

1862: );
1863: END IF;
1864:
1865: IF p_notif_attr.MESSAGE9 IS NOT NULL THEN
1866: wf_engine.SetItemAttrText
1867: (
1868: itemtype => G_ITEM_TYPE,
1869: itemkey => l_item_key,
1870: aname => 'MESSAGE9',

Line 1876: wf_engine.SetItemAttrText

1872: );
1873: END IF;
1874:
1875: IF p_notif_attr.MESSAGE10 IS NOT NULL THEN
1876: wf_engine.SetItemAttrText
1877: (
1878: itemtype => G_ITEM_TYPE,
1879: itemkey => l_item_key,
1880: aname => 'MESSAGE10',

Line 2348: WF_ENGINE.SetItemAttrText

2344: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,
2345: 'Setting workflow attributes ');
2346: END IF;
2347:
2348: WF_ENGINE.SetItemAttrText
2349: (
2350: itemtype => G_ITEM_TYPE,
2351: itemkey => l_item_key,
2352: aname => 'TO_EMAIL',

Line 2356: WF_ENGINE.SetItemAttrText

2352: aname => 'TO_EMAIL',
2353: avalue => l_qto_email
2354: );
2355:
2356: WF_ENGINE.SetItemAttrText
2357: (
2358: itemtype => G_ITEM_TYPE,
2359: itemkey => l_item_key,
2360: aname => 'SENDER_EMAIL',

Line 2364: WF_ENGINE.SetItemAttrNumber

2360: aname => 'SENDER_EMAIL',
2361: avalue => l_sender_email
2362: );
2363:
2364: WF_ENGINE.SetItemAttrNumber
2365: (
2366: itemtype => G_ITEM_TYPE,
2367: itemkey => l_item_key,
2368: aname => 'ATTACHMENT_ID',

Line 2372: WF_ENGINE.SetItemAttrNumber

2368: aname => 'ATTACHMENT_ID',
2369: avalue => NVL(p_email_attr.attachment_id,l_attachment_id)
2370: );
2371:
2372: WF_ENGINE.SetItemAttrNumber
2373: (
2374: itemtype => G_ITEM_TYPE,
2375: itemkey => l_item_key,
2376: aname => 'EMAIL_BODY_ID',

Line 2380: WF_ENGINE.SetItemAttrText

2376: aname => 'EMAIL_BODY_ID',
2377: avalue => NVL(p_email_attr.email_body_id,l_email_body_id)
2378: );
2379:
2380: WF_ENGINE.SetItemAttrText
2381: (
2382: itemtype => G_ITEM_TYPE,
2383: itemkey => l_item_key,
2384: aname => 'ATTACHMENT_NAME',

Line 2388: WF_ENGINE.SetItemAttrText

2384: aname => 'ATTACHMENT_NAME',
2385: avalue => NVL(p_email_attr.attachment_name,l_attachment_name)
2386: );
2387:
2388: WF_ENGINE.SetItemAttrText
2389: (
2390: itemtype => G_ITEM_TYPE,
2391: itemkey => l_item_key,
2392: aname => 'CONTRACT_STATUS',

Line 2396: WF_ENGINE.SetItemAttrText

2392: aname => 'CONTRACT_STATUS',
2393: avalue => NVL(p_email_attr.contract_status,l_contract_status)
2394: );
2395:
2396: WF_ENGINE.SetItemAttrText
2397: (
2398: itemtype => G_ITEM_TYPE,
2399: itemkey => l_item_key,
2400: aname => 'IH_SUBJECT',

Line 2404: WF_ENGINE.SetItemAttrText

2400: aname => 'IH_SUBJECT',
2401: avalue => NVL(p_email_attr.ih_subject,l_ih_subject)
2402: );
2403:
2404: WF_ENGINE.SetItemAttrText
2405: (
2406: itemtype => G_ITEM_TYPE,
2407: itemkey => l_item_key,
2408: aname => 'IH_MESSAGE',

Line 2412: WF_ENGINE.SetItemAttrText

2408: aname => 'IH_MESSAGE',
2409: avalue => NVL(p_email_attr.ih_message,l_ih_message)
2410: );
2411:
2412: WF_ENGINE.SetItemAttrText
2413: (
2414: itemtype => G_ITEM_TYPE,
2415: itemkey => l_item_key,
2416: aname => 'EMAIL_SUBJECT',

Line 2570: wf_engine.SetItemAttrText

2566: ELSIF x_return_status = G_RET_STS_ERROR THEN
2567: RAISE FND_API.G_EXC_ERROR;
2568: END IF;
2569:
2570: wf_engine.SetItemAttrText
2571: (
2572: itemtype => G_ITEM_TYPE,
2573: itemkey => l_item_key,
2574: aname => 'SEND_CONFIRM',

Line 2653: WF_ENGINE.SetItemAttrText

2649: OPEN get_cc_email(p_contract_id);
2650: FETCH get_cc_email INTO l_cc_email_address;
2651: IF get_cc_email%FOUND THEN
2652:
2653: WF_ENGINE.SetItemAttrText
2654: (
2655: itemtype => G_ITEM_TYPE,
2656: itemkey => l_item_key,
2657: aname => 'CC_EMAIL',

Line 2922: wf_engine.SetItemAttrText

2918: ELSIF x_return_status = G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922: wf_engine.SetItemAttrText
2923: (
2924: itemtype => G_ITEM_TYPE,
2925: itemkey => l_item_key,
2926: aname => 'SEND_CONFIRM',

Line 3008: WF_ENGINE.SetItemAttrText

3004: OPEN get_cc_email(p_contract_id);
3005: FETCH get_cc_email INTO l_cc_email_address;
3006: IF get_cc_email%FOUND THEN
3007:
3008: WF_ENGINE.SetItemAttrText
3009: (
3010: itemtype => G_ITEM_TYPE,
3011: itemkey => l_item_key,
3012: aname => 'CC_EMAIL',

Line 3764: l_contract_id := wf_engine.GetItemAttrNumber(

3760: ' funcmode: ' || funcmode);
3761: END IF;
3762: IF (funcmode = 'RUN') THEN
3763:
3764: l_contract_id := wf_engine.GetItemAttrNumber(
3765: itemtype => itemtype,
3766: itemkey => itemkey,
3767: aname => 'CONTRACT_ID');
3768:

Line 3769: l_notif_type := wf_engine.GetActivityAttrText

3765: itemtype => itemtype,
3766: itemkey => itemkey,
3767: aname => 'CONTRACT_ID');
3768:
3769: l_notif_type := wf_engine.GetActivityAttrText
3770: (
3771: itemtype => itemtype,
3772: itemkey => itemkey,
3773: actid => actid,

Line 3840: wf_engine.SetItemAttrText

3836: IF l_return_status <> G_RET_STS_SUCCESS THEN
3837: RAISE FND_API.G_EXC_ERROR;
3838: END IF;
3839:
3840: wf_engine.SetItemAttrText
3841: (
3842: itemtype => itemtype,
3843: itemkey => itemkey,
3844: aname => 'SEND_CONFIRM',

Line 4132: l_contract_id := wf_engine.GetItemAttrNumber(

4128: ' funcmode: ' || funcmode);
4129: END IF;
4130: IF (funcmode = 'RUN') THEN
4131:
4132: l_contract_id := wf_engine.GetItemAttrNumber(
4133: itemtype => itemtype,
4134: itemkey => itemkey,
4135: aname => 'CONTRACT_ID');
4136:

Line 4137: l_email_type := wf_engine.GetActivityAttrText

4133: itemtype => itemtype,
4134: itemkey => itemkey,
4135: aname => 'CONTRACT_ID');
4136:
4137: l_email_type := wf_engine.GetActivityAttrText
4138: (
4139: itemtype => itemtype,
4140: itemkey => itemkey,
4141: actid => actid,

Line 4267: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');

4263: resultout out nocopy varchar2 )
4264: is
4265: l_api_name CONSTANT VARCHAR2(30) := 'email_mute';
4266:
4267: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4268: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4269: cursor c1(p_name varchar2) is
4270: select user_id from fnd_user
4271: where user_name=p_name;

Line 4268: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');

4264: is
4265: l_api_name CONSTANT VARCHAR2(30) := 'email_mute';
4266:
4267: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4268: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4269: cursor c1(p_name varchar2) is
4270: select user_id from fnd_user
4271: where user_name=p_name;
4272: l_user_id number;

Line 4302: wf_engine.SetItemAttrText

4298: APPLICATION_ID => NULL);
4299: end if;
4300:
4301: if (l_p_value is NULL or l_p_value='N') then
4302: wf_engine.SetItemAttrText
4303: (itemtype => G_WF_NAME,
4304: itemkey => itemkey,
4305: aname => '.MAIL_QUERY',
4306: avalue => ' ');

Line 4308: wf_engine.SetItemAttrText

4304: itemkey => itemkey,
4305: aname => '.MAIL_QUERY',
4306: avalue => ' ');
4307: else
4308: wf_engine.SetItemAttrText
4309: (itemtype => G_WF_NAME,
4310: itemkey => itemkey,
4311: aname => '.MAIL_QUERY',
4312: avalue => l_user_name);

Line 4504: l_save_threshold := WF_ENGINE.threshold;

4500: ' Contract Id: ' || p_wf_attributes.contract_id ||
4501: ' User Key: ' || l_user_key );
4502: END IF;
4503: ELSE
4504: l_save_threshold := WF_ENGINE.threshold;
4505: WF_ENGINE.threshold := -1;
4506: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4507: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4508: 'Process will be deferred for Item key: ' || l_item_key ||

Line 4505: WF_ENGINE.threshold := -1;

4501: ' User Key: ' || l_user_key );
4502: END IF;
4503: ELSE
4504: l_save_threshold := WF_ENGINE.threshold;
4505: WF_ENGINE.threshold := -1;
4506: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4507: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4508: 'Process will be deferred for Item key: ' || l_item_key ||
4509: ' Contract Id: ' || p_wf_attributes.contract_id ||

Line 4515: WF_ENGINE.CREATEPROCESS

4511: END IF;
4512: END IF;
4513:
4514: -- Create the workflow process
4515: WF_ENGINE.CREATEPROCESS
4516: (
4517: itemtype => G_ITEM_TYPE,
4518: itemkey => l_item_key,
4519: process => G_MAIN_PROCESS,

Line 4523: wf_engine.SetItemAttrNumber

4519: process => G_MAIN_PROCESS,
4520: user_key => l_user_key
4521: );
4522:
4523: wf_engine.SetItemAttrNumber
4524: (
4525: itemtype => G_ITEM_TYPE,
4526: itemkey => l_item_key,
4527: aname => 'CONTRACT_ID',

Line 4531: WF_ENGINE.setitemattrtext

4527: aname => 'CONTRACT_ID',
4528: avalue => p_wf_attributes.contract_id
4529: );
4530:
4531: WF_ENGINE.setitemattrtext
4532: (
4533: itemtype => G_ITEM_TYPE,
4534: itemkey => l_item_key,
4535: aname => 'CONTRACT_NUMBER',

Line 4539: WF_ENGINE.setitemattrtext

4535: aname => 'CONTRACT_NUMBER',
4536: avalue => l_contract_number
4537: );
4538:
4539: WF_ENGINE.setitemattrtext
4540: (
4541: itemtype => G_ITEM_TYPE,
4542: itemkey => l_item_key,
4543: aname => 'CONTRACT_MODIFIER',

Line 4548: WF_ENGINE.setitemattrtext

4544: avalue => l_contract_modifier
4545: );
4546:
4547: IF p_wf_attributes.process_type IS NOT NULL THEN
4548: WF_ENGINE.setitemattrtext
4549: (
4550: itemtype => G_ITEM_TYPE,
4551: itemkey => l_item_key,
4552: aname => 'PROCESS_TYPE',

Line 4557: WF_ENGINE.setitemattrtext

4553: avalue => p_wf_attributes.process_type
4554: );
4555: END IF;
4556: IF p_wf_attributes.irr_flag IS NOT NULL THEN
4557: WF_ENGINE.setitemattrtext
4558: (
4559: itemtype => G_ITEM_TYPE,
4560: itemkey => l_item_key,
4561: aname => 'IRR_FLAG',

Line 4568: WF_ENGINE.setitemattrtext

4564: END IF;
4565: IF p_wf_attributes.negotiation_status IS NOT NULL AND
4566: p_wf_attributes.negotiation_status <> G_NEG_STS_PRE_DRAFT THEN
4567:
4568: WF_ENGINE.setitemattrtext
4569: (
4570: itemtype => G_ITEM_TYPE,
4571: itemkey => l_item_key,
4572: aname => 'NEGOTIATION_STATUS',

Line 4579: wf_engine.SetItemAttrNumber

4575: END IF;
4576:
4577: -- Added 4 item attributes below to fix bug 4776175
4578: -- These values are passed to approval workflow
4579: wf_engine.SetItemAttrNumber
4580: (
4581: itemtype => G_ITEM_TYPE,
4582: itemkey => l_item_key,
4583: aname => 'USER_ID',

Line 4587: wf_engine.SetItemAttrNumber

4583: aname => 'USER_ID',
4584: avalue => fnd_global.user_id
4585: );
4586:
4587: wf_engine.SetItemAttrNumber
4588: (
4589: itemtype => G_ITEM_TYPE,
4590: itemkey => l_item_key,
4591: aname => 'RESP_ID',

Line 4595: wf_engine.SetItemAttrNumber

4591: aname => 'RESP_ID',
4592: avalue => fnd_global.resp_id
4593: );
4594:
4595: wf_engine.SetItemAttrNumber
4596: (
4597: itemtype => G_ITEM_TYPE,
4598: itemkey => l_item_key,
4599: aname => 'RESP_APPL_ID',

Line 4603: wf_engine.SetItemAttrNumber

4599: aname => 'RESP_APPL_ID',
4600: avalue => fnd_global.resp_appl_id
4601: );
4602:
4603: wf_engine.SetItemAttrNumber
4604: (
4605: itemtype => G_ITEM_TYPE,
4606: itemkey => l_item_key,
4607: aname => 'SECURITY_GROUP_ID',

Line 4619: WF_ENGINE.setitemowner

4615: ' IRR Flag: ' || NVL(p_wf_attributes.irr_flag,'NULL'));
4616: END IF;
4617:
4618: -- Assign owner to the workflow instance. Bug fix 4752631
4619: WF_ENGINE.setitemowner
4620: (
4621: itemtype => G_ITEM_TYPE,
4622: itemkey => l_item_key,
4623: owner => fnd_global.user_name

Line 4627: WF_ENGINE.STARTPROCESS

4623: owner => fnd_global.user_name
4624: );
4625:
4626: -- Start the workflow process
4627: WF_ENGINE.STARTPROCESS
4628: (
4629: itemtype => G_ITEM_TYPE,
4630: itemkey => l_item_key
4631: );

Line 4660: WF_ENGINE.threshold := l_save_threshold;

4656: END IF;
4657:
4658: --Always reset threshold or all activities in this session will be deferred.
4659: IF p_wf_attributes.negotiation_status = G_NEG_STS_PRE_DRAFT THEN
4660: WF_ENGINE.threshold := l_save_threshold;
4661: END IF;
4662:
4663: IF FND_API.to_boolean( p_commit ) THEN
4664: COMMIT;

Line 4980: wf_engine.abortprocess

4976: IF l_count > 0 THEN
4977: -- End of code added for Bug#14150408
4978:
4979: -- Abort the workflow process and purging code goes here
4980: wf_engine.abortprocess
4981: (
4982: itemtype => G_ITEM_TYPE,
4983: itemkey => l_item_key
4984: );

Line 5088: l_contract_id := wf_engine.GetItemAttrNumber(

5084: ' actid: ' || to_char(actid) ||
5085: ' funcmode: ' || funcmode);
5086: END IF;
5087: IF (funcmode = 'RUN') THEN
5088: l_contract_id := wf_engine.GetItemAttrNumber(
5089: itemtype => itemtype,
5090: itemkey => itemkey,
5091: aname => 'CONTRACT_ID');
5092:

Line 5094: /* WF_ENGINE.setitemattrtext

5090: itemkey => itemkey,
5091: aname => 'CONTRACT_ID');
5092:
5093: -- Set any other optional values to item attributes
5094: /* WF_ENGINE.setitemattrtext
5095: (
5096: itemtype => itemtype,
5097: itemkey => itemkey,
5098: aname => 'CONTRACT_NUMBER',

Line 5102: WF_ENGINE.SetItemAttrText

5098: aname => 'CONTRACT_NUMBER',
5099: avalue => l_kdetails_rec.contract_number
5100: );
5101:
5102: WF_ENGINE.SetItemAttrText
5103: (
5104: itemtype => itemtype,
5105: itemkey => itemkey,
5106: aname => 'CONTRACT_MODIFIER',

Line 5237: l_contract_id := wf_engine.GetItemAttrNumber(

5233: ' actid: ' || to_char(actid) ||
5234: ' funcmode: ' || funcmode);
5235: END IF;
5236: IF (funcmode = 'RUN') THEN
5237: l_contract_id := wf_engine.GetItemAttrNumber(
5238: itemtype => itemtype,
5239: itemkey => itemkey,
5240: aname => 'CONTRACT_ID');
5241:

Line 5243: l_negotiation_status := wf_engine.GetItemAttrText(

5239: itemkey => itemkey,
5240: aname => 'CONTRACT_ID');
5241:
5242: -- Get negotiation status
5243: l_negotiation_status := wf_engine.GetItemAttrText(
5244: itemtype => itemtype,
5245: itemkey => itemkey,
5246: aname => 'NEGOTIATION_STATUS');
5247:

Line 5264: wf_engine.SetItemAttrNumber

5260: -- and stamp it in the new OKSKPRCS wf. bug 5723364. R12 Upgrade script
5261: -- is incorrectly setting these attributes to FND_GLOBAL values
5262: FOR l_user_dtls_rec IN l_user_dtls_csr(l_contract_id)
5263: LOOP
5264: wf_engine.SetItemAttrNumber
5265: (
5266: itemtype => itemtype,
5267: itemkey => itemkey,
5268: aname => l_user_dtls_rec.attr_name,

Line 5281: wf_engine.SetItemAttrNumber

5277: OPEN l_resp_appl_id_csr(l_resp_id);
5278: FETCH l_resp_appl_id_csr INTO l_resp_appl_id;
5279: CLOSE l_resp_appl_id_csr;
5280:
5281: wf_engine.SetItemAttrNumber
5282: (
5283: itemtype => itemtype,
5284: itemkey => itemkey,
5285: aname => 'RESP_APPL_ID',

Line 5357: wf_engine.SetItemAttrText

5353: END IF;
5354:
5355: -- Reset negotiation status to NULL so that no other process will
5356: -- update incorrect Negotiation status
5357: wf_engine.SetItemAttrText
5358: (
5359: itemtype => itemtype,
5360: itemkey => itemkey,
5361: aname => 'NEGOTIATION_STATUS',

Line 5461: l_contract_id := wf_engine.GetItemAttrNumber(

5457: ' funcmode: ' || funcmode);
5458: END IF;
5459: IF (funcmode = 'RUN') THEN
5460:
5461: l_contract_id := wf_engine.GetItemAttrNumber(
5462: itemtype => itemtype,
5463: itemkey => itemkey,
5464: aname => 'CONTRACT_ID');
5465:

Line 5470: l_process_type := wf_engine.GetItemAttrText(

5466: -- Get process type to determine if this is a new or a renewal contract
5467: -- If it is a new contract, process type is always Manual
5468: -- If it is a renewal contract, determine if this contract qualifies
5469: -- for either Online or Evergreen process
5470: l_process_type := wf_engine.GetItemAttrText(
5471: itemtype => itemtype,
5472: itemkey => itemkey,
5473: aname => 'PROCESS_TYPE');
5474:

Line 5627: l_contract_id := wf_engine.GetItemAttrNumber(

5623: ' funcmode: ' || funcmode);
5624: END IF;
5625: IF (funcmode = 'RUN') THEN
5626:
5627: l_contract_id := wf_engine.GetItemAttrNumber(
5628: itemtype => itemtype,
5629: itemkey => itemkey,
5630: aname => 'CONTRACT_ID');
5631:

Line 5965: wf_engine.SetItemAttrNumber(

5961: ' Security Group Id=>'||p_security_group_id );
5962: END IF;
5963: -- Reset following item attributes to reflect the current user
5964: begin
5965: wf_engine.SetItemAttrNumber(
5966: itemtype => G_ITEM_TYPE,
5967: itemkey => p_wf_item_key,
5968: aname => 'USER_ID',
5969: avalue => p_user_id);

Line 5972: wf_engine.AddItemAttr (

5968: aname => 'USER_ID',
5969: avalue => p_user_id);
5970: exception
5971: when others then
5972: wf_engine.AddItemAttr (
5973: itemtype => G_ITEM_TYPE,
5974: itemkey => p_wf_item_key,
5975: aname => 'USER_ID');
5976:

Line 5977: wf_engine.SetItemAttrNumber (

5973: itemtype => G_ITEM_TYPE,
5974: itemkey => p_wf_item_key,
5975: aname => 'USER_ID');
5976:
5977: wf_engine.SetItemAttrNumber (
5978: itemtype => G_ITEM_TYPE,
5979: itemkey => p_wf_item_key,
5980: aname => 'USER_ID',
5981: avalue => p_user_id);

Line 5984: wf_engine.SetItemAttrNumber(

5980: aname => 'USER_ID',
5981: avalue => p_user_id);
5982: end;
5983: begin
5984: wf_engine.SetItemAttrNumber(
5985: itemtype => G_ITEM_TYPE,
5986: itemkey => p_wf_item_key,
5987: aname => 'RESP_ID',
5988: avalue => p_resp_id);

Line 5991: wf_engine.AddItemAttr (

5987: aname => 'RESP_ID',
5988: avalue => p_resp_id);
5989: exception
5990: when others then
5991: wf_engine.AddItemAttr (
5992: itemtype => G_ITEM_TYPE,
5993: itemkey => p_wf_item_key,
5994: aname => 'RESP_ID');
5995:

Line 5996: wf_engine.SetItemAttrNumber (

5992: itemtype => G_ITEM_TYPE,
5993: itemkey => p_wf_item_key,
5994: aname => 'RESP_ID');
5995:
5996: wf_engine.SetItemAttrNumber (
5997: itemtype => G_ITEM_TYPE,
5998: itemkey => p_wf_item_key,
5999: aname => 'RESP_ID',
6000: avalue => p_resp_id);

Line 6003: wf_engine.SetItemAttrNumber(

5999: aname => 'RESP_ID',
6000: avalue => p_resp_id);
6001: end;
6002: begin
6003: wf_engine.SetItemAttrNumber(
6004: itemtype => G_ITEM_TYPE,
6005: itemkey => p_wf_item_key,
6006: aname => 'RESP_APPL_ID',
6007: avalue => p_resp_appl_id);

Line 6010: wf_engine.AddItemAttr (

6006: aname => 'RESP_APPL_ID',
6007: avalue => p_resp_appl_id);
6008: exception
6009: when others then
6010: wf_engine.AddItemAttr (
6011: itemtype => G_ITEM_TYPE,
6012: itemkey => p_wf_item_key,
6013: aname => 'RESP_APPL_ID');
6014:

Line 6015: wf_engine.SetItemAttrNumber (

6011: itemtype => G_ITEM_TYPE,
6012: itemkey => p_wf_item_key,
6013: aname => 'RESP_APPL_ID');
6014:
6015: wf_engine.SetItemAttrNumber (
6016: itemtype => G_ITEM_TYPE,
6017: itemkey => p_wf_item_key,
6018: aname => 'RESP_APPL_ID',
6019: avalue => p_resp_appl_id);

Line 6022: wf_engine.SetItemAttrNumber(

6018: aname => 'RESP_APPL_ID',
6019: avalue => p_resp_appl_id);
6020: end;
6021: begin
6022: wf_engine.SetItemAttrNumber(
6023: itemtype => G_ITEM_TYPE,
6024: itemkey => p_wf_item_key,
6025: aname => 'SECURITY_GROUP_ID',
6026: avalue => p_security_group_id);

Line 6029: wf_engine.AddItemAttr (

6025: aname => 'SECURITY_GROUP_ID',
6026: avalue => p_security_group_id);
6027: exception
6028: when others then
6029: wf_engine.AddItemAttr (
6030: itemtype => G_ITEM_TYPE,
6031: itemkey => p_wf_item_key,
6032: aname => 'SECURITY_GROUP_ID');
6033:

Line 6034: wf_engine.SetItemAttrNumber (

6030: itemtype => G_ITEM_TYPE,
6031: itemkey => p_wf_item_key,
6032: aname => 'SECURITY_GROUP_ID');
6033:
6034: wf_engine.SetItemAttrNumber (
6035: itemtype => G_ITEM_TYPE,
6036: itemkey => p_wf_item_key,
6037: aname => 'SECURITY_GROUP_ID',
6038: avalue => p_security_group_id);

Line 6213: wf_engine.SetItemAttrText

6209: ELSIF x_return_status = G_RET_STS_ERROR THEN
6210: RAISE FND_API.G_EXC_ERROR;
6211: END IF;
6212:
6213: wf_engine.SetItemAttrText
6214: (
6215: itemtype => G_ITEM_TYPE,
6216: itemkey => l_item_key,
6217: aname => 'SEND_CONFIRM',

Line 6290: wf_engine.SetItemAttrText

6286: END IF;
6287:
6288: -- If submit for approval action is taken at Authoring set this flag to 'N' so
6289: -- that QA check is not performed but when taken at Workbench, set it to 'Y'.
6290: wf_engine.SetItemAttrText
6291: (
6292: itemtype => G_ITEM_TYPE,
6293: itemkey => l_item_key,
6294: aname => 'QA_REQUIRED_YN',

Line 6533: wf_engine.SetItemAttrText

6529:
6530: -- Set this item attribute to 'Y' which indicates that this contract was
6531: -- published online manually. This is an important attribute since this is the only
6532: -- contract information that specifies that a contract is going thru online process
6533: wf_engine.SetItemAttrText
6534: (
6535: itemtype => G_ITEM_TYPE,
6536: itemkey => l_item_key,
6537: aname => 'PUBLISH_MAN_YN',

Line 6673: l_contract_id := wf_engine.GetItemAttrNumber(

6669: ' funcmode: ' || funcmode);
6670: END IF;
6671: IF (funcmode = 'RUN') THEN
6672:
6673: l_contract_id := wf_engine.GetItemAttrNumber(
6674: itemtype => itemtype,
6675: itemkey => itemkey,
6676: aname => 'CONTRACT_ID');
6677:

Line 6680: wf_engine.SetItemAttrText

6676: aname => 'CONTRACT_ID');
6677:
6678: -- Initialize workflow message attributes to Null.
6679: FOR l_count IN 1 .. 10 LOOP
6680: wf_engine.SetItemAttrText
6681: (
6682: itemtype => itemtype,
6683: itemkey => itemkey,
6684: aname => 'MESSAGE' || l_count,

Line 6759: wf_engine.SetItemAttrText

6755: l_negotiation_status := G_NEG_STS_IA_QA_FAIL;
6756: END IF;
6757:
6758: IF l_msg_ctr <= 10 THEN
6759: wf_engine.SetItemAttrText
6760: (
6761: itemtype => itemtype,
6762: itemkey => itemkey,
6763: aname => 'MESSAGE' || l_msg_ctr,

Line 6801: wf_engine.SetItemAttrText

6797: WHEN FND_API.G_EXC_ERROR THEN
6798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
6799: -- Set the message only when a vacant message item attribute is available
6800: IF (l_msg_ctr < 10) THEN
6801: wf_engine.SetItemAttrText
6802: (
6803: itemtype => itemtype,
6804: itemkey => itemkey,
6805: aname => 'MESSAGE' || l_msg_ctr,

Line 6953: wf_engine.SetItemAttrText

6949: -- even with an expense of loosing a populated message.
6950: IF l_msg_ctr > 10 THEN
6951: l_msg_ctr := 10;
6952: END IF;
6953: wf_engine.SetItemAttrText
6954: (
6955: itemtype => itemtype,
6956: itemkey => itemkey,
6957: aname => 'MESSAGE' || l_msg_ctr,

Line 7009: wf_engine.SetItemAttrText

7005: -- even with an expense of loosing a populated message.
7006: IF l_msg_ctr > 10 THEN
7007: l_msg_ctr := 10;
7008: END IF;
7009: wf_engine.SetItemAttrText
7010: (
7011: itemtype => itemtype,
7012: itemkey => itemkey,
7013: aname => 'MESSAGE' || l_msg_ctr,

Line 7202: l_contract_id := wf_engine.GetItemAttrNumber(

7198: ' funcmode: ' || funcmode);
7199: END IF;
7200: IF (funcmode = 'RUN') THEN
7201:
7202: l_contract_id := wf_engine.GetItemAttrNumber(
7203: itemtype => itemtype,
7204: itemkey => itemkey,
7205: aname => 'CONTRACT_ID');
7206:

Line 7209: l_irr_flag := wf_engine.GetItemAttrText(

7205: aname => 'CONTRACT_ID');
7206:
7207: -- Get submit for approval flag to determine if this contract
7208: -- requires explict action by salesrep.
7209: l_irr_flag := wf_engine.GetItemAttrText(
7210: itemtype => itemtype,
7211: itemkey => itemkey,
7212: aname => 'IRR_FLAG');
7213:

Line 7482: l_contract_id := wf_engine.GetItemAttrNumber(

7478: ' funcmode: ' || funcmode);
7479: END IF;
7480: IF (funcmode = 'RUN') THEN
7481:
7482: l_contract_id := wf_engine.GetItemAttrNumber(
7483: itemtype => itemtype,
7484: itemkey => itemkey,
7485: aname => 'CONTRACT_ID');
7486:

Line 7487: l_negotiation_status := wf_engine.GetActivityAttrText(

7483: itemtype => itemtype,
7484: itemkey => itemkey,
7485: aname => 'CONTRACT_ID');
7486:
7487: l_negotiation_status := wf_engine.GetActivityAttrText(
7488: itemtype => itemtype,
7489: itemkey => itemkey,
7490: actid => actid,
7491: aname => 'TARGET_NEGO_STATUS');

Line 7662: l_user_id := wf_engine.GetItemAttrNumber

7658: ' p_commit: ' || p_commit ||
7659: ' p_wf_item_key: ' || p_wf_item_key);
7660: END IF;
7661: BEGIN
7662: l_user_id := wf_engine.GetItemAttrNumber
7663: (
7664: itemtype => G_ITEM_TYPE,
7665: itemkey => p_wf_item_key,
7666: aname => 'USER_ID'

Line 7670: wf_engine.AddItemAttr

7666: aname => 'USER_ID'
7667: );
7668: EXCEPTION
7669: WHEN OTHERS THEN
7670: wf_engine.AddItemAttr
7671: (
7672: itemtype => G_ITEM_TYPE,
7673: itemkey => p_wf_item_key,
7674: aname => 'USER_ID'

Line 7676: wf_engine.SetItemAttrNumber

7672: itemtype => G_ITEM_TYPE,
7673: itemkey => p_wf_item_key,
7674: aname => 'USER_ID'
7675: );
7676: wf_engine.SetItemAttrNumber
7677: (
7678: itemtype => G_ITEM_TYPE,
7679: itemkey => p_wf_item_key,
7680: aname => 'USER_ID',

Line 7685: l_resp_id := wf_engine.GetItemAttrNumber

7681: avalue => null
7682: );
7683: END;
7684: BEGIN
7685: l_resp_id := wf_engine.GetItemAttrNumber
7686: (
7687: itemtype => G_ITEM_TYPE,
7688: itemkey => p_wf_item_key,
7689: aname => 'RESP_ID'

Line 7693: wf_engine.AddItemAttr

7689: aname => 'RESP_ID'
7690: );
7691: EXCEPTION
7692: WHEN OTHERS THEN
7693: wf_engine.AddItemAttr
7694: (
7695: itemtype => G_ITEM_TYPE,
7696: itemkey => p_wf_item_key,
7697: aname => 'RESP_ID'

Line 7699: wf_engine.SetItemAttrNumber

7695: itemtype => G_ITEM_TYPE,
7696: itemkey => p_wf_item_key,
7697: aname => 'RESP_ID'
7698: );
7699: wf_engine.SetItemAttrNumber
7700: (
7701: itemtype => G_ITEM_TYPE,
7702: itemkey => p_wf_item_key,
7703: aname => 'RESP_ID',

Line 7708: l_resp_appl_id := wf_engine.GetItemAttrNumber

7704: avalue => null
7705: );
7706: END;
7707: BEGIN
7708: l_resp_appl_id := wf_engine.GetItemAttrNumber
7709: (
7710: itemtype => G_ITEM_TYPE,
7711: itemkey => p_wf_item_key,
7712: aname => 'RESP_APPL_ID'

Line 7717: wf_engine.AddItemAttr

7713: );
7714:
7715: EXCEPTION
7716: WHEN OTHERS THEN
7717: wf_engine.AddItemAttr
7718: (
7719: itemtype => G_ITEM_TYPE,
7720: itemkey => p_wf_item_key,
7721: aname => 'RESP_APPL_ID'

Line 7723: wf_engine.SetItemAttrNumber

7719: itemtype => G_ITEM_TYPE,
7720: itemkey => p_wf_item_key,
7721: aname => 'RESP_APPL_ID'
7722: );
7723: wf_engine.SetItemAttrNumber
7724: (
7725: itemtype => G_ITEM_TYPE,
7726: itemkey => p_wf_item_key,
7727: aname => 'RESP_APPL_ID',

Line 7732: l_security_group_id := wf_engine.GetItemAttrNumber

7728: avalue => null
7729: );
7730: END;
7731: BEGIN
7732: l_security_group_id := wf_engine.GetItemAttrNumber
7733: (
7734: itemtype => G_ITEM_TYPE,
7735: itemkey => p_wf_item_key,
7736: aname => 'SECURITY_GROUP_ID'

Line 7740: wf_engine.AddItemAttr

7736: aname => 'SECURITY_GROUP_ID'
7737: );
7738: EXCEPTION
7739: WHEN OTHERS THEN
7740: wf_engine.AddItemAttr
7741: (
7742: itemtype => G_ITEM_TYPE,
7743: itemkey => p_wf_item_key,
7744: aname => 'SECURITY_GROUP_ID'

Line 7746: wf_engine.SetItemAttrNumber

7742: itemtype => G_ITEM_TYPE,
7743: itemkey => p_wf_item_key,
7744: aname => 'SECURITY_GROUP_ID'
7745: );
7746: wf_engine.SetItemAttrNumber
7747: (
7748: itemtype => G_ITEM_TYPE,
7749: itemkey => p_wf_item_key,
7750: aname => 'SECURITY_GROUP_ID',

Line 7859: l_contract_id := wf_engine.GetItemAttrNumber(

7855: ' funcmode: ' || funcmode);
7856: END IF;
7857: IF (funcmode = 'RUN') THEN
7858:
7859: l_contract_id := wf_engine.GetItemAttrNumber(
7860: itemtype => itemtype,
7861: itemkey => itemkey,
7862: aname => 'CONTRACT_ID');
7863:

Line 8116: wf_engine.SetItemAttrText

8112: l_item_key := p_item_key;
8113: END IF;
8114:
8115: -- Check if a confirmation email has to be delivered or not
8116: wf_engine.SetItemAttrText
8117: (
8118: itemtype => G_ITEM_TYPE,
8119: itemkey => l_item_key,
8120: aname => 'SEND_CONFIRM',

Line 8409: wf_engine.SetItemAttrText

8405: ELSIF x_return_status = G_RET_STS_ERROR THEN
8406: RAISE FND_API.G_EXC_ERROR;
8407: END IF;
8408:
8409: wf_engine.SetItemAttrText
8410: (
8411: itemtype => G_ITEM_TYPE,
8412: itemkey => l_item_key,
8413: aname => 'SEND_CONFIRM',

Line 8503: wf_engine.AbortProcess (G_ITEM_TYPE, l_item_key);

8499: last_update_date = SYSDATE,
8500: last_updated_by = FND_GLOBAL.USER_ID,
8501: last_update_login = FND_GLOBAL.LOGIN_ID
8502: WHERE chr_id = p_contract_id;
8503: wf_engine.AbortProcess (G_ITEM_TYPE, l_item_key);
8504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8506: 'Updated Contract and Process Aborted '||G_PKG_NAME ||'.'||l_api_name);
8507: END IF;

Line 8636: l_contract_id := wf_engine.GetItemAttrNumber(

8632: ' funcmode: ' || funcmode);
8633: END IF;
8634: IF (funcmode = 'RUN') THEN
8635:
8636: l_contract_id := wf_engine.GetItemAttrNumber(
8637: itemtype => itemtype,
8638: itemkey => itemkey,
8639: aname => 'CONTRACT_ID');
8640:

Line 9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;

9022: l_wf_err_name VARCHAR2(30);
9023: l_wf_err_msg VARCHAR2(2000);
9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;

Line 9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;

9023: l_wf_err_msg VARCHAR2(2000);
9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;

Line 9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;

9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;

Line 9030: l_contract_id_names WF_ENGINE.nametabtyp;

9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;

Line 9031: l_contract_number_names WF_ENGINE.nametabtyp;

9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;

Line 9032: l_contract_modifier_names WF_ENGINE.nametabtyp;

9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;

Line 9033: l_process_type_names WF_ENGINE.nametabtyp;

9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;

Line 9034: l_irr_flag_names WF_ENGINE.nametabtyp;

9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;

Line 9035: l_neg_status_names WF_ENGINE.nametabtyp;

9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;

Line 9036: l_user_id_names WF_ENGINE.nametabtyp;

9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:

Line 9037: l_responsibility_id_names WF_ENGINE.nametabtyp;

9033: l_process_type_names WF_ENGINE.nametabtyp;
9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;

Line 9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;

9034: l_irr_flag_names WF_ENGINE.nametabtyp;
9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;

Line 9039: l_security_group_id_names WF_ENGINE.nametabtyp;

9035: l_neg_status_names WF_ENGINE.nametabtyp;
9036: l_user_id_names WF_ENGINE.nametabtyp;
9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;

Line 9041: l_contract_id_values WF_ENGINE.numtabtyp;

9037: l_responsibility_id_names WF_ENGINE.nametabtyp;
9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;

Line 9042: l_contract_number_values WF_ENGINE.texttabtyp;

9038: l_resp_appl_id_names WF_ENGINE.nametabtyp;
9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;

Line 9043: l_contract_modifier_values WF_ENGINE.texttabtyp;

9039: l_security_group_id_names WF_ENGINE.nametabtyp;
9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;

Line 9044: l_process_type_values WF_ENGINE.texttabtyp;

9040:
9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;

Line 9045: l_irr_flag_values WF_ENGINE.texttabtyp;

9041: l_contract_id_values WF_ENGINE.numtabtyp;
9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;

Line 9046: l_neg_status_values WF_ENGINE.texttabtyp;

9042: l_contract_number_values WF_ENGINE.texttabtyp;
9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;
9050: l_security_group_id_values WF_ENGINE.numtabtyp;

Line 9047: l_user_id_values WF_ENGINE.numtabtyp;

9043: l_contract_modifier_values WF_ENGINE.texttabtyp;
9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;
9050: l_security_group_id_values WF_ENGINE.numtabtyp;
9051:

Line 9048: l_responsibility_id_values WF_ENGINE.numtabtyp;

9044: l_process_type_values WF_ENGINE.texttabtyp;
9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;
9050: l_security_group_id_values WF_ENGINE.numtabtyp;
9051:
9052: l_contract_id_count NUMBER := 0;

Line 9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;

9045: l_irr_flag_values WF_ENGINE.texttabtyp;
9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;
9050: l_security_group_id_values WF_ENGINE.numtabtyp;
9051:
9052: l_contract_id_count NUMBER := 0;
9053: l_date DATE := sysdate;

Line 9050: l_security_group_id_values WF_ENGINE.numtabtyp;

9046: l_neg_status_values WF_ENGINE.texttabtyp;
9047: l_user_id_values WF_ENGINE.numtabtyp;
9048: l_responsibility_id_values WF_ENGINE.numtabtyp;
9049: l_resp_appl_id_values WF_ENGINE.numtabtyp;
9050: l_security_group_id_values WF_ENGINE.numtabtyp;
9051:
9052: l_contract_id_count NUMBER := 0;
9053: l_date DATE := sysdate;
9054:

Line 9135: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', 'l_contract_id_count='||l_contract_id_count||' ,calling WF_ENGINE_BULK.createprocess');

9131:
9132: IF (l_contract_id_count > 0) THEN
9133:
9134: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9135: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', 'l_contract_id_count='||l_contract_id_count||' ,calling WF_ENGINE_BULK.createprocess');
9136: END IF;
9137:
9138: WF_ENGINE_BULK.createprocess(
9139: itemtype => G_ITEM_TYPE,

Line 9138: WF_ENGINE_BULK.createprocess(

9134: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9135: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', 'l_contract_id_count='||l_contract_id_count||' ,calling WF_ENGINE_BULK.createprocess');
9136: END IF;
9137:
9138: WF_ENGINE_BULK.createprocess(
9139: itemtype => G_ITEM_TYPE,
9140: itemkeys => l_item_keys,
9141: process => G_MAIN_PROCESS,
9142: user_keys => l_user_keys,

Line 9145: WF_ENGINE_BULK.setitemattrnumber(

9141: process => G_MAIN_PROCESS,
9142: user_keys => l_user_keys,
9143: owner_roles => l_owner_roles);
9144:
9145: WF_ENGINE_BULK.setitemattrnumber(
9146: itemtype => G_ITEM_TYPE,
9147: itemkeys => l_item_keys,
9148: anames => l_contract_id_names,
9149: avalues => l_contract_id_values);

Line 9151: WF_ENGINE_BULK.setitemattrtext(

9147: itemkeys => l_item_keys,
9148: anames => l_contract_id_names,
9149: avalues => l_contract_id_values);
9150:
9151: WF_ENGINE_BULK.setitemattrtext(
9152: itemtype => G_ITEM_TYPE,
9153: itemkeys => l_item_keys,
9154: anames => l_contract_number_names,
9155: avalues => l_contract_number_values);

Line 9157: WF_ENGINE_BULK.setitemattrtext(

9153: itemkeys => l_item_keys,
9154: anames => l_contract_number_names,
9155: avalues => l_contract_number_values);
9156:
9157: WF_ENGINE_BULK.setitemattrtext(
9158: itemtype => G_ITEM_TYPE,
9159: itemkeys => l_item_keys,
9160: anames => l_contract_modifier_names,
9161: avalues => l_contract_modifier_values);

Line 9163: WF_ENGINE_BULK.setitemattrtext(

9159: itemkeys => l_item_keys,
9160: anames => l_contract_modifier_names,
9161: avalues => l_contract_modifier_values);
9162:
9163: WF_ENGINE_BULK.setitemattrtext(
9164: itemtype => G_ITEM_TYPE,
9165: itemkeys => l_item_keys,
9166: anames => l_process_type_names,
9167: avalues => l_process_type_values);

Line 9169: WF_ENGINE_BULK.setitemattrtext(

9165: itemkeys => l_item_keys,
9166: anames => l_process_type_names,
9167: avalues => l_process_type_values);
9168:
9169: WF_ENGINE_BULK.setitemattrtext(
9170: itemtype => G_ITEM_TYPE,
9171: itemkeys => l_item_keys,
9172: anames => l_irr_flag_names,
9173: avalues => l_irr_flag_values);

Line 9175: WF_ENGINE_BULK.setitemattrtext(

9171: itemkeys => l_item_keys,
9172: anames => l_irr_flag_names,
9173: avalues => l_irr_flag_values);
9174:
9175: WF_ENGINE_BULK.setitemattrtext(
9176: itemtype => G_ITEM_TYPE,
9177: itemkeys => l_item_keys,
9178: anames => l_neg_status_names,
9179: avalues => l_neg_status_values);

Line 9181: WF_ENGINE_BULK.setitemattrnumber(

9177: itemkeys => l_item_keys,
9178: anames => l_neg_status_names,
9179: avalues => l_neg_status_values);
9180:
9181: WF_ENGINE_BULK.setitemattrnumber(
9182: itemtype => G_ITEM_TYPE,
9183: itemkeys => l_item_keys,
9184: anames => l_user_id_names,
9185: avalues => l_user_id_values);

Line 9187: WF_ENGINE_BULK.setitemattrnumber(

9183: itemkeys => l_item_keys,
9184: anames => l_user_id_names,
9185: avalues => l_user_id_values);
9186:
9187: WF_ENGINE_BULK.setitemattrnumber(
9188: itemtype => G_ITEM_TYPE,
9189: itemkeys => l_item_keys,
9190: anames => l_responsibility_id_names,
9191: avalues => l_responsibility_id_values);

Line 9193: WF_ENGINE_BULK.setitemattrnumber(

9189: itemkeys => l_item_keys,
9190: anames => l_responsibility_id_names,
9191: avalues => l_responsibility_id_values);
9192:
9193: WF_ENGINE_BULK.setitemattrnumber(
9194: itemtype => G_ITEM_TYPE,
9195: itemkeys => l_item_keys,
9196: anames => l_resp_appl_id_names,
9197: avalues => l_resp_appl_id_values);

Line 9199: WF_ENGINE_BULK.setitemattrnumber(

9195: itemkeys => l_item_keys,
9196: anames => l_resp_appl_id_names,
9197: avalues => l_resp_appl_id_values);
9198:
9199: WF_ENGINE_BULK.setitemattrnumber(
9200: itemtype => G_ITEM_TYPE,
9201: itemkeys => l_item_keys,
9202: anames => l_security_group_id_names,
9203: avalues => l_security_group_id_values);

Line 9206: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');

9202: anames => l_security_group_id_names,
9203: avalues => l_security_group_id_values);
9204:
9205: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9206: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
9207: END IF;
9208:
9209: WF_ENGINE_BULK.startprocess(
9210: itemtype => G_ITEM_TYPE,

Line 9209: WF_ENGINE_BULK.startprocess(

9205: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9206: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
9207: END IF;
9208:
9209: WF_ENGINE_BULK.startprocess(
9210: itemtype => G_ITEM_TYPE,
9211: itemkeys => l_item_keys);
9212:
9213: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN