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

Line 1652: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

1648:
1649: /* ACCOUNT ACCESS TYPE */
1650: IF (rsc_acc.access_type= 'ACCOUNT') THEN
1651:
1652: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
1653: INTO l_terr_rsc_access_id
1654: FROM DUAL;
1655:
1656: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 1670: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

1666:
1667: /* OPPORTUNITY ACCESS TYPE */
1668: ELSIF rsc_acc.access_type= 'OPPORTUNITY' THEN
1669:
1670: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
1671: INTO l_terr_rsc_access_id
1672: FROM DUAL;
1673:
1674: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 1688: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

1684:
1685: /* LEAD ACCESS TYPE */
1686: ELSIF rsc_acc.access_type= 'LEAD' THEN
1687:
1688: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
1689: INTO l_terr_rsc_access_id
1690: FROM DUAL;
1691:
1692: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 2253: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

2249: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
2250:
2251: a := a+1;
2252:
2253: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
2254: INTO l_terr_rsc_access_id
2255: FROM DUAL;
2256:
2257: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 2272: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

2268: ELSIF rsc_acc.access_type= 'LEAD' THEN
2269:
2270: a := a+1;
2271:
2272: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
2273: INTO l_terr_rsc_access_id
2274: FROM DUAL;
2275:
2276: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 3314: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

3310:
3311: /* ACCOUNT ACCESS TYPE */
3312: IF (rsc_acc.access_type= 'ACCOUNT') THEN
3313:
3314: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
3315: INTO l_terr_rsc_access_id
3316: FROM DUAL;
3317:
3318: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 3332: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

3328:
3329: /* OPPORTUNITY ACCESS TYPE */
3330: ELSIF rsc_acc.access_type= 'OPPORTUNITY' THEN
3331:
3332: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
3333: INTO l_terr_rsc_access_id
3334: FROM DUAL;
3335:
3336: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 3350: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

3346:
3347: /* LEAD ACCESS TYPE */
3348: ELSIF rsc_acc.access_type= 'LEAD' THEN
3349:
3350: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
3351: INTO l_terr_rsc_access_id
3352: FROM DUAL;
3353:
3354: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 4109: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

4105: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
4106:
4107: a := a+1;
4108:
4109: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
4110: INTO l_terr_rsc_access_id
4111: FROM DUAL;
4112:
4113: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 4128: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

4124: ELSIF rsc_acc.access_type= 'LEAD' THEN
4125:
4126: a := a+1;
4127:
4128: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
4129: INTO l_terr_rsc_access_id
4130: FROM DUAL;
4131:
4132: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 5197: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

5193: ELSE
5194: l_qual_type := rsc_acc.access_type;
5195: END IF;
5196:
5197: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
5198: INTO l_terr_rsc_access_id
5199: FROM DUAL;
5200:
5201: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 5576: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

5572: ELSE
5573: l_qual_type := rsc_acc.access_type;
5574: END IF;
5575:
5576: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
5577: INTO l_terr_rsc_access_id
5578: FROM DUAL;
5579:
5580: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 6227: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

6223: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
6224:
6225: a := a+1;
6226:
6227: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
6228: INTO l_terr_rsc_access_id
6229: FROM DUAL;
6230:
6231: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 6245: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

6241: ELSIF rsc_acc.access_type= 'LEAD' THEN
6242:
6243: a := a+1;
6244:
6245: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
6246: INTO l_terr_rsc_access_id
6247: FROM DUAL;
6248:
6249: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 6808: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

6804: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
6805:
6806: a := a+1;
6807:
6808: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
6809: INTO l_terr_rsc_access_id
6810: FROM DUAL;
6811:
6812: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 6827: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

6823: ELSIF rsc_acc.access_type= 'LEAD' THEN
6824:
6825: a := a+1;
6826:
6827: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
6828: INTO l_terr_rsc_access_id
6829: FROM DUAL;
6830:
6831: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 7969: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

7965: a := a+1;
7966:
7967: IF rsc_acc.access_type= 'ACCOUNT' THEN
7968:
7969: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
7970: INTO l_terr_rsc_access_id
7971: FROM DUAL;
7972:
7973: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 7986: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

7982: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := 1;
7983:
7984: ELSIF rsc_acc.access_type= 'OPPORTUNITY' THEN
7985:
7986: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
7987: INTO l_terr_rsc_access_id
7988: FROM DUAL;
7989:
7990: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 8003: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

7999: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := 1;
8000:
8001: ELSIF rsc_acc.access_type= 'LEAD' THEN
8002:
8003: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
8004: INTO l_terr_rsc_access_id
8005: FROM DUAL;
8006:
8007: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 8415: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

8411: ELSE
8412: l_qual_type := rsc_acc.access_type;
8413: END IF;
8414:
8415: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
8416: INTO l_terr_rsc_access_id
8417: FROM DUAL;
8418:
8419: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 8792: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

8788: ELSE
8789: l_qual_type := rsc_acc.access_type;
8790: END IF;
8791:
8792: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
8793: INTO l_terr_rsc_access_id
8794: FROM DUAL;
8795:
8796: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 9626: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

9622: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
9623:
9624: a := a+1;
9625:
9626: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
9627: INTO l_terr_rsc_access_id
9628: FROM DUAL;
9629:
9630: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 9644: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

9640: ELSIF rsc_acc.access_type= 'LEAD' THEN
9641:
9642: a := a+1;
9643:
9644: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
9645: INTO l_terr_rsc_access_id
9646: FROM DUAL;
9647:
9648: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 10209: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

10205: IF rsc_acc.access_type= 'OPPORTUNITY' THEN
10206:
10207: a := a+1;
10208:
10209: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
10210: INTO l_terr_rsc_access_id
10211: FROM DUAL;
10212:
10213: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 10228: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

10224: ELSIF rsc_acc.access_type= 'LEAD' THEN
10225:
10226: a := a+1;
10227:
10228: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
10229: INTO l_terr_rsc_access_id
10230: FROM DUAL;
10231:
10232: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;

Line 12746: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

12742: END IF;
12743:
12744: l_trans_access_code := rsc_acc.trans_access_code;
12745:
12746: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
12747: INTO l_terr_rsc_access_id
12748: FROM DUAL;
12749:
12750: INSERT INTO jtf_terr_rsc_access_all

Line 13031: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

13027: ELSE
13028: l_qual_type := rsc_acc.access_type;
13029: END IF;
13030:
13031: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
13032: INTO l_terr_rsc_access_id
13033: FROM DUAL;
13034:
13035: l_TerrRsc_Access_Tbl(a).TERR_RSC_ACCESS_ID := l_terr_rsc_access_id;