[Home] [Help]
349: , a.pricing_attr_value_to
350: , a.pricing_attribute_context
351: , a.pricing_attribute
352: , a.comparison_operator_code
353: FROM qp_pricing_attributes a
354: WHERE a.list_line_id = cp_listLineId;
355: i NUMBER := null;
356: BEGIN
357: --x_return_status := FND_API.G_RET_STS_SUCCESS;
858: END LOOP;
859: END map_ozf_qp_lines;
860:
861: /**
862: Creates new qp_list_lines and qp_pricing_attributes
863: for a given offer_adjustment_id
864: */
865: PROCEDURE create_new_qp_lines
866: (
1618: --dbms_output.put_line('end POpulate complete discounts');
1619: END populate_discounts;
1620:
1621: /**
1622: Note not initializing the record to attribute_grouping_no leads to unexpected error cannot insert null into qp_pricing_attributes.attribute_grouping_no
1623: */
1624: /**
1625: This method populates product attributes ie. Product Attribute, Product Attr Value , excluder flag
1626: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1824: BEGIN
1825: -- initialize
1826: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.
1827: -- exclude this new product from all the qp discount structures.
1828: -- map the newly created qp_pricing_attributes to this exclusion product.
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830: l_pricing_attr_tbl.delete;
1831: i := 1;
1832: FOR l_qpListLines IN c_qpListLines(cp_offDiscountProductId => p_offDiscountProductId) LOOP