1 PACKAGE WSH_SHIP_CONFIRM_ACTIONS2 as
2 /* $Header: WSHDDSPS.pls 120.1.12010000.1 2008/07/29 05:59:43 appldev ship $ */
3 --
4 --Function: part_of_ship_set
5 --Parameters: p_source_line_id
6 --Description: This function returns a boolean number that indicates
7 -- if the order line is part of a ship set
8
9 FUNCTION Part_Of_Ship_Set(p_source_line_id number) RETURN BOOLEAN;
10
11 --
12 --Procedure: Get_Line_Total_Shp_Qty
13 --Parameters: p_stop_id
14 -- p_source_line_id
15 -- x_line_shp_qty
16 -- x_return_status
17 --Description: This procedure calculates the total shippped quantity
18 -- for a order line/source line in a specified delivery
19
20 -- OPM KYH 12/SEP/00 - add x_line_shp_qty2 to out params
21 -- =====================================================
22 PROCEDURE Get_Line_Total_Shp_Qty(
23 p_stop_id in number
24 , p_source_line_id in number
25 , x_line_shp_qty out NOCOPY number
26 , x_line_shp_qty2 out NOCOPY number
27 , x_return_status out NOCOPY varchar2) ;
28
29 --
30 --Procedure: Ship_Zero_Quantity
31 --Parameters: p_source_line_id
32 -- x_return_status
33 --Description: This procedure especailly handle the case when we try
34 -- to ship zero quantity for a line
35 --
36 PROCEDURE Ship_Zero_Quantity(
37 p_source_line_id IN NUMBER
38 , x_return_status OUT NOCOPY VARCHAR2
39 );
40
41 --
42 --Procedure: Backorder
43 --Parameters: p_details_id : Table of delivery detail id with zero
44 -- shipped quantity and cycle_count_quantity = requested_quantity
45 -- p_bo_qtys = normal quantity to backorder/cycle-count
46 -- p_overpick_qtys = excess overpicked quantity to cancel
47 -- for backorder purpose
48 -- x_return_status
49 --Description: This procedure especailly handle the case when we try
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,
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
68 --
69 --Procedure: Check_Exception
70 --Parameters: p_detail_id : delivery detail id which is checked
71 -- x_exception_exist : out parameter which indicates if
72 -- exception exists for the delivery detail
73 -- x_severity_present : out parameter which indicates if
74 -- maximum severity of exception is either 'H' - High,
75 -- 'M' - Medium or 'L' - Low
76 -- x_return_status
77 --Description: This procedure check if exception exists for a detail
78 --
79 PROCEDURE check_exception(
80 p_delivery_detail_id IN NUMBER
81 , x_exception_exist OUT NOCOPY VARCHAR2
82 , x_severity_present OUT NOCOPY VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 );
85
86 --
87 -- Procedure: Backorder
88 -- Description: This is a wrapper of the BackOrder procedure already present in the package.
89 -- This is introduced for Consolidation of BO Delivery Details project.
90 -- This wrapper avoids the change of the calls made to Backorder api from different apis
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,
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;