[Home] [Help]
PACKAGE: APPS.MRP_FLOW_SCHEDULE_PVT
Source
1 PACKAGE MRP_Flow_Schedule_PVT AUTHID CURRENT_USER AS
2 /* $Header: MRPVWFSS.pls 115.5 2002/11/29 17:46:32 sjagan 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 );
104
105 TYPE Flow_Schedule_Val_PVT_Rec_Type IS RECORD
106 ( completion_locator VARCHAR2(240)
107 , line VARCHAR2(240)
108 , organization VARCHAR2(240)
109 , primary_item VARCHAR2(240)
110 , project VARCHAR2(240)
111 , schedule_group VARCHAR2(240)
112 , task VARCHAR2(240)
113 , wip_entity VARCHAR2(240)
114 );
115
116 /*
117 Enhancement 2665434 : The following four procedures are for inter conversion between
118 MRP_Flow_Schedule_PUB.flow_schedule_rec_type and MRP_Flow_Schedule_PVT.flow_schedule_PVT_rec_type .
119 Similarly for inter conversion between Flow_Schedule_Val_Rec_Type and Flow_Schedule_Val_Pvt_Rec_Type.
120 */
121
122
123 PROCEDURE PUB_Flow_Sched_Val_Rec_To_PVT (
124 p_flow_schedule_Val_rec IN MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type ,
125 x_Flow_Schedule_Val_Pvt_Rec OUT NOCOPY Flow_Schedule_Val_Pvt_Rec_Type) ;
126
127 PROCEDURE PUB_Flow_Sched_Rec_To_PVT (
128 p_flow_schedule_rec IN MRP_Flow_Schedule_PUB.Flow_Schedule_Rec_Type ,
129 x_Flow_Schedule_Pvt_Rec OUT NOCOPY Flow_Schedule_Pvt_Rec_Type) ;
130
131 PROCEDURE PVT_Flow_Sched_Val_Rec_To_PUB (
132 p_Flow_Schedule_Val_Pvt_Rec IN Flow_Schedule_Val_Pvt_Rec_Type ,
133 x_flow_schedule_Val_Rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type ) ;
134
135 PROCEDURE PVT_Flow_Sched_Rec_To_PUB (
136 p_Flow_Schedule_Pvt_Rec IN Flow_Schedule_Pvt_Rec_Type ,
137 x_flow_schedule_Rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Rec_Type ) ;
138
139 /*Enhancement 2665434
140 Added parameter p_explode_bom . The code for BOM_OE_EXPLODER_PKG.be_exploder has been
141 shifted from MRP_Flow_Schedule_PUB.Process_Flow_Schedule to the PVT Process_Flow_Schedule
142 Changed defaulting from non-null values to NULL for p_init_msg_list,p_commit and p_validation_level
143 Removed defaulting from record types .
144 */
145
146 PROCEDURE Process_Flow_Schedule
147 ( p_api_version_number IN NUMBER
148 , p_init_msg_list IN VARCHAR2 := NULL
149 , p_commit IN VARCHAR2 := NULL
150 , p_validation_level IN NUMBER := NULL
151 , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
152 , x_return_status OUT NOCOPY VARCHAR2
153 , x_msg_count OUT NOCOPY NUMBER
154 , x_msg_data OUT NOCOPY VARCHAR2
155 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
156 , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
157 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
158 , p_explode_bom IN VARCHAR2 := NULL
159 );
160
161 -- Start of Comments
162 -- API name Lock_Flow_Schedule
163 -- Type Private
164 -- Function
165 --
166 -- Pre-reqs
167 --
168 -- Parameters
169 --
170 -- Version Current version = 1.0
171 -- Initial version = 1.0
172 --
173 -- Notes
174 --
175 -- End of Comments
176
177 /*
178 Enhancement : 2665434
179 Description : Changed x_flow_schedule_rec to be of MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
180 Also removed defaulting for p_flow_Schedule_rec ,as the 2 allers to the procedure
181 1)From MRP_Flow_Schedule_PUB.Lock_Row
182 2)From MRP_WFS_Form_Flow_Schedule.Lock_Row
183 are passing this record type explicitly.
184 */
185
186 PROCEDURE Lock_Flow_Schedule
187 ( p_api_version_number IN NUMBER
188 , p_init_msg_list IN VARCHAR2 := NULL
189 , x_return_status OUT NOCOPY VARCHAR2
190 , x_msg_count OUT NOCOPY NUMBER
191 , x_msg_data OUT NOCOPY VARCHAR2
192 , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
193 , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
194 );
195
196 -- Start of Comments
197 -- API name Get_Flow_Schedule
198 -- Type Private
199 -- Function
200 --
201 -- Pre-reqs
202 --
203 -- Parameters
204 --
205 -- Version Current version = 1.0
206 -- Initial version = 1.0
207 --
208 -- Notes
209 --
210 -- End of Comments
211
212 /*
213 Enhancement : 2665434
214 Description : Changed x_flow_schedule_rec to be of
215 MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
216 */
217
218 PROCEDURE Get_Flow_Schedule
219 ( p_api_version_number IN NUMBER
220 , p_init_msg_list IN VARCHAR2 := NULL
221 , x_return_status OUT NOCOPY VARCHAR2
222 , x_msg_count OUT NOCOPY NUMBER
223 , x_msg_data OUT NOCOPY VARCHAR2
224 , p_wip_entity_id IN NUMBER
225 , x_flow_schedule_rec OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
226 );
227
228 END MRP_Flow_Schedule_PVT;