eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 143: DELETE FROM jtf_terr_rsc_access_all

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);
145:
146: DELETE FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id;
147:

Line 454: /insert in jtf_terr_rsc_access_all table /

450:
451: --dbms_output.put_line(' After inserting jtf_terr_rsc_all');
452:
453:
454: /*insert in jtf_terr_rsc_access_all table */
455: FOR rsc_acc IN c_role_access(l_geo_terr_group_id, tran_type.role_code) LOOP
456: --dbms_output.put_line('acc_type:'||rsc_acc.access_type);
457:
458: /* get the sequence */

Line 488: INSERT INTO jtf_terr_rsc_access_all

484: */
485:
486: -- SOLIN, BUG 5018824
487: /* insert into jft_Terr_rsc_Access_all */
488: INSERT INTO jtf_terr_rsc_access_all
489: ( TERR_RSC_ACCESS_ID
490: ,LAST_UPDATE_DATE
491: ,LAST_UPDATED_BY
492: ,CREATION_DATE

Line 516: , jtf_terr_rsc_access_all c

512: , l_org_id --org Id
513: , 1
514: , c.trans_access_code
515: FROM jtf_terr_rsc_all b
516: , jtf_terr_rsc_access_all c
517: WHERE b.terr_id = l_parent_terr_id
518: AND b.role = tran_type.role_code
519: AND b.resource_type <> 'RS_EMPLOYEE'
520: AND b.terr_rsc_id = c.terr_rsc_id

Line 523: --dbms_output.put_line(' After inserting jtf_terr_rsc_access_all');