75:
76: -- Function Does_Comp_Have_Same_ECO
77:
78: FUNCTION Does_Comp_Have_Same_ECO
79: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
80: , p_change_notice IN VARCHAR2
81: , p_organization_code IN VARCHAR2
82: ) RETURN BOOLEAN
83: IS
103:
104: -- Function Does_Desg_Have_Same_ECO
105:
106: FUNCTION Does_Desg_Have_Same_ECO
107: ( p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
108: , p_change_notice IN VARCHAR2
109: , p_organization_code IN VARCHAR2
110: ) RETURN BOOLEAN
111: IS
131:
132: -- Function Does_SComp_Have_Same_ECO
133:
134: FUNCTION Does_SComp_Have_Same_ECO
135: ( p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
136: , p_change_notice IN VARCHAR2
137: , p_organization_code IN VARCHAR2
138: ) RETURN BOOLEAN
139: IS
309: FUNCTION Check_Records_In_Same_ECO
310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
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
310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
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
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
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
1019: PROCEDURE Populate_Bo_Tables
1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
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
1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
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
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
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 )
1134: , p_eco_revision_tbl IN Eco_Revision_Tbl_Type :=
1135: G_MISS_ECO_REVISION_TBL
1136: , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
1137: G_MISS_REVISED_ITEM_TBL
1138: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1139: G_MISS_REV_COMPONENT_TBL
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 :=
1136: , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
1137: G_MISS_REVISED_ITEM_TBL
1138: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1139: G_MISS_REV_COMPONENT_TBL
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
1138: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1139: G_MISS_REV_COMPONENT_TBL
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
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
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--
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
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--
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
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'
1215: , p_change_line_tbl IN Change_Line_Tbl_Type := -- Eng Change
1216: G_MISS_CHANGE_LINE_TBL
1217: , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
1218: G_MISS_REVISED_ITEM_TBL
1219: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1220: G_MISS_REV_COMPONENT_TBL
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 :=
1217: , p_revised_item_tbl IN Revised_Item_Tbl_Type :=
1218: G_MISS_REVISED_ITEM_TBL
1219: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1220: G_MISS_REV_COMPONENT_TBL
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
1219: , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type :=
1220: G_MISS_REV_COMPONENT_TBL
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
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
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--
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
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--
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
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'
1258:
1259: l_ECO_rec Eco_Rec_Type;
1260: l_eco_revision_tbl Eco_Revision_Tbl_Type;
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--
1259: l_ECO_rec Eco_Rec_Type;
1260: l_eco_revision_tbl Eco_Revision_Tbl_Type;
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--
1260: l_eco_revision_tbl Eco_Revision_Tbl_Type;
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:
1272:
1273: l_p_ECO_rec Eco_Rec_Type;
1274: l_p_eco_revision_tbl Eco_Revision_Tbl_Type;
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--
1273: l_p_ECO_rec Eco_Rec_Type;
1274: l_p_eco_revision_tbl Eco_Revision_Tbl_Type;
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--
1274: l_p_eco_revision_tbl Eco_Revision_Tbl_Type;
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;