1760: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1761: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
1762: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
1763: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
1764: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1765: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
1766: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1767:
1768: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
1761: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
1762: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
1763: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
1764: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1765: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
1766: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1767:
1768: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
1769: l_org_hierarchy_level_id NUMBER;
1762: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
1763: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
1764: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1765: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
1766: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1767:
1768: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
1769: l_org_hierarchy_level_id NUMBER;
1770: l_org_code VARCHAR2(3);
4211: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4212: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4213: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4214: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4215: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4216: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4217: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4218:
4219: --
4212: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4213: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4214: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4215: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4216: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4217: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4218:
4219: --
4220: -- Cursor to Pick all ECO header for the Top Organization for the given
4213: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4214: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4215: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4216: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4217: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4218:
4219: --
4220: -- Cursor to Pick all ECO header for the Top Organization for the given
4221: -- Change Notice
4912: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4913: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4914: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4915: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4916: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4917: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4918: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4919: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
4920:
4913: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4914: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4915: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4916: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4917: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4918: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4919: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
4920:
4921: CURSOR c_revised_items_data IS
4914: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4915: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4916: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4917: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4918: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4919: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
4920:
4921: CURSOR c_revised_items_data IS
4922: SELECT use_up_item_id