DBA Data[Home] [Help]

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 1757: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

1753: p_org_hierarchy_name IN VARCHAR2,
1754: p_org_hierarchy_level IN VARCHAR2
1755: )
1756: IS
1757: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1758: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1759: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
1760: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
1761: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 1758: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

1754: p_org_hierarchy_level IN VARCHAR2
1755: )
1756: IS
1757: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1758: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1759: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 1759: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

1755: )
1756: IS
1757: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1758: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1759: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 1760: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

1756: IS
1757: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
1758: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
1759: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 3243: Eng_Eco_Pub.Process_Eco

3239: Error_Handler.Initialize;
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3242: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3243: Eng_Eco_Pub.Process_Eco
3244: (
3245: p_api_version_number => 1.0
3246: ,p_init_msg_list => FALSE
3247: ,x_return_status => l_return_status

Line 3442: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

3438: PROCEDURE Propagate_Revised_Component (
3439: p_component_sequence_id IN NUMBER
3440: , p_revised_item_sequence_id IN NUMBER
3441: , p_change_id IN NUMBER
3442: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3443: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3444: , p_local_organization_id IN NUMBER
3445: , x_Return_Status OUT NOCOPY VARCHAR2
3446: ) IS

Line 3443: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

3439: p_component_sequence_id IN NUMBER
3440: , p_revised_item_sequence_id IN NUMBER
3441: , p_change_id IN NUMBER
3442: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3443: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3444: , p_local_organization_id IN NUMBER
3445: , x_Return_Status OUT NOCOPY VARCHAR2
3446: ) IS
3447:

Line 3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

3952: p_error_status => l_return_status
3953: , p_mesg_token_tbl => l_mesg_token_tbl
3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3960: , x_rev_component_tbl => l_rev_component_tbl

Line 3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

3953: , p_mesg_token_tbl => l_mesg_token_tbl
3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3960: , x_rev_component_tbl => l_rev_component_tbl
3961: , x_ref_designator_tbl => l_ref_designator_tbl

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

3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3960: , x_rev_component_tbl => l_rev_component_tbl
3961: , x_ref_designator_tbl => l_ref_designator_tbl
3962: , x_sub_component_tbl => l_sub_component_tbl

Line 3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3960: , x_rev_component_tbl => l_rev_component_tbl
3961: , x_ref_designator_tbl => l_ref_designator_tbl
3962: , x_sub_component_tbl => l_sub_component_tbl
3963: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

Line 3963: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3960: , x_rev_component_tbl => l_rev_component_tbl
3961: , x_ref_designator_tbl => l_ref_designator_tbl
3962: , x_sub_component_tbl => l_sub_component_tbl
3963: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3964: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3965: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3966: );
3967:

Line 3964: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

3960: , x_rev_component_tbl => l_rev_component_tbl
3961: , x_ref_designator_tbl => l_ref_designator_tbl
3962: , x_sub_component_tbl => l_sub_component_tbl
3963: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3964: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3965: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3966: );
3967:
3968: Eng_Propagation_Log_Util.Add_Entity_Map(

Line 3965: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

3961: , x_ref_designator_tbl => l_ref_designator_tbl
3962: , x_sub_component_tbl => l_sub_component_tbl
3963: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
3964: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3965: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3966: );
3967:
3968: Eng_Propagation_Log_Util.Add_Entity_Map(
3969: p_change_id => p_change_id

Line 3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

3988: p_error_status => l_return_status
3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3996: , x_rev_component_tbl => l_rev_component_tbl

Line 3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3996: , x_rev_component_tbl => l_rev_component_tbl
3997: , x_ref_designator_tbl => l_ref_designator_tbl

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

3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3996: , x_rev_component_tbl => l_rev_component_tbl
3997: , x_ref_designator_tbl => l_ref_designator_tbl
3998: , x_sub_component_tbl => l_sub_component_tbl

Line 3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3996: , x_rev_component_tbl => l_rev_component_tbl
3997: , x_ref_designator_tbl => l_ref_designator_tbl
3998: , x_sub_component_tbl => l_sub_component_tbl
3999: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

Line 3999: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL

3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3996: , x_rev_component_tbl => l_rev_component_tbl
3997: , x_ref_designator_tbl => l_ref_designator_tbl
3998: , x_sub_component_tbl => l_sub_component_tbl
3999: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
4000: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
4001: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
4002: );
4003: -- local change id is set later

Line 4000: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL

3996: , x_rev_component_tbl => l_rev_component_tbl
3997: , x_ref_designator_tbl => l_ref_designator_tbl
3998: , x_sub_component_tbl => l_sub_component_tbl
3999: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
4000: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
4001: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
4002: );
4003: -- local change id is set later
4004: -- if there are errors, based on the level they are not populated in the

Line 4001: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL

3997: , x_ref_designator_tbl => l_ref_designator_tbl
3998: , x_sub_component_tbl => l_sub_component_tbl
3999: , x_rev_operation_tbl => ENG_Eco_PUB.G_MISS_REV_OPERATION_TBL
4000: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
4001: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
4002: );
4003: -- local change id is set later
4004: -- if there are errors, based on the level they are not populated in the
4005: -- maps table.

Line 4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

4204: l_return_status VARCHAR2(1);
4205: l_err_text VARCHAR2(2000);
4206: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4207: -- Variables for Call to Process ECO
4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4211: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4212: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

4205: l_err_text VARCHAR2(2000);
4206: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4207: -- Variables for Call to Process ECO
4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

4206: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4207: -- Variables for Call to Process ECO
4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4211: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

4207: -- Variables for Call to Process ECO
4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4740: Eng_Eco_Pub.Process_Eco(

4736: END LOOP; -- End rev IN c_eco_revision
4737: END LOOP;
4738:
4739: -- Process Header and ECO Revisions
4740: Eng_Eco_Pub.Process_Eco(
4741: p_api_version_number => 1.0
4742: , p_init_msg_list => FALSE
4743: , x_return_status => l_return_status
4744: , x_msg_count => l_msg_count

Line 4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;

4905: l_err_text VARCHAR2(2000);
4906: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4907: l_msg_count NUMBER;
4908:
4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4911: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4912: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;
4913: l_rev_component_tbl Bom_Bo_Pub.Rev_Component_Tbl_Type;

Line 4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;

4906: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4907: l_msg_count NUMBER;
4908:
4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4911: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4911: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;

4907: l_msg_count NUMBER;
4908:
4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4911: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4912: l_revised_item_tbl Eng_Eco_Pub.Revised_Item_Tbl_Type;

4908:
4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4911: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
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;

Line 4919: l_revised_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_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
4923: , revised_item_id