830: l_po_number VARCHAR2 (30);
831: BEGIN
832: SELECT segment1
833: INTO l_po_number
834: FROM po_headers_all
835: WHERE po_header_id = p_po_header_id;
836: RETURN l_po_number;
837: EXCEPTION
838: WHEN OTHERS
1531: l_po_number VARCHAR2 (30);
1532: BEGIN
1533: SELECT segment1
1534: INTO l_po_number
1535: FROM po_headers_all
1536: WHERE po_header_id = p_po_header_id
1537: AND org_id = p_org_id;
1538:
1539: RETURN l_po_number;