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_GEN_TERR_PVT dependencies on JTF_TERRITORY_PVT

Line 914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

910: ,p_terr_id IN g_terr_id_tab
911: ,p_overlay_top IN g_terr_id_tab)
912: IS
913:
914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

911: ,p_overlay_top IN g_terr_id_tab)
912: IS
913:
914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
919: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

Line 916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

912: IS
913:
914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
919: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
920: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

913:
914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
919: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
920: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
921:

Line 918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

914: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
915: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
916: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
917: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
918: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
919: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
920: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
921:
922: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

Line 924: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

920: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
921:
922: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
924: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
925: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
928:

Line 925: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

921:
922: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
924: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
925: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
928:
929: TYPE role_typ IS RECORD(

Line 926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

922: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
924: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
925: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
928:
929: TYPE role_typ IS RECORD(
930: grp_role_id NUMBER:=FND_API.G_MISS_NUM

Line 927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
924: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
925: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
928:
929: TYPE role_typ IS RECORD(
930: grp_role_id NUMBER:=FND_API.G_MISS_NUM
931: );

Line 966: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

962: l_pi_count NUMBER := 0;
963: l_prev_qual_usg_id NUMBER;
964: l_na_count NUMBER;
965:
966: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
967: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
968: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
969: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
970: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

Line 967: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

963: l_prev_qual_usg_id NUMBER;
964: l_na_count NUMBER;
965:
966: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
967: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
968: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
969: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
970: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
971: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

Line 968: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

964: l_na_count NUMBER;
965:
966: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
967: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
968: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
969: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
970: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
971: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
972:

Line 969: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

965:
966: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
967: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
968: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
969: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
970: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
971: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
972:
973: x_terr_id NUMBER;

Line 1583: JTF_TERRITORY_PVT.create_territory (

1579:
1580: l_init_msg_list := FND_API.G_TRUE;
1581:
1582: IF l_prev_qual_usg_id <> 1 THEN -- geography territory values are there if this condition is true
1583: JTF_TERRITORY_PVT.create_territory (
1584: p_api_version_number => l_api_version_number,
1585: p_init_msg_list => l_init_msg_list,
1586: p_commit => l_commit,
1587: p_validation_level => FND_API.g_valid_level_NONE,

Line 1937: JTF_TERRITORY_PVT.create_territory (

1933: END LOOP; /* gval */
1934:
1935: l_init_msg_list :=FND_API.G_TRUE;
1936:
1937: JTF_TERRITORY_PVT.create_territory (
1938: p_api_version_number => l_api_version_number,
1939: p_init_msg_list => l_init_msg_list,
1940: p_commit => l_commit,
1941: p_validation_level => FND_API.g_valid_level_NONE,

Line 2175: JTF_TERRITORY_PVT.create_territory (

2171: END LOOP; /* end for acc_type in role_access */
2172:
2173: l_init_msg_list :=FND_API.G_TRUE;
2174:
2175: JTF_TERRITORY_PVT.create_territory (
2176: p_api_version_number => l_api_version_number,
2177: p_init_msg_list => l_init_msg_list,
2178: p_commit => l_commit,
2179: p_validation_level => FND_API.g_valid_level_NONE,

Line 2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

2407: ,p_org_id IN g_org_id_tab
2408: ,p_change_type IN g_change_type_tab)
2409: IS
2410:
2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

2408: ,p_change_type IN g_change_type_tab)
2409: IS
2410:
2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2416: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

Line 2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

2409: IS
2410:
2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2416: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2417: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

2410:
2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2416: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2417: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2418:

Line 2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

2411: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
2412: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2413: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2414: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2415: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2416: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2417: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2418:
2419: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

Line 2421: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

2417: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2418:
2419: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2421: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2422: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2425:

Line 2422: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

2418:
2419: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2421: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2422: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2425:
2426: TYPE role_typ IS RECORD(

Line 2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

2419: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2421: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2422: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2425:
2426: TYPE role_typ IS RECORD(
2427: grp_role_id NUMBER:=FND_API.G_MISS_NUM

Line 2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
2421: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
2422: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2425:
2426: TYPE role_typ IS RECORD(
2427: grp_role_id NUMBER:=FND_API.G_MISS_NUM
2428: );

Line 2462: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

2458: l_pi_count NUMBER := 0;
2459: l_prev_qual_usg_id NUMBER;
2460: l_na_count NUMBER;
2461:
2462: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
2463: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
2464: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
2465: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
2466: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

Line 2463: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

2459: l_prev_qual_usg_id NUMBER;
2460: l_na_count NUMBER;
2461:
2462: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
2463: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
2464: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
2465: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
2466: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
2467: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

Line 2464: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

2460: l_na_count NUMBER;
2461:
2462: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
2463: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
2464: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
2465: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
2466: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
2467: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
2468:

Line 2465: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

2461:
2462: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
2463: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
2464: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
2465: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
2466: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
2467: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
2468:
2469: x_terr_id NUMBER;

Line 3011: JTF_TERRITORY_PVT.create_territory (

3007:
3008: l_init_msg_list := FND_API.G_TRUE;
3009:
3010: /* CALL CREATE TERRITORY API */
3011: JTF_TERRITORY_PVT.create_territory (
3012: p_api_version_number => l_api_version_number,
3013: p_init_msg_list => l_init_msg_list,
3014: p_commit => l_commit,
3015: p_validation_level => FND_API.g_valid_level_NONE,

Line 3242: JTF_TERRITORY_PVT.create_territory (

3238:
3239: l_init_msg_list := FND_API.G_TRUE;
3240:
3241: IF l_prev_qual_usg_id <> 1 THEN -- geography territory values are there if this condition is true
3242: JTF_TERRITORY_PVT.create_territory (
3243: p_api_version_number => l_api_version_number,
3244: p_init_msg_list => l_init_msg_list,
3245: p_commit => l_commit,
3246: p_validation_level => FND_API.g_valid_level_NONE,

Line 3612: JTF_TERRITORY_PVT.create_territory (

3608: END LOOP; /* csr_qual IN csr_get_qual */
3609:
3610: l_init_msg_list :=FND_API.G_TRUE;
3611:
3612: JTF_TERRITORY_PVT.create_territory (
3613: p_api_version_number => l_api_version_number,
3614: p_init_msg_list => l_init_msg_list,
3615: p_commit => l_commit,
3616: p_validation_level => FND_API.g_valid_level_NONE,

Line 3793: JTF_TERRITORY_PVT.create_territory (

3789: END LOOP; /* gval */
3790:
3791: l_init_msg_list :=FND_API.G_TRUE;
3792:
3793: JTF_TERRITORY_PVT.create_territory (
3794: p_api_version_number => l_api_version_number,
3795: p_init_msg_list => l_init_msg_list,
3796: p_commit => l_commit,
3797: p_validation_level => FND_API.g_valid_level_NONE,

Line 4031: JTF_TERRITORY_PVT.create_territory (

4027: END LOOP; /* end for acc_type in role_access */
4028:
4029: l_init_msg_list :=FND_API.G_TRUE;
4030:
4031: JTF_TERRITORY_PVT.create_territory (
4032: p_api_version_number => l_api_version_number,
4033: p_init_msg_list => l_init_msg_list,
4034: p_commit => l_commit,
4035: p_validation_level => FND_API.g_valid_level_NONE,

Line 4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

4328: k NUMBER;
4329: l NUMBER;
4330: a NUMBER;
4331:
4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

4329: l NUMBER;
4330: a NUMBER;
4331:
4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:

Line 4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

4330: a NUMBER;
4331:
4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

Line 4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

4331:
4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

Line 4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

4332: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
4333: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

4334: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:

Line 4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

4335: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

Line 4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

4336: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

Line 4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

4337:
4338: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

Line 4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

4339: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
4346: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
4347:

Line 4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

4340: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
4346: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
4347:
4348: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

Line 4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

4341: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
4346: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
4347:
4348: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4349: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 4346: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

4342:
4343: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
4344: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
4345: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
4346: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
4347:
4348: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4349: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4350:

Line 4827: JTF_TERRITORY_PVT.Create_Terr_Value(

4823: END IF;
4824: END LOOP;
4825:
4826:
4827: JTF_TERRITORY_PVT.Create_Terr_Value(
4828: P_Api_Version_Number => l_Api_Version_Number,
4829: P_Init_Msg_List => l_Init_Msg_List,
4830: P_Commit => l_Commit,
4831: p_validation_level => FND_API.g_valid_level_NONE,

Line 5089: JTF_TERRITORY_PVT.create_territory (

5085: END LOOP; /* qval IN pqual */
5086:
5087: l_init_msg_list :=FND_API.G_TRUE;
5088:
5089: JTF_TERRITORY_PVT.create_territory (
5090: p_api_version_number => l_api_version_number,
5091: p_init_msg_list => l_init_msg_list,
5092: p_commit => l_commit,
5093: p_validation_level => FND_API.g_valid_level_NONE,

Line 5469: JTF_TERRITORY_PVT.create_territory (

5465: END LOOP; /* qval IN pqual */
5466:
5467: l_init_msg_list :=FND_API.G_TRUE;
5468:
5469: JTF_TERRITORY_PVT.create_territory (
5470: p_api_version_number => l_api_version_number,
5471: p_init_msg_list => l_init_msg_list,
5472: p_commit => l_commit,
5473: p_validation_level => FND_API.g_valid_level_NONE,

Line 5855: JTF_TERRITORY_PVT.create_territory (

5851: END LOOP;
5852:
5853: l_init_msg_list :=FND_API.G_TRUE;
5854:
5855: JTF_TERRITORY_PVT.create_territory (
5856: p_api_version_number => l_api_version_number,
5857: p_init_msg_list => l_init_msg_list,
5858: p_commit => l_commit,
5859: p_validation_level => FND_API.g_valid_level_NONE,

Line 6128: JTF_TERRITORY_PVT.create_territory (

6124: END LOOP;
6125:
6126: l_init_msg_list :=FND_API.G_TRUE;
6127:
6128: JTF_TERRITORY_PVT.create_territory (
6129: p_api_version_number => l_api_version_number,
6130: p_init_msg_list => l_init_msg_list,
6131: p_commit => l_commit,
6132: p_validation_level => FND_API.g_valid_level_NONE,

Line 6452: JTF_TERRITORY_PVT.create_territory (

6448: END LOOP;
6449:
6450: l_init_msg_list :=FND_API.G_TRUE;
6451:
6452: JTF_TERRITORY_PVT.create_territory (
6453: p_api_version_number => l_api_version_number,
6454: p_init_msg_list => l_init_msg_list,
6455: p_commit => l_commit,
6456: p_validation_level => FND_API.g_valid_level_NONE,

Line 6709: JTF_TERRITORY_PVT.create_territory (

6705: END LOOP;
6706:
6707: l_init_msg_list :=FND_API.G_TRUE;
6708:
6709: JTF_TERRITORY_PVT.create_territory (
6710: p_api_version_number => l_api_version_number,
6711: p_init_msg_list => l_init_msg_list,
6712: p_commit => l_commit,
6713: p_validation_level => FND_API.g_valid_level_NONE,

Line 7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

7034: k NUMBER;
7035: l NUMBER;
7036: a NUMBER;
7037:
7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

7035: l NUMBER;
7036: a NUMBER;
7037:
7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:

Line 7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

7036: a NUMBER;
7037:
7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

Line 7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

7037:
7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

Line 7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

7038: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
7039: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

7040: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:

Line 7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

7041: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

Line 7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

7042: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

Line 7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

7043:
7044: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

Line 7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

7045: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
7052: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
7053:

Line 7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

7046: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
7052: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
7053:
7054: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

Line 7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

7047: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
7052: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
7053:
7054: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7055: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 7052: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

7048:
7049: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
7050: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
7051: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
7052: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
7053:
7054: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7055: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7056:

Line 7690: JTF_TERRITORY_PVT.create_territory (

7686: END IF;
7687:
7688: l_init_msg_list := FND_API.G_TRUE;
7689: /* CALL CREATE TERRITORY API */
7690: JTF_TERRITORY_PVT.create_territory (
7691: p_api_version_number => l_api_version_number,
7692: p_init_msg_list => l_init_msg_list,
7693: p_commit => l_commit,
7694: p_validation_level => FND_API.g_valid_level_NONE,

Line 7901: JTF_TERRITORY_PVT.create_territory (

7897: END LOOP;
7898:
7899: l_init_msg_list := FND_API.G_TRUE;
7900:
7901: JTF_TERRITORY_PVT.create_territory (
7902: p_api_version_number => l_api_version_number,
7903: p_init_msg_list => l_init_msg_list,
7904: p_commit => l_commit,
7905: p_validation_level => FND_API.g_valid_level_NONE,

Line 8307: JTF_TERRITORY_PVT.create_territory (

8303: END LOOP; /* qval IN pqual */
8304:
8305: l_init_msg_list :=FND_API.G_TRUE;
8306:
8307: JTF_TERRITORY_PVT.create_territory (
8308: p_api_version_number => l_api_version_number,
8309: p_init_msg_list => l_init_msg_list,
8310: p_commit => l_commit,
8311: p_validation_level => FND_API.g_valid_level_NONE,

Line 8686: JTF_TERRITORY_PVT.create_territory (

8682: END LOOP; /* qval IN pqual */
8683:
8684: l_init_msg_list :=FND_API.G_TRUE;
8685:
8686: JTF_TERRITORY_PVT.create_territory (
8687: p_api_version_number => l_api_version_number,
8688: p_init_msg_list => l_init_msg_list,
8689: p_commit => l_commit,
8690: p_validation_level => FND_API.g_valid_level_NONE,

Line 9058: JTF_TERRITORY_PVT.create_territory (

9054: END LOOP; /* csr_qual IN csr_get_qual */
9055:
9056: l_init_msg_list :=FND_API.G_TRUE;
9057:
9058: JTF_TERRITORY_PVT.create_territory (
9059: p_api_version_number => l_api_version_number,
9060: p_init_msg_list => l_init_msg_list,
9061: p_commit => l_commit,
9062: p_validation_level => FND_API.g_valid_level_NONE,

Line 9257: JTF_TERRITORY_PVT.create_territory (

9253: END LOOP;
9254:
9255: l_init_msg_list :=FND_API.G_TRUE;
9256:
9257: JTF_TERRITORY_PVT.create_territory (
9258: p_api_version_number => l_api_version_number,
9259: p_init_msg_list => l_init_msg_list,
9260: p_commit => l_commit,
9261: p_validation_level => FND_API.g_valid_level_NONE,

Line 9526: JTF_TERRITORY_PVT.create_territory (

9522: END LOOP;
9523:
9524: l_init_msg_list :=FND_API.G_TRUE;
9525:
9526: JTF_TERRITORY_PVT.create_territory (
9527: p_api_version_number => l_api_version_number,
9528: p_init_msg_list => l_init_msg_list,
9529: p_commit => l_commit,
9530: p_validation_level => FND_API.g_valid_level_NONE,

Line 9853: JTF_TERRITORY_PVT.create_territory (

9849: END LOOP;
9850:
9851: l_init_msg_list :=FND_API.G_TRUE;
9852:
9853: JTF_TERRITORY_PVT.create_territory (
9854: p_api_version_number => l_api_version_number,
9855: p_init_msg_list => l_init_msg_list,
9856: p_commit => l_commit,
9857: p_validation_level => FND_API.g_valid_level_NONE,

Line 10110: JTF_TERRITORY_PVT.create_territory (

10106: END LOOP;
10107:
10108: l_init_msg_list :=FND_API.G_TRUE;
10109:
10110: JTF_TERRITORY_PVT.create_territory (
10111: p_api_version_number => l_api_version_number,
10112: p_init_msg_list => l_init_msg_list,
10113: p_commit => l_commit,
10114: p_validation_level => FND_API.g_valid_level_NONE,

Line 12809: JTF_TERRITORY_PVT.Delete_Territory

12805: JTF_TTY_NA_TERRGP.delete_terrgp(c.TERR_GROUP_ID);
12806: END LOOP;
12807:
12808:
12809: JTF_TERRITORY_PVT.Delete_Territory
12810: ( 1.0,
12811: NULL,
12812: 'T',
12813: 0,