1 PACKAGE Bom_Bom_Component_Util AS
2 /* $Header: BOMUCMPS.pls 120.0 2005/05/25 06:12:19 appldev noship $ */
3 /*#
4 * This API contains entity utility method for the Bill of Materials Components.
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname BOM Component Util Package
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
10 */
11
12 -- PROCEDURE Convert_Miss_To_Null
13
14 /*#
15 * This method will convert the missing values of some attributes that the user wishes to NULL
16 * @param p_bom_component_rec Bom Component exposed column record
17 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Rec_Type}
18 * @param p_bom_comp_unexp_rec Bom component unexposed column record
19 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type }
20 * @param x_bom_component_rec Bom Component exposed column record
21 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Rec_Type}
22 * @param x_bom_comp_unexp_rec Bom component unexposed column record
23 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type }
24 * @rep:scope private
25 * @rep:lifecycle active
26 * @rep:displayname Convert Miss To Null
27 */
28
29
30 PROCEDURE Convert_Miss_To_Null
31 ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
32 , p_bom_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
33 , x_bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
34 , x_bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
35 );
36
37 /*#
38 * Perform Writes is the only exposed method that the user will have access, to perform
39 * any insert/update/deletes to the Inventory Components table
40 * @param p_bom_component_rec Bom Component exposed column record
41 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Rec_Type}
42 * @param p_bom_comp_unexp_rec Bom component unexposed column record
43 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type }
44 * @param x_Mesg_Token_Tbl Message token table
45 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
46 * @param x_Return_status Return Status
47 * @rep:scope private
48 * @rep:lifecycle active
49 * @rep:displayname Perform Writes
50 */
51
52
53 PROCEDURE Perform_Writes
54 ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
55 , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
56 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
57 , x_Return_Status IN OUT NOCOPY VARCHAR2
58 );
59
60 /*#
61 * Procedure will query the database record, seperate the values into exposed columns
62 * and unexposed columns and return those records
63 * @param p_Component_Item_Id Component item id
64 * @param p_Operation_Sequence_Number Operation Sequence number
65 * @param p_Effectivity_Date Effectivity date
66 * @param p_Bill_Sequence_Id Bill sequence id
67 * @param p_from_end_item_number from end item number
68 * @param x_Bom_Component_Rec Bom component Exposed column Record
69 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Rec_Type}
70 * @param x_Bom_Comp_Unexp_Rec Bom component Unexposed column Record
71 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type }
72 * @param x_Return_status Return Status
73 * @param p_Mesg_Token_Tbl Message token table
74 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
75 * @param x_Mesg_Token_Tbl Message token table
76 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
77 * @rep:scope private
78 * @rep:lifecycle active
79 * @rep:displayname Query Row
80 */
81
82
83 PROCEDURE Query_Row
84 ( p_Component_Item_Id IN NUMBER
85 , p_Operation_Sequence_Number IN NUMBER
86 , p_Effectivity_Date IN DATE
87 , p_Bill_Sequence_Id IN NUMBER
88 , p_from_end_item_number IN VARCHAR2 := NULL
89 , x_Bom_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
90 , x_Bom_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
91 , x_Return_Status IN OUT NOCOPY VARCHAR2
92 , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
93 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
94 );
95
96
97 /** ECO BO Routine definitions **/
98 /*#
99 * This method will query the database record, seperate the values into exposed columns
100 * and unexposed columns and return with those records.This can be used with ECO
101 * @param p_Component_Item_Id Component item id
102 * @param p_Operation_Sequence_Number Operation Sequence number
103 * @param p_Effectivity_Date Effectivity date
104 * @param p_Bill_Sequence_Id Bill sequence id
105 * @param x_Rev_Component_Rec Revision component Exposed column Record
106 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Component_Rec_Type}
107 * @param x_Rev_Comp_Unexp_Rec Revision component Unexposed column Record
108 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type }
109 * @param x_Return_status Return Status
110 * @param p_Mesg_Token_Tbl Message token table
111 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
112 * @param x_Mesg_Token_Tbl Message token table
113 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
114 * @rep:scope private
115 * @rep:lifecycle active
116 * @rep:displayname Query Row
117 */
118
119 PROCEDURE Query_Row
120 ( p_Component_Item_Id IN NUMBER
121 , p_Operation_Sequence_Number IN NUMBER
122 , p_Effectivity_Date IN DATE
123 , p_Bill_Sequence_Id IN NUMBER
124 , p_from_end_item_number IN VARCHAR2 := NULL
125 , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
126 , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
127 , x_Return_Status IN OUT NOCOPY VARCHAR2
128 , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type
129 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130 );
131
132
133 /*#
134 * Perform Writes is the only exposed method that the user will have access, to perform
135 * any insert/update/deletes to the Inventory Components table.This can be used with ECO
136 * @param p_rev_component_rec Revision Component exposed column record
137 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Component_Rec_Type}
138 * @param p_rev_comp_unexp_rec Revision component unexposed column record
139 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type }
140 * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
141 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
142 * @param x_Mesg_Token_Tbl Message token table
143 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
144 * @param x_Return_status Return Status
145 * @rep:scope private
146 * @rep:lifecycle active
147 * @rep:displayname Perform Writes
148 */
149
150 PROCEDURE Perform_Writes( p_rev_component_rec IN
151 Bom_Bo_Pub.Rev_Component_Rec_Type
152 , p_rev_comp_unexp_rec IN
153 Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
154 , p_control_rec IN
155 Bom_Bo_Pub.Control_Rec_Type
156 := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
157 , x_Mesg_Token_Tbl IN OUT NOCOPY
158 Error_Handler.Mesg_Token_Tbl_Type
159 , x_Return_Status IN OUT NOCOPY VARCHAR2
160 );
161
162
163 /*#
164 * Cancel component
165 * @param p_component_sequence_id component sequence id
166 * @param p_cancel_comments comments for cancelling
167 * @param p_user_id user id
168 * @param p_login_id login id
169 * @rep:scope private
170 * @rep:lifecycle active
171 * @rep:displayname Cancel component
172 */
173
174
175 PROCEDURE Cancel_Component( p_component_sequence_id IN NUMBER
176 , p_cancel_comments IN VARCHAR2
177 , p_user_id IN NUMBER
178 , p_login_id IN NUMBER
179 );
180 /*#
181 * This method will be called when a revised component is the first component being added on a
182 * revised item. This method will create a Bill and update the revised item information indicating
183 * that bill for this revised item now exists.
184 * @param p_assembly_item_id Assembly Item ID
185 * @param p_organization_id Organization ID
186 * @param p_pending_from_ecn Pending from ECN
187 * @param p_bill_sequence_id bill sequence id
188 * @param p_common_bill_sequence_id common bill sequence id
189 * @param p_assembly_type assembly type
190 * @param p_last_update_date WHO column
191 * @param p_last_updated_by WHO column
192 * @param p_creation_date WHO column
193 * @param p_created_by WHO column
194 * @param p_revised_item_seq_id revised item sequence id
195 * @param p_original_system_reference Legacy system form which the original data has come from.
196 * @param p_alternate_bom_code alternate bom designator
197 * @rep:scope private
198 * @rep:lifecycle active
199 * @rep:displayname Create New Bill
200 */
201
202
203 PROCEDURE Create_New_Bill( p_assembly_item_id IN NUMBER
204 , p_organization_id IN NUMBER
205 , p_pending_from_ecn IN VARCHAR2
206 , p_bill_sequence_id IN NUMBER
207 , p_common_bill_sequence_id IN NUMBER
208 , p_assembly_type IN NUMBER
209 , p_last_update_date IN DATE
210 , p_last_updated_by IN NUMBER
211 , p_creation_date IN DATE
212 , p_created_by IN NUMBER
213 , p_revised_item_seq_id IN NUMBER
214 , p_original_system_reference IN VARCHAR2
215 , p_alternate_bom_code IN VARCHAR2 := null
216 );
217
218 /*#
219 * This method will convert the missing values of some attributes that the user wishes to NULL
220 * @param p_rev_component_rec Revision Component exposed column record.This can be used with ECO
221 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Component_Rec_Type }
222 * @param p_rev_comp_unexp_rec Revision component unexposed column record
223 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type }
224 * @param x_Rev_component_rec Revision Component exposed column record
225 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Component_Rec_Type}
226 * @param x_Rev_comp_unexp_rec Revision component unexposed column record
227 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type }
228 * @rep:scope private
229 * @rep:lifecycle active
230 * @rep:displayname Convert Miss To Null
231 */
232
233 PROCEDURE Convert_Miss_To_Null
234 ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
235 , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
236 , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
237 , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
238 );
239 END Bom_Bom_Component_Util;
240
241 -- SHOW ERRORS PACKAGE Bom_Bom_Component_Util;
[Home] [Help]