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
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