9: ) return VARCHAR2
10: IS
11: l_status VARCHAR2(25);
12: BEGIN
13: l_status := po_headers_sv3.get_po_status(p_po_header_id);
14: return(l_status);
15: EXCEPTION
16: WHEN OTHERS THEN
17: return(NULL);
73: end;
74:
75: begin
76: select user_hold_flag into po_hold_exists
77: from po_headers poh,
78: so_drop_ship_sources sodss
79: where
80: sodss.header_id = p_headerid
81: and sodss.line_id = p_lineid