1 PACKAGE Oe_Config_Schedule_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OEXVCSCS.pls 120.1.12010000.1 2008/07/25 07:59:23 appldev ship $ */
3
4 /*----------------------------------------------------------------
5 This record type will be used to remember imp. old and changed
6 values on the lines. The related records will be collected in
7 a table and will be used in the delayed request execution.
8 -----------------------------------------------------------------*/
9
10 TYPE Reservation_Rec_Type IS RECORD
11 ( entity_id NUMBER
12 ,line_id NUMBER
13 ,qty_to_reserve NUMBER
14 ,qty_to_unreserve NUMBER
15 ,qty2_to_reserve NUMBER -- INVCONV
16 ,qty2_to_unreserve NUMBER -- INVCONV
17 );
18
19 TYPE OE_Reservations_Tbl_Type is TABLE OF
20 Reservation_Rec_Type INDEX BY binary_integer;
21
22 OE_Reservations_Tbl OE_Reservations_Tbl_Type;
23
24 -------------- Constants ---------------------------------------
25 -- Caller used in process_group API
26 SCH_ATO CONSTANT VARCHAR2(30) := 'SCHEDULE_ATO';
27 SCH_UI CONSTANT VARCHAR2(30) := 'UI_ACTION';
28 SCH_SET CONSTANT VARCHAR2(30) := 'SCHEDULE_SET';
29
30 --------------- Public Procedures ------------------------------
31
32 PROCEDURE Log_Config_Sch_Request
33 ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
34 ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
35 ,p_sch_action IN VARCHAR2
36 ,p_caller IN VARCHAR2 := OE_SCHEDULE_UTIL.SCH_INTERNAL
37 ,x_return_status OUT NOCOPY VARCHAR2);
38
39
40 PROCEDURE Schedule_ATO
41 ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
42 ,x_return_status OUT NOCOPY VARCHAR2);
43
44
45 PROCEDURE Schedule_SMC
46 ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
47 ,x_return_status OUT NOCOPY VARCHAR2);
48
49
50 PROCEDURE Schedule_NONSMC
51 ( p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
52 ,p_res_changes IN VARCHAR2 := 'N'
53 ,x_return_status OUT NOCOPY VARCHAR2);
54
55
56 PROCEDURE Process_Group
57 ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
58 ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
59 ,p_sch_action IN VARCHAR2
60 ,p_caller IN VARCHAR2 := 'X'
61 ,p_handle_unreserve IN VARCHAR2 := 'N'
62 ,p_partial IN BOOLEAN := FALSE
63 ,p_partial_set IN BOOLEAN := FALSE
64 ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
65 ,x_return_status OUT NOCOPY VARCHAR2);
66
67
68 Procedure Query_Set_Lines
69 (p_header_id IN NUMBER,
70 p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
71 p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,
72 p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
73 p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
74 p_sch_action IN VARCHAR2,
75 p_send_cancel_lines IN VARCHAR2 := 'N',
76 x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
77 x_return_status OUT NOCOPY VARCHAR2);
78
79 PROCEDURE Delete_Attribute_Changes
80 (p_entity_id NUMBER := -1);
81
82 PROCEDURE Save_Sch_Attributes
83 ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
84 ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
85 ,p_sch_action IN VARCHAR2
86 ,p_caller IN VARCHAR2
87 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
88
89 PROCEDURE Update_Reservation
90 ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
91 ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
92 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
93 END Oe_Config_Schedule_Pvt;