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_WF dependencies on WF_ENGINE

Line 229: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,

225: IF (funcmode = 'RUN') THEN
226:
227: SAVEPOINT raise_fulfillment_event;
228:
229: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'TRANSACTION_ID');
232:
233: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 233: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

229: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'TRANSACTION_ID');
232:
233: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'PROCESS_CODE');
236:
237: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 237: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

233: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'PROCESS_CODE');
236:
237: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'RECIPIENT_TYPE');
240:
241: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 241: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

237: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'RECIPIENT_TYPE');
240:
241: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'RECIPIENT_ID');
244:
245: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 245: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

241: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'RECIPIENT_ID');
244:
245: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
246: itemkey => itemkey,
247: aname => 'RECIPIENT_DESCRIPTION');
248:
249: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 249: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

245: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
246: itemkey => itemkey,
247: aname => 'RECIPIENT_DESCRIPTION');
248:
249: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'CREATED_BY');
252:
253: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 253: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

249: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'CREATED_BY');
252:
253: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,
254: itemkey => itemkey,
255: aname => 'EMAIL_ADDRESS');
256:
257: --19-jul-2007 ansethur R12B XML Publisher starts

Line 258: l_from_address := wf_engine.GetItemAttrText( itemtype => itemtype,

254: itemkey => itemkey,
255: aname => 'EMAIL_ADDRESS');
256:
257: --19-jul-2007 ansethur R12B XML Publisher starts
258: l_from_address := wf_engine.GetItemAttrText( itemtype => itemtype,
259: itemkey => itemkey,
260: aname => 'FROM_ADDRESS');
261: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
262: itemkey => itemkey,

Line 261: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

257: --19-jul-2007 ansethur R12B XML Publisher starts
258: l_from_address := wf_engine.GetItemAttrText( itemtype => itemtype,
259: itemkey => itemkey,
260: aname => 'FROM_ADDRESS');
261: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
262: itemkey => itemkey,
263: aname => 'BATCH_ID');
264: --19-jul-2007 ansethur R12B XML Publisher end
265: OPEN okl_key_csr;

Line 395: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,

391: IF (funcmode = 'RUN') THEN
392:
393: SAVEPOINT call_fulfillment;
394:
395: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'TRANSACTION_ID');
398:
399: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 399: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

395: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'TRANSACTION_ID');
398:
399: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
400: itemkey => itemkey,
401: aname => 'PROCESS_CODE');
402:
403: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 403: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

399: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
400: itemkey => itemkey,
401: aname => 'PROCESS_CODE');
402:
403: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'RECIPIENT_TYPE');
406:
407: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 407: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

403: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'RECIPIENT_TYPE');
406:
407: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'RECIPIENT_ID');
410:
411: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 411: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

407: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'RECIPIENT_ID');
410:
411: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'RECIPIENT_DESCRIPTION');
414:
415: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 415: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

411: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'RECIPIENT_DESCRIPTION');
414:
415: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'CREATED_BY');
418:
419: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 419: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,

415: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'CREATED_BY');
418:
419: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'EXPAND_ROLES');
422:
423: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 423: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

419: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'EXPAND_ROLES');
422:
423: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'EMAIL_ADDRESS');
426:
427: OKL_AM_UTIL_PVT.EXECUTE_FULFILLMENT_REQUEST (

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

472: l_msg_idx := FND_MSG_PUB.G_NEXT;
473:
474: END LOOP;
475:
476: wf_engine.SetItemAttrText ( itemtype=> itemtype,
477: itemkey => itemkey,
478: aname => 'STATUS_MESSAGE',
479: avalue => l_status_message);
480:

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

487: , p_user_id => l_created_by
488: , x_name => l_notification_agent
489: , x_description => l_desc);
490:
491: wf_engine.SetItemAttrText ( itemtype=> itemtype,
492: itemkey => itemkey,
493: aname => 'NOTIFY_AGENT',
494: avalue => l_notification_agent);
495:

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

492: itemkey => itemkey,
493: aname => 'NOTIFY_AGENT',
494: avalue => l_notification_agent);
495:
496: wf_engine.SetItemAttrText ( itemtype=> itemtype,
497: itemkey => itemkey,
498: aname => 'RECIPIENT_DESCRIPTION',
499: avalue => l_notification_agent);
500:

Line 612: wf_engine.CreateProcess(itemtype => l_itemtype,

608:
609: IF (funcmode = 'RUN') THEN
610:
611:
612: wf_engine.CreateProcess(itemtype => l_itemtype,
613: itemkey => l_key,
614: process => l_process);
615:
616:

Line 617: wf_engine.SetItemParent(itemtype => l_itemtype,

613: itemkey => l_key,
614: process => l_process);
615:
616:
617: wf_engine.SetItemParent(itemtype => l_itemtype,
618: itemkey => l_key,
619: parent_itemtype => itemtype,
620: parent_itemkey => itemkey,
621: parent_context => 'MASTER');

Line 623: l_parent_trx_id := wf_engine.GetItemAttrText (

619: parent_itemtype => itemtype,
620: parent_itemkey => itemkey,
621: parent_context => 'MASTER');
622:
623: l_parent_trx_id := wf_engine.GetItemAttrText (
624: itemtype => itemtype,
625: itemkey => itemkey,
626: aname => 'TRANSACTION_ID');
627:

Line 628: wf_engine.SetItemAttrText (

624: itemtype => itemtype,
625: itemkey => itemkey,
626: aname => 'TRANSACTION_ID');
627:
628: wf_engine.SetItemAttrText (
629: itemtype => l_itemtype,
630: itemkey => l_key,
631: aname => 'TRANSACTION_ID',
632: avalue => l_parent_trx_id);

Line 634: l_parent_trx_type := wf_engine.GetItemAttrText (

630: itemkey => l_key,
631: aname => 'TRANSACTION_ID',
632: avalue => l_parent_trx_id);
633:
634: l_parent_trx_type := wf_engine.GetItemAttrText (
635: itemtype => itemtype,
636: itemkey => itemkey,
637: aname => 'TRX_TYPE_ID');
638:

Line 639: l_mess_desc := wf_engine.GetItemAttrText (

635: itemtype => itemtype,
636: itemkey => itemkey,
637: aname => 'TRX_TYPE_ID');
638:
639: l_mess_desc := wf_engine.GetItemAttrText (
640: itemtype => itemtype,
641: itemkey => itemkey,
642: aname => 'MESSAGE_DESCRIPTION');
643:

Line 648: l_msg_doc := wf_engine.GetItemAttrText(

644: --dkagrawa -Bug#5256290 added exception handling start
645: BEGIN
646: -- smadhava - Bug#5235038 - Added - Start
647: -- Get the MESSAGE_DOC attribute value set in the original Workflow
648: l_msg_doc := wf_engine.GetItemAttrText(
649: itemtype => itemtype
650: , itemkey => itemkey
651: , aname => 'MESSAGE_DOC');
652: -- smadhava - Bug#5235038 - Added - End

Line 659: l_requester := wf_engine.GetItemAttrText (

655: l_msg_doc := null;
656: END;
657: --dkagrawa -Bug#5256290 end
658:
659: l_requester := wf_engine.GetItemAttrText (
660: itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'REQUESTER');
663:

Line 664: wf_engine.SetItemAttrText (

660: itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'REQUESTER');
663:
664: wf_engine.SetItemAttrText (
665: itemtype => l_itemtype,
666: itemkey => l_key,
667: aname => 'TRX_TYPE_ID',
668: avalue => l_parent_trx_type);

Line 670: wf_engine.SetItemAttrText (

666: itemkey => l_key,
667: aname => 'TRX_TYPE_ID',
668: avalue => l_parent_trx_type);
669:
670: wf_engine.SetItemAttrText (
671: itemtype => l_itemtype,
672: itemkey => l_key,
673: aname => 'PARENT_ITEM_KEY',
674: avalue => itemkey);

Line 676: wf_engine.SetItemAttrText (

672: itemkey => l_key,
673: aname => 'PARENT_ITEM_KEY',
674: avalue => itemkey);
675:
676: wf_engine.SetItemAttrText (
677: itemtype => l_itemtype,
678: itemkey => l_key,
679: aname => 'PARENT_ITEM_TYPE',
680: avalue => itemtype);

Line 682: wf_engine.SetItemAttrText (

678: itemkey => l_key,
679: aname => 'PARENT_ITEM_TYPE',
680: avalue => itemtype);
681:
682: wf_engine.SetItemAttrText (
683: itemtype => l_itemtype,
684: itemkey => l_key,
685: aname => 'MESSAGE_DESCRIPTION',
686: avalue => l_mess_desc);

Line 688: wf_engine.SetItemAttrText (

684: itemkey => l_key,
685: aname => 'MESSAGE_DESCRIPTION',
686: avalue => l_mess_desc);
687:
688: wf_engine.SetItemAttrText (
689: itemtype => l_itemtype,
690: itemkey => l_key,
691: aname => 'REQUESTER',
692: avalue => l_requester);

Line 694: wf_engine.SetItemAttrText (

690: itemkey => l_key,
691: aname => 'REQUESTER',
692: avalue => l_requester);
693:
694: wf_engine.SetItemAttrText (
695: itemtype => l_itemtype,
696: itemkey => l_key,
697: aname => 'WF_ADMINISTRATOR',
698: avalue => l_requester);

Line 709: wf_engine.SetItemAttrText (

705: -- Else assign the call to pop_approval_doc to assign the MESSAGE_DESCRIPTION
706: IF l_msg_doc IS NULL THEN
707: l_msg_doc := 'plsql:okl_am_wf.pop_approval_doc/'||l_key;
708: END IF;
709: wf_engine.SetItemAttrText (
710: itemtype => l_itemtype,
711: itemkey => l_key,
712: aname => 'MESSAGE_DOC',
713: avalue => l_msg_doc);

Line 719: wf_engine.SetItemAttrText (

715: -- 19-NOV-03 MDOKAL -- Bug 3262184
716: -- process optional parameters
717: FOR ia_rec IN check_ia_exists_csr(itemtype) LOOP
718:
719: wf_engine.SetItemAttrText (
720: itemtype => l_itemtype,
721: itemkey => l_key,
722: aname => ia_rec.name,
723: avalue => wf_engine.GetItemAttrText(

Line 723: avalue => wf_engine.GetItemAttrText(

719: wf_engine.SetItemAttrText (
720: itemtype => l_itemtype,
721: itemkey => l_key,
722: aname => ia_rec.name,
723: avalue => wf_engine.GetItemAttrText(
724: itemtype => itemtype,
725: itemkey => itemkey,
726: aname => ia_rec.name)
727: );

Line 730: wf_engine.StartProcess(itemtype => l_itemtype,

726: aname => ia_rec.name)
727: );
728: END LOOP;
729:
730: wf_engine.StartProcess(itemtype => l_itemtype,
731: itemkey => l_key);
732:
733: resultout := 'COMPLETE:';
734: RETURN;

Line 813: l_parent_key := wf_engine.GetItemAttrText (

809:
810:
811: -- Get parent information from Approvals WF
812:
813: l_parent_key := wf_engine.GetItemAttrText (
814: itemtype => itemtype,
815: itemkey => itemkey,
816: aname => 'PARENT_ITEM_KEY');
817:

Line 818: l_parent_type := wf_engine.GetItemAttrText (

814: itemtype => itemtype,
815: itemkey => itemkey,
816: aname => 'PARENT_ITEM_KEY');
817:
818: l_parent_type := wf_engine.GetItemAttrText (
819: itemtype => itemtype,
820: itemkey => itemkey,
821: aname => 'PARENT_ITEM_TYPE');
822:

Line 825: l_approved_yn := wf_engine.GetItemAttrText (

821: aname => 'PARENT_ITEM_TYPE');
822:
823:
824: -- Get Approved flag
825: l_approved_yn := wf_engine.GetItemAttrText (
826: itemtype => itemtype,
827: itemkey => itemkey,
828: aname => 'RESULT');
829:

Line 839: wf_engine.SetItemAttrText (

835: l_approved_yn := 'N';
836: end if;
837:
838:
839: wf_engine.SetItemAttrText (
840: itemtype => l_parent_type,
841: itemkey => l_parent_key,
842: aname => 'APPROVED_YN',
843: avalue => l_approved_yn);

Line 845: l_transaction_id := wf_engine.GetItemAttrText (

841: itemkey => l_parent_key,
842: aname => 'APPROVED_YN',
843: avalue => l_approved_yn);
844:
845: l_transaction_id := wf_engine.GetItemAttrText (
846: itemtype => l_parent_type,
847: itemkey => l_parent_key,
848: aname => 'TRANSACTION_ID');
849:

Line 947: l_trx_type := wf_engine.GetItemAttrText (

943: END IF;
944:
945: IF (funcmode = 'RUN') THEN
946:
947: l_trx_type := wf_engine.GetItemAttrText (
948: itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'TRX_TYPE_ID');
951:

Line 962: wf_engine.SetItemAttrText (

958: CLOSE c_get_app_id_csr;
959:
960: IF l_knt <> 0 AND l_app_id IS NOT NULL THEN
961:
962: wf_engine.SetItemAttrText (
963: itemtype => itemtype,
964: itemkey => itemkey,
965: aname => 'APPLICATION_ID',
966: avalue => l_app_id);

Line 1061: l_trx_type := wf_engine.GetItemAttrText (

1057:
1058: IF (funcmode = 'RUN') THEN
1059:
1060: -- Get OAM parameter values from Approvals WF
1061: l_trx_type := wf_engine.GetItemAttrText (
1062: itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => 'TRX_TYPE_ID');
1065:

Line 1066: l_app_id := wf_engine.GetItemAttrText (

1062: itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => 'TRX_TYPE_ID');
1065:
1066: l_app_id := wf_engine.GetItemAttrText (
1067: itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'APPLICATION_ID');
1070:

Line 1071: l_transaction_id := wf_engine.GetItemAttrText (

1067: itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'APPLICATION_ID');
1070:
1071: l_transaction_id := wf_engine.GetItemAttrText (
1072: itemtype => itemtype,
1073: itemkey => itemkey,
1074: aname => 'TRANSACTION_ID');
1075:

Line 1097: wf_engine.SetItemAttrText (

1093: , p_user_id => l_user_id -- SGORANTL 28-DEC-05 4887809
1094: , x_name => l_approver
1095: , x_description => l_name);
1096:
1097: wf_engine.SetItemAttrText (
1098: itemtype => itemtype,
1099: itemkey => itemkey,
1100: aname => 'PERFORMING_AGENT',
1101: avalue => l_approver);

Line 1103: wf_engine.SetItemAttrText (

1099: itemkey => itemkey,
1100: aname => 'PERFORMING_AGENT',
1101: avalue => l_approver);
1102:
1103: wf_engine.SetItemAttrText (
1104: itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'FIRST_NAME',
1107: avalue => l_approver_rec.first_name);

Line 1109: wf_engine.SetItemAttrText (

1105: itemkey => itemkey,
1106: aname => 'FIRST_NAME',
1107: avalue => l_approver_rec.first_name);
1108:
1109: wf_engine.SetItemAttrText (
1110: itemtype => itemtype,
1111: itemkey => itemkey,
1112: aname => 'LAST_NAME',
1113: avalue => l_approver_rec.last_name);

Line 1115: wf_engine.SetItemAttrNumber (

1111: itemkey => itemkey,
1112: aname => 'LAST_NAME',
1113: avalue => l_approver_rec.last_name);
1114:
1115: wf_engine.SetItemAttrNumber (
1116: itemtype => itemtype,
1117: itemkey => itemkey,
1118: aname => 'USER_ID',
1119: avalue => l_approver_rec.user_id);

Line 1121: wf_engine.SetItemAttrNumber (

1117: itemkey => itemkey,
1118: aname => 'USER_ID',
1119: avalue => l_approver_rec.user_id);
1120:
1121: wf_engine.SetItemAttrNumber (
1122: itemtype => itemtype,
1123: itemkey => itemkey,
1124: aname => 'PERSON_ID',
1125: avalue => l_approver_rec.person_id);

Line 1127: wf_engine.SetItemAttrText (

1123: itemkey => itemkey,
1124: aname => 'PERSON_ID',
1125: avalue => l_approver_rec.person_id);
1126:
1127: wf_engine.SetItemAttrText (
1128: itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'API_INSERTION',
1131: avalue => l_approver_rec.api_insertion);

Line 1133: wf_engine.SetItemAttrText (

1129: itemkey => itemkey,
1130: aname => 'API_INSERTION',
1131: avalue => l_approver_rec.api_insertion);
1132:
1133: wf_engine.SetItemAttrText (
1134: itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => 'AUTHORITY',
1137: avalue => l_approver_rec.authority);

Line 1142: l_result := wf_engine.GetItemAttrText (

1138:
1139: resultout := 'COMPLETE:FOUND';
1140: ELSE
1141:
1142: l_result := wf_engine.GetItemAttrText (
1143: itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'RESULT');
1146:

Line 1149: wf_engine.SetItemAttrText (

1145: aname => 'RESULT');
1146:
1147: IF l_result IS NULL THEN
1148: -- There were no appovers, set RESULT to APPROVE
1149: wf_engine.SetItemAttrText (
1150: itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'RESULT',
1153: avalue => 'APPROVED');

Line 1233: l_approved_yn := wf_engine.GetItemAttrText (

1229:
1230: IF (funcmode = 'RUN') THEN
1231:
1232: -- Get current approval status
1233: l_approved_yn := wf_engine.GetItemAttrText (
1234: itemtype => itemtype,
1235: itemkey => itemkey,
1236: aname => 'RESULT');
1237:

Line 1246: l_transaction_id := wf_engine.GetItemAttrText (

1242: END IF;
1243:
1244: -- All OAM attributes
1245:
1246: l_transaction_id := wf_engine.GetItemAttrText (
1247: itemtype => itemtype,
1248: itemkey => itemkey,
1249: aname => 'TRANSACTION_ID');
1250:

Line 1251: l_trx_type := wf_engine.GetItemAttrText (

1247: itemtype => itemtype,
1248: itemkey => itemkey,
1249: aname => 'TRANSACTION_ID');
1250:
1251: l_trx_type := wf_engine.GetItemAttrText (
1252: itemtype => itemtype,
1253: itemkey => itemkey,
1254: aname => 'TRX_TYPE_ID');
1255:

Line 1256: l_app_id := wf_engine.GetItemAttrNumber (

1252: itemtype => itemtype,
1253: itemkey => itemkey,
1254: aname => 'TRX_TYPE_ID');
1255:
1256: l_app_id := wf_engine.GetItemAttrNumber (
1257: itemtype => itemtype,
1258: itemkey => itemkey,
1259: aname => 'APPLICATION_ID');
1260:

Line 1261: l_approver_rec.last_name := wf_engine.GetItemAttrText (

1257: itemtype => itemtype,
1258: itemkey => itemkey,
1259: aname => 'APPLICATION_ID');
1260:
1261: l_approver_rec.last_name := wf_engine.GetItemAttrText (
1262: itemtype => itemtype,
1263: itemkey => itemkey,
1264: aname => 'LAST_NAME');
1265:

Line 1266: l_approver_rec.first_name := wf_engine.GetItemAttrText (

1262: itemtype => itemtype,
1263: itemkey => itemkey,
1264: aname => 'LAST_NAME');
1265:
1266: l_approver_rec.first_name := wf_engine.GetItemAttrText (
1267: itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'FIRST_NAME');
1270:

Line 1271: l_user_id := wf_engine.GetItemAttrNumber (

1267: itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'FIRST_NAME');
1270:
1271: l_user_id := wf_engine.GetItemAttrNumber (
1272: itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'USER_ID');
1275:

Line 1282: l_approver_rec.person_id := wf_engine.GetItemAttrNumber (

1278: else
1279: l_approver_rec.user_id := l_user_id;
1280: end if;
1281:
1282: l_approver_rec.person_id := wf_engine.GetItemAttrNumber (
1283: itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'PERSON_ID');
1286:

Line 1287: l_approver_rec.api_insertion := wf_engine.GetItemAttrText (

1283: itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'PERSON_ID');
1286:
1287: l_approver_rec.api_insertion := wf_engine.GetItemAttrText (
1288: itemtype => itemtype,
1289: itemkey => itemkey,
1290: aname => 'API_INSERTION');
1291:

Line 1292: l_approver_rec.authority := wf_engine.GetItemAttrText (

1288: itemtype => itemtype,
1289: itemkey => itemkey,
1290: aname => 'API_INSERTION');
1291:
1292: l_approver_rec.authority := wf_engine.GetItemAttrText (
1293: itemtype => itemtype,
1294: itemkey => itemkey,
1295: aname => 'AUTHORITY');
1296:

Line 1374: l_error_itemtype := wf_engine.GetItemAttrText (

1370:
1371: IF funcmode = 'RUN' THEN
1372:
1373: -- get the errored processes itemtype and itemkey
1374: l_error_itemtype := wf_engine.GetItemAttrText (
1375: itemtype => itemtype,
1376: itemkey => itemkey,
1377: aname => 'ERROR_ITEM_TYPE');
1378:

Line 1379: l_error_itemkey := wf_engine.GetItemAttrText (

1375: itemtype => itemtype,
1376: itemkey => itemkey,
1377: aname => 'ERROR_ITEM_TYPE');
1378:
1379: l_error_itemkey := wf_engine.GetItemAttrText (
1380: itemtype => itemtype,
1381: itemkey => itemkey,
1382: aname => 'ERROR_ITEM_KEY');
1383:

Line 1386: l_return_status := wf_engine.GetItemAttrText (

1382: aname => 'ERROR_ITEM_KEY');
1383:
1384: -- get the error details from the errored process
1385:
1386: l_return_status := wf_engine.GetItemAttrText (
1387: itemtype => l_error_itemtype,
1388: itemkey => l_error_itemkey,
1389: aname => 'API_ERROR');
1390:

Line 1391: l_msg_data := wf_engine.GetItemAttrText (

1387: itemtype => l_error_itemtype,
1388: itemkey => l_error_itemkey,
1389: aname => 'API_ERROR');
1390:
1391: l_msg_data := wf_engine.GetItemAttrText (
1392: itemtype => l_error_itemtype,
1393: itemkey => l_error_itemkey,
1394: aname => 'API_ERROR_STACK');
1395:

Line 1398: wf_engine.SetItemAttrText (

1394: aname => 'API_ERROR_STACK');
1395:
1396: -- set error details in the standard error item type
1397:
1398: wf_engine.SetItemAttrText (
1399: itemtype => itemtype,
1400: itemkey => itemkey,
1401: aname => 'API_ERROR',
1402: avalue => l_return_status);

Line 1404: wf_engine.SetItemAttrText (

1400: itemkey => itemkey,
1401: aname => 'API_ERROR',
1402: avalue => l_return_status);
1403:
1404: wf_engine.SetItemAttrText (
1405: itemtype => itemtype,
1406: itemkey => itemkey,
1407: aname => 'API_ERROR_STACK',
1408: avalue => l_msg_data);

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

1488: l_status_message := 'An error was encountered but no message was found in the error stack';
1489:
1490: END IF;
1491:
1492: wf_engine.SetItemAttrText ( itemtype => itemtype,
1493: itemkey => itemkey,
1494: aname => 'API_ERROR_STACK',
1495: avalue => l_status_message);
1496:

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

1493: itemkey => itemkey,
1494: aname => 'API_ERROR_STACK',
1495: avalue => l_status_message);
1496:
1497: wf_engine.SetItemAttrText ( itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'API_ERROR',
1500: avalue => 'E');
1501:

Line 1664: l_message := wf_engine.GetItemAttrText (

1660: IF (is_debug_procedure_on) THEN
1661: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1662: END IF;
1663:
1664: l_message := wf_engine.GetItemAttrText (
1665: itemtype => 'OKLAMAPP',
1666: itemkey => document_id,
1667: aname => 'MESSAGE_DESCRIPTION');
1668:

Line 1715: wf_engine.SetItemAttrText (

1711: SAVEPOINT set_atts;
1712:
1713: IF (funcmode = 'RUN') THEN
1714:
1715: wf_engine.SetItemAttrText (
1716: itemtype => itemtype,
1717: itemkey => itemkey,
1718: aname => 'RESULT',
1719: avalue => 'REJECT');

Line 1790: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,

1786: IF (is_debug_procedure_on) THEN
1787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1788: END IF;
1789:
1790: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,
1791: itemkey,
1792: 'ORG_ID');
1793: current_org_id := nvl(mo_global.get_current_org_id(),-1);
1794:

Line 1798: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,

1794:
1795: IF(itemtype = 'OKLCSCRM') THEN
1796:
1797: -- Get the user who intiated the workflow
1798: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1799: itemkey,
1800: 'USER_ID');
1801: -- Get the current user
1802: current_user_id:= FND_GLOBAL.USER_ID;

Line 1804: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,

1800: 'USER_ID');
1801: -- Get the current user
1802: current_user_id:= FND_GLOBAL.USER_ID;
1803: -- Get the responsibility at which the above user intiated the workflow
1804: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1805: itemkey,
1806: 'RESPONSIBILITY_ID');
1807: -- Get the current responsibility
1808: current_resp_id:= FND_GLOBAL.RESP_ID;

Line 1810: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,

1806: 'RESPONSIBILITY_ID');
1807: -- Get the current responsibility
1808: current_resp_id:= FND_GLOBAL.RESP_ID;
1809: -- Get the application where the above user intiated the workflow
1810: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1811: itemkey,
1812: 'APPLICATION_ID');
1813: -- Get the current application
1814: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

Line 1930: l_recipient_type := wf_engine.GetItemAttrText (

1926:
1927: SAVEPOINT call_populate;
1928:
1929:
1930: l_recipient_type := wf_engine.GetItemAttrText (
1931: itemtype => itemtype,
1932: itemkey => itemkey,
1933: aname => 'RECIPIENT_TYPE');
1934:

Line 1935: l_process_code := wf_engine.GetItemAttrText (

1931: itemtype => itemtype,
1932: itemkey => itemkey,
1933: aname => 'RECIPIENT_TYPE');
1934:
1935: l_process_code := wf_engine.GetItemAttrText (
1936: itemtype => itemtype,
1937: itemkey => itemkey,
1938: aname => 'PROCESS_CODE');
1939:

Line 1940: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1936: itemtype => itemtype,
1937: itemkey => itemkey,
1938: aname => 'PROCESS_CODE');
1939:
1940: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1941: itemkey => itemkey,
1942: aname => 'CREATED_BY');
1943:
1944: OPEN c_get_temp_code(l_process_code,l_recipient_type);

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

1961: , p_user_id => l_created_by
1962: , x_name => l_notification_agent
1963: , x_description => l_desc);
1964:
1965: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1966: itemkey => itemkey,
1967: aname => 'NOTIFY_AGENT',
1968: avalue => l_notification_agent);
1969:

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

1966: itemkey => itemkey,
1967: aname => 'NOTIFY_AGENT',
1968: avalue => l_notification_agent);
1969:
1970: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1971: itemkey => itemkey,
1972: aname => 'RECIPIENT_DESCRIPTION',
1973: avalue => l_notification_agent);
1974:

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

1971: itemkey => itemkey,
1972: aname => 'RECIPIENT_DESCRIPTION',
1973: avalue => l_notification_agent);
1974:
1975: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1976: itemkey => itemkey,
1977: aname => 'TEMPLATE_CODE',
1978: avalue => l_template_code);
1979:

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

1977: aname => 'TEMPLATE_CODE',
1978: avalue => l_template_code);
1979:
1980:
1981: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1982: itemkey => itemkey,
1983: aname => 'DELIVERY_MODE',
1984: avalue => l_delivery_mode);
1985:

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

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

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

1989: itemkey => itemkey,
1990: aname => 'MESSAGE_BODY_TEXT',
1991: avalue => l_message_body
1992: );
1993: wf_engine.SetItemAttrText (itemtype => itemtype,
1994: itemkey => itemkey,
1995: aname => 'MESSAGE_SUB_TEXT',
1996: avalue => l_message_sub
1997: );

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

1995: aname => 'MESSAGE_SUB_TEXT',
1996: avalue => l_message_sub
1997: );
1998: --19-jul-2007 ansethur R12B XML Publisher Starts
1999: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2000: itemkey => itemkey,
2001: aname => 'DATA_SOURCE_CODE',
2002: avalue => l_datasource_code);
2003: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

1999: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2000: itemkey => itemkey,
2001: aname => 'DATA_SOURCE_CODE',
2002: avalue => l_datasource_code);
2003: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2004: itemkey => itemkey,
2005: aname => 'SUBJECT',
2006: avalue => l_email_subject_line);
2007: --19-jul-2007 ansethur R12B XML Publisher Ends