DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_HEADERS_ALL_B

Line 2542: FROM qp_price_book_headers_all_b

2538: BEGIN
2539: --select the previous document_id if it exists on the price book
2540: SELECT document_id
2541: INTO l_document_id
2542: FROM qp_price_book_headers_all_b
2543: WHERE price_book_header_id = p_price_book_header_id;
2544: EXCEPTION
2545: WHEN OTHERS THEN
2546: l_document_id := null;

Line 2550: UPDATE qp_price_book_headers_all_b

2546: l_document_id := null;
2547: END;
2548:
2549: IF l_document_id IS NOT NULL THEN
2550: UPDATE qp_price_book_headers_all_b
2551: SET document_id = null
2552: WHERE price_book_header_id = p_price_book_header_id;
2553:
2554: DELETE FROM qp_documents