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

Line 57: l_aname wf_engine.nametabtyp;

53: --l_customer_number NUMBER;
54: l_customer_number varchar2(30) ;-- bug4575846
55: l_expiration_date DATE;
56:
57: l_aname wf_engine.nametabtyp;
58: l_avaluetext wf_engine.texttabtyp;
59:
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN

Line 58: l_avaluetext wf_engine.texttabtyp;

54: l_customer_number varchar2(30) ;-- bug4575846
55: l_expiration_date DATE;
56:
57: l_aname wf_engine.nametabtyp;
58: l_avaluetext wf_engine.texttabtyp;
59:
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN
62:

Line 86: l_sales_document_type_code := wf_engine.GetItemAttrText(

82: FROM OE_APPROVER_TRANSACTIONS
83: WHERE TRANSACTION_ID = l_transaction_id;
84:
85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
86: l_sales_document_type_code := wf_engine.GetItemAttrText(
87: OE_GLOBALS.G_WFI_NGO,
88: l_transaction_id,
89: 'SALES_DOCUMENT_TYPE_CODE');
90: END IF;

Line 136: wf_engine.SetItemAttrText(itemtype,

132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add('Setting the role to->' || l_role, 1 ) ;
134: END IF;
135:
136: wf_engine.SetItemAttrText(itemtype,
137: itemkey,
138: 'NOTIFICATION_APPROVER',
139: l_role);
140:

Line 176: wf_engine.SetItemAttrText(itemtype,

172: app_exception.raise_exception;
173: END IF;
174:
175: IF l_attachment_location is NOT NULL THEN
176: wf_engine.SetItemAttrText(itemtype,
177: itemkey,
178: 'CONTRACT_ATTACHMENT',
179: l_attachment_location);
180: END IF;

Line 214: wf_engine.SetItemAttrTextArray( itemtype

210: l_aname(3) := 'EXPIRATION_DATE';
211: --Bug 12884612: Use date mask while converting to text
212: l_avaluetext(3) := to_char(l_expiration_date,'DD-MON-RRRR');
213:
214: wf_engine.SetItemAttrTextArray( itemtype
215: , itemkey
216: , l_aname
217: , l_avaluetext
218: );

Line 332: l_aname wf_engine.nametabtyp;

328: --l_customer_number NUMBER;
329: l_customer_number varchar2(30); --bug4575846
330: l_expiration_date DATE;
331:
332: l_aname wf_engine.nametabtyp;
333: l_avaluetext wf_engine.texttabtyp;
334:
335: BEGIN
336:

Line 333: l_avaluetext wf_engine.texttabtyp;

329: l_customer_number varchar2(30); --bug4575846
330: l_expiration_date DATE;
331:
332: l_aname wf_engine.nametabtyp;
333: l_avaluetext wf_engine.texttabtyp;
334:
335: BEGIN
336:
337: --

Line 366: l_sales_document_type_code := wf_engine.GetItemAttrText(

362: WHERE TRANSACTION_ID = l_transaction_id);
363:
364:
365: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
366: l_sales_document_type_code := wf_engine.GetItemAttrText(
367: OE_GLOBALS.G_WFI_NGO,
368: l_transaction_id,
369: 'SALES_DOCUMENT_TYPE_CODE');
370: END IF;

Line 409: wf_engine.SetItemAttrText(itemtype,

405: OE_STANDARD_WF.Clear_Msg_Context;
406: return;
407:
408: else
409: wf_engine.SetItemAttrText(itemtype,
410: itemkey,
411: 'NOTIFICATION_APPROVER',
412: l_role);
413:

Line 451: wf_engine.SetItemAttrTextArray( itemtype

447: l_aname(3) := 'EXPIRATION_DATE';
448: --Bug 12884612: Use date mask while converting to text
449: l_avaluetext(3) := to_char(l_expiration_date,'DD-MON-RRRR');
450:
451: wf_engine.SetItemAttrTextArray( itemtype
452: , itemkey
453: , l_aname
454: , l_avaluetext
455: );

Line 769: l_sales_document_type_code := wf_engine.GetItemAttrText(

765:
766: l_transaction_id := to_number(itemkey);
767:
768: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
769: l_sales_document_type_code := wf_engine.GetItemAttrText(
770: OE_GLOBALS.G_WFI_NGO,
771: l_transaction_id,
772: 'SALES_DOCUMENT_TYPE_CODE');
773: END IF;

Line 804: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);

800: -- end data fix project
801: --app_exception.raise_exception;
802: --bug7386039
803:
804: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);
805: return;
806:
807: END IF;
808:

Line 912: l_sales_document_type_code := wf_engine.GetItemAttrText(

908: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN
909:
910: -- If the current approver is the last in the list, then still reject it.
911: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
912: l_sales_document_type_code := wf_engine.GetItemAttrText(
913: OE_GLOBALS.G_WFI_NGO,
914: l_transaction_id,
915: 'SALES_DOCUMENT_TYPE_CODE');
916: END IF;

Line 1079: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);

1075: -- OE_STANDARD_WF.Clear_Msg_Context;
1076: -- end data fix project
1077: --app_exception.raise_exception;
1078: --bug7386039
1079: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);
1080: return;
1081:
1082: END IF;
1083:

Line 1274: l_sales_document_type_code := wf_engine.GetItemAttrText(

1270: from WF_ITEM_ACTIVITY_STATUSES
1271: where NOTIFICATION_ID = to_number(document_id);
1272:
1273:
1274: l_sales_document_type_code := wf_engine.GetItemAttrText(
1275: OE_GLOBALS.G_WFI_NGO,
1276: to_char(l_transaction_id),
1277: 'SALES_DOCUMENT_TYPE_CODE');
1278:

Line 1322: l_aname wf_engine.nametabtyp;

1318: l_sold_to VARCHAR2 (240);
1319: --l_customer_number NUMBER;
1320: l_customer_number VARCHAR2 (30); -- bug4575846
1321: l_expiration_date DATE;
1322: l_aname wf_engine.nametabtyp;
1323: l_avaluetext wf_engine.texttabtyp;
1324: ----++++++++++++++++++++++++++++++++++++++++++++
1325: l_admin_approver ame_util.approverrecord;
1326: l_ret_approver VARCHAR2 (50);

Line 1323: l_avaluetext wf_engine.texttabtyp;

1319: --l_customer_number NUMBER;
1320: l_customer_number VARCHAR2 (30); -- bug4575846
1321: l_expiration_date DATE;
1322: l_aname wf_engine.nametabtyp;
1323: l_avaluetext wf_engine.texttabtyp;
1324: ----++++++++++++++++++++++++++++++++++++++++++++
1325: l_admin_approver ame_util.approverrecord;
1326: l_ret_approver VARCHAR2 (50);
1327: l_name wf_users.NAME%TYPE; --bug 8620671

Line 1374: l_aname2 wf_engine.nametabtyp;

1370: l_ame_transaction VARCHAR2 (250);
1371: l_item_type VARCHAR2 (10) := 'OEAME';
1372: l_nego_url VARCHAR2 (1000);
1373: l_order_url VARCHAR2 (1000);
1374: l_aname2 wf_engine.nametabtyp;
1375: l_avalue wf_engine.numtabtyp;
1376: i NUMBER := 0;
1377: -- for attribute text
1378: j NUMBER := 0;

Line 1375: l_avalue wf_engine.numtabtyp;

1371: l_item_type VARCHAR2 (10) := 'OEAME';
1372: l_nego_url VARCHAR2 (1000);
1373: l_order_url VARCHAR2 (1000);
1374: l_aname2 wf_engine.nametabtyp;
1375: l_avalue wf_engine.numtabtyp;
1376: i NUMBER := 0;
1377: -- for attribute text
1378: j NUMBER := 0;
1379: l_process_out VARCHAR2 (10);

Line 1428: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,

1424:
1425: IF itemtype = oe_globals.g_wfi_ngo
1426: THEN
1427: l_sales_document_type_code :=
1428: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,
1429: l_transaction_id,
1430: 'SALES_DOCUMENT_TYPE_CODE'
1431: );
1432:

Line 1717: wf_engine.createprocess

1713:
1714: -- Create a child process for the retrieved approver.
1715: IF itemtype = 'OENH'
1716: THEN
1717: wf_engine.createprocess
1718: (itemtype => l_item_type,
1719: itemkey => l_item_key,
1720: process => 'AME_PARALLEL_APPROVAL'
1721: );

Line 1724: wf_engine.createprocess

1720: process => 'AME_PARALLEL_APPROVAL'
1721: );
1722: ELSIF itemtype = 'OEOH'
1723: THEN
1724: wf_engine.createprocess
1725: (itemtype => l_item_type,
1726: itemkey => l_item_key,
1727: process => 'AME_PARALLEL_APPR_RMA'
1728: );

Line 1732: wf_engine.setitemparent (itemtype => l_item_type,

1728: );
1729: END IF;
1730:
1731: /* Need to set the parent child relationship between processes */
1732: wf_engine.setitemparent (itemtype => l_item_type,
1733: itemkey => l_item_key,
1734: parent_itemtype => itemtype,
1735: parent_itemkey => itemkey,
1736: parent_context => NULL

Line 1739: wf_engine.setitemattrnumber (itemtype,

1735: parent_itemkey => itemkey,
1736: parent_context => NULL
1737: );
1738: IF itemtype = 'OENH' THEN
1739: wf_engine.setitemattrnumber (itemtype,
1740: itemkey,
1741: 'HEADER_ID',
1742: TO_NUMBER (itemkey)
1743: );

Line 1747: wf_engine.getitemattrtext (itemtype,

1743: );
1744:
1745: END IF ;
1746: l_notif_from_role :=
1747: wf_engine.getitemattrtext (itemtype,
1748: itemkey,
1749: 'NOTIFICATION_FROM_ROLE'
1750: );
1751: i := i + 1;

Line 1773: wf_engine.getitemattrtext (itemtype,

1769: i := i + 1;
1770: l_aname (i) := 'SALES_DOCUMENT_TYPE_CODE';
1771: l_avaluetext (i) := l_sales_document_type_code;
1772: l_sales_document_type :=
1773: wf_engine.getitemattrtext (itemtype,
1774: itemkey,
1775: 'SALES_DOCUMENT_TYPE'
1776: );
1777: i := i + 1;

Line 1781: wf_engine.getitemattrtext (itemtype,

1777: i := i + 1;
1778: l_aname (i) := 'SALES_DOCUMENT_TYPE';
1779: l_avaluetext (i) := l_sales_document_type;
1780: l_nego_details :=
1781: wf_engine.getitemattrtext (itemtype,
1782: itemkey,
1783: 'NEGOTIATION_DETAILS'
1784: );
1785: i := i + 1;

Line 1789: wf_engine.getitemattrtext (itemtype,

1785: i := i + 1;
1786: l_aname (i) := 'NEGOTIATION_DETAILS';
1787: l_avaluetext (i) := l_nego_details;
1788: l_nego_url :=
1789: wf_engine.getitemattrtext (itemtype,
1790: itemkey,
1791: 'NEGOTIATION_DETAILS_URL'
1792: );
1793: i := i + 1;

Line 1797: wf_engine.getitemattrtext

1793: i := i + 1;
1794: l_aname (i) := 'NEGOTIATION_DETAILS_URL';
1795: l_avaluetext (i) := l_nego_url;
1796: l_nego_short_desc :=
1797: wf_engine.getitemattrtext
1798: (itemtype,
1799: itemkey,
1800: 'NEGOTIATION_SHORT_DESCRIPTOR'
1801: );

Line 1808: wf_engine.setitemattrnumber (itemtype,

1804: l_avaluetext (i) := l_nego_short_desc;
1805: j := j + 1;
1806: l_aname2 (j) := 'TRANSACTION_NUMBER';
1807: l_avalue (j) := l_transaction_number;
1808: wf_engine.setitemattrnumber (itemtype,
1809: itemkey,
1810: 'TRANSACTION_NUMBER',
1811: l_transaction_number
1812: );

Line 1856: wf_engine.setitemattrtext (itemtype,

1852:
1853: IF l_attachment_location IS NOT NULL
1854: THEN
1855:
1856: wf_engine.setitemattrtext (itemtype,
1857: itemkey,
1858: 'CONTRACT_ATTACHMENT',
1859: l_attachment_location
1860: );

Line 1867: wf_engine.getitemattrnumber (itemtype,

1863: l_avaluetext (i) := l_attachment_location;
1864: END IF;
1865: ELSE -- type is rma and not quote.
1866: l_order_number :=
1867: wf_engine.getitemattrnumber (itemtype,
1868: itemkey,
1869: 'ORDER_NUMBER'
1870: );
1871: j := j + 1;

Line 1875: wf_engine.getitemattrtext (itemtype,

1871: j := j + 1;
1872: l_aname2 (j) := 'ORDER_NUMBER';
1873: l_avalue (j) := l_order_number;
1874: l_order_url :=
1875: wf_engine.getitemattrtext (itemtype,
1876: itemkey,
1877: 'ORDER_DETAILS_URL'
1878: );
1879: i := i + 1;

Line 1883: wf_engine.getitemattrtext (itemtype,

1879: i := i + 1;
1880: l_aname (i) := 'ORDER_DETAILS_URL';
1881: l_avaluetext (i) := l_order_url;
1882: l_rma_descriptor :=
1883: wf_engine.getitemattrtext (itemtype,
1884: itemkey,
1885: 'HDR_SHORT_DESCRIPTOR'
1886: );
1887: i := i + 1;

Line 1932: wf_engine.setitemattrtext (itemtype,

1928: );
1929: i := i + 1;
1930: l_aname (i) := 'SALESPERSON';
1931: l_avaluetext (i) := l_salesrep;
1932: wf_engine.setitemattrtext (itemtype,
1933: itemkey,
1934: 'SALESPERSON',
1935: l_salesrep
1936: );

Line 1940: wf_engine.setitemattrtext (itemtype,

1936: );
1937: i := i + 1;
1938: l_aname (i) := 'SOLD_TO';
1939: l_avaluetext (i) := l_sold_to;
1940: wf_engine.setitemattrtext (itemtype,
1941: itemkey,
1942: 'SOLD_TO',
1943: l_sold_to
1944: );

Line 1956: wf_engine.setitemattrtextarray (l_item_type,

1952: oe_debug_pub.ADD ('before calling start process');
1953: END IF;
1954: END IF;
1955:
1956: wf_engine.setitemattrtextarray (l_item_type,
1957: l_item_key,
1958: l_aname,
1959: l_avaluetext
1960: );

Line 1961: wf_engine.setitemattrnumberarray (l_item_type,

1957: l_item_key,
1958: l_aname,
1959: l_avaluetext
1960: );
1961: wf_engine.setitemattrnumberarray (l_item_type,
1962: l_item_key,
1963: l_aname2,
1964: l_avalue
1965: );

Line 1967: wf_engine.startprocess (itemtype => l_item_type,

1963: l_aname2,
1964: l_avalue
1965: );
1966: -------itemtype = OE_GLOBALS.G_WFI_NGO-------
1967: wf_engine.startprocess (itemtype => l_item_type,
1968: itemkey => l_item_key
1969: );
1970: END IF;
1971: END LOOP;

Line 2053: --wf_engine.setitemattrtext (itemtype, itemkey, 'AME_EXCEPTION', 'Y');

2049: oe_standard_wf.save_messages;
2050: oe_standard_wf.clear_msg_context;
2051: -- end data fix project
2052: --resultout := 'COMPLETE:INVALID_APPROVER';
2053: --wf_engine.setitemattrtext (itemtype, itemkey, 'AME_EXCEPTION', 'Y');
2054: ROLLBACK TO get_ame_approvers_launch;
2055: RAISE;
2056: END get_ame_approvers_launch;
2057:

Line 2073: wf_engine.getitemattrtext (itemtype => itemtype,

2069: IF l_debug_level >0 THEN
2070: oe_debug_pub.ADD ('Checking if there is AME exception');
2071: END IF ;
2072: l_exception :=
2073: wf_engine.getitemattrtext (itemtype => itemtype,
2074: itemkey => itemkey,
2075: aname => 'AME_EXCEPTION'
2076: );
2077: IF l_debug_level >0 THEN

Line 2201: wf_engine.abortprocess (i.item_type, i.item_key);

2197: THEN
2198: FOR i IN get_all_children
2199: LOOP
2200: -- if exception is encounted before children are aborted, they would be left orphans in case of rejection.
2201: wf_engine.abortprocess (i.item_type, i.item_key);
2202: END LOOP;
2203:
2204: resultout := 'COMPLETE:REJECTION';
2205: IF l_debug_level > 0 THEN

Line 2297: l_aname wf_engine.nametabtyp;

2293: l_sold_to VARCHAR2 (240);
2294: --l_customer_number NUMBER;
2295: l_customer_number VARCHAR2 (30); --bug4575846
2296: l_expiration_date DATE;
2297: l_aname wf_engine.nametabtyp;
2298: l_avaluetext wf_engine.texttabtyp;
2299: ----++++++++++++++++++++++++++++++++++++++++++++
2300: l_admin_approver ame_util.approverrecord;
2301: l_ret_approver VARCHAR2 (50);

Line 2298: l_avaluetext wf_engine.texttabtyp;

2294: --l_customer_number NUMBER;
2295: l_customer_number VARCHAR2 (30); --bug4575846
2296: l_expiration_date DATE;
2297: l_aname wf_engine.nametabtyp;
2298: l_avaluetext wf_engine.texttabtyp;
2299: ----++++++++++++++++++++++++++++++++++++++++++++
2300: l_admin_approver ame_util.approverrecord;
2301: l_ret_approver VARCHAR2 (50);
2302: l_name wf_users.NAME%TYPE; --bug 8620671

Line 2377: wf_engine.getitemattrtext (itemtype,

2373:
2374: -- We need to set the status of the last approver to APPROVED here
2375: -- in the OE_APPROVER_TRANSACTIONS
2376: l_role :=
2377: wf_engine.getitemattrtext (itemtype,
2378: l_transaction_id,
2379: 'NOTIFICATION_APPROVER'
2380: );
2381:

Line 2386: wf_engine.getitemattrtext (itemtype,

2382: IF l_parent_itemtype = oe_globals.g_wfi_ngo
2383: THEN
2384: BEGIN
2385: l_sales_document_type_code :=
2386: wf_engine.getitemattrtext (itemtype,
2387: l_transaction_id,
2388: 'SALES_DOCUMENT_TYPE_CODE'
2389: );
2390: EXCEPTION

Line 2412: wf_engine.getitemattrtext (itemtype,

2408: oe_debug_pub.ADD ('l_setp - ' || l_step);
2409: oe_debug_pub.ADD ('l_setp - ' || l_step);
2410: END IF ;
2411: l_name :=
2412: wf_engine.getitemattrtext (itemtype,
2413: l_transaction_id,
2414: 'NOTIFICATION_APPROVER'
2415: );
2416: l_orig_system :=

Line 2417: wf_engine.getitemattrtext (itemtype,

2413: l_transaction_id,
2414: 'NOTIFICATION_APPROVER'
2415: );
2416: l_orig_system :=
2417: wf_engine.getitemattrtext (itemtype,
2418: l_transaction_id,
2419: 'ORIG_SYSTEM'
2420: );
2421: l_orig_system_id :=

Line 2422: wf_engine.getitemattrtext (itemtype,

2418: l_transaction_id,
2419: 'ORIG_SYSTEM'
2420: );
2421: l_orig_system_id :=
2422: wf_engine.getitemattrtext (itemtype,
2423: l_transaction_id,
2424: 'ORIG_SYSTEM_ID'
2425: );
2426: l_user_id :=

Line 2427: wf_engine.getitemattrtext (itemtype,

2423: l_transaction_id,
2424: 'ORIG_SYSTEM_ID'
2425: );
2426: l_user_id :=
2427: wf_engine.getitemattrtext (itemtype,
2428: l_transaction_id,
2429: 'USER_ID'
2430: );
2431: IF l_debug_level > 0 THEN

Line 2535: wf_engine.setitemattrtextarray (itemtype,

2531: l_aname (1) := 'APPROVER_RESPONSE';
2532: l_avaluetext (1) := 'APPROVED';
2533: l_aname (2) := 'AME_SUB_APPROVAL_RESPONSE';
2534: l_avaluetext (2) := 'APPROVED';
2535: wf_engine.setitemattrtextarray (itemtype,
2536: itemkey,
2537: l_aname,
2538: l_avaluetext
2539: );

Line 2540: wf_engine.setitemattrtextarray (l_parent_itemtype,

2536: itemkey,
2537: l_aname,
2538: l_avaluetext
2539: );
2540: wf_engine.setitemattrtextarray (l_parent_itemtype,
2541: l_parent_itemkey,
2542: l_aname,
2543: l_avaluetext
2544: );

Line 2574: wf_engine.setitemattrtext (l_parent_itemtype,

2570: END IF;
2571: EXCEPTION
2572: WHEN xx_ame
2573: THEN
2574: wf_engine.setitemattrtext (l_parent_itemtype,
2575: l_parent_itemkey,
2576: 'AME_EXCEPTION',
2577: 'Y'
2578: );

Line 2623: l_aname wf_engine.nametabtyp;

2619: l_sold_to VARCHAR2 (240);
2620: --l_customer_number NUMBER;
2621: l_customer_number VARCHAR2 (30); --bug4575846
2622: l_expiration_date DATE;
2623: l_aname wf_engine.nametabtyp;
2624: l_avaluetext wf_engine.texttabtyp;
2625: ----++++++++++++++++++++++++++++++++++++++++++++
2626: l_admin_approver ame_util.approverrecord;
2627: l_ret_approver VARCHAR2 (50);

Line 2624: l_avaluetext wf_engine.texttabtyp;

2620: --l_customer_number NUMBER;
2621: l_customer_number VARCHAR2 (30); --bug4575846
2622: l_expiration_date DATE;
2623: l_aname wf_engine.nametabtyp;
2624: l_avaluetext wf_engine.texttabtyp;
2625: ----++++++++++++++++++++++++++++++++++++++++++++
2626: l_admin_approver ame_util.approverrecord;
2627: l_ret_approver VARCHAR2 (50);
2628: l_name wf_users.NAME%TYPE; --bug 8620671

Line 2703: wf_engine.getitemattrtext (itemtype,

2699:
2700: -- We need to set the status of the last approver to APPROVED here
2701: -- in the OE_APPROVER_TRANSACTIONS
2702: l_role :=
2703: wf_engine.getitemattrtext (itemtype,
2704: l_transaction_id,
2705: 'NOTIFICATION_APPROVER'
2706: );
2707:

Line 2712: wf_engine.getitemattrtext (itemtype,

2708: IF l_parent_item_type = oe_globals.g_wfi_ngo
2709: THEN
2710: BEGIN
2711: l_sales_document_type_code :=
2712: wf_engine.getitemattrtext (itemtype,
2713: l_transaction_id,
2714: 'SALES_DOCUMENT_TYPE_CODE'
2715: );
2716: EXCEPTION

Line 2738: wf_engine.getitemattrtext (itemtype,

2734: oe_debug_pub.ADD ('l_setp - ' || l_step);
2735: oe_debug_pub.ADD ('l_setp - ' || l_step);
2736: END IF ;
2737: l_name :=
2738: wf_engine.getitemattrtext (itemtype,
2739: l_transaction_id,
2740: 'NOTIFICATION_APPROVER'
2741: );
2742: l_orig_system :=

Line 2743: wf_engine.getitemattrtext (itemtype,

2739: l_transaction_id,
2740: 'NOTIFICATION_APPROVER'
2741: );
2742: l_orig_system :=
2743: wf_engine.getitemattrtext (itemtype,
2744: l_transaction_id,
2745: 'ORIG_SYSTEM'
2746: );
2747: l_orig_system_id :=

Line 2748: wf_engine.getitemattrtext (itemtype,

2744: l_transaction_id,
2745: 'ORIG_SYSTEM'
2746: );
2747: l_orig_system_id :=
2748: wf_engine.getitemattrtext (itemtype,
2749: l_transaction_id,
2750: 'ORIG_SYSTEM_ID'
2751: );
2752: l_user_id :=

Line 2753: wf_engine.getitemattrtext (itemtype,

2749: l_transaction_id,
2750: 'ORIG_SYSTEM_ID'
2751: );
2752: l_user_id :=
2753: wf_engine.getitemattrtext (itemtype,
2754: l_transaction_id,
2755: 'USER_ID'
2756: );
2757: IF l_debug_level > 0 THEN

Line 2861: wf_engine.setitemattrtextarray (itemtype,

2857: l_aname (1) := 'APPROVER_RESPONSE';
2858: l_avaluetext (1) := 'REJECTED';
2859: l_aname (2) := 'AME_SUB_APPROVAL_RESPONSE';
2860: l_avaluetext (2) := 'REJECT';
2861: wf_engine.setitemattrtextarray (itemtype,
2862: itemkey,
2863: l_aname,
2864: l_avaluetext
2865: );

Line 2866: wf_engine.setitemattrtextarray (l_parent_item_type,

2862: itemkey,
2863: l_aname,
2864: l_avaluetext
2865: );
2866: wf_engine.setitemattrtextarray (l_parent_item_type,
2867: l_parent_itemkey,
2868: l_aname,
2869: l_avaluetext
2870: );

Line 2900: wf_engine.setitemattrtext (l_parent_item_type,

2896: END IF;
2897: EXCEPTION
2898: WHEN xx_ame
2899: THEN
2900: wf_engine.setitemattrtext (l_parent_item_type,
2901: l_parent_itemkey,
2902: 'AME_EXCEPTION',
2903: 'Y'
2904: );

Line 2999: wf_engine.getitemattrtext (itemtype => l_parent_item_type,

2995: /* Check if there we have encountered any ame exception.
2996: If the value of ame_exception is not null, then we have faced some exception.
2997: So just comlete the block activity and return */
2998: l_ame_exception :=
2999: wf_engine.getitemattrtext (itemtype => l_parent_item_type,
3000: itemkey => l_parent_item_key,
3001: aname => 'AME_EXCEPTION'
3002: );
3003: IF l_debug_level > 0 THEN

Line 3009: wf_engine.getitemattrtext (itemtype => itemtype,

3005: || l_ame_exception
3006: );
3007: END IF ;
3008: l_current_person_id :=
3009: wf_engine.getitemattrtext (itemtype => itemtype,
3010: itemkey => itemkey,
3011: aname => 'ORIG_SYSTEM_ID'
3012: );
3013:

Line 3020: /* l_approver_group_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3016: resultout := 'COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
3017: RETURN;
3018: END IF;
3019:
3020: /* l_approver_group_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3021: itemkey => itemkey,
3022: aname => 'APPROVAL_GROUP_ID');*/
3023: /*l_header_id :=
3024: wf_engine.getitemattrnumber (itemtype => l_parent_item_type,

Line 3024: wf_engine.getitemattrnumber (itemtype => l_parent_item_type,

3020: /* l_approver_group_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3021: itemkey => itemkey,
3022: aname => 'APPROVAL_GROUP_ID');*/
3023: /*l_header_id :=
3024: wf_engine.getitemattrnumber (itemtype => l_parent_item_type,
3025: itemkey => l_parent_item_key,
3026: aname => 'HEADER_ID'
3027: ); not required. Since this procedure is always called
3028: only from child parallel flow, parent item key is the header id always*/

Line 3037: wf_engine.getitemattrtext (itemtype => itemtype,

3033: IF l_debug_level > 0 THEN
3034: oe_debug_pub.ADD ('Header id derived is:' || l_header_id);
3035: END IF ;
3036: l_approver_response :=
3037: wf_engine.getitemattrtext (itemtype => itemtype,
3038: itemkey => itemkey,
3039: aname => 'APPROVER_RESPONSE'
3040: );
3041: IF l_debug_level > 0 THEN

Line 3050: wf_engine.getitemattrtext (itemtype,

3046: IF l_parent_item_type = 'OENH'
3047: THEN
3048: BEGIN
3049: l_sales_document_type_code :=
3050: wf_engine.getitemattrtext (itemtype,
3051: itemkey,
3052: 'SALES_DOCUMENT_TYPE_CODE'
3053: );
3054: EXCEPTION

Line 3195: /* l_child_approver_empid := wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.ADD ('Inside getting child workflows');
3193: END IF ;
3194:
3195: /* l_child_approver_empid := wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3196: itemkey => l_child_wf_cur.item_key,
3197: aname => 'APPROVER_EMPID');
3198:
3199: l_child_approver_groupid :=wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

Line 3199: l_child_approver_groupid :=wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

3195: /* l_child_approver_empid := wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3196: itemkey => l_child_wf_cur.item_key,
3197: aname => 'APPROVER_EMPID');
3198:
3199: l_child_approver_groupid :=wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3200: itemkey => l_child_wf_cur.item_key,
3201: aname => 'APPROVAL_GROUP_ID');
3202:
3203:

Line 3225: wf_engine.abortprocess (l_child_wf_cur.item_type,

3221: oe_debug_pub.ADD ( 'before aborting the flow for:'
3222: || l_child_wf_cur.item_key
3223: );
3224: END IF ;
3225: wf_engine.abortprocess (l_child_wf_cur.item_type,
3226: l_child_wf_cur.item_key
3227: );
3228: EXCEPTION
3229: WHEN NO_DATA_FOUND

Line 3251: wf_engine.abortprocess (l_child_wf_cur.item_type,

3247: FETCH l_child_wf
3248: INTO l_child_wf_cur;
3249:
3250: EXIT WHEN l_child_wf%NOTFOUND;
3251: wf_engine.abortprocess (l_child_wf_cur.item_type,
3252: l_child_wf_cur.item_key
3253: );
3254: END LOOP;
3255:

Line 3264: wf_engine.setitemattrtext (l_parent_item_type,

3260: RETURN;
3261: EXCEPTION
3262: WHEN xx_ame
3263: THEN
3264: wf_engine.setitemattrtext (l_parent_item_type,
3265: l_parent_item_key,
3266: 'AME_EXCEPTION',
3267: 'Y'
3268: );

Line 3313: l_sales_document_type_code := wf_engine.GetItemAttrText(

3309: g_ame_used := 'N';
3310:
3311: IF itemtype = oe_globals.g_wfi_ngo
3312: THEN
3313: l_sales_document_type_code := wf_engine.GetItemAttrText(
3314: itemtype,
3315: itemkey,
3316: 'SALES_DOCUMENT_TYPE_CODE');
3317: IF l_debug_level > 0 THEN

Line 3466: wf_engine.completeactivity (itemtype => l_parent_item_type,

3462:
3463: g_current_item_key := itemkey;
3464:
3465: BEGIN
3466: wf_engine.completeactivity (itemtype => l_parent_item_type,
3467: itemkey => l_parent_item_key,
3468: activity => 'WAIT_FOR_AME',
3469: RESULT => NULL
3470: );