APPS.OZF_VOLUME_OFFER_DISC_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 2545: 'ozf_offer_discount_products',

2541: IF p_validation_mode = JTF_PLSQL_API.g_create
2542: AND (p_vo_prod_rec.off_discount_product_id IS NOT NULL AND p_vo_prod_rec.off_discount_product_id <> FND_API.g_miss_num)
2543: THEN
2544: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
2545: 'ozf_offer_discount_products',
2546: 'OFF_DISCOUNT_PRODUCT_ID = ''' || p_vo_prod_rec.off_discount_product_id ||''''
2547: );
2548: OZF_Offer_Adj_Line_PVT.debug_message('Off Discount Product Id is '||p_vo_prod_rec.off_discount_product_id);
2549: IF l_valid_flag = FND_API.g_false THEN

Line 2563: 'ozf_offer_discount_products',

2559: begin
2560: IF (p_vo_prod_rec.product_attr_value IS NOT NULL AND p_vo_prod_rec.product_attr_value <> FND_API.g_miss_char) THEN
2561:
2562: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
2563: 'ozf_offer_discount_products',
2564: l_attr || l_attr2
2565: );
2566: OZF_Offer_Adj_Line_PVT.debug_message('Valid Flag for duplicate products is:'||l_valid_flag);
2567: IF l_valid_flag = FND_API.g_false THEN

Line 3361: SELECT ozf_offer_discount_products_s.NEXTVAL

3357: l_vo_prod_id NUMBER;
3358: l_object_version_number NUMBER;
3359: l_dummy NUMBER;
3360: CURSOR c_id IS
3361: SELECT ozf_offer_discount_products_s.NEXTVAL
3362: FROM dual;
3363:
3364: CURSOR c_id_exists (l_id IN NUMBER) IS
3365: SELECT 1

Line 3366: FROM OZF_OFFER_DISCOUNT_PRODUCTS

3362: FROM dual;
3363:
3364: CURSOR c_id_exists (l_id IN NUMBER) IS
3365: SELECT 1
3366: FROM OZF_OFFER_DISCOUNT_PRODUCTS
3367: WHERE OFF_DISCOUNT_PRODUCT_ID = l_id;
3368:
3369: BEGIN
3370: --initialize

Line 3557: FROM OZF_OFFER_DISCOUNT_PRODUCTS

3553: )
3554: IS
3555: CURSOR c_get_vo_prod_line(p_offer_prod_id NUMBER, p_object_version_number NUMBER) IS
3556: SELECT *
3557: FROM OZF_OFFER_DISCOUNT_PRODUCTS
3558: WHERE OFF_DISCOUNT_PRODUCT_ID = p_offer_prod_id
3559: AND object_version_number = p_object_version_number;
3560: -- Hint: Developer need to provide Where clause
3561: