eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENGECOBO dependencies on ENG_ECO_PUB

Line 260: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

256:
257: PROCEDURE Propagate_Attach_Lines (
258: p_change_id IN NUMBER
259: , p_revised_item_sequence_id IN NUMBER
260: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
261: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
262: , p_local_organization_id IN NUMBER
263: , p_local_line_rev_id IN NUMBER
264: , x_return_status OUT NOCOPY VARCHAR2

Line 261: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

257: PROCEDURE Propagate_Attach_Lines (
258: p_change_id IN NUMBER
259: , p_revised_item_sequence_id IN NUMBER
260: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
261: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
262: , p_local_organization_id IN NUMBER
263: , p_local_line_rev_id IN NUMBER
264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 772: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

768: , p_global_new_item_rev IN VARCHAR2
769: , p_global_current_item_rev_id IN NUMBER
770: , p_local_organization_id IN NUMBER
771: , p_local_line_rev_id IN NUMBER
772: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
773: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
774: , x_return_status OUT NOCOPY VARCHAR2
775: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
776: ) IS

Line 773: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

769: , p_global_current_item_rev_id IN NUMBER
770: , p_local_organization_id IN NUMBER
771: , p_local_line_rev_id IN NUMBER
772: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
773: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
774: , x_return_status OUT NOCOPY VARCHAR2
775: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
776: ) IS
777:

Line 1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL

Line 1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL

Line 1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change

1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL

Line 1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

Line 1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL

1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

Line 1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL

1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

Line 1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL

1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
1045: );

Line 1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
1045: );
1046: -- local change id is set later

Line 1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

1039: , x_rev_component_tbl => ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
1045: );
1046: -- local change id is set later
1047: -- if there are errors, based on the level they are not populated in the

Line 1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

1040: , x_ref_designator_tbl => ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
1041: , x_sub_component_tbl => ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
1042: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
1043: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
1044: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
1045: );
1046: -- local change id is set later
1047: -- if there are errors, based on the level they are not populated in the
1048: -- maps table.

Line 1739: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

1735: p_org_hierarchy_name IN VARCHAR2,
1736: p_org_hierarchy_level IN VARCHAR2
1737: )
1738: IS
1739: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1740: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1741: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
1742: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1743: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 1740: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

1736: p_org_hierarchy_level IN VARCHAR2
1737: )
1738: IS
1739: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1740: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1741: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
1742: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1743: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
1744: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;

Line 1741: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

1737: )
1738: IS
1739: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1740: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1741: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
1742: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1743: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
1744: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
1745: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;

Line 1742: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

1738: IS
1739: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1740: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1741: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
1742: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1743: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
1744: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
1745: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
1746: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

Line 3151: Eng_Eco_Pub.Process_Eco

3147: Error_Handler.Initialize;
3148:
3149: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3150: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3151: Eng_Eco_Pub.Process_Eco
3152: (
3153: p_api_version_number => 1.0
3154: ,p_init_msg_list => FALSE
3155: ,x_return_status => l_return_status

Line 3317: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

3313: PROCEDURE Propagate_Revised_Component (
3314: p_component_sequence_id IN NUMBER
3315: , p_revised_item_sequence_id IN NUMBER
3316: , p_change_id IN NUMBER
3317: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3318: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3319: , p_local_organization_id IN NUMBER
3320: , x_Return_Status OUT NOCOPY VARCHAR2
3321: ) IS

Line 3318: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3314: p_component_sequence_id IN NUMBER
3315: , p_revised_item_sequence_id IN NUMBER
3316: , p_change_id IN NUMBER
3317: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3318: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3319: , p_local_organization_id IN NUMBER
3320: , x_Return_Status OUT NOCOPY VARCHAR2
3321: ) IS
3322:

Line 3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

3827: p_error_status => l_return_status
3828: , p_mesg_token_tbl => l_mesg_token_tbl
3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3835: , x_rev_component_tbl => l_rev_component_tbl

Line 3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

3828: , p_mesg_token_tbl => l_mesg_token_tbl
3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3835: , x_rev_component_tbl => l_rev_component_tbl
3836: , x_ref_designator_tbl => l_ref_designator_tbl

Line 3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change

3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3835: , x_rev_component_tbl => l_rev_component_tbl
3836: , x_ref_designator_tbl => l_ref_designator_tbl
3837: , x_sub_component_tbl => l_sub_component_tbl

Line 3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3835: , x_rev_component_tbl => l_rev_component_tbl
3836: , x_ref_designator_tbl => l_ref_designator_tbl
3837: , x_sub_component_tbl => l_sub_component_tbl
3838: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

Line 3838: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3835: , x_rev_component_tbl => l_rev_component_tbl
3836: , x_ref_designator_tbl => l_ref_designator_tbl
3837: , x_sub_component_tbl => l_sub_component_tbl
3838: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3839: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3840: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3841: );
3842:

Line 3839: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

3835: , x_rev_component_tbl => l_rev_component_tbl
3836: , x_ref_designator_tbl => l_ref_designator_tbl
3837: , x_sub_component_tbl => l_sub_component_tbl
3838: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3839: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3840: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3841: );
3842:
3843: Eng_Propagation_Log_Util.Add_Entity_Map(

Line 3840: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

3836: , x_ref_designator_tbl => l_ref_designator_tbl
3837: , x_sub_component_tbl => l_sub_component_tbl
3838: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3839: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3840: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3841: );
3842:
3843: Eng_Propagation_Log_Util.Add_Entity_Map(
3844: p_change_id => p_change_id

Line 3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

3863: p_error_status => l_return_status
3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3871: , x_rev_component_tbl => l_rev_component_tbl

Line 3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3871: , x_rev_component_tbl => l_rev_component_tbl
3872: , x_ref_designator_tbl => l_ref_designator_tbl

Line 3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change

3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3871: , x_rev_component_tbl => l_rev_component_tbl
3872: , x_ref_designator_tbl => l_ref_designator_tbl
3873: , x_sub_component_tbl => l_sub_component_tbl

Line 3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3871: , x_rev_component_tbl => l_rev_component_tbl
3872: , x_ref_designator_tbl => l_ref_designator_tbl
3873: , x_sub_component_tbl => l_sub_component_tbl
3874: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

Line 3874: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3871: , x_rev_component_tbl => l_rev_component_tbl
3872: , x_ref_designator_tbl => l_ref_designator_tbl
3873: , x_sub_component_tbl => l_sub_component_tbl
3874: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3875: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3876: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3877: );
3878: -- local change id is set later

Line 3875: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

3871: , x_rev_component_tbl => l_rev_component_tbl
3872: , x_ref_designator_tbl => l_ref_designator_tbl
3873: , x_sub_component_tbl => l_sub_component_tbl
3874: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3875: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3876: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3877: );
3878: -- local change id is set later
3879: -- if there are errors, based on the level they are not populated in the

Line 3876: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

3872: , x_ref_designator_tbl => l_ref_designator_tbl
3873: , x_sub_component_tbl => l_sub_component_tbl
3874: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3875: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3876: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3877: );
3878: -- local change id is set later
3879: -- if there are errors, based on the level they are not populated in the
3880: -- maps table.

Line 4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

4079: l_return_status VARCHAR2(1);
4080: l_err_text VARCHAR2(2000);
4081: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4082: -- Variables for Call to Process ECO
4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4086: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4087: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

4080: l_err_text VARCHAR2(2000);
4081: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4082: -- Variables for Call to Process ECO
4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4086: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4087: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4088: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;

Line 4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

4081: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4082: -- Variables for Call to Process ECO
4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4086: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4087: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4088: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4089: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;

Line 4086: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

4082: -- Variables for Call to Process ECO
4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4086: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4087: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4088: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4089: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4090: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

Line 4614: Eng_Eco_Pub.Process_Eco(

4610: END LOOP; -- End rev IN c_eco_revision
4611: END LOOP;
4612:
4613: -- Process Header and ECO Revisions
4614: Eng_Eco_Pub.Process_Eco(
4615: p_api_version_number => 1.0
4616: , p_init_msg_list => FALSE
4617: , x_return_status => l_return_status
4618: , x_msg_count => l_msg_count

Line 4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

4778: l_err_text VARCHAR2(2000);
4779: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4780: l_msg_count NUMBER;
4781:
4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4784: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4785: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4786: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

4779: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4780: l_msg_count NUMBER;
4781:
4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4784: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4785: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4786: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4787: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;

Line 4784: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

4780: l_msg_count NUMBER;
4781:
4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4784: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4785: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4786: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4787: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4788: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;

Line 4785: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

4781:
4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4784: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4785: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4786: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;
4787: l_sub_component_tbl Bom_Bo_Pub.Sub_Component_Tbl_Type;
4788: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4789: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

Line 4792: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

4788: l_ref_designator_tbl Bom_Bo_Pub.Ref_Designator_Tbl_Type;
4789: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4790: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4791: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4792: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
4793:
4794: CURSOR c_revised_items_data IS
4795: SELECT use_up_item_id
4796: , revised_item_id