4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_SRS_rec IN Controller_SRS_Rec_Type
8: , x_SRS_tbl OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
9: , x_unexp_SRS_rec OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_SRS_rec IN Controller_SRS_Rec_Type
8: , x_SRS_tbl OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
9: , x_unexp_SRS_rec OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record
73:
74:
75:
76: PROCEDURE Create_Controller_Rec
77: ( p_SRS_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
78: , p_unexp_SRS_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
79: , x_controller_SRS_rec OUT NOCOPY Controller_SRS_Rec_Type
80: )
81: IS
74:
75:
76: PROCEDURE Create_Controller_Rec
77: ( p_SRS_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
78: , p_unexp_SRS_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
79: , x_controller_SRS_rec OUT NOCOPY Controller_SRS_Rec_Type
80: )
81: IS
82: BEGIN
156: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
157: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
158: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
159: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
160: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
161: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
162: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
163: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
164: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
157: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
158: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
159: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
160: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
161: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
162: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
163: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
164: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
165: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
158: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
159: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
160: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
161: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
162: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
163: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
164: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
165: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
166: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
164: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
165: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
166: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
167: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
168: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
169: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
170: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
171:
172: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
165: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
166: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
167: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
168: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
169: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
170: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
171:
172: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
173: l_return_status VARCHAR2(1);
166: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
167: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
168: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
169: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
170: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
171:
172: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
173: l_return_status VARCHAR2(1);
174: l_msg_count NUMBER;
238: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
239: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
240: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
241: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
242: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
243: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
244: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
245: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
246: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
239: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
240: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
241: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
242: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
243: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
244: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
245: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
246: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
247: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
240: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
241: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
242: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
243: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
244: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
245: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
246: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
247: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
248: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
246: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
247: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
248: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
249: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
250: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
251: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
252: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
253:
254: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
247: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
248: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
249: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
250: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
251: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
252: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
253:
254: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
255: l_return_status VARCHAR2(1);
248: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
249: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
250: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
251: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
252: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
253:
254: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
255: l_return_status VARCHAR2(1);
256: l_msg_count NUMBER;
329: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
330: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
331: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
332: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
333: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
334: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
335: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
336: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
337: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
330: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
331: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
332: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
333: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
334: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
335: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
336: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
337: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
338: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
331: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
332: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
333: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
334: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
335: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
336: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
337: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
338: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
339: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
337: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
338: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
339: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
340: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
341: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
342: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
343: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
344:
345: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
338: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
339: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
340: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
341: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
342: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
343: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
344:
345: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
346: l_return_status VARCHAR2(1);
339: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
340: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
341: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
342: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
343: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
344:
345: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
346: l_return_status VARCHAR2(1);
347: l_msg_count NUMBER;
411: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
412: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
413: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
414: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
415: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
416: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
417: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
418: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
419: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
412: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
413: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
414: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
415: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
416: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
417: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
418: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
419: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
420: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
413: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
414: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
415: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
416: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
417: l_unexp_SRS_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
418: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
419: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
420: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
421: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
419: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
420: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
421: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
422: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
423: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
424: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
425: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
426:
427: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
420: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
421: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
422: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
423: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
424: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
425: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
426:
427: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
428: l_return_status VARCHAR2(1);
421: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
422: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
423: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
424: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
425: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
426:
427: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
428: l_return_status VARCHAR2(1);
429: l_msg_count NUMBER;