APPS.OZF_QP_PRODUCTS_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN

106: IS
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;
114: END IF;

Line 139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);

135: SELECT list_header_id FROM qp_pricing_attributes WHERE pricing_attribute_id = p_pricing_attribute_id;
136: l_list_header NUMBER;
137: CURSOR c_list_header2 (p_off_discount_product_id NUMBER)
138: IS
139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);
140: l_list_header2 NUMBER;
141: BEGIN
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: OPEN c_list_header(p_qp_product_rec.pricing_attribute_id);