1 PACKAGE BOM_Val_To_Id AUTHID CURRENT_USER AS
2 /* $Header: BOMSVIDS.pls 115.6 2002/11/13 20:56:31 rfarook 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 FUNCTION Organization
29 ( p_organization IN VARCHAR2
30 , x_err_text IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
31
32 FUNCTION Bill_Sequence_Id
33 ( p_assembly_item_id IN NUMBER
34 , p_alternate_bom_code IN VARCHAR2
35 , p_organization_id IN NUMBER
36 , x_err_text IN OUT NOCOPY VARCHAR2
37 ) RETURN NUMBER;
38
39 PROCEDURE Bom_Header_UUI_To_UI
40 ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
41 , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
42 , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
43 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44 , x_Return_Status IN OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Bom_Header_VID
48 ( x_Return_Status IN OUT NOCOPY VARCHAR2
49 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50 , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
51 , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
52 , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
53 );
54
55 PROCEDURE Bom_Revision_UUI_To_UI2
56 ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
57 , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
58 , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
59 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
60 , x_return_status IN OUT NOCOPY VARCHAR2
61 );
62
63
64 PROCEDURE Rev_Component_VID
65 ( x_Return_Status IN OUT NOCOPY Varchar2
66 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
67 , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
68 , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
69 , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
70 );
71
72 -- Called by the BOM Business Object.
73 PROCEDURE Bom_Component_VID
74 ( x_return_status IN OUT NOCOPY VARCHAR2
75 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
76 , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
77 , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
78 , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
79 );
80
81
82 PROCEDURE Rev_Component_UUI_To_UI
83 ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
84 , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
85 , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
86 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
87 , x_Return_Status IN OUT NOCOPY VARCHAR2
88 );
89
90 -- Called by the BOM Business Object.
91 PROCEDURE Bom_Component_UUI_To_UI
92 ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
93 , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
94 , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
95 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
96 , x_Return_Status IN OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE Rev_Component_UUI_to_UI2
100 ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
101 , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
102 , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
103 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
104 , x_other_message IN OUT NOCOPY VARCHAR2
105 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
106 , x_Return_Status IN OUT NOCOPY VARCHAR2
107 );
108
109 -- Called by the BOM Business Object.
110 PROCEDURE Bom_Component_UUI_to_UI2
111 ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
112 , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
113 , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
114 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
115 , x_other_message IN OUT NOCOPY VARCHAR2
116 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
117 , x_Return_Status IN OUT NOCOPY VARCHAR2
118 );
119
120
121 PROCEDURE Sub_Component_UUI_To_UI
122 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
123 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
124 , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
125 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
126 , x_Return_Status IN OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE Sub_Component_UUI_To_UI2
130 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
131 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
132 , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
133 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
134 , x_other_message IN OUT NOCOPY VARCHAR2
135 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
136 , x_Return_Status IN OUT NOCOPY VARCHAR2
137 );
138
139 -- Procedure called by BOM Business Object
140 PROCEDURE Sub_Component_UUI_To_UI
141 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
142 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
143 , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
144 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
145 , x_Return_Status IN OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE Sub_Component_UUI_To_UI2
149 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
150 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
151 , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
152 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
153 , x_other_message IN OUT NOCOPY VARCHAR2
154 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
155 , x_Return_Status IN OUT NOCOPY VARCHAR2
156 );
157
158 PROCEDURE Ref_Designator_UUI_To_UI
159 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
160 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
161 , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
162 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
163 , x_Return_Status IN OUT NOCOPY VARCHAR2
164 );
165
166
167 PROCEDURE Ref_Designator_UUI_To_UI2
168 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
169 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
170 , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
171 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
172 , x_other_message IN OUT NOCOPY VARCHAR2
173 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
174 , x_Return_Status IN OUT NOCOPY VARCHAR2
175 );
176
177 --Procedures called by the BOM Business Object
178 PROCEDURE Ref_Designator_UUI_To_UI
179 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
180 , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
181 , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
182 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
183 , x_Return_Status IN OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE Ref_Designator_UUI_To_UI2
187 ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
188 , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
189 , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
190 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
191 , x_other_message IN OUT NOCOPY VARCHAR2
192 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
193 , x_Return_Status IN OUT NOCOPY VARCHAR2
194 );
195
196 --Procedures called by the BOM Business Object
197 PROCEDURE Bom_Comp_Operation_UUI_To_UI
198 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
199 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
200 , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
201 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
202 , x_Return_Status IN OUT NOCOPY VARCHAR2
203 );
204
205 PROCEDURE Bom_Comp_Operation_UUI_To_UI2
206 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
207 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
208 , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
209 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210 , x_other_message IN OUT NOCOPY VARCHAR2
211 , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
212 , x_Return_Status IN OUT NOCOPY VARCHAR2
213 );
214
215
216 END BOM_Val_To_Id;