APPS.OZF_DISC_LINE_PVT dependencies on OZF_DISCOUNT_PRODUCT_RELN

Line 3136: 'ozf_discount_product_reln',

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

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

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

Line 3313: FROM ozf_discount_product_reln

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

Line 3627: SELECT ozf_discount_product_reln_s.NEXTVAL

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

Line 3632: FROM OZF_DISCOUNT_PRODUCT_RELN

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

Line 3851: FROM OZF_DISCOUNT_PRODUCT_RELN

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