1 PACKAGE WSH_SHIP_CONFIRM_ACTIONS2 AUTHID CURRENT_USER as
2 /* $Header: WSHDDSPS.pls 120.2 2010/09/01 06:53:27 anvarshn 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_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 --
70 --Procedure: Check_Exception
71 --Parameters: p_detail_id : delivery detail id which is checked
72 -- x_exception_exist : out parameter which indicates if
73 -- exception exists for the delivery detail
74 -- x_severity_present : out parameter which indicates if
75 -- maximum severity of exception is either 'H' - High,
76 -- 'M' - Medium or 'L' - Low
77 -- x_return_status
78 --Description: This procedure check if exception exists for a detail
79 --
80 PROCEDURE check_exception(
81 p_delivery_detail_id IN NUMBER
82 , x_exception_exist OUT NOCOPY VARCHAR2
83 , x_severity_present OUT NOCOPY VARCHAR2
84 , x_return_status OUT NOCOPY VARCHAR2
85 );
86
87 --
88 -- Procedure: Backorder
89 -- Description: This is a wrapper of the BackOrder procedure already present in the package.
90 -- This is introduced for Consolidation of BO Delivery Details project.
91 -- This wrapper avoids the change of the calls made to Backorder api from different apis
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,
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;
[Home] [Help]