APPS.WSH_DELIVERIES_PUB dependencies on WSH_TRIPS

Line 1067: x_trip_name := wsh_trips_pvt.get_name(l_del_action_out_rec.result_id_tab(l_first));

1063: IF l_del_action_out_rec.result_id_tab.count > 0 THEN
1064: l_first := l_del_action_out_rec.result_id_tab.first;
1065: IF l_del_action_out_rec.result_id_tab(l_first) IS NOT NULL THEN
1066: x_trip_id := l_del_action_out_rec.result_id_tab(l_first);
1067: x_trip_name := wsh_trips_pvt.get_name(l_del_action_out_rec.result_id_tab(l_first));
1068: END IF;
1069: END IF;
1070: END IF;
1071: --

Line 1184: l_trip_id WSH_TRIPS.Trip_Id%TYPE;

1180:
1181: -- Parameter Variables for WSH_DOCUMENT_SET.Print_Document_Sets
1182: l_report_set_id NUMBER;
1183: l_organization_id NUMBER;
1184: l_trip_id WSH_TRIPS.Trip_Id%TYPE;
1185: l_trip_name WSH_TRIPS.Name%TYPE;
1186: l_msg_count NUMBER;
1187: l_msg_data VARCHAR2(500);
1188: l_return_status VARCHAR2(1);

Line 1185: l_trip_name WSH_TRIPS.Name%TYPE;

1181: -- Parameter Variables for WSH_DOCUMENT_SET.Print_Document_Sets
1182: l_report_set_id NUMBER;
1183: l_organization_id NUMBER;
1184: l_trip_id WSH_TRIPS.Trip_Id%TYPE;
1185: l_trip_name WSH_TRIPS.Name%TYPE;
1186: l_msg_count NUMBER;
1187: l_msg_data VARCHAR2(500);
1188: l_return_status VARCHAR2(1);
1189: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;