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 DUAL

Line 1330: FROM DUAL;

1326: i :=i +1;
1327:
1328: SELECT JTF_TTY_TERR_GRP_ROLES_S.NEXTVAL
1329: INTO l_id
1330: FROM DUAL;
1331:
1332: l_overnon_role_tbl(i).grp_role_id:= l_id;
1333:
1334: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

Line 1441: FROM DUAL;

1437:
1438: /* Oracle Sales and Telesales Usage */
1439: SELECT JTF_TERR_USGS_S.NEXTVAL
1440: INTO l_terr_usg_id
1441: FROM DUAL;
1442:
1443: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1444: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1445: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1467: FROM DUAL;

1463: IF acctype.access_type='ACCOUNT' THEN
1464:
1465: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
1466: INTO l_terr_qtype_usg_id
1467: FROM DUAL;
1468:
1469: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1470: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1471: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1484: FROM DUAL;

1480: ELSIF acctype.access_type='LEAD' THEN
1481:
1482: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
1483: INTO l_terr_qtype_usg_id
1484: FROM DUAL;
1485:
1486: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1487: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1488: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1501: FROM DUAL;

1497: ELSIF acctype.access_type='OPPORTUNITY' THEN
1498:
1499: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
1500: INTO l_terr_qtype_usg_id
1501: FROM DUAL;
1502:
1503: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1504: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1505: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1534: FROM DUAL;

1530: j:=j+1;
1531:
1532: SELECT JTF_TERR_QUAL_S.NEXTVAL
1533: INTO l_terr_qual_id
1534: FROM DUAL;
1535:
1536: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
1537: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1538: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1627: FROM DUAL;

1623: i := i+1;
1624:
1625: SELECT JTF_TERR_RSC_S.NEXTVAL
1626: INTO l_terr_rsc_id
1627: FROM DUAL;
1628:
1629: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
1630: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
1631: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 1654: FROM DUAL;

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;
1657: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
1658: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 1672: FROM DUAL;

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;
1675: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
1676: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 1690: FROM DUAL;

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;
1693: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
1694: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 1835: FROM DUAL;

1831:
1832:
1833: SELECT JTF_TERR_USGS_S.NEXTVAL
1834: INTO l_terr_usg_id
1835: FROM DUAL;
1836:
1837: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
1838: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1839: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1849: FROM DUAL;

1845: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
1846:
1847: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
1848: INTO l_terr_qtype_usg_id
1849: FROM DUAL;
1850:
1851: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1852: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1853: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1863: FROM DUAL;

1859: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
1860:
1861: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
1862: INTO l_terr_qtype_usg_id
1863: FROM DUAL;
1864:
1865: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
1866: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1867: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 1877: FROM DUAL;

1873: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
1874:
1875: SELECT JTF_TERR_QUAL_S.NEXTVAL
1876: INTO l_terr_qual_id
1877: FROM DUAL;
1878:
1879: j:=0;
1880: K:=0;
1881: l_prev_qual_usg_id:=1;

Line 1890: FROM DUAL;

1886:
1887: j:=j+1;
1888: SELECT JTF_TERR_QUAL_S.NEXTVAL
1889: INTO l_terr_qual_id
1890: FROM DUAL;
1891:
1892: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
1893: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
1894: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 2006: FROM DUAL;

2002: l_terr_all_rec.NUM_WINNERS := NULL ;
2003:
2004: SELECT JTF_TERR_USGS_S.NEXTVAL
2005: INTO l_terr_usg_id
2006: FROM DUAL;
2007:
2008: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2009: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
2010: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 2028: FROM DUAL;

2024: i:=i+1;
2025:
2026: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
2027: INTO l_terr_qtype_usg_id
2028: FROM DUAL;
2029:
2030: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
2031: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
2032: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 2042: FROM DUAL;

2038: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
2039:
2040: SELECT JTF_TERR_QUAL_S.NEXTVAL
2041: INTO l_terr_qual_id
2042: FROM DUAL;
2043:
2044: /* opp expected purchase */
2045:
2046: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;

Line 2099: FROM DUAL;

2095:
2096: i:=i+1;
2097: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
2098: INTO l_terr_qtype_usg_id
2099: FROM DUAL;
2100:
2101: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
2102: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
2103: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 2113: FROM DUAL;

2109: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
2110:
2111: SELECT JTF_TERR_QUAL_S.NEXTVAL
2112: INTO l_terr_qual_id
2113: FROM DUAL;
2114:
2115: /* lead expected purchase */
2116: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
2117: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 2226: FROM DUAL;

2222: i:=i+1;
2223:
2224: SELECT JTF_TERR_RSC_S.NEXTVAL
2225: INTO l_terr_rsc_id
2226: FROM DUAL;
2227:
2228: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
2229: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
2230: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 2255: FROM DUAL;

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;
2258: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
2259: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 2274: FROM DUAL;

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;
2277: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
2278: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 2845: FROM DUAL;

2841: i :=i +1;
2842:
2843: SELECT JTF_TTY_TERR_GRP_ROLES_S.NEXTVAL
2844: INTO l_id
2845: FROM DUAL;
2846:
2847: l_overnon_role_tbl(i).grp_role_id:= l_id;
2848:
2849: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

Line 2951: FROM DUAL;

2947:
2948: /* ORACLE SALES AND TELESALES USAGE */
2949: SELECT JTF_TERR_USGS_S.NEXTVAL
2950: INTO l_terr_usg_id
2951: FROM DUAL;
2952:
2953: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
2954: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
2955: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 2966: FROM DUAL;

2962:
2963: /* ACCOUNT TRANSACTION TYPE */
2964: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
2965: INTO l_terr_qtype_usg_id
2966: FROM DUAL;
2967:
2968: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1001;
2969: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
2970: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 2981: FROM DUAL;

2977:
2978: /* LEAD TRANSACTION TYPE */
2979: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
2980: INTO l_terr_qtype_usg_id
2981: FROM DUAL;
2982:
2983: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1002;
2984: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
2985: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 2996: FROM DUAL;

2992:
2993: /* OPPORTUNITY TRANSACTION TYPE */
2994: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
2995: INTO l_terr_qtype_usg_id
2996: FROM DUAL;
2997:
2998: l_terr_qualtypeusgs_tbl(3).QUAL_TYPE_USG_ID := -1003;
2999: l_terr_qualtypeusgs_tbl(3).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3000: l_terr_qualtypeusgs_tbl(3).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 3100: FROM DUAL;

3096: /* Oracle Sales and Telesales Usage */
3097:
3098: SELECT JTF_TERR_USGS_S.NEXTVAL
3099: INTO l_terr_usg_id
3100: FROM DUAL;
3101:
3102: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3103: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3104: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3126: FROM DUAL;

3122: IF acctype.access_type='ACCOUNT' THEN
3123:
3124: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3125: INTO l_terr_qtype_usg_id
3126: FROM DUAL;
3127:
3128: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3129: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3130: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3143: FROM DUAL;

3139: ELSIF acctype.access_type='LEAD' THEN
3140:
3141: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3142: INTO l_terr_qtype_usg_id
3143: FROM DUAL;
3144:
3145: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3146: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3147: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3160: FROM DUAL;

3156: ELSIF acctype.access_type='OPPORTUNITY' THEN
3157:
3158: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3159: INTO l_terr_qtype_usg_id
3160: FROM DUAL;
3161:
3162: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3163: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3164: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3193: FROM DUAL;

3189: j:=j+1;
3190:
3191: SELECT JTF_TERR_QUAL_S.NEXTVAL
3192: INTO l_terr_qual_id
3193: FROM DUAL;
3194:
3195: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
3196: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3197: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3289: FROM DUAL;

3285: i := i+1;
3286:
3287: SELECT JTF_TERR_RSC_S.NEXTVAL
3288: INTO l_terr_rsc_id
3289: FROM DUAL;
3290:
3291: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
3292: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
3293: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 3316: FROM DUAL;

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;
3319: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
3320: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 3334: FROM DUAL;

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;
3337: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
3338: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 3352: FROM DUAL;

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;
3355: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
3356: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 3504: FROM DUAL;

3500: /* ORACLE SALES AND TELESALES USAGE */
3501:
3502: SELECT JTF_TERR_USGS_S.NEXTVAL
3503: INTO l_terr_usg_id
3504: FROM DUAL;
3505:
3506: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3507: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3508: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3519: FROM DUAL;

3515:
3516: /* LEAD TRANSACTION TYPE */
3517: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3518: INTO l_terr_qtype_usg_id
3519: FROM DUAL;
3520:
3521: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3522: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3523: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3534: FROM DUAL;

3530:
3531: /* OPPORTUNITY TRANSACTION TYPE */
3532: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3533: INTO l_terr_qtype_usg_id
3534: FROM DUAL;
3535:
3536: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3537: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3538: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3562: FROM DUAL;

3558: j:=j+1;
3559:
3560: SELECT JTF_TERR_QUAL_S.NEXTVAL
3561: INTO l_terr_qual_id
3562: FROM DUAL;
3563:
3564: /* Top_level Parent's Qualifier */
3565: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
3566: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 3691: FROM DUAL;

3687:
3688:
3689: SELECT JTF_TERR_USGS_S.NEXTVAL
3690: INTO l_terr_usg_id
3691: FROM DUAL;
3692:
3693: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3694: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3695: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3705: FROM DUAL;

3701: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
3702:
3703: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3704: INTO l_terr_qtype_usg_id
3705: FROM DUAL;
3706:
3707: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3708: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3709: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3719: FROM DUAL;

3715: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
3716:
3717: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3718: INTO l_terr_qtype_usg_id
3719: FROM DUAL;
3720:
3721: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3722: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3723: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3733: FROM DUAL;

3729: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
3730:
3731: SELECT JTF_TERR_QUAL_S.NEXTVAL
3732: INTO l_terr_qual_id
3733: FROM DUAL;
3734:
3735: j:=0;
3736: K:=0;
3737: l_prev_qual_usg_id:=1;

Line 3746: FROM DUAL;

3742:
3743: j:=j+1;
3744: SELECT JTF_TERR_QUAL_S.NEXTVAL
3745: INTO l_terr_qual_id
3746: FROM DUAL;
3747:
3748: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
3749: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3750: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3862: FROM DUAL;

3858: l_terr_all_rec.NUM_WINNERS := NULL ;
3859:
3860: SELECT JTF_TERR_USGS_S.NEXTVAL
3861: INTO l_terr_usg_id
3862: FROM DUAL;
3863:
3864: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
3865: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3866: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3884: FROM DUAL;

3880: i:=i+1;
3881:
3882: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3883: INTO l_terr_qtype_usg_id
3884: FROM DUAL;
3885:
3886: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3887: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3888: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3898: FROM DUAL;

3894: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
3895:
3896: SELECT JTF_TERR_QUAL_S.NEXTVAL
3897: INTO l_terr_qual_id
3898: FROM DUAL;
3899:
3900: /* opp expected purchase */
3901:
3902: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;

Line 3955: FROM DUAL;

3951:
3952: i:=i+1;
3953: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
3954: INTO l_terr_qtype_usg_id
3955: FROM DUAL;
3956:
3957: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
3958: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);
3959: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(x);

Line 3969: FROM DUAL;

3965: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
3966:
3967: SELECT JTF_TERR_QUAL_S.NEXTVAL
3968: INTO l_terr_qual_id
3969: FROM DUAL;
3970:
3971: /* lead expected purchase */
3972: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
3973: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(x);

Line 4082: FROM DUAL;

4078: i:=i+1;
4079:
4080: SELECT JTF_TERR_RSC_S.NEXTVAL
4081: INTO l_terr_rsc_id
4082: FROM DUAL;
4083:
4084: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
4085: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
4086: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 4111: FROM DUAL;

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;
4114: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
4115: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 4130: FROM DUAL;

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;
4133: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
4134: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 4703: FROM DUAL;

4699: i := i + 1;
4700:
4701: SELECT JTF_TTY_TERR_GRP_ROLES_S.NEXTVAL
4702: INTO l_id
4703: FROM DUAL;
4704:
4705: l_overnon_role_tbl(i).grp_role_id:= l_id;
4706:
4707: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

Line 4962: FROM DUAL;

4958:
4959: /* Oracle Sales and Telesales Usage */
4960: SELECT JTF_TERR_USGS_S.NEXTVAL
4961: INTO l_terr_usg_id
4962: FROM DUAL;
4963:
4964: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
4965: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
4966: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 4984: FROM DUAL;

4980: i:=i+1;
4981:
4982: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
4983: INTO l_terr_qtype_usg_id
4984: FROM DUAL;
4985:
4986: IF ( acctype.access_type = 'ACCOUNT' ) THEN
4987: l_qual_type_usg_id := -1001;
4988: ELSIF ( acctype.access_type = 'LEAD' ) THEN

Line 5029: FROM DUAL;

5025: j:=j+1;
5026:
5027: SELECT JTF_TERR_QUAL_S.NEXTVAL
5028: INTO l_terr_qual_id
5029: FROM DUAL;
5030:
5031: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
5032: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
5033: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5139: FROM DUAL;

5135: i:=i+1;
5136:
5137: SELECT JTF_TERR_RSC_S.NEXTVAL
5138: INTO l_terr_rsc_id
5139: FROM DUAL;
5140:
5141: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
5142: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
5143: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 5199: FROM DUAL;

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;
5202: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
5203: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5357: FROM DUAL;

5353:
5354: /* Oracle Sales and Telesales Usage */
5355: SELECT JTF_TERR_USGS_S.NEXTVAL
5356: INTO l_terr_usg_id
5357: FROM DUAL;
5358:
5359: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
5360: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
5361: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5391: FROM DUAL;

5387: END IF;
5388:
5389: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
5390: INTO l_terr_qtype_usg_id
5391: FROM DUAL;
5392:
5393: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
5394: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
5395: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5422: FROM DUAL;

5418: j:=j+1;
5419:
5420: SELECT JTF_TERR_QUAL_S.NEXTVAL
5421: INTO l_terr_qual_id
5422: FROM DUAL;
5423:
5424: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
5425: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
5426: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5520: FROM DUAL;

5516: i:=i+1;
5517:
5518: SELECT JTF_TERR_RSC_S.NEXTVAL
5519: INTO l_terr_rsc_id
5520: FROM DUAL;
5521:
5522: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
5523: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
5524: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 5578: FROM DUAL;

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;
5581: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
5582: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5751: FROM DUAL;

5747: l_terr_all_rec.NUM_WINNERS := NULL ;
5748:
5749: SELECT JTF_TERR_USGS_S.NEXTVAL
5750: INTO l_terr_usg_id
5751: FROM DUAL;
5752:
5753: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
5754: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
5755: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5765: FROM DUAL;

5761: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
5762:
5763: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
5764: INTO l_terr_qtype_usg_id
5765: FROM DUAL;
5766:
5767: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
5768: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
5769: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5779: FROM DUAL;

5775: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
5776:
5777: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
5778: INTO l_terr_qtype_usg_id
5779: FROM DUAL;
5780:
5781: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
5782: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_last_update_date(x);
5783: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5793: FROM DUAL;

5789: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
5790:
5791: SELECT JTF_TERR_QUAL_S.NEXTVAL
5792: INTO l_terr_qual_id
5793: FROM DUAL;
5794:
5795: j:=0;
5796: K:=0;
5797: l_prev_qual_usg_id:=1;

Line 5807: FROM DUAL;

5803: j:=j+1;
5804:
5805: SELECT JTF_TERR_QUAL_S.NEXTVAL
5806: INTO l_terr_qual_id
5807: FROM DUAL;
5808:
5809: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
5810: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
5811: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5961: FROM DUAL;

5957: l_terr_all_rec.attribute15 := p_terr_attribute15(x);
5958:
5959: SELECT JTF_TERR_USGS_S.NEXTVAL
5960: INTO l_terr_usg_id
5961: FROM DUAL;
5962:
5963: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
5964: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
5965: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5982: FROM DUAL;

5978: IF acc_type.access_type= 'OPPORTUNITY' THEN
5979: i:=i+1;
5980: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
5981: INTO l_terr_qtype_usg_id
5982: FROM DUAL;
5983:
5984: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
5985: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
5986: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 5996: FROM DUAL;

5992: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
5993:
5994: SELECT JTF_TERR_QUAL_S.NEXTVAL
5995: INTO l_terr_qual_id
5996: FROM DUAL;
5997:
5998: /* opp expected purchase */
5999: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
6000: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6052: FROM DUAL;

6048:
6049: i:=i+1;
6050: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
6051: INTO l_terr_qtype_usg_id
6052: FROM DUAL;
6053:
6054: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
6055: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
6056: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6066: FROM DUAL;

6062: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6063:
6064: SELECT JTF_TERR_QUAL_S.NEXTVAL
6065: INTO l_terr_qual_id
6066: FROM DUAL;
6067:
6068: /* lead expected purchase */
6069: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
6070: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6184: FROM DUAL;

6180: i:=i+1;
6181:
6182: SELECT JTF_TERR_RSC_S.NEXTVAL
6183: INTO l_terr_rsc_id
6184: FROM DUAL;
6185:
6186: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
6187: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
6188: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6229: FROM DUAL;

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;
6232: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
6233: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6247: FROM DUAL;

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;
6250: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
6251: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6349: FROM DUAL;

6345:
6346:
6347: SELECT JTF_TERR_USGS_S.NEXTVAL
6348: INTO l_terr_usg_id
6349: FROM DUAL;
6350:
6351: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
6352: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
6353: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6363: FROM DUAL;

6359: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
6360:
6361: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
6362: INTO l_terr_qtype_usg_id
6363: FROM DUAL;
6364:
6365: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
6366: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
6367: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6377: FROM DUAL;

6373: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
6374:
6375: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
6376: INTO l_terr_qtype_usg_id
6377: FROM DUAL;
6378:
6379: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
6380: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_last_update_date(x);
6381: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6391: FROM DUAL;

6387: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
6388:
6389: SELECT JTF_TERR_QUAL_S.NEXTVAL
6390: INTO l_terr_qual_id
6391: FROM DUAL;
6392:
6393: j:=0;
6394: K:=0;
6395: l_prev_qual_usg_id:=1;

Line 6404: FROM DUAL;

6400:
6401: j:=j+1;
6402: SELECT JTF_TERR_QUAL_S.NEXTVAL
6403: INTO l_terr_qual_id
6404: FROM DUAL;
6405:
6406: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
6407: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
6408: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6542: FROM DUAL;

6538: l_terr_all_rec.attribute15 := p_terr_attribute15(x);
6539:
6540: SELECT JTF_TERR_USGS_S.NEXTVAL
6541: INTO l_terr_usg_id
6542: FROM DUAL;
6543:
6544: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
6545: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
6546: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6563: FROM DUAL;

6559: IF acc_type.access_type= 'OPPORTUNITY' THEN
6560: i:=i+1;
6561: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
6562: INTO l_terr_qtype_usg_id
6563: FROM DUAL;
6564:
6565: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
6566: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
6567: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6577: FROM DUAL;

6573: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6574:
6575: SELECT JTF_TERR_QUAL_S.NEXTVAL
6576: INTO l_terr_qual_id
6577: FROM DUAL;
6578:
6579: /* opp expected purchase */
6580: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
6581: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6633: FROM DUAL;

6629:
6630: i:=i+1;
6631: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
6632: INTO l_terr_qtype_usg_id
6633: FROM DUAL;
6634:
6635: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
6636: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
6637: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6647: FROM DUAL;

6643: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6644:
6645: SELECT JTF_TERR_QUAL_S.NEXTVAL
6646: INTO l_terr_qual_id
6647: FROM DUAL;
6648:
6649: /* lead expected purchase */
6650: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
6651: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6765: FROM DUAL;

6761: i:=i+1;
6762:
6763: SELECT JTF_TERR_RSC_S.NEXTVAL
6764: INTO l_terr_rsc_id
6765: FROM DUAL;
6766:
6767: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
6768: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
6769: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 6810: FROM DUAL;

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;
6813: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
6814: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 6829: FROM DUAL;

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;
6832: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
6833: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 7518: FROM DUAL;

7514: i := i + 1;
7515:
7516: SELECT JTF_TTY_TERR_GRP_ROLES_S.NEXTVAL
7517: INTO l_id
7518: FROM DUAL;
7519:
7520: l_overnon_role_tbl(i).grp_role_id:= l_id;
7521:
7522: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

Line 7639: FROM DUAL;

7635:
7636: /* ORACLE SALES AND TELESALES USAGE */
7637: SELECT JTF_TERR_USGS_S.NEXTVAL
7638: INTO l_terr_usg_id
7639: FROM DUAL;
7640:
7641: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
7642: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
7643: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);

Line 7658: FROM DUAL;

7654: i := i+1;
7655:
7656: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
7657: INTO l_terr_qtype_usg_id
7658: FROM DUAL;
7659:
7660: IF ( actype.access_type = 'ACCOUNT' ) THEN
7661: l_qual_type_usg_id := -1001;
7662: ELSIF ( actype.access_type = 'LEAD' ) THEN

Line 7799: FROM DUAL;

7795:
7796: /* Oracle Sales and Telesales Usage */
7797: SELECT JTF_TERR_USGS_S.NEXTVAL
7798: INTO l_terr_usg_id
7799: FROM DUAL;
7800:
7801: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
7802: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
7803: l_terr_usgs_tbl(1).LAST_UPDATED_BY := G_USER_ID;

Line 7819: FROM DUAL;

7815: i:=i+1;
7816:
7817: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
7818: INTO l_terr_qtype_usg_id
7819: FROM DUAL;
7820:
7821: IF ( actype.access_type = 'ACCOUNT' ) THEN
7822: l_qual_type_usg_id := -1001;
7823: ELSIF ( actype.access_type = 'LEAD' ) THEN

Line 7849: FROM DUAL;

7845: /*
7846: ** Customer Name Range Qualifier -1012 */
7847: SELECT JTF_TERR_QUAL_S.NEXTVAL
7848: INTO l_terr_qual_id
7849: FROM DUAL;
7850:
7851: l_terr_qual_tbl(1).TERR_QUAL_ID := l_terr_qual_id;
7852: l_terr_qual_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
7853: l_terr_qual_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 7943: FROM DUAL;

7939: procedure call in UI : JTF_TTY_GEN_TERR_PVT.create_catchall_terr_rsc.
7940:
7941: SELECT JTF_TERR_RSC_S.NEXTVAL
7942: INTO l_terr_rsc_id
7943: FROM DUAL;
7944:
7945: l_TerrRsc_Tbl(1).terr_id := x_terr_id;
7946: l_TerrRsc_Tbl(1).TERR_RSC_ID := l_terr_rsc_id;
7947: l_TerrRsc_Tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);

Line 7971: FROM DUAL;

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;
7974: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
7975: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 7988: FROM DUAL;

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;
7991: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
7992: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8005: FROM DUAL;

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;
8008: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
8009: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8181: FROM DUAL;

8177:
8178: /* Oracle Sales and Telesales Usage */
8179: SELECT JTF_TERR_USGS_S.NEXTVAL
8180: INTO l_terr_usg_id
8181: FROM DUAL;
8182:
8183: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
8184: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
8185: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8215: FROM DUAL;

8211: END IF;
8212:
8213: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
8214: INTO l_terr_qtype_usg_id
8215: FROM DUAL;
8216:
8217: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
8218: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
8219: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8247: FROM DUAL;

8243: j:=j+1;
8244:
8245: SELECT JTF_TERR_QUAL_S.NEXTVAL
8246: INTO l_terr_qual_id
8247: FROM DUAL;
8248:
8249: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
8250: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
8251: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8358: FROM DUAL;

8354: i:=i+1;
8355:
8356: SELECT JTF_TERR_RSC_S.NEXTVAL
8357: INTO l_terr_rsc_id
8358: FROM DUAL;
8359:
8360: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
8361: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
8362: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 8417: FROM DUAL;

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;
8420: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
8421: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8574: FROM DUAL;

8570:
8571: /* Oracle Sales and Telesales Usage */
8572: SELECT JTF_TERR_USGS_S.NEXTVAL
8573: INTO l_terr_usg_id
8574: FROM DUAL;
8575:
8576: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
8577: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
8578: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8608: FROM DUAL;

8604: END IF;
8605:
8606: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
8607: INTO l_terr_qtype_usg_id
8608: FROM DUAL;
8609:
8610: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
8611: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
8612: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8639: FROM DUAL;

8635: j:=j+1;
8636:
8637: SELECT JTF_TERR_QUAL_S.NEXTVAL
8638: INTO l_terr_qual_id
8639: FROM DUAL;
8640:
8641: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
8642: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
8643: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8736: FROM DUAL;

8732: i:=i+1;
8733:
8734: SELECT JTF_TERR_RSC_S.NEXTVAL
8735: INTO l_terr_rsc_id
8736: FROM DUAL;
8737:
8738: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
8739: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
8740: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 8794: FROM DUAL;

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;
8797: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
8798: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8955: FROM DUAL;

8951:
8952: /* ORACLE SALES AND TELESALES USAGE */
8953: SELECT JTF_TERR_USGS_S.NEXTVAL
8954: INTO l_terr_usg_id
8955: FROM DUAL;
8956:
8957: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
8958: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
8959: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8970: FROM DUAL;

8966:
8967: /* LEAD TRANSACTION TYPE */
8968: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
8969: INTO l_terr_qtype_usg_id
8970: FROM DUAL;
8971:
8972: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
8973: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
8974: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 8985: FROM DUAL;

8981:
8982: /* OPPORTUNITY TRANSACTION TYPE */
8983: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
8984: INTO l_terr_qtype_usg_id
8985: FROM DUAL;
8986:
8987: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
8988: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_last_update_date(x);
8989: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9010: FROM DUAL;

9006: j:=j+1;
9007:
9008: SELECT JTF_TERR_QUAL_S.NEXTVAL
9009: INTO l_terr_qual_id
9010: FROM DUAL;
9011:
9012: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
9013: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
9014: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9153: FROM DUAL;

9149: l_terr_all_rec.NUM_WINNERS := NULL ;
9150:
9151: SELECT JTF_TERR_USGS_S.NEXTVAL
9152: INTO l_terr_usg_id
9153: FROM DUAL;
9154:
9155: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
9156: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9157: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9167: FROM DUAL;

9163: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
9164:
9165: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9166: INTO l_terr_qtype_usg_id
9167: FROM DUAL;
9168:
9169: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9170: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9171: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9181: FROM DUAL;

9177: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
9178:
9179: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9180: INTO l_terr_qtype_usg_id
9181: FROM DUAL;
9182:
9183: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9184: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_last_update_date(x);
9185: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9195: FROM DUAL;

9191: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
9192:
9193: SELECT JTF_TERR_QUAL_S.NEXTVAL
9194: INTO l_terr_qual_id
9195: FROM DUAL;
9196:
9197: j:=0;
9198: K:=0;
9199: l_prev_qual_usg_id:=1;

Line 9209: FROM DUAL;

9205: j:=j+1;
9206:
9207: SELECT JTF_TERR_QUAL_S.NEXTVAL
9208: INTO l_terr_qual_id
9209: FROM DUAL;
9210:
9211: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
9212: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
9213: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9359: FROM DUAL;

9355: l_terr_all_rec.attribute15 := overlayterr.attribute15;
9356:
9357: SELECT JTF_TERR_USGS_S.NEXTVAL
9358: INTO l_terr_usg_id
9359: FROM DUAL;
9360:
9361: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
9362: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9363: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9380: FROM DUAL;

9376: IF acc_type.access_type= 'OPPORTUNITY' THEN
9377: i:=i+1;
9378: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9379: INTO l_terr_qtype_usg_id
9380: FROM DUAL;
9381:
9382: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9383: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
9384: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9394: FROM DUAL;

9390: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9391:
9392: SELECT JTF_TERR_QUAL_S.NEXTVAL
9393: INTO l_terr_qual_id
9394: FROM DUAL;
9395:
9396: /* opp expected purchase */
9397: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
9398: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 9450: FROM DUAL;

9446:
9447: i:=i+1;
9448: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9449: INTO l_terr_qtype_usg_id
9450: FROM DUAL;
9451:
9452: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9453: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
9454: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9464: FROM DUAL;

9460: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9461:
9462: SELECT JTF_TERR_QUAL_S.NEXTVAL
9463: INTO l_terr_qual_id
9464: FROM DUAL;
9465:
9466: /* lead expected purchase */
9467: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
9468: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 9583: FROM DUAL;

9579: i:=i+1;
9580:
9581: SELECT JTF_TERR_RSC_S.NEXTVAL
9582: INTO l_terr_rsc_id
9583: FROM DUAL;
9584:
9585: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
9586: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
9587: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 9628: FROM DUAL;

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;
9631: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
9632: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9646: FROM DUAL;

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;
9649: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
9650: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9750: FROM DUAL;

9746:
9747:
9748: SELECT JTF_TERR_USGS_S.NEXTVAL
9749: INTO l_terr_usg_id
9750: FROM DUAL;
9751:
9752: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
9753: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9754: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9764: FROM DUAL;

9760: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
9761:
9762: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9763: INTO l_terr_qtype_usg_id
9764: FROM DUAL;
9765:
9766: l_terr_qualtypeusgs_tbl(1).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9767: l_terr_qualtypeusgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9768: l_terr_qualtypeusgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9778: FROM DUAL;

9774: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
9775:
9776: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9777: INTO l_terr_qtype_usg_id
9778: FROM DUAL;
9779:
9780: l_terr_qualtypeusgs_tbl(2).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9781: l_terr_qualtypeusgs_tbl(2).LAST_UPDATE_DATE := p_last_update_date(x);
9782: l_terr_qualtypeusgs_tbl(2).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9792: FROM DUAL;

9788: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
9789:
9790: SELECT JTF_TERR_QUAL_S.NEXTVAL
9791: INTO l_terr_qual_id
9792: FROM DUAL;
9793:
9794: j:=0;
9795: K:=0;
9796: l_prev_qual_usg_id:=1;

Line 9805: FROM DUAL;

9801:
9802: j:=j+1;
9803: SELECT JTF_TERR_QUAL_S.NEXTVAL
9804: INTO l_terr_qual_id
9805: FROM DUAL;
9806:
9807: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;
9808: l_terr_qual_tbl(j).LAST_UPDATE_DATE := p_last_update_date(x);
9809: l_terr_qual_tbl(j).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9943: FROM DUAL;

9939: l_terr_all_rec.attribute15 := overlayterr.attribute15;
9940:
9941: SELECT JTF_TERR_USGS_S.NEXTVAL
9942: INTO l_terr_usg_id
9943: FROM DUAL;
9944:
9945: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;
9946: l_terr_usgs_tbl(1).LAST_UPDATE_DATE := p_last_update_date(x);
9947: l_terr_usgs_tbl(1).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9964: FROM DUAL;

9960: IF acc_type.access_type= 'OPPORTUNITY' THEN
9961: i:=i+1;
9962: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
9963: INTO l_terr_qtype_usg_id
9964: FROM DUAL;
9965:
9966: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
9967: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
9968: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 9978: FROM DUAL;

9974: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9975:
9976: SELECT JTF_TERR_QUAL_S.NEXTVAL
9977: INTO l_terr_qual_id
9978: FROM DUAL;
9979:
9980: /* opp expected purchase */
9981: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
9982: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 10034: FROM DUAL;

10030:
10031: i:=i+1;
10032: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
10033: INTO l_terr_qtype_usg_id
10034: FROM DUAL;
10035:
10036: l_terr_qualtypeusgs_tbl(i).TERR_QUAL_TYPE_USG_ID := l_terr_qtype_usg_id;
10037: l_terr_qualtypeusgs_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);
10038: l_terr_qualtypeusgs_tbl(i).LAST_UPDATED_BY := p_last_updated_by(x);

Line 10048: FROM DUAL;

10044: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
10045:
10046: SELECT JTF_TERR_QUAL_S.NEXTVAL
10047: INTO l_terr_qual_id
10048: FROM DUAL;
10049:
10050: /* lead expected purchase */
10051: l_terr_qual_tbl(i).TERR_QUAL_ID := l_terr_qual_id;
10052: l_terr_qual_tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 10166: FROM DUAL;

10162: i:=i+1;
10163:
10164: SELECT JTF_TERR_RSC_S.NEXTVAL
10165: INTO l_terr_rsc_id
10166: FROM DUAL;
10167:
10168: l_TerrRsc_Tbl(i).terr_id := x_terr_id;
10169: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
10170: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := p_last_update_date(x);

Line 10211: FROM DUAL;

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;
10214: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
10215: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 10230: FROM DUAL;

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;
10233: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := p_last_update_date(x);
10234: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := p_last_updated_by(x);

Line 12696: FROM DUAL;

12692: l_terr_rsc_id := 0;
12693: l_terr_rsc_access_id := 0;
12694: SELECT jtf_terr_rsc_s.NEXTVAL
12695: INTO l_terr_rsc_id
12696: FROM DUAL;
12697:
12698: SELECT terr_id INTO l_catchall_terr_id
12699: FROM JTF_TERR_ALL
12700: WHERE CATCH_ALL_FLAG='Y'

Line 12748: FROM DUAL;

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
12751: ( TERR_RSC_ACCESS_ID,
12752: LAST_UPDATE_DATE,

Line 12966: FROM DUAL;

12962: i:=i+1;
12963:
12964: SELECT JTF_TERR_RSC_S.NEXTVAL
12965: INTO l_terr_rsc_id
12966: FROM DUAL;
12967:
12968: l_TerrRsc_Tbl(i).terr_id := l_terr_id;
12969: l_TerrRsc_Tbl(i).TERR_RSC_ID := l_terr_rsc_id;
12970: l_TerrRsc_Tbl(i).LAST_UPDATE_DATE := sysdate;

Line 13033: FROM DUAL;

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;
13036: l_TerrRsc_Access_Tbl(a).LAST_UPDATE_DATE := sysdate;
13037: l_TerrRsc_Access_Tbl(a).LAST_UPDATED_BY := l_user_id;