APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_DLV_OBJ

Line 177: TYPE dlv_in_tab_type is TABLE Of wsh_otm_dlv_obj INDEX BY BINARY_INTEGER;

173: l_del_trip_rec NUMBER := NULL;
174: l_num_error NUMBER;
175: --bug# 6497991 (end)
176:
177: TYPE dlv_in_tab_type is TABLE Of wsh_otm_dlv_obj INDEX BY BINARY_INTEGER;
178: dlv_in_tab dlv_in_tab_type;
179:
180: GET_DELIVERY_OBJECTS_FALIED EXCEPTION;
181: GET_DEAFULT_UOMS_FALIED EXCEPTION;

Line 862: l_dlv_obj wsh_otm_dlv_obj;

858: l_rl_details wsh_otm_det_tab;
859: l_lpn_tab wsh_otm_lpn_tab;
860: l_packed_items WSH_OTM_LPN_CONT_TAB;
861: l_loose_items_ids WSH_OTM_ID_TAB;
862: l_dlv_obj wsh_otm_dlv_obj;
863: l_det_obj wsh_otm_det_obj;
864: l_weight NUMBER;
865: l_dlv_id_tab WSH_OTM_ID_TAB;
866: l_error_dlv_id_tab WSH_OTM_ID_TAB;

Line 1020: ||'wsh_otm_dlv_obj( '

1016: END IF;
1017:
1018: l_deliveries_sql :=
1019: 'select '
1020: ||'wsh_otm_dlv_obj( '
1021: ||'decode(wnd.tms_interface_flag,''CP'',''RC'',''UP'',''RC'',''DP'',''D''),'
1022: --||'''RC'','
1023: ||'wnd.delivery_id,'
1024: ||'wnd.name,'

Line 1106: --l_dlv_obj := wsh_otm_dlv_obj();

1102: l_all_details := wsh_otm_det_tab();
1103: -- 6922924
1104: l_good_dlv_tab := wsh_otm_dlv_tab();
1105:
1106: --l_dlv_obj := wsh_otm_dlv_obj();
1107: l_dlv_id_tab := WSH_OTM_ID_TAB();
1108: LOOP
1109: --{
1110: FETCH c_deliveries INTO l_dlv_obj,l_det_obj;