1 PACKAGE IEX_DUNNING_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexvduns.pls 120.17.12020000.2 2012/11/08 17:04:15 ehuh ship $ */
3
4 -- this will be passed back by the get_components procedure
5 TYPE FULFILLMENT_BIND_REC IS RECORD(
6 KEY_NAME VARCHAR2(150),
7 KEY_TYPE VARCHAR2(25), -- 'NUMBER' or 'VARCHAR' or 'DATE'
8 KEY_VALUE VARCHAR2(240));
9
10 TYPE FULFILLMENT_BIND_TBL IS TABLE OF FULFILLMENT_BIND_REC INDEX BY binary_integer;
11
12 g_included_current_invs varchar2(1) := 'N'; -- added by gnramasa for bug 9326376 2-Feb-10
13 g_included_unapplied_rec varchar2(1) := 'N'; -- added by gnramasa for bug 9326376 2-Feb-10
14
15 Procedure Validate_Delinquency(
16 P_Init_Msg_List IN VARCHAR2 ,
17 P_Delinquency_ID IN NUMBER,
18 X_Return_Status OUT NOCOPY VARCHAR2,
19 X_Msg_Count OUT NOCOPY NUMBER,
20 X_Msg_Data OUT NOCOPY VARCHAR2
21 );
22
23 Procedure Create_AG_DN_XREF
24 (p_api_version IN NUMBER := 1.0,
25 p_init_msg_list IN VARCHAR2 ,
26 p_commit IN VARCHAR2 ,
27 P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_AG_DN_XREF_ID OUT NOCOPY NUMBER);
32
33 Procedure Update_AG_DN_XREF
34 (p_api_version IN NUMBER := 1.0,
35 p_init_msg_list IN VARCHAR2 ,
36 p_commit IN VARCHAR2 ,
37 P_AG_DN_XREF_REC IN IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE,
38 p_AG_DN_XREF_ID IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42
43 Procedure Delete_AG_DN_XREF
44 (p_api_version IN NUMBER := 1.0,
45 p_init_msg_list IN VARCHAR2 ,
46 p_commit IN VARCHAR2 ,
47 P_AG_DN_XREF_ID IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52 Procedure Create_Dunning
53 (p_api_version IN NUMBER := 1.0,
54 p_init_msg_list IN VARCHAR2 ,
55 p_commit IN VARCHAR2 ,
56 P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_Dunning_ID OUT NOCOPY NUMBER);
61
62 Procedure Create_Staged_Dunning
63 (p_api_version IN NUMBER := 1.0,
64 p_init_msg_list IN VARCHAR2 ,
65 p_commit IN VARCHAR2 ,
66 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
67 p_dunning_id IN NUMBER,
68 p_correspondence_date IN DATE,
69 p_ag_dn_xref_id IN NUMBER,
70 p_running_level IN VARCHAR2,
71 p_grace_days IN NUMBER := 0,
72 p_include_dispute_items IN VARCHAR2 DEFAULT 'N',
73 p_dunning_mode IN VARCHAR2,
74 p_inc_inv_curr IN IEX_UTILITIES.INC_INV_CURR_TBL,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 Procedure Update_Dunning
80 (p_api_version IN NUMBER := 1.0,
81 p_init_msg_list IN VARCHAR2 ,
82 p_commit IN VARCHAR2 ,
83 P_Dunning_REC IN IEX_DUNNING_PUB.DUNNING_REC_TYPE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2);
87
88 /*=========================================================================
89 clchang update 10/16/2002 -
90 Send Dunning can be in Customer, Account and Transaction levels in 11.5.9;
91 Send_Level_Dunning is for Customer and Account level;
92 Send_Dunning keeps the same, and is for Transaction Level;
93 *=========================================================================*/
94 Procedure Send_Level_Dunning
95 (p_api_version IN NUMBER := 1.0,
96 p_init_msg_list IN VARCHAR2 ,
97 p_commit IN VARCHAR2 ,
98 p_running_level IN VARCHAR2,
99 p_dunning_plan_id in number,
100 p_resend_flag IN VARCHAR2 DEFAULT NULL,
101 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
102 p_parent_request_id IN NUMBER,
103 p_dunning_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
104 p_confirmation_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
105 p_correspondence_date IN DATE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2);
109
110 Procedure Send_Level_Staged_Dunning
111 (p_api_version IN NUMBER := 1.0,
112 p_init_msg_list IN VARCHAR2 ,
113 p_commit IN VARCHAR2 ,
114 p_running_level IN VARCHAR2,
115 p_dunning_plan_id in number,
116 p_correspondence_date IN DATE,
117 p_resend_flag IN VARCHAR2 DEFAULT NULL,
118 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
119 p_parent_request_id IN NUMBER,
120 p_dunning_mode IN VARCHAR2 DEFAULT NULL,
121 p_single_staged_letter IN VARCHAR2 DEFAULT 'N',
122 p_confirmation_mode IN VARCHAR2 DEFAULT NULL,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2);
126
127 Procedure Send_Dunning
128 (p_api_version IN NUMBER := 1.0,
129 p_init_msg_list IN VARCHAR2 ,
130 p_commit IN VARCHAR2 ,
131 p_dunning_plan_id in number,
132 p_resend_flag IN VARCHAR2 DEFAULT NULL,
133 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
134 p_parent_request_id IN NUMBER,
135 p_dunning_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
136 p_confirmation_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
137 p_correspondence_date IN DATE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2);
141
142 Procedure Send_Staged_Dunning
143 (p_api_version IN NUMBER := 1.0,
144 p_init_msg_list IN VARCHAR2 ,
145 p_commit IN VARCHAR2 ,
146 p_dunning_plan_id in number,
147 p_correspondence_date IN DATE,
148 p_resend_flag IN VARCHAR2 DEFAULT NULL,
149 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
150 p_parent_request_id IN NUMBER,
151 p_dunning_mode IN VARCHAR2 DEFAULT NULL,
152 p_single_staged_letter IN VARCHAR2 DEFAULT 'N',
153 p_confirmation_mode IN VARCHAR2 DEFAULT NULL,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2);
157
158 --Start bug 9970624 gnramasa 4th Aug 10
159 --stage_dunning_inv_copy procedure is no more used to send inv copy
160 /*
161 Procedure stage_dunning_inv_copy
162 (p_api_version IN NUMBER := 1.0,
163 p_init_msg_list IN VARCHAR2 ,
164 p_commit IN VARCHAR2 ,
165 p_no_of_workers IN NUMBER,
166 p_process_err_rec_only IN VARCHAR2,
167 p_request_id IN NUMBER,
168 p_dunning_mode IN VARCHAR2,
169 p_confirmation_mode IN VARCHAR2,
170 p_running_level IN VARCHAR2,
171 p_correspondence_date IN DATE,
172 p_max_dunning_trx_id IN NUMBER,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2);
176 */
177 --End bug 9970624 gnramasa 4th Aug 10
178
179 /*=========================================================================
180 clchang added 03/04/2003 -
181 The following 2 Resend procedures are especially for resend dunnings;
182 Called by FORM, not Concurrent Program;
183 *=========================================================================*/
184 Procedure Resend_Level_Dunning
185 (p_api_version IN NUMBER := 1.0,
186 p_init_msg_list IN VARCHAR2 ,
187 p_commit IN VARCHAR2 ,
188 p_dunning_plan_id in number,
189 p_running_level IN VARCHAR2,
190 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
191 p_org_id in number default null,
192 p_dunning_id in number default null,
193 x_request_id OUT NOCOPY NUMBER,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2);
197
198 Procedure Resend_Level_Staged_Dunning
199 (p_api_version IN NUMBER := 1.0,
200 p_init_msg_list IN VARCHAR2 ,
201 p_commit IN VARCHAR2 ,
202 p_dunning_plan_id in number,
203 p_dunning_id in number,
204 p_running_level IN VARCHAR2,
205 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
206 p_org_id in number default null,
207 x_request_id OUT NOCOPY NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2);
211
212 Procedure Resend_Dunning
213 (p_api_version IN NUMBER := 1.0,
214 p_init_msg_list IN VARCHAR2 ,
215 p_commit IN VARCHAR2 ,
216 p_dunning_plan_id in number,
217 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
218 p_org_id in number default null,
219 p_dunning_id in number default null,
220 x_request_id OUT NOCOPY NUMBER,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2);
224
225 Procedure Resend_Staged_Dunning
226 (p_api_version IN NUMBER := 1.0,
227 p_init_msg_list IN VARCHAR2 ,
228 p_commit IN VARCHAR2 ,
229 p_dunning_plan_id in number,
230 p_dunning_id in number,
231 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
232 p_org_id in number default null,
233 x_request_id OUT NOCOPY NUMBER,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2);
237
238 /* clchang added (for 11.5.9)
239 no iex aging in 11.5.9;
240 in send_dunning, aging_bucket_line_id is not from iex_delinquencies;
241 we need to get by ourselves;
242 */
243 Procedure AGING_DEL(
244 p_api_version IN NUMBER := 1.0,
245 p_init_msg_list IN VARCHAR2 ,
246 p_commit IN VARCHAR2 ,
247 p_delinquency_id IN NUMBER,
248 p_dunning_plan_id in number,
249 p_bucket IN VARCHAR2 DEFAULT NULL,
250 p_object_code IN VARCHAR2 DEFAULT NULL,
251 p_object_id IN NUMBER DEFAULT NULL,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 x_AGING_Bucket_line_ID OUT NOCOPY NUMBER);
256
257
258 Procedure Call_FFM(
259 p_api_version IN NUMBER := 1.0,
260 p_init_msg_list IN VARCHAR2 ,
261 p_commit IN VARCHAR2 ,
262 p_key_name IN VARCHAR2,
263 p_key_id IN NUMBER,
264 p_template_id IN NUMBER,
265 p_method IN VARCHAR2,
266 p_party_id IN NUMBER,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 x_REQUEST_ID OUT NOCOPY NUMBER);
271
272 Procedure Get_Callback_Date(
273 p_init_msg_list IN VARCHAR2 ,
274 p_callback_days IN NUMBER,
275 p_correspondence_date IN DATE default null,
276 x_callback_date OUT NOCOPY DATE,
277 X_Return_Status OUT NOCOPY VARCHAR2,
278 X_Msg_Count OUT NOCOPY NUMBER,
279 X_Msg_Data OUT NOCOPY VARCHAR2 );
280
281
282 PROCEDURE Close_Dunning
283 (p_api_version IN NUMBER := 1.0,
284 p_init_msg_list IN VARCHAR2 ,
285 p_commit IN VARCHAR2 ,
286 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
287 --p_delinquencies_tbl IN IEX_DUNNING_PUB.DelId_NumList,
288 p_running_level IN VARCHAR2,
289 --p_dunning_id IN NUMBER default NULL, -- added by gnramasa for bug 8489610 14-May-09
290 --p_status IN VARCHAR2 DEFAULT 'OPEN', -- added by gnramasa for bug 8489610 14-May-09
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2);
294
295 PROCEDURE Close_Staged_Dunning
296 (p_api_version IN NUMBER := 1.0,
297 p_init_msg_list IN VARCHAR2 ,
298 p_commit IN VARCHAR2 ,
299 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
300 p_ag_dn_xref_id IN NUMBER,
301 p_running_level IN VARCHAR2,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2);
305
306 /*=========================================================================
307 clchang update 10/02/2002 - no ReOpen Dunning in 115.9
308 -- clchang added 09/04/2002 for reopen delinquencies
309 -- added in 115.9 code line and 115.6 branch
310 PROCEDURE ReOpen_Dunning
311 (p_api_version IN NUMBER := 1.0,
312 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313 p_commit IN VARCHAR2 := FND_API.G_FALSE,
314 --p_delinquencies_tbl IN IEX_DUNNING_PUB.DelId_NumList,
315 p_delinquencies_tbl IN DBMS_SQL.NUMBER_TABLE,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2);
319 *=========================================================================*/
320 Procedure Daily_Dunning
321 (p_api_version IN NUMBER := 1.0,
322 p_init_msg_list IN VARCHAR2 ,
323 p_commit IN VARCHAR2 ,
324 --p_dunning_tbl IN IEX_DUNNING_PUB.DUNNING_TBL_TYPE,
325 p_running_level IN VARCHAR2,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2);
329
330 Procedure NEW_TASK(
331 p_api_version IN NUMBER := 1.0,
332 p_init_msg_list IN VARCHAR2 ,
333 p_commit IN VARCHAR2 ,
334 p_delinquency_id IN NUMBER,
335 p_dunning_id IN NUMBER,
336 p_dunning_object_id IN NUMBER,
337 p_dunning_level IN VARCHAR2,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 x_TASK_ID OUT NOCOPY NUMBER);
342
343 /*========================================================================
344 * Clchang updated 09/19/2002 for Bug 2242346
345 * to create a callback,
346 * we got resource_id from iex_delinquencyies before;
347 * now, we get resource_id based on which agent owns the least tasks
348 * in PARTY level;
349 *
350 *========================================================================*/
351 PROCEDURE Get_Resource(p_api_version IN NUMBER,
352 p_commit IN VARCHAR2,
353 p_init_msg_list IN VARCHAR2 ,
354 p_party_id IN NUMBER,
355 x_resource_id OUT NOCOPY NUMBER,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2);
359
360 /*
361 || Overview: This procedure is an extension of Call_FFM. Call_FFM only allows one bind variable/value
362 || This will allow you to pass in unlimited bind variables in a name/value pair structure
363 ||
364 || Parameter: p_FULFILLMENT_BIND_TBL = name/value pairs for bind variables
365 || p_template_id = fulfillment template
366 || p_method = Fulfillment Type, currently only 'EMAIL' is supported
367 || p_party_id = pk to hz_parties
368 ||
369 || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
370 || jtf_FM_query_mes
371 || jtf_FM_query
372 ||
373 || Target Tables:
374 ||
375 || Creation date: 03/07/02 11:36:AM
376 ||
377 || Major Modifications: when who what
378 || 03/07/02 11:36:AM raverma created
379 || 08/06/02 10:00:AM pjgomes Added parameter p_email to Send_Fulfillment api
380 || 08/19/02 02:00:PM pjgomes Changed default value of p_email to NULL
381 */
382 Procedure Send_Fulfillment(p_api_version IN NUMBER := 1.0,
383 p_init_msg_list IN VARCHAR2 ,
384 p_commit IN VARCHAR2 ,
385 p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
386 p_template_id IN NUMBER,
387 p_method IN VARCHAR2,
388 p_party_id IN NUMBER,
389 p_user_id IN NUMBER DEFAULT NULL,
390 p_email IN VARCHAR2 DEFAULT NULL,
391 p_level IN VARCHAR2 DEFAULT NULL,
392 p_source_id IN NUMBER DEFAULT NULL,
393 p_object_code IN VARCHAR2 DEFAULT NULL,
394 p_object_id IN NUMBER DEFAULT NULL,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_msg_data OUT NOCOPY VARCHAR2,
398 x_REQUEST_ID OUT NOCOPY NUMBER,
399 x_contact_destination OUT NOCOPY varchar2,
400 x_contact_party_id OUT NOCOPY NUMBER);
401
402
403 /* This is a new procedure for 11.5.11.
404 * To replace FULFILLMENT by XML Publisher.
405 * Copied from Send_Fulfillemtn.
406 */
407 Procedure Send_XML ( p_api_version IN NUMBER := 1.0,
408 p_init_msg_list IN VARCHAR2 ,
409 p_commit IN VARCHAR2 ,
410 p_resend IN VARCHAR2 ,
411 p_request_id IN NUMBER DEFAULT NULL,
412 p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
413 p_template_id IN NUMBER,
414 p_method IN VARCHAR2,
415 p_party_id IN NUMBER,
416 p_user_id IN NUMBER DEFAULT NULL,
417 p_email IN VARCHAR2 DEFAULT NULL,
418 p_level IN VARCHAR2 DEFAULT NULL,
419 p_source_id IN NUMBER DEFAULT NULL,
420 p_object_code IN VARCHAR2 DEFAULT NULL,
421 p_object_id IN NUMBER DEFAULT NULL,
422 p_resource_id IN NUMBER DEFAULT NULL,
423 p_dunning_mode IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8489610 14-May-09
424 p_parent_request_id IN NUMBER DEFAULT NULL,
425 p_org_id in number default null, -- added for bug 9151851
426 p_correspondence_date IN DATE DEFAULT NULL,
427 p_addt_template_id IN NUMBER DEFAULT NULL, --added for bug 9970624 gnramasa 4th Aug 10
428 x_return_status OUT NOCOPY VARCHAR2,
429 x_msg_count OUT NOCOPY NUMBER,
430 x_msg_data OUT NOCOPY VARCHAR2,
431 x_REQUEST_ID OUT NOCOPY NUMBER,
432 x_contact_destination OUT NOCOPY varchar2,
433 x_contact_party_id OUT NOCOPY NUMBER);
434
435 Procedure GetContactInfo( p_api_version IN NUMBER := 1.0,
436 p_init_msg_list IN VARCHAR2 ,
437 p_commit IN VARCHAR2 ,
438 p_method IN VARCHAR2,
439 p_party_id IN NUMBER,
440 p_dunning_level IN VARCHAR2,
441 p_cust_site_use_id IN VARCHAR2,
442 x_return_status OUT NOCOPY VARCHAR2,
443 x_msg_count OUT NOCOPY NUMBER,
444 x_msg_data OUT NOCOPY VARCHAR2,
445 x_contact OUT NOCOPY VARCHAR2,
446 x_contact_party_id OUT NOCOPY number);
447
448
449 Procedure GetContactPoint( p_api_version IN NUMBER := 1.0,
450 p_init_msg_list IN VARCHAR2 ,
451 p_commit IN VARCHAR2 ,
452 p_method IN VARCHAR2,
453 p_party_id IN NUMBER,
454 x_return_status OUT NOCOPY VARCHAR2,
455 x_msg_count OUT NOCOPY NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2,
457 x_contact OUT NOCOPY VARCHAR2);
458
459
460 Procedure CHK_QUERY_DATA( p_query_id IN NUMBER,
461 p_FULFILLMENT_BIND_TBL IN IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
462 x_keep_flag OUT NOCOPY NUMBER);
463
464 Procedure WriteLog ( p_msg IN VARCHAR2 DEFAULT NULL,
465 p_flag IN NUMBER DEFAULT NULL);
466
467 procedure GET_DEFAULT_DUN_DEST(p_api_version IN NUMBER := 1.0,
468 p_init_msg_list IN VARCHAR2,
469 p_commit IN VARCHAR2,
470 p_level in varchar2,
471 p_source_id in number,
472 p_send_method in varchar2,
473 X_LOCATION_ID OUT NOCOPY NUMBER,
474 X_CONTACT_ID OUT NOCOPY NUMBER,
475 X_CONTACT_POINT_ID OUT NOCOPY NUMBER,
476 x_return_status OUT NOCOPY VARCHAR2,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2);
479
480 procedure GET_DEFAULT_DUN_DATA(p_api_version IN NUMBER := 1.0,
481 p_init_msg_list IN VARCHAR2,
482 p_commit IN VARCHAR2,
483 p_level in varchar2,
484 p_source_id in number,
485 p_send_method in varchar2,
486 p_resend IN VARCHAR2 ,
487 p_object_code IN VARCHAR2 ,
488 p_object_id IN NUMBER,
489 p_fulfillment_bind_tbl in out nocopy IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492 x_msg_data OUT NOCOPY VARCHAR2);
493
494 --Start adding for bug 8489610 by gnramasa 14-May-09
495 Procedure gen_xml_data_dunning (p_request_id IN NUMBER ,
496 p_running_level IN VARCHAR2,
497 p_dunning_plan_id IN NUMBER,
498 p_dunning_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 28-May-09
499 p_confirmation_mode IN VARCHAR2, -- added by gnramasa for bug 8489610 28-May-09
500 p_process_err_rec_only IN VARCHAR2,
501 p_no_of_rec_prc_bylastrun IN NUMBER,
502 p_no_of_succ_rec_bylastrun IN NUMBER,
503 p_no_of_fail_rec_bylastrun IN NUMBER,
504 p_org_id_coll_method IN VARCHAR2, -- Added by snuthala for bug 10221334 21/10/2010
505 x_no_of_rec_prc OUT NOCOPY NUMBER,
506 x_no_of_succ_rec OUT NOCOPY NUMBER,
507 x_no_of_fail_rec OUT NOCOPY NUMBER);
508 --End adding for bug 8489610 by gnramasa 14-May-09
509
510 FUNCTION party_currency_code (p_party_id NUMBER) RETURN VARCHAR2;
511
512 FUNCTION acct_currency_code (p_account_id NUMBER) RETURN VARCHAR2;
513
514 FUNCTION site_currency_code (p_customer_site_use_id NUMBER) RETURN VARCHAR2;
515
516 FUNCTION party_amount_due_remaining(p_party_id NUMBER) RETURN NUMBER;
517
518 FUNCTION acct_amount_due_remaining(p_account_id NUMBER) RETURN NUMBER;
519
520 FUNCTION site_amount_due_remaining(p_customer_site_use_id NUMBER) RETURN NUMBER;
521
522 FUNCTION get_party_id(p_account_id NUMBER) RETURN NUMBER;
523
524 FUNCTION GET_DUNNING_LOCATION(P_SITE_USE_ID NUMBER) RETURN NUMBER;
525
526 Procedure INSERT_DUNNING_TRANSACTION
527 (p_api_version IN NUMBER := 1.0,
528 p_init_msg_list IN VARCHAR2 ,
529 p_commit IN VARCHAR2 ,
530 p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE,
531 p_dunning_id IN NUMBER,
532 p_correspondence_date IN DATE default sysdate,
533 p_ag_dn_xref_id IN NUMBER,
534 p_running_level IN VARCHAR2,
535 p_grace_days IN NUMBER,
536 p_include_dispute_items IN VARCHAR2,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2
540 ,p_workitem_id IN NUMBER); -- bug 14772139
541
542 END IEX_DUNNING_PVT;
[Home] [Help]