DBA Data[Home] [Help]

APPS.OE_DROP_SHIP_PVT dependencies on PO_HEADERS

Line 13: l_status := po_headers_sv3.get_po_status(p_po_header_id);

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

Line 77: from po_headers poh,

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