8:
9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1
18: G_MISS_REV_SUB_RES_REC Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;--L1
75: /* Exposed and Unexposed record */
76: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
77: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
78: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
79: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
76: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
77: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
78: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
79: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
77: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
78: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
79: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
78: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
79: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
79: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
80: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
81: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
1456: /* Other Entities */
1457: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
1458: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1459: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1460: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1457: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
1458: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1459: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1460: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1458: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1459: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1460: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1459: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1460: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1460: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1461: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1469: -- := p_rev_sub_resource_tbl ;
1462: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1469: -- := p_rev_sub_resource_tbl ;
1470:
2819: /* Other Entities */
2820: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2821: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2822: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2823: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2820: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2821: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2822: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2823: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2821: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2822: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2823: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2822: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2823: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2823: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2824: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2832:
2825: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2832:
2833: /* Others */
4468: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4469: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4470: , p_component_item_name IN VARCHAR2 := NULL
4471: , p_operation_seq_num IN NUMBER := NULL
4472: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
4473: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4474: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4475: , x_return_status OUT NOCOPY VARCHAR2
4476: )
4469: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4470: , p_component_item_name IN VARCHAR2 := NULL
4471: , p_operation_seq_num IN NUMBER := NULL
4472: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
4473: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4474: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4475: , x_return_status OUT NOCOPY VARCHAR2
4476: )
4477: IS
4486: l_bo_return_status VARCHAR2(1);
4487: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
4488: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4489: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4490: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4487: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
4488: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4489: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4490: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4488: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4489: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4490: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4489: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4490: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4497: l_return_value NUMBER;
4490: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4497: l_return_value NUMBER;
4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4491: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4497: l_return_value NUMBER;
4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4499:
4492: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4493: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4494: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4495: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4497: l_return_value NUMBER;
4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4499:
4500: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5375: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5376: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5377: , p_component_item_name IN VARCHAR2 := NULL
5378: , p_operation_seq_num IN NUMBER := NULL
5379: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5380: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5381: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5382: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5383: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5376: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5377: , p_component_item_name IN VARCHAR2 := NULL
5378: , p_operation_seq_num IN NUMBER := NULL
5379: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5380: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5381: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5382: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5383: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5384: , x_return_status OUT NOCOPY VARCHAR2
5377: , p_component_item_name IN VARCHAR2 := NULL
5378: , p_operation_seq_num IN NUMBER := NULL
5379: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5380: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5381: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5382: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5383: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5384: , x_return_status OUT NOCOPY VARCHAR2
5385: )
5378: , p_operation_seq_num IN NUMBER := NULL
5379: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5380: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5381: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5382: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5383: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5384: , x_return_status OUT NOCOPY VARCHAR2
5385: )
5386: IS
5395: l_bo_return_status VARCHAR2(1);
5396: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
5397: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5398: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5399: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5396: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
5397: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5398: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5399: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5397: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5398: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5399: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5398: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5399: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5406: l_return_value NUMBER;
5399: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5406: l_return_value NUMBER;
5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5400: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5406: l_return_value NUMBER;
5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5408:
5401: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5402: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5403: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5404: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5406: l_return_value NUMBER;
5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5408:
5409: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6195: , p_item_revision IN VARCHAR2 := NULL
6196: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6197: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6198: , I IN NUMBER
6199: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6196: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6197: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6198: , I IN NUMBER
6199: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6197: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6198: , I IN NUMBER
6199: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6205: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6198: , I IN NUMBER
6199: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6205: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6206: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6199: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6205: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6206: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6207: , x_return_status OUT NOCOPY VARCHAR2
6200: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6205: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6206: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6207: , x_return_status OUT NOCOPY VARCHAR2
6208: -- Bug 2941096 // kamohan
6201: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6202: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6203: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6204: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6205: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6206: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6207: , x_return_status OUT NOCOPY VARCHAR2
6208: -- Bug 2941096 // kamohan
6209: , x_bill_sequence_id IN NUMBER := NULL
6219: l_bo_return_status VARCHAR2(1);
6220: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
6221: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6222: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6223: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6220: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
6221: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6222: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6223: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6221: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6222: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6223: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6229: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6222: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6223: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6229: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6230: l_return_value NUMBER;
6223: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6229: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6230: l_return_value NUMBER;
6231: l_process_children BOOLEAN := TRUE;
6224: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6229: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6230: l_return_value NUMBER;
6231: l_process_children BOOLEAN := TRUE;
6232: l_dummy NUMBER ;
6225: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6226: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6227: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6228: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6229: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6230: l_return_value NUMBER;
6231: l_process_children BOOLEAN := TRUE;
6232: l_dummy NUMBER ;
6233: l_Token_Tbl Error_Handler.Token_Tbl_Type;
7536: , p_effectivity_date IN DATE := NULL
7537: , p_item_revision IN VARCHAR2 := NULL
7538: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7539: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7540: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7537: , p_item_revision IN VARCHAR2 := NULL
7538: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7539: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7540: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7545: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7538: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7539: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7540: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7545: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7546: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7539: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7540: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7545: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7546: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7547: , x_return_status OUT NOCOPY VARCHAR2
7540: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7545: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7546: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7547: , x_return_status OUT NOCOPY VARCHAR2
7548: -- Bug 2941096 // kamohan
7541: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7542: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7543: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7544: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7545: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7546: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7547: , x_return_status OUT NOCOPY VARCHAR2
7548: -- Bug 2941096 // kamohan
7549: , x_bill_sequence_id IN NUMBER := NULL
7559: l_bo_return_status VARCHAR2(1);
7560: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
7561: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7562: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7563: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7560: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
7561: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7562: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7563: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7561: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7562: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7563: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7569: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7562: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7563: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7569: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7570: l_return_value NUMBER;
7563: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7569: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7570: l_return_value NUMBER;
7571: l_process_children BOOLEAN := TRUE;
7564: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7569: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7570: l_return_value NUMBER;
7571: l_process_children BOOLEAN := TRUE;
7572: l_dummy NUMBER ;
7565: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7566: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7567: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7568: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7569: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7570: l_return_value NUMBER;
7571: l_process_children BOOLEAN := TRUE;
7572: l_dummy NUMBER ;
7573: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8885: , p_change_notice IN VARCHAR2 := NULL
8886: , p_organization_id IN NUMBER := NULL
8887: , I IN NUMBER
8888: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8889: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8886: , p_organization_id IN NUMBER := NULL
8887: , I IN NUMBER
8888: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8889: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8887: , I IN NUMBER
8888: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8889: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8902: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8922: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8923: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8924: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8925: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8926: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8923: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8924: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8925: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8926: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8924: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8925: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8926: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8932: l_return_value NUMBER;
10312: ( p_validation_level IN NUMBER
10313: , p_change_notice IN VARCHAR2 := NULL
10314: , p_organization_id IN NUMBER := NULL
10315: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10316: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10313: , p_change_notice IN VARCHAR2 := NULL
10314: , p_organization_id IN NUMBER := NULL
10315: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10316: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10314: , p_organization_id IN NUMBER := NULL
10315: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10316: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10329: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10348: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10349: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10350: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10351: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10352: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10349: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10350: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10351: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10352: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10350: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10351: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10352: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10358: l_return_value NUMBER;
11888: , p_change_notice IN VARCHAR2 := NULL
11889: , p_organization_id IN NUMBER := NULL
11890: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11891: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11892: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11889: , p_organization_id IN NUMBER := NULL
11890: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11891: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11892: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11890: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11891: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11892: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11906: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13091: , p_organization_id IN NUMBER := NULL
13092: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
13093: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13094: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13095: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13092: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
13093: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13094: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13095: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13093: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13094: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13095: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13127: l_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type;
13128: l_old_eco_rev_rec ENG_Eco_PUB.Eco_Revision_Rec_Type := NULL;
13129: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13130: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13131: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13128: l_old_eco_rev_rec ENG_Eco_PUB.Eco_Revision_Rec_Type := NULL;
13129: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13130: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13131: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13129: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13130: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13131: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13137: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14164: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
14165: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
14166: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14167: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14168: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14165: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
14166: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14167: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14168: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14166: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14167: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14168: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14174: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14174: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14175: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14176: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14177: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14178: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14175: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14176: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14177: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14178: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14176: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14177: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14178: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14199: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
14200: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
14201: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14202: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14203: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14204: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14205: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14206:
14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14200: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
14201: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14202: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14203: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14204: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14205: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14206:
14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14208: := p_rev_operation_tbl; --L1
14201: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14202: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14203: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14204: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14205: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14206:
14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14208: := p_rev_operation_tbl; --L1
14209: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
15657: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15658: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15659: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15660: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15661: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15658: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15659: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15660: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15661: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15659: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15660: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15661: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15660: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15661: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15661: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15662: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15673: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15674: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15675: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15676: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15677: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15674: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15675: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15676: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15677: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15675: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15676: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15677: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15683: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15700: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
15701: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
15702: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15703: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15704: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15701: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
15702: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15703: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15704: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15702: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15703: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15704: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15703: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15704: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15704: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15705: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
16457: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
16458: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
16459: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16460: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16461: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16458: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
16459: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16460: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16461: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16459: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16460: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16461: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16460: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16461: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16461: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16469: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16462: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16463: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16464: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16465: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16469: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16470: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16466: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16469: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16470: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16471: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16472: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16473: , x_err_text OUT NOCOPY VARCHAR2
16474: )
16467: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16469: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16470: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16471: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16472: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16473: , x_err_text OUT NOCOPY VARCHAR2
16474: )
16475: IS
16468: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16469: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16470: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16471: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16472: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16473: , x_err_text OUT NOCOPY VARCHAR2
16474: )
16475: IS
16476: l_api_version_number CONSTANT NUMBER := 1.0;
16477: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
16478: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16479: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16480: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16481: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16482: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16483: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16484: BEGIN
16485:
16478: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16479: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16480: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16481: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16482: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16483: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16484: BEGIN
16485:
16486: -- Standard call to check for call compatibility
16479: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16480: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16481: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16482: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16483: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16484: BEGIN
16485:
16486: -- Standard call to check for call compatibility
16487: