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 1324: INSERT INTO qp_price_book_line_details

1320:
1321: --Insert records into the price book line details table from the line
1322: --details temp table
1323: FORALL j IN l_line_id_tbl.FIRST..l_line_id_tbl.LAST
1324: INSERT INTO qp_price_book_line_details
1325: (price_book_line_det_id, price_book_line_id,
1326: price_book_header_id,
1327: list_header_id, list_line_id,
1328: list_line_no, list_price,

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

1332: creation_date, created_by, last_update_date,
1333: last_updated_by, last_update_login
1334: )
1335: VALUES
1336: (qp_price_book_line_details_s.nextval, l_line_id_tbl(j),
1337: p_price_book_header_id,
1338: l_cf_list_header_id_tbl(j), l_cf_list_line_id_tbl(j),
1339: decode(l_pricing_phase_id_tbl(j), 1, null, l_list_line_no_tbl(j)),
1340: --insert null for list_line_no in case of PLL, PBH price list line

Line 1863: DELETE FROM qp_price_book_line_details

1859:
1860: DELETE FROM qp_price_book_lines
1861: WHERE price_book_header_id = l_overwrite_pb_header_id;
1862:
1863: DELETE FROM qp_price_book_line_details
1864: WHERE price_book_header_id = l_overwrite_pb_header_id;
1865:
1866: DELETE FROM qp_price_book_attributes
1867: WHERE price_book_header_id = l_overwrite_pb_header_id;

Line 1947: DELETE FROM qp_price_book_line_details

1943:
1944: DELETE FROM qp_price_book_lines
1945: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1946:
1947: DELETE FROM qp_price_book_line_details
1948: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1949:
1950: DELETE FROM qp_price_book_attributes
1951: WHERE price_book_header_id = l_corr_delta_pb_header_id;

Line 2477: SELECT /*+ index(qpbdtls qp_price_book_line_details_n1) */

2473:
2474: --For each pricebook line set the starting net_price to list_price
2475: l_net_price := nvl(l_list_price_tbl(i), 0);
2476:
2477: SELECT /*+ index(qpbdtls qp_price_book_line_details_n1) */
2478: qpbdtls.price_book_line_det_id, qpbdtls.adjustment_amount --bug 8933586
2479: BULK COLLECT INTO l_line_det_id_tbl, l_adjustment_amount_tbl
2480: FROM qp_price_book_line_details qpbdtls
2481: WHERE qpbdtls.price_book_line_id = l_line_id_tbl(i)

Line 2480: FROM qp_price_book_line_details qpbdtls

2476:
2477: SELECT /*+ index(qpbdtls qp_price_book_line_details_n1) */
2478: qpbdtls.price_book_line_det_id, qpbdtls.adjustment_amount --bug 8933586
2479: BULK COLLECT INTO l_line_det_id_tbl, l_adjustment_amount_tbl
2480: FROM qp_price_book_line_details qpbdtls
2481: WHERE qpbdtls.price_book_line_id = l_line_id_tbl(i)
2482: ORDER BY qpbdtls.price_book_line_det_id;
2483:
2484: IF l_line_det_id_tbl.COUNT > 0 THEN

Line 2506: UPDATE qp_price_book_line_details

2502: --Bulk update price book line details with cumulative net prices
2503: --for all line details belonging to all lines in current iteration of
2504: --pb_lines_cur
2505: FORALL m IN l_line_det_id_tbl2.FIRST..l_line_det_id_tbl2.LAST
2506: UPDATE qp_price_book_line_details
2507: SET adjusted_net_price = l_net_price_tbl(m)
2508: WHERE price_book_line_det_id = l_line_det_id_tbl2(m);
2509:
2510: --Bulk update the net price on the summary price book line to the