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_QTYPE_USGS_S

Line 979: SELECT JTF_TERR_QTYPE_USGS_S.nextval

975: l_terr_usgs_tbl(1).ORG_ID := terr_group.ORG_ID;
976:
977:
978: /* ACCOUNT TRANSACTION TYPE */
979: SELECT JTF_TERR_QTYPE_USGS_S.nextval
980: into l_terr_qtype_usg_id
981: FROM DUAL;
982:
983: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1001;

Line 994: SELECT JTF_TERR_QTYPE_USGS_S.nextval

990: l_terr_qualtypeusgs_tbl(1).TERR_ID := null;
991: l_terr_qualtypeusgs_tbl(1).ORG_ID := terr_group.ORG_ID;
992:
993: /* LEAD TRANSACTION TYPE */
994: SELECT JTF_TERR_QTYPE_USGS_S.nextval
995: into l_terr_qtype_usg_id
996: FROM DUAL;
997:
998: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1002;

Line 1009: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1005: l_terr_qualtypeusgs_tbl(2).TERR_ID := null;
1006: l_terr_qualtypeusgs_tbl(2).ORG_ID := terr_group.ORG_ID;
1007:
1008: /* OPPORTUNITY TRANSACTION TYPE */
1009: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1010: into l_terr_qtype_usg_id
1011: FROM DUAL;
1012:
1013: l_terr_qualtypeusgs_tbl(3).QUAL_TYPE_USG_ID := -1003;

Line 1157: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1153: i:=i+1;
1154: if actype.access_type='ACCOUNT' then
1155:
1156: /* ACCOUNT TRANSACTION TYPE */
1157: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1158: into l_terr_qtype_usg_id
1159: FROM DUAL;
1160:
1161: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;

Line 1174: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1170:
1171: elsif actype.access_type='LEAD' then
1172:
1173: /* LEAD TRANSACTION TYPE */
1174: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1175: INTO l_terr_qtype_usg_id
1176: FROM DUAL;
1177:
1178: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 1191: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1187:
1188: elsif actype.access_type='OPPORTUNITY' then
1189:
1190: /* OPPORTUNITY TRANSACTION TYPE */
1191: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1192: into l_terr_qtype_usg_id
1193: FROM DUAL;
1194:
1195: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 1528: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1524:
1525: /* ACCOUNT TRANSACTION TYPE */
1526: if acctype.access_type='ACCOUNT' then
1527:
1528: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1529: into l_terr_qtype_usg_id
1530: FROM DUAL;
1531: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1532: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1544: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1540:
1541: /* LEAD TRANSACTION TYPE */
1542: elsif acctype.access_type='LEAD' 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: /* OPPORTUNITY TRANSACTION TYPE */
1558: elsif acctype.access_type='OPPORTUNITY' 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 1922: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1918:
1919: /* ACCOUNT TRANSACTION TYPE */
1920: if acctype.access_type='ACCOUNT' then
1921:
1922: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1923: into l_terr_qtype_usg_id
1924: FROM DUAL;
1925: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1926: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1938: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1934:
1935: /* LEAD TRANSACTION TYPE */
1936: elsif acctype.access_type='LEAD' then
1937:
1938: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1939: into l_terr_qtype_usg_id
1940: FROM DUAL;
1941: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1942: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 1954: SELECT JTF_TERR_QTYPE_USGS_S.nextval

1950:
1951: /* OPPORTUNITY TRANSACTION TYPE */
1952: elsif acctype.access_type='OPPORTUNITY' then
1953:
1954: SELECT JTF_TERR_QTYPE_USGS_S.nextval
1955: into l_terr_qtype_usg_id
1956: FROM DUAL;
1957: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;
1958: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;

Line 2338: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2334: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
2335:
2336:
2337: /* LEAD TRANSACTION TYPE */
2338: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2339: into l_terr_qtype_usg_id
2340: FROM DUAL;
2341:
2342: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2353: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2349: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
2350: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
2351:
2352: /* OPPORTUNITY TRANSACTION TYPE */
2353: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2354: into l_terr_qtype_usg_id
2355: FROM DUAL;
2356:
2357: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2539: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2535: l_terr_usgs_tbl(1).TERR_ID:= null;
2536: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
2537: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
2538:
2539: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2540: into l_terr_qtype_usg_id
2541: FROM DUAL;
2542:
2543: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2553: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2549: l_terr_qualtypeusgs_tbl(1).TERR_ID:= null;
2550: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
2551: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
2552:
2553: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2554: into l_terr_qtype_usg_id
2555: FROM DUAL;
2556:
2557: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2737: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2733: --i:=i+1;
2734: --dbms_output.put_line('acc type '||acc_type.access_type);
2735: if acc_type.access_type= 'OPPORTUNITY' then
2736: i:=i+1;
2737: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2738: into l_terr_qtype_usg_id
2739: FROM DUAL;
2740:
2741: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 2803: SELECT JTF_TERR_QTYPE_USGS_S.nextval

2799:
2800: elsif acc_type.access_type= 'LEAD' then
2801:
2802: i:=i+1;
2803: SELECT JTF_TERR_QTYPE_USGS_S.nextval
2804: into l_terr_qtype_usg_id
2805: FROM DUAL;
2806:
2807: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3122: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3118: l_terr_usgs_tbl(1).TERR_ID:= null;
3119: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
3120: l_terr_usgs_tbl(1).ORG_ID:= terr_group.ORG_ID;
3121:
3122: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3123: into l_terr_qtype_usg_id
3124: FROM DUAL;
3125:
3126: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3136: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3132: l_terr_qualtypeusgs_tbl(1).TERR_ID:= null;
3133: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID:=-1002;
3134: l_terr_qualtypeusgs_tbl(1).ORG_ID:=terr_group.ORG_ID;
3135:
3136: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3137: into l_terr_qtype_usg_id
3138: FROM DUAL;
3139:
3140: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3316: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3312: --i:=i+1;
3313: --dbms_output.put_line('acc type '||acc_type.access_type);
3314: if acc_type.access_type= 'OPPORTUNITY' then
3315: i:=i+1;
3316: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3317: into l_terr_qtype_usg_id
3318: FROM DUAL;
3319:
3320: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;

Line 3382: SELECT JTF_TERR_QTYPE_USGS_S.nextval

3378:
3379: elsif acc_type.access_type= 'LEAD' then
3380:
3381: i:=i+1;
3382: SELECT JTF_TERR_QTYPE_USGS_S.nextval
3383: into l_terr_qtype_usg_id
3384: FROM DUAL;
3385:
3386: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID:= l_terr_qtype_usg_id;