DBA Data[Home] [Help]

APPS.XDPCORE_WI dependencies on XDP_WORKITEMS

Line 625: SELECT workitem_name INTO l_WorkItemName from xdp_workitems WHERE workitem_id = l_workitemID;

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,
629: AttrName => 'WORKITEM_NAME',

Line 1448: from XDP_WORKITEMS

1444: NVL(USER_WF_ITEM_KEY_PREFIX, null) ITEM_KEY_PREFIX ,
1445: NVL(USER_WF_PROCESS_NAME, null) PROCESS_NAME,
1446: NVL(WF_EXEC_PROC, null) WF_EXEC_PROC,
1447: NVL(FA_EXEC_MAP_PROC, null) FA_EXEC_MAP_PROC
1448: from XDP_WORKITEMS
1449: where WORKITEM_ID = CheckIfWorkItemIsaWorkflow.workitem_ID;
1450:
1451: begin
1452:

Line 2495: FROM xdp_workitems wis

2491: itemkey => GET_WI_RESPONSIBILITY.itemkey,
2492: aname => 'WORKITEM_INSTANCE_ID');
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:

Line 2592: FROM XDP_WORKITEMS_VL wis

2588: l_display_name varchar2(100);
2589:
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;