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_ALL

Line 543: select terr_id from jtf_terr_all

539: v_Terr_Id NUMBER := p_Terr_Id;
540:
541: --Declare cursor to get usages
542: Cursor C_Terr IS
543: select terr_id from jtf_terr_all
544: connect by parent_territory_id = prior terr_id AND TERR_ID <> 1
545: start with terr_id = v_Terr_Id;
546:
547:

Line 614: DELETE from JTF_TERR_ALL WHERE TERR_ID = c.Terr_Id;

610: -- Delete the Territory Resource records
611: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = c.Terr_Id;
612:
613: --Delete Territory record
614: DELETE from JTF_TERR_ALL WHERE TERR_ID = c.Terr_Id;
615:
616: --
617: END LOOP;
618:

Line 1015: From JTF_TERR_ALL

1011: ATTRIBUTE15,
1012: ORG_ID,
1013: NUM_WINNERS,
1014: NUM_QUAL
1015: From JTF_TERR_ALL
1016: Where TERR_ID = l_terr_id
1017: For Update NOWAIT;
1018:
1019: --Local variable declaration

Line 1326: UPDATE JTF_TERR_ALL

1322: X_Terr_Id => l_terr_id,
1323: X_Terr_All_Out_Rec => l_Terr_All_Out_Rec);
1324:
1325: ELSE
1326: UPDATE JTF_TERR_ALL
1327: SET terr_group_id = p_terr_all_rec.territory_group_id,
1328: LAST_UPDATED_BY = p_terr_all_rec.LAST_UPDATED_BY,
1329: LAST_UPDATE_LOGIN = p_terr_all_rec.LAST_UPDATE_LOGIN,
1330: NAME = p_terr_all_rec.NAME,

Line 1450: -- Function : To create a records in jtf_Terr_all table

1446: -- start of comments
1447: -- ***************************************************
1448: -- API name : Create_Territory_record
1449: -- Type : PUBLIC
1450: -- Function : To create a records in jtf_Terr_all table
1451: --
1452: -- Pre-reqs :
1453: -- Parameters:
1454: -- IN :

Line 2263: UPDATE jtf_terr_ALL jt

2259: */
2260: PROCEDURE update_terr_num_qual(p_terr_id IN NUMBER, p_qual_type_id IN NUMBER) AS
2261: BEGIN
2262:
2263: UPDATE jtf_terr_ALL jt
2264: SET jt.num_qual = (
2265: SELECT COUNT(jtq.qual_usg_id)
2266: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2267: WHERE jtq.terr_id = jt.terr_id

Line 3100: From JTF_TERR_ALL

3096: ATTRIBUTE15,
3097: ORG_ID,
3098: NUM_WINNERS,
3099: NUM_QUAL
3100: From JTF_TERR_ALL
3101: Where TERR_ID = l_terr_id
3102: For Update NOWAIT;
3103:
3104: --Local variable declaration

Line 5581: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then

5577: Then
5578: --
5579: l_parent_terr_id := p_Terr_All_Rec.parent_territory_Id;
5580: --dbms_output('Validate_Foreign_Key: Returned from JTF_CTM_UTILITY_PVT.fk_id_is_valid');
5581: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
5582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5583: --dbms_output('PARENT Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
5584: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_PARENT_TERR');
5585: FND_MESSAGE.Set_Token('TERR_ID', to_char(l_parent_terr_id));

Line 5614: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TEMPLATE_TERRITORY_ID, 'TERR_ID', 'JTF_TERR_ALL');

5610: --dbms_output('Validate_Foreign_Key: Checking for TEMPLATE_TERRITORY_ID');
5611: --
5612: iF (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID is not null) AND
5613: (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
5614: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TEMPLATE_TERRITORY_ID, 'TERR_ID', 'JTF_TERR_ALL');
5615: if l_status <> FND_API.G_TRUE Then
5616: x_return_status := FND_API.G_RET_STS_ERROR;
5617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5618: --dbms_output('TEMP: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

Line 5630: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.escalation_territory_id, 'TERR_ID', 'JTF_TERR_ALL');

5626: --dbms_output('Validate_Foreign_Key: Checking for ESCALATION_TERRITORY_ID');
5627: --
5628: If (p_Terr_All_Rec.ESCALATION_TERRITORY_ID is not null) AND
5629: (p_Terr_All_Rec.ESCALATION_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
5630: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.escalation_territory_id, 'TERR_ID', 'JTF_TERR_ALL');
5631: if l_status <> FND_API.G_TRUE Then
5632: x_return_status := FND_API.G_RET_STS_ERROR;
5633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5634: --dbms_output('ESC TERR: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

Line 5689: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then

5685:
5686: -- Validate the territory Id
5687: If p_Terr_Id IS NOT NULL THEN
5688: l_Validate_id := p_Terr_Id;
5689: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
5690: --dbms_output('Validate_Territory_Usage: l_status <> FND_API.G_TRUE');
5691: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5692: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
5693: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

Line 5869: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then

5865: -- Validate the territory Id
5866: l_Validate_id := p_Terr_Id;
5867: If p_Terr_Id IS NOT NULL Then
5868: --dbms_output('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
5869: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
5870: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
5871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5872: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5873: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

Line 6300: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu

6296: AS
6297: BEGIN
6298: Select Max(rank)
6299: into x_Rank
6300: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu
6301: where jt.Parent_Territory_id = p_Parent_Terr_Id and
6302: jt.Terr_Id = jtu.Terr_Id and
6303: jtu.source_id = p_Source_Id;
6304:

Line 6343: FROM jtf_terr_ALL j

6339:
6340: /* (1) check template exists */
6341: CURSOR c_chk_template (p_template_terr_id NUMBER) IS
6342: SELECT 'X'
6343: FROM jtf_terr_ALL j
6344: WHERE j.terr_id = p_template_terr_id
6345: AND j.template_flag = 'Y';
6346:
6347:

Line 7038: FROM jtf_terr_ALL

7034:
7035: /* START OF 1520656 BUG FIX - JDOCHERT 12/07 */
7036: CURSOR c_get_terr(lp_terr_id NUMBER)
7037: IS SELECT 'Y'
7038: FROM jtf_terr_ALL
7039: WHERE template_flag = 'Y'
7040: AND terr_id = lp_terr_id;
7041:
7042: l_template_flag VARCHAR2(1);

Line 8099: from JTF_TERR_ALL jta

8095: l_tbl_count NUMBER;
8096:
8097: CURSOR csr_child_terrs (p_terr_id NUMBER) IS
8098: select jta.terr_id
8099: from JTF_TERR_ALL jta
8100: where jta.parent_territory_id = p_terr_Id;
8101:
8102: BEGIN
8103:

Line 8203: update JTF_TERR_ALL

8199: x_Msg_Count => l_msg_count,
8200: x_Msg_Data => l_msg_data,
8201: x_terr_id => l_terr_id );
8202:
8203: update JTF_TERR_ALL
8204: set parent_territory_id = l_new_terr_id
8205: where terr_id = l_terr_id;
8206:
8207: end loop;

Line 8678: FROM jtf_terr_ALL j

8674: ** 09/17/00 JDOCHERT BUG#1408610 FIX
8675: */
8676: CURSOR csr_chk_num_winners (lp_terr_id NUMBER) IS
8677: SELECT 'X'
8678: FROM jtf_terr_ALL j
8679: WHERE j.parent_territory_id = 1
8680: AND j.terr_id = lp_terr_id;
8681:
8682: l_return_csr VARCHAR2(1);

Line 8747: FROM jtf_terr_all jt

8743: AS
8744:
8745: CURSOR csr_get_terr_num (lp_terr_id NUMBER) IS
8746: SELECT COUNT(*)
8747: FROM jtf_terr_all jt
8748: CONNECT BY PRIOR jt.terr_id = jt.parent_territory_id
8749: START WITH jt.terr_id = lp_terr_id;
8750:
8751: BEGIN

Line 8941: FROM jtf_terr_all jt

8937: IF (G_Debug) THEN
8938:
8939: SELECT COUNT(*)
8940: INTO l_hier_terr_count
8941: FROM jtf_terr_all jt
8942: CONNECT BY PRIOR jt.terr_id = jt.parent_territory_id
8943: START WITH jt.terr_id = p_copy_source_terr_Id;
8944:
8945: Write_Log(2, ' ');

Line 8947: Write_Log(2, 'Populating JTF_TERR_ALL table. Copied ' || l_hier_terr_count || ' territories.');

8943: START WITH jt.terr_id = p_copy_source_terr_Id;
8944:
8945: Write_Log(2, ' ');
8946: Write_Log(2, '/***************** BEGIN: COPY TERRITORY STATUS *********************/');
8947: Write_Log(2, 'Populating JTF_TERR_ALL table. Copied ' || l_hier_terr_count || ' territories.');
8948: Write_Log(2, 'Inserted ' || l_hier_terr_count || ' rows into JTF_TERR_ALL ');
8949: Write_Log(2, '/***************** END: COPY TERRITORY STATUS *********************/');
8950:
8951: END IF;

Line 8948: Write_Log(2, 'Inserted ' || l_hier_terr_count || ' rows into JTF_TERR_ALL ');

8944:
8945: Write_Log(2, ' ');
8946: Write_Log(2, '/***************** BEGIN: COPY TERRITORY STATUS *********************/');
8947: Write_Log(2, 'Populating JTF_TERR_ALL table. Copied ' || l_hier_terr_count || ' territories.');
8948: Write_Log(2, 'Inserted ' || l_hier_terr_count || ' rows into JTF_TERR_ALL ');
8949: Write_Log(2, '/***************** END: COPY TERRITORY STATUS *********************/');
8950:
8951: END IF;
8952:

Line 9076: FROM jtf_terr_all j

9072: BEGIN
9073:
9074: SELECT j.parent_territory_id
9075: INTO l_existing_parent_terr_id
9076: FROM jtf_terr_all j
9077: WHERE j.terr_id = p_terr_all_rec.terr_id;
9078:
9079: EXCEPTION
9080: WHEN NO_DATA_FOUND THEN

Line 9092: FROM jtf_terr_all j

9088: ** of the current territory
9089: */
9090: SELECT COUNT(*)
9091: INTO l_return_csr
9092: FROM jtf_terr_all j
9093: WHERE j.terr_id = p_terr_all_rec.parent_territory_id -- new parent territory id
9094: CONNECT BY PRIOR j.terr_id = j.parent_territory_id
9095: START WITH j.terr_id = p_terr_all_rec.terr_id; -- territory_id
9096: