[Home] [Help]
PACKAGE: APPS.INV_PULLSEQUENCE_PKG
Source
1 PACKAGE INV_PullSequence_PKG AUTHID CURRENT_USER as
2 /* $Header: INVKPSQS.pls 120.3 2011/02/17 06:37:34 sisankar ship $ */
3
4 FUNCTION Check_Unique( p_Pull_sequence_Id IN OUT NOCOPY NUMBER,
5 p_Organization_Id NUMBER,
6 p_Kanban_Plan_Id NUMBER,
7 p_Inventory_Item_Id NUMBER,
8 p_Subinventory_Name VARCHAR2,
9 p_Locator_Id NUMBER)
10 RETURN BOOLEAN ;
11
12 Procedure commit_row;
13
14 Procedure rollback_row;
15
16 FUNCTION Query_Row
17 ( p_pull_sequence_id IN NUMBER
18 ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
19
20 FUNCTION Convert_Miss_To_Null
21 ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
22 ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
23
24 FUNCTION Complete_Record
25 ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26 , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
27 ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
28
29 PROCEDURE Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type);
30 /*
31 PROCEDURE Insert_Row( x_return_status OUT NOCOPY VARCHAR2,
32 p_pull_sequence_id IN OUT NOCOPY NUMBER,
33 p_Inventory_item_id NUMBER,
34 p_Organization_id NUMBER,
35 p_Subinventory_name VARCHAR2,
36 p_Kanban_Plan_id NUMBER,
37 p_Source_type NUMBER,
38 p_Last_Update_Date DATE,
39 p_Last_Updated_By NUMBER,
40 p_Creation_Date DATE,
41 p_Created_By NUMBER,
42 p_Last_Update_Login NUMBER,
43 p_Locator_id NUMBER,
44 p_Supplier_id NUMBER,
45 p_Supplier_site_id NUMBER,
46 p_Source_Organization_id NUMBER,
47 p_Source_Subinventory VARCHAR2,
48 p_Source_Locator_id NUMBER,
49 p_Wip_Line_id NUMBER,
50 p_Release_kanban_flag NUMBER,
51 p_Calculate_kanban_flag NUMBER,
52 p_Kanban_size NUMBER,
53 p_Number_of_cards NUMBER,
54 p_Minimum_order_quantity NUMBER,
55 p_Aggregation_type NUMBER,
56 p_Allocation_Percent NUMBER,
57 p_Replenishment_lead_time NUMBER,
58 p_Fixed_Lot_multiplier NUMBER,
59 p_Safety_Stock_Days NUMBER,
60 p_Updated_Flag NUMBER,
61 p_Attribute_Category VARCHAR2,
62 p_Attribute1 VARCHAR2,
63 p_Attribute2 VARCHAR2,
64 p_Attribute3 VARCHAR2,
65 p_Attribute4 VARCHAR2,
66 p_Attribute5 VARCHAR2,
67 p_Attribute6 VARCHAR2,
68 p_Attribute7 VARCHAR2,
69 p_Attribute8 VARCHAR2,
70 p_Attribute9 VARCHAR2,
71 p_Attribute10 VARCHAR2,
72 p_Attribute11 VARCHAR2,
73 p_Attribute12 VARCHAR2,
74 p_Attribute13 VARCHAR2,
75 p_Attribute14 VARCHAR2,
76 p_Attribute15 VARCHAR2,
77 p_Request_Id NUMBER,
78 p_Program_application_Id NUMBER,
79 p_Program_Id NUMBER,
80 p_Program_Update_date DATE,
81 p_point_of_use_x NUMBER DEFAULT NULL,
82 p_point_of_use_y NUMBER DEFAULT NULL,
83 p_point_of_supply_x NUMBER DEFAULT NULL,
84 p_point_of_supply_y NUMBER DEFAULT NULL,
85 p_planning_update_status NUMBER DEFAULT NULL,
86 p_auto_request VARCHAR2 DEFAULT NULL,
87 p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Added P_Auto_Allocate_Flag for 3905884
88 --eKanban Changes
89 p_replenishment_type NUMBER DEFAULT NULL,
90 p_future_card_size NUMBER DEFAULT NULL,
91 p_future_no_of_cards NUMBER DEFAULT NULL,
92 p_planning_effectivity DATE DEFAULT NULL,
93 p_consolidation NUMBER DEFAULT NULL,
94 p_consolidation_group VARCHAR2 DEFAULT NULL,
95 p_avg_dependent_demand NUMBER DEFAULT NULL,
96 p_avg_independent_demand NUMBER DEFAULT NULL);
97 */
98
99 PROCEDURE Lock_Row (p_Pull_sequence_Id NUMBER,
100 p_Inventory_item_id NUMBER,
101 p_Organization_id NUMBER,
102 p_Subinventory_name VARCHAR2,
103 p_Kanban_Plan_id NUMBER,
104 p_Source_type NUMBER,
105 p_Locator_id NUMBER,
106 p_Supplier_id NUMBER,
107 p_Supplier_site_id NUMBER,
108 p_Source_Organization_id NUMBER,
109 p_Source_Subinventory VARCHAR2,
110 p_Source_Locator_id NUMBER,
111 p_Wip_Line_id NUMBER,
112 p_Release_kanban_flag NUMBER,
113 p_Calculate_kanban_flag NUMBER,
114 p_Kanban_size NUMBER,
115 p_Number_of_cards NUMBER,
116 p_Minimum_order_quantity NUMBER,
117 p_Aggregation_type NUMBER,
118 p_Allocation_Percent NUMBER,
119 p_Replenishment_lead_time NUMBER,
120 p_Fixed_Lot_multiplier NUMBER,
121 p_Safety_Stock_Days NUMBER,
122 p_Updated_Flag NUMBER,
123 p_Attribute_Category VARCHAR2,
124 p_Attribute1 VARCHAR2,
125 p_Attribute2 VARCHAR2,
126 p_Attribute3 VARCHAR2,
127 p_Attribute4 VARCHAR2,
128 p_Attribute5 VARCHAR2,
129 p_Attribute6 VARCHAR2,
130 p_Attribute7 VARCHAR2,
131 p_Attribute8 VARCHAR2,
132 p_Attribute9 VARCHAR2,
133 p_Attribute10 VARCHAR2,
134 p_Attribute11 VARCHAR2,
135 p_Attribute12 VARCHAR2,
136 p_Attribute13 VARCHAR2,
137 p_Attribute14 VARCHAR2,
138 p_Attribute15 VARCHAR2,
139 p_point_of_use_x NUMBER DEFAULT NULL,
140 p_point_of_use_y NUMBER DEFAULT NULL,
141 p_point_of_supply_x NUMBER DEFAULT NULL,
142 p_point_of_supply_y NUMBER DEFAULT NULL,
143 p_planning_update_status NUMBER DEFAULT NULL,
144 p_auto_request VARCHAR2 DEFAULT NULL,
145 p_Auto_Allocate_Flag NUMBER DEFAULT NULL); --Added P_Auto_Allocate_Flag for 3905884.
146
147
148 PROCEDURE Update_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_sequence_Rec_Type);
149 /*
150 PROCEDURE Update_Row( x_return_status OUT NOCOPY VARCHAR2,
151 p_Pull_sequence_Id NUMBER,
152 p_Inventory_item_id NUMBER,
153 p_Organization_id NUMBER,
154 p_Subinventory_name VARCHAR2,
155 p_Kanban_Plan_id NUMBER,
156 p_Source_type NUMBER,
157 p_Last_Update_Date DATE,
158 p_Last_Updated_By NUMBER,
159 p_Creation_Date DATE,
160 p_Created_By NUMBER,
161 p_Last_Update_Login NUMBER,
162 p_Locator_id NUMBER,
163 p_Supplier_id NUMBER,
164 p_Supplier_site_id NUMBER,
165 p_Source_Organization_id NUMBER,
166 p_Source_Subinventory VARCHAR2,
167 p_Source_Locator_id NUMBER,
168 p_Wip_Line_id NUMBER,
169 p_Release_kanban_flag NUMBER,
170 p_Calculate_kanban_flag NUMBER,
171 p_Kanban_size NUMBER,
172 p_Number_of_cards NUMBER,
173 p_Minimum_order_quantity NUMBER,
174 p_Aggregation_type NUMBER,
175 p_Allocation_Percent NUMBER,
176 p_Replenishment_lead_time NUMBER,
177 p_Fixed_Lot_multiplier NUMBER,
178 p_Safety_Stock_Days NUMBER,
179 p_Updated_Flag NUMBER,
180 p_Attribute_Category VARCHAR2,
181 p_Attribute1 VARCHAR2,
182 p_Attribute2 VARCHAR2,
183 p_Attribute3 VARCHAR2,
184 p_Attribute4 VARCHAR2,
185 p_Attribute5 VARCHAR2,
186 p_Attribute6 VARCHAR2,
187 p_Attribute7 VARCHAR2,
188 p_Attribute8 VARCHAR2,
189 p_Attribute9 VARCHAR2,
190 p_Attribute10 VARCHAR2,
191 p_Attribute11 VARCHAR2,
192 p_Attribute12 VARCHAR2,
193 p_Attribute13 VARCHAR2,
194 p_Attribute14 VARCHAR2,
195 p_Attribute15 VARCHAR2,
196 p_point_of_use_x NUMBER DEFAULT NULL,
197 p_point_of_use_y NUMBER DEFAULT NULL,
198 p_point_of_supply_x NUMBER DEFAULT NULL,
199 p_point_of_supply_y NUMBER DEFAULT NULL,
200 p_planning_update_status NUMBER DEFAULT NULL,
201 p_auto_request VARCHAR2 DEFAULT NULL,
202 p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Added P_Auto_Allocate_Flag for 3905884
203 --eKanban Changes
204 p_replenishment_type NUMBER DEFAULT NULL,
205 p_future_card_size NUMBER DEFAULT NULL,
206 p_future_no_of_cards NUMBER DEFAULT NULL,
207 p_planning_effectivity DATE DEFAULT NULL,
208 p_consolidation NUMBER DEFAULT NULL,
209 p_consolidation_group VARCHAR2 DEFAULT NULL,
210 p_avg_dependent_demand NUMBER DEFAULT NULL,
211 p_avg_independent_demand NUMBER DEFAULT NULL);
212 */
213
214
215
216 PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,
217 p_Pull_sequence_Id NUMBER);
218
219 PROCEDURE Update_Row(x_return_status OUT NOCOPY VARCHAR2,
220 p_Pull_Sequence_Id NUMBER,
221 p_Inventory_item_id NUMBER,
222 p_Organization_id NUMBER,
223 p_Subinventory_name VARCHAR2,
224 p_Kanban_Plan_id NUMBER,
225 p_Source_type NUMBER,
226 p_Last_Update_Date DATE,
227 p_Last_Updated_By NUMBER,
228 p_Creation_Date DATE,
229 p_Created_By NUMBER,
230 p_Last_Update_Login NUMBER,
231 p_Locator_id NUMBER,
232 p_Supplier_id NUMBER,
233 p_Supplier_site_id NUMBER,
234 p_Source_Organization_id NUMBER,
235 p_Source_Subinventory VARCHAR2,
236 p_Source_Locator_id NUMBER,
237 p_Wip_Line_id NUMBER,
238 p_Release_Kanban_flag NUMBER,
239 p_Calculate_Kanban_flag NUMBER,
240 p_Kanban_size NUMBER,
241 p_Number_of_cards NUMBER,
242 p_Minimum_order_quantity NUMBER,
243 p_Aggregation_Type NUMBER,
244 p_Allocation_Percent NUMBER,
245 p_Replenishment_lead_time NUMBER,
246 p_Fixed_Lot_multiplier NUMBER,
247 p_Safety_Stock_Days NUMBER,
248 p_Updated_Flag NUMBER,
249 p_Attribute_Category VARCHAR2,
250 p_Attribute1 VARCHAR2,
251 p_Attribute2 VARCHAR2,
252 p_Attribute3 VARCHAR2,
253 p_Attribute4 VARCHAR2,
254 p_Attribute5 VARCHAR2,
255 p_Attribute6 VARCHAR2,
256 p_Attribute7 VARCHAR2,
257 p_Attribute8 VARCHAR2,
258 p_Attribute9 VARCHAR2,
259 p_Attribute10 VARCHAR2,
260 p_Attribute11 VARCHAR2,
261 p_Attribute12 VARCHAR2,
262 p_Attribute13 VARCHAR2,
263 p_Attribute14 VARCHAR2,
264 p_Attribute15 VARCHAR2,
265 p_point_of_use_x NUMBER DEFAULT NULL,
266 p_point_of_use_y NUMBER DEFAULT NULL,
267 p_point_of_supply_x NUMBER DEFAULT NULL,
268 p_point_of_supply_y NUMBER DEFAULT NULL,
269 p_planning_update_status NUMBER DEFAULT NULL,
270 p_auto_request VARCHAR2 DEFAULT NULL,
271 p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Bug3905884
272 --eKanban Changes
273 p_replenishment_type NUMBER DEFAULT NULL,
274 p_future_card_size NUMBER DEFAULT NULL,
275 p_future_no_of_cards NUMBER DEFAULT NULL,
276 p_planning_effectivity DATE DEFAULT NULL,
277 p_consolidation NUMBER DEFAULT NULL,
278 p_consolidation_group VARCHAR2 DEFAULT NULL,
279 p_avg_dependent_demand NUMBER DEFAULT NULL,
280 p_avg_independent_demand NUMBER DEFAULT NULL,
281 p_last_imp_plan VARCHAR2 DEFAULT NULL,
282 p_imp_plan_start_date DATE DEFAULT NULL,
283 p_imp_plan_end_date DATE DEFAULT NULL,
284 p_no_of_temp_card NUMBER DEFAULT NULL,
285 p_no_of_temp_cycle NUMBER DEFAULT NULL,
286 p_temp_exp_date DATE DEFAULT NULL);
287
288 PROCEDURE Insert_Row(x_return_status OUT NOCOPY Varchar2,
289 p_pull_sequence_id IN Out NOCOPY NUMBER,
290 p_Inventory_item_id NUMBER,
291 p_Organization_id NUMBER,
292 p_Subinventory_name VARCHAR2,
293 p_Kanban_Plan_id NUMBER,
294 p_Source_type NUMBER,
295 p_Last_Update_Date DATE,
296 p_Last_Updated_By NUMBER,
297 p_Creation_Date DATE,
298 p_Created_By NUMBER,
299 p_Last_Update_Login NUMBER,
300 p_Locator_id NUMBER,
301 p_Supplier_id NUMBER,
302 p_Supplier_site_id NUMBER,
303 p_Source_Organization_id NUMBER,
304 p_Source_Subinventory VARCHAR2,
305 p_Source_Locator_id NUMBER,
306 p_Wip_Line_id NUMBER,
307 p_Release_Kanban_Flag NUMBER,
308 p_Calculate_Kanban_Flag NUMBER,
309 p_Kanban_size NUMBER,
310 p_Number_of_cards NUMBER,
311 p_Minimum_order_quantity NUMBER,
312 p_Aggregation_type NUMBER,
313 p_Allocation_Percent NUMBER,
314 p_Replenishment_lead_time NUMBER,
315 p_Fixed_Lot_multiplier NUMBER,
316 p_Safety_Stock_Days NUMBER,
317 p_Updated_Flag NUMBER,
318 p_Attribute_Category VARCHAR2,
319 p_Attribute1 VARCHAR2,
320 p_Attribute2 VARCHAR2,
321 p_Attribute3 VARCHAR2,
322 p_Attribute4 VARCHAR2,
323 p_Attribute5 VARCHAR2,
324 p_Attribute6 VARCHAR2,
325 p_Attribute7 VARCHAR2,
326 p_Attribute8 VARCHAR2,
327 p_Attribute9 VARCHAR2,
328 p_Attribute10 VARCHAR2,
329 p_Attribute11 VARCHAR2,
330 p_Attribute12 VARCHAR2,
331 p_Attribute13 VARCHAR2,
332 p_Attribute14 VARCHAR2,
333 p_Attribute15 VARCHAR2,
334 p_Request_Id NUMBER,
335 p_Program_application_Id NUMBER,
336 p_Program_Id NUMBER,
337 p_Program_Update_date DATE,
338 p_point_of_use_x NUMBER DEFAULT NULL,
339 p_point_of_use_y NUMBER DEFAULT NULL,
340 p_point_of_supply_x NUMBER DEFAULT NULL,
341 p_point_of_supply_y NUMBER DEFAULT NULL,
342 p_planning_update_status NUMBER DEFAULT NULL,
343 p_auto_request VARCHAR2 DEFAULT NULL,
344 p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Bug3905884
345 --eKanban Changes
346 p_replenishment_type NUMBER DEFAULT NULL,
347 p_future_card_size NUMBER DEFAULT NULL,
348 p_future_no_of_cards NUMBER DEFAULT NULL,
349 p_planning_effectivity DATE DEFAULT NULL,
350 p_consolidation NUMBER DEFAULT NULL,
351 p_consolidation_group VARCHAR2 DEFAULT NULL,
352 p_avg_dependent_demand NUMBER DEFAULT NULL,
353 p_avg_independent_demand NUMBER DEFAULT NULL,
354 p_last_imp_plan VARCHAR2 DEFAULT NULL,
355 p_imp_plan_start_date DATE DEFAULT NULL,
356 p_imp_plan_end_date DATE DEFAULT NULL,
357 p_no_of_temp_card NUMBER DEFAULT NULL,
358 p_no_of_temp_cycle NUMBER DEFAULT NULL,
359 p_temp_exp_date DATE DEFAULT NULL);
360
361 END INV_PullSequence_PKG;