DBA Data[Home] [Help]

APPS.REV_CONTROLLER dependencies on BOM_BO_PUB

Line 84: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

80: -- Procedure Validate_And_Write
81:
82: PROCEDURE Validate_And_Write
83: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type
84: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
85: , p_record_status IN VARCHAR2
86: , x_REV_controller_rec IN OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
87: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
88: , x_return_status OUT NOCOPY VARCHAR2

Line 91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

87: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
88: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

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;

Line 98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_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;

Line 99: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_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;

Line 107: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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:
111: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;

Line 108: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_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:
111: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
112: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 109: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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:
111: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
112: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
113: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 183: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

179: -- Procedure Delete_Row
180:
181: PROCEDURE Delete_Row
182: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type
183: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
185: , x_return_status OUT NOCOPY VARCHAR2
186: )
187: IS

Line 188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
185: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

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;

Line 195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_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;

Line 196: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_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;

Line 204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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:
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;

Line 205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_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:
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
209: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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:
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
209: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
210: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;