APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 825: FROM ozf_offer_discount_products

821: SELECT off_discount_product_id
822: , product_attribute
823: , product_attr_value
824: , excluder_flag
825: FROM ozf_offer_discount_products
826: WHERE offer_discount_line_id = cp_offerDiscountlineId;
827:
828: BEGIN
829: -- initialize

Line 1293: -- insert the new products into ozf_offer_discount_products

1289: );
1290:
1291: -- initialize
1292: -- query new products added in the adjustment
1293: -- insert the new products into ozf_offer_discount_products
1294: -- update ozf_offer_adjustment_products with the off_discount_product_id of the newly created product
1295: END create_new_products;
1296:
1297:

Line 1468: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1464: l_volumeFrom NUMBER;
1465: CURSOR c_minVolume(cp_offDiscountProductId NUMBER)
1466: IS
1467: SELECT min(volume_from)
1468: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1469: WHERE a.parent_discount_line_id = b.offer_discount_line_id
1470: AND b.off_discount_product_id = cp_offDiscountProductId;
1471: BEGIN
1472: OPEN c_minVolume(cp_offDiscountProductId => p_offDiscountProductId);

Line 1533: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1529: IS
1530: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)
1531: IS
1532: SELECT a.offer_discount_line_id , b.apply_discount_flag
1533: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1534: WHERE parent_discount_line_id = cp_parentDiscountLineId
1535: AND a.parent_discount_line_id = b.offer_discount_line_id
1536: AND b.off_discount_product_id = cp_offDiscountProductId;
1537:

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

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
1686: */
1687: PROCEDURE populate_product_attributes
1688: (
1689: x_pricing_attr_rec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_rec_type

Line 1703: ozf_offer_discount_products

1699: , excluder_flag
1700: , apply_discount_flag
1701: , include_volume_flag
1702: FROM
1703: ozf_offer_discount_products
1704: WHERE off_discount_product_id = cp_offDiscountProductId;
1705: BEGIN
1706: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1707: x_pricing_attr_rec := null;

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

1865: i NUMBER;
1866: CURSOR c_qpListLines(cp_offDiscountProductId NUMBER)
1867: IS
1868: SELECT b.list_line_id, a.product_attribute, a.product_attr_value , c.list_header_id
1869: FROM ozf_offer_discount_products a, ozf_qp_discounts b , qp_list_lines c
1870: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1871: AND b.list_line_id = c.list_line_id
1872: AND a.off_discount_product_id = p_offDiscountProductId;
1873: