1719: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1724: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1725: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1726:
1727: l_rs VARCHAR2(1);
1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1724: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1725: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1726:
1727: l_rs VARCHAR2(1);
1728: l_msg_count NUMBER;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1724: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1725: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1726:
1727: l_rs VARCHAR2(1);
1728: l_msg_count NUMBER;
1729: l_msg_data VARCHAR2(32767);
1782: l_del_action_prms.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
1783: l_del_action_prms.action_code := 'UNASSIGN-TRIP';
1784: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
1785:
1786: WSH_DELIVERIES_GRP.delivery_action(
1787: p_api_version_number => 1.0,
1788: p_init_msg_list => FND_API.G_TRUE,
1789: p_commit => FND_API.G_FALSE,
1790: p_action_prms => l_del_action_prms,
1926: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1927: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1927: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
2241: l_del_action_prms.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
2242: l_del_action_prms.action_code := 'UNASSIGN-TRIP';
2243: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2244:
2245: WSH_DELIVERIES_GRP.delivery_action(
2246: p_api_version_number => 1.0,
2247: p_init_msg_list => FND_API.G_TRUE,
2248: p_commit => FND_API.G_FALSE,
2249: p_action_prms => l_del_action_prms,
2721: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2726: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
2727: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
2728:
2729: l_rs VARCHAR2(1);
2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2726: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
2727: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
2728:
2729: l_rs VARCHAR2(1);
2730: l_msg_count NUMBER;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2726: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
2727: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
2728:
2729: l_rs VARCHAR2(1);
2730: l_msg_count NUMBER;
2731: l_msg_data VARCHAR2(32767);
2877: l_del_action_prms.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
2878: l_del_action_prms.action_code := 'UNASSIGN-TRIP';
2879: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2880:
2881: WSH_DELIVERIES_GRP.delivery_action(
2882: p_api_version_number => 1.0,
2883: p_init_msg_list => FND_API.G_TRUE,
2884: p_commit => FND_API.G_FALSE,
2885: p_action_prms => l_del_action_prms,
3042: WSH_DEBUG_SV.logmsg(l_module_name,'Dropoff Pl Dep Date:'||l_del_action_prms.dropoff_dep_date);
3043: WSH_DEBUG_SV.logmsg(l_module_name,'========================================');
3044: END IF;
3045:
3046: WSH_DELIVERIES_GRP.delivery_action(
3047: p_api_version_number => 1.0,
3048: p_init_msg_list => FND_API.G_TRUE,
3049: p_commit => FND_API.G_FALSE,
3050: p_action_prms => l_del_action_prms,
4815:
4816: l_current_trip_id NUMBER;
4817:
4818: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4819: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4820: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4821: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4822:
4823: l_rs VARCHAR2(1);
4816: l_current_trip_id NUMBER;
4817:
4818: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4819: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4820: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4821: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4822:
4823: l_rs VARCHAR2(1);
4824: l_msg_count NUMBER;
4817:
4818: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4819: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4820: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4821: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4822:
4823: l_rs VARCHAR2(1);
4824: l_msg_count NUMBER;
4825: l_msg_data VARCHAR2(32767);
4895: l_del_action_prms.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
4896: l_del_action_prms.action_code := 'UNASSIGN-TRIP';
4897: l_del_action_prms.trip_id := l_current_trip_id;
4898:
4899: WSH_DELIVERIES_GRP.delivery_action(
4900: p_api_version_number => 1.0,
4901: p_init_msg_list => FND_API.G_TRUE,
4902: p_commit => FND_API.G_FALSE,
4903: p_action_prms => l_del_action_prms,