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_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
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_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
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_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
63: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
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_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
63: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
64: x_out_rows OUT NOCOPY 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_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
63: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
64: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
65: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
60: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
61: p_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
63: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
64: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
65: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
66: x_return_status OUT NOCOPY VARCHAR2
67: );
68:
61: p_sources IN WSH_UTIL_CORE.Column_Tab_Type, -- RTV BO Cons Changes
62: p_bo_mode IN VARCHAR2,
63: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
64: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
65: x_cons_flags OUT NOCOPY WSH_UTIL_CORE.Column_Tab_Type, -- Consolidation of BO Delivery Details project
66: x_return_status OUT NOCOPY VARCHAR2
67: );
68:
69: --
92: -- (as additional parameter is added to the original backorder api).
93: --
94: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
95: PROCEDURE Backorder(
96: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
93: --
94: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
95: PROCEDURE Backorder(
96: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
94: -- bug# 6908504 (replenishment project): Added a new parameter p_bo_source .
95: PROCEDURE Backorder(
96: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
102: p_bo_mode IN VARCHAR2,
95: PROCEDURE Backorder(
96: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
102: p_bo_mode IN VARCHAR2,
103: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
96: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type ,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
102: p_bo_mode IN VARCHAR2,
103: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
104: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
97: p_bo_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
98: p_req_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
99: p_bo_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
102: p_bo_mode IN VARCHAR2,
103: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
104: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
105: x_return_status OUT NOCOPY VARCHAR2
100: p_overpick_qtys IN WSH_UTIL_CORE.Id_Tab_Type,
101: p_overpick_qtys2 IN WSH_UTIL_CORE.Id_Tab_Type,
102: p_bo_mode IN VARCHAR2,
103: p_bo_source IN VARCHAR2 DEFAULT 'SHIP',
104: x_out_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
105: x_return_status OUT NOCOPY VARCHAR2
106: );
107:
108: END WSH_SHIP_CONFIRM_ACTIONS2;