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_QTYPE_USGS_S

Line 991: SELECT JTF_TERR_QTYPE_USGS_S.nextval

987: l_terr_usgs_tbl(1).ORG_ID := terr_group.ORG_ID;
988:
989:
990: /* ACCOUNT TRANSACTION TYPE */
991: SELECT JTF_TERR_QTYPE_USGS_S.nextval
992: into l_terr_qtype_usg_id
993: FROM DUAL;
994:
995: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1001;

Line 1006: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1002: l_terr_qualtypeusgs_tbl(1).TERR_ID := null;
1003: l_terr_qualtypeusgs_tbl(1).ORG_ID := terr_group.ORG_ID;
1004:
1005: /* LEAD TRANSACTION TYPE */
1006: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1007: into l_terr_qtype_usg_id
1008: FROM DUAL;
1009:
1010: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1002;

Line 1021: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1017: l_terr_qualtypeusgs_tbl(2).TERR_ID := null;
1018: l_terr_qualtypeusgs_tbl(2).ORG_ID := terr_group.ORG_ID;
1019:
1020: /* OPPORTUNITY TRANSACTION TYPE */
1021: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1022: into l_terr_qtype_usg_id
1023: FROM DUAL;
1024:
1025: l_terr_qualtypeusgs_tbl(3).QUAL_TYPE_USG_ID := -1003;

Line 1171: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1167: i:=i+1;
1168: if actype.access_type='ACCOUNT' then
1169:
1170: /* ACCOUNT TRANSACTION TYPE */
1171: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1172: into l_terr_qtype_usg_id
1173: FROM DUAL;
1174:
1175: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;

Line 1188: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1184:
1185: elsif actype.access_type='LEAD' then
1186:
1187: /* LEAD TRANSACTION TYPE */
1188: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1189: INTO l_terr_qtype_usg_id
1190: FROM DUAL;
1191:
1192: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 1205: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1201:
1202: elsif actype.access_type='OPPORTUNITY' then
1203:
1204: /* OPPORTUNITY TRANSACTION TYPE */
1205: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1206: into l_terr_qtype_usg_id
1207: FROM DUAL;
1208:
1209: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 1544: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1540:
1541: /* ACCOUNT TRANSACTION TYPE */
1542: if acctype.access_type='ACCOUNT' then
1543:
1544: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1545: into l_terr_qtype_usg_id
1546: FROM DUAL;
1547: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1548: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1560: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1556:
1557: /* LEAD TRANSACTION TYPE */
1558: elsif acctype.access_type='LEAD' then
1559:
1560: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1561: into l_terr_qtype_usg_id
1562: FROM DUAL;
1563: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1564: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1576: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1572:
1573: /* OPPORTUNITY TRANSACTION TYPE */
1574: elsif acctype.access_type='OPPORTUNITY' then
1575:
1576: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1577: into l_terr_qtype_usg_id
1578: FROM DUAL;
1579: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1580: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1934: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1930:
1931: /* ACCOUNT TRANSACTION TYPE */
1932: if acctype.access_type='ACCOUNT' then
1933:
1934: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1935: into l_terr_qtype_usg_id
1936: FROM DUAL;
1937: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1938: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1950: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1946:
1947: /* LEAD TRANSACTION TYPE */
1948: elsif acctype.access_type='LEAD' then
1949:
1950: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1951: into l_terr_qtype_usg_id
1952: FROM DUAL;
1953: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1954: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1966: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1962:
1963: /* OPPORTUNITY TRANSACTION TYPE */
1964: elsif acctype.access_type='OPPORTUNITY' then
1965:
1966: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1967: into l_terr_qtype_usg_id
1968: FROM DUAL;
1969: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1970: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 2349: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2345: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
2346:
2347:
2348: /* LEAD TRANSACTION TYPE */
2349: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2350: into l_terr_qtype_usg_id
2351: FROM DUAL;
2352:
2353: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2364: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2360: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
2361: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
2362:
2363: /* OPPORTUNITY TRANSACTION TYPE */
2364: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2365: into l_terr_qtype_usg_id
2366: FROM DUAL;
2367:
2368: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2549: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2545: l_terr_usgs_tbl(1).TERR_ID:= null;
2546: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
2547: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
2548:
2549: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2550: into l_terr_qtype_usg_id
2551: FROM DUAL;
2552:
2553: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2563: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2559: l_terr_qualtypeusgs_tbl(1).TERR_ID:= null;
2560: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
2561: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
2562:
2563: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2564: into l_terr_qtype_usg_id
2565: FROM DUAL;
2566:
2567: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2745: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2741: --i:=i+1;
2742: --dbms_output.put_line('acc type '||acc_type.access_type);
2743: if acc_type.access_type= 'OPPORTUNITY' then
2744: i:=i+1;
2745: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2746: into l_terr_qtype_usg_id
2747: FROM DUAL;
2748:
2749: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2811: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2807:
2808: elsif acc_type.access_type= 'LEAD' then
2809:
2810: i:=i+1;
2811: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2812: into l_terr_qtype_usg_id
2813: FROM DUAL;
2814:
2815: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3130: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3126: l_terr_usgs_tbl(1).TERR_ID:= null;
3127: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
3128: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
3129:
3130: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3131: into l_terr_qtype_usg_id
3132: FROM DUAL;
3133:
3134: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3144: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3140: l_terr_qualtypeusgs_tbl(1).TERR_ID:= null;
3141: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
3142: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
3143:
3144: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3145: into l_terr_qtype_usg_id
3146: FROM DUAL;
3147:
3148: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3324: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3320: --i:=i+1;
3321: --dbms_output.put_line('acc type '||acc_type.access_type);
3322: if acc_type.access_type= 'OPPORTUNITY' then
3323: i:=i+1;
3324: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3325: into l_terr_qtype_usg_id
3326: FROM DUAL;
3327:
3328: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3390: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3386:
3387: elsif acc_type.access_type= 'LEAD' then
3388:
3389: i:=i+1;
3390: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3391: into l_terr_qtype_usg_id
3392: FROM DUAL;
3393:
3394: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4143: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4139: /* ACCOUNT TRANSACTION TYPE */
4140:
4141: if acctype.access_type='ACCOUNT' then
4142:
4143: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4144: into l_terr_qtype_usg_id
4145: FROM DUAL;
4146:
4147: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;

Line 4160: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4156:
4157: /* LEAD TRANSACTION TYPE */
4158: elsif acctype.access_type='LEAD' then
4159:
4160: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4161: into l_terr_qtype_usg_id
4162: FROM DUAL;
4163: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
4164: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_terr_group_rec.LAST_UPDATE_DATE;

Line 4176: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4172:
4173: /* OPPORTUNITY TRANSACTION TYPE */
4174: elsif acctype.access_type='OPPORTUNITY' then
4175:
4176: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4177: into l_terr_qtype_usg_id
4178: FROM DUAL;
4179: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
4180: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;

Line 4526: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4522: l_terr_usgs_tbl(1).ORG_ID:= p_ORG_ID;
4523:
4524:
4525: /* LEAD TRANSACTION TYPE */
4526: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4527: into l_terr_qtype_usg_id
4528: FROM DUAL;
4529:
4530: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4541: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4537: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
4538: l_terr_qualtypeusgs_tbl(1).ORG_ID:=p_ORG_ID;
4539:
4540: /* OPPORTUNITY TRANSACTION TYPE */
4541: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4542: into l_terr_qtype_usg_id
4543: FROM DUAL;
4544:
4545: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4732: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4728: l_terr_usgs_tbl(1).TERR_ID:= null;
4729: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
4730: l_terr_usgs_tbl(1).ORG_ID:= p_ORG_ID;
4731:
4732: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4733: into l_terr_qtype_usg_id
4734: FROM DUAL;
4735:
4736: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4746: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4742: l_terr_qualtypeusgs_tbl(1).TERR_ID:= null;
4743: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
4744: l_terr_qualtypeusgs_tbl(1).ORG_ID:=p_ORG_ID;
4745:
4746: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4747: into l_terr_qtype_usg_id
4748: FROM DUAL;
4749:
4750: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4921: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4917: --i:=i+1;
4918: --dbms_output.put_line('acc type '||acc_type.access_type);
4919: if acc_type.access_type= 'OPPORTUNITY' then
4920: i:=i+1;
4921: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4922: into l_terr_qtype_usg_id
4923: FROM DUAL;
4924:
4925: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 4987: SELECT JTF_TERR_QTYPE_USGS_S.nextval

4983:
4984: elsif acc_type.access_type= 'LEAD' then
4985:
4986: i:=i+1;
4987: SELECT JTF_TERR_QTYPE_USGS_S.nextval
4988: into l_terr_qtype_usg_id
4989: FROM DUAL;
4990:
4991: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;