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

Line 33: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

29: BEGIN
30:
31: IF (funcmode = 'RUN') THEN
32:
33: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
34: itemkey => itemkey,
35: aname => 'TRANSACTION_ID');
36:
37: OPEN okl_check_req_csr(l_art_id);

Line 111: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

107: BEGIN
108:
109: IF (funcmode = 'RUN') THEN
110:
111: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'TRANSACTION_ID');
114:
115: OPEN okl_check_req_csr(l_art_id);

Line 219: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

215: --Bug # 6174484 ssdeshpa Fixed for SQL Performance End
216: l_asset_return okl_asset_return_csr%rowtype;
217:
218: BEGIN
219: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'TRANSACTION_ID');
222:
223: OPEN okl_asset_return_csr(l_art_id);

Line 236: wf_engine.SetItemAttrText ( itemtype=> itemtype,

232: , p_user_id => l_asset_return.last_updated_by
233: , x_name => l_user
234: , x_description => l_name);
235:
236: wf_engine.SetItemAttrText ( itemtype=> itemtype,
237: itemkey => itemkey,
238: aname => 'REQUESTER',
239: avalue => l_user);
240:

Line 241: wf_engine.SetItemAttrText ( itemtype=> itemtype,

237: itemkey => itemkey,
238: aname => 'REQUESTER',
239: avalue => l_user);
240:
241: wf_engine.SetItemAttrText ( itemtype=> itemtype,
242: itemkey => itemkey,
243: aname => 'KHR_ID',
244: avalue => to_char(l_asset_return.CHR_ID));
245:

Line 246: wf_engine.SetItemAttrText ( itemtype=> itemtype,

242: itemkey => itemkey,
243: aname => 'KHR_ID',
244: avalue => to_char(l_asset_return.CHR_ID));
245:
246: wf_engine.SetItemAttrText ( itemtype=> itemtype,
247: itemkey => itemkey,
248: aname => 'CONTRACT_NUMBER',
249: avalue => l_asset_return.CONTRACT_NUMBER);
250:

Line 251: wf_engine.SetItemAttrText ( itemtype=> itemtype,

247: itemkey => itemkey,
248: aname => 'CONTRACT_NUMBER',
249: avalue => l_asset_return.CONTRACT_NUMBER);
250:
251: wf_engine.SetItemAttrText ( itemtype=> itemtype,
252: itemkey => itemkey,
253: aname => 'ASSET_NUMBER',
254: avalue => l_asset_return.ASSET_NUMBER);
255:

Line 256: wf_engine.SetItemAttrText ( itemtype=> itemtype,

252: itemkey => itemkey,
253: aname => 'ASSET_NUMBER',
254: avalue => l_asset_return.ASSET_NUMBER);
255:
256: wf_engine.SetItemAttrText ( itemtype=> itemtype,
257: itemkey => itemkey,
258: aname => 'DATE_RETURNED',
259: avalue => to_char(l_asset_return.DATE_RETURNED));
260:

Line 261: wf_engine.SetItemAttrText ( itemtype=> itemtype,

257: itemkey => itemkey,
258: aname => 'DATE_RETURNED',
259: avalue => to_char(l_asset_return.DATE_RETURNED));
260:
261: wf_engine.SetItemAttrText ( itemtype=> itemtype,
262: itemkey => itemkey,
263: aname => 'KLE_ID',
264: avalue => to_char(l_asset_return.KLE_ID));
265:

Line 266: wf_engine.SetItemAttrText ( itemtype=> itemtype,

262: itemkey => itemkey,
263: aname => 'KLE_ID',
264: avalue => to_char(l_asset_return.KLE_ID));
265:
266: wf_engine.SetItemAttrText ( itemtype=> itemtype,
267: itemkey => itemkey,
268: aname => 'CREATED_BY',
269: avalue => to_char(l_asset_return.last_updated_by));
270:

Line 271: wf_engine.SetItemAttrText ( itemtype=> itemtype,

267: itemkey => itemkey,
268: aname => 'CREATED_BY',
269: avalue => to_char(l_asset_return.last_updated_by));
270:
271: wf_engine.SetItemAttrText ( itemtype=> itemtype,
272: itemkey => itemkey,
273: aname => 'ASSET_DESCRIPTION',
274: avalue => l_asset_return.asset_description);
275:

Line 276: wf_engine.SetItemAttrText ( itemtype=> itemtype,

272: itemkey => itemkey,
273: aname => 'ASSET_DESCRIPTION',
274: avalue => l_asset_return.asset_description);
275:
276: wf_engine.SetItemAttrText ( itemtype=> itemtype,
277: itemkey => itemkey,
278: aname => 'COMMENTS',
279: avalue => l_asset_return.comments);
280:

Line 281: wf_engine.SetItemAttrText ( itemtype=> itemtype,

277: itemkey => itemkey,
278: aname => 'COMMENTS',
279: avalue => l_asset_return.comments);
280:
281: wf_engine.SetItemAttrText ( itemtype=> itemtype,
282: itemkey => itemkey,
283: aname => 'SERIAL_NUMBER',
284: avalue => l_asset_return.serial_number);
285:

Line 286: wf_engine.SetItemAttrText ( itemtype=> itemtype,

282: itemkey => itemkey,
283: aname => 'SERIAL_NUMBER',
284: avalue => l_asset_return.serial_number);
285:
286: wf_engine.SetItemAttrText ( itemtype=> itemtype,
287: itemkey => itemkey,
288: aname => 'MODEL_NUMBER',
289: avalue => l_asset_return.model_number);
290:

Line 291: wf_engine.SetItemAttrText ( itemtype=> itemtype,

287: itemkey => itemkey,
288: aname => 'MODEL_NUMBER',
289: avalue => l_asset_return.model_number);
290:
291: wf_engine.SetItemAttrText ( itemtype=> itemtype,
292: itemkey => itemkey,
293: aname => 'DISPLAY_NAME',
294: avalue => l_name);
295: EXCEPTION

Line 382: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

378: l_to_email VARCHAR2(100);
379:
380:
381: BEGIN
382: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
383: itemkey => itemkey,
384: aname => 'TRANSACTION_ID');
385:
386: OPEN okl_asset_return_csr(l_art_id);

Line 403: wf_engine.SetItemAttrText ( itemtype=> itemtype,

399: , p_user_id => l_asset_return.last_updated_by
400: , x_name => l_user
401: , x_description => l_name);
402:
403: wf_engine.SetItemAttrText ( itemtype=> itemtype,
404: itemkey => itemkey,
405: aname => 'REQUESTER',
406: avalue => l_user);
407:

Line 408: wf_engine.SetItemAttrText ( itemtype=> itemtype,

404: itemkey => itemkey,
405: aname => 'REQUESTER',
406: avalue => l_user);
407:
408: wf_engine.SetItemAttrText ( itemtype=> itemtype,
409: itemkey => itemkey,
410: aname => 'CONTRACT_NUMBER',
411: avalue => l_asset_return.CONTRACT_NUMBER);
412:

Line 413: wf_engine.SetItemAttrText ( itemtype=> itemtype,

409: itemkey => itemkey,
410: aname => 'CONTRACT_NUMBER',
411: avalue => l_asset_return.CONTRACT_NUMBER);
412:
413: wf_engine.SetItemAttrText ( itemtype=> itemtype,
414: itemkey => itemkey,
415: aname => 'ASSET_NUMBER',
416: avalue => l_asset_return.ASSET_NUMBER);
417:

Line 418: wf_engine.SetItemAttrText ( itemtype=> itemtype,

414: itemkey => itemkey,
415: aname => 'ASSET_NUMBER',
416: avalue => l_asset_return.ASSET_NUMBER);
417:
418: wf_engine.SetItemAttrText ( itemtype=> itemtype,
419: itemkey => itemkey,
420: aname => 'DATE_RETURNED',
421: avalue => to_char(l_asset_return.DATE_RETURNED));
422:

Line 423: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

419: itemkey => itemkey,
420: aname => 'DATE_RETURNED',
421: avalue => to_char(l_asset_return.DATE_RETURNED));
422:
423: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
424: itemkey => itemkey,
425: aname => 'CREATED_BY',
426: avalue => to_char(l_asset_return.LAST_UPDATED_BY));
427:

Line 430: wf_engine.SetItemAttrText ( itemtype=> itemtype,

426: avalue => to_char(l_asset_return.LAST_UPDATED_BY));
427:
428: -- Item Attributes for Fulfillment
429:
430: wf_engine.SetItemAttrText ( itemtype=> itemtype,
431: itemkey => itemkey,
432: aname => 'PROCESS_CODE',
433: avalue => 'AMNRA');
434:

Line 435: wf_engine.SetItemAttrText ( itemtype=> itemtype,

431: itemkey => itemkey,
432: aname => 'PROCESS_CODE',
433: avalue => 'AMNRA');
434:
435: wf_engine.SetItemAttrText ( itemtype=> itemtype,
436: itemkey => itemkey,
437: aname => 'TRANSACTION_ID',
438: avalue => l_art_id);
439: --12/20/06 rkuttiya changed recipient type to VENDOR, for XMLP Project

Line 440: /*wf_engine.SetItemAttrText ( itemtype=> itemtype,

436: itemkey => itemkey,
437: aname => 'TRANSACTION_ID',
438: avalue => l_art_id);
439: --12/20/06 rkuttiya changed recipient type to VENDOR, for XMLP Project
440: /*wf_engine.SetItemAttrText ( itemtype=> itemtype,
441: itemkey => itemkey,
442: aname => 'RECIPIENT_TYPE',
443: avalue => 'V'); */
444:

Line 445: wf_engine.SetItemAttrText ( itemtype=> itemtype,

441: itemkey => itemkey,
442: aname => 'RECIPIENT_TYPE',
443: avalue => 'V'); */
444:
445: wf_engine.SetItemAttrText ( itemtype=> itemtype,
446: itemkey => itemkey,
447: aname => 'RECIPIENT_TYPE',
448: avalue => 'VENDOR');
449:

Line 450: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

446: itemkey => itemkey,
447: aname => 'RECIPIENT_TYPE',
448: avalue => 'VENDOR');
449:
450: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
451: itemkey => itemkey,
452: aname => 'RECIPIENT_ID',
453: avalue => to_char(l_asset_return.AGENT_ID));
454:

Line 455: wf_engine.SetItemAttrText ( itemtype=> itemtype,

451: itemkey => itemkey,
452: aname => 'RECIPIENT_ID',
453: avalue => to_char(l_asset_return.AGENT_ID));
454:
455: wf_engine.SetItemAttrText ( itemtype=> itemtype,
456: itemkey => itemkey,
457: aname => 'RECIPIENT_DESCRIPTION',
458: avalue => l_vendor.NAME);
459:

Line 466: wf_engine.SetItemAttrText ( itemtype=> itemtype,

462: OPEN c_recipient(l_asset_return.agent_id);
463: FETCH c_recipient INTO l_to_email;
464: CLOSE c_recipient;
465:
466: wf_engine.SetItemAttrText ( itemtype=> itemtype,
467: itemkey => itemkey,
468: aname => 'EMAIL_ADDRESS',
469: avalue => l_to_email);
470:

Line 475: wf_engine.SetItemAttrText ( itemtype=> itemtype,

471: OPEN c_agent_csr(l_asset_return.last_updated_by);
472: FETCH c_agent_csr into l_from_email;
473: CLOSE c_agent_csr;
474:
475: wf_engine.SetItemAttrText ( itemtype=> itemtype,
476: itemkey => itemkey,
477: aname => 'FROM_ADDRESS',
478: avalue => l_from_email);
479:

Line 507: wf_engine.SetItemAttrText ( itemtype=> itemtype,

503:
504:
505: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
506: l_batch_id := lx_xmp_rec.batch_id;
507: wf_engine.SetItemAttrText ( itemtype=> itemtype,
508: itemkey => itemkey,
509: aname => 'BATCH_ID',
510: avalue => l_batch_id );
511: resultout := 'COMPLETE:SUCCESS';

Line 609: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

605: AND re.user_name = wu.name; -- mdokal : Bug 3562321
606:
607: BEGIN
608:
609: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
610: itemkey => itemkey,
611: aname => 'TRANSACTION_ID');
612:
613: OPEN okl_asset_return_csr(l_art_id);

Line 628: wf_engine.SetItemAttrText ( itemtype=> itemtype,

624: OPEN wf_users_csr(l_asset_return.RMR_ID);
625: FETCH wf_users_csr INTO l_user;
626: CLOSE wf_users_csr;
627:
628: wf_engine.SetItemAttrText ( itemtype=> itemtype,
629: itemkey => itemkey,
630: aname => 'TOTAL_RECIPIENTS',
631: avalue => l_user);
632:

Line 633: wf_engine.SetItemAttrText ( itemtype=> itemtype,

629: itemkey => itemkey,
630: aname => 'TOTAL_RECIPIENTS',
631: avalue => l_user);
632:
633: wf_engine.SetItemAttrText ( itemtype=> itemtype,
634: itemkey => itemkey,
635: aname => 'CURRENT_RECIPIENT',
636: avalue => l_user+1);
637:

Line 638: wf_engine.SetItemAttrText ( itemtype=> itemtype,

634: itemkey => itemkey,
635: aname => 'CURRENT_RECIPIENT',
636: avalue => l_user+1);
637:
638: wf_engine.SetItemAttrText ( itemtype=> itemtype,
639: itemkey => itemkey,
640: aname => 'CONTRACT_NUMBER',
641: avalue => l_asset_detail.CONTRACT_NUMBER); --bug 5253787
642:

Line 643: wf_engine.SetItemAttrText ( itemtype=> itemtype,

639: itemkey => itemkey,
640: aname => 'CONTRACT_NUMBER',
641: avalue => l_asset_detail.CONTRACT_NUMBER); --bug 5253787
642:
643: wf_engine.SetItemAttrText ( itemtype=> itemtype,
644: itemkey => itemkey,
645: aname => 'ASSET_NUMBER',
646: avalue => l_asset_detail.ASSET_NUMBER); --bug 5253787
647:

Line 648: wf_engine.SetItemAttrText ( itemtype=> itemtype,

644: itemkey => itemkey,
645: aname => 'ASSET_NUMBER',
646: avalue => l_asset_detail.ASSET_NUMBER); --bug 5253787
647:
648: wf_engine.SetItemAttrText ( itemtype=> itemtype,
649: itemkey => itemkey,
650: aname => 'DATE_RETURNED',
651: avalue => to_char(l_asset_return.DATE_RETURNED));
652:

Line 653: wf_engine.SetItemAttrText ( itemtype=> itemtype,

649: itemkey => itemkey,
650: aname => 'DATE_RETURNED',
651: avalue => to_char(l_asset_return.DATE_RETURNED));
652:
653: wf_engine.SetItemAttrText ( itemtype=> itemtype,
654: itemkey => itemkey,
655: aname => 'CREATED_BY',
656: avalue => to_char(l_asset_return.LAST_UPDATED_BY));
657:

Line 658: wf_engine.SetItemAttrText ( itemtype=> itemtype,

654: itemkey => itemkey,
655: aname => 'CREATED_BY',
656: avalue => to_char(l_asset_return.LAST_UPDATED_BY));
657:
658: wf_engine.SetItemAttrText ( itemtype=> itemtype,
659: itemkey => itemkey,
660: aname => 'REMARKETER_ID',
661: avalue => to_char(l_asset_return.RMR_ID));
662:

Line 663: wf_engine.SetItemAttrText ( itemtype=> itemtype,

659: itemkey => itemkey,
660: aname => 'REMARKETER_ID',
661: avalue => to_char(l_asset_return.RMR_ID));
662:
663: wf_engine.SetItemAttrText ( itemtype=> itemtype,
664: itemkey => itemkey,
665: aname => 'ASSET_DESCRIPTION',
666: avalue => l_asset_detail.asset_description); --bug 5253787
667:

Line 668: wf_engine.SetItemAttrText ( itemtype=> itemtype,

664: itemkey => itemkey,
665: aname => 'ASSET_DESCRIPTION',
666: avalue => l_asset_detail.asset_description); --bug 5253787
667:
668: wf_engine.SetItemAttrText ( itemtype=> itemtype,
669: itemkey => itemkey,
670: aname => 'MODEL_NUMBER',
671: avalue => l_asset_detail.model_number); --bug 5253787
672:

Line 673: wf_engine.SetItemAttrText ( itemtype=> itemtype,

669: itemkey => itemkey,
670: aname => 'MODEL_NUMBER',
671: avalue => l_asset_detail.model_number); --bug 5253787
672:
673: wf_engine.SetItemAttrText ( itemtype=> itemtype,
674: itemkey => itemkey,
675: aname => 'SERIAL_NUMBER',
676: avalue => l_asset_detail.serial_number); --bug 5253787
677:

Line 804: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

800: BEGIN
801:
802: IF (funcmode = 'RUN') THEN
803:
804: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'REMARKETER_ID');
807:
808: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 808: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

804: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'REMARKETER_ID');
807:
808: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
809: itemkey => itemkey,
810: aname => 'TOTAL_RECIPIENTS');
811:
812: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 812: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

808: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
809: itemkey => itemkey,
810: aname => 'TOTAL_RECIPIENTS');
811:
812: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'CURRENT_RECIPIENT');
815:
816: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 816: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

812: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'CURRENT_RECIPIENT');
815:
816: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'PERFORMING_AGENT');
819:
820:

Line 825: wf_engine.SetItemAttrText ( itemtype=> itemtype,

821: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
822: FETCH wf_users_csr INTO l_user, l_name ;
823: CLOSE wf_users_csr;
824:
825: wf_engine.SetItemAttrText ( itemtype=> itemtype,
826: itemkey => itemkey,
827: aname => 'PERFORMING_AGENT',
828: avalue => l_user);
829:

Line 830: wf_engine.SetItemAttrText ( itemtype=> itemtype,

826: itemkey => itemkey,
827: aname => 'PERFORMING_AGENT',
828: avalue => l_user);
829:
830: wf_engine.SetItemAttrText ( itemtype=> itemtype,
831: itemkey => itemkey,
832: aname => 'RECIPIENT_NAME',
833: avalue => l_name);
834:

Line 837: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

833: avalue => l_name);
834:
835: l_current_rec := l_current_rec-1;
836:
837: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
838: itemkey => itemkey,
839: aname => 'CURRENT_RECIPIENT',
840: avalue => l_current_rec);
841:

Line 914: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

910: BEGIN
911:
912: IF (funcmode = 'RUN') THEN
913:
914: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
915: itemkey => itemkey,
916: aname => 'TRANSACTION_ID');
917:
918: OPEN okl_check_req_csr(l_art_id);

Line 998: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

994: BEGIN
995:
996: IF (funcmode = 'RUN') THEN
997:
998: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'TRANSACTION_ID');
1001:
1002: OPEN okl_check_req_csr(l_art_id);

Line 1068: l_creator := wf_engine.GetItemAttrText( itemtype => itemtype,

1064: BEGIN
1065:
1066: IF (funcmode = 'RUN') THEN
1067:
1068: l_creator := wf_engine.GetItemAttrText( itemtype => itemtype,
1069: itemkey => itemkey,
1070: aname => 'CREATED_BY');
1071:
1072:

Line 1086: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1082: IF l_role IS NULL THEN
1083: resultout := 'COMPLETE:ROLE_NOT_FOUND';
1084: ELSE
1085:
1086: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1087: itemkey => itemkey,
1088: aname => 'REQUESTER',
1089: avalue => l_role);
1090:

Line 1189: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1185: BEGIN
1186:
1187: IF (funcmode = 'RUN') THEN
1188:
1189: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1190: itemkey => itemkey,
1191: aname => 'TRANSACTION_ID');
1192:
1193: OPEN okl_check_req_csr(l_art_id);

Line 1225: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

1221: x_object_tbl => l_object_tbl,
1222: x_return_status => l_return_status);
1223:
1224: -- Item Attributes for Fulfillment
1225: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1226: itemkey => itemkey,
1227: aname => 'CREATED_BY',
1228: avalue => l_art_rec.LAST_UPDATED_BY);
1229:

Line 1230: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1226: itemkey => itemkey,
1227: aname => 'CREATED_BY',
1228: avalue => l_art_rec.LAST_UPDATED_BY);
1229:
1230: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1231: itemkey => itemkey,
1232: aname => 'PROCESS_CODE',
1233: avalue => 'AMRTR');
1234:

Line 1236: /*wf_engine.SetItemAttrText ( itemtype=> itemtype,

1232: aname => 'PROCESS_CODE',
1233: avalue => 'AMRTR');
1234:
1235: --12/20/06 rkuttiya commented to change recipient type to LESSEE, for XMLP Project
1236: /*wf_engine.SetItemAttrText ( itemtype=> itemtype,
1237: itemkey => itemkey,
1238: aname => 'RECIPIENT_TYPE',
1239: avalue => 'P'); */
1240:

Line 1241: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1237: itemkey => itemkey,
1238: aname => 'RECIPIENT_TYPE',
1239: avalue => 'P'); */
1240:
1241: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1242: itemkey => itemkey,
1243: aname => 'RECIPIENT_TYPE',
1244: avalue => 'LESSEE');
1245:

Line 1246: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

1242: itemkey => itemkey,
1243: aname => 'RECIPIENT_TYPE',
1244: avalue => 'LESSEE');
1245:
1246: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1247: itemkey => itemkey,
1248: aname => 'RECIPIENT_ID',
1249: avalue => nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1250:

Line 1251: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1247: itemkey => itemkey,
1248: aname => 'RECIPIENT_ID',
1249: avalue => nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1250:
1251: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1252: itemkey => itemkey,
1253: aname => 'RECIPIENT_DESCRIPTION',
1254: avalue => l_object_tbl(1).name );
1255:

Line 1263: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1259: OPEN c_recipient(nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1260: FETCH c_recipient INTO l_to_email;
1261: CLOSE c_recipient;
1262:
1263: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1264: itemkey => itemkey,
1265: aname => 'EMAIL_ADDRESS', -- 20/07/2007 ansethur modified the Item attribute name
1266: avalue => l_to_email);
1267:

Line 1272: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1268: OPEN c_agent_csr(l_art_rec.last_updated_by);
1269: FETCH c_agent_csr into l_from_email;
1270: CLOSE c_agent_csr;
1271:
1272: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1273: itemkey => itemkey,
1274: aname => 'FROM_ADDRESS', -- 20/07/2007 ansethur modified the Item attribute name
1275: avalue => l_from_email);
1276:

Line 1302: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1298:
1299:
1300: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1301: l_batch_id := lx_xmp_rec.batch_id;
1302: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1303: itemkey => itemkey,
1304: aname => 'BATCH_ID',
1305: avalue => l_batch_id );
1306: resultout := 'COMPLETE:VALID'; -- 20/07/2007 ansethur modified the value passed

Line 1420: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1416: BEGIN
1417:
1418: IF (funcmode = 'RUN') THEN
1419:
1420: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1421: itemkey => itemkey,
1422: aname => 'TRANSACTION_ID');
1423:
1424: OPEN okl_check_req_csr(l_art_id);

Line 1448: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

1444: -- Check that a contact was returned for the TRANSACTION_ID given.
1445: IF l_csr_rec.pac_id IS NOT NULL THEN
1446: resultout := 'COMPLETE:VALID';
1447:
1448: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1449: itemkey => itemkey,
1450: aname => 'CREATED_BY',
1451: avalue => l_csr_rec.last_updated_by);
1452:

Line 1453: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1449: itemkey => itemkey,
1450: aname => 'CREATED_BY',
1451: avalue => l_csr_rec.last_updated_by);
1452:
1453: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1454: itemkey => itemkey,
1455: aname => 'REQUESTER',
1456: avalue => l_user_name);
1457:

Line 1459: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1455: aname => 'REQUESTER',
1456: avalue => l_user_name);
1457:
1458: -- Populate Item Attributes for Fulfillment
1459: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1460: itemkey => itemkey,
1461: aname => 'PROCESS_CODE',
1462: avalue => 'AMNSI');
1463: --12/18/06 modified recipient type to 'LESSEE' for XML Publisher, since this was originally Party Contact

Line 1465: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1461: aname => 'PROCESS_CODE',
1462: avalue => 'AMNSI');
1463: --12/18/06 modified recipient type to 'LESSEE' for XML Publisher, since this was originally Party Contact
1464: /*
1465: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1466: itemkey => itemkey,
1467: aname => 'RECIPIENT_TYPE',
1468: avalue => 'PC'); */
1469: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 1469: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1465: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1466: itemkey => itemkey,
1467: aname => 'RECIPIENT_TYPE',
1468: avalue => 'PC'); */
1469: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1470: itemkey => itemkey,
1471: aname => 'RECIPIENT_TYPE',
1472: avalue => 'LESSEE');
1473:

Line 1474: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1470: itemkey => itemkey,
1471: aname => 'RECIPIENT_TYPE',
1472: avalue => 'LESSEE');
1473:
1474: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1475: itemkey => itemkey,
1476: aname => 'RECIPIENT_ID',
1477: avalue => l_csr_rec.pac_id);
1478:

Line 1480: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1476: aname => 'RECIPIENT_ID',
1477: avalue => l_csr_rec.pac_id);
1478:
1479:
1480: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1481: itemkey => itemkey,
1482: aname => 'RECIPIENT_DESCRIPTION',
1483: avalue => l_csr_rec.contact_party_name);
1484: --12/18/06 rkuttiya modified for XMLP Project

Line 1494: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1490: OPEN c_agent_csr(l_csr_rec.last_updated_by);
1491: FETCH c_agent_csr into l_from_email;
1492: CLOSE c_agent_csr;
1493:
1494: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1495: itemkey => itemkey,
1496: aname => 'EMAIL_ADDRESS',
1497: avalue => l_to_email);
1498:

Line 1500: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1496: aname => 'EMAIL_ADDRESS',
1497: avalue => l_to_email);
1498:
1499:
1500: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1501: itemkey => itemkey,
1502: aname => 'FROM_ADDRESS',
1503: avalue => l_from_email);
1504:

Line 1528: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1524:
1525:
1526: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1527: l_batch_id := lx_xmp_rec.batch_id;
1528: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1529: itemkey => itemkey,
1530: aname => 'BATCH_ID',
1531: avalue => l_batch_id );
1532: resultout := 'COMPLETE:VALID'; -- rkuttiya changed

Line 1606: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1602: BEGIN
1603:
1604: IF (funcmode = 'RUN') THEN
1605:
1606: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'TRANSACTION_ID');
1609:
1610: -- vsgandhi 12959022 16-sept-2011

Line 1611: l_org_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1607: itemkey => itemkey,
1608: aname => 'TRANSACTION_ID');
1609:
1610: -- vsgandhi 12959022 16-sept-2011
1611: l_org_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1612: itemkey => itemkey,
1613: aname => 'ORG_ID');
1614:
1615:

Line 1706: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1702: BEGIN
1703:
1704: IF (funcmode = 'RUN') THEN
1705:
1706: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1707: itemkey => itemkey,
1708: aname => 'TRANSACTION_ID');
1709:
1710: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1710: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

1706: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1707: itemkey => itemkey,
1708: aname => 'TRANSACTION_ID');
1709:
1710: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'APPROVED_YN');
1713:
1714:

Line 1866: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1862: l_updated_by NUMBER;
1863:
1864: BEGIN
1865:
1866: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1867: itemkey => itemkey,
1868: aname => 'TRANSACTION_ID');
1869:
1870: --build message (temp)

Line 1911: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1907: , p_user_id => l_updated_by
1908: , x_name => l_user
1909: , x_description => l_name);
1910:
1911: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1912: itemkey => itemkey,
1913: aname => 'REQUESTER',
1914: avalue => l_user);
1915:

Line 1916: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1912: itemkey => itemkey,
1913: aname => 'REQUESTER',
1914: avalue => l_user);
1915:
1916: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1917: itemkey => itemkey,
1918: aname => 'WF_ADMINISTRATOR',
1919: avalue => l_user);
1920:

Line 1921: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1917: itemkey => itemkey,
1918: aname => 'WF_ADMINISTRATOR',
1919: avalue => l_user);
1920:
1921: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1922: itemkey => itemkey,
1923: aname => 'TRX_TYPE_ID',
1924: avalue => 'OKLAMAAR');
1925:

Line 1926: wf_engine.SetItemAttrText ( itemtype=> itemtype,

1922: itemkey => itemkey,
1923: aname => 'TRX_TYPE_ID',
1924: avalue => 'OKLAMAAR');
1925:
1926: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1927: itemkey => itemkey,
1928: aname => 'MESSAGE_DESCRIPTION',
1929: avalue => l_message);
1930: EXCEPTION

Line 1999: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1995:
1996: l_asset_return okl_asset_return_csr%rowtype;
1997:
1998: BEGIN
1999: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'TRANSACTION_ID');
2002:
2003: OPEN okl_asset_return_csr(l_art_id);

Line 2020: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2016: p_user_id => l_asset_return.last_updated_by,
2017: x_name => l_requester,
2018: x_description => l_name);
2019:
2020: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2021: itemkey => itemkey,
2022: aname => 'REQUESTER',
2023: avalue => l_requester);
2024:

Line 2025: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2021: itemkey => itemkey,
2022: aname => 'REQUESTER',
2023: avalue => l_requester);
2024:
2025: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2026: itemkey => itemkey,
2027: aname => 'PERFORMING_AGENT',
2028: avalue => l_performer);
2029: */

Line 2030: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2026: itemkey => itemkey,
2027: aname => 'PERFORMING_AGENT',
2028: avalue => l_performer);
2029: */
2030: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2031: itemkey => itemkey,
2032: aname => 'CONTACT_NAME',
2033: avalue => l_asset_return.CONTACT_NAME);
2034:

Line 2035: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2031: itemkey => itemkey,
2032: aname => 'CONTACT_NAME',
2033: avalue => l_asset_return.CONTACT_NAME);
2034:
2035: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2036: itemkey => itemkey,
2037: aname => 'CONTACT_METHOD',
2038: avalue => l_asset_return.CONTACT_DETAILS);
2039:

Line 2040: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2036: itemkey => itemkey,
2037: aname => 'CONTACT_METHOD',
2038: avalue => l_asset_return.CONTACT_DETAILS);
2039:
2040: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2041: itemkey => itemkey,
2042: aname => 'CONTRACT_NUMBER',
2043: avalue => l_asset_return.CONTRACT_NUMBER);
2044:

Line 2045: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2041: itemkey => itemkey,
2042: aname => 'CONTRACT_NUMBER',
2043: avalue => l_asset_return.CONTRACT_NUMBER);
2044:
2045: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2046: itemkey => itemkey,
2047: aname => 'ASSET_NUMBER',
2048: avalue => l_asset_return.ASSET_NUMBER);
2049:

Line 2050: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2046: itemkey => itemkey,
2047: aname => 'ASSET_NUMBER',
2048: avalue => l_asset_return.ASSET_NUMBER);
2049:
2050: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2051: itemkey => itemkey,
2052: aname => 'ASSET_DESCRIPTION',
2053: avalue => l_asset_return.asset_description);
2054:

Line 2055: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2051: itemkey => itemkey,
2052: aname => 'ASSET_DESCRIPTION',
2053: avalue => l_asset_return.asset_description);
2054:
2055: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2056: itemkey => itemkey,
2057: aname => 'DETAILS',
2058: avalue => l_asset_return.comments);
2059:

Line 2060: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2056: itemkey => itemkey,
2057: aname => 'DETAILS',
2058: avalue => l_asset_return.comments);
2059:
2060: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2061: itemkey => itemkey,
2062: aname => 'SERIAL_NUMBER',
2063: avalue => l_asset_return.serial_number);
2064:

Line 2065: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2061: itemkey => itemkey,
2062: aname => 'SERIAL_NUMBER',
2063: avalue => l_asset_return.serial_number);
2064:
2065: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2066: itemkey => itemkey,
2067: aname => 'MODEL_NUMBER',
2068: avalue => l_asset_return.model_number);
2069:

Line 2098: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2094:
2095: BEGIN
2096:
2097: IF (funcmode = 'RUN') THEN
2098: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2099: itemkey => itemkey,
2100: aname => 'TRANSACTION_ID');
2101:
2102:

Line 2176: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2172:
2173: BEGIN
2174:
2175: IF (funcmode = 'RUN') THEN
2176: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2177: itemkey => itemkey,
2178: aname => 'TRANSACTION_ID');
2179:
2180: --build message

Line 2217: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2213: IF l_header_done THEN
2214: l_message := l_message||'';
2215: END IF;
2216:
2217: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2218: itemkey => itemkey,
2219: aname => 'TRX_TYPE_ID',
2220: avalue => 'OKLAMATK');
2221:

Line 2222: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2218: itemkey => itemkey,
2219: aname => 'TRX_TYPE_ID',
2220: avalue => 'OKLAMATK');
2221:
2222: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2223: itemkey => itemkey,
2224: aname => 'MESSAGE_DESCRIPTION',
2225: avalue => l_message);
2226:

Line 2227: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2223: itemkey => itemkey,
2224: aname => 'MESSAGE_DESCRIPTION',
2225: avalue => l_message);
2226:
2227: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2228: itemkey => itemkey,
2229: aname => 'REQUESTER',
2230: avalue => l_user_name);
2231:

Line 2232: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2228: itemkey => itemkey,
2229: aname => 'REQUESTER',
2230: avalue => l_user_name);
2231:
2232: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2233: itemkey => itemkey,
2234: aname => 'WF_ADMINISTRATOR',
2235: avalue => l_user);
2236: resultout := 'COMPLETE:';

Line 2310: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2306:
2307: BEGIN
2308:
2309: IF (funcmode = 'RUN') THEN
2310: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2311: itemkey => itemkey,
2312: aname => 'TRANSACTION_ID');
2313:
2314: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 2314: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

2310: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2311: itemkey => itemkey,
2312: aname => 'TRANSACTION_ID');
2313:
2314: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
2315: itemkey => itemkey,
2316: aname => 'APPROVED_YN');
2317:
2318: IF upper(l_approved_yn) = 'Y' THEN

Line 2438: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2434:
2435: BEGIN
2436:
2437: IF (funcmode = 'RUN') THEN
2438: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2439: itemkey => itemkey,
2440: aname => 'TRANSACTION_ID');
2441:
2442: OPEN okl_pfc_csr(l_id);

Line 2450: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2446: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2447: FETCH wf_users_csr INTO l_user;
2448: CLOSE wf_users_csr;
2449:
2450: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2451: itemkey => itemkey,
2452: aname => 'TOTAL_RECIPIENTS',
2453: avalue => l_user);
2454:

Line 2455: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2451: itemkey => itemkey,
2452: aname => 'TOTAL_RECIPIENTS',
2453: avalue => l_user);
2454:
2455: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2456: itemkey => itemkey,
2457: aname => 'CURRENT_RECIPIENT',
2458: avalue => l_user+1);
2459:

Line 2460: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2456: itemkey => itemkey,
2457: aname => 'CURRENT_RECIPIENT',
2458: avalue => l_user+1);
2459:
2460: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2461: itemkey => itemkey,
2462: aname => 'CONTRACT_NUMBER',
2463: avalue => l_pfc_rec.CONTRACT_NUMBER);
2464:

Line 2465: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2461: itemkey => itemkey,
2462: aname => 'CONTRACT_NUMBER',
2463: avalue => l_pfc_rec.CONTRACT_NUMBER);
2464:
2465: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2466: itemkey => itemkey,
2467: aname => 'STRATEGY',
2468: avalue => l_pfc_rec.STRATEGY);
2469:

Line 2470: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2466: itemkey => itemkey,
2467: aname => 'STRATEGY',
2468: avalue => l_pfc_rec.STRATEGY);
2469:
2470: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2471: itemkey => itemkey,
2472: aname => 'ASSIGNMENT_GROUP_ID',
2473: avalue => to_char(l_pfc_rec.TMB_ID));
2474:

Line 2475: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2471: itemkey => itemkey,
2472: aname => 'ASSIGNMENT_GROUP_ID',
2473: avalue => to_char(l_pfc_rec.TMB_ID));
2474:
2475: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2476: itemkey => itemkey,
2477: aname => 'BUDGET',
2478: avalue => l_pfc_rec.BUDGET);
2479:

Line 2480: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2476: itemkey => itemkey,
2477: aname => 'BUDGET',
2478: avalue => l_pfc_rec.BUDGET);
2479:
2480: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2481: itemkey => itemkey,
2482: aname => 'EXECUTION_DATE',
2483: avalue => l_pfc_rec.EXECUTION_DATE);
2484:

Line 2493: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2489: ,p_user_id => l_pfc_rec.last_updated_by
2490: ,x_name => l_user_name
2491: ,x_description => l_name);
2492:
2493: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2494: itemkey => itemkey,
2495: aname => 'REQUESTER',
2496: avalue => l_user_name);
2497:

Line 2596: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2592: BEGIN
2593:
2594: IF (funcmode = 'RUN') THEN
2595:
2596: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2597: itemkey => itemkey,
2598: aname => 'ASSIGNMENT_GROUP_ID');
2599:
2600: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2600: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2596: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2597: itemkey => itemkey,
2598: aname => 'ASSIGNMENT_GROUP_ID');
2599:
2600: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2601: itemkey => itemkey,
2602: aname => 'TOTAL_RECIPIENTS');
2603:
2604: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2604: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2600: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2601: itemkey => itemkey,
2602: aname => 'TOTAL_RECIPIENTS');
2603:
2604: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2605: itemkey => itemkey,
2606: aname => 'CURRENT_RECIPIENT');
2607:
2608: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 2608: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

2604: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2605: itemkey => itemkey,
2606: aname => 'CURRENT_RECIPIENT');
2607:
2608: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,
2609: itemkey => itemkey,
2610: aname => 'PERFORMING_AGENT');
2611:
2612:

Line 2617: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2613: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2614: FETCH wf_users_csr INTO l_user, l_name ;
2615: CLOSE wf_users_csr;
2616:
2617: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2618: itemkey => itemkey,
2619: aname => 'PERFORMING_AGENT',
2620: avalue => l_user);
2621:

Line 2622: wf_engine.SetItemAttrText ( itemtype=> itemtype,

2618: itemkey => itemkey,
2619: aname => 'PERFORMING_AGENT',
2620: avalue => l_user);
2621:
2622: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2623: itemkey => itemkey,
2624: aname => 'RECIPIENT_NAME',
2625: avalue => l_name);
2626:

Line 2629: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,

2625: avalue => l_name);
2626:
2627: l_current_rec := l_current_rec-1;
2628:
2629: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
2630: itemkey => itemkey,
2631: aname => 'CURRENT_RECIPIENT',
2632: avalue => l_current_rec);
2633:

Line 2705: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2701: BEGIN
2702:
2703: IF (funcmode = 'RUN') THEN
2704:
2705: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2706: itemkey => itemkey,
2707: aname => 'TRANSACTION_ID');
2708:
2709: OPEN okl_check_req_csr(l_art_id);

Line 2723: wf_engine.SetItemAttrText( itemtype => itemtype,

2719: x_name => l_requester,
2720: x_description => l_description);
2721:
2722:
2723: wf_engine.SetItemAttrText( itemtype => itemtype,
2724: itemkey => itemkey,
2725: aname => 'REQUESTER',
2726: avalue => l_requester);
2727:

Line 2728: wf_engine.SetItemAttrText( itemtype => itemtype,

2724: itemkey => itemkey,
2725: aname => 'REQUESTER',
2726: avalue => l_requester);
2727:
2728: wf_engine.SetItemAttrText( itemtype => itemtype,
2729: itemkey => itemkey,
2730: aname => 'WF_ADMINISTRATOR',
2731: avalue => l_requester);
2732:

Line 2802: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2798:
2799: BEGIN
2800:
2801: IF (funcmode = 'RUN') THEN
2802: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2803: itemkey => itemkey,
2804: aname => 'TRANSACTION_ID');
2805:
2806: -- Get the notification recipient from profile.

Line 2809: wf_engine.SetItemAttrText( itemtype => itemtype,

2805:
2806: -- Get the notification recipient from profile.
2807: l_performer := fnd_profile.value('OKL_TRANSPORTATION_NOTIFICATION');
2808:
2809: wf_engine.SetItemAttrText( itemtype => itemtype,
2810: itemkey => itemkey,
2811: aname => 'PERFORMING_AGENT',
2812: avalue => l_performer);
2813: