1 PACKAGE BOM_Val_To_Id AUTHID CURRENT_USER AS
2 /* $Header: BOMSVIDS.pls 120.0.12010000.2 2010/01/20 19:36:05 umajumde ship $ */
3 /****************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMSVIDS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package BOM_Val_To_Id
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 01-JUL-99 Rahul Chitko Initial Creation
21 --
22 -- 07-MAY-2001 Refai Farook EAM related changes
23 --
24 -- 21-AUG-01 Refai Farook One To Many support changes
25 --
26 ****************************************************************************/
27
28 --Bug 8850425 begin
29 FUNCTION Comp_Operation_Seq_Id( p_component_sequence_id IN NUMBER
30 , p_operation_sequence_number IN NUMBER
31 ) RETURN NUMBER;
32 --Bug 8850425 end
33
34 FUNCTION Organization
35 ( p_organization IN VARCHAR2
36 , x_err_text IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
37
38 FUNCTION Bill_Sequence_Id
39 ( p_assembly_item_id IN NUMBER
40 , p_alternate_bom_code IN VARCHAR2
41 , p_organization_id IN NUMBER
42 , x_err_text IN OUT NOCOPY VARCHAR2
43 ) RETURN NUMBER;
44
45 PROCEDURE Bom_Header_UUI_To_UI
46 ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
47 , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
48 , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
49 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50 , x_Return_Status IN OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Bom_Header_VID
54 ( x_Return_Status IN OUT NOCOPY VARCHAR2
55 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56 , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57 , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
58 , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
59 );
60
61 PROCEDURE Bom_Revision_UUI_To_UI2
62 ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
63 , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
64 , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
65 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
66 , x_return_status IN OUT NOCOPY VARCHAR2
67 );
68
69
70 PROCEDURE Rev_Component_VID
71 ( x_Return_Status IN OUT NOCOPY Varchar2
72 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
73 , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
74 , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75 , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
76 );
77
78 -- Called by the BOM Business Object.
79 PROCEDURE Bom_Component_VID
80 ( x_return_status IN OUT NOCOPY VARCHAR2
81 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
82 , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
83 , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
84 , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
85 );
86
87
88 PROCEDURE Rev_Component_UUI_To_UI
89 ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
90 , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
91 , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
92 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
93 , x_Return_Status IN OUT NOCOPY VARCHAR2
94 );
95
96 -- Called by the BOM Business Object.
97 PROCEDURE Bom_Component_UUI_To_UI
98 ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
99 , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
100 , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
101 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
102 , x_Return_Status IN OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE Rev_Component_UUI_to_UI2
106 ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
107 , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
108 , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
109 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
110 , x_other_message IN OUT NOCOPY VARCHAR2
111 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
112 , x_Return_Status IN OUT NOCOPY VARCHAR2
113 );
114
115 -- Called by the BOM Business Object.
116 PROCEDURE Bom_Component_UUI_to_UI2
117 ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
118 , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
119 , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
120 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
121 , x_other_message IN OUT NOCOPY VARCHAR2
122 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
123 , x_Return_Status IN OUT NOCOPY VARCHAR2
124 );
125
126
127 PROCEDURE Sub_Component_UUI_To_UI
128 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
129 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
130 , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
131 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
132 , x_Return_Status IN OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE Sub_Component_UUI_To_UI2
136 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
137 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
138 , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
139 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
140 , x_other_message IN OUT NOCOPY VARCHAR2
141 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
142 , x_Return_Status IN OUT NOCOPY VARCHAR2
143 );
144
145 -- Procedure called by BOM Business Object
146 PROCEDURE Sub_Component_UUI_To_UI
147 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
148 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
149 , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
150 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
151 , x_Return_Status IN OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE Sub_Component_UUI_To_UI2
155 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
156 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
157 , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
158 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159 , x_other_message IN OUT NOCOPY VARCHAR2
160 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
161 , x_Return_Status IN OUT NOCOPY VARCHAR2
162 );
163
164 PROCEDURE Ref_Designator_UUI_To_UI
165 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
166 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
167 , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
168 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
169 , x_Return_Status IN OUT NOCOPY VARCHAR2
170 );
171
172
173 PROCEDURE Ref_Designator_UUI_To_UI2
174 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
175 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
176 , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
177 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
178 , x_other_message IN OUT NOCOPY VARCHAR2
179 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
180 , x_Return_Status IN OUT NOCOPY VARCHAR2
181 );
182
183 --Procedures called by the BOM Business Object
184 PROCEDURE Ref_Designator_UUI_To_UI
185 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
186 , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
187 , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
188 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
189 , x_Return_Status IN OUT NOCOPY VARCHAR2
190 );
191
192 PROCEDURE Ref_Designator_UUI_To_UI2
193 ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
194 , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
195 , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
196 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
197 , x_other_message IN OUT NOCOPY VARCHAR2
198 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
199 , x_Return_Status IN OUT NOCOPY VARCHAR2
200 );
201
202 --Procedures called by the BOM Business Object
203 PROCEDURE Bom_Comp_Operation_UUI_To_UI
204 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
205 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
206 , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
207 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
208 , x_Return_Status IN OUT NOCOPY VARCHAR2
209 );
210
211 PROCEDURE Bom_Comp_Operation_UUI_To_UI2
212 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
213 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
214 , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
215 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
216 , x_other_message IN OUT NOCOPY VARCHAR2
217 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
218 , x_Return_Status IN OUT NOCOPY VARCHAR2
219 );
220
221
222 END BOM_Val_To_Id;