DBA Data[Home] [Help]

APPS.PO_CONC_MODS_PVT dependencies on PO_DRAFTS

Line 51: l_document_id po_drafts.document_id%TYPE;

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);

Line 84: FROM po_drafts

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;