APPS.JTF_LOC_AREAS_PVT dependencies on JTF_LOC_AREAS_TL

Line 150: INSERT INTO JTF_LOC_AREAS_TL

146: l_loc_area_rec.orig_system_ref,
147: l_loc_area_rec.parent_location_area_id
148: );
149:
150: INSERT INTO JTF_LOC_AREAS_TL
151: (
152: location_area_id,
153: language,
154: last_update_date,

Line 179: FROM JTF_LOC_AREAS_TL t

175: WHERE l.installed_flag in ('I', 'B')
176: AND NOT EXISTS
177: (
178: SELECT NULL
179: FROM JTF_LOC_AREAS_TL t
180: WHERE t.location_area_id = l_loc_area_rec.location_area_id
181: AND t.language = l.language_code
182: );
183:

Line 369: UPDATE JTF_LOC_AREAS_TL SET

365: END IF;
366: RAISE FND_API.g_exc_error;
367: END IF;
368:
369: UPDATE JTF_LOC_AREAS_TL SET
370: last_update_date = SYSDATE,
371: last_updated_by = FND_GLOBAL.user_id,
372: last_update_login = FND_GLOBAL.conc_login_id,
373: source_lang = USERENV('LANG'),

Line 516: DELETE FROM JTF_LOC_AREAS_TL

512: RAISE FND_API.g_exc_error;
513: END IF;
514:
515: /* removed by julou for bug 1717907/1703508
516: DELETE FROM JTF_LOC_AREAS_TL
517: WHERE location_area_id = p_loc_area_id;
518:
519: IF (SQL%NOTFOUND) THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 637: FROM JTF_LOC_AREAS_TL

633: FOR UPDATE OF location_area_id NOWAIT;
634:
635: CURSOR c_loc_area_tl IS
636: SELECT location_area_id
637: FROM JTF_LOC_AREAS_TL
638: WHERE location_area_id = p_loc_area_id
639: AND USERENV('LANG') IN (language, source_lang)
640: FOR UPDATE OF location_area_id NOWAIT;
641:

Line 1103: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t

1099: CURSOR c_area_name_count1(l_id NUMBER, l_parent_id NUMBER, l_name VARCHAR2) IS
1100: SELECT 1
1101: FROM DUAL
1102: WHERE EXISTS(SELECT 1
1103: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1104: WHERE t.location_area_name = l_name
1105: AND t.language = USERENV('LANG')
1106: AND t.location_area_id <> l_id
1107: AND b.parent_location_area_id = l_parent_id

Line 1114: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t

1110: CURSOR c_area_name_count2(l_parent_id NUMBER, l_name VARCHAR2) IS
1111: SELECT 1
1112: FROM DUAL
1113: WHERE EXISTS(SELECT 1
1114: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1115: WHERE t.location_area_name = l_name
1116: AND t.language = USERENV('LANG')
1117: AND b.parent_location_area_id = l_parent_id
1118: AND b.location_area_id =t.location_area_id);