149: SELECT nvl(phm.status, 'DRAFT'),
150: nvl(phm.closed_code, 'OPEN'),
151: nvl(phm.frozen_flag, 'N'),
152: nvl(phm.user_hold_flag, 'N')
153: FROM po_headers_merge_v phm
154: WHERE phm.po_header_id = docid
155: and phm.draft_id= draftId;
156:
157: CURSOR state_req(docid NUMBER) IS
632: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
633: BEGIN
634: SELECT poh.agent_id
635: INTO x_preparer_id
636: FROM po_headers_merge_v poh
637: WHERE poh.po_header_id = p_document_id
638: AND poh.draft_id = p_draft_id;
639: EXCEPTION
640: WHEN OTHERS THEN
1079: poh.revision_num
1080: INTO l_old_status,
1081: l_creation_date,
1082: l_revision_num
1083: FROM PO_HEADERS_MERGE_V poh
1084: WHERE poh.po_header_id = p_document_id
1085: AND poh.draft_id = p_draft_id;
1086:
1087: ELSE