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

Line 256: wf_engine.SetItemAttrNumber(itemtype => EVALUATE_ALL_WIS_PARAMS.itemtype,

252: XDPCORE_ERROR.LOG_SESSION_ERROR( 'BUSINESS' );
253: --Set the workitem instance id of which evaluation failed..
254: --we cant set this in the lower calls where the error is occurred
255: --as we are doing a roll back on error...
256: wf_engine.SetItemAttrNumber(itemtype => EVALUATE_ALL_WIS_PARAMS.itemtype,
257: itemkey => EVALUATE_ALL_WIS_PARAMS.itemkey,
258: aname => 'WORKITEM_INSTANCE_ID',
259: avalue => g_WIInstance_ID_in_Error);
260:

Line 541: l_nid := WF_ENGINE.context_nid;

537:
538: BEGIN
539:
540: IF (funcmode = 'RESPOND') THEN
541: l_nid := WF_ENGINE.context_nid;
542: l_newParamValue := wf_notification.GetAttrText( l_nid, 'NEW_PARAM_VALUE');
543:
544: -- User havent entered any overriding parameter value..
545: IF l_newParamValue IS NOT NULL THEN

Line 546: l_WIInstanceID := wf_engine.getItemAttrNumber( itemtype, itemkey, 'WORKITEM_INSTANCE_ID' );

542: l_newParamValue := wf_notification.GetAttrText( l_nid, 'NEW_PARAM_VALUE');
543:
544: -- User havent entered any overriding parameter value..
545: IF l_newParamValue IS NOT NULL THEN
546: l_WIInstanceID := wf_engine.getItemAttrNumber( itemtype, itemkey, 'WORKITEM_INSTANCE_ID' );
547: l_paramName := wf_engine.getItemAttrText( itemtype, itemkey, 'WI_PARAMETER_NAME' );
548: l_evaluate := wf_notification.GetAttrText( l_nid, 'EVALUATE');
549:
550: OverrideParamValue( l_WIInstanceID, l_paramName, l_newParamValue, l_evaluate);

Line 547: l_paramName := wf_engine.getItemAttrText( itemtype, itemkey, 'WI_PARAMETER_NAME' );

543:
544: -- User havent entered any overriding parameter value..
545: IF l_newParamValue IS NOT NULL THEN
546: l_WIInstanceID := wf_engine.getItemAttrNumber( itemtype, itemkey, 'WORKITEM_INSTANCE_ID' );
547: l_paramName := wf_engine.getItemAttrText( itemtype, itemkey, 'WI_PARAMETER_NAME' );
548: l_evaluate := wf_notification.GetAttrText( l_nid, 'EVALUATE');
549:
550: OverrideParamValue( l_WIInstanceID, l_paramName, l_newParamValue, l_evaluate);
551: END IF;

Line 616: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => evaluateWIParams.itemtype,

612: l_ErrStr varchar2(1996);
613:
614: begin
615:
616: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => evaluateWIParams.itemtype,
617: itemkey => evaluateWIParams.itemkey,
618: aname => 'WORKITEM_INSTANCE_ID');
619: BEGIN
620: xdp_engine.EvaluateWIParamsOnStart(l_WIInstanceID );

Line 682: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,

678: where workitem_instance_id = cv_wiid;
679:
680: begin
681:
682: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,
683: itemkey => evaluateAllWIsParams.itemkey,
684: aname => 'ORDER_ID');
685:
686: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,

Line 686: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,

682: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,
683: itemkey => evaluateAllWIsParams.itemkey,
684: aname => 'ORDER_ID');
685:
686: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => evaluateAllWIsParams.itemtype,
687: itemkey => evaluateAllWIsParams.itemkey,
688: aname => 'LINE_ITEM_ID');
689:
690: /* Evaluate parameters for all INDEPENDENT workitems */

Line 752: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,

748: x_Progress VARCHAR2(2000);
749:
750: begin
751:
752: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,
753: itemkey => AreAllWIsDone.itemkey,
754: aname => 'ORDER_ID');
755:
756: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,

Line 756: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,

752: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,
753: itemkey => AreAllWIsDone.itemkey,
754: aname => 'ORDER_ID');
755:
756: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,
757: itemkey => AreAllWIsDone.itemkey,
758: aname => 'LINE_ITEM_ID');
759:
760: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,

Line 760: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,

756: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,
757: itemkey => AreAllWIsDone.itemkey,
758: aname => 'LINE_ITEM_ID');
759:
760: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => AreAllWIsDone.itemtype,
761: itemkey => AreAllWIsDone.itemkey,
762: aname => 'CURRENT_WI_SEQUENCE');
763:
764: if c_WIList%ISOPEN then

Line 846: l_OrderID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,

842: x_Progress VARCHAR2(2000);
843:
844: begin
845:
846: l_OrderID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,
847: itemkey => LaunchWorkitemProcess.itemkey,
848: aname => 'ORDER_ID');
849:
850: l_LineItemID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,

Line 850: l_LineItemID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,

846: l_OrderID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,
847: itemkey => LaunchWorkitemProcess.itemkey,
848: aname => 'ORDER_ID');
849:
850: l_LineItemID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,
851: itemkey => LaunchWorkitemProcess.itemkey,
852: aname => 'LINE_ITEM_ID');
853:
854: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

Line 854: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

850: l_LineItemID := wf_engine.GetItemAttrNUmber(itemtype => LaunchWorkitemProcess.itemtype,
851: itemkey => LaunchWorkitemProcess.itemkey,
852: aname => 'LINE_ITEM_ID');
853:
854: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,
855: itemkey => LaunchWorkitemProcess.itemkey,
856: aname => 'WORKITEM_INSTANCE_ID');
857:
858: l_WorkitemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

Line 858: l_WorkitemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

854: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,
855: itemkey => LaunchWorkitemProcess.itemkey,
856: aname => 'WORKITEM_INSTANCE_ID');
857:
858: l_WorkitemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,
859: itemkey => LaunchWorkitemProcess.itemkey,
860: aname => 'WORKITEM_ID');
861:
862: l_Priority := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

Line 862: l_Priority := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,

858: l_WorkitemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,
859: itemkey => LaunchWorkitemProcess.itemkey,
860: aname => 'WORKITEM_ID');
861:
862: l_Priority := wf_engine.GetItemAttrNumber(itemtype => LaunchWorkitemProcess.itemtype,
863: itemkey => LaunchWorkitemProcess.itemkey,
864: aname => 'WI_PRIORITY');
865:
866:

Line 914: wf_engine.SetItemParent(itemtype => l_WFItemType,

910: Raja: 04-Nov-1999
911: Must set the parent child relation ships
912: */
913:
914: wf_engine.SetItemParent(itemtype => l_WFItemType,
915: itemkey => l_WFItemKey,
916: parent_itemtype => LaunchWorkitemProcess.itemtype,
917: parent_itemkey => LaunchWorkitemProcess.itemkey,
918: parent_context => null);

Line 1145: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,

1141: ErrCode number;
1142: ErrStr varchar2(1996);
1143:
1144: begin
1145: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,
1146: itemkey => LaunchAllIndependentWIs.itemkey,
1147: aname => 'ORDER_ID');
1148:
1149: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,

Line 1149: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,

1145: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,
1146: itemkey => LaunchAllIndependentWIs.itemkey,
1147: aname => 'ORDER_ID');
1148:
1149: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndependentWIs.itemtype,
1150: itemkey => LaunchAllIndependentWIs.itemkey,
1151: aname => 'LINE_ITEM_ID');
1152:
1153: /* Create WF Processes for all the independent Workitems */

Line 1260: wf_engine.SetItemParent(itemtype => l_WFItemType,

1256: Raja: 04-Nov-1999
1257: Must set the parent child relation ships
1258: */
1259:
1260: wf_engine.SetItemParent(itemtype => l_WFItemType,
1261: itemkey => l_WFItemKey,
1262: parent_itemtype => LaunchIndWorkitemProcess .itemtype,
1263: parent_itemkey => LaunchIndWorkitemProcess .itemkey,
1264: parent_context => null);

Line 1486: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ContinueWorkitem.itemtype,

1482: from XDP_FULFILL_WORKLIST
1483: where ORDER_ID = p_OrderID
1484: and status_code in ('READY','IN PROGRESS') );
1485: begin
1486: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ContinueWorkitem.itemtype,
1487: itemkey => ContinueWorkitem.itemkey,
1488: aname => 'ORDER_ID');
1489:
1490: for v_ContinueWI in c_ContinueWI(l_OrderID) loop

Line 1529: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => InitializeWorkitemProcess.itemtype,

1525: x_Progress VARCHAR2(2000);
1526:
1527: begin
1528:
1529: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => InitializeWorkitemProcess.itemtype,
1530: itemkey => InitializeWorkitemProcess.itemkey,
1531: aname => 'WORKITEM_INSTANCE_ID');
1532:
1533: if l_WIInstanceID is null then

Line 1711: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,

1707: ErrStr varchar2(1996);
1708:
1709: begin
1710:
1711: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,
1712: itemkey => LaunchWIServiceProcess.itemkey,
1713: aname => 'ORDER_ID');
1714:
1715: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,

Line 1715: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,

1711: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,
1712: itemkey => LaunchWIServiceProcess.itemkey,
1713: aname => 'ORDER_ID');
1714:
1715: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWIServiceProcess.itemtype,
1716: itemkey => LaunchWIServiceProcess.itemkey,
1717: aname => 'LINE_ITEM_ID');
1718:
1719: if c_GetIndWIList%ISOPEN then

Line 1833: wf_engine.StartProcess(itemtype => t_ChildTypes(i),

1829: RAISE e_NoWorkitemsFoundException;
1830: else
1831:
1832: FOR i in 1..l_Counter LOOP
1833: wf_engine.StartProcess(itemtype => t_ChildTypes(i),
1834: itemkey => t_ChildKeys(i));
1835: END LOOP;
1836:
1837: end if;

Line 1936: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,

1932: ErrStr varchar2(1996);
1933:
1934: begin
1935:
1936: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,
1937: itemkey => LaunchWISeqProcess.itemkey,
1938: aname => 'ORDER_ID');
1939:
1940: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,

Line 1940: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,

1936: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,
1937: itemkey => LaunchWISeqProcess.itemkey,
1938: aname => 'ORDER_ID');
1939:
1940: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,
1941: itemkey => LaunchWISeqProcess.itemkey,
1942: aname => 'LINE_ITEM_ID');
1943:
1944: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,

Line 1944: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,

1940: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,
1941: itemkey => LaunchWISeqProcess.itemkey,
1942: aname => 'LINE_ITEM_ID');
1943:
1944: l_PrevSequence := wf_engine.GetItemAttrNumber(itemtype => LaunchWISeqProcess.itemtype,
1945: itemkey => LaunchWISeqProcess.itemkey,
1946: aname => 'CURRENT_WI_SEQUENCE');
1947:
1948: if c_WIList%ISOPEN then

Line 2012: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

2008: Raja: 04-Nov-1999
2009: Must set the parent child relation ships
2010: */
2011:
2012: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
2013: itemkey => t_ChildKeys(l_Counter),
2014: parent_itemtype => LaunchWISeqProcess.itemtype,
2015: parent_itemkey => LaunchWISeqProcess.itemkey,
2016: parent_context => null);

Line 2331: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => GetWIParamOnStart.itemtype,

2327: l_WIInstanceID NUMBER;
2328:
2329: begin
2330:
2331: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => GetWIParamOnStart.itemtype,
2332: itemkey => GetWIParamOnStart.itemkey,
2333: aname => 'WORKITEM_INSTANCE_ID');
2334:
2335: xdp_engine.EvaluateWIParamsOnStart(l_WIInstanceID );

Line 2490: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => GET_WI_RESPONSIBILITY.itemtype,

2486: l_WorkitemID NUMBER;
2487: x_progress varchar2(2000);
2488: BEGIN
2489:
2490: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => GET_WI_RESPONSIBILITY.itemtype,
2491: itemkey => GET_WI_RESPONSIBILITY.itemkey,
2492: aname => 'WORKITEM_INSTANCE_ID');
2493: BEGIN
2494: SELECT wis.role_name INTO l_wi_responsiblilty

Line 2550: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,

2546: ErrStr varchar2(1996);
2547:
2548: BEGIN
2549:
2550: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,
2551: itemkey => ResolveIndDepWIs.itemkey,
2552: aname => 'ORDER_ID');
2553:
2554: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,

Line 2554: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,

2550: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,
2551: itemkey => ResolveIndDepWIs.itemkey,
2552: aname => 'ORDER_ID');
2553:
2554: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepWIs.itemtype,
2555: itemkey => ResolveIndDepWIs.itemkey,
2556: aname => 'LINE_ITEM_ID');
2557:
2558: