DBA Data[Home] [Help]

APPS.ENG_ECO_PUB dependencies on ENG_ECO_PUB

Line 1: PACKAGE BODY ENG_Eco_PUB AS

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:

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PUB';

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:

Line 23: ( p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type

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

Line 51: ( p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type

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

Line 281: ( p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type

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

Line 310: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type

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

Line 311: , p_eco_revision_tbl IN ENG_ECO_PUB.Eco_Revision_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

Line 312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_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

Line 319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change

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

Line 1020: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type

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

Line 1021: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_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

Line 1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_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

Line 1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_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

Line 1666: END ENG_Eco_PUB;

1662: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1663: END;
1664: */
1665:
1666: END ENG_Eco_PUB;