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
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: );
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
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
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: );
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:
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
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: );
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: /*
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
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: );
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: */
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
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: );
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
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: );
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
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: );
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
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: );
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:
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
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: );
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
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: );
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:
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
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: );
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:
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
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: );
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
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: );
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:
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
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: );
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
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: );
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:
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
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: );
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:
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
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: );
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
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: );
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:
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
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: );
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:
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
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: );
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: /*
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
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: );
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: */