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_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERRITORY_RESOURCE_PVT

Line 412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

408: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
409: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
410: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
411:
412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;

Line 413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;

409: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
410: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
411:
412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;

Line 414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

410: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
411:
412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
418:

Line 415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;

411:
412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
418:
419: l_commitcount NUMBER := 1000;

Line 416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;

412: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
418:
419: l_commitcount NUMBER := 1000;
420: l_row_inserted NUMBER := 0;

Line 417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;

413: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
414: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
415: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
416: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
417: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
418:
419: l_commitcount NUMBER := 1000;
420: l_row_inserted NUMBER := 0;
421: l_pi_count NUMBER := 0;

Line 1412: jtf_territory_resource_pvt.create_terrresource (

1408:
1409: l_init_msg_list := FND_API.G_TRUE;
1410:
1411: -- 07/08/03: JDOCHERT: bug#3023653
1412: jtf_territory_resource_pvt.create_terrresource (
1413: p_api_version_number => l_Api_Version_Number,
1414: p_init_msg_list => l_Init_Msg_List,
1415: p_commit => l_Commit,
1416: p_validation_level => fnd_api.g_valid_level_NONE,

Line 1804: jtf_territory_resource_pvt.create_terrresource (

1800:
1801: l_init_msg_list :=FND_API.G_TRUE;
1802:
1803: -- 07/08/03: JDOCHERT: bug#3023653
1804: jtf_territory_resource_pvt.create_terrresource (
1805: p_api_version_number => l_Api_Version_Number,
1806: p_init_msg_list => l_Init_Msg_List,
1807: p_commit => l_Commit,
1808: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2196: jtf_territory_resource_pvt.create_terrresource (

2192:
2193: l_init_msg_list :=FND_API.G_TRUE;
2194:
2195: -- 07/08/03: JDOCHERT: bug#3023653
2196: jtf_territory_resource_pvt.create_terrresource (
2197: p_api_version_number => l_Api_Version_Number,
2198: p_init_msg_list => l_Init_Msg_List,
2199: p_commit => l_Commit,
2200: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3035: jtf_territory_resource_pvt.create_terrresource (

3031:
3032: l_init_msg_list :=FND_API.G_TRUE;
3033:
3034: -- 07/08/03: JDOCHERT: bug#3023653
3035: jtf_territory_resource_pvt.create_terrresource (
3036: p_api_version_number => l_Api_Version_Number,
3037: p_init_msg_list => l_Init_Msg_List,
3038: p_commit => l_Commit,
3039: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3619: jtf_territory_resource_pvt.create_terrresource (

3615:
3616: l_init_msg_list :=FND_API.G_TRUE;
3617:
3618: -- 07/08/03: JDOCHERT: bug#3023653
3619: jtf_territory_resource_pvt.create_terrresource (
3620: p_api_version_number => l_Api_Version_Number,
3621: p_init_msg_list => l_Init_Msg_List,
3622: p_commit => l_Commit,
3623: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3732: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

3728: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
3729: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
3730: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3731:
3732: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3733: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3734: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3735: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3736:

Line 3733: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;

3729: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
3730: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3731:
3732: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3733: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3734: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3735: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3736:
3737: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

Line 3734: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

3730: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3731:
3732: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3733: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3734: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3735: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3736:
3737: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
3738: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

Line 3735: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;

3731:
3732: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3733: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3734: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
3735: l_TerrRsc_Access_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
3736:
3737: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
3738: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
3739: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 3775: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;

3771: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
3772: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
3773: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
3774: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
3775: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
3776: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
3777:
3778: x_terr_id NUMBER;
3779: x_msg_count number;

Line 3776: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;

3772: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
3773: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
3774: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
3775: x_TerrRsc_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_out_tbl_type;
3776: x_TerrRsc_Access_Out_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_out_tbl_type;
3777:
3778: x_terr_id NUMBER;
3779: x_msg_count number;
3780: x_msg_data varchar2(2000);

Line 4399: jtf_territory_resource_pvt.create_terrresource (

4395: end loop;/* FOR tran_type in role_interest_nonpi */
4396:
4397: l_init_msg_list :=FND_API.G_TRUE;
4398:
4399: jtf_territory_resource_pvt.create_terrresource (
4400: p_api_version_number => l_Api_Version_Number,
4401: p_init_msg_list => l_Init_Msg_List,
4402: p_commit => l_Commit,
4403: p_validation_level => fnd_api.g_valid_level_NONE,

Line 5181: jtf_territory_resource_pvt.create_terrresource (

5177: end loop; /* rsc in resource_grp */
5178:
5179: l_init_msg_list :=FND_API.G_TRUE;
5180:
5181: jtf_territory_resource_pvt.create_terrresource (
5182: p_api_version_number => l_Api_Version_Number,
5183: p_init_msg_list => l_Init_Msg_List,
5184: p_commit => l_Commit,
5185: p_validation_level => fnd_api.g_valid_level_NONE,