APPS.JTF_LOC_POSTAL_CODES_PVT dependencies on JTF_LOC_POSTAL_CODES_S

Line 36: SELECT JTF_LOC_POSTAL_CODES_S.NEXTVAL

32: l_postal_code_rec postal_code_rec_type := p_postal_code_rec;
33: l_postal_code_count NUMBER;
34:
35: CURSOR c_postal_code_seq IS
36: SELECT JTF_LOC_POSTAL_CODES_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_postal_code_count(postal_code_id IN NUMBER) IS
40: SELECT COUNT(*)

Line 294: UPDATE JTF_LOC_POSTAL_CODES SET

290: -- update
291: JTF_Utility_PVT.debug_message(l_full_name||': update');
292:
293: IF p_remove_flag = 'Y' THEN
294: UPDATE JTF_LOC_POSTAL_CODES SET
295: end_date_active = SYSDATE
296: WHERE location_postal_code_id = l_postal_code_rec.location_postal_code_id
297: AND object_version_number = l_postal_code_rec.object_version_number;
298: ELSE

Line 299: UPDATE JTF_LOC_POSTAL_CODES SET

295: end_date_active = SYSDATE
296: WHERE location_postal_code_id = l_postal_code_rec.location_postal_code_id
297: AND object_version_number = l_postal_code_rec.object_version_number;
298: ELSE
299: UPDATE JTF_LOC_POSTAL_CODES SET
300: last_update_date = SYSDATE,
301: last_updated_by = FND_GLOBAL.user_id,
302: object_version_number = l_postal_code_rec.object_version_number + 1,
303: last_update_login = FND_GLOBAL.conc_login_id,