APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_ORDER_HEADERS

Line 498: FROM oe_order_headers

494: oe_debug_pub.add( 'l_header_rec: packing instructions' ||l_header_rec.packing_instructions ) ;
495: END IF;
496: BEGIN
497: SELECT booked_flag INTO l_booked_flag
498: FROM oe_order_headers
499: WHERE header_id = l_header_rec.header_id;
500:
501: IF l_booked_flag = 'Y' THEN
502: l_header_rec.booked_flag := l_booked_flag;

Line 2050: From oe_order_headers

2046: nvl(l_header_rec.header_id,0) <> 0) Then
2047: Begin
2048: Select booked_flag,xml_message_id
2049: Into l_booked_flag,l_xml_message_id
2050: From oe_order_headers
2051: Where header_id = l_header_rec.header_id;
2052: If l_booked_flag = 'Y' Then
2053: l_header_rec.booked_flag := l_booked_flag;
2054: End If;