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 604: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;

600: --Delete Territory qual type usgs
601: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
602:
603: --Delete Territory usgs
604: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
605:
606: --Delete Territory Resource Access
607: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
608: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL WHERE TERR_ID = c.Terr_Id );

Line 3340: From JTF_TERR_USGS_ALL

3336: CREATED_BY,
3337: LAST_UPDATE_LOGIN,
3338: TERR_ID,
3339: SOURCE_ID
3340: From JTF_TERR_USGS_ALL
3341: Where terr_usg_id = l_terr_usg_id
3342: FOR Update NOWAIT;
3343: --Local variable declaration
3344: l_api_name CONSTANT VARCHAR2(30) := 'Update_territory_Usages';

Line 5853: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu

5849: l_qual_Type_Usg_id := p_Terr_QualTypeUsgs_Rec.QUAL_TYPE_USG_ID;
5850: --Check the qual_type_usg_id specified is valid
5851: Select 1
5852: into l_dummy
5853: From jtf_terr_usgs_ALL jtu, jtf_qual_type_usgs_ALL jqtu
5854: where jtu.terr_id = p_Terr_Id and
5855: jqtu.source_id = jtu.source_id and
5856: jqtu.qual_type_usg_id = l_qual_Type_Usg_id;
5857:

Line 6300: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu

6296: AS
6297: BEGIN
6298: Select Max(rank)
6299: into x_Rank
6300: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu
6301: where jt.Parent_Territory_id = p_Parent_Terr_Id and
6302: jt.Terr_Id = jtu.Terr_Id and
6303: jtu.source_id = p_Source_Id;
6304:

Line 8528: FROM JTF_TERR_USGS_ALL

8524: -- cursor to check that Unique Key constraint not violated
8525: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
8526: , lp_source_id NUMBER) IS
8527: SELECT 'X'
8528: FROM JTF_TERR_USGS_ALL
8529: WHERE terr_id = lp_terr_id
8530: AND source_id = lp_source_id;
8531:
8532: l_return_csr VARCHAR2(1);