[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
1415:
1416: --Insert records into the price book break lines table from the line attrs
1417: --temp table for PBH Price List and Modifier Lines
1418: FORALL k IN l_line_index2_tbl.FIRST..l_line_index2_tbl.LAST
1419: INSERT INTO qp_price_book_break_lines
1420: (price_book_break_line_id, price_book_line_det_id,
1421: price_book_line_id, price_book_header_id,
1422: pricing_context, pricing_attribute, pricing_attr_value_from,
1423: pricing_attr_value_to, comparison_operator_code,
1424: pricing_attribute_datatype, operand, application_method,
1425: recurring_value,
1426: creation_date, created_by, last_update_date, last_updated_by,
1427: last_update_login)
1428: SELECT /*+ ORDERED index(a QP_PREQ_LINE_ATTRS_TMP_N3) */ qp_price_book_break_lines_s.nextval, l_pb_line_det_id_tbl(k),
1429: l_pb_line_id_tbl(k), p_price_book_header_id,
1430: a.context, a.attribute, a.value_from,
1431: a.value_to, a.comparison_operator_type_code,
1432: a.datatype, b.operand_value, b.operand_calculation_code,
1846:
1847: DELETE FROM qp_price_book_attributes
1848: WHERE price_book_header_id = l_overwrite_pb_header_id;
1849:
1850: DELETE FROM qp_price_book_break_lines
1851: WHERE price_book_header_id = l_overwrite_pb_header_id;
1852:
1853: DELETE FROM qp_price_book_messages
1854: WHERE price_book_header_id = l_overwrite_pb_header_id;
1930:
1931: DELETE FROM qp_price_book_attributes
1932: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1933:
1934: DELETE FROM qp_price_book_break_lines
1935: WHERE price_book_header_id = l_corr_delta_pb_header_id;
1936:
1937: DELETE FROM qp_price_book_messages
1938: WHERE price_book_header_id = l_corr_delta_pb_header_id;