1: PACKAGE BODY ENG_Eco_PUB AS
2: /* $Header: ENGBECOB.pls 120.1.12020000.3 2012/07/13 07:33:46 qyou ship $ */
3:
4:
5:
13: -- Added Process_Eco with New Entities
14: -- 11-DEC-02 Bruno Bontempi Taken away people processing
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PUB';
18:
19:
20: -- Function Does_Rev_Have_Same_ECO
21:
19:
20: -- Function Does_Rev_Have_Same_ECO
21:
22: FUNCTION Does_Rev_Have_Same_ECO
23: ( p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
24: , p_change_notice IN VARCHAR2
25: , p_organization_code IN VARCHAR2
26: ) RETURN BOOLEAN
27: IS
47:
48: -- Function Does_Item_Have_Same_ECO
49:
50: FUNCTION Does_Item_Have_Same_ECO
51: ( p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
52: , p_change_notice IN VARCHAR2
53: , p_organization_code IN VARCHAR2
54: ) RETURN BOOLEAN
55: IS
277: * Purpose : This function is to check all the records have the
278: * same change_notice and same organization.
279: *********************************************************************/
280: FUNCTION Does_ChangeLine_Have_Same_ECO
281: ( p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type
282: , p_change_notice IN VARCHAR2
283: , p_organization_code IN VARCHAR2
284: ) RETURN BOOLEAN
285: IS
306:
307: -- Function Check_Records_In_Same_ECO
308:
309: FUNCTION Check_Records_In_Same_ECO
310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
307: -- Function Check_Records_In_Same_ECO
308:
309: FUNCTION Check_Records_In_Same_ECO
310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
308:
309: FUNCTION Check_Records_In_Same_ECO
310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
321: , x_organization_code OUT NOCOPY VARCHAR2
322: ) RETURN BOOLEAN
323: IS
1016: field.
1017: *********************************************************************/
1018:
1019: PROCEDURE Populate_Bo_Tables
1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1017: *********************************************************************/
1018:
1019: PROCEDURE Populate_Bo_Tables
1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1018:
1019: PROCEDURE Populate_Bo_Tables
1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1031: record_count NUMBER;
1032: BEGIN
1033: -- Populate ECO revision change number
1662: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1663: END;
1664: */
1665:
1666: END ENG_Eco_PUB;