47: -- Description: This procedure checks if the list of delivery details
48: -- can be unassigned from the delivery they are unassigned to.
49:
50: PROCEDURE check_unassign_from_delivery(
51: p_detail_rows IN wsh_util_core.id_tab_type,
52: x_return_status OUT NOCOPY VARCHAR2) ;
53:
54: --
55: -- Function: serial_num_ctl_req
157: --
158: -----------------------------------------------------------------------------
159:
160: PROCEDURE check_assign_del_multi(
161: p_detail_rows IN wsh_util_core.id_tab_type,
162: x_del_params OUT NOCOPY wsh_delivery_autocreate.grp_attr_rec_type,
163: x_return_status OUT NOCOPY VARCHAR2);
164:
165:
258: p_delivery_detail_id IN NUMBER
259: , p_delivery_id IN NUMBER
260: , p_list_type IN VARCHAR2
261: , x_return_status OUT NOCOPY VARCHAR2
262: , x_disabled_list OUT NOCOPY WSH_UTIL_CORE.column_tab_type
263: , x_msg_count OUT NOCOPY NUMBER
264: , x_msg_data OUT NOCOPY VARCHAR2
265: , p_caller IN VARCHAR2 DEFAULT NULL --public api changes
266: );
342: p_action IN VARCHAR2,
343: p_caller IN VARCHAR2,
344: p_deliveryid IN NUMBER DEFAULT null,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
347: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
348: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type );
349:
350: --
343: p_caller IN VARCHAR2,
344: p_deliveryid IN NUMBER DEFAULT null,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
347: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
348: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type );
349:
350: --
351: -- Overloaded procedure
344: p_deliveryid IN NUMBER DEFAULT null,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
347: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
348: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type );
349:
350: --
351: -- Overloaded procedure
352: --
410: p_new_table IN wsh_interface.deliverydetailtab,
411: p_action_code IN VARCHAR2,
412: p_phase IN NUMBER,
413: p_caller IN VARCHAR2,
414: x_changed_id_tab OUT NOCOPY wsh_util_core.id_tab_type,
415: x_return_status OUT NOCOPY VARCHAR2
416: );
417:
418: --End for Load Tender Project