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.

[Home] [Help]

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 2552: wf_engine.SetItemAttrText

2548: ELSIF x_return_status = G_RET_STS_ERROR THEN
2549: RAISE FND_API.G_EXC_ERROR;
2550: END IF;
2551:
2552: wf_engine.SetItemAttrText
2553: (
2554: itemtype => G_ITEM_TYPE,
2555: itemkey => l_item_key,
2556: aname => 'SEND_CONFIRM',

Line 2844: wf_engine.SetItemAttrText

2840: ELSIF x_return_status = G_RET_STS_ERROR THEN
2841: RAISE FND_API.G_EXC_ERROR;
2842: END IF;
2843:
2844: wf_engine.SetItemAttrText
2845: (
2846: itemtype => G_ITEM_TYPE,
2847: itemkey => l_item_key,
2848: aname => 'SEND_CONFIRM',

Line 3646: l_contract_id := wf_engine.GetItemAttrNumber(

3642: ' funcmode: ' || funcmode);
3643: END IF;
3644: IF (funcmode = 'RUN') THEN
3645:
3646: l_contract_id := wf_engine.GetItemAttrNumber(
3647: itemtype => itemtype,
3648: itemkey => itemkey,
3649: aname => 'CONTRACT_ID');
3650:

Line 3651: l_notif_type := wf_engine.GetActivityAttrText

3647: itemtype => itemtype,
3648: itemkey => itemkey,
3649: aname => 'CONTRACT_ID');
3650:
3651: l_notif_type := wf_engine.GetActivityAttrText
3652: (
3653: itemtype => itemtype,
3654: itemkey => itemkey,
3655: actid => actid,

Line 3722: wf_engine.SetItemAttrText

3718: IF l_return_status <> G_RET_STS_SUCCESS THEN
3719: RAISE FND_API.G_EXC_ERROR;
3720: END IF;
3721:
3722: wf_engine.SetItemAttrText
3723: (
3724: itemtype => itemtype,
3725: itemkey => itemkey,
3726: aname => 'SEND_CONFIRM',

Line 4014: l_contract_id := wf_engine.GetItemAttrNumber(

4010: ' funcmode: ' || funcmode);
4011: END IF;
4012: IF (funcmode = 'RUN') THEN
4013:
4014: l_contract_id := wf_engine.GetItemAttrNumber(
4015: itemtype => itemtype,
4016: itemkey => itemkey,
4017: aname => 'CONTRACT_ID');
4018:

Line 4019: l_email_type := wf_engine.GetActivityAttrText

4015: itemtype => itemtype,
4016: itemkey => itemkey,
4017: aname => 'CONTRACT_ID');
4018:
4019: l_email_type := wf_engine.GetActivityAttrText
4020: (
4021: itemtype => itemtype,
4022: itemkey => itemkey,
4023: actid => actid,

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

4145: resultout out nocopy varchar2 )
4146: is
4147: l_api_name CONSTANT VARCHAR2(30) := 'email_mute';
4148:
4149: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4150: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4151: cursor c1(p_name varchar2) is
4152: select user_id from fnd_user
4153: where user_name=p_name;

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

4146: is
4147: l_api_name CONSTANT VARCHAR2(30) := 'email_mute';
4148:
4149: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4150: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4151: cursor c1(p_name varchar2) is
4152: select user_id from fnd_user
4153: where user_name=p_name;
4154: l_user_id number;

Line 4184: wf_engine.SetItemAttrText

4180: APPLICATION_ID => NULL);
4181: end if;
4182:
4183: if (l_p_value is NULL or l_p_value='N') then
4184: wf_engine.SetItemAttrText
4185: (itemtype => G_WF_NAME,
4186: itemkey => itemkey,
4187: aname => '.MAIL_QUERY',
4188: avalue => ' ');

Line 4190: wf_engine.SetItemAttrText

4186: itemkey => itemkey,
4187: aname => '.MAIL_QUERY',
4188: avalue => ' ');
4189: else
4190: wf_engine.SetItemAttrText
4191: (itemtype => G_WF_NAME,
4192: itemkey => itemkey,
4193: aname => '.MAIL_QUERY',
4194: avalue => l_user_name);

Line 4377: l_save_threshold := WF_ENGINE.threshold;

4373: ' Contract Id: ' || p_wf_attributes.contract_id ||
4374: ' User Key: ' || l_user_key );
4375: END IF;
4376: ELSE
4377: l_save_threshold := WF_ENGINE.threshold;
4378: WF_ENGINE.threshold := -1;
4379: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4380: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4381: 'Process will be deferred for Item key: ' || l_item_key ||

Line 4378: WF_ENGINE.threshold := -1;

4374: ' User Key: ' || l_user_key );
4375: END IF;
4376: ELSE
4377: l_save_threshold := WF_ENGINE.threshold;
4378: WF_ENGINE.threshold := -1;
4379: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4380: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4381: 'Process will be deferred for Item key: ' || l_item_key ||
4382: ' Contract Id: ' || p_wf_attributes.contract_id ||

Line 4388: WF_ENGINE.CREATEPROCESS

4384: END IF;
4385: END IF;
4386:
4387: -- Create the workflow process
4388: WF_ENGINE.CREATEPROCESS
4389: (
4390: itemtype => G_ITEM_TYPE,
4391: itemkey => l_item_key,
4392: process => G_MAIN_PROCESS,

Line 4396: wf_engine.SetItemAttrNumber

4392: process => G_MAIN_PROCESS,
4393: user_key => l_user_key
4394: );
4395:
4396: wf_engine.SetItemAttrNumber
4397: (
4398: itemtype => G_ITEM_TYPE,
4399: itemkey => l_item_key,
4400: aname => 'CONTRACT_ID',

Line 4404: WF_ENGINE.setitemattrtext

4400: aname => 'CONTRACT_ID',
4401: avalue => p_wf_attributes.contract_id
4402: );
4403:
4404: WF_ENGINE.setitemattrtext
4405: (
4406: itemtype => G_ITEM_TYPE,
4407: itemkey => l_item_key,
4408: aname => 'CONTRACT_NUMBER',

Line 4412: WF_ENGINE.setitemattrtext

4408: aname => 'CONTRACT_NUMBER',
4409: avalue => l_contract_number
4410: );
4411:
4412: WF_ENGINE.setitemattrtext
4413: (
4414: itemtype => G_ITEM_TYPE,
4415: itemkey => l_item_key,
4416: aname => 'CONTRACT_MODIFIER',

Line 4421: WF_ENGINE.setitemattrtext

4417: avalue => l_contract_modifier
4418: );
4419:
4420: IF p_wf_attributes.process_type IS NOT NULL THEN
4421: WF_ENGINE.setitemattrtext
4422: (
4423: itemtype => G_ITEM_TYPE,
4424: itemkey => l_item_key,
4425: aname => 'PROCESS_TYPE',

Line 4430: WF_ENGINE.setitemattrtext

4426: avalue => p_wf_attributes.process_type
4427: );
4428: END IF;
4429: IF p_wf_attributes.irr_flag IS NOT NULL THEN
4430: WF_ENGINE.setitemattrtext
4431: (
4432: itemtype => G_ITEM_TYPE,
4433: itemkey => l_item_key,
4434: aname => 'IRR_FLAG',

Line 4441: WF_ENGINE.setitemattrtext

4437: END IF;
4438: IF p_wf_attributes.negotiation_status IS NOT NULL AND
4439: p_wf_attributes.negotiation_status <> G_NEG_STS_PRE_DRAFT THEN
4440:
4441: WF_ENGINE.setitemattrtext
4442: (
4443: itemtype => G_ITEM_TYPE,
4444: itemkey => l_item_key,
4445: aname => 'NEGOTIATION_STATUS',

Line 4452: wf_engine.SetItemAttrNumber

4448: END IF;
4449:
4450: -- Added 4 item attributes below to fix bug 4776175
4451: -- These values are passed to approval workflow
4452: wf_engine.SetItemAttrNumber
4453: (
4454: itemtype => G_ITEM_TYPE,
4455: itemkey => l_item_key,
4456: aname => 'USER_ID',

Line 4460: wf_engine.SetItemAttrNumber

4456: aname => 'USER_ID',
4457: avalue => fnd_global.user_id
4458: );
4459:
4460: wf_engine.SetItemAttrNumber
4461: (
4462: itemtype => G_ITEM_TYPE,
4463: itemkey => l_item_key,
4464: aname => 'RESP_ID',

Line 4468: wf_engine.SetItemAttrNumber

4464: aname => 'RESP_ID',
4465: avalue => fnd_global.resp_id
4466: );
4467:
4468: wf_engine.SetItemAttrNumber
4469: (
4470: itemtype => G_ITEM_TYPE,
4471: itemkey => l_item_key,
4472: aname => 'RESP_APPL_ID',

Line 4476: wf_engine.SetItemAttrNumber

4472: aname => 'RESP_APPL_ID',
4473: avalue => fnd_global.resp_appl_id
4474: );
4475:
4476: wf_engine.SetItemAttrNumber
4477: (
4478: itemtype => G_ITEM_TYPE,
4479: itemkey => l_item_key,
4480: aname => 'SECURITY_GROUP_ID',

Line 4492: WF_ENGINE.setitemowner

4488: ' IRR Flag: ' || NVL(p_wf_attributes.irr_flag,'NULL'));
4489: END IF;
4490:
4491: -- Assign owner to the workflow instance. Bug fix 4752631
4492: WF_ENGINE.setitemowner
4493: (
4494: itemtype => G_ITEM_TYPE,
4495: itemkey => l_item_key,
4496: owner => fnd_global.user_name

Line 4500: WF_ENGINE.STARTPROCESS

4496: owner => fnd_global.user_name
4497: );
4498:
4499: -- Start the workflow process
4500: WF_ENGINE.STARTPROCESS
4501: (
4502: itemtype => G_ITEM_TYPE,
4503: itemkey => l_item_key
4504: );

Line 4533: WF_ENGINE.threshold := l_save_threshold;

4529: END IF;
4530:
4531: --Always reset threshold or all activities in this session will be deferred.
4532: IF p_wf_attributes.negotiation_status = G_NEG_STS_PRE_DRAFT THEN
4533: WF_ENGINE.threshold := l_save_threshold;
4534: END IF;
4535:
4536: IF FND_API.to_boolean( p_commit ) THEN
4537: COMMIT;

Line 4816: wf_engine.abortprocess

4812: 'Aborting workflow... ');
4813: END IF;
4814:
4815: -- Abort the workflow process and purging code goes here
4816: wf_engine.abortprocess
4817: (
4818: itemtype => G_ITEM_TYPE,
4819: itemkey => l_item_key
4820: );

Line 4922: l_contract_id := wf_engine.GetItemAttrNumber(

4918: ' actid: ' || to_char(actid) ||
4919: ' funcmode: ' || funcmode);
4920: END IF;
4921: IF (funcmode = 'RUN') THEN
4922: l_contract_id := wf_engine.GetItemAttrNumber(
4923: itemtype => itemtype,
4924: itemkey => itemkey,
4925: aname => 'CONTRACT_ID');
4926:

Line 4928: /* WF_ENGINE.setitemattrtext

4924: itemkey => itemkey,
4925: aname => 'CONTRACT_ID');
4926:
4927: -- Set any other optional values to item attributes
4928: /* WF_ENGINE.setitemattrtext
4929: (
4930: itemtype => itemtype,
4931: itemkey => itemkey,
4932: aname => 'CONTRACT_NUMBER',

Line 4936: WF_ENGINE.SetItemAttrText

4932: aname => 'CONTRACT_NUMBER',
4933: avalue => l_kdetails_rec.contract_number
4934: );
4935:
4936: WF_ENGINE.SetItemAttrText
4937: (
4938: itemtype => itemtype,
4939: itemkey => itemkey,
4940: aname => 'CONTRACT_MODIFIER',

Line 5071: l_contract_id := wf_engine.GetItemAttrNumber(

5067: ' actid: ' || to_char(actid) ||
5068: ' funcmode: ' || funcmode);
5069: END IF;
5070: IF (funcmode = 'RUN') THEN
5071: l_contract_id := wf_engine.GetItemAttrNumber(
5072: itemtype => itemtype,
5073: itemkey => itemkey,
5074: aname => 'CONTRACT_ID');
5075:

Line 5077: l_negotiation_status := wf_engine.GetItemAttrText(

5073: itemkey => itemkey,
5074: aname => 'CONTRACT_ID');
5075:
5076: -- Get negotiation status
5077: l_negotiation_status := wf_engine.GetItemAttrText(
5078: itemtype => itemtype,
5079: itemkey => itemkey,
5080: aname => 'NEGOTIATION_STATUS');
5081:

Line 5098: wf_engine.SetItemAttrNumber

5094: -- and stamp it in the new OKSKPRCS wf. bug 5723364. R12 Upgrade script
5095: -- is incorrectly setting these attributes to FND_GLOBAL values
5096: FOR l_user_dtls_rec IN l_user_dtls_csr(l_contract_id)
5097: LOOP
5098: wf_engine.SetItemAttrNumber
5099: (
5100: itemtype => itemtype,
5101: itemkey => itemkey,
5102: aname => l_user_dtls_rec.attr_name,

Line 5115: wf_engine.SetItemAttrNumber

5111: OPEN l_resp_appl_id_csr(l_resp_id);
5112: FETCH l_resp_appl_id_csr INTO l_resp_appl_id;
5113: CLOSE l_resp_appl_id_csr;
5114:
5115: wf_engine.SetItemAttrNumber
5116: (
5117: itemtype => itemtype,
5118: itemkey => itemkey,
5119: aname => 'RESP_APPL_ID',

Line 5191: wf_engine.SetItemAttrText

5187: END IF;
5188:
5189: -- Reset negotiation status to NULL so that no other process will
5190: -- update incorrect Negotiation status
5191: wf_engine.SetItemAttrText
5192: (
5193: itemtype => itemtype,
5194: itemkey => itemkey,
5195: aname => 'NEGOTIATION_STATUS',

Line 5295: l_contract_id := wf_engine.GetItemAttrNumber(

5291: ' funcmode: ' || funcmode);
5292: END IF;
5293: IF (funcmode = 'RUN') THEN
5294:
5295: l_contract_id := wf_engine.GetItemAttrNumber(
5296: itemtype => itemtype,
5297: itemkey => itemkey,
5298: aname => 'CONTRACT_ID');
5299:

Line 5304: l_process_type := wf_engine.GetItemAttrText(

5300: -- Get process type to determine if this is a new or a renewal contract
5301: -- If it is a new contract, process type is always Manual
5302: -- If it is a renewal contract, determine if this contract qualifies
5303: -- for either Online or Evergreen process
5304: l_process_type := wf_engine.GetItemAttrText(
5305: itemtype => itemtype,
5306: itemkey => itemkey,
5307: aname => 'PROCESS_TYPE');
5308:

Line 5661: wf_engine.SetItemAttrNumber(

5657: ' Security Group Id=>'||p_security_group_id );
5658: END IF;
5659: -- Reset following item attributes to reflect the current user
5660: begin
5661: wf_engine.SetItemAttrNumber(
5662: itemtype => G_ITEM_TYPE,
5663: itemkey => p_wf_item_key,
5664: aname => 'USER_ID',
5665: avalue => p_user_id);

Line 5668: wf_engine.AddItemAttr (

5664: aname => 'USER_ID',
5665: avalue => p_user_id);
5666: exception
5667: when others then
5668: wf_engine.AddItemAttr (
5669: itemtype => G_ITEM_TYPE,
5670: itemkey => p_wf_item_key,
5671: aname => 'USER_ID');
5672:

Line 5673: wf_engine.SetItemAttrNumber (

5669: itemtype => G_ITEM_TYPE,
5670: itemkey => p_wf_item_key,
5671: aname => 'USER_ID');
5672:
5673: wf_engine.SetItemAttrNumber (
5674: itemtype => G_ITEM_TYPE,
5675: itemkey => p_wf_item_key,
5676: aname => 'USER_ID',
5677: avalue => p_user_id);

Line 5680: wf_engine.SetItemAttrNumber(

5676: aname => 'USER_ID',
5677: avalue => p_user_id);
5678: end;
5679: begin
5680: wf_engine.SetItemAttrNumber(
5681: itemtype => G_ITEM_TYPE,
5682: itemkey => p_wf_item_key,
5683: aname => 'RESP_ID',
5684: avalue => p_resp_id);

Line 5687: wf_engine.AddItemAttr (

5683: aname => 'RESP_ID',
5684: avalue => p_resp_id);
5685: exception
5686: when others then
5687: wf_engine.AddItemAttr (
5688: itemtype => G_ITEM_TYPE,
5689: itemkey => p_wf_item_key,
5690: aname => 'RESP_ID');
5691:

Line 5692: wf_engine.SetItemAttrNumber (

5688: itemtype => G_ITEM_TYPE,
5689: itemkey => p_wf_item_key,
5690: aname => 'RESP_ID');
5691:
5692: wf_engine.SetItemAttrNumber (
5693: itemtype => G_ITEM_TYPE,
5694: itemkey => p_wf_item_key,
5695: aname => 'RESP_ID',
5696: avalue => p_resp_id);

Line 5699: wf_engine.SetItemAttrNumber(

5695: aname => 'RESP_ID',
5696: avalue => p_resp_id);
5697: end;
5698: begin
5699: wf_engine.SetItemAttrNumber(
5700: itemtype => G_ITEM_TYPE,
5701: itemkey => p_wf_item_key,
5702: aname => 'RESP_APPL_ID',
5703: avalue => p_resp_appl_id);

Line 5706: wf_engine.AddItemAttr (

5702: aname => 'RESP_APPL_ID',
5703: avalue => p_resp_appl_id);
5704: exception
5705: when others then
5706: wf_engine.AddItemAttr (
5707: itemtype => G_ITEM_TYPE,
5708: itemkey => p_wf_item_key,
5709: aname => 'RESP_APPL_ID');
5710:

Line 5711: wf_engine.SetItemAttrNumber (

5707: itemtype => G_ITEM_TYPE,
5708: itemkey => p_wf_item_key,
5709: aname => 'RESP_APPL_ID');
5710:
5711: wf_engine.SetItemAttrNumber (
5712: itemtype => G_ITEM_TYPE,
5713: itemkey => p_wf_item_key,
5714: aname => 'RESP_APPL_ID',
5715: avalue => p_resp_appl_id);

Line 5718: wf_engine.SetItemAttrNumber(

5714: aname => 'RESP_APPL_ID',
5715: avalue => p_resp_appl_id);
5716: end;
5717: begin
5718: wf_engine.SetItemAttrNumber(
5719: itemtype => G_ITEM_TYPE,
5720: itemkey => p_wf_item_key,
5721: aname => 'SECURITY_GROUP_ID',
5722: avalue => p_security_group_id);

Line 5725: wf_engine.AddItemAttr (

5721: aname => 'SECURITY_GROUP_ID',
5722: avalue => p_security_group_id);
5723: exception
5724: when others then
5725: wf_engine.AddItemAttr (
5726: itemtype => G_ITEM_TYPE,
5727: itemkey => p_wf_item_key,
5728: aname => 'SECURITY_GROUP_ID');
5729:

Line 5730: wf_engine.SetItemAttrNumber (

5726: itemtype => G_ITEM_TYPE,
5727: itemkey => p_wf_item_key,
5728: aname => 'SECURITY_GROUP_ID');
5729:
5730: wf_engine.SetItemAttrNumber (
5731: itemtype => G_ITEM_TYPE,
5732: itemkey => p_wf_item_key,
5733: aname => 'SECURITY_GROUP_ID',
5734: avalue => p_security_group_id);

Line 5909: wf_engine.SetItemAttrText

5905: ELSIF x_return_status = G_RET_STS_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;
5908:
5909: wf_engine.SetItemAttrText
5910: (
5911: itemtype => G_ITEM_TYPE,
5912: itemkey => l_item_key,
5913: aname => 'SEND_CONFIRM',

Line 5986: wf_engine.SetItemAttrText

5982: END IF;
5983:
5984: -- If submit for approval action is taken at Authoring set this flag to 'N' so
5985: -- that QA check is not performed but when taken at Workbench, set it to 'Y'.
5986: wf_engine.SetItemAttrText
5987: (
5988: itemtype => G_ITEM_TYPE,
5989: itemkey => l_item_key,
5990: aname => 'QA_REQUIRED_YN',

Line 6229: wf_engine.SetItemAttrText

6225:
6226: -- Set this item attribute to 'Y' which indicates that this contract was
6227: -- published online manually. This is an important attribute since this is the only
6228: -- contract information that specifies that a contract is going thru online process
6229: wf_engine.SetItemAttrText
6230: (
6231: itemtype => G_ITEM_TYPE,
6232: itemkey => l_item_key,
6233: aname => 'PUBLISH_MAN_YN',

Line 6369: l_contract_id := wf_engine.GetItemAttrNumber(

6365: ' funcmode: ' || funcmode);
6366: END IF;
6367: IF (funcmode = 'RUN') THEN
6368:
6369: l_contract_id := wf_engine.GetItemAttrNumber(
6370: itemtype => itemtype,
6371: itemkey => itemkey,
6372: aname => 'CONTRACT_ID');
6373:

Line 6376: wf_engine.SetItemAttrText

6372: aname => 'CONTRACT_ID');
6373:
6374: -- Initialize workflow message attributes to Null.
6375: FOR l_count IN 1 .. 10 LOOP
6376: wf_engine.SetItemAttrText
6377: (
6378: itemtype => itemtype,
6379: itemkey => itemkey,
6380: aname => 'MESSAGE' || l_count,

Line 6455: wf_engine.SetItemAttrText

6451: l_negotiation_status := G_NEG_STS_IA_QA_FAIL;
6452: END IF;
6453:
6454: IF l_msg_ctr <= 10 THEN
6455: wf_engine.SetItemAttrText
6456: (
6457: itemtype => itemtype,
6458: itemkey => itemkey,
6459: aname => 'MESSAGE' || l_msg_ctr,

Line 6497: wf_engine.SetItemAttrText

6493: WHEN FND_API.G_EXC_ERROR THEN
6494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
6495: -- Set the message only when a vacant message item attribute is available
6496: IF (l_msg_ctr < 10) THEN
6497: wf_engine.SetItemAttrText
6498: (
6499: itemtype => itemtype,
6500: itemkey => itemkey,
6501: aname => 'MESSAGE' || l_msg_ctr,

Line 6649: wf_engine.SetItemAttrText

6645: -- even with an expense of loosing a populated message.
6646: IF l_msg_ctr > 10 THEN
6647: l_msg_ctr := 10;
6648: END IF;
6649: wf_engine.SetItemAttrText
6650: (
6651: itemtype => itemtype,
6652: itemkey => itemkey,
6653: aname => 'MESSAGE' || l_msg_ctr,

Line 6705: wf_engine.SetItemAttrText

6701: -- even with an expense of loosing a populated message.
6702: IF l_msg_ctr > 10 THEN
6703: l_msg_ctr := 10;
6704: END IF;
6705: wf_engine.SetItemAttrText
6706: (
6707: itemtype => itemtype,
6708: itemkey => itemkey,
6709: aname => 'MESSAGE' || l_msg_ctr,

Line 6898: l_contract_id := wf_engine.GetItemAttrNumber(

6894: ' funcmode: ' || funcmode);
6895: END IF;
6896: IF (funcmode = 'RUN') THEN
6897:
6898: l_contract_id := wf_engine.GetItemAttrNumber(
6899: itemtype => itemtype,
6900: itemkey => itemkey,
6901: aname => 'CONTRACT_ID');
6902:

Line 6905: l_irr_flag := wf_engine.GetItemAttrText(

6901: aname => 'CONTRACT_ID');
6902:
6903: -- Get submit for approval flag to determine if this contract
6904: -- requires explict action by salesrep.
6905: l_irr_flag := wf_engine.GetItemAttrText(
6906: itemtype => itemtype,
6907: itemkey => itemkey,
6908: aname => 'IRR_FLAG');
6909:

Line 7178: l_contract_id := wf_engine.GetItemAttrNumber(

7174: ' funcmode: ' || funcmode);
7175: END IF;
7176: IF (funcmode = 'RUN') THEN
7177:
7178: l_contract_id := wf_engine.GetItemAttrNumber(
7179: itemtype => itemtype,
7180: itemkey => itemkey,
7181: aname => 'CONTRACT_ID');
7182:

Line 7183: l_negotiation_status := wf_engine.GetActivityAttrText(

7179: itemtype => itemtype,
7180: itemkey => itemkey,
7181: aname => 'CONTRACT_ID');
7182:
7183: l_negotiation_status := wf_engine.GetActivityAttrText(
7184: itemtype => itemtype,
7185: itemkey => itemkey,
7186: actid => actid,
7187: aname => 'TARGET_NEGO_STATUS');

Line 7358: l_user_id := wf_engine.GetItemAttrNumber

7354: ' p_commit: ' || p_commit ||
7355: ' p_wf_item_key: ' || p_wf_item_key);
7356: END IF;
7357: BEGIN
7358: l_user_id := wf_engine.GetItemAttrNumber
7359: (
7360: itemtype => G_ITEM_TYPE,
7361: itemkey => p_wf_item_key,
7362: aname => 'USER_ID'

Line 7366: wf_engine.AddItemAttr

7362: aname => 'USER_ID'
7363: );
7364: EXCEPTION
7365: WHEN OTHERS THEN
7366: wf_engine.AddItemAttr
7367: (
7368: itemtype => G_ITEM_TYPE,
7369: itemkey => p_wf_item_key,
7370: aname => 'USER_ID'

Line 7372: wf_engine.SetItemAttrNumber

7368: itemtype => G_ITEM_TYPE,
7369: itemkey => p_wf_item_key,
7370: aname => 'USER_ID'
7371: );
7372: wf_engine.SetItemAttrNumber
7373: (
7374: itemtype => G_ITEM_TYPE,
7375: itemkey => p_wf_item_key,
7376: aname => 'USER_ID',

Line 7381: l_resp_id := wf_engine.GetItemAttrNumber

7377: avalue => null
7378: );
7379: END;
7380: BEGIN
7381: l_resp_id := wf_engine.GetItemAttrNumber
7382: (
7383: itemtype => G_ITEM_TYPE,
7384: itemkey => p_wf_item_key,
7385: aname => 'RESP_ID'

Line 7389: wf_engine.AddItemAttr

7385: aname => 'RESP_ID'
7386: );
7387: EXCEPTION
7388: WHEN OTHERS THEN
7389: wf_engine.AddItemAttr
7390: (
7391: itemtype => G_ITEM_TYPE,
7392: itemkey => p_wf_item_key,
7393: aname => 'RESP_ID'

Line 7395: wf_engine.SetItemAttrNumber

7391: itemtype => G_ITEM_TYPE,
7392: itemkey => p_wf_item_key,
7393: aname => 'RESP_ID'
7394: );
7395: wf_engine.SetItemAttrNumber
7396: (
7397: itemtype => G_ITEM_TYPE,
7398: itemkey => p_wf_item_key,
7399: aname => 'RESP_ID',

Line 7404: l_resp_appl_id := wf_engine.GetItemAttrNumber

7400: avalue => null
7401: );
7402: END;
7403: BEGIN
7404: l_resp_appl_id := wf_engine.GetItemAttrNumber
7405: (
7406: itemtype => G_ITEM_TYPE,
7407: itemkey => p_wf_item_key,
7408: aname => 'RESP_APPL_ID'

Line 7413: wf_engine.AddItemAttr

7409: );
7410:
7411: EXCEPTION
7412: WHEN OTHERS THEN
7413: wf_engine.AddItemAttr
7414: (
7415: itemtype => G_ITEM_TYPE,
7416: itemkey => p_wf_item_key,
7417: aname => 'RESP_APPL_ID'

Line 7419: wf_engine.SetItemAttrNumber

7415: itemtype => G_ITEM_TYPE,
7416: itemkey => p_wf_item_key,
7417: aname => 'RESP_APPL_ID'
7418: );
7419: wf_engine.SetItemAttrNumber
7420: (
7421: itemtype => G_ITEM_TYPE,
7422: itemkey => p_wf_item_key,
7423: aname => 'RESP_APPL_ID',

Line 7428: l_security_group_id := wf_engine.GetItemAttrNumber

7424: avalue => null
7425: );
7426: END;
7427: BEGIN
7428: l_security_group_id := wf_engine.GetItemAttrNumber
7429: (
7430: itemtype => G_ITEM_TYPE,
7431: itemkey => p_wf_item_key,
7432: aname => 'SECURITY_GROUP_ID'

Line 7436: wf_engine.AddItemAttr

7432: aname => 'SECURITY_GROUP_ID'
7433: );
7434: EXCEPTION
7435: WHEN OTHERS THEN
7436: wf_engine.AddItemAttr
7437: (
7438: itemtype => G_ITEM_TYPE,
7439: itemkey => p_wf_item_key,
7440: aname => 'SECURITY_GROUP_ID'

Line 7442: wf_engine.SetItemAttrNumber

7438: itemtype => G_ITEM_TYPE,
7439: itemkey => p_wf_item_key,
7440: aname => 'SECURITY_GROUP_ID'
7441: );
7442: wf_engine.SetItemAttrNumber
7443: (
7444: itemtype => G_ITEM_TYPE,
7445: itemkey => p_wf_item_key,
7446: aname => 'SECURITY_GROUP_ID',

Line 7555: l_contract_id := wf_engine.GetItemAttrNumber(

7551: ' funcmode: ' || funcmode);
7552: END IF;
7553: IF (funcmode = 'RUN') THEN
7554:
7555: l_contract_id := wf_engine.GetItemAttrNumber(
7556: itemtype => itemtype,
7557: itemkey => itemkey,
7558: aname => 'CONTRACT_ID');
7559:

Line 7812: wf_engine.SetItemAttrText

7808: l_item_key := p_item_key;
7809: END IF;
7810:
7811: -- Check if a confirmation email has to be delivered or not
7812: wf_engine.SetItemAttrText
7813: (
7814: itemtype => G_ITEM_TYPE,
7815: itemkey => l_item_key,
7816: aname => 'SEND_CONFIRM',

Line 8105: wf_engine.SetItemAttrText

8101: ELSIF x_return_status = G_RET_STS_ERROR THEN
8102: RAISE FND_API.G_EXC_ERROR;
8103: END IF;
8104:
8105: wf_engine.SetItemAttrText
8106: (
8107: itemtype => G_ITEM_TYPE,
8108: itemkey => l_item_key,
8109: aname => 'SEND_CONFIRM',

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

8195: last_update_date = SYSDATE,
8196: last_updated_by = FND_GLOBAL.USER_ID,
8197: last_update_login = FND_GLOBAL.LOGIN_ID
8198: WHERE chr_id = p_contract_id;
8199: wf_engine.AbortProcess (G_ITEM_TYPE, l_item_key);
8200: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8201: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8202: 'Updated Contract and Process Aborted '||G_PKG_NAME ||'.'||l_api_name);
8203: END IF;

Line 8332: l_contract_id := wf_engine.GetItemAttrNumber(

8328: ' funcmode: ' || funcmode);
8329: END IF;
8330: IF (funcmode = 'RUN') THEN
8331:
8332: l_contract_id := wf_engine.GetItemAttrNumber(
8333: itemtype => itemtype,
8334: itemkey => itemkey,
8335: aname => 'CONTRACT_ID');
8336:

Line 8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;

8718: l_wf_err_name VARCHAR2(30);
8719: l_wf_err_msg VARCHAR2(2000);
8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;

Line 8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;

8719: l_wf_err_msg VARCHAR2(2000);
8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;

Line 8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;

8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;

Line 8726: l_contract_id_names WF_ENGINE.nametabtyp;

8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;

Line 8727: l_contract_number_names WF_ENGINE.nametabtyp;

8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;

Line 8728: l_contract_modifier_names WF_ENGINE.nametabtyp;

8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;

Line 8729: l_process_type_names WF_ENGINE.nametabtyp;

8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;

Line 8730: l_irr_flag_names WF_ENGINE.nametabtyp;

8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;

Line 8731: l_neg_status_names WF_ENGINE.nametabtyp;

8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;

Line 8732: l_user_id_names WF_ENGINE.nametabtyp;

8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:

Line 8733: l_responsibility_id_names WF_ENGINE.nametabtyp;

8729: l_process_type_names WF_ENGINE.nametabtyp;
8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;

Line 8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;

8730: l_irr_flag_names WF_ENGINE.nametabtyp;
8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;

Line 8735: l_security_group_id_names WF_ENGINE.nametabtyp;

8731: l_neg_status_names WF_ENGINE.nametabtyp;
8732: l_user_id_names WF_ENGINE.nametabtyp;
8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;

Line 8737: l_contract_id_values WF_ENGINE.numtabtyp;

8733: l_responsibility_id_names WF_ENGINE.nametabtyp;
8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;

Line 8738: l_contract_number_values WF_ENGINE.texttabtyp;

8734: l_resp_appl_id_names WF_ENGINE.nametabtyp;
8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;

Line 8739: l_contract_modifier_values WF_ENGINE.texttabtyp;

8735: l_security_group_id_names WF_ENGINE.nametabtyp;
8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;

Line 8740: l_process_type_values WF_ENGINE.texttabtyp;

8736:
8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;

Line 8741: l_irr_flag_values WF_ENGINE.texttabtyp;

8737: l_contract_id_values WF_ENGINE.numtabtyp;
8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;

Line 8742: l_neg_status_values WF_ENGINE.texttabtyp;

8738: l_contract_number_values WF_ENGINE.texttabtyp;
8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;
8746: l_security_group_id_values WF_ENGINE.numtabtyp;

Line 8743: l_user_id_values WF_ENGINE.numtabtyp;

8739: l_contract_modifier_values WF_ENGINE.texttabtyp;
8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;
8746: l_security_group_id_values WF_ENGINE.numtabtyp;
8747:

Line 8744: l_responsibility_id_values WF_ENGINE.numtabtyp;

8740: l_process_type_values WF_ENGINE.texttabtyp;
8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;
8746: l_security_group_id_values WF_ENGINE.numtabtyp;
8747:
8748: l_contract_id_count NUMBER := 0;

Line 8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;

8741: l_irr_flag_values WF_ENGINE.texttabtyp;
8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;
8746: l_security_group_id_values WF_ENGINE.numtabtyp;
8747:
8748: l_contract_id_count NUMBER := 0;
8749: l_date DATE := sysdate;

Line 8746: l_security_group_id_values WF_ENGINE.numtabtyp;

8742: l_neg_status_values WF_ENGINE.texttabtyp;
8743: l_user_id_values WF_ENGINE.numtabtyp;
8744: l_responsibility_id_values WF_ENGINE.numtabtyp;
8745: l_resp_appl_id_values WF_ENGINE.numtabtyp;
8746: l_security_group_id_values WF_ENGINE.numtabtyp;
8747:
8748: l_contract_id_count NUMBER := 0;
8749: l_date DATE := sysdate;
8750:

Line 8831: 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');

8827:
8828: IF (l_contract_id_count > 0) THEN
8829:
8830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8831: 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');
8832: END IF;
8833:
8834: WF_ENGINE_BULK.createprocess(
8835: itemtype => G_ITEM_TYPE,

Line 8834: WF_ENGINE_BULK.createprocess(

8830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8831: 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');
8832: END IF;
8833:
8834: WF_ENGINE_BULK.createprocess(
8835: itemtype => G_ITEM_TYPE,
8836: itemkeys => l_item_keys,
8837: process => G_MAIN_PROCESS,
8838: user_keys => l_user_keys,

Line 8841: WF_ENGINE_BULK.setitemattrnumber(

8837: process => G_MAIN_PROCESS,
8838: user_keys => l_user_keys,
8839: owner_roles => l_owner_roles);
8840:
8841: WF_ENGINE_BULK.setitemattrnumber(
8842: itemtype => G_ITEM_TYPE,
8843: itemkeys => l_item_keys,
8844: anames => l_contract_id_names,
8845: avalues => l_contract_id_values);

Line 8847: WF_ENGINE_BULK.setitemattrtext(

8843: itemkeys => l_item_keys,
8844: anames => l_contract_id_names,
8845: avalues => l_contract_id_values);
8846:
8847: WF_ENGINE_BULK.setitemattrtext(
8848: itemtype => G_ITEM_TYPE,
8849: itemkeys => l_item_keys,
8850: anames => l_contract_number_names,
8851: avalues => l_contract_number_values);

Line 8853: WF_ENGINE_BULK.setitemattrtext(

8849: itemkeys => l_item_keys,
8850: anames => l_contract_number_names,
8851: avalues => l_contract_number_values);
8852:
8853: WF_ENGINE_BULK.setitemattrtext(
8854: itemtype => G_ITEM_TYPE,
8855: itemkeys => l_item_keys,
8856: anames => l_contract_modifier_names,
8857: avalues => l_contract_modifier_values);

Line 8859: WF_ENGINE_BULK.setitemattrtext(

8855: itemkeys => l_item_keys,
8856: anames => l_contract_modifier_names,
8857: avalues => l_contract_modifier_values);
8858:
8859: WF_ENGINE_BULK.setitemattrtext(
8860: itemtype => G_ITEM_TYPE,
8861: itemkeys => l_item_keys,
8862: anames => l_process_type_names,
8863: avalues => l_process_type_values);

Line 8865: WF_ENGINE_BULK.setitemattrtext(

8861: itemkeys => l_item_keys,
8862: anames => l_process_type_names,
8863: avalues => l_process_type_values);
8864:
8865: WF_ENGINE_BULK.setitemattrtext(
8866: itemtype => G_ITEM_TYPE,
8867: itemkeys => l_item_keys,
8868: anames => l_irr_flag_names,
8869: avalues => l_irr_flag_values);

Line 8871: WF_ENGINE_BULK.setitemattrtext(

8867: itemkeys => l_item_keys,
8868: anames => l_irr_flag_names,
8869: avalues => l_irr_flag_values);
8870:
8871: WF_ENGINE_BULK.setitemattrtext(
8872: itemtype => G_ITEM_TYPE,
8873: itemkeys => l_item_keys,
8874: anames => l_neg_status_names,
8875: avalues => l_neg_status_values);

Line 8877: WF_ENGINE_BULK.setitemattrnumber(

8873: itemkeys => l_item_keys,
8874: anames => l_neg_status_names,
8875: avalues => l_neg_status_values);
8876:
8877: WF_ENGINE_BULK.setitemattrnumber(
8878: itemtype => G_ITEM_TYPE,
8879: itemkeys => l_item_keys,
8880: anames => l_user_id_names,
8881: avalues => l_user_id_values);

Line 8883: WF_ENGINE_BULK.setitemattrnumber(

8879: itemkeys => l_item_keys,
8880: anames => l_user_id_names,
8881: avalues => l_user_id_values);
8882:
8883: WF_ENGINE_BULK.setitemattrnumber(
8884: itemtype => G_ITEM_TYPE,
8885: itemkeys => l_item_keys,
8886: anames => l_responsibility_id_names,
8887: avalues => l_responsibility_id_values);

Line 8889: WF_ENGINE_BULK.setitemattrnumber(

8885: itemkeys => l_item_keys,
8886: anames => l_responsibility_id_names,
8887: avalues => l_responsibility_id_values);
8888:
8889: WF_ENGINE_BULK.setitemattrnumber(
8890: itemtype => G_ITEM_TYPE,
8891: itemkeys => l_item_keys,
8892: anames => l_resp_appl_id_names,
8893: avalues => l_resp_appl_id_values);

Line 8895: WF_ENGINE_BULK.setitemattrnumber(

8891: itemkeys => l_item_keys,
8892: anames => l_resp_appl_id_names,
8893: avalues => l_resp_appl_id_values);
8894:
8895: WF_ENGINE_BULK.setitemattrnumber(
8896: itemtype => G_ITEM_TYPE,
8897: itemkeys => l_item_keys,
8898: anames => l_security_group_id_names,
8899: avalues => l_security_group_id_values);

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

8898: anames => l_security_group_id_names,
8899: avalues => l_security_group_id_values);
8900:
8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
8903: END IF;
8904:
8905: WF_ENGINE_BULK.startprocess(
8906: itemtype => G_ITEM_TYPE,

Line 8905: WF_ENGINE_BULK.startprocess(

8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
8903: END IF;
8904:
8905: WF_ENGINE_BULK.startprocess(
8906: itemtype => G_ITEM_TYPE,
8907: itemkeys => l_item_keys);
8908:
8909: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN