1: PACKAGE ARP_REVERSE_RECEIPT AUTHID CURRENT_USER AS
2: /* $Header: ARREREVS.pls 120.3.12010000.2 2009/01/22 11:12:44 spdixit 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,
2: /* $Header: ARREREVS.pls 120.3.12010000.2 2009/01/22 11:12:44 spdixit 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 */
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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)
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: FUNCTION check_settlement_status(