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 877: wf_engine.SetItemAttrText (itemtype => itemtype,

873: elsif (getAdHocRole%FOUND) then
874: WF_DIRECTORY.SetAdHocRoleAttr(role_name=> x_role_name,email_address => Email_Address);
875: end if;
876: --------------Bug No: 7270214-------------------
877: wf_engine.SetItemAttrText (itemtype => itemtype,
878: itemkey => itemkey,
879: aname => 'USER_AD_HOC_ROLE',
880: avalue => x_role_name);
881:

Line 982: l_requester_user_id := wf_engine.GetItemAttrNumber (

978: end if;
979:
980: -- to construct the roleName, we need the organization number
981: -- get the user id and find out what is his/her org number
982: l_requester_user_id := wf_engine.GetItemAttrNumber (
983: itemtype => p_itemtype,
984: itemkey => p_itemkey,
985: aname => 'REQUESTER_USER_ID');
986:

Line 1096: requestType := wf_engine.GetItemAttrText (

1092: resultout := 'COMPLETE:T';
1093:
1094: -- Check to see if the approver is a Universal Approver
1095: -- Get the application id of the requestType
1096: requestType := wf_engine.GetItemAttrText (
1097: itemtype => itemtype,
1098: itemkey => itemkey,
1099: aname => 'REQUEST_TYPE');
1100:

Line 1101: requestId := wf_engine.GetItemAttrNumber (

1097: itemtype => itemtype,
1098: itemkey => itemkey,
1099: aname => 'REQUEST_TYPE');
1100:
1101: requestId := wf_engine.GetItemAttrNumber (
1102: itemtype => itemtype,
1103: itemkey => itemkey,
1104: aname => 'REQUEST_ID');
1105:

Line 1136: wf_engine.SetItemAttrText (

1132: l_approver_username_display := lower (approverUsername);
1133: end if;
1134:
1135: -- We need to update the approver username and id
1136: wf_engine.SetItemAttrText (
1137: itemtype => itemtype,
1138: itemkey => itemkey,
1139: aname => 'APPROVER_USERNAME',
1140: avalue => approverUsername);

Line 1142: wf_engine.SetItemAttrText (

1138: itemkey => itemkey,
1139: aname => 'APPROVER_USERNAME',
1140: avalue => approverUsername);
1141:
1142: wf_engine.SetItemAttrText (
1143: itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'APPROVER_USERNAME_DISPLAY',
1146: avalue => l_approver_username_display);

Line 1148: wf_engine.SetItemAttrNumber (

1144: itemkey => itemkey,
1145: aname => 'APPROVER_USERNAME_DISPLAY',
1146: avalue => l_approver_username_display);
1147:
1148: wf_engine.SetItemAttrNumber (
1149: itemtype => itemtype,
1150: itemkey => itemkey,
1151: aname => 'APPROVER_ID',
1152: avalue => approverID);

Line 1155: requestType := wf_engine.GetItemAttrText (

1151: aname => 'APPROVER_ID',
1152: avalue => approverID);
1153:
1154: -- update the APPROVER_USER_ID in the ****_REG table.
1155: requestType := wf_engine.GetItemAttrText (
1156: itemtype => itemtype,
1157: itemkey => itemkey,
1158: aname => 'REQUEST_TYPE');
1159: if (requestType = 'USERTYPE') then

Line 1296: x_approverID := wf_engine.GetItemAttrNumber (

1292: end if;
1293:
1294: x_resultType := 'OK';
1295: -- Get the APPROVER_ID and APPROVAL_ID
1296: x_approverID := wf_engine.GetItemAttrNumber (
1297: itemtype => x_itemtype,
1298: itemkey => x_itemkey,
1299: aname => 'APPROVER_ID');
1300:

Line 1301: l_approvalID := wf_engine.GetItemAttrNumber (

1297: itemtype => x_itemtype,
1298: itemkey => x_itemkey,
1299: aname => 'APPROVER_ID');
1300:
1301: l_approvalID := wf_engine.GetItemAttrNumber (
1302: itemtype => x_itemtype,
1303: itemkey => x_itemkey,
1304: aname => 'APPROVAL_ID');
1305:

Line 1306: l_requesterUserID := wf_engine.GetItemAttrNumber (

1302: itemtype => x_itemtype,
1303: itemkey => x_itemkey,
1304: aname => 'APPROVAL_ID');
1305:
1306: l_requesterUserID := wf_engine.GetItemAttrNumber (
1307: itemtype => x_itemtype,
1308: itemkey => x_itemkey,
1309: aname => 'REQUESTER_USER_ID');
1310:

Line 1311: l_requestType := wf_engine.GetItemAttrText (

1307: itemtype => x_itemtype,
1308: itemkey => x_itemkey,
1309: aname => 'REQUESTER_USER_ID');
1310:
1311: l_requestType := wf_engine.GetItemAttrText (
1312: itemtype => x_itemtype,
1313: itemkey => x_itemkey,
1314: aname => 'REQUEST_TYPE');
1315:

Line 1413: requestType := wf_engine.GetItemAttrText (

1409: --
1410: -- RUN mode - normal process execution
1411: --
1412: if (funcmode = 'RUN') then
1413: requestType := wf_engine.GetItemAttrText (
1414: itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'REQUEST_TYPE');
1417: if (requestType = 'USERTYPE') then

Line 1542: ownerUsername := wf_engine.GetItemAttrText (

1538: cancel_notification (itemtype, itemkey);
1539:
1540: -- The result of the request has not been decided
1541: -- Forward the request to the owner of this process.
1542: ownerUsername := wf_engine.GetItemAttrText (
1543: itemtype => itemtype,
1544: itemkey => itemkey,
1545: aname => 'OWNER_USERNAME');
1546:

Line 1548: wf_engine.SetItemAttrText (

1544: itemkey => itemkey,
1545: aname => 'OWNER_USERNAME');
1546:
1547: -- This is for the next activity in the workflow, can_delegate.
1548: wf_engine.SetItemAttrText (
1549: itemtype => itemtype,
1550: itemkey => itemkey,
1551: aname => 'APPROVER_USERNAME',
1552: avalue => ownerUsername);

Line 1559: requestType := wf_engine.GetItemAttrText (

1555: fetch getUserID into ownerUserID;
1556: close getUserID;
1557:
1558: -- Get the requestType.
1559: requestType := wf_engine.GetItemAttrText (
1560: itemtype => itemtype,
1561: itemkey => itemkey,
1562: aname => 'REQUEST_TYPE');
1563:

Line 1620: requestResult := wf_engine.GetItemAttrText (

1616: --
1617: -- RUN mode - normal process execution
1618: --
1619: if (funcmode = 'RUN') then
1620: requestResult := wf_engine.GetItemAttrText (
1621: itemtype => itemtype,
1622: itemkey => itemkey,
1623: aname => 'REQUEST_RESULT');
1624:

Line 1685: where USER_NAME = WF_ENGINE.context_text;

1681:
1682: cursor getUserID is
1683: select USER_ID
1684: from FND_USER
1685: where USER_NAME = WF_ENGINE.context_text;
1686: --
1687: begin
1688:
1689: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering post_notification (' ||

Line 1706: p_user_name => WF_ENGINE.context_text,

1702: -- Check if the user is the SYSADMIN
1703: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1704: x_flag => l_permission_flag,
1705: x_return_status => l_return_status,
1706: p_user_name => WF_ENGINE.context_text,
1707: p_permission_name => 'JTF_REG_APPROVAL');
1708: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1709: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1710: end if;

Line 1717: p_user_name => WF_ENGINE.context_text,

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

Line 1729: p_user_name => WF_ENGINE.context_text,

1725: -- Not a Primary User, check if the user is an Owner
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_APPROVER');
1731: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1732: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1733: end if;

Line 1742: requestType := wf_engine.GetItemAttrText (

1738: fnd_message.set_name ('JTF', 'JTF_APPROVAL_PERMISSION');
1739: raise_application_error (-20000, fnd_message.get);
1740: else
1741: -- Get the requestType.
1742: requestType := wf_engine.GetItemAttrText (
1743: itemtype => itemtype,
1744: itemkey => itemkey,
1745: aname => 'REQUEST_TYPE');
1746: --

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

1803: --
1804: if (funcmode = 'RUN') then
1805:
1806: -- Save the Grant Delegation Flag
1807: l_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
1808: itemkey => itemkey,
1809: aname => 'DELEGATION_FLAG');
1810:
1811: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1807: l_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
1808: itemkey => itemkey,
1809: aname => 'DELEGATION_FLAG');
1810:
1811: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1812: itemkey => itemkey,
1813: aname => 'REQUEST_ID');
1814:
1815: l_requesterUserID := wf_engine.GetItemAttrNumber (

Line 1815: l_requesterUserID := wf_engine.GetItemAttrNumber (

1811: l_request_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1812: itemkey => itemkey,
1813: aname => 'REQUEST_ID');
1814:
1815: l_requesterUserID := wf_engine.GetItemAttrNumber (
1816: itemtype => itemtype,
1817: itemkey => itemkey,
1818: aname => 'REQUESTER_USER_ID');
1819:

Line 1906: requesterUserID := wf_engine.GetItemAttrNumber (

1902: if itemkey is null then
1903: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');
1904: end if;
1905:
1906: requesterUserID := wf_engine.GetItemAttrNumber (
1907: itemtype => itemtype,
1908: itemkey => itemkey,
1909: aname => 'REQUESTER_USER_ID');
1910:

Line 1911: requestType := wf_engine.GetItemAttrText (

1907: itemtype => itemtype,
1908: itemkey => itemkey,
1909: aname => 'REQUESTER_USER_ID');
1910:
1911: requestType := wf_engine.GetItemAttrText (
1912: itemtype => itemtype,
1913: itemkey => itemkey,
1914: aname => 'REQUEST_TYPE');
1915:

Line 1916: requestID := wf_engine.GetItemAttrNumber (

1912: itemtype => itemtype,
1913: itemkey => itemkey,
1914: aname => 'REQUEST_TYPE');
1915:
1916: requestID := wf_engine.GetItemAttrNumber (
1917: itemtype => itemtype,
1918: itemkey => itemkey,
1919: aname => 'REQUEST_ID');
1920:

Line 1921: approverComment := wf_engine.GetItemAttrText (

1917: itemtype => itemtype,
1918: itemkey => itemkey,
1919: aname => 'REQUEST_ID');
1920:
1921: approverComment := wf_engine.GetItemAttrText (
1922: itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'APPROVER_COMMENT');
1925:

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

1960:
1961: for enrollAppRegRow in enrollmentApprovalCursor loop
1962: -- Launch workflow created during registration.
1963: if Not hasWorkFlowStarted(enrollAppRegRow.WF_ITEM_TYPE,to_char(enrollAppRegRow.SUBSCRIPTION_REG_ID)) then
1964: wf_engine.StartProcess (itemtype => enrollAppRegRow.WF_ITEM_TYPE,
1965: itemkey => to_char(enrollAppRegRow.SUBSCRIPTION_REG_ID));
1966: end if;
1967:
1968: end loop;

Line 2120: requestType := wf_engine.GetItemAttrText (

2116: --
2117: -- RUN mode - normal process execution
2118: --
2119: if (funcmode = 'RUN') then
2120: requestType := wf_engine.GetItemAttrText (
2121: itemtype => itemtype,
2122: itemkey => itemkey,
2123: aname => 'REQUEST_TYPE');
2124:

Line 2125: requesterUserID := wf_engine.GetItemAttrNumber (

2121: itemtype => itemtype,
2122: itemkey => itemkey,
2123: aname => 'REQUEST_TYPE');
2124:
2125: requesterUserID := wf_engine.GetItemAttrNumber (
2126: itemtype => itemtype,
2127: itemkey => itemkey,
2128: aname => 'REQUESTER_USER_ID');
2129:

Line 2130: approverComment := wf_engine.GetItemAttrText (

2126: itemtype => itemtype,
2127: itemkey => itemkey,
2128: aname => 'REQUESTER_USER_ID');
2129:
2130: approverComment := wf_engine.GetItemAttrText (
2131: itemtype => itemtype,
2132: itemkey => itemkey,
2133: aname => 'APPROVER_COMMENT');
2134:

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

2152: for enrollRegRow in enrollmentsCursor
2153: loop
2154: -- Abort all Workflow Enrollment
2155: --if (enrollRegRow.WF_ITEM_TYPE is not null) then
2156: -- wf_engine.AbortProcess (itemtype => enrollRegRow.WF_ITEM_TYPE,
2157: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2158: --end if;
2159:
2160: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'

Line 2320: l_approver_username := wf_engine.GetItemAttrText (

2316: resultout := 'COMPLETE:N';
2317:
2318: if (funcmode = 'RUN') then
2319: -- Get the Approver User ID
2320: l_approver_username := wf_engine.GetItemAttrText (
2321: itemtype => itemtype,
2322: itemkey => itemkey,
2323: aname => 'APPROVER_USERNAME');
2324:

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

2337: X_RESULT => l_result);
2338:
2339: if (l_result = JTF_UM_WF_DELEGATION_PVT.CHECKED_UPDATE) then
2340: -- Grant Delegation Flag is set to Yes.
2341: wf_engine.SetItemAttrText (itemtype => itemtype,
2342: itemkey => itemkey,
2343: aname => 'DELEGATION_FLAG',
2344: avalue => 'Y');
2345: resultout := 'COMPLETE:Y';

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

2345: resultout := 'COMPLETE:Y';
2346:
2347: elsif (l_result = JTF_UM_WF_DELEGATION_PVT.NOT_CHECKED_UPDATE) then
2348: -- Grant Delegation Flag is set to No.
2349: wf_engine.SetItemAttrText (itemtype => itemtype,
2350: itemkey => itemkey,
2351: aname => 'DELEGATION_FLAG',
2352: avalue => 'N');
2353: resultout := 'COMPLETE:Y';

Line 2409: l_requester_usertype_id := wf_engine.GetItemAttrNumber (

2405: --
2406:
2407: if (funcmode = 'RUN') then
2408: -- Get the Requester Usertype ID
2409: l_requester_usertype_id := wf_engine.GetItemAttrNumber (
2410: itemtype => itemtype,
2411: itemkey => itemkey,
2412: aname => 'REQUESTER_USERTYPE_ID');
2413:

Line 2415: l_request_id := wf_engine.GetItemAttrNumber(

2411: itemkey => itemkey,
2412: aname => 'REQUESTER_USERTYPE_ID');
2413:
2414: -- Get the Request ID
2415: l_request_id := wf_engine.GetItemAttrNumber(
2416: itemtype => itemtype,
2417: itemkey => itemkey,
2418: aname => 'REQUEST_ID');
2419:

Line 2490: l_approver_username := wf_engine.GetItemAttrText (

2486: --
2487:
2488: if (funcmode = 'RUN') then
2489: -- Get the Current Approver Username
2490: l_approver_username := wf_engine.GetItemAttrText (
2491: itemtype => itemtype,
2492: itemkey => itemkey,
2493: aname => 'APPROVER_USERNAME');
2494:

Line 2496: l_request_type := wf_engine.GetItemAttrText (

2492: itemkey => itemkey,
2493: aname => 'APPROVER_USERNAME');
2494:
2495: -- Get the profile option of Universal Approvers
2496: l_request_type := wf_engine.GetItemAttrText (
2497: itemtype => itemtype,
2498: itemkey => itemkey,
2499: aname => 'REQUEST_TYPE');
2500:

Line 2501: l_request_id := wf_engine.GetItemAttrNumber (

2497: itemtype => itemtype,
2498: itemkey => itemkey,
2499: aname => 'REQUEST_TYPE');
2500:
2501: l_request_id := wf_engine.GetItemAttrNumber (
2502: itemtype => itemtype,
2503: itemkey => itemkey,
2504: aname => 'REQUEST_ID');
2505:

Line 2506: l_requester_user_id := wf_engine.GetItemAttrNumber (

2502: itemtype => itemtype,
2503: itemkey => itemkey,
2504: aname => 'REQUEST_ID');
2505:
2506: l_requester_user_id := wf_engine.GetItemAttrNumber (
2507: itemtype => itemtype,
2508: itemkey => itemkey,
2509: aname => 'REQUESTER_USER_ID');
2510:

Line 2583: usertypeID := wf_engine.GetItemAttrNumber (

2579: -- RUN mode - normal process execution
2580: --
2581:
2582: if (funcmode = 'RUN') then
2583: usertypeID := wf_engine.GetItemAttrNumber (
2584: itemtype => itemtype,
2585: itemkey => itemkey,
2586: aname => 'REQUESTER_USERTYPE_ID');
2587:

Line 2602: requestType := wf_engine.GetItemAttrText (

2598:
2599: else
2600: -- We will send email out.
2601:
2602: requestType := wf_engine.GetItemAttrText (
2603: itemtype => itemtype,
2604: itemkey => itemkey,
2605: aname => 'REQUEST_TYPE');
2606:

Line 2731: request_type := wf_engine.GetItemAttrText (

2727: raise_application_error (-20000, 'resultCode is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2728: end if;
2729:
2730: -- Check Request type
2731: request_type := wf_engine.GetItemAttrText (
2732: itemtype => itemtype,
2733: itemkey => itemkey,
2734: aname => 'REQUEST_TYPE');
2735:

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

2785: end if;
2786:
2787: -- Set the delegation flag
2788: if (delegationFlag is not null) then
2789: wf_engine.SetItemAttrText (itemtype => itemtype,
2790: itemkey => itemkey,
2791: aname => 'DELEGATION_FLAG',
2792: avalue => delegationFlag);
2793: end if;

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

2910: ',' || p_itemkey || ',' || p_resultCode || ',' || p_approverComment ||
2911: ',' || p_act1 || ',' || p_act2 || ',' || p_act3 || ',' || p_act4 ||
2912: ',' || p_act5 || ',' || p_act6 || ') API');
2913:
2914: wf_engine.SetItemAttrText (itemtype => p_itemtype,
2915: itemkey => p_itemkey,
2916: aname => 'APPROVER_COMMENT',
2917: avalue => p_approverComment);
2918:

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

2915: itemkey => p_itemkey,
2916: aname => 'APPROVER_COMMENT',
2917: avalue => p_approverComment);
2918:
2919: wf_engine.SetItemAttrText (itemtype => p_itemtype,
2920: itemkey => p_itemkey,
2921: aname => 'REQUEST_RESULT',
2922: avalue => p_resultCode);
2923:

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

2921: aname => 'REQUEST_RESULT',
2922: avalue => p_resultCode);
2923:
2924: -- Find out what kind of request type is it
2925: requestType := wf_engine.GetItemAttrText (itemtype => p_itemtype,
2926: itemkey => p_itemkey,
2927: aname => 'REQUEST_TYPE');
2928:
2929: if (p_act1 is not null) then

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

2928:
2929: if (p_act1 is not null) then
2930: begin
2931: act := p_act1;
2932: wf_engine.BeginActivity (itemtype => p_itemtype,
2933: itemkey => p_itemkey,
2934: activity => act);
2935: OK := TRUE;
2936: exception

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

2941:
2942: if (not OK) and (p_act2 is not null) then
2943: begin
2944: act := p_act2;
2945: wf_engine.BeginActivity (itemtype => p_itemtype,
2946: itemkey => p_itemkey,
2947: activity => act);
2948: OK := TRUE;
2949: exception

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

2954:
2955: if (not OK) and (p_act3 is not null) then
2956: begin
2957: act := p_act3;
2958: wf_engine.BeginActivity (itemtype => p_itemtype,
2959: itemkey => p_itemkey,
2960: activity => act);
2961: OK := TRUE;
2962: exception

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

2967:
2968: if (not OK) and (p_act4 is not null) then
2969: begin
2970: act := p_act4;
2971: wf_engine.BeginActivity (itemtype => p_itemtype,
2972: itemkey => p_itemkey,
2973: activity => act);
2974: OK := TRUE;
2975: exception

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

2980:
2981: if (not OK) and (p_act5 is not null) then
2982: begin
2983: act := p_act5;
2984: wf_engine.BeginActivity (itemtype => p_itemtype,
2985: itemkey => p_itemkey,
2986: activity => act);
2987: OK := TRUE;
2988: exception

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

2993:
2994: if (not OK) and (p_act6 is not null) then
2995: begin
2996: act := p_act6;
2997: wf_engine.BeginActivity (itemtype => p_itemtype,
2998: itemkey => p_itemkey,
2999: activity => act);
3000: OK := TRUE;
3001: exception

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

3005: end if;
3006:
3007: if OK then
3008:
3009: wf_engine.CompleteActivity (p_itemtype, p_itemkey, act, wf_resultCode);
3010:
3011: else
3012:
3013: raise_application_error (-20000, 'No Activity Found Failed at JTF_UM_WF_APPROVAL.Do_Complete_Approval_Activity ('

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

3049: if p_itemtype is null then
3050: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.abort_process.');
3051: end if;
3052:
3053: wf_engine.ItemStatus (p_itemtype, p_itemkey, status, result);
3054: if (status <> 'COMPLETE') then
3055: -- need to cancel any open notification
3056: cancel_notification (p_itemtype, p_itemkey);
3057: -- now call the workflow abort process

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

3054: if (status <> 'COMPLETE') then
3055: -- need to cancel any open notification
3056: cancel_notification (p_itemtype, p_itemkey);
3057: -- now call the workflow abort process
3058: wf_engine.abortprocess (itemtype => p_itemtype,
3059: itemkey => p_itemkey);
3060: end if;
3061:
3062: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting abort_process API');

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

3466: fetch check_usertype_status into p_usertype_status;
3467: close check_usertype_status;
3468:
3469: if (p_usertype_status = 'APPROVED') then
3470: wf_engine.startProcess (itemType => p_wf_new_item_type,
3471: itemKey => p_new_item_key);
3472: end if;
3473: end if;
3474: end loop;

Line 3585: p_approver_comment := wf_engine.GetItemAttrText (

3581: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3582: 'Entering get_approver_comment (' || p_reg_id || ',' ||
3583: p_wf_item_type || ') API');
3584:
3585: p_approver_comment := wf_engine.GetItemAttrText (
3586: itemtype => p_wf_item_type,
3587: itemkey => to_char(p_reg_id),
3588: aname => 'APPROVER_COMMENT');
3589: