1 PACKAGE BOM_Rtg_Val_To_Id AUTHID CURRENT_USER AS
2 /* $Header: BOMRVIDS.pls 115.3 2002/11/21 06:02:48 djebar ship $*/
3 /****************************************************************************
4 --
5 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 -- FILENAME BOMRVIDS.pls
8 --
9 --
10 --
11 -- DESCRIPTION
12 --
13 -- Spec of package BOM_RTG_Val_To_Id
14 --
15 -- NOTES
16 --
17 -- HISTORY
18 --
19 -- 07-AUG-00 Biao Zhang Initial Creation
20 -- 07-SEP-00 Masanori Kimizuka Modified to support ECO for Routing
21 --
22 ****************************************************************************/
23
24
25 FUNCTION Organization
26 ( p_organization IN VARCHAR2
27 , x_err_text IN OUT NOCOPY VARCHAR2)
28 RETURN NUMBER;
29
30 FUNCTION Assembly_Item
31 ( p_assembly_item_name IN VARCHAR2
32 , p_organization_id IN NUMBER
33 , x_err_text IN OUT NOCOPY VARCHAR2)
34 RETURN NUMBER;
35
36
37 FUNCTION Common_Assembly_Item_Id
38 ( p_organization_id IN NUMBER
39 , p_common_assembly_item_name IN VARCHAR2
40 , x_err_text IN OUT NOCOPY VARCHAR2)
41 RETURN NUMBER;
42
43 FUNCTION Routing_Sequence_id
44 ( p_assembly_item_id IN NUMBER
45 , p_organization_id IN NUMBER
46 , p_alternate_routing_designator IN VARCHAR2
47 , x_err_text IN OUT NOCOPY VARCHAR2)
48 RETURN NUMBER;
49
50 FUNCTION Common_Routing_Sequence_id
51 ( p_common_assembly_item_id IN NUMBER
52 , p_organization_id IN NUMBER
53 , p_alternate_routing_designator IN VARCHAR2
54 , x_err_text IN OUT NOCOPY VARCHAR2)
55 RETURN NUMBER;
56
57 FUNCTION Completion_locator_id
58 ( p_completion_location_name IN VARCHAR2
59 , p_organization_id IN NUMBER
60 , x_err_text IN OUT NOCOPY VARCHAR2)
61 RETURN NUMBER;
62
63 FUNCTION Line_Id
64 ( p_line_code IN VARCHAR2
65 , p_organization_id IN NUMBER
66 , x_err_text IN OUT NOCOPY VARCHAR2
67 ) RETURN NUMBER;
68
69 FUNCTION Standard_Operation_Id
70 ( p_operation_type IN NUMBER
71 , p_standard_operation_code IN VARCHAR2
72 , p_organization_id IN NUMBER
73 , p_routing_sequence_id IN NUMBER
74 , x_err_text IN OUT NOCOPY VARCHAR2
75 ) RETURN NUMBER;
76
77 FUNCTION Department_Id
78 ( p_department_code IN VARCHAR2
79 , p_organization_id IN NUMBER
80 , x_err_text IN OUT NOCOPY VARCHAR2
81 ) RETURN NUMBER;
82
83 FUNCTION Process_Op_Seq_Id
84 ( p_process_code IN VARCHAR2
85 , p_organization_id IN NUMBER
86 , p_process_seq_number IN NUMBER
87 , p_routing_sequence_id IN NUMBER
88 , x_err_text IN OUT NOCOPY VARCHAR2
89 ) RETURN NUMBER;
90
91 FUNCTION Line_Op_Seq_Id
92 ( p_line_code IN VARCHAR2
93 , p_organization_id IN NUMBER
94 , p_line_seq_number IN NUMBER
95 , p_routing_sequence_id IN NUMBER
96 , x_err_text IN OUT NOCOPY VARCHAR2
97 ) RETURN NUMBER;
98
99 FUNCTION Activity_Id
100 ( p_activity IN VARCHAR2
101 , p_organization_id IN NUMBER
102 , x_err_text IN OUT NOCOPY VARCHAR2
103 ) RETURN NUMBER;
104
105 --confirm
106 FUNCTION Resource_Id
107 ( p_resource_code IN VARCHAR2
108 , p_organization_id IN NUMBER
109 , x_err_text IN OUT NOCOPY VARCHAR2
110 ) RETURN NUMBER;
111
112 FUNCTION Operation_Sequence_Id
113 ( p_routing_sequence_id IN NUMBER
114 , p_operation_type IN NUMBER
115 , p_operation_seq_num IN NUMBER
116 , p_effectivity_date IN date
117 , x_err_text IN OUT NOCOPY VARCHAR2
118 ) RETURN NUMBER;
119
120
121
122 /***************************************************************************
123 *
124 * ROUTING HEADER ENTITY
125 *
126 *****************************************************************************/
127
128 -- Convert Routing header User Unique Index to Unique Index
129 PROCEDURE Rtg_Header_UUI_To_UI
130 ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_header_rec_type
131 , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
132 , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
133 , x_return_status IN OUT NOCOPY VARCHAR2
134 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
135 );
136 -- Convert header value to ID
137 PROCEDURE Rtg_Header_VID
138 ( p_rtg_header_Rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
139 , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
140 , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
141 , x_Return_Status IN OUT NOCOPY VARCHAR2
142 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
143 );
144
145
146 /***************************************************************************
147 *
148 * ROUTING REVISIONS ENTITY
149 *
150 *****************************************************************************/
151
152 -- Convert Routing revision User Unique Index to Unique Index
153 PROCEDURE Rtg_revision_UUI_To_UI
154 ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
155 , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
156 , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
157 , x_return_status IN OUT NOCOPY VARCHAR2
158 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159 );
160 /*
161 -- Convert routing revision record value to ID
162 PROCEDURE Rtg_revision_VID
163 ( p_operation_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
164 , p_operation_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
165 , x_rtg_head_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
166 , x_Return_Status IN OUT NOCOPY VARCHAR2
167 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
168 );
169 */
170
171
172
173 /***************************************************************************
174 *
175 * OPERATION SEQUENCES ENTITY
176 *
177 *****************************************************************************/
178
179
180 -- Convert operation User Unique Index to Unique Index
181 -- Called by the Routing Business Object
182 PROCEDURE Operation_UUI_To_UI
183 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
184 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
185 , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
186 , x_return_status IN OUT NOCOPY VARCHAR2
187 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188 );
189
190
191 -- Convert revised operation User Unique Index to Unique Index
192 -- Called by the ECO Business Object
193 PROCEDURE Rev_Operation_UUI_To_UI
194 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
195 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
196 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
197 , x_return_status IN OUT NOCOPY VARCHAR2
198 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
199 );
200
201
202 -- Convert common operation User Unique Index to Unique Index
203 -- Internally called by the ECO and Routing Business Object
204 PROCEDURE Com_Operation_UUI_To_UI
205 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
206 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
207 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
208 , x_return_status IN OUT NOCOPY VARCHAR2
209 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210 );
211
212
213 -- Convert operation value to ID
214 -- Called by the Routing Business Object
215 PROCEDURE Operation_VID
216 ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
217 , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
218 , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
219 , x_Return_Status IN OUT NOCOPY VARCHAR2
220 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
221 );
222
223 -- Convert revised operation value to ID
224 -- Called by the ECO Business Object
225 PROCEDURE Rev_Operation_VID
226 ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
227 , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
228 , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
229 , x_Return_Status IN OUT NOCOPY VARCHAR2
230 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
231 );
232
233
234 -- Convert common operation value to ID
235 -- Internally called by the ECO and Routing Business Object
236 PROCEDURE Com_Operation_VID
237 ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
238 , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
239 , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
240 , x_Return_Status IN OUT NOCOPY VARCHAR2
241 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242 );
243
244
245 /***************************************************************************
246 *
247 * OPERATION RESOURCES ENTITY
248 *
249 *****************************************************************************/
250
251
252 -- Convert operation resource User Unique Index to Unique Index
253 -- Called by the Routing Business Object
254 PROCEDURE Op_resource_UUI_To_UI
255 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
256 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
257 , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
258 , x_return_status IN OUT NOCOPY VARCHAR2
259 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
260 );
261
262 /*
263 -- Convert operation User Unique Index to Unique Index in resource record
264 PROCEDURE Op_resource_UUI_To_UI2
265 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
266 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
267 , x_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
268 , x_return_status IN OUT NOCOPY VARCHAR2
269 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
270 );
271 */
272
273 -- Convert operation resource value to ID
274 -- Called by the Routing Business Object
275 PROCEDURE Op_resource_VID
276 ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
277 , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
278 , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_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 -- Convert revised operation resource User Unique Index to Unique Index
286 -- Called by the ECO Business Object
287 PROCEDURE Rev_Op_resource_UUI_To_UI
288 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
289 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
290 , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
291 , x_return_status IN OUT NOCOPY VARCHAR2
292 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
293 );
294
295
296 -- Convert revised operation resource value to ID
297 -- Called by the ECO Business Object
298 PROCEDURE Rev_Op_resource_VID
299 ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
300 , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
301 , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
302 , x_Return_Status IN OUT NOCOPY VARCHAR2
303 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
304 );
305
306
307 /***************************************************************************
308 *
309 * SUBSTITUTE OPERATION RESOURCES ENTITY
310 *
311 *****************************************************************************/
312
313 -- Convert operation sub resource User Unique Index to Unique Index
314 -- Called by the Routing Business Object
315 PROCEDURE Sub_Resource_UUI_To_UI
316 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
317 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
318 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
319 , x_return_status IN OUT NOCOPY VARCHAR2
320 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
321 );
322
323 -- Convert operation sub resource value to ID
324 -- Called by the Routing Business Object
325 PROCEDURE Sub_Resource_VID
326 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
327 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
328 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
329 , x_Return_Status IN OUT NOCOPY VARCHAR2
330 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
331 );
332
333
334 -- Convert revised operation sub resource User Unique Index to Unique Index
335 -- Called by the ECO Business Object
336 PROCEDURE Rev_Sub_Resource_UUI_To_UI
337 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
338 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
339 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
340 , x_return_status IN OUT NOCOPY VARCHAR2
341 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
342 );
343
344 -- Convert revised operation sub resource value to ID
345 -- Called by the ECO Business Object
346 PROCEDURE Rev_Sub_Resource_VID
347 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
348 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
349 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
350 , x_Return_Status IN OUT NOCOPY VARCHAR2
351 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
352 );
353
354
355 /***************************************************************************
356 *
357 * OPERATION NETWORK ENTITY
358 *
359 *****************************************************************************/
360
361 -- Convert operation network User Unique Index to Unique Index
362 PROCEDURE OP_network_UUI_To_UI
363 ( p_op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
364 , p_op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
365 , x_op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
366 , x_return_status IN OUT NOCOPY VARCHAR2
367 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
368 );
369 /*
370 -- Convert operation network value to ID
371 PROCEDURE OP_network_VID
372 ( p_op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
373 , p_op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
374 , x_op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
375 , x_Return_Status IN OUT NOCOPY VARCHAR2
376 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
377 );
378 */
379
380 END BOM_Rtg_Val_To_Id;