[Home] [Help]
PACKAGE: APPS.INV_REPLENISH_COUNT_PVT
Source
1 PACKAGE inv_replenish_count_pvt AUTHID CURRENT_USER AS
2 /* $Header: INVVRPCS.pls 120.0 2005/05/25 05:43:52 appldev noship $*/
3
4 /**
5 * Package : INV_REPLENISH_COUNT_PVT <br>
6 * File : INVVRPCS.pls <br>
7 * Content : <br>
8 * Description : <br>
9 * Notes :
10 * Modified : Mon Aug 25 12:17:54 GMT+05:30 2003 <br>
11 *
12 * Package Specification for INV_REPLENISH_COUNT_PVT.<br>
13 * This file contains procedures and functions needed for
14 * Replenishment Count being used in the mobile WMS/INV applications.<br>
15 * This package also includes APIs to process and report Count entries
16 * for a Replenishment Count.<b>
17 **/
18
19 TYPE t_genref IS REF CURSOR;
20 /**
21 * This Procedure is used to insert values into table mtl_replenish_lines<p>
22 * @param x_return_status Return Status<br>
23 * @param x_msg_count Message Count<br>
24 * @param x_msg_data Message Data<br>
25 * @param p_organization_id Organization Id<br>
26 * @param p_replenish_header_id Replenishment Count Header Id<br>
27 * @param p_locator_id Locator Id<br>
28 * @param p_item_id Item ID<br>
29 * @param p_count_type_code Count Type Code<br>
30 * @param p_count_quantity Count Quantity<br>
31 * @param p_count_uom_code Count Uom Code<br>
32 * @param p_primary_uom_code Primary Uom Code <br>
33 * @param p_count_secondary_uom_code Secondary Uom Code<br>
34 * @param p_count_secondary_quantity Secondary Quantity<br>
35 **/
36 PROCEDURE insert_row(
37 x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , p_organization_id IN NUMBER
41 , p_replenish_header_id IN NUMBER
42 , p_locator_id IN NUMBER
43 , p_item_id IN NUMBER
44 , p_count_type_code IN NUMBER
45 , p_count_quantity IN NUMBER
46 , p_count_uom_code IN VARCHAR2
47 , p_primary_uom_code IN VARCHAR2
48 , p_count_secondary_uom_code IN VARCHAR2 -- INVCONV, NSRIVAST
49 , p_count_secondary_quantity IN NUMBER -- INVCONV, NSRIVAST
50 );
51
52 /**
53 * This Procedure is used to update table mtl_replenish_lines.<p>
54 * @param x_return_status Return Status<br>
55 * @param x_msg_count Message Count<br>
56 * @param x_msg_data Message Data<br>
57 * @param p_item_id Item ID<br>
58 * @param p_replenish_header_id Replenishment Count Header Id<br>
59 * @param p_replenish_line_id Replenishment Count Line Id
60 * @param p_count_quantity Count Quantity<br>
61 * @param p_primary_uom_code Primary Uom Code<br>
62 * @param p_count_secondary_quantity Secondary Quantity<br>
63 **/
64 PROCEDURE update_row(
65 x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , p_item_id IN NUMBER
69 , p_replenish_header_id IN NUMBER
70 , p_replenish_line_id IN NUMBER
71 , p_count_quantity IN NUMBER
72 , p_count_uom_code IN VARCHAR2
73 , p_count_secondary_quantity IN NUMBER -- INVCONV, NSRIVAST
74 );
75
76 /** This Procedure is used to fetch the Replenishment Count lines for the user input.<p>
77 * @param x_return_status Return Status<br>
78 * @param x_msg_count Message Count<br>
79 * @param x_msg_data Message Data<br>
80 * @param x_replenish_count_lines_lov Replenish Count Lines LOV<br>
81 * @param p_replenish_header_id Replenishment Header Id<br>
82 * @param p_use_loc_pick_seq Use Locator Picking Sequence or not<br>
83 * @param p_organization_id Organization Id<br>
84 * @param p_subinventory_code Subinventory Code<br>
85 * @param p_planning_level Planning level of the subinventory<br>
86 * @param p_quantity_tracked Qauntity Tracked Flag of the Subinventory
87 **/
88 PROCEDURE fetch_count_lines(
89 x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT NOCOPY NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 , x_replenish_count_lines OUT NOCOPY t_genref
93 , p_replenish_header_id IN NUMBER
94 , p_use_loc_pick_seq IN VARCHAR2
95 , p_organization_id IN NUMBER
96 , p_subinventory_code IN VARCHAR2
97 , p_planning_level IN NUMBER
98 , p_quantity_tracked IN NUMBER
99 );
100
101 /** This procedure is used to get the Replenishment Count Name if the Subinventory and Organization passed
102 * as input has only one active Replenishment Count.<p>
103 * @param x_return_status Return Status<br>
104 * @param x_msg_count Message Count<br>
105 * @param x_msg_data Message Data<br>
106 * @param x_replenish_count_name Replenishment Count Name for the Subinventory and Organization passed<br>
107 * if there exists only obe active Replenishment Count.<br>
108 * NULL - Otherwise.<br>
109 * @param p_organization_id Organization ID<br>
110 * @param p_subinventory_code Subinventory Code<br>
111 * @param p_planning_level Subinventory Planning Level<br>
112 **/
113 PROCEDURE get_replenish_count_name(
114 x_return_status OUT NOCOPY VARCHAR2
115 , x_msg_count OUT NOCOPY NUMBER
116 , x_msg_data OUT NOCOPY VARCHAR2
117 , x_replenish_count_name OUT NOCOPY VARCHAR2
118 , p_organization_id IN NUMBER
119 , p_subinventory_code IN VARCHAR2
120 , p_planning_level IN NUMBER
121 );
122
123 /** This procedure is used to check whether invalid and/or uncounted lines exist.<p>
124 * @param x_return_status Return Status<br>
125 * @param x_msg_count Message Count<br>
126 * @param x_msg_data Message Data<br>
127 * @param p_replenish_header_id Replenishment Count Header Id<br>
128 * @param p_quantity_tracked Qauntity Tracked Flag of the Subinventory<br>
129 * @param p_planning_level Planning level of the subinventory<br>
130 * @param p_subinventory_code Subinventory Code<br>
131 * @RETURN NUMBER 1 - Invalid and uncounted lines exist.<br>
132 * 2 - Invalid but no uncounted lines exist.<br>
133 * 3 - No invalid but uncounted lines exist.<br>
134 * 4 - No invalid and no uncounted lines exist.<br>
135 **/
136 FUNCTION invalid_uncounted_lines_exist(
137 x_return_status OUT NOCOPY VARCHAR2
138 , x_msg_count OUT NOCOPY NUMBER
139 , x_msg_data OUT NOCOPY VARCHAR2
140 , p_replenish_header_id IN NUMBER
141 , p_quantity_tracked IN NUMBER
142 , p_planning_level IN NUMBER
143 , p_subinventory_code IN VARCHAR2
144 )
145 RETURN NUMBER;
146
147 /** This function returns if the Replenishment Count passed as input is a valid
148 * one for the passed subinventory planning level.<p>
149 * @param x_return_status Return Status<br>
150 * @param x_msg_count Message Count<br>
151 * @param x_msg_data Message Data<br>
152 * @param p_replenish_header_id Replenishment Count Header Id<br>
153 * @param p_planning_level Subinventory Planning Level<br>
154 * @RETURN NUMBER 1 - Count is valid.<br>
155 * 2 - Count is invalid.<br>
156 **/
157 FUNCTION is_count_valid(
158 x_return_status OUT NOCOPY VARCHAR2
159 , x_msg_count OUT NOCOPY NUMBER
160 , x_msg_data OUT NOCOPY VARCHAR2
161 , p_replenish_header_id IN NUMBER
162 , p_planning_level IN NUMBER
163 )
164 RETURN NUMBER;
165
166 /** This procedure submits the passed in Replenishment Count
167 * for processing and Report.<p>
168 * @param x_return_status Return Status<br>
169 * @param x_msg_count Message Count<br>
170 * @param x_msg_data Message Data<br>
171 * @param x_proces_request_id Process Request Id<br>
172 * @param p_replenish_header_id Replenishment Count Header Id<br>
173 * @param p_organization_id Organization Id<br>
174 **/
175 PROCEDURE process_report_count(
176 x_return_status OUT NOCOPY VARCHAR2
177 , x_msg_count OUT NOCOPY NUMBER
178 , x_msg_data OUT NOCOPY VARCHAR2
179 , x_process_request_id OUT NOCOPY NUMBER
180 , p_replenish_header_id IN NUMBER
181 , p_organization_id IN NUMBER
182 );
183 END inv_replenish_count_pvt;