1 PACKAGE BOM_Op_Seq_UTIL AUTHID CURRENT_USER AS
2 /* $Header: BOMUOPSS.pls 120.1 2006/01/03 22:17:27 bbpatel noship $ */
3 /*#
4 * This API contains Routing Operation entity utility procedure. Utility procedures
5 * include insert, update, query, delete and perform writes (insert/update/delete) for a row.
6 *
7 * @rep:scope private
8 * @rep:product BOM
9 * @rep:lifecycle active
10 * @rep:displayname Routing Operation Utitlity package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
13 */
14
15 /****************************************************************************
16 --
17 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
18 -- All rights reserved.
19 --
20 -- FILENAME
21 --
22 -- BOMUOPSS.pls
23 --
24 -- DESCRIPTION
25 --
26 -- Spec of package BOM_Op_Seq_UTIL
27 --
28 -- NOTES
29 --
30 -- HISTORY
31 -- 07-AUG-2000 Masanori Kimizuka Initial Creation
32 --
33 ****************************************************************************/
34
35
36 /****************************************************************************
37 * QUERY ROW
38 *****************************************************************************/
39
40 /** Routing BO Query_Row **/
41 /*#
42 * Procedure to query a database record and return the populated Exposed and Unexposed
43 * Routing Operation record.
44 *
45 * @param p_operation_sequence_number IN Operation Sequence Number
46 * @param p_effectivity_date IN Operation Effectivity Date
47 * @param p_routing_sequence_id IN Routing Sequence Id
48 * @param p_operation_type IN Operation Type
49 * @param p_mesg_token_tbl IN Input Message Token Table
50 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
51 * @param x_operation_rec IN OUT NOCOPY Populated Routing Operation Exposed Record from queried row
52 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
53 * @param x_op_unexp_rec IN OUT NOCOPY Populated Routing Operation Unexposed Record from queried row
54 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
55 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
56 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
57 * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
58 *
59 * @rep:scope private
60 * @rep:lifecycle active
61 * @rep:displayname Query a row for Routing Operation record
62 * @rep:compatibility S
63 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
64 */
65 PROCEDURE Query_Row
66 ( p_operation_sequence_number IN NUMBER
67 , p_effectivity_date IN DATE
68 , p_routing_sequence_id IN NUMBER
69 , p_operation_type IN NUMBER
70 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
71 , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
72 , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
73 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
74 , x_return_status IN OUT NOCOPY VARCHAR2
75 ) ;
76
77
78
79 /** ECO BO Query_Row **/
80 /*#
81 * Procedure to query a database record and return the populated Exposed and Unexposed
82 * Revised Routing Operation record.
83 *
84 * @param p_operation_sequence_number IN Operation Sequence Number
85 * @param p_effectivity_date IN Operation Effectivity Date
86 * @param p_routing_sequence_id IN Routing Sequence Id
87 * @param p_operation_type IN Operation Type
88 * @param p_mesg_token_tbl IN Input Message Token Table
89 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
90 * @param x_rev_operation_rec IN OUT NOCOPY Populated Revised Routing Operation Exposed Record from queried row
91 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
92 * @param x_rev_op_unexp_rec IN OUT NOCOPY Populated Revised Routing Operation Unexposed Record from queried row
93 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
94 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
95 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
96 * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
97 *
98 * @rep:scope private
99 * @rep:lifecycle active
100 * @rep:displayname Query a row for Revised Routing Operation record
101 * @rep:compatibility S
102 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
103 */
104 PROCEDURE Query_Row
105 ( p_operation_sequence_number IN NUMBER
106 , p_effectivity_date IN DATE
107 , p_routing_sequence_id IN NUMBER
108 , p_operation_type IN NUMBER
109 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
110 , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
111 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
112 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
113 , x_return_status IN OUT NOCOPY VARCHAR2
114 ) ;
115
116
117
118
119 /** Common Operation Query_Row **/
120 /*#
121 * Procedure to query a database record and return the populated Exposed and Unexposed
122 * Common Routing Operation record.
123 *
124 * @param p_operation_sequence_number IN Operation Sequence Number
125 * @param p_effectivity_date IN Operation Effectivity Date
126 * @param p_routing_sequence_id IN Routing Sequence Id
127 * @param p_operation_type IN Operation Type
128 * @param p_mesg_token_tbl IN Input Message Token Table
129 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
130 * @param x_com_operation_rec IN OUT NOCOPY Populated Common Routing Operation Exposed Record from queried row
131 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
132 * @param x_com_op_unexp_rec IN OUT NOCOPY Populated Common Routing Operation Unexposed Record from queried row
133 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
134 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
135 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
136 * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
137 *
138 * @rep:scope private
139 * @rep:lifecycle active
140 * @rep:displayname Query a row for Common Routing Operation record
141 * @rep:compatibility S
142 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
143 */
144 PROCEDURE Query_Row
145 ( p_operation_sequence_number IN NUMBER
146 , p_effectivity_date IN DATE
147 , p_routing_sequence_id IN NUMBER
148 , p_operation_type IN NUMBER
149 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
150 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
151 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
152 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
153 , x_return_status IN OUT NOCOPY VARCHAR2
154 ) ;
155
156
157 /****************************************************************************
158 * PERFORM WRITE
159 *****************************************************************************/
160
161 /** Routing BO Perform Writes **/
162 /*#
163 * Procedure to insert/update/delete a database record using Exposed and Unexposed
164 * Routing Operation record depending on Transaction Type.
165 *
166 * @param p_operation_rec IN Routing Operation Exposed Record
167 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
168 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
169 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
170 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
171 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
172 * @param x_return_status IN OUT NOCOPY Return Status
173 *
174 * @rep:scope private
175 * @rep:lifecycle active
176 * @rep:displayname Insert/Update/Delete a row for Routing Operation record
177 * @rep:compatibility S
178 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
179 */
180 PROCEDURE Perform_Writes
181 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
182 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
183 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
184 , x_return_status IN OUT NOCOPY VARCHAR2
185 ) ;
186
187 /** ECO BO Perform Writes **/
188 /*#
189 * Procedure to insert/update/delete a database record using Exposed and Unexposed
190 * Revised Routing Operation record depending on Transaction Type.
191 *
192 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
193 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
194 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
195 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
196 * @param p_control_rec IN Control Record
197 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
198 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
199 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
200 * @param x_return_status IN OUT NOCOPY Return Status
201 *
202 * @rep:scope private
203 * @rep:lifecycle active
204 * @rep:displayname Insert/Update/Delete a row for Revised Routing Operation record
205 * @rep:compatibility S
206 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
207 */
208 PROCEDURE Perform_Writes
209 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
210 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
211 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
212 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
213 , x_return_status IN OUT NOCOPY VARCHAR2
214 ) ;
215
216 /** Common Operation Perform Writes **/
217 /*#
218 * Procedure to insert/update/delete a database record using Exposed and Unexposed
219 * Common Routing Operation record depending on Transaction Type.
220 *
221 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
222 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
223 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
224 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
225 * @param p_control_rec IN Control Record
226 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
227 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
228 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
229 * @param x_return_status IN OUT NOCOPY Return Status
230 *
231 * @rep:scope private
232 * @rep:lifecycle active
233 * @rep:displayname Insert/Update/Delete a row for Common Routing Operation record
234 * @rep:compatibility S
235 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
236 */
237 PROCEDURE Perform_Writes
238 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
239 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
240 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
241 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242 , x_return_status IN OUT NOCOPY VARCHAR2
243 ) ;
244
245 /****************************************************************************
246 * OTHERS
247 *****************************************************************************/
248
249 /** Insert Operation **/
250 /*#
251 * Procedure inserts a database record using Exposed and Unexposed
252 * Routing Operation record.
253 *
254 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
255 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
256 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
257 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
258 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
259 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
260 * @param x_return_status IN OUT NOCOPY Return Status
261 *
262 * @rep:scope private
263 * @rep:lifecycle active
264 * @rep:displayname Insert a row for Routing Operation record
265 * @rep:compatibility S
266 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
267 */
268 PROCEDURE Insert_Row
269 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
270 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
271 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
272 , x_return_status IN OUT NOCOPY VARCHAR2
273 ) ;
274
275 /** Update Operation **/
276 /*#
277 * Procedure updates a database record using Exposed and Unexposed
278 * Routing Operation record.
279 *
280 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
281 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
282 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
283 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
284 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
285 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
286 * @param x_return_status IN OUT NOCOPY Return Status
287 *
288 * @rep:scope private
289 * @rep:lifecycle active
290 * @rep:displayname Update a row for Routing Operation record
291 * @rep:compatibility S
292 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
293 */
294 PROCEDURE Update_Row
295 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
296 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
297 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
298 , x_return_status IN OUT NOCOPY VARCHAR2
299 ) ;
300
301
302 /** Delete Operations **/
303 /*#
304 * Procedure deletes a database record using Exposed and Unexposed
305 * Routing Operation record. For ECO BO, revised operation record will be
306 * deleted. For Routing BO, a delete group will be created to delete an Operation.
307 *
308 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
309 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
310 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
311 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
312 * @param x_com_operation_rec IN OUT NOCOPY Common Routing Operation Exposed Record after deletion
313 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
314 * @param x_com_op_unexp_rec IN OUT NOCOPY Common Routing Operation Unexposed Record after deletion
315 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
316 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
317 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
318 * @param x_return_status IN OUT NOCOPY Return Status
319 *
320 * @rep:scope private
321 * @rep:lifecycle active
322 * @rep:displayname Delete a row for Routing Operation record
323 * @rep:compatibility S
324 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
325 */
326 PROCEDURE Delete_Row
327 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
328 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
329 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
330 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
331 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
332 , x_return_status IN OUT NOCOPY VARCHAR2
333 ) ;
334
335 /** ECO BO Cancel Revised Operation **/
336
337 /*#
338 * This procedure is commented out to remove the dependency of Routing BO code on ENG.
339 *
340 * @param p_operation_sequence_id IN Operation Sequence Id
341 * @param p_cancel_comments IN Cancel Comments
342 * @param p_op_seq_num IN Operation Sequence Number
343 * @param p_user_id IN User Id
344 * @param p_login_id IN Login Id
345 * @param p_prog_id IN Program Id
346 * @param p_prog_appid IN Program Application Id
347 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
348 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
349 * @param x_return_status IN OUT NOCOPY Return Status
350 *
351 * @rep:scope private
352 * @rep:lifecycle active
353 * @rep:displayname Cancel the Revised Operation
354 * @rep:compatibility S
355 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
356 */
357 PROCEDURE Cancel_Operation
358 ( p_operation_sequence_id IN NUMBER
359 , p_cancel_comments IN VARCHAR2
360 , p_op_seq_num IN NUMBER
361 , p_user_id IN NUMBER
362 , p_login_id IN NUMBER
363 , p_prog_id IN NUMBER
364 , p_prog_appid IN NUMBER
365 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
366 , x_return_status IN OUT NOCOPY VARCHAR2
367 ) ;
368
369
370
371 /** ECO BO Create New Routing **/
372 /*#
376 * @param p_organization_id IN Organization Id
373 * This procedure is commented out to remove the dependency of Routing BO code on ENG.
374 *
375 * @param p_assembly_item_id IN Assembly Item Id
377 * @param p_alternate_routing_code IN Alternate Routing Code
378 * @param p_pending_from_ecn IN Pending from ECN
379 * @param p_routing_sequence_id IN Routing Sequence Id
380 * @param p_common_routing_sequence_id IN Common Routing Sequence Id
381 * @param p_routing_type IN Routing Type
382 * @param p_last_update_date IN Last Update Date
383 * @param p_last_updated_by IN Last Update By
384 * @param p_creation_date IN Creation Date
385 * @param p_created_by IN Created By
386 * @param p_login_id IN Login Id
387 * @param p_revised_item_sequence_id IN Revised Item Sequence
388 * @param p_original_system_reference IN Original System Reference
389 * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
390 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
391 * @param x_return_status IN OUT NOCOPY Return Status
392 *
393 * @rep:scope private
394 * @rep:lifecycle active
395 * @rep:displayname Create New Routing
396 * @rep:compatibility S
397 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
398 */
399 PROCEDURE Create_New_Routing
400 ( p_assembly_item_id IN NUMBER
401 , p_organization_id IN NUMBER
402 , p_alternate_routing_code IN VARCHAR2
403 , p_pending_from_ecn IN VARCHAR2
404 , p_routing_sequence_id IN NUMBER
405 , p_common_routing_sequence_id IN NUMBER
406 , p_routing_type IN NUMBER
407 , p_last_update_date IN DATE
408 , p_last_updated_by IN NUMBER
409 , p_creation_date IN DATE
410 , p_created_by IN NUMBER
411 , p_login_id IN NUMBER
412 , p_revised_item_sequence_id IN NUMBER
413 , p_original_system_reference IN VARCHAR2
414 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
415 , x_return_status IN OUT NOCOPY VARCHAR2
416 ) ;
417
418 END BOM_Op_Seq_UTIL;
419