DBA Data[Home] [Help]

APPS.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_UTIL_CORE

Line 167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

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;

Line 168: l_backorder_quantities_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;

Line 169: l_backorder_quantities2_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;

Line 170: l_requested_quantities_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;

Line 171: l_requested_quantities2_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;

Line 172: l_overpicked_quantities_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;
176: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

Line 173: l_overpicked_quantities2_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;
177: l_dummy_num_var NUMBER := NULL;

Line 174: l_dummy_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;
178: l_table_index NUMBER := 1;

Line 175: l_out_rows 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;
179:

Line 384: wsh_util_core.get_messages

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);

Line 479: wsh_util_core.get_messages

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);