DBA Data[Home] [Help]

APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERRITORY_PVT

Line 393: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;

389: l_qualifier NUMBER;
390:
391: x_terr_id NUMBER;
392:
393: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
394: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
395: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
396: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 394: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

390:
391: x_terr_id NUMBER;
392:
393: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
394: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
395: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
396: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
398:

Line 395: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

391: x_terr_id NUMBER;
392:
393: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
394: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
395: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
396: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
398:
399: /* Customer Name Range + Postal Code Qualifier Support */

Line 396: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

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

Line 397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

393: l_terr_all_rec JTF_TERRITORY_PVT.terr_all_rec_type;
394: l_terr_usgs_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
395: l_terr_qualtypeusgs_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
396: l_terr_qual_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
398:
399: /* Customer Name Range + Postal Code Qualifier Support */
400: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
401: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;

Line 400: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;

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

Line 401: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;

397: l_terr_values_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
398:
399: /* Customer Name Range + Postal Code Qualifier Support */
400: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
401: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
402: /* DUNS# Qualifier Support */
403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:

Line 403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;

399: /* Customer Name Range + Postal Code Qualifier Support */
400: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
401: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
402: /* DUNS# Qualifier Support */
403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

Line 404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;

400: l_terr_qual_tbl_mc1 JTF_TERRITORY_PVT.terr_qual_tbl_type;
401: l_terr_values_tbl_mc1 JTF_TERRITORY_PVT.terr_values_tbl_type;
402: /* DUNS# Qualifier Support */
403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

Line 406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;

402: /* DUNS# Qualifier Support */
403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:

Line 407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;

403: l_terr_qual_tbl_mc2 JTF_TERRITORY_PVT.terr_qual_tbl_type;
404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

Line 408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;

404: l_terr_values_tbl_mc2 JTF_TERRITORY_PVT.terr_values_tbl_type;
405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

Line 409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;

405:
406: l_terr_usgs_empty_tbl JTF_TERRITORY_PVT.terr_usgs_tbl_type;
407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

Line 411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;

407: l_terr_qualtypeusgs_empty_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_tbl_type;
408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
414: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
415:

Line 412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;

408: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
414: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
415:
416: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

Line 413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;

409: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
414: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
415:
416: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
417: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;

Line 414: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;

410:
411: x_terr_usgs_out_tbl JTF_TERRITORY_PVT.terr_usgs_out_tbl_type;
412: x_terr_qualtypeusgs_out_tbl JTF_TERRITORY_PVT.terr_qualtypeusgs_out_tbl_type;
413: x_terr_qual_out_tbl JTF_TERRITORY_PVT.terr_qual_out_tbl_type;
414: x_terr_values_out_tbl JTF_TERRITORY_PVT.terr_values_out_tbl_type;
415:
416: l_TerrRsc_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;
417: l_TerrRsc_Access_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrRsc_Access_tbl_type ;
418: l_TerrRsc_empty_Tbl JTF_TERRITORY_RESOURCE_PVT.TerrResource_tbl_type;

Line 1034: jtf_territory_pvt.create_territory (

1030: --MO_GLOBAL.SET_ORG_CONTEXT(TERR_GROUP.ORG_ID, NULL);
1031: --
1032:
1033: /* CALL CREATE TERRITORY API */
1034: jtf_territory_pvt.create_territory (
1035: p_api_version_number => l_api_version_number,
1036: p_init_msg_list => l_init_msg_list,
1037: p_commit => l_commit,
1038: p_validation_level => fnd_api.g_valid_level_NONE,

Line 1274: jtf_territory_pvt.create_territory (

1270:
1271: -- 07/08/03: JDOCHERT: bug#3023653
1272: --mo_global.set_org_context(terr_group.ORG_ID,null);
1273: --
1274: jtf_territory_pvt.create_territory (
1275: p_api_version_number => l_api_version_number,
1276: p_init_msg_list => l_init_msg_list,
1277: p_commit => l_commit,
1278: p_validation_level => fnd_api.g_valid_level_NONE,

Line 1650: jtf_territory_pvt.create_territory (

1646: -- 07/08/03: JDOCHERT: bug#3023653
1647: --mo_global.set_org_context(terr_group.ORG_ID,null);
1648: --
1649:
1650: jtf_territory_pvt.create_territory (
1651: p_api_version_number => l_api_version_number,
1652: p_init_msg_list => l_init_msg_list,
1653: p_commit => l_commit,
1654: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2044: jtf_territory_pvt.create_territory (

2040: -- 07/08/03: JDOCHERT: bug#3023653
2041: --mo_global.set_org_context(terr_group.ORG_ID,null);
2042: --
2043:
2044: jtf_territory_pvt.create_territory (
2045: p_api_version_number => l_api_version_number,
2046: p_init_msg_list => l_init_msg_list,
2047: p_commit => l_commit,
2048: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2443: jtf_territory_pvt.create_territory (

2439:
2440: -- 07/08/03: JDOCHERT: bug#3023653
2441: --mo_global.set_org_context(terr_group.ORG_ID,null);
2442: --
2443: jtf_territory_pvt.create_territory (
2444: p_api_version_number => l_api_version_number,
2445: p_init_msg_list => l_init_msg_list,
2446: p_commit => l_commit,
2447: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2637: jtf_territory_pvt.create_territory (

2633: -- 07/08/03: JDOCHERT: bug#3023653
2634: --mo_global.set_org_context(terr_group.ORG_ID,null);
2635: --
2636:
2637: jtf_territory_pvt.create_territory (
2638: p_api_version_number => l_api_version_number,
2639: p_init_msg_list => l_init_msg_list,
2640: p_commit => l_commit,
2641: p_validation_level => fnd_api.g_valid_level_NONE,

Line 2881: jtf_territory_pvt.create_territory (

2877: -- 07/08/03: JDOCHERT: bug#3023653
2878: --mo_global.set_org_context(terr_group.ORG_ID,null);
2879: --
2880:
2881: jtf_territory_pvt.create_territory (
2882: p_api_version_number => l_api_version_number,
2883: p_init_msg_list => l_init_msg_list,
2884: p_commit => l_commit,
2885: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3220: jtf_territory_pvt.create_territory (

3216: -- 07/08/03: JDOCHERT: bug#3023653
3217: --mo_global.set_org_context(terr_group.ORG_ID,null);
3218: --
3219:
3220: jtf_territory_pvt.create_territory (
3221: p_api_version_number => l_api_version_number,
3222: p_init_msg_list => l_init_msg_list,
3223: p_commit => l_commit,
3224: p_validation_level => fnd_api.g_valid_level_NONE,

Line 3463: jtf_territory_pvt.create_territory (

3459:
3460: --mo_global.set_org_context(204,null);
3461: --AS_UTILITY_PVT.file_debug(' winners # '||terr_group.NUM_WINNERS);
3462: --AS_UTILITY_PVT.file_debug(' migration of territory_group # '||terr_group.TERRITORY_GROUP_ID);
3463: jtf_territory_pvt.create_territory (
3464: p_api_version_number => l_api_version_number,
3465: p_init_msg_list => l_init_msg_list,
3466: p_commit => l_commit,
3467: p_validation_level => fnd_api.g_valid_level_NONE,