DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_HEADERS_B

Line 1852: DELETE FROM qp_price_book_headers_b

1848: fnd_file.put_line(FND_FILE.LOG, errbuf);
1849: RETURN;
1850:
1851: ELSE --Old Request is Null or Completed
1852: DELETE FROM qp_price_book_headers_b
1853: WHERE price_book_header_id = l_overwrite_pb_header_id
1854: RETURNING pb_input_header_id, document_id
1855: INTO l_old_input_header_id, l_document_id;
1856:

Line 1936: DELETE FROM qp_price_book_headers_b

1932: fnd_file.put_line(FND_FILE.LOG, errbuf);
1933: RETURN;
1934:
1935: ELSE --Old Delta Request is Null or Complete
1936: DELETE FROM qp_price_book_headers_b
1937: WHERE price_book_header_id = l_corr_delta_pb_header_id
1938: RETURNING pb_input_header_id, document_id
1939: INTO l_delta_input_header_id, l_delta_document_id;
1940:

Line 2393: UPDATE qp_price_book_headers_b

2389: ELSE --submit request successful
2390: errbuf := '';
2391: retcode := 0;
2392:
2393: UPDATE qp_price_book_headers_b
2394: SET request_id = l_child_request_id
2395: WHERE price_book_header_id = l_publish_price_book_header_id;
2396:
2397: COMMIT; --to complete request submission