DBA Data[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 1822: l_notifname := wf_engine.getitemattrtext (

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

Line 1845: l_approval_id := wf_engine.getitemattrnumber (

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

Line 1864: l_orgid := wf_engine.getitemattrnumber (

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

Line 1919: wf_engine.setitemattrtext (

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

Line 1955: wf_engine.setitemattrtext (

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

Line 1968: l_message := wf_engine.getitemattrtext (

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

Line 1990: l_notification_id := wf_engine.getitemattrnumber (

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

Line 2068: wf_engine.setitemattrnumber (

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

Line 2087: wf_engine.setitemattrtext (

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

Line 2102: wf_engine.setitemattrtext (

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

Line 2301: l_object_approval_id := wf_engine.getitemattrnumber (

2297: END IF;
2298:
2299: IF funcmode = 'RUN' THEN
2300:
2301: l_object_approval_id := wf_engine.getitemattrnumber (
2302: itemtype,
2303: itemkey,
2304: 'APPROVALID'
2305: );

Line 2307: l_notifname := wf_engine.getitemattrtext (

2303: itemkey,
2304: 'APPROVALID'
2305: );
2306:
2307: l_notifname := wf_engine.getitemattrtext (
2308: itemtype,
2309: itemkey,
2310: 'MESSAGE'
2311: );

Line 3753: l_message := wf_engine.getitemattrtext (

3749: END IF;
3750:
3751: IF funcmode = 'RUN'
3752: THEN
3753: l_message := wf_engine.getitemattrtext (
3754: itemtype,
3755: itemkey,
3756: 'MESSAGE'
3757: );

Line 3788: wf_engine.setitemattrtext (

3784: END IF;
3785: l_message := 'OA_REQUEST_CANCELLED_FYI';
3786: END IF;
3787:
3788: wf_engine.setitemattrtext (
3789: itemtype => itemtype,
3790: itemkey => itemkey,
3791: aname => 'MESSAGE',
3792: avalue => l_message

Line 3796: l_notifname := wf_engine.getitemattrtext (

3792: avalue => l_message
3793: );
3794: -- Please note that the notification event name is same as message name
3795:
3796: l_notifname := wf_engine.getitemattrtext (
3797: itemtype,
3798: itemkey,
3799: 'MESSAGE'
3800: );

Line 3816: l_approval_id := wf_engine.getitemattrnumber (

3812:
3813: IF l_notifenabled = 'Y'
3814: THEN
3815: -- Get the approval id
3816: l_approval_id := wf_engine.getitemattrnumber (
3817: itemtype,
3818: itemkey,
3819: 'APPROVALID'
3820: );

Line 3834: l_orgid := wf_engine.getitemattrnumber (

3830: l_approval_id
3831: );
3832: FETCH get_org_id INTO l_orgid;
3833: CLOSE get_org_id; */
3834: l_orgid := wf_engine.getitemattrnumber (
3835: itemtype,
3836: itemkey,
3837: 'ORGID'
3838: );

Line 4016: l_approval_id := wf_engine.getitemattrnumber (

4012: document_id,
4013: ':'
4014: ) + 1
4015: ) || 'HED';
4016: l_approval_id := wf_engine.getitemattrnumber (
4017: itemtype => itemtype,
4018: itemkey => itemkey,
4019: aname => 'APPROVALID'
4020: );

Line 4306: l_approval_id := wf_engine.getitemattrnumber (

4302: document_id,
4303: ':'
4304: ) + 1
4305: ) || 'HED';
4306: l_approval_id := wf_engine.getitemattrnumber (
4307: itemtype => itemtype,
4308: itemkey => itemkey,
4309: aname => 'APPROVALID'
4310: );

Line 4646: l_approval_id := wf_engine.getitemattrnumber (

4642: document_id,
4643: ':'
4644: ) + 1
4645: ) || 'HED';
4646: l_approval_id := wf_engine.getitemattrnumber (
4647: itemtype => itemtype,
4648: itemkey => itemkey,
4649: aname => 'APPROVALID'
4650: );

Line 4828: l_approval_id := wf_engine.getitemattrnumber (

4824: document_id,
4825: ':'
4826: ) + 1
4827: ) || 'HED';
4828: l_approval_id := wf_engine.getitemattrnumber (
4829: itemtype => itemtype,
4830: itemkey => itemkey,
4831: aname => 'APPROVALID'
4832: );

Line 5097: l_approval_id := wf_engine.getitemattrnumber (

5093: document_id,
5094: ':'
5095: ) + 1
5096: ) || 'HED';
5097: l_approval_id := wf_engine.getitemattrnumber (
5098: itemtype => itemtype,
5099: itemkey => itemkey,
5100: aname => 'APPROVALID'
5101: );

Line 5471: l_approval_id := wf_engine.getitemattrnumber (

5467: END IF;
5468:
5469: IF funcmode = 'RUN'
5470: THEN
5471: l_approval_id := wf_engine.getitemattrnumber (
5472: itemtype,
5473: itemkey,
5474: 'APPROVALID'
5475: );

Line 5491: wf_engine.setitemattrtext (

5487: 1,
5488: 'N'
5489: );
5490: END IF;
5491: wf_engine.setitemattrtext (
5492: itemtype => itemtype,
5493: itemkey => itemkey,
5494: aname => 'APPROVAL_OBJECT',
5495: avalue => l_approval_object

Line 5498: wf_engine.setitemattrnumber (

5494: aname => 'APPROVAL_OBJECT',
5495: avalue => l_approval_object
5496: );
5497:
5498: wf_engine.setitemattrnumber (
5499: itemtype => itemtype,
5500: itemkey => itemkey,
5501: aname => 'ORGID',
5502: avalue => l_org_id

Line 5505: wf_engine.setitemattrnumber (

5501: aname => 'ORGID',
5502: avalue => l_org_id
5503: );
5504:
5505: wf_engine.setitemattrnumber (
5506: itemtype => itemtype,
5507: itemkey => itemkey,
5508: aname => 'QTEHDRID',
5509: avalue => i.quote_header_id

Line 5512: wf_engine.setitemattrnumber (

5508: aname => 'QTEHDRID',
5509: avalue => i.quote_header_id
5510: );
5511:
5512: wf_engine.setitemattrnumber (
5513: itemtype => itemtype,
5514: itemkey => itemkey,
5515: aname => 'QTENUMBER',
5516: avalue => i.quote_number

Line 5538: wf_engine.setitemattrtext (

5534: aso_debug_pub.ADD ('l_url: '||substr(l_url,1,240),1,'N');
5535: END IF;
5536:
5537:
5538: wf_engine.setitemattrtext (
5539: itemtype => itemtype,
5540: itemkey => itemkey,
5541: aname => 'OAQTEDETAILLNK',
5542: avalue => l_url