108: , x_msg_data OUT NOCOPY VARCHAR2
109: , p_request_task_id IN NUMBER
110: , p_scheduled_start_date_tbl IN jtf_date_table
111: , p_scheduled_end_date_tbl IN jtf_date_table
112: , p_resource_id_tbl IN jtf_number_table
113: , p_resource_type_tbl IN jtf_varchar2_table_100
114: , p_cost_tbl IN jtf_number_table
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
110: , p_scheduled_start_date_tbl IN jtf_date_table
111: , p_scheduled_end_date_tbl IN jtf_date_table
112: , p_resource_id_tbl IN jtf_number_table
113: , p_resource_type_tbl IN jtf_varchar2_table_100
114: , p_cost_tbl IN jtf_number_table
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
117: , p_spares_cost_tbl IN jtf_number_table
118: , p_spares_date_tbl IN jtf_date_table
111: , p_scheduled_end_date_tbl IN jtf_date_table
112: , p_resource_id_tbl IN jtf_number_table
113: , p_resource_type_tbl IN jtf_varchar2_table_100
114: , p_cost_tbl IN jtf_number_table
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
117: , p_spares_cost_tbl IN jtf_number_table
118: , p_spares_date_tbl IN jtf_date_table
119: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
112: , p_resource_id_tbl IN jtf_number_table
113: , p_resource_type_tbl IN jtf_varchar2_table_100
114: , p_cost_tbl IN jtf_number_table
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
117: , p_spares_cost_tbl IN jtf_number_table
118: , p_spares_date_tbl IN jtf_date_table
119: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
120: );
113: , p_resource_type_tbl IN jtf_varchar2_table_100
114: , p_cost_tbl IN jtf_number_table
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
117: , p_spares_cost_tbl IN jtf_number_table
118: , p_spares_date_tbl IN jtf_date_table
119: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
120: );
121:
115: , p_terr_id_tbl IN jtf_number_table
116: , p_win_to_promis_id_tbl IN jtf_number_table
117: , p_spares_cost_tbl IN jtf_number_table
118: , p_spares_date_tbl IN jtf_date_table
119: , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
120: );
121:
122: PROCEDURE create_multi_trips_request(
123: p_api_version IN NUMBER