DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_HEADERS_ALL

Line 5526: l_hdr_fstat oe_order_headers_all.flow_status_code%TYPE;

5522: ( p_header_rec.header_id IS NOT NULL ) AND
5523: ( Nvl(x_header_rec.flow_status_code, 'NULL') = 'NULL' )
5524: THEN
5525: DECLARE
5526: l_hdr_fstat oe_order_headers_all.flow_status_code%TYPE;
5527: BEGIN
5528: SELECT h.flow_status_code
5529: INTO l_hdr_fstat
5530: FROM oe_order_headers_all h

Line 5530: FROM oe_order_headers_all h

5526: l_hdr_fstat oe_order_headers_all.flow_status_code%TYPE;
5527: BEGIN
5528: SELECT h.flow_status_code
5529: INTO l_hdr_fstat
5530: FROM oe_order_headers_all h
5531: WHERE h.header_id = p_header_rec.header_id;
5532:
5533: x_header_rec.flow_status_code := l_hdr_fstat;
5534: EXCEPTION