DBA Data[Home] [Help]

APPS.JTF_LOC_TYPES_PVT dependencies on JTF_LOC_TYPES_B

Line 37: FROM JTF_LOC_TYPES_B

33: l_loc_type_id NUMBER;
34:
35: CURSOR c_loc_type_b IS
36: SELECT location_type_id
37: FROM JTF_LOC_TYPES_B
38: WHERE location_type_id = p_loc_type_id
39: AND object_version_number = p_object_version
40: FOR UPDATE OF location_type_id NOWAIT;
41:

Line 225: UPDATE JTF_LOC_TYPES_B SET

221:
222: -------------------------- update --------------------
223: JTF_Utility_PVT.debug_message(l_full_name ||': update');
224:
225: UPDATE JTF_LOC_TYPES_B SET
226: last_update_date = SYSDATE,
227: last_updated_by = FND_GLOBAL.user_id,
228: last_update_login = FND_GLOBAL.conc_login_id,
229: object_version_number = p_loc_type_rec.object_version_number + 1,