43: --Modifies:
44: -- None.
45: --Locks:
46: -- PO_HEADERS_ALL
47: -- PO_RELEASES_ALL
48: -- PO_REQUISITION_HEADERS_ALL
49: --Function:
50: -- Locks the document headers of the given ids.
51: --Parameters:
101:
102: CURSOR l_lock_release_csr(p_doc_id_key NUMBER) IS
103: SELECT NULL
104: FROM
105: PO_RELEASES_ALL POR
106: , PO_SESSION_GT IDS
107: WHERE POR.po_release_id = IDS.num1
108: AND IDS.key = p_doc_id_key
109: FOR UPDATE OF POR.po_release_id
136:
137: CURSOR l_rcv_lock_release_csr(p_doc_id_key NUMBER) IS
138: SELECT NULL
139: FROM
140: PO_RELEASES_ALL POR
141: , PO_SESSION_GT IDS
142: WHERE POR.po_release_id = IDS.num1
143: AND IDS.key = p_doc_id_key
144: FOR UPDATE