[Home] [Help]
PACKAGE: APPS.OE_GRP_SCH_UTIL
Source
1 PACKAGE OE_GRP_SCH_UTIL AS
2 /* $Header: OEXVGRPS.pls 120.0 2005/06/01 00:26:12 appldev noship $ */
3
4 -- Global constant holding the package name
5
6 Type Sch_Group_Rec_Type IS RECORD (
7 request_id NUMBER := NULL,
8 entity_type VARCHAR2(30) := NULL,
9 header_id NUMBER := NULL, -- Group Identifier
10 line_id NUMBER := NULL, -- Group Identifier
11 top_model_line_id NUMBER := NULL, -- Group Identifier
12 ship_set_number NUMBER := NULL, -- Group Identifier
13 arrival_set_number NUMBER := NULL, -- Group Identifier
14 -- Group Attributes
15 ship_from_org_id NUMBER := NULL,
16 schedule_ship_date DATE := NULL,
17 schedule_arrival_date DATE := NULL,
18 request_date DATE := NULL,
19 ship_to_org_id NUMBER := NULL,
20 quantity NUMBER := NULL,
21 freight_carrier VARCHAR2(30) := NULL,
22 latest_date DATE := NULL,
23 demand_class_code VARCHAR2(30) := NULL,
24 shipment_priority VARCHAR2(30) := NULL,
25 -- Old Group Attributes
26 old_ship_set_number NUMBER := NULL,
27 old_arrival_set_number NUMBER := NULL,
28 old_ship_from_org_id NUMBER := NULL,
29 old_schedule_ship_date DATE := NULL,
30 old_schedule_arrival_date DATE := NULL,
31 old_request_date DATE := NULL,
32 old_ship_to_org_id NUMBER := NULL,
33 old_quantity NUMBER := NULL,
34 old_freight_carrier VARCHAR2(30) := NULL,
35 old_latest_date DATE := NULL,
36 old_demand_class_code VARCHAR2(30) := NULL,
37 old_shipment_priority VARCHAR2(30) := NULL,
38 -- Scheduling Action
39 action VARCHAR2(30) := NULL,
40 delayed_request VARCHAR2(30) := NULL,
41 explode VARCHAR2(30) := NULL);
42
43 TYPE number_arr IS TABLE OF number INDEX BY BINARY_INTEGER;
44
45 Procedure Group_Schedule(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
46 ,x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type
47
48 ,x_return_status OUT NOCOPY Varchar2);
49
50
51 Procedure Schedule_Order(p_header_id IN NUMBER,
52 p_sch_action IN VARCHAR2,
53 p_entity_type IN VARCHAR2,
54 p_line_id IN NUMBER,
55 x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
56
57 x_return_status OUT NOCOPY VARCHAR2,
58
59 x_msg_count OUT NOCOPY NUMBER,
60
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63
64 Procedure Schedule_ATO(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
65 x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
66
67 x_return_status OUT NOCOPY VARCHAR2);
68
69
70 Procedure Schedule_set_of_lines
71 ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
72 p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
73 x_return_status OUT NOCOPY VARCHAR2);
74
75
76 Procedure Process_set_of_lines
77 ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
78 := OE_ORDER_PUB.G_MISS_LINE_TBL,
79 p_write_to_db IN VARCHAR2 := FND_API.G_TRUE,
80 x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
81
82 p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
83 p_log_msg IN VARCHAR2 := 'Y',
84 x_return_status OUT NOCOPY VARCHAR2);
85
86
87 Procedure Schedule_SMC(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90
91 Procedure Schedule_Set(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
92 x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
93
94 x_return_status OUT NOCOPY VARCHAR2);
95
96
97 Procedure Sch_Multi_selected_lines
98 (p_line_list IN VARCHAR2,
99 p_line_count IN NUMBER,
100 p_action IN VARCHAR2,
101 x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
102
103 x_return_status OUT NOCOPY VARCHAR2,
104
105 x_msg_count OUT NOCOPY NUMBER,
106
107 x_msg_data OUT NOCOPY VARCHAR2);
108
109
110 Procedure Line_In_Sch_Group
111 (p_application_id IN NUMBER,
112 p_entity_short_name IN VARCHAR2,
113 p_validation_entity_short_name IN VARCHAR2,
114 p_validation_tmplt_short_name IN VARCHAR2,
115 p_record_set_short_name IN VARCHAR2,
116 p_scope IN VARCHAR2,
117 x_result OUT NOCOPY NUMBER);
118
119
120 FUNCTION Compare_Set_Attr
121 (p_set_ship_from_org_id IN NUMBER ,
122 p_line_ship_from_org_id IN NUMBER,
123 p_set_ship_to_org_id IN NUMBER,
124 p_line_ship_to_org_id IN NUMBER,
125 p_set_schedule_ship_date IN DATE,
126 p_line_schedule_ship_date IN DATE,
127 p_set_arrival_date IN DATE,
128 p_line_arrival_date IN DATE,
129 p_set_type IN VARCHAR2)
130 RETURN BOOLEAN;
131
132
133 END OE_GRP_SCH_UTIL;