APPS.OZF_OFFER_ADJ_PRODUCTS_PVT dependencies on OZF_OFFER_ADJUSTMENT_PRODUCTS

Line 119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN

115: BEGIN
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
118: IF p_adj_prod.offer_adjustment_product_id IS NOT NULL AND p_adj_prod.offer_adjustment_product_id <> FND_API.G_MISS_NUM THEN
119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN
120: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_ID_DUP');
121: x_return_status := FND_API.g_ret_sts_error;
122: return;
123: END IF;

Line 556: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);

552: l_offer_adjustment_product_id NUMBER;
553:
554: CURSOR c_id_exists(l_offer_adjustment_product_id NUMBER)
555: IS
556: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);
557: l_dummy NUMBER;
558:
559: l_excluder_flag VARCHAR2(1) := 'N';
560: BEGIN

Line 717: SELECT * FROM ozf_offer_adjustment_products

713: l_api_version_number CONSTANT NUMBER := 1.0;
714: l_tar_rec offer_adj_prod_rec := p_adj_prod_rec;
715: CURSOR c_get_adj_prod(p_adj_product_id NUMBER , p_object_version_number NUMBER)
716: IS
717: SELECT * FROM ozf_offer_adjustment_products
718: WHERE offer_adjustment_product_id = p_adj_product_id
719: AND object_version_number = p_object_version_number;
720: l_ref_rec c_get_adj_prod%rowtype;
721: