1 PACKAGE ARP_PROCESS_APPLICATION AS
2 /* $Header: ARCEAPPS.pls 120.16.12000000.2 2007/04/27 05:50:10 nemani ship $ */
3
4 FUNCTION revision RETURN VARCHAR2;
5
6 PROCEDURE reverse(
7 p_ra_id IN NUMBER
8 , p_reversal_gl_date IN DATE
9 , p_reversal_date IN DATE
10 , p_module_name IN VARCHAR2
11 , p_module_version IN VARCHAR2
12 , p_bal_due_remaining OUT NOCOPY NUMBER
13 , p_called_from IN VARCHAR2 DEFAULT NULL); /* jrautiai BR implementation */
14
15 PROCEDURE reverse_cm_app(
16 pn_ra_id IN NUMBER
17 , pn_applied_ps_id IN NUMBER
18 , pd_reversal_gl_date IN DATE
19 , pd_reversal_date IN DATE
20 , pc_module_name IN VARCHAR2
21 , pc_module_version IN VARCHAR2
22 , p_called_from IN VARCHAR2 DEFAULT NULL );
23
24 PROCEDURE update_selected_transaction(
25 pn_ra_id IN NUMBER,
26 pn_amount_applied IN NUMBER,
27 pc_invoice_currency_code IN VARCHAR2,
28 pn_invoice_exchange_rate IN NUMBER,
29 pc_receipt_currency_code IN VARCHAR2,
30 pn_receipt_exchange_rate IN NUMBER,
31 pc_module_name IN VARCHAR2,
32 pc_module_version IN VARCHAR2,
33 p_attribute_category IN VARCHAR2,
34 p_attribute1 IN VARCHAR2,
35 p_attribute2 IN VARCHAR2,
36 p_attribute3 IN VARCHAR2,
37 p_attribute4 IN VARCHAR2,
38 p_attribute5 IN VARCHAR2,
39 p_attribute6 IN VARCHAR2,
40 p_attribute7 IN VARCHAR2,
41 p_attribute8 IN VARCHAR2,
42 p_attribute9 IN VARCHAR2,
43 p_attribute10 IN VARCHAR2,
44 p_attribute11 IN VARCHAR2,
45 p_attribute12 IN VARCHAR2,
46 p_attribute13 IN VARCHAR2,
47 p_attribute14 IN VARCHAR2,
48 p_attribute15 IN VARCHAR2,
49 p_global_attribute_category IN VARCHAR2,
50 p_global_attribute1 IN VARCHAR2,
51 p_global_attribute2 IN VARCHAR2,
52 p_global_attribute3 IN VARCHAR2,
53 p_global_attribute4 IN VARCHAR2,
54 p_global_attribute5 IN VARCHAR2,
55 p_global_attribute6 IN VARCHAR2,
56 p_global_attribute7 IN VARCHAR2,
57 p_global_attribute8 IN VARCHAR2,
58 p_global_attribute9 IN VARCHAR2,
59 p_global_attribute10 IN VARCHAR2,
60 p_global_attribute11 IN VARCHAR2,
61 p_global_attribute12 IN VARCHAR2,
62 p_global_attribute13 IN VARCHAR2,
63 p_global_attribute14 IN VARCHAR2,
64 p_global_attribute15 IN VARCHAR2,
65 p_global_attribute16 IN VARCHAR2,
66 p_global_attribute17 IN VARCHAR2,
67 p_global_attribute18 IN VARCHAR2,
68 p_global_attribute19 IN VARCHAR2,
69 p_global_attribute20 IN VARCHAR2 );
70
71 PROCEDURE receipt_application(
72 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73 p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77 p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78 p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79 p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80 p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
83 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
84 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE,
85 p_application_ref_type IN
86 ar_receivable_applications.application_ref_type%TYPE,
87 p_application_ref_id IN
88 ar_receivable_applications.application_ref_id%TYPE,
89 p_application_ref_num IN
90 ar_receivable_applications.application_ref_num%TYPE,
91 p_secondary_application_ref_id IN
92 ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
93 p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
94 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
95 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
96 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
97 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
98 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
99 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
100 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
101 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
102 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
103 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
104 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
105 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
106 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
107 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
108 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
109 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
110 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
111 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
112 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
113 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
114 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
115 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
116 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
117 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
118 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
119 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
120 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
121 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
122 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
123 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
124 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
125 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
126 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
127 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
128 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
129 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
130 p_comments IN ar_receivable_applications.comments%TYPE,
131 p_module_name IN VARCHAR2,
132 p_module_version IN VARCHAR2,
133 -- OUT NOCOPY
134 x_application_ref_id OUT NOCOPY
135 ar_receivable_applications.application_ref_id%TYPE,
136 x_application_ref_num OUT NOCOPY
137 ar_receivable_applications.application_ref_num%TYPE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
142 p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
143 p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144 x_claim_reason_name OUT NOCOPY VARCHAR2,
145 p_called_from IN VARCHAR2 DEFAULT NULL, /* jrautiai BR implementation */
146 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y', /* jrautiai BR implementation */
147 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL, /* jrautiai BR implementation */
148 p_amount_due_remaining IN
149 ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
150 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
151 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
152 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
153 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
154 --{HYUDETUPT
155 from_llca_call IN VARCHAR2 DEFAULT 'N',
156 p_gt_id IN NUMBER DEFAULT NULL
157 --}
158 );
159
160 PROCEDURE cm_application(
161 p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
162 p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
163 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
164 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
165 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
166 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
167 p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
168 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
169 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
170 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
171 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
172 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
173 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
174 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
175 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
176 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
177 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
178 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
179 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
180 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
181 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
182 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
183 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
184 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
185 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
186 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
187 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
188 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
189 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
190 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
191 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
192 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
193 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
194 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
195 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
196 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
197 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
198 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
199 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
200 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
201 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
202 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
203 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
204 p_customer_trx_line_id IN NUMBER,
205 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2662270
206 p_module_name IN VARCHAR2,
207 p_module_version IN VARCHAR2,
208 -- OUT NOCOPY
209 p_out_rec_application_id OUT NOCOPY NUMBER,
210 p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
211 p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
212 );
213
214 PROCEDURE cm_activity_application(
215 p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
216 p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
217 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
218 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
219 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
220 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
221 p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
222 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
223 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
224 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
225 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
226 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
227 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
228 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
229 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
230 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
231 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
232 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
233 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
234 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
235 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
236 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
237 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
238 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
239 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
240 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
241 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
242 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
243 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
244 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
245 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
246 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
247 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
248 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
249 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
250 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
251 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
252 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
256 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
253 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
254 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
255 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
257 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
258 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
259 p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
260 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
261 p_module_name IN VARCHAR2,
262 p_module_version IN VARCHAR2,
263 -- OUT NOCOPY
264 p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
265 p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
266 p_out_rec_application_id OUT NOCOPY NUMBER,
267 p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
268 p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2);
272
273 PROCEDURE on_account_receipts(
274 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
275 p_amount_applied IN
276 ar_receivable_applications.amount_applied%TYPE,
277 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
278 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
279 p_ussgl_transaction_code IN
280 ar_receivable_applications.ussgl_transaction_code%TYPE,
281 p_attribute_category IN
282 ar_receivable_applications.attribute_category%TYPE,
283 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
284 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
285 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
286 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
287 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
288 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
289 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
290 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
291 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
292 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
293 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
294 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
295 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
296 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
297 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
298 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
299 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
300 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
301 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
302 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
303 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
304 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
305 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
306 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
307 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
308 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
309 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
310 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
311 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
312 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
313 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
314 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
315 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
316 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
317 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
318 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
319 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --Bug 2047229
320 p_module_name IN VARCHAR2,
321 p_module_version IN VARCHAR2
322 , p_out_rec_application_id OUT NOCOPY NUMBER
323 , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL
324 , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL
325 , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
326 , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
327 , p_secondary_app_ref_type IN
328 ar_receivable_applications.secondary_application_ref_type%TYPE := null
329 , p_secondary_app_ref_num IN
330 ar_receivable_applications.secondary_application_ref_num%TYPE := null
331 );
332
333 /* jrautiai BR implementation */
334 PROCEDURE activity_application(
335 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
339 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
336 p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
337 p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
338 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
340 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
341 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
342 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
343 p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
344 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
345 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
346 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
347 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
348 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
349 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
350 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
351 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
352 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
353 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
354 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
355 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
356 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
357 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
358 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
359 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
360 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
361 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
362 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
363 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
364 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
365 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
366 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
367 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
368 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
369 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
370 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
371 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
372 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
373 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
374 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
375 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
376 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
377 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
378 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
379 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
380 p_comments IN
381 ar_receivable_applications.comments%TYPE DEFAULT NULL,
382 p_module_name IN VARCHAR2,
383 p_module_version IN VARCHAR2,
384 p_application_ref_type IN OUT NOCOPY
385 ar_receivable_applications.application_ref_type%TYPE,
386 p_application_ref_id IN OUT NOCOPY
387 ar_receivable_applications.application_ref_id%TYPE,
388 p_application_ref_num IN OUT NOCOPY
389 ar_receivable_applications.application_ref_num%TYPE,
390 p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
391 p_payment_set_id IN NUMBER DEFAULT NULL,
392 p_called_from IN VARCHAR2 DEFAULT NULL , /*5444407*/
393 p_out_rec_application_id OUT NOCOPY NUMBER,
394 p_applied_rec_app_id IN NUMBER DEFAULT NULL,
395 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
396 p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
397 p_netted_cash_receipt_id IN
398 ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL ,
399 p_secondary_app_ref_type IN
400 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
401 p_secondary_app_ref_num IN
402 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
403 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
404 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL --Bug5450371
405
406 );
407
408 --Other_account_application procedure is introduced for Claim application
409 PROCEDURE other_account_application(
410 p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
411 p_amount_applied IN
412 ar_receivable_applications.amount_applied%TYPE,
413 p_apply_date IN ar_receivable_applications.apply_date%TYPE,
414 p_gl_date IN ar_receivable_applications.gl_date%TYPE,
415 p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
416 p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
417 p_ussgl_transaction_code IN
418 ar_receivable_applications.ussgl_transaction_code%TYPE,
419 p_application_ref_type IN
423 p_application_ref_num IN
420 ar_receivable_applications.application_ref_type%TYPE,
421 p_application_ref_id IN
422 ar_receivable_applications.application_ref_id%TYPE,
424 ar_receivable_applications.application_ref_num%TYPE,
425 p_secondary_application_ref_id IN NUMBER DEFAULT NULL,
426 p_comments IN
427 ar_receivable_applications.comments%TYPE,
428 p_attribute_category IN
429 ar_receivable_applications.attribute_category%TYPE,
430 p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
431 p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
432 p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
433 p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
434 p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
435 p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
436 p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
437 p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
438 p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
439 p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
440 p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
441 p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
442 p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
443 p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
444 p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
445 p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
446 p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
447 p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
448 p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
449 p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
450 p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
451 p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
452 p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
453 p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
454 p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
455 p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
456 p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
457 p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
458 p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
459 p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
460 p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
461 p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
462 p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
463 p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
464 p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
465 p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
466 p_module_name IN VARCHAR2,
467 p_module_version IN VARCHAR2,
468 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
469 x_application_ref_id OUT NOCOPY
470 ar_receivable_applications.application_ref_id%TYPE,
471 x_application_ref_num OUT NOCOPY
472 ar_receivable_applications.application_ref_num%TYPE
473 , x_return_status OUT NOCOPY VARCHAR2
474 , x_msg_count OUT NOCOPY NUMBER
475 , x_msg_data OUT NOCOPY VARCHAR2
476 , p_out_rec_application_id OUT NOCOPY NUMBER
477 , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL
478 , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL
479 , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
480 , x_claim_reason_name OUT NOCOPY VARCHAR2
481 , p_called_from IN VARCHAR2 DEFAULT NULL
482 );
483 PROCEDURE create_claim(
484 p_amount IN NUMBER
485 , p_amount_applied IN NUMBER
486 , p_currency_code IN VARCHAR2
487 , p_exchange_rate_type IN VARCHAR2
488 , p_exchange_rate_date IN DATE
489 , p_exchange_rate IN NUMBER
490 , p_customer_trx_id IN NUMBER
491 , p_invoice_ps_id IN NUMBER
492 , p_cust_trx_type_id IN NUMBER
493 , p_trx_number IN VARCHAR2
494 , p_cust_account_id IN NUMBER
495 , p_bill_to_site_id IN NUMBER
496 , p_ship_to_site_id IN NUMBER
497 , p_salesrep_id IN NUMBER
498 , p_customer_ref_date IN DATE
499 , p_customer_ref_number IN VARCHAR2
500 , p_cash_receipt_id IN NUMBER
501 , p_receipt_number IN VARCHAR2
502 , p_reason_id IN NUMBER
503 , p_customer_reason IN VARCHAR2
504 , p_comments IN VARCHAR2
505 , p_apply_date IN DATE DEFAULT NULL
506 , p_attribute_category IN VARCHAR2
507 , p_attribute1 IN VARCHAR2
508 , p_attribute2 IN VARCHAR2
509 , p_attribute3 IN VARCHAR2
513 , p_attribute7 IN VARCHAR2
510 , p_attribute4 IN VARCHAR2
511 , p_attribute5 IN VARCHAR2
512 , p_attribute6 IN VARCHAR2
514 , p_attribute8 IN VARCHAR2
515 , p_attribute9 IN VARCHAR2
516 , p_attribute10 IN VARCHAR2
517 , p_attribute11 IN VARCHAR2
518 , p_attribute12 IN VARCHAR2
519 , p_attribute13 IN VARCHAR2
520 , p_attribute14 IN VARCHAR2
521 , p_attribute15 IN VARCHAR2
522 , x_return_status OUT NOCOPY VARCHAR2
523 , x_msg_count OUT NOCOPY NUMBER
524 , x_msg_data OUT NOCOPY VARCHAR2
525 , x_claim_id OUT NOCOPY NUMBER
526 , x_claim_number OUT NOCOPY VARCHAR2
527 , x_claim_reason_name OUT NOCOPY VARCHAR2
528 , p_legal_entity_id IN NUMBER);
529
530 PROCEDURE update_claim(
531 p_claim_id IN OUT NOCOPY NUMBER
532 , p_invoice_ps_id IN NUMBER
533 , p_customer_trx_id IN NUMBER
534 , p_amount IN NUMBER
535 , p_amount_applied IN NUMBER
536 , p_apply_date IN DATE
537 , p_cash_receipt_id IN NUMBER
538 , p_receipt_number IN VARCHAR2
539 , p_action_type IN VARCHAR2
540 , x_claim_reason_code_id OUT NOCOPY NUMBER
541 , x_claim_reason_name OUT NOCOPY VARCHAR2
542 , x_claim_number OUT NOCOPY VARCHAR2
543 , x_return_status OUT NOCOPY VARCHAR2
544 , x_msg_count OUT NOCOPY NUMBER
545 , x_msg_data OUT NOCOPY VARCHAR2);
546
547 PROCEDURE get_claim_status(
548 p_claim_id IN NUMBER,
549 x_claim_status OUT NOCOPY VARCHAR2);
550
551 PROCEDURE put_trx_in_dispute(
552 p_invoice_ps_id IN NUMBER
553 , p_dispute_amount IN NUMBER
554 , p_active_claim IN VARCHAR2 DEFAULT NULL);
555
556 PROCEDURE update_dispute_on_trx(
557 p_invoice_ps_id IN NUMBER
558 , p_active_claim IN VARCHAR2 DEFAULT NULL
559 , p_amount IN NUMBER);
560
561 PROCEDURE fetch_app_ccid(
562 p_invoice_ps_id IN
563 ar_payment_schedules.payment_schedule_id%TYPE,
564 p_applied_customer_trx_id OUT NOCOPY
565 ar_receivable_applications.applied_customer_trx_id%TYPE, p_code_combination_id OUT NOCOPY
566 ar_receivable_applications.code_combination_id%TYPE,
567 p_source_type OUT NOCOPY
568 ar_distributions.source_type%TYPE);
569
570 PROCEDURE Unassociate_Regular_CM ( p_cust_Trx_id IN NUMBER,
571 p_app_cust_trx_id IN NUMBER);
572
573 FUNCTION is_regular_cm (p_customer_Trx_id IN NUMBER,
574 p_invoicing_rule_id OUT NOCOPY NUMBER) return BOOLEAN;
575
576 END arp_process_application;
[Home] [Help]