[Home] [Help]
90: IS
91: /*CURSOR c_prod(p_offer_adjustment_id NUMBER,p_product_context VARCHAR2, p_product_attribute VARCHAR2, p_product_attr_value VARCHAR2, p_excluder_flag VARCHAR2)
92: IS
93: SELECT 1 FROM dual WHERE EXISTS
94: (SELECT 'X' FROM ozf_offer_discount_products a, ozf_offer_adjustments_b b, ozf_offers c
95: WHERE
96: a.offer_id = c.offer_id
97: AND c.qp_list_header_id = b.list_header_id
98: AND b.offer_adjustment_id = p_offer_adjustment_id
142: CLOSE c_offerId;
143:
144: IF (p_adj_prod.product_attr_value IS NOT NULL AND p_adj_prod.product_attr_value <> FND_API.g_miss_char) THEN
145: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
146: 'ozf_offer_discount_products',
147: l_attr || l_attr2 || l_offerId
148: );
149: IF l_valid_flag = FND_API.g_false THEN
150: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_PROD_DUP');
183: END IF;
184: END IF;
185: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountProductId is : '||p_adj_prod.off_discount_product_id);
186: IF p_adj_prod.off_discount_product_id IS NOT NULL AND p_adj_prod.off_discount_product_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.CHECK_FK_EXISTS('ozf_offer_discount_products','off_discount_product_id',to_char(p_adj_prod.off_discount_product_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_INV_PROD_LINE');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;
330: IS
331: CURSOR C(p_offer_discount_line_id NUMBER, p_off_discount_product_id NUMBER) is
332: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X'
333: FROM ozf_offer_discount_lines a
334: , ozf_offer_discount_products b
335: , ozf_offer_adjustments_b c
336: , ozf_offers d
337: WHERE a.offer_discount_line_id = b.offer_discount_line_id
338: AND a.offer_id = d.offer_id