166: * Parameters OUT: N/A
167: * Purpose : This function is to check all the records have the * same change_notice and same organization.
168: *********************************************************************/
169: FUNCTION Does_Op_Have_Same_ECO
170: ( p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
171: , p_change_notice IN VARCHAR2
172: , p_organization_code IN VARCHAR2
173: ) RETURN BOOLEAN
174: IS
202: * Parameters OUT: N/A
203: * Purpose : This function is to check all the records have the * same change_notice and same organization.
204: *********************************************************************/
205: FUNCTION Does_Res_Have_Same_ECO
206: ( p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
207: , p_change_notice IN VARCHAR2
208: , p_organization_code IN VARCHAR2
209: ) RETURN BOOLEAN
210: IS
238: * Parameters OUT: N/A
239: * Purpose : This function is to check all the records have the * same change_notice and same organization.
240: *********************************************************************/
241: FUNCTION Does_SubRes_Have_Same_ECO
242: ( p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
243: , p_change_notice IN VARCHAR2
244: , p_organization_code IN VARCHAR2
245: ) RETURN BOOLEAN
246: IS
312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
321: , x_organization_code OUT NOCOPY VARCHAR2
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
321: , x_organization_code OUT NOCOPY VARCHAR2
322: ) RETURN BOOLEAN
1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1031: record_count NUMBER;
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1031: record_count NUMBER;
1032: BEGIN
1140: , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
1141: G_MISS_REF_DESIGNATOR_TBL
1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1141: G_MISS_REF_DESIGNATOR_TBL
1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL
1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL
1161: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL
1161: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1162: )
1221: , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
1222: G_MISS_REF_DESIGNATOR_TBL
1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1222: G_MISS_REF_DESIGNATOR_TBL
1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1233: , x_change_line_tbl IN OUT NOCOPY Change_Line_Tbl_Type -- Eng Change
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1233: , x_change_line_tbl IN OUT NOCOPY Change_Line_Tbl_Type -- Eng Change
1234: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1234: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1235: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL
1235: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL
1243: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL
1243: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1244: )
1261: l_revised_item_tbl Revised_Item_Tbl_Type;
1262: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change
1262: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change
1270: l_change_line_tbl Change_Line_Tbl_Type;
1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change
1270: l_change_line_tbl Change_Line_Tbl_Type;
1271: l_disable_revision NUMBER; --BUG 3034642
1275: l_p_revised_item_tbl Revised_Item_Tbl_Type;
1276: l_p_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1276: l_p_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1284: BEGIN
1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1284: BEGIN
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;