1 PACKAGE BOM_Default_Sub_Op_Res AUTHID CURRENT_USER AS
2 /* $Header: BOMDSORS.pls 120.1 2006/02/21 03:32:45 grastogi noship $ */
3 /*#
4 * This API contains methods that will try to copy over values from OLD record for all NULL columns found in
5 * business object Sub Operation Resource record.It will also default in values either by retrieving
6 * them from the database, or by having the program assign values.
7 * @rep:scope private
8 * @rep:product BOM
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:displayname Sub Operation Resource Defaulting
12 */
13
14 /****************************************************************************
15 --
16 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
17 -- All rights reserved.
18 --
19 -- FILENAME
20 --
21 -- BOMDSORS.pls
22 --
23 -- DESCRIPTION
24 --
25 -- Spec of package BOM_Default_Sub_Op_Res
26 --
27 -- NOTES
28 --
29 -- HISTORY
30 -- 22-AUG-2000 Masanori Kimizuka Initial Creation
31 --
32 ****************************************************************************/
33
34
35 /****************************************************************************
36 * ATTRIBUTE DEFAULTING
37 *****************************************************************************/
38 /*#
39 * This method as used by routing BO will try to default in values,for all NULL columns found in business object Sub Operation Resource
40 * record of type Bom_Rtg_Pub.Sub_Resource_Rec_Type either by retrieving them from the database, or by having the program
41 * assign values.For CREATEs, there is no OLD record. So the program must default
42 * in individual attribute values,independently of each other. This
43 * feature enables the user to enter minimal information for the
44 * operation to go through
45 * @param p_sub_resource_rec IN Sub Operation Resource Exposed Column Record
46 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
47 * @param p_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
48 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
49 * @param x_sub_resource_rec IN OUT NOCOPY processed Sub Operation Resource Exposed Column Record
50 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
51 * @param x_sub_res_unexp_rec IN OUT NOCOPY processed Sub Operation Resource Unexposed Column Record
52 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
53 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
54 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
55 * @param x_return_status IN OUT NOCOPY Return Status
56 * @rep:scope private
57 * @rep:displayname Operation Resource-Attribute Defaulting
58 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
59 * @rep:lifecycle active
60 */
61
62 --
63 -- Attribute Defualting for Rtg Sub Operation Resource Record
64 -- used by Rtg BO
65 --
66 PROCEDURE Attribute_Defaulting
67 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
68 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
69 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
70 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
71 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
72 , x_return_status IN OUT NOCOPY VARCHAR2
73 ) ;
74
75
76 --
77 -- Attribute Defaulting for Reviesed Sub Operation Resource Record
78 -- used by Eco BO
79 --
80 /*#
81 * This method as used by ECO BO will try to default in values,for all NULL columns found in business object Sub Operation Resource
82 * record of type Bom_Rtg_Pub.Sub_Resource_Rec_Type either by retrieving them from the database, or by having the program
83 * assign values.For CREATEs, there is no OLD record. So the program must default
84 * in individual attribute values,independently of each other. This
85 * feature enables the user to enter minimal information for the
86 * operation to go through
87 * @param p_rev_sub_resource_rec IN Sub Operation Resource Exposed Column Record
88 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
89 * @param p_rev_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
90 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
91 * @param p_control_Rec IN Control Record
92 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
93 * @param x_rev_sub_resource_rec IN OUT NOCOPY processed Sub Operation Resource Exposed Column Record
94 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
95 * @param x_rev_sub_res_unexp_rec IN OUT NOCOPY processed Sub Operation Resource Unexposed Column Record
96 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
97 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
98 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
99 * @param x_return_status IN OUT NOCOPY Return Status
100 * @rep:scope private
101 * @rep:displayname Operation Resource-Attribute Defaulting
102 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
103 * @rep:lifecycle active
104 */
105
106 PROCEDURE Attribute_Defaulting
107 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
108 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
109 , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
110 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
111 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
112 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
113 , x_return_status IN OUT NOCOPY VARCHAR2
114 ) ;
115
116
117 /****************************************************************************
118 * POPULATE NULL COLUMNS
119 *****************************************************************************/
120 /*#
121 * This method as used by Routing BO will copy over values from OLD record for all NULL columns found in
122 * business object Operation Resource record of type Bom_Bo_Pub.Sub_Resource_Rec_Type.
123 * The user may send in a record with certain values set to NULL. Values for all such
124 * columns are copied over from the OLD record. This feature enables the user to enter
125 * minimal information for the operation.
126 * @param p_sub_resource_rec IN Sub Operation Resource Exposed Column Record
127 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
128 * @param p_old_sub_resource_rec IN Sub Operation Resource Old Record Exposed Column Record
129 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
130 * @param p_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
131 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Typee}
132 * @param p_old_sub_res_unexp_rec IN Sub Operation Resource Old Record Unexposed Column Record
133 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Typee}
134 * @param x_sub_resource_rec IN OUT NOCOPY processed Sub Operation Resource Exposed Column Record
135 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
136 * @param x_sub_res_unexp_rec IN OUT NOCOPY processed Sub Operation Resource Column Record
137 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
138 * @rep:scope private
139 * @rep:compatibility S
140 * @rep:displayname Opeartion Resource-Populate NULL Columns
141 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
142 * @rep:lifecycle active
143 */
144 --
145 -- Populate NULL Columns for Rtg Sub Operation Resource Record
146 -- used by Rtg BO
147 --
148 PROCEDURE Populate_Null_Columns
149 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
150 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
151 , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
152 , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
153 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
154 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
155 ) ;
156
157 --
158 -- Populate NULL columns for Reviesed Sub Operation Resource Record
159 -- used by Eco BO
160 --
161 /*#
162 * This method as used by ECO BO will copy over values from OLD record for all NULL columns found in
163 * business object Operation Resource record of type Bom_Bo_Pub.Sub_Resource_Rec_Type.
164 * The user may send in a record with certain values set to NULL. Values for all such
165 * columns are copied over from the OLD record. This feature enables the user to enter
166 * minimal information for the operation.
167 * @param p_rev_sub_resource_rec IN Sub Operation Resource Exposed Column Record
168 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
169 * @param p_old_rev_sub_resource_rec IN Sub Operation Resource Old Record Exposed Column Record
170 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
171 * @param p_rev_sub_res_unexp_rec IN Sub Operation Resource Unexposed Column Record
172 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Typee}
173 * @param p_old_rev_sub_res_unexp_rec IN Sub Operation Resource Old Record Unexposed Column Record
174 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Typee}
175 * @param x_rev_sub_resource_rec IN OUT NOCOPY processed Sub Operation Resource Exposed Column Record
176 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
177 * @param x_rev_sub_res_unexp_rec IN OUT NOCOPY processed Sub Operation Resource Column Record
178 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
179 * @rep:scope private
180 * @rep:compatibility S
181 * @rep:displayname Opeartion Resource-Populate NULL Columns
182 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
183 * @rep:lifecycle active
184 */
185
186 PROCEDURE Populate_Null_Columns
187 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
188 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
189 , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
190 , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
191 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
192 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
193 ) ;
194
195
196 /****************************************************************************
197 * ENTITY LEVEL DEFAULTING
198 *****************************************************************************/
199 /*#
200 * This method as used by routing BO will perform checks against Sub Opearion Resource record in the order
201 * Non-updateable columns (UPDATEs) Certain columns must not be changed by the user when updating the record.
202 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it.
203 * Business logic: The record must comply with business logic rules.
204 * @param p_sub_resource_rec IN Sub Opearion Resource Exposed Column Record
205 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
206 * @param p_sub_res_unexp_rec IN Sub Opearion Resource Unexposed Column Record
207 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
208 * @param x_sub_resource_rec IN OUT NOCOPY processed Sub Opearion Resource Exposed Column Record
209 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Resource_Rec_Type}
210 * @param x_sub_res_unexp_rec IN OUT NOCOPY processed Sub Opearion Resource Unexposed Column Record
211 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type}
212 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
213 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
214 * @param x_return_status IN OUT NOCOPY Return Status
215 * @rep:scope private
216 * @rep:compatibility S
217 * @rep:displayname Opearion Resource-Entity Defaulting
218 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
219 * @rep:lifecycle active
220 */
221 --
222 -- Entity Level Defaulting Rtg Sub Operation Resource Record
223 -- used by Rtg BO
224 --
225 PROCEDURE Entity_Defaulting
226 ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
227 , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
228 , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
229 , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
230 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
231 , x_return_status IN OUT NOCOPY VARCHAR2
232 ) ;
233
234
235 --
236 -- Entity Level Defaulting for Reviesed Operation Resource Record
237 -- used by Eco BO
238 --
239 /*#
240 * This method as used by ECO BO will perform checks against Sub Opearion Resource record in the order
241 * Non-updateable columns (UPDATEs) Certain columns must not be changed by the user when updating the record.
242 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it.
243 * Business logic: The record must comply with business logic rules.
244 * @param p_rev_sub_resource_rec IN Sub Opearion Resource Exposed Column Record
245 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
246 * @param p_rev_sub_res_unexp_rec IN Sub Opearion Resource Unexposed Column Record
247 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
248 * @param p_control_Rec IN Control Record
249 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Control_Rec_Type}
250 * @param x_rev_sub_resource_rec IN OUT NOCOPY processed Sub Opearion Resource Exposed Column Record
251 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type}
252 * @param x_rev_sub_res_unexp_rec IN OUT NOCOPY processed Sub Opearion Resource Unexposed Column Record
253 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type}
254 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
255 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
256 * @param x_return_status IN OUT NOCOPY Return Status
257 * @rep:scope private
258 * @rep:compatibility S
259 * @rep:displayname Opearion Resource-Entity Defaulting
260 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
261 * @rep:lifecycle active
262 */
263
264 PROCEDURE Entity_Defaulting
265 ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
266 , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
267 , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
268 , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
269 , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
270 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271 , x_return_status IN OUT NOCOPY VARCHAR2
272 ) ;
273
274
275
276 END BOM_Default_Sub_Op_Res ;