DBA Data[Home] [Help]

APPS.PO_LOCKS dependencies on PO_REQUISITION_HEADERS_ALL

Line 48: -- PO_REQUISITION_HEADERS_ALL

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:
52: --IN:

Line 94: PO_REQUISITION_HEADERS_ALL PRH

90:
91: CURSOR l_lock_req_csr(p_doc_id_key NUMBER) IS
92: SELECT NULL
93: FROM
94: PO_REQUISITION_HEADERS_ALL PRH
95: , PO_SESSION_GT IDS
96: WHERE PRH.requisition_header_id = IDS.num1
97: AND IDS.key = p_doc_id_key
98: FOR UPDATE OF PRH.requisition_header_id

Line 130: PO_REQUISITION_HEADERS_ALL PRH

126:
127: CURSOR l_rcv_lock_req_csr(p_doc_id_key NUMBER) IS
128: SELECT NULL
129: FROM
130: PO_REQUISITION_HEADERS_ALL PRH
131: , PO_SESSION_GT IDS
132: WHERE PRH.requisition_header_id = IDS.num1
133: AND IDS.key = p_doc_id_key
134: FOR UPDATE