[Home] [Help]
197: LIMIT rows;
198:
199: --Delete the price book break lines
200: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST
201: DELETE FROM qp_price_book_break_lines
202: WHERE price_book_line_id = l_unchanged_line_id_tbl(i);
203:
204: --Delete the price book attributes
205: FORALL i IN l_unchanged_line_id_tbl.FIRST..l_unchanged_line_id_tbl.LAST
1395:
1396: --Insert records into the price book break lines table from the line attrs
1397: --temp table for PBH Price List and Modifier Lines
1398: FORALL k IN l_line_index2_tbl.FIRST..l_line_index2_tbl.LAST
1399: INSERT INTO qp_price_book_break_lines
1400: (price_book_break_line_id, price_book_line_det_id,
1401: price_book_line_id, price_book_header_id,
1402: pricing_context, pricing_attribute, pricing_attr_value_from,
1403: pricing_attr_value_to, comparison_operator_code,
1404: pricing_attribute_datatype, operand, application_method,
1405: recurring_value,
1406: creation_date, created_by, last_update_date, last_updated_by,
1407: last_update_login)
1408: SELECT /*+ ORDERED index(a QP_PREQ_LINE_ATTRS_TMP_N3) */ qp_price_book_break_lines_s.nextval, l_pb_line_det_id_tbl(k),
1409: l_pb_line_id_tbl(k), p_price_book_header_id,
1410: a.context, a.attribute, a.value_from,
1411: a.value_to, a.comparison_operator_type_code,
1412: a.datatype, b.operand_value, b.operand_calculation_code,
1865:
1866: DELETE FROM qp_price_book_attributes
1867: WHERE price_book_header_id = l_overwrite_pb_header_id;
1868:
1869: DELETE FROM qp_price_book_break_lines
1870: WHERE price_book_header_id = l_overwrite_pb_header_id;
1871:
1872: DELETE FROM qp_price_book_messages
1873: WHERE price_book_header_id = l_overwrite_pb_header_id;
1949:
1950: DELETE FROM qp_price_book_attributes
1951: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1952:
1953: DELETE FROM qp_price_book_break_lines
1954: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1955:
1956: DELETE FROM qp_price_book_messages
1957: WHERE price_book_header_id = l_corr_delta_pb_header_id;