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 JTF_TERR_QTYPE_USGS_S

Line 1465: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

1461: /* ACCOUNT TRANSACTION TYPE */
1462:
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;

Line 1482: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

1478:
1479: /* LEAD TRANSACTION TYPE */
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;

Line 1499: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

1495:
1496: /* OPPORTUNITY TRANSACTION TYPE */
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;

Line 1847: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

1843: l_terr_usgs_tbl(1).TERR_ID := NULL;
1844: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 1861: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

1857: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
1858: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 2026: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

2022:
2023: IF acc_type.access_type= 'OPPORTUNITY' THEN
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;

Line 2097: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

2093:
2094: ELSIF acc_type.access_type= 'LEAD' THEN
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;

Line 2964: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

2960: l_terr_usgs_tbl(1).TERR_ID := NULL;
2961: l_terr_usgs_tbl(1).ORG_ID := p_ORG_ID(x);
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;

Line 2979: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

2975: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
2976: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_ORG_ID(x);
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;

Line 2994: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

2990: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
2991: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_ORG_ID(x);
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;

Line 3124: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3120: /* ACCOUNT TRANSACTION TYPE */
3121:
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;

Line 3141: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3137:
3138: /* LEAD TRANSACTION TYPE */
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;

Line 3158: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3154:
3155: /* OPPORTUNITY TRANSACTION TYPE */
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;

Line 3517: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3513: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
3514: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
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;

Line 3532: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3528: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
3529: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
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;

Line 3703: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3699: l_terr_usgs_tbl(1).TERR_ID := NULL;
3700: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 3717: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3713: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
3714: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 3882: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3878:
3879: IF acc_type.access_type= 'OPPORTUNITY' THEN
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;

Line 3953: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

3949:
3950: ELSIF acc_type.access_type= 'LEAD' THEN
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;

Line 4982: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

4978: LOOP
4979:
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

Line 5389: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

5385: ELSIF ( acctype.access_type = 'PROPOSAL' ) THEN
5386: l_qual_type_usg_id := -1106;
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;

Line 5763: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

5759: l_terr_usgs_tbl(1).TERR_ID := NULL;
5760: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 5777: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

5773: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
5774: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 5980: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

5976: --i:=i+1;
5977: --dbms_output.put_line('acc type '||acc_type.access_type);
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;

Line 6050: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

6046:
6047: ELSIF acc_type.access_type= 'LEAD' THEN
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;

Line 6361: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

6357: l_terr_usgs_tbl(1).TERR_ID := NULL;
6358: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 6375: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

6371: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
6372: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 6561: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

6557: --i:=i+1;
6558: --dbms_output.put_line('acc type '||acc_type.access_type);
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;

Line 6631: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

6627:
6628: ELSIF acc_type.access_type= 'LEAD' THEN
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;

Line 7656: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

7652: FOR actype IN na_access(p_terr_group_id(x))
7653: LOOP
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

Line 7817: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

7813: LOOP
7814:
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

Line 8213: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

8209: ELSIF ( acctype.access_type = 'PROPOSAL' ) THEN
8210: l_qual_type_usg_id := -1106;
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;

Line 8606: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

8602: ELSIF ( acctype.access_type='PROPOSAL' ) THEN
8603: l_qual_type_usg_id := -1106;
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;

Line 8968: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

8964: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
8965: l_terr_usgs_tbl(1).ORG_ID := p_org_id(x);
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;

Line 8983: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

8979: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
8980: l_terr_qualtypeusgs_tbl(1).ORG_ID := p_org_id(x);
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;

Line 9165: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9161: l_terr_usgs_tbl(1).TERR_ID := NULL;
9162: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 9179: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9175: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
9176: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 9378: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9374: --i:=i+1;
9375: --dbms_output.put_line('acc type '||acc_type.access_type);
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;

Line 9448: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9444:
9445: ELSIF acc_type.access_type= 'LEAD' THEN
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;

Line 9762: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9758: l_terr_usgs_tbl(1).TERR_ID := NULL;
9759: l_terr_usgs_tbl(1).SOURCE_ID := -1001;
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;

Line 9776: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9772: l_terr_qualtypeusgs_tbl(1).TERR_ID := NULL;
9773: l_terr_qualtypeusgs_tbl(1).QUAL_TYPE_USG_ID := -1002;
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;

Line 9962: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

9958: --i:=i+1;
9959: --dbms_output.put_line('acc type '||acc_type.access_type);
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;

Line 10032: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL

10028:
10029: ELSIF acc_type.access_type= 'LEAD' THEN
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;