APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_USGS_ALL

Line 45: -- 09/09/00 jdochert Added Unique validation for JTF_TERR_USGS_ALL + JTF_TERR_QTYPE_USGS_ALL

41: -- l_terr_id NUMBER := P_TERR_ALL_REC.TERR_ID;
42: -- 08/08/00 jdochert Removing if statement that causes error when LOW_VALUE_CHAR = FND_API.G_MISS_CHAR
43: -- and ID_USED_FLAG = 'Y": this was an error in logic.
44: -- 08/21/00 jdochert Changing overlap_exists procedure to do an UPPER on comparison operator
45: -- 09/09/00 jdochert Added Unique validation for JTF_TERR_USGS_ALL + JTF_TERR_QTYPE_USGS_ALL
46: -- 09/17/00 jdochert BUG#1408610 FIX
47: --
48: -- 10/04/00 jdochert Added validation for NUM_WINNERS
49: -- 11/02/00 jdochert Added processing for NUM_QUAL

Line 612: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;

608: --Delete Territory qual type usgs
609: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
610:
611: --Delete Territory usgs
612: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
613:
614: --Delete Territory Resource Access
615: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
616: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL WHERE TERR_ID = c.Terr_Id );

Line 1353: FROM jtf_terr_usgs_all jtua

1349: AND p_terr_all_rec.PARENT_TERRITORY_ID <> 1 ) THEN
1350:
1351: SELECT 1
1352: INTO l_dummy
1353: FROM jtf_terr_usgs_all jtua
1354: WHERE jtua.terr_id = p_terr_all_rec.PARENT_TERRITORY_ID
1355: AND jtua.source_id = p_terr_usgs_tbl (1).source_id
1356: AND jtua.org_id = p_terr_all_rec.org_id ;
1357: END IF;

Line 3715: From JTF_TERR_USGS_ALL

3711: CREATED_BY,
3712: LAST_UPDATE_LOGIN,
3713: TERR_ID,
3714: SOURCE_ID
3715: From JTF_TERR_USGS_ALL
3716: Where terr_usg_id = l_terr_usg_id
3717: FOR Update NOWAIT;
3718: --Local variable declaration
3719: l_api_name CONSTANT VARCHAR2(30) := 'Update_territory_Usages';

Line 6235: FROM jtf_terr_usgs_all childusg, jtf_terr_usgs_all parusg

6231: AND p_terr_all_rec.PARENT_TERRITORY_ID <> 1) THEN
6232:
6233: SELECT 1
6234: INTO l_dummy
6235: FROM jtf_terr_usgs_all childusg, jtf_terr_usgs_all parusg
6236: WHERE childusg.terr_id = p_terr_all_rec.TERR_ID
6237: AND parusg.terr_id = p_terr_all_rec.PARENT_TERRITORY_ID
6238: AND childusg.source_id = parusg.source_id
6239: AND childusg.org_id = parusg.org_id ;

Line 6682: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu

6678: l_qual_Type_Usg_id := p_Terr_QualTypeUsgs_Rec.QUAL_TYPE_USG_ID;
6679: --Check the qual_type_usg_id specified is valid
6680: Select 1
6681: into l_dummy
6682: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu
6683: where jtu.terr_id = p_Terr_Id and
6684: jqtu.source_id = jtu.source_id and
6685: jqtu.qual_type_usg_id = l_qual_Type_Usg_id;
6686:

Line 7864: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu

7860: AS
7861: BEGIN
7862: Select Max(rank)
7863: into x_Rank
7864: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu
7865: where jt.Parent_Territory_id = p_Parent_Terr_Id and
7866: jt.Terr_Id = jtu.Terr_Id and
7867: jtu.source_id = p_Source_Id;
7868:

Line 10092: FROM JTF_TERR_USGS_ALL

10088: -- cursor to check that Unique Key constraint not violated
10089: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
10090: , lp_source_id NUMBER) IS
10091: SELECT 'X'
10092: FROM JTF_TERR_USGS_ALL
10093: WHERE terr_id = lp_terr_id
10094: AND source_id = lp_source_id;
10095:
10096: l_return_csr VARCHAR2(1);