47: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
48: d_api_version CONSTANT NUMBER := 1.0;
49:
50: l_mod_number VARCHAR2(100);
51: l_document_id po_drafts.document_id%TYPE;
52: l_seq_for_item_key VARCHAR2(100) := NULL;
53: l_itemkey VARCHAR2(100);
54: l_itemtype VARCHAR2(100);
55: l_requestor_user_name VARCHAR2(100);
80: SELECT modification_number,
81: document_id
82: INTO l_mod_number,
83: l_document_id
84: FROM po_drafts
85: WHERE draft_id = p_lock_by_draft_id;
86: EXCEPTION
87: WHEN no_data_found THEN
88: RAISE;