DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_TERRITORY_GET_PUB

Line 9537: l_assign_resources_tbl JTF_TERRITORY_GET_PUB.QualifyingRsc_out_tbl_type;

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;

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

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,

Line 9844: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory

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,

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

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,

Line 9878: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

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,

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

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,

Line 9919: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

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,

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

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,

Line 10113: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

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,