DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PB_INPUT_HEADERS_B

Line 1485: UPDATE qp_pb_input_headers_b

1481: x_retcode := 0;
1482: x_return_status := 'S';
1483:
1484: --Update the input header table with the request_id of the parent conc request
1485: UPDATE qp_pb_input_headers_b
1486: SET request_id = x_request_id
1487: WHERE pb_input_header_id = p_pb_input_header_id;
1488:
1489: COMMIT; --To complete parent concurrent request submission

Line 1881: DELETE FROM qp_pb_input_headers_b

1877:
1878: DELETE FROM qp_price_book_messages
1879: WHERE pb_input_header_id = l_old_input_header_id;
1880:
1881: DELETE FROM qp_pb_input_headers_b
1882: WHERE pb_input_header_id = l_old_input_header_id;
1883:
1884: DELETE FROM qp_pb_input_headers_tl
1885: WHERE pb_input_header_id = l_old_input_header_id;

Line 1965: DELETE FROM qp_pb_input_headers_b

1961:
1962: DELETE FROM qp_price_book_messages
1963: WHERE pb_input_header_id = l_delta_input_header_id;
1964:
1965: DELETE FROM qp_pb_input_headers_b
1966: WHERE pb_input_header_id = l_delta_input_header_id;
1967:
1968: DELETE FROM qp_pb_input_headers_tl
1969: WHERE pb_input_header_id = l_delta_input_header_id;

Line 2589: FROM QP_PB_INPUT_HEADERS_B

2585: fnd_file.put_line(FND_FILE.LOG,'Begin Publishing');
2586: /** KDURGASI **/
2587: SELECT PUB_OUTPUT_DOCUMENT_TYPE
2588: INTO l_document_type
2589: FROM QP_PB_INPUT_HEADERS_B
2590: WHERE pb_input_header_id = p_pb_input_header_id;
2591:
2592: QP_PRICE_BOOK_UTIL.GENERATE_PRICE_BOOK_XML
2593: (