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.

[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QUAL

Line 373: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => l_Terr_Qual_Id );

369:
370: --Remove the qualifier if no values are specified.
371: BEGIN
372: IF l_index = 0 THEN
373: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => l_Terr_Qual_Id );
374: FND_MESSAGE.Set_Name('JTF', 'JTY_TERR_MISSING_TERR_VALUES');
375: FND_MESSAGE.Set_Token('QUAL_USG_ID', to_char(l_Terr_Qual_Tbl(1).QUAL_USG_ID));
376: FND_MSG_PUB.ADD;
377: End If;

Line 539: FROM JTF_TERR_QUAL_ALL

535: start with terr_id = v_Terr_Id;
536:
537: CURSOR C_TERR_QUAL_IDS ( p_Terr_Id IN NUMBER) IS
538: SELECT TERR_QUAL_ID
539: FROM JTF_TERR_QUAL_ALL
540: WHERE TERR_ID = p_Terr_Id;
541:
542:
543:

Line 606: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;

602: CLOSE C_TERR_QUAL_IDS;
603: END;
604:
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:

Line 1482: -- Call api to insert records into jtf_terr_qualtype_usgs

1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: CLOSE C_QUAL_TYPE_USG_ID;
1481: END;
1482: -- Call api to insert records into jtf_terr_qualtype_usgs
1483: --
1484: --dbms_output('Create_Territory_Header PVT: Before Calling Create_Terr_QualType_Usage');
1485:
1486: Create_Terr_QualType_Usage(P_Api_Version_Number => P_Api_Version_Number,

Line 2367: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu

2363:
2364: UPDATE jtf_terr_ALL jt
2365: SET jt.num_qual = (
2366: SELECT COUNT(jtq.qual_usg_id)
2367: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2368: WHERE jtq.terr_id = jt.terr_id
2369: AND jtq.qual_usg_id = jqu.qual_usg_id
2370: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
2371: AND jqtu.qual_type_id = p_qual_type_id

Line 2529: JTF_TERR_QUAL_PKG.Insert_Row(x_Rowid => l_rowid,

2525: l_terr_qual_id := NULL;
2526: END IF;
2527:
2528: -- Call insert terr_Qual_Type_Usgs table handler
2529: JTF_TERR_QUAL_PKG.Insert_Row(x_Rowid => l_rowid,
2530: x_TERR_QUAL_ID => l_terr_qual_id,
2531: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
2532: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
2533: x_CREATION_DATE => P_Terr_Qual_Rec.CREATION_DATE,

Line 4274: From JTF_TERR_QUAL_ALL

4270: QUAL_USG_ID,
4271: USE_TO_NAME_FLAG,
4272: GENERATE_FLAG,
4273: OVERLAP_ALLOWED_FLAG
4274: From JTF_TERR_QUAL_ALL
4275: Where terr_qual_id = l_terr_qual_id
4276: FOR Update NOWAIT;
4277: --Local variable declaration
4278: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_Qualifier';

Line 4342: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QUAL');

4338: --dbms_output('Update_Terr_Qualifier REC: NO-RCORDS-FOUND');
4339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4340: THEN
4341: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
4342: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QUAL');
4343: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_Qual_Rec.terr_qual_id));
4344: FND_MSG_PUB.Add;
4345: END IF;
4346: raise FND_API.G_EXC_ERROR;

Line 4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');

4346: raise FND_API.G_EXC_ERROR;
4347: End if;
4348: CLOSE C_GetTerrQualifier;
4349: -- P_Terr_Qual_Rec.terr_qual_id cant be null
4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
4352: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
4353: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
4354: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,

Line 4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,

4347: End if;
4348: CLOSE C_GetTerrQualifier;
4349: -- P_Terr_Qual_Rec.terr_qual_id cant be null
4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
4352: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
4353: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
4354: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
4355: x_CREATION_DATE => P_Terr_Qual_Rec.creation_date,

Line 5376: FROM jtf_terr_qual_ALL jtq

5372: /* anonymous block to get territory id */
5373: BEGIN
5374: SELECT terr_id
5375: INTO lp_terr_id
5376: FROM jtf_terr_qual_ALL jtq
5377: WHERE jtq.terr_qual_id = p_terr_qual_id;
5378: EXCEPTION
5379: WHEN NO_DATA_FOUND THEN
5380: NULL;

Line 5391: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => P_Terr_Qual_Id );

5387: WHERE terr_qual_id = p_terr_qual_id
5388: RETURNING terr_value_id
5389: BULK COLLECT INTO deletedIds;
5390:
5391: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => P_Terr_Qual_Id );
5392: --
5393: --Prepare message name
5394: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5395: IF SQL%FOUND THEN

Line 5407: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QUALIFIERS');

5403: -- update_terr_num_qual(lp_terr_id, -1002);
5404:
5405: --Prepare message token
5406: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5407: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QUALIFIERS');
5408: FND_MSG_PUB.ADD();
5409:
5410: -- Debug Message
5411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 5438: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QUALIFIERS');

5434: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5435: l_row_count := 0;
5436: --Prepare message token
5437: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5438: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QUALIFIERS');
5439: --Add message to API message list
5440: FND_MSG_PUB.ADD();
5441: --
5442: FND_MSG_PUB.Count_And_Get

Line 5682: FROM JTF_TERR_QUAL_ALL

5678: IF ( p_Terr_Id IS NOT NULL ) AND
5679: ( P_Terr_Qual_Rec.Qual_Usg_Id IS NOT NULL ) Then
5680:
5681: SELECT COUNT(*) INTO l_qual_count
5682: FROM JTF_TERR_QUAL_ALL
5683: WHERE TERR_ID = p_Terr_Id
5684: AND QUAL_USG_ID = P_Terr_Qual_Rec.Qual_Usg_Id ;
5685:
5686: IF ( l_qual_count IS NOT NULL ) AND

Line 6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq

6919: jqu.display_sql1,
6920: jqu.display_sql2,
6921: jqu.display_sql3,
6922: html_lov_sql1
6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq
6924: where jqu.qual_usg_id = jtq.qual_Usg_Id and
6925: jqu.org_id = jtq.org_id AND
6926: jtq.terr_qual_id = p_Terr_Qual_Id;
6927:

Line 7915: FROM jtf_terr_qual j

7911:
7912: /* (2) check that at least 1 dynamic is specified for use in generation */
7913: CURSOR c_chk_qual_mode (p_template_terr_id NUMBER) IS
7914: SELECT COUNT(*)
7915: FROM jtf_terr_qual j
7916: WHERE j.terr_id = p_template_terr_id
7917: AND j.qualifier_mode = 'DYNAMIC';
7918:
7919: l_terr_id NUMBER := 0;

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 8794: FROM jtf_terr_qual j1

8790: , j1.GENERATE_FLAG
8791: , j1.OVERLAP_ALLOWED_FLAG
8792: , j1.QUALIFIER_MODE
8793: , j1.ORG_ID
8794: FROM jtf_terr_qual j1
8795: WHERE j1.terr_id = p_template_terr_id;
8796:
8797: /* cursor to get values for STATIC qualifiers' values */
8798: CURSOR c_get_terr_value (p_terr_qual_id NUMBER) IS

Line 8947: FROM jtf_terr_qual j1

8943: , j1.GENERATE_FLAG
8944: , j1.OVERLAP_ALLOWED_FLAG
8945: , j1.QUALIFIER_MODE
8946: , j1.ORG_ID
8947: FROM jtf_terr_qual j1
8948: WHERE j1.terr_id = p_template_terr_id
8949: AND j1.qualifier_mode = 'STATIC';
8950:
8951: /* cursor to get values for STATIC qualifiers' values */

Line 9093: FROM jtf_terr_qual j1

9089: , j1.GENERATE_FLAG
9090: , j1.OVERLAP_ALLOWED_FLAG
9091: , j1.QUALIFIER_MODE
9092: , j1.ORG_ID
9093: FROM jtf_terr_qual j1
9094: WHERE j1.terr_id = p_template_terr_id
9095: AND j1.qualifier_mode = 'DYNAMIC';
9096:
9097: /* cursor to get values for dynamic qualifier values */

Line 9478: /* insert record IN JTF_TERR_QUAL_ALL */

9474: l_tmpl_terr_qual_rec.overlap_allowed_flag := l_dyn_qual_tbl(i).OVERLAP_ALLOWED_FLAG;
9475: l_tmpl_terr_qual_rec.qualifier_mode := l_dyn_qual_tbl(i).QUALIFIER_MODE;
9476: l_tmpl_terr_qual_rec.org_id := l_dyn_qual_tbl(i).ORG_ID;
9477:
9478: /* insert record IN JTF_TERR_QUAL_ALL */
9479: create_new_terr_qual_rec(l_new_terr_id, l_tmpl_terr_qual_rec, l_new_terr_qual_id);
9480:
9481: l_rec_index := l_dyn_qual_tbl(i).start_record + l_dyn_qual_tbl(i).current_record;
9482:

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