[Home] [Help]
PACKAGE: APPS.MRP_FLOW_SCHEDULE_PVT
Source
1 PACKAGE MRP_Flow_Schedule_PVT AUTHID CURRENT_USER AS
2 /* $Header: MRPVWFSS.pls 120.0.12010000.2 2009/05/19 06:36:05 adasa ship $ */
3
4 -- Start of Comments
5 -- API name Process_Flow_Schedule
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 /*Enhancement : 2665434 .New record types defined for PLSQL standards compliance.
21 These record types do not have any defaulting .
22 */
23
24 TYPE Flow_Schedule_PVT_Rec_Type IS RECORD
25 ( alternate_bom_designator VARCHAR2(10)
26 , alternate_routing_desig VARCHAR2(10)
27 , attribute1 VARCHAR2(150)
28 , attribute10 VARCHAR2(150)
29 , attribute11 VARCHAR2(150)
30 , attribute12 VARCHAR2(150)
31 , attribute13 VARCHAR2(150)
32 , attribute14 VARCHAR2(150)
33 , attribute15 VARCHAR2(150)
34 , attribute2 VARCHAR2(150)
35 , attribute3 VARCHAR2(150)
36 , attribute4 VARCHAR2(150)
37 , attribute5 VARCHAR2(150)
38 , attribute6 VARCHAR2(150)
39 , attribute7 VARCHAR2(150)
40 , attribute8 VARCHAR2(150)
41 , attribute9 VARCHAR2(150)
42 , attribute_category VARCHAR2(30)
43 , bom_revision VARCHAR2(3)
44 , bom_revision_date DATE
45 , build_sequence NUMBER
46 , class_code VARCHAR2(10)
47 , completion_locator_id NUMBER
48 , completion_subinventory VARCHAR2(10)
49 , created_by NUMBER
50 , creation_date DATE
51 , date_closed DATE
52 , demand_class VARCHAR2(30)
53 , demand_source_delivery VARCHAR2(30)
54 , demand_source_header_id NUMBER
55 , demand_source_line VARCHAR2(30)
56 , demand_source_type NUMBER
57 , last_updated_by NUMBER
58 , last_update_date DATE
59 , last_update_login NUMBER
60 , line_id NUMBER
61 , material_account NUMBER
62 , material_overhead_account NUMBER
63 , material_variance_account NUMBER
64 , mps_net_quantity NUMBER
65 , mps_scheduled_comp_date DATE
66 , organization_id NUMBER
67 , outside_processing_acct NUMBER
68 , outside_proc_var_acct NUMBER
69 , overhead_account NUMBER
70 , overhead_variance_account NUMBER
71 , planned_quantity NUMBER
72 , primary_item_id NUMBER
73 , program_application_id NUMBER
74 , program_id NUMBER
75 , program_update_date DATE
76 , project_id NUMBER
77 , quantity_completed NUMBER
78 , request_id NUMBER
79 , resource_account NUMBER
80 , resource_variance_account NUMBER
81 , routing_revision VARCHAR2(3)
82 , routing_revision_date DATE
83 , scheduled_completion_date DATE
84 , scheduled_flag NUMBER
85 , scheduled_start_date DATE
86 , schedule_group_id NUMBER
87 , schedule_number VARCHAR2(30)
88 , status NUMBER
89 , std_cost_adjustment_acct NUMBER
90 , task_id NUMBER
91 , wip_entity_id NUMBER
92 , scheduled_by NUMBER
93 , return_status VARCHAR2(1)
94 , db_flag VARCHAR2(1)
95 , operation VARCHAR2(30)
96 , end_item_unit_number VARCHAR2(30)
97 , quantity_scrapped NUMBER
98 , kanban_card_id NUMBER
99 , synch_schedule_num VARCHAR2(30)
100 , synch_operation_seq_num NUMBER
101 , roll_forwarded_flag NUMBER
102 , current_line_operation NUMBER
103 , so_consumed_plan_id VARCHAR2(30) /*Added for bug 8200872 */
104 );
105
106 TYPE Flow_Schedule_Val_PVT_Rec_Type IS RECORD
107 ( completion_locator VARCHAR2(240)
108 , line VARCHAR2(240)
109 , organization VARCHAR2(240)
110 , primary_item VARCHAR2(240)
111 , project VARCHAR2(240)
112 , schedule_group VARCHAR2(240)
113 , task VARCHAR2(240)
114 , wip_entity VARCHAR2(240)
115 );
116
117 /*
118 Enhancement 2665434 : The following four procedures are for inter conversion between
119 MRP_Flow_Schedule_PUB.flow_schedule_rec_type and MRP_Flow_Schedule_PVT.flow_schedule_PVT_rec_type .
120 Similarly for inter conversion between Flow_Schedule_Val_Rec_Type and Flow_Schedule_Val_Pvt_Rec_Type.
121 */
122
123
124 PROCEDURE PUB_Flow_Sched_Val_Rec_To_PVT (
125 p_flow_schedule_Val_rec IN MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type ,
126 x_Flow_Schedule_Val_Pvt_Rec OUT NOCOPY Flow_Schedule_Val_Pvt_Rec_Type) ;
127
128 PROCEDURE PUB_Flow_Sched_Rec_To_PVT (
129 p_flow_schedule_rec IN MRP_Flow_Schedule_PUB.Flow_Schedule_Rec_Type ,
130 x_Flow_Schedule_Pvt_Rec OUT NOCOPY Flow_Schedule_Pvt_Rec_Type) ;
131
132 PROCEDURE PVT_Flow_Sched_Val_Rec_To_PUB (
133 p_Flow_Schedule_Val_Pvt_Rec IN Flow_Schedule_Val_Pvt_Rec_Type ,
134 x_flow_schedule_Val_Rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type ) ;
135
136 PROCEDURE PVT_Flow_Sched_Rec_To_PUB (
137 p_Flow_Schedule_Pvt_Rec IN Flow_Schedule_Pvt_Rec_Type ,
138 x_flow_schedule_Rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Rec_Type ) ;
139
140 /*Enhancement 2665434
141 Added parameter p_explode_bom . The code for BOM_OE_EXPLODER_PKG.be_exploder has been
142 shifted from MRP_Flow_Schedule_PUB.Process_Flow_Schedule to the PVT Process_Flow_Schedule
143 Changed defaulting from non-null values to NULL for p_init_msg_list,p_commit and p_validation_level
144 Removed defaulting from record types .
145 */
146
147 PROCEDURE Process_Flow_Schedule
148 ( p_api_version_number IN NUMBER
149 , p_init_msg_list IN VARCHAR2 := NULL
150 , p_commit IN VARCHAR2 := NULL
151 , p_validation_level IN NUMBER := NULL
152 , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
153 , x_return_status OUT NOCOPY VARCHAR2
154 , x_msg_count OUT NOCOPY NUMBER
155 , x_msg_data OUT NOCOPY VARCHAR2
156 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
157 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
158 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
159 , p_explode_bom IN VARCHAR2 := NULL
160 );
161
162 -- Start of Comments
163 -- API name Lock_Flow_Schedule
164 -- Type Private
165 -- Function
166 --
167 -- Pre-reqs
168 --
169 -- Parameters
170 --
171 -- Version Current version = 1.0
172 -- Initial version = 1.0
173 --
174 -- Notes
175 --
176 -- End of Comments
177
178 /*
179 Enhancement : 2665434
180 Description : Changed x_flow_schedule_rec to be of MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
181 Also removed defaulting for p_flow_Schedule_rec ,as the 2 allers to the procedure
182 1)From MRP_Flow_Schedule_PUB.Lock_Row
183 2)From MRP_WFS_Form_Flow_Schedule.Lock_Row
184 are passing this record type explicitly.
185 */
186
187 PROCEDURE Lock_Flow_Schedule
188 ( p_api_version_number IN NUMBER
189 , p_init_msg_list IN VARCHAR2 := NULL
190 , x_return_status OUT NOCOPY VARCHAR2
191 , x_msg_count OUT NOCOPY NUMBER
192 , x_msg_data OUT NOCOPY VARCHAR2
193 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
194 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
195 );
196
197 -- Start of Comments
198 -- API name Get_Flow_Schedule
199 -- Type Private
200 -- Function
201 --
202 -- Pre-reqs
203 --
204 -- Parameters
205 --
206 -- Version Current version = 1.0
207 -- Initial version = 1.0
208 --
209 -- Notes
210 --
211 -- End of Comments
212
213 /*
214 Enhancement : 2665434
215 Description : Changed x_flow_schedule_rec to be of
216 MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
217 */
218
219 PROCEDURE Get_Flow_Schedule
220 ( p_api_version_number IN NUMBER
221 , p_init_msg_list IN VARCHAR2 := NULL
222 , x_return_status OUT NOCOPY VARCHAR2
223 , x_msg_count OUT NOCOPY NUMBER
224 , x_msg_data OUT NOCOPY VARCHAR2
225 , p_wip_entity_id IN NUMBER
226 , x_flow_schedule_rec OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
227 );
228
229 END MRP_Flow_Schedule_PVT;