[Home] [Help]
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
597: --Delete Territory Qualifer records
598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
599:
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:
3618: CREATION_DATE,
3619: LAST_UPDATE_LOGIN,
3620: TERR_ID,
3621: QUAL_TYPE_USG_ID
3622: From JTF_TERR_QTYPE_USGS_ALL
3623: Where terr_qtype_usg_id = l_terr_qual_type_usg_id
3624: FOR Update NOWAIT;
3625: --Local variable declaration
3626: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_QualType_Usage';
5211: SELECT 'x'
5212: into l_Temp
5213: from jtf_qual_usgs_ALL jqu,
5214: jtf_qual_type_usgs_ALL jqtu,
5215: jtf_terr_qtype_usgs_ALL jtqu
5216: where jtqu.terr_id = p_Terr_Id and
5217: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5218: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and
5219: jqu.enabled_flag = 'Y' and
8595: -- cursor to check that Unique Key constraint not violated
8596: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
8597: , lp_qual_type_usg_id NUMBER) IS
8598: SELECT 'X'
8599: FROM JTF_TERR_QTYPE_USGS_ALL
8600: WHERE terr_id = lp_terr_id
8601: AND qual_type_usg_id = lp_qual_type_usg_id;
8602:
8603: l_return_csr VARCHAR2(1);