1 PACKAGE ENG_Eco_PVT AUTHID CURRENT_USER AS
2 /* $Header: ENGVECOS.pls 120.2 2011/03/08 06:19:50 gliang 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
17 --
18
19 -- End of Comments
20 PROCEDURE Process_Eco
21 ( p_api_version_number IN NUMBER
22 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23 , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
24 ENG_GLOBALS.G_MISS_CONTROL_REC
25 , x_return_status OUT NOCOPY VARCHAR2
26 , x_msg_count OUT NOCOPY NUMBER
27 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
28 ENG_Eco_PUB.G_MISS_ECO_REC
29 , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
30 ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
31 , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type := -- Eng Change
32 ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL
33 , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
34 ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
35 , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
36 BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
37 , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
38 BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
39 , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
40 BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
41 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
42 Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
43 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
44 Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
45 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
46 Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
47 , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
48 , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
49 , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
50 , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
51 , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
52 , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
53 , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
54 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
55 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
56 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
57 , x_disable_revision OUT NOCOPY NUMBER -- Bug no:3034642
58 );
59
60 -- Start of Comments
61 -- API name Lock_Eco
62 -- Type Private
63 -- Function
64 --
65 -- Pre-reqs
66 --
67 -- Parameters
68 --
69 -- Version Current version = 1.0
70 -- Initial version = 1.0
71 --
72 -- Notes: Not Used. Eng Change Enhancement changes are not implemented
73 --
74 -- End of Comments
75
76 PROCEDURE Lock_Eco
77 ( p_api_version_number IN NUMBER
78 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_msg_count OUT NOCOPY NUMBER
81 , x_msg_data OUT NOCOPY VARCHAR2
82 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
83 ENG_Eco_PUB.G_MISS_ECO_REC
84 , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
85 ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
86 , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
87 ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
88 , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
89 BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
90 , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
91 BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
92 , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
93 BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
94 , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
95 , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
96 , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
97 , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
98 , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
99 , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
100 , x_err_text OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE Process_Rev_Item
104 ( p_validation_level IN NUMBER
105 , p_change_notice IN VARCHAR2 := NULL
106 , p_organization_id IN NUMBER := NULL
107 , I IN NUMBER
108 , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
109 , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
110 , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
111 , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
112 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
113 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
114 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
115 , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
116 , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
117 , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
118 , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
119 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
120 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
121 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
122 , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
123 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
124 , x_return_status OUT NOCOPY VARCHAR2
125 , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
126 );
127
128 PROCEDURE Process_Rev_Comp
129 ( p_validation_level IN NUMBER
130 , p_change_notice IN VARCHAR2 := NULL
131 , p_organization_id IN NUMBER := NULL
132 , p_revised_item_name IN VARCHAR2 := NULL
133 , p_alternate_bom_code IN VARCHAR2 := NULL -- Bug 2429272 Change4(cont..of..ENGSVIDB.pls)
134 , p_effectivity_date IN DATE := NULL
135 , p_item_revision IN VARCHAR2 := NULL
136 , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
137 , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
138 , I IN NUMBER
139 , p_rev_component_rec IN BOM_BO_PUB.Rev_Component_Rec_Type
140 , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
141 , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
142 , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
143 , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
144 , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
145 , x_rev_comp_unexp_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
146 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
147 , x_return_status OUT NOCOPY VARCHAR2
148 , x_bill_sequence_id IN NUMBER := NULL
149 );
150
151 -- Ehn 10647772: change order workflow auto explosion and submission
152 PROCEDURE Explode_WF_Routing(p_change_notice IN VARCHAR2,
153 p_org_id IN NUMBER,
154 x_return_status IN OUT NOCOPY VARCHAR2,
155 x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156 );
157
158 END ENG_Eco_PVT;