APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_LPN_TAB

Line 113: --lpn_tab WSH_OTM_LPN_TAB;

109: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_TRIP_OBJECTS';
110:
111: l_trip_tab WSH_OTM_TRIP_TAB;
112: l_stops_tab WSH_OTM_STOP_TAB;
113: --lpn_tab WSH_OTM_LPN_TAB;
114: l_dlv_tab WSH_OTM_DLV_TAB;
115: l_dlv_ids WSH_OTM_ID_TAB;
116: l_vol NUMBER;
117: l_gross_weight NUMBER;

Line 130: l_lpns WSH_OTM_LPN_TAB;

126: x_base_vol_uom VARCHAR2(150);
127: l_lpn_count NUMBER;
128: l_stop_details WSH_OTM_STOP_DET_TAB;
129: l_new_stop_details WSH_OTM_STOP_DET_TAB;
130: l_lpns WSH_OTM_LPN_TAB;
131: l_pick_up_flag VARCHAR2(1);
132: l_drop_off_flag VARCHAR2(1);
133: l_trips_sql VARCHAR2(2000);
134: l_trip_obj WSH_OTM_TRIP_OBJ;

Line 140: l_lpn_tab WSH_OTM_LPN_TAB;

136: c_trips WSH_UTIL_CORE.RefCurType;
137: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
138: i NUMBER;
139: i1 NUMBER;
140: l_lpn_tab WSH_OTM_LPN_TAB;
141: l_organization_id NUMBER;
142: l_return_status VARCHAr2(10);
143: l_all_dlv_tab WSH_OTM_DLV_TAB;
144: l_total_freight_cost NUMBER;

Line 647: l_lpn_tab := WSH_OTM_LPN_TAB();

643: raise GET_DELIVERY_OBJECTS_FALIED;
644: --}
645: END IF;
646:
647: l_lpn_tab := WSH_OTM_LPN_TAB();
648:
649: FOR i2 in 1..l_dlv_tab.COUNT LOOP
650: --{
651: l_lpn_count := l_lpn_count + l_dlv_tab(i2).lpn.COUNT;

Line 858: l_lpn_tab wsh_otm_lpn_tab;

854: l_dlv_tab wsh_otm_dlv_tab;
855: l_all_details wsh_otm_det_tab;
856: l_del_details wsh_otm_det_tab;
857: l_rl_details wsh_otm_det_tab;
858: l_lpn_tab wsh_otm_lpn_tab;
859: l_packed_items WSH_OTM_LPN_CONT_TAB;
860: l_loose_items_ids WSH_OTM_ID_TAB;
861: l_dlv_obj wsh_otm_dlv_obj;
862: l_det_obj wsh_otm_det_obj;

Line 1224: l_lpn_tab := wsh_otm_lpn_tab();

1220:
1221:
1222:
1223: l_rl_details := wsh_otm_det_tab();
1224: l_lpn_tab := wsh_otm_lpn_tab();
1225: l_all_lpn_tab := l_dummy_lpn_tab;
1226: l_total_quantity := 0;
1227:
1228: -- Loop through l_del_details to create the following