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

293: IF (funcmode = 'RUN') THEN
294:
295: SAVEPOINT raise_fulfillment_event;
296:
297: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'TRANSACTION_ID');
300:
301: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

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

297: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'TRANSACTION_ID');
300:
301: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'PROCESS_CODE');
304:
305: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

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

301: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'PROCESS_CODE');
304:
305: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'RECIPIENT_TYPE');
308:
309: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

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

305: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'RECIPIENT_TYPE');
308:
309: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'RECIPIENT_ID');
312:
313: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

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

309: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'RECIPIENT_ID');
312:
313: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
314: itemkey => itemkey,
315: aname => 'RECIPIENT_DESCRIPTION');
316:
317: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

313: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
314: itemkey => itemkey,
315: aname => 'RECIPIENT_DESCRIPTION');
316:
317: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
318: itemkey => itemkey,
319: aname => 'CREATED_BY');
320:
321: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

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

317: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
318: itemkey => itemkey,
319: aname => 'CREATED_BY');
320:
321: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'EMAIL_ADDRESS');
324:
325: --19-jul-2007 ansethur R12B XML Publisher starts

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

322: itemkey => itemkey,
323: aname => 'EMAIL_ADDRESS');
324:
325: --19-jul-2007 ansethur R12B XML Publisher starts
326: l_from_address := wf_engine.GetItemAttrText( itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'FROM_ADDRESS');
329: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
330: itemkey => itemkey,

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

325: --19-jul-2007 ansethur R12B XML Publisher starts
326: l_from_address := wf_engine.GetItemAttrText( itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'FROM_ADDRESS');
329: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
330: itemkey => itemkey,
331: aname => 'BATCH_ID');
332: --19-jul-2007 ansethur R12B XML Publisher end
333: OPEN okl_key_csr;

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

459: IF (funcmode = 'RUN') THEN
460:
461: SAVEPOINT call_fulfillment;
462:
463: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'TRANSACTION_ID');
466:
467: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,

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

463: l_transaction_id := wf_engine.GetItemAttrText( itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'TRANSACTION_ID');
466:
467: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
468: itemkey => itemkey,
469: aname => 'PROCESS_CODE');
470:
471: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,

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

467: l_process_code := wf_engine.GetItemAttrText( itemtype => itemtype,
468: itemkey => itemkey,
469: aname => 'PROCESS_CODE');
470:
471: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'RECIPIENT_TYPE');
474:
475: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,

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

471: l_recipient_type := wf_engine.GetItemAttrText( itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'RECIPIENT_TYPE');
474:
475: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
476: itemkey => itemkey,
477: aname => 'RECIPIENT_ID');
478:
479: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

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

475: l_recipient_id := wf_engine.GetItemAttrText( itemtype => itemtype,
476: itemkey => itemkey,
477: aname => 'RECIPIENT_ID');
478:
479: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'RECIPIENT_DESCRIPTION');
482:
483: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

479: l_recipient_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'RECIPIENT_DESCRIPTION');
482:
483: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
484: itemkey => itemkey,
485: aname => 'CREATED_BY');
486:
487: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,

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

483: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
484: itemkey => itemkey,
485: aname => 'CREATED_BY');
486:
487: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'EXPAND_ROLES');
490:
491: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,

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

487: l_expand_roles := wf_engine.GetItemAttrText( itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'EXPAND_ROLES');
490:
491: l_email_address := wf_engine.GetItemAttrText( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'EMAIL_ADDRESS');
494:
495: OKL_AM_UTIL_PVT.EXECUTE_FULFILLMENT_REQUEST (

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

540: l_msg_idx := FND_MSG_PUB.G_NEXT;
541:
542: END LOOP;
543:
544: wf_engine.SetItemAttrText ( itemtype=> itemtype,
545: itemkey => itemkey,
546: aname => 'STATUS_MESSAGE',
547: avalue => l_status_message);
548:

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

555: , p_user_id => l_created_by
556: , x_name => l_notification_agent
557: , x_description => l_desc);
558:
559: wf_engine.SetItemAttrText ( itemtype=> itemtype,
560: itemkey => itemkey,
561: aname => 'NOTIFY_AGENT',
562: avalue => l_notification_agent);
563:

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

560: itemkey => itemkey,
561: aname => 'NOTIFY_AGENT',
562: avalue => l_notification_agent);
563:
564: wf_engine.SetItemAttrText ( itemtype=> itemtype,
565: itemkey => itemkey,
566: aname => 'RECIPIENT_DESCRIPTION',
567: avalue => l_notification_agent);
568:

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

678:
679: IF (funcmode = 'RUN') THEN
680:
681:
682: wf_engine.CreateProcess(itemtype => l_itemtype,
683: itemkey => l_key,
684: process => l_process);
685:
686:

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

683: itemkey => l_key,
684: process => l_process);
685:
686:
687: wf_engine.SetItemParent(itemtype => l_itemtype,
688: itemkey => l_key,
689: parent_itemtype => itemtype,
690: parent_itemkey => itemkey,
691: parent_context => 'MASTER');

Line 693: l_parent_trx_id := wf_engine.GetItemAttrText (

689: parent_itemtype => itemtype,
690: parent_itemkey => itemkey,
691: parent_context => 'MASTER');
692:
693: l_parent_trx_id := wf_engine.GetItemAttrText (
694: itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'TRANSACTION_ID');
697:

Line 698: wf_engine.SetItemAttrText (

694: itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'TRANSACTION_ID');
697:
698: wf_engine.SetItemAttrText (
699: itemtype => l_itemtype,
700: itemkey => l_key,
701: aname => 'TRANSACTION_ID',
702: avalue => l_parent_trx_id);

Line 704: l_parent_trx_type := wf_engine.GetItemAttrText (

700: itemkey => l_key,
701: aname => 'TRANSACTION_ID',
702: avalue => l_parent_trx_id);
703:
704: l_parent_trx_type := wf_engine.GetItemAttrText (
705: itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'TRX_TYPE_ID');
708:

Line 709: l_mess_desc := wf_engine.GetItemAttrText (

705: itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'TRX_TYPE_ID');
708:
709: l_mess_desc := wf_engine.GetItemAttrText (
710: itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'MESSAGE_DESCRIPTION');
713:

Line 715: l_org_id := wf_engine.GetItemAttrText (

711: itemkey => itemkey,
712: aname => 'MESSAGE_DESCRIPTION');
713:
714: --Added by bkatraga for bug 9412628
715: l_org_id := wf_engine.GetItemAttrText (
716: itemtype => itemtype,
717: itemkey => itemkey,
718: aname => 'ORG_ID');
719:

Line 720: wf_engine.SetItemAttrText (

716: itemtype => itemtype,
717: itemkey => itemkey,
718: aname => 'ORG_ID');
719:
720: wf_engine.SetItemAttrText (
721: itemtype => l_itemtype,
722: itemkey => l_key,
723: aname => 'ORG_ID',
724: avalue => l_org_id);

Line 731: l_msg_doc := wf_engine.GetItemAttrText(

727: --dkagrawa -Bug#5256290 added exception handling start
728: BEGIN
729: -- smadhava - Bug#5235038 - Added - Start
730: -- Get the MESSAGE_DOC attribute value set in the original Workflow
731: l_msg_doc := wf_engine.GetItemAttrText(
732: itemtype => itemtype
733: , itemkey => itemkey
734: , aname => 'MESSAGE_DOC');
735: -- smadhava - Bug#5235038 - Added - End

Line 742: l_requester := wf_engine.GetItemAttrText (

738: l_msg_doc := null;
739: END;
740: --dkagrawa -Bug#5256290 end
741:
742: l_requester := wf_engine.GetItemAttrText (
743: itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'REQUESTER');
746:

Line 747: wf_engine.SetItemAttrText (

743: itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'REQUESTER');
746:
747: wf_engine.SetItemAttrText (
748: itemtype => l_itemtype,
749: itemkey => l_key,
750: aname => 'TRX_TYPE_ID',
751: avalue => l_parent_trx_type);

Line 753: wf_engine.SetItemAttrText (

749: itemkey => l_key,
750: aname => 'TRX_TYPE_ID',
751: avalue => l_parent_trx_type);
752:
753: wf_engine.SetItemAttrText (
754: itemtype => l_itemtype,
755: itemkey => l_key,
756: aname => 'PARENT_ITEM_KEY',
757: avalue => itemkey);

Line 759: wf_engine.SetItemAttrText (

755: itemkey => l_key,
756: aname => 'PARENT_ITEM_KEY',
757: avalue => itemkey);
758:
759: wf_engine.SetItemAttrText (
760: itemtype => l_itemtype,
761: itemkey => l_key,
762: aname => 'PARENT_ITEM_TYPE',
763: avalue => itemtype);

Line 765: wf_engine.SetItemAttrText (

761: itemkey => l_key,
762: aname => 'PARENT_ITEM_TYPE',
763: avalue => itemtype);
764:
765: wf_engine.SetItemAttrText (
766: itemtype => l_itemtype,
767: itemkey => l_key,
768: aname => 'MESSAGE_DESCRIPTION',
769: avalue => l_mess_desc);

Line 771: wf_engine.SetItemAttrText (

767: itemkey => l_key,
768: aname => 'MESSAGE_DESCRIPTION',
769: avalue => l_mess_desc);
770:
771: wf_engine.SetItemAttrText (
772: itemtype => l_itemtype,
773: itemkey => l_key,
774: aname => 'REQUESTER',
775: avalue => l_requester);

Line 777: wf_engine.SetItemAttrText (

773: itemkey => l_key,
774: aname => 'REQUESTER',
775: avalue => l_requester);
776:
777: wf_engine.SetItemAttrText (
778: itemtype => l_itemtype,
779: itemkey => l_key,
780: aname => 'WF_ADMINISTRATOR',
781: avalue => l_requester);

Line 792: wf_engine.SetItemAttrText (

788: -- Else assign the call to pop_approval_doc to assign the MESSAGE_DESCRIPTION
789: IF l_msg_doc IS NULL THEN
790: l_msg_doc := 'plsql:okl_am_wf.pop_approval_doc/'||l_key;
791: END IF;
792: wf_engine.SetItemAttrText (
793: itemtype => l_itemtype,
794: itemkey => l_key,
795: aname => 'MESSAGE_DOC',
796: avalue => l_msg_doc);

Line 802: wf_engine.SetItemAttrText (

798: -- 19-NOV-03 MDOKAL -- Bug 3262184
799: -- process optional parameters
800: FOR ia_rec IN check_ia_exists_csr(itemtype) LOOP
801:
802: wf_engine.SetItemAttrText (
803: itemtype => l_itemtype,
804: itemkey => l_key,
805: aname => ia_rec.name,
806: avalue => wf_engine.GetItemAttrText(

Line 806: avalue => wf_engine.GetItemAttrText(

802: wf_engine.SetItemAttrText (
803: itemtype => l_itemtype,
804: itemkey => l_key,
805: aname => ia_rec.name,
806: avalue => wf_engine.GetItemAttrText(
807: itemtype => itemtype,
808: itemkey => itemkey,
809: aname => ia_rec.name)
810: );

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

809: aname => ia_rec.name)
810: );
811: END LOOP;
812:
813: wf_engine.StartProcess(itemtype => l_itemtype,
814: itemkey => l_key);
815:
816: resultout := 'COMPLETE:';
817: RETURN;

Line 896: l_parent_key := wf_engine.GetItemAttrText (

892:
893:
894: -- Get parent information from Approvals WF
895:
896: l_parent_key := wf_engine.GetItemAttrText (
897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'PARENT_ITEM_KEY');
900:

Line 901: l_parent_type := wf_engine.GetItemAttrText (

897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'PARENT_ITEM_KEY');
900:
901: l_parent_type := wf_engine.GetItemAttrText (
902: itemtype => itemtype,
903: itemkey => itemkey,
904: aname => 'PARENT_ITEM_TYPE');
905:

Line 908: l_approved_yn := wf_engine.GetItemAttrText (

904: aname => 'PARENT_ITEM_TYPE');
905:
906:
907: -- Get Approved flag
908: l_approved_yn := wf_engine.GetItemAttrText (
909: itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'RESULT');
912:

Line 922: wf_engine.SetItemAttrText (

918: l_approved_yn := 'N';
919: end if;
920:
921:
922: wf_engine.SetItemAttrText (
923: itemtype => l_parent_type,
924: itemkey => l_parent_key,
925: aname => 'APPROVED_YN',
926: avalue => l_approved_yn);

Line 928: l_transaction_id := wf_engine.GetItemAttrText (

924: itemkey => l_parent_key,
925: aname => 'APPROVED_YN',
926: avalue => l_approved_yn);
927:
928: l_transaction_id := wf_engine.GetItemAttrText (
929: itemtype => l_parent_type,
930: itemkey => l_parent_key,
931: aname => 'TRANSACTION_ID');
932:

Line 1030: l_trx_type := wf_engine.GetItemAttrText (

1026: END IF;
1027:
1028: IF (funcmode = 'RUN') THEN
1029:
1030: l_trx_type := wf_engine.GetItemAttrText (
1031: itemtype => itemtype,
1032: itemkey => itemkey,
1033: aname => 'TRX_TYPE_ID');
1034:

Line 1045: wf_engine.SetItemAttrText (

1041: CLOSE c_get_app_id_csr;
1042:
1043: IF l_knt <> 0 AND l_app_id IS NOT NULL THEN
1044:
1045: wf_engine.SetItemAttrText (
1046: itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => 'APPLICATION_ID',
1049: avalue => l_app_id);

Line 1144: l_trx_type := wf_engine.GetItemAttrText (

1140:
1141: IF (funcmode = 'RUN') THEN
1142:
1143: -- Get OAM parameter values from Approvals WF
1144: l_trx_type := wf_engine.GetItemAttrText (
1145: itemtype => itemtype,
1146: itemkey => itemkey,
1147: aname => 'TRX_TYPE_ID');
1148:

Line 1149: l_app_id := wf_engine.GetItemAttrText (

1145: itemtype => itemtype,
1146: itemkey => itemkey,
1147: aname => 'TRX_TYPE_ID');
1148:
1149: l_app_id := wf_engine.GetItemAttrText (
1150: itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'APPLICATION_ID');
1153:

Line 1154: l_transaction_id := wf_engine.GetItemAttrText (

1150: itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'APPLICATION_ID');
1153:
1154: l_transaction_id := wf_engine.GetItemAttrText (
1155: itemtype => itemtype,
1156: itemkey => itemkey,
1157: aname => 'TRANSACTION_ID');
1158:

Line 1180: wf_engine.SetItemAttrText (

1176: , p_user_id => l_user_id -- SGORANTL 28-DEC-05 4887809
1177: , x_name => l_approver
1178: , x_description => l_name);
1179:
1180: wf_engine.SetItemAttrText (
1181: itemtype => itemtype,
1182: itemkey => itemkey,
1183: aname => 'PERFORMING_AGENT',
1184: avalue => l_approver);

Line 1186: wf_engine.SetItemAttrText (

1182: itemkey => itemkey,
1183: aname => 'PERFORMING_AGENT',
1184: avalue => l_approver);
1185:
1186: wf_engine.SetItemAttrText (
1187: itemtype => itemtype,
1188: itemkey => itemkey,
1189: aname => 'FIRST_NAME',
1190: avalue => l_approver_rec.first_name);

Line 1192: wf_engine.SetItemAttrText (

1188: itemkey => itemkey,
1189: aname => 'FIRST_NAME',
1190: avalue => l_approver_rec.first_name);
1191:
1192: wf_engine.SetItemAttrText (
1193: itemtype => itemtype,
1194: itemkey => itemkey,
1195: aname => 'LAST_NAME',
1196: avalue => l_approver_rec.last_name);

Line 1198: wf_engine.SetItemAttrNumber (

1194: itemkey => itemkey,
1195: aname => 'LAST_NAME',
1196: avalue => l_approver_rec.last_name);
1197:
1198: wf_engine.SetItemAttrNumber (
1199: itemtype => itemtype,
1200: itemkey => itemkey,
1201: aname => 'USER_ID',
1202: avalue => l_approver_rec.user_id);

Line 1204: wf_engine.SetItemAttrNumber (

1200: itemkey => itemkey,
1201: aname => 'USER_ID',
1202: avalue => l_approver_rec.user_id);
1203:
1204: wf_engine.SetItemAttrNumber (
1205: itemtype => itemtype,
1206: itemkey => itemkey,
1207: aname => 'PERSON_ID',
1208: avalue => l_approver_rec.person_id);

Line 1210: wf_engine.SetItemAttrText (

1206: itemkey => itemkey,
1207: aname => 'PERSON_ID',
1208: avalue => l_approver_rec.person_id);
1209:
1210: wf_engine.SetItemAttrText (
1211: itemtype => itemtype,
1212: itemkey => itemkey,
1213: aname => 'API_INSERTION',
1214: avalue => l_approver_rec.api_insertion);

Line 1216: wf_engine.SetItemAttrText (

1212: itemkey => itemkey,
1213: aname => 'API_INSERTION',
1214: avalue => l_approver_rec.api_insertion);
1215:
1216: wf_engine.SetItemAttrText (
1217: itemtype => itemtype,
1218: itemkey => itemkey,
1219: aname => 'AUTHORITY',
1220: avalue => l_approver_rec.authority);

Line 1225: l_result := wf_engine.GetItemAttrText (

1221:
1222: resultout := 'COMPLETE:FOUND';
1223: ELSE
1224:
1225: l_result := wf_engine.GetItemAttrText (
1226: itemtype => itemtype,
1227: itemkey => itemkey,
1228: aname => 'RESULT');
1229:

Line 1232: wf_engine.SetItemAttrText (

1228: aname => 'RESULT');
1229:
1230: IF l_result IS NULL THEN
1231: -- There were no appovers, set RESULT to APPROVE
1232: wf_engine.SetItemAttrText (
1233: itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'RESULT',
1236: avalue => 'APPROVED');

Line 1316: l_approved_yn := wf_engine.GetItemAttrText (

1312:
1313: IF (funcmode = 'RUN') THEN
1314:
1315: -- Get current approval status
1316: l_approved_yn := wf_engine.GetItemAttrText (
1317: itemtype => itemtype,
1318: itemkey => itemkey,
1319: aname => 'RESULT');
1320:

Line 1329: l_transaction_id := wf_engine.GetItemAttrText (

1325: END IF;
1326:
1327: -- All OAM attributes
1328:
1329: l_transaction_id := wf_engine.GetItemAttrText (
1330: itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'TRANSACTION_ID');
1333:

Line 1334: l_trx_type := wf_engine.GetItemAttrText (

1330: itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'TRANSACTION_ID');
1333:
1334: l_trx_type := wf_engine.GetItemAttrText (
1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'TRX_TYPE_ID');
1338:

Line 1339: l_app_id := wf_engine.GetItemAttrNumber (

1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'TRX_TYPE_ID');
1338:
1339: l_app_id := wf_engine.GetItemAttrNumber (
1340: itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'APPLICATION_ID');
1343:

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

1340: itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'APPLICATION_ID');
1343:
1344: l_approver_rec.last_name := wf_engine.GetItemAttrText (
1345: itemtype => itemtype,
1346: itemkey => itemkey,
1347: aname => 'LAST_NAME');
1348:

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

1345: itemtype => itemtype,
1346: itemkey => itemkey,
1347: aname => 'LAST_NAME');
1348:
1349: l_approver_rec.first_name := wf_engine.GetItemAttrText (
1350: itemtype => itemtype,
1351: itemkey => itemkey,
1352: aname => 'FIRST_NAME');
1353:

Line 1354: l_user_id := wf_engine.GetItemAttrNumber (

1350: itemtype => itemtype,
1351: itemkey => itemkey,
1352: aname => 'FIRST_NAME');
1353:
1354: l_user_id := wf_engine.GetItemAttrNumber (
1355: itemtype => itemtype,
1356: itemkey => itemkey,
1357: aname => 'USER_ID');
1358:

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

1361: else
1362: l_approver_rec.user_id := l_user_id;
1363: end if;
1364:
1365: l_approver_rec.person_id := wf_engine.GetItemAttrNumber (
1366: itemtype => itemtype,
1367: itemkey => itemkey,
1368: aname => 'PERSON_ID');
1369:

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

1366: itemtype => itemtype,
1367: itemkey => itemkey,
1368: aname => 'PERSON_ID');
1369:
1370: l_approver_rec.api_insertion := wf_engine.GetItemAttrText (
1371: itemtype => itemtype,
1372: itemkey => itemkey,
1373: aname => 'API_INSERTION');
1374:

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

1371: itemtype => itemtype,
1372: itemkey => itemkey,
1373: aname => 'API_INSERTION');
1374:
1375: l_approver_rec.authority := wf_engine.GetItemAttrText (
1376: itemtype => itemtype,
1377: itemkey => itemkey,
1378: aname => 'AUTHORITY');
1379:

Line 1457: l_error_itemtype := wf_engine.GetItemAttrText (

1453:
1454: IF funcmode = 'RUN' THEN
1455:
1456: -- get the errored processes itemtype and itemkey
1457: l_error_itemtype := wf_engine.GetItemAttrText (
1458: itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'ERROR_ITEM_TYPE');
1461:

Line 1462: l_error_itemkey := wf_engine.GetItemAttrText (

1458: itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'ERROR_ITEM_TYPE');
1461:
1462: l_error_itemkey := wf_engine.GetItemAttrText (
1463: itemtype => itemtype,
1464: itemkey => itemkey,
1465: aname => 'ERROR_ITEM_KEY');
1466:

Line 1469: l_return_status := wf_engine.GetItemAttrText (

1465: aname => 'ERROR_ITEM_KEY');
1466:
1467: -- get the error details from the errored process
1468:
1469: l_return_status := wf_engine.GetItemAttrText (
1470: itemtype => l_error_itemtype,
1471: itemkey => l_error_itemkey,
1472: aname => 'API_ERROR');
1473:

Line 1474: l_msg_data := wf_engine.GetItemAttrText (

1470: itemtype => l_error_itemtype,
1471: itemkey => l_error_itemkey,
1472: aname => 'API_ERROR');
1473:
1474: l_msg_data := wf_engine.GetItemAttrText (
1475: itemtype => l_error_itemtype,
1476: itemkey => l_error_itemkey,
1477: aname => 'API_ERROR_STACK');
1478:

Line 1481: wf_engine.SetItemAttrText (

1477: aname => 'API_ERROR_STACK');
1478:
1479: -- set error details in the standard error item type
1480:
1481: wf_engine.SetItemAttrText (
1482: itemtype => itemtype,
1483: itemkey => itemkey,
1484: aname => 'API_ERROR',
1485: avalue => l_return_status);

Line 1487: wf_engine.SetItemAttrText (

1483: itemkey => itemkey,
1484: aname => 'API_ERROR',
1485: avalue => l_return_status);
1486:
1487: wf_engine.SetItemAttrText (
1488: itemtype => itemtype,
1489: itemkey => itemkey,
1490: aname => 'API_ERROR_STACK',
1491: avalue => l_msg_data);

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

1571: l_status_message := 'An error was encountered but no message was found in the error stack';
1572:
1573: END IF;
1574:
1575: wf_engine.SetItemAttrText ( itemtype => itemtype,
1576: itemkey => itemkey,
1577: aname => 'API_ERROR_STACK',
1578: avalue => l_status_message);
1579:

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

1576: itemkey => itemkey,
1577: aname => 'API_ERROR_STACK',
1578: avalue => l_status_message);
1579:
1580: wf_engine.SetItemAttrText ( itemtype => itemtype,
1581: itemkey => itemkey,
1582: aname => 'API_ERROR',
1583: avalue => 'E');
1584:

Line 1747: l_message := wf_engine.GetItemAttrText (

1743: IF (is_debug_procedure_on) THEN
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1745: END IF;
1746:
1747: l_message := wf_engine.GetItemAttrText (
1748: itemtype => 'OKLAMAPP',
1749: itemkey => document_id,
1750: aname => 'MESSAGE_DESCRIPTION');
1751:

Line 1798: wf_engine.SetItemAttrText (

1794: SAVEPOINT set_atts;
1795:
1796: IF (funcmode = 'RUN') THEN
1797:
1798: wf_engine.SetItemAttrText (
1799: itemtype => itemtype,
1800: itemkey => itemkey,
1801: aname => 'RESULT',
1802: avalue => 'REJECT');

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

1871: IF (is_debug_procedure_on) THEN
1872: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1873: END IF;
1874:
1875: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,
1876: itemkey,
1877: 'ORG_ID');
1878: current_org_id := nvl(mo_global.get_current_org_id(),-1);
1879:

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

1885: end if;
1886:
1887: IF (itemtype = 'OKLAMPPT') THEN
1888: -- Get the user who intiated the workflow
1889: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1890: itemkey,
1891: 'USER_ID');
1892: -- Get the current user
1893: current_user_id:= FND_GLOBAL.USER_ID;

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

1891: 'USER_ID');
1892: -- Get the current user
1893: current_user_id:= FND_GLOBAL.USER_ID;
1894: -- Get the responsibility at which the above user intiated the workflow
1895: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1896: itemkey,
1897: 'RESPONSIBILITY_ID');
1898: -- Get the current responsibility
1899: current_resp_id:= FND_GLOBAL.RESP_ID;

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

1898: -- Get the current responsibility
1899: current_resp_id:= FND_GLOBAL.RESP_ID;
1900: -- Get the application where the above user intiated the workflow
1901:
1902: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1903: itemkey,
1904: 'APPL_ID');
1905: -- Get the current application
1906: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

1909:
1910: -- rmunjulu 11717591 added OKLCSTRQ start
1911: IF (itemtype = 'OKLCSTRQ') THEN
1912: -- Get the user who intiated the workflow
1913: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1914: itemkey,
1915: 'USER_ID');
1916: -- Get the current user
1917: current_user_id:= FND_GLOBAL.USER_ID;

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

1915: 'USER_ID');
1916: -- Get the current user
1917: current_user_id:= FND_GLOBAL.USER_ID;
1918: -- Get the responsibility at which the above user intiated the workflow
1919: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1920: itemkey,
1921: 'RESPONSIBILITY_ID');
1922: -- Get the current responsibility
1923: current_resp_id:= FND_GLOBAL.RESP_ID;

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

1922: -- Get the current responsibility
1923: current_resp_id:= FND_GLOBAL.RESP_ID;
1924: -- Get the application where the above user intiated the workflow
1925:
1926: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1927: itemkey,
1928: 'APPL_ID');
1929: -- Get the current application
1930: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

1934:
1935: IF (itemtype = 'OKLCSCRM') THEN
1936:
1937: -- Get the user who intiated the workflow
1938: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1939: itemkey,
1940: 'USER_ID');
1941: -- Get the current user
1942: current_user_id:= FND_GLOBAL.USER_ID;

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

1940: 'USER_ID');
1941: -- Get the current user
1942: current_user_id:= FND_GLOBAL.USER_ID;
1943: -- Get the responsibility at which the above user intiated the workflow
1944: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1945: itemkey,
1946: 'RESPONSIBILITY_ID');
1947: -- Get the current responsibility
1948: current_resp_id:= FND_GLOBAL.RESP_ID;

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

1946: 'RESPONSIBILITY_ID');
1947: -- Get the current responsibility
1948: current_resp_id:= FND_GLOBAL.RESP_ID;
1949: -- Get the application where the above user intiated the workflow
1950: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1951: itemkey,
1952: 'APPLICATION_ID');
1953: -- Get the current application
1954: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

1957:
1958: IF (itemtype = 'OKLAMNQT') THEN
1959:
1960: -- Get the user who intiated the workflow
1961: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1962: itemkey,
1963: 'USER_ID');
1964: -- Get the current user
1965: current_user_id:= FND_GLOBAL.USER_ID;

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

1963: 'USER_ID');
1964: -- Get the current user
1965: current_user_id:= FND_GLOBAL.USER_ID;
1966: -- Get the responsibility at which the above user intiated the workflow
1967: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1968: itemkey,
1969: 'RESPONSIBILITY_ID');
1970: -- Get the current responsibility
1971: current_resp_id:= FND_GLOBAL.RESP_ID;

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

1969: 'RESPONSIBILITY_ID');
1970: -- Get the current responsibility
1971: current_resp_id:= FND_GLOBAL.RESP_ID;
1972: -- Get the application where the above user intiated the workflow
1973: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1974: itemkey,
1975: 'APPLICATION_ID');
1976: -- Get the current application
1977: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

1981: -- Start of code added as part of Bug:15933691 venkatho
1982: IF (itemtype = 'OKLSOQUO') THEN
1983:
1984: -- Get the user who intiated the workflow
1985: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1986: itemkey,
1987: 'USER_ID');
1988: -- Get the current user
1989: current_user_id:= FND_GLOBAL.USER_ID;

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

1987: 'USER_ID');
1988: -- Get the current user
1989: current_user_id:= FND_GLOBAL.USER_ID;
1990: -- Get the responsibility at which the above user intiated the workflow
1991: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1992: itemkey,
1993: 'RESPONSIBILITY_ID');
1994: -- Get the current responsibility
1995: current_resp_id:= FND_GLOBAL.RESP_ID;

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

1993: 'RESPONSIBILITY_ID');
1994: -- Get the current responsibility
1995: current_resp_id:= FND_GLOBAL.RESP_ID;
1996: -- Get the application where the above user intiated the workflow
1997: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1998: itemkey,
1999: 'APPLICATION_ID');
2000: -- Get the current application
2001: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

2137: current_appl_id NUMBER;
2138: BEGIN
2139:
2140: -- Get the Org from where the workflow was initiated
2141: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,
2142: itemkey,
2143: 'ORG_ID');
2144:
2145: -- Get the current org

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

2145: -- Get the current org
2146: current_org_id:= fnd_profile.value('ORG_ID');
2147:
2148: -- Get the user who intiated the workflow
2149: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
2150: itemkey,
2151: 'USER_ID');
2152: -- Get the current user
2153: current_user_id:= FND_GLOBAL.USER_ID;

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

2152: -- Get the current user
2153: current_user_id:= FND_GLOBAL.USER_ID;
2154:
2155: -- Get the responsibility at which the above user intiated the workflow
2156: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
2157: itemkey,
2158: 'RESPONSIBILITY_ID');
2159: -- Get the current responsibility
2160: current_resp_id:= FND_GLOBAL.RESP_ID;

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

2159: -- Get the current responsibility
2160: current_resp_id:= FND_GLOBAL.RESP_ID;
2161:
2162: -- Get the application where the above user intiated the workflow
2163: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
2164: itemkey,
2165: 'APPLICATION_ID');
2166: -- Get the current application
2167: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

Line 2268: l_recipient_type := wf_engine.GetItemAttrText (

2264:
2265: SAVEPOINT call_populate;
2266:
2267:
2268: l_recipient_type := wf_engine.GetItemAttrText (
2269: itemtype => itemtype,
2270: itemkey => itemkey,
2271: aname => 'RECIPIENT_TYPE');
2272:

Line 2273: l_process_code := wf_engine.GetItemAttrText (

2269: itemtype => itemtype,
2270: itemkey => itemkey,
2271: aname => 'RECIPIENT_TYPE');
2272:
2273: l_process_code := wf_engine.GetItemAttrText (
2274: itemtype => itemtype,
2275: itemkey => itemkey,
2276: aname => 'PROCESS_CODE');
2277:

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

2274: itemtype => itemtype,
2275: itemkey => itemkey,
2276: aname => 'PROCESS_CODE');
2277:
2278: l_created_by := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2279: itemkey => itemkey,
2280: aname => 'CREATED_BY');
2281:
2282: OPEN c_get_temp_code(l_process_code,l_recipient_type);

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

2299: , p_user_id => l_created_by
2300: , x_name => l_notification_agent
2301: , x_description => l_desc);
2302:
2303: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2304: itemkey => itemkey,
2305: aname => 'NOTIFY_AGENT',
2306: avalue => l_notification_agent);
2307:

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

2304: itemkey => itemkey,
2305: aname => 'NOTIFY_AGENT',
2306: avalue => l_notification_agent);
2307:
2308: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2309: itemkey => itemkey,
2310: aname => 'RECIPIENT_DESCRIPTION',
2311: avalue => l_notification_agent);
2312:

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

2309: itemkey => itemkey,
2310: aname => 'RECIPIENT_DESCRIPTION',
2311: avalue => l_notification_agent);
2312:
2313: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2314: itemkey => itemkey,
2315: aname => 'TEMPLATE_CODE',
2316: avalue => l_template_code);
2317:

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

2315: aname => 'TEMPLATE_CODE',
2316: avalue => l_template_code);
2317:
2318:
2319: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2320: itemkey => itemkey,
2321: aname => 'DELIVERY_MODE',
2322: avalue => l_delivery_mode);
2323:

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

2322: avalue => l_delivery_mode);
2323:
2324:
2325:
2326: wf_engine.SetItemAttrText (itemtype => itemtype,
2327: itemkey => itemkey,
2328: aname => 'MESSAGE_BODY_TEXT',
2329: avalue => l_message_body
2330: );

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

2327: itemkey => itemkey,
2328: aname => 'MESSAGE_BODY_TEXT',
2329: avalue => l_message_body
2330: );
2331: wf_engine.SetItemAttrText (itemtype => itemtype,
2332: itemkey => itemkey,
2333: aname => 'MESSAGE_SUB_TEXT',
2334: avalue => l_message_sub
2335: );

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

2333: aname => 'MESSAGE_SUB_TEXT',
2334: avalue => l_message_sub
2335: );
2336: --19-jul-2007 ansethur R12B XML Publisher Starts
2337: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2338: itemkey => itemkey,
2339: aname => 'DATA_SOURCE_CODE',
2340: avalue => l_datasource_code);
2341: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

2337: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2338: itemkey => itemkey,
2339: aname => 'DATA_SOURCE_CODE',
2340: avalue => l_datasource_code);
2341: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2342: itemkey => itemkey,
2343: aname => 'SUBJECT',
2344: avalue => l_email_subject_line);
2345: --19-jul-2007 ansethur R12B XML Publisher Ends