[Home] [Help]
PACKAGE: APPS.OE_CONFIG_UTIL
Source
1 PACKAGE OE_CONFIG_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUCFGS.pls 120.4 2011/02/24 10:29:39 snimmaga ship $ */
3
4 -- Constants
5 G_ENTITY_CONTRACT CONSTANT VARCHAR2(30) := 'CONTRACT';
6 OE_BMX_ITEM_OP_SEQ CONSTANT NUMBER := 2;
7 OE_BMX_ENG CONSTANT NUMBER := 2;
8 OE_BMX_IMPLEMENTED_ONLY CONSTANT NUMBER := 1;
9 OE_BMX_CURRENT CONSTANT NUMBER := 2;
10 -- OE version of exploder
11 OE_BMX_ORDER_ENTRY_MODULE CONSTANT NUMBER := 3;
12 -- included items only
13 OE_BMX_STD_COMPS_ONLY CONSTANT VARCHAR2(30) := 'INCLUDED';
14 -- all components
15 OE_BMX_ALL_COMPS CONSTANT VARCHAR2(30) := 'ALL';
16 -- orderable components only
17 OE_BMX_OPTION_COMPS CONSTANT VARCHAR2(30) := 'OPTIONAL';
18 -- maximum number of levels
19 OE_BMX_MAX_LEVELS CONSTANT NUMBER := 60;
20
21 -- flag to avoid recursion of cascading.
22 CASCADE_CHANGES_FLAG VARCHAR2(1) := 'N';
23 G_UPGRADED_FLAG VARCHAR2(1) := 'N';
24 -- if user used configurator or options window, this will be set.
25 G_CONFIG_UI_USED VARCHAR2(1) := 'N';
26
27 /* Bug # 5036404 Start */
28 -- Retreive the profile values
29 G_FREEZE_METHOD VARCHAR2(30) := FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD');
30 G_COPY_MODEL_DFF VARCHAR2(30) := nvl(FND_PROFILE.VALUE('ONT_COPY_MODEL_DFF'),'N');
31 /* Bug # 5036404 End */
32
33 FUNCTION Config_Exists(p_line_rec IN OE_ORDER_PUB.line_rec_type)
34 RETURN BOOLEAN;
35
36 Procedure Complete_Config
37 ( p_top_model_line_id IN NUMBER
38 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
39
40 Procedure Cascade_Changes
41 ( p_parent_line_id IN NUMBER,
42 p_request_rec IN OE_Order_Pub.Request_Rec_Type,
43 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 );
45
46
47 Procedure Change_Configuration
48 ( p_request_rec IN OE_Order_Pub.Request_Rec_Type,
49 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 );
51
52 Procedure Query_Config_Line
53 (p_parent_line_id IN NUMBER
54 ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type);
55
56 FUNCTION Validate_Cfgs_In_Order(p_header_id IN NUMBER)
57 RETURN VARCHAR2;
58
59 PROCEDURE Validate_Configuration
60 (p_model_line_id IN NUMBER,
61 p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
62 := OE_Order_Pub.G_MISS_REQUEST_TBL,
63 p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
64 := OE_Order_Pub.G_MISS_REQUEST_TBL,
65 p_validate_flag IN VARCHAR2 := 'Y',
66 p_complete_flag IN VARCHAR2 := 'Y',
67 p_caller IN VARCHAR2 := '',
68 x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69 x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
71
72 Procedure Match_And_Reserve
73 ( p_line_id IN NUMBER
74 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
75
76 Procedure Delink_Config
77 ( p_line_id IN NUMBER
78 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
79
80 PROCEDURE Delink_Config_batch
81 ( p_line_id IN NUMBER
82 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
83
84 Procedure Link_Config
85 ( p_line_id IN NUMBER
86 , p_config_item_id IN NUMBER
87 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
88
89
90 Procedure Query_Options
91 (p_top_model_line_id IN NUMBER
92 ,p_send_cancel_lines IN VARCHAR2 := 'N'
93 ,p_source_type IN VARCHAR2 := ''
94 ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
95
96 Procedure Query_ATO_Options
97 (p_ato_line_id IN NUMBER
98 ,p_send_cancel_lines IN VARCHAR2 := 'N'
99 ,p_source_type IN VARCHAR2 := ''
100 ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
101
102 FUNCTION Freeze_Inc_Items_for_Order(p_header_id IN NUMBER)
103 RETURN VARCHAR2;
104
105 FUNCTION Freeze_Included_Items(p_line_id IN NUMBER)
106 RETURN VARCHAR2;
107
108 FUNCTION Process_Included_Items
109 (p_line_rec IN OE_ORDER_PUB.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC,
110 p_line_id IN NUMBER := FND_API.G_MISS_NUM,
111 p_freeze IN BOOLEAN,
112 p_process_requests IN BOOLEAN DEFAULT FALSE)
113 RETURN VARCHAR2;
114
115 Procedure Query_Included_Items
116 ( p_line_id IN NUMBER
117 , p_header_id IN NUMBER := FND_API.G_MISS_NUM
118 , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
119 , p_send_cancel_lines IN VARCHAR2 := 'N'
120 , p_source_type IN VARCHAR2 := ''
121 , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
122
123
124 Procedure Explode
125 ( p_validation_org IN NUMBER
126 , p_group_id IN NUMBER := NULL
127 , p_session_id IN NUMBER := NULL
128 , p_levels IN NUMBER := 60
129 , p_stdcompflag IN VARCHAR2
130 , p_exp_quantity IN NUMBER := NULL
131 , p_top_item_id IN NUMBER
132 , p_revdate IN DATE
133 , p_component_code IN VARCHAR2 := NULL
134 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , x_error_code OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
137
138
139 PROCEDURE Supply_Reserved (
140 p_application_id IN NUMBER,
141 p_entity_short_name IN VARCHAR2,
142 p_validation_entity_short_name IN VARCHAR2,
143 p_validation_tmplt_short_name IN VARCHAR2,
144 p_record_set_short_name IN VARCHAR2,
145 p_scope IN VARCHAR2,
146 x_result OUT NOCOPY /* file.sql.39 change */ NUMBER);
147
148
149 PROCEDURE Validate_Configuration_upg
150 (p_model_line_id IN NUMBER,
151 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
152
153
154 FUNCTION Is_ATO_Model
155 (p_line_id IN NUMBER
156 := FND_API.G_MISS_NUM ,
157 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
158 := OE_ORDER_PUB.G_MISS_LINE_REC)
159 RETURN BOOLEAN;
160
161 FUNCTION Is_PTO_Model
162 (p_line_id IN NUMBER
163 := FND_API.G_MISS_NUM ,
164 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
165 := OE_ORDER_PUB.G_MISS_LINE_REC)
166 RETURN BOOLEAN;
167
168 FUNCTION Is_Included_Option
169 (p_line_id IN NUMBER
170 := FND_API.G_MISS_NUM ,
171 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
172 := OE_ORDER_PUB.G_MISS_LINE_REC)
173 RETURN BOOLEAN;
174
175 FUNCTION Is_Config_Item
176 (p_line_id IN NUMBER
177 := FND_API.G_MISS_NUM ,
178 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
179 := OE_ORDER_PUB.G_MISS_LINE_REC)
180 RETURN BOOLEAN;
181
182 FUNCTION Is_ATO_Option
183 (p_line_id IN NUMBER
184 := FND_API.G_MISS_NUM ,
185 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
186 := OE_ORDER_PUB.G_MISS_LINE_REC)
187 RETURN BOOLEAN;
188
189 FUNCTION Is_PTO_Option
190 (p_line_id IN NUMBER
191 := FND_API.G_MISS_NUM ,
192 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
193 := OE_ORDER_PUB.G_MISS_LINE_REC)
194 RETURN BOOLEAN;
195
196 FUNCTION Is_ATO_Class
197 (p_line_id IN NUMBER
198 := FND_API.G_MISS_NUM ,
199 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
200 := OE_ORDER_PUB.G_MISS_LINE_REC)
201 RETURN BOOLEAN;
202
203 FUNCTION Is_PTO_Class
204 (p_line_id IN NUMBER
205 := FND_API.G_MISS_NUM ,
206 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
207 := OE_ORDER_PUB.G_MISS_LINE_REC)
208 RETURN BOOLEAN;
209
210 FUNCTION Is_ATO_Subconfig
211 (p_line_id IN NUMBER
212 := FND_API.G_MISS_NUM ,
213 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
214 := OE_ORDER_PUB.G_MISS_LINE_REC)
215 RETURN BOOLEAN;
216
217 FUNCTION Is_Kit
218 (p_line_id IN NUMBER
219 := FND_API.G_MISS_NUM ,
220 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
221 := OE_ORDER_PUB.G_MISS_LINE_REC)
222 RETURN BOOLEAN;
223
224 FUNCTION Is_ATO_Item
225 (p_line_id IN NUMBER
226 := FND_API.G_MISS_NUM ,
227 p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
228 := OE_ORDER_PUB.G_MISS_LINE_REC)
229 RETURN BOOLEAN;
230
231 PROCEDURE Part_of_Configuration
232 ( p_application_id IN NUMBER,
233 p_entity_short_name IN VARCHAR2,
234 p_validation_entity_short_name IN VARCHAR2,
235 p_validation_tmplt_short_name IN VARCHAR2,
236 p_record_set_short_name IN VARCHAR2,
237 p_scope IN VARCHAR2,
238 x_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
239
240 PROCEDURE Update_Comp_Seq_Id
241 ( p_line_id IN NUMBER
242 ,p_comp_seq_id IN NUMBER
243 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
244
245 PROCEDURE Update_Visible_Demand_Flag
246 ( p_ato_line_id IN NUMBER
247 ,p_visible_demand_flag IN VARCHAR2 := 'N'
248 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
249
250 PROCEDURE Update_Mfg_Comp_Seq_Id
251 ( p_ato_line_id IN NUMBER
252 ,p_mfg_comp_seq_id IN NUMBER
253 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
254
255 PROCEDURE Update_Model_Group_Number
256 ( p_ato_line_id IN NUMBER
257 ,p_model_group_number IN NUMBER
258 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
259
260 PROCEDURE Update_Cto_Columns
261 ( p_ato_line_id IN NUMBER
262 ,p_request_id IN NUMBER
263 ,p_program_id IN NUMBER
264 ,p_prog_update_date IN DATE
265 ,p_prog_appl_id IN NUMBER
266 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
267
268 PROCEDURE Cascade_Updates_Deletes
269 ( p_model_line_id IN NUMBER
270 ,p_model_component IN VARCHAR2
271 ,p_x_options_tbl IN OUT NOCOPY
272 Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
273 ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
274 := OE_Order_Pub.G_MISS_REQUEST_TBL
275 ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
276 := OE_Order_Pub.G_MISS_REQUEST_TBL
277 ,p_ui_flag IN VARCHAR2 := 'N'
278 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
279
280 PROCEDURE Notify_CTO
281 ( p_ato_line_id IN NUMBER
282 ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283 := OE_Order_Pub.G_MISS_REQUEST_REC
284 ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285 := OE_Order_Pub.G_MISS_REQUEST_TBL
286 ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287 := OE_Order_Pub.G_MISS_REQUEST_TBL
288 ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289 := OE_Order_Pub.G_MISS_REQUEST_TBL
290 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
291
292
293 PROCEDURE Decimal_Ratio_Check
294 ( p_top_model_line_id IN NUMBER
295 ,p_component_code IN VARCHAR2
296 ,p_ratio IN NUMBER);
297
298
299 PROCEDURE Default_Child_Line
300 ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
301 ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
302 ,p_direct_save IN BOOLEAN := FALSE
303 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
304
305
306 --##1922440 bug fix.
307 PROCEDURE Is_Included_Item_Constrained
308 ( p_application_id IN NUMBER,
309 p_entity_short_name IN VARCHAR2,
310 p_validation_entity_short_name IN VARCHAR2,
311 p_validation_tmplt_short_name IN VARCHAR2,
312 p_record_set_short_name IN VARCHAR2,
313 p_scope IN VARCHAR2,
314 x_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
315
316
317 PROCEDURE ATO_Remnant_Check
318 ( p_application_id IN NUMBER,
319 p_entity_short_name IN VARCHAR2,
320 p_validation_entity_short_name IN VARCHAR2,
321 p_validation_tmplt_short_name IN VARCHAR2,
322 p_record_set_short_name IN VARCHAR2,
323 p_scope IN VARCHAR2,
324 x_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
325
326
327 PROCEDURE Launch_Supply_Workbench
328 ( p_header_id IN NUMBER
329 ,p_top_model_line_id IN NUMBER
330 ,p_ato_line_id IN NUMBER
331 ,p_line_id IN NUMBER
332 ,p_item_type_code IN VARCHAR2
333 ,x_wb_item_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
334 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
335
336
337 PROCEDURE Get_Config_Effective_Date
338 ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null
339 ,p_model_line_id IN NUMBER := null
340 ,x_old_behavior OUT NOCOPY VARCHAR2
341 ,x_config_effective_date OUT NOCOPY DATE
342 ,x_frozen_model_bill OUT NOCOPY VARCHAR2);
343
344 PROCEDURE Create_hdr_xml
345 ( p_model_line_id IN NUMBER ,
346 p_ui_flag IN VARCHAR2 := 'N',
347 x_xml_hdr OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
348
349 PROCEDURE Send_input_xml
350 ( p_model_line_id IN NUMBER ,
351 p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
352 := OE_Order_Pub.G_MISS_REQUEST_TBL,
353 p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
354 := OE_Order_Pub.G_MISS_REQUEST_TBL,
355 p_model_qty IN NUMBER,
356 p_xml_hdr IN VARCHAR2 := NULL,
357 x_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
358 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
359
360 PROCEDURE parse_output_xml
361 ( p_xml IN LONG,
362 p_line_id IN NUMBER,
363 x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364 x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
365 x_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
366 x_config_rev_nbr OUT NOCOPY /* file.sql.39 change */ NUMBER,
367 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
368
369 -- Added for DOO Pre Exploded Kit ER 9339742
370 PROCEDURE Process_Pre_Exploded_Kits
371 ( p_top_model_line_id IN NUMBER
372 , p_explosion_date IN DATE
373 , x_return_status OUT NOCOPY VARCHAR2);
374
375 END OE_CONFIG_UTIL;