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 861: l_dlv_obj wsh_otm_dlv_obj;

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;
863: l_weight NUMBER;
864: l_dlv_id_tab WSH_OTM_ID_TAB;
865: l_error_dlv_id_tab WSH_OTM_ID_TAB;

Line 1014: ||'wsh_otm_dlv_obj( '

1010: END IF;
1011:
1012: l_deliveries_sql :=
1013: 'select '
1014: ||'wsh_otm_dlv_obj( '
1015: ||'decode(wnd.tms_interface_flag,''CP'',''RC'',''UP'',''RC'',''DP'',''D''),'
1016: --||'''RC'','
1017: ||'wnd.delivery_id,'
1018: ||'wnd.name,'

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

1091: l_all_details := wsh_otm_det_tab();
1092: -- 6922924
1093: l_good_dlv_tab := wsh_otm_dlv_tab();
1094:
1095: --l_dlv_obj := wsh_otm_dlv_obj();
1096: l_dlv_id_tab := WSH_OTM_ID_TAB();
1097: LOOP
1098: --{
1099: FETCH c_deliveries INTO l_dlv_obj,l_det_obj;