50: -- to ship zero quantity for a line
51: --
52: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
53: PROCEDURE Backorder(
54: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
51: --
52: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
53: PROCEDURE Backorder(
54: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
52: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
53: PROCEDURE Backorder(
54: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
53: PROCEDURE Backorder(
54: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
54: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
62: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
55: p_line_ids IN WSH_UTIL_CORE.Id_Tab_Type , -- Consolidation of BO Delivery Details project
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
62: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
63: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
56: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
57: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
58: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
62: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
63: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
64: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
59: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
62: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
63: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
64: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
65: x_return_status OUT NOCOPY VARCHAR2
66: );
67:
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_bo_mode IN VARCHAR2,
62: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
63: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
64: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
65: x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: --
91: -- (as additional parameter is added to the original backorder api).
92: --
93: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
94: PROCEDURE Backorder(
95: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
92: --
93: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
94: PROCEDURE Backorder(
95: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
93: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
94: PROCEDURE Backorder(
95: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_bo_mode IN VARCHAR2,
94: PROCEDURE Backorder(
95: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_bo_mode IN VARCHAR2,
102: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
95: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_bo_mode IN VARCHAR2,
102: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
103: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
96: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
97: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_bo_mode IN VARCHAR2,
102: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
103: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
104: x_return_status OUT NOCOPY VARCHAR2
99: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_bo_mode IN VARCHAR2,
102: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
103: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
104: x_return_status OUT NOCOPY VARCHAR2
105: );
106:
107: END WSH_SHIP_CONFIRM_ACTIONS2;