[Home] [Help]
PACKAGE: APPS.OZF_PRE_PROCESS_PVT
Source
1 PACKAGE ozf_pre_process_pvt AS
2 /*$Header: ozfpprss.pls*/
3
4 -- Record Types
5
6 TYPE party_rec_type is RECORD
7 (
8 party_id NUMBER,
9 party_type VARCHAR2(30),
10 duns_number VARCHAR2(100),
11 party_name VARCHAR2(100),
12 party_rule_name VARCHAR2(100)
13 );
14
15 TYPE party_site_rec_type is RECORD
16 (
17 party_site_id NUMBER,
18 address VARCHAR2(1000),
19 city VARCHAR2(100),
20 state VARCHAR2(100),
21 country VARCHAR2(300),
22 postal_code VARCHAR2(100),
23 party_site_rule_name VARCHAR2(100)
24 );
25
26 TYPE party_cntct_rec_type is RECORD
27 (
28 contact_party_id NUMBER,
29 contact_name VARCHAR2(240),
30 party_email_id VARCHAR2(240),
31 party_phone VARCHAR2(240),
32 party_fax VARCHAR2(240),
33 contact_rule_name VARCHAR2(100)
34 );
35
36
37 TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
38 TYPE varchar2_table IS TABLE OF VARCHAR2(5000) INDEX BY BINARY_INTEGER;
39 TYPE date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
40
41 TYPE resale_line_int_tbl_type IS TABLE OF ozf_resale_lines_int_all%rowtype;
42
43 TYPE resale_line_int_rec_type is RECORD
44 (
45 resale_line_int_id NUMBER_TABLE,
46 object_version_number NUMBER_TABLE,
47 resale_batch_id NUMBER_TABLE,
48 status_code VARCHAR2_TABLE,
49 resale_transfer_type VARCHAR2_TABLE,
50 product_transfer_movement_type VARCHAR2_TABLE,
51 tracing_flag VARCHAR2_TABLE,
52 ship_from_cust_account_id NUMBER_TABLE,
53 ship_from_site_id NUMBER_TABLE,
54 ship_from_party_name VARCHAR2_TABLE,
55 ship_from_location VARCHAR2_TABLE,
56 ship_from_address VARCHAR2_TABLE,
57 ship_from_city VARCHAR2_TABLE,
58 ship_from_state VARCHAR2_TABLE,
59 ship_from_postal_code VARCHAR2_TABLE,
60 ship_from_country VARCHAR2_TABLE,
61 ship_from_contact_party_id NUMBER_TABLE,
62 ship_from_contact_name VARCHAR2_TABLE,
63 ship_from_email VARCHAR2_TABLE,
64 ship_from_fax VARCHAR2_TABLE,
65 ship_from_phone VARCHAR2_TABLE,
66 sold_from_cust_account_id NUMBER_TABLE,
67 sold_from_site_id NUMBER_TABLE,
68 sold_from_party_name VARCHAR2_TABLE,
69 sold_from_location VARCHAR2_TABLE,
70 sold_from_address VARCHAR2_TABLE,
71 sold_from_city VARCHAR2_TABLE,
72 sold_from_state VARCHAR2_TABLE,
73 sold_from_postal_code VARCHAR2_TABLE,
74 sold_from_country VARCHAR2_TABLE,
75 sold_from_contact_party_id NUMBER_TABLE,
76 sold_from_contact_name VARCHAR2_TABLE,
77 sold_from_email VARCHAR2_TABLE,
78 sold_from_phone VARCHAR2_TABLE,
79 sold_from_fax VARCHAR2_TABLE,
80 bill_to_cust_account_id NUMBER_TABLE,
81 bill_to_site_use_id NUMBER_TABLE,
82 bill_to_party_id NUMBER_TABLE,
83 bill_to_party_site_id NUMBER_TABLE,
84 bill_to_party_name VARCHAR2_TABLE,
85 bill_to_duns_number VARCHAR2_TABLE,
86 bill_to_location VARCHAR2_TABLE,
87 bill_to_address VARCHAR2_TABLE,
88 bill_to_city VARCHAR2_TABLE,
89 bill_to_state VARCHAR2_TABLE,
90 bill_to_postal_code VARCHAR2_TABLE,
91 bill_to_country VARCHAR2_TABLE,
92 bill_to_contact_party_id NUMBER_TABLE,
93 bill_to_contact_name VARCHAR2_TABLE,
94 bill_to_email VARCHAR2_TABLE,
95 bill_to_phone VARCHAR2_TABLE,
96 bill_to_fax VARCHAR2_TABLE,
97 ship_to_cust_account_id NUMBER_TABLE,
98 ship_to_site_use_id NUMBER_TABLE,
99 ship_to_party_id NUMBER_TABLE,
100 ship_to_party_site_id NUMBER_TABLE,
101 ship_to_party_name VARCHAR2_TABLE,
102 ship_to_duns_number VARCHAR2_TABLE,
103 ship_to_location VARCHAR2_TABLE,
104 ship_to_address VARCHAR2_TABLE,
105 ship_to_city VARCHAR2_TABLE,
106 ship_to_country VARCHAR2_TABLE,
107 ship_to_postal_code VARCHAR2_TABLE,
108 ship_to_state VARCHAR2_TABLE,
109 ship_to_contact_party_id NUMBER_TABLE,
110 ship_to_contact_name VARCHAR2_TABLE,
111 ship_to_email VARCHAR2_TABLE,
112 ship_to_phone VARCHAR2_TABLE,
113 ship_to_fax VARCHAR2_TABLE,
114 end_cust_party_id NUMBER_TABLE,
115 end_cust_site_use_id NUMBER_TABLE,
116 end_cust_site_use_code VARCHAR2_TABLE,
117 end_cust_party_site_id NUMBER_TABLE,
118 end_cust_party_name VARCHAR2_TABLE,
119 end_cust_location VARCHAR2_TABLE,
120 end_cust_address VARCHAR2_TABLE,
121 end_cust_city VARCHAR2_TABLE,
122 end_cust_state VARCHAR2_TABLE,
123 end_cust_postal_code VARCHAR2_TABLE,
124 end_cust_country VARCHAR2_TABLE,
125 end_cust_contact_party_id NUMBER_TABLE,
126 end_cust_contact_name VARCHAR2_TABLE,
127 end_cust_email VARCHAR2_TABLE,
128 end_cust_phone VARCHAR2_TABLE,
129 end_cust_fax VARCHAR2_TABLE,
130 direct_customer_flag VARCHAR2_TABLE,
131 order_type_id NUMBER_TABLE,
132 order_type VARCHAR2_TABLE,
133 order_category VARCHAR2_TABLE,
134 agreement_type VARCHAR2_TABLE,
135 agreement_id NUMBER_TABLE,
136 agreement_name VARCHAR2_TABLE,
137 agreement_price NUMBER_TABLE,
138 agreement_uom_code VARCHAR2_TABLE,
139 corrected_agreement_id NUMBER_TABLE,
140 corrected_agreement_name VARCHAR2_TABLE,
141 price_list_id NUMBER_TABLE,
142 orig_system_currency_code VARCHAR2_TABLE,
143 orig_system_selling_price NUMBER_TABLE,
144 orig_system_quantity NUMBER_TABLE,
145 orig_system_uom VARCHAR2_TABLE,
146 orig_system_purchase_uom VARCHAR2_TABLE,
147 orig_system_purchase_curr VARCHAR2_TABLE,
148 orig_system_purchase_price NUMBER_TABLE,
149 orig_system_purchase_quantity NUMBER_TABLE,
150 orig_system_agreement_uom VARCHAR2_TABLE,
151 orig_system_agreement_name VARCHAR2_TABLE,
152 orig_system_agreement_type VARCHAR2_TABLE,
153 orig_system_agreement_curr VARCHAR2_TABLE,
154 orig_system_agreement_price NUMBER_TABLE,
155 orig_system_agreement_quantity NUMBER_TABLE,
156 orig_system_item_number VARCHAR2_TABLE,
157 currency_code VARCHAR2_TABLE,
158 exchange_rate_type VARCHAR2_TABLE,
159 exchange_rate_date DATE_TABLE,
160 exchange_rate NUMBER_TABLE,
161 order_number VARCHAR2_TABLE,
162 date_ordered DATE_TABLE,
163 claimed_amount NUMBER_TABLE,
164 total_claimed_amount NUMBER_TABLE,
165 purchase_price NUMBER_TABLE,
166 acctd_purchase_price NUMBER_TABLE,
167 purchase_uom_code VARCHAR2_TABLE,
168 selling_price NUMBER_TABLE,
169 acctd_selling_price NUMBER_TABLE,
170 uom_code VARCHAR2_TABLE,
171 quantity NUMBER_TABLE,
172 inventory_item_id NUMBER_TABLE,
173 item_number VARCHAR2_TABLE,
174 dispute_code VARCHAR2_TABLE,
175 data_source_code VARCHAR2_TABLE,
176 org_id NUMBER_TABLE,
177 response_code VARCHAR2_TABLE );
178
179
180 -- Transaction Type
181
182 g_product_transfer CONSTANT VARCHAR2(30) := '01';
183 g_resale CONSTANT VARCHAR2(30) := '02';
184 g_req_for_credit CONSTANT VARCHAR2(30) := 'RA';
185
186 -- Resale Transfer Type
187
188 g_tsfr_return CONSTANT VARCHAR2(20) := 'BN';
189 g_tsfr_ship_debit_sale CONSTANT VARCHAR2(20) := 'SD';
190 g_tsfr_stock_sale CONSTANT VARCHAR2(20) := 'SS';
191 g_tsfr_inter_branch CONSTANT VARCHAR2(20) := 'IB';
192
193 -- Product Transfer Movement Type
194
195 g_mvmt_cust_to_dist CONSTANT varchar2(20) := 'CD';
196 g_mvmt_dist_to_cust CONSTANT varchar2(20) := 'DC';
197 g_mvmt_tsfr_in CONSTANT varchar2(20) := 'TI';
198 g_mvmt_tsfr_out CONSTANT varchar2(20) := 'TO';
199 g_mvmt_dist_to_mf CONSTANT varchar2(20) := 'DM';
200 g_mvmt_mf_to_dist CONSTANT varchar2(20) := 'MD';
201
202 -- Transaction Purpose Code
203
204 g_original CONSTANT varchar2(20) := '00';
205
206 -- Partner Types
207 g_distributor CONSTANT varchar2(20) := 'DS';
208
209
210 -- Mapping Types
211 g_uom_type CONSTANT varchar2(20) := 'OZF_UOM_CODES';
212 g_product_type CONSTANT varchar2(20) := 'OZF_PRODUCT_CODES';
213 g_agreement_type CONSTANT varchar2(20) := 'OZF_AGREEMENT_CODES';
214
215 -- Agreement Types
216 g_price_list CONSTANT varchar2(20) := 'PL';
217 g_special_price CONSTANT varchar2(20) := 'SPO';
218
219 -- Status Code
220 g_batch_new CONSTANT varchar2(20) := 'NEW';
221 g_batch_rejected CONSTANT varchar2(20) := 'REJECTED';
222 g_batch_open CONSTANT varchar2(20) := 'OPEN';
223 g_batch_disputed CONSTANT varchar2(20) := 'DISPUTED';
224
225 -- Event Names
226 g_xml_outbound_event CONSTANT varchar2(30) := 'oracle.apps.ozf.idsm.reslo';
227 g_xml_confirm_bod_event CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.confirm';
228 g_xml_data_process_event CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.XMLProcess';
229 g_webadi_data_process_event CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.WEBADIProcess';
230
231 -- Workflow Item Type
232 g_xml_import_workflow CONSTANT varchar2(30) := 'OZFRESO';
233 g_data_process_workflow CONSTANT varchar2(30) := 'OZFRSIFD';
234
235 PROCEDURE webadi_import
236 (
237 p_batch_number IN VARCHAR2,
238 x_return_status OUT NOCOPY VARCHAR2
239 );
240
241 PROCEDURE process_xmlgt_inbwf
242 (
243 itemtype IN VARCHAR2,
244 itemkey IN VARCHAR2,
245 actid IN NUMBER,
246 funcmode IN VARCHAR2,
247 resultout IN OUT NOCOPY VARCHAR2
248 );
249
250
251 PROCEDURE resale_pre_process
252 (
253 p_api_version_number IN NUMBER,
254 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255 p_commit IN VARCHAR2 := FND_API.G_FALSE,
256 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257 p_batch_id IN NUMBER,
258 x_batch_status OUT NOCOPY VARCHAR2,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2
262 );
263
264 PROCEDURE Batch_Update (
265 p_api_version_number IN NUMBER,
266 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267 p_commit IN VARCHAR2 := FND_API.G_FALSE,
268 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269 p_batch_id IN NUMBER,
270 x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2
274 );
275
276 PROCEDURE Batch_Fetch
277 (
278 p_batch_id IN NUMBER,
279 x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
280 x_return_status OUT NOCOPY VARCHAR2
281 );
282
283 PROCEDURE Validate_Batch
284 (
285 p_api_version_number IN NUMBER,
286 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287 p_commit IN VARCHAR2 := FND_API.G_FALSE,
288 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289 p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
290 x_batch_status OUT NOCOPY VARCHAR2,
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2
294 );
295
296 PROCEDURE Batch_Defaulting
297 (
298 p_api_version_number IN NUMBER,
299 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300 p_commit IN VARCHAR2 := FND_API.G_FALSE,
301 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302 px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2
306 );
307
308 PROCEDURE Lines_Update
309 (
310 p_batch_id IN NUMBER,
311 px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER
315 );
316
317 PROCEDURE Lines_Process
318 (
319 p_line_count IN NUMBER,
320 px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
324 x_msg_count OUT NOCOPY NUMBER
321 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_data OUT NOCOPY VARCHAR2,
325 );
326
327 PROCEDURE Lines_Bulk_Update
328 (
329 p_batch_id IN NUMBER,
330 p_line_record IN resale_line_int_rec_type,
331 x_return_status OUT NOCOPY VARCHAR2
332 );
333
334
335
336 PROCEDURE Line_Defaulting
337 (
338 p_line_count IN NUMBER,
339 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
340 x_return_status OUT NOCOPY VARCHAR2
341 );
342
343 PROCEDURE Line_Validations
344 (
345 p_line_count IN NUMBER,
346 px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
347 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
348 x_return_status OUT NOCOPY VARCHAR2
349 );
350
351 PROCEDURE Code_ID_Mapping
352 (
353 p_batch_record IN ozf_resale_batches_all%ROWTYPE,
354 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_data OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER
358 );
359
360 PROCEDURE Line_Party_Validations
361 (
362 p_line_count IN NUMBER,
363 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
364 x_return_status OUT NOCOPY VARCHAR2
365 );
366
367 PROCEDURE Line_Currency_Price_Derivation
368 (
369 p_line_count IN NUMBER,
370 px_line_record IN OUT NOCOPY resale_line_int_rec_type,
371 x_return_status OUT NOCOPY VARCHAR2
372 );
373
374
375 PROCEDURE Currency_Price_Derivation
376 (
377 p_line_count IN NUMBER,
378 p_conversion_type IN VARCHAR2,
379 p_int_line_id_tbl IN NUMBER_TABLE,
380 p_external_price_tbl IN NUMBER_TABLE,
381 p_conversion_date_tbl IN DATE_TABLE,
382 p_ext_currency_tbl IN VARCHAR2_TABLE,
383 px_internal_price_tbl IN OUT NOCOPY NUMBER_TABLE,
384 px_currency_tbl IN OUT NOCOPY VARCHAR2_TABLE,
385 px_exchange_rate_tbl IN OUT NOCOPY NUMBER_TABLE,
386 px_rate_type_tbl IN OUT NOCOPY VARCHAR2_TABLE,
387 x_accounted_price_tbl OUT NOCOPY NUMBER_TABLE,
388 px_status_tbl IN OUT NOCOPY VARCHAR2_TABLE,
389 px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
390 x_return_status OUT NOCOPY VARCHAR2
391 );
392
393 PROCEDURE Agreement_Default
394 (
395 p_party_id IN NUMBER,
396 p_cust_account_id IN NUMBER,
397 p_batch_type IN VARCHAR2,
398 p_interface_line_id_tbl IN NUMBER_TABLE,
399 p_ext_agreement_name IN VARCHAR2_TABLE,
400 p_ext_agreement_type IN VARCHAR2_TABLE,
401 px_int_agreement_name IN OUT NOCOPY VARCHAR2_TABLE,
402 px_int_agreement_type IN OUT NOCOPY VARCHAR2_TABLE,
403 px_agreement_id IN OUT NOCOPY NUMBER_TABLE,
404 px_corrected_agreement_id IN OUT NOCOPY NUMBER_TABLE,
405 px_corrected_agreement_name IN OUT NOCOPY VARCHAR2_TABLE,
406 px_status_tbl IN OUT NOCOPY VARCHAR2_TABLE,
407 px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
408 p_resale_transfer_type IN VARCHAR2_TABLE,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2
412 );
413
414 PROCEDURE Product_validations
415 (
416 p_party_id IN VARCHAR2,
417 p_cust_account_id IN VARCHAR2,
418 p_interface_line_id_tbl IN NUMBER_TABLE,
419 p_ext_item_number_tbl IN VARCHAR2_TABLE,
420 p_item_number_tbl IN VARCHAR2_TABLE,
421 px_item_id_tbl IN OUT NOCOPY NUMBER_TABLE,
422 px_status_tbl IN OUT NOCOPY VARCHAR2_TABLE,
423 px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2
427 );
428
429 PROCEDURE UOM_Code_Mapping
430 (
431 p_party_id IN NUMBER,
432 p_cust_account_id IN NUMBER,
433 p_interface_line_id_tbl IN NUMBER_TABLE,
434 p_ext_purchase_uom IN VARCHAR2_TABLE,
435 p_ext_uom IN VARCHAR2_TABLE,
436 p_ext_agreement_uom IN VARCHAR2_TABLE,
437 px_int_purchase_uom IN OUT NOCOPY VARCHAR2_TABLE,
438 px_int_uom IN OUT NOCOPY VARCHAR2_TABLE,
439 px_int_agreement_uom IN OUT NOCOPY VARCHAR2_TABLE,
440 px_status_tbl IN OUT NOCOPY VARCHAR2_TABLE,
441 px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
442 x_return_status OUT NOCOPY VARCHAR2,
443 x_msg_count OUT NOCOPY NUMBER,
444 x_msg_data OUT NOCOPY VARCHAR2
445 );
446
447 PROCEDURE Party_Mapping
448 (
449 p_party_id IN NUMBER,
450 p_cust_account_id IN NUMBER,
454 px_cust_account_id_tbl IN OUT NOCOPY NUMBER_TABLE,
451 p_party_type IN VARCHAR2,
452 p_party_name_tbl IN OUT NOCOPY VARCHAR2_TABLE,
453 p_location_tbl IN OUT NOCOPY VARCHAR2_TABLE,
455 px_site_use_id_tbl IN OUT NOCOPY NUMBER_TABLE,
456 px_party_id_tbl IN OUT NOCOPY NUMBER_TABLE,
457 px_party_site_id_tbl IN OUT NOCOPY NUMBER_TABLE,
458 x_return_status OUT NOCOPY VARCHAR2
459 );
460
461 PROCEDURE Party_Validations
462 (
463 p_resale_line_int_id IN NUMBER_TABLE,
464 p_location IN VARCHAR2_TABLE,
465 p_address IN VARCHAR2_TABLE,
466 p_city IN VARCHAR2_TABLE,
467 p_state IN VARCHAR2_TABLE,
468 p_postal_code IN VARCHAR2_TABLE,
469 p_country IN VARCHAR2_TABLE,
470 p_contact_name IN VARCHAR2_TABLE,
471 p_email IN VARCHAR2_TABLE,
472 p_fax IN VARCHAR2_TABLE,
473 p_phone IN VARCHAR2_TABLE,
474 p_site_use_type IN VARCHAR2_TABLE,
475 p_direct_customer_flag IN VARCHAR2_TABLE,
476 p_party_type IN VARCHAR2,
477 p_line_count IN NUMBER,
478 px_party_name IN OUT NOCOPY VARCHAR2_TABLE,
479 px_cust_account_id IN OUT NOCOPY NUMBER_TABLE,
480 px_site_use_id IN OUT NOCOPY NUMBER_TABLE,
481 px_party_id IN OUT NOCOPY NUMBER_TABLE,
482 px_party_site_id IN OUT NOCOPY NUMBER_TABLE,
483 px_contact_party_id IN OUT NOCOPY NUMBER_TABLE,
484 px_status_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
485 px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE,
486 x_return_status OUT NOCOPY VARCHAR2
487 );
488
489 PROCEDURE DQM_processing (
490 p_api_version_number IN NUMBER,
491 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
492 p_commit IN VARCHAR2 := FND_API.G_FALSE,
493 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
494 p_party_rec IN party_rec_type,
495 p_party_site_rec IN party_site_rec_type,
496 p_contact_rec IN party_cntct_rec_type,
497 x_party_id OUT NOCOPY NUMBER,
498 x_party_site_id OUT NOCOPY NUMBER,
499 x_party_contact_id OUT NOCOPY NUMBER,
500 x_return_status OUT NOCOPY VARCHAR2,
501 x_msg_count OUT NOCOPY NUMBER,
502 x_msg_data OUT NOCOPY VARCHAR2
503 );
504
505
506 PROCEDURE code_conversion
507 (
508 p_party_id IN VARCHAR2,
509 p_cust_account_id IN VARCHAR2,
510 p_mapping_type IN VARCHAR2,
511 p_external_code_tbl IN VARCHAR2_TABLE,
512 x_internal_code_tbl OUT NOCOPY VARCHAR2_TABLE,
513 x_return_status OUT NOCOPY VARCHAR2,
514 x_msg_count OUT NOCOPY NUMBER,
515 x_msg_data OUT NOCOPY VARCHAR2
516 );
517
518 PROCEDURE Get_Customer_Accnt_Id(
519 p_party_id IN NUMBER,
520 p_party_site_id IN NUMBER,
521 x_return_status OUT NOCOPY VARCHAR2,
522 x_cust_acct_id OUT NOCOPY NUMBER
523 );
524
525 PROCEDURE Get_party_site_from_ECX (
526 p_location IN VARCHAR2,
527 x_party_site_id OUT NOCOPY NUMBER,
528 x_return_status OUT NOCOPY VARCHAR2
529 );
530
531 PROCEDURE Chk_party_record_null(
532 p_line_count IN NUMBER,
533 p_party_type IN VARCHAR2,
534 p_cust_account_id IN NUMBER_TABLE,
535 p_acct_site_id IN NUMBER_TABLE,
536 p_party_id IN NUMBER_TABLE,
537 p_party_site_id IN NUMBER_TABLE,
538 p_location IN VARCHAR2_TABLE,
539 p_party_name IN VARCHAR2_TABLE,
540 x_null_flag OUT NOCOPY VARCHAR2,
541 x_return_status OUT NOCOPY VARCHAR2
542 );
543
544
545 PROCEDURE Derive_Party
546 ( p_resale_line_int_id IN NUMBER_TABLE
547 , p_line_count IN NUMBER
548 , p_party_type IN VARCHAR2
549 , p_cust_account_id IN NUMBER_TABLE
550 , p_site_id IN NUMBER_TABLE
551 , x_cust_account_id OUT NOCOPY NUMBER_TABLE
552 , x_site_id OUT NOCOPY NUMBER_TABLE
553 , x_site_use_id OUT NOCOPY NUMBER_TABLE
554 , x_party_id OUT NOCOPY NUMBER_TABLE
555 , x_party_name OUT NOCOPY VARCHAR2_TABLE
556 , px_status_code_tbl IN OUT NOCOPY VARCHAR2_TABLE
557 , px_dispute_code_tbl IN OUT NOCOPY VARCHAR2_TABLE
558 , x_return_status OUT NOCOPY VARCHAR2
559 );
560
561 PROCEDURE update_interface_line (
562 p_api_version_number IN NUMBER,
563 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
565 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
566 p_int_line_tbl IN resale_line_int_tbl_type,
567 x_return_status OUT NOCOPY VARCHAR2,
568 x_msg_count OUT NOCOPY NUMBER,
569 x_msg_data OUT NOCOPY VARCHAR2
570 );
571
572 PROCEDURE update_interface_batch (
573 p_api_version_number IN NUMBER,
574 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
575 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
576 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
577 p_int_batch_rec IN ozf_resale_batches_all%rowtype,
578 x_return_status OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_msg_data OUT NOCOPY VARCHAR2
581 );
582
583 PROCEDURE raise_event
584 (
585 p_batch_id IN NUMBER,
586 p_event_name IN VARCHAR2,
587 x_return_status OUT NOCOPY VARCHAR2
588 );
589
590 PROCEDURE Confirm_BOD_Enabled
591 (
592 itemtype IN VARCHAR2,
593 itemkey IN VARCHAR2,
594 actid IN NUMBER,
595 funcmode IN VARCHAR2,
596 result IN OUT NOCOPY VARCHAR2
597 );
598
599 PROCEDURE Send_Outbound
600 (
601 itemtype IN VARCHAR2,
602 itemkey IN VARCHAR2,
603 actid IN NUMBER,
604 funcmode IN VARCHAR2,
605 resultout IN OUT NOCOPY VARCHAR2
606 );
607
608 PROCEDURE Send_Success_CBOD
609 (
610 itemtype in VARCHAR2,
611 itemkey in VARCHAR2,
612 actid in NUMBER,
613 funcmode in VARCHAR2,
614 result in out NOCOPY VARCHAR2
615 );
616
617 PROCEDURE Raise_data_process
618 (
619 itemtype IN VARCHAR2,
620 itemkey IN VARCHAR2,
621 actid IN NUMBER,
622 funcmode IN VARCHAR2,
623 resultout IN OUT NOCOPY VARCHAR2
624 );
625
626 PROCEDURE Insert_Resale_Log (
627 p_id_value IN VARCHAR2,
628 p_id_type IN VARCHAR2,
629 p_error_code IN VARCHAR2,
630 p_column_name IN VARCHAR2,
631 p_column_value IN VARCHAR2,
632 x_return_status OUT NOCOPY VARCHAR2 )
633 ;
634 END ozf_pre_process_pvt;