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 533: select terr_id from jtf_terr_all

529: v_Terr_Id NUMBER := p_Terr_Id;
530:
531: --Declare cursor to get usages
532: Cursor C_Terr IS
533: select terr_id from jtf_terr_all
534: connect by parent_territory_id = prior terr_id AND TERR_ID <> 1
535: start with terr_id = v_Terr_Id;
536:
537: CURSOR C_TERR_QUAL_IDS ( p_Terr_Id IN NUMBER) IS

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

618: -- Delete the Territory Resource records
619: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = c.Terr_Id;
620:
621: --Delete Territory record
622: DELETE from JTF_TERR_ALL WHERE TERR_ID = c.Terr_Id;
623:
624: --
625: END LOOP;
626:

Line 1041: From JTF_TERR_ALL

1037: ATTRIBUTE15,
1038: ORG_ID,
1039: NUM_WINNERS,
1040: NUM_QUAL
1041: From JTF_TERR_ALL
1042: Where TERR_ID = l_terr_id
1043: For Update NOWAIT;
1044:
1045: --Local variable declaration

Line 1403: UPDATE JTF_TERR_ALL

1399: X_Terr_Id => l_terr_id,
1400: X_Terr_All_Out_Rec => l_Terr_All_Out_Rec);
1401:
1402: ELSE
1403: UPDATE JTF_TERR_ALL
1404: SET terr_group_id = p_terr_all_rec.territory_group_id,
1405: LAST_UPDATED_BY = p_terr_all_rec.LAST_UPDATED_BY,
1406: LAST_UPDATE_LOGIN = p_terr_all_rec.LAST_UPDATE_LOGIN,
1407: NAME = p_terr_all_rec.NAME,

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

1547: -- start of comments
1548: -- ***************************************************
1549: -- API name : Create_Territory_record
1550: -- Type : PUBLIC
1551: -- Function : To create a records in jtf_Terr_all table
1552: --
1553: -- Pre-reqs :
1554: -- Parameters:
1555: -- IN :

Line 2364: UPDATE jtf_terr_ALL jt

2360: */
2361: PROCEDURE update_terr_num_qual(p_terr_id IN NUMBER, p_qual_type_id IN NUMBER) AS
2362: BEGIN
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

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

2878:
2879: -- Validate the territory Id
2880: If ( P_Terr_Qual_Rec.TERR_ID IS NOT NULL )AND (P_Terr_Qual_Rec.TERR_ID = FND_API.G_MISS_NUM ) Then
2881: --dbms_output('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
2882: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(P_Terr_Qual_Rec.TERR_ID, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2883: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2884: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2885: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2886: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');

Line 2886: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');

2882: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(P_Terr_Qual_Rec.TERR_ID, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2883: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2884: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2885: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2886: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');
2887: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
2888: FND_MSG_PUB.ADD;
2889: END IF;
2890: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3474: From JTF_TERR_ALL

3470: ATTRIBUTE15,
3471: ORG_ID,
3472: NUM_WINNERS,
3473: NUM_QUAL
3474: From JTF_TERR_ALL
3475: Where TERR_ID = l_terr_id
3476: For Update NOWAIT;
3477:
3478: --Local variable declaration

Line 5654: FROM jtf_terr_all jta,

5650: AND ROWNUM < 2; */
5651:
5652: SELECT 'x'
5653: INTO l_Temp
5654: FROM jtf_terr_all jta,
5655: jtf_terr_type_qual_all jtqa,
5656: jtf_qual_usgs_all jqua
5657: WHERE jta.terr_id = p_Terr_Id
5658: AND jta.territory_type_id = jtqa.terr_type_id

Line 5811: FROM JTF_TERR_ALL childterr,

5807: AND p_Terr_All_Rec.END_DATE_ACTIVE IS NOT NULL
5808: AND p_Terr_All_Rec.PARENT_TERRITORY_ID IS NOT NULL THEN
5809:
5810: Select count(*) INTO l_ter_name_count
5811: FROM JTF_TERR_ALL childterr,
5812: HR_OPERATING_UNITS hr,
5813: JTF_TERR_ALL parentterr
5814: WHERE childterr.org_id = hr.organization_id
5815: AND childterr.parent_territory_id = parentTerr.terr_id

Line 5813: JTF_TERR_ALL parentterr

5809:
5810: Select count(*) INTO l_ter_name_count
5811: FROM JTF_TERR_ALL childterr,
5812: HR_OPERATING_UNITS hr,
5813: JTF_TERR_ALL parentterr
5814: WHERE childterr.org_id = hr.organization_id
5815: AND childterr.parent_territory_id = parentTerr.terr_id
5816: AND childterr.org_id = parentTerr.org_id
5817: AND childterr.NAME = p_Terr_All_Rec.NAME

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

6104:
6105: -- Validate the territory Id
6106: l_Validate_id := p_Terr_All_Rec.TERR_ID;
6107: If l_Validate_id IS NOT NULL THEN
6108: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6109: --dbms_output('Validate_Territory_Usage: l_status <> FND_API.G_TRUE');
6110: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6111: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
6112: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

Line 6125: FROM JTF_TERR_ALL

6121: INTO l_ter_name,
6122: l_start_date_active,
6123: l_end_date_active,
6124: l_parent_territory_id
6125: FROM JTF_TERR_ALL
6126: WHERE TERR_ID = p_Terr_All_Rec.TERR_ID;
6127: -- Following values are used in finding the duplicate names.
6128: IF (p_Terr_All_Rec.START_DATE_ACTIVE IS NOT NULL AND p_Terr_All_Rec.START_DATE_ACTIVE <> FND_API.G_MISS_DATE ) THEN
6129: l_start_date_active := p_Terr_All_Rec.START_DATE_ACTIVE ;

Line 6153: FROM JTF_TERR_ALL childterr,

6149: AND l_end_date_active IS NOT NULL
6150: AND l_parent_territory_id IS NOT NULL THEN
6151:
6152: Select count(*) INTO l_ter_name_count
6153: FROM JTF_TERR_ALL childterr,
6154: HR_OPERATING_UNITS hr,
6155: JTF_TERR_ALL parentterr
6156: WHERE childterr.org_id = hr.organization_id
6157: AND childterr.parent_territory_id = parentTerr.terr_id

Line 6155: JTF_TERR_ALL parentterr

6151:
6152: Select count(*) INTO l_ter_name_count
6153: FROM JTF_TERR_ALL childterr,
6154: HR_OPERATING_UNITS hr,
6155: JTF_TERR_ALL parentterr
6156: WHERE childterr.org_id = hr.organization_id
6157: AND childterr.parent_territory_id = parentTerr.terr_id
6158: AND childterr.org_id = parentTerr.org_id
6159: AND childterr.NAME = p_Terr_All_Rec.NAME

Line 6194: FROM jtf_terr_all jta

6190: BEGIN
6191:
6192: SELECT jta.start_date_active,jta.end_date_active
6193: INTO l_pterr_start_date,l_pterr_end_date
6194: FROM jtf_terr_all jta
6195: WHERE jta.terr_id = l_parent_territory_id ;
6196:
6197: -- Validate Terr start date .
6198: IF ( l_start_date_active IS NOT NULL ) AND ( ( l_start_date_active < l_pterr_start_date ) OR ( l_start_date_active > l_pterr_end_date ) ) THEN

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

6362: Then
6363: --
6364: l_parent_terr_id := p_Terr_All_Rec.parent_territory_Id;
6365: --dbms_output('Validate_Foreign_Key: Returned from JTF_CTM_UTILITY_PVT.fk_id_is_valid');
6366: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6368: --dbms_output('PARENT Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_PARENT_TERR');
6370: FND_MESSAGE.Set_Token('TERR_ID', to_char(l_parent_terr_id));

Line 6381: FROM JTF_TERR_ALL

6377: IF (p_Terr_All_Rec.START_DATE_ACTIVE IS NOT NULL
6378: AND p_Terr_All_Rec.END_DATE_ACTIVE IS NOT NULL AND p_Terr_All_Rec.PARENT_TERRITORY_ID <> 1 ) THEN
6379:
6380: SELECT START_DATE_ACTIVE, END_DATE_ACTIVE INTO PSTART_DATE_ACTIVE, PEND_DATE_ACTIVE
6381: FROM JTF_TERR_ALL
6382: WHERE TERR_ID = p_Terr_All_Rec.PARENT_TERRITORY_ID;
6383:
6384: IF PSTART_DATE_ACTIVE is NOT NULL
6385: AND PSTART_DATE_ACTIVE > p_Terr_All_Rec.START_DATE_ACTIVE THEN

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

6441: --dbms_output('Validate_Foreign_Key: Checking for TEMPLATE_TERRITORY_ID');
6442: --
6443: iF (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID is not null) AND
6444: (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
6445: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TEMPLATE_TERRITORY_ID, 'TERR_ID', 'JTF_TERR_ALL');
6446: if l_status <> FND_API.G_TRUE Then
6447: x_return_status := FND_API.G_RET_STS_ERROR;
6448: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6449: --dbms_output('TEMP: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

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

6457: --dbms_output('Validate_Foreign_Key: Checking for ESCALATION_TERRITORY_ID');
6458: --
6459: If (p_Terr_All_Rec.ESCALATION_TERRITORY_ID is not null) AND
6460: (p_Terr_All_Rec.ESCALATION_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
6461: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.escalation_territory_id, 'TERR_ID', 'JTF_TERR_ALL');
6462: if l_status <> FND_API.G_TRUE Then
6463: x_return_status := FND_API.G_RET_STS_ERROR;
6464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6465: --dbms_output('ESC TERR: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

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

6515:
6516: -- Validate the territory Id
6517: If p_Terr_Id IS NOT NULL THEN
6518: l_Validate_id := p_Terr_Id;
6519: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6520: --dbms_output('Validate_Territory_Usage: l_status <> FND_API.G_TRUE');
6521: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6522: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
6523: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

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

6694: -- Validate the territory Id
6695: l_Validate_id := p_Terr_Id;
6696: If p_Terr_Id IS NOT NULL Then
6697: --dbms_output('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
6698: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6699: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6700: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6701: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6702: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');

Line 6702: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');

6698: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6699: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6700: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6701: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6702: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');
6703: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
6704: FND_MSG_PUB.ADD;
6705: END IF;
6706: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 7864: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu

7860: AS
7861: BEGIN
7862: Select Max(rank)
7863: into x_Rank
7864: from jtf_terr_ALL jt, jtf_terr_usgs_ALL jtu
7865: where jt.Parent_Territory_id = p_Parent_Terr_Id and
7866: jt.Terr_Id = jtu.Terr_Id and
7867: jtu.source_id = p_Source_Id;
7868:

Line 7907: FROM jtf_terr_ALL j

7903:
7904: /* (1) check template exists */
7905: CURSOR c_chk_template (p_template_terr_id NUMBER) IS
7906: SELECT 'X'
7907: FROM jtf_terr_ALL j
7908: WHERE j.terr_id = p_template_terr_id
7909: AND j.template_flag = 'Y';
7910:
7911:

Line 8602: FROM jtf_terr_ALL

8598:
8599: /* START OF 1520656 BUG FIX - JDOCHERT 12/07 */
8600: CURSOR c_get_terr(lp_terr_id NUMBER)
8601: IS SELECT 'Y'
8602: FROM jtf_terr_ALL
8603: WHERE template_flag = 'Y'
8604: AND terr_id = lp_terr_id;
8605:
8606: l_template_flag VARCHAR2(1);

Line 9663: from JTF_TERR_ALL jta

9659: l_tbl_count NUMBER;
9660:
9661: CURSOR csr_child_terrs (p_terr_id NUMBER) IS
9662: select jta.terr_id
9663: from JTF_TERR_ALL jta
9664: where jta.parent_territory_id = p_terr_Id;
9665:
9666: BEGIN
9667:

Line 9767: update JTF_TERR_ALL

9763: x_Msg_Count => l_msg_count,
9764: x_Msg_Data => l_msg_data,
9765: x_terr_id => l_terr_id );
9766:
9767: update JTF_TERR_ALL
9768: set parent_territory_id = l_new_terr_id
9769: where terr_id = l_terr_id;
9770:
9771: end loop;

Line 10242: FROM jtf_terr_ALL j

10238: ** 09/17/00 JDOCHERT BUG#1408610 FIX
10239: */
10240: CURSOR csr_chk_num_winners (lp_terr_id NUMBER) IS
10241: SELECT 'X'
10242: FROM jtf_terr_ALL j
10243: WHERE j.parent_territory_id = 1
10244: AND j.terr_id = lp_terr_id;
10245:
10246: l_return_csr VARCHAR2(1);

Line 10311: FROM jtf_terr_all jt

10307: AS
10308:
10309: CURSOR csr_get_terr_num (lp_terr_id NUMBER) IS
10310: SELECT COUNT(*)
10311: FROM jtf_terr_all jt
10312: CONNECT BY PRIOR jt.terr_id = jt.parent_territory_id
10313: START WITH jt.terr_id = lp_terr_id;
10314:
10315: BEGIN

Line 10505: FROM jtf_terr_all jt

10501: IF (G_Debug) THEN
10502:
10503: SELECT COUNT(*)
10504: INTO l_hier_terr_count
10505: FROM jtf_terr_all jt
10506: CONNECT BY PRIOR jt.terr_id = jt.parent_territory_id
10507: START WITH jt.terr_id = p_copy_source_terr_Id;
10508:
10509: Write_Log(2, ' ');

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

10507: START WITH jt.terr_id = p_copy_source_terr_Id;
10508:
10509: Write_Log(2, ' ');
10510: Write_Log(2, '/***************** BEGIN: COPY TERRITORY STATUS *********************/');
10511: Write_Log(2, 'Populating JTF_TERR_ALL table. Copied ' || l_hier_terr_count || ' territories.');
10512: Write_Log(2, 'Inserted ' || l_hier_terr_count || ' rows into JTF_TERR_ALL ');
10513: Write_Log(2, '/***************** END: COPY TERRITORY STATUS *********************/');
10514:
10515: END IF;

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

10508:
10509: Write_Log(2, ' ');
10510: Write_Log(2, '/***************** BEGIN: COPY TERRITORY STATUS *********************/');
10511: Write_Log(2, 'Populating JTF_TERR_ALL table. Copied ' || l_hier_terr_count || ' territories.');
10512: Write_Log(2, 'Inserted ' || l_hier_terr_count || ' rows into JTF_TERR_ALL ');
10513: Write_Log(2, '/***************** END: COPY TERRITORY STATUS *********************/');
10514:
10515: END IF;
10516:

Line 10640: FROM jtf_terr_all j

10636: BEGIN
10637:
10638: SELECT j.parent_territory_id
10639: INTO l_existing_parent_terr_id
10640: FROM jtf_terr_all j
10641: WHERE j.terr_id = p_terr_all_rec.terr_id;
10642:
10643: EXCEPTION
10644: WHEN NO_DATA_FOUND THEN

Line 10656: FROM jtf_terr_all j

10652: ** of the current territory
10653: */
10654: SELECT COUNT(*)
10655: INTO l_return_csr
10656: FROM jtf_terr_all j
10657: WHERE j.terr_id = p_terr_all_rec.parent_territory_id -- new parent territory id
10658: CONNECT BY PRIOR j.terr_id = j.parent_territory_id
10659: START WITH j.terr_id = p_terr_all_rec.terr_id; -- territory_id
10660: