PACKAGE: APPS.OE_GROUP_SCH_UTIL

Source

1 PACKAGE OE_GROUP_SCH_UTIL AS
2 /* $Header: OEXUGRPS.pls 120.1.12000000.1 2007/01/16 22:02:40 appldev ship $ */
3 
4 TYPE number_arr IS TABLE OF number INDEX BY BINARY_INTEGER;
5 
6 Procedure Schedule_Order
7 (p_header_id       IN  NUMBER,
8  p_sch_action      IN  VARCHAR2,
9  x_atp_tbl         OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type,
10  x_return_status   OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
11  x_msg_count       OUT NOCOPY /* file.sql.39 change */ NUMBER,
12  x_msg_data        OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
13 
14 Procedure Schedule_Multi_lines
15 (p_selected_line_tbl  IN  OE_GLOBALS.Selected_Record_Tbl, --R12. MOAC
16  p_line_count     IN  NUMBER,
17  p_sch_action         IN  VARCHAR2,
18  x_atp_tbl        OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type,
19  x_return_status  OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20  x_msg_count      OUT NOCOPY /* file.sql.39 change */ NUMBER,
21  x_msg_data       OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
22 
23 Procedure Schedule_Set
24 (p_request_rec   IN  OE_ORDER_PUB.request_rec_type,
25  x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
26 
27 Procedure Schedule_set_lines
28 ( p_sch_set_tbl     IN  OE_ORDER_PUB.request_tbl_type
29 , x_return_status   OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
30 
31 Procedure Validate_Group
32 (p_x_line_tbl    IN  OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
33  p_sch_action    IN  VARCHAR2,
34  p_validate_action IN VARCHAR2 DEFAULT 'PARTIAL',     --Added for Bug 3590437
35  x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
36 
37 -- Added for Bug-2454163
38 FUNCTION Find_line( p_x_line_tbl  IN OE_ORDER_PUB.Line_Tbl_Type,
39                     p_line_id     IN  NUMBER)
40 Return BOOLEAN;
41 
42 Procedure Group_Schedule_sets
43 ( p_sch_set_tbl     IN  OE_ORDER_PUB.request_tbl_type
44 , x_return_status   OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
45 
46 TYPE set_rec_type is RECORD
47 ( line_id               NUMBER
48 , ship_set_id           NUMBER
49 , arrival_set_id        NUMBER
50 );
51 
52 TYPE set_Tbl_Type IS TABLE OF set_rec_type
53     INDEX BY BINARY_INTEGER;
54 
55 END OE_GROUP_SCH_UTIL;