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 XDP_FULFILL_WORKLIST

Line 624: SELECT workitem_id INTO l_workitemID FROM xdp_fulfill_worklist WHERE workitem_instance_id = l_WIInstanceID;

620: xdp_engine.EvaluateWIParamsOnStart(l_WIInstanceID );
621: EXCEPTION
622: WHEN OTHERS THEN
623: -- Evaluation procedure for this WI failed..
624: SELECT workitem_id INTO l_workitemID FROM xdp_fulfill_worklist WHERE workitem_instance_id = l_WIInstanceID;
625: SELECT workitem_name INTO l_WorkItemName from xdp_workitems WHERE workitem_id = l_workitemID;
626:
627: XDPCORE.CheckNAddItemAttrText ( itemtype => evaluateWIParams.itemtype,
628: itemkey => evaluateWIParams.itemkey,

Line 662: from XDP_FULFILL_WORKLIST

658:
659:
660: cursor c_GetWIList (OrderID number, LineItemID number) is
661: select WORKITEM_INSTANCE_ID
662: from XDP_FULFILL_WORKLIST
663: where ORDER_ID = Order_ID
664: and LINE_ITEM_ID = LineItemID
665: and status_code = 'STANDBY'
666: ORDER BY WI_SEQUENCE;

Line 963: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

959: x_Progress := x_Progress || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
960: RAISE e_AddWFItemException;
961: end if;
962:
963: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
964: /*
965: update XDP_FULFILL_WORKLIST
966: set WF_ITEM_TYPE = l_WFItemType,
967: WF_ITEM_KEY = l_WFItemKey,

Line 965: update XDP_FULFILL_WORKLIST

961: end if;
962:
963: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
964: /*
965: update XDP_FULFILL_WORKLIST
966: set WF_ITEM_TYPE = l_WFItemType,
967: WF_ITEM_KEY = l_WFItemKey,
968: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
969: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 998: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

994: x_Progress := x_Progress || l_UserWFProcess || ' for Workitem: ' || l_WorkitemID || ' Order: ' || l_OrderID || ' Workitem InstanceID: ' || l_WIInstanceID || ' LineItemID: ' || l_LineItemID || ' Error: '|| SUBSTR(l_ErrDescription, 1, 1500);
995: RAISE e_UserWFCreateException;
996: end if;
997:
998: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
999: /*
1000: update XDP_FULFILL_WORKLIST
1001: set WF_ITEM_TYPE = l_WFItemType,
1002: WF_ITEM_KEY = l_WFItemKey,

Line 1000: update XDP_FULFILL_WORKLIST

996: end if;
997:
998: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
999: /*
1000: update XDP_FULFILL_WORKLIST
1001: set WF_ITEM_TYPE = l_WFItemType,
1002: WF_ITEM_KEY = l_WFItemKey,
1003: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1004: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1050: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

1046: RAISE e_InvalidWITypeException;
1047:
1048: end if;
1049:
1050: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1051:
1052: update XDP_FULFILL_WORKLIST
1053: set WF_ITEM_TYPE = l_WFItemType,
1054: WF_ITEM_KEY = l_WFItemKey,

Line 1052: update XDP_FULFILL_WORKLIST

1048: end if;
1049:
1050: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1051:
1052: update XDP_FULFILL_WORKLIST
1053: set WF_ITEM_TYPE = l_WFItemType,
1054: WF_ITEM_KEY = l_WFItemKey,
1055: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1056: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1132: from XDP_FULFILL_WORKLIST

1128: l_result varchar2(1) := 'N';
1129:
1130: cursor c_GetIndWIList (OrderID number, LineItemID number) is
1131: select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY
1132: from XDP_FULFILL_WORKLIST
1133: where ORDER_ID = Order_ID
1134: and LINE_ITEM_ID = LineItemID
1135: and status_code = 'STANDBY'
1136: and WI_SEQUENCE = 0;

Line 1309: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

1305: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1306: RAISE e_AddWFItemException;
1307: end if;
1308:
1309: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1310: /*
1311: update XDP_FULFILL_WORKLIST
1312: set WF_ITEM_TYPE = l_WFItemType,
1313: WF_ITEM_KEY = l_WFItemKey,

Line 1311: update XDP_FULFILL_WORKLIST

1307: end if;
1308:
1309: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1310: /*
1311: update XDP_FULFILL_WORKLIST
1312: set WF_ITEM_TYPE = l_WFItemType,
1313: WF_ITEM_KEY = l_WFItemKey,
1314: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1346: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

1342: x_Progress := x_Progress || ' Order: ' || p_OrderID || ' Workitem InstanceID: ' || p_WIInstanceID || ' LineItemID: ' || p_LineItemID || ' Error: ' || SUBSTR(l_ErrDescription, 1, 1500);
1343: RAISE e_UserWFCreateException;
1344: end if;
1345:
1346: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1347: /*
1348: update XDP_FULFILL_WORKLIST
1349: set WF_ITEM_TYPE = l_WFItemType,
1350: WF_ITEM_KEY = l_WFItemKey,

Line 1348: update XDP_FULFILL_WORKLIST

1344: end if;
1345:
1346: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1347: /*
1348: update XDP_FULFILL_WORKLIST
1349: set WF_ITEM_TYPE = l_WFItemType,
1350: WF_ITEM_KEY = l_WFItemKey,
1351: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1352: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1398: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

1394:
1395: end if;
1396:
1397:
1398: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1399:
1400: update XDP_FULFILL_WORKLIST
1401: set WF_ITEM_TYPE = l_WFItemType,
1402: WF_ITEM_KEY = l_WFItemKey,

Line 1400: update XDP_FULFILL_WORKLIST

1396:
1397:
1398: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
1399:
1400: update XDP_FULFILL_WORKLIST
1401: set WF_ITEM_TYPE = l_WFItemType,
1402: WF_ITEM_KEY = l_WFItemKey,
1403: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1404: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1482: from XDP_FULFILL_WORKLIST

1478: CURSOR c_ContinueWI(p_OrderID number) is
1479: select 'Y' yahoo
1480: from dual
1481: where exists (select WORKITEM_INSTANCE_ID
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,

Line 1498: from XDP_FULFILL_WORKLIST

1494: /*
1495: begin
1496: select 'Y' into l_Continue from dual
1497: where exists (select WORKITEM_INSTANCE_ID
1498: from XDP_FULFILL_WORKLIST
1499: where ORDER_ID = l_OrderID
1500: and status_code = 'READY' );
1501:
1502: exception

Line 1680: from XDP_FULFILL_WORKLIST

1676:
1677:
1678: cursor c_GetIndWIList (OrderID number, LineItemID number) is
1679: select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY
1680: from XDP_FULFILL_WORKLIST
1681: where ORDER_ID = Order_ID
1682: and LINE_ITEM_ID = LineItemID
1683: and status_code = 'STANDBY'
1684: and WI_SEQUENCE = 0;

Line 1688: from XDP_FULFILL_WORKLIST

1684: and WI_SEQUENCE = 0;
1685:
1686: cursor c_GetDepWIList (OrderID number, LineItemID number) is
1687: select WORKITEM_INSTANCE_ID
1688: from XDP_FULFILL_WORKLIST
1689: where ORDER_ID = Order_ID
1690: and LINE_ITEM_ID = LineItemID
1691: and status_code = 'STANDBY'
1692: and WI_SEQUENCE > 0;

Line 2068: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

2064: || SUBSTR(l_ErrDescription, 1, 1500);
2065: RAISE e_AddWFItemException;
2066: end if;
2067:
2068: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2069: /*
2070: update XDP_FULFILL_WORKLIST
2071: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2072: WF_ITEM_KEY = t_ChildKeys(l_Counter),

Line 2070: update XDP_FULFILL_WORKLIST

2066: end if;
2067:
2068: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2069: /*
2070: update XDP_FULFILL_WORKLIST
2071: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2072: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2073: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2074: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2113: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

2109: RAISE e_UserWFCreateException;
2110: end if;
2111:
2112:
2113: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2114: /*
2115: update XDP_FULFILL_WORKLIST
2116: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2117: WF_ITEM_KEY = t_ChildKeys(l_Counter),

Line 2115: update XDP_FULFILL_WORKLIST

2111:
2112:
2113: -- /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2114: /*
2115: update XDP_FULFILL_WORKLIST
2116: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2117: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2118: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2119: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2191: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

2187: x_progress := 'In XDPCORE_WI.LaunchWISeqProcess. Error when adding Item Attribute CURRENT_WI_SEQUENCE. Error: ' || substr(ErrStr,1,1500);
2188: raise e_AddAttributeException;
2189: end if;
2190:
2191: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2192:
2193: update XDP_FULFILL_WORKLIST
2194: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2195: WF_ITEM_KEY = t_ChildKeys(l_Counter),

Line 2193: update XDP_FULFILL_WORKLIST

2189: end if;
2190:
2191: /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */
2192:
2193: update XDP_FULFILL_WORKLIST
2194: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2195: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2196: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2197: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2357: XDP_FULFILL_WORKLIST

2353:
2354:
2355: cursor c_GetWIState(p_WIInstanceID number) is
2356: select status_code, line_item_id from
2357: XDP_FULFILL_WORKLIST
2358: where workitem_instance_id = p_WIInstanceID
2359: for update;
2360:
2361: cursor c_GetLineState(p_LineItemID number) is

Line 2439: UPDATE xdp_fulfill_worklist

2435: PRAGMA AUTONOMOUS_TRANSACTION ;
2436: x_progress VARCHAR2(20000);
2437: BEGIN
2438:
2439: UPDATE xdp_fulfill_worklist
2440: SET status_code = p_status_code ,
2441: wf_item_type = p_itemtype ,
2442: wf_item_key = p_itemkey ,
2443: last_update_date = sysdate,

Line 2468: FROM xdp_fulfill_worklist

2464:
2465: BEGIN
2466: SELECT provisioning_date
2467: INTO l_prov_date
2468: FROM xdp_fulfill_worklist
2469: WHERE workitem_instance_id = p_workitem_instance_id ;
2470:
2471: RETURN l_prov_date;
2472:

Line 2497: from xdp_fulfill_worklist lst

2493: BEGIN
2494: SELECT wis.role_name INTO l_wi_responsiblilty
2495: FROM xdp_workitems wis
2496: WHERE wis.workitem_id in ( select lst.workitem_id
2497: from xdp_fulfill_worklist lst
2498: WHERE lst.workitem_instance_id = l_WIInstanceID);
2499:
2500: EXCEPTION
2501:

Line 2527: from XDP_FULFILL_WORKLIST

2523: l_DepFound number := 0;
2524:
2525: cursor c_GetIndWIList (OrderID number, LineItemID number) is
2526: select 'Y'
2527: from XDP_FULFILL_WORKLIST
2528: where ORDER_ID = Order_ID
2529: and LINE_ITEM_ID = LineItemID
2530: and status_code = 'STANDBY'
2531: and WI_SEQUENCE = 0;

Line 2535: from XDP_FULFILL_WORKLIST

2531: and WI_SEQUENCE = 0;
2532:
2533: cursor c_GetDepWIList (OrderID number, LineItemID number) is
2534: select 'Y'
2535: from XDP_FULFILL_WORKLIST
2536: where ORDER_ID = Order_ID
2537: and LINE_ITEM_ID = LineItemID
2538: and status_code = 'STANDBY'
2539: and WI_SEQUENCE > 0;

Line 2594: FROM xdp_fulfill_worklist lst

2590: BEGIN
2591: SELECT display_name into l_display_name
2592: FROM XDP_WORKITEMS_VL wis
2593: WHERE wis.workitem_id IN ( SELECT lst.workitem_id
2594: FROM xdp_fulfill_worklist lst
2595: WHERE workitem_instance_id = p_WIInstanceID );
2596: return l_display_name;
2597:
2598: EXCEPTION