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

Line 1076: l_JobID := wf_engine.GetItemAttrNumber(itemtype => GetResubmissionJobID.itemtype,

1072: l_JobID number;
1073: e_UnhandledException exception;
1074: begin
1075: begin
1076: l_JobID := wf_engine.GetItemAttrNumber(itemtype => GetResubmissionJobID.itemtype,
1077: itemkey => GetResubmissionJobID.itemkey,
1078: aname => 'RESUBMISSION_JOB_ID');
1079:
1080: exception

Line 1114: l_error_itemtype := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,

1110: l_status VARCHAR2(40);
1111: l_url VARCHAR2(1000);
1112:
1113: BEGIN
1114: l_error_itemtype := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,
1115: itemkey => SetErrorStatus.itemkey,
1116: aname => 'ERROR_ITEM_TYPE');
1117:
1118: l_error_itemkey := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,

Line 1118: l_error_itemkey := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,

1114: l_error_itemtype := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,
1115: itemkey => SetErrorStatus.itemkey,
1116: aname => 'ERROR_ITEM_TYPE');
1117:
1118: l_error_itemkey := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,
1119: itemkey => SetErrorStatus.itemkey,
1120: aname => 'ERROR_ITEM_KEY');
1121:
1122: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetErrorStatus.itemtype,

Line 1122: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetErrorStatus.itemtype,

1118: l_error_itemkey := WF_ENGINE.GETITEMATTRTEXT(itemtype => SetErrorStatus.itemtype,
1119: itemkey => SetErrorStatus.itemkey,
1120: aname => 'ERROR_ITEM_KEY');
1121:
1122: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetErrorStatus.itemtype,
1123: itemkey =>SetErrorStatus.itemkey,
1124: actid =>SetErrorStatus.actid,
1125: aname =>'STATUS');
1126:

Line 1134: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,

1130: l_workitem_count := instr(l_error_itemkey,'WI') ;
1131: l_fa_count := instr(l_error_itemkey,'FA') ;
1132:
1133: IF l_order_count > 0 THEN
1134: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,
1135: itemkey => l_error_itemkey,
1136: aname => 'ORDER_ID');
1137: UPDATE_XDP_ORDER_STATUS(l_status,l_orderID );
1138:

Line 1140: l_lineitemId := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,

1136: aname => 'ORDER_ID');
1137: UPDATE_XDP_ORDER_STATUS(l_status,l_orderID );
1138:
1139: ELSIF (l_line_count > 0 OR l_pkg_count > 0 ) THEN
1140: l_lineitemId := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,
1141: itemkey => l_error_itemkey,
1142: aname => 'LINE_ITEM_ID');
1143: UPDATE_XDP_ORDER_LINE_STATUS(l_status,l_lineitemID);
1144:

Line 1147: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,

1143: UPDATE_XDP_ORDER_LINE_STATUS(l_status,l_lineitemID);
1144:
1145: ELSIF (l_workitem_count > 0 AND l_fa_count = 0) THEN
1146:
1147: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,
1148: itemkey => l_error_itemkey,
1149: aname => 'ORDER_ID');
1150:
1151: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => l_error_itemtype,

Line 1151: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => l_error_itemtype,

1147: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => l_error_itemtype,
1148: itemkey => l_error_itemkey,
1149: aname => 'ORDER_ID');
1150:
1151: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => l_error_itemtype,
1152: itemkey => l_error_itemkey,
1153: aname => 'WORKITEM_INSTANCE_ID');
1154:
1155: UPDATE_XDP_WORKITEM_STATUS(l_status,l_WIInstanceID);

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

1160: itemKey,
1161: l_url);
1162: --10/04/2002 HBCHUNG
1163: --setting Notification URL
1164: wf_engine.SetItemAttrText(itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'ERROR_WI_UPDATE_URL',
1167: avalue => l_url);
1168:

Line 1172: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => l_error_itemtype,

1168:
1169:
1170:
1171: ELSIF l_fa_count > 0 THEN
1172: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => l_error_itemtype,
1173: itemkey => l_error_itemkey,
1174: aname => 'FA_INSTANCE_ID');
1175: UPDATE_XDP_FA_STATUS(l_status,l_FAInstanceID);
1176: END IF;

Line 1203: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => SetOrderStatus.itemtype,

1199: WHERE order_id = orderid ;
1200:
1201: BEGIN
1202:
1203: l_OrderID := WF_ENGINE.GETITEMATTRNUMBER(itemtype => SetOrderStatus.itemtype,
1204: itemkey => SetOrderStatus.itemkey,
1205: aname => 'ORDER_ID');
1206:
1207:

Line 1273: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendOrderStatus.itemtype,

1269: l_SendFlag varchar2(10);
1270:
1271: begin
1272:
1273: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendOrderStatus.itemtype,
1274: itemkey => SendOrderStatus.itemkey,
1275: actid => SendOrderStatus.actid,
1276: aname => 'SEND_FLAG');
1277:

Line 1282: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendOrderStatus.itemtype,

1278: /* Only if the SEND_FLAG is set to 'Y' will the message be sent */
1279:
1280: if l_SendFlag = 'Y' then
1281:
1282: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendOrderStatus.itemtype,
1283: itemkey => SendOrderStatus.itemkey,
1284: aname => 'ORDER_ID');
1285:
1286: /* Enqueue into the Outboud Queue with the appropriate message */

Line 1287: l_Message := wf_engine.GetActivityAttrText( itemtype => SendOrderStatus.itemtype,

1283: itemkey => SendOrderStatus.itemkey,
1284: aname => 'ORDER_ID');
1285:
1286: /* Enqueue into the Outboud Queue with the appropriate message */
1287: l_Message := wf_engine.GetActivityAttrText( itemtype => SendOrderStatus.itemtype,
1288: itemkey => SendOrderStatus.itemkey,
1289: actid => SendOrderStatus.actid,
1290: aname => 'MESSAGE');
1291:

Line 1337: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetWorkitemStatus.itemtype,

1333: WHERE WORKITEM_INSTANCE_ID = WIInstanceID ;
1334:
1335: BEGIN
1336:
1337: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetWorkitemStatus.itemtype,
1338: itemkey => SetWorkitemStatus.itemkey,
1339: aname => 'WORKITEM_INSTANCE_ID');
1340:
1341:

Line 1399: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetWIStatusSuccess.itemtype,

1395: IS
1396: l_WIInstanceID NUMBER;
1397: BEGIN
1398:
1399: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetWIStatusSuccess.itemtype,
1400: itemkey => SetWIStatusSuccess.itemkey,
1401: aname => 'WORKITEM_INSTANCE_ID');
1402:
1403: UPDATE_XDP_WORKITEM_STATUS('SUCCESS' , l_WIInstanceID );

Line 1428: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendWorkitemStatus.itemtype,

1424: l_SendFlag varchar2(10);
1425:
1426: begin
1427:
1428: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendWorkitemStatus.itemtype,
1429: itemkey => SendWorkitemStatus.itemkey,
1430: actid => SendWorkitemStatus.actid,
1431: aname => 'SEND_FLAG');
1432:

Line 1438: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,

1434: /* Only if the SEND_FLAG is 'Y' will the message be sent */
1435:
1436: if l_SendFlag = 'Y' then
1437:
1438: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,
1439: itemkey => SendWorkitemStatus.itemkey,
1440: aname => 'ORDER_ID');
1441:
1442: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,

Line 1442: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,

1438: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,
1439: itemkey => SendWorkitemStatus.itemkey,
1440: aname => 'ORDER_ID');
1441:
1442: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendWorkitemStatus.itemtype,
1443: itemkey => SendWorkitemStatus.itemkey,
1444: aname => 'WORKITEM_INSTANCE_ID');
1445:
1446:

Line 1448: l_Message := wf_engine.GetActivityAttrText( itemtype => SendWorkitemStatus.itemtype,

1444: aname => 'WORKITEM_INSTANCE_ID');
1445:
1446:
1447: /* Enqueue into the Outboud Queue with the appropriate message */
1448: l_Message := wf_engine.GetActivityAttrText( itemtype => SendWorkitemStatus.itemtype,
1449: itemkey => SendWorkitemStatus.itemkey,
1450: actid => SendWorkitemStatus.actid,
1451: aname => 'MESSAGE');
1452:

Line 1497: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

1493: e_SetFAStatusException EXCEPTION;
1494:
1495: BEGIN
1496:
1497: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1498: itemkey => SetFAStatus.itemkey,
1499: aname => 'FA_INSTANCE_ID');
1500:
1501: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

Line 1501: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

1497: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1498: itemkey => SetFAStatus.itemkey,
1499: aname => 'FA_INSTANCE_ID');
1500:
1501: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1502: itemkey => SetFAStatus.itemkey,
1503: aname => 'ORDER_ID');
1504:
1505: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

Line 1505: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

1501: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1502: itemkey => SetFAStatus.itemkey,
1503: aname => 'ORDER_ID');
1504:
1505: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1506: itemkey => SetFAStatus.itemkey,
1507: aname => 'WORKITEM_INSTANCE_ID');
1508:
1509: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

Line 1509: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,

1505: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1506: itemkey => SetFAStatus.itemkey,
1507: aname => 'WORKITEM_INSTANCE_ID');
1508:
1509: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1510: itemkey => SetFAStatus.itemkey,
1511: aname => 'LINE_ITEM_ID');
1512:
1513: l_FAStatus := wf_engine.GetActivityAttrText( itemtype => SetFAStatus.itemtype,

Line 1513: l_FAStatus := wf_engine.GetActivityAttrText( itemtype => SetFAStatus.itemtype,

1509: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetFAStatus.itemtype,
1510: itemkey => SetFAStatus.itemkey,
1511: aname => 'LINE_ITEM_ID');
1512:
1513: l_FAStatus := wf_engine.GetActivityAttrText( itemtype => SetFAStatus.itemtype,
1514: itemkey => SetFAStatus.itemkey,
1515: actid => SetFAStatus.actid,
1516: aname => 'FA_STATUS');
1517:

Line 1521: l_Event := wf_engine.GetActivityAttrText( itemtype => SetFAStatus.itemtype,

1517:
1518: l_ResubmissionJobID := GetResubmissionJobID(itemtype => SetFAStatus.itemtype,
1519: itemkey => SetFAStatus.itemkey);
1520:
1521: l_Event := wf_engine.GetActivityAttrText( itemtype => SetFAStatus.itemtype,
1522: itemkey => SetFAStatus.itemkey,
1523: actid => SetFAStatus.actid,
1524: aname => 'NOTIF_RESPONSE');
1525:

Line 1532: wf_engine.AbortProcess(itemtype => SetFAStatus.itemtype,

1528: IF XDPCORE_FA.IsFAAborted(l_FAInstanceID) = TRUE THEN
1529:
1530: UPDATE_XDP_FA_STATUS(l_FAStatus,l_FAInstanceID);
1531:
1532: wf_engine.AbortProcess(itemtype => SetFAStatus.itemtype,
1533: itemkey => SetFAStatus.itemkey);
1534:
1535: return;
1536: else

Line 1614: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,

1610: x_progress varchar2(2000);
1611:
1612: begin
1613:
1614: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,
1615: itemkey => SendFeProvStatus.itemkey,
1616: aname => 'FA_INSTANCE_ID');
1617:
1618: --From now on we will get this from runtime table.

Line 1639: wf_engine.AbortProcess(itemtype => SendFeProvStatus.itemtype,

1635: if XDPCORE_FA.IsFAAborted(l_FAInstanceID) = TRUE then
1636:
1637: UPDATE_XDP_FA_STATUS(l_FeExecStatus,l_FAInstanceID);
1638:
1639: wf_engine.AbortProcess(itemtype => SendFeProvStatus.itemtype,
1640: itemkey => SendFeProvStatus.itemkey);
1641:
1642: else
1643:

Line 1644: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendFeProvStatus.itemtype,

1640: itemkey => SendFeProvStatus.itemkey);
1641:
1642: else
1643:
1644: l_SendFlag := wf_engine.GetActivityAttrText( itemtype => SendFeProvStatus.itemtype,
1645: itemkey => SendFeProvStatus.itemkey,
1646: actid => SendFeProvStatus.actid,
1647: aname => 'SEND_FLAG');
1648:

Line 1652: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,

1648:
1649: /* Only if the Send Flag has been set to be 'Y' the message will be sent */
1650: if l_SendFlag = 'Y' then
1651:
1652: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,
1653: itemkey => SendFeProvStatus.itemkey,
1654: aname => 'WORKITEM_INSTANCE_ID');
1655:
1656:

Line 1658: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,

1654: aname => 'WORKITEM_INSTANCE_ID');
1655:
1656:
1657:
1658: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SendFeProvStatus.itemtype,
1659: itemkey => SendFeProvStatus.itemkey,
1660: aname => 'ORDER_ID');
1661:
1662:

Line 1663: l_Message := wf_engine.GetActivityAttrText( itemtype => SendFeProvStatus.itemtype,

1659: itemkey => SendFeProvStatus.itemkey,
1660: aname => 'ORDER_ID');
1661:
1662:
1663: l_Message := wf_engine.GetActivityAttrText( itemtype => SendFeProvStatus.itemtype,
1664: itemkey => SendFeProvStatus.itemkey,
1665: actid => SendFeProvStatus.actid,
1666: aname => 'MESSAGE');
1667:

Line 1811: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,

1807: AND LINE_ITEM_ID = LineItemID ;
1808:
1809: BEGIN
1810:
1811: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,
1812: itemkey => SetLineStatus.itemkey,
1813: aname => 'ORDER_ID');
1814:
1815: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,

Line 1815: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,

1811: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,
1812: itemkey => SetLineStatus.itemkey,
1813: aname => 'ORDER_ID');
1814:
1815: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetLineStatus.itemtype,
1816: itemkey => SetLineStatus.itemkey,
1817: aname => 'LINE_ITEM_ID');
1818:
1819: IF c_GetWI%ISOPEN THEN

Line 1894: l_Status := wf_engine.GetActivityAttrText( itemtype => SaveWorkitem.itemtype,

1890:
1891: BEGIN
1892:
1893:
1894: l_Status := wf_engine.GetActivityAttrText( itemtype => SaveWorkitem.itemtype,
1895: itemkey => SaveWorkitem.itemkey,
1896: actid => SaveWorkitem.actid,
1897: aname => 'WORKITEM_STATUS');
1898:

Line 1899: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SaveWorkitem.itemtype,

1895: itemkey => SaveWorkitem.itemkey,
1896: actid => SaveWorkitem.actid,
1897: aname => 'WORKITEM_STATUS');
1898:
1899: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SaveWorkitem.itemtype,
1900: itemkey => SaveWorkitem.itemkey,
1901: aname => 'WORKITEM_INSTANCE_ID');
1902:
1903: UPDATE_XDP_WORKITEM_STATUS(l_Status, l_WIINstanceID);

Line 2695: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetNodeWIStatus.itemtype,

2691: l_WIInstanceID NUMBER ;
2692: l_status VARCHAR2(40);
2693:
2694: BEGIN
2695: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetNodeWIStatus.itemtype,
2696: itemkey =>SetNodeWIStatus.itemkey,
2697: actid =>SetNodeWIStatus.actid,
2698: aname =>'STATUS');
2699:

Line 2700: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetNodeWIStatus.itemtype,

2696: itemkey =>SetNodeWIStatus.itemkey,
2697: actid =>SetNodeWIStatus.actid,
2698: aname =>'STATUS');
2699:
2700: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetNodeWIStatus.itemtype,
2701: itemkey => SetNodeWIStatus.itemkey,
2702: aname => 'WORKITEM_INSTANCE_ID');
2703: UPDATE_XDP_WORKITEM_STATUS(l_status,l_WIInstanceID);
2704:

Line 2722: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetNodeLineStatus.itemtype,

2718: l_status VARCHAR2(40);
2719:
2720: BEGIN
2721:
2722: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetNodeLineStatus.itemtype,
2723: itemkey => SetNodeLineStatus.itemkey,
2724: aname => 'LINE_ITEM_ID');
2725: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetNodeLineStatus.itemtype,
2726: itemkey =>SetNodeLineStatus.itemkey,

Line 2725: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetNodeLineStatus.itemtype,

2721:
2722: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => SetNodeLineStatus.itemtype,
2723: itemkey => SetNodeLineStatus.itemkey,
2724: aname => 'LINE_ITEM_ID');
2725: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>SetNodeLineStatus.itemtype,
2726: itemkey =>SetNodeLineStatus.itemkey,
2727: actid =>SetNodeLineStatus.actid,
2728: aname =>'STATUS');
2729: