APPS.SBC_CONTROLLER dependencies on BOM_BO_PUB

Line 8: , x_SBC_tbl OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_SBC_rec IN Controller_SBC_Rec_Type
8: , x_SBC_tbl OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
9: , x_unexp_SBC_rec OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN

Line 9: , x_unexp_SBC_rec OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_SBC_rec IN Controller_SBC_Rec_Type
8: , x_SBC_tbl OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
9: , x_unexp_SBC_rec OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record

Line 55: ( p_SBC_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

51: x_unexp_SBC_rec.substitute_component_id := p_controller_SBC_rec.substitute_component_id;
52: END Create_Exp_Unexp_Rec;
53:
54: PROCEDURE Create_Controller_Rec
55: ( p_SBC_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
56: , p_unexp_SBC_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
57: , x_controller_SBC_rec OUT NOCOPY Controller_SBC_Rec_Type
58: )
59: IS

Line 56: , p_unexp_SBC_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

52: END Create_Exp_Unexp_Rec;
53:
54: PROCEDURE Create_Controller_Rec
55: ( p_SBC_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
56: , p_unexp_SBC_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
57: , x_controller_SBC_rec OUT NOCOPY Controller_SBC_Rec_Type
58: )
59: IS
60: BEGIN

Line 104: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

100: -- Procedure Initialize_Record
101:
102: PROCEDURE Initialize_Record
103: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
104: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
105: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
106: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
107: , x_return_status OUT NOCOPY VARCHAR2
108: )

Line 110: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

106: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
107: , x_return_status OUT NOCOPY VARCHAR2
108: )
109: IS
110: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
111: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
112: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
113: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
114: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

112: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
113: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
114: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
115: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

113: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
114: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
115: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

114: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
115: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
130:

Line 185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

181: -- Procedure Validate_And_Write
182:
183: PROCEDURE Validate_And_Write
184: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: , p_record_status IN VARCHAR2
187: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
189: , x_return_status OUT NOCOPY VARCHAR2

Line 192: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
189: , x_return_status OUT NOCOPY VARCHAR2
190: )
191: IS
192: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
193: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
194: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
195: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
196: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

194: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
195: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
196: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
197: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

195: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
196: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
197: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

196: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
197: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
212:

Line 277: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

273: -- Procedure Delete_Row
274:
275: PROCEDURE Delete_Row
276: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
277: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
278: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
279: , x_return_status OUT NOCOPY VARCHAR2
280: )
281: IS

Line 282: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

278: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
279: , x_return_status OUT NOCOPY VARCHAR2
280: )
281: IS
282: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
283: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
284: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
285: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
286: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

284: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
285: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
286: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
287: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

285: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
286: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
287: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

286: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
287: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
302:

Line 356: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

352: --Procedure Change_Attibute
353:
354: PROCEDURE Change_Attribute
355: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
356: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
357: , p_record_status IN VARCHAR2
358: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
359: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
360: , x_return_status OUT NOCOPY VARCHAR2

Line 363: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

359: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
360: , x_return_status OUT NOCOPY VARCHAR2
361: )
362: IS
363: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
364: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
365: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
366: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
367: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

365: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
366: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
367: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
368: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

366: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
367: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
368: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

367: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
368: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
383: