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 759: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

755: BEGIN
756:
757: IF (funcmode = 'RUN') THEN
758:
759: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'REMARKETER_ID');
762:
763: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

759: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'REMARKETER_ID');
762:
763: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
764: itemkey => itemkey,
765: aname => 'TOTAL_RECIPIENTS');
766:
767: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

763: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
764: itemkey => itemkey,
765: aname => 'TOTAL_RECIPIENTS');
766:
767: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
768: itemkey => itemkey,
769: aname => 'CURRENT_RECIPIENT');
770:
771: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

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

767: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
768: itemkey => itemkey,
769: aname => 'CURRENT_RECIPIENT');
770:
771: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'PERFORMING_AGENT');
774:
775:

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

776: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
777: FETCH wf_users_csr INTO l_user, l_name ;
778: CLOSE wf_users_csr;
779:
780: wf_engine.SetItemAttrText ( itemtype=> itemtype,
781: itemkey => itemkey,
782: aname => 'PERFORMING_AGENT',
783: avalue => l_user);
784:

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

781: itemkey => itemkey,
782: aname => 'PERFORMING_AGENT',
783: avalue => l_user);
784:
785: wf_engine.SetItemAttrText ( itemtype=> itemtype,
786: itemkey => itemkey,
787: aname => 'RECIPIENT_NAME',
788: avalue => l_name);
789:

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

788: avalue => l_name);
789:
790: l_current_rec := l_current_rec-1;
791:
792: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
793: itemkey => itemkey,
794: aname => 'CURRENT_RECIPIENT',
795: avalue => l_current_rec);
796:

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

865: BEGIN
866:
867: IF (funcmode = 'RUN') THEN
868:
869: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
870: itemkey => itemkey,
871: aname => 'TRANSACTION_ID');
872:
873: OPEN okl_check_req_csr(l_art_id);

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

949: BEGIN
950:
951: IF (funcmode = 'RUN') THEN
952:
953: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
954: itemkey => itemkey,
955: aname => 'TRANSACTION_ID');
956:
957: OPEN okl_check_req_csr(l_art_id);

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

1019: BEGIN
1020:
1021: IF (funcmode = 'RUN') THEN
1022:
1023: l_creator := wf_engine.GetItemAttrText( itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => 'CREATED_BY');
1026:
1027:

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

1037: IF l_role IS NULL THEN
1038: resultout := 'COMPLETE:ROLE_NOT_FOUND';
1039: ELSE
1040:
1041: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1042: itemkey => itemkey,
1043: aname => 'REQUESTER',
1044: avalue => l_role);
1045:

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

1140: BEGIN
1141:
1142: IF (funcmode = 'RUN') THEN
1143:
1144: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1145: itemkey => itemkey,
1146: aname => 'TRANSACTION_ID');
1147:
1148: OPEN okl_check_req_csr(l_art_id);

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

1176: x_object_tbl => l_object_tbl,
1177: x_return_status => l_return_status);
1178:
1179: -- Item Attributes for Fulfillment
1180: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1181: itemkey => itemkey,
1182: aname => 'CREATED_BY',
1183: avalue => l_art_rec.LAST_UPDATED_BY);
1184:

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

1181: itemkey => itemkey,
1182: aname => 'CREATED_BY',
1183: avalue => l_art_rec.LAST_UPDATED_BY);
1184:
1185: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1186: itemkey => itemkey,
1187: aname => 'PROCESS_CODE',
1188: avalue => 'AMRTR');
1189:

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

1187: aname => 'PROCESS_CODE',
1188: avalue => 'AMRTR');
1189:
1190: --12/20/06 rkuttiya commented to change recipient type to LESSEE, for XMLP Project
1191: /*wf_engine.SetItemAttrText ( itemtype=> itemtype,
1192: itemkey => itemkey,
1193: aname => 'RECIPIENT_TYPE',
1194: avalue => 'P'); */
1195:

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

1192: itemkey => itemkey,
1193: aname => 'RECIPIENT_TYPE',
1194: avalue => 'P'); */
1195:
1196: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1197: itemkey => itemkey,
1198: aname => 'RECIPIENT_TYPE',
1199: avalue => 'LESSEE');
1200:

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

1197: itemkey => itemkey,
1198: aname => 'RECIPIENT_TYPE',
1199: avalue => 'LESSEE');
1200:
1201: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1202: itemkey => itemkey,
1203: aname => 'RECIPIENT_ID',
1204: avalue => nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1205:

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

1202: itemkey => itemkey,
1203: aname => 'RECIPIENT_ID',
1204: avalue => nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1205:
1206: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1207: itemkey => itemkey,
1208: aname => 'RECIPIENT_DESCRIPTION',
1209: avalue => l_object_tbl(1).name );
1210:

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

1214: OPEN c_recipient(nvl(l_rule_rec.object2_id1, l_rule_rec.object1_id1));
1215: FETCH c_recipient INTO l_to_email;
1216: CLOSE c_recipient;
1217:
1218: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1219: itemkey => itemkey,
1220: aname => 'EMAIL_ADDRESS', -- 20/07/2007 ansethur modified the Item attribute name
1221: avalue => l_to_email);
1222:

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

1223: OPEN c_agent_csr(l_art_rec.last_updated_by);
1224: FETCH c_agent_csr into l_from_email;
1225: CLOSE c_agent_csr;
1226:
1227: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1228: itemkey => itemkey,
1229: aname => 'FROM_ADDRESS', -- 20/07/2007 ansethur modified the Item attribute name
1230: avalue => l_from_email);
1231:

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

1253:
1254:
1255: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1256: l_batch_id := lx_xmp_rec.batch_id;
1257: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1258: itemkey => itemkey,
1259: aname => 'BATCH_ID',
1260: avalue => l_batch_id );
1261: resultout := 'COMPLETE:VALID'; -- 20/07/2007 ansethur modified the value passed

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

1371: BEGIN
1372:
1373: IF (funcmode = 'RUN') THEN
1374:
1375: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1376: itemkey => itemkey,
1377: aname => 'TRANSACTION_ID');
1378:
1379: OPEN okl_check_req_csr(l_art_id);

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

1399: -- Check that a contact was returned for the TRANSACTION_ID given.
1400: IF l_csr_rec.pac_id IS NOT NULL THEN
1401: resultout := 'COMPLETE:VALID';
1402:
1403: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
1404: itemkey => itemkey,
1405: aname => 'CREATED_BY',
1406: avalue => l_csr_rec.last_updated_by);
1407:

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

1404: itemkey => itemkey,
1405: aname => 'CREATED_BY',
1406: avalue => l_csr_rec.last_updated_by);
1407:
1408: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1409: itemkey => itemkey,
1410: aname => 'REQUESTER',
1411: avalue => l_user_name);
1412:

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

1410: aname => 'REQUESTER',
1411: avalue => l_user_name);
1412:
1413: -- Populate Item Attributes for Fulfillment
1414: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1415: itemkey => itemkey,
1416: aname => 'PROCESS_CODE',
1417: avalue => 'AMNSI');
1418: --12/18/06 modified recipient type to 'LESSEE' for XML Publisher, since this was originally Party Contact

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

1416: aname => 'PROCESS_CODE',
1417: avalue => 'AMNSI');
1418: --12/18/06 modified recipient type to 'LESSEE' for XML Publisher, since this was originally Party Contact
1419: /*
1420: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1421: itemkey => itemkey,
1422: aname => 'RECIPIENT_TYPE',
1423: avalue => 'PC'); */
1424: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

1420: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1421: itemkey => itemkey,
1422: aname => 'RECIPIENT_TYPE',
1423: avalue => 'PC'); */
1424: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1425: itemkey => itemkey,
1426: aname => 'RECIPIENT_TYPE',
1427: avalue => 'LESSEE');
1428:

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

1425: itemkey => itemkey,
1426: aname => 'RECIPIENT_TYPE',
1427: avalue => 'LESSEE');
1428:
1429: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1430: itemkey => itemkey,
1431: aname => 'RECIPIENT_ID',
1432: avalue => l_csr_rec.pac_id);
1433:

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

1431: aname => 'RECIPIENT_ID',
1432: avalue => l_csr_rec.pac_id);
1433:
1434:
1435: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1436: itemkey => itemkey,
1437: aname => 'RECIPIENT_DESCRIPTION',
1438: avalue => l_csr_rec.contact_party_name);
1439: --12/18/06 rkuttiya modified for XMLP Project

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

1445: OPEN c_agent_csr(l_csr_rec.last_updated_by);
1446: FETCH c_agent_csr into l_from_email;
1447: CLOSE c_agent_csr;
1448:
1449: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1450: itemkey => itemkey,
1451: aname => 'EMAIL_ADDRESS',
1452: avalue => l_to_email);
1453:

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

1451: aname => 'EMAIL_ADDRESS',
1452: avalue => l_to_email);
1453:
1454:
1455: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1456: itemkey => itemkey,
1457: aname => 'FROM_ADDRESS',
1458: avalue => l_from_email);
1459:

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

1479:
1480:
1481: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1482: l_batch_id := lx_xmp_rec.batch_id;
1483: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1484: itemkey => itemkey,
1485: aname => 'BATCH_ID',
1486: avalue => l_batch_id );
1487: resultout := 'COMPLETE:VALID'; -- rkuttiya changed

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

1556: BEGIN
1557:
1558: IF (funcmode = 'RUN') THEN
1559:
1560: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1561: itemkey => itemkey,
1562: aname => 'TRANSACTION_ID');
1563:
1564: OPEN okl_check_req_csr(l_id);

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

1645: BEGIN
1646:
1647: IF (funcmode = 'RUN') THEN
1648:
1649: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'TRANSACTION_ID');
1652:
1653: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1649: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'TRANSACTION_ID');
1652:
1653: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
1654: itemkey => itemkey,
1655: aname => 'APPROVED_YN');
1656:
1657:

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

1805: l_updated_by NUMBER;
1806:
1807: BEGIN
1808:
1809: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1810: itemkey => itemkey,
1811: aname => 'TRANSACTION_ID');
1812:
1813: --build message (temp)

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

1850: , p_user_id => l_updated_by
1851: , x_name => l_user
1852: , x_description => l_name);
1853:
1854: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1855: itemkey => itemkey,
1856: aname => 'REQUESTER',
1857: avalue => l_user);
1858:

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

1855: itemkey => itemkey,
1856: aname => 'REQUESTER',
1857: avalue => l_user);
1858:
1859: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1860: itemkey => itemkey,
1861: aname => 'WF_ADMINISTRATOR',
1862: avalue => l_user);
1863:

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

1860: itemkey => itemkey,
1861: aname => 'WF_ADMINISTRATOR',
1862: avalue => l_user);
1863:
1864: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1865: itemkey => itemkey,
1866: aname => 'TRX_TYPE_ID',
1867: avalue => 'OKLAMAAR');
1868:

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

1865: itemkey => itemkey,
1866: aname => 'TRX_TYPE_ID',
1867: avalue => 'OKLAMAAR');
1868:
1869: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1870: itemkey => itemkey,
1871: aname => 'MESSAGE_DESCRIPTION',
1872: avalue => l_message);
1873: EXCEPTION

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

1938:
1939: l_asset_return okl_asset_return_csr%rowtype;
1940:
1941: BEGIN
1942: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1943: itemkey => itemkey,
1944: aname => 'TRANSACTION_ID');
1945:
1946: OPEN okl_asset_return_csr(l_art_id);

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

1959: p_user_id => l_asset_return.last_updated_by,
1960: x_name => l_requester,
1961: x_description => l_name);
1962:
1963: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1964: itemkey => itemkey,
1965: aname => 'REQUESTER',
1966: avalue => l_requester);
1967:

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

1964: itemkey => itemkey,
1965: aname => 'REQUESTER',
1966: avalue => l_requester);
1967:
1968: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1969: itemkey => itemkey,
1970: aname => 'PERFORMING_AGENT',
1971: avalue => l_performer);
1972: */

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

1969: itemkey => itemkey,
1970: aname => 'PERFORMING_AGENT',
1971: avalue => l_performer);
1972: */
1973: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1974: itemkey => itemkey,
1975: aname => 'CONTACT_NAME',
1976: avalue => l_asset_return.CONTACT_NAME);
1977:

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

1974: itemkey => itemkey,
1975: aname => 'CONTACT_NAME',
1976: avalue => l_asset_return.CONTACT_NAME);
1977:
1978: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1979: itemkey => itemkey,
1980: aname => 'CONTACT_METHOD',
1981: avalue => l_asset_return.CONTACT_DETAILS);
1982:

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

1979: itemkey => itemkey,
1980: aname => 'CONTACT_METHOD',
1981: avalue => l_asset_return.CONTACT_DETAILS);
1982:
1983: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1984: itemkey => itemkey,
1985: aname => 'CONTRACT_NUMBER',
1986: avalue => l_asset_return.CONTRACT_NUMBER);
1987:

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

1984: itemkey => itemkey,
1985: aname => 'CONTRACT_NUMBER',
1986: avalue => l_asset_return.CONTRACT_NUMBER);
1987:
1988: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1989: itemkey => itemkey,
1990: aname => 'ASSET_NUMBER',
1991: avalue => l_asset_return.ASSET_NUMBER);
1992:

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

1989: itemkey => itemkey,
1990: aname => 'ASSET_NUMBER',
1991: avalue => l_asset_return.ASSET_NUMBER);
1992:
1993: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1994: itemkey => itemkey,
1995: aname => 'ASSET_DESCRIPTION',
1996: avalue => l_asset_return.asset_description);
1997:

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

1994: itemkey => itemkey,
1995: aname => 'ASSET_DESCRIPTION',
1996: avalue => l_asset_return.asset_description);
1997:
1998: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1999: itemkey => itemkey,
2000: aname => 'DETAILS',
2001: avalue => l_asset_return.comments);
2002:

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

1999: itemkey => itemkey,
2000: aname => 'DETAILS',
2001: avalue => l_asset_return.comments);
2002:
2003: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2004: itemkey => itemkey,
2005: aname => 'SERIAL_NUMBER',
2006: avalue => l_asset_return.serial_number);
2007:

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

2004: itemkey => itemkey,
2005: aname => 'SERIAL_NUMBER',
2006: avalue => l_asset_return.serial_number);
2007:
2008: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2009: itemkey => itemkey,
2010: aname => 'MODEL_NUMBER',
2011: avalue => l_asset_return.model_number);
2012:

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

2037:
2038: BEGIN
2039:
2040: IF (funcmode = 'RUN') THEN
2041: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'TRANSACTION_ID');
2044:
2045:

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

2115:
2116: BEGIN
2117:
2118: IF (funcmode = 'RUN') THEN
2119: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2120: itemkey => itemkey,
2121: aname => 'TRANSACTION_ID');
2122:
2123: --build message

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

2156: IF l_header_done THEN
2157: l_message := l_message||'';
2158: END IF;
2159:
2160: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2161: itemkey => itemkey,
2162: aname => 'TRX_TYPE_ID',
2163: avalue => 'OKLAMATK');
2164:

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

2161: itemkey => itemkey,
2162: aname => 'TRX_TYPE_ID',
2163: avalue => 'OKLAMATK');
2164:
2165: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2166: itemkey => itemkey,
2167: aname => 'MESSAGE_DESCRIPTION',
2168: avalue => l_message);
2169:

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

2166: itemkey => itemkey,
2167: aname => 'MESSAGE_DESCRIPTION',
2168: avalue => l_message);
2169:
2170: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2171: itemkey => itemkey,
2172: aname => 'REQUESTER',
2173: avalue => l_user_name);
2174:

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

2171: itemkey => itemkey,
2172: aname => 'REQUESTER',
2173: avalue => l_user_name);
2174:
2175: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2176: itemkey => itemkey,
2177: aname => 'WF_ADMINISTRATOR',
2178: avalue => l_user);
2179: resultout := 'COMPLETE:';

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

2249:
2250: BEGIN
2251:
2252: IF (funcmode = 'RUN') THEN
2253: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2254: itemkey => itemkey,
2255: aname => 'TRANSACTION_ID');
2256:
2257: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

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

2253: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2254: itemkey => itemkey,
2255: aname => 'TRANSACTION_ID');
2256:
2257: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
2258: itemkey => itemkey,
2259: aname => 'APPROVED_YN');
2260:
2261: IF upper(l_approved_yn) = 'Y' THEN

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

2377:
2378: BEGIN
2379:
2380: IF (funcmode = 'RUN') THEN
2381: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2382: itemkey => itemkey,
2383: aname => 'TRANSACTION_ID');
2384:
2385: OPEN okl_pfc_csr(l_id);

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

2389: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2390: FETCH wf_users_csr INTO l_user;
2391: CLOSE wf_users_csr;
2392:
2393: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2394: itemkey => itemkey,
2395: aname => 'TOTAL_RECIPIENTS',
2396: avalue => l_user);
2397:

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

2394: itemkey => itemkey,
2395: aname => 'TOTAL_RECIPIENTS',
2396: avalue => l_user);
2397:
2398: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2399: itemkey => itemkey,
2400: aname => 'CURRENT_RECIPIENT',
2401: avalue => l_user+1);
2402:

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

2399: itemkey => itemkey,
2400: aname => 'CURRENT_RECIPIENT',
2401: avalue => l_user+1);
2402:
2403: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2404: itemkey => itemkey,
2405: aname => 'CONTRACT_NUMBER',
2406: avalue => l_pfc_rec.CONTRACT_NUMBER);
2407:

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

2404: itemkey => itemkey,
2405: aname => 'CONTRACT_NUMBER',
2406: avalue => l_pfc_rec.CONTRACT_NUMBER);
2407:
2408: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2409: itemkey => itemkey,
2410: aname => 'STRATEGY',
2411: avalue => l_pfc_rec.STRATEGY);
2412:

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

2409: itemkey => itemkey,
2410: aname => 'STRATEGY',
2411: avalue => l_pfc_rec.STRATEGY);
2412:
2413: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2414: itemkey => itemkey,
2415: aname => 'ASSIGNMENT_GROUP_ID',
2416: avalue => to_char(l_pfc_rec.TMB_ID));
2417:

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

2414: itemkey => itemkey,
2415: aname => 'ASSIGNMENT_GROUP_ID',
2416: avalue => to_char(l_pfc_rec.TMB_ID));
2417:
2418: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2419: itemkey => itemkey,
2420: aname => 'BUDGET',
2421: avalue => l_pfc_rec.BUDGET);
2422:

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

2419: itemkey => itemkey,
2420: aname => 'BUDGET',
2421: avalue => l_pfc_rec.BUDGET);
2422:
2423: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2424: itemkey => itemkey,
2425: aname => 'EXECUTION_DATE',
2426: avalue => l_pfc_rec.EXECUTION_DATE);
2427:

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

2432: ,p_user_id => l_pfc_rec.last_updated_by
2433: ,x_name => l_user_name
2434: ,x_description => l_name);
2435:
2436: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2437: itemkey => itemkey,
2438: aname => 'REQUESTER',
2439: avalue => l_user_name);
2440:

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

2535: BEGIN
2536:
2537: IF (funcmode = 'RUN') THEN
2538:
2539: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2540: itemkey => itemkey,
2541: aname => 'ASSIGNMENT_GROUP_ID');
2542:
2543: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2539: l_rmr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2540: itemkey => itemkey,
2541: aname => 'ASSIGNMENT_GROUP_ID');
2542:
2543: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2544: itemkey => itemkey,
2545: aname => 'TOTAL_RECIPIENTS');
2546:
2547: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2543: l_total_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2544: itemkey => itemkey,
2545: aname => 'TOTAL_RECIPIENTS');
2546:
2547: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2548: itemkey => itemkey,
2549: aname => 'CURRENT_RECIPIENT');
2550:
2551: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,

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

2547: l_current_rec := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2548: itemkey => itemkey,
2549: aname => 'CURRENT_RECIPIENT');
2550:
2551: l_current_user := wf_engine.GetItemAttrText( itemtype => itemtype,
2552: itemkey => itemkey,
2553: aname => 'PERFORMING_AGENT');
2554:
2555:

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

2556: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2557: FETCH wf_users_csr INTO l_user, l_name ;
2558: CLOSE wf_users_csr;
2559:
2560: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2561: itemkey => itemkey,
2562: aname => 'PERFORMING_AGENT',
2563: avalue => l_user);
2564:

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

2561: itemkey => itemkey,
2562: aname => 'PERFORMING_AGENT',
2563: avalue => l_user);
2564:
2565: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2566: itemkey => itemkey,
2567: aname => 'RECIPIENT_NAME',
2568: avalue => l_name);
2569:

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

2568: avalue => l_name);
2569:
2570: l_current_rec := l_current_rec-1;
2571:
2572: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
2573: itemkey => itemkey,
2574: aname => 'CURRENT_RECIPIENT',
2575: avalue => l_current_rec);
2576:

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

2644: BEGIN
2645:
2646: IF (funcmode = 'RUN') THEN
2647:
2648: l_art_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2649: itemkey => itemkey,
2650: aname => 'TRANSACTION_ID');
2651:
2652: OPEN okl_check_req_csr(l_art_id);

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

2662: x_name => l_requester,
2663: x_description => l_description);
2664:
2665:
2666: wf_engine.SetItemAttrText( itemtype => itemtype,
2667: itemkey => itemkey,
2668: aname => 'REQUESTER',
2669: avalue => l_requester);
2670:

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

2667: itemkey => itemkey,
2668: aname => 'REQUESTER',
2669: avalue => l_requester);
2670:
2671: wf_engine.SetItemAttrText( itemtype => itemtype,
2672: itemkey => itemkey,
2673: aname => 'WF_ADMINISTRATOR',
2674: avalue => l_requester);
2675:

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

2741:
2742: BEGIN
2743:
2744: IF (funcmode = 'RUN') THEN
2745: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2746: itemkey => itemkey,
2747: aname => 'TRANSACTION_ID');
2748:
2749: -- Get the notification recipient from profile.

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

2748:
2749: -- Get the notification recipient from profile.
2750: l_performer := fnd_profile.value('OKL_TRANSPORTATION_NOTIFICATION');
2751:
2752: wf_engine.SetItemAttrText( itemtype => itemtype,
2753: itemkey => itemkey,
2754: aname => 'PERFORMING_AGENT',
2755: avalue => l_performer);
2756: