APPS.JTF_LOC_PVT dependencies on JTF_LOC_HIERARCHIES_B

Line 55: FROM jtf_loc_hierarchies_b

51: l_hier_id NUMBER;
52:
53: CURSOR c_hier IS
54: SELECT location_hierarchy_id
55: FROM jtf_loc_hierarchies_b
56: WHERE location_type_code = p_hier_rec.location_type_code
57: AND DECODE(p_hier_rec.location_type_code,
58: 'AREA1', area1_id,
59: 'AREA2', area2_id,

Line 107: SELECT jtf_loc_hierarchies_b_s.NEXTVAL

103: l_hier_id NUMBER;
104: l_count NUMBER;
105:
106: CURSOR c_hier_seq IS
107: SELECT jtf_loc_hierarchies_b_s.NEXTVAL
108: FROM DUAL;
109:
110: CURSOR c_hier_count IS
111: SELECT count(*)

Line 112: FROM jtf_loc_hierarchies_b

108: FROM DUAL;
109:
110: CURSOR c_hier_count IS
111: SELECT count(*)
112: FROM jtf_loc_hierarchies_b
113: WHERE location_hierarchy_id = l_hier_id;
114:
115: BEGIN
116:

Line 120: UPDATE jtf_loc_hierarchies_b

116:
117: l_hier_id := get_loc_hierarchy_id(p_hier_rec);
118:
119: IF l_hier_id IS NOT NULL THEN
120: UPDATE jtf_loc_hierarchies_b
121: SET location_hierarchy_id = l_hier_id,
122: last_update_date = SYSDATE,
123: last_updated_by = FND_GLOBAL.user_id,
124: last_update_login = FND_GLOBAL.conc_login_id,

Line 163: INSERT INTO jtf_loc_hierarchies_b(

159:
160: EXIT WHEN l_count = 0;
161: END LOOP;
162:
163: INSERT INTO jtf_loc_hierarchies_b(
164: location_hierarchy_id,
165: last_update_date,
166: last_updated_by,
167: creation_date,

Line 341: -- insert or update jtf_loc_hierarchies_b table

337: END IF;
338: CLOSE c_parent_area;
339: END LOOP;
340:
341: -- insert or update jtf_loc_hierarchies_b table
342: l_hier_rec.location_type_code := l_area_rec.location_type_code;
343: load_hierarchy(l_area_rec, l_hier_rec);
344:
345: -- if this area is a city, load all postal codes