9533:
9534: l_dynamic_sql VARCHAR2(2000);
9535: l_dynamic_sql1 VARCHAR2(2000);
9536:
9537: l_assign_resources_tbl JTF_TERRITORY_GET_PUB.QualifyingRsc_out_tbl_type;
9538:
9539: l_x_planned_start_date DATE;
9540: l_x_planned_end_date DATE;
9541: l_x_shift_construct_id NUMBER;
9838: IF (l_territory_id IS NOT NULL) THEN
9839:
9840: -- change the API Name temporarily so that in case of unexpected error
9841: -- it is properly caught
9842: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9843:
9844: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
9845: (
9846: p_api_version => l_api_version,
9840: -- change the API Name temporarily so that in case of unexpected error
9841: -- it is properly caught
9842: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9843:
9844: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
9845: (
9846: p_api_version => l_api_version,
9847: p_init_msg_list => p_init_msg_list,
9848: x_return_status => x_return_status,
9872: IF ( l_esc_territory_id IS NOT NULL) THEN
9873:
9874: -- change the API Name temporarily so that in case of unexpected error
9875: -- it is properly caught
9876: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9877:
9878: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9879: (
9880: p_api_version_number => l_api_version,
9874: -- change the API Name temporarily so that in case of unexpected error
9875: -- it is properly caught
9876: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9877:
9878: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9879: (
9880: p_api_version_number => l_api_version,
9881: p_init_msg_list => p_init_msg_list,
9882: p_commit => NULL,
9913: IF ( l_assign_resources_tbl.COUNT = 0 ) THEN
9914:
9915: -- change the API Name temporarily so that in case of unexpected error
9916: -- it is properly caught
9917: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9918:
9919: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9920: (
9921: p_api_version_number => l_api_version,
9915: -- change the API Name temporarily so that in case of unexpected error
9916: -- it is properly caught
9917: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
9918:
9919: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
9920: (
9921: p_api_version_number => l_api_version,
9922: p_init_msg_list => p_init_msg_list,
9923: p_commit => NULL,
10107: ELSE -- p_esc_tbl.count <= 0
10108:
10109: -- change the API Name temporarily so that in case of unexpected error
10110: -- it is properly caught
10111: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
10112:
10113: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
10114: (
10115: p_api_version_number => l_api_version,
10109: -- change the API Name temporarily so that in case of unexpected error
10110: -- it is properly caught
10111: l_api_name := l_api_name||'-JTF_TERRITORY_GET_PUB';
10112:
10113: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
10114: (
10115: p_api_version_number => l_api_version,
10116: p_init_msg_list => p_init_msg_list,
10117: p_commit => NULL,