1 PACKAGE AR_IREC_APPLY_CREDITS AUTHID CURRENT_USER AS
2 /* $Header: ARIAPCRS.pls 120.4 2006/05/22 14:08:09 rsinthre noship $ */
3
4
5 PROCEDURE copy_transaction_list_records(p_customer_id IN NUMBER,
6 p_customer_site_use_id IN NUMBER DEFAULT NULL,
7 p_currency_code IN VARCHAR2);
8
9 PROCEDURE copy_open_debits(p_customer_id IN NUMBER,
10 p_customer_site_use_id IN NUMBER DEFAULT NULL,
11 p_currency_code IN VARCHAR2);
12
13 PROCEDURE copy_open_credits(p_customer_id IN NUMBER,
14 p_customer_site_use_id IN NUMBER DEFAULT NULL,
15 p_currency_code IN VARCHAR2);
16
17 PROCEDURE create_apply_credits_record( p_payment_schedule_id IN NUMBER,
18 p_customer_id IN NUMBER,
19 p_customer_site_id IN NUMBER );
20
21 PROCEDURE delete_all_credits(p_customer_id IN NUMBER,
22 p_customer_site_use_id IN NUMBER DEFAULT NULL,
23 p_currency_code IN VARCHAR2
24 );
25
26 PROCEDURE delete_all_debits(p_customer_id IN NUMBER,
27 p_customer_site_use_id IN NUMBER DEFAULT NULL,
28 p_currency_code IN VARCHAR2
29 );
30
31 PROCEDURE delete_apply_credits_record( p_payment_schedule_id IN NUMBER
32 );
33
34 PROCEDURE delete_all_records(p_customer_id IN NUMBER,
35 p_customer_site_use_id IN NUMBER DEFAULT NULL,
36 p_currency_code IN VARCHAR2
37 );
38
39 PROCEDURE apply_credits(p_customer_id IN NUMBER,
40 p_customer_site_use_id IN NUMBER DEFAULT NULL,
41 p_driving_customer_id IN NUMBER,
42 p_currency_code IN VARCHAR2,
43 p_credit_memos_only IN VARCHAR2,
44 x_open_invoices_status OUT NOCOPY VARCHAR2,
45 x_dup_appln_dbt_psid OUT NOCOPY NUMBER,
46 x_dup_appln_crdt_psid OUT NOCOPY NUMBER,
47 x_cash_receipt_id OUT NOCOPY NUMBER,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE copy_apply_credits_records( p_customer_id IN NUMBER,
54 p_customer_site_use_id IN NUMBER DEFAULT NULL,
55 p_currency_code IN VARCHAR2
56 );
57
58 END AR_IREC_APPLY_CREDITS ;