1 PACKAGE ENG_Form_Eco_PVT AUTHID CURRENT_USER AS
2 /* $Header: ENGFPVTS.pls 115.9 2003/07/08 13:19:40 akumar ship $ */
3
4 -- Start of Comments
5 -- API name Process_Eco
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes show errors package body ENG_Eco_PUB;
17
18 -- show errors package body ENG_Eco_PUB;
19
20 -- End of Comments
21
22 PROCEDURE Process_Eco
23 ( x_return_status IN OUT NOCOPY VARCHAR2
24 , x_msg_count IN OUT NOCOPY NUMBER
25 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
26 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
27 ENG_Eco_PUB.G_MISS_ECO_REC
28 , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
29 , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
30 , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
31 , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
32 , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
33 , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
34 , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL -- add
35 , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL -- add
36 , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL -- add
37 , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
38 ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
39 , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
40 ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
41 , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
42 BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
43 , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
44 BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
45 , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
46 BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
47 , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
48 BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL --add
49 , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
50 BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL --add
51 , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
52 BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL --add
53 , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
54 , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type --ECO 10dec
55 , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
56 , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
57 , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
58 , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
59 , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
60 , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type --add
61 , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type --add
62 , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type --add
63 , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
64 , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
65 , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
66 , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
67 , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
68 , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
69 , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
70 , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
71 , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
72 );
73
74 /*
75 -- Start of Comments
76 -- API name Lock_Eco
77 -- Type Private
78 -- Function
79 --
80 -- Pre-reqs
81 --
82 -- Parameters
83 --
84 -- Version Current version = 1.0
85 -- Initial version = 1.0
86 --
87 -- Notes
88 --
89 -- End of Comments
90
91 PROCEDURE Lock_Eco
92 ( p_api_version_number IN NUMBER
93 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
94 , x_return_status IN OUT NOCOPY VARCHAR2
95 , x_msg_count IN OUT NOCOPY NUMBER
96 , x_msg_data IN OUT NOCOPY VARCHAR2
97 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
98 ENG_Eco_PUB.G_MISS_ECO_REC
99 , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
100 ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
101 , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
102 ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
103 , p_rev_component_tbl IN ENG_Eco_PUB.Rev_Component_Tbl_Type :=
104 ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
105 , p_ref_designator_tbl IN ENG_Eco_PUB.Ref_Designator_Tbl_Type :=
106 ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
107 , p_sub_component_tbl IN ENG_Eco_PUB.Sub_Component_Tbl_Type :=
108 ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
109 , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110 , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
111 , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
112 , x_rev_component_tbl IN OUT NOCOPY ENG_Eco_PUB.Rev_Component_Tbl_Type
113 , x_ref_designator_tbl IN OUT NOCOPY ENG_Eco_PUB.Ref_Designator_Tbl_Type
114 , x_sub_component_tbl IN OUT NOCOPY ENG_Eco_PUB.Sub_Component_Tbl_Type
115 , x_err_text IN OUT NOCOPY VARCHAR2
116 );
117
118 */
119
120
121 END ENG_Form_Eco_PVT;