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_USGS_S

Line 1439: SELECT JTF_TERR_USGS_S.NEXTVAL

1435: l_terr_all_rec.ORG_ID := p_org_id(x);
1436: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 1833: SELECT JTF_TERR_USGS_S.NEXTVAL

1829: l_terr_all_rec.ORG_ID := p_ORG_ID(x);
1830: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 2004: SELECT JTF_TERR_USGS_S.NEXTVAL

2000: l_terr_all_rec.AUTO_ASSIGN_RESOURCES_FLAG := NULL;
2001: l_terr_all_rec.ORG_ID := p_ORG_ID(x);
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;

Line 2949: SELECT JTF_TERR_USGS_S.NEXTVAL

2945: l_terr_all_rec.ORG_ID := p_ORG_ID(x);
2946:
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;

Line 3098: SELECT JTF_TERR_USGS_S.NEXTVAL

3094: l_terr_all_rec.NUM_WINNERS := NULL ;
3095:
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;

Line 3502: SELECT JTF_TERR_USGS_S.NEXTVAL

3498: l_terr_all_rec.NUM_WINNERS := l_pi_count ;
3499:
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;

Line 3689: SELECT JTF_TERR_USGS_S.NEXTVAL

3685: l_terr_all_rec.ORG_ID := p_ORG_ID(x);
3686: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 3860: SELECT JTF_TERR_USGS_S.NEXTVAL

3856: l_terr_all_rec.AUTO_ASSIGN_RESOURCES_FLAG := NULL;
3857: l_terr_all_rec.ORG_ID := p_ORG_ID(x);
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;

Line 4960: SELECT JTF_TERR_USGS_S.NEXTVAL

4956: l_terr_all_rec.attribute14 := p_terr_attribute14(x);
4957: l_terr_all_rec.attribute15 := p_terr_attribute15(x);
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;

Line 5355: SELECT JTF_TERR_USGS_S.NEXTVAL

5351: l_terr_all_rec.attribute14 := p_terr_attribute14(x);
5352: l_terr_all_rec.attribute15 := p_terr_attribute15(x);
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;

Line 5749: SELECT JTF_TERR_USGS_S.NEXTVAL

5745: l_terr_all_rec.AUTO_ASSIGN_RESOURCES_FLAG := NULL;
5746: l_terr_all_rec.ORG_ID := p_org_id(x);
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;

Line 5959: SELECT JTF_TERR_USGS_S.NEXTVAL

5955: l_terr_all_rec.attribute13 := p_terr_attribute13(x);
5956: l_terr_all_rec.attribute14 := p_terr_attribute14(x);
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;

Line 6347: SELECT JTF_TERR_USGS_S.NEXTVAL

6343: l_terr_all_rec.ORG_ID := p_org_id(x);
6344: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 6540: SELECT JTF_TERR_USGS_S.NEXTVAL

6536: l_terr_all_rec.attribute13 := p_terr_attribute13(x);
6537: l_terr_all_rec.attribute14 := p_terr_attribute14(x);
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;

Line 7637: SELECT JTF_TERR_USGS_S.NEXTVAL

7633: /* ORG_ID IS SET TO SAME VALUE AS TERRITORY GROUP's Top-Level Parent Territory */
7634: l_terr_all_rec.ORG_ID := p_org_id(x);
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;

Line 7797: SELECT JTF_TERR_USGS_S.NEXTVAL

7793: l_terr_all_rec.ORG_ID := p_org_id(x);
7794: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 8179: SELECT JTF_TERR_USGS_S.NEXTVAL

8175: l_terr_all_rec.attribute14 := naterr.attribute14;
8176: l_terr_all_rec.attribute15 := naterr.attribute15;
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;

Line 8572: SELECT JTF_TERR_USGS_S.NEXTVAL

8568: l_terr_all_rec.attribute14 := naterr.attribute14;
8569: l_terr_all_rec.attribute15 := naterr.attribute15;
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;

Line 8953: SELECT JTF_TERR_USGS_S.NEXTVAL

8949: l_terr_all_rec.ORG_ID := p_org_id(x);
8950: l_terr_all_rec.NUM_WINNERS := l_pi_count ;
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;

Line 9151: SELECT JTF_TERR_USGS_S.NEXTVAL

9147: l_terr_all_rec.AUTO_ASSIGN_RESOURCES_FLAG := NULL;
9148: l_terr_all_rec.ORG_ID := p_org_id(x);
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;

Line 9357: SELECT JTF_TERR_USGS_S.NEXTVAL

9353: l_terr_all_rec.attribute13 := overlayterr.attribute13;
9354: l_terr_all_rec.attribute14 := overlayterr.attribute14;
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;

Line 9748: SELECT JTF_TERR_USGS_S.NEXTVAL

9744: l_terr_all_rec.ORG_ID := p_org_id(x);
9745: l_terr_all_rec.NUM_WINNERS := NULL ;
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;

Line 9941: SELECT JTF_TERR_USGS_S.NEXTVAL

9937: l_terr_all_rec.attribute13 := overlayterr.attribute13;
9938: l_terr_all_rec.attribute14 := overlayterr.attribute14;
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;