DBA Data[Home] [Help]

APPS.JTF_LOC_TYPES_PVT dependencies on JTF_LOC_TYPES_TL

Line 44: FROM JTF_LOC_TYPES_TL

40: FOR UPDATE OF location_type_id NOWAIT;
41:
42: CURSOR c_loc_type_tl IS
43: SELECT location_type_id
44: FROM JTF_LOC_TYPES_TL
45: WHERE location_type_id = p_loc_type_id
46: AND USERENV('LANG') IN (language, source_lang)
47: FOR UPDATE OF location_type_id NOWAIT;
48:

Line 243: UPDATE JTF_LOC_TYPES_TL SET

239: END IF;
240: RAISE FND_API.g_exc_error;
241: END IF;
242:
243: UPDATE JTF_LOC_TYPES_TL SET
244: last_update_date = SYSDATE,
245: last_updated_by = FND_GLOBAL.user_id,
246: last_update_login = FND_GLOBAL.conc_login_id,
247: location_type_name = p_loc_type_rec.location_type_name,

Line 460: 'JTF_LOC_TYPES_TL',

456: x_return_status := FND_API.g_ret_sts_success;
457:
458: l_uk_flag := JTF_Utility_PVT.check_uniqueness
459: (
460: 'JTF_LOC_TYPES_TL',
461: 'location_type_id <> ' || p_loc_type_rec.location_type_id
462: || ' AND location_type_name = ''' || p_loc_type_rec.location_type_name
463: || ''' AND language = ''' || USERENV('LANG') ||''''
464: );