APPS.OE_SHIPPING_WF dependencies on OE_ORDER_LINES_ALL

Line 31: FROM oe_order_lines_all

27: IF G_FREEZE_II = 'PICK RELEASE' THEN
28:
29: SELECT item_type_code,ato_line_id,explosion_date
30: INTO l_item_type,l_ato_line_id,l_explosion_date
31: FROM oe_order_lines_all
32: WHERE line_id = to_number(itemkey);
33:
34: IF l_debug_level > 0 THEN
35: OE_DEBUG_PUB.Add('Item Type:'||l_item_type);

Line 273: FROM oe_order_lines_all

269: oe_debug_pub.add( 'BEFORE LOCKING THE TOP LINE '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
270: END IF;
271: SELECT line_id, top_model_line_id
272: INTO l_line_id, l_top_model_line_id
273: FROM oe_order_lines_all
274: WHERE line_id = l_top_model_line_id
275: FOR UPDATE NOWAIT;
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'TOP LINE LOCKED AT '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

Line 285: FROM oe_order_lines_all

281: --bug 3814076
282: l_itemkey := to_number(itemkey);
283: SELECT line_id
284: INTO l_line_id
285: FROM oe_order_lines_all
286: WHERE line_id = l_itemkey
287: FOR UPDATE NOWAIT;
288:
289: END IF;

Line 352: from oe_order_lines_all

348:
349: resultout := 'COMPLETE';
350: select header_id
351: into l_header_id
352: from oe_order_lines_all
353: where line_id = to_number(itemkey);
354:
355: oe_msg_pub.initialize;
356: oe_msg_pub.set_process_activity(actid);