APPS.WSH_DELIVERIES_PUB dependencies on WSH_TRIPS

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

1150: IF l_del_action_out_rec.result_id_tab.count > 0 THEN
1151: l_first := l_del_action_out_rec.result_id_tab.first;
1152: IF l_del_action_out_rec.result_id_tab(l_first) IS NOT NULL THEN
1153: x_trip_id := l_del_action_out_rec.result_id_tab(l_first);
1154: x_trip_name := wsh_trips_pvt.get_name(l_del_action_out_rec.result_id_tab(l_first));
1155: END IF;
1156: END IF;
1157: END IF;
1158: --

Line 1271: l_trip_id WSH_TRIPS.Trip_Id%TYPE;

1267:
1268: -- Parameter Variables for WSH_DOCUMENT_SET.Print_Document_Sets
1269: l_report_set_id NUMBER;
1270: l_organization_id NUMBER;
1271: l_trip_id WSH_TRIPS.Trip_Id%TYPE;
1272: l_trip_name WSH_TRIPS.Name%TYPE;
1273: l_msg_count NUMBER;
1274: l_msg_data VARCHAR2(500);
1275: l_return_status VARCHAR2(1);

Line 1272: l_trip_name WSH_TRIPS.Name%TYPE;

1268: -- Parameter Variables for WSH_DOCUMENT_SET.Print_Document_Sets
1269: l_report_set_id NUMBER;
1270: l_organization_id NUMBER;
1271: l_trip_id WSH_TRIPS.Trip_Id%TYPE;
1272: l_trip_name WSH_TRIPS.Name%TYPE;
1273: l_msg_count NUMBER;
1274: l_msg_data VARCHAR2(500);
1275: l_return_status VARCHAR2(1);
1276: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;