[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
605: --Delete Territory Qualifer records
606: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
607:
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:
3993: CREATION_DATE,
3994: LAST_UPDATE_LOGIN,
3995: TERR_ID,
3996: QUAL_TYPE_USG_ID
3997: From JTF_TERR_QTYPE_USGS_ALL
3998: Where terr_qtype_usg_id = l_terr_qual_type_usg_id
3999: FOR Update NOWAIT;
4000: --Local variable declaration
4001: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_QualType_Usage';
5638: /* SELECT 'x'
5639: into l_Temp
5640: from jtf_qual_usgs_ALL jqu,
5641: jtf_qual_type_usgs_ALL jqtu,
5642: jtf_terr_qtype_usgs_ALL jtqu
5643: where jtqu.terr_id = p_Terr_Id and
5644: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5645: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and
5646: jqu.enabled_flag = 'Y' and
10159: -- cursor to check that Unique Key constraint not violated
10160: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
10161: , lp_qual_type_usg_id NUMBER) IS
10162: SELECT 'X'
10163: FROM JTF_TERR_QTYPE_USGS_ALL
10164: WHERE terr_id = lp_terr_id
10165: AND qual_type_usg_id = lp_qual_type_usg_id;
10166:
10167: l_return_csr VARCHAR2(1);