APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_VALUES_ALL

Line 595: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID = l_terr_qual_id;

591: LOOP
592: FETCH C_TERR_QUAL_IDS INTO l_terr_qual_id;
593: EXIT WHEN C_TERR_QUAL_IDS%NOTFOUND;
594: --Delete Territory Values
595: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID = l_terr_qual_id;
596: END LOOP;
597: CLOSE C_TERR_QUAL_IDS;
598: EXCEPTION
599: WHEN NO_DATA_FOUND THEN

Line 4569: From JTF_TERR_VALUES_ALL

4565: ID_USED_FLAG,
4566: LOW_VALUE_CHAR_ID,
4567: ORG_ID,
4568: CNR_GROUP_ID
4569: From JTF_TERR_VALUES_ALL
4570: Where TERR_VALUE_ID = l_TERR_VALUE_ID
4571: For Update NOWAIT;
4572:
4573: Cursor C_GetTerr_qual_id(l_TERR_VALUE_ID Number) IS

Line 4575: From JTF_TERR_VALUES_ALL

4571: For Update NOWAIT;
4572:
4573: Cursor C_GetTerr_qual_id(l_TERR_VALUE_ID Number) IS
4574: Select TERR_QUAL_ID
4575: From JTF_TERR_VALUES_ALL
4576: Where TERR_VALUE_ID = l_TERR_VALUE_ID ;
4577:
4578: --Local variable declaration
4579: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_Value';

Line 5386: DELETE jtf_terr_values_ALL

5382: NULL;
5383: END;
5384:
5385: /* Do a bulk delete of Territory Qualifier VALUES */
5386: DELETE jtf_terr_values_ALL
5387: WHERE terr_qual_id = p_terr_qual_id
5388: RETURNING terr_value_id
5389: BULK COLLECT INTO deletedIds;
5390:

Line 7711: From JTF_TERR_VALUES_ALL

7707: BEGIN
7708:
7709: Select 'X'
7710: into l_dummy
7711: From JTF_TERR_VALUES_ALL
7712: WHERE TERR_QUAL_ID = P_terr_qual_id
7713: AND nvl(COMPARISON_OPERATOR , '-9999') = nvl( decode(P_Terr_Value_Rec.COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL , P_Terr_Value_Rec.COMPARISON_OPERATOR ) , '-9999')
7714: AND nvl(LOW_VALUE_CHAR , '-9999') = nvl( decode(P_Terr_Value_Rec.LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL , P_Terr_Value_Rec.LOW_VALUE_CHAR ) , '-9999')
7715: AND nvl(HIGH_VALUE_CHAR , '-9999') = nvl( decode(P_Terr_Value_Rec.HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL , P_Terr_Value_Rec.HIGH_VALUE_CHAR ) , '-9999')

Line 7787: From JTF_TERR_VALUES_ALL

7783: l_dummy VARCHAR2(5);
7784: BEGIN
7785: Select 'X'
7786: into l_dummy
7787: From JTF_TERR_VALUES_ALL
7788: WHERE TERR_VALUE_ID <> P_Terr_Value_Rec.TERR_VALUE_ID
7789: AND TERR_QUAL_ID = P_terr_qual_id
7790: AND nvl(COMPARISON_OPERATOR , '-9999') = nvl( decode(P_Terr_Value_Rec.COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL , P_Terr_Value_Rec.COMPARISON_OPERATOR ) , '-9999')
7791: AND nvl(LOW_VALUE_CHAR , '-9999') = nvl( decode(P_Terr_Value_Rec.LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL , P_Terr_Value_Rec.LOW_VALUE_CHAR ) , '-9999')