[Home] [Help]
59: -- SQL Why: To prevent others from modifying the document.
60: CURSOR lock_po_csr IS
61: SELECT 1
62: FROM po_headers POH, po_lines POL, po_line_locations PLL,
63: po_distributions POD
64: WHERE POH.po_header_id = p_document_id
65: AND POH.po_header_id = POL.po_header_id (+) -- JOIN
66: AND POL.po_line_id = PLL.po_line_id (+) -- JOIN
67: -- Need NVL(..) because we cannot use (+) with the IN operator:
84: -- SQL What: Locks the release and all its shipments and distributions.
85: -- SQL Why: To prevent others from modifying the document.
86: CURSOR lock_release_csr IS
87: SELECT 1
88: FROM po_releases POR, po_line_locations PLL, po_distributions POD
89: WHERE POR.po_release_id = p_document_id
90: AND POR.po_release_id = PLL.po_release_id (+) -- JOIN
91: AND PLL.line_location_id = POD.line_location_id (+) -- JOIN
92: FOR UPDATE NOWAIT;
347: SELECT 1
348: FROM po_headers POH,
349: po_lines POL,
350: po_line_locations PLL,
351: po_distributions POD,
352: po_session_gt gt
353: WHERE gt.KEY=po_sesiongt_key
354: AND POH.po_header_id =gt.char4
355: AND gt.char1 = 'PO'
380: -- SQL Why: To prevent others from modifying the document.
381: CURSOR lock_release_csr IS
382: SELECT 1
383: FROM po_releases POR, po_line_locations PLL,
384: po_distributions POD,
385: po_session_gt gt
386: WHERE gt.KEY=po_sesiongt_key
387: AND POR.po_release_id =gt.char4
388: AND gt.char1 = 'RELEASE'