APPS.JTF_ASSIGN_PUB dependencies on JTF_TERRITORY_GET_PUB

Line 9601: l_assign_resources_tbl JTF_TERRITORY_GET_PUB.QualifyingRsc_out_tbl_type;

9597:
9598: l_dynamic_sql VARCHAR2(2000);
9599: l_dynamic_sql1 VARCHAR2(2000);
9600:
9601: l_assign_resources_tbl JTF_TERRITORY_GET_PUB.QualifyingRsc_out_tbl_type;
9602:
9603: l_x_planned_start_date DATE;
9604: l_x_planned_end_date DATE;
9605: l_x_shift_construct_id NUMBER;

Line 9906: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';

9902: IF (l_territory_id IS NOT NULL) THEN
9903:
9904: -- change the API Name temporarily so that in case of unexpected error
9905: -- it is properly caught
9906: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9907:
9908: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
9909: (
9910: p_api_version => l_api_version,

Line 9908: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory

9904: -- change the API Name temporarily so that in case of unexpected error
9905: -- it is properly caught
9906: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9907:
9908: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
9909: (
9910: p_api_version => l_api_version,
9911: p_init_msg_list => p_init_msg_list,
9912: x_return_status => x_return_status,

Line 9940: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';

9936: IF ( l_esc_territory_id IS NOT NULL) THEN
9937:
9938: -- change the API Name temporarily so that in case of unexpected error
9939: -- it is properly caught
9940: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9941:
9942: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9943: (
9944: p_api_version_number => l_api_version,

Line 9942: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

9938: -- change the API Name temporarily so that in case of unexpected error
9939: -- it is properly caught
9940: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9941:
9942: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9943: (
9944: p_api_version_number => l_api_version,
9945: p_init_msg_list => p_init_msg_list,
9946: p_commit => NULL,

Line 9981: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';

9977: IF ( l_assign_resources_tbl.COUNT = 0 ) THEN
9978:
9979: -- change the API Name temporarily so that in case of unexpected error
9980: -- it is properly caught
9981: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9982:
9983: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9984: (
9985: p_api_version_number => l_api_version,

Line 9983: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

9979: -- change the API Name temporarily so that in case of unexpected error
9980: -- it is properly caught
9981: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9982:
9983: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9984: (
9985: p_api_version_number => l_api_version,
9986: p_init_msg_list => p_init_msg_list,
9987: p_commit => NULL,

Line 10175: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';

10171: ELSE -- p_esc_tbl.count <= 0
10172:
10173: -- change the API Name temporarily so that in case of unexpected error
10174: -- it is properly caught
10175: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
10176:
10177: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
10178: (
10179: p_api_version_number => l_api_version,

Line 10177: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

10173: -- change the API Name temporarily so that in case of unexpected error
10174: -- it is properly caught
10175: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
10176:
10177: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
10178: (
10179: p_api_version_number => l_api_version,
10180: p_init_msg_list => p_init_msg_list,
10181: p_commit => NULL,