1 PACKAGE MRP_Flow_Schedule_Util AS
2 /* $Header: MRPUSCNS.pls 120.1 2005/06/01 10:16:06 appldev $ */
3
4 -- Attributes global constants
5
6 G_ALTERNATE_BOM_DESIGNATOR CONSTANT NUMBER := 1;
7 G_ALTERNATE_ROUTING_DESIG CONSTANT NUMBER := 2;
8 G_ATTRIBUTE1 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE10 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE11 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE12 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE13 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE14 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE15 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE2 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE3 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE4 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE5 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE6 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE7 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE8 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE9 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 18;
24 G_BOM_REVISION CONSTANT NUMBER := 19;
25 G_BOM_REVISION_DATE CONSTANT NUMBER := 20;
26 G_BUILD_SEQUENCE CONSTANT NUMBER := 21;
27 G_CLASS CONSTANT NUMBER := 22;
28 G_COMPLETION_LOCATOR CONSTANT NUMBER := 23;
29 G_COMPLETION_SUBINVENTORY CONSTANT NUMBER := 24;
30 G_CREATED_BY CONSTANT NUMBER := 25;
31 G_CREATION_DATE CONSTANT NUMBER := 26;
32 G_DATE_CLOSED CONSTANT NUMBER := 27;
33 G_DEMAND_CLASS CONSTANT NUMBER := 28;
34 G_DEMAND_SOURCE_DELIVERY CONSTANT NUMBER := 29;
35 G_DEMAND_SOURCE_HEADER CONSTANT NUMBER := 30;
36 G_DEMAND_SOURCE_LINE CONSTANT NUMBER := 31;
37 G_DEMAND_SOURCE_TYPE CONSTANT NUMBER := 32;
38 G_LAST_UPDATED_BY CONSTANT NUMBER := 33;
39 G_LAST_UPDATE_DATE CONSTANT NUMBER := 34;
40 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 35;
41 G_LINE CONSTANT NUMBER := 36;
42 G_MATERIAL_ACCOUNT CONSTANT NUMBER := 37;
43 G_MATERIAL_OVERHEAD_ACCOUNT CONSTANT NUMBER := 38;
44 G_MATERIAL_VARIANCE_ACCOUNT CONSTANT NUMBER := 39;
45 G_MPS_NET_QUANTITY CONSTANT NUMBER := 40;
46 G_MPS_SCHEDULED_COMP_DATE CONSTANT NUMBER := 41;
47 G_ORGANIZATION CONSTANT NUMBER := 42;
48 G_OUTSIDE_PROCESSING_ACCT CONSTANT NUMBER := 43;
49 G_OUTSIDE_PROC_VAR_ACCT CONSTANT NUMBER := 44;
50 G_OVERHEAD_ACCOUNT CONSTANT NUMBER := 45;
51 G_OVERHEAD_VARIANCE_ACCOUNT CONSTANT NUMBER := 46;
52 G_PLANNED_QUANTITY CONSTANT NUMBER := 47;
53 G_PRIMARY_ITEM CONSTANT NUMBER := 48;
54 G_PROGRAM_APPLICATION CONSTANT NUMBER := 49;
55 G_PROGRAM CONSTANT NUMBER := 50;
56 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 51;
57 G_PROJECT CONSTANT NUMBER := 52;
58 G_QUANTITY_COMPLETED CONSTANT NUMBER := 53;
59 G_REQUEST CONSTANT NUMBER := 54;
60 G_RESOURCE_ACCOUNT CONSTANT NUMBER := 55;
61 G_RESOURCE_VARIANCE_ACCOUNT CONSTANT NUMBER := 56;
62 G_ROUTING_REVISION CONSTANT NUMBER := 57;
63 G_ROUTING_REVISION_DATE CONSTANT NUMBER := 58;
64 G_SCHEDULED_COMPLETION_DATE CONSTANT NUMBER := 59;
65 G_SCHEDULED CONSTANT NUMBER := 60;
66 G_SCHEDULED_START_DATE CONSTANT NUMBER := 61;
67 G_SCHEDULE_GROUP CONSTANT NUMBER := 62;
68 G_SCHEDULE_NUMBER CONSTANT NUMBER := 63;
69 G_STATUS CONSTANT NUMBER := 64;
70 G_STD_COST_ADJUSTMENT_ACCT CONSTANT NUMBER := 65;
71 G_TASK CONSTANT NUMBER := 66;
72 G_WIP_ENTITY CONSTANT NUMBER := 67;
73 G_MAX_ATTR_ID CONSTANT NUMBER := 68;
74 G_END_ITEM_UNIT_NUMBER CONSTANT NUMBER := 69;
75 G_QUANTITY_SCRAPPED CONSTANT NUMBER := 70;
76
77 G_ROLL_FORWARDED CONSTANT NUMBER := 1;
78 G_INTERMEDIATE_ROLL_FORWARDED CONSTANT NUMBER := 2;
79 -- Define record type
80 TYPE report_rec_type IS RECORD(
81 line_id NUMBER,
82 line_code VARCHAR2(10),
83 primary_item_id NUMBER,
84 item VARCHAR2(2000),
85 schedule_number VARCHAR2(30),
86 build_sequence NUMBER,
87 demand_class VARCHAR2(30),
88 demand_source_line VARCHAR2(30),
89 demand_source_header_id NUMBER,
90 demand_source_delivery VARCHAR2(30),
91 demand_source_type NUMBER,
92 schedule_group_id NUMBER,
93 schedule_group VARCHAR2(30),
94 completion_date DATE,
95 planned_quantity NUMBER,
96 quantity_completed NUMBER,
97 variance1 NUMBER,
98 to_completion_date DATE,
99 to_scheduled_qty NUMBER,
100 to_adjusted_qty NUMBER,
101 variance2 NUMBER,
102 MPS_SCHEDULED_COMPLETION_DATE DATE,
103 MPS_NET_QUANTITY NUMBER,
104 BOM_REVISION VARCHAR2(3),
105 ROUTING_REVISION VARCHAR2(3),
106 BOM_REVISION_DATE DATE,
107 ROUTING_REVISION_DATE DATE,
108 ALTERNATE_BOM_DESIGNATOR VARCHAR2(10),
109 ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10),
110 COMPLETION_SUBINVENTORY VARCHAR2(10),
111 COMPLETION_LOCATOR_ID NUMBER,
112 MATERIAL_ACCOUNT NUMBER,
113 MATERIAL_OVERHEAD_ACCOUNT NUMBER,
114 RESOURCE_ACCOUNT NUMBER,
115 OUTSIDE_PROCESSING_ACCOUNT NUMBER,
116 MATERIAL_VARIANCE_ACCOUNT NUMBER,
117 RESOURCE_VARIANCE_ACCOUNT NUMBER,
118 OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER,
119 STD_COST_ADJUSTMENT_ACCOUNT NUMBER,
120 OVERHEAD_ACCOUNT NUMBER,
121 OVERHEAD_VARIANCE_ACCOUNT NUMBER,
122 PROJECT_ID NUMBER,
123 TASK_ID NUMBER,
124 ATTRIBUTE_CATEGORY VARCHAR2(30),
125 ATTRIBUTE1 VARCHAR2(150),
126 ATTRIBUTE2 VARCHAR2(150),
127 ATTRIBUTE3 VARCHAR2(150),
128 ATTRIBUTE4 VARCHAR2(150),
129 ATTRIBUTE5 VARCHAR2(150),
130 ATTRIBUTE6 VARCHAR2(150),
131 ATTRIBUTE7 VARCHAR2(150),
132 ATTRIBUTE8 VARCHAR2(150),
133 ATTRIBUTE9 VARCHAR2(150),
134 ATTRIBUTE10 VARCHAR2(150),
135 ATTRIBUTE11 VARCHAR2(150),
136 ATTRIBUTE12 VARCHAR2(150),
137 ATTRIBUTE13 VARCHAR2(150),
138 ATTRIBUTE14 VARCHAR2(150),
139 ATTRIBUTE15 VARCHAR2(150),
140 KANBAN_CARD_ID NUMBER,
141 END_ITEM_UNIT_NUMBER VARCHAR2(30),
142 CURRENT_LINE_OPERATION NUMBER,
143 WIP_ENTITY_ID NUMBER /*Added to support 'Roll Flow Schedules: Maintain Schedule Number' project.*/
144 );
145
146 /* To support 'Roll Flow Schedules: Maintain Schedule Number' project.
147 This type is used in the variable to store old/new schedule/wip_entity_id */
148 TYPE FSSchNum IS TABLE OF WIP_FLOW_SCHEDULES.schedule_number%TYPE
149 INDEX BY BINARY_INTEGER;
150 TYPE FSWipId IS TABLE OF WIP_FLOW_SCHEDULES.wip_entity_id%TYPE
151 INDEX BY BINARY_INTEGER;
152
153
154 /**?
155 ' fs.MPS_SCHEDULED_COMPLETION_DATE, fs.MPS_NET_QUANTITY, '||
156 ' fs.BOM_REVISION, fs.ROUTING_REVISION,fs.BOM_REVISION_DATE, '||
157 ' fs.ROUTING_REVISION_DATE, fs.ALTERNATE_BOM_DESIGNATOR, '||
158 ' fs.ALTERNATE_ROUTING_DESIGNATOR, fs.COMPLETION_SUBINVENTORY, '||
159 ' fs.COMPLETION_LOCATOR_ID, fs.MATERIAL_ACCOUNT, '||
160 ' fs.MATERIAL_OVERHEAD_ACCOUNT, fs.RESOURCE_ACCOUNT, '||
161 ' fs.OUTSIDE_PROCESSING_ACCOUNT, fs.MATERIAL_VARIANCE_ACCOUNT, '||
162 ' fs.RESOURCE_VARIANCE_ACCOUNT, fs.OUTSIDE_PROC_VARIANCE_ACCOUNT, '||
163 ' fs.STD_COST_ADJUSTMENT_ACCOUNT, fs.OVERHEAD_ACCOUNT, '||
164 ' fs.OVERHEAD_VARIANCE_ACCOUNT, fs.PROJECT_ID,fs.TASK_ID, '||
165 ' fs.ATTRIBUTE_CATEGORY, fs.ATTRIBUTE1,fs.ATTRIBUTE2, '||
166 ' fs.ATTRIBUTE3, fs.ATTRIBUTE4,fs.ATTRIBUTE5, '||
167 ' fs.ATTRIBUTE6, fs.ATTRIBUTE7,fs.ATTRIBUTE8, '||
168 ' fs.ATTRIBUTE9, fs.ATTRIBUTE10,fs.ATTRIBUTE11, '||
169 ' fs.ATTRIBUTE12, fs.ATTRIBUTE13,fs.ATTRIBUTE14, '||
170 ' fs.ATTRIBUTE15, fs.KANBAN_CARD_ID,fs.END_ITEM_UNIT_NUMBER, '||
171 ' fs.CURRENT_LINE_OPERATION '||
172
173 /**/
174 -- Procedure Clear_Dependent_Attr
175 /*
176 Enhancement : 2665434
177 Description : Changed the usage of the record type from old record type
178 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
179 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
180 */
181
182 PROCEDURE Clear_Dependent_Attr
183 ( p_attr_id IN NUMBER DEFAULT NULL
184 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
185 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
186 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
187 );
188
189 -- Procedure Apply_Attribute_Changes
190 /*
191 Enhancement : 2665434
192 Description : Changed the usage of the record type from old record type
193 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
194 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
195 */
196
197 PROCEDURE Apply_Attribute_Changes
198 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
199 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
200 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
201 );
202
203 -- Function Complete_Record
204 /*
205 Enhancement : 2665434
206 Description : Changed the usage of the record type from old record type
207 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
208 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) and also reversed the logic.
209 */
210 FUNCTION Complete_Record
211 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
212 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
213 ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
214
215 -- Function Convert_Miss_To_Null
216 /*
217 Enhancement : 2665434
218 Description : Changed the usage of the record type from old record type
219 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
220 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
221 */
222
223 FUNCTION Convert_Miss_To_Null
224 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
225 ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
226
227 -- Procedure Update_Row
228 /*
229 Enhancement : 2665434
230 Description : Changed the usage of the record type from old record type
231 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
232 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
233 */
234 PROCEDURE Update_Row
235 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
236 );
237
238 -- Procedure Insert_Row
239 /*
240 Enhancement : 2665434
241 Description : Changed the usage of the record type from old record type
242 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
243 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
244 */
245 PROCEDURE Insert_Row
246 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
247 );
248
249 -- Procedure Delete_Row
250
251 PROCEDURE Delete_Row
252 ( p_wip_entity_id IN NUMBER
253 );
254
255 -- Function Query_Row
256 /*
257 Enhancement : 2665434
258 Description : Changed the return type from old record type (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to
259 new record type (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
260 */
261 FUNCTION Query_Row
262 ( p_wip_entity_id IN NUMBER
263 ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
264
265 -- Procedure lock_Row
266 --
267 /*
268 Enhancement : 2665434
269 Description : Changed the usage of the record type from old record type
270 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
271 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
272 */
273 PROCEDURE Lock_Row
274 ( x_return_status OUT NOCOPY VARCHAR2
275 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
276 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
277 );
278
279 -- Function Get_Values
280 /*
281 Enhancement : 2665434
282 Description : Changed the usage of the record type from old record type
283 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
284 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) .
285 */
286 FUNCTION Get_Values
287 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
288 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
289 ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type;
290
291 -- Function Get_Ids
292 /*
293 Enhancement : 2665434
294 Description : Changed the usage of the record type from old record type
295 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
296 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
297 */
298
299 FUNCTION Get_Ids
300 ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
301 , p_flow_schedule_val_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type
305 -- for the flow schedule summary buckets.
302 ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
303
304 -- Procedure populates mrp_form_query with the values necessary
306
307 PROCEDURE populate_flow_summary(
308 x_return_status OUT NOCOPY VARCHAR2,
309 p_line_id IN NUMBER,
310 p_org_id IN NUMBER,
311 p_first_bucket_date IN DATE,
312 p_query_id IN NUMBER
313 );
314
315 -- Simple update to update the quantity of a summary bucket
316
317 PROCEDURE Update_Quantity(
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2,
321 p_wip_entity_id IN NUMBER,
322 p_quantity IN NUMBER
323 );
324
325 PROCEDURE Update_Quantity(
326 p_wip_entity_id IN NUMBER,
327 p_quantity IN NUMBER
328 );
329
330 PROCEDURE Delete_Flow_Row(
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2,
334 p_wip_entity_id IN NUMBER
335 );
336
337 -- Globals used for the concurrent procedure
338 G_SUCCESS CONSTANT NUMBER := 0;
339 G_WARNING CONSTANT NUMBER := 1;
340 G_ERROR CONSTANT NUMBER := 2;
341
342 -- Delete flow schedules concurrent procedure
343 PROCEDURE Delete_Flow_Schedules( ERRBUF OUT NOCOPY VARCHAR2,
344 RETCODE OUT NOCOPY VARCHAR2,
345 p_organization_id IN NUMBER,
346 p_start_date IN VARCHAR2,
347 p_end_date IN VARCHAR2,
348 p_from_line IN VARCHAR2,
349 p_to_line IN VARCHAR2,
350 p_from_item IN VARCHAR2,
351 p_to_item IN VARCHAR2,
352 p_category_set_id IN NUMBER,
353 p_category_structure_id IN NUMBER,
354 p_from_category IN VARCHAR2,
355 p_to_category IN VARCHAR2);
356
357 -- Roll flow schedules concurrent procedure
358 /*
359 Enhancement : 2665434
360 Description : Changed the usage of the record type from old record type
361 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
362 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
363 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
364 */
365 PROCEDURE Roll_Flow_Schedules( ERRBUF OUT NOCOPY VARCHAR2,
366 RETCODE OUT NOCOPY VARCHAR2,
367 p_organization_id IN NUMBER,
368 p_spread_qty IN NUMBER,
369 p_dummy IN NUMBER,
370 p_dummy1 IN NUMBER,
371 p_dummy2 IN NUMBER,
372 p_dummy3 IN NUMBER,
373 p_dummy4 IN NUMBER,
374 p_output IN NUMBER,
375 p_from_start_date IN VARCHAR2,
376 p_from_end_date IN VARCHAR2,
377 p_to_start_date IN VARCHAR2,
378 p_to_end_date IN VARCHAR2,
379 p_from_line IN VARCHAR2,
380 p_to_line IN VARCHAR2,
381 p_from_item IN VARCHAR2,
382 p_to_item IN VARCHAR2,
383 p_category_set_id IN NUMBER,
384 p_category_structure_id IN NUMBER,
385 p_from_category IN VARCHAR2,
386 p_to_category IN VARCHAR2);
387
388 FUNCTION Item_Where_Clause( p_item_lo IN VARCHAR2,
389 p_item_hi IN VARCHAR2,
390 p_table_name IN VARCHAR2,
391 x_where OUT NOCOPY VARCHAR2,
392 x_err_buf OUT NOCOPY VARCHAR2)
393 RETURN BOOLEAN;
394
395 FUNCTION Category_Where_Clause ( p_cat_lo IN VARCHAR2,
396 p_cat_hi IN VARCHAR2,
397 p_table_name IN VARCHAR2,
398 p_cat_struct_id IN NUMBER,
399 p_where OUT NOCOPY VARCHAR2,
400 x_err_buf OUT NOCOPY VARCHAR2 )
401 RETURN BOOLEAN;
402
403 PROCEDURE Line_Schedule ( p_rule_id IN NUMBER,
404 p_line_id IN NUMBER,
405 p_org_id IN NUMBER,
406 p_sched_start_date IN DATE,
407 p_sched_end_date IN DATE,
411 x_msg_count OUT NOCOPY NUMBER,
408 p_update IN NUMBER,
409 p_flex_tolerance IN NUMBER,
410 x_return_status OUT NOCOPY VARCHAR2,
412 x_msg_data OUT NOCOPY VARCHAR2);
413
414 PROCEDURE Post_Schedule_Update ( p_org_id IN NUMBER) ;
415 PROCEDURE Explode_New_Items;
416
417 /*Bug 3042045*/
418 FUNCTION Get_Flow_Quantity ( p_demand_source_line IN VARCHAR2,
419 p_demand_source_type IN NUMBER,
420 p_demand_source_delivery IN VARCHAR2,
421 p_use_open_quantity IN VARCHAR2 )
422 RETURN NUMBER;
423
424 FUNCTION Get_Demand_Project ( p_demand_id IN NUMBER,
425 p_type IN NUMBER)
426 RETURN NUMBER;
427
428 FUNCTION Check_ATO_Holds ( p_line_id IN NUMBER,
429 p_header_id IN NUMBER,
430 p_action_id IN NUMBER)
431 RETURN NUMBER;
435 p_item_id IN NUMBER,
432
433 /*Bug 3042045*/
434 FUNCTION Get_Reservation_Quantity ( p_org_id IN NUMBER,
436 p_line_id IN NUMBER,
437 p_use_open_quantity IN VARCHAR2 )
438 RETURN NUMBER;
439
440 FUNCTION check_std_holds(p_line_id IN NUMBER) return NUMBER;
441
442 /*
443 * check holds for order header/line
444 */
445 FUNCTION Check_Holds(
446 p_header_id IN NUMBER,
447 p_line_id IN NUMBER,
448 p_wf_item IN VARCHAR2,
449 p_wf_activity IN VARCHAR2)
450 RETURN NUMBER;
451
452 --PRAGMA RESTRICT_REFERENCES (get_flow_quantity, WNDS, WNPS);
453 --PRAGMA RESTRICT_REFERENCES (get_demand_project, WNDS, WNPS);
454 --PRAGMA RESTRICT_REFERENCES (check_ato_holds, WNDS, WNPS);
455
456 /*
457 * get the first alternate routing designator for the item on the line
458 */
459 FUNCTION get_routing_designator(
460 p_item_id IN NUMBER,
461 p_organization_id IN NUMBER,
462 p_line_id IN NUMBER)
463 RETURN VARCHAR2;
464
465
466
467 END MRP_Flow_Schedule_Util;