APPS.OZF_VOLUME_OFFER_DISC_PVT dependencies on OZF_OFFERS

Line 409: SELECT offer_type FROM ozf_offers

405: x_return_status OUT NOCOPY VARCHAR2
406: )
407: IS
408: CURSOR c_offer_type(p_offer_id NUMBER) IS
409: SELECT offer_type FROM ozf_offers
410: WHERE offer_id = p_offer_id;
411:
412: CURSOR c_tier_type(p_offer_discount_line_id number) IS
413: SELECT tier_type FROM ozf_offer_discount_lines

Line 416: l_offer_type OZF_OFFERS.offer_type%type;

412: CURSOR c_tier_type(p_offer_discount_line_id number) IS
413: SELECT tier_type FROM ozf_offer_discount_lines
414: WHERE offer_discount_line_id = p_offer_discount_line_id;
415:
416: l_offer_type OZF_OFFERS.offer_type%type;
417: l_tier_type OZF_OFFER_DISCOUNT_LINES.tier_type%type;
418:
419: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_req_items';
420:

Line 609: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_vo_disc_rec.offer_id)) = FND_API.g_false THEN

605: -- Enter custom code here
606:
607: IF p_vo_disc_rec.offer_id IS NOT NULL AND p_vo_disc_rec.offer_id <> FND_API.G_MISS_NUM
608: THEN
609: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_vo_disc_rec.offer_id)) = FND_API.g_false THEN
610: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ID' );
611: x_return_status := FND_API.g_ret_sts_error;
612: return;
613: END IF;

Line 959: FROM ozf_offers

955: IS
956: CURSOR c_currency(cp_offerId NUMBER)
957: IS
958: SELECT transaction_currency_code
959: FROM ozf_offers
960: WHERE offer_id = cp_offerId;
961: l_currency ozf_offers.transaction_currency_code%TYPE;
962: BEGIN
963: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 961: l_currency ozf_offers.transaction_currency_code%TYPE;

957: IS
958: SELECT transaction_currency_code
959: FROM ozf_offers
960: WHERE offer_id = cp_offerId;
961: l_currency ozf_offers.transaction_currency_code%TYPE;
962: BEGIN
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
964: OPEN c_currency(cp_offerId => nvl(p_vo_disc_rec.offer_id,getOfferId(p_offerDiscountLineId => p_vo_disc_rec.offer_discount_line_id)));
965: FETCH c_currency INTO l_currency;

Line 2732: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_vo_prod_rec.offer_id)) = FND_API.g_false THEN

2728: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
2729: x_return_status := FND_API.G_RET_STS_SUCCESS;
2730: IF p_vo_prod_rec.offer_id IS NOT NULL AND p_vo_prod_rec.offer_id <> FND_API.G_MISS_NUM
2731: THEN
2732: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_vo_prod_rec.offer_id)) = FND_API.g_false THEN
2733: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ID' );
2734: x_return_status := FND_API.g_ret_sts_error;
2735: return;
2736: END IF;

Line 2848: select qp_list_header_id into l_list_header_id from ozf_offers where offer_id = l_uom_code.offer_id;

2844: l_organization_id,
2845: to_number(p_vo_prod_rec.product_attr_value),
2846: l_uom_code.uom_code) = 'N'
2847: */
2848: select qp_list_header_id into l_list_header_id from ozf_offers where offer_id = l_uom_code.offer_id;
2849: IF NOT QP_Validate.Product_Uom (
2850: l_uom_code.uom_code,
2851: to_number(p_vo_prod_rec.product_attr_value),
2852: l_list_header_id)