eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PVT dependencies on AMS_SOURCE_CODES

Line 4468: SELECT 1 from AMS_SOURCE_CODES

4464:
4465: --nepanda : fix for bug 9149865
4466: CURSOR c_check_uniqeness_create
4467: IS
4468: SELECT 1 from AMS_SOURCE_CODES
4469: WHERE source_code = p_modifier_list_rec.offer_code;
4470:
4471: -- nepanda : Fix for Bug 12950967
4472: CURSOR c_qp_limit_line_id(p_limit_id NUMBER) IS

Line 4608: --l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');

4604: );
4605: ELSE
4606: l_modifier_list_rec.name := p_modifier_list_rec.offer_code;
4607: --nepanda : fix for bug 9149865
4608: --l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');
4609:
4610: OPEN c_check_uniqeness_create;
4611: FETCH c_check_uniqeness_create INTO l_uk_flag;
4612: CLOSE c_check_uniqeness_create;