11: FUNCTION get_po_number (X_po_header_id IN NUMBER)
12: RETURN VARCHAR2 IS
13:
14: X_progress VARCHAR2(3) := NULL;
15: X_po_number PO_HEADERS.segment1%TYPE := NULL;
16:
17: BEGIN
18:
19: X_progress := '005';
23: ELSE
24:
25: SELECT POH.segment1
26: INTO X_po_number
27: FROM PO_HEADERS_ALL POH -- FPI GA
28: WHERE POH.PO_HEADER_ID = X_po_header_id;
29:
30: return(x_po_number);
31:
430: IF X_po_header_id is not NULL THEN
431:
432: SELECT POH.global_agreement_flag, POH.org_id
433: INTO X_ga_flag, X_owning_org_id
434: FROM PO_HEADERS_ALL POH
435: WHERE POH.PO_HEADER_ID = X_po_header_id;
436:
437: SELECT name
438: INTO X_owning_org_name