[Home] [Help]
404: , a.pricing_attr_value_to
405: , a.pricing_attribute_context
406: , a.pricing_attribute
407: , a.comparison_operator_code
408: FROM qp_pricing_attributes a
409: WHERE a.list_line_id = cp_listLineId;
410: i NUMBER := null;
411: BEGIN
412: --x_return_status := FND_API.G_RET_STS_SUCCESS;
913: END LOOP;
914: END map_ozf_qp_lines;
915:
916: /**
917: Creates new qp_list_lines and qp_pricing_attributes
918: for a given offer_adjustment_id
919: */
920: PROCEDURE create_new_qp_lines
921: (
1677: --dbms_output.put_line('end POpulate complete discounts');
1678: END populate_discounts;
1679:
1680: /**
1681: Note not initializing the record to attribute_grouping_no leads to unexpected error cannot insert null into qp_pricing_attributes.attribute_grouping_no
1682: */
1683: /**
1684: This method populates product attributes ie. Product Attribute, Product Attr Value , excluder flag
1685: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table
1883: BEGIN
1884: -- initialize
1885: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.
1886: -- exclude this new product from all the qp discount structures.
1887: -- map the newly created qp_pricing_attributes to this exclusion product.
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889: l_pricing_attr_tbl.delete;
1890: i := 1;
1891: FOR l_qpListLines IN c_qpListLines(cp_offDiscountProductId => p_offDiscountProductId) LOOP