DBA Data[Home] [Help]

APPS.PO_LOCKS dependencies on PO_RELEASES_ALL

Line 47: -- PO_RELEASES_ALL

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:

Line 105: PO_RELEASES_ALL POR

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

Line 140: PO_RELEASES_ALL POR

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