1 PACKAGE BOM_Validate_Op_Seq AS
2 /* $Header: BOMLOPSS.pls 120.1 2006/01/03 22:00:59 bbpatel noship $ */
3 /*#
4 * This API performs Attribute and Entity level validations for Routing Operation.
5 * Entity level validations include existence and accessibility check for Routing
6 * Operation record. Attribute level validations include check for required attributes and
7 * business logic validations.
8 *
9 * @rep:scope private
10 * @rep:product BOM
11 * @rep:lifecycle active
12 * @rep:displayname Validate Routing Operation
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
15 */
16
17 /****************************************************************************
18 --
19 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
20 -- All rights reserved.
21 --
22 -- FILENAME
23 --
24 -- BOMLOPSS.pls
25 --
26 -- DESCRIPTION
27 --
28 -- Spec of package BOM_Validate_Op_Seq
29 --
30 -- NOTES
31 --
32 -- HISTORY
33 -- 07-AUG-2000 Masanori Kimizuka Initial Creation
34 --
35 ****************************************************************************/
36
37
38
39 /****************************************************************************
40 * CHECK EXISTENCE
41 *****************************************************************************/
42
43
44 -- Check_Existence used by RTG BO
45 /*#
46 * Procedure will query the routing operation record and return it in old record variable.
47 * If the Transaction Type is Create and the record already exists the return status
48 * would be error. If the Transaction Type is Update or Delete and the record does not
49 * exist then the return status would be an error as well. Such an error in a record will
50 * cause all children to error out, since they are referencing an invalid parent.
51 * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
52 *
53 * @param p_operation_rec IN Routing Operation Exposed Record
54 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
55 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
56 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
57 * @param x_old_operation_rec IN OUT NOCOPY Routing Operation Exposed Record if already exists
58 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
59 * @param x_old_op_unexp_rec IN OUT NOCOPY Routing Operation Unexposed Record if already exists
60 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
61 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
62 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
63 * @param x_return_status IN OUT NOCOPY Return Status
64 *
65 * @rep:scope private
66 * @rep:lifecycle active
67 * @rep:displayname Check Existence for Routing Operation record
68 * @rep:compatibility S
69 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
70 */
71 PROCEDURE Check_Existence
72 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
73 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
74 , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
75 , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
76 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
77 , x_return_status IN OUT NOCOPY VARCHAR2
78 ) ;
79
80 -- Check_Existence used by ECO BO
81 /*#
82 * Procedure will query the revised routing operation record and return it in old record variable.
83 * If the Transaction Type is Create and the record already exists the return status
84 * would be error. If the Transaction Type is Update or Delete and the record does not
85 * exist then the return status would be an error as well. Such an error in a record will
86 * cause all children to error out, since they are referencing an invalid parent.
87 * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
88 *
89 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
90 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
91 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
92 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
93 * @param x_old_rev_operation_rec IN OUT NOCOPY Revised Routing Operation Exposed Record if already exists
94 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
95 * @param x_old_rev_op_unexp_rec IN OUT NOCOPY Revised Routing Operation Unexposed Record if already exists
96 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
97 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
98 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
99 * @param x_return_status IN OUT NOCOPY Return Status
100 *
101 * @rep:scope private
102 * @rep:lifecycle active
103 * @rep:displayname Check Existence for Revised Routing Operation record
104 * @rep:compatibility S
105 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
106 */
107 PROCEDURE Check_Existence
108 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
109 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
110 , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
111 , x_old_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 -- Check_Existence internally called by RTG BO and ECO BO
117 /*#
118 * Procedure will query the common routing operation record and return it in old record variable.
119 * If the Transaction Type is Create and the record already exists the return status
120 * would be error. If the Transaction Type is Update or Delete and the record does not
121 * exist then the return status would be an error as well. Such an error in a record will
122 * cause all children to error out, since they are referencing an invalid parent.
123 * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
124 *
125 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
126 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
127 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
128 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
129 * @param x_old_com_operation_rec IN OUT NOCOPY Common Routing Operation Exposed Record if already exists
130 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
131 * @param x_old_com_op_unexp_rec IN OUT NOCOPY Common Routing Operation Unexposed Record if already exists
132 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
133 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
134 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
135 * @param x_return_status IN OUT NOCOPY Return Status
136 *
137 * @rep:scope private
138 * @rep:lifecycle active
139 * @rep:displayname Check Existence for Common Routing Operation record
140 * @rep:compatibility S
141 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
142 */
143 PROCEDURE Check_Existence
144 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
145 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
146 , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
147 , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
148 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
149 , x_return_status IN OUT NOCOPY VARCHAR2
150 ) ;
151
152
153
154 /****************************************************************************
155 * CHECK LINEAGE
156 *****************************************************************************/
157
158 -- Check_Lineage used by ECO BO
159 /*#
160 * Procedure will be used by ECO BO. This procedure will check whether the Operation
161 * belongs to right parent Routing and that parent exists. Otherwise error status will be returned.
162 * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
163 *
164 * @param p_routing_sequence_id IN Routing Sequence Id
165 * @param p_operation_sequence_number IN Operation Sequence Number
166 * @param p_effectivity_date IN Effectivity Date of the Operation
167 * @param p_operation_type IN Operation Type
168 * @param p_revised_item_sequence_id IN Revised Item Sequence Id
169 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
170 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
171 * @param x_return_status IN OUT NOCOPY Return Status
172 *
173 * @rep:scope private
174 * @rep:lifecycle active
175 * @rep:displayname Check Lineage for the Routing Operation
176 * @rep:compatibility S
177 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
178 */
179 PROCEDURE Check_Lineage
180 ( p_routing_sequence_id IN NUMBER
181 , p_operation_sequence_number IN NUMBER
182 , p_effectivity_date IN DATE
183 , p_operation_type IN NUMBER
184 , p_revised_item_sequence_id IN NUMBER
185 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
186 , x_return_status IN OUT NOCOPY VARCHAR2
187 ) ;
188
189
190
191 /****************************************************************************
192 * check common routing
193 *****************************************************************************/
194
195 -- Check_CommonRtg used by ECO BO and RTG BO
196 /*#
197 * Procedure will verify that the parent Routing do not have common Routing.
198 * Otherwise error status will be returned. Mesg_Token_Table will carry the
199 * error messsage and the tokens associated with the message.
200 *
201 * @param p_routing_sequence_id IN Routing Sequence Id
202 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
203 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
204 * @param x_return_status IN OUT NOCOPY Return Status
205 *
206 * @rep:scope private
207 * @rep:lifecycle active
208 * @rep:displayname Check Common Routing
209 * @rep:compatibility S
210 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
211 */
212 PROCEDURE Check_CommonRtg
213 ( p_routing_sequence_id IN NUMBER
214 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
215 , x_return_status IN OUT NOCOPY VARCHAR2
216 ) ;
217
218
219 /****************************************************************************
220 * CHECK REQUIRED
221 *****************************************************************************/
222
223 -- Check_Required used by RTG BO
224 /*#
225 * Procedure to check the required attributes for the Routing Operation record.
226 * Some fields are required for an operation to be performed. The user must enter values
227 * for these fields. This procedure checks whether the required field columns are not NULL.
228 * Otherwise error status will be returned. Mesg_Token_Table will carry the
229 * error messsage and the tokens associated with the message.
230 *
231 * @param p_operation_rec IN Routing Operation Exposed Record
232 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
233 * @param x_return_status IN OUT NOCOPY Return Status
234 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
235 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
236 *
237 * @rep:scope private
238 * @rep:lifecycle active
239 * @rep:displayname Check Routing Operation required attributes
240 * @rep:compatibility S
241 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
242 */
243 PROCEDURE Check_Required
244 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
245 , x_return_status IN OUT NOCOPY VARCHAR2
246 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
247 ) ;
248
249 -- Check_Required used by ECO BO
250 /*#
251 * Procedure to check the required attributes for the Revised Routing Operation record.
252 * Some fields are required for an operation to be performed. The user must enter values
253 * for these fields. This procedure checks whether the required field columns are not NULL.
254 * Otherwise error status will be returned. Mesg_Token_Table will carry the
255 * error messsage and the tokens associated with the message.
256 *
257 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
258 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
259 * @param x_return_status IN OUT NOCOPY Return Status
260 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
261 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
262 *
263 * @rep:scope private
264 * @rep:lifecycle active
265 * @rep:displayname Check Revised Routing Operation required attributes
266 * @rep:compatibility S
267 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
268 */
269 PROCEDURE Check_Required
270 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
271 , x_return_status IN OUT NOCOPY VARCHAR2
272 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
273 ) ;
274
275
276 -- Check_Required internally called by RTG BO and by ECO BO
277 /*#
278 * Procedure to check the required attributes for the Common Routing Operation record.
279 * Some fields are required for an operation to be performed. The user must enter values
280 * for these fields. This procedure checks whether the required field columns are not NULL.
281 * Otherwise error status will be returned. Mesg_Token_Table will carry the
282 * error messsage and the tokens associated with the message.
283 *
284 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
285 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
286 * @param x_return_status IN OUT NOCOPY Return Status
287 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
288 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
289 *
290 * @rep:scope private
291 * @rep:lifecycle active
292 * @rep:displayname Check Common Routing Operation required attributes
293 * @rep:compatibility S
294 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
295 */
296 PROCEDURE Check_Required
297 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
298 , x_return_status IN OUT NOCOPY VARCHAR2
299 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
300 ) ;
301
302
303 /****************************************************************************
304 * CHECK ATTRIBUTES
305 *****************************************************************************/
306
307 -- Check_Attributes used by RTG BO
308 /*#
309 * This procedure checks the attributes validity of Routing Operation record. Validations include check for
310 * missing attribute values in case of UPDATE, valid attributes values.
311 * Otherwise error status will be returned. Mesg_Token_Table will carry the
312 * error messsage and the tokens associated with the message.
313 *
314 * @param p_operation_rec IN Routing Operation Exposed Record
315 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
316 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
317 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
318 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
319 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
320 * @param x_return_status IN OUT NOCOPY Return Status
321 *
322 * @rep:scope private
323 * @rep:lifecycle active
324 * @rep:displayname Check Routing Operation attributes
325 * @rep:compatibility S
326 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
327 */
328 PROCEDURE Check_Attributes
329 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
330 , p_op_unexp_rec IN Bom_Rtg_Pub.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
336 -- Check_Attributes used by ECO BO
337 /*#
338 * This procedure checks the attributes validity of Revised Routing Operation record.
339 * Validations include check for missing attribute values in case of UPDATE,
340 * valid attributes values. Otherwise error status will be returned.
341 * Mesg_Token_Table will carry the error messsage and the tokens associated
342 * with the message.
343 *
344 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
345 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
346 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
347 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
348 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
349 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
350 * @param x_return_status IN OUT NOCOPY Return Status
351 *
352 * @rep:scope private
353 * @rep:lifecycle active
354 * @rep:displayname Check Revised Routing Operation attributes
355 * @rep:compatibility S
356 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
357 */
358 PROCEDURE Check_Attributes
359 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
360 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
361 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
362 , x_return_status IN OUT NOCOPY VARCHAR2
363 ) ;
364
365
366 -- Check_Attributes internally called by RTG BO and ECO BO
367 /*#
368 * This procedure checks the attributes validity of Common Routing Operation record.
369 * Validations include check for missing attribute values in case of UPDATE,
370 * valid attributes values. Otherwise error status will be returned.
371 * Mesg_Token_Table will carry the error messsage and the tokens associated
372 * with the message.
373 *
374 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
375 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
376 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
377 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
378 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
379 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
380 * @param x_return_status IN OUT NOCOPY Return Status
381 *
382 * @rep:scope private
386 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
383 * @rep:lifecycle active
384 * @rep:displayname Check Common Routing Operation attributes
385 * @rep:compatibility S
387 */
388 PROCEDURE Check_Attributes
389 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
390 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
391 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
392 , x_return_status IN OUT NOCOPY VARCHAR2
393 ) ;
394
395
396 /****************************************************************************
397 * CHECK CONDITIONALLY REQUIRED
398 *****************************************************************************/
399
400 -- Check_Conditionally_Required used by RTG BO
401 /*#
402 * This procedure checks the conditionally required attributes for Routing Operation record.
403 * Currently there is no code in this procedure as it is moved to Check_Required procedure.
404 *
405 * @param p_operation_rec IN Routing Operation Exposed Record
406 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
407 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
408 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
409 * @param x_return_status IN OUT NOCOPY Return Status
410 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
411 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
412 *
413 * @rep:scope private
414 * @rep:lifecycle active
415 * @rep:displayname Check Conditionally required Routing Operation attributes
416 * @rep:compatibility S
417 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
418 */
419 PROCEDURE Check_Conditionally_Required
420 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
421 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
422 , x_return_status IN OUT NOCOPY VARCHAR2
423 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
424 ) ;
425
426 -- Check_Conditionally_Required used by ECO BO
427 /*#
428 * This procedure checks the conditionally required attributes for Revised Routing Operation record.
429 * Currently there is no code in this procedure as it is moved to Check_Required procedure.
430 *
434 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
431 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
432 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
433 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
435 * @param x_return_status IN OUT NOCOPY Return Status
436 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
437 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
438 *
439 * @rep:scope private
440 * @rep:lifecycle active
441 * @rep:displayname Check Conditionally required Revised Routing Operation attributes
442 * @rep:compatibility S
443 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
444 */
445 PROCEDURE Check_Conditionally_Required
446 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
447 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
448 , x_return_status IN OUT NOCOPY VARCHAR2
449 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
450 ) ;
451
452 -- Check_Conditionally_Required internally called by RTG BO and ECO BO
453 /*#
454 * This procedure checks the conditionally required attributes for Common Routing Operation record.
455 * Currently there is no code in this procedure as it is moved to Check_Required procedure.
456 *
457 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
458 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
459 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
460 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
461 * @param x_return_status IN OUT NOCOPY Return Status
462 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
463 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
464 *
465 * @rep:scope private
466 * @rep:lifecycle active
467 * @rep:displayname Check Conditionally required Common Routing Operation attributes
468 * @rep:compatibility S
469 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
470 */
471 PROCEDURE Check_Conditionally_Required
472 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
473 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
474 , x_return_status IN OUT NOCOPY VARCHAR2
475 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
476 ) ;
477
478
479
480 /****************************************************************************
481 * CHECK NONOPERATED ATTRIBUTES
482 *****************************************************************************/
483
484 -- Check_NonOperated_Attribute used by RTG BO
485 /*#
486 * This procedure, depending on CFM Routing Flag, checks if Routing Operation's
487 * non-operated attribute is null. If so, the procedure sets the value to null and
488 * and sets the warning message indicating non-operated attribute is ignored.
489 *
490 * @param p_operation_rec IN Routing Operation Exposed Record
491 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
492 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
493 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
494 * @param x_operation_rec IN OUT NOCOPY Routing Operation Exposed Record after processing
495 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
496 * @param x_op_unexp_rec IN OUT NOCOPY Routing Operation Unexposed Record after processing
497 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
498 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
499 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
500 * @param x_return_status IN OUT NOCOPY Return Status
501 *
502 * @rep:scope private
503 * @rep:lifecycle active
504 * @rep:displayname Check non-operated Routing Operation attributes
505 * @rep:compatibility S
506 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
507 */
508 PROCEDURE Check_NonOperated_Attribute
509 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
510 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
511 , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
512 , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
513 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
514 , x_return_status IN OUT NOCOPY VARCHAR2
515 ) ;
516
517 -- Check_NonOperated_Attribute used by ECO BO
518 /*#
519 * This procedure, depending on CFM Routing Flag, checks if Revised Routing Operation's
520 * non-operated attribute is null. If so, the procedure sets the value to null and
521 * and sets the warning message indicating non-operated attribute is ignored.
522 *
523 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
524 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
525 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
526 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
527 * @param x_rev_operation_rec IN OUT NOCOPY Revised Routing Operation Exposed Record after processing
528 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
529 * @param x_rev_op_unexp_rec IN OUT NOCOPY Revised Routing Operation Unexposed Record after processing
530 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
531 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
532 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
533 * @param x_return_status IN OUT NOCOPY Return Status
534 *
535 * @rep:scope private
536 * @rep:lifecycle active
537 * @rep:displayname Check non-operated Revised Routing Operation attributes
538 * @rep:compatibility S
539 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
540 */
544 , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
541 PROCEDURE Check_NonOperated_Attribute
542 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
543 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
545 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
546 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
547 , x_return_status IN OUT NOCOPY VARCHAR2
548 ) ;
549
550
551 -- Check_NonOperated_Attribute internally called by RTG BO and ECO BO
552 /*#
553 * This procedure, depending on CFM Routing Flag, checks if Common Routing Operation's
554 * non-operated attribute is null. If so, the procedure sets the value to null and
558 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
555 * and sets the warning message indicating non-operated attribute is ignored.
556 *
557 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
559 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
560 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
561 * @param x_com_operation_rec IN OUT NOCOPY Common Routing Operation Exposed Record after processing
562 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
563 * @param x_com_op_unexp_rec IN OUT NOCOPY Common Routing Operation Unexposed Record after processing
564 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
565 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
566 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
567 * @param x_return_status IN OUT NOCOPY Return Status
568 *
569 * @rep:scope private
570 * @rep:lifecycle active
571 * @rep:displayname Check non-operated Common Routing Operation attributes
572 * @rep:compatibility S
573 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
574 */
575 PROCEDURE Check_NonOperated_Attribute
576 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
577 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
578 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
579 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
580 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
581 , x_return_status IN OUT NOCOPY VARCHAR2
582 ) ;
586 /****************************************************************************
583
584
585
587 * CHECK ENTITY ATTRIBUTES
588 *****************************************************************************/
589
590 -- Check_Entity used by RTG BO
591 /*#
592 * Procedure to validate the Routing Operation entity record.
593 * The following are checked:
594 * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record.
595 * Cross-attribute checking: The validity of attributes is checked, based on factors external to it.
596 * Business logic: The record must comply with business logic rules.
597 *
598 * @param p_operation_rec IN Routing Operation Exposed Record
599 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
600 * @param p_op_unexp_rec IN Routing Operation Unexposed Record
601 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
602 * @param p_old_operation_rec IN Old Routing Operation Exposed Record
603 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
604 * @param p_old_op_unexp_rec IN Old Routing Operation Unexposed Record
605 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
606 * @param x_operation_rec IN OUT NOCOPY Routing Operation Exposed Record after processing
607 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Operation_Rec_Type }
608 * @param x_op_unexp_rec IN OUT NOCOPY Routing Operation Unexposed Record after processing
609 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Unexposed_Rec_Type}
610 * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
611 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
612 * @param x_return_status IN OUT NOCOPY Return Status
613 *
614 * @rep:scope private
615 * @rep:lifecycle active
616 * @rep:displayname Check Routing Operation entity
617 * @rep:compatibility S
618 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
619 */
620 PROCEDURE Check_Entity
621 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
622 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
623 , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
624 , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
625 , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
626 , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
627 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
628 , x_return_status IN OUT NOCOPY VARCHAR2
629 ) ;
630
631 -- Check_Entity used by ECO BO
632 /*#
633 * Procedure to validate the Revised Routing Operation entity record.
634 * The following are checked:
635 * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record.
636 * Cross-attribute checking: The validity of attributes is checked, based on factors external to it.
637 * Business logic: The record must comply with business logic rules.
638 *
639 * @param p_rev_operation_rec IN Revised Routing Operation Exposed Record
640 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
641 * @param p_rev_op_unexp_rec IN Revised Routing Operation Unexposed Record
642 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
643 * @param p_old_rev_operation_rec IN Old Revised Routing Operation Exposed Record
644 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
645 * @param p_old_rev_op_unexp_rec IN Old Revised Routing Operation Unexposed Record
646 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
647 * @param p_control_rec IN Control Record
648 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
649 * @param x_rev_operation_rec IN OUT NOCOPY Revised Routing Operation Exposed Record after processing
650 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Operation_Rec_Type }
651 * @param x_rev_op_unexp_rec IN OUT NOCOPY Revised Routing Operation Unexposed Record after processing
652 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type}
653 * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
654 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
655 * @param x_return_status IN OUT NOCOPY Return Status
656 *
657 * @rep:scope private
658 * @rep:lifecycle active
659 * @rep:displayname Check Revised Routing Operation entity
660 * @rep:compatibility S
661 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
662 */
663 PROCEDURE Check_Entity
664 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
665 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
666 , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
667 , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
668 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
669 , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
670 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
671 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
672 , x_return_status IN OUT NOCOPY VARCHAR2
673 ) ;
674
675 -- Check_Entity internally called by RTG BO and by ECO BO
676 /*#
677 * Procedure to validate the Common Routing Operation entity record.
678 * The following are checked:
679 * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record.
680 * Cross-attribute checking: The validity of attributes is checked, based on factors external to it.
681 * Business logic: The record must comply with business logic rules.
682 *
683 * @param p_com_operation_rec IN Common Routing Operation Exposed Record
684 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
685 * @param p_com_op_unexp_rec IN Common Routing Operation Unexposed Record
689 * @param p_old_com_op_unexp_rec IN Old Common Routing Operation Unexposed Record
686 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
687 * @param p_old_com_operation_rec IN Old Common Routing Operation Exposed Record
688 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
690 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
691 * @param p_control_rec IN Control Record
692 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
693 * @param x_com_operation_rec IN OUT NOCOPY Common Routing Operation Exposed Record after processing
694 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Operation_Rec_Type }
695 * @param x_com_op_unexp_rec IN OUT NOCOPY Common Routing Operation Unexposed Record after processing
696 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type}
697 * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
698 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
699 * @param x_return_status IN OUT NOCOPY Return Status
700 *
701 * @rep:scope private
702 * @rep:lifecycle active
703 * @rep:displayname Check Common Routing Operation entity
704 * @rep:compatibility S
705 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
706 */
707 PROCEDURE Check_Entity
708 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
709 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
710 , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
711 , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
712 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
713 , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
714 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
715 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
716 , x_return_status IN OUT NOCOPY VARCHAR2
717 ) ;
718
719 /****************************************************************************
720 * CHECK_ACCESS
721 *****************************************************************************/
722
723
724 /*#
725 * This procedure will verify that the revised item and the revised operation
726 * is accessible to the user.
727 *
728 * @param p_revised_item_name IN Revised Item Name
729 * @param p_revised_item_id IN Revised Item Id
730 * @param p_organization_id IN Organization Id
731 * @param p_change_notice IN Change Order Name
732 * @param p_new_item_revision IN New Item Revision
733 * @param p_effectivity_date IN Effectivity Date for the Operation
734 * @param p_new_routing_revsion IN New Routing Revision
735 * @param p_from_end_item_number IN From End Item Unit Number
736 * @param p_operation_seq_num IN Operation Sequence Number
737 * @param p_routing_sequence_id IN Routing Sequence Id
738 * @param p_operation_type IN Operation Type
739 * @param p_Mesg_Token_Tbl IN Message Token Table
740 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
741 * @param p_entity_processed IN Entity to be Processed. Valid values 'RES' and 'SR'.
742 * @param p_resource_seq_num IN Resource Sequence Number
743 * @param p_sub_resource_code IN Substitute Resource Code
744 * @param p_sub_group_num IN Substitute Group Number
745 * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
746 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
747 * @param x_return_status IN OUT NOCOPY Return Status
748 *
749 * @rep:scope private
750 * @rep:lifecycle active
751 * @rep:displayname Check Access for Revised Item and Operation
752 * @rep:compatibility S
753 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
754 */
755 PROCEDURE Check_Access
756 ( p_revised_item_name IN VARCHAR2
757 , p_revised_item_id IN NUMBER
758 , p_organization_id IN NUMBER
759 , p_change_notice IN VARCHAR2
760 , p_new_item_revision IN VARCHAR2
761 , p_effectivity_date IN DATE
762 , p_new_routing_revsion IN VARCHAR2 -- Added by MK on 11/02/00
763 , p_from_end_item_number IN VARCHAR2 -- Added by MK on 11/02/00
764 , p_operation_seq_num IN NUMBER
765 , p_routing_sequence_id IN NUMBER
766 , p_operation_type IN NUMBER
767 , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
768 , p_entity_processed IN VARCHAR2
769 , p_resource_seq_num IN NUMBER
770 , p_sub_resource_code IN VARCHAR2
771 , p_sub_group_num IN NUMBER
772 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
773 , x_Return_Status IN OUT NOCOPY VARCHAR2
774 ) ;
775
776 END BOM_Validate_Op_Seq ;