APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TERR_USGS_ALL

Line 140: DELETE FROM jtf_terr_usgs_all where terr_id = l_terr_id;

136: if create then create the terr_id using the sequence*/
137: IF l_terr_id IS NOT NULL THEN
138: /* Update case All the delete scripts here */
139:
140: DELETE FROM jtf_terr_usgs_all where terr_id = l_terr_id;
141: DELETE FROM jtf_terr_qtype_usgs_all where terr_id = l_terr_id;
142:
143: DELETE FROM jtf_terr_rsc_access_all
144: WHERE terr_rsc_id IN (SELECT terr_rsc_id FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id);

Line 283: BEGIN --insert into jtf_terr_usgs_all

279: --dbms_output.put_line('Error 2 ' || sqlerrm);
280: NULL;
281: END; -- insert into terr_all
282:
283: BEGIN --insert into jtf_terr_usgs_all
284: --dbms_output.put_line('insert into jtf_terr_usgs_all');
285:
286: /* insert into terr_usgs_all */
287:

Line 284: --dbms_output.put_line('insert into jtf_terr_usgs_all');

280: NULL;
281: END; -- insert into terr_all
282:
283: BEGIN --insert into jtf_terr_usgs_all
284: --dbms_output.put_line('insert into jtf_terr_usgs_all');
285:
286: /* insert into terr_usgs_all */
287:
288: --dbms_output.put_line('Before inserting in terr usgs all Terr ID = ' || l_terr_id);

Line 289: INSERT INTO jtf_terr_usgs_all

285:
286: /* insert into terr_usgs_all */
287:
288: --dbms_output.put_line('Before inserting in terr usgs all Terr ID = ' || l_terr_id);
289: INSERT INTO jtf_terr_usgs_all
290: (TERR_USG_ID
291: , LAST_UPDATE_DATE
292: , LAST_UPDATED_BY
293: , CREATION_DATE

Line 312: --dbms_output.put_line(' After inserting jtf_terr_usgs_all');

308: , l_org_id
309: from jtf_tty_geo_terr
310: where geo_territory_id = p_geo_terr_id;
311:
312: --dbms_output.put_line(' After inserting jtf_terr_usgs_all');
313:
314:
315:
316: EXCEPTION

Line 323: END; --insert into jtf_terr_usgs_all

319: RAISE;
320: WHEN OTHERS THEN
321: --dbms_output.put_line('Error 4 ' || sqlerrm);
322: RAISE;
323: END; --insert into jtf_terr_usgs_all
324:
325: BEGIN -- insert into QType Usage
326:
327: /* Open the cursor to get the Qtype */