263: workitem_name, wi_type_code
264: into
265: x_workitem_name,lv_type
266: from
267: xdp_workitems wim
268: where
269: wim.workitem_id = p_workitem_id;
270: if lv_type not in ('STATIC','DYNAMIC') then
271: return_code := -191272;
347: lv_order_id,
348: lv_wi,
349: lv_line_item_id
350: from
351: xdp_workitems wim,
352: XDP_FULFILL_WORKLIST fwt
353: where
354: wim.workitem_id = fwt.workitem_id and
355: fwt.workitem_instance_id = p_workitem_instance_id;