APPS.OZF_DISC_LINE_PVT dependencies on OZF_DISCOUNT_PRODUCT_RELN

Line 3137: 'ozf_discount_product_reln',

3133: IF p_validation_mode = JTF_PLSQL_API.g_create
3134: AND p_prod_reln_rec.discount_product_reln_id IS NOT NULL
3135: THEN
3136: IF OZF_Utility_PVT.check_uniqueness(
3137: 'ozf_discount_product_reln',
3138: 'discount_product_reln_id = ''' || p_prod_reln_rec.discount_product_reln_id ||''''
3139: ) = FND_API.g_false THEN
3140:
3141: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_PROD_RELN_ID_DUP');

Line 3145: l_valid_flag := OZF_Utility_PVT.check_uniqueness('ozf_discount_product_reln'

3141: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_PROD_RELN_ID_DUP');
3142: x_return_status := FND_API.g_ret_sts_error;
3143: END IF;
3144: END IF;
3145: l_valid_flag := OZF_Utility_PVT.check_uniqueness('ozf_discount_product_reln'
3146: ,'offer_discount_line_id = '
3147: ||p_prod_reln_rec.offer_discount_line_id
3148: ||' AND off_discount_product_id = '
3149: ||p_prod_reln_rec.off_discount_product_id);

Line 3314: FROM ozf_discount_product_reln

3310: l_return_status VARCHAR2(1);
3311:
3312: CURSOR c_complete IS
3313: SELECT *
3314: FROM ozf_discount_product_reln
3315: WHERE discount_product_reln_id = p_prod_reln_rec.discount_product_reln_id;
3316: l_prod_reln_rec c_complete%ROWTYPE;
3317: BEGIN
3318: x_complete_rec := p_prod_reln_rec;

Line 3628: SELECT ozf_discount_product_reln_s.NEXTVAL

3624: l_dummy NUMBER;
3625: l_prod_reln_rec prod_reln_rec_type := g_miss_prod_reln_rec;
3626:
3627: CURSOR c_id IS
3628: SELECT ozf_discount_product_reln_s.NEXTVAL
3629: FROM dual;
3630:
3631: CURSOR c_id_exists (l_id IN NUMBER) IS
3632: SELECT 1

Line 3633: FROM OZF_DISCOUNT_PRODUCT_RELN

3629: FROM dual;
3630:
3631: CURSOR c_id_exists (l_id IN NUMBER) IS
3632: SELECT 1
3633: FROM OZF_DISCOUNT_PRODUCT_RELN
3634: WHERE discount_product_reln_id = l_id;
3635: BEGIN
3636: -- Standard Start of API savepoint
3637: SAVEPOINT create_prod_reln_pvt;

Line 3852: FROM OZF_DISCOUNT_PRODUCT_RELN

3848:
3849:
3850: CURSOR c_get_prod_reln(discount_product_reln_id NUMBER) IS
3851: SELECT *
3852: FROM OZF_DISCOUNT_PRODUCT_RELN
3853: WHERE discount_product_reln_id = p_prod_reln_rec.discount_product_reln_id;
3854: -- Hint: Developer need to provide Where clause
3855:
3856: