1 PACKAGE ARP_PROCESS_WRITEOFF AS
2 /* $Header: ARPWRTFS.pls 120.2.12000000.2 2007/04/27 06:11:25 nemani ship $ */
3
4 /*5444407*/
5
6 TYPE rec_wrt_off_type IS RECORD
7 (batch_id ar_batches.batch_id%TYPE);
8
9 TYPE t_rec_wrt_off_type IS TABLE OF rec_wrt_off_type
10 INDEX BY BINARY_INTEGER;
11
12 gt_rec_wrt_off_type t_rec_wrt_off_type;
13
14 PROCEDURE create_receipt_writeoff (
15 errbuf IN OUT NOCOPY VARCHAR2,
16 retcode IN OUT NOCOPY VARCHAR2,
17 p_receipt_currency_code IN ar_cash_receipts.currency_code%type,
18 p_unapp_amount IN VARCHAR2,
19 p_unapp_amount_percent IN VARCHAR2,
20 p_receipt_date_from IN VARCHAR2,
21 p_receipt_date_to IN VARCHAR2,
22 p_receipt_gl_date_from IN VARCHAR2,
23 p_receipt_gl_date_to IN VARCHAR2,
24 p_receipt_method_id IN VARCHAR2,
25 p_customer_number IN VARCHAR2,
26 p_receipt_number IN ar_cash_receipts.receipt_number%type,
27 p_receivable_trx_id IN VARCHAR2,
28 p_apply_date IN VARCHAR2,
29 p_gl_date IN VARCHAR2,
30 p_comments IN ar_receivable_applications.comments%type
31 );
32
33 FUNCTION unapplied_amount(p_cash_receipt_id IN NUMBER,
34 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
35 p_user_id IN ar_approval_user_limits.user_id%TYPE,
36 p_request_id IN NUMBER DEFAULT NULL, /*5444407*/
37 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE
38 default NULL,
39 p_amount_from IN NUMBER default null,
40 p_amount_to IN NUMBER default null)
41 RETURN NUMBER;
42
43 FUNCTION applied_amount(p_cash_receipt_id IN NUMBER,
44 p_request_id IN NUMBER DEFAULT 0)
45 RETURN NUMBER;
46
47 FUNCTION on_account_amount(p_cash_receipt_id IN NUMBER) RETURN NUMBER;
48
49 FUNCTION balancing_segment(p_code_combination_id IN NUMBER) RETURN VARCHAR2;
50
51
52 END ARP_PROCESS_WRITEOFF;