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 DUAL

Line 851: FROM DUAL;

847: i :=i +1;
848:
849: SELECT JTF_TTY_TERR_GRP_ROLES_S.nextval
850: into l_id
851: FROM DUAL;
852:
853: l_overnon_role_tbl(i).grp_role_id:= l_id;
854: --
855:

Line 977: FROM DUAL;

973:
974: /* ORACLE SALES AND TELESALES USAGE */
975: SELECT JTF_TERR_USGS_S.nextval
976: INTO l_terr_usg_id
977: FROM DUAL;
978:
979: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
980: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
981: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;

Line 993: FROM DUAL;

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;
996: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
997: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;

Line 1008: FROM DUAL;

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;
1011: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1012: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;

Line 1023: FROM DUAL;

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;
1026: l_terr_qualtypeusgs_tbl(3).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1027: l_terr_qualtypeusgs_tbl(3).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;

Line 1151: FROM DUAL;

1147:
1148: /* Oracle Sales and Telesales Usage */
1149: SELECT JTF_TERR_USGS_S.nextval
1150: into l_terr_usg_id
1151: FROM DUAL;
1152:
1153: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1154: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;
1155: l_terr_usgs_tbl(1).LAST_UPDATED_BY := G_USER_ID;

Line 1173: FROM DUAL;

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;
1176: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;
1177: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := G_USER_ID;

Line 1190: FROM DUAL;

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;
1193: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1194: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1207: FROM DUAL;

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;
1210: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1211: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1228: FROM DUAL;

1224: /*
1225: ** Customer Name Range Qualifier -1012 */
1226: SELECT JTF_TERR_QUAL_S.nextval
1227: into l_terr_qual_id
1228: FROM DUAL;
1229:
1230: l_terr_qual_tbl(1).TERR_QUAL_ID :=l_terr_qual_id;
1231: l_terr_qual_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1232: l_terr_qual_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1325: FROM DUAL;

1321: l_init_msg_list :=FND_API.G_TRUE;
1322:
1323: SELECT JTF_TERR_RSC_S.nextval
1324: into l_terr_rsc_id
1325: FROM DUAL;
1326:
1327: l_TerrRsc_Tbl(1).terr_id := x_terr_id;
1328: l_TerrRsc_Tbl(1).TERR_RSC_ID :=l_terr_rsc_id;
1329: l_TerrRsc_Tbl(1).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 1357: FROM DUAL;

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;
1360: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1361: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1375: FROM DUAL;

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;
1378: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1379: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1393: FROM DUAL;

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;
1396: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1397: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1521: FROM DUAL;

1517:
1518: /* Oracle Sales and Telesales Usage */
1519: SELECT JTF_TERR_USGS_S.nextval
1520: into l_terr_usg_id
1521: FROM DUAL;
1522:
1523: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1524: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1525: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1546: FROM DUAL;

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;
1549: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1550: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1562: FROM DUAL;

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;
1565: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1566: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1578: FROM DUAL;

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;
1581: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1582: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1612: FROM DUAL;

1608: j:=j+1;
1609:
1610: SELECT JTF_TERR_QUAL_S.nextval
1611: into l_terr_qual_id
1612: FROM DUAL;
1613:
1614: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
1615: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1616: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1716: FROM DUAL;

1712: i:=i+1;
1713:
1714: SELECT JTF_TERR_RSC_S.nextval
1715: into l_terr_rsc_id
1716: FROM DUAL;
1717:
1718: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
1719: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
1720: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 1748: FROM DUAL;

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 ;
1751: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1752: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1765: FROM DUAL;

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 ;
1768: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1769: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1783: FROM DUAL;

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 ;
1786: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1787: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1913: FROM DUAL;

1909:
1910: /* Oracle Sales and Telesales Usage */
1911: SELECT JTF_TERR_USGS_S.nextval
1912: into l_terr_usg_id
1913: FROM DUAL;
1914:
1915: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1916: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1917: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1936: FROM DUAL;

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;
1939: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1940: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1952: FROM DUAL;

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;
1955: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1956: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 1968: FROM DUAL;

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;
1971: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
1972: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= terr_group.CREATION_DATE;

Line 2002: FROM DUAL;

1998: j:=j+1;
1999:
2000: SELECT JTF_TERR_QUAL_S.nextval
2001: into l_terr_qual_id
2002: FROM DUAL;
2003:
2004: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
2005: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
2006: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2108: FROM DUAL;

2104: i:=i+1;
2105:
2106: SELECT JTF_TERR_RSC_S.nextval
2107: into l_terr_rsc_id
2108: FROM DUAL;
2109:
2110: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2111: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
2112: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 2140: FROM DUAL;

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 ;
2143: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
2144: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 2157: FROM DUAL;

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 ;
2160: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
2161: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 2175: FROM DUAL;

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 ;
2178: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
2179: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 2335: FROM DUAL;

2331:
2332: /* ORACLE SALES AND TELESALES USAGE */
2333: SELECT JTF_TERR_USGS_S.nextval
2334: into l_terr_usg_id
2335: FROM DUAL;
2336:
2337: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2338: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2339: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2351: FROM DUAL;

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;
2354: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2355: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2366: FROM DUAL;

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;
2369: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2370: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2392: FROM DUAL;

2388: j:=j+1;
2389:
2390: SELECT JTF_TERR_QUAL_S.nextval
2391: INTO l_terr_qual_id
2392: FROM DUAL;
2393:
2394: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
2395: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
2396: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2537: FROM DUAL;

2533:
2534:
2535: SELECT JTF_TERR_USGS_S.nextval
2536: into l_terr_usg_id
2537: FROM DUAL;
2538:
2539: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2540: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2541: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2551: FROM DUAL;

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;
2554: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2555: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2565: FROM DUAL;

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;
2568: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2569: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2579: FROM DUAL;

2575: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
2576:
2577: SELECT JTF_TERR_QUAL_S.nextval
2578: into l_terr_qual_id
2579: FROM DUAL;
2580:
2581: j:=0;
2582: K:=0;
2583: l_prev_qual_usg_id:=1;

Line 2593: FROM DUAL;

2589:
2590: j:=j+1;
2591: SELECT JTF_TERR_QUAL_S.nextval
2592: into l_terr_qual_id
2593: FROM DUAL;
2594:
2595: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
2596: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
2597: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2726: FROM DUAL;

2722: l_terr_all_rec.NUM_WINNERS :=null ;
2723:
2724: SELECT JTF_TERR_USGS_S.nextval
2725: into l_terr_usg_id
2726: FROM DUAL;
2727:
2728: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2729: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2730: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2747: FROM DUAL;

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;
2750: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2751: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2761: FROM DUAL;

2757: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2758:
2759: SELECT JTF_TERR_QUAL_S.nextval
2760: into l_terr_qual_id
2761: FROM DUAL;
2762: /* opp expected purchase */
2763:
2764: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
2765: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2813: FROM DUAL;

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;
2816: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2817: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2827: FROM DUAL;

2823: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2824:
2825: SELECT JTF_TERR_QUAL_S.nextval
2826: into l_terr_qual_id
2827: FROM DUAL;
2828:
2829: /* lead expected purchase */
2830: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
2831: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2942: FROM DUAL;

2938: i:=i+1;
2939:
2940: SELECT JTF_TERR_RSC_S.nextval
2941: into l_terr_rsc_id
2942: FROM DUAL;
2943:
2944: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2945: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
2946: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 2977: FROM DUAL;

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 ;
2980: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
2981: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 2998: FROM DUAL;

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;
3001: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3002: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3017: FROM DUAL;

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;
3020: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3021: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3118: FROM DUAL;

3114:
3115:
3116: SELECT JTF_TERR_USGS_S.nextval
3117: into l_terr_usg_id
3118: FROM DUAL;
3119:
3120: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3121: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3122: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3132: FROM DUAL;

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;
3135: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3136: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3146: FROM DUAL;

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;
3149: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3150: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3160: FROM DUAL;

3156: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
3157:
3158: SELECT JTF_TERR_QUAL_S.nextval
3159: into l_terr_qual_id
3160: FROM DUAL;
3161:
3162: j:=0;
3163: K:=0;
3164: l_prev_qual_usg_id:=1;

Line 3174: FROM DUAL;

3170:
3171: j:=j+1;
3172: SELECT JTF_TERR_QUAL_S.nextval
3173: into l_terr_qual_id
3174: FROM DUAL;
3175:
3176: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
3177: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3178: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3305: FROM DUAL;

3301: l_terr_all_rec.NUM_WINNERS :=null ;
3302:
3303: SELECT JTF_TERR_USGS_S.nextval
3304: into l_terr_usg_id
3305: FROM DUAL;
3306:
3307: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3308: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3309: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3326: FROM DUAL;

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;
3329: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3330: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3340: FROM DUAL;

3336: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3337:
3338: SELECT JTF_TERR_QUAL_S.nextval
3339: into l_terr_qual_id
3340: FROM DUAL;
3341: /* opp expected purchase */
3342:
3343: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
3344: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3392: FROM DUAL;

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;
3395: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3396: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3406: FROM DUAL;

3402: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3403:
3404: SELECT JTF_TERR_QUAL_S.nextval
3405: into l_terr_qual_id
3406: FROM DUAL;
3407:
3408: /* lead expected purchase */
3409: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
3410: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3526: FROM DUAL;

3522: i:=i+1;
3523:
3524: SELECT JTF_TERR_RSC_S.nextval
3525: into l_terr_rsc_id
3526: FROM DUAL;
3527:
3528: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
3529: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
3530: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 3561: FROM DUAL;

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 ;
3564: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;
3565: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= terr_group.CREATION_DATE;

Line 3582: FROM DUAL;

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;
3585: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3586: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3601: FROM DUAL;

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;
3604: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3605: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 4119: FROM DUAL;

4115: /* Oracle Sales and Telesales Usage */
4116:
4117: SELECT JTF_TERR_USGS_S.nextval
4118: into l_terr_usg_id
4119: FROM DUAL;
4120:
4121: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
4122: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_terr_group_rec.LAST_UPDATE_DATE;
4123: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_terr_group_rec.LAST_UPDATED_BY;

Line 4145: FROM DUAL;

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;
4148: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_terr_group_rec.LAST_UPDATE_DATE;
4149: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_terr_group_rec.LAST_UPDATED_BY;

Line 4162: FROM DUAL;

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;
4165: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_terr_group_rec.LAST_UPDATED_BY;
4166: l_terr_qualtypeusgs_tbl(i).CREATION_DATE := p_terr_group_rec.CREATION_DATE;

Line 4178: FROM DUAL;

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;
4181: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;
4182: l_terr_qualtypeusgs_tbl(i).CREATION_DATE:= p_terr_group_rec.CREATION_DATE;

Line 4216: FROM DUAL;

4212: j:=j+1;
4213:
4214: SELECT JTF_TERR_QUAL_S.nextval
4215: into l_terr_qual_id
4216: FROM DUAL;
4217:
4218: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
4219: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
4220: l_terr_qual_tbl(j).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4316: FROM DUAL;

4312: i := i+1;
4313:
4314: SELECT JTF_TERR_RSC_S.nextval
4315: into l_terr_rsc_id
4316: FROM DUAL;
4317:
4318: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
4319: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
4320: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=p_terr_group_rec.LAST_UPDATE_DATE;

Line 4344: FROM DUAL;

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 ;
4347: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;
4348: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= p_terr_group_rec.CREATION_DATE;

Line 4361: FROM DUAL;

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;
4364: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
4365: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4379: FROM DUAL;

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 ;
4382: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;
4383: l_TerrRsc_Access_Tbl(a).CREATION_DATE:= p_terr_group_rec.CREATION_DATE;

Line 4512: FROM DUAL;

4508: /* ORACLE SALES AND TELESALES USAGE */
4509:
4510: SELECT JTF_TERR_USGS_S.nextval
4511: into l_terr_usg_id
4512: FROM DUAL;
4513:
4514: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
4515: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4516: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4528: FROM DUAL;

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;
4531: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4532: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4543: FROM DUAL;

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;
4546: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4547: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4572: FROM DUAL;

4568: j:=j+1;
4569:
4570: SELECT JTF_TERR_QUAL_S.nextval
4571: INTO l_terr_qual_id
4572: FROM DUAL;
4573:
4574: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
4575: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
4576: l_terr_qual_tbl(j).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4720: FROM DUAL;

4716:
4717:
4718: SELECT JTF_TERR_USGS_S.nextval
4719: into l_terr_usg_id
4720: FROM DUAL;
4721:
4722: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
4723: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4724: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4734: FROM DUAL;

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;
4737: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4738: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4748: FROM DUAL;

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;
4751: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4752: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4762: FROM DUAL;

4758: l_terr_qualtypeusgs_tbl(2).ORG_ID:=p_ORG_ID;
4759:
4760: SELECT JTF_TERR_QUAL_S.nextval
4761: into l_terr_qual_id
4762: FROM DUAL;
4763:
4764: j:=0;
4765: K:=0;
4766: l_prev_qual_usg_id:=1;

Line 4775: FROM DUAL;

4771:
4772: j:=j+1;
4773: SELECT JTF_TERR_QUAL_S.nextval
4774: into l_terr_qual_id
4775: FROM DUAL;
4776:
4777: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
4778: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
4779: l_terr_qual_tbl(j).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4901: FROM DUAL;

4897: l_terr_all_rec.NUM_WINNERS :=null ;
4898:
4899: SELECT JTF_TERR_USGS_S.nextval
4900: into l_terr_usg_id
4901: FROM DUAL;
4902:
4903: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
4904: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4905: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4923: FROM DUAL;

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;
4926: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4927: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 4937: FROM DUAL;

4933: l_terr_qualtypeusgs_tbl(i).ORG_ID:=p_ORG_ID;
4934:
4935: SELECT JTF_TERR_QUAL_S.nextval
4936: into l_terr_qual_id
4937: FROM DUAL;
4938: /* opp expected purchase */
4939:
4940: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
4941: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;

Line 4989: FROM DUAL;

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;
4992: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE;
4993: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 5003: FROM DUAL;

4999: l_terr_qualtypeusgs_tbl(i).ORG_ID:=p_ORG_ID;
5000:
5001: SELECT JTF_TERR_QUAL_S.nextval
5002: into l_terr_qual_id
5003: FROM DUAL;
5004:
5005: /* lead expected purchase */
5006: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
5007: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;

Line 5109: FROM DUAL;

5105: i:=i+1;
5106:
5107: SELECT JTF_TERR_RSC_S.nextval
5108: into l_terr_rsc_id
5109: FROM DUAL;
5110:
5111: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
5112: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
5113: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=p_terr_group_rec.LAST_UPDATE_DATE;

Line 5142: FROM DUAL;

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;
5145: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
5146: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;

Line 5161: FROM DUAL;

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;
5164: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE:= p_terr_group_rec.LAST_UPDATE_DATE ;
5165: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY:= p_terr_group_rec.LAST_UPDATED_BY;