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_NA_GEO_TERR_PVT dependencies on JTF_TERR_RSC_ACCESS_S

Line 1355: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1351:
1352: /* ACCOUNT ACCESS TYPE */
1353: IF rsc_acc.access_type= 'ACCOUNT' then
1354:
1355: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1356: INTO l_terr_rsc_access_id
1357: FROM DUAL;
1358:
1359: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1373: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1369:
1370: /* OPPORTUNITY ACCESS TYPE */
1371: ELSIF rsc_acc.access_type= 'OPPORTUNITY' then
1372:
1373: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1374: into l_terr_rsc_access_id
1375: FROM DUAL;
1376:
1377: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1391: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1387:
1388: /* LEAD ACCESS TYPE */
1389: elsif rsc_acc.access_type= 'LEAD' then
1390:
1391: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1392: into l_terr_rsc_access_id
1393: FROM DUAL;
1394:
1395: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1746: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1742:
1743: /* ACCOUNT ACCESS TYPE */
1744: IF (rsc_acc.access_type= 'ACCOUNT') THEN
1745:
1746: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1747: into l_terr_rsc_access_id
1748: FROM DUAL;
1749: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1750: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 1763: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1759:
1760: /* OPPORTUNITY ACCESS TYPE */
1761: elsif rsc_acc.access_type= 'OPPORTUNITY' then
1762:
1763: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1764: into l_terr_rsc_access_id
1765: FROM DUAL;
1766: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1767: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 1781: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1777:
1778: /* LEAD ACCESS TYPE */
1779: elsif rsc_acc.access_type= 'LEAD' then
1780:
1781: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1782: into l_terr_rsc_access_id
1783: FROM DUAL;
1784: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1785: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2138: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2134:
2135: /* ACCOUNT ACCESS TYPE */
2136: IF (rsc_acc.access_type= 'ACCOUNT') THEN
2137:
2138: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2139: into l_terr_rsc_access_id
2140: FROM DUAL;
2141: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2142: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2155: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2151:
2152: /* OPPORTUNITY ACCESS TYPE */
2153: elsif rsc_acc.access_type= 'OPPORTUNITY' then
2154:
2155: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2156: into l_terr_rsc_access_id
2157: FROM DUAL;
2158: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2159: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2173: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2169:
2170: /* LEAD ACCESS TYPE */
2171: elsif rsc_acc.access_type= 'LEAD' then
2172:
2173: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2174: into l_terr_rsc_access_id
2175: FROM DUAL;
2176: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2177: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2975: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2971: -- Product Overlay territories
2972: --
2973: if rsc_acc.access_type= 'ACCOUNT' then
2974:
2975: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2976: into l_terr_rsc_access_id
2977: FROM DUAL;
2978: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2979: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2996: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2992: if rsc_acc.access_type= 'OPPORTUNITY' then
2993:
2994: a := a+1;
2995:
2996: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2997: into l_terr_rsc_access_id
2998: FROM DUAL;
2999:
3000: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3015: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3011: elsif rsc_acc.access_type= 'LEAD' then
3012:
3013: a := a+1;
3014:
3015: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3016: into l_terr_rsc_access_id
3017: FROM DUAL;
3018:
3019: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3559: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3555: -- Product Overlay territories
3556: --
3557: if rsc_acc.access_type= 'ACCOUNT' then
3558:
3559: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3560: into l_terr_rsc_access_id
3561: FROM DUAL;
3562: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
3563: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3580: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3576: if rsc_acc.access_type= 'OPPORTUNITY' then
3577:
3578: a := a+1;
3579:
3580: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3581: into l_terr_rsc_access_id
3582: FROM DUAL;
3583:
3584: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3599: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3595: elsif rsc_acc.access_type= 'LEAD' then
3596:
3597: a := a+1;
3598:
3599: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3600: into l_terr_rsc_access_id
3601: FROM DUAL;
3602:
3603: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 4342: SELECT JTF_TERR_RSC_ACCESS_S.nextval

4338:
4339: /* ACCOUNT ACCESS TYPE */
4340: IF (rsc_acc.access_type= 'ACCOUNT') THEN
4341:
4342: SELECT JTF_TERR_RSC_ACCESS_S.nextval
4343: into l_terr_rsc_access_id
4344: FROM DUAL;
4345: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
4346: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;

Line 4359: SELECT JTF_TERR_RSC_ACCESS_S.nextval

4355:
4356: /* OPPORTUNITY ACCESS TYPE */
4357: elsif rsc_acc.access_type= 'OPPORTUNITY' then
4358:
4359: SELECT JTF_TERR_RSC_ACCESS_S.nextval
4360: into l_terr_rsc_access_id
4361: FROM DUAL;
4362:
4363: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 4377: SELECT JTF_TERR_RSC_ACCESS_S.nextval

4373:
4374: /* LEAD ACCESS TYPE */
4375: elsif rsc_acc.access_type= 'LEAD' then
4376:
4377: SELECT JTF_TERR_RSC_ACCESS_S.nextval
4378: into l_terr_rsc_access_id
4379: FROM DUAL;
4380: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
4381: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;

Line 5140: SELECT JTF_TERR_RSC_ACCESS_S.nextval

5136: if rsc_acc.access_type= 'OPPORTUNITY' then
5137:
5138: a := a+1;
5139:
5140: SELECT JTF_TERR_RSC_ACCESS_S.nextval
5141: into l_terr_rsc_access_id
5142: FROM DUAL;
5143:
5144: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 5159: SELECT JTF_TERR_RSC_ACCESS_S.nextval

5155: elsif rsc_acc.access_type= 'LEAD' then
5156:
5157: a := a+1;
5158:
5159: SELECT JTF_TERR_RSC_ACCESS_S.nextval
5160: into l_terr_rsc_access_id
5161: FROM DUAL;
5162:
5163: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;