APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TERR_ALL

Line 109: FROM jtf_terr_all

105: BEGIN
106: SELECT
107: terr_id
108: INTO l_terr_id
109: FROM jtf_terr_all
110: WHERE geo_territory_id = p_geo_terr_id;
111:
112: EXCEPTION
113: when FND_API.G_EXC_ERROR then

Line 148: DELETE FROM jtf_terr_all WHERE terr_id = l_terr_id;

144: WHERE terr_rsc_id IN (SELECT terr_rsc_id FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id);
145:
146: DELETE FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id;
147:
148: DELETE FROM jtf_terr_all WHERE terr_id = l_terr_id;
149:
150: ELSE
151: /*create the sequence only when call is from create otherwise use the existing ID */
152:

Line 184: FROM jtf_terr_all

180: l_rank,
181: l_start_date_active,
182: l_end_date_active,
183: l_terr_type_id
184: FROM jtf_terr_all
185: WHERE geo_territory_id = p_geo_parent_terr_id;
186:
187: --dbms_output.put_line(' Parent Territory Id is:'||l_parent_terr_id);
188:

Line 224: INSERT INTO jtf_terr_all

220:
221:
222: --dbms_output.put_line('TERRITORY ID ' || l_terr_id);
223:
224: INSERT INTO jtf_terr_all
225: ( TERR_ID
226: , NAME
227: ,LAST_UPDATE_DATE
228: ,LAST_UPDATED_BY

Line 270: --dbms_output.put_line(' After inserting jtf_terr_all');

266: , l_start_date_active --TODO END_DATE_ACTIVE
267: , l_end_date_active
268: FROM jtf_tty_geo_terr
269: where geo_territory_id = p_geo_terr_id;
270: --dbms_output.put_line(' After inserting jtf_terr_all');
271:
272:
273:
274: EXCEPTION