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

Line 1340: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1336:
1337: /* ACCOUNT ACCESS TYPE */
1338: IF rsc_acc.access_type= 'ACCOUNT' then
1339:
1340: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1341: INTO l_terr_rsc_access_id
1342: FROM DUAL;
1343:
1344: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1358: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1354:
1355: /* OPPORTUNITY ACCESS TYPE */
1356: ELSIF rsc_acc.access_type= 'OPPORTUNITY' then
1357:
1358: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1359: into l_terr_rsc_access_id
1360: FROM DUAL;
1361:
1362: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1376: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1372:
1373: /* LEAD ACCESS TYPE */
1374: elsif rsc_acc.access_type= 'LEAD' then
1375:
1376: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1377: into l_terr_rsc_access_id
1378: FROM DUAL;
1379:
1380: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 1733: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1729:
1730: /* ACCOUNT ACCESS TYPE */
1731: IF (rsc_acc.access_type= 'ACCOUNT') THEN
1732:
1733: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1734: into l_terr_rsc_access_id
1735: FROM DUAL;
1736: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1737: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 1750: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1746:
1747: /* OPPORTUNITY ACCESS TYPE */
1748: elsif rsc_acc.access_type= 'OPPORTUNITY' then
1749:
1750: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1751: into l_terr_rsc_access_id
1752: FROM DUAL;
1753: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1754: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 1768: SELECT JTF_TERR_RSC_ACCESS_S.nextval

1764:
1765: /* LEAD ACCESS TYPE */
1766: elsif rsc_acc.access_type= 'LEAD' then
1767:
1768: SELECT JTF_TERR_RSC_ACCESS_S.nextval
1769: into l_terr_rsc_access_id
1770: FROM DUAL;
1771: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
1772: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2127: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2123:
2124: /* ACCOUNT ACCESS TYPE */
2125: IF (rsc_acc.access_type= 'ACCOUNT') THEN
2126:
2127: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2128: into l_terr_rsc_access_id
2129: FROM DUAL;
2130: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2131: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2144: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2140:
2141: /* OPPORTUNITY ACCESS TYPE */
2142: elsif rsc_acc.access_type= 'OPPORTUNITY' then
2143:
2144: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2145: into l_terr_rsc_access_id
2146: FROM DUAL;
2147: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2148: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2162: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2158:
2159: /* LEAD ACCESS TYPE */
2160: elsif rsc_acc.access_type= 'LEAD' then
2161:
2162: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2163: into l_terr_rsc_access_id
2164: FROM DUAL;
2165: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2166: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2967: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2963: -- Product Overlay territories
2964: --
2965: if rsc_acc.access_type= 'ACCOUNT' then
2966:
2967: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2968: into l_terr_rsc_access_id
2969: FROM DUAL;
2970: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
2971: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2988: SELECT JTF_TERR_RSC_ACCESS_S.nextval

2984: if rsc_acc.access_type= 'OPPORTUNITY' then
2985:
2986: a := a+1;
2987:
2988: SELECT JTF_TERR_RSC_ACCESS_S.nextval
2989: into l_terr_rsc_access_id
2990: FROM DUAL;
2991:
2992: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3007: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3003: elsif rsc_acc.access_type= 'LEAD' then
3004:
3005: a := a+1;
3006:
3007: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3008: into l_terr_rsc_access_id
3009: FROM DUAL;
3010:
3011: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3551: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3547: -- Product Overlay territories
3548: --
3549: if rsc_acc.access_type= 'ACCOUNT' then
3550:
3551: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3552: into l_terr_rsc_access_id
3553: FROM DUAL;
3554: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;
3555: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3572: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3568: if rsc_acc.access_type= 'OPPORTUNITY' then
3569:
3570: a := a+1;
3571:
3572: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3573: into l_terr_rsc_access_id
3574: FROM DUAL;
3575:
3576: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;

Line 3591: SELECT JTF_TERR_RSC_ACCESS_S.nextval

3587: elsif rsc_acc.access_type= 'LEAD' then
3588:
3589: a := a+1;
3590:
3591: SELECT JTF_TERR_RSC_ACCESS_S.nextval
3592: into l_terr_rsc_access_id
3593: FROM DUAL;
3594:
3595: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID:= l_terr_rsc_access_id;