163: FROM WMS_LICENSE_PLATE_NUMBERS
164: START WITH lpn_id = l_inner_lpn_id
165: CONNECT BY lpn_id = PRIOR parent_lpn_id;
166:
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
164: START WITH lpn_id = l_inner_lpn_id
165: CONNECT BY lpn_id = PRIOR parent_lpn_id;
166:
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
165: CONNECT BY lpn_id = PRIOR parent_lpn_id;
166:
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
166:
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
168: l_backorder_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
169: l_backorder_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
177: l_dummy_num_var NUMBER := NULL;
170: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
177: l_dummy_num_var NUMBER := NULL;
178: l_table_index NUMBER := 1;
171: l_requested_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
172: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
173: l_overpicked_quantities2_table WSH_UTIL_CORE.ID_TAB_TYPE;
174: l_dummy_table wsh_util_core.id_tab_type;
175: l_out_rows wsh_util_core.id_tab_type;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
177: l_dummy_num_var NUMBER := NULL;
178: l_table_index NUMBER := 1;
179:
380: END IF;
381:
382: EXCEPTION
383: WHEN fnd_api.g_exc_unexpected_error THEN
384: wsh_util_core.get_messages
385: (p_init_msg_list => 'Y',
386: x_summary => x_msg_data,
387: x_details => l_details,
388: x_count => x_msg_count);
475: END IF;
476:
477: EXCEPTION
478: WHEN fnd_api.g_exc_unexpected_error THEN
479: wsh_util_core.get_messages
480: (p_init_msg_list => 'Y',
481: x_summary => x_msg_data,
482: x_details => l_details,
483: x_count => x_msg_count);