APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERR_ALL

Line 1265: FROM JTF_TERR_ALL JTA,

1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: SELECT JSA.RSC_LOV_SQL
1264: INTO l_rsc_lov_sql
1265: FROM JTF_TERR_ALL JTA,
1266: JTF_TERR_USGS_ALL JTU,
1267: JTF_SOURCES_ALL JSA
1268: WHERE JTA.TERR_ID = P_TerrRsc_Rec.Terr_Id
1269: AND JTA.TERR_ID = JTU.TERR_ID

Line 1347: FROM JTF_TERR_ALL JTA,

1343:
1344: BEGIN
1345: SELECT JSA.RSC_LOV_SQL
1346: INTO l_rsc_lov_sql
1347: FROM JTF_TERR_ALL JTA,
1348: JTF_TERR_RSC_ALL JTR,
1349: JTF_TERR_USGS_ALL JTU,
1350: JTF_SOURCES_ALL JSA
1351: WHERE JTR.terr_rsc_id = P_TerrRsc_Rec.Terr_Rsc_Id

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

2412: -- Validate the territory Id
2413: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
2414: If l_Validate_id <> FND_API.G_MISS_NUM Then
2415: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
2416: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2417: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2419: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2420: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

Line 2477: FROM jtf_terr_all jta

2473: BEGIN
2474:
2475: SELECT jta.start_date_active,jta.end_date_active
2476: INTO l_terr_start_date,l_terr_end_date
2477: FROM jtf_terr_all jta
2478: WHERE jta.terr_id = l_terr_id ;
2479:
2480: -- Validate start date .
2481: IF ( l_res_start_date_active < l_terr_start_date ) OR ( l_res_start_date_active > l_terr_end_date ) THEN

Line 3210: from JTF_TERR_ALL

3206: l_Terr_Id := p_TerrRsc_Tbl(l_res_counter).Terr_Id;
3207: --
3208: --dbms_output.put_line('Inside the for loop. Before validating Terr_Id');
3209: Select 'X' into l_temp
3210: from JTF_TERR_ALL
3211: where TERR_ID = p_TerrRsc_Tbl(l_res_counter).Terr_Id;
3212: --
3213: --
3214: End LOOP;

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

3487: -- Validate the territory Id
3488: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
3489: If l_Validate_id IS NOT NULL Then
3490: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3491: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
3492: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3494: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3495: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

Line 3598: FROM jtf_terr_all jta

3594: BEGIN
3595:
3596: SELECT jta.start_date_active,jta.end_date_active
3597: INTO l_terr_start_date,l_terr_end_date
3598: FROM jtf_terr_all jta
3599: WHERE jta.terr_id = p_TerrRsc_Rec.Terr_Id ;
3600:
3601: -- Validate start date .
3602: IF ( p_TerrRsc_Rec.START_DATE_ACTIVE < l_terr_start_date ) OR ( p_TerrRsc_Rec.START_DATE_ACTIVE > l_terr_end_date ) THEN

Line 4726: from jtf_terr_rsc_ALL j, jtf_terr_ALL jt

4722: l_terr_ids_tbl Terr_Ids_Tbl_Type;
4723:
4724: CURSOR csr_terr_rsc(l_resource_id NUMBER, l_resource_type VARCHAR) IS
4725: select j.terr_id
4726: from jtf_terr_rsc_ALL j, jtf_terr_ALL jt
4727: where j.resource_id = l_resource_id
4728: and j.resource_type = l_resource_type
4729: and j.terr_id = jt.terr_id
4730: and jt.template_flag = 'N'

Line 4738: from JTF_TERR_ALL jt

4734: and not jt.terr_id = 1;
4735:
4736: CURSOR csr_unassigned_terrs IS
4737: select terr_id
4738: from JTF_TERR_ALL jt
4739: where NOT EXISTS (select jtr.terr_id
4740: from jtf_terr_rsc_ALL jtr
4741: where jt.terr_id = jtr.terr_id
4742: )