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