25: */
26:
27:
28: PROCEDURE Assign_Details (
29: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
30: p_parent_detail_id IN NUMBER,
31: p_delivery_id IN NUMBER,
32: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
33: x_pack_status OUT NOCOPY VARCHAR2,
58: */
59:
60:
61: PROCEDURE Unassign_Details (
62: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
63: p_parent_detail_flag IN VARCHAR2,
64: p_delivery_flag IN VARCHAR2,
65: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
66: x_return_status OUT NOCOPY VARCHAR2,
84: */
85:
86:
87: PROCEDURE Unassign_Details (
88: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
89: p_parent_detail_flag IN VARCHAR2,
90: p_delivery_flag IN VARCHAR2,
91: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
92: x_return_status OUT NOCOPY VARCHAR2);
114: */
115:
116:
117: PROCEDURE Auto_Pack_Lines (
118: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
119: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
120: p_pack_cont_flag IN VARCHAR2,
121: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
122: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
115:
116:
117: PROCEDURE Auto_Pack_Lines (
118: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
119: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
120: p_pack_cont_flag IN VARCHAR2,
121: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
122: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
123: x_return_status OUT NOCOPY VARCHAR2);
118: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
119: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
120: p_pack_cont_flag IN VARCHAR2,
121: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
122: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
123: x_return_status OUT NOCOPY VARCHAR2);
124:
125:
126:
148: */
149:
150:
151: PROCEDURE Separate_Details (
152: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
153: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
154: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
155: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
156: x_return_status OUT NOCOPY VARCHAR2,
149:
150:
151: PROCEDURE Separate_Details (
152: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
153: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
154: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
155: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
156: x_return_status OUT NOCOPY VARCHAR2,
157: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N');
150:
151: PROCEDURE Separate_Details (
152: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
153: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
154: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
155: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
156: x_return_status OUT NOCOPY VARCHAR2,
157: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N');
158:
151: PROCEDURE Separate_Details (
152: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
153: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
154: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
155: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
156: x_return_status OUT NOCOPY VARCHAR2,
157: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N');
158:
159:
234: */
235:
236:
237: PROCEDURE Calculate_Total_Capacities (
238: p_detail_input_tab IN WSH_UTIL_CORE.id_tab_type,
239: x_cont_wt_avail OUT NOCOPY NUMBER,
240: x_cont_vol_avail OUT NOCOPY NUMBER,
241: x_item_wt_total OUT NOCOPY NUMBER,
242: x_item_vol_total OUT NOCOPY NUMBER,