eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_VALUES

Line 55: -- 05/22/01 ARPATEL Added CNR_GROUP_ID to cursors selecting from JTF_TERR_VALUES.

51: -- 04/05/01 ARPATEL Added processing for copy hierarchy in proc 'Copy Territory'
52: -- 04/12/01 jdochert Added PROCEDURE chk_num_copy_terr
53: -- 04/20/01 ARPATEL Added Concurrent_Copy_Territory procedure for concurrent requests
54: -- 04/28/01 ARPATEL Added FUNCTION conc_req_copy_terr returning concurrent request ID.
55: -- 05/22/01 ARPATEL Added CNR_GROUP_ID to cursors selecting from JTF_TERR_VALUES.
56: -- 07/13/01 ARPATEL Added validation for territory templates without 'DYNAMIC QUALIFIERS'
57: -- 09/06/01 ARPATEL Added VALUE1_ID, VALUE2_ID AND VALUE3_ID to JTF_TERR_VALUES cursors
58: -- and procedure create_new_terr_value_rec
59: -- 09/18/01 ARPATEL Removed debug message level checks to enable form to pick up these messages

Line 57: -- 09/06/01 ARPATEL Added VALUE1_ID, VALUE2_ID AND VALUE3_ID to JTF_TERR_VALUES cursors

53: -- 04/20/01 ARPATEL Added Concurrent_Copy_Territory procedure for concurrent requests
54: -- 04/28/01 ARPATEL Added FUNCTION conc_req_copy_terr returning concurrent request ID.
55: -- 05/22/01 ARPATEL Added CNR_GROUP_ID to cursors selecting from JTF_TERR_VALUES.
56: -- 07/13/01 ARPATEL Added validation for territory templates without 'DYNAMIC QUALIFIERS'
57: -- 09/06/01 ARPATEL Added VALUE1_ID, VALUE2_ID AND VALUE3_ID to JTF_TERR_VALUES cursors
58: -- and procedure create_new_terr_value_rec
59: -- 09/18/01 ARPATEL Removed debug message level checks to enable form to pick up these messages
60: -- 12/03/04 achanda Added value4_id : bug # 3726007
61: --

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 3129: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');

3125: IF (l_terr_value_id = FND_API.G_MISS_NUM) THEN
3126: l_terr_value_id := NULL;
3127: END IF;
3128: --
3129: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
3130: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
3131: x_TERR_VALUE_ID => l_terr_value_id,
3132: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
3133: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,

Line 3130: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,

3126: l_terr_value_id := NULL;
3127: END IF;
3128: --
3129: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
3130: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
3131: x_TERR_VALUE_ID => l_terr_value_id,
3132: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
3133: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
3134: x_CREATED_BY => P_Terr_Value_Rec.CREATED_BY,

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 4610: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_VALUES');

4606: --dbms_output('Update_Terr_Value REC: NO-RCORDS-FOUND');
4607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4608: THEN
4609: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
4610: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_VALUES');
4611: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_Value_Rec.TERR_VALUE_ID));
4612: FND_MSG_PUB.Add;
4613: END IF;
4614: raise FND_API.G_EXC_ERROR;

Line 4691: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_VALUES');

4687: --dbms_output('Update_Terr_Value REC: NO-RCORDS-FOUND');
4688: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4689: THEN
4690: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
4691: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_VALUES');
4692: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_Value_Rec.TERR_VALUE_ID));
4693: FND_MSG_PUB.Add;
4694: END IF;
4695: raise FND_API.G_EXC_ERROR;

Line 4699: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');

4695: raise FND_API.G_EXC_ERROR;
4696:
4697: End if;
4698: CLOSE C_GetTerritoryValue;
4699: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4700: --call the table handler
4701: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4702: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4703: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,

Line 4701: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,

4697: End if;
4698: CLOSE C_GetTerritoryValue;
4699: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4700: --call the table handler
4701: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4702: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4703: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
4704: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
4705: x_CREATED_BY => P_Terr_Value_Rec.created_by,

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 5531: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);

5527: --Initialize the return status to success
5528: x_return_status := FND_API.G_RET_STS_SUCCESS;
5529: --
5530:
5531: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);
5532: --
5533: --Prepare message name
5534: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5535: IF SQL%FOUND THEN

Line 5542: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_VALUES');

5538: l_row_count := SQL%ROWCOUNT;
5539: END IF;
5540: --Prepare message token
5541: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5542: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_VALUES');
5543: FND_MSG_PUB.ADD();
5544:
5545: -- Debug Message
5546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 5574: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_VALUES');

5570: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5571: l_row_count := 0;
5572: --Prepare message token
5573: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5574: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_VALUES');
5575: --Add message to API message list
5576: FND_MSG_PUB.ADD();
5577: --
5578: FND_MSG_PUB.Count_And_Get

Line 6815: /* Function used in JTF_TERR_VALUES_DESC_V to return

6811: );
6812: --
6813: END Validate_Terr_Qtype_Usage;
6814:
6815: /* Function used in JTF_TERR_VALUES_DESC_V to return
6816: ** descriptive values for ids and lookup_codes
6817: */
6818: PROCEDURE Validate_terr_Value
6819: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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')

Line 8081: FROM jtf_terr_values j1, jtf_terr_qual j2, jtf_terr j3

8077:
8078: /* cursor to get the number of territories that will be generated */
8079: CURSOR c_get_max_value_set (p_template_terr_id NUMBER) IS
8080: SELECT MAX (j1.VALUE_SET)
8081: FROM jtf_terr_values j1, jtf_terr_qual j2, jtf_terr j3
8082: WHERE j1.terr_qual_id = j2.terr_qual_id
8083: AND j2.terr_id = j3.terr_id
8084: AND j3.terr_id = p_template_terr_id
8085: AND j2.qualifier_mode = 'DYNAMIC'

Line 8826: FROM jtf_terr_values j1

8822: , j1.VALUE1_ID
8823: , j1.VALUE2_ID
8824: , j1.VALUE3_ID
8825: , j1.VALUE4_ID
8826: FROM jtf_terr_values j1
8827: WHERE j1.terr_qual_id = p_terr_qual_id;
8828:
8829: /* local record variables */
8830: l_tmpl_terr_qual_rec Terr_Qual_Rec_Type;

Line 8980: FROM jtf_terr_values j1

8976: , j1.VALUE1_ID
8977: , j1.VALUE2_ID
8978: , j1.VALUE3_ID
8979: , j1.VALUE4_ID
8980: FROM jtf_terr_values j1
8981: WHERE j1.terr_qual_id = p_terr_qual_id;
8982:
8983: /* local record variables */
8984: l_tmpl_terr_qual_rec Terr_Qual_Rec_Type;

Line 9126: FROM jtf_terr_values j1

9122: , j1.VALUE1_ID
9123: , j1.VALUE2_ID
9124: , j1.VALUE3_ID
9125: , j1.VALUE4_ID
9126: FROM jtf_terr_values j1
9127: WHERE j1.terr_qual_id = p_terr_qual_id
9128: ORDER BY j1.value_set;
9129:
9130: l_tmpl_terr_qual_rec Terr_Qual_Rec_Type;

Line 9848: p_terr_value_record IN jtf_terr_values%ROWTYPE )

9844: -- checked only under a single parent.
9845: ---------------------------------------------------------------------
9846: FUNCTION Overlap_Exists(p_Parent_Terr_Id IN NUMBER,
9847: p_Qual_Usg_Id IN NUMBER,
9848: p_terr_value_record IN jtf_terr_values%ROWTYPE )
9849: RETURN VARCHAR2
9850: AS
9851: dummy NUMBER := 0;
9852: l_found NUMBER := 0;

Line 9873: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9869: Then
9870: If p_terr_value_record.low_value_char is NOT NULL Then
9871: Select count(*)
9872: into dummy
9873: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
9874: Where jt.parent_territory_id = p_Parent_Terr_Id
9875: and jtq.terr_id = jt.terr_id
9876: and jtq.qual_usg_id = p_Qual_Usg_Id
9877: and jtv.terr_qual_id = jtq.terr_qual_id

Line 9900: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9896: -- Check the high_value_char
9897: If p_terr_value_record.high_value_char is NOT NULL Then
9898: Select count(*)
9899: into dummy
9900: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
9901: Where jt.parent_territory_id = p_Parent_Terr_Id
9902: and jtq.terr_id = jt.terr_id
9903: and jtq.qual_usg_id = p_Qual_Usg_Id
9904: and jtv.terr_qual_id = jtq.terr_qual_id

Line 9931: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9927: -- only check for a subset of the availabel operator as these are the only
9928: -- available one for this combination
9929: Select count(*)
9930: into dummy
9931: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
9932: Where jt.parent_territory_id = p_Parent_Terr_Id
9933: and jtq.terr_id = jt.terr_id
9934: and jtq.qual_usg_id = p_Qual_Usg_Id
9935: and jtv.terr_qual_id = jtq.terr_qual_id

Line 9949: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9945:
9946: If p_terr_value_record.low_value_number is NOT NULL Then
9947: Select 1
9948: into dummy
9949: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
9950: Where jt.parent_territory_id = p_Parent_Terr_Id
9951: and jtq.terr_id = jt.terr_id
9952: and jtq.qual_usg_id = p_Qual_Usg_Id
9953: and jtv.terr_qual_id = jtq.terr_qual_id

Line 9971: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9967:
9968: If p_terr_value_record.high_value_number is NOT NULL Then
9969: Select 1
9970: into dummy
9971: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
9972: Where jt.parent_territory_id = p_Parent_Terr_Id
9973: and jtq.terr_id = jt.terr_id
9974: and jtq.qual_usg_id = p_Qual_Usg_Id
9975: and jtv.terr_qual_id = jtq.terr_qual_id

Line 9999: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

9995:
9996: If p_terr_value_record.low_value_number is NOT NULL Then
9997: Select count(*)
9998: into dummy
9999: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
10000: Where jt.parent_territory_id = p_Parent_Terr_Id
10001: and jtq.terr_id = jt.terr_id
10002: and jtq.qual_usg_id = p_Qual_Usg_Id
10003: and jtv.terr_qual_id = jtq.terr_qual_id

Line 10021: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

10017:
10018: If p_terr_value_record.high_value_number is NOT NULL Then
10019: Select count(*)
10020: into dummy
10021: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
10022: Where jt.parent_territory_id = p_Parent_Terr_Id
10023: and jtq.terr_id = jt.terr_id
10024: and jtq.qual_usg_id = p_Qual_Usg_Id
10025: and jtv.terr_qual_id = jtq.terr_qual_id

Line 10047: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt

10043: l_convert_to_id_flag is NULL ) )
10044: Then
10045: Select count(*)
10046: into dummy
10047: from jtf_terr_values jtv, jtf_terr_qual jtq, jtf_terr jt
10048: Where jt.parent_territory_id = p_Parent_Terr_Id
10049: and jtq.terr_id = jt.terr_id
10050: and jtq.qual_usg_id = p_Qual_Usg_Id
10051: and jtv.terr_qual_id = jtq.terr_qual_id

Line 10719: /* Function used in JTF_TERR_VALUES_DESC_V to return

10715: );
10716: END validate_parent;
10717:
10718:
10719: /* Function used in JTF_TERR_VALUES_DESC_V to return
10720: ** descriptive values for ids and lookup_codes
10721: */
10722: FUNCTION get_terr_value_desc (
10723: p_convert_to_id_flag VARCHAR2