APPS.PO_DOCUMENT_LOCK_GRP dependencies on PO_HEADERS

Line 62: FROM po_headers POH, po_lines POL, po_line_locations PLL,

58: -- distributions of the PO.
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

Line 77: FROM po_headers POH, po_lines POL, po_line_locations PLL

73: -- SQL What: Locks the header and all the lines and price breaks of the PA.
74: -- SQL Why: To prevent others from modifying the document.
75: CURSOR lock_pa_csr IS
76: SELECT 1
77: FROM po_headers POH, po_lines POL, po_line_locations PLL
78: WHERE POH.po_header_id = p_document_id
79: AND POH.po_header_id = POL.po_header_id (+) -- JOIN
80: AND POL.po_line_id = PLL.po_line_id (+) -- JOIN
81: AND PLL.shipment_type (+) = 'PRICE BREAK'

Line 133: FROM po_headers

129: -- Verify that the PO exists.
130: BEGIN
131: SELECT 1
132: INTO l_dummy
133: FROM po_headers
134: WHERE po_header_id = p_document_id
135: AND type_lookup_code IN ('STANDARD','PLANNED');
136: EXCEPTION
137: WHEN no_data_found THEN

Line 157: FROM po_headers

153: -- Verify that the PA exists.
154: BEGIN
155: SELECT 1
156: INTO l_dummy
157: FROM po_headers
158: WHERE po_header_id = p_document_id
159: AND type_lookup_code IN ('BLANKET','CONTRACT');
160: EXCEPTION
161: WHEN no_data_found THEN