APPS.XDP_OA_UTIL dependencies on XDP_WORKITEMS

Line 147: from xdp_workitems

143: -- Change: obsoleted the following cursor.
144: -- The singleton SELECT for workitem details validates the WI and Ver better.
145: /* CURSOR lc_wi IS
146: select workitem_id
147: from xdp_workitems
148: where workitem_name = p_workitem_name;
149: */
150: BEGIN
151:

Line 175: -- from xdp_workitems

171: -- into lv_wi_id,
172: -- g_Workitem_Name,
173: -- g_Validation_Procedure,
174: -- g_Validation_Enabled_Flag
175: -- from xdp_workitems
176: -- where workitem_name = p_workitem_name and
177: -- version = p_workitem_version;
178: -- ELSE
179: -- lv_wi_id := NULL;

Line 214: FROM xdp_workitems

210: INTO lv_wi_id,
211: g_Workitem_Name,
212: g_Validation_Procedure,
213: g_Validation_Enabled_Flag
214: FROM xdp_workitems
215: WHERE workitem_name = p_workitem_name
216: AND version = p_workitem_version;
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN

Line 347: from xdp_workitems

343: select workitem_id,workitem_name,validation_procedure,
344: validation_enabled_flag
345: into lv_wi_id,g_Workitem_Name,g_Validation_Procedure,
346: g_Validation_Enabled_Flag
347: from xdp_workitems
348: where workitem_id = p_workitem_id;
349:
350: if p_provisioning_date is not null then
351: lv_prov_date := p_provisioning_date;

Line 1593: xdp_workitems wim

1589: priority,
1590: status_code
1591: from
1592: XDP_FULFILL_WORKLIST fwt,
1593: xdp_workitems wim
1594: where
1595: fwt.workitem_instance_id = p_wi_instance_id and
1596: fwt.workitem_id = wim.workitem_id
1597: order by fwt.line_item_id;

Line 1635: xdp_workitems wim

1631: priority,
1632: status_code
1633: from
1634: XDP_FULFILL_WORKLIST fwt,
1635: xdp_workitems wim
1636: where
1637: fwt.order_id = p_sdp_order_id and
1638: fwt.workitem_id = wim.workitem_id
1639: order by fwt.line_item_id;