1 PACKAGE wms_re_common_pvt AS
2 /* $Header: WMSVPPCS.pls 120.1 2005/06/07 12:17:49 appldev $ */
3 -- File : WMSVPPCS.pls
4 -- Content : WMS_RE_Common_PVT package specification
5 -- Description : Common private procedures and functions internally used by
6 -- WMS strategy and rule API's.
7 --
8 -- Currently it manages the rule table
9 -- and the input line table (all plsql tables)
10 -- Notes :
11 -- Modified : 02/08/99 mzeckzer created
12
13 -- API name : InitInputTable
14 -- Type : Private
15 -- Function : Creates and initializes internal table of input records to
16 -- process.
17 PROCEDURE InitInputTable;
18 --
19 -- API name : InitInputPointer
20 -- Type : Private
21 -- Function : Initializes next pointer to the first available row in the
22 -- internal table of input records to process.
23 PROCEDURE InitInputPointer;
24 --
25 -- API name : InitInputLine
26 -- Type : Private
27 -- Function : Creates a new line in the internal table of input records to
28 -- process and initializes all neccessary values.
29 -- [ Added the following new columns(s) in PROCEDURE InitInputLine
30 -- to support serial allocation for serial reserved items ]
31
32 PROCEDURE InitInputLine
33 ( p_pp_transaction_temp_id IN NUMBER
34 ,p_revision IN VARCHAR2
35 ,p_lot_number IN VARCHAR2
36 ,p_lot_expiration_date IN DATE
37 ,p_from_subinventory_code IN VARCHAR2
38 ,p_from_locator_id IN NUMBER
39 ,p_from_cost_group_id IN NUMBER
40 ,p_to_subinventory_code IN VARCHAR2
41 ,p_to_locator_id IN NUMBER
42 ,p_to_cost_group_id IN NUMBER
43 ,p_transaction_quantity IN NUMBER
44 ,p_secondary_quantity IN NUMBER DEFAULT NULL
45 ,p_grade_code IN VARCHAR2 DEFAULT NULL
46 ,p_reservation_id IN NUMBER
47 ,p_serial_number IN VARCHAR2 DEFAULT NULL --- [ Added a new column - p_serial_number ]
48 ,p_lpn_id IN NUMBER
49 );
50 --
51 -- API name : GetCountInputLines
52 -- Type : Private
53 -- Function : Returns number of rows in the internal table of input
54 -- records to process.
55 FUNCTION GetCountInputLines RETURN INTEGER;
56 --
57 -- API name : GetNextInputLine
58 -- Type : Private
59 -- Function : Returns all values of the next row in the internal table of
60 -- input records to process and sets the next pointer to the
61 -- next available row.
62 -- [ Added the following new columns(s) in PROCEDURE GetNextInputLine
63 -- to support serial allocation for serial reserved items ]
64
65 PROCEDURE GetNextInputLine
66 ( x_pp_transaction_temp_id OUT NOCOPY NUMBER
67 ,x_revision OUT NOCOPY VARCHAR2
68 ,x_lot_number OUT NOCOPY VARCHAR2
69 ,x_lot_expiration_date OUT NOCOPY DATE
70 ,x_from_subinventory_code OUT NOCOPY VARCHAR2
71 ,x_from_locator_id OUT NOCOPY NUMBER
72 ,x_from_cost_group_id OUT NOCOPY NUMBER
73 ,x_to_subinventory_code OUT NOCOPY VARCHAR2
74 ,x_to_locator_id OUT NOCOPY NUMBER
75 ,x_to_cost_group_id OUT NOCOPY NUMBER
76 ,x_transaction_quantity OUT NOCOPY NUMBER
77 ,x_secondary_quantity OUT NOCOPY NUMBER
78 ,x_grade_code OUT NOCOPY VARCHAR2
79 ,x_reservation_id OUT NOCOPY NUMBER
80 ,x_serial_number OUT NOCOPY VARCHAR2 --- [ Added a new column - p_serial_number ]
81 ,x_lpn_id OUT NOCOPY NUMBER
82 );
83 --
84 -- API name : UpdateInputLine
85 -- Type : Private
86 -- Function : Updates the transaction quantity of the current row
87 -- in the internal table of input records to process
88 -- according to the provided value.
89 PROCEDURE UpdateInputLine
90 ( p_transaction_quantity IN NUMBER
91 , p_secondary_quantity IN NUMBER DEFAULT NULL
92 );
93 --
94 -- API name : DeleteInputLine
95 -- Type : Private
96 -- Function : Deletes the current row in the internal table of input
97 -- records to process.
98 PROCEDURE DeleteInputLine;
99 --
100 -- API name : InitRulesTable
101 -- Type : Private
102 -- Function : Creates and initializes internal table of all rules member
103 -- of the actual wms strategy to execute.
104 PROCEDURE InitRulesTable;
105 --
106 -- API name : InitRule
107 -- Type : Private
108 -- Function : Creates a new line in the internal table of strategy members
109 -- and initializes all neccessary values. Returns number of rows
110 -- created so far.
111 PROCEDURE InitRule
112 ( p_rule_id IN NUMBER
113 ,p_partial_success_allowed_flag IN VARCHAR2
114 ,x_rule_counter OUT NOCOPY NUMBER
115 );
116 --
117 -- API name : GetNextRule
118 -- Type : Private
119 -- Function : Returns all values of the next row in the internal table of
120 -- strategy members and sets the next pointer to the next
121 -- available row.
122 PROCEDURE GetNextRule
123 ( x_rule_id OUT NOCOPY NUMBER
124 ,x_partial_success_allowed_flag OUT NOCOPY VARCHAR2
125 );
126 END WMS_RE_Common_PVT;