APPS.OZF_OFFER_ADJ_PRODUCTS_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 71: SELECT a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b

67: )
68: RETURN VARCHAR2
69: IS
70: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
71: SELECT a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b
72: WHERE a.qp_list_header_id = b.list_header_id
73: AND b.offer_adjustment_id = cp_offerAdjustmentId;
74: l_offerType VARCHAR2(30);
75: BEGIN

Line 94: (SELECT 'X' FROM ozf_offer_discount_products a, ozf_offer_adjustments_b b, ozf_offers c

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

Line 106: FROM ozf_offers a, ozf_offer_adjustments_b b

102: AND excluder_flag = p_excluder_flag ;
103: */
104: CURSOR c_offerId (cp_offerAdjustmentId NUMBER) IS
105: SELECT a.offer_id
106: FROM ozf_offers a, ozf_offer_adjustments_b b
107: WHERE a.qp_list_header_id = b.list_header_id
108: AND b.offer_adjustment_id = cp_offerAdjustmentId;
109:
110: l_attr varchar2(500) := 'product_attribute = ''' || p_adj_prod.product_attribute ||''' AND product_attr_value = '''|| p_adj_prod.product_attr_value ;

Line 171: IF OZF_UTILITY_PVT.check_fk_exists('ozf_offer_adjustments_b','offer_adjustment_id',to_char(p_adj_prod.offer_adjustment_id)) = FND_API.G_FALSE THEN

167: l_vo_prod_rec OZF_Volume_Offer_disc_PVT.vo_prod_rec_type;
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: IF p_adj_prod.offer_adjustment_id IS NOT NULL AND p_adj_prod.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
171: IF OZF_UTILITY_PVT.check_fk_exists('ozf_offer_adjustments_b','offer_adjustment_id',to_char(p_adj_prod.offer_adjustment_id)) = FND_API.G_FALSE THEN
172: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_ADJ_ID');
173: x_return_status := FND_API.g_ret_sts_error;
174: return;
175: END IF;

Line 335: , ozf_offer_adjustments_b c

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
339: AND d.qp_list_header_id = c.list_header_id

Line 385: FROM ozf_offer_adjustments_b

381: )
382: IS
383: CURSOR c_effectiveDate(cp_offerAdjustmentId NUMBER) IS
384: SELECT effective_date
385: FROM ozf_offer_adjustments_b
386: WHERE offer_adjustment_id = cp_offerAdjustmentId;
387: l_effectiveDate DATE;
388: BEGIN
389: x_return_status := FND_API.G_RET_STS_SUCCESS;