[Home] [Help]
148: where workitem_name = p_workitem_name;
149: */
150: BEGIN
151:
152: select XDP_FULFILL_WORKLIST_S.nextval
153: into lv_instance_id
154: from dual;
155:
156: select order_id,
329:
330:
331: BEGIN
332:
333: select XDP_FULFILL_WORKLIST_S.nextval
334: into lv_instance_id
335: from dual;
336:
337: select order_id,line_number into lv_order_id,lv_line_number