[Home] [Help]
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
74: /* Exposed and Unexposed record */
75: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
76: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
77: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
78: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
75: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
76: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
77: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
78: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
76: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
77: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
78: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
84: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
77: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
78: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
84: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
85: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
78: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
84: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
85: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
86: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
79: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
84: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
85: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
86: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
87: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
80: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
81: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
82: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
83: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
84: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
85: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
86: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
87: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
88: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
1449: /* Other Entities */
1450: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
1451: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1452: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1453: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1450: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
1451: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1452: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1453: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1451: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
1452: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1453: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1452: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1453: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1453: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1454: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1462: -- := p_rev_sub_resource_tbl ;
1455: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1462: -- := p_rev_sub_resource_tbl ;
1463:
2806: /* Other Entities */
2807: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2808: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2809: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2810: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2807: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2808: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2809: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2810: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2808: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
2809: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2810: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2809: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2810: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2810: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2818: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2811: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2818: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2819:
2812: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2818: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2819:
2820: /* Others */
4425: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4426: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4427: , p_component_item_name IN VARCHAR2 := NULL
4428: , p_operation_seq_num IN NUMBER := NULL
4429: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
4430: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4431: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4432: , x_return_status OUT NOCOPY VARCHAR2
4433: )
4426: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
4427: , p_component_item_name IN VARCHAR2 := NULL
4428: , p_operation_seq_num IN NUMBER := NULL
4429: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
4430: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4431: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4432: , x_return_status OUT NOCOPY VARCHAR2
4433: )
4434: IS
4443: l_bo_return_status VARCHAR2(1);
4444: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
4445: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4446: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4447: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4444: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
4445: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4446: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4447: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4445: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
4446: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4447: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4446: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
4447: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4454: l_return_value NUMBER;
4447: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4454: l_return_value NUMBER;
4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4448: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4454: l_return_value NUMBER;
4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4456:
4449: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4450: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
4451: l_old_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4452: l_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4454: l_return_value NUMBER;
4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4456:
4457: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5332: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5333: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5334: , p_component_item_name IN VARCHAR2 := NULL
5335: , p_operation_seq_num IN NUMBER := NULL
5336: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5337: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5338: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5339: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5333: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
5334: , p_component_item_name IN VARCHAR2 := NULL
5335: , p_operation_seq_num IN NUMBER := NULL
5336: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5337: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5338: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5339: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , x_return_status OUT NOCOPY VARCHAR2
5334: , p_component_item_name IN VARCHAR2 := NULL
5335: , p_operation_seq_num IN NUMBER := NULL
5336: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5337: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5338: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5339: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , x_return_status OUT NOCOPY VARCHAR2
5342: )
5335: , p_operation_seq_num IN NUMBER := NULL
5336: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
5337: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
5338: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
5339: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , x_return_status OUT NOCOPY VARCHAR2
5342: )
5343: IS
5352: l_bo_return_status VARCHAR2(1);
5353: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
5354: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5355: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5356: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5353: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
5354: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5355: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5356: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5354: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
5355: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5356: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5355: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
5356: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5363: l_return_value NUMBER;
5356: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5363: l_return_value NUMBER;
5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5357: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5363: l_return_value NUMBER;
5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5365:
5358: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
5359: l_old_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
5360: l_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5361: l_old_ref_desg_unexp_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5363: l_return_value NUMBER;
5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5365:
5366: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6152: , p_item_revision IN VARCHAR2 := NULL
6153: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6154: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6155: , I IN NUMBER
6156: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6153: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6154: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6155: , I IN NUMBER
6156: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6154: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
6155: , I IN NUMBER
6156: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6162: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6155: , I IN NUMBER
6156: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6162: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6156: , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6162: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6164: , x_return_status OUT NOCOPY VARCHAR2
6157: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6162: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6164: , x_return_status OUT NOCOPY VARCHAR2
6165: -- Bug 2941096 // kamohan
6158: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
6159: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
6160: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
6161: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
6162: , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
6163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6164: , x_return_status OUT NOCOPY VARCHAR2
6165: -- Bug 2941096 // kamohan
6166: , x_bill_sequence_id IN NUMBER := NULL
6176: l_bo_return_status VARCHAR2(1);
6177: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
6178: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6179: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6180: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6177: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
6178: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6179: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6180: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6178: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
6179: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6180: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6186: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6179: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
6180: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6186: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6187: l_return_value NUMBER;
6180: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6186: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6187: l_return_value NUMBER;
6188: l_process_children BOOLEAN := TRUE;
6181: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6186: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6187: l_return_value NUMBER;
6188: l_process_children BOOLEAN := TRUE;
6189: l_dummy NUMBER ;
6182: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6183: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
6184: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
6185: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
6186: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
6187: l_return_value NUMBER;
6188: l_process_children BOOLEAN := TRUE;
6189: l_dummy NUMBER ;
6190: l_Token_Tbl Error_Handler.Token_Tbl_Type;
7492: , p_effectivity_date IN DATE := NULL
7493: , p_item_revision IN VARCHAR2 := NULL
7494: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7495: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7493: , p_item_revision IN VARCHAR2 := NULL
7494: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7495: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7501: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7494: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7495: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7501: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7502: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7495: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
7496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7501: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7502: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7503: , x_return_status OUT NOCOPY VARCHAR2
7496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7501: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7502: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7503: , x_return_status OUT NOCOPY VARCHAR2
7504: -- Bug 2941096 // kamohan
7497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
7498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
7499: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
7500: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
7501: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
7502: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
7503: , x_return_status OUT NOCOPY VARCHAR2
7504: -- Bug 2941096 // kamohan
7505: , x_bill_sequence_id IN NUMBER := NULL
7515: l_bo_return_status VARCHAR2(1);
7516: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
7517: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7518: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7519: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7516: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
7517: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7518: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7519: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7517: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
7518: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7519: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7525: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7518: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
7519: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7525: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7526: l_return_value NUMBER;
7519: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7525: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7526: l_return_value NUMBER;
7527: l_process_children BOOLEAN := TRUE;
7520: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7525: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7526: l_return_value NUMBER;
7527: l_process_children BOOLEAN := TRUE;
7528: l_dummy NUMBER ;
7521: l_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7522: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
7523: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
7524: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
7525: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
7526: l_return_value NUMBER;
7527: l_process_children BOOLEAN := TRUE;
7528: l_dummy NUMBER ;
7529: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8840: , p_change_notice IN VARCHAR2 := NULL
8841: , p_organization_id IN NUMBER := NULL
8842: , I IN NUMBER
8843: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8844: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8841: , p_organization_id IN NUMBER := NULL
8842: , I IN NUMBER
8843: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8844: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8842: , I IN NUMBER
8843: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8844: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8856: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8856: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8857: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8877: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8878: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8879: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8880: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8881: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8878: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8879: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8880: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8881: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8886: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8879: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8880: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8881: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8886: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8887: l_return_value NUMBER;
10264: ( p_validation_level IN NUMBER
10265: , p_change_notice IN VARCHAR2 := NULL
10266: , p_organization_id IN NUMBER := NULL
10267: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10268: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10265: , p_change_notice IN VARCHAR2 := NULL
10266: , p_organization_id IN NUMBER := NULL
10267: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10268: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10266: , p_organization_id IN NUMBER := NULL
10267: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10268: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10280: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10280: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10281: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10300: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10301: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10302: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10303: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10304: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10301: l_rev_item_miss_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10302: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10303: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10304: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10309: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10302: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10303: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10304: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10309: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10310: l_return_value NUMBER;
11814: , p_change_notice IN VARCHAR2 := NULL
11815: , p_organization_id IN NUMBER := NULL
11816: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11817: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11818: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11815: , p_organization_id IN NUMBER := NULL
11816: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11817: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11818: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11816: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11817: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11818: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11831: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11831: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11832: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13017: , p_organization_id IN NUMBER := NULL
13018: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
13019: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13020: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13021: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13018: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
13019: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13020: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13021: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13019: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13020: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13021: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13035: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13035: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13053: l_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type;
13054: l_old_eco_rev_rec ENG_Eco_PUB.Eco_Revision_Rec_Type := NULL;
13055: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13056: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13057: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13054: l_old_eco_rev_rec ENG_Eco_PUB.Eco_Revision_Rec_Type := NULL;
13055: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13056: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13057: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13062: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13055: l_old_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL;
13056: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13057: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13062: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13063: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14090: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
14091: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
14092: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14093: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14094: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14091: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
14092: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14093: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14094: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14099: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14092: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14093: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14094: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14099: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14100: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14100: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14125: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
14126: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
14127: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14128: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14129: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14130: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14131: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14132:
14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14126: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
14127: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14128: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14129: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14130: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14131: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14132:
14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14134: := p_rev_operation_tbl; --L1
14127: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
14128: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
14129: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14130: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14131: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14132:
14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14134: := p_rev_operation_tbl; --L1
14135: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
15580: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15581: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15582: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15583: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15584: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15581: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15582: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15583: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15584: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15582: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
15583: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15584: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15583: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
15584: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15584: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15585: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15596: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15597: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15598: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15599: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15600: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15597: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15598: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15599: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15600: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15605: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15598: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15599: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15600: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15605: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15606: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15621: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
15622: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
15623: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15624: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15625: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15622: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
15623: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15624: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15625: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15623: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
15624: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15625: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15624: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
15625: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15625: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15626: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
16369: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
16370: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
16371: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16372: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16373: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16370: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
16371: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16372: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16373: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16371: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
16372: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16373: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16372: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
16373: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16373: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16381: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16374: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
16375: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
16376: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
16377: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16381: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16382: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16378: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16381: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16382: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16383: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16384: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16385: , x_err_text OUT NOCOPY VARCHAR2
16386: )
16379: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16381: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16382: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16383: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16384: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16385: , x_err_text OUT NOCOPY VARCHAR2
16386: )
16387: IS
16380: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
16381: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
16382: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
16383: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
16384: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
16385: , x_err_text OUT NOCOPY VARCHAR2
16386: )
16387: IS
16388: l_api_version_number CONSTANT NUMBER := 1.0;
16389: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
16390: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16391: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16392: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16393: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16394: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16395: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16396: BEGIN
16397:
16390: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16391: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16392: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16393: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16394: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16395: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16396: BEGIN
16397:
16398: -- Standard call to check for call compatibility
16391: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
16392: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
16393: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
16394: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
16395: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
16396: BEGIN
16397:
16398: -- Standard call to check for call compatibility
16399: