461: AND object_attribute = 'ADJA';
462:
463: CURSOR c_backdate_flag(p_list_header_id NUMBER, p_offer_adjustment_id NUMBER, p_effective_date DATE) IS
464: SELECT 1
465: FROM OZF_OFFER_ADJUSTMENTS_VL
466: WHERE (p_effective_date
468: AND offer_adjustment_id = p_offer_adjustment_id;
469:
1100: x_return_status := FND_API.g_ret_sts_success;
1101: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1102: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1103: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1104: ' ozf_offer_adjustments_vl ',
1105: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1106: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1107: );
1108: -- Check for, 2 adjustments with same effective date -sangara
1120: CLOSE c_adj_exists_oncreate;
1121:
1122: ELSE
1123: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1124: ' ozf_offer_adjustments_vl ',
1125: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1126: ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1127: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1128: );