1 PACKAGE ARP_PROCESS_WRITEOFF AUTHID CURRENT_USER AS
2 /* $Header: ARPWRTFS.pls 120.4 2011/01/16 12:23:52 rsamanta 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 g_request_id NUMBER := -1;
14
15 PROCEDURE create_receipt_writeoff (
16 errbuf IN OUT NOCOPY VARCHAR2,
17 retcode IN OUT NOCOPY VARCHAR2,
18 p_receipt_currency_code IN ar_cash_receipts.currency_code%type,
19 p_unapp_amount IN VARCHAR2,
20 p_unapp_amount_percent IN VARCHAR2,
21 p_receipt_date_from IN VARCHAR2,
22 p_receipt_date_to IN VARCHAR2,
23 p_receipt_gl_date_from IN VARCHAR2,
24 p_receipt_gl_date_to IN VARCHAR2,
25 p_receipt_method_id IN VARCHAR2,
26 p_customer_number IN VARCHAR2,
27 p_receipt_number IN ar_cash_receipts.receipt_number%type,
28 p_receivable_trx_id IN VARCHAR2,
29 p_apply_date IN VARCHAR2,
30 p_gl_date IN VARCHAR2,
31 p_comments IN ar_receivable_applications.comments%type
32 );
33
34 FUNCTION unapplied_amount(p_cash_receipt_id IN NUMBER,
35 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
36 p_user_id IN ar_approval_user_limits.user_id%TYPE,
37 p_request_id IN NUMBER DEFAULT NULL, /*5444407*/
38 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE
39 default NULL,
40 p_amount_from IN NUMBER default null,
41 p_amount_to IN NUMBER default null)
42 RETURN NUMBER;
43
44 FUNCTION applied_amount(p_cash_receipt_id IN NUMBER,
45 p_request_id IN NUMBER DEFAULT 0)
46 RETURN NUMBER;
47
48 FUNCTION on_account_amount(p_cash_receipt_id IN NUMBER) RETURN NUMBER;
49
50 FUNCTION balancing_segment(p_code_combination_id IN NUMBER) RETURN VARCHAR2;
51
52
53 END ARP_PROCESS_WRITEOFF;