1 PACKAGE BOM_Validate_Op_Res AUTHID CURRENT_USER AS
2 /* $Header: BOMLRESS.pls 120.7.12010000.2 2008/11/14 16:36:45 snandana ship $ */
3 /*#
4 * This API contains the methods to validate Operation Resources.
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname Validate BOM Operation Resources Package
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
10 */
11 /****************************************************************************
12 --
13 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
14 -- All rights reserved.
15 --
16 -- FILENAME
17 --
18 -- BOMLRESS.pls
19 --
20 -- DESCRIPTION
21 --
22 -- Spec of package BOM_Validate_Op_Res
23 --
24 -- NOTES
25 --
26 -- HISTORY
27 -- 18-AUG-2000 Masanori Kimizuka Initial Creation
28 --
29 ****************************************************************************/
30
31
32
33 /****************************************************************************
34 * CHECK EXISTENCE
35 *****************************************************************************/
36 /*#
37 * Check_Existence will perform a query using the primary key information and will return
38 * success if the operation is CREATE and the record EXISTS or will return an error if the operation
39 * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
40 * will return the old record in the old entity parameters with a success status.
41 * @param p_op_resource_rec Operation Resource Record as given by the User
42 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
43 * @param p_op_res_Unexp_Rec Operation Resource Unexposed Record
44 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
45 * @param x_old_op_resource_rec Old Operation Resource exposed column record
46 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
47 * @param x_old_op_res_unexp_rec Old Operation Resource unexposed column record
48 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
49 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
50 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
51 * @param x_return_status Indicating success or faliure
52 * @rep:scope private
53 * @rep:lifecycle active
54 * @rep:displayname Check Existence for Routing BO
55 */
56
57 -- Check_Existence used by RTG BO
58 PROCEDURE Check_Existence
59 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
60 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
61 , x_old_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
62 , x_old_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
63 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
64 , x_return_status IN OUT NOCOPY VARCHAR2
65 ) ;
66
67 /*#
68 * Check_Existence will perform a query using the primary key information and will return
69 * success if the operation is CREATE and the record EXISTS or will return an error if the operation
70 * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
71 * will return the old record in the old entity parameters with a success status.
72 * @param p_rev_op_resource_rec Operation Resource Record as given by the User
73 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
74 * @param p_rev_op_res_Unexp_Rec Operation Resource Unexposed Record
75 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
76 * @param x_old_rev_op_resource_rec Old Operation Resource exposed column record
77 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
78 * @param x_old_rev_op_res_unexp_rec Old Operation Resource unexposed column record
79 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
80 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
81 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
82 * @param x_return_status Indicating success or faliure
83 * @rep:scope private
84 * @rep:lifecycle active
85 * @rep:displayname Check Existence for ECO BO
86 */
87
88 -- Check_Existence used by ECO BO and internally called by RTG BO
89 PROCEDURE Check_Existence
90 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
91 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
92 , x_old_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
93 , x_old_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
94 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
95 , x_return_status IN OUT NOCOPY VARCHAR2
96 ) ;
97
98
99 /****************************************************************************
100 * CHECK NON-REFERENCE ENVENT
101 *****************************************************************************/
102
103 -- Check_NonRefEvent used by RTG BO and by ECO BO
104 PROCEDURE Check_NonRefEvent
105 ( p_operation_sequence_id IN NUMBER
106 , p_operation_type IN NUMBER
107 , p_entity_processed IN VARCHAR2
108 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
109 , x_return_status IN OUT NOCOPY VARCHAR2
110 ) ;
111
112
113 /****************************************************************************
114 * CHECK ATTRIBUTES
115 *****************************************************************************/
116 /*#
117 * Check Attributes convert the BOM Record and will validate individual
118 * attributes .Any errors will be populated in the x_Mesg_Token_Tbl and returned with a x_return_status
119 * @param x_return_status Indicating success or faliure
120 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
121 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
122 * @param p_op_resource_rec Bom Operation Resource Record as given by the User
123 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
124 * @param p_op_res_unexp_rec Bom Operation Resource Record as given by the User
125 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
126 * @rep:scope private
127 * @rep:lifecycle active
128 * @rep:displayname Check Attributes for Routing BO
129 */
130 -- Check_Attributes used by RTG BO
131 PROCEDURE Check_Attributes
132 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
133 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
134 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
135 , x_return_status IN OUT NOCOPY VARCHAR2
136 ) ;
137
138
139 -- Check_Attributes used by ECO BO and internally called by RTG BO
140 /*#
141 * Check Attributes convert the BOM Record and will validate individual
142 * attributes .Any errors will be populated in the x_Mesg_Token_Tbl and returned with a x_return_status
143 * @param x_return_status Indicating success or faliure
144 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
145 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
146 * @param p_rev_op_resource_rec Bom Operation Resource Record as given by the User
147 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
148 * @param p_rev_op_res_unexp_rec Bom Operation Resource Record as given by the User
149 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
150 * @rep:scope private
151 * @rep:lifecycle active
152 * @rep:displayname Check Attributes for ECO BO
153 */
154 PROCEDURE Check_Attributes
155 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
156 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
157 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
158 , x_return_status IN OUT NOCOPY VARCHAR2
159 ) ;
160
161 /****************************************************************************
162 * CHECK ENTITY ATTRIBUTES
163 *****************************************************************************/
164 /*#
165 * Check Entity will execute the business validations for the
166 * operation resource entity .Any errors are loaded in the x_Mesg_Token_Tbl
167 * and a return status value is set.
168 * @param x_return_status Indicating success or faliure
169 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
170 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
171 * @param p_op_resource_rec Operation Resource Record
172 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
173 * @param p_op_res_unexp_rec Operation Resource Unexposed Record
174 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
175 * @param p_old_op_resource_rec Old Operation Resource Record
176 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
177 * @param p_old_op_res_unexp_rec Operation Resource Unexposed Record
178 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
179 * @param x_op_resource_rec Operation Resource Record
180 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
181 * @param x_op_res_unexp_rec Operation Resource Unexposed Record
182 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
183 * @rep:scope private
184 * @rep:lifecycle active
185 * @rep:displayname Check Entity for Routing BO
186 */
187 -- Check_Entity used by RTG BO
188 PROCEDURE Check_Entity
189 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
190 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
191 , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
192 , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
193 , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
194 , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
195 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
196 , x_return_status IN OUT NOCOPY VARCHAR2
197 ) ;
198
199 -- Check_Entity used by ECO BO and internally called by RTG BO
200 /*#
201 * Check Entity will execute the business validations for the
202 * operation resource entity .Any errors are loaded in the x_Mesg_Token_Tbl
203 * and a return status value is set.
204 * @param x_return_status Indicating success or faliure
205 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
206 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
207 * @param p_rev_op_resource_rec Operation Resource Record
208 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
209 * @param p_rev_op_res_unexp_rec Operation Resource Unexposed Record
210 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
211 * @param p_control_Rec IN Control Record
212 * @paraminfo { @rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
213 * @param p_old_rev_op_resource_rec Old Operation Resource Record
214 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
215 * @param p_old_rev_op_res_unexp_rec Operation Resource Unexposed Record
216 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
217 * @param x_rev_op_resource_rec Operation Resource Record
218 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
219 * @param x_rev_op_res_unexp_rec Operation Resource Unexposed Record
220 * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type }
221 * @rep:scope private
222 * @rep:lifecycle active
223 * @rep:displayname Check Entity for ECO BO
224 */
225
226 PROCEDURE Check_Entity
227 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
228 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
229 , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
230 , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
231 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
232 , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
233 , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
234 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
235 , x_return_status IN OUT NOCOPY VARCHAR2
236 ) ;
237
238
239
240 /****************************************************************************
241 * OTHERS
242 *****************************************************************************/
243 FUNCTION Get_Rev_Op_ACD (p_op_seq_id IN NUMBER)
244 RETURN NUMBER ;
245
246 /*#
247 * This method will validate the resource id
248 * @param p_resource_id the resource id to be validated
249 * @param p_op_seq_id the operation sequence id
250 * @param x_return_status Indicating success or faliure
251 * @rep:scope private
252 * @rep:lifecycle active
253 * @rep:displayname Validate Resource Id
254 */
255 PROCEDURE Val_Resource_Id
256 ( p_resource_id IN NUMBER
257 , p_op_seq_id IN NUMBER
258 , x_return_status IN OUT NOCOPY VARCHAR2
259 ) ;
260
261 /*#
262 * This method will validate the Activity id
263 * @param p_activity_id the activity id to be validated
264 * @param p_op_seq_id the operation sequence id
265 * @param x_return_status Indicating success or faliure
266 * @rep:scope private
267 * @rep:lifecycle active
268 * @rep:displayname Validate Activate Id
269 */
270 PROCEDURE Val_Activity_Id
271 ( p_activity_id IN NUMBER
272 , p_op_seq_id IN NUMBER
273 , x_return_status IN OUT NOCOPY VARCHAR2
274 ) ;
275 /*#
276 * This method will validate the setup id
277 * @param p_setup_id the setup id to be validated
278 * @param p_resource_id the resource
279 * @param p_organization_id the organization id
280 * @param x_return_status Indicating success or faliure
281 * @rep:scope private
282 * @rep:lifecycle active
283 * @rep:displayname Validate setup Id
284 */
285
286 PROCEDURE Val_Setup_Id
287 ( p_setup_id IN NUMBER
288 , p_resource_id IN NUMBER
289 , p_organization_id IN NUMBER
290 , x_return_status IN OUT NOCOPY VARCHAR2
291 ) ;
292
293 /*#
294 * This method will validate the usage rate or amount and inverse
295 * @param p_usage_rate_or_amount usage rate or amount
296 * @param p_usage_rate_or_amount_inverse usage rate or amount and inverse
297 * @param x_return_status Indicating success or faliure
298 * @rep:scope private
299 * @rep:lifecycle active
300 * @rep:displayname Validate the usage rate or amount and inverse
301 */
302 PROCEDURE Val_Usage_Rate_or_Amount
303 ( p_usage_rate_or_amount IN NUMBER
304 , p_usage_rate_or_amount_inverse IN NUMBER
305 , x_return_status IN OUT NOCOPY VARCHAR2
306 ) ;
307
308 /*#
309 * This method will validate the Scheduled Resource
310 * @param p_op_seq_id the operation sequence id
311 * @param p_res_seq_num the resource sequence number
312 * @param p_schedule_flag the schedule flag
313 * @param x_return_status Indicating success or faliure
314 * @rep:scope private
315 * @rep:lifecycle active
316 * @rep:displayname Validate Resource Id
317 */
318 PROCEDURE Val_Scheduled_Resource
319 ( p_op_seq_id IN NUMBER
320 , p_res_seq_num IN NUMBER
321 , p_schedule_flag IN NUMBER
322 , x_return_status IN OUT NOCOPY VARCHAR2
323 ) ;
324 PROCEDURE Val_Scheduled_Resource
325 ( p_op_seq_id IN NUMBER
326 , p_res_seq_num IN NUMBER
327 , p_sch_seq_num IN NUMBER
328 , p_schedule_flag IN NUMBER
329 , x_return_status IN OUT NOCOPY VARCHAR2
330 ) ;
331
332 PROCEDURE Val_Autocharge_for_OSP_Res
333 ( p_resource_id IN NUMBER
334 , p_organization_id IN NUMBER
335 , x_return_status IN OUT NOCOPY VARCHAR2
336 ) ;
337
338 PROCEDURE Val_PO_Move
339 ( p_op_seq_id IN NUMBER
340 , p_res_seq_num IN NUMBER
341 , x_return_status IN OUT NOCOPY VARCHAR2
342 ) ;
343
344 PROCEDURE Val_Dept_Has_Location
345 ( p_op_seq_id IN NUMBER
346 , x_return_status IN OUT NOCOPY VARCHAR2
347 ) ;
348
349 PROCEDURE Get_Resource_Uom
350 ( p_resource_id IN NUMBER
351 , x_hour_uom_code IN OUT NOCOPY VARCHAR2
352 , x_hour_uom_class IN OUT NOCOPY VARCHAR2
353 , x_res_uom_code IN OUT NOCOPY VARCHAR2
354 , x_res_uom_class IN OUT NOCOPY VARCHAR2
355 ) ;
356
357 /*#
358 * This method will validate Resource UOM For Schedule
359 * @param p_hour_uom_class the hour uom class
360 * @param p_res_uom_class the resource uom class
361 * @param p_hour_uom_code the hour uom code
362 * @param p_res_uom_code the resource uom code
363 * @param x_return_status Indicating success or faliure
364 * @rep:scope private
365 * @rep:lifecycle active
366 * @rep:displayname Validate Resource UOM For Schedule
367 */
368 PROCEDURE Val_Res_UOM_For_Schedule
369 ( p_hour_uom_class IN VARCHAR2
370 , p_res_uom_class IN VARCHAR2
371 , p_hour_uom_code IN VARCHAR2
372 , p_res_uom_code IN VARCHAR2
373 , x_return_status IN OUT NOCOPY VARCHAR2
374 ) ;
375
376 /*#
377 * This method will validate Negative Usage Rate
378 * @param p_autocharge_type the autocharge type
379 * @param p_schedule_flag the schedule flag
380 * @param p_hour_uom_class the hour uom class
381 * @param p_res_uom_class the resource uom class
382 * @param x_return_status Indicating success or faliure
383 * @rep:scope private
384 * @rep:lifecycle active
385 * @rep:displayname Validate Negative Usage Rate
386 */
387 PROCEDURE Val_Negative_Usage_Rate
388 ( p_autocharge_type IN NUMBER
389 , p_schedule_flag IN NUMBER
390 , p_hour_uom_class IN VARCHAR2
391 , p_res_uom_class IN VARCHAR2
392 , x_return_status IN OUT NOCOPY VARCHAR2
393 ) ;
394
395 /*#
396 * This method will validate Principal Resource Unique
397 * @param p_op_seq_id the operation sequence id
398 * @param p_res_seq_num the resource sequence number
399 * @param p_sub_group_num the substitute group number
400 * @param x_return_status Indicating success or faliure
401 * @rep:scope private
402 * @rep:lifecycle active
403 * @rep:displayname Validate Principal Resource Unique
404 */
405 PROCEDURE Val_Principal_Res_Unique
406 ( p_op_seq_id IN NUMBER
407 , p_res_seq_num IN NUMBER
408 , p_sub_group_num IN NUMBER
409 , x_return_status IN OUT NOCOPY VARCHAR2
410 ) ;
411 /*#
412 * This method will validate the substitute group number order
413 * @param p_op_seq_id the operation sequence id
414 * @param x_Mesg_Token_Tbl Filled with any errors or warnings
415 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
416 * @param x_return_status Indicating success or faliure
417 * @rep:scope private
418 * @rep:lifecycle active
419 * @rep:displayname Validate substitute group number order
420 */
421 PROCEDURE Val_Sgn_Order
422 ( p_op_seq_id IN NUMBER
423 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
424 , x_return_status IN OUT NOCOPY VARCHAR2
425 );
426
427 /* Fix for bug 4506885 - Added parameter p_sub_grp_num. */
428 /*#
429 * This method will validate the Schedule Sequence Number
430 * @param p_op_seq_id the operation sequence id
431 * @param p_res_seq_num the resource sequence number
432 * @param p_sch_seq_num the schedule sequence number
433 * @param p_sub_grp_num the substitute group number
434 * @param x_return_status Indicating success or faliure
435 * @rep:scope private
436 * @rep:lifecycle active
437 * @rep:displayname Validate Schedule Sequence Number
438 */
439 PROCEDURE Val_Schedule_Seq_Num
440 ( p_op_seq_id IN NUMBER
441 , p_res_seq_num IN NUMBER
442 , p_sch_seq_num IN NUMBER
443 , p_sub_grp_num IN NUMBER
444 , x_return_status IN OUT NOCOPY VARCHAR2
445 );
446
447 /* bug:4638695 For an operation do not allow same resource to be added more than once with same SSN */
448 /*#
449 * This method will validate the Resource SSN
450 * @param p_op_seq_id the operation sequence id
451 * @param p_res_seq_num the resource sequence number
452 * @param p_sch_seq_num the schedule sequence number
453 * @param p_resource_id the resource id
454 * @param x_return_status Indicating success or faliure
455 * @rep:scope private
456 * @rep:lifecycle active
457 * @rep:displayname Validate Resource SSN
458 */
459 PROCEDURE Val_Resource_SSN
460 ( p_op_seq_id IN NUMBER
461 , p_res_seq_num IN NUMBER
462 , p_sch_seq_num IN NUMBER
463 , p_resource_id IN NUMBER
464 , x_return_status IN OUT NOCOPY VARCHAR2
465 );
466
467 /* Fix for bug 6074930-Added below procedure val_schedule_flag. */
468 PROCEDURE Val_Schedule_Flag
469 ( p_op_seq_id IN NUMBER
470 , p_res_seq_num IN NUMBER
471 , p_sch_seq_num IN NUMBER
472 , p_sch_flag IN NUMBER
473 , p_ret_res_id IN OUT NOCOPY NUMBER
474 , x_return_status IN OUT NOCOPY VARCHAR2
475 );
476
477 /****************************************************************************
478 * CHECK REQUIRED
479
480 -- Check_Required used by RTG BO
481 PROCEDURE Check_Required
482 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
483 , x_return_status IN OUT NOCOPY VARCHAR2
484 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
485 ) ;
486
487 -- Check_Required used by ECO BO
488 PROCEDURE Check_Required
489 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
490 , x_return_status IN OUT NOCOPY VARCHAR2
491 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492 ) ;
493
494
495 -- Check_Required internally called by RTG BO and by ECO BO
496 PROCEDURE Check_Required
497 ( p_com_op_resource_rec IN Bom_Rtg_Pub.Com_op_resource_Rec_Type
498 , x_return_status IN OUT NOCOPY VARCHAR2
499 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
500 ) ;
501
502 *****************************************************************************/
503
504
505 /****************************************************************************
506 * CHECK CONDITIONALLY REQUIRED
507
508 -- Check_Conditionally_Required used by RTG BO
509 PROCEDURE Check_Conditionally_Required
510 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
511 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
512 , x_return_status IN OUT NOCOPY VARCHAR2
513 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
514 ) ;
515
516 -- Check_Conditionally_Required used by ECO BO
517 PROCEDURE Check_Conditionally_Required
518 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
519 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
520 , x_return_status IN OUT NOCOPY VARCHAR2
521 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
522 ) ;
523
524 -- Check_Conditionally_Required internally called by RTG BO and ECO BO
525 PROCEDURE Check_Conditionally_Required
526 ( p_com_op_resource_rec IN Bom_Rtg_Pub.Com_op_resource_Rec_Type
527 , p_com_op_res_unexp_rec IN Bom_Rtg_Pub.Com_Op_Res_Unexposed_Rec_Type
528 , x_return_status IN OUT NOCOPY VARCHAR2
529 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
530 ) ;
531
532 *****************************************************************************/
533 G_round_off_val number :=NVL(FND_PROFILE.VALUE('BOM:ROUND_OFF_VALUE'),6); /* Bug 7322996 */
534
535 END BOM_Validate_Op_Res ;