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_RESOURCE_PVT

Line 919: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_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;
923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 920: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
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;

Line 922: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_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;
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;

Line 923: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
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;

Line 970: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

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;
974: x_msg_count NUMBER;

Line 971: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
974: x_msg_count NUMBER;
975: x_msg_data VARCHAR2(2000);

Line 1711: Jtf_Territory_Resource_Pvt.create_terrresource (

1707: END LOOP;/* FOR tran_type in role_interest_nonpi */
1708:
1709: l_init_msg_list :=FND_API.G_TRUE;
1710:
1711: Jtf_Territory_Resource_Pvt.create_terrresource (
1712: p_api_version_number => l_Api_Version_Number,
1713: p_init_msg_list => l_Init_Msg_List,
1714: p_commit => l_Commit,
1715: p_validation_level => FND_API.g_valid_level_NONE,

Line 2294: Jtf_Territory_Resource_Pvt.create_terrresource (

2290: END LOOP; /* rsc in resource_grp */
2291:
2292: l_init_msg_list :=FND_API.G_TRUE;
2293:
2294: Jtf_Territory_Resource_Pvt.create_terrresource (
2295: p_api_version_number => l_Api_Version_Number,
2296: p_init_msg_list => l_Init_Msg_List,
2297: p_commit => l_Commit,
2298: p_validation_level => FND_API.g_valid_level_NONE,

Line 2416: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_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;
2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 2417: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
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;

Line 2419: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_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;
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;

Line 2420: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
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;

Line 2466: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

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;
2470: x_msg_count NUMBER;

Line 2467: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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;
2470: x_msg_count NUMBER;
2471: x_msg_data VARCHAR2(2000);

Line 3373: Jtf_Territory_Resource_Pvt.create_terrresource (

3369: END LOOP;/* FOR tran_type in role_interest_nonpi */
3370:
3371: l_init_msg_list :=FND_API.G_TRUE;
3372:
3373: Jtf_Territory_Resource_Pvt.create_terrresource (
3374: p_api_version_number => l_Api_Version_Number,
3375: p_init_msg_list => l_Init_Msg_List,
3376: p_commit => l_Commit,
3377: p_validation_level => FND_API.g_valid_level_NONE,

Line 4150: Jtf_Territory_Resource_Pvt.create_terrresource (

4146: END LOOP; /* rsc in resource_grp */
4147:
4148: l_init_msg_list :=FND_API.G_TRUE;
4149:
4150: Jtf_Territory_Resource_Pvt.create_terrresource (
4151: p_api_version_number => l_Api_Version_Number,
4152: p_init_msg_list => l_Init_Msg_List,
4153: p_commit => l_Commit,
4154: p_validation_level => FND_API.g_valid_level_NONE,

Line 4348: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

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:
4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 4349: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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:
4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4353:

Line 4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

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:
4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4353:
4354: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
4355: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

Line 4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

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:
4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4353:
4354: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
4355: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
4356:

Line 4354: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

4350:
4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4353:
4354: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
4355: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
4356:
4357:
4358: /* JDOCHERT: /05/29/03:

Line 4355: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

4351: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
4352: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
4353:
4354: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
4355: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
4356:
4357:
4358: /* JDOCHERT: /05/29/03:
4359: ** Transaction Types for a NON-OVERLAY territory are

Line 5223: Jtf_Territory_Resource_Pvt.create_terrresource (

5219: l_init_msg_list :=FND_API.G_TRUE;
5220:
5221:
5222: -- 07/08/03: JDOCHERT: bug#3023653
5223: Jtf_Territory_Resource_Pvt.create_terrresource (
5224: p_api_version_number => l_Api_Version_Number,
5225: p_init_msg_list => l_Init_Msg_List,
5226: p_commit => l_Commit,
5227: p_validation_level => FND_API.g_valid_level_NONE,

Line 5600: Jtf_Territory_Resource_Pvt.create_terrresource (

5596: END LOOP;/* FOR tran_type in role_interest_nonpi */
5597:
5598: l_init_msg_list :=FND_API.G_TRUE;
5599:
5600: Jtf_Territory_Resource_Pvt.create_terrresource (
5601: p_api_version_number => l_Api_Version_Number,
5602: p_init_msg_list => l_Init_Msg_List,
5603: p_commit => l_Commit,
5604: p_validation_level => FND_API.g_valid_level_NONE,

Line 6265: Jtf_Territory_Resource_Pvt.create_terrresource (

6261:
6262: l_init_msg_list :=FND_API.G_TRUE;
6263:
6264: -- 07/08/03: JDOCHERT: bug#3023653
6265: Jtf_Territory_Resource_Pvt.create_terrresource (
6266: p_api_version_number => l_Api_Version_Number,
6267: p_init_msg_list => l_Init_Msg_List,
6268: p_commit => l_Commit,
6269: p_validation_level => FND_API.g_valid_level_NONE,

Line 6847: Jtf_Territory_Resource_Pvt.create_terrresource (

6843:
6844: l_init_msg_list :=FND_API.G_TRUE;
6845:
6846: -- 07/08/03: JDOCHERT: bug#3023653
6847: Jtf_Territory_Resource_Pvt.create_terrresource (
6848: p_api_version_number => l_Api_Version_Number,
6849: p_init_msg_list => l_Init_Msg_List,
6850: p_commit => l_Commit,
6851: p_validation_level => FND_API.g_valid_level_NONE,

Line 7054: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

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:
7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 7055: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_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:
7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7059:

Line 7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

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:
7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7059:
7060: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
7061: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

Line 7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

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:
7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7059:
7060: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
7061: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
7062:

Line 7060: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

7056:
7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7059:
7060: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
7061: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
7062:
7063:
7064: /* JDOCHERT: /05/29/03:

Line 7061: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

7057: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
7058: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
7059:
7060: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
7061: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
7062:
7063:
7064: /* JDOCHERT: /05/29/03:
7065: ** Transaction Types for a NON-OVERLAY territory are

Line 8023: Jtf_Territory_Resource_Pvt.create_terrresource (

8019: END LOOP;
8020:
8021: l_init_msg_list := FND_API.G_TRUE;
8022:
8023: Jtf_Territory_Resource_Pvt.create_terrresource (
8024: p_api_version_number => l_Api_Version_Number,
8025: p_init_msg_list => l_Init_Msg_List,
8026: p_commit => l_Commit,
8027: p_validation_level => FND_API.g_valid_level_NONE,

Line 8440: Jtf_Territory_Resource_Pvt.create_terrresource (

8436:
8437: l_init_msg_list :=FND_API.G_TRUE;
8438:
8439: -- 07/08/03: JDOCHERT: bug#3023653
8440: Jtf_Territory_Resource_Pvt.create_terrresource (
8441: p_api_version_number => l_Api_Version_Number,
8442: p_init_msg_list => l_Init_Msg_List,
8443: p_commit => l_Commit,
8444: p_validation_level => FND_API.g_valid_level_NONE,

Line 8816: Jtf_Territory_Resource_Pvt.create_terrresource (

8812: END LOOP;/* FOR tran_type in role_interest_nonpi */
8813:
8814: l_init_msg_list :=FND_API.G_TRUE;
8815:
8816: Jtf_Territory_Resource_Pvt.create_terrresource (
8817: p_api_version_number => l_Api_Version_Number,
8818: p_init_msg_list => l_Init_Msg_List,
8819: p_commit => l_Commit,
8820: p_validation_level => FND_API.g_valid_level_NONE,

Line 9664: Jtf_Territory_Resource_Pvt.create_terrresource (

9660:
9661: l_init_msg_list :=FND_API.G_TRUE;
9662:
9663: -- 07/08/03: JDOCHERT: bug#3023653
9664: Jtf_Territory_Resource_Pvt.create_terrresource (
9665: p_api_version_number => l_Api_Version_Number,
9666: p_init_msg_list => l_Init_Msg_List,
9667: p_commit => l_Commit,
9668: p_validation_level => FND_API.g_valid_level_NONE,

Line 10248: Jtf_Territory_Resource_Pvt.create_terrresource (

10244:
10245: l_init_msg_list :=FND_API.G_TRUE;
10246:
10247: -- 07/08/03: JDOCHERT: bug#3023653
10248: Jtf_Territory_Resource_Pvt.create_terrresource (
10249: p_api_version_number => l_Api_Version_Number,
10250: p_init_msg_list => l_Init_Msg_List,
10251: p_commit => l_Commit,
10252: p_validation_level => FND_API.g_valid_level_NONE,

Line 12866: --l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

12862:
12863: i NUMBER;
12864: a NUMBER;
12865:
12866: --l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

Line 12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

12863: i NUMBER;
12864: a NUMBER;
12865:
12866: --l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

Line 12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

12864: a NUMBER;
12865:
12866: --l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:

Line 12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;

12866: --l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:
12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

Line 12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;

12867: l_TerrRsc_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12868: l_TerrRsc_Access_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:
12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12875: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

Line 12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;

12869:
12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:
12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12875: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12876:
12877: /* Roles defined for the TG */

Line 12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;

12870: x_TerrRsc_Out_Tbl Jtf_Territory_Resource_Pvt.TerrResource_out_tbl_type;
12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:
12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12875: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12876:
12877: /* Roles defined for the TG */
12878: CURSOR roles_for_TG(l_terr_group_id NUMBER) IS

Line 12875: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;

12871: x_TerrRsc_Access_Out_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_out_tbl_type;
12872:
12873: --l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type;
12874: l_TerrRsc_empty_Tbl Jtf_Territory_Resource_Pvt.TerrResource_tbl_type_wflex;
12875: l_TerrRsc_Access_empty_Tbl Jtf_Territory_Resource_Pvt.TerrRsc_Access_tbl_type ;
12876:
12877: /* Roles defined for the TG */
12878: CURSOR roles_for_TG(l_terr_group_id NUMBER) IS
12879: SELECT b.role_code role_code

Line 13055: Jtf_Territory_Resource_Pvt.create_terrresource (

13051: END LOOP;/* FOR role_type in role_interest_nonpi */
13052:
13053: l_init_msg_list :=FND_API.G_TRUE;
13054:
13055: Jtf_Territory_Resource_Pvt.create_terrresource (
13056: p_api_version_number => l_Api_Version_Number,
13057: p_init_msg_list => l_Init_Msg_List,
13058: p_commit => l_Commit,
13059: p_validation_level => FND_API.g_valid_level_NONE,