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.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 1889: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

1885: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);
1886:
1887: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1888: --Delete Territory Resource Access
1889: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
1890: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL
1891: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
1892:
1893: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last

Line 1988: DELETE FROM JTF_TERR_RSC_ACCESS_ALL

1984: if l_del_rsc_rec.terr_rsc_id.count > 0 then
1985: BEGIN
1986: --Delete Territory Resource Access
1987: forall i in l_del_rsc_rec.terr_rsc_id.first..l_del_rsc_rec.terr_rsc_id.last
1988: DELETE FROM JTF_TERR_RSC_ACCESS_ALL
1989: WHERE TERR_RSC_ID = l_del_rsc_rec.terr_rsc_id(i);
1990:
1991: -- Delete the Territory Resource records
1992: forall i in l_del_rsc_rec.terr_rsc_id.first..l_del_rsc_rec.terr_rsc_id.last

Line 5202: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(

5198:
5199: --dbms_output.put_line('Add Access to resource_id: '||l_terr_rsc_out_tbl(i).terr_rsc_id ||',access count: '||l_tr_access_tbl.count );
5200: if l_rsc_access_rec.TERR_RSC_ID.count > 0 then
5201: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5202: INSERT INTO JTF_TERR_RSC_ACCESS_ALL(
5203: TERR_RSC_ACCESS_ID,
5204: LAST_UPDATE_DATE,
5205: LAST_UPDATED_BY,
5206: CREATION_DATE,

Line 5280: Update JTF_TERR_RSC_ACCESS_ALL

5276:
5277: --dbms_output.put_line('Add Access to resource_id: '||l_terr_rsc_out_tbl(i).terr_rsc_id ||',access count: '||l_tr_access_tbl.count );
5278: if l_rsc_access_rec.TERR_RSC_ID.count > 0 then
5279: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5280: Update JTF_TERR_RSC_ACCESS_ALL
5281: SET
5282: LAST_UPDATE_DATE = l_rsc_access_rec.LAST_UPDATE_DATE(i),
5283: LAST_UPDATED_BY = l_rsc_access_rec.LAST_UPDATED_BY(i),
5284: LAST_UPDATE_LOGIN = l_rsc_access_rec.LAST_UPDATE_LOGIN(i),