1 PACKAGE OE_SCHEDULE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUSCHS.pls 120.21 2011/03/03 09:53:43 rmoharan ship $ */
3
4 -- scheduling actions
5
6 OESCH_ACT_RESERVE CONSTANT VARCHAR2(30) := 'RESERVE';
7 OESCH_ACT_SCHEDULE CONSTANT VARCHAR2(30) := 'SCHEDULE';
8 OESCH_ACT_DEMAND CONSTANT VARCHAR2(30) := 'SCHEDULE';
9 OESCH_ACT_SOURCE CONSTANT VARCHAR2(30) := 'SOURCE';
10 OESCH_ACT_UNDEMAND CONSTANT VARCHAR2(30) := 'UNSCHEDULE';
11 OESCH_ACT_UNRESERVE CONSTANT VARCHAR2(30) := 'UNRESERVE';
12 OESCH_ACT_UNSCHEDULE CONSTANT VARCHAR2(30) := 'UNSCHEDULE';
13 OESCH_ACT_ATP_CHECK CONSTANT VARCHAR2(30) := 'ATP_CHECK';
14 OESCH_ACT_RESCHEDULE CONSTANT VARCHAR2(30) := 'RESCHEDULE';
15 OESCH_ACT_RES_TRANSFER CONSTANT VARCHAR2(30) := 'RES_TRANSFER';
16 OESCH_ACT_REDEMAND CONSTANT VARCHAR2(30) := 'REDEMAND';
17 OESCH_ACT_CHECK_SCHEDULING CONSTANT VARCHAR2(30) := 'CHECK_SCHEDULING';
18
19
20 -- scheduling entitites
21
22 OESCH_ENTITY_ORDER CONSTANT VARCHAR2(30) := 'ORDER';
23 OESCH_ENTITY_SET CONSTANT VARCHAR2(30) := 'SET';
24 OESCH_ENTITY_SHIP_SET CONSTANT VARCHAR2(30) := 'SHIP_SET';
25 OESCH_ENTITY_ARRIVAL_SET CONSTANT VARCHAR2(30) := 'ARRIVAL_SET';
26 OESCH_ENTITY_SMC CONSTANT VARCHAR2(30) := 'SHIP_MODEL_COMPLETE';
27 OESCH_ENTITY_ATO_CONFIG CONSTANT VARCHAR2(30) := 'ATO_CONFIG';
28 OESCH_ENTITY_CONFIGURATION CONSTANT VARCHAR2(30) := 'CONFIGURATION';
29 OESCH_ENTITY_O_LINE CONSTANT VARCHAR2(30) := 'ORDER_LINE';
30 OESCH_ENTITY_P_LINE CONSTANT VARCHAR2(30) := 'PARENT_LINE';
31 OESCH_ENTITY_LINE CONSTANT VARCHAR2(30) := 'LINE';
32
33 --Caller
34 SCH_INTERNAL CONSTANT VARCHAR2(30) := 'INTERNAL';
35 SCH_EXTERNAL CONSTANT VARCHAR2(30) := 'EXTERNAL';
36
37 -- Valid Scheduling levels
38
39 SCH_LEVEL_ONE CONSTANT VARCHAR2(30) := 'ONE';
40 SCH_LEVEL_TWO CONSTANT VARCHAR2(30) := 'TWO';
41 SCH_LEVEL_THREE CONSTANT VARCHAR2(30) := 'THREE';
42 -- BUG 1955004
43 SCH_LEVEL_FOUR CONSTANT VARCHAR2(30) := 'FOUR';
44 SCH_LEVEL_FIVE CONSTANT VARCHAR2(30) := 'FIVE';
45 -- END 1955004
46
47 -- 6663462 Delayed_schedule
48
49 OE_Delayed_Schedule_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
50
51
52
53 -- Valid Scheduling Status.
54
55 OESCH_STATUS_SCHEDULED CONSTANT VARCHAR2(30) := 'SCHEDULED';
56
57 -- Auto Schedule Flag and globals
58
59 OESCH_PERFORM_SCHEDULING VARCHAR2(1) := 'Y';
60 OESCH_AUTO_SCH_FLAG VARCHAR2(30) := 'N';
61 OESCH_AUTO_SCH_FLAG_FROM_USER VARCHAR2(30) := 'N';
62 OESCH_PERFORM_GRP_SCHEDULING VARCHAR2(1) := 'Y';
63 --11825106
64 OESCH_SET_SCHEDULING VARCHAR2(1) := 'Y';
65
66 OESCH_AUTO_SCHEDULE_PROFILE VARCHAR2(30) :=
67 FND_PROFILE.VALUE('ONT_AUTOSCHEDULE');
68
69 --Added for ER 6110708
70 OESCH_ITEM_IS_SUBSTITUTED VARCHAR2(1) := 'N';
71
72 /* Bug: 2097933..
73 This flag is to indicate if Reservation has been
74 performed on this line or not */
75 OESCH_PERFORMED_RESERVATION VARCHAR2(1) := 'N';
76
77 -- Scheduling action flag
78 G_LINE_ACTION VARCHAR2(30);
79
80
81 -- Cached Values
82
83 sch_cached_header_id NUMBER;
84 sch_cached_sch_level_code VARCHAR2(30);
85 sch_cached_sch_level_code_head VARCHAR2(30);
86 sch_cached_sch_level_code_line VARCHAR2(30);
87 sch_cached_order_type VARCHAR2(80);
88 sch_cached_line_type_id NUMBER;
89 sch_cached_line_type VARCHAR2(80);
90 MRP_SESSION_ID NUMBER := 0;
91 -- 3748723 : New cache variables for sales order id
92 sch_cached_mtl_order_type_id NUMBER;
93 sch_cached_mtl_order_type_name VARCHAR2(80);
94 sch_cached_mtl_sales_order_id NUMBER;
95 sch_cached_mtl_header_id NUMBER;
96 sch_cached_mtl_source_code VARCHAr2(40);
97
98 -- BUG 1955004
99 TYPE inactive_demand_rec_type IS RECORD
100 (line_id NUMBER
101 ,scheduling_level_code VARCHAR2(30));
102
103 TYPE OE_inactive_demand_tbl_type IS TABLE OF
104 inactive_demand_rec_type INDEX by BINARY_INTEGER;
105
106 OE_inactive_demand_tbl OE_inactive_demand_tbl_type;
107 --END 1955004
108
109 -- BUG 1282873
110 TYPE sch_rec_type IS RECORD
111 ( line_id NUMBER
112 ,attribute1 varchar2(30));
113
114 TYPE oe_sch_tbl_type is TABLE OF
115 sch_rec_type INDEX BY binary_integer;
116
117 OE_Override_Tbl OE_sch_Tbl_Type;
118 -- END 1282873
119 oe_split_rsv_tbl OE_sch_Tbl_Type; -- 8706868
120 /* -- 3288805 --*/
121 G_HEADER_ID NUMBER := null; -- moved from body to spec.
122 G_DATE_TYPE VARCHAR2(30) := null; -- moved from body to spec.
123
124
125 PROCEDURE Schedule_line
126 ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
127 ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
128 ,p_caller IN VARCHAR2 := SCH_INTERNAL
129 ,x_return_status OUT NOCOPY VARCHAR2);
130
131
132
133 FUNCTION Need_Scheduling
134 ( p_line_rec IN OE_ORDER_PUB.line_rec_type
135 ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
136 ,x_line_action OUT NOCOPY VARCHAR2
137
138 ,x_auto_sch OUT NOCOPY VARCHAR2)
139
140 RETURN BOOLEAN;
141
142
143 PROCEDURE Validate_Line
144 ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
145 ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
146 ,p_sch_action IN VARCHAR2
147 ,p_caller IN VARCHAR2 := SCH_EXTERNAL
148 ,x_return_status OUT NOCOPY VARCHAR2);
149
150
151 Procedure Process_request
152 ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
153 ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
154 ,p_caller IN VARCHAR2
155 ,p_sch_action IN VARCHAR2
156 ,x_return_status OUT NOCOPY VARCHAR2);
157
158
159
160 FUNCTION Get_Lead_Time
161 ( p_ato_line_id IN NUMBER
162 ,p_ship_from_org_id IN NUMBER)
163 RETURN NUMBER;
164
165
166 FUNCTION Get_Date_Type
167 ( p_header_id IN NUMBER)
168 RETURN VARCHAR2;
169
170
171 FUNCTION Get_Order_Number(p_header_id in number)
172 RETURN NUMBER;
173
174
175 Procedure Load_INV_Request
176 ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
177 ,p_quantity_to_reserve IN NUMBER
178 ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL -- INVCONV
179 ,x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type);
180
181
182
183 Procedure Insert_Into_Mtl_Sales_Orders
184 ( p_header_rec IN OE_ORDER_PUB.header_rec_type);
185
186 FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER,
187 p_order_type_id IN NUMBER DEFAULT NULL) --3745318 added a new parameter p_order_type_id
188 RETURN NUMBER;
189
190 FUNCTION Get_Scheduling_Level( p_header_id IN NUMBER,
191 p_line_type_id IN NUMBER)
192 RETURN VARCHAR2;
193
194 Procedure Process_Group_of_lines
195 ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
196 ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
197 ,p_caller IN VARCHAR2
198 ,x_return_status OUT NOCOPY VARCHAR2);
199
200
201 Procedure Process_line
202 ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
203 ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
204 ,p_caller IN VARCHAR2
205 ,p_call_prn IN BOOLEAN := TRUE
206 ,x_return_status OUT NOCOPY VARCHAR2);
207
208
209 -- BUG 1955004
210 Procedure Inactive_Demand_Scheduling
211 ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
212 ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
213 ,p_sch_action IN VARCHAR2 := NULL
214 ,x_return_status OUT NOCOPY VARCHAR2);
215
216 -- END 1955004
217
218 Procedure Load_MRP_request_from_tbl
219 ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
220 ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
221 ,p_partial_set IN BOOLEAN := FALSE
222 ,p_sch_action IN VARCHAR2 := NULL
223 ,p_part_of_set IN VARCHAR2 DEFAULT 'N' --4405004
224 ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ);
225
226
227 -- Added parameter p_old_line_tbl to support bug 1955004
228 Procedure Load_Results_from_tbl
229 ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
230 , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
231 , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
232 , p_sch_action IN VARCHAR2 := NULL
233 , p_partial IN BOOLEAN := FALSE
234 , p_partial_set IN BOOLEAN := FALSE
235 , x_return_status OUT NOCOPY VARCHAR2);
236
237
238 Procedure ATP_Check
239 ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
240 p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
241 p_validate IN VARCHAR2 := FND_API.G_TRUE,
242 x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
243
244 x_return_status OUT NOCOPY VARCHAR2);
245
246
247 PROCEDURE Multi_ATP_Check
248 (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
249 p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
250 x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
251
252 x_return_status OUT NOCOPY VARCHAR2);
253
254
255 Procedure Unreserve_Line
256 ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
257 ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 6628134
258 ,p_quantity_to_unreserve IN NUMBER
259 ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL-- INCONV
260 ,x_return_status OUT NOCOPY VARCHAR2);
261
262
263 Procedure Reserve_line
264 ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
265 ,p_quantity_to_reserve IN NUMBER
266 ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL-- INCONV
267 ,p_rsv_update IN BOOLEAN DEFAULT FALSE -- To be passed as TRUE where there is an increase to the reserve quantity
268 ,x_return_status OUT NOCOPY VARCHAR2);
269
270
271 PROCEDURE Set_Auto_Sch_Flag
272 (p_value_from_user IN VARCHAR2 := FND_API.G_MISS_CHAR);
273
274 --Bug 5948059
275 --To return the value of OESCH_AUTO_SCH_FLAG
276 FUNCTION Get_Auto_Sch_Flag
277 RETURN VARCHAR2;
278
279 Procedure SPLIT_SCHEDULING
280 ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
281 , x_return_status OUT NOCOPY VARCHAR2);
282
283
284
285 TYPE mrp_line_rec_type is RECORD
286 ( line_id NUMBER
287 , schedule_ship_date DATE
288 , schedule_arrival_date DATE
289 , ship_from_org_id NUMBER
290 , ship_method_code VARCHAR2(30)
291 );
292
293 TYPE Mrp_Line_Tbl_Type IS TABLE OF mrp_line_rec_type
294 INDEX BY BINARY_INTEGER;
295
296 Procedure Update_Results_from_backlog_wb
297 ( p_mrp_line_tbl IN mrp_line_tbl_type
298 , x_msg_count OUT NOCOPY NUMBER
299
300 , x_msg_data OUT NOCOPY VARCHAR2
301
302 , x_return_status OUT NOCOPY VARCHAR2);
303
304
305 FUNCTION Get_Session_Id
306 RETURN number;
307
308 FUNCTION Get_MRP_Session_Id
309 RETURN number;
310
311 Procedure Insert_Mandatory_Components
312 (p_order_number IN NUMBER,
313 p_ato_line_id IN NUMBER,
314 p_customer_name IN VARCHAR2,
315 p_customer_location IN VARCHAR2,
316 p_arrival_set_name IN VARCHAR2,
317 p_ship_set_name IN VARCHAR2,
318 p_ship_set_id IN NUMBER,
319 p_requested_ship_date IN DATE,
320 p_requested_arrival_date IN DATE,
321 p_session_id IN NUMBER,
322 p_instance_id IN NUMBER,
323 p_insert_code IN NUMBER,
324 x_return_status OUT NOCOPY VARCHAR2
325
326 );
327
328 Function Within_Rsv_Time_Fence(p_schedule_ship_date IN DATE,
329 p_org_id IN NUMBER)
330 RETURN BOOLEAN;
331
332 Procedure Delete_Row(p_line_id IN NUMBER);
333
334 Procedure Call_MRP_ATP
335 ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336 ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
337 ,x_return_status OUT NOCOPY VARCHAR2);
338
339
340 Procedure Post_Forms_Commit
341 (x_return_status OUT NOCOPY VARCHAR2
342
343 ,x_msg_count OUT NOCOPY NUMBER
344
345 ,x_msg_data OUT NOCOPY VARCHAR2);
346
347
348 Procedure call_process_order
349 ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
350 , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
351 , p_control_rec IN OE_GLOBALS.control_rec_type
352 , p_caller IN VARCHAR2
353 , x_return_status OUT NOCOPY VARCHAR2);
354
355
356 PROCEDURE Handle_External_Lines
357 (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type);
358
359 /*----------------------------------------------------------------
360 This record type will be used to remember old inventory item
361 values on the lines which is part of set. The related records will be
362 used in execution of set delayed request.
363 -----------------------------------------------------------------*/
364
365 TYPE Inventory_item_rec_type IS RECORD
366 ( line_id NUMBER
367 ,inventory_item_id NUMBER);
368
369 TYPE OE_Item_Tbl_Type is TABLE OF
370 Inventory_item_rec_type INDEX BY binary_integer;
371
372 OE_Item_Tbl OE_Item_Tbl_Type;
373
374 -- Start 2434807 --
375
376 G_ATP_TBL OE_ATP.atp_tbl_type; -- Moved from Package body to Scpec.
377
378 PROCEDURE Get_Atp_Table_Count(p_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
379 p_atp_tbl_cnt OUT NOCOPY NUMBER);
380
381 -- End 2434807 --
382
383 Procedure Display_Sch_Errors
384 ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
385 , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
386 := OE_ORDER_PUB.G_MISS_LINE_TBL
387 , p_line_id IN NUMBER DEFAULT NULL);
388
389
390 FUNCTION Schedule_Attribute_Changed
391 ( p_line_rec IN Oe_Order_Pub.line_rec_type
392 , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
393 RETURN BOOLEAN;
394
395 FUNCTION Set_Attr_Matched(p_set_ship_from_org_id IN NUMBER ,
396 p_line_ship_from_org_id IN NUMBER,
397 p_set_ship_to_org_id IN NUMBER,
398 p_line_ship_to_org_id IN NUMBER,
399 p_set_schedule_ship_date IN DATE,
400 p_line_schedule_ship_date IN DATE,
401 p_set_arrival_date IN DATE,
402 p_line_arrival_date IN DATE,
403 p_set_shipping_method_code IN VARCHAR2,
404 p_line_shipping_method_code IN VARCHAR2,
405 p_set_type IN VARCHAR2)
406 RETURN BOOLEAN;
407
408 FUNCTION Validate_ship_method
409 (p_new_ship_method IN VARCHAR2,
410 p_old_ship_method IN VARCHAR2,
411 p_ship_from_org_id IN NUMBER)
412 RETURN BOOLEAN;
413
414 -- Start 2595661
415 FUNCTION Get_Pick_Status (p_line_id IN NUMBER) RETURN BOOLEAN;
416
417 PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
418 ,p_quantity_to_unreserve IN NUMBER
419 ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
420 ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
421 ,x_return_status OUT NOCOPY VARCHAR2);
422
423 -- End 2595661
424
425 -- 2391781
426 /*----------------------------------------------------------------
427 This record type will be used to store modified scheduling attribute item
428 values on the lines which is part of set. The related records will be
429 used in cascading during group scheduling.
430 -----------------------------------------------------------------*/
431
432 TYPE cascade_sch_rec_type IS RECORD
433 ( line_id NUMBER
434 ,set_id NUMBER
435 ,attribute1 VARCHAR2(240):= NULL
436 ,attribute2 VARCHAR2(240):= NULL
437 ,date_attribute1 DATE := NULL);
438
439 TYPE OE_sch_Attrb_Tbl_Type is TABLE OF
440 cascade_sch_rec_type INDEX BY binary_integer;
441
442 OE_sch_Attrb_Tbl OE_sch_Attrb_Tbl_Type;
443
444 Procedure Schedule_Split_Lines
445 ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
446 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
447
448 Procedure Update_PO(p_schedule_ship_date IN DATE,
449 p_source_document_id IN VARCHAR2,
450 p_source_document_line_id IN VARCHAR2);
451 -- Pack J
452 PROCEDURE Promise_Date_for_Sch_Action
453 (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
454 ,p_sch_action IN VARCHAR2
455 ,P_header_id IN NUMBER DEFAULT NULL);
456
457 PROCEDURE Global_atp(p_line_id IN NUMBER);
458
459 FUNCTION Get_ATP_CHECK_Session_Id
460 RETURN number;
461
462 Procedure Cascade_Ship_Set_Attr
463 ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
464 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
465
466 -- 4026758
467 Procedure Log_Delete_Set_Request
468 (p_header_id IN NUMBER,
469 p_line_id IN NUMBER,
470 p_set_id IN NUMBER,
471 x_return_status OUT NOCOPY VARCHAR2);
472
473 /* Added the following 2 procedures to fix the bug 6378240 */
474
475 PROCEDURE MRP_ROLLBACK
476 ( p_line_id IN NUMBER
477 ,p_schedule_action_code IN VARCHAR2
478 ,x_return_status OUT NOCOPY VARCHAR2);
479
480 PROCEDURE CALL_MRP_ROLLBACK
481 ( x_return_status OUT NOCOPY VARCHAR2);
482
483 /* Added the following procedure to fix the bug 6663462 */
484
485 Procedure DELAYED_SCHEDULE_LINES
486 ( x_return_status OUT NOCOPY VARCHAR2);
487
488 -- Added for ER 6110708
489 PROCEDURE IS_ITEM_SUBSTITUTED
490 (
491 p_application_id IN NUMBER
492 , p_entity_short_name IN VARCHAR2
493 , p_validation_entity_short_name IN VARCHAR2
494 , p_validation_tmplt_short_name IN VARCHAR2
495 , p_record_set_short_name IN VARCHAR2
496 , p_scope IN VARCHAR2
497 , x_result_out OUT NOCOPY NUMBER
498 );
499
500 -- Added for ER 6110708
501 PROCEDURE IS_LINE_PICKED
502 (
503 p_application_id IN NUMBER
504 , p_entity_short_name IN VARCHAR2
505 , p_validation_entity_short_name IN VARCHAR2
506 , p_validation_tmplt_short_name IN VARCHAR2
507 , p_record_set_short_name IN VARCHAR2
508 , p_scope IN VARCHAR2
509 , x_result_out OUT NOCOPY NUMBER
510 );
511
512 /*----------------------------------------------------------------------------------
513 * PROCEDURE res_against_req_po
514 * Added for ER 9224462. This API will validate if there are any reservations of a
515 * line against a REQ or PO. If it has, p_result will return 1, else return 0.
516 * This API has standard signature as required by Processing Constraints framework,
517 * for API based Validation template. Based on this API a Validation template will
518 * be created.
519 * ---------------------------------------------------------------------------------*/
520 PROCEDURE res_against_req_po
521 ( p_application_id IN NUMBER,
522 p_entity_short_name in VARCHAR2,
523 p_validation_entity_short_name in VARCHAR2,
524 p_validation_tmplt_short_name in VARCHAR2,
525 p_record_set_tmplt_short_name in VARCHAR2,
526 p_scope in VARCHAR2,
527 p_result OUT NOCOPY NUMBER );
528
529 /*4241385*/
530 /*----------------------------------------------------------------------------------
531 * PROCEDURE GET_SET_DETAILS
532 * Added for ER 4241385. This API will take set_id as the input parameter and return
533 whether the set exists or not (new set, or exisitng set) and if the set exisits,
534 whether it is scheduled or not.
535 * ---------------------------------------------------------------------------------*/
536
537 PROCEDURE get_set_details
538 ( p_set_id IN NUMBER
539 ,x_set_exists OUT NOCOPY BOOLEAN
540 ,x_set_scheduled OUT NOCOPY BOOLEAN );
541
542
543 Procedure Log_Set_Request
544 (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
545 p_old_line_rec IN OE_ORDER_PUB.Line_rec_type, -- making public for 4241385
546 p_sch_action IN VARCHAR2,
547 p_caller IN VARCHAR2,
548 x_return_status OUT NOCOPY VARCHAR2);
549
550 END OE_SCHEDULE_UTIL;
551