eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OZF_PRE_PROCESS_PVT

Source


1 PACKAGE ozf_pre_process_pvt AUTHID CURRENT_USER AS
2 /*$Header: ozfvprss.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(360),
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    price_list_name   		       VARCHAR2_TABLE,
143    orig_system_currency_code       VARCHAR2_TABLE,
144    orig_system_selling_price       NUMBER_TABLE,
145    orig_system_quantity            NUMBER_TABLE,
146    orig_system_uom                 VARCHAR2_TABLE,
147    orig_system_purchase_uom        VARCHAR2_TABLE,
148    orig_system_purchase_curr       VARCHAR2_TABLE,
149    orig_system_purchase_price      NUMBER_TABLE,
150    orig_system_purchase_quantity   NUMBER_TABLE,
151    orig_system_agreement_uom       VARCHAR2_TABLE,
152    orig_system_agreement_name      VARCHAR2_TABLE,
153    orig_system_agreement_type      VARCHAR2_TABLE,
154    orig_system_agreement_curr      VARCHAR2_TABLE,
155    orig_system_agreement_price     NUMBER_TABLE,
156    orig_system_agreement_quantity  NUMBER_TABLE,
157    orig_system_item_number         VARCHAR2_TABLE,
158    currency_code                   VARCHAR2_TABLE,
159    exchange_rate_type              VARCHAR2_TABLE,
160    exchange_rate_date               DATE_TABLE,
161    exchange_rate                   NUMBER_TABLE,
162    order_number                    VARCHAR2_TABLE,
163    date_ordered                    DATE_TABLE,
164    claimed_amount                  NUMBER_TABLE,
165    total_claimed_amount            NUMBER_TABLE,
166    purchase_price                  NUMBER_TABLE,
167    acctd_purchase_price            NUMBER_TABLE,
168    purchase_uom_code               VARCHAR2_TABLE,
169    selling_price                   NUMBER_TABLE,
170    acctd_selling_price             NUMBER_TABLE,
171    uom_code                        VARCHAR2_TABLE,
172    quantity                        NUMBER_TABLE,
173    inventory_item_id               NUMBER_TABLE,
174    item_number                     VARCHAR2_TABLE,
175    dispute_code                    VARCHAR2_TABLE,
176    data_source_code                VARCHAR2_TABLE,
177    org_id                          NUMBER_TABLE,
178    response_code                   VARCHAR2_TABLE,
179 
180    -- For Bug#9447673 SSD IDSM ER(+)
181    invoice_line_number		   VARCHAR2_TABLE,
182    order_line_number		   VARCHAR2_TABLE,
183    supplier_item_cost		   NUMBER_TABLE,
184    supplier_item_uom   		   VARCHAR2_TABLE
185    -- For Bug#9447673 SSD IDSM ER(-)
186    );
187 
188 
189 -- Transaction Type
190 
191 g_product_transfer                CONSTANT VARCHAR2(30) := '01';
192 g_resale			                   CONSTANT VARCHAR2(30) := '02';
193 g_req_for_credit		             CONSTANT VARCHAR2(30) := 'RA';
194 
195 -- Resale Transfer Type
196 
197 g_tsfr_return                     CONSTANT VARCHAR2(20) := 'BN';
198 g_tsfr_ship_debit_sale            CONSTANT VARCHAR2(20) := 'SD';
199 g_tsfr_stock_sale                 CONSTANT VARCHAR2(20) := 'SS';
200 g_tsfr_inter_branch               CONSTANT VARCHAR2(20) := 'IB';
201 
202 -- Product Transfer Movement Type
203 
204  g_mvmt_cust_to_dist		         CONSTANT varchar2(20) := 'CD';
205  g_mvmt_dist_to_cust		         CONSTANT varchar2(20) := 'DC';
206  g_mvmt_tsfr_in			         CONSTANT varchar2(20) := 'TI';
207  g_mvmt_tsfr_out		            CONSTANT varchar2(20) := 'TO';
208  g_mvmt_dist_to_mf		         CONSTANT varchar2(20) := 'DM';
209  g_mvmt_mf_to_dist		         CONSTANT varchar2(20) := 'MD';
210 
211 -- Transaction Purpose Code
212 
213 g_original                       CONSTANT varchar2(20) := '00';
214 
215 -- Partner Types
216 g_distributor                    CONSTANT varchar2(20) := 'DS';
217 
218 
219 -- Mapping Types
220 g_uom_type                       CONSTANT varchar2(20) := 'OZF_UOM_CODES';
221 g_product_type                   CONSTANT varchar2(20) := 'OZF_PRODUCT_CODES';
222 g_agreement_type                 CONSTANT varchar2(20) := 'OZF_AGREEMENT_CODES';
223 
224 -- Agreement Types
225 g_price_list                     CONSTANT varchar2(20) := 'PL';
226 g_special_price                  CONSTANT varchar2(20) := 'SPO';
227 
228 -- Status Code
229 g_batch_new                      CONSTANT varchar2(20) := 'NEW';
230 g_batch_rejected                 CONSTANT varchar2(20) := 'REJECTED';
231 g_batch_open                     CONSTANT varchar2(20) := 'OPEN';
232 g_batch_disputed                 CONSTANT varchar2(20) := 'DISPUTED';
233 
234 -- Event Names
235 g_xml_outbound_event             CONSTANT varchar2(30) := 'oracle.apps.ozf.idsm.reslo';
236 g_xml_confirm_bod_event          CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.confirm';
237 g_xml_data_process_event         CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.XMLProcess';
238 g_webadi_data_process_event      CONSTANT varchar2(50) := 'oracle.apps.ozf.idsm.WEBADIProcess';
239 
240 -- Workflow Item Type
241 g_xml_import_workflow            CONSTANT varchar2(30) := 'OZFRESO';
242 g_data_process_workflow          CONSTANT varchar2(30) := 'OZFRSIFD';
243 
244 PROCEDURE webadi_import
245 (
246 	p_batch_number		IN	        VARCHAR2,
247 	x_return_status	OUT NOCOPY VARCHAR2
248 );
249 
250 PROCEDURE process_xmlgt_inbwf
251 (
252    itemtype   IN VARCHAR2,
253    itemkey    IN VARCHAR2,
254    actid      IN NUMBER,
255    funcmode   IN VARCHAR2,
256    resultout  IN OUT NOCOPY VARCHAR2
257 );
258 
259 
260 PROCEDURE resale_pre_process
261   (
262    p_api_version_number    IN  NUMBER,
263    p_init_msg_list         IN  VARCHAR2     := FND_API.G_FALSE,
264    p_commit                IN  VARCHAR2     := FND_API.G_FALSE,
265    p_validation_level      IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,
266    p_batch_id		         IN  NUMBER,
267    x_batch_status          OUT NOCOPY  VARCHAR2,
268    x_return_status         OUT NOCOPY  VARCHAR2,
269    x_msg_count             OUT NOCOPY  NUMBER,
270    x_msg_data              OUT NOCOPY  VARCHAR2
271  );
272 
273 PROCEDURE Batch_Update (
274    p_api_version_number    IN  NUMBER,
275    p_init_msg_list         IN  VARCHAR2  := FND_API.G_FALSE,
276    p_commit                IN  VARCHAR2  := FND_API.G_FALSE,
277    p_validation_level      IN  NUMBER    := FND_API.G_VALID_LEVEL_FULL,
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    x_msg_count             OUT NOCOPY  NUMBER,
282    x_msg_data              OUT NOCOPY  VARCHAR2
283 );
284 
285 PROCEDURE Batch_Fetch
286 (
287   p_batch_id		        IN  NUMBER,
288   x_resale_batch_rec	     OUT NOCOPY  ozf_resale_batches_all%rowtype,
289   x_return_status         OUT NOCOPY  VARCHAR2
290 );
291 
292 PROCEDURE Validate_Batch
293 (
294    p_api_version_number    IN  NUMBER,
295    p_init_msg_list         IN  VARCHAR2     := FND_API.G_FALSE,
296    p_commit                IN  VARCHAR2     := FND_API.G_FALSE,
297    p_validation_level      IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,
298    p_resale_batch_rec	   IN  ozf_resale_batches_all%rowtype,
299    x_batch_status          OUT NOCOPY  VARCHAR2,
300    x_return_status         OUT NOCOPY  VARCHAR2,
301    x_msg_count             OUT NOCOPY  NUMBER,
302    x_msg_data              OUT NOCOPY  VARCHAR2
303 );
304 
305 PROCEDURE Batch_Defaulting
306 (
307   p_api_version_number    IN  NUMBER,
308   p_init_msg_list         IN  VARCHAR2     := FND_API.G_FALSE,
309   p_commit                IN  VARCHAR2     := FND_API.G_FALSE,
310   p_validation_level      IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,
311   px_resale_batch_rec	   IN  OUT NOCOPY ozf_resale_batches_all%rowtype,
312   x_return_status         OUT NOCOPY  VARCHAR2,
313   x_msg_count             OUT NOCOPY  NUMBER,
314   x_msg_data              OUT NOCOPY  VARCHAR2
315 );
316 
317 PROCEDURE Lines_Update
318 (
319   p_batch_id		        IN  NUMBER,
320   px_batch_record         IN  OUT NOCOPY ozf_resale_batches_all%rowtype,
321   x_return_status         OUT NOCOPY  VARCHAR2,
322   x_msg_data              OUT NOCOPY  VARCHAR2,
323   x_msg_count             OUT NOCOPY  NUMBER
324 );
325 
326 PROCEDURE  Lines_Process
327 (
328   p_line_count            IN  NUMBER,
329   px_batch_record         IN  OUT NOCOPY ozf_resale_batches_all%rowtype,
333   x_msg_count             OUT NOCOPY  NUMBER
330   px_line_record          IN  OUT NOCOPY  resale_line_int_rec_type,
331   x_return_status         OUT NOCOPY  VARCHAR2,
332   x_msg_data              OUT NOCOPY  VARCHAR2,
334 );
335 
336 
337 PROCEDURE  Lines_Bulk_Update
338 (
339   p_batch_id       IN  NUMBER,
340   p_line_record    IN  resale_line_int_rec_type,
341   x_return_status  OUT NOCOPY  VARCHAR2
342 );
343 
344 
345 PROCEDURE Line_Defaulting
346 (
347   p_line_count    IN  NUMBER,
348   px_line_record  IN  OUT NOCOPY resale_line_int_rec_type,
349   x_return_status OUT NOCOPY  VARCHAR2
350 );
351 
352 
353 -- For Bug#9447673 SSD IDSM ER(+)
354 PROCEDURE Line_Defaulting
355 (
356   p_line_count    IN  NUMBER,
357   px_line_record  IN  OUT NOCOPY resale_line_int_rec_type,
358   p_direct_order_flag IN VARCHAR2,
359   x_return_status OUT NOCOPY  VARCHAR2
360 );
361 -- For Bug#9447673 SSD IDSM(-)
362 
363 PROCEDURE Line_Validations
364 (
365   p_line_count     IN  NUMBER,
366   px_batch_record  IN  OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
367   px_line_record   IN  OUT NOCOPY resale_line_int_rec_type,
368   x_return_status  OUT NOCOPY  VARCHAR2
369 );
370 
371 /*
372 -- For Bug#9447673 SSD IDSM ER(+)
373 PROCEDURE Line_Validations
374 (
375   p_line_count     IN  NUMBER,
376   px_batch_record  IN  OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
377   px_line_record   IN  OUT NOCOPY resale_line_int_rec_type,
378   p_direct_order_flag IN VARCHAR2,
379   x_return_status  OUT NOCOPY  VARCHAR2
380 );
381 -- For Bug#9447673 SSD IDSM(-)
382 */
383 
384 PROCEDURE Code_ID_Mapping
385 (
386   p_batch_record  IN  ozf_resale_batches_all%ROWTYPE,
387   px_line_record  IN  OUT NOCOPY resale_line_int_rec_type,
388   x_return_status OUT NOCOPY  VARCHAR2,
389   x_msg_data      OUT NOCOPY  VARCHAR2,
390   x_msg_count     OUT NOCOPY  NUMBER
391 );
392 
393 PROCEDURE Line_Party_Validations
394 (
395   p_line_count    IN  NUMBER,
396   px_line_record  IN  OUT NOCOPY resale_line_int_rec_type,
397   x_return_status OUT NOCOPY  VARCHAR2
398 );
399 
400 PROCEDURE Line_Currency_Price_Derivation
401 (
402     p_line_count             IN  NUMBER,
403     px_line_record           IN  OUT NOCOPY resale_line_int_rec_type,
404     x_return_status          OUT NOCOPY  VARCHAR2
405 );
406 
407 
408 PROCEDURE Currency_Price_Derivation
409 (
410   p_line_count          IN   NUMBER,
411   p_conversion_type     IN   VARCHAR2,
412   p_int_line_id_tbl     IN   NUMBER_TABLE,
413   p_external_price_tbl  IN   NUMBER_TABLE,
414   p_conversion_date_tbl IN   DATE_TABLE,
415   p_ext_currency_tbl    IN   VARCHAR2_TABLE,
416   px_internal_price_tbl IN OUT NOCOPY   NUMBER_TABLE,
417   px_currency_tbl       IN OUT NOCOPY   VARCHAR2_TABLE,
418   px_exchange_rate_tbl  IN OUT NOCOPY   NUMBER_TABLE,
419   px_rate_type_tbl      IN OUT NOCOPY   VARCHAR2_TABLE,
420   x_accounted_price_tbl OUT NOCOPY  NUMBER_TABLE,
421   px_status_tbl         IN OUT NOCOPY   VARCHAR2_TABLE,
422   px_dispute_code_tbl   IN OUT NOCOPY   VARCHAR2_TABLE,
423   x_return_status       OUT NOCOPY VARCHAR2
424 );
425 
426 PROCEDURE Agreement_Default
427 (
428    p_party_id               IN  NUMBER,
429    p_cust_account_id        IN  NUMBER,
430    p_batch_type             IN  VARCHAR2,
431    p_interface_line_id_tbl  IN  NUMBER_TABLE,
432    p_ext_agreement_name     IN  VARCHAR2_TABLE,
433    p_ext_agreement_type     IN  VARCHAR2_TABLE,
434    px_int_agreement_name    IN  OUT NOCOPY VARCHAR2_TABLE,
435    px_int_agreement_type    IN  OUT NOCOPY  VARCHAR2_TABLE,
436    px_agreement_id          IN  OUT NOCOPY NUMBER_TABLE,
437    px_corrected_agreement_id IN OUT NOCOPY  NUMBER_TABLE,
438    px_corrected_agreement_name IN OUT NOCOPY  VARCHAR2_TABLE,
439    px_price_list_id         IN OUT NOCOPY  NUMBER_TABLE,
440    px_price_list_name       IN OUT NOCOPY  VARCHAR2_TABLE,
441    px_status_tbl            IN  OUT NOCOPY  VARCHAR2_TABLE,
442    px_dispute_code_tbl      IN  OUT NOCOPY  VARCHAR2_TABLE,
443    p_resale_transfer_type   IN  VARCHAR2_TABLE,
444    x_return_status          OUT NOCOPY  VARCHAR2,
445    x_msg_count              OUT NOCOPY  NUMBER,
446    x_msg_data               OUT NOCOPY  VARCHAR2
447  );
448 
449 PROCEDURE Product_validations
450 (
451     p_party_id              IN  VARCHAR2,
452     p_cust_account_id       IN  VARCHAR2,
453     p_interface_line_id_tbl IN  NUMBER_TABLE,
454     p_ext_item_number_tbl   IN  VARCHAR2_TABLE,
455     p_item_number_tbl       IN  VARCHAR2_TABLE,
456     px_item_id_tbl          IN  OUT NOCOPY NUMBER_TABLE,
457     px_status_tbl           IN  OUT NOCOPY  VARCHAR2_TABLE,
458     px_dispute_code_tbl     IN  OUT NOCOPY  VARCHAR2_TABLE,
459     x_return_status         OUT NOCOPY  VARCHAR2,
460     x_msg_count             OUT NOCOPY  NUMBER,
461     x_msg_data              OUT NOCOPY  VARCHAR2
462 );
463 
464 PROCEDURE UOM_Code_Mapping
465 (
466     p_party_id              IN  NUMBER,
467     p_cust_account_id       IN  NUMBER,
468     p_interface_line_id_tbl IN  NUMBER_TABLE,
469     p_ext_purchase_uom      IN  VARCHAR2_TABLE,
470     p_ext_uom               IN  VARCHAR2_TABLE,
471     p_ext_agreement_uom     IN  VARCHAR2_TABLE,
472     px_int_purchase_uom     IN  OUT NOCOPY  VARCHAR2_TABLE,
473     px_int_uom              IN  OUT NOCOPY  VARCHAR2_TABLE,
474     px_int_agreement_uom    IN  OUT NOCOPY  VARCHAR2_TABLE,
475     px_status_tbl           IN  OUT NOCOPY  VARCHAR2_TABLE,
476     px_dispute_code_tbl     IN  OUT NOCOPY  VARCHAR2_TABLE,
477     x_return_status         OUT NOCOPY  VARCHAR2,
478     x_msg_count             OUT NOCOPY  NUMBER,
482 --//Bugfix 12649013 - Added additional parameters
479     x_msg_data              OUT NOCOPY  VARCHAR2
480 );
481 
483 PROCEDURE Party_Mapping
484 (
485   p_party_id               IN     NUMBER,
486   p_cust_account_id        IN     NUMBER,
487   p_party_type             IN     VARCHAR2,
488   p_interface_line_id_tbl  IN     NUMBER_TABLE,
489   p_party_name_tbl         IN OUT NOCOPY VARCHAR2_TABLE,
490   p_location_tbl           IN OUT NOCOPY VARCHAR2_TABLE,
491   px_cust_account_id_tbl   IN OUT NOCOPY NUMBER_TABLE,
492   px_site_use_id_tbl       IN OUT NOCOPY NUMBER_TABLE,
493   px_party_id_tbl          IN OUT NOCOPY NUMBER_TABLE,
494   px_party_site_id_tbl     IN OUT NOCOPY NUMBER_TABLE,
495   px_status_tbl            IN  OUT NOCOPY  VARCHAR2_TABLE,
496   px_dispute_code_tbl      IN  OUT NOCOPY  VARCHAR2_TABLE,
497   x_return_status          OUT NOCOPY  VARCHAR2,
498   x_msg_count              OUT NOCOPY  NUMBER,
499   x_msg_data               OUT NOCOPY  VARCHAR2
500 );
501 
502 PROCEDURE Party_Validations
503  (
504      p_resale_line_int_id      IN NUMBER_TABLE,
505      p_location                IN VARCHAR2_TABLE,
506      p_address                 IN VARCHAR2_TABLE,
507      p_city                    IN VARCHAR2_TABLE,
508      p_state                   IN VARCHAR2_TABLE,
509      p_postal_code             IN VARCHAR2_TABLE,
510      p_country                 IN VARCHAR2_TABLE,
511      p_contact_name            IN VARCHAR2_TABLE,
512      p_email                   IN VARCHAR2_TABLE,
513      p_fax                     IN VARCHAR2_TABLE,
514      p_phone                   IN VARCHAR2_TABLE,
515      p_site_use_type           IN VARCHAR2_TABLE,
516      p_direct_customer_flag    IN VARCHAR2_TABLE,
517      p_party_type              IN VARCHAR2,
518      p_line_count              IN NUMBER,
519      px_party_name             IN OUT NOCOPY VARCHAR2_TABLE,
520      px_cust_account_id        IN OUT NOCOPY NUMBER_TABLE,
521      px_site_use_id            IN OUT NOCOPY NUMBER_TABLE,
522      px_party_id               IN OUT NOCOPY NUMBER_TABLE,
523      px_party_site_id          IN OUT NOCOPY NUMBER_TABLE,
524      px_contact_party_id       IN OUT NOCOPY NUMBER_TABLE,
525      px_status_code_tbl        IN OUT NOCOPY VARCHAR2_TABLE,
526      px_dispute_code_tbl       IN OUT NOCOPY VARCHAR2_TABLE,
527      x_return_status           OUT NOCOPY VARCHAR2
528  );
529 
530 PROCEDURE DQM_processing (
531    p_api_version_number    IN         NUMBER,
532    p_init_msg_list         IN         VARCHAR2     := FND_API.G_FALSE,
533    p_commit                IN         VARCHAR2     := FND_API.G_FALSE,
534    p_validation_level      IN         NUMBER       := FND_API.G_VALID_LEVEL_FULL,
535    p_party_rec		         IN         party_rec_type,
536    p_party_site_rec	      IN         party_site_rec_type,
537    p_contact_rec	         IN         party_cntct_rec_type,
538    x_party_id		         OUT NOCOPY NUMBER,
539    x_party_site_id         OUT NOCOPY NUMBER,
540    x_party_contact_id      OUT NOCOPY NUMBER,
541    x_return_status         OUT NOCOPY VARCHAR2,
542    x_msg_count             OUT NOCOPY NUMBER,
543    x_msg_data              OUT NOCOPY VARCHAR2
544 );
545 
546 
547 PROCEDURE code_conversion
548 (
549     p_party_id              IN  VARCHAR2,
550     p_cust_account_id       IN  VARCHAR2,
551     p_mapping_type          IN  VARCHAR2,
552     p_external_code_tbl     IN  VARCHAR2_TABLE,
553     x_internal_code_tbl     OUT NOCOPY  VARCHAR2_TABLE,
554     x_return_status         OUT NOCOPY  VARCHAR2,
555     x_msg_count             OUT NOCOPY  NUMBER,
556     x_msg_data              OUT NOCOPY  VARCHAR2
557 );
558 
559 PROCEDURE Get_Customer_Accnt_Id(
560    p_party_id      IN  NUMBER,
561    p_party_site_id IN  NUMBER,
562    x_return_status OUT NOCOPY VARCHAR2,
563    x_cust_acct_id  OUT NOCOPY NUMBER
564 );
565 
566 PROCEDURE Get_party_site_from_ECX (
567    p_location       IN          VARCHAR2,
568    x_party_site_id  OUT NOCOPY  NUMBER,
569    x_return_status  OUT NOCOPY  VARCHAR2
570 );
571 
572 PROCEDURE Chk_party_record_null(
573    p_line_count             IN  NUMBER,
574    p_party_type             IN  VARCHAR2,
575    p_cust_account_id        IN  NUMBER_TABLE,
576    p_acct_site_id           IN  NUMBER_TABLE,
577    p_party_id               IN  NUMBER_TABLE,
578    p_party_site_id          IN  NUMBER_TABLE,
579    p_location               IN  VARCHAR2_TABLE,
580    p_party_name             IN  VARCHAR2_TABLE,
581    x_null_flag              OUT NOCOPY  VARCHAR2_TABLE,
582    x_return_status          OUT NOCOPY  VARCHAR2
583 );
584 
585 
586 PROCEDURE Derive_Party
587 (  p_resale_line_int_id   IN   NUMBER_TABLE
588  , p_line_count           IN   NUMBER
589  , p_party_type           IN   VARCHAR2
590  , p_cust_account_id      IN   NUMBER_TABLE
591  , p_site_id              IN   NUMBER_TABLE
592  , x_cust_account_id      IN OUT NOCOPY   NUMBER_TABLE
593  , x_site_id              IN OUT NOCOPY   NUMBER_TABLE
594  , x_site_use_id          IN OUT NOCOPY   NUMBER_TABLE
595  , x_party_id             IN OUT NOCOPY   NUMBER_TABLE
596  , x_party_name           IN OUT NOCOPY   VARCHAR2_TABLE
597  , px_status_code_tbl     IN OUT NOCOPY   VARCHAR2_TABLE
598  , px_dispute_code_tbl    IN OUT NOCOPY   VARCHAR2_TABLE
599  , p_null_flag_tb          IN   VARCHAR2_TABLE
600  , x_return_status        OUT NOCOPY   VARCHAR2
601 );
602 
603 PROCEDURE update_interface_line (
604 	p_api_version_number    IN    NUMBER,
605 	p_init_msg_list         IN    VARCHAR2     := FND_API.G_FALSE,
606 	P_Commit                IN    VARCHAR2     := FND_API.G_FALSE,
607 	p_validation_level      IN    NUMBER       := FND_API.G_VALID_LEVEL_FULL,
608 	p_int_line_tbl		      IN	   resale_line_int_tbl_type,
609 	x_return_status		   OUT NOCOPY VARCHAR2,
613 
610 	x_msg_count		         OUT NOCOPY NUMBER,
611 	x_msg_data		         OUT NOCOPY VARCHAR2
612 );
614 PROCEDURE update_interface_batch (
615 	p_api_version_number    IN   	NUMBER,
616 	p_init_msg_list         IN    VARCHAR2     := FND_API.G_FALSE,
617 	P_Commit                IN    VARCHAR2     := FND_API.G_FALSE,
618 	p_validation_level      IN    NUMBER       := FND_API.G_VALID_LEVEL_FULL,
619 	p_int_batch_rec		   IN	   ozf_resale_batches_all%rowtype,
620 	x_return_status		   OUT NOCOPY VARCHAR2,
621 	x_msg_count		         OUT NOCOPY NUMBER,
622 	x_msg_data		         OUT NOCOPY VARCHAR2
623 );
624 
625 PROCEDURE raise_event
626 (
627   p_batch_id		      IN  NUMBER,
628   p_event_name          IN  VARCHAR2,
629   x_return_status       OUT NOCOPY VARCHAR2
630 );
631 
632 PROCEDURE Confirm_BOD_Enabled
633 (
634   itemtype              IN VARCHAR2,
635   itemkey               IN VARCHAR2,
636   actid                 IN NUMBER,
637   funcmode              IN VARCHAR2,
638   result                IN OUT NOCOPY VARCHAR2
639 );
640 
641 PROCEDURE Send_Outbound
642 (
643    itemtype   IN VARCHAR2,
644    itemkey    IN VARCHAR2,
645    actid      IN NUMBER,
646    funcmode   IN VARCHAR2,
647    resultout  IN OUT NOCOPY VARCHAR2
648 );
649 
650 PROCEDURE Send_Success_CBOD
651 (
652     itemtype  in VARCHAR2,
653     itemkey   in VARCHAR2,
654     actid     in NUMBER,
655     funcmode  in VARCHAR2,
656     result    in out NOCOPY VARCHAR2
657 );
658 
659 PROCEDURE Raise_data_process
660 (
661    itemtype   IN VARCHAR2,
662    itemkey    IN VARCHAR2,
663    actid      IN NUMBER,
664    funcmode   IN VARCHAR2,
665    resultout  IN OUT NOCOPY VARCHAR2
666 );
667 
668 PROCEDURE Insert_Resale_Log (
669   p_id_value      IN VARCHAR2,
670   p_id_type       IN VARCHAR2,
671   p_error_code    IN VARCHAR2,
672   p_column_name   IN VARCHAR2,
673   p_column_value  IN VARCHAR2,
674   x_return_status OUT NOCOPY VARCHAR2 )
675 ;
676 END ozf_pre_process_pvt;