[Home] [Help]
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
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'
317: p_online_report_id IN NUMBER,
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2,
320: x_return_status OUT NOCOPY VARCHAR2,
321: p_user_id IN po_lines.last_updated_by%TYPE,
322: p_login_id IN po_lines.last_update_login%TYPE ,
323: po_sesiongt_key IN po_session_gt.key%TYPE)
324:
325: IS
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2,
320: x_return_status OUT NOCOPY VARCHAR2,
321: p_user_id IN po_lines.last_updated_by%TYPE,
322: p_login_id IN po_lines.last_update_login%TYPE ,
323: po_sesiongt_key IN po_session_gt.key%TYPE)
324:
325: IS
326:
345: -- SQL Why: To prevent others from modifying the document.
346: CURSOR lock_po_csr IS
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
364: -- SQL Why: To prevent others from modifying the document.
365: CURSOR lock_pa_csr IS
366: SELECT 1
367: FROM po_headers POH,
368: po_lines POL,
369: po_line_locations PLL,
370: po_session_gt gt
371: WHERE gt.KEY=po_sesiongt_key
372: AND POH.po_header_id =gt.char4