DBA Data[Home] [Help]

APPS.JTF_LOC_AREAS_PVT dependencies on JTF_LOC_AREAS_B_S

Line 36: SELECT JTF_LOC_AREAS_B_S.NEXTVAL

32: l_loc_area_rec loc_area_rec_type := p_loc_area_rec;
33: l_loc_area_count NUMBER;
34:
35: CURSOR c_loc_area_seq IS
36: SELECT JTF_LOC_AREAS_B_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_loc_area_count(loc_area_id IN NUMBER) IS
40: SELECT COUNT(*)

Line 342: UPDATE JTF_LOC_AREAS_B SET

338: IF p_remove_flag = 'Y' THEN
339: l_loc_area_rec.end_date_active := SYSDATE;
340: END IF;
341:
342: UPDATE JTF_LOC_AREAS_B SET
343: last_update_date = SYSDATE,
344: last_updated_by = FND_GLOBAL.user_id,
345: object_version_number = l_loc_area_rec.object_version_number + 1,
346: last_update_login = FND_GLOBAL.conc_login_id,