1 PACKAGE ar_receipt_lib_pvt AUTHID CURRENT_USER AS
2 /* $Header: ARXPRELS.pls 120.19.12010000.4 2009/04/10 16:38:52 spdixit ship $ */
3 --These package variables contain the profile option values.
4 pg_profile_doc_seq VARCHAR2(240);
5 pg_profile_enable_cc VARCHAR2(240);
6 pg_profile_appln_gl_date_def VARCHAR2(240);
7 pg_profile_amt_applied_def VARCHAR2(240);
8 pg_profile_cc_rate_type VARCHAR2(240);
9 pg_profile_dsp_inv_rate VARCHAR2(240);
10 pg_profile_create_bk_charges VARCHAR2(240);
11 pg_profile_def_x_rate_type VARCHAR2(240);
12
13 pg_cust_derived_from VARCHAR2(20);
14
15 /* Revert changes done for customer bank ref from Default_cash_ids under payment uptake */
16 PROCEDURE Default_cash_ids(
17 p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
18 p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
19 p_customer_name IN hz_parties.party_name%TYPE,
20 p_customer_number IN hz_cust_accounts.account_number%TYPE,
21 p_location IN hz_cust_site_uses.location%type,
22 p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
23 /* 6612301 */
24 p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
25 p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
26 p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
27 p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
28 p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
29 p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
30 p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
31 p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
32 p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
33 /* 6612301 */
34 p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
35 p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,
36 p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
37 p_receipt_date IN DATE,
38 p_return_status OUT NOCOPY VARCHAR2,
39 p_default_site_use IN VARCHAR2 --bug4448307-4509459
40 );
41
42 PROCEDURE Get_Cash_Defaults(
43 p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
44 p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
45 p_exchange_rate IN OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE,
46 p_exchange_rate_date IN OUT NOCOPY ar_cash_receipts.exchange_date%TYPE,
47 p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
48 p_factor_discount_amount IN OUT NOCOPY ar_cash_receipts.factor_discount_amount%TYPE,
49 p_receipt_date IN OUT NOCOPY ar_cash_receipts.receipt_date%TYPE,
50 p_gl_date IN OUT NOCOPY DATE,
51 p_maturity_date IN OUT NOCOPY DATE,
52 p_customer_receipt_reference IN OUT NOCOPY ar_cash_receipts.customer_receipt_reference%TYPE,
53 p_override_remit_account_flag IN OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE,
54 p_remittance_bank_account_id IN OUT NOCOPY ar_cash_receipts.remit_bank_acct_use_id%TYPE,
55 p_deposit_date IN OUT NOCOPY ar_cash_receipts.deposit_date%TYPE,
56 p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
57 p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
58 p_anticipated_clearing_date IN OUT NOCOPY ar_cash_receipts.anticipated_clearing_date%TYPE,
59 p_called_from IN VARCHAR2,
60 p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,
61 p_return_status OUT NOCOPY VARCHAR2
62 );
63
64 /* Bug fix 3435834 : Added two new parameters p_customer_trx_line_id and p_line_number */
65
66 PROCEDURE Default_appln_ids(
67 p_cash_receipt_id IN OUT NOCOPY NUMBER,
68 p_receipt_number IN VARCHAR2,
69 p_customer_trx_id IN OUT NOCOPY NUMBER,
70 p_trx_number IN VARCHAR2,
71 p_customer_trx_line_id IN OUT NOCOPY NUMBER,
72 p_line_number IN NUMBER,
73 p_installment IN OUT NOCOPY NUMBER,
74 p_applied_payment_schedule_id IN NUMBER,
75 p_llca_type IN VARCHAR2,
76 p_group_id IN VARCHAR2, /* Bug 5284890 */
77 p_return_status OUT NOCOPY VARCHAR2);
78
79 PROCEDURE Default_application_info(
80 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
81 p_cr_gl_date OUT NOCOPY DATE,
82 p_cr_date OUT NOCOPY DATE,
83 p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
84 p_cr_unapp_amount OUT NOCOPY NUMBER,
85 p_cr_currency_code OUT NOCOPY VARCHAR2,
86 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
87 p_installment IN OUT NOCOPY NUMBER,
88 p_show_closed_invoices IN VARCHAR2,
89 p_customer_trx_line_id IN NUMBER,
90 p_trx_due_date OUT NOCOPY DATE,
91 p_trx_currency_code OUT NOCOPY VARCHAR2,
92 p_trx_date OUT NOCOPY DATE,
93 p_trx_gl_date OUT NOCOPY DATE,
94 p_apply_gl_date IN OUT NOCOPY DATE,
95 p_calc_discount_on_lines_flag OUT NOCOPY VARCHAR2,
96 p_partial_discount_flag OUT NOCOPY VARCHAR2,
97 p_allow_overappln_flag OUT NOCOPY VARCHAR2,
98 p_natural_appln_only_flag OUT NOCOPY VARCHAR2,
99 p_creation_sign OUT NOCOPY VARCHAR2,
100 p_cr_payment_schedule_id OUT NOCOPY NUMBER,
101 p_applied_payment_schedule_id IN OUT NOCOPY NUMBER,
102 p_term_id OUT NOCOPY NUMBER,
103 p_amount_due_original OUT NOCOPY NUMBER,
104 p_amount_due_remaining OUT NOCOPY NUMBER,
105 p_trx_line_amount OUT NOCOPY NUMBER,
106 p_discount IN OUT NOCOPY NUMBER,
107 p_apply_date IN OUT NOCOPY DATE,
108 p_discount_max_allowed OUT NOCOPY NUMBER,
109 p_discount_earned_allowed OUT NOCOPY NUMBER,
110 p_discount_earned OUT NOCOPY NUMBER,
111 p_discount_unearned OUT NOCOPY NUMBER,
112 p_new_amount_due_remaining OUT NOCOPY NUMBER,
113 p_remittance_bank_account_id OUT NOCOPY NUMBER,
114 p_receipt_method_id OUT NOCOPY NUMBER,
115 p_amount_applied IN OUT NOCOPY NUMBER,
116 p_amount_applied_from IN OUT NOCOPY NUMBER,
117 p_trans_to_receipt_rate IN OUT NOCOPY NUMBER,
118 p_llca_type IN VARCHAR2,
119 p_line_amount IN OUT NOCOPY NUMBER,
120 p_tax_amount IN OUT NOCOPY NUMBER,
121 p_freight_amount IN OUT NOCOPY NUMBER,
122 p_charges_amount IN OUT NOCOPY NUMBER,
123 p_line_discount IN OUT NOCOPY NUMBER,
124 p_tax_discount IN OUT NOCOPY NUMBER,
125 p_freight_discount IN OUT NOCOPY NUMBER,
126 p_line_items_original OUT NOCOPY NUMBER,
127 p_line_items_remaining OUT NOCOPY NUMBER,
128 p_tax_original OUT NOCOPY NUMBER,
129 p_tax_remaining OUT NOCOPY NUMBER,
130 p_freight_original OUT NOCOPY NUMBER,
131 p_freight_remaining OUT NOCOPY NUMBER,
132 p_rec_charges_charged OUT NOCOPY NUMBER,
133 p_rec_charges_remaining OUT NOCOPY NUMBER,
134 p_called_from IN VARCHAR2,
135 p_return_status OUT NOCOPY VARCHAR2);
136
137 PROCEDURE Default_cash_receipt_id(
138 p_cash_receipt_id IN OUT NOCOPY NUMBER,
139 p_receipt_number IN VARCHAR2,
140 p_return_status OUT NOCOPY VARCHAR2
141 );
142
143 PROCEDURE Derive_unapp_ids(
144 p_trx_number IN VARCHAR2,
145 p_customer_trx_id IN OUT NOCOPY NUMBER,
146 p_installment IN NUMBER,
147 p_applied_payment_schedule_id IN OUT NOCOPY NUMBER,
148 p_receipt_number IN VARCHAR2,
149 p_cash_receipt_id IN OUT NOCOPY NUMBER,
150 p_receivable_application_id IN OUT NOCOPY NUMBER,
151 p_called_from IN VARCHAR2,
152 p_apply_gl_date OUT NOCOPY DATE,
153 p_return_status OUT NOCOPY VARCHAR2
154 );
155 /* Added for bug 3119391 */
156 PROCEDURE Default_unapp_info(
157 p_receivable_application_id IN NUMBER,
158 p_apply_gl_date IN DATE,
159 p_cash_receipt_id IN NUMBER,
160 p_reversal_gl_date IN OUT NOCOPY DATE,
161 p_receipt_gl_date OUT NOCOPY DATE,
162 p_cr_unapp_amount OUT NOCOPY NUMBER );
163
164 PROCEDURE Default_reverse_info(p_cash_receipt_id IN NUMBER,
165 p_reversal_gl_date IN OUT NOCOPY DATE,
166 p_reversal_date IN OUT NOCOPY DATE,
167 p_receipt_state OUT NOCOPY VARCHAR2,
168 p_receipt_gl_date OUT NOCOPY DATE,
169 p_type OUT NOCOPY VARCHAR2
170 ) ;
171
172 PROCEDURE Derive_reverse_ids(
173 p_receipt_number IN VARCHAR2,
174 p_cash_receipt_id IN OUT NOCOPY NUMBER,
175 p_reversal_category_name IN VARCHAR2,
176 p_reversal_category_code IN OUT NOCOPY VARCHAR2,
177 p_reversal_reason_name IN VARCHAR2,
178 p_reversal_reason_code IN OUT NOCOPY VARCHAR2,
179 p_return_status OUT NOCOPY VARCHAR2
180 );
181 PROCEDURE Default_on_ac_app_info(
182 p_cash_receipt_id IN NUMBER,
183 p_cr_gl_date OUT NOCOPY DATE,
184 p_cr_unapp_amount OUT NOCOPY NUMBER,
185 p_receipt_date OUT NOCOPY DATE,
186 p_cr_payment_schedule_id OUT NOCOPY NUMBER,
187 p_amount_applied IN OUT NOCOPY NUMBER,
188 p_apply_gl_date IN OUT NOCOPY DATE,
189 p_apply_date IN OUT NOCOPY DATE,
190 p_cr_currency_code OUT NOCOPY VARCHAR2,
191 p_return_status OUT NOCOPY VARCHAR2
192 );
193 PROCEDURE Derive_unapp_on_ac_ids(
194 p_receipt_number IN VARCHAR2,
195 p_cash_receipt_id IN OUT NOCOPY NUMBER,
196 p_receivable_application_id IN OUT NOCOPY NUMBER,
197 p_apply_gl_date OUT NOCOPY DATE,
198 p_return_status OUT NOCOPY VARCHAR2
199 );
200
201 PROCEDURE Derive_otheraccount_ids(
202 p_receipt_number IN VARCHAR2,
203 p_cash_receipt_id IN OUT NOCOPY NUMBER,
204 p_applied_ps_id IN NUMBER,
205 p_receivable_application_id IN OUT NOCOPY NUMBER,
206 p_apply_gl_date OUT NOCOPY DATE,
207 p_cr_unapp_amt OUT NOCOPY NUMBER, /* Bug fix 3569640 */
208 p_return_status OUT NOCOPY VARCHAR2
209 );
210
211 PROCEDURE Default_unapp_on_ac_act_info(
212 p_receivable_application_id IN NUMBER,
213 p_apply_gl_date IN DATE,
214 p_cash_receipt_id IN NUMBER,
215 p_reversal_gl_date IN OUT NOCOPY DATE,
216 p_receipt_gl_date OUT NOCOPY DATE
217 );
218
219 PROCEDURE Derive_activity_unapp_ids(
220 p_receipt_number IN VARCHAR2,
221 p_cash_receipt_id IN OUT NOCOPY NUMBER,
222 p_receivable_application_id IN OUT NOCOPY NUMBER,
223 p_called_from IN VARCHAR2,
224 p_apply_gl_date OUT NOCOPY DATE,
225 p_cr_unapp_amount OUT NOCOPY NUMBER, /* Bug fix 3569640 */
226 p_return_status OUT NOCOPY VARCHAR2);
227
228 /* bug 2649369, proactive change to param p_met_code, change type from CHAR to VARCHAR2 */
229
230 PROCEDURE get_doc_seq(
231 p_application_id IN NUMBER,
232 p_document_name IN VARCHAR2,
233 p_sob_id IN NUMBER,
234 p_met_code IN VARCHAR2,
235 p_trx_date IN DATE,
236 p_doc_sequence_value IN OUT NOCOPY NUMBER,
237 p_doc_sequence_id OUT NOCOPY NUMBER,
238 p_return_status OUT NOCOPY VARCHAR2
239 );
240 PROCEDURE Derive_cust_info_from_trx(
241 p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
242 p_trx_number IN ra_customer_trx.trx_number%TYPE,
243 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
244 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
245 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
246 p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
247 p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
248 p_return_status OUT NOCOPY VARCHAR2
249 );
250 PROCEDURE Validate_Desc_Flexfield(
251 p_desc_flex_rec IN OUT NOCOPY ar_receipt_api_pub.attribute_rec_type,
252 p_desc_flex_name IN VARCHAR2,
253 p_return_status IN OUT NOCOPY VARCHAR2
254 );
255 /* Bug fix 3539008 */
256 PROCEDURE Default_Desc_Flexfield(
257 p_desc_flex_rec OUT NOCOPY ar_receipt_api_pub.attribute_rec_type,
258 p_cash_receipt_id IN NUMBER,
259 p_return_status IN OUT NOCOPY VARCHAR2
260 );
261 -- Bug 4594101: ETAX: added p_receipt_Date for derivation of
262 -- tax rates.
263 PROCEDURE Default_misc_ids(
264 p_usr_currency_code IN VARCHAR2,
265 p_usr_exchange_rate_type IN VARCHAR2,
266 p_activity IN VARCHAR2,
267 p_reference_type IN VARCHAR2,
268 p_reference_num IN VARCHAR2,
269 p_tax_code IN VARCHAR2,
270 p_receipt_method_name IN OUT NOCOPY VARCHAR2,
271 p_remittance_bank_account_name IN VARCHAR2,
272 p_remittance_bank_account_num IN VARCHAR2,
273 p_currency_code IN OUT NOCOPY VARCHAR2,
274 p_exchange_rate_type IN OUT NOCOPY VARCHAR2,
275 p_receivables_trx_id IN OUT NOCOPY NUMBER,
276 p_reference_id IN OUT NOCOPY NUMBER,
277 p_vat_tax_id IN OUT NOCOPY NUMBER,
278 p_receipt_method_id IN OUT NOCOPY NUMBER,
279 p_remittance_bank_account_id IN OUT NOCOPY NUMBER,
280 p_return_status OUT NOCOPY VARCHAR2,
281 p_receipt_date IN DATE DEFAULT NULL
282 );
283 PROCEDURE Get_misc_defaults(
284 p_currency_code IN OUT NOCOPY VARCHAR2,
285 p_exchange_rate_type IN OUT NOCOPY VARCHAR2,
286 p_exchange_rate IN OUT NOCOPY NUMBER,
287 p_exchange_date IN OUT NOCOPY DATE,
288 p_amount IN OUT NOCOPY NUMBER,
289 p_receipt_date IN OUT NOCOPY DATE,
290 p_gl_date IN OUT NOCOPY DATE,
291 p_remittance_bank_account_id IN OUT NOCOPY NUMBER,
292 p_deposit_date IN OUT NOCOPY DATE,
293 p_state IN OUT NOCOPY VARCHAR2,
294 p_distribution_set_id IN OUT NOCOPY NUMBER,
295 p_vat_tax_id IN OUT NOCOPY NUMBER,
296 p_tax_rate IN OUT NOCOPY NUMBER,
297 p_receipt_method_id IN NUMBER,
298 p_receivables_trx_id IN NUMBER,
299 p_tax_code IN VARCHAR2,
300 p_tax_amount IN NUMBER,
301 p_creation_method_code OUT NOCOPY VARCHAR2,
302 p_return_status OUT NOCOPY VARCHAR2
303 );
304
305 PROCEDURE Default_prepay_cc_activity(
306 p_appl_type IN VARCHAR2,
307 p_receivable_trx_id IN OUT NOCOPY NUMBER,
308 p_return_status OUT NOCOPY VARCHAR2
309 );
310
311 PROCEDURE default_open_receipt(
312 p_cash_receipt_id IN OUT NOCOPY NUMBER
313 , p_receipt_number IN OUT NOCOPY VARCHAR2
314 , p_applied_ps_id IN OUT NOCOPY NUMBER
315 , p_open_cash_receipt_id IN OUT NOCOPY NUMBER
316 , p_open_receipt_number IN OUT NOCOPY VARCHAR2
317 , p_apply_gl_date IN OUT NOCOPY DATE
318 , p_open_rec_app_id IN NUMBER
319 , x_cr_payment_schedule_id OUT NOCOPY NUMBER
320 , x_last_receipt_date OUT NOCOPY DATE
321 , x_open_applied_ps_id OUT NOCOPY NUMBER
322 , x_unapplied_cash OUT NOCOPY NUMBER
323 , x_open_amount_applied OUT NOCOPY NUMBER
324 , x_claim_rec_trx_id OUT NOCOPY NUMBER
325 , x_application_ref_num OUT NOCOPY VARCHAR2
326 , x_secondary_app_ref_id OUT NOCOPY NUMBER
327 , x_application_ref_reason OUT NOCOPY VARCHAR2
328 , x_customer_reference OUT NOCOPY VARCHAR2
329 , x_customer_reason OUT NOCOPY VARCHAR2
330 , x_cr_gl_date OUT NOCOPY DATE
331 , x_open_cr_gl_date OUT NOCOPY DATE
332 , x_receipt_currency OUT NOCOPY VARCHAR2
333 , x_open_receipt_currency OUT NOCOPY VARCHAR2
334 , x_cr_customer_id OUT NOCOPY NUMBER
335 , x_open_cr_customer_id OUT NOCOPY NUMBER
336 , x_return_status OUT NOCOPY VARCHAR2);
337
338 PROCEDURE default_unapp_open_receipt(
339 p_receivable_application_id IN NUMBER
340 , x_applied_cash_receipt_id OUT NOCOPY NUMBER
341 , x_applied_rec_app_id OUT NOCOPY NUMBER
342 , x_amount_applied OUT NOCOPY NUMBER
343 , x_return_status OUT NOCOPY VARCHAR2);
344
345 FUNCTION get_legal_entity (p_remit_bank_acct_use_id IN NUMBER)
346 RETURN NUMBER;
347
348 PROCEDURE default_refund_attributes (
349 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
350 ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
351 ,p_currency_code IN fnd_currencies.currency_code%TYPE
352 ,p_amount IN NUMBER
353 ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
354 ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
355 ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
356 ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
357 ,x_party_address OUT NOCOPY VARCHAR2
358 ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE
359 ,x_exchange_rate_type OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE
360 ,x_exchange_date OUT NOCOPY ar_cash_receipts.exchange_date%TYPE
361 ,x_legal_entity_id OUT NOCOPY ar_cash_receipts.legal_entity_id%TYPE
362 ,x_payment_method_code OUT NOCOPY ap_invoices.payment_method_code%TYPE
363 ,x_payment_method_name OUT NOCOPY VARCHAR2
364 ,x_bank_account_id OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE
365
366 ,x_bank_account_num OUT NOCOPY VARCHAR2
367 ,x_payment_reason_code OUT NOCOPY ap_invoices.payment_reason_code%TYPE
368 ,x_payment_reason_name OUT NOCOPY VARCHAR2
369 ,x_delivery_channel_code OUT NOCOPY ap_invoices.delivery_channel_code%TYPE
370 ,x_delivery_channel_name OUT NOCOPY VARCHAR2
371 ,x_pay_alone_flag OUT NOCOPY VARCHAR2
372 ,x_return_status OUT NOCOPY VARCHAR2
373 ,x_msg_count OUT NOCOPY NUMBER
374 ,x_msg_data OUT NOCOPY VARCHAR2
375 );
376
377
378
379 PROCEDURE populate_llca_gt (
380 p_customer_trx_id IN NUMBER,
381 p_llca_type IN VARCHAR2,
382 p_llca_trx_lines_tbl IN ar_receipt_api_pub.llca_trx_lines_tbl_type,
383 p_line_amount IN NUMBER,
384 p_tax_amount IN NUMBER,
385 p_freight_amount IN NUMBER,
386 p_charges_amount IN NUMBER,
387 p_line_discount IN NUMBER,
388 p_tax_discount IN NUMBER,
389 p_freight_discount IN NUMBER,
390 p_amount_applied IN NUMBER,
391 p_amount_applied_from IN NUMBER,
392 p_return_status OUT NOCOPY VARCHAR2);
393
394 PROCEDURE populate_errors_gt (
395 p_customer_trx_id IN NUMBER,
396 p_customer_trx_line_id IN NUMBER,
397 p_error_message IN VARCHAR2,
398 p_invalid_value IN VARCHAR2
399 );
400
401 PROCEDURE Default_disc_and_amt_applied(
402 p_customer_id IN NUMBER,
403 p_bill_to_site_use_id IN NUMBER,
404 p_applied_payment_schedule_id IN NUMBER,
405 p_amount_applied IN OUT NOCOPY NUMBER,
406 p_discount IN OUT NOCOPY NUMBER,
407 p_term_id IN NUMBER,
408 p_installment IN NUMBER,
409 p_trx_date IN DATE,
410 p_cr_date IN DATE,
411 p_cr_currency_code IN VARCHAR2,
412 p_trx_currency_code IN VARCHAR2,
413 p_cr_exchange_rate IN NUMBER,
414 p_trx_exchange_rate IN NUMBER,
415 p_apply_date IN DATE,
416 p_amount_due_original IN NUMBER,
417 p_amount_due_remaining IN NUMBER,
418 p_cr_unapp_amount IN NUMBER,
419 p_allow_overappln_flag IN VARCHAR2,
420 p_calc_discount_on_lines_flag IN VARCHAR2,
421 p_partial_discount_flag IN VARCHAR2,
422 p_amount_line_items_original IN NUMBER,
423 p_discount_taken_unearned IN NUMBER,
424 p_discount_taken_earned IN NUMBER,
425 p_customer_trx_line_id IN NUMBER,
426 p_trx_line_amount IN NUMBER,
427 p_llca_type IN VARCHAR2,
428 p_discount_max_allowed OUT NOCOPY NUMBER,
429 p_discount_earned_allowed OUT NOCOPY NUMBER,
430 p_discount_earned OUT NOCOPY NUMBER,
431 p_discount_unearned OUT NOCOPY NUMBER,
432 p_new_amount_due_remaining OUT NOCOPY NUMBER,
433 p_return_status OUT NOCOPY VARCHAR2
434 );
435
436 PROCEDURE Default_Receipt_Method_Info(
437 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
438 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
439 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
440 p_remittance_bank_account_id IN OUT NOCOPY ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
441 p_state OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
442 p_creation_method_code OUT NOCOPY ar_receipt_classes.creation_method_code%TYPE,
443 p_called_from IN VARCHAR2,
444 p_return_status OUT NOCOPY VARCHAR2
445 ) ;
446
447 END ar_receipt_lib_pvt;
[Home] [Help]