[Home] [Help]
PACKAGE BODY: APPS.ASO_CONFIG_OPERATIONS_INT_W
Source
1 PACKAGE BODY ASO_Config_Operations_Int_W as
2 /* $Header: asovqwcb.pls 120.2 2005/10/03 15:39:00 skulkarn ship $ */
3 -- Start of Comments
4 -- Package name : ASO_CONFIG_OPERATIONS_INT_W
5 -- Purpose : Rosetta wrappers for ASO Config Operations Public API
6 -- History : Created on 09/12/02
7 -- NOTE :
8 -- END of Comments
9 ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
10 ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
11
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CONFIG_OPERATIONS_INT_W';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQWCB.PLS';
14
15 FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16 a number := fnd_api.g_miss_num;
17 b number := 0-1962.0724;
18 BEGIN
19 IF n=a THEN RETURN b; END IF;
20 IF n=b THEN RETURN a; END IF;
21 RETURN n;
22 END;
23
24 PROCEDURE Is_Container
25 (p_api_version IN NUMBER := 1 ,
26 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27 p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32 p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33 p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34 p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
35 x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
36 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
37 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
38 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 ) AS
40 l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
41 l_api_name CONSTANT VARCHAR2(30) := 'is_container';
42
43 BEGIN
44 Aso_Quote_Util_Pvt.Enable_Debug_Pvt;
45 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Is_Container BEGIN');
46
47 Aso_Quote_Util_Pvt.debug('Construct appl param record');
48 Aso_Quote_Util_Pvt.debug('calling appln id '||p_ap_calling_application_id);
49 l_appl_param_rec := Construct_Appl_Param_Rec(
50 p_ap_config_creation_date => p_ap_config_creation_date,
51 p_ap_config_model_lookup_date => p_ap_config_model_lookup_date,
52 p_ap_config_effective_date => p_ap_config_effective_date,
53 p_ap_calling_application_id => p_ap_calling_application_id,
54 p_ap_usage_name => p_ap_usage_name,
55 p_ap_publication_mode => p_ap_publication_mode,
56 p_ap_language => p_ap_language
57 );
58
59 Aso_Quote_Util_Pvt.debug('Call TO CZ_NETWORK_API_PUB.Is_Container ');
60 CZ_NETWORK_API_PUB.Is_Container(p_api_version => 1.0,
61 p_inventory_item_id => p_inventory_item_id,
62 p_organization_id => p_organization_id,
63 p_appl_param_rec => l_appl_param_rec,
64 x_return_value => x_return_value,
65 x_return_status => x_return_status,
66 x_msg_count => x_msg_count,
67 x_msg_data => x_msg_data
68 );
69
70 Aso_Quote_Util_Pvt.debug('X_Return_value from ASO '||x_return_value);
71 Aso_Quote_Util_Pvt.debug('X_Return_Status from Is_Container '||X_Return_Status);
72 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Is_Container END');
73 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
74
75 EXCEPTION
76 WHEN FND_API.G_EXC_ERROR
77 THEN
78 x_return_status := FND_API.G_RET_STS_ERROR;
79 FND_MSG_PUB.Count_And_Get(
80 p_encoded => FND_API.G_FALSE,
81 p_count => x_msg_count,
82 p_data => x_msg_data
83 );
84 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
85
86 WHEN FND_API.G_EXC_UNEXPECTED_ERROR
87 THEN
88 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89 FND_MSG_PUB.Count_And_Get(
90 p_encoded => FND_API.G_FALSE,
91 p_count => x_msg_count,
92 p_data => x_msg_data
93 );
94 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
95 WHEN OTHERS THEN
96 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
98 THEN
99 FND_MSG_PUB.Add_Exc_Msg(
100 G_PKG_NAME,
101 l_api_name
102 );
103 END IF;
104 FND_MSG_PUB.Count_And_Get(
105 p_encoded => FND_API.G_FALSE,
106 p_count => x_msg_count,
107 p_data => x_msg_data
108 );
109 ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
110 END Is_Container;
111
112 PROCEDURE Get_Contained_Models
113 (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
114 p_api_version IN NUMBER := 1 ,
115 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116 p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121 p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122 p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123 p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
124 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
125 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
126 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 )
128 AS
129 l_api_name CONSTANT VARCHAR2(30) := 'get_contained_models';
130 l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
131 lx_model_tbl CZ_API_PUB.number_tbl_type;
132 indx1 BINARY_INTEGER; indx2 BINARY_INTEGER;
133 BEGIN
134 Aso_Quote_Util_Pvt.Enable_Debug_Pvt;
135 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Get_Contained_Models BEGIN');
136 x_model_tbl := jtf_number_table();
137
138 Aso_Quote_Util_Pvt.debug('Construct appl param record');
139 Aso_Quote_Util_Pvt.debug('calling appln id '||p_ap_calling_application_id);
140 l_appl_param_rec := Construct_Appl_Param_Rec(
141 p_ap_config_creation_date => p_ap_config_creation_date,
142 p_ap_config_model_lookup_date => p_ap_config_model_lookup_date,
143 p_ap_config_effective_date => p_ap_config_effective_date,
144 p_ap_calling_application_id => p_ap_calling_application_id,
145 p_ap_usage_name => p_ap_usage_name,
146 p_ap_publication_mode => p_ap_publication_mode,
147 p_ap_language => p_ap_language
148 );
149
150 Aso_Quote_Util_Pvt.debug('Call to CZ_NETWORK_API_PUB.Get_Contained_Models ');
151 CZ_NETWORK_API_PUB.Get_Contained_Models(
152 p_api_version => 1.0,
153 p_inventory_item_id => p_inventory_item_id,
154 p_organization_id => p_organization_id,
155 p_appl_param_rec => l_appl_param_rec,
156 x_model_tbl => lx_model_tbl,
157 x_return_status => x_return_status,
158 x_msg_count => x_msg_count,
159 x_msg_data => x_msg_data
160 );
161 Aso_Quote_Util_Pvt.debug('return CZ_NETWORK_API_PUB.Get_Contained_Models '||X_Return_Status);
162 IF lx_model_tbl.COUNT > 0 THEN
163 x_model_tbl.extend(lx_model_tbl.COUNT);
164
165 indx1 := lx_model_tbl.first;
166 indx2 := 1;
167 WHILE TRUE LOOP
168 x_model_tbl(indx2) := rosetta_g_miss_num_map(lx_model_tbl(indx1));
169 indx2 := indx2 + 1;
170 IF lx_model_tbl.last = indx1
171 THEN EXIT;
172 END IF;
173 indx1 := lx_model_tbl.NEXT(indx1);
174 END LOOP;
175 END IF;
176
177 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Get_Contained_Models END');
178 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
179 EXCEPTION
180 WHEN FND_API.G_EXC_ERROR
181 THEN
182 x_return_status := FND_API.G_RET_STS_ERROR;
183 FND_MSG_PUB.Count_And_Get(
184 p_encoded => FND_API.G_FALSE,
185 p_count => x_msg_count,
186 p_data => x_msg_data
187 );
188 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
189 WHEN FND_API.G_EXC_UNEXPECTED_ERROR
190 THEN
191 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192 FND_MSG_PUB.Count_And_Get(
193 p_encoded => FND_API.G_FALSE,
194 p_count => x_msg_count,
195 p_data => x_msg_data
196 );
197 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
198 WHEN OTHERS THEN
199 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201 THEN
202 FND_MSG_PUB.Add_Exc_Msg(
203 G_PKG_NAME,
204 l_api_name
205 );
206 END IF;
207 FND_MSG_PUB.Count_And_Get(
208 p_encoded => FND_API.G_FALSE,
209 p_count => x_msg_count,
210 p_data => x_msg_data
211 );
212 ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
213 END Get_Contained_Models;
214
215 PROCEDURE Config_Operations
216 (x_q_quote_header_id OUT NOCOPY NUMBER,
217 x_q_last_update_date OUT NOCOPY DATE,
218 x_q_object_version_number OUT NOCOPY NUMBER,
219 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227 p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228 p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229 p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230 p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231 p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232 p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233 p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234 p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235 p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360 p_ql_creation_date IN jtf_date_table := NULL,
361 p_ql_created_by IN jtf_number_table := NULL,
362 p_ql_last_updated_by IN jtf_number_table := NULL,
363 p_ql_last_update_date IN jtf_date_table := NULL,
364 p_ql_last_update_login IN jtf_number_table := NULL,
365 p_ql_request_id IN jtf_number_table := NULL,
366 p_ql_program_application_id IN jtf_number_table := NULL,
367 p_ql_program_id IN jtf_number_table := NULL,
368 p_ql_program_update_date IN jtf_date_table := NULL,
369 p_ql_quote_line_id IN jtf_number_table := NULL,
370 p_ql_quote_header_id IN jtf_number_table := NULL,
371 p_ql_org_id IN jtf_number_table := NULL,
372 p_ql_line_number IN jtf_number_table := NULL,
373 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
374 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
375 p_ql_inventory_item_id IN jtf_number_table := NULL,
376 p_ql_organization_id IN jtf_number_table := NULL,
377 p_ql_quantity IN jtf_number_table := NULL,
378 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
379 p_ql_start_date_active IN jtf_date_table := NULL,
380 p_ql_end_date_active IN jtf_date_table := NULL,
381 p_ql_order_line_type_id IN jtf_number_table := NULL,
382 p_ql_price_list_id IN jtf_number_table := NULL,
383 p_ql_price_list_line_id IN jtf_number_table := NULL,
384 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
385 p_ql_line_list_price IN jtf_number_table := NULL,
386 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
387 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
388 p_ql_line_quote_price IN jtf_number_table := NULL,
389 p_ql_related_item_id IN jtf_number_table := NULL,
390 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
391 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
392 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
393 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
394 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
395 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
396 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
397 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
398 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
399 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
400 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
401 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
402 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
403 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
404 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
405 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
406 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
407 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
408 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
409 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
410 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
411 p_ql_accounting_rule_id IN jtf_number_table := NULL,
412 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
413 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
414 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
415 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
416 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
417 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
418 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
419 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
420 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
421 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
422 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
423 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
424 p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
425 p_ql_minisite_id IN jtf_number_table := NULL,
426 p_ql_section_id IN jtf_number_table := NULL,
427 p_ql_priced_price_list_id IN jtf_number_table := NULL,
428 p_ql_agreement_id IN jtf_number_table := NULL,
429 p_ql_commitment_id IN jtf_number_table := NULL,
430 p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
431 p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
432 p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
433 p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
434 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
435 p_api_version_number IN NUMBER := 1 ,
436 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
437 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
438 p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
439 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
440 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
441 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442 )
443 AS
444 l_api_name CONSTANT VARCHAR2(30) := 'config_operations';
445 l_control_rec Aso_Quote_Pub.Control_Rec_Type
446 := Aso_Quote_Pub.G_MISS_Control_Rec;
447 l_qte_header_rec Aso_Quote_Pub.Qte_Header_Rec_Type
448 := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
449 l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
450 := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
451 l_qte_line_tbl Aso_Quote_Pub.Qte_Line_Tbl_Type
452 := Aso_Quote_Pub.G_MISS_Qte_Line_Tbl;
453
454 x_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;
455
456 BEGIN
457 Aso_Quote_Util_Pvt.Enable_Debug_Pvt;
458 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Config_Operations BEGIN');
459
460 Aso_Quote_Util_Pvt.Set_Control_Rec_W(
461 p_last_update_date => p_c_last_update_date,
462 p_auto_version_flag => p_c_auto_version_flag,
463 p_pricing_request_type => p_c_pricing_request_type,
464 p_header_pricing_event => p_c_header_pricing_event,
465 p_line_pricing_event => p_c_line_pricing_event,
466 p_cal_tax_flag => p_c_cal_tax_flag,
467 p_cal_freight_charge_flag => p_c_cal_freight_charge_flag,
468 p_functionality_code => p_c_functionality_code,
469 p_copy_task_flag => p_c_copy_task_flag,
470 p_copy_notes_flag => p_c_copy_notes_flag,
471 p_copy_att_flag => p_c_copy_att_flag,
472 p_deactivate_all => p_c_deactivate_all,
473 p_price_mode => p_c_price_mode,
474 p_dependency_flag => p_c_dependency_flag,
475 p_defaulting_flag => p_c_defaulting_flag,
476 p_defaulting_fwk_flag => p_c_defaulting_fwk_flag,
477 p_application_type_code => p_c_application_type_code,
478 x_control_rec => l_control_rec);
479
480 l_qte_header_rec := Aso_Quote_Util_Pvt.Construct_Qte_Header_Rec(
481 p_quote_header_id => p_q_quote_header_id ,
482 p_creation_date => p_q_creation_date ,
483 p_created_by => p_q_created_by ,
484 p_last_updated_by => p_q_last_updated_by ,
485 p_last_update_date => p_q_last_update_date ,
486 p_last_update_login => p_q_last_update_login ,
487 p_request_id => p_q_request_id ,
488 p_program_application_id => p_q_program_application_id ,
489 p_program_id => p_q_program_id ,
490 p_program_update_date => p_q_program_update_date ,
491 p_org_id => p_q_org_id ,
492 p_quote_name => p_q_quote_name ,
493 p_quote_number => p_q_quote_number ,
494 p_quote_version => p_q_quote_version ,
495 p_quote_status_id => p_q_quote_status_id ,
496 p_quote_source_code => p_q_quote_source_code ,
497 p_quote_expiration_date => p_q_quote_expiration_date ,
498 p_price_frozen_date => p_q_price_frozen_date ,
499 p_quote_password => p_q_quote_password ,
500 p_original_system_reference => p_q_original_system_reference ,
501 p_party_id => p_q_party_id ,
502 p_cust_account_id => p_q_cust_account_id ,
503 p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
504 p_org_contact_id => p_q_org_contact_id ,
505 p_party_name => p_q_party_name ,
506 p_party_type => p_q_party_type ,
507 p_person_first_name => p_q_person_first_name ,
508 p_person_last_name => p_q_person_last_name ,
509 p_person_middle_name => p_q_person_middle_name ,
510 p_phone_id => p_q_phone_id ,
511 p_price_list_id => p_q_price_list_id ,
512 p_price_list_name => p_q_price_list_name ,
513 p_currency_code => p_q_currency_code ,
514 p_total_list_price => p_q_total_list_price ,
515 p_total_adjusted_amount => p_q_total_adjusted_amount ,
516 p_total_adjusted_percent => p_q_total_adjusted_percent ,
517 p_total_tax => p_q_total_tax ,
518 p_total_shipping_charge => p_q_total_shipping_charge ,
519 p_surcharge => p_q_surcharge ,
520 p_total_quote_price => p_q_total_quote_price ,
521 p_payment_amount => p_q_payment_amount ,
522 p_accounting_rule_id => p_q_accounting_rule_id ,
523 p_exchange_rate => p_q_exchange_rate ,
524 p_exchange_type_code => p_q_exchange_type_code ,
525 p_exchange_rate_date => p_q_exchange_rate_date ,
526 p_quote_category_code => p_q_quote_category_code ,
527 p_quote_status_code => p_q_quote_status_code ,
528 p_quote_status => p_q_quote_status ,
529 p_employee_person_id => p_q_employee_person_id ,
530 p_sales_channel_code => p_q_sales_channel_code ,
531 p_salesrep_first_name => p_q_salesrep_first_name ,
532 p_salesrep_last_name => p_q_salesrep_last_name ,
533 p_attribute_category => p_q_attribute_category ,
534 p_attribute1 => p_q_attribute1 ,
535 p_attribute10 => p_q_attribute10 ,
536 p_attribute11 => p_q_attribute11 ,
537 p_attribute12 => p_q_attribute12 ,
538 p_attribute13 => p_q_attribute13 ,
539 p_attribute14 => p_q_attribute14 ,
540 p_attribute15 => p_q_attribute15 ,
541 p_attribute2 => p_q_attribute2 ,
542 p_attribute3 => p_q_attribute3 ,
543 p_attribute4 => p_q_attribute4 ,
544 p_attribute5 => p_q_attribute5 ,
545 p_attribute6 => p_q_attribute6 ,
546 p_attribute7 => p_q_attribute7 ,
547 p_attribute8 => p_q_attribute8 ,
548 p_attribute9 => p_q_attribute9 ,
549 p_contract_id => p_q_contract_id ,
550 p_qte_contract_id => p_q_qte_contract_id ,
551 p_ffm_request_id => p_q_ffm_request_id ,
552 p_invoice_to_address1 => p_q_invoice_to_address1 ,
553 p_invoice_to_address2 => p_q_invoice_to_address2 ,
554 p_invoice_to_address3 => p_q_invoice_to_address3 ,
555 p_invoice_to_address4 => p_q_invoice_to_address4 ,
556 p_invoice_to_city => p_q_invoice_to_city ,
557 p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
558 p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
559 p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
560 p_invoice_to_country_code => p_q_invoice_to_country_code ,
561 p_invoice_to_country => p_q_invoice_to_country ,
562 p_invoice_to_county => p_q_invoice_to_county ,
563 p_invoice_to_party_id => p_q_invoice_to_party_id ,
564 p_invoice_to_party_name => p_q_invoice_to_party_name ,
565 p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
566 p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
567 p_invoice_to_province => p_q_invoice_to_province ,
568 p_invoice_to_state => p_q_invoice_to_state ,
569 p_invoicing_rule_id => p_q_invoicing_rule_id ,
570 p_marketing_source_code_id => p_q_marketing_source_code_id ,
571 p_marketing_source_code => p_q_marketing_source_code ,
572 p_marketing_source_name => p_q_marketing_source_name ,
573 p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
574 p_order_type_id => p_q_order_type_id ,
575 p_order_id => p_q_order_id ,
576 p_order_number => p_q_order_number ,
577 p_order_type_name => p_q_order_type_name ,
578 p_ordered_date => p_q_ordered_date ,
579 p_resource_id => p_q_resource_id ,
580 p_contract_template_id => p_q_contract_template_id ,
581 p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
582 p_contract_requester_id => p_q_contract_requester_id ,
583 p_contract_approval_level => p_q_contract_approval_level ,
584 p_publish_flag => p_q_publish_flag ,
585 p_resource_grp_id => p_q_resource_grp_id ,
586 p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
587 p_display_arithmetic_operator => p_q_display_arithmetic_op ,
588 p_quote_description => p_q_quote_description ,
589 p_quote_type => p_q_quote_type ,
590 p_minisite_id => p_q_minisite_id ,
591 p_cust_party_id => p_q_cust_party_id ,
592 p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
593 p_pricing_status_indicator => p_q_pricing_status_indicator ,
594 p_tax_status_indicator => p_q_tax_status_indicator ,
595 p_price_updated_date => p_q_price_updated_date ,
596 p_tax_updated_date => p_q_tax_updated_date ,
597 p_recalculate_flag => p_q_recalculate_flag ,
598 p_price_request_id => p_q_price_request_id ,
599 p_customer_name_and_title => p_q_customer_name_and_title,
600 p_customer_signature_date => p_q_customer_signature_date,
601 p_supplier_name_and_title => p_q_supplier_name_and_title,
602 p_supplier_signature_date => p_q_supplier_signature_date,
603 p_credit_update_date => p_q_credit_update_date,
604 p_object_version_number => p_q_object_version_number);
605
606 l_instance_tbl := Aso_Quote_Util_Pvt.Construct_Instance_Tbl(
607 p_instance_id => p_i_instance_id,
608 p_price_list_id => p_i_price_list_id);
609
610 l_qte_line_tbl := Aso_Quote_Util_Pvt.Construct_Qte_Line_Tbl(
611 p_creation_date => p_ql_creation_date ,
612 p_created_by => p_ql_created_by ,
613 p_last_updated_by => p_ql_last_updated_by ,
614 p_last_update_date => p_ql_last_update_date ,
615 p_last_update_login => p_ql_last_update_login ,
616 p_request_id => p_ql_request_id ,
617 p_program_application_id => p_ql_program_application_id ,
618 p_program_id => p_ql_program_id ,
619 p_program_update_date => p_ql_program_update_date ,
620 p_quote_line_id => p_ql_quote_line_id ,
621 p_quote_header_id => p_ql_quote_header_id ,
622 p_org_id => p_ql_org_id ,
623 p_line_number => p_ql_line_number ,
624 p_line_category_code => p_ql_line_category_code ,
625 p_item_type_code => p_ql_item_type_code ,
626 p_inventory_item_id => p_ql_inventory_item_id ,
627 p_organization_id => p_ql_organization_id ,
628 p_quantity => p_ql_quantity ,
629 p_uom_code => p_ql_uom_code ,
630 p_start_date_active => p_ql_start_date_active ,
631 p_end_date_active => p_ql_end_date_active ,
632 p_order_line_type_id => p_ql_order_line_type_id ,
633 p_price_list_id => p_ql_price_list_id ,
634 p_price_list_line_id => p_ql_price_list_line_id ,
635 p_currency_code => p_ql_currency_code ,
636 p_line_list_price => p_ql_line_list_price ,
637 p_line_adjusted_amount => p_ql_line_adjusted_amount ,
638 p_line_adjusted_percent => p_ql_line_adjusted_percent ,
639 p_line_quote_price => p_ql_line_quote_price ,
640 p_related_item_id => p_ql_related_item_id ,
641 p_item_relationship_type => p_ql_item_relationship_type ,
642 p_split_shipment_flag => p_ql_split_shipment_flag ,
643 p_backorder_flag => p_ql_backorder_flag ,
644 p_selling_price_change => p_ql_selling_price_change ,
645 p_recalculate_flag => p_ql_recalculate_flag ,
646 p_attribute_category => p_ql_attribute_category ,
647 p_attribute1 => p_ql_attribute1 ,
648 p_attribute2 => p_ql_attribute2 ,
649 p_attribute3 => p_ql_attribute3 ,
650 p_attribute4 => p_ql_attribute4 ,
651 p_attribute5 => p_ql_attribute5 ,
652 p_attribute6 => p_ql_attribute6 ,
653 p_attribute7 => p_ql_attribute7 ,
654 p_attribute8 => p_ql_attribute8 ,
655 p_attribute9 => p_ql_attribute9 ,
656 p_attribute10 => p_ql_attribute10 ,
657 p_attribute11 => p_ql_attribute11 ,
658 p_attribute12 => p_ql_attribute12 ,
659 p_attribute13 => p_ql_attribute13 ,
660 p_attribute14 => p_ql_attribute14 ,
661 p_attribute15 => p_ql_attribute15 ,
662 p_accounting_rule_id => p_ql_accounting_rule_id ,
663 p_ffm_content_name => p_ql_ffm_content_name ,
664 p_ffm_content_type => p_ql_ffm_content_type ,
665 p_ffm_document_type => p_ql_ffm_document_type ,
666 p_ffm_media_id => p_ql_ffm_media_id ,
667 p_ffm_media_type => p_ql_ffm_media_type ,
668 p_ffm_user_note => p_ql_ffm_user_note ,
669 p_invoice_to_party_id => p_ql_invoice_to_party_id ,
670 p_invoice_to_party_site_id => p_ql_invoice_to_party_site_id,
671 p_invoicing_rule_id => p_ql_invoicing_rule_id ,
672 p_marketing_source_code_id => p_ql_marketing_source_code_id,
673 p_operation_code => p_ql_operation_code ,
674 p_invoice_to_cust_account_id => p_ql_invoice_to_cust_acct_id,
675 p_pricing_quantity_uom => p_ql_pricing_quantity_uom ,
676 p_minisite_id => p_ql_minisite_id ,
677 p_section_id => p_ql_section_id ,
678 p_priced_price_list_id => p_ql_priced_price_list_id ,
679 p_agreement_id => p_ql_agreement_id ,
680 p_commitment_id => p_ql_commitment_id ,
681 p_display_arithmetic_operator => p_ql_display_arithmetic_op,
682 p_invoice_to_cust_party_id => p_ql_invoice_to_cust_party_id);
683
684
685 Aso_Quote_Util_Pvt.debug('Call TO Aso_Config_Operations_Int.Config_Operations ');
686
687 Aso_Config_Operations_Int.Config_Operations(
688 p_api_version_number => p_api_version_number,
689 p_init_msg_list => p_init_msg_list,
690 p_commit => p_commit,
691 p_validation_level => p_validation_level,
692 p_control_rec => l_control_rec,
693 p_qte_header_rec => l_qte_header_rec,
694 p_qte_line_tbl => l_qte_line_tbl,
695 p_instance_tbl => l_instance_tbl,
696 p_operation_code => p_operation_code,
697 x_Qte_Header_Rec => x_Qte_Header_Rec,
698 x_return_status => x_return_status,
699 x_msg_count => x_msg_count,
700 x_msg_data => x_msg_data);
701
702
703 x_q_quote_header_id := rosetta_g_miss_num_map(x_Qte_Header_Rec.quote_header_id);
704 x_q_last_update_date := x_Qte_Header_Rec.last_update_date;
705 x_q_object_version_number := x_Qte_Header_Rec.object_version_number;
706
707
708 ASO_QUOTE_UTIL_PVT.debug('Quote Hdr Id '|| x_q_quote_header_id);
709 ASO_QUOTE_UTIL_PVT.debug('Quote last updt DATE '|| x_q_last_update_date);
710 Aso_Quote_Util_Pvt.debug('return Aso_Config_Operations_Int.Config_Operations '||X_Return_Status);
711 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Config_Operations END');
712 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
713
714 EXCEPTION
715 WHEN FND_API.G_EXC_ERROR
716 THEN
717 x_return_status := FND_API.G_RET_STS_ERROR;
718 FND_MSG_PUB.Count_And_Get(
719 p_encoded => FND_API.G_FALSE,
720 p_count => x_msg_count,
721 p_data => x_msg_data
722 );
723
724 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
725 WHEN FND_API.G_EXC_UNEXPECTED_ERROR
726 THEN
727 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728 FND_MSG_PUB.Count_And_Get(
729 p_encoded => FND_API.G_FALSE,
730 p_count => x_msg_count,
731 p_data => x_msg_data
732 );
733 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
734 WHEN OTHERS THEN
735 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737 THEN
738 FND_MSG_PUB.Add_Exc_Msg(
739 G_PKG_NAME,
740 l_api_name
741 );
742 END IF;
743 FND_MSG_PUB.Count_And_Get(
744 p_encoded => FND_API.G_FALSE,
745 p_count => x_msg_count,
746 p_data => x_msg_data
747 );
748 Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
749 END Config_Operations;
750
751
752 FUNCTION Construct_Appl_Param_Rec(
753 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757 p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758 p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759 p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
760 )
761 RETURN CZ_API_PUB.appl_param_rec_type
762 IS
763 l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
764 BEGIN
765 ASO_Quote_Util_Pvt.Enable_Debug_Pvt;
766 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_int_w.Construct_Appl_Param_Rec BEGIN');
767 IF p_ap_config_creation_date = ROSETTA_G_MISTAKE_DATE THEN
768 l_appl_param_rec.config_creation_date := FND_API.G_MISS_DATE;
769 ELSE
770 l_appl_param_rec.config_creation_date := p_ap_config_creation_date;
771 END IF;
772
773 IF p_ap_config_model_lookup_date = ROSETTA_G_MISTAKE_DATE THEN
774 l_appl_param_rec.config_model_lookup_date := FND_API.G_MISS_DATE;
775 ELSE
776 l_appl_param_rec.config_model_lookup_date := p_ap_config_model_lookup_date;
777 END IF;
778
779 IF p_ap_config_effective_date = ROSETTA_G_MISTAKE_DATE THEN
780 l_appl_param_rec.config_effective_date := FND_API.G_MISS_DATE;
781 ELSE
782 l_appl_param_rec.config_effective_date := p_ap_config_effective_date;
783 END IF;
784
785 IF p_ap_calling_application_id = ROSETTA_G_MISS_NUM THEN
786 l_appl_param_rec.calling_application_id := FND_API.G_MISS_NUM;
787 ELSE
788 l_appl_param_rec.calling_application_id := p_ap_calling_application_id;
789 END IF;
790
791 l_appl_param_rec.usage_name := p_ap_usage_name;
792 l_appl_param_rec.publication_mode := p_ap_publication_mode;
793 l_appl_param_rec.language := p_ap_language;
794 Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_int_w.Construct_Appl_Param_Rec END');
795 ASO_Quote_Util_Pvt.Enable_Debug_Pvt;
796 RETURN l_appl_param_rec;
797 END Construct_Appl_Param_Rec;
798
799 END ASO_Config_Operations_Int_W;