[Home] [Help]
PACKAGE: APPS.OZF_RESALE_COMMON_PVT
Source
1 PACKAGE OZF_RESALE_COMMON_PVT AS
2 /* $Header: ozfvrscs.pls 120.4.12000000.3 2007/09/07 02:44:47 julou ship $ */
3
4
5 -- Default NUMBER of records fetch per call
6 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
7
8 G_ID_TYPE_BATCH CONSTANT VARCHAR2(30) := 'BATCH';
9 G_ID_TYPE_LINE CONSTANT VARCHAR2(30) := 'LINE';
10 G_ID_TYPE_IFACE CONSTANT VARCHAR2(30) := 'IFACE';
11
12 G_BATCH_NEW CONSTANT VARCHAR2(30) := 'NEW';
13 G_BATCH_OPEN CONSTANT VARCHAR2(30) := 'OPEN';
14 G_BATCH_PROCESSING CONSTANT VARCHAR2(30) := 'PROCESSING';
15 G_BATCH_PROCESSED CONSTANT VARCHAR2(30) := 'PROCESSED';
16 G_BATCH_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
17 G_BATCH_DISPUTED CONSTANT VARCHAR2(30) := 'DISPUTED';
18 G_BATCH_PENDING_PAYMENT CONSTANT VARCHAR2(30) := 'PENDING_PAYMENT';
19 G_BATCH_CLOSED CONSTANT VARCHAR2(30) := 'CLOSED';
20
21 G_BATCH_ADJ_NEW CONSTANT VARCHAR2(30) := 'NEW';
22 G_BATCH_ADJ_OPEN CONSTANT VARCHAR2(30) := 'OPEN';
23 G_BATCH_ADJ_PROCESSED CONSTANT VARCHAR2(30) := 'PROCESSED';
24 G_BATCH_ADJ_DUPLICATED CONSTANT VARCHAR2(30) := 'DUPLICATED';
25 G_BATCH_ADJ_DISPUTED CONSTANT VARCHAR2(30) := 'DISPUTED';
26 G_BATCH_ADJ_CLOSED CONSTANT VARCHAR2(30) := 'CLOSED';
27
28 G_TP_ACCRUAL CONSTANT VARCHAR2(30) := 'TP_ACCRUAL';
29 G_CHARGEBACK CONSTANT VARCHAR2(30) := 'CHARGEBACK';
30 G_TRACING CONSTANT VARCHAR2(30) := 'TRACING';
31 G_SPECIAL_PRICING CONSTANT VARCHAR2(30) := 'SHIP_DEBIT';
32
33 G_BATCH_REF_TYPE CONSTANT VARCHAR2(30) := 'BATCH';
34 G_BATCH_OBJECT_CLASS CONSTANT VARCHAR2(30) := 'BATCH';
35
36 G_INVALD_DISPUTE_CODE CONSTANT VARCHAR2(30) := 'INVLD';
37
38 -- julou bug 6317120. this assignment becomes invalid if MO: Operating Unit is not set. Get org_id from table.
39 --G_ORG_ID NUMBER := TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99));
40 CURSOR gc_batch_org_id(p_id NUMBER) IS
41 SELECT org_id
42 FROM ozf_resale_batches
43 WHERE resale_batch_id = p_id;
44
45 CURSOR gc_line_org_id(p_id NUMBER) IS
46 SELECT org_id
47 FROM ozf_resale_lines
48 WHERE resale_line_id = p_id;
49
50 CURSOR gc_iface_org_id(p_id NUMBER) IS
51 SELECT org_id
52 FROM ozf_resale_lines_int
53 WHERE resale_line_int_id = p_id;
54
55 -- Added by vanitha
56 TYPE party_rec_type IS RECORD
57 (
58 Partner_Party_ID NUMBER,
59 Name VARCHAR2(360),
60 Address VARCHAR2(240),
61 City VARCHAR2(60),
62 State VARCHAR2(60),
63 Postal_Code VARCHAR2(60),
64 Country VARCHAR2(60),
65 Site_Use_Code VARCHAR2(60),
66 Party_ID NUMBER,
67 Party_Site_ID NUMBER,
68 Party_Site_Use_ID NUMBER
69 );
70 --
71 CURSOR g_interface_rec_csr(p_id in NUMBER) IS
72 SELECT *
73 FROM ozf_resale_lines_int
74 WHERE resale_line_int_id = p_id;
75
76 CURSOR g_header_id_csr IS
77 SELECT ozf_resale_headers_all_s.nextval
78 FROM dual;
79
80 CURSOR g_line_id_csr IS
81 SELECT ozf_resale_lines_all_s.nextval
82 FROM dual;
83
84 CURSOR g_map_id_csr IS
85 SELECT ozf_resale_batch_line_map_s.nextval
86 FROM dual;
87
88 CURSOR g_log_id_csr IS
89 SELECT ozf_resale_logs_all_s.nextval
90 FROM dual;
91
92 CURSOR g_adjustment_id_csr IS
93 SELECT ozf_resale_adjustments_all_s.nextval
94 FROM dual;
95
96 CURSOR g_inventory_tracking_csr IS
97 SELECT inventory_tracking_flag
98 FROM ozf_sys_parameters;
99
100 TYPE interface_lines_tbl_type IS TABLE OF g_interface_rec_csr%rowtype INDEX BY BINARY_INTEGER;
101
102 TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
103 TYPE varchar_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
104 TYPE date_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
105 TYPE long_varchar_tbl_type IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
106
107 CURSOR g_batch_type_csr (p_id NUMBER) IS
108 SELECT batch_type
109 FROM ozf_resale_batches
110 WHERE resale_batch_id = p_id;
111
112 CURSOR g_total_amount_csr(p_id in NUMBER) IS
113 -- [BEGIN OF BUG 4376520 FIXING]
114 /*
115 SELECT sum(calculated_amount)
116 , sum(total_claimed_amount)
117 , sum(total_accepted_amount)
118 , sum(total_allowed_amount)
119 --, sum(total_accepted_amount - total_claimed_amount)
120 , sum(total_claimed_amount - total_allowed_amount)-- disputed amount
121 */
122 SELECT NVL(sum(calculated_amount), 0)
123 , NVL(sum(total_claimed_amount), 0)
124 , NVL(sum(total_accepted_amount), 0)
125 , NVL(sum(total_allowed_amount), 0)
126 -- BUG 4731894 (+)
127 --, NVL(sum(total_claimed_amount - total_allowed_amount), 0) -- disputed amount
128 , NVL(sum(NVL(total_claimed_amount, 0) - NVL(total_allowed_amount, 0)), 0) -- disputed amount
129 -- BUG 4731894 (-)
130 -- [END OF BUG 4376520 FIXING]
131 FROM ozf_resale_lines_int
132 WHERE resale_batch_id = p_id
133 -- [BEGIN OF BUG 4376520 FIXING]
134 AND NVL(tracing_flag, 'F') <> 'T'
135 -- [END OF BUG 4376520 FIXING]
136 AND status_code <> 'DUPLICATED'; -- BUG 4930718
137
138 CURSOR g_disputed_line_count_csr (p_id NUMBER)IS
139 SELECT count(1)
140 FROM ozf_resale_lines_int
141 WHERE status_code = G_BATCH_ADJ_DISPUTED
142 AND resale_batch_id = p_id;
143
144 CURSOR g_exchange_rate_type_csr IS
145 SELECT exchange_rate_type
146 FROM ozf_sys_parameters;
147
148 -- Start: bug # 5997978 fixed
149 CURSOR g_resale_batch_org_id_csr(cv_batch_id NUMBER) IS
150 SELECT org_id
151 FROM ozf_resale_batches_all
152 WHERE resale_batch_id = cv_batch_id;
153
154 CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
155 SELECT org_id
156 FROM ozf_resale_headers_all
157 WHERE resale_header_id = cv_header_id;
158 -- End: bug # 5997978 fixed
159
160
161 ---------------------------------------------------------------------
162 -- PROCEDURE
163 -- Insert_Resale_Log
164 --
165 -- PURPOSE
166 -- This procedure inserts a error log
167 --
168 -- PARAMETERS
169 --
170 --
171 -- NOTES
172 ---------------------------------------------------------------------
173 PROCEDURE Insert_Resale_Log (
174 p_id_value IN VARCHAR2,
175 p_id_type IN VARCHAR2,
176 p_error_code IN VARCHAR2,
177 p_error_message IN VARCHAR2 := NULL,
178 p_column_name IN VARCHAR2,
179 p_column_value IN VARCHAR2,
180 x_return_status OUT NOCOPY VARCHAR2 );
181
182 ---------------------------------------------------------------------
183 -- PROCEDURE
184 -- Bulk_Insert_Resale_Log
185 --
186 -- PURPOSE
187 -- This procecure inserts error log for multiple resale interface lines using
188 -- bulk insert function
189 --
190 -- PARAMETERS
191 --
192 --
193 -- NOTES
194 ---------------------------------------------------------------------
195 PROCEDURE Bulk_Insert_Resale_Log (
196 p_id_value IN number_tbl_type,
197 p_id_type IN VARCHAR2,
198 p_error_code IN varchar_tbl_type,
199 p_column_name IN varchar_tbl_type,
200 p_column_value IN long_varchar_tbl_type,
201 p_batch_id IN NUMBER, -- bug # 5997978 fixed
202 x_return_status OUT NOCOPY VARCHAR2
203 );
204
205 ---------------------------------------------------------------------
206 -- PROCEDURE
207 -- Bulk_Dispute_Line
208 --
209 -- PURPOSE
210 -- This procedure sets the statuses of interface lines that have disputes
211 --
212 -- PARAMETERS
213 --
214 --
215 -- NOTES
216 ---------------------------------------------------------------------
217 PROCEDURE Bulk_Dispute_Line (
218 p_batch_id IN NUMBER,
219 p_line_status IN VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2
221 );
222
223 ---------------------------------------------------------------------
224 -- PROCEDURE
225 -- Update_Header_Calculations
226 --
227 -- PURPOSE
228 -- ThIS procedure updates the results of chargeback processing
229 --
230 -- PARAMETERS
231 --
232 --
233 -- NOTES
234 ---------------------------------------------------------------------
235 PROCEDURE Update_Batch_Calculations (
236 p_api_version IN NUMBER
237 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
239 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240 ,p_resale_batch_id IN NUMBER
241 ,x_return_status OUT NOCOPY VARCHAR2
242 ,x_msg_data OUT NOCOPY VARCHAR2
243 ,x_msg_count OUT NOCOPY NUMBER
244 );
245
246 ---------------------------------------------------------------------
247 -- PROCEDURE
248 -- Update_Line_Calculations
249 --
250 -- PURPOSE
251 --
252 -- PARAMETERS
253 -- x_return_status out VARCHAR2
254 --
255 -- NOTES
256 --
257 ---------------------------------------------------------------------
258 PROCEDURE Update_Line_Calculations(
259 p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE,
260 p_unit_price IN NUMBER,
261 p_line_quantity IN NUMBER,
262 p_allowed_amount IN NUMBER,
263 x_return_status OUT NOCOPY VARCHAR2
264 );
265
266 ---------------------------------------------------------------------
267 -- PROCEDURE
268 -- Validate_Batch
269 --
270 -- PURPOSE
271 -- This procedure validates the batch information
272 -- make sure that we can process this batch.
273 --
274 -- PARAMETERS
275 --
276 --
277 -- NOTES
278 ---------------------------------------------------------------------
279 PROCEDURE Validate_Batch(
280 p_api_version IN NUMBER
281 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
282 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
283 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284 ,p_resale_batch_id IN NUMBER
285 ,x_batch_status OUT NOCOPY VARCHAR2
286 ,x_return_status OUT NOCOPY VARCHAR2
287 ,x_msg_data OUT NOCOPY VARCHAR2
288 ,x_msg_count OUT NOCOPY NUMBER
289 );
290
291 ---------------------------------------------------------------------
292 -- PROCEDURE
293 -- Validate_Order_Record
294 --
295 -- PURPOSE
296 -- This procedure validates the order information
297 -- I will only validate cust_account_id, currency_code and uom
298 --
299 -- PARAMETERS
300 --
301 --
302 -- NOTES
303 ---------------------------------------------------------------------
304 PROCEDURE Validate_Order_Record(
305 p_api_version IN NUMBER
306 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
308 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
309 ,p_resale_batch_id IN NUMBER
310 ,x_return_status OUT NOCOPY VARCHAR2
311 ,x_msg_data OUT NOCOPY VARCHAR2
312 ,x_msg_count OUT NOCOPY NUMBER
313 );
314
315 ---------------------------------------------------------------------
316 -- PROCEDURE
317 -- Update_Duplicates
318 --
319 -- PURPOSE
320 -- This procedure updates the duplicates
321 --
322 -- PARAMETERS
323 --
324 --
325 -- NOTES
326 ---------------------------------------------------------------------
327 PROCEDURE Update_Duplicates (
328 p_api_version IN NUMBER
329 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
330 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
331 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
332 ,p_resale_batch_id IN NUMBER
333 ,p_resale_batch_type IN VARCHAR2
334 ,p_batch_status IN VARCHAR2
335 ,x_batch_status OUT NOCOPY VARCHAR2
336 ,x_return_status OUT NOCOPY VARCHAR2
337 ,x_msg_data OUT NOCOPY VARCHAR2
338 ,x_msg_count OUT NOCOPY NUMBER
339 );
340
341 ---------------------------------------------------------------------
342 -- PROCEDURE
343 -- Check_Duplicate_Line
344 --
345 -- PURPOSE
346 -- This procedure tries to see whether the current line and adjustments have been sent before.
347 --
348 -- PARAMETERS
349 --
350 --
351 -- NOTES
352 ---------------------------------------------------------------------
353 PROCEDURE Check_Duplicate_Line(
354 p_api_version_number IN NUMBER
355 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358 ,p_resale_line_int_id IN NUMBER
359 ,p_direct_customer_flag IN VARCHAR2
360 ,p_claimed_amount IN NUMBER
361 ,p_batch_type IN VARCHAR2
362 ,x_dup_line_id OUT NOCOPY NUMBER
363 ,x_dup_adjustment_id OUT NOCOPY NUMBER
364 ,x_reprocessing OUT NOCOPY BOOLEAN
365 ,x_return_status OUT NOCOPY VARCHAR2
366 ,x_msg_count OUT NOCOPY NUMBER
367 ,x_msg_data OUT NOCOPY VARCHAR2
368 );
369
370 ---------------------------------------------------------------------
371 -- PROCEDURE
372 -- Create_Utilization
373 --
374 -- PURPOSE
375 -- ThIS procedure prepare the record FOR utilization
376 --
380 -- NOTES
377 -- PARAMETERS
378 --
379 --
381 ---------------------------------------------------------------------
382 PROCEDURE Create_Utilization(
383 p_api_version IN NUMBER
384 ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
385 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
386 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
387 ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
388 ,p_fund_id IN NUMBER
389 ,p_line_id IN NUMBER
390 ,p_cust_account_id IN NUMBER
391 ,p_approver_id IN NUMBER
392 ,x_return_status OUT NOCOPY VARCHAR2
393 ,x_msg_data OUT NOCOPY VARCHAR2
394 ,x_msg_count OUT NOCOPY NUMBER
395 );
396
397 ---------------------------------------------------------------------
398 -- PROCEDURE
399 -- Create_Adj_And_Utilization
400 --
401 -- PURPOSE
402 -- This procedure adjustment and utilization
403 --
404 -- PARAMETERS
405 --
406 --
407 -- NOTES
408 ---------------------------------------------------------------------
409 PROCEDURE Create_Adj_And_Utilization(
410 p_api_version IN NUMBER
411 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
414 ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
415 ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
416 ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
417 ,p_to_create_utilization IN BOOLEAN
418 ,x_return_status OUT NOCOPY VARCHAR2
419 ,x_msg_data OUT NOCOPY VARCHAR2
420 ,x_msg_count OUT NOCOPY NUMBER
421 );
422
423 ---------------------------------------------------------------------
424 -- PROCEDURE
425 -- Create_Sales_Transaction
426 --
427 -- PURPOSE
428 -- This procedure inserts a record in ozf sales transaction table
429 --
430 -- PARAMETERS
431 -- p_line_int_rec IN g_interface_rec_csr%rowtype,
432 -- x_headerid out NUMBER
433 -- x_return_status out VARCHAR2
434 --
435 -- NOTES
436 --
437 ---------------------------------------------------------------------
438 PROCEDURE Create_Sales_Transaction(
439 p_api_version IN NUMBER
440 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
442 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443 ,p_line_int_rec IN g_interface_rec_csr%rowtype
444 ,p_header_id IN NUMBER
445 ,p_line_id IN NUMBER
446 ,x_sales_transaction_id OUT NOCOPY NUMBER
447 ,x_return_status OUT NOCOPY VARCHAR2
448 ,x_msg_data OUT NOCOPY VARCHAR2
449 ,x_msg_count OUT NOCOPY NUMBER
450 );
451
452 ---------------------------------------------------------------------
453 -- PROCEDURE
454 -- Insert_Resale_Header
455 --
456 -- PURPOSE
457 -- This procedure inserts a record in resale header table
458 --
459 -- PARAMETERS
460 -- p_line_int_rec IN g_interface_rec_csr%rowtype,
461 -- x_headerid out NUMBER
462 -- x_return_status out VARCHAR2
463 --
464 -- NOTES
465 --
466 ---------------------------------------------------------------------
467 PROCEDURE Insert_Resale_Header(
468 p_api_version IN NUMBER
469 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
470 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
471 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
472 ,p_line_int_rec IN g_interface_rec_csr%rowtype
473 ,x_header_id OUT NOCOPY NUMBER
474 ,x_return_status OUT NOCOPY VARCHAR2
475 ,x_msg_data OUT NOCOPY VARCHAR2
476 ,x_msg_count OUT NOCOPY NUMBER
477 );
478
479 ---------------------------------------------------------------------
480 -- PROCEDURE
481 -- Insert_Resale_Line
482 --
483 -- PURPOSE
484 -- This procedure inserts a record in resale line table
485 --
486 -- PARAMETERS
487 -- p_line_int_rec IN g_interface_rec_csr%rowtype,
488 -- x_return_status out VARCHAR2
489 --
490 -- NOTES
491 --
492 ---------------------------------------------------------------------
493 PROCEDURE Insert_Resale_Line(
494 p_api_version IN NUMBER
495 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
496 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
497 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
498 ,p_line_int_rec IN g_interface_rec_csr%rowtype
499 ,p_header_id IN NUMBER
500 ,x_line_id OUT NOCOPY NUMBER
501 ,x_return_status OUT NOCOPY VARCHAR2
502 ,x_msg_data OUT NOCOPY VARCHAR2
506 ---------------------------------------------------------------------
503 ,x_msg_count OUT NOCOPY NUMBER
504 );
505
507 -- PROCEDURE
508 -- Insert_Resale_Line_Mapping
509 --
510 -- PURPOSE
511 -- This procedure inserts a record in resale_batch_line_mapping table
512 --
513 -- PARAMETERS
514 -- p_line_int_rec IN g_interface_rec_csr%rowtype,
515 -- x_return_status out VARCHAR2
516 --
517 -- NOTES
518 --
519 ---------------------------------------------------------------------
520 PROCEDURE Insert_Resale_Line_Mapping(
521 p_api_version IN NUMBER
522 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
523 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
524 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525 ,p_resale_batch_id IN NUMBER
526 ,p_line_id IN NUMBER
527 ,x_return_status OUT NOCOPY VARCHAR2
528 ,x_msg_data OUT NOCOPY VARCHAR2
529 ,x_msg_count OUT NOCOPY NUMBER
530 );
531
532 ---------------------------------------------------------------------
533 -- PROCEDURE
534 -- Delete_Log
535 --
536 -- PURPOSE
537 -- This procedure delets the log for all open lines of batch
538 --
539 -- PARAMETERS
540 -- p_resale_batch_id in number
541 --
542 -- NOTES
543 -----------------------------------------------------------------------
544 PROCEDURE Delete_Log(
545 p_api_version IN NUMBER
546 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
548 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549 ,p_resale_batch_id IN NUMBER
550 ,x_return_status OUT NOCOPY VARCHAR2
551 ,x_msg_data OUT NOCOPY VARCHAR2
552 ,x_msg_count OUT NOCOPY NUMBER
553 );
554
555 ---------------------------------------------------------------------
556 -- PROCEDURE
557 -- Create_Party
558 --
559 -- PURPOSE
560 -- This procedure creates party, party site, party site use and relationship
561 --
562 -- PARAMETERS
563 -- px_party_rec IN OUT party_rec_type
564 -- x_return_status out VARCHAR2
565 --
566 -- NOTES
567 --
568 ---------------------------------------------------------------------
569 PROCEDURE Create_Party
570 ( p_api_version IN NUMBER
571 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
572 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
573 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
574 ,px_party_rec IN OUT NOCOPY party_rec_type
575 ,x_return_status OUT NOCOPY VARCHAR2
576 ,x_msg_count OUT NOCOPY NUMBER
577 ,x_msg_data OUT NOCOPY VARCHAR2
578 );
579
580 ---------------------------------------------------------------------
581 -- PROCEDURE
582 -- Build_Global_Resale_Rec
583 --
584 -- PURPOSE
585 -- Build Global Resale Record for Pricing Simulation
586 --
587 -- PARAMETERS
588 -- p_caller_type IN VARCHAR2
589 -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
590 -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
591 --
592 -- NOTES
593 --
594 ---------------------------------------------------------------------
595 PROCEDURE Build_Global_Resale_Rec(
596 p_api_version IN NUMBER
597 ,p_init_msg_list IN VARCHAR2
598 ,p_commit IN VARCHAR2
599 ,p_validation_level IN NUMBER
600 ,p_caller_type IN VARCHAR2
601 ,p_line_index IN NUMBER
602 ,p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
603 ,p_resale_header_rec IN OZF_RESALE_HEADERS%ROWTYPE
604 ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
605 ,x_return_status OUT NOCOPY VARCHAR2
606 ,x_msg_count OUT NOCOPY NUMBER
607 ,x_msg_data OUT NOCOPY VARCHAR2
608 );
609
610
611 END OZF_RESALE_COMMON_PVT;