APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_QUAL_S

Line 1211: SELECT JTF_TERR_QUAL_S.nextval

1207:
1208:
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;

Line 1594: SELECT JTF_TERR_QUAL_S.nextval

1590: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
1591:
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;

Line 1988: SELECT JTF_TERR_QUAL_S.nextval

1984: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
1985:
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;

Line 2379: SELECT JTF_TERR_QUAL_S.nextval

2375: FOR csr_qual IN csr_get_qual ( topt.terr_id ) LOOP
2376:
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;

Line 2567: SELECT JTF_TERR_QUAL_S.nextval

2563: l_terr_qualtypeusgs_tbl(2).TERR_ID:= null;
2564: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID:=-1003;
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;

Line 2581: SELECT JTF_TERR_QUAL_S.nextval

2577:
2578: if l_prev_qual_usg_id <> qval.qual_usg_id then
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;

Line 2751: SELECT JTF_TERR_QUAL_S.nextval

2747: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
2748: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1003;
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:

Line 2817: SELECT JTF_TERR_QUAL_S.nextval

2813: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
2814: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1002;
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 */

Line 3150: SELECT JTF_TERR_QUAL_S.nextval

3146: l_terr_qualtypeusgs_tbl(2).TERR_ID:= null;
3147: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID:=-1003;
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;

Line 3164: SELECT JTF_TERR_QUAL_S.nextval

3160:
3161: if l_prev_qual_usg_id <> qval.qual_usg_id then
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;

Line 3330: SELECT JTF_TERR_QUAL_S.nextval

3326: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
3327: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1003;
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:

Line 3396: SELECT JTF_TERR_QUAL_S.nextval

3392: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
3393: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1002;
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 */