1 PACKAGE ARP_REVERSE_RECEIPT AS
2 /* $Header: ARREREVS.pls 120.3 2005/12/24 13:16:05 jbeckett ship $*/
3 --
4 PROCEDURE reverse (
5 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6 p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
7 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
8 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
9 p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
10 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
11 p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
12 p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
13 p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
14 p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
15 p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
16 p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
17 p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
18 p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
19 p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
20 p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
21 p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
22 p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
23 p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
24 p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
25 p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
26 p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
27 p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
28 p_module_name IN VARCHAR2,
29 p_module_version IN VARCHAR2,
30 p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,
31 p_called_from IN VARCHAR2 DEFAULT NULL); /* jrautiai BR implementation */
32 --
33 PROCEDURE debit_memo_reversal(
34 p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
35 p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
36 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
37 p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
38 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
39 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
40 p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
41 p_reversal_reason_code IN
42 ar_cash_receipts.reversal_reason_code%TYPE,
43 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
44 p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
45 p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
46 p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
47 p_attribute3 IN ar_cash_receipts.attribute3%TYPE,
48 p_attribute4 IN ar_cash_receipts.attribute4%TYPE,
49 p_attribute5 IN ar_cash_receipts.attribute5%TYPE,
50 p_attribute6 IN ar_cash_receipts.attribute6%TYPE,
51 p_attribute7 IN ar_cash_receipts.attribute7%TYPE,
52 p_attribute8 IN ar_cash_receipts.attribute8%TYPE,
53 p_attribute9 IN ar_cash_receipts.attribute9%TYPE,
54 p_attribute10 IN ar_cash_receipts.attribute10%TYPE,
55 p_attribute11 IN ar_cash_receipts.attribute11%TYPE,
56 p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
57 p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
58 p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
59 p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
60 p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
61 p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
62 p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
63 p_status IN OUT NOCOPY VARCHAR2,
64 p_module_name IN VARCHAR2,
65 p_module_version IN VARCHAR2 );
66 --
67 FUNCTION receipt_has_non_cancel_claims(
68 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
69 p_include_trx_claims IN VARCHAR2 DEFAULT 'Y')
70 RETURN BOOLEAN;
71 --
72 PROCEDURE cancel_claims (p_cr_id IN NUMBER,
73 p_include_trx_claims IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77 --
78 FUNCTION receipt_has_claims(
79 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)
80 RETURN BOOLEAN;
81 --
82 PROCEDURE check_netted_receipts(
83 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
84 x_return_status OUT NOCOPY VARCHAR2);
85 --
86 FUNCTION receipt_has_processed_refunds(
87 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE)
88 RETURN BOOLEAN;
89 --
90
91 END ARP_REVERSE_RECEIPT;