PACKAGE: APPS.OE_GROUP_SCH_UTIL

Source

1 PACKAGE OE_GROUP_SCH_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUGRPS.pls 120.2.12020000.1 2012/06/26 09:29:26 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 Procedure Validate_Item_Warehouse
47 (p_inventory_item_id      IN NUMBER,  -- 4241385
48  p_ship_from_org_id       IN NUMBER,
49  x_return_status OUT NOCOPY  VARCHAR2);
50 
51 TYPE set_rec_type is RECORD
52 ( line_id               NUMBER
53 , ship_set_id           NUMBER
54 , arrival_set_id        NUMBER
55 );
56 
57 TYPE set_Tbl_Type IS TABLE OF set_rec_type
58     INDEX BY BINARY_INTEGER;
59 
60 END OE_GROUP_SCH_UTIL;