[Home] [Help]
PACKAGE BODY: APPS.IBE_QUOTE_W2_PVT
Source
1 PACKAGE BODY IBE_Quote_W2_PVT as
2 /* $Header: IBEVQW2B.pls 120.3 2008/03/14 09:05:22 mgiridha ship $ */
3 -- Start of Comments
4 -- Package name : IBE_QUOTE_W2_PVT
5 -- Purpose :
6 -- History :
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) := 'IBE_QUOTE_W2_PVT';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVQW2B.PLS';
14 l_true VARCHAR2(1) := FND_API.G_TRUE;
15
16 PROCEDURE set_control_rec_w(
17 p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18 p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19 p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20 p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21 p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22 p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23 p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
24 x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
25 )
26 IS
27 BEGIN
28 IF p_c_last_update_date <> ROSETTA_G_MISTAKE_DATE
29 AND p_c_last_update_date <> FND_API.G_MISS_DATE
30 AND p_c_last_update_date <> null THEN
31 x_control_rec.last_update_date := p_c_last_update_date;
32 END IF;
33
34 IF p_c_auto_version_flag <> FND_API.G_MISS_CHAR THEN
35 x_control_rec.auto_version_flag := p_c_auto_version_flag;
36 END IF;
37
38 IF p_c_pricing_request_type <> FND_API.G_MISS_CHAR THEN
39 x_control_rec.pricing_request_type := p_c_pricing_request_type;
40 END IF;
41
42 IF p_c_header_pricing_event <> FND_API.G_MISS_CHAR THEN
43 x_control_rec.header_pricing_event := p_c_header_pricing_event;
44 END IF;
45
46 IF p_c_line_pricing_event <> FND_API.G_MISS_CHAR THEN
47 x_control_rec.line_pricing_event := p_c_line_pricing_event;
48 END IF;
49
50 IF p_c_cal_tax_flag <> FND_API.G_MISS_CHAR THEN
51 x_control_rec.calculate_tax_flag := p_c_cal_tax_flag;
52 END IF;
53
54 IF p_c_cal_freight_charge_flag <> FND_API.G_MISS_CHAR THEN
55 x_control_rec.calculate_freight_charge_flag := p_c_cal_freight_charge_flag;
56 END IF;
57 END Set_Control_Rec_W;
58
59 PROCEDURE set_saveshare2_control_rec_w(
60 p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61 p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68 p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69 p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
71 x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
72 ) is
73
74 l_control_rec ASO_QUOTE_PUB.control_rec_type;
75 l_saveshare_control_rec IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type;
76
77 BEGIN
78 Set_Control_rec_w(
79 p_c_LAST_UPDATE_DATE => p_c_LAST_UPDATE_DATE
80 ,p_c_auto_version_flag => p_c_auto_version_flag
81 ,p_c_pricing_request_type => p_c_pricing_request_type
82 ,p_c_header_pricing_event => p_c_header_pricing_event
83 ,p_c_line_pricing_event => p_c_line_pricing_event
84 ,p_c_CAL_TAX_FLAG => p_c_CAL_TAX_FLAG
85 ,p_c_CAL_FREIGHT_CHARGE_FLAG => p_c_CAL_FREIGHT_CHARGE_FLAG
86 ,x_control_rec => l_control_rec );
87
88 x_saveshare_control_rec.control_rec := l_control_rec;
89
90 x_saveshare_control_rec.delete_source_cart := p_ssc_delete_source_cart;
91
92 IF p_ssc_combinesameitem is not NULL THEN
93 x_saveshare_control_rec.combinesameitem := p_ssc_combinesameitem;
94 END IF;
95
96 IF p_ssc_operation_code is not NULL THEN
97 x_saveshare_control_rec.operation_code := p_ssc_operation_code;
98 END IF;
99
100 IF p_ssc_deactivate_cart is not NULL THEN
101 x_saveshare_control_rec.deactivate_cart := p_ssc_deactivate_cart;
102 END IF;
103 END;
104
105 FUNCTION construct_quote_access_tbl(
106 p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
107 p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
108 p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109 p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110 p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111 p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112 p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113 p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114 p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115 p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116 p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117 p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118 p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119 p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120 p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121 p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122 p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
123 p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
124 p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
125 p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
126 p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
127 p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
128 p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
129 p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL)
130 RETURN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE IS
131
132 l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE;
133 l_table_size NUMBER;
134
135 BEGIN
136 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137 IBE_UTIL.DEBUG('CONSTRUCT_QUOTE_ACCESS_TABLE:START');
138 END IF;
139 IF p_qsh_NOTIFY_FLAG IS NOT NULL THEN
140 l_table_size := p_qsh_NOTIFY_FLAG.COUNT;
141 END IF;
142
143 IF l_table_size > 0 THEN
144 FOR i IN 1..l_table_size LOOP
145 IF ((p_qsh_operation_code is not null ) and (p_qsh_operation_code(i) is not null)) THEN
146 l_quote_access_tbl(i).operation_code := p_qsh_operation_code(i);
147 END IF;
148
149 IF((p_qsh_QUOTE_SHAREE_ID is not null ) and ((p_qsh_QUOTE_SHAREE_ID(i) is not null)
150 or (p_qsh_QUOTE_SHAREE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
151 l_quote_access_tbl(i).QUOTE_SHAREE_ID := p_qsh_QUOTE_SHAREE_ID(i);
152 END IF;
153
154 IF ((p_qsh_REQUEST_ID is not null ) and ((p_qsh_REQUEST_ID(i) is not null)
155 or (p_qsh_REQUEST_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
156 l_quote_access_tbl(i).REQUEST_ID := p_qsh_REQUEST_ID(i);
157 END IF;
158
159 IF ((p_qsh_PROGRAM_APPLICATION_ID is not null ) and ((p_qsh_PROGRAM_APPLICATION_ID(i) is not null)
160 or (p_qsh_PROGRAM_APPLICATION_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
161 l_quote_access_tbl(i).PROGRAM_APPLICATION_ID := p_qsh_PROGRAM_APPLICATION_ID(i) ;
162 END IF;
163
164 IF ((p_qsh_PROGRAM_ID is not null ) and ((p_qsh_PROGRAM_ID(i) is not null)
165 or (p_qsh_PROGRAM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
166 l_quote_access_tbl(i).PROGRAM_ID := p_qsh_PROGRAM_ID(i);
167 END IF;
168
169 IF ((p_qsh_PROGRAM_UPDATE_DATE is not null ) and ((p_qsh_PROGRAM_UPDATE_DATE(i) is not null)
170 or (p_qsh_PROGRAM_UPDATE_DATE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
171 l_quote_access_tbl(i).PROGRAM_UPDATE_DATE := p_qsh_PROGRAM_UPDATE_DATE(i);
172 END IF;
173
174 IF ((p_qsh_OBJECT_VERSION_NUMBER is not null ) and ((p_qsh_OBJECT_VERSION_NUMBER(i) is not null)
175 or (p_qsh_OBJECT_VERSION_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
176 l_quote_access_tbl(i).OBJECT_VERSION_NUMBER := p_qsh_OBJECT_VERSION_NUMBER(i);
177 END IF;
178
179 IF ((p_qsh_CREATED_BY is not null ) and ((p_qsh_CREATED_BY(i) is not null)
180 or (p_qsh_CREATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
181 l_quote_access_tbl(i).CREATED_BY := p_qsh_CREATED_BY(i);
182 END IF;
183
184 IF ((p_qsh_CREATION_DATE is not null ) and ((p_qsh_CREATION_DATE(i) is not null)
185 or (p_qsh_CREATION_DATE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
186 l_quote_access_tbl(i).CREATION_DATE := p_qsh_CREATION_DATE(i);
187 END IF;
188
189 IF ((p_qsh_LAST_UPDATED_BY is not null ) and ((p_qsh_LAST_UPDATED_BY(i) is not null)
190 or (p_qsh_LAST_UPDATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
191 l_quote_access_tbl(i).LAST_UPDATED_BY := p_qsh_LAST_UPDATED_BY(i);
192 END IF;
193
194 IF ((p_qsh_LAST_UPDATE_DATE is not null ) and ((p_qsh_LAST_UPDATE_DATE(i) is not null)
195 or (p_qsh_LAST_UPDATE_DATE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
196 l_quote_access_tbl(i).LAST_UPDATE_DATE := p_qsh_LAST_UPDATE_DATE(i);
197 END IF;
198
199 IF ((p_qsh_LAST_UPDATE_LOGIN is not null ) and ((p_qsh_LAST_UPDATE_LOGIN(i) is not null)
200 or (p_qsh_LAST_UPDATE_LOGIN(i) <> ROSETTA_G_MISS_NUM))) THEN
201 l_quote_access_tbl(i).LAST_UPDATE_LOGIN := p_qsh_LAST_UPDATE_LOGIN(i);
202 END IF;
203 IF ((p_qsh_QUOTE_HEADER_ID is not null ) and ((p_qsh_QUOTE_HEADER_ID(i) is not null)
204 or (p_qsh_QUOTE_HEADER_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
205 l_quote_access_tbl(i).QUOTE_HEADER_ID := p_qsh_QUOTE_HEADER_ID(i);
206 END IF;
207
208 IF ((p_qsh_QUOTE_SHAREE_NUMBER is not null ) and ((p_qsh_QUOTE_SHAREE_NUMBER(i) is not null)
209 or (p_qsh_QUOTE_SHAREE_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
210 l_quote_access_tbl(i).QUOTE_SHAREE_NUMBER := p_qsh_QUOTE_SHAREE_NUMBER(i);
211 END IF;
212
213 IF (p_qsh_UPDATE_PRIV_TYPE_CODE is not null ) THEN
214 l_quote_access_tbl(i).UPDATE_PRIVILEGE_TYPE_CODE := p_qsh_UPDATE_PRIV_TYPE_CODE(i);
215 END IF;
216
217 IF ((p_qsh_SECURITY_GROUP_ID is not null ) and ((p_qsh_SECURITY_GROUP_ID(i) is not null)
218 or (p_qsh_SECURITY_GROUP_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
219 l_quote_access_tbl(i).SECURITY_GROUP_ID := p_qsh_SECURITY_GROUP_ID(i);
220 END IF;
221
222 IF ((p_qsh_PARTY_ID is not null ) and ((p_qsh_PARTY_ID(i) is not null)
223 or (p_qsh_PARTY_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
224 l_quote_access_tbl(i).PARTY_ID := p_qsh_PARTY_ID(i);
225 END IF;
226
227 IF ((p_qsh_CUST_ACCOUNT_ID is not null ) and ((p_qsh_CUST_ACCOUNT_ID(i) is not null)
228 or (p_qsh_CUST_ACCOUNT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
229 l_quote_access_tbl(i).CUST_ACCOUNT_ID := p_qsh_CUST_ACCOUNT_ID(i);
230 END IF;
231
232 IF ((p_qsh_START_DATE_ACTIVE is not null ) and ((p_qsh_START_DATE_ACTIVE(i) is not null)
233 or (p_qsh_START_DATE_ACTIVE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
234 l_quote_access_tbl(i).START_DATE_ACTIVE := p_qsh_START_DATE_ACTIVE(i);
235 END IF;
236
237 IF ((p_qsh_END_DATE_ACTIVE is not null ) and ((p_qsh_END_DATE_ACTIVE(i) is not null)
238 or (p_qsh_END_DATE_ACTIVE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
239 l_quote_access_tbl(i).END_DATE_ACTIVE := p_qsh_END_DATE_ACTIVE(i);
240 END IF;
241
242 IF ((p_qsh_RECIPIENT_NAME is not null ) and (p_qsh_RECIPIENT_NAME(i) is not null)) THEN
243 l_quote_access_tbl(i).RECIPIENT_NAME := p_qsh_RECIPIENT_NAME(i);
244 END IF;
245
246 IF ((p_qsh_EMAIL_ADDRESS is not null ) and (p_qsh_EMAIL_ADDRESS(i) is not null)) THEN
247 l_quote_access_tbl(i).EMAIL_CONTACT_ADDRESS := p_qsh_EMAIL_ADDRESS(i);
248 END IF;
249
250 IF ((p_qsh_CONTACT_POINT_ID is not null ) and ((p_qsh_CONTACT_POINT_ID(i) is not null)
251 or (p_qsh_CONTACT_POINT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
252 l_quote_access_tbl(i).CONTACT_POINT_ID := p_qsh_CONTACT_POINT_ID(i);
253 END IF;
254
255 -- IF ((p_qsh_NOTIFY_FLAG is not null ) and (p_qsh_NOTIFY_FLAG(i) is not null)) THEN
256 l_quote_access_tbl(i).NOTIFY_FLAG := p_qsh_NOTIFY_FLAG(i);
257 -- END IF;
258
259 END LOOP;
260 END IF;
261 RETURN L_QUOTE_ACCESS_TBL;
262 END;
263
264
265
266 FUNCTION construct_sales_credit_tbl(
267 p_operation_code IN jtf_varchar2_table_100 := NULL,
268 p_qte_line_index IN jtf_number_table := NULL,
269 p_sales_credit_id IN jtf_number_table := NULL,
270 p_creation_date IN jtf_date_table := NULL,
271 p_created_by IN jtf_number_table := NULL,
272 p_last_updated_by IN jtf_number_table := NULL,
273 p_last_update_date IN jtf_date_table := NULL,
274 p_last_update_login IN jtf_number_table := NULL,
275 p_request_id IN jtf_number_table := NULL,
276 p_program_application_id IN jtf_number_table := NULL,
277 p_program_id IN jtf_number_table := NULL,
278 p_program_update_date IN jtf_date_table := NULL,
279 p_quote_header_id IN jtf_number_table := NULL,
280 p_quote_line_id IN jtf_number_table := NULL,
281 p_percent IN jtf_number_table := NULL,
282 p_resource_id IN jtf_number_table := NULL,
283 p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284 p_resource_group_id IN jtf_number_table := NULL,
285 p_employee_person_id IN jtf_number_table := NULL,
286 p_sales_credit_type_id IN jtf_number_table := NULL,
287 p_attribute_category IN jtf_varchar2_table_100 := NULL,
288 p_attribute1 IN jtf_varchar2_table_300 := NULL,
289 p_attribute2 IN jtf_varchar2_table_300 := NULL,
290 p_attribute3 IN jtf_varchar2_table_300 := NULL,
291 p_attribute4 IN jtf_varchar2_table_300 := NULL,
292 p_attribute5 IN jtf_varchar2_table_300 := NULL,
296 p_attribute9 IN jtf_varchar2_table_300 := NULL,
293 p_attribute6 IN jtf_varchar2_table_300 := NULL,
294 p_attribute7 IN jtf_varchar2_table_300 := NULL,
295 p_attribute8 IN jtf_varchar2_table_300 := NULL,
297 p_attribute10 IN jtf_varchar2_table_300 := NULL,
298 p_attribute11 IN jtf_varchar2_table_300 := NULL,
299 p_attribute12 IN jtf_varchar2_table_300 := NULL,
300 p_attribute13 IN jtf_varchar2_table_300 := NULL,
301 p_attribute14 IN jtf_varchar2_table_300 := NULL,
302 p_attribute15 IN jtf_varchar2_table_300 := NULL
303 )
304 RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type
305 IS
306 l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
307 l_table_size PLS_INTEGER := 0;
308 i PLS_INTEGER;
309 BEGIN
310 IF p_operation_code IS NOT NULL THEN
311 l_table_size := p_operation_code.COUNT;
312 END IF;
313
314 IF l_table_size > 0 THEN
315 FOR i IN 1..l_table_size LOOP
316 l_sales_credit_tbl(i).operation_code := p_operation_code(i);
317 IF p_qte_line_index(i)= ROSETTA_G_MISS_NUM THEN
318 l_sales_credit_tbl(i).qte_line_index := FND_API.G_MISS_NUM;
319 ELSE
320 l_sales_credit_tbl(i).qte_line_index := p_qte_line_index(i);
321 END IF;
322 IF p_sales_credit_id(i)= ROSETTA_G_MISS_NUM THEN
323 l_sales_credit_tbl(i).sales_credit_id := FND_API.G_MISS_NUM;
324 ELSE
325 l_sales_credit_tbl(i).sales_credit_id := p_sales_credit_id(i);
326 END IF;
327 IF p_creation_date(i)= ROSETTA_G_MISTAKE_DATE THEN
328 l_sales_credit_tbl(i).creation_date := FND_API.G_MISS_DATE;
329 ELSE
330 l_sales_credit_tbl(i).creation_date := p_creation_date(i);
331 END IF;
332 IF p_created_by(i)= ROSETTA_G_MISS_NUM THEN
333 l_sales_credit_tbl(i).created_by := FND_API.G_MISS_NUM;
334 ELSE
335 l_sales_credit_tbl(i).created_by := p_created_by(i);
336 END IF;
337 IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
338 l_sales_credit_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
339 ELSE
340 l_sales_credit_tbl(i).last_updated_by := p_last_updated_by(i);
341 END IF;
342 IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
343 l_sales_credit_tbl(i).last_update_date := FND_API.G_MISS_DATE;
344 ELSE
345 l_sales_credit_tbl(i).last_update_date := p_last_update_date(i);
346 END IF;
347 IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
348 l_sales_credit_tbl(i).last_update_login := FND_API.G_MISS_NUM;
349 ELSE
350 l_sales_credit_tbl(i).last_update_login := p_last_update_login(i);
351 END IF;
352 IF p_request_id(i)= ROSETTA_G_MISS_NUM THEN
353 l_sales_credit_tbl(i).request_id := FND_API.G_MISS_NUM;
354 ELSE
355 l_sales_credit_tbl(i).request_id := p_request_id(i);
356 END IF;
357 IF p_program_application_id(i)= ROSETTA_G_MISS_NUM THEN
358 l_sales_credit_tbl(i).program_application_id := FND_API.G_MISS_NUM;
359 ELSE
360 l_sales_credit_tbl(i).program_application_id := p_program_application_id(i);
361 END IF;
362 IF p_program_id(i)= ROSETTA_G_MISS_NUM THEN
363 l_sales_credit_tbl(i).program_id := FND_API.G_MISS_NUM;
364 ELSE
365 l_sales_credit_tbl(i).program_id := p_program_id(i);
366 END IF;
367 IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
368 l_sales_credit_tbl(i).program_update_date := FND_API.G_MISS_DATE;
369 ELSE
370 l_sales_credit_tbl(i).program_update_date := p_program_update_date(i);
371 END IF;
372 IF p_quote_header_id(i)= ROSETTA_G_MISS_NUM THEN
373 l_sales_credit_tbl(i).quote_header_id := FND_API.G_MISS_NUM;
374 ELSE
375 l_sales_credit_tbl(i).quote_header_id := p_quote_header_id(i);
376 END IF;
377 IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
378 l_sales_credit_tbl(i).quote_line_id := FND_API.G_MISS_NUM;
379 ELSE
380 l_sales_credit_tbl(i).quote_line_id := p_quote_line_id(i);
381 END IF;
382 IF p_percent(i)= ROSETTA_G_MISS_NUM THEN
383 l_sales_credit_tbl(i).percent := FND_API.G_MISS_NUM;
384 ELSE
385 l_sales_credit_tbl(i).percent := p_percent(i);
386 END IF;
387 IF p_resource_id(i)= ROSETTA_G_MISS_NUM THEN
388 l_sales_credit_tbl(i).resource_id := FND_API.G_MISS_NUM;
389 ELSE
390 l_sales_credit_tbl(i).resource_id := p_resource_id(i);
391 END IF;
392
393 l_sales_credit_tbl(i).sales_credit_type := p_sales_credit_type(i);
394
395 IF p_resource_group_id(i)= ROSETTA_G_MISS_NUM THEN
396 l_sales_credit_tbl(i).resource_group_id := FND_API.G_MISS_NUM;
397 ELSE
398 l_sales_credit_tbl(i).resource_group_id := p_resource_group_id(i);
399 END IF;
400 IF p_employee_person_id(i)= ROSETTA_G_MISS_NUM THEN
401 l_sales_credit_tbl(i).employee_person_id := FND_API.G_MISS_NUM;
402 ELSE
403 l_sales_credit_tbl(i).employee_person_id := p_employee_person_id(i);
404 END IF;
405 IF p_sales_credit_type_id(i)= ROSETTA_G_MISS_NUM THEN
406 l_sales_credit_tbl(i).sales_credit_type_id := FND_API.G_MISS_NUM;
410
407 ELSE
408 l_sales_credit_tbl(i).sales_credit_type_id := p_sales_credit_type_id(i);
409 END IF;
411 l_sales_credit_tbl(i).attribute_category_code := p_attribute_category(i);
412 l_sales_credit_tbl(i).attribute1 := p_attribute1(i);
413 l_sales_credit_tbl(i).attribute2 := p_attribute2(i);
414 l_sales_credit_tbl(i).attribute3 := p_attribute3(i);
415 l_sales_credit_tbl(i).attribute4 := p_attribute4(i);
416 l_sales_credit_tbl(i).attribute5 := p_attribute5(i);
417 l_sales_credit_tbl(i).attribute6 := p_attribute6(i);
418 l_sales_credit_tbl(i).attribute7 := p_attribute7(i);
419 l_sales_credit_tbl(i).attribute8 := p_attribute8(i);
420 l_sales_credit_tbl(i).attribute9 := p_attribute9(i);
421 l_sales_credit_tbl(i).attribute10 := p_attribute10(i);
422 l_sales_credit_tbl(i).attribute11 := p_attribute11(i);
423 l_sales_credit_tbl(i).attribute12 := p_attribute12(i);
424 l_sales_credit_tbl(i).attribute13 := p_attribute13(i);
425 l_sales_credit_tbl(i).attribute14 := p_attribute14(i);
426 l_sales_credit_tbl(i).attribute15 := p_attribute15(i);
427 END LOOP;
428
429 RETURN l_sales_credit_tbl;
430 ELSE
431 RETURN ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
432 END IF;
433 END Construct_Sales_Credit_Tbl;
434
435 FUNCTION construct_qte_header_rec(
436 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437 p_creation_date IN DATE := FND_API.G_MISS_DATE,
438 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447 p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448 p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449 p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450 p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451 p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452 p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453 p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454 p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455 p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458 p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459 p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460 p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461 p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462 p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463 p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465 p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467 p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469 p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470 p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471 p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472 p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473 p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474 p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475 p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476 p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477 p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478 p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479 p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480 p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481 p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482 p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483 p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484 p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485 p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488 -- bug 6873117 mgiridha added attribute 16-20
489 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509 p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510 p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511 p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512 p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513 p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514 p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515 p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516 p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517 p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518 p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519 p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520 p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521 p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522 p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523 p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524 p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525 p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526 p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527 p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528 p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529 p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530 p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531 p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532 p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533 p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534 p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535 p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536 p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537 p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538 p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540 p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541 p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
542 )
543 RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
544 IS
545 l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
546 BEGIN
547 IF p_quote_header_id= ROSETTA_G_MISS_NUM THEN
548 l_qte_header.quote_header_id := FND_API.G_MISS_NUM;
549 ELSE
550 l_qte_header.quote_header_id := p_quote_header_id;
551 END IF;
552 IF p_creation_date= ROSETTA_G_MISTAKE_DATE THEN
553 l_qte_header.creation_date := FND_API.G_MISS_DATE;
554 ELSE
555 l_qte_header.creation_date := p_creation_date;
556 END IF;
557 IF p_created_by= ROSETTA_G_MISS_NUM THEN
558 l_qte_header.created_by := FND_API.G_MISS_NUM;
559 ELSE
560 l_qte_header.created_by := p_created_by;
561 END IF;
562 IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
563 l_qte_header.last_updated_by := FND_API.G_MISS_NUM;
564 ELSE
565 l_qte_header.last_updated_by := p_last_updated_by;
566 END IF;
567 IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
568 l_qte_header.last_update_date := FND_API.G_MISS_DATE;
569 ELSE
570 l_qte_header.last_update_date := p_last_update_date;
571 END IF;
572 IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
573 l_qte_header.last_update_login := FND_API.G_MISS_NUM;
574 ELSE
575 l_qte_header.last_update_login := p_last_update_login;
576 END IF;
577 IF p_request_id= ROSETTA_G_MISS_NUM THEN
578 l_qte_header.request_id := FND_API.G_MISS_NUM;
579 ELSE
580 l_qte_header.request_id := p_request_id;
581 END IF;
582 IF p_program_application_id= ROSETTA_G_MISS_NUM THEN
583 l_qte_header.program_application_id := FND_API.G_MISS_NUM;
584 ELSE
585 l_qte_header.program_application_id := p_program_application_id;
586 END IF;
587 IF p_program_id= ROSETTA_G_MISS_NUM THEN
588 l_qte_header.program_id := FND_API.G_MISS_NUM;
589 ELSE
590 l_qte_header.program_id := p_program_id;
591 END IF;
592 IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
593 l_qte_header.program_update_date := FND_API.G_MISS_DATE;
594 ELSE
595 l_qte_header.program_update_date := p_program_update_date;
596 END IF;
597 IF p_org_id= ROSETTA_G_MISS_NUM THEN
598 l_qte_header.org_id := FND_API.G_MISS_NUM;
599 ELSE
600 l_qte_header.org_id := p_org_id;
601 END IF;
602 l_qte_header.quote_name := p_quote_name;
606 l_qte_header.quote_number := p_quote_number;
603 IF p_quote_number= ROSETTA_G_MISS_NUM THEN
604 l_qte_header.quote_number := FND_API.G_MISS_NUM;
605 ELSE
607 END IF;
608 IF p_quote_version= ROSETTA_G_MISS_NUM THEN
609 l_qte_header.quote_version := FND_API.G_MISS_NUM;
610 ELSE
611 l_qte_header.quote_version := p_quote_version;
612 END IF;
613 IF p_quote_status_id= ROSETTA_G_MISS_NUM THEN
614 l_qte_header.quote_status_id := FND_API.G_MISS_NUM;
615 ELSE
616 l_qte_header.quote_status_id := p_quote_status_id;
617 END IF;
618 l_qte_header.quote_source_code := p_quote_source_code;
619 IF p_quote_expiration_date= ROSETTA_G_MISTAKE_DATE THEN
620 l_qte_header.quote_expiration_date := FND_API.G_MISS_DATE;
621 ELSE
622 l_qte_header.quote_expiration_date := p_quote_expiration_date;
623 END IF;
624 IF p_price_frozen_date= ROSETTA_G_MISTAKE_DATE THEN
625 l_qte_header.price_frozen_date := FND_API.G_MISS_DATE;
626 ELSE
627 l_qte_header.price_frozen_date := p_price_frozen_date;
628 END IF;
629 l_qte_header.quote_password := p_quote_password;
630 l_qte_header.original_system_reference := p_original_system_reference;
631 IF p_party_id= ROSETTA_G_MISS_NUM THEN
632 l_qte_header.party_id := FND_API.G_MISS_NUM;
633 ELSE
634 l_qte_header.party_id := p_party_id;
635 END IF;
636 IF p_cust_account_id= ROSETTA_G_MISS_NUM THEN
637 l_qte_header.cust_account_id := FND_API.G_MISS_NUM;
638 ELSE
639 l_qte_header.cust_account_id := p_cust_account_id;
640 END IF;
641 IF p_invoice_to_cust_account_id= ROSETTA_G_MISS_NUM THEN
642 l_qte_header.invoice_to_cust_account_id := FND_API.G_MISS_NUM;
643 ELSE
644 l_qte_header.invoice_to_cust_account_id := p_invoice_to_cust_account_id;
645 END IF;
646 IF p_org_contact_id= ROSETTA_G_MISS_NUM THEN
647 l_qte_header.org_contact_id := FND_API.G_MISS_NUM;
648 ELSE
649 l_qte_header.org_contact_id := p_org_contact_id;
650 END IF;
651 l_qte_header.party_name := p_party_name;
652 l_qte_header.party_type := p_party_type;
653 l_qte_header.person_first_name := p_person_first_name;
654 l_qte_header.person_last_name := p_person_last_name;
655 l_qte_header.person_middle_name := p_person_middle_name;
656 IF p_phone_id= ROSETTA_G_MISS_NUM THEN
657 l_qte_header.phone_id := FND_API.G_MISS_NUM;
658 ELSE
659 l_qte_header.phone_id := p_phone_id;
660 END IF;
661 IF p_price_list_id= ROSETTA_G_MISS_NUM THEN
662 l_qte_header.price_list_id := FND_API.G_MISS_NUM;
663 ELSE
664 l_qte_header.price_list_id := p_price_list_id;
665 END IF;
666 l_qte_header.price_list_name := p_price_list_name;
667 l_qte_header.currency_code := p_currency_code;
668 IF p_total_list_price= ROSETTA_G_MISS_NUM THEN
669 l_qte_header.total_list_price := FND_API.G_MISS_NUM;
670 ELSE
671 l_qte_header.total_list_price := p_total_list_price;
672 END IF;
673 IF p_total_adjusted_amount= ROSETTA_G_MISS_NUM THEN
674 l_qte_header.total_adjusted_amount := FND_API.G_MISS_NUM;
675 ELSE
676 l_qte_header.total_adjusted_amount := p_total_adjusted_amount;
677 END IF;
678 IF p_total_adjusted_percent= ROSETTA_G_MISS_NUM THEN
679 l_qte_header.total_adjusted_percent := FND_API.G_MISS_NUM;
680 ELSE
681 l_qte_header.total_adjusted_percent := p_total_adjusted_percent;
682 END IF;
683 IF p_total_tax= ROSETTA_G_MISS_NUM THEN
684 l_qte_header.total_tax := FND_API.G_MISS_NUM;
685 ELSE
686 l_qte_header.total_tax := p_total_tax;
687 END IF;
688 IF p_total_shipping_charge= ROSETTA_G_MISS_NUM THEN
689 l_qte_header.total_shipping_charge := FND_API.G_MISS_NUM;
690 ELSE
691 l_qte_header.total_shipping_charge := p_total_shipping_charge;
692 END IF;
693 IF p_surcharge= ROSETTA_G_MISS_NUM THEN
694 l_qte_header.surcharge := FND_API.G_MISS_NUM;
695 ELSE
696 l_qte_header.surcharge := p_surcharge;
697 END IF;
698 IF p_total_quote_price= ROSETTA_G_MISS_NUM THEN
699 l_qte_header.total_quote_price := FND_API.G_MISS_NUM;
700 ELSE
701 l_qte_header.total_quote_price := p_total_quote_price;
702 END IF;
703 IF p_payment_amount= ROSETTA_G_MISS_NUM THEN
704 l_qte_header.payment_amount := FND_API.G_MISS_NUM;
705 ELSE
706 l_qte_header.payment_amount := p_payment_amount;
707 END IF;
708 IF p_accounting_rule_id= ROSETTA_G_MISS_NUM THEN
709 l_qte_header.accounting_rule_id := FND_API.G_MISS_NUM;
710 ELSE
711 l_qte_header.accounting_rule_id := p_accounting_rule_id;
712 END IF;
713 IF p_exchange_rate= ROSETTA_G_MISS_NUM THEN
714 l_qte_header.exchange_rate := FND_API.G_MISS_NUM;
715 ELSE
716 l_qte_header.exchange_rate := p_exchange_rate;
717 END IF;
718 l_qte_header.exchange_type_code := p_exchange_type_code;
719 IF p_exchange_rate_date= ROSETTA_G_MISTAKE_DATE THEN
720 l_qte_header.exchange_rate_date := FND_API.G_MISS_DATE;
721 ELSE
722 l_qte_header.exchange_rate_date := p_exchange_rate_date;
723 END IF;
724 l_qte_header.quote_category_code := p_quote_category_code;
725 l_qte_header.quote_status_code := p_quote_status_code;
726 l_qte_header.quote_status := p_quote_status;
730 l_qte_header.employee_person_id := p_employee_person_id;
727 IF p_employee_person_id= ROSETTA_G_MISS_NUM THEN
728 l_qte_header.employee_person_id := FND_API.G_MISS_NUM;
729 ELSE
731 END IF;
732 l_qte_header.sales_channel_code := p_sales_channel_code;
733 -- l_qte_header.salesrep_full_name := p_salesrep_full_name;
734 l_qte_header.attribute_category := p_attribute_category;
735 -- bug 6873117 mgiridha added attribute 16-20
736 l_qte_header.attribute1 := p_attribute1;
737 l_qte_header.attribute10 := p_attribute10;
738 l_qte_header.attribute11 := p_attribute11;
739 l_qte_header.attribute12 := p_attribute12;
740 l_qte_header.attribute13 := p_attribute13;
741 l_qte_header.attribute14 := p_attribute14;
742 l_qte_header.attribute15 := p_attribute15;
743 l_qte_header.attribute16 := p_attribute16;
744 l_qte_header.attribute17 := p_attribute17;
745 l_qte_header.attribute18 := p_attribute18;
746 l_qte_header.attribute19 := p_attribute19;
747 l_qte_header.attribute2 := p_attribute2;
748 l_qte_header.attribute20 := p_attribute20;
749 l_qte_header.attribute3 := p_attribute3;
750 l_qte_header.attribute4 := p_attribute4;
751 l_qte_header.attribute5 := p_attribute5;
752 l_qte_header.attribute6 := p_attribute6;
753 l_qte_header.attribute7 := p_attribute7;
754 l_qte_header.attribute8 := p_attribute8;
755 l_qte_header.attribute9 := p_attribute9;
756 IF p_contract_id= ROSETTA_G_MISS_NUM THEN
757 l_qte_header.contract_id := FND_API.G_MISS_NUM;
758 ELSE
759 l_qte_header.contract_id := p_contract_id;
760 END IF;
761 IF p_qte_contract_id= ROSETTA_G_MISS_NUM THEN
762 l_qte_header.qte_contract_id := FND_API.G_MISS_NUM;
763 ELSE
764 l_qte_header.qte_contract_id := p_qte_contract_id;
765 END IF;
766 IF p_ffm_request_id= ROSETTA_G_MISS_NUM THEN
767 l_qte_header.ffm_request_id := FND_API.G_MISS_NUM;
768 ELSE
769 l_qte_header.ffm_request_id := p_ffm_request_id;
770 END IF;
771 l_qte_header.invoice_to_address1 := p_invoice_to_address1;
772 l_qte_header.invoice_to_address2 := p_invoice_to_address2;
773 l_qte_header.invoice_to_address3 := p_invoice_to_address3;
774 l_qte_header.invoice_to_address4 := p_invoice_to_address4;
775 l_qte_header.invoice_to_city := p_invoice_to_city;
776 l_qte_header.invoice_to_contact_first_name := p_invoice_to_cont_first_name;
777 l_qte_header.invoice_to_contact_last_name := p_invoice_to_cont_last_name;
778 l_qte_header.invoice_to_contact_middle_name := p_invoice_to_cont_mid_name;
779 l_qte_header.invoice_to_country_code := p_invoice_to_country_code;
780 l_qte_header.invoice_to_country := p_invoice_to_country;
781 l_qte_header.invoice_to_county := p_invoice_to_county;
782 IF p_invoice_to_party_id= ROSETTA_G_MISS_NUM THEN
783 l_qte_header.invoice_to_party_id := FND_API.G_MISS_NUM;
784 ELSE
785 l_qte_header.invoice_to_party_id := p_invoice_to_party_id;
786 END IF;
787 l_qte_header.invoice_to_party_name := p_invoice_to_party_name;
788 IF p_invoice_to_party_site_id= ROSETTA_G_MISS_NUM THEN
789 l_qte_header.invoice_to_party_site_id := FND_API.G_MISS_NUM;
790 ELSE
791 l_qte_header.invoice_to_party_site_id := p_invoice_to_party_site_id;
792 END IF;
793 l_qte_header.invoice_to_postal_code := p_invoice_to_postal_code;
794 l_qte_header.invoice_to_province := p_invoice_to_province;
795 l_qte_header.invoice_to_state := p_invoice_to_state;
796 IF p_invoicing_rule_id= ROSETTA_G_MISS_NUM THEN
797 l_qte_header.invoicing_rule_id := FND_API.G_MISS_NUM;
798 ELSE
799 l_qte_header.invoicing_rule_id := p_invoicing_rule_id;
800 END IF;
801 IF p_marketing_source_code_id= ROSETTA_G_MISS_NUM THEN
802 l_qte_header.marketing_source_code_id := FND_API.G_MISS_NUM;
803 ELSE
804 l_qte_header.marketing_source_code_id := p_marketing_source_code_id;
805 END IF;
806 l_qte_header.marketing_source_code := p_marketing_source_code;
807 l_qte_header.marketing_source_name := p_marketing_source_name;
808 IF p_orig_mktg_source_code_id= ROSETTA_G_MISS_NUM THEN
809 l_qte_header.orig_mktg_source_code_id := FND_API.G_MISS_NUM;
810 ELSE
811 l_qte_header.orig_mktg_source_code_id := p_orig_mktg_source_code_id;
812 END IF;
813 IF p_order_type_id= ROSETTA_G_MISS_NUM THEN
814 l_qte_header.order_type_id := FND_API.G_MISS_NUM;
815 ELSE
816 l_qte_header.order_type_id := p_order_type_id;
817 END IF;
818 IF p_order_id= ROSETTA_G_MISS_NUM THEN
819 l_qte_header.order_id := FND_API.G_MISS_NUM;
820 ELSE
821 l_qte_header.order_id := p_order_id;
822 END IF;
823 IF p_order_number= ROSETTA_G_MISS_NUM THEN
824 l_qte_header.order_number := FND_API.G_MISS_NUM;
825 ELSE
826 l_qte_header.order_number := p_order_number;
827 END IF;
828 l_qte_header.order_type_name := p_order_type_name;
829 IF p_ordered_date= ROSETTA_G_MISTAKE_DATE THEN
830 l_qte_header.ordered_date := FND_API.G_MISS_DATE;
831 ELSE
832 l_qte_header.ordered_date := p_ordered_date;
833 END IF;
834 IF p_resource_id = ROSETTA_G_MISS_NUM THEN
835 l_qte_header.resource_id := FND_API.G_MISS_NUM;
836 ELSE
837 l_qte_header.resource_id := p_resource_id;
838 END IF;
839 RETURN l_qte_header;
840 END Construct_Qte_Header_Rec;
841
842
843 FUNCTION construct_qte_line_tbl(
844 p_quote_header_id IN jtf_number_table := NULL,
845 p_quote_line_id IN jtf_number_table := NULL
846 )
850 l_table_size PLS_INTEGER := 0;
847 RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
848 IS
849 l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
851 i PLS_INTEGER;
852 BEGIN
853 IF p_quote_header_id IS NOT NULL THEN
854 l_table_size := p_quote_header_id.COUNT;
855 END IF;
856
857 IF l_table_size > 0 THEN
858 FOR i IN 1..l_table_size LOOP
859 IF p_quote_header_id(i)= ROSETTA_G_MISS_NUM THEN
860 l_qte_line_tbl(i).quote_header_id := FND_API.G_MISS_NUM;
861 ELSE
862 l_qte_line_tbl(i).quote_header_id := p_quote_header_id(i);
863 END IF;
864 IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
865 l_qte_line_tbl(i).quote_line_id := FND_API.G_MISS_NUM;
866 ELSE
867 l_qte_line_tbl(i).quote_line_id := p_quote_line_id(i);
868 END IF;
869 l_qte_line_tbl(i).operation_code := 'UPDATE';
870 END LOOP;
871
872 RETURN l_qte_line_tbl;
873 ELSE
874 RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
875 END IF;
876 END Construct_Qte_Line_Tbl;
877
878 PROCEDURE save_share_v2_wrapper
879 (
880 p_api_version_number IN NUMBER := 1 ,
881 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
882 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883
884 p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885 p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886 p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887 p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888 p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889 p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890 p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891 p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
892 p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
893 p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
894 p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
895
896 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
897 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
898 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
899 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
900 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
901 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
902 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
903 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
904 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
905 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
906 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
907 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
908 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
909 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
910 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
911 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
912 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
913 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
914 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
915 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
916 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
917 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
918 p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
920 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
921 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
922 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
923 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
926 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
927 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
928 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
930 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
931 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
932 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
933 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
934 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
935 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
936 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
937 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
938 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
939 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
940 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
941 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
942 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
944 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
948 -- bug 6873117 added attribute 16-20
945 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
946 -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
947 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
970 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
972 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
973 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
977 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
978 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
981 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
982 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
983 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
984 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
985 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
986 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
987 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
988 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
989 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
990 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
991 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
992 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
993 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
994 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
995 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
996 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
997 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
998 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
999 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1000 --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1001 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003
1004 p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1005 p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1006 p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007 p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008 p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009 p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010 p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011 p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012 p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013 p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014 p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015 p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016 p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017 p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018 p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019 p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020 p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
1021 p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
1022 p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1023 p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1024 p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
1025 p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
1029 p_party_id NUMBER := FND_API.G_MISS_NUM,
1026 p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
1027 p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1028 p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030 P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1031 P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1032 p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1033 P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1034 P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1035 p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1036 x_return_status OUT NOCOPY VARCHAR2 ,
1037 x_msg_count OUT NOCOPY NUMBER ,
1038 x_msg_data OUT NOCOPY VARCHAR2 ) is
1039
1040 l_saveshare_control_rec IBE_QUOTE_SAVESHARE_V2_PVT.SAVESHARE_CONTROL_REC_TYPE;
1041 l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
1042 := IBE_QUOTE_SAVESHARE_pvt.g_miss_QUOTE_ACCESS_TBL;
1043 l_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
1044 BEGIN
1045 Set_Saveshare2_Control_Rec_W(
1046 p_c_last_update_date => p_c_last_update_date ,
1047 p_c_auto_version_flag => p_c_auto_version_flag,
1048 p_c_pricing_request_type => p_c_pricing_request_type,
1049 p_c_header_pricing_event => p_c_header_pricing_event,
1050 p_c_line_pricing_event => p_c_line_pricing_event,
1051 p_c_cal_tax_flag => p_c_cal_tax_flag,
1052 p_c_cal_freight_charge_flag => p_c_cal_freight_charge_flag ,
1053 p_ssc_delete_source_cart => p_ssc_delete_source_cart,
1054 p_ssc_combinesameitem => p_ssc_combinesameitem,
1055 p_ssc_operation_code => p_ssc_operation_code,
1056 p_ssc_deactivate_cart => p_ssc_deactivate_cart,
1057 x_saveshare_control_rec => l_saveshare_control_rec) ;
1058
1059 /*l_qte_header_rec := Construct_Qte_Header_Rec(
1060 p_quote_header_id => p_q_quote_header_id,
1061 p_last_update_date => p_q_last_update_date);*/
1062
1063 l_qte_header_rec := Construct_Qte_Header_Rec(
1064 p_quote_header_id => p_q_quote_header_id ,
1065 p_creation_date => p_q_creation_date ,
1066 p_created_by => p_q_created_by ,
1067 p_last_updated_by => p_q_last_updated_by ,
1068 p_last_update_date => p_q_last_update_date ,
1069 p_last_update_login => p_q_last_update_login ,
1070 p_request_id => p_q_request_id ,
1071 p_program_application_id => p_q_program_application_id ,
1072 p_program_id => p_q_program_id ,
1073 p_program_update_date => p_q_program_update_date ,
1074 p_org_id => p_q_org_id ,
1075 p_quote_name => p_q_quote_name ,
1076 p_quote_number => p_q_quote_number ,
1077 p_quote_version => p_q_quote_version ,
1078 p_quote_status_id => p_q_quote_status_id ,
1079 p_quote_source_code => p_q_quote_source_code ,
1080 p_quote_expiration_date => p_q_quote_expiration_date ,
1081 p_price_frozen_date => p_q_price_frozen_date ,
1082 p_quote_password => p_q_quote_password ,
1083 p_original_system_reference => p_q_original_system_reference ,
1084 p_party_id => p_q_party_id ,
1085 p_cust_account_id => p_q_cust_account_id ,
1086 p_invoice_to_cust_account_id => p_q_invoice_to_cust_account_id,
1087 p_org_contact_id => p_q_org_contact_id ,
1088 p_party_name => p_q_party_name ,
1089 p_party_type => p_q_party_type ,
1090 p_person_first_name => p_q_person_first_name ,
1091 p_person_last_name => p_q_person_last_name ,
1092 p_person_middle_name => p_q_person_middle_name ,
1093 p_phone_id => p_q_phone_id ,
1094 p_price_list_id => p_q_price_list_id ,
1095 p_price_list_name => p_q_price_list_name ,
1096 p_currency_code => p_q_currency_code ,
1097 p_total_list_price => p_q_total_list_price ,
1098 p_total_adjusted_amount => p_q_total_adjusted_amount ,
1099 p_total_adjusted_percent => p_q_total_adjusted_percent ,
1100 p_total_tax => p_q_total_tax ,
1101 p_total_shipping_charge => p_q_total_shipping_charge ,
1102 p_surcharge => p_q_surcharge ,
1103 p_total_quote_price => p_q_total_quote_price ,
1104 p_payment_amount => p_q_payment_amount ,
1105 p_accounting_rule_id => p_q_accounting_rule_id ,
1106 p_exchange_rate => p_q_exchange_rate ,
1107 p_exchange_type_code => p_q_exchange_type_code ,
1108 p_exchange_rate_date => p_q_exchange_rate_date ,
1109 p_quote_category_code => p_q_quote_category_code ,
1113 p_sales_channel_code => p_q_sales_channel_code ,
1110 p_quote_status_code => p_q_quote_status_code ,
1111 p_quote_status => p_q_quote_status ,
1112 p_employee_person_id => p_q_employee_person_id ,
1114 -- p_salesrep_full_name => p_q_salesrep_full_name ,
1115 p_attribute_category => p_q_attribute_category ,
1116 -- bug 6873117 mgiridha added attribute 16-20
1117 p_attribute1 => p_q_attribute1 ,
1118 p_attribute10 => p_q_attribute10 ,
1119 p_attribute11 => p_q_attribute11 ,
1120 p_attribute12 => p_q_attribute12 ,
1121 p_attribute13 => p_q_attribute13 ,
1122 p_attribute14 => p_q_attribute14 ,
1123 p_attribute15 => p_q_attribute15 ,
1124 p_attribute16 => p_q_attribute16 ,
1125 p_attribute17 => p_q_attribute17 ,
1126 p_attribute18 => p_q_attribute18 ,
1127 p_attribute19 => p_q_attribute19 ,
1128 p_attribute2 => p_q_attribute2 ,
1129 p_attribute20 => p_q_attribute20 ,
1130 p_attribute3 => p_q_attribute3 ,
1131 p_attribute4 => p_q_attribute4 ,
1132 p_attribute5 => p_q_attribute5 ,
1133 p_attribute6 => p_q_attribute6 ,
1134 p_attribute7 => p_q_attribute7 ,
1135 p_attribute8 => p_q_attribute8 ,
1136 p_attribute9 => p_q_attribute9 ,
1137 p_contract_id => p_q_contract_id ,
1138 p_qte_contract_id => p_q_qte_contract_id ,
1139 p_ffm_request_id => p_q_ffm_request_id ,
1140 p_invoice_to_address1 => p_q_invoice_to_address1 ,
1141 p_invoice_to_address2 => p_q_invoice_to_address2 ,
1142 p_invoice_to_address3 => p_q_invoice_to_address3 ,
1143 p_invoice_to_address4 => p_q_invoice_to_address4 ,
1144 p_invoice_to_city => p_q_invoice_to_city ,
1145 p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
1146 p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
1147 p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
1148 p_invoice_to_country_code => p_q_invoice_to_country_code ,
1149 p_invoice_to_country => p_q_invoice_to_country ,
1150 p_invoice_to_county => p_q_invoice_to_county ,
1151 p_invoice_to_party_id => p_q_invoice_to_party_id ,
1152 p_invoice_to_party_name => p_q_invoice_to_party_name ,
1153 p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
1154 p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
1155 p_invoice_to_province => p_q_invoice_to_province ,
1156 p_invoice_to_state => p_q_invoice_to_state ,
1157 p_invoicing_rule_id => p_q_invoicing_rule_id ,
1158 p_marketing_source_code_id => p_q_marketing_source_code_id ,
1159 p_marketing_source_code => p_q_marketing_source_code ,
1160 p_marketing_source_name => p_q_marketing_source_name ,
1161 p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
1162 p_order_type_id => p_q_order_type_id ,
1163 p_order_id => p_q_order_id ,
1164 p_order_number => p_q_order_number ,
1165 p_order_type_name => p_q_order_type_name ,
1166 p_ordered_date => p_q_ordered_date ,
1167 p_resource_id => p_q_resource_id ,
1168 p_pricing_status_indicator =>p_q_pricing_status_indicator ,
1169 p_tax_status_indicator =>p_q_tax_status_indicator);
1170
1171 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1172 IBE_UTIL.DEBUG(' IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2:START');
1173 END IF;
1174
1175 l_quote_access_tbl := construct_quote_access_tbl(
1176 p_qsh_OPERATION_CODE => p_qsh_OPERATION_CODE ,
1177 p_qsh_QUOTE_SHAREE_ID => p_qsh_QUOTE_SHAREE_ID ,
1178 p_qsh_REQUEST_ID => p_qsh_REQUEST_ID ,
1179 p_qsh_PROGRAM_APPLICATION_ID => p_qsh_PROGRAM_APPLICATION_ID ,
1180 p_qsh_PROGRAM_ID => p_qsh_PROGRAM_ID ,
1181 p_qsh_PROGRAM_UPDATE_DATE => p_qsh_PROGRAM_UPDATE_DATE ,
1182 p_qsh_OBJECT_VERSION_NUMBER => p_qsh_OBJECT_VERSION_NUMBER ,
1183 p_qsh_CREATED_BY => p_qsh_CREATED_BY ,
1184 p_qsh_CREATION_DATE => p_qsh_CREATION_DATE ,
1185 p_qsh_LAST_UPDATED_BY => p_qsh_LAST_UPDATED_BY ,
1186 p_qsh_LAST_UPDATE_DATE => p_qsh_LAST_UPDATE_DATE ,
1187 p_qsh_LAST_UPDATE_LOGIN => p_qsh_LAST_UPDATE_LOGIN ,
1188 p_qsh_QUOTE_HEADER_ID => p_qsh_QUOTE_HEADER_ID ,
1189 p_qsh_QUOTE_SHAREE_NUMBER => p_qsh_QUOTE_SHAREE_NUMBER ,
1190 p_qsh_UPDATE_PRIV_TYPE_CODE => p_qsh_UPDATE_PRIV_TYPE_CODE ,
1191 p_qsh_SECURITY_GROUP_ID => p_qsh_SECURITY_GROUP_ID ,
1192 p_qsh_PARTY_ID => p_qsh_PARTY_ID ,
1193 p_qsh_CUST_ACCOUNT_ID => p_qsh_CUST_ACCOUNT_ID ,
1194 p_qsh_START_DATE_ACTIVE => p_qsh_START_DATE_ACTIVE ,
1195 p_qsh_END_DATE_ACTIVE => p_qsh_END_DATE_ACTIVE ,
1196 p_qsh_RECIPIENT_NAME => p_qsh_RECIPIENT_NAME ,
1197 p_qsh_CONTACT_POINT_ID => p_qsh_CONTACT_POINT_ID ,
1198 p_qsh_EMAIL_ADDRESS => p_qsh_EMAIL_ADDRESS ,
1199 p_qsh_NOTIFY_FLAG => p_qsh_NOTIFY_FLAG );
1200
1201 IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2
1202 (P_saveshare_control_rec => l_saveshare_control_rec,
1203 P_party_id => P_PARTY_ID,
1204 P_cust_account_id => P_CUST_ACCOUNT_ID,
1205 P_retrieval_number => P_retrieval_number,
1206 P_Quote_header_rec => L_QTE_HEADER_REC,
1207 P_quote_access_tbl => L_quote_access_tbl,
1208 P_source_quote_header_id => P_source_quote_header_id,
1209 P_source_last_update_date => P_source_last_update_date ,
1210 p_minisite_id => p_minisite_id,
1211 p_URL => p_URL,
1212 p_notes => p_notes,
1213 p_api_version => p_api_version_number,
1214 p_init_msg_list => p_init_msg_list,
1215 p_commit => p_commit,
1216 x_return_status => x_return_status,
1217 x_msg_count => x_msg_count,
1218 x_msg_data => x_msg_data) ;
1219
1220 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1221 IBE_UTIL.DEBUG(' IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2:END');
1222 END IF;
1223 END;
1224
1225 END IBE_Quote_W2_PVT;