1 PACKAGE BOM_Validate_Sub_Op_Res AS
2 /* $Header: BOMLSORS.pls 120.1.12000000.2 2007/10/17 13:52:22 jiabraha ship $ */
3 /*#
4 * This API contains Attribute and Entity level validation for the Bill of Materials Sub Operation Resource Records.
5 * This contains procedures for
6 * Checking the existence of the Sub Operation Resource record in case of create,update or delete.
7 * Checking the acces rights of the user to the Assembly Item's BOM Item Type.
8 * Checking the validity of all Sub Operation Resource Attributes
9 * Checking the required fields in the Sub Operation Resource Record.
10 * Checking the Business Logic validation for the Sub Operation Resource Entity.
11 * Checking the Delete Constraints for Sub Operation Resource.
12 * @rep:scope private
13 * @rep:product BOM
14 * @rep:lifecycle active
15 * @rep:displayname Validate Sub Operation Resource
16 * @rep:compatibility S
17 */
18 /****************************************************************************
19 --
20 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
21 -- All rights reserved.
22 --
23 -- FILENAME
24 --
25 -- BOMLSORS.pls
26 --
27 -- DESCRIPTION
28 --
29 -- Spec of package BOM_Validate_Sub_Op_Res
30 --
31 -- NOTES
32 --
33 -- HISTORY
34 -- 22-AUG-2000 Masanori Kimizuka Initial Creation
35 --
36 ****************************************************************************/
37
38
39 /****************************************************************************
40 * CHECK EXISTENCE
41 *****************************************************************************/
42
43
44 -- Check_Existence used by RTG BO
45 PROCEDURE Check_Existence
46 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
47 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
48 , x_old_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
49 , x_old_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
50 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
51 , x_return_status IN OUT NOCOPY VARCHAR2
52 ) ;
53
54 -- Check_Existence used by ECO BO and internally called by RTG BO
55 PROCEDURE Check_Existence
56 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
57 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
58 , x_old_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
59 , x_old_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
60 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61 , x_return_status IN OUT NOCOPY VARCHAR2
62 ) ;
63
64
65
66
67 /****************************************************************************
68 * CHECK ATTRIBUTES
69 *****************************************************************************/
70
71 -- Check_Attributes used by RTG BO
72 /*#
73 * This method as used by Routing BO checks for each of the attribute/field individually for validity.
74 * Examples of these checks are: range checks, checks against lookups etc. It checks
75 * whether user-entered attributes are valid and it also checks each attribute independently of the others
76 * It raises
77 * 1 Severe Error IV in case of Create transaction type
78 * 2 Standard Error in case of other transaction types.
79 * @param x_return_status IN OUT NOCOPY Return Status
80 * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
81 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
82 * @param p_sub_resource_rec IN Sub Operation Resource Exposed Column Record
83 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
84 * @param p_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
85 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
86 * @rep:scope private
87 * @rep:displayname Check Sub Operation Resource Attributes
88 * @rep:compatibility S
89 * @rep:lifecycle active
90 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
91 */
92 PROCEDURE Check_Attributes
93 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
94 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
95 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
96 , x_return_status IN OUT NOCOPY VARCHAR2
97 ) ;
98
99
100 -- Check_Attributes used by ECO BO and internally called by RTG BO
101 /*#
102 * This method as used by ECO BO checks for each of the attribute/field individually for validity.
103 * Examples of these checks are: range checks, checks against lookups etc. It checks
104 * whether user-entered attributes are valid and it also checks each attribute independently of the others
105 * It raises
106 * 1 Severe Error IV in case of Create transaction type
107 * 2 Standard Error in case of other transaction types.
108 * @param x_return_status IN OUT NOCOPY Return Status
109 * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
110 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
111 * @param p_rev_sub_resource_rec IN Sub Operation Resource Exposed Column Record
112 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
113 * @param p_rev_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
114 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
115 * @rep:scope private
116 * @rep:displayname Check Sub Operation Resource Attributes
117 * @rep:compatibility S
118 * @rep:lifecycle active
119 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
120 */
121 PROCEDURE Check_Attributes
122 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
123 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
124 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
125 , x_return_status IN OUT NOCOPY VARCHAR2
126 ) ;
127
128
129 /****************************************************************************
130 * CHECK ENTITY ATTRIBUTES
131 *****************************************************************************/
132
133 -- Check_Entity used by RTG BO
134 /*#
135 * This as used by Routing BO is where the whole record is checked. The following are checked
136 * Non-updatable columns (UPDATEs): Certain columns must not be changed by the user when updating the record
137 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it
138 * Business logic: The record must comply with business logic rules.
139 * It raises
140 * 1 Severe Error IV for Create transaction type.
141 * 2 Standard Error for Update transaction type.
142 * @param x_return_status IN OUT NOCOPY Return Status
143 * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
144 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
145 * @param p_sub_resource_rec IN Sub Operation Resource Exposed Column Record
146 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
147 * @param p_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
148 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
149 * @param p_old_sub_resource_rec IN Sub Operation Resource Old Record Exposed Column Record
150 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
151 * @param p_old_sub_res_unexp_rec IN Sub Operation Resource Old Record Unexposed Column Record
152 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
153 * @param x_sub_resource_rec IN Sub Operation Resource Record Exposed Column Record
154 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
155 * @param x_sub_res_unexp_rec IN Sub Operation Resource Record Unexposed Column Record
156 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
157 * @rep:scope private
158 * @rep:displayname Check Sub Operation Resource Entity
159 * @rep:compatibility S
160 * @rep:lifecycle active
161 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
162 */
163
164 PROCEDURE Check_Entity
165 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
166 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
167 , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
168 , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
169 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
170 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
171 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
172 , x_return_status IN OUT NOCOPY VARCHAR2
173 ) ;
174
175 -- Check_Entity used by ECO BO and internally called by RTG BO
176 /*#
177 * This as used by ECO BO is where the whole record is checked. The following are checked
178 * Non-updatable columns (UPDATEs): Certain columns must not be changed by the user when updating the record
179 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it
180 * Business logic: The record must comply with business logic rules.
181 * It raises
182 * 1 Severe Error IV for Create transaction type.
183 * 2 Standard Error for Update transaction type.
184 * @param x_return_status IN OUT NOCOPY Return Status
185 * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
186 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
187 * @param p_rev_sub_resource_rec IN Sub Operation Resource Exposed Column Record
188 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
189 * @param p_rev_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
190 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
191 * @param p_old_rev_sub_resource_rec IN Sub Operation Resource Old Record Exposed Column Record
192 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
193 * @param p_old_rev_sub_res_unexp_rec IN Sub Operation Resource Old Record Unexposed Column Record
194 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
195 * @param p_control_Rec IN Control Record
196 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
197 * @param x_rev_sub_resource_rec IN Sub Operation Resource Record Exposed Column Record
198 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
199 * @param x_rev_sub_res_unexp_rec IN Sub Operation Resource Record Unexposed Column Record
200 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
201 * @rep:scope private
202 * @rep:displayname Check Component Entity
203 * @rep:compatibility S
204 * @rep:lifecycle active
205 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
206 */
207
208 PROCEDURE Check_Entity
209 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
210 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
211 , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
212 , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
213 , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
214 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
215 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
216 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
217 , x_return_status IN OUT NOCOPY VARCHAR2
218 ) ;
219
220
221
222 /****************************************************************************
223 * OTHERS
224 *****************************************************************************/
225
226 PROCEDURE Val_Scheduled_Sub_Resource
227 ( p_op_seq_id IN NUMBER
228 , p_resource_id IN NUMBER
229 , p_sub_group_num IN NUMBER
230 , p_schedule_flag IN NUMBER
231 , x_return_status IN OUT NOCOPY VARCHAR2
232 ) ;
233
234
235 PROCEDURE Val_Sub_PO_Move
236 ( p_op_seq_id IN NUMBER
237 , p_resource_id IN NUMBER
238 , p_sub_group_num IN NUMBER
239 , x_return_status IN OUT NOCOPY VARCHAR2
240 ) ;
241
242 /* Fix for bug 6074930 - Added below procedure val_schedule_flag.*/
243 PROCEDURE Val_Schedule_Flag
244 ( p_op_seq_id IN NUMBER
245 , p_res_seq_num IN NUMBER
246 , p_sch_seq_num IN NUMBER
247 , p_sch_flag IN NUMBER
248 , p_sub_grp_num IN NUMBER
249 , p_rep_grp_num IN NUMBER
250 , p_basis_type IN NUMBER
251 , p_in_res_id IN NUMBER
252 , p_ret_res_id IN OUT NOCOPY NUMBER
253 , x_return_status IN OUT NOCOPY VARCHAR2
254 );
255
256
257
258 /****************************************************************************
259 * CHECK REQUIRED
260
261 -- Check_Required used by RTG BO
262 PROCEDURE Check_Required
263 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
264 , x_return_status IN OUT NOCOPY VARCHAR2
265 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
266 ) ;
267
268 -- Check_Required used by ECO BO
269 PROCEDURE Check_Required
270 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_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 PROCEDURE Check_Required
278 ( p_com_sub_resource_rec IN Bom_Rtg_Pub.Com_op_resource_Rec_Type
279 , x_return_status IN OUT NOCOPY VARCHAR2
280 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
281 ) ;
282
283 *****************************************************************************/
284
285
286 /****************************************************************************
287 * CHECK CONDITIONALLY REQUIRED
288
289 -- Check_Conditionally_Required used by RTG BO
290 PROCEDURE Check_Conditionally_Required
291 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
292 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
293 , x_return_status IN OUT NOCOPY VARCHAR2
294 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
295 ) ;
296
297 -- Check_Conditionally_Required used by ECO BO
298 PROCEDURE Check_Conditionally_Required
299 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
300 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
301 , x_return_status IN OUT NOCOPY VARCHAR2
302 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
303 ) ;
304
305 -- Check_Conditionally_Required internally called by RTG BO and ECO BO
306 PROCEDURE Check_Conditionally_Required
307 ( p_com_sub_resource_rec IN Bom_Rtg_Pub.Com_op_resource_Rec_Type
308 , p_com_sub_res_unexp_rec IN Bom_Rtg_Pub.Com_Sub_Res_Unexposed_Rec_Type
309 , x_return_status IN OUT NOCOPY VARCHAR2
310 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
311 ) ;
312
313 *****************************************************************************/
314
315
316 /*
317
318
319
320 -- Procedure Entity_Delete
321
322 PROCEDURE Check_Entity_Delete
323 ( x_return_status IN OUT NOCOPY VARCHAR2
324 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
325 , p_bom_component_rec IN Bom_Rtg_Pub.Bom_Comps_Rec_Type
326 , p_bom_Comp_Unexp_Rec IN Bom_Rtg_Pub.Bom_Comps_Unexposed_Rec_Type
327 );
328
329
330
331 */
332
333 /*
334 ** Procedures used by ECO BO and internally called by RTG BO
335
336
337
338 PROCEDURE Check_Entity_Delete
339 ( x_return_status IN OUT NOCOPY VARCHAR2
340 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
341 , p_rev_component_rec IN Bom_Rtg_Pub.Rev_Component_Rec_Type
342 , p_Rev_Comp_Unexp_Rec IN Bom_Rtg_Pub.Rev_Comp_Unexposed_Rec_Type
343 );
344
345
346
347
348 PROCEDURE Check_Access
349 ( p_revised_item_name IN VARCHAR2
350 , p_revised_item_id IN NUMBER
351 , p_organization_id IN NUMBER
352 , p_change_notice IN VARCHAR2
353 , p_new_item_revision IN VARCHAR2
354 , p_effectivity_date IN DATE
355 , p_component_item_id IN NUMBER
356 , p_op_resource_seq_num IN NUMBER
357 , p_bill_sequence_id IN NUMBER
358 , p_component_name IN VARCHAR2
359 , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
360 Error_Handler.G_MISS_MESG_TOKEN_TBL
361 , p_entity_processed IN VARCHAR2 := 'RC'
362 , p_rfd_sbc_name IN VARCHAR2 := NULL
363 , x_mesg_token_tbl OUT Error_Handler.Mesg_Token_Tbl_Type
364 , x_Return_Status OUT VARCHAR2
365 );
366
367
368 */
369
370 ------------------------------------------------------------------------------
371
372
373
374 END BOM_Validate_Sub_Op_Res ;