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

Line 17: wf_engine.ItemStatus(itemType,itemkey,status,result);

13: is
14: status varchar2(50);
15: result varchar2(50);
16: begin
17: wf_engine.ItemStatus(itemType,itemkey,status,result);
18: if status is null then
19: return false;
20: else
21: return true;

Line 277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);

273:
274: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering ValidateWF (' ||
275: itemtype || ') API');
276:
277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);

Line 278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);

274: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering ValidateWF (' ||
275: itemtype || ') API');
276:
277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);

Line 279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);

275: itemtype || ') API');
276:
277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);

Line 280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);

276:
277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);
284:

Line 281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);

277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);
284:
285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting ValidateWF API');

Line 282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);

278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);
279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);
284:
285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting ValidateWF API');
286:

Line 283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);

279: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USER_ID', l_atype, l_subtype, l_format);
280: wf_engine.getItemAttrInfo (itemtype, 'REQUESTER_USERTYPE_ID', l_atype, l_subtype, l_format);
281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);
284:
285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting ValidateWF API');
286:
287: exception

Line 429: wf_engine.CreateProcess (itemtype => itemtype,

425:
426: --
427: -- Start Process
428: --
429: wf_engine.CreateProcess (itemtype => itemtype,
430: itemkey => itemkey);
431: --
432: itemUserKey := substrb (requesterUsername || ' requests for ' || requestType || ' : '|| getRequestName (requestType, requestId), 1, 238);
433:

Line 436: wf_engine.SetItemUserKey (itemtype => itemtype,

432: itemUserKey := substrb (requesterUsername || ' requests for ' || requestType || ' : '|| getRequestName (requestType, requestId), 1, 238);
433:
434:
435:
436: wf_engine.SetItemUserKey (itemtype => itemtype,
437: itemkey => itemkey,
438: UserKey => itemUserKey);
439: --
440: -- Initialize workflow item attributes

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

438: UserKey => itemUserKey);
439: --
440: -- Initialize workflow item attributes
441: --
442: wf_engine.SetItemAttrText (itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'REQUEST_TYPE',
445: avalue => requestType);
446:

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

443: itemkey => itemkey,
444: aname => 'REQUEST_TYPE',
445: avalue => requestType);
446:
447: wf_engine.SetItemAttrNumber (itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'REQUEST_ID',
450: avalue => requestID);
451:

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

448: itemkey => itemkey,
449: aname => 'REQUEST_ID',
450: avalue => requestID);
451:
452: wf_engine.SetItemAttrNumber (itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'REQUESTER_USER_ID',
455: avalue => requesterUserID);
456:

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

453: itemkey => itemkey,
454: aname => 'REQUESTER_USER_ID',
455: avalue => requesterUserID);
456:
457: wf_engine.SetItemAttrNumber (itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'REQUESTER_USERTYPE_ID',
460: avalue => requesterUsertypeID);
461:

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

458: itemkey => itemkey,
459: aname => 'REQUESTER_USERTYPE_ID',
460: avalue => requesterUsertypeID);
461:
462: wf_engine.SetItemAttrNumber (itemtype => itemtype,
463: itemkey => itemkey,
464: aname => 'APPROVAL_ID',
465: avalue => approvalID);
466:

Line 467: wf_engine.SetItemOwner (itemtype => itemtype,

463: itemkey => itemkey,
464: aname => 'APPROVAL_ID',
465: avalue => approvalID);
466:
467: wf_engine.SetItemOwner (itemtype => itemtype,
468: itemkey => itemkey,
469: owner => processOwner);
470:
471:

Line 533: wf_engine.startProcess (itemtype => itemType,

529: else
530: raise_application_error ('20000', 'Not a valid request type: ' || requestType);
531: end if;
532:
533: wf_engine.startProcess (itemtype => itemType,
534: itemkey => to_char(requestRegID));
535:
536: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting LaunchProcess API');
537:

Line 688: approvalID := wf_engine.GetItemAttrNumber (

684: --
685: -- RUN mode - normal process execution
686: --
687: if (funcmode = 'RUN') then
688: approvalID := wf_engine.GetItemAttrNumber (
689: itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'APPROVAL_ID');
692:

Line 693: requesterUserID := wf_engine.GetItemAttrNumber (

689: itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'APPROVAL_ID');
692:
693: requesterUserID := wf_engine.GetItemAttrNumber (
694: itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'REQUESTER_USER_ID');
697:

Line 698: requestType := wf_engine.GetItemAttrText (

694: itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'REQUESTER_USER_ID');
697:
698: requestType := wf_engine.GetItemAttrText (
699: itemtype => itemtype,
700: itemkey => itemkey,
701: aname => 'REQUEST_TYPE');
702:

Line 703: requestId := wf_engine.GetItemAttrNumber (

699: itemtype => itemtype,
700: itemkey => itemkey,
701: aname => 'REQUEST_TYPE');
702:
703: requestId := wf_engine.GetItemAttrNumber (
704: itemtype => itemtype,
705: itemkey => itemkey,
706: aname => 'REQUEST_ID');
707:

Line 708: usertypeId := wf_engine.GetItemAttrNumber (

704: itemtype => itemtype,
705: itemkey => itemkey,
706: aname => 'REQUEST_ID');
707:
708: usertypeId := wf_engine.GetItemAttrNumber (
709: itemtype => itemtype,
710: itemkey => itemkey,
711: aname => 'REQUESTER_USERTYPE_ID');
712:

Line 720: wf_engine.SetItemAttrText (

716: else
717: requestName := getRequestName (requestType, requestId);
718: end if;
719:
720: wf_engine.SetItemAttrText (
721: itemtype => itemtype,
722: itemkey => itemkey,
723: aname => 'REQUEST_NAME',
724: avalue => requestName);

Line 726: wf_engine.SetItemAttrText (

722: itemkey => itemkey,
723: aname => 'REQUEST_NAME',
724: avalue => requestName);
725:
726: wf_engine.SetItemAttrText (
727: itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'REQUESTER_USERTYPE_NAME',
730: avalue => usertypeName);

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

754: RESP_APPL_ID => respApplID,
755: APPLICATION_ID => applID,
756: SITE_LEVEL => true);
757:
758: wf_engine.SetItemAttrText (itemtype => itemtype,
759: itemkey => itemkey,
760: aname => 'APPROVAL_URL',
761: avalue => approvalURL);
762:

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

765: ownerUsername := get_wf_owner_username (
766: p_request_id => requestID,
767: p_request_type => requestType);
768:
769: wf_engine.SetItemAttrText (itemtype => itemtype,
770: itemkey => itemkey,
771: aname => 'OWNER_USERNAME',
772: avalue => ownerUsername);
773:

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

777: NAME => 'JTF_UM_APPROVAL_TIMEOUT_MINS',
778: APPLICATION_ID => applID,
779: SITE_LEVEL => true), 0);
780:
781: wf_engine.SetItemAttrNumber (itemtype => itemtype,
782: itemkey => itemkey,
783: aname => 'MIN_TO_TIMEOUT',
784: avalue => timeout);
785:

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

791: RESP_APPL_ID => respApplID,
792: APPLICATION_ID => applID,
793: SITE_LEVEL => true);
794:
795: wf_engine.SetItemAttrText (itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'APPLICATION_URL',
798: avalue => applicationURL);
799:

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

803: NAME => 'JTA_UM_SENDER',
804: APPLICATION_ID => applID,
805: SITE_LEVEL => true);
806:
807: wf_engine.SetItemAttrText (itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'SENDER_NAME',
810: avalue => senderName);
811:

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

817: RESP_APPL_ID => respApplID,
818: APPLICATION_ID => applID,
819: SITE_LEVEL => true);
820:
821: wf_engine.SetItemAttrText (itemtype => itemtype,
822: itemkey => itemkey,
823: aname => 'SUPPORT_CONTACT',
824: avalue => supportContact);
825:

Line 836: wf_engine.SetItemAttrText (

832: open getCompanyNumber;
833: fetch getCompanyNumber into companyNumber;
834: close getCompanyNumber;
835:
836: wf_engine.SetItemAttrText (
837: itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'COMPANY_NUMBER',
840: avalue => to_char(companyNumber));

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

843:
844: -- Get the requester Username.
845: requesterUserName := getRequesterUsername (requesterUserID);
846:
847: wf_engine.SetItemAttrText (itemtype => itemtype,
848: itemkey => itemkey,
849: aname => 'REQUESTER_USERNAME',
850: avalue => requesterUserName);
851:

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

849: aname => 'REQUESTER_USERNAME',
850: avalue => requesterUserName);
851:
852:
853: wf_engine.SetItemAttrText (itemtype => itemtype,
854: itemkey => itemkey,
855: aname => 'REQUESTER_USERNAME_DISPLAY',
856: avalue => lower (requesterUserName));
857:

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

879: end if;
880:
881: --------------Bug No: 7270214-------------------
882: --------------Bug No: 7661549-------------------
883: wf_engine.SetItemAttrText (itemtype => itemtype,
884: itemkey => itemkey,
885: aname => 'USER_AD_HOC_ROLE',
886: avalue => x_role_name);
887:

Line 989: l_requester_user_id := wf_engine.GetItemAttrNumber (

985: end if;
986:
987: -- to construct the roleName, we need the organization number
988: -- get the user id and find out what is his/her org number
989: l_requester_user_id := wf_engine.GetItemAttrNumber (
990: itemtype => p_itemtype,
991: itemkey => p_itemkey,
992: aname => 'REQUESTER_USER_ID');
993:

Line 1104: requestType := wf_engine.GetItemAttrText (

1100: resultout := 'COMPLETE:T';
1101:
1102: -- Check to see if the approver is a Universal Approver
1103: -- Get the application id of the requestType
1104: requestType := wf_engine.GetItemAttrText (
1105: itemtype => itemtype,
1106: itemkey => itemkey,
1107: aname => 'REQUEST_TYPE');
1108:

Line 1109: requestId := wf_engine.GetItemAttrNumber (

1105: itemtype => itemtype,
1106: itemkey => itemkey,
1107: aname => 'REQUEST_TYPE');
1108:
1109: requestId := wf_engine.GetItemAttrNumber (
1110: itemtype => itemtype,
1111: itemkey => itemkey,
1112: aname => 'REQUEST_ID');
1113:

Line 1144: wf_engine.SetItemAttrText (

1140: l_approver_username_display := lower (approverUsername);
1141: end if;
1142:
1143: -- We need to update the approver username and id
1144: wf_engine.SetItemAttrText (
1145: itemtype => itemtype,
1146: itemkey => itemkey,
1147: aname => 'APPROVER_USERNAME',
1148: avalue => approverUsername);

Line 1150: wf_engine.SetItemAttrText (

1146: itemkey => itemkey,
1147: aname => 'APPROVER_USERNAME',
1148: avalue => approverUsername);
1149:
1150: wf_engine.SetItemAttrText (
1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'APPROVER_USERNAME_DISPLAY',
1154: avalue => l_approver_username_display);

Line 1156: wf_engine.SetItemAttrNumber (

1152: itemkey => itemkey,
1153: aname => 'APPROVER_USERNAME_DISPLAY',
1154: avalue => l_approver_username_display);
1155:
1156: wf_engine.SetItemAttrNumber (
1157: itemtype => itemtype,
1158: itemkey => itemkey,
1159: aname => 'APPROVER_ID',
1160: avalue => approverID);

Line 1163: requestType := wf_engine.GetItemAttrText (

1159: aname => 'APPROVER_ID',
1160: avalue => approverID);
1161:
1162: -- update the APPROVER_USER_ID in the ****_REG table.
1163: requestType := wf_engine.GetItemAttrText (
1164: itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'REQUEST_TYPE');
1167: if (requestType = 'USERTYPE') then

Line 1308: x_approverID := wf_engine.GetItemAttrNumber (

1304: end if;
1305:
1306: x_resultType := 'OK';
1307: -- Get the APPROVER_ID and APPROVAL_ID
1308: x_approverID := wf_engine.GetItemAttrNumber (
1309: itemtype => x_itemtype,
1310: itemkey => x_itemkey,
1311: aname => 'APPROVER_ID');
1312:

Line 1313: l_approvalID := wf_engine.GetItemAttrNumber (

1309: itemtype => x_itemtype,
1310: itemkey => x_itemkey,
1311: aname => 'APPROVER_ID');
1312:
1313: l_approvalID := wf_engine.GetItemAttrNumber (
1314: itemtype => x_itemtype,
1315: itemkey => x_itemkey,
1316: aname => 'APPROVAL_ID');
1317:

Line 1318: l_requesterUserID := wf_engine.GetItemAttrNumber (

1314: itemtype => x_itemtype,
1315: itemkey => x_itemkey,
1316: aname => 'APPROVAL_ID');
1317:
1318: l_requesterUserID := wf_engine.GetItemAttrNumber (
1319: itemtype => x_itemtype,
1320: itemkey => x_itemkey,
1321: aname => 'REQUESTER_USER_ID');
1322:

Line 1323: l_requestType := wf_engine.GetItemAttrText (

1319: itemtype => x_itemtype,
1320: itemkey => x_itemkey,
1321: aname => 'REQUESTER_USER_ID');
1322:
1323: l_requestType := wf_engine.GetItemAttrText (
1324: itemtype => x_itemtype,
1325: itemkey => x_itemkey,
1326: aname => 'REQUEST_TYPE');
1327:

Line 1425: requestType := wf_engine.GetItemAttrText (

1421: --
1422: -- RUN mode - normal process execution
1423: --
1424: if (funcmode = 'RUN') then
1425: requestType := wf_engine.GetItemAttrText (
1426: itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'REQUEST_TYPE');
1429: if (requestType = 'USERTYPE') then

Line 1554: ownerUsername := wf_engine.GetItemAttrText (

1550: cancel_notification (itemtype, itemkey);
1551:
1552: -- The result of the request has not been decided
1553: -- Forward the request to the owner of this process.
1554: ownerUsername := wf_engine.GetItemAttrText (
1555: itemtype => itemtype,
1556: itemkey => itemkey,
1557: aname => 'OWNER_USERNAME');
1558:

Line 1560: wf_engine.SetItemAttrText (

1556: itemkey => itemkey,
1557: aname => 'OWNER_USERNAME');
1558:
1559: -- This is for the next activity in the workflow, can_delegate.
1560: wf_engine.SetItemAttrText (
1561: itemtype => itemtype,
1562: itemkey => itemkey,
1563: aname => 'APPROVER_USERNAME',
1564: avalue => ownerUsername);

Line 1571: requestType := wf_engine.GetItemAttrText (

1567: fetch getUserID into ownerUserID;
1568: close getUserID;
1569:
1570: -- Get the requestType.
1571: requestType := wf_engine.GetItemAttrText (
1572: itemtype => itemtype,
1573: itemkey => itemkey,
1574: aname => 'REQUEST_TYPE');
1575:

Line 1632: requestResult := wf_engine.GetItemAttrText (

1628: --
1629: -- RUN mode - normal process execution
1630: --
1631: if (funcmode = 'RUN') then
1632: requestResult := wf_engine.GetItemAttrText (
1633: itemtype => itemtype,
1634: itemkey => itemkey,
1635: aname => 'REQUEST_RESULT');
1636:

Line 1697: where USER_NAME = WF_ENGINE.context_text;

1693:
1694: cursor getUserID is
1695: select USER_ID
1696: from FND_USER
1697: where USER_NAME = WF_ENGINE.context_text;
1698: --
1699: begin
1700:
1701: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering post_notification (' ||

Line 1718: p_user_name => WF_ENGINE.context_text,

1714: -- Check if the user is the SYSADMIN
1715: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1716: x_flag => l_permission_flag,
1717: x_return_status => l_return_status,
1718: p_user_name => WF_ENGINE.context_text,
1719: p_permission_name => 'JTF_REG_APPROVAL');
1720: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1721: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1722: end if;

Line 1729: p_user_name => WF_ENGINE.context_text,

1725: -- Not a SYSADMIN, check if the user is a Primary User
1726: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1727: x_flag => l_permission_flag,
1728: x_return_status => l_return_status,
1729: p_user_name => WF_ENGINE.context_text,
1730: p_permission_name => 'JTF_PRIMARY_USER_SUMMARY');
1731: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1732: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1733: end if;

Line 1741: p_user_name => WF_ENGINE.context_text,

1737: -- Not a Primary User, check if the user is an Owner
1738: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1739: x_flag => l_permission_flag,
1740: x_return_status => l_return_status,
1741: p_user_name => WF_ENGINE.context_text,
1742: p_permission_name => 'JTF_APPROVER');
1743: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1744: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1745: end if;

Line 1754: requestType := wf_engine.GetItemAttrText (

1750: fnd_message.set_name ('JTF', 'JTF_APPROVAL_PERMISSION');
1751: raise_application_error (-20000, fnd_message.get);
1752: else
1753: -- Get the requestType.
1754: requestType := wf_engine.GetItemAttrText (
1755: itemtype => itemtype,
1756: itemkey => itemkey,
1757: aname => 'REQUEST_TYPE');
1758: --

Line 1819: l_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

1815: --
1816: if (funcmode = 'RUN') then
1817:
1818: -- Save the Grant Delegation Flag
1819: l_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'DELEGATION_FLAG');
1822:
1823: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1823: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1819: l_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'DELEGATION_FLAG');
1822:
1823: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1824: itemkey => itemkey,
1825: aname => 'REQUEST_ID');
1826:
1827: l_requesterUserID := wf_engine.GetItemAttrNumber (

Line 1827: l_requesterUserID := wf_engine.GetItemAttrNumber (

1823: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1824: itemkey => itemkey,
1825: aname => 'REQUEST_ID');
1826:
1827: l_requesterUserID := wf_engine.GetItemAttrNumber (
1828: itemtype => itemtype,
1829: itemkey => itemkey,
1830: aname => 'REQUESTER_USER_ID');
1831:

Line 1921: requesterUserID := wf_engine.GetItemAttrNumber (

1917: if itemkey is null then
1918: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');
1919: end if;
1920:
1921: requesterUserID := wf_engine.GetItemAttrNumber (
1922: itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'REQUESTER_USER_ID');
1925:

Line 1926: requestType := wf_engine.GetItemAttrText (

1922: itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'REQUESTER_USER_ID');
1925:
1926: requestType := wf_engine.GetItemAttrText (
1927: itemtype => itemtype,
1928: itemkey => itemkey,
1929: aname => 'REQUEST_TYPE');
1930:

Line 1931: requestID := wf_engine.GetItemAttrNumber (

1927: itemtype => itemtype,
1928: itemkey => itemkey,
1929: aname => 'REQUEST_TYPE');
1930:
1931: requestID := wf_engine.GetItemAttrNumber (
1932: itemtype => itemtype,
1933: itemkey => itemkey,
1934: aname => 'REQUEST_ID');
1935:

Line 1936: approverComment := wf_engine.GetItemAttrText (

1932: itemtype => itemtype,
1933: itemkey => itemkey,
1934: aname => 'REQUEST_ID');
1935:
1936: approverComment := wf_engine.GetItemAttrText (
1937: itemtype => itemtype,
1938: itemkey => itemkey,
1939: aname => 'APPROVER_COMMENT');
1940:

Line 1990: wf_engine.StartProcess (itemtype => enrollAppRegRow.WF_ITEM_TYPE,

1986:
1987: for enrollAppRegRow in enrollmentApprovalCursor loop
1988: -- Launch workflow created during registration.
1989: if Not hasWorkFlowStarted(enrollAppRegRow.WF_ITEM_TYPE,to_char(enrollAppRegRow.SUBSCRIPTION_REG_ID)) then
1990: wf_engine.StartProcess (itemtype => enrollAppRegRow.WF_ITEM_TYPE,
1991: itemkey => to_char(enrollAppRegRow.SUBSCRIPTION_REG_ID));
1992: end if;
1993:
1994: end loop;

Line 2146: requestType := wf_engine.GetItemAttrText (

2142: --
2143: -- RUN mode - normal process execution
2144: --
2145: if (funcmode = 'RUN') then
2146: requestType := wf_engine.GetItemAttrText (
2147: itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'REQUEST_TYPE');
2150:

Line 2151: requesterUserID := wf_engine.GetItemAttrNumber (

2147: itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'REQUEST_TYPE');
2150:
2151: requesterUserID := wf_engine.GetItemAttrNumber (
2152: itemtype => itemtype,
2153: itemkey => itemkey,
2154: aname => 'REQUESTER_USER_ID');
2155:

Line 2156: approverComment := wf_engine.GetItemAttrText (

2152: itemtype => itemtype,
2153: itemkey => itemkey,
2154: aname => 'REQUESTER_USER_ID');
2155:
2156: approverComment := wf_engine.GetItemAttrText (
2157: itemtype => itemtype,
2158: itemkey => itemkey,
2159: aname => 'APPROVER_COMMENT');
2160:

Line 2182: -- wf_engine.AbortProcess (itemtype => enrollRegRow.WF_ITEM_TYPE,

2178: for enrollRegRow in enrollmentsCursor
2179: loop
2180: -- Abort all Workflow Enrollment
2181: --if (enrollRegRow.WF_ITEM_TYPE is not null) then
2182: -- wf_engine.AbortProcess (itemtype => enrollRegRow.WF_ITEM_TYPE,
2183: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2184: --end if;
2185:
2186: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'

Line 2346: l_approver_username := wf_engine.GetItemAttrText (

2342: resultout := 'COMPLETE:N';
2343:
2344: if (funcmode = 'RUN') then
2345: -- Get the Approver User ID
2346: l_approver_username := wf_engine.GetItemAttrText (
2347: itemtype => itemtype,
2348: itemkey => itemkey,
2349: aname => 'APPROVER_USERNAME');
2350:

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

2363: X_RESULT => l_result);
2364:
2365: if (l_result = JTF_UM_WF_DELEGATION_PVT.CHECKED_UPDATE) then
2366: -- Grant Delegation Flag is set to Yes.
2367: wf_engine.SetItemAttrText (itemtype => itemtype,
2368: itemkey => itemkey,
2369: aname => 'DELEGATION_FLAG',
2370: avalue => 'Y');
2371: resultout := 'COMPLETE:Y';

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

2371: resultout := 'COMPLETE:Y';
2372:
2373: elsif (l_result = JTF_UM_WF_DELEGATION_PVT.NOT_CHECKED_UPDATE) then
2374: -- Grant Delegation Flag is set to No.
2375: wf_engine.SetItemAttrText (itemtype => itemtype,
2376: itemkey => itemkey,
2377: aname => 'DELEGATION_FLAG',
2378: avalue => 'N');
2379: resultout := 'COMPLETE:Y';

Line 2435: l_requester_usertype_id := wf_engine.GetItemAttrNumber (

2431: --
2432:
2433: if (funcmode = 'RUN') then
2434: -- Get the Requester Usertype ID
2435: l_requester_usertype_id := wf_engine.GetItemAttrNumber (
2436: itemtype => itemtype,
2437: itemkey => itemkey,
2438: aname => 'REQUESTER_USERTYPE_ID');
2439:

Line 2441: l_request_id := wf_engine.GetItemAttrNumber(

2437: itemkey => itemkey,
2438: aname => 'REQUESTER_USERTYPE_ID');
2439:
2440: -- Get the Request ID
2441: l_request_id := wf_engine.GetItemAttrNumber(
2442: itemtype => itemtype,
2443: itemkey => itemkey,
2444: aname => 'REQUEST_ID');
2445:

Line 2516: l_approver_username := wf_engine.GetItemAttrText (

2512: --
2513:
2514: if (funcmode = 'RUN') then
2515: -- Get the Current Approver Username
2516: l_approver_username := wf_engine.GetItemAttrText (
2517: itemtype => itemtype,
2518: itemkey => itemkey,
2519: aname => 'APPROVER_USERNAME');
2520:

Line 2522: l_request_type := wf_engine.GetItemAttrText (

2518: itemkey => itemkey,
2519: aname => 'APPROVER_USERNAME');
2520:
2521: -- Get the profile option of Universal Approvers
2522: l_request_type := wf_engine.GetItemAttrText (
2523: itemtype => itemtype,
2524: itemkey => itemkey,
2525: aname => 'REQUEST_TYPE');
2526:

Line 2527: l_request_id := wf_engine.GetItemAttrNumber (

2523: itemtype => itemtype,
2524: itemkey => itemkey,
2525: aname => 'REQUEST_TYPE');
2526:
2527: l_request_id := wf_engine.GetItemAttrNumber (
2528: itemtype => itemtype,
2529: itemkey => itemkey,
2530: aname => 'REQUEST_ID');
2531:

Line 2532: l_requester_user_id := wf_engine.GetItemAttrNumber (

2528: itemtype => itemtype,
2529: itemkey => itemkey,
2530: aname => 'REQUEST_ID');
2531:
2532: l_requester_user_id := wf_engine.GetItemAttrNumber (
2533: itemtype => itemtype,
2534: itemkey => itemkey,
2535: aname => 'REQUESTER_USER_ID');
2536:

Line 2609: usertypeID := wf_engine.GetItemAttrNumber (

2605: -- RUN mode - normal process execution
2606: --
2607:
2608: if (funcmode = 'RUN') then
2609: usertypeID := wf_engine.GetItemAttrNumber (
2610: itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'REQUESTER_USERTYPE_ID');
2613:

Line 2628: requestType := wf_engine.GetItemAttrText (

2624:
2625: else
2626: -- We will send email out.
2627:
2628: requestType := wf_engine.GetItemAttrText (
2629: itemtype => itemtype,
2630: itemkey => itemkey,
2631: aname => 'REQUEST_TYPE');
2632:

Line 2757: request_type := wf_engine.GetItemAttrText (

2753: raise_application_error (-20000, 'resultCode is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2754: end if;
2755:
2756: -- Check Request type
2757: request_type := wf_engine.GetItemAttrText (
2758: itemtype => itemtype,
2759: itemkey => itemkey,
2760: aname => 'REQUEST_TYPE');
2761:

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

2811: end if;
2812:
2813: -- Set the delegation flag
2814: if (delegationFlag is not null) then
2815: wf_engine.SetItemAttrText (itemtype => itemtype,
2816: itemkey => itemkey,
2817: aname => 'DELEGATION_FLAG',
2818: avalue => delegationFlag);
2819: end if;

Line 2946: wf_engine.SetItemAttrText (itemtype => p_itemtype,

2942: ',' || p_itemkey || ',' || p_resultCode || ',' || p_approverComment ||
2943: ',' || p_act1 || ',' || p_act2 || ',' || p_act3 || ',' || p_act4 ||
2944: ',' || p_act5 || ',' || p_act6 || ',' || p_act7 || ',' || p_act8 || ') API');
2945:
2946: wf_engine.SetItemAttrText (itemtype => p_itemtype,
2947: itemkey => p_itemkey,
2948: aname => 'APPROVER_COMMENT',
2949: avalue => p_approverComment);
2950:

Line 2951: wf_engine.SetItemAttrText (itemtype => p_itemtype,

2947: itemkey => p_itemkey,
2948: aname => 'APPROVER_COMMENT',
2949: avalue => p_approverComment);
2950:
2951: wf_engine.SetItemAttrText (itemtype => p_itemtype,
2952: itemkey => p_itemkey,
2953: aname => 'REQUEST_RESULT',
2954: avalue => p_resultCode);
2955:

Line 2957: requestType := wf_engine.GetItemAttrText (itemtype => p_itemtype,

2953: aname => 'REQUEST_RESULT',
2954: avalue => p_resultCode);
2955:
2956: -- Find out what kind of request type is it
2957: requestType := wf_engine.GetItemAttrText (itemtype => p_itemtype,
2958: itemkey => p_itemkey,
2959: aname => 'REQUEST_TYPE');
2960:
2961: if (p_act1 is not null) then

Line 2964: wf_engine.BeginActivity (itemtype => p_itemtype,

2960:
2961: if (p_act1 is not null) then
2962: begin
2963: act := p_act1;
2964: wf_engine.BeginActivity (itemtype => p_itemtype,
2965: itemkey => p_itemkey,
2966: activity => act);
2967: OK := TRUE;
2968: exception

Line 2977: wf_engine.BeginActivity (itemtype => p_itemtype,

2973:
2974: if (not OK) and (p_act2 is not null) then
2975: begin
2976: act := p_act2;
2977: wf_engine.BeginActivity (itemtype => p_itemtype,
2978: itemkey => p_itemkey,
2979: activity => act);
2980: OK := TRUE;
2981: exception

Line 2990: wf_engine.BeginActivity (itemtype => p_itemtype,

2986:
2987: if (not OK) and (p_act3 is not null) then
2988: begin
2989: act := p_act3;
2990: wf_engine.BeginActivity (itemtype => p_itemtype,
2991: itemkey => p_itemkey,
2992: activity => act);
2993: OK := TRUE;
2994: exception

Line 3003: wf_engine.BeginActivity (itemtype => p_itemtype,

2999:
3000: if (not OK) and (p_act4 is not null) then
3001: begin
3002: act := p_act4;
3003: wf_engine.BeginActivity (itemtype => p_itemtype,
3004: itemkey => p_itemkey,
3005: activity => act);
3006: OK := TRUE;
3007: exception

Line 3016: wf_engine.BeginActivity (itemtype => p_itemtype,

3012:
3013: if (not OK) and (p_act5 is not null) then
3014: begin
3015: act := p_act5;
3016: wf_engine.BeginActivity (itemtype => p_itemtype,
3017: itemkey => p_itemkey,
3018: activity => act);
3019: OK := TRUE;
3020: exception

Line 3029: wf_engine.BeginActivity (itemtype => p_itemtype,

3025:
3026: if (not OK) and (p_act6 is not null) then
3027: begin
3028: act := p_act6;
3029: wf_engine.BeginActivity (itemtype => p_itemtype,
3030: itemkey => p_itemkey,
3031: activity => act);
3032: OK := TRUE;
3033: exception

Line 3042: wf_engine.BeginActivity (itemtype => p_itemtype,

3038:
3039: if (not OK) and (p_act7 is not null) then
3040: begin
3041: act := p_act7;
3042: wf_engine.BeginActivity (itemtype => p_itemtype,
3043: itemkey => p_itemkey,
3044: activity => act);
3045: OK := TRUE;
3046: exception

Line 3056: wf_engine.BeginActivity (itemtype => p_itemtype,

3052:
3053: if (not OK) and (p_act8 is not null) then
3054: begin
3055: act := p_act8;
3056: wf_engine.BeginActivity (itemtype => p_itemtype,
3057: itemkey => p_itemkey,
3058: activity => act);
3059: OK := TRUE;
3060: exception

Line 3069: wf_engine.CompleteActivity (p_itemtype, p_itemkey, act, wf_resultCode);

3065:
3066:
3067: if OK then
3068:
3069: wf_engine.CompleteActivity (p_itemtype, p_itemkey, act, wf_resultCode);
3070:
3071: else
3072:
3073: raise_application_error (-20000, 'No Activity Found Failed at JTF_UM_WF_APPROVAL.Do_Complete_Approval_Activity ('

Line 3113: wf_engine.ItemStatus (p_itemtype, p_itemkey, status, result);

3109: if p_itemtype is null then
3110: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.abort_process.');
3111: end if;
3112:
3113: wf_engine.ItemStatus (p_itemtype, p_itemkey, status, result);
3114: if (status <> 'COMPLETE') then
3115: -- need to cancel any open notification
3116: cancel_notification (p_itemtype, p_itemkey);
3117: -- now call the workflow abort process

Line 3118: wf_engine.abortprocess (itemtype => p_itemtype,

3114: if (status <> 'COMPLETE') then
3115: -- need to cancel any open notification
3116: cancel_notification (p_itemtype, p_itemkey);
3117: -- now call the workflow abort process
3118: wf_engine.abortprocess (itemtype => p_itemtype,
3119: itemkey => p_itemkey);
3120: end if;
3121:
3122: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting abort_process API');

Line 3530: wf_engine.startProcess (itemType => p_wf_new_item_type,

3526: fetch check_usertype_status into p_usertype_status;
3527: close check_usertype_status;
3528:
3529: if (p_usertype_status = 'APPROVED') then
3530: wf_engine.startProcess (itemType => p_wf_new_item_type,
3531: itemKey => p_new_item_key);
3532: end if;
3533: end if;
3534: end loop;

Line 3645: p_approver_comment := wf_engine.GetItemAttrText (

3641: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3642: 'Entering get_approver_comment (' || p_reg_id || ',' ||
3643: p_wf_item_type || ') API');
3644:
3645: p_approver_comment := wf_engine.GetItemAttrText (
3646: itemtype => p_wf_item_type,
3647: itemkey => to_char(p_reg_id),
3648: aname => 'APPROVER_COMMENT');
3649: