7465: BEGIN
7466:
7467: SELECT draft_id
7468: INTO p_draft_id
7469: FROM po_drafts DFT
7470: WHERE DFT.document_id = p_req_header_id
7471: AND DFT.status in ('DRAFT')
7472: AND DFT.creation_date = (SELECT Max(creation_date)
7473: FROM po_drafts
7469: FROM po_drafts DFT
7470: WHERE DFT.document_id = p_req_header_id
7471: AND DFT.status in ('DRAFT')
7472: AND DFT.creation_date = (SELECT Max(creation_date)
7473: FROM po_drafts
7474: WHERE document_id = p_req_header_id
7475: AND status in ('DRAFT'));
7476:
7477: EXCEPTION