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 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 965: FROM DUAL;

961:
962: /* ORACLE SALES AND TELESALES USAGE */
963: SELECT JTF_TERR_USGS_S.nextval
964: INTO l_terr_usg_id
965: FROM DUAL;
966:
967: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
968: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
969: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;

Line 981: FROM DUAL;

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

Line 996: FROM DUAL;

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

Line 1011: FROM DUAL;

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

Line 1137: FROM DUAL;

1133:
1134: /* Oracle Sales and Telesales Usage */
1135: SELECT JTF_TERR_USGS_S.nextval
1136: into l_terr_usg_id
1137: FROM DUAL;
1138:
1139: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1140: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := terr_group.LAST_UPDATE_DATE;
1141: l_terr_usgs_tbl(1).LAST_UPDATED_BY := G_USER_ID;

Line 1159: FROM DUAL;

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

Line 1176: FROM DUAL;

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

Line 1193: FROM DUAL;

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

Line 1213: FROM DUAL;

1209: /*
1210: ** Customer Name Range Qualifier -1012 */
1211: SELECT JTF_TERR_QUAL_S.nextval
1212: into l_terr_qual_id
1213: FROM DUAL;
1214:
1215: l_terr_qual_tbl(1).TERR_QUAL_ID :=l_terr_qual_id;
1216: l_terr_qual_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1217: l_terr_qual_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1310: FROM DUAL;

1306: l_init_msg_list :=FND_API.G_TRUE;
1307:
1308: SELECT JTF_TERR_RSC_S.nextval
1309: into l_terr_rsc_id
1310: FROM DUAL;
1311:
1312: l_TerrRsc_Tbl(1).terr_id := x_terr_id;
1313: l_TerrRsc_Tbl(1).TERR_RSC_ID :=l_terr_rsc_id;
1314: l_TerrRsc_Tbl(1).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 1342: FROM DUAL;

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

Line 1360: FROM DUAL;

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

Line 1378: FROM DUAL;

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

Line 1507: FROM DUAL;

1503:
1504: /* Oracle Sales and Telesales Usage */
1505: SELECT JTF_TERR_USGS_S.nextval
1506: into l_terr_usg_id
1507: FROM DUAL;
1508:
1509: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1510: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1511: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1530: FROM DUAL;

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

Line 1546: FROM DUAL;

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;
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='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;
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 1596: FROM DUAL;

1592: j:=j+1;
1593:
1594: SELECT JTF_TERR_QUAL_S.nextval
1595: into l_terr_qual_id
1596: FROM DUAL;
1597:
1598: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
1599: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1600: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1703: FROM DUAL;

1699: i:=i+1;
1700:
1701: SELECT JTF_TERR_RSC_S.nextval
1702: into l_terr_rsc_id
1703: FROM DUAL;
1704:
1705: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
1706: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
1707: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 1735: FROM DUAL;

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

Line 1752: FROM DUAL;

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

Line 1770: FROM DUAL;

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

Line 1901: FROM DUAL;

1897:
1898: /* Oracle Sales and Telesales Usage */
1899: SELECT JTF_TERR_USGS_S.nextval
1900: into l_terr_usg_id
1901: FROM DUAL;
1902:
1903: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1904: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
1905: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 1924: FROM DUAL;

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

Line 1940: FROM DUAL;

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

Line 1956: FROM DUAL;

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

Line 1990: FROM DUAL;

1986: j:=j+1;
1987:
1988: SELECT JTF_TERR_QUAL_S.nextval
1989: into l_terr_qual_id
1990: FROM DUAL;
1991:
1992: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
1993: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
1994: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2097: FROM DUAL;

2093: i:=i+1;
2094:
2095: SELECT JTF_TERR_RSC_S.nextval
2096: into l_terr_rsc_id
2097: FROM DUAL;
2098:
2099: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2100: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
2101: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 2129: FROM DUAL;

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

Line 2146: FROM DUAL;

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

Line 2164: FROM DUAL;

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

Line 2324: FROM DUAL;

2320:
2321: /* ORACLE SALES AND TELESALES USAGE */
2322: SELECT JTF_TERR_USGS_S.nextval
2323: into l_terr_usg_id
2324: FROM DUAL;
2325:
2326: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2327: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2328: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2340: FROM DUAL;

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

Line 2355: FROM DUAL;

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

Line 2381: FROM DUAL;

2377: j:=j+1;
2378:
2379: SELECT JTF_TERR_QUAL_S.nextval
2380: INTO l_terr_qual_id
2381: FROM DUAL;
2382:
2383: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
2384: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
2385: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2527: FROM DUAL;

2523:
2524:
2525: SELECT JTF_TERR_USGS_S.nextval
2526: into l_terr_usg_id
2527: FROM DUAL;
2528:
2529: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2530: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2531: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2541: FROM DUAL;

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

Line 2555: FROM DUAL;

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

Line 2569: FROM DUAL;

2565: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
2566:
2567: SELECT JTF_TERR_QUAL_S.nextval
2568: into l_terr_qual_id
2569: FROM DUAL;
2570:
2571: j:=0;
2572: K:=0;
2573: l_prev_qual_usg_id:=1;

Line 2583: FROM DUAL;

2579:
2580: j:=j+1;
2581: SELECT JTF_TERR_QUAL_S.nextval
2582: into l_terr_qual_id
2583: FROM DUAL;
2584:
2585: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
2586: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
2587: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2718: FROM DUAL;

2714: l_terr_all_rec.NUM_WINNERS :=null ;
2715:
2716: SELECT JTF_TERR_USGS_S.nextval
2717: into l_terr_usg_id
2718: FROM DUAL;
2719:
2720: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2721: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
2722: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 2739: FROM DUAL;

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

Line 2753: FROM DUAL;

2749: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2750:
2751: SELECT JTF_TERR_QUAL_S.nextval
2752: into l_terr_qual_id
2753: FROM DUAL;
2754: /* opp expected purchase */
2755:
2756: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
2757: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2805: FROM DUAL;

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

Line 2819: FROM DUAL;

2815: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2816:
2817: SELECT JTF_TERR_QUAL_S.nextval
2818: into l_terr_qual_id
2819: FROM DUAL;
2820:
2821: /* lead expected purchase */
2822: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
2823: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 2934: FROM DUAL;

2930: i:=i+1;
2931:
2932: SELECT JTF_TERR_RSC_S.nextval
2933: into l_terr_rsc_id
2934: FROM DUAL;
2935:
2936: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2937: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
2938: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 2969: FROM DUAL;

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

Line 2990: FROM DUAL;

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

Line 3009: FROM DUAL;

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

Line 3110: FROM DUAL;

3106:
3107:
3108: SELECT JTF_TERR_USGS_S.nextval
3109: into l_terr_usg_id
3110: FROM DUAL;
3111:
3112: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3113: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3114: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3124: FROM DUAL;

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

Line 3138: FROM DUAL;

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

Line 3152: FROM DUAL;

3148: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
3149:
3150: SELECT JTF_TERR_QUAL_S.nextval
3151: into l_terr_qual_id
3152: FROM DUAL;
3153:
3154: j:=0;
3155: K:=0;
3156: l_prev_qual_usg_id:=1;

Line 3166: FROM DUAL;

3162:
3163: j:=j+1;
3164: SELECT JTF_TERR_QUAL_S.nextval
3165: into l_terr_qual_id
3166: FROM DUAL;
3167:
3168: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;
3169: l_terr_qual_tbl(j).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;
3170: l_terr_qual_tbl(j).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3297: FROM DUAL;

3293: l_terr_all_rec.NUM_WINNERS :=null ;
3294:
3295: SELECT JTF_TERR_USGS_S.nextval
3296: into l_terr_usg_id
3297: FROM DUAL;
3298:
3299: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3300: l_terr_usgs_tbl(1).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE;
3301: l_terr_usgs_tbl(1).LAST_UPDATED_BY:= terr_group.LAST_UPDATED_BY;

Line 3318: FROM DUAL;

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

Line 3332: FROM DUAL;

3328: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3329:
3330: SELECT JTF_TERR_QUAL_S.nextval
3331: into l_terr_qual_id
3332: FROM DUAL;
3333: /* opp expected purchase */
3334:
3335: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
3336: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3384: FROM DUAL;

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

Line 3398: FROM DUAL;

3394: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3395:
3396: SELECT JTF_TERR_QUAL_S.nextval
3397: into l_terr_qual_id
3398: FROM DUAL;
3399:
3400: /* lead expected purchase */
3401: l_terr_qual_tbl(i).TERR_QUAL_ID :=l_terr_qual_id;
3402: l_terr_qual_tbl(i).LAST_UPDATE_DATE:= terr_group.LAST_UPDATE_DATE ;

Line 3518: FROM DUAL;

3514: i:=i+1;
3515:
3516: SELECT JTF_TERR_RSC_S.nextval
3517: into l_terr_rsc_id
3518: FROM DUAL;
3519:
3520: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
3521: l_TerrRsc_Tbl(i).TERR_RSC_ID :=l_terr_rsc_id;
3522: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE:=terr_group.LAST_UPDATE_DATE;

Line 3553: FROM DUAL;

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

Line 3574: FROM DUAL;

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

Line 3593: FROM DUAL;

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