DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_HEADERS_B

Line 1833: DELETE FROM qp_price_book_headers_b

1829: fnd_file.put_line(FND_FILE.LOG, errbuf);
1830: RETURN;
1831:
1832: ELSE --Old Request is Null or Completed
1833: DELETE FROM qp_price_book_headers_b
1834: WHERE price_book_header_id = l_overwrite_pb_header_id
1835: RETURNING pb_input_header_id, document_id
1836: INTO l_old_input_header_id, l_document_id;
1837:

Line 1917: DELETE FROM qp_price_book_headers_b

1913: fnd_file.put_line(FND_FILE.LOG, errbuf);
1914: RETURN;
1915:
1916: ELSE --Old Delta Request is Null or Complete
1917: DELETE FROM qp_price_book_headers_b
1918: WHERE price_book_header_id = l_corr_delta_pb_header_id
1919: RETURNING pb_input_header_id, document_id
1920: INTO l_delta_input_header_id, l_delta_document_id;
1921:

Line 2372: UPDATE qp_price_book_headers_b

2368: ELSE --submit request successful
2369: errbuf := '';
2370: retcode := 0;
2371:
2372: UPDATE qp_price_book_headers_b
2373: SET request_id = l_child_request_id
2374: WHERE price_book_header_id = l_publish_price_book_header_id;
2375:
2376: COMMIT; --to complete request submission