[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:
71:
72: IS
73:
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;
72: IS
73:
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;
73:
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;
1446:
1447:
1448:
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;
1447:
1448:
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;
1448:
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;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:
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;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:
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;
2805:
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;
4440: l_item_parent_exists BOOLEAN := FALSE;
4441: l_comp_parent_exists BOOLEAN := FALSE;
4442: l_Return_Status VARCHAR2(1);
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;
4441: l_comp_parent_exists BOOLEAN := FALSE;
4442: l_Return_Status VARCHAR2(1);
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;
4442: l_Return_Status VARCHAR2(1);
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;
5349: l_item_parent_exists BOOLEAN := FALSE;
5350: l_comp_parent_exists BOOLEAN := FALSE;
5351: l_Return_Status VARCHAR2(1);
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;
5350: l_comp_parent_exists BOOLEAN := FALSE;
5351: l_Return_Status VARCHAR2(1);
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;
5351: l_Return_Status VARCHAR2(1);
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;
6173: l_valid BOOLEAN := TRUE;
6174: l_item_parent_exists BOOLEAN := FALSE;
6175: l_Return_Status VARCHAR2(1);
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;
6174: l_item_parent_exists BOOLEAN := FALSE;
6175: l_Return_Status VARCHAR2(1);
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;
6175: l_Return_Status VARCHAR2(1);
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;
7512: l_valid BOOLEAN := TRUE;
7513: l_item_parent_exists BOOLEAN := FALSE;
7514: l_Return_Status VARCHAR2(1);
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;
7513: l_item_parent_exists BOOLEAN := FALSE;
7514: l_Return_Status VARCHAR2(1);
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;
7514: l_Return_Status VARCHAR2(1);
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;
8839: ( p_validation_level IN NUMBER
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
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
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
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
8858: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8859: , x_return_status OUT NOCOPY VARCHAR2
8860: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
8861: )
8867: l_valid BOOLEAN := TRUE;
8868: l_eco_parent_exists BOOLEAN := FALSE;
8869: l_Return_Status VARCHAR2(1);
8870: l_bo_return_status VARCHAR2(1);
8871: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8868: l_eco_parent_exists BOOLEAN := FALSE;
8869: l_Return_Status VARCHAR2(1);
8870: l_bo_return_status VARCHAR2(1);
8871: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
8869: l_Return_Status VARCHAR2(1);
8870: l_bo_return_status VARCHAR2(1);
8871: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
8877: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8870: l_bo_return_status VARCHAR2(1);
8871: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8871: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8872: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8873: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8874: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8875: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
8876: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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
10263: PROCEDURE Rev_Items
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
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
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
10290: l_valid BOOLEAN := TRUE;
10291: l_eco_parent_exists BOOLEAN := FALSE;
10292: l_Return_Status VARCHAR2(1);
10293: l_bo_return_status VARCHAR2(1);
10294: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10291: l_eco_parent_exists BOOLEAN := FALSE;
10292: l_Return_Status VARCHAR2(1);
10293: l_bo_return_status VARCHAR2(1);
10294: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
10292: l_Return_Status VARCHAR2(1);
10293: l_bo_return_status VARCHAR2(1);
10294: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
10300: l_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10293: l_bo_return_status VARCHAR2(1);
10294: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10294: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10295: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10296: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10297: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10298: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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;
10299: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
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
11812: PROCEDURE Change_Line
11813: ( p_validation_level IN 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
11813: ( p_validation_level IN 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
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
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
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
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--
11834: )
11835: IS
11836:
11837: /* Exposed and Unexposed record */
11838: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11839: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11835: IS
11836:
11837: /* Exposed and Unexposed record */
11838: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11839: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11843: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11837: /* Exposed and Unexposed record */
11838: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11839: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11843: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11844: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11845:
11838: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11839: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11843: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11844: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11845:
11846: /* Error Handling Variables */
11839: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11843: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11844: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11845:
11846: /* Error Handling Variables */
11847: l_token_tbl Error_Handler.Token_Tbl_Type ;
11840:
11841: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11842: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11843: l_old_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
11844: l_old_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
11845:
11846: /* Error Handling Variables */
11847: l_token_tbl Error_Handler.Token_Tbl_Type ;
11848: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
11850: l_other_message VARCHAR2(2000);
11851: l_err_text VARCHAR2(2000);
11852:
11853: /* Others */
11854: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11855: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
11856:
11857: l_return_status VARCHAR2(1);
11858: l_bo_return_status VARCHAR2(1);
11851: l_err_text VARCHAR2(2000);
11852:
11853: /* Others */
11854: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
11855: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
11856:
11857: l_return_status VARCHAR2(1);
11858: l_bo_return_status VARCHAR2(1);
11859: l_eco_parent_exists BOOLEAN := FALSE;
11870: EXC_FAT_QUIT_BRANCH EXCEPTION ;
11871: EXC_SEV_QUIT_OBJECT EXCEPTION;
11872:
11873: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
11874: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
11875:
11876: BEGIN
11877:
11878:
13014: PROCEDURE Eco_Rev
13015: ( p_validation_level IN NUMBER
13016: , p_change_notice IN VARCHAR2 := NULL
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
13015: ( p_validation_level IN NUMBER
13016: , p_change_notice IN VARCHAR2 := NULL
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
13016: , p_change_notice IN VARCHAR2 := NULL
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
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
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
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
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
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
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
13044: l_valid BOOLEAN := TRUE;
13045: l_Return_Status VARCHAR2(1);
13046: l_bo_return_status VARCHAR2(1);
13047: l_eco_parent_exists BOOLEAN := FALSE;
13048: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
13045: l_Return_Status VARCHAR2(1);
13046: l_bo_return_status VARCHAR2(1);
13047: l_eco_parent_exists BOOLEAN := FALSE;
13048: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
13053: l_eco_rev_unexp_rec ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type;
13046: l_bo_return_status VARCHAR2(1);
13047: l_eco_parent_exists BOOLEAN := FALSE;
13048: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13047: l_eco_parent_exists BOOLEAN := FALSE;
13048: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13048: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13049: l_old_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13050: l_old_eco_unexp_rec ENG_Eco_PUB.Eco_Unexposed_Rec_Type;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13051: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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;
13052: --l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
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
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
13064:
13065:
13066: l_return_value NUMBER;
13067: l_Token_Tbl Error_Handler.Token_Tbl_Type;
13901: AND o.obj_name = v_assignee_type;
13902:
13903: v_assignee_id NUMBER;
13904: v_assignee_type VARCHAR2(80);
13905: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type;
13906: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
13907: l_dest_change_id NUMBER;
13908: l_msg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
13909: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13902:
13903: v_assignee_id NUMBER;
13904: v_assignee_type VARCHAR2(80);
13905: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type;
13906: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
13907: l_dest_change_id NUMBER;
13908: l_msg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
13909: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13910: l_sql_stmt VARCHAR2(1000);
14086:
14087:
14088: PROCEDURE Eco_Header
14089: ( p_validation_level IN NUMBER
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
14087:
14088: PROCEDURE Eco_Header
14089: ( p_validation_level IN NUMBER
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
14088: PROCEDURE Eco_Header
14089: ( p_validation_level IN NUMBER
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
14089: ( p_validation_level IN NUMBER
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
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
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
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
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
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
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
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
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--
14119: l_err_text VARCHAR2(2000);
14120: l_valid BOOLEAN := TRUE;
14121: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14122: l_bo_return_status VARCHAR2(1) := 'S';
14123: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14120: l_valid BOOLEAN := TRUE;
14121: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14122: l_bo_return_status VARCHAR2(1) := 'S';
14123: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14121: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14122: l_bo_return_status VARCHAR2(1) := 'S';
14123: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14122: l_bo_return_status VARCHAR2(1) := 'S';
14123: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14123: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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;
14124: l_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_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:
14136: :=p_rev_op_resource_tbl; --L1
14137: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14138: :=p_rev_sub_resource_tbl;--L1
14139:
14140: l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14141: l_status_check_required BOOLEAN := TRUE; -- Added for enhancement 541
14142: -- Bug 2916558 // kamohan
14143: -- Start Changes
14144:
14170: l_prog_id NUMBER;
14171: l_request_id NUMBER;
14172: l_profile_exist BOOLEAN;
14173: l_package_name varchar2(100) :='EGO_CHANGETYPE_EXPLOSION.explodeTemplates';
14174: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
14175:
14176: -- Changes for bug 3426896
14177: l_pls_msg_count NUMBER;
14178: l_pls_msg_data VARCHAR2(3000);
15572: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
15573: ENG_GLOBALS.G_MISS_CONTROL_REC
15574: , x_return_status OUT NOCOPY VARCHAR2
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
15580: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15573: ENG_GLOBALS.G_MISS_CONTROL_REC
15574: , x_return_status OUT NOCOPY VARCHAR2
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
15580: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
15581: ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
15574: , x_return_status OUT NOCOPY VARCHAR2
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
15578: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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 :=
15579: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
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
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
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_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
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_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--
15616: l_bo_return_status VARCHAR2(1);
15617:
15618: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15619:
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15617:
15618: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15619:
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15618: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15619:
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15619:
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
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;
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--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15638: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15639:
15640: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
15641: l_other_message VARCHAR2(2000);
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15638: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15639:
15640: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
15641: l_other_message VARCHAR2(2000);
15642: l_other_token_tbl Error_Handler.Token_Tbl_Type;
16363: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
16364: , x_return_status OUT NOCOPY VARCHAR2
16365: , x_msg_count OUT NOCOPY NUMBER
16366: , x_msg_data OUT NOCOPY VARCHAR2
16367: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16364: , x_return_status OUT NOCOPY VARCHAR2
16365: , x_msg_count OUT NOCOPY NUMBER
16366: , x_msg_data OUT NOCOPY VARCHAR2
16367: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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
16365: , x_msg_count OUT NOCOPY NUMBER
16366: , x_msg_data OUT NOCOPY VARCHAR2
16367: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16366: , x_msg_data OUT NOCOPY VARCHAR2
16367: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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
16367: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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 :=
16368: ENG_Eco_PUB.G_MISS_ECO_REC
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
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
16383: , x_ref_designator_tbl IN OUT NOCOPY 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
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
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
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
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;
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