APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_LINE_DETAILS

Line 55: FROM qp_price_book_line_details

51: a_deleted_line_id_first NUMBER,
52: a_deleted_line_id_last NUMBER)
53: IS
54: SELECT price_book_line_det_id, price_book_line_id
55: FROM qp_price_book_line_details
56: WHERE price_book_header_id = a_full_price_book_header_id
57: AND price_book_line_id IN (SELECT a.price_book_line_id
58: FROM qp_price_book_lines a
59: WHERE a.price_book_header_id =

Line 211: DELETE FROM qp_price_book_line_details

207: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
208:
209: --Delete the price book line details
210: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST
211: DELETE FROM qp_price_book_line_details
212: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
213:
214: --Delete the price book lines
215: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST

Line 1344: INSERT INTO qp_price_book_line_details

1340:
1341: --Insert records into the price book line details table from the line
1342: --details temp table
1343: FORALL j IN l_line_id_tbl.FIRST..l_line_id_tbl.LAST
1344: INSERT INTO qp_price_book_line_details
1345: (price_book_line_det_id, price_book_line_id,
1346: price_book_header_id,
1347: list_header_id, list_line_id,
1348: list_line_no, list_price,

Line 1356: (qp_price_book_line_details_s.nextval, l_line_id_tbl(j),

1352: creation_date, created_by, last_update_date,
1353: last_updated_by, last_update_login
1354: )
1355: VALUES
1356: (qp_price_book_line_details_s.nextval, l_line_id_tbl(j),
1357: p_price_book_header_id,
1358: l_cf_list_header_id_tbl(j), l_cf_list_line_id_tbl(j),
1359: decode(l_pricing_phase_id_tbl(j), 1, null, l_list_line_no_tbl(j)),
1360: --insert null for list_line_no in case of PLL, PBH price list line

Line 1844: DELETE FROM qp_price_book_line_details

1840:
1841: DELETE FROM qp_price_book_lines
1842: WHERE price_book_header_id = l_overwrite_pb_header_id;
1843:
1844: DELETE FROM qp_price_book_line_details
1845: WHERE price_book_header_id = l_overwrite_pb_header_id;
1846:
1847: DELETE FROM qp_price_book_attributes
1848: WHERE price_book_header_id = l_overwrite_pb_header_id;

Line 1928: DELETE FROM qp_price_book_line_details

1924:
1925: DELETE FROM qp_price_book_lines
1926: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1927:
1928: DELETE FROM qp_price_book_line_details
1929: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1930:
1931: DELETE FROM qp_price_book_attributes
1932: WHERE price_book_header_id = l_corr_delta_pb_header_id;

Line 2458: FROM qp_price_book_line_details

2454: l_net_price := nvl(l_list_price_tbl(i), 0);
2455:
2456: SELECT price_book_line_det_id, adjustment_amount
2457: BULK COLLECT INTO l_line_det_id_tbl, l_adjustment_amount_tbl
2458: FROM qp_price_book_line_details
2459: WHERE price_book_line_id = l_line_id_tbl(i)
2460: ORDER BY price_book_line_det_id;
2461:
2462: IF l_line_det_id_tbl.COUNT > 0 THEN

Line 2484: UPDATE qp_price_book_line_details

2480: --Bulk update price book line details with cumulative net prices
2481: --for all line details belonging to all lines in current iteration of
2482: --pb_lines_cur
2483: FORALL m IN l_line_det_id_tbl2.FIRST..l_line_det_id_tbl2.LAST
2484: UPDATE qp_price_book_line_details
2485: SET adjusted_net_price = l_net_price_tbl(m)
2486: WHERE price_book_line_det_id = l_line_det_id_tbl2(m);
2487:
2488: --Bulk update the net price on the summary price book line to the