4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_REV_rec IN REV_Controller.Controller_REV_Rec_Type
8: , x_REV_tbl OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
9: , x_unexp_REV_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_REV_rec IN REV_Controller.Controller_REV_Rec_Type
8: , x_REV_tbl OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
9: , x_unexp_REV_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record
42:
43: END Create_Exp_Unexp_Rec;
44:
45: PROCEDURE Create_Controller_Rec
46: ( p_REV_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
47: , p_unexp_REV_rec IN ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
48: , x_controller_REV_rec OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
49: )
50: IS
43: END Create_Exp_Unexp_Rec;
44:
45: PROCEDURE Create_Controller_Rec
46: ( p_REV_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
47: , p_unexp_REV_rec IN ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
48: , x_controller_REV_rec OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
49: )
50: IS
51: BEGIN
89: )
90: IS
91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
90: IS
91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
99: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
99: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
100:
101: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
102: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
103: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
104:
105: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
106: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
107: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
108: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
109: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
102: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
103: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
104:
105: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
106: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
107: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
108: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
109: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
110:
186: )
187: IS
188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
187: IS
188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
196: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
196: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
197:
198: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
199: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
200: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
201:
202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
199: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
200: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
201:
202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
207:
262: /*
263: --Procedure Change_Attibute
264:
265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
263: --Procedure Change_Attibute
264:
265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2
265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
291: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
291: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
292: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
350:
351: PROCEDURE Lock_Row
352: ( x_return_status OUT NOCOPY VARCHAR2
353: , x_err_text OUT NOCOPY VARCHAR2
354: , p_REV_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
356: );
357: */
358:
351: PROCEDURE Lock_Row
352: ( x_return_status OUT NOCOPY VARCHAR2
353: , x_err_text OUT NOCOPY VARCHAR2
354: , p_REV_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
356: );
357: */
358:
359: END REV_Controller;