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

Line 57: wf_engine.createprocess (

53: l_itemtype := P_itemtype_name; --'ASOAPPRV';
54: l_itemkey := TO_CHAR (
55: P_Object_approval_id
56: ) || 'HED';
57: wf_engine.createprocess (
58: itemtype => l_itemtype,
59: itemkey => l_itemkey,
60: process => 'STARTAPPROVALS'
61: );

Line 62: wf_engine.setitemowner (

58: itemtype => l_itemtype,
59: itemkey => l_itemkey,
60: process => 'STARTAPPROVALS'
61: );
62: wf_engine.setitemowner (
63: l_itemtype, --'ASOAPPRV',
64: l_itemkey,
65: P_sender_name
66: );

Line 67: wf_engine.setitemuserkey (

63: l_itemtype, --'ASOAPPRV',
64: l_itemkey,
65: P_sender_name
66: );
67: wf_engine.setitemuserkey (
68: itemtype => l_itemtype,
69: itemkey => l_itemkey,
70: userkey => l_itemkey
71: );

Line 72: wf_engine.setitemattrtext (

68: itemtype => l_itemtype,
69: itemkey => l_itemkey,
70: userkey => l_itemkey
71: );
72: wf_engine.setitemattrtext (
73: itemtype => l_itemtype,
74: itemkey => l_itemkey,
75: aname => 'REQUESTOR_USERNAME',
76: avalue => P_sender_name

Line 78: wf_engine.setitemattrnumber (

74: itemkey => l_itemkey,
75: aname => 'REQUESTOR_USERNAME',
76: avalue => P_sender_name
77: );
78: wf_engine.setitemattrnumber (
79: itemtype => l_itemtype,
80: itemkey => l_itemkey,
81: aname => 'APPROVALID',
82: avalue => P_Object_approval_id

Line 85: wf_engine.setitemattrtext (

81: aname => 'APPROVALID',
82: avalue => P_Object_approval_id
83: );
84:
85: wf_engine.setitemattrtext (
86: itemtype => l_itemtype,
87: itemkey => l_itemkey,
88: aname => 'NEWPROCESSFLAG',
89: avalue =>'Y'

Line 96: wf_engine.setitemattrtext (

92:
93: l_requestor_display_name := wf_directory.getroledisplayname (
94: P_sender_name
95: );
96: wf_engine.setitemattrtext (
97: itemtype => l_itemtype,
98: itemkey => l_itemkey,
99: aname => 'REQUESTOR_DISPLAYNAME',
100: avalue => l_requestor_display_name

Line 110: wf_engine.startprocess (

106: 'N'
107: );
108: END IF;
109:
110: wf_engine.startprocess (
111: itemtype => l_itemtype,
112: itemkey => l_itemkey
113: );
114:

Line 186: l_approval_id := wf_engine.getitemattrnumber (

182: END IF;
183:
184: IF funcmode = 'RUN'
185: THEN
186: l_approval_id := wf_engine.getitemattrnumber (
187: itemtype,
188: itemkey,
189: 'APPROVALID'
190: );

Line 191: l_requestor_name := wf_engine.getitemattrtext (

187: itemtype,
188: itemkey,
189: 'APPROVALID'
190: );
191: l_requestor_name := wf_engine.getitemattrtext (
192: itemtype,
193: itemkey,
194: 'REQUESTOR_USERNAME'
195: );

Line 197: wf_engine.getitemattrtext (

193: itemkey,
194: 'REQUESTOR_USERNAME'
195: );
196: l_requestor_displayname :=
197: wf_engine.getitemattrtext (
198: itemtype,
199: itemkey,
200: 'REQUESTOR_DISPLAYNAME'
201: );

Line 275: wf_engine.createprocess (

271: 1,
272: 'N'
273: );
274: END IF;
275: wf_engine.createprocess (
276: itemtype => itemtype,
277: itemkey => l_itemkey,
278: process => 'INDIVIDUAL_APPROVAL'
279: );

Line 280: wf_engine.setitemuserkey (

276: itemtype => itemtype,
277: itemkey => l_itemkey,
278: process => 'INDIVIDUAL_APPROVAL'
279: );
280: wf_engine.setitemuserkey (
281: itemtype => itemtype,
282: itemkey => l_itemkey,
283: userkey => l_itemkey
284: );

Line 285: wf_engine.setitemattrnumber (

281: itemtype => itemtype,
282: itemkey => l_itemkey,
283: userkey => l_itemkey
284: );
285: wf_engine.setitemattrnumber (
286: itemtype => itemtype,
287: itemkey => l_itemkey,
288: aname => 'APPROVAL_DET_ID',
289: avalue => i.approval_det_id

Line 291: wf_engine.setitemattrtext (

287: itemkey => l_itemkey,
288: aname => 'APPROVAL_DET_ID',
289: avalue => i.approval_det_id
290: );
291: wf_engine.setitemattrtext (
292: itemtype => itemtype, --'ASOAPPRV',
293: itemkey => l_itemkey,
294: aname => 'REQUESTOR_DISPLAYNAME',
295: avalue => l_requestor_displayname

Line 297: wf_engine.setitemattrtext (

293: itemkey => l_itemkey,
294: aname => 'REQUESTOR_DISPLAYNAME',
295: avalue => l_requestor_displayname
296: );
297: wf_engine.setitemattrtext (
298: itemtype => itemtype,
299: itemkey => l_itemkey,
300: aname => 'RECEIVER_USERNAME',
301: avalue => l_forward_user_name

Line 304: wf_engine.setitemattrtext (

300: aname => 'RECEIVER_USERNAME',
301: avalue => l_forward_user_name
302: );
303:
304: wf_engine.setitemattrtext (
305: itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'NEWPROCESSFLAG',
308: avalue =>'Y'

Line 315: wf_engine.setitemattrtext (

311: l_forward_displayname :=
312: wf_directory.getroledisplayname (
313: l_forward_user_name
314: );
315: wf_engine.setitemattrtext (
316: itemtype => itemtype,
317: itemkey => l_itemkey,
318: aname => 'RECEIVER_DISPLAYNAME',
319: avalue => l_forward_displayname

Line 321: wf_engine.setitemattrtext (

317: itemkey => l_itemkey,
318: aname => 'RECEIVER_DISPLAYNAME',
319: avalue => l_forward_displayname
320: );
321: wf_engine.setitemattrtext (
322: itemtype => itemtype, --'ASOAPPRV',
323: itemkey => l_itemkey,
324: aname => 'REQUESTOR_USERNAME',
325: avalue => l_requestor_name

Line 327: wf_engine.setitemattrnumber (

323: itemkey => l_itemkey,
324: aname => 'REQUESTOR_USERNAME',
325: avalue => l_requestor_name
326: );
327: wf_engine.setitemattrnumber (
328: itemtype => itemtype, --'ASOAPPRV',
329: itemkey => l_itemkey,
330: aname => 'APPROVALID',
331: avalue => l_approval_id

Line 342: wf_engine.setitemattrtext (

338: 1,
339: 'N'
340: );
341: END IF;
342: wf_engine.setitemattrtext (
343: itemtype => itemtype, --'ASOAPPRV',
344: itemkey => l_itemkey,
345: aname => 'MESSAGE',
346: avalue => 'OA_FYI_TO_REQUESTER'

Line 350: wf_engine.setitemparent (

346: avalue => 'OA_FYI_TO_REQUESTER'
347: );
348: -- define the parent child relationship
349:
350: wf_engine.setitemparent (
351: itemtype => itemtype,
352: itemkey => l_itemkey,
353: parent_itemtype => itemtype,
354: parent_itemkey => itemkey,

Line 357: wf_engine.startprocess (

353: parent_itemtype => itemtype,
354: parent_itemkey => itemkey,
355: parent_context => NULL
356: );
357: wf_engine.startprocess (
358: itemtype => itemtype,
359: itemkey => l_itemkey
360: );
361: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 380: resultout := 'COMPLETE' || ':' || wf_engine.eng_null;

376: WHERE object_approval_id = l_approval_id
377: AND approver_sequence = next_seq;
378: END LOOP;
379:
380: resultout := 'COMPLETE' || ':' || wf_engine.eng_null;
381: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
382: aso_debug_pub.ADD (
383: 'End Sumbit_Approval Process',
384: 1,

Line 494: l_approval_id := wf_engine.getitemattrnumber (

490: END IF;
491:
492: IF funcmode = 'RUN'
493: THEN
494: l_approval_id := wf_engine.getitemattrnumber (
495: itemtype,
496: itemkey,
497: 'APPROVALID'
498: );

Line 499: l_approval_det_id := wf_engine.getitemattrnumber (

495: itemtype,
496: itemkey,
497: 'APPROVALID'
498: );
499: l_approval_det_id := wf_engine.getitemattrnumber (
500: itemtype,
501: itemkey,
502: 'APPROVAL_DET_ID'
503: );

Line 617: wf_engine.setitemattrtext (

613: 1,
614: 'N'
615: );
616: END IF;
617: wf_engine.setitemattrtext (
618: itemtype => itemtype,
619: itemkey => itemkey,
620: aname => 'MESSAGE',
621: avalue => 'OA_REQUEST_REJECTED'

Line 641: wf_engine.setitemattrtext (

637: 1,
638: 'N'
639: );
640: END IF;
641: wf_engine.setitemattrtext (
642: itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'MESSAGE',
645: avalue => 'OA_REQ_APPR_BY_ALL_APPR'

Line 660: l_new_process_flag := wf_engine.getitemattrnumber (

656:
657:
658: /* For backward compatibility */
659: BEGIN
660: l_new_process_flag := wf_engine.getitemattrnumber (
661: itemtype,
662: itemkey,
663: 'NEWPROCESSFLAG'
664: );

Line 809: l_approval_id := wf_engine.getitemattrnumber (

805: END IF;
806:
807: IF funcmode = 'RUN'
808: THEN
809: l_approval_id := wf_engine.getitemattrnumber (
810: itemtype,
811: itemkey,
812: 'APPROVALID'
813: );

Line 853: wf_engine.setitemattrtext (

849: 1,
850: 'N'
851: );
852: END IF;
853: wf_engine.setitemattrtext (
854: itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'MESSAGE',
857: avalue => 'OA_REQUEST_REJECTED'

Line 871: l_new_process_flag := wf_engine.getitemattrnumber (

867:
868:
869: /* For backward compatibility */
870: BEGIN
871: l_new_process_flag := wf_engine.getitemattrnumber (
872: itemtype,
873: itemkey,
874: 'NEWPROCESSFLAG'
875: );

Line 909: wf_engine.setitemattrtext (

905: 1,
906: 'N'
907: );
908: END IF;
909: wf_engine.setitemattrtext (
910: itemtype => itemtype,
911: itemkey => itemkey,
912: aname => 'MESSAGE',
913: avalue => 'OA_REQ_APPR_BY_ALL_APPR'

Line 1028: wf_engine.setitemattrtext (

1024: 1,
1025: 'N'
1026: );
1027: END IF;
1028: wf_engine.setitemattrtext (
1029: itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => 'MESSAGE',
1032: avalue => 'OA_REQUEST_APPROVED_FYI'

Line 1034: l_approval_det_id := wf_engine.getitemattrnumber (

1030: itemkey => itemkey,
1031: aname => 'MESSAGE',
1032: avalue => 'OA_REQUEST_APPROVED_FYI'
1033: );
1034: l_approval_det_id := wf_engine.getitemattrnumber (
1035: itemtype,
1036: itemkey,
1037: 'APPROVAL_DET_ID'
1038: );

Line 1046: l_note := wf_engine.getitemattrtext (

1042: 1,
1043: 'N'
1044: );
1045: END IF;
1046: l_note := wf_engine.getitemattrtext (
1047: itemtype,
1048: itemkey,
1049: 'NOTE'
1050: );

Line 1158: wf_engine.setitemattrtext (

1154: 1,
1155: 'N'
1156: );
1157: END IF;
1158: wf_engine.setitemattrtext (
1159: itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'MESSAGE',
1162: avalue => 'OA_REQUEST_REJECTED_FYI'

Line 1164: l_approval_det_id := wf_engine.getitemattrnumber (

1160: itemkey => itemkey,
1161: aname => 'MESSAGE',
1162: avalue => 'OA_REQUEST_REJECTED_FYI'
1163: );
1164: l_approval_det_id := wf_engine.getitemattrnumber (
1165: itemtype,
1166: itemkey,
1167: 'APPROVAL_DET_ID'
1168: );

Line 1176: l_note := wf_engine.getitemattrtext (

1172: 1,
1173: 'N'
1174: );
1175: END IF;
1176: l_note := wf_engine.getitemattrtext (
1177: itemtype,
1178: itemkey,
1179: 'NOTE'
1180: );

Line 1276: l_notification_id := wf_engine.getitemattrnumber (

1272: END IF;
1273:
1274: IF funcmode = 'RUN'
1275: THEN
1276: l_notification_id := wf_engine.getitemattrnumber (
1277: itemtype,
1278: itemkey,
1279: 'NOTIFICATION_ID'
1280: );

Line 1299: wf_engine.setitemattrtext (

1295: 1,
1296: 'N'
1297: );
1298: END IF;
1299: wf_engine.setitemattrtext (
1300: itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => 'MESSAGE',
1303: avalue => 'OA_REQUEST_TIMEDOUT_FYI'

Line 1305: l_approval_det_id := wf_engine.getitemattrnumber (

1301: itemkey => itemkey,
1302: aname => 'MESSAGE',
1303: avalue => 'OA_REQUEST_TIMEDOUT_FYI'
1304: );
1305: l_approval_det_id := wf_engine.getitemattrnumber (
1306: itemtype,
1307: itemkey,
1308: 'APPROVAL_DET_ID'
1309: );

Line 1310: l_note := wf_engine.getitemattrtext (

1306: itemtype,
1307: itemkey,
1308: 'APPROVAL_DET_ID'
1309: );
1310: l_note := wf_engine.getitemattrtext (
1311: itemtype,
1312: itemkey,
1313: 'NOTE'
1314: );

Line 1469: wf_engine.abortprocess (

1465: p_approval_det_id =>null,
1466: p_status => 'CAN',
1467: note => null);
1468:
1469: wf_engine.abortprocess (
1470: itemtype => p_itemtype, --'ASOAPPRV',
1471: itemkey => TO_CHAR (
1472: approval_id
1473: ) || 'HED',

Line 1567: wf_engine.completeactivityinternalname (

1563: END IF;
1564:
1565: -- fix for bug 3130487
1566: BEGIN
1567: wf_engine.completeactivityinternalname (
1568: p_itemtype, --'ASOAPPRV',
1569: TO_CHAR (
1570: i.approval_det_id
1571: ) || 'DET',

Line 1594: wf_engine.abortprocess (

1590: 1,
1591: 'N'
1592: );
1593: END IF;
1594: wf_engine.abortprocess (
1595: itemtype => p_itemtype, --'ASOAPPRV',
1596: itemkey => TO_CHAR (
1597: i.approval_det_id
1598: ) || 'DET',

Line 1612: wf_engine.createprocess (

1608: 1,
1609: 'N'
1610: );
1611: END IF;
1612: wf_engine.createprocess (
1613: itemtype => l_itemtype,
1614: itemkey => l_itemkey,
1615: process => 'CANCEL_REQUISITION'
1616: );

Line 1617: wf_engine.setitemuserkey (

1613: itemtype => l_itemtype,
1614: itemkey => l_itemkey,
1615: process => 'CANCEL_REQUISITION'
1616: );
1617: wf_engine.setitemuserkey (
1618: itemtype => l_itemtype,
1619: itemkey => l_itemkey,
1620: userkey => l_itemkey
1621: );

Line 1622: wf_engine.setitemattrnumber (

1618: itemtype => l_itemtype,
1619: itemkey => l_itemkey,
1620: userkey => l_itemkey
1621: );
1622: wf_engine.setitemattrnumber (
1623: itemtype => l_itemtype,
1624: itemkey => l_itemkey,
1625: aname => 'APPROVAL_DET_ID',
1626: avalue => i.approval_det_id

Line 1628: wf_engine.setitemattrtext (

1624: itemkey => l_itemkey,
1625: aname => 'APPROVAL_DET_ID',
1626: avalue => i.approval_det_id
1627: );
1628: wf_engine.setitemattrtext (
1629: itemtype => l_itemtype, --'ASOAPPRV',
1630: itemkey => l_itemkey,
1631: aname => 'REQUESTOR_DISPLAYNAME',
1632: avalue => l_requestor_displayname

Line 1634: wf_engine.setitemattrtext (

1630: itemkey => l_itemkey,
1631: aname => 'REQUESTOR_DISPLAYNAME',
1632: avalue => l_requestor_displayname
1633: );
1634: wf_engine.setitemattrtext (
1635: itemtype => l_itemtype, --'ASOAPPRV',
1636: itemkey => l_itemkey,
1637: aname => 'REQUESTOR_USERNAME',
1638: avalue => l_requestor_name

Line 1640: wf_engine.setitemattrtext (

1636: itemkey => l_itemkey,
1637: aname => 'REQUESTOR_USERNAME',
1638: avalue => l_requestor_name
1639: );
1640: wf_engine.setitemattrtext (
1641: itemtype => l_itemtype,
1642: itemkey => l_itemkey,
1643: aname => 'RECEIVER_USERNAME',
1644: avalue => l_forward_user_name

Line 1657: wf_engine.setitemattrtext (

1653: l_forward_displayname :=
1654: wf_directory.getroledisplayname (
1655: l_forward_user_name
1656: );
1657: wf_engine.setitemattrtext (
1658: itemtype => l_itemtype,
1659: itemkey => l_itemkey,
1660: aname => 'RECEIVER_DISPLAYNAME',
1661: avalue => l_forward_displayname

Line 1670: wf_engine.setitemattrtext (

1666: 1,
1667: 'N'
1668: );
1669: END IF;
1670: wf_engine.setitemattrtext (
1671: itemtype => l_itemtype,
1672: itemkey => l_itemkey,
1673: aname => 'REQUEST_CANCELLOR_USERNAME',
1674: avalue => l_cancellor_username

Line 1683: wf_engine.setitemattrtext (

1679: 1,
1680: 'N'
1681: );
1682: END IF;
1683: wf_engine.setitemattrtext (
1684: itemtype => l_itemtype,
1685: itemkey => l_itemkey,
1686: aname => 'REQUEST_CANCELLOR_DISPLAYNAME',
1687: avalue => l_cancellor_displayname

Line 1696: wf_engine.setitemattrnumber (

1692: 1,
1693: 'N'
1694: );
1695: END IF;
1696: wf_engine.setitemattrnumber (
1697: itemtype => l_itemtype, --'ASOAPPRV',
1698: itemkey => l_itemkey,
1699: aname => 'APPROVALID',
1700: avalue => l_approval_id

Line 1703: wf_engine.startprocess (

1699: aname => 'APPROVALID',
1700: avalue => l_approval_id
1701: );
1702:
1703: wf_engine.startprocess (
1704: itemtype => l_itemtype,
1705: itemkey => l_itemkey
1706: );
1707: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1821: l_notifname := wf_engine.getitemattrtext (

1817:
1818: IF funcmode = 'RUN'
1819: THEN
1820: -- Please note that the notification event name is same as message name
1821: l_notifname := wf_engine.getitemattrtext (
1822: itemtype,
1823: itemkey,
1824: 'MESSAGE'
1825: );

Line 1844: l_approval_id := wf_engine.getitemattrnumber (

1840:
1841: IF l_notifenabled = 'Y'
1842: THEN
1843: -- Get the approval id
1844: l_approval_id := wf_engine.getitemattrnumber (
1845: itemtype,
1846: itemkey,
1847: 'APPROVALID'
1848: );

Line 1863: l_orgid := wf_engine.getitemattrnumber (

1859: );
1860: FETCH get_org_id INTO l_orgid;
1861: CLOSE get_org_id; */
1862:
1863: l_orgid := wf_engine.getitemattrnumber (
1864: itemtype,
1865: itemkey,
1866: 'ORGID'
1867: );

Line 1918: wf_engine.setitemattrtext (

1914:
1915: IF l_msgenabled = 'Y'
1916: THEN
1917: -- Set the message name
1918: wf_engine.setitemattrtext (
1919: itemtype => itemtype,
1920: itemkey => itemkey,
1921: aname => 'MESSAGE',
1922: avalue => l_message

Line 1954: wf_engine.setitemattrtext (

1950: 1,
1951: 'N'
1952: );
1953: END IF;
1954: wf_engine.setitemattrtext (
1955: itemtype => itemtype,
1956: itemkey => itemkey,
1957: aname => 'MESSAGE',
1958: avalue => 'OA_REQUEST_APPROVAL'

Line 1967: l_message := wf_engine.getitemattrtext (

1963: RETURN;
1964: END IF;
1965: END IF;
1966:
1967: l_message := wf_engine.getitemattrtext (
1968: itemtype,
1969: itemkey,
1970: 'MESSAGE'
1971: );

Line 1989: l_notification_id := wf_engine.getitemattrnumber (

1985: 1,
1986: 'N'
1987: );
1988: END IF;
1989: l_notification_id := wf_engine.getitemattrnumber (
1990: itemtype,
1991: itemkey,
1992: 'NOTIFICATION_ID'
1993: );

Line 2067: wf_engine.setitemattrnumber (

2063: 1,
2064: 'N'
2065: );
2066: END IF;
2067: wf_engine.setitemattrnumber (
2068: itemtype => itemtype,
2069: itemkey => itemkey,
2070: aname => 'NOTIFICATION_ID',
2071: avalue => l_notification_id

Line 2086: wf_engine.setitemattrtext (

2082: 1,
2083: 'N'
2084: );
2085: END IF;
2086: wf_engine.setitemattrtext (
2087: itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'MESSAGE',
2090: avalue => 'OA_REQUEST_APPROVAL'

Line 2101: wf_engine.setitemattrtext (

2097: 1,
2098: 'N'
2099: );
2100: END IF;
2101: wf_engine.setitemattrtext (
2102: itemtype => itemtype,
2103: itemkey => itemkey,
2104: aname => 'MESSAGE',
2105: avalue => 'OA_REQUEST_APPROVAL_REM'

Line 2297: l_object_approval_id := wf_engine.getitemattrnumber (

2293: END IF;
2294:
2295: IF funcmode = 'RUN' THEN
2296:
2297: l_object_approval_id := wf_engine.getitemattrnumber (
2298: itemtype,
2299: itemkey,
2300: 'APPROVALID'
2301: );

Line 2303: l_notifname := wf_engine.getitemattrtext (

2299: itemkey,
2300: 'APPROVALID'
2301: );
2302:
2303: l_notifname := wf_engine.getitemattrtext (
2304: itemtype,
2305: itemkey,
2306: 'MESSAGE'
2307: );

Line 3723: l_message := wf_engine.getitemattrtext (

3719: END IF;
3720:
3721: IF funcmode = 'RUN'
3722: THEN
3723: l_message := wf_engine.getitemattrtext (
3724: itemtype,
3725: itemkey,
3726: 'MESSAGE'
3727: );

Line 3758: wf_engine.setitemattrtext (

3754: END IF;
3755: l_message := 'OA_REQUEST_CANCELLED_FYI';
3756: END IF;
3757:
3758: wf_engine.setitemattrtext (
3759: itemtype => itemtype,
3760: itemkey => itemkey,
3761: aname => 'MESSAGE',
3762: avalue => l_message

Line 3766: l_notifname := wf_engine.getitemattrtext (

3762: avalue => l_message
3763: );
3764: -- Please note that the notification event name is same as message name
3765:
3766: l_notifname := wf_engine.getitemattrtext (
3767: itemtype,
3768: itemkey,
3769: 'MESSAGE'
3770: );

Line 3786: l_approval_id := wf_engine.getitemattrnumber (

3782:
3783: IF l_notifenabled = 'Y'
3784: THEN
3785: -- Get the approval id
3786: l_approval_id := wf_engine.getitemattrnumber (
3787: itemtype,
3788: itemkey,
3789: 'APPROVALID'
3790: );

Line 3804: l_orgid := wf_engine.getitemattrnumber (

3800: l_approval_id
3801: );
3802: FETCH get_org_id INTO l_orgid;
3803: CLOSE get_org_id; */
3804: l_orgid := wf_engine.getitemattrnumber (
3805: itemtype,
3806: itemkey,
3807: 'ORGID'
3808: );

Line 3986: l_approval_id := wf_engine.getitemattrnumber (

3982: document_id,
3983: ':'
3984: ) + 1
3985: ) || 'HED';
3986: l_approval_id := wf_engine.getitemattrnumber (
3987: itemtype => itemtype,
3988: itemkey => itemkey,
3989: aname => 'APPROVALID'
3990: );

Line 4276: l_approval_id := wf_engine.getitemattrnumber (

4272: document_id,
4273: ':'
4274: ) + 1
4275: ) || 'HED';
4276: l_approval_id := wf_engine.getitemattrnumber (
4277: itemtype => itemtype,
4278: itemkey => itemkey,
4279: aname => 'APPROVALID'
4280: );

Line 4616: l_approval_id := wf_engine.getitemattrnumber (

4612: document_id,
4613: ':'
4614: ) + 1
4615: ) || 'HED';
4616: l_approval_id := wf_engine.getitemattrnumber (
4617: itemtype => itemtype,
4618: itemkey => itemkey,
4619: aname => 'APPROVALID'
4620: );

Line 4798: l_approval_id := wf_engine.getitemattrnumber (

4794: document_id,
4795: ':'
4796: ) + 1
4797: ) || 'HED';
4798: l_approval_id := wf_engine.getitemattrnumber (
4799: itemtype => itemtype,
4800: itemkey => itemkey,
4801: aname => 'APPROVALID'
4802: );

Line 5067: l_approval_id := wf_engine.getitemattrnumber (

5063: document_id,
5064: ':'
5065: ) + 1
5066: ) || 'HED';
5067: l_approval_id := wf_engine.getitemattrnumber (
5068: itemtype => itemtype,
5069: itemkey => itemkey,
5070: aname => 'APPROVALID'
5071: );

Line 5438: l_approval_id := wf_engine.getitemattrnumber (

5434: END IF;
5435:
5436: IF funcmode = 'RUN'
5437: THEN
5438: l_approval_id := wf_engine.getitemattrnumber (
5439: itemtype,
5440: itemkey,
5441: 'APPROVALID'
5442: );

Line 5458: wf_engine.setitemattrtext (

5454: 1,
5455: 'N'
5456: );
5457: END IF;
5458: wf_engine.setitemattrtext (
5459: itemtype => itemtype,
5460: itemkey => itemkey,
5461: aname => 'APPROVAL_OBJECT',
5462: avalue => l_approval_object

Line 5465: wf_engine.setitemattrnumber (

5461: aname => 'APPROVAL_OBJECT',
5462: avalue => l_approval_object
5463: );
5464:
5465: wf_engine.setitemattrnumber (
5466: itemtype => itemtype,
5467: itemkey => itemkey,
5468: aname => 'ORGID',
5469: avalue => l_org_id

Line 5472: wf_engine.setitemattrnumber (

5468: aname => 'ORGID',
5469: avalue => l_org_id
5470: );
5471:
5472: wf_engine.setitemattrnumber (
5473: itemtype => itemtype,
5474: itemkey => itemkey,
5475: aname => 'QTEHDRID',
5476: avalue => i.quote_header_id

Line 5479: wf_engine.setitemattrnumber (

5475: aname => 'QTEHDRID',
5476: avalue => i.quote_header_id
5477: );
5478:
5479: wf_engine.setitemattrnumber (
5480: itemtype => itemtype,
5481: itemkey => itemkey,
5482: aname => 'QTENUMBER',
5483: avalue => i.quote_number

Line 5503: wf_engine.setitemattrtext (

5499: aso_debug_pub.ADD ('l_url: '||substr(l_url,1,240),1,'N');
5500: END IF;
5501:
5502:
5503: wf_engine.setitemattrtext (
5504: itemtype => itemtype,
5505: itemkey => itemkey,
5506: aname => 'OAQTEDETAILLNK',
5507: avalue => l_url