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_PVT

Line 389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

385: l_qualifier NUMBER;
386:
387: x_terr_id NUMBER;
388:
389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

386:
387: x_terr_id NUMBER;
388:
389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:

Line 391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

387: x_terr_id NUMBER;
388:
389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:
395: /* Customer Name Range + Postal Code Qualifier Support */

Line 392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

388:
389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:
395: /* Customer Name Range + Postal Code Qualifier Support */
396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

389: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
390: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
391: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:
395: /* Customer Name Range + Postal Code Qualifier Support */
396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;

392: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:
395: /* Customer Name Range + Postal Code Qualifier Support */
396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
398: /* DUNS# Qualifier Support */
399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;

393: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
394:
395: /* Customer Name Range + Postal Code Qualifier Support */
396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
398: /* DUNS# Qualifier Support */
399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:

Line 399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;

395: /* Customer Name Range + Postal Code Qualifier Support */
396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
398: /* DUNS# Qualifier Support */
399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

Line 400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;

396: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
398: /* DUNS# Qualifier Support */
399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

398: /* DUNS# Qualifier Support */
399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:

Line 403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

399: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

Line 404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

400: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
408: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

Line 405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

401:
402: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_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;

Line 407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

403: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_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:

Line 408: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

404: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_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;

Line 409: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

405: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_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 ;

Line 410: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

406:
407: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_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;

Line 1046: jtf_territory_pvt.create_territory (

1042: --MO_GLOBAL.SET_ORG_CONTEXT(TERR_GROUP.ORG_ID, NULL);
1043: --
1044:
1045: /* CALL CREATE TERRITORY API */
1046: jtf_territory_pvt.create_territory (
1047: p_api_version_number => l_api_version_number,
1048: p_init_msg_list => l_init_msg_list,
1049: p_commit => l_commit,
1050: p_validation_level => fnd_api.g_valid_level_NONE,

Line 1290: jtf_territory_pvt.create_territory (

1286:
1287: -- 07/08/03: JDOCHERT: bug#3023653
1288: -- mo_global.set_org_context(terr_group.ORG_ID,null);
1289: --
1290: jtf_territory_pvt.create_territory (
1291: p_api_version_number => l_api_version_number,
1292: p_init_msg_list => l_init_msg_list,
1293: p_commit => l_commit,
1294: p_validation_level => fnd_api.g_valid_level_NONE,

Line 1666: jtf_territory_pvt.create_territory (

1662: -- 07/08/03: JDOCHERT: bug#3023653
1663: --mo_global.set_org_context(terr_group.ORG_ID,null);
1664: --
1665:
1666: jtf_territory_pvt.create_territory (
1667: p_api_version_number => l_api_version_number,
1668: p_init_msg_list => l_init_msg_list,
1669: p_commit => l_commit,
1670: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2056: jtf_territory_pvt.create_territory (

2052: -- 07/08/03: JDOCHERT: bug#3023653
2053: --mo_global.set_org_context(terr_group.ORG_ID,null);
2054: --
2055:
2056: jtf_territory_pvt.create_territory (
2057: p_api_version_number => l_api_version_number,
2058: p_init_msg_list => l_init_msg_list,
2059: p_commit => l_commit,
2060: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2454: jtf_territory_pvt.create_territory (

2450:
2451: -- 07/08/03: JDOCHERT: bug#3023653
2452: --mo_global.set_org_context(terr_group.ORG_ID,null);
2453: --
2454: jtf_territory_pvt.create_territory (
2455: p_api_version_number => l_api_version_number,
2456: p_init_msg_list => l_init_msg_list,
2457: p_commit => l_commit,
2458: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2647: jtf_territory_pvt.create_territory (

2643: -- 07/08/03: JDOCHERT: bug#3023653
2644: --mo_global.set_org_context(terr_group.ORG_ID,null);
2645: --
2646:
2647: jtf_territory_pvt.create_territory (
2648: p_api_version_number => l_api_version_number,
2649: p_init_msg_list => l_init_msg_list,
2650: p_commit => l_commit,
2651: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2889: jtf_territory_pvt.create_territory (

2885: -- 07/08/03: JDOCHERT: bug#3023653
2886: --mo_global.set_org_context(terr_group.ORG_ID,null);
2887: --
2888:
2889: jtf_territory_pvt.create_territory (
2890: p_api_version_number => l_api_version_number,
2891: p_init_msg_list => l_init_msg_list,
2892: p_commit => l_commit,
2893: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3228: jtf_territory_pvt.create_territory (

3224: -- 07/08/03: JDOCHERT: bug#3023653
3225: --mo_global.set_org_context(terr_group.ORG_ID,null);
3226: --
3227:
3228: jtf_territory_pvt.create_territory (
3229: p_api_version_number => l_api_version_number,
3230: p_init_msg_list => l_init_msg_list,
3231: p_commit => l_commit,
3232: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3471: jtf_territory_pvt.create_territory (

3467:
3468: --mo_global.set_org_context(204,null);
3469: --AS_UTILITY_PVT.file_debug(' winners # '||terr_group.NUM_WINNERS);
3470: --AS_UTILITY_PVT.file_debug(' migration of territory_group # '||terr_group.TERRITORY_GROUP_ID);
3471: jtf_territory_pvt.create_territory (
3472: p_api_version_number => l_api_version_number,
3473: p_init_msg_list => l_init_msg_list,
3474: p_commit => l_commit,
3475: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

3722: , x_return_status OUT NOCOPY VARCHAR2
3723: , x_error_message OUT NOCOPY VARCHAR2
3724: ) IS
3725:
3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_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;

Line 3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

3723: , x_error_message OUT NOCOPY VARCHAR2
3724: ) IS
3725:
3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_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:

Line 3728: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

3724: ) IS
3725:
3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_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;

Line 3729: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

3725:
3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_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 ;

Line 3730: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

3726: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
3727: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_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;

Line 3737: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_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;
3740: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3741:

Line 3738: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_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;
3740: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3741:
3742:

Line 3739: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_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;
3740: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3741:
3742:
3743: i NUMBER;

Line 3740: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_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;
3740: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
3741:
3742:
3743: i NUMBER;
3744: j NUMBER;

Line 3771: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

3767:
3768: l_pi_count NUMBER := 0;
3769: l_prev_qual_usg_id NUMBER;
3770:
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;

Line 3772: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

3768: l_pi_count NUMBER := 0;
3769: l_prev_qual_usg_id NUMBER;
3770:
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;

Line 3773: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

3769: l_prev_qual_usg_id NUMBER;
3770:
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:

Line 3774: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

3770:
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;

Line 4265: jtf_territory_pvt.create_territory (

4261:
4262: l_init_msg_list :=FND_API.G_TRUE;
4263:
4264: if l_prev_qual_usg_id <> 1 then -- geography territory values are there if this condition is true
4265: jtf_territory_pvt.create_territory (
4266: p_api_version_number => l_api_version_number,
4267: p_init_msg_list => l_init_msg_list,
4268: p_commit=> l_commit,
4269: p_validation_level => fnd_api.g_valid_level_NONE,

Line 4637: jtf_territory_pvt.create_territory (

4633: -- 07/08/03: JDOCHERT: bug#3023653
4634: --mo_global.set_org_context(p_terr_group_rec.ORG_ID,null);
4635: --
4636:
4637: jtf_territory_pvt.create_territory (
4638: p_api_version_number => l_api_version_number,
4639: p_init_msg_list => l_init_msg_list,
4640: p_commit => l_commit,
4641: p_validation_level => fnd_api.g_valid_level_NONE,

Line 4825: jtf_territory_pvt.create_territory (

4821:
4822: l_init_msg_list :=FND_API.G_TRUE;
4823:
4824:
4825: jtf_territory_pvt.create_territory (
4826: p_api_version_number => l_api_version_number,
4827: p_init_msg_list => l_init_msg_list,
4828: p_commit => l_commit,
4829: p_validation_level => fnd_api.g_valid_level_NONE,

Line 5061: jtf_territory_pvt.create_territory (

5057: end loop; /* acc_type */
5058:
5059: l_init_msg_list :=FND_API.G_TRUE;
5060:
5061: jtf_territory_pvt.create_territory (
5062: p_api_version_number => l_api_version_number,
5063: p_init_msg_list => l_init_msg_list,
5064: p_commit => l_commit,
5065: p_validation_level => fnd_api.g_valid_level_NONE,