eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_QP_DISCOUNTS

Line 13: -- with ozf_qp_discounts. The default tier for price breaks starting with "0" does not correspong to any ozf_qp_discount.

9: -- History
10: -- Tue Mar 14 2006:4/33 PM RSSHARMA Created
11: -- Mon Apr 03 2006:1/27 PM RSSHARMA Fixed end date Query for end dating lines
12: -- Tue Aug 15 2006:3/26 PM RSSHARMA Fixed bug # 5468261. Fixed query in populate_dis_lines, to outer join qp_rltd_deal_lines
13: -- with ozf_qp_discounts. The default tier for price breaks starting with "0" does not correspong to any ozf_qp_discount.
14: -- This outer join will enable selection of the default tier starting with "0".
15: -- Tue Aug 15 2006:6/17 PM RSSHARMA Contd # 5468261 fixes. Changed order of calling zero discounts. Also DO not create
16: -- relations for default line.
17: -- NOTE

Line 258: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c

254: IS
255: CURSOR c_qpListLines(cp_offerAdjustmentId NUMBER)
256: IS
257: SELECT distinct parent_discount_line_id , c.list_line_id
258: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c
259: WHERE a.offer_discount_line_id = b.offer_discount_line_id
260: AND b.parent_discount_line_id = c.offer_discount_line_id
261: AND a.offer_adjustment_id = cp_offerAdjustmentId;
262: BEGIN

Line 561: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d

557: IS
558: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
559: IS
560: SELECT a.from_rltd_modifier_id, a.to_rltd_modifier_id, b.offer_discount_line_id , nvl(c.modified_discount,d.operand) discount , d.arithmetic_operator
561: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d
562: WHERE a.to_rltd_modifier_id = b.list_line_id(+)
563: and b.offer_discount_line_id = c.offer_discount_line_id(+)
564: AND a.to_rltd_modifier_id = d.list_line_id
565: AND a.from_rltd_modifier_id = cp_listLineId

Line 805: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

801: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
802: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
803: )
804: IS
805: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
806: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
807: l_qpDiscountId NUMBER;
808: l_qpProductId NUMBER;
809: l_objectVersion NUMBER;

Line 832: -- check for discount equality, in case yes insert into ozf_qp_discounts table

828: BEGIN
829: -- initialize
830: -- loop thru the Discount Structure
831: -- for each discount line loop thru. the qp_modifiers table
832: -- check for discount equality, in case yes insert into ozf_qp_discounts table
833: -- similar thing for relating products
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: --dbms_output.put_line('Map Ozf qp lines');
836: --dbms_output.put_line('Table counts are :'||p_modifier_line_tbl.count||' : '||p_pricing_attr_tbl.count);

Line 853: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount

849: l_qpDiscountsRec := null;
850: l_qpDiscountsRec.list_line_id := p_modifier_line_tbl(i).list_line_id;
851: l_qpDiscountsRec.offer_discount_line_id := l_discounts.offer_discount_line_id;
852: l_qpDiscountsRec.start_date := sysdate;
853: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount
854: (
855: p_api_version_number => 1.0
856: , p_init_msg_list => FND_API.G_FALSE
857: , p_commit => FND_API.G_FALSE

Line 935: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d

931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
932: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
933: IS
934: SELECT distinct parent_discount_line_id , c.list_line_id
935: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d
936: WHERE a.offer_discount_line_id = b.offer_discount_line_id
937: AND b.parent_discount_line_id = c.offer_discount_line_id
938: AND c.list_line_id = d.list_line_id
939: AND d.list_line_type_code = 'PBH'

Line 1748: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

1744: , x_msg_count OUT NOCOPY NUMBER
1745: , x_msg_data OUT NOCOPY VARCHAR2
1746: )
1747: IS
1748: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
1749: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1750: l_qpDiscountId NUMBER;
1751: l_qpProductId NUMBER;
1752: l_objectVersion NUMBER;

Line 1765: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount

1761: l_qpDiscountsRec := null;
1762: l_qpDiscountsRec.list_line_id := p_modifiers_tbl(i).list_line_id;
1763: l_qpDiscountsRec.offer_discount_line_id := p_modifiers_tbl(i).comments;
1764: l_qpDiscountsRec.start_date := sysdate;
1765: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount
1766: (
1767: p_api_version_number => 1.0
1768: , p_init_msg_list => FND_API.G_FALSE
1769: , p_commit => FND_API.G_FALSE

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: