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

Line 477: WF_ENGINE.SetItemAttrText

473: ||l_msg_data||fnd_global.local_chr(10) ;
474: l_cnt := l_cnt + 1 ;
475: END LOOP ;
476: x_error_msg := l_final_data;
477: WF_ENGINE.SetItemAttrText
478: (itemtype => p_itemtype,
479: itemkey => p_itemkey ,
480: aname => p_attr_name,
481: avalue => l_final_data );

Line 483: l_appr_meaning := wf_engine.GetItemAttrText(

479: itemkey => p_itemkey ,
480: aname => p_attr_name,
481: avalue => l_final_data );
482: --
483: l_appr_meaning := wf_engine.GetItemAttrText(
484: itemtype => p_itemtype,
485: itemkey => p_itemkey,
486: aname => 'AMS_APPROVAL_OBJECT_MEANING');
487:

Line 488: l_appr_obj_name := wf_engine.GetItemAttrText(

484: itemtype => p_itemtype,
485: itemkey => p_itemkey,
486: aname => 'AMS_APPROVAL_OBJECT_MEANING');
487:
488: l_appr_obj_name := wf_engine.GetItemAttrText(
489: itemtype => p_itemtype,
490: itemkey => p_itemkey,
491: aname => 'AMS_APPROVAL_OBJECT_NAME');
492: --

Line 499: Wf_Engine.SetItemAttrText

495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
496:
497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);
498:
499: Wf_Engine.SetItemAttrText
500: (itemtype => p_itemtype,
501: itemkey => p_itemkey ,
502: aname => 'ERR_SUBJECT',
503: avalue => l_gen_err_sub );

Line 904: l_save_threshold NUMBER := wf_engine.threshold;

900: l_msg_data VARCHAR2(4000);
901: l_error_msg VARCHAR2(4000);
902: x_resource_id NUMBER;
903: l_index NUMBER;
904: l_save_threshold NUMBER := wf_engine.threshold;
905: -- [BEGIN OF BUG2631497 FIXING by mchang 23-OCT-2002]
906: l_user_id NUMBER;
907: l_resp_id NUMBER;
908: l_appl_id NUMBER;

Line 947: -- wf_engine.threshold := -1;

943:
944: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype
945: ||' Item key : '||itemkey);
946:
947: -- wf_engine.threshold := -1;
948: WF_ENGINE.CreateProcess (itemtype => itemtype,
949: itemkey => itemkey ,
950: process => p_workflowprocess);
951:

Line 948: WF_ENGINE.CreateProcess (itemtype => itemtype,

944: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype
945: ||' Item key : '||itemkey);
946:
947: -- wf_engine.threshold := -1;
948: WF_ENGINE.CreateProcess (itemtype => itemtype,
949: itemkey => itemkey ,
950: process => p_workflowprocess);
951:
952: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

Line 952: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

948: WF_ENGINE.CreateProcess (itemtype => itemtype,
949: itemkey => itemkey ,
950: process => p_workflowprocess);
951:
952: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
953: itemkey => itemkey ,
954: userkey => itemuserkey);
955:
956:

Line 970: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

966: l_resp_id := FND_GLOBAL.resp_id;
967: l_appl_id := FND_GLOBAL.resp_appl_id;
968: l_security_group_id := FND_GLOBAL.security_group_id;
969:
970: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
971: itemkey => itemkey,
972: aname => 'USER_ID',
973: avalue => l_user_id
974: );

Line 976: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

972: aname => 'USER_ID',
973: avalue => l_user_id
974: );
975:
976: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
977: itemkey => itemkey,
978: aname => 'RESPONSIBILITY_ID',
979: avalue => l_resp_id
980: );

Line 982: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

978: aname => 'RESPONSIBILITY_ID',
979: avalue => l_resp_id
980: );
981:
982: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
983: itemkey => itemkey,
984: aname => 'APPLICATION_ID',
985: avalue => l_appl_id
986: );

Line 988: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

984: aname => 'APPLICATION_ID',
985: avalue => l_appl_id
986: );
987:
988: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
989: itemkey => itemkey,
990: aname => 'SECURITY_GROUP_ID',
991: avalue => l_security_group_id -- was l_appl_id
992: );

Line 997: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

993: -- [END OF BUG2631497 FIXING]
994:
995:
996: -- Activity Type (Some of valid values are 'CAMP','DELV','EVEH','EVEO'..);
997: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
998: itemkey => itemkey,
999: aname => 'AMS_ACTIVITY_TYPE',
1000: avalue => p_activity_type );
1001:

Line 1003: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

999: aname => 'AMS_ACTIVITY_TYPE',
1000: avalue => p_activity_type );
1001:
1002: -- Activity ID (primary Id of Activity Object)
1003: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1004: itemkey => itemkey,
1005: aname => 'AMS_ACTIVITY_ID',
1006: avalue => p_activity_id );
1007:

Line 1011: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

1007:
1008:
1009: -- Original Status Id (If error occurs we have to revert back to this
1010: -- status )
1011: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
1012: itemkey => itemkey,
1013: aname => 'AMS_ORIG_STAT_ID',
1014: avalue => p_orig_stat_id );
1015:

Line 1018: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

1014: avalue => p_orig_stat_id );
1015:
1016: -- New Status Id (If activity is approved status of activity is updated
1017: -- by this status )
1018: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
1019: itemkey => itemkey,
1020: aname => 'AMS_NEW_STAT_ID',
1021: avalue => p_new_stat_id );
1022:

Line 1025: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

1021: avalue => p_new_stat_id );
1022:
1023: -- Reject Status Id (If activity is approved status of activity is rejected
1024: -- by this status )
1025: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
1026: itemkey => itemkey,
1027: aname => 'AMS_REJECT_STAT_ID',
1028: avalue => p_reject_stat_id );
1029:

Line 1032: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

1028: avalue => p_reject_stat_id );
1029:
1030:
1031: -- Object Version Number
1032: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
1033: itemkey => itemkey,
1034: aname => 'AMS_OBJECT_VERSION_NUMBER',
1035: avalue => p_object_version_number );
1036:

Line 1038: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1034: aname => 'AMS_OBJECT_VERSION_NUMBER',
1035: avalue => p_object_version_number );
1036:
1037: -- Notes from the requester
1038: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1039: itemkey => itemkey,
1040: aname => 'AMS_NOTES_FROM_REQUESTOR',
1041: avalue => nvl(p_notes_from_requester,'') );
1042:

Line 1043: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1039: itemkey => itemkey,
1040: aname => 'AMS_NOTES_FROM_REQUESTOR',
1041: avalue => nvl(p_notes_from_requester,'') );
1042:
1043: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1044: itemkey => itemkey,
1045: aname => 'DOCUMENT_ID',
1046: avalue => itemtype || ':' ||itemkey);
1047:

Line 1048: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

1044: itemkey => itemkey,
1045: aname => 'DOCUMENT_ID',
1046: avalue => itemtype || ':' ||itemkey);
1047:
1048: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
1049: itemkey => itemkey,
1050: aname => 'AMS_REQUESTER_ID',
1051: avalue => p_requester_userid );
1052:

Line 1056: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

1052:
1053: l_return_status := FND_API.G_RET_STS_SUCCESS;
1054:
1055:
1056: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1057: itemkey => itemkey,
1058: aname => 'AMS_APPROVAL_TYPE',
1059: avalue => p_approval_type );
1060:

Line 1072: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070:
1071:
1072: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1073: itemkey => itemkey,
1074: aname => 'AMS_REQUESTER',
1075: avalue => l_requester_role );
1076:

Line 1078: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

1074: aname => 'AMS_REQUESTER',
1075: avalue => l_requester_role );
1076:
1077: /* genric flag requested by mumu.*/
1078: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1079: itemkey => itemkey,
1080: aname => 'AMS_GENERIC_FLAG',
1081: avalue => p_gen_process_flag );
1082:

Line 1083: WF_ENGINE.SetItemOwner(itemtype => itemtype,

1079: itemkey => itemkey,
1080: aname => 'AMS_GENERIC_FLAG',
1081: avalue => p_gen_process_flag );
1082:
1083: WF_ENGINE.SetItemOwner(itemtype => itemtype,
1084: itemkey => itemkey,
1085: owner => l_requester_role);
1086:
1087:

Line 1089: WF_ENGINE.StartProcess (itemtype => itemtype,

1085: owner => l_requester_role);
1086:
1087:
1088: -- Start the Process
1089: WF_ENGINE.StartProcess (itemtype => itemtype,
1090: itemkey => itemkey);
1091:
1092:
1093: -- Create the Submitted history record

Line 1120: -- wf_engine.threshold := l_save_threshold ;

1116:
1117: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1118: RAISE Fnd_Api.G_EXC_ERROR;
1119: END IF;
1120: -- wf_engine.threshold := l_save_threshold ;
1121: EXCEPTION
1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: -- wf_engine.threshold := l_save_threshold ;

Line 1124: -- wf_engine.threshold := l_save_threshold ;

1120: -- wf_engine.threshold := l_save_threshold ;
1121: EXCEPTION
1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: -- wf_engine.threshold := l_save_threshold ;
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => l_msg_count,
1128: p_data => l_msg_data);

Line 1155: -- wf_engine.threshold := l_save_threshold ;

1151: wf_core.context ('ams_gen_approval_pvt', 'StartProcess',p_activity_type
1152: ,p_activity_id ,l_error_msg);
1153: RAISE;
1154: WHEN OTHERS THEN
1155: -- wf_engine.threshold := l_save_threshold ;
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => l_msg_count,
1159: p_data => l_msg_data);

Line 1224: l_activity_id := wf_engine.GetItemAttrNumber(

1220: BEGIN
1221: FND_MSG_PUB.initialize();
1222: IF (funcmode = 'RUN') THEN
1223: -- get the acitvity id
1224: l_activity_id := wf_engine.GetItemAttrNumber(
1225: itemtype => itemtype,
1226: itemkey => itemkey,
1227: aname => 'AMS_ACTIVITY_ID' );
1228:

Line 1230: l_activity_type := wf_engine.GetItemAttrText(

1226: itemkey => itemkey,
1227: aname => 'AMS_ACTIVITY_ID' );
1228:
1229: -- get the activity type
1230: l_activity_type := wf_engine.GetItemAttrText(
1231: itemtype => itemtype,
1232: itemkey => itemkey,
1233: aname => 'AMS_ACTIVITY_TYPE' );
1234:

Line 1235: l_approval_type := wf_engine.GetItemAttrText(

1231: itemtype => itemtype,
1232: itemkey => itemkey,
1233: aname => 'AMS_ACTIVITY_TYPE' );
1234:
1235: l_approval_type := wf_engine.GetItemAttrText(
1236: itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => 'AMS_APPROVAL_TYPE' );
1239:

Line 1396: l_approval_detail_id := wf_engine.GetItemAttrNumber(

1392:
1393: BEGIN
1394: FND_MSG_PUB.initialize();
1395: IF (funcmode = 'RUN') THEN
1396: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1397: itemtype => itemtype,
1398: itemkey => itemkey,
1399: aname => 'AMS_APPROVAL_DETAIL_ID' );
1400:

Line 1401: l_current_seq := wf_engine.GetItemAttrText(

1397: itemtype => itemtype,
1398: itemkey => itemkey,
1399: aname => 'AMS_APPROVAL_DETAIL_ID' );
1400:
1401: l_current_seq := wf_engine.GetItemAttrText(
1402: itemtype => itemtype,
1403: itemkey => itemkey,
1404: aname => 'AMS_APPROVER_SEQ' );
1405:

Line 1408: l_activity_id := Wf_Engine.GetItemAttrNumber(

1404: aname => 'AMS_APPROVER_SEQ' );
1405:
1406: -- 11.5.9
1407:
1408: l_activity_id := Wf_Engine.GetItemAttrNumber(
1409: itemtype => itemtype,
1410: itemkey => itemkey,
1411: aname => 'AMS_ACTIVITY_ID' );
1412:

Line 1413: l_activity_type := Wf_Engine.GetItemAttrText(

1409: itemtype => itemtype,
1410: itemkey => itemkey,
1411: aname => 'AMS_ACTIVITY_ID' );
1412:
1413: l_activity_type := Wf_Engine.GetItemAttrText(
1414: itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'AMS_ACTIVITY_TYPE' );
1417:

Line 1418: l_version := Wf_Engine.GetItemAttrNumber(

1414: itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'AMS_ACTIVITY_TYPE' );
1417:
1418: l_version := Wf_Engine.GetItemAttrNumber(
1419: itemtype => itemtype,
1420: itemkey => itemkey,
1421: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1422:

Line 1423: l_approval_type := Wf_Engine.GetItemAttrText(

1419: itemtype => itemtype,
1420: itemkey => itemkey,
1421: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1422:
1423: l_approval_type := Wf_Engine.GetItemAttrText(
1424: itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => 'AMS_APPROVAL_TYPE' );
1427:

Line 1516: l_prev_approver_disp_name := wf_engine.GetItemAttrText(

1512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515: -- Change for Bug 2535600
1516: l_prev_approver_disp_name := wf_engine.GetItemAttrText(
1517: itemtype => itemtype,
1518: itemkey => itemkey,
1519: aname => 'AMS_APPROVER_DISPLAY_NAME' );
1520:

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

1518: itemkey => itemkey,
1519: aname => 'AMS_APPROVER_DISPLAY_NAME' );
1520:
1521: -- Added for Bug 2535600
1522: wf_engine.SetItemAttrText( itemtype => itemtype,
1523: itemkey => itemkey,
1524: aname => 'AMS_PREV_APPROVER_DISP_NAME',
1525: avalue => l_prev_approver_disp_name);
1526:

Line 1527: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

1523: itemkey => itemkey,
1524: aname => 'AMS_PREV_APPROVER_DISP_NAME',
1525: avalue => l_prev_approver_disp_name);
1526:
1527: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname => 'APPROVAL_NOTE');
1530:
1531: wf_engine.SetItemAttrText( itemtype => itemtype,

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

1527: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname => 'APPROVAL_NOTE');
1530:
1531: wf_engine.SetItemAttrText( itemtype => itemtype,
1532: itemkey => itemkey,
1533: aname => 'AMS_PREV_APPROVER_NOTE',
1534: avalue => l_note);
1535:

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

1533: aname => 'AMS_PREV_APPROVER_NOTE',
1534: avalue => l_note);
1535:
1536: -- Need to be set to null or else it consolidates notes
1537: wf_engine.SetItemAttrText( itemtype => itemtype,
1538: itemkey => itemkey,
1539: aname => 'APPROVAL_NOTE',
1540: avalue => null);
1541:

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

1538: itemkey => itemkey,
1539: aname => 'APPROVAL_NOTE',
1540: avalue => null);
1541:
1542: wf_engine.SetItemAttrText( itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'AMS_APPROVER_DISPLAY_NAME',
1545: avalue => l_approver_display_name);
1546: -- End of 2535600

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

1545: avalue => l_approver_display_name);
1546: -- End of 2535600
1547:
1548:
1549: wf_engine.SetItemAttrText( itemtype => itemtype,
1550: itemkey => itemkey,
1551: aname => 'AMS_APPROVER',
1552: avalue => l_approver);
1553:

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

1550: itemkey => itemkey,
1551: aname => 'AMS_APPROVER',
1552: avalue => l_approver);
1553:
1554: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1555: itemkey => itemkey,
1556: aname => 'AMS_APPROVER_ID',
1557: avalue => l_object_approver_id);
1558:

Line 1682: l_approval_detail_id := wf_engine.GetItemAttrNumber(

1678: l_appr_display_name VARCHAR2(360);
1679: BEGIN
1680: FND_MSG_PUB.initialize();
1681: IF (funcmode = 'RUN') THEN
1682: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1683: itemtype => itemtype,
1684: itemkey => itemkey,
1685: aname => 'AMS_APPROVAL_DETAIL_ID' );
1686:

Line 1687: l_current_seq := wf_engine.GetItemAttrText(

1683: itemtype => itemtype,
1684: itemkey => itemkey,
1685: aname => 'AMS_APPROVAL_DETAIL_ID' );
1686:
1687: l_current_seq := wf_engine.GetItemAttrText(
1688: itemtype => itemtype,
1689: itemkey => itemkey,
1690: aname => 'AMS_APPROVER_SEQ' );
1691:

Line 1692: l_approver_id := wf_engine.GetItemAttrNumber(

1688: itemtype => itemtype,
1689: itemkey => itemkey,
1690: aname => 'AMS_APPROVER_SEQ' );
1691:
1692: l_approver_id := wf_engine.GetItemAttrNumber(
1693: itemtype => itemtype,
1694: itemkey => itemkey,
1695: aname => 'AMS_APPROVER_ID' );
1696:

Line 1697: l_activity_id := wf_engine.GetItemAttrNumber(

1693: itemtype => itemtype,
1694: itemkey => itemkey,
1695: aname => 'AMS_APPROVER_ID' );
1696:
1697: l_activity_id := wf_engine.GetItemAttrNumber(
1698: itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => 'AMS_ACTIVITY_ID' );
1701:

Line 1702: l_activity_type := wf_engine.GetItemAttrText(

1698: itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => 'AMS_ACTIVITY_ID' );
1701:
1702: l_activity_type := wf_engine.GetItemAttrText(
1703: itemtype => itemtype,
1704: itemkey => itemkey,
1705: aname => 'AMS_ACTIVITY_TYPE' );
1706:

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

1705: aname => 'AMS_ACTIVITY_TYPE' );
1706:
1707: -- Added for 11.5.9
1708: -- Bug 2535600
1709: wf_engine.SetItemAttrText( itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'AMS_APPROVAL_DATE',
1712: avalue => trunc(sysdate));
1713:

Line 1714: l_version := Wf_Engine.GetItemAttrNumber(

1710: itemkey => itemkey,
1711: aname => 'AMS_APPROVAL_DATE',
1712: avalue => trunc(sysdate));
1713:
1714: l_version := Wf_Engine.GetItemAttrNumber(
1715: itemtype => itemtype,
1716: itemkey => itemkey,
1717: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1718:

Line 1719: l_approval_type := Wf_Engine.GetItemAttrText(

1715: itemtype => itemtype,
1716: itemkey => itemkey,
1717: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1718:
1719: l_approval_type := Wf_Engine.GetItemAttrText(
1720: itemtype => itemtype,
1721: itemkey => itemkey,
1722: aname => 'AMS_APPROVAL_TYPE' );
1723:

Line 1724: l_note := Wf_Engine.GetItemAttrText(

1720: itemtype => itemtype,
1721: itemkey => itemkey,
1722: aname => 'AMS_APPROVAL_TYPE' );
1723:
1724: l_note := Wf_Engine.GetItemAttrText(
1725: itemtype => itemtype,
1726: itemkey => itemkey,
1727: aname => 'APPROVAL_NOTE' );
1728:

Line 1731: l_forward_nid := Wf_Engine.GetItemAttrNumber(

1727: aname => 'APPROVAL_NOTE' );
1728:
1729: -- Start of addition for forward/reassign notification
1730:
1731: l_forward_nid := Wf_Engine.GetItemAttrNumber(
1732: itemtype => itemtype,
1733: itemkey => itemkey,
1734: aname => 'AMS_FORWARD_NID' );
1735: -- Commented for 3150550

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

1747: RAISE Fnd_Api.G_EXC_ERROR;
1748: END IF;
1749:
1750: -- Set the WF Attributes
1751: wf_engine.SetItemAttrText( itemtype => itemtype,
1752: itemkey => itemkey,
1753: aname => 'AMS_APPROVER',
1754: avalue => l_responder);
1755:

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

1753: aname => 'AMS_APPROVER',
1754: avalue => l_responder);
1755:
1756:
1757: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1758: itemkey => itemkey,
1759: aname => 'AMS_APPROVER_ID',
1760: avalue => l_approver_id);
1761:

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

1759: aname => 'AMS_APPROVER_ID',
1760: avalue => l_approver_id);
1761:
1762:
1763: wf_engine.SetItemAttrText( itemtype => itemtype,
1764: itemkey => itemkey,
1765: aname => 'AMS_APPROVER_DISPLAY_NAME',
1766: avalue => l_appr_display_name);
1767:

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

1767:
1768: -- Reset the forward_nid wf attribute to null
1769: -- This is a must
1770:
1771: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1772: itemkey => itemkey,
1773: aname => 'AMS_FORWARD_NID',
1774: avalue => null);
1775: END IF;

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

1806: p_current_seq => l_current_seq,
1807: x_next_seq => l_next_seq,
1808: x_required_flag => l_required_flag);
1809: IF l_next_seq is not null THEN
1810: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1811: itemkey => itemkey,
1812: aname => 'AMS_APPROVER_SEQ',
1813: avalue => l_next_seq);
1814: resultout := 'COMPLETE:Y';

Line 1913: l_activity_id := wf_engine.GetItemAttrNumber(

1909: -- RUN mode
1910: --
1911: IF (funcmode = 'RUN') THEN
1912: -- get the acitvity id
1913: l_activity_id := wf_engine.GetItemAttrNumber(
1914: itemtype => itemtype,
1915: itemkey => itemkey,
1916: aname => 'AMS_ACTIVITY_ID' );
1917:

Line 1919: l_activity_type := wf_engine.GetItemAttrText(

1915: itemkey => itemkey,
1916: aname => 'AMS_ACTIVITY_ID' );
1917:
1918: -- get the activity type
1919: l_activity_type := wf_engine.GetItemAttrText(
1920: itemtype => itemtype,
1921: itemkey => itemkey,
1922: aname => 'AMS_ACTIVITY_TYPE' );
1923:

Line 1924: l_version := wf_engine.GetItemAttrNumber(

1920: itemtype => itemtype,
1921: itemkey => itemkey,
1922: aname => 'AMS_ACTIVITY_TYPE' );
1923:
1924: l_version := wf_engine.GetItemAttrNumber(
1925: itemtype => itemtype,
1926: itemkey => itemkey,
1927: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1928:

Line 1929: l_approval_type := wf_engine.GetItemAttrText(

1925: itemtype => itemtype,
1926: itemkey => itemkey,
1927: aname => 'AMS_OBJECT_VERSION_NUMBER' );
1928:
1929: l_approval_type := wf_engine.GetItemAttrText(
1930: itemtype => itemtype,
1931: itemkey => itemkey,
1932: aname => 'AMS_APPROVAL_TYPE' );
1933:

Line 1934: l_orig_status_id := wf_engine.GetItemAttrNumber(

1930: itemtype => itemtype,
1931: itemkey => itemkey,
1932: aname => 'AMS_APPROVAL_TYPE' );
1933:
1934: l_orig_status_id := wf_engine.GetItemAttrNumber(
1935: itemtype => itemtype,
1936: itemkey => itemkey,
1937: aname => 'AMS_ORIG_STAT_ID' );
1938:

Line 1940: Wf_Engine.SetItemAttrText(itemtype => itemtype,

1936: itemkey => itemkey,
1937: aname => 'AMS_ORIG_STAT_ID' );
1938:
1939: -- Added by VMODUR on July-02-2002
1940: Wf_Engine.SetItemAttrText(itemtype => itemtype,
1941: itemkey => itemkey,
1942: aname => 'UPDATE_GEN_STATUS',
1943: avalue => 'ERROR');
1944:

Line 2073: WF_ENGINE.AbortProcess (itemtype => itemtype,

2069: itemkey VARCHAR2(30) := p_itemkey ;
2070: itemtype VARCHAR2(30) := nvl(p_itemtype,'AMS_APPROVAL') ;
2071: BEGIN
2072: AMS_Utility_PVT.debug_message('Process Abort Process');
2073: WF_ENGINE.AbortProcess (itemtype => itemtype,
2074: itemkey => itemkey ,
2075: process => p_workflowprocess);
2076: EXCEPTION
2077: WHEN OTHERS THEN

Line 2158: l_activity_type := wf_engine.GetItemAttrText(

2154: BEGIN
2155: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2156: l_itemKey := substr(document_id, instr(document_id,':')+1);
2157:
2158: l_activity_type := wf_engine.GetItemAttrText(
2159: itemtype => l_itemtype,
2160: itemkey => l_itemkey,
2161: aname => 'AMS_ACTIVITY_TYPE' );
2162:

Line 2163: l_approval_type := wf_engine.GetItemAttrText(

2159: itemtype => l_itemtype,
2160: itemkey => l_itemkey,
2161: aname => 'AMS_ACTIVITY_TYPE' );
2162:
2163: l_approval_type := wf_engine.GetItemAttrText(
2164: itemtype => l_itemtype,
2165: itemkey => l_itemkey,
2166: aname => 'AMS_APPROVAL_TYPE' );
2167:

Line 2226: l_activity_type := wf_engine.GetItemAttrText(

2222: BEGIN
2223: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2224: l_itemKey := substr(document_id, instr(document_id,':')+1);
2225:
2226: l_activity_type := wf_engine.GetItemAttrText(
2227: itemtype => l_itemtype,
2228: itemkey => l_itemkey,
2229: aname => 'AMS_ACTIVITY_TYPE' );
2230:

Line 2231: l_approval_type := wf_engine.GetItemAttrText(

2227: itemtype => l_itemtype,
2228: itemkey => l_itemkey,
2229: aname => 'AMS_ACTIVITY_TYPE' );
2230:
2231: l_approval_type := wf_engine.GetItemAttrText(
2232: itemtype => l_itemtype,
2233: itemkey => l_itemkey,
2234: aname => 'AMS_APPROVAL_TYPE' );
2235:

Line 2295: l_activity_type := wf_engine.GetItemAttrText(

2291: BEGIN
2292: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2293: l_itemKey := substr(document_id, instr(document_id,':')+1);
2294:
2295: l_activity_type := wf_engine.GetItemAttrText(
2296: itemtype => l_itemtype,
2297: itemkey => l_itemkey,
2298: aname => 'AMS_ACTIVITY_TYPE' );
2299:

Line 2300: l_approval_type := wf_engine.GetItemAttrText(

2296: itemtype => l_itemtype,
2297: itemkey => l_itemkey,
2298: aname => 'AMS_ACTIVITY_TYPE' );
2299:
2300: l_approval_type := wf_engine.GetItemAttrText(
2301: itemtype => l_itemtype,
2302: itemkey => l_itemkey,
2303: aname => 'AMS_APPROVAL_TYPE' );
2304:

Line 2364: l_activity_type := wf_engine.GetItemAttrText(

2360: BEGIN
2361: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2362: l_itemKey := substr(document_id, instr(document_id,':')+1);
2363:
2364: l_activity_type := wf_engine.GetItemAttrText(
2365: itemtype => l_itemtype,
2366: itemkey => l_itemkey,
2367: aname => 'AMS_ACTIVITY_TYPE' );
2368:

Line 2369: l_approval_type := wf_engine.GetItemAttrText(

2365: itemtype => l_itemtype,
2366: itemkey => l_itemkey,
2367: aname => 'AMS_ACTIVITY_TYPE' );
2368:
2369: l_approval_type := wf_engine.GetItemAttrText(
2370: itemtype => l_itemtype,
2371: itemkey => l_itemkey,
2372: aname => 'AMS_APPROVAL_TYPE' );
2373:

Line 2432: l_activity_type := wf_engine.GetItemAttrText(

2428: BEGIN
2429: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2430: l_itemKey := substr(document_id, instr(document_id,':')+1);
2431:
2432: l_activity_type := wf_engine.GetItemAttrText(
2433: itemtype => l_itemtype,
2434: itemkey => l_itemkey,
2435: aname => 'AMS_ACTIVITY_TYPE' );
2436:

Line 2437: l_approval_type := wf_engine.GetItemAttrText(

2433: itemtype => l_itemtype,
2434: itemkey => l_itemkey,
2435: aname => 'AMS_ACTIVITY_TYPE' );
2436:
2437: l_approval_type := wf_engine.GetItemAttrText(
2438: itemtype => l_itemtype,
2439: itemkey => l_itemkey,
2440: aname => 'AMS_APPROVAL_TYPE' );
2441:

Line 2507: l_activity_type := wf_engine.GetItemAttrText(

2503: BEGIN
2504: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMSGAPP');
2505: l_itemKey := substr(document_id, instr(document_id,':')+1);
2506:
2507: l_activity_type := wf_engine.GetItemAttrText(
2508: itemtype => l_itemtype,
2509: itemkey => l_itemkey,
2510: aname => 'AMS_ACTIVITY_TYPE' );
2511:

Line 2512: l_approval_type := wf_engine.GetItemAttrText(

2508: itemtype => l_itemtype,
2509: itemkey => l_itemkey,
2510: aname => 'AMS_ACTIVITY_TYPE' );
2511:
2512: l_approval_type := wf_engine.GetItemAttrText(
2513: itemtype => l_itemtype,
2514: itemkey => l_itemkey,
2515: aname => 'AMS_APPROVAL_TYPE' );
2516:

Line 2517: l_appr_meaning := wf_engine.GetItemAttrText(

2513: itemtype => l_itemtype,
2514: itemkey => l_itemkey,
2515: aname => 'AMS_APPROVAL_TYPE' );
2516:
2517: l_appr_meaning := wf_engine.GetItemAttrText(
2518: itemtype => l_itemtype,
2519: itemkey => l_itemkey,
2520: aname => 'AMS_APPROVAL_OBJECT_MEANING');
2521:

Line 2522: l_appr_obj_name := wf_engine.GetItemAttrText(

2518: itemtype => l_itemtype,
2519: itemkey => l_itemkey,
2520: aname => 'AMS_APPROVAL_OBJECT_MEANING');
2521:
2522: l_appr_obj_name := wf_engine.GetItemAttrText(
2523: itemtype => l_itemtype,
2524: itemkey => l_itemkey,
2525: aname => 'AMS_APPROVAL_OBJECT_NAME');
2526:

Line 2536: l_errmsg := wf_engine.GetItemAttrText(

2532: EXECUTE IMMEDIATE dml_str USING IN document_id,IN display_type,IN OUT document, IN OUT document_type;
2533:
2534: elsif (l_return_stat = 'E') THEN -- no data found, generate a generic message
2535:
2536: l_errmsg := wf_engine.GetItemAttrText(
2537: itemtype => l_itemtype,
2538: itemkey => l_itemkey,
2539: aname => 'AMS_ERROR_MSG');
2540:

Line 2579: l_activity_type := wf_engine.GetItemAttrText(

2575: l_approval_type varchar2(80);
2576:
2577:
2578: BEGIN
2579: l_activity_type := wf_engine.GetItemAttrText(
2580: itemtype => itemtype,
2581: itemkey => itemkey,
2582: aname => 'AMS_ACTIVITY_TYPE' );
2583:

Line 2584: l_approval_type := wf_engine.GetItemAttrText(

2580: itemtype => itemtype,
2581: itemkey => itemkey,
2582: aname => 'AMS_ACTIVITY_TYPE' );
2583:
2584: l_approval_type := wf_engine.GetItemAttrText(
2585: itemtype => itemtype,
2586: itemkey => itemkey,
2587: aname => 'AMS_APPROVAL_TYPE' );
2588:

Line 2612: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

2608: funcmode in varchar2,
2609: resultout OUT NOCOPY varchar2 )
2610: IS
2611: BEGIN
2612: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2613: itemkey => itemkey,
2614: aname => 'UPDATE_GEN_STATUS',
2615: avalue => 'APPROVED' );
2616: Update_Status(itemtype => itemtype,

Line 2657: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

2653: l_responder VARCHAR2(100);
2654: l_appr_display_name VARCHAR2(360);
2655: l_forward_nid NUMBER;
2656: BEGIN
2657: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2658: itemkey => itemkey,
2659: aname => 'UPDATE_GEN_STATUS',
2660: avalue => 'REJECTED');
2661:

Line 2664: l_activity_id := Wf_Engine.GetItemAttrNumber(

2660: avalue => 'REJECTED');
2661:
2662:
2663: -- Added by VM for 11.5.9
2664: l_activity_id := Wf_Engine.GetItemAttrNumber(
2665: itemtype => itemtype,
2666: itemkey => itemkey,
2667: aname => 'AMS_ACTIVITY_ID' );
2668:

Line 2670: l_activity_type := Wf_Engine.GetItemAttrText(

2666: itemkey => itemkey,
2667: aname => 'AMS_ACTIVITY_ID' );
2668:
2669: -- get the activity type
2670: l_activity_type := Wf_Engine.GetItemAttrText(
2671: itemtype => itemtype,
2672: itemkey => itemkey,
2673: aname => 'AMS_ACTIVITY_TYPE' );
2674:

Line 2675: l_approver_seq := Wf_Engine.GetItemAttrNumber(

2671: itemtype => itemtype,
2672: itemkey => itemkey,
2673: aname => 'AMS_ACTIVITY_TYPE' );
2674:
2675: l_approver_seq := Wf_Engine.GetItemAttrNumber(
2676: itemtype => itemtype,
2677: itemkey => itemkey,
2678: aname => 'AMS_APPROVER_SEQ' );
2679:

Line 2680: l_version := Wf_Engine.GetItemAttrNumber(

2676: itemtype => itemtype,
2677: itemkey => itemkey,
2678: aname => 'AMS_APPROVER_SEQ' );
2679:
2680: l_version := Wf_Engine.GetItemAttrNumber(
2681: itemtype => itemtype,
2682: itemkey => itemkey,
2683: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2684:

Line 2685: l_approver_id := Wf_Engine.GetItemAttrNumber(

2681: itemtype => itemtype,
2682: itemkey => itemkey,
2683: aname => 'AMS_OBJECT_VERSION_NUMBER' );
2684:
2685: l_approver_id := Wf_Engine.GetItemAttrNumber(
2686: itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'AMS_APPROVER_ID' );
2689:

Line 2690: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(

2686: itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'AMS_APPROVER_ID' );
2689:
2690: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
2691: itemtype => itemtype,
2692: itemkey => itemkey,
2693: aname => 'AMS_APPROVAL_DETAIL_ID' );
2694:

Line 2695: l_approval_type := Wf_Engine.GetItemAttrText(

2691: itemtype => itemtype,
2692: itemkey => itemkey,
2693: aname => 'AMS_APPROVAL_DETAIL_ID' );
2694:
2695: l_approval_type := Wf_Engine.GetItemAttrText(
2696: itemtype => itemtype,
2697: itemkey => itemkey,
2698: aname => 'AMS_APPROVAL_TYPE' );
2699:

Line 2700: l_note := Wf_Engine.GetItemAttrText(

2696: itemtype => itemtype,
2697: itemkey => itemkey,
2698: aname => 'AMS_APPROVAL_TYPE' );
2699:
2700: l_note := Wf_Engine.GetItemAttrText(
2701: itemtype => itemtype,
2702: itemkey => itemkey,
2703: aname => 'APPROVAL_NOTE' );
2704: -- End 11.5.9

Line 2707: l_forward_nid := Wf_Engine.GetItemAttrNumber(

2703: aname => 'APPROVAL_NOTE' );
2704: -- End 11.5.9
2705: -- Start of addition for forward/reassign notification
2706:
2707: l_forward_nid := Wf_Engine.GetItemAttrNumber(
2708: itemtype => itemtype,
2709: itemkey => itemkey,
2710: aname => 'AMS_FORWARD_NID' );
2711: -- Commented for 3150550

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

2723: RAISE Fnd_Api.G_EXC_ERROR;
2724: END IF;
2725:
2726: -- Set the WF Attributes
2727: wf_engine.SetItemAttrText( itemtype => itemtype,
2728: itemkey => itemkey,
2729: aname => 'AMS_APPROVER',
2730: avalue => l_responder);
2731:

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

2729: aname => 'AMS_APPROVER',
2730: avalue => l_responder);
2731:
2732:
2733: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2734: itemkey => itemkey,
2735: aname => 'AMS_APPROVER_ID',
2736: avalue => l_approver_id);
2737:

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

2735: aname => 'AMS_APPROVER_ID',
2736: avalue => l_approver_id);
2737:
2738:
2739: wf_engine.SetItemAttrText( itemtype => itemtype,
2740: itemkey => itemkey,
2741: aname => 'AMS_APPROVER_DISPLAY_NAME',
2742: avalue => l_appr_display_name);
2743:

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

2743:
2744: -- Reset the forward_nid wf attribute to null
2745: -- This is a must
2746:
2747: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2748: itemkey => itemkey,
2749: aname => 'AMS_FORWARD_NID',
2750: avalue => null);
2751:

Line 2866: l_activity_type := wf_engine.GetItemAttrText(

2862: l_process_type varchar2(80);
2863: l_activity_type varchar2(80);
2864: BEGIN
2865:
2866: l_activity_type := wf_engine.GetItemAttrText(
2867: itemtype => itemtype,
2868: itemkey => itemkey,
2869: aname => 'AMS_ACTIVITY_TYPE' );
2870:

Line 2880: l_process_type := wf_engine.GetItemAttrText(

2876: resultout := 'OTHER';
2877: end if;
2878:
2879: /* commented because of seed data change aug 17 2001
2880: l_process_type := wf_engine.GetItemAttrText(
2881: itemtype => itemtype,
2882: itemkey => itemkey,
2883: aname => 'AMS_APPROVAL_TYPE' );
2884: if (l_process_type = 'BUDGET_REQUEST'

Line 2947: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,

2943: --
2944: IF (funcmode = 'RUN') THEN
2945:
2946: -- Get the Requestor
2947: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
2948: itemkey => itemkey,
2949: aname => 'AMS_REQUESTER_ID');
2950:
2951: -- Get the Approver

Line 2952: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,

2948: itemkey => itemkey,
2949: aname => 'AMS_REQUESTER_ID');
2950:
2951: -- Get the Approver
2952: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
2953: itemkey => itemkey,
2954: aname => 'AMS_APPROVER_ID');
2955:
2956: IF l_requestor = l_approver THEN

Line 2958: l_note := wf_engine.getitemattrtext(

2954: aname => 'AMS_APPROVER_ID');
2955:
2956: IF l_requestor = l_approver THEN
2957:
2958: l_note := wf_engine.getitemattrtext(
2959: itemtype => itemtype
2960: ,itemkey => itemkey
2961: ,aname => 'AMS_PREV_APPROVER_NOTE'
2962: );

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

2959: itemtype => itemtype
2960: ,itemkey => itemkey
2961: ,aname => 'AMS_PREV_APPROVER_NOTE'
2962: );
2963: wf_engine.SetItemAttrText( itemtype => itemtype,
2964: itemkey => itemkey,
2965: aname => 'APPROVAL_NOTE',
2966: avalue => l_note);
2967: resultout := 'COMPLETE:N';

Line 3241: l_nid := wf_engine.context_nid;

3237:
3238: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3239:
3240: BEGIN
3241: l_nid := wf_engine.context_nid;
3242:
3243: IF (funcmode = 'RESPOND') THEN
3244:
3245: l_result := upper(wf_notification.GETATTRTEXT(l_nid, 'RESULT'));

Line 3258: l_assignee := WF_ENGINE.context_text;

3254:
3255: -- Set the forwarded/transferred notification id so that
3256: -- we can use it later to see actual approver
3257:
3258: l_assignee := WF_ENGINE.context_text;
3259:
3260: -- ams_forward_nid is not really needed.
3261: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3262: itemkey => itemkey,

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

3257:
3258: l_assignee := WF_ENGINE.context_text;
3259:
3260: -- ams_forward_nid is not really needed.
3261: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3262: itemkey => itemkey,
3263: aname => 'AMS_FORWARD_NID',
3264: avalue => l_nid);
3265:

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

3272: RAISE Fnd_Api.G_EXC_ERROR;
3273: END IF;
3274:
3275: -- Set the WF Attributes
3276: wf_engine.SetItemAttrText( itemtype => itemtype,
3277: itemkey => itemkey,
3278: aname => 'AMS_APPROVER',
3279: avalue => l_assignee);
3280:

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

3277: itemkey => itemkey,
3278: aname => 'AMS_APPROVER',
3279: avalue => l_assignee);
3280:
3281: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3282: itemkey => itemkey,
3283: aname => 'AMS_APPROVER_ID',
3284: avalue => l_new_approver_id);
3285:

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

3282: itemkey => itemkey,
3283: aname => 'AMS_APPROVER_ID',
3284: avalue => l_new_approver_id);
3285:
3286: wf_engine.SetItemAttrText( itemtype => itemtype,
3287: itemkey => itemkey,
3288: aname => 'AMS_APPROVER_DISPLAY_NAME',
3289: avalue => l_appr_display_name);
3290:

Line 3293: l_activity_type := Wf_Engine.GetItemAttrText(

3289: avalue => l_appr_display_name);
3290:
3291: -- Update the approver details here
3292:
3293: l_activity_type := Wf_Engine.GetItemAttrText(
3294: itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'AMS_ACTIVITY_TYPE' );
3297:

Line 3298: l_version := Wf_Engine.GetItemAttrNumber(

3294: itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'AMS_ACTIVITY_TYPE' );
3297:
3298: l_version := Wf_Engine.GetItemAttrNumber(
3299: itemtype => itemtype,
3300: itemkey => itemkey,
3301: aname => 'AMS_OBJECT_VERSION_NUMBER'
3302: );

Line 3304: l_activity_id := Wf_Engine.GetItemAttrNumber(

3300: itemkey => itemkey,
3301: aname => 'AMS_OBJECT_VERSION_NUMBER'
3302: );
3303:
3304: l_activity_id := Wf_Engine.GetItemAttrNumber(
3305: itemtype => itemtype,
3306: itemkey => itemkey,
3307: aname => 'AMS_ACTIVITY_ID' );
3308:

Line 3309: l_current_seq := Wf_Engine.GetItemAttrText(

3305: itemtype => itemtype,
3306: itemkey => itemkey,
3307: aname => 'AMS_ACTIVITY_ID' );
3308:
3309: l_current_seq := Wf_Engine.GetItemAttrText(
3310: itemtype => itemtype,
3311: itemkey => itemkey,
3312: aname => 'AMS_APPROVER_SEQ' );
3313:

Line 3314: l_approval_type := Wf_Engine.GetItemAttrText(

3310: itemtype => itemtype,
3311: itemkey => itemkey,
3312: aname => 'AMS_APPROVER_SEQ' );
3313:
3314: l_approval_type := Wf_Engine.GetItemAttrText(
3315: itemtype => itemtype,
3316: itemkey => itemkey,
3317: aname => 'AMS_APPROVAL_TYPE' );
3318: