APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 770: FROM ozf_offer_discount_products

766: SELECT off_discount_product_id
767: , product_attribute
768: , product_attr_value
769: , excluder_flag
770: FROM ozf_offer_discount_products
771: WHERE offer_discount_line_id = cp_offerDiscountlineId;
772:
773: BEGIN
774: -- initialize

Line 1238: -- insert the new products into ozf_offer_discount_products

1234: );
1235:
1236: -- initialize
1237: -- query new products added in the adjustment
1238: -- insert the new products into ozf_offer_discount_products
1239: -- update ozf_offer_adjustment_products with the off_discount_product_id of the newly created product
1240: END create_new_products;
1241:
1242:

Line 1409: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1405: l_volumeFrom NUMBER;
1406: CURSOR c_minVolume(cp_offDiscountProductId NUMBER)
1407: IS
1408: SELECT min(volume_from)
1409: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1410: WHERE a.parent_discount_line_id = b.offer_discount_line_id
1411: AND b.off_discount_product_id = cp_offDiscountProductId;
1412: BEGIN
1413: OPEN c_minVolume(cp_offDiscountProductId => p_offDiscountProductId);

Line 1474: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1470: IS
1471: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)
1472: IS
1473: SELECT a.offer_discount_line_id , b.apply_discount_flag
1474: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1475: WHERE parent_discount_line_id = cp_parentDiscountLineId
1476: AND a.parent_discount_line_id = b.offer_discount_line_id
1477: AND b.off_discount_product_id = cp_offDiscountProductId;
1478:

Line 1626: into a Qp_Modifiers_Pub.pricing_attr_rec_type record given the Product Id in ozf_offer_discount_products table

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
1627: */
1628: PROCEDURE populate_product_attributes
1629: (
1630: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

Line 1644: ozf_offer_discount_products

1640: , excluder_flag
1641: , apply_discount_flag
1642: , include_volume_flag
1643: FROM
1644: ozf_offer_discount_products
1645: WHERE off_discount_product_id = cp_offDiscountProductId;
1646: BEGIN
1647: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1648: x_pricing_attr_rec := null;

Line 1810: FROM ozf_offer_discount_products a, ozf_qp_discounts b , qp_list_lines c

1806: i NUMBER;
1807: CURSOR c_qpListLines(cp_offDiscountProductId NUMBER)
1808: IS
1809: SELECT b.list_line_id, a.product_attribute, a.product_attr_value , c.list_header_id
1810: FROM ozf_offer_discount_products a, ozf_qp_discounts b , qp_list_lines c
1811: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1812: AND b.list_line_id = c.list_line_id
1813: AND a.off_discount_product_id = p_offDiscountProductId;
1814: