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.0.12000000.2 2007/04/13 13:32:55 ksathupa 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 1017: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type

1013: field.
1014: *********************************************************************/
1015:
1016: PROCEDURE Populate_Bo_Tables
1017: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1018: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1019: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1020: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1021: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 1018: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type

1014: *********************************************************************/
1015:
1016: PROCEDURE Populate_Bo_Tables
1017: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1018: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1019: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1020: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1021: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1022: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 1019: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type

1015:
1016: PROCEDURE Populate_Bo_Tables
1017: ( p_ECO_rec IN OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
1018: , p_eco_revision_tbl IN OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
1019: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1020: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1021: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1022: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1023: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type

Line 1026: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )

1022: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1023: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1024: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1025: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1026: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1027: IS
1028: record_count NUMBER;
1029: BEGIN
1030: -- Populate ECO revision change number

Line 1662: END ENG_Eco_PUB;

1658: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1659: END;
1660: */
1661:
1662: END ENG_Eco_PUB;