[Home] [Help]
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PVT';
7: G_EXC_QUIT_IMPORT EXCEPTION;
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;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PVT';
7: G_EXC_QUIT_IMPORT EXCEPTION;
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;
7: G_EXC_QUIT_IMPORT EXCEPTION;
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:
72:
73: IS
74:
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;
73: IS
74:
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;
74:
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;
1453:
1454:
1455:
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;
1454:
1455:
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;
1455:
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;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:
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;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:
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;
2818:
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;
4483: l_item_parent_exists BOOLEAN := FALSE;
4484: l_comp_parent_exists BOOLEAN := FALSE;
4485: l_Return_Status VARCHAR2(1);
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;
4484: l_comp_parent_exists BOOLEAN := FALSE;
4485: l_Return_Status VARCHAR2(1);
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;
4485: l_Return_Status VARCHAR2(1);
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;
5392: l_item_parent_exists BOOLEAN := FALSE;
5393: l_comp_parent_exists BOOLEAN := FALSE;
5394: l_Return_Status VARCHAR2(1);
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;
5393: l_comp_parent_exists BOOLEAN := FALSE;
5394: l_Return_Status VARCHAR2(1);
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;
5394: l_Return_Status VARCHAR2(1);
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;
6216: l_valid BOOLEAN := TRUE;
6217: l_item_parent_exists BOOLEAN := FALSE;
6218: l_Return_Status VARCHAR2(1);
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;
6217: l_item_parent_exists BOOLEAN := FALSE;
6218: l_Return_Status VARCHAR2(1);
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;
6218: l_Return_Status VARCHAR2(1);
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;
7556: l_valid BOOLEAN := TRUE;
7557: l_item_parent_exists BOOLEAN := FALSE;
7558: l_Return_Status VARCHAR2(1);
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;
7557: l_item_parent_exists BOOLEAN := FALSE;
7558: l_Return_Status VARCHAR2(1);
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;
7558: l_Return_Status VARCHAR2(1);
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;
8884: ( p_validation_level IN NUMBER
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
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
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
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
8903: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8904: , x_return_status OUT NOCOPY VARCHAR2
8905: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
8906: )
8912: l_valid BOOLEAN := TRUE;
8913: l_eco_parent_exists BOOLEAN := FALSE;
8914: l_Return_Status VARCHAR2(1);
8915: l_bo_return_status VARCHAR2(1);
8916: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8913: l_eco_parent_exists BOOLEAN := FALSE;
8914: l_Return_Status VARCHAR2(1);
8915: l_bo_return_status VARCHAR2(1);
8916: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
8914: l_Return_Status VARCHAR2(1);
8915: l_bo_return_status VARCHAR2(1);
8916: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
8922: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8915: l_bo_return_status VARCHAR2(1);
8916: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8916: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8917: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8918: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8919: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8920: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8921: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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
10311: PROCEDURE Rev_Items
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
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
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
10338: l_valid BOOLEAN := TRUE;
10339: l_eco_parent_exists BOOLEAN := FALSE;
10340: l_Return_Status VARCHAR2(1);
10341: l_bo_return_status VARCHAR2(1);
10342: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10339: l_eco_parent_exists BOOLEAN := FALSE;
10340: l_Return_Status VARCHAR2(1);
10341: l_bo_return_status VARCHAR2(1);
10342: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
10340: l_Return_Status VARCHAR2(1);
10341: l_bo_return_status VARCHAR2(1);
10342: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
10348: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10341: l_bo_return_status VARCHAR2(1);
10342: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10342: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10343: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10344: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10345: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10346: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10347: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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
11886: PROCEDURE Change_Line
11887: ( p_validation_level IN 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
11887: ( p_validation_level IN 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
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
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
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
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--
11908: )
11909: IS
11910:
11911: /* Exposed and Unexposed record */
11912: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11913: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11909: IS
11910:
11911: /* Exposed and Unexposed record */
11912: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11913: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11917: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11911: /* Exposed and Unexposed record */
11912: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11913: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11917: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11918: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11919:
11912: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11913: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11917: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11918: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11919:
11920: /* Error Handling Variables */
11913: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11917: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11918: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11919:
11920: /* Error Handling Variables */
11921: l_token_tbl Error_Handler.Token_Tbl_Type ;
11914:
11915: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11916: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11917: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11918: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11919:
11920: /* Error Handling Variables */
11921: l_token_tbl Error_Handler.Token_Tbl_Type ;
11922: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
11924: l_other_message VARCHAR2(2000);
11925: l_err_text VARCHAR2(2000);
11926:
11927: /* Others */
11928: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11929: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
11930:
11931: l_return_status VARCHAR2(1);
11932: l_bo_return_status VARCHAR2(1);
11925: l_err_text VARCHAR2(2000);
11926:
11927: /* Others */
11928: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11929: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
11930:
11931: l_return_status VARCHAR2(1);
11932: l_bo_return_status VARCHAR2(1);
11933: l_eco_parent_exists BOOLEAN := FALSE;
11944: EXC_FAT_QUIT_BRANCH EXCEPTION ;
11945: EXC_SEV_QUIT_OBJECT EXCEPTION;
11946:
11947: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
11948: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
11949:
11950: BEGIN
11951:
11952:
13088: PROCEDURE Eco_Rev
13089: ( p_validation_level IN NUMBER
13090: , p_change_notice IN VARCHAR2 := NULL
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
13089: ( p_validation_level IN NUMBER
13090: , p_change_notice IN VARCHAR2 := NULL
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
13090: , p_change_notice IN VARCHAR2 := NULL
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
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
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
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
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
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
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
13118: l_valid BOOLEAN := TRUE;
13119: l_Return_Status VARCHAR2(1);
13120: l_bo_return_status VARCHAR2(1);
13121: l_eco_parent_exists BOOLEAN := FALSE;
13122: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
13119: l_Return_Status VARCHAR2(1);
13120: l_bo_return_status VARCHAR2(1);
13121: l_eco_parent_exists BOOLEAN := FALSE;
13122: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
13127: l_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type;
13120: l_bo_return_status VARCHAR2(1);
13121: l_eco_parent_exists BOOLEAN := FALSE;
13122: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13121: l_eco_parent_exists BOOLEAN := FALSE;
13122: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13122: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13123: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13124: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13125: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13126: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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
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
13138:
13139:
13140: l_return_value NUMBER;
13141: l_Token_Tbl Error_Handler.Token_Tbl_Type;
13975: AND o.obj_name = v_assignee_type;
13976:
13977: v_assignee_id NUMBER;
13978: v_assignee_type VARCHAR2(80);
13979: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type;
13980: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
13981: l_dest_change_id NUMBER;
13982: l_msg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
13983: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13976:
13977: v_assignee_id NUMBER;
13978: v_assignee_type VARCHAR2(80);
13979: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type;
13980: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
13981: l_dest_change_id NUMBER;
13982: l_msg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
13983: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13984: l_sql_stmt VARCHAR2(1000);
14160:
14161:
14162: PROCEDURE Eco_Header
14163: ( p_validation_level IN NUMBER
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
14161:
14162: PROCEDURE Eco_Header
14163: ( p_validation_level IN NUMBER
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
14162: PROCEDURE Eco_Header
14163: ( p_validation_level IN NUMBER
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
14163: ( p_validation_level IN NUMBER
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
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
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
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
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
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
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
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
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--
14193: l_err_text VARCHAR2(2000);
14194: l_valid BOOLEAN := TRUE;
14195: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14196: l_bo_return_status VARCHAR2(1) := 'S';
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14194: l_valid BOOLEAN := TRUE;
14195: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14196: l_bo_return_status VARCHAR2(1) := 'S';
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14195: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14196: l_bo_return_status VARCHAR2(1) := 'S';
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14196: l_bo_return_status VARCHAR2(1) := 'S';
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14197: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14198: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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:
14210: :=p_rev_op_resource_tbl; --L1
14211: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14212: :=p_rev_sub_resource_tbl;--L1
14213:
14214: l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14215: l_status_check_required BOOLEAN := TRUE; -- Added for enhancement 541
14216: -- Bug 2916558 // kamohan
14217: -- Start Changes
14218:
14244: l_prog_id NUMBER;
14245: l_request_id NUMBER;
14246: l_profile_exist BOOLEAN;
14247: l_package_name varchar2(100) :='EGO_CHANGETYPE_EXPLOSION.explodeTemplates';
14248: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
14249:
14250: -- Changes for bug 3426896
14251: l_pls_msg_count NUMBER;
14252: l_pls_msg_data VARCHAR2(3000);
15649: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
15650: ENG_GLOBALS.G_MISS_CONTROL_REC
15651: , x_return_status OUT NOCOPY VARCHAR2
15652: , x_msg_count OUT NOCOPY NUMBER
15653: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
15657: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15650: ENG_GLOBALS.G_MISS_CONTROL_REC
15651: , x_return_status OUT NOCOPY VARCHAR2
15652: , x_msg_count OUT NOCOPY NUMBER
15653: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
15657: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15658: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15651: , x_return_status OUT NOCOPY VARCHAR2
15652: , x_msg_count OUT NOCOPY NUMBER
15653: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15652: , x_msg_count OUT NOCOPY NUMBER
15653: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
15653: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15654: ENG_Eco_PUB.G_MISS_ECO_REC
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
15655: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15656: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
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
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_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--
15695: l_organization_id NUMBER;
15696:
15697: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15698:
15699: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15696:
15697: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15698:
15699: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15697: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15698:
15699: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15698:
15699: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15699: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
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--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15717: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15718:
15719: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
15720: l_other_message VARCHAR2(2000);
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15717: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15718:
15719: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
15720: l_other_message VARCHAR2(2000);
15721: l_other_token_tbl Error_Handler.Token_Tbl_Type;
16451: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
16452: , x_return_status OUT NOCOPY VARCHAR2
16453: , x_msg_count OUT NOCOPY NUMBER
16454: , x_msg_data OUT NOCOPY VARCHAR2
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16452: , x_return_status OUT NOCOPY VARCHAR2
16453: , x_msg_count OUT NOCOPY NUMBER
16454: , x_msg_data OUT NOCOPY VARCHAR2
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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
16453: , x_msg_count OUT NOCOPY NUMBER
16454: , x_msg_data OUT NOCOPY VARCHAR2
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16454: , x_msg_data OUT NOCOPY VARCHAR2
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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
16455: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16456: ENG_Eco_PUB.G_MISS_ECO_REC
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
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
16471: , x_ref_designator_tbl IN OUT NOCOPY 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
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
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
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
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;
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