1: PACKAGE ARP_RW_BATCHES_CHECK_PKG AS
2: /* $Header: ARERBA1S.pls 120.3 2003/10/23 21:49:45 orashid ship $ */
3: PROCEDURE update_manual_batch(
4: p_row_id IN VARCHAR2,
5: p_batch_id IN ar_batches.batch_id%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
2: /* $Header: ARERBA1S.pls 120.3 2003/10/23 21:49:45 orashid ship $ */
3: PROCEDURE update_manual_batch(
4: p_row_id IN VARCHAR2,
5: p_batch_id IN ar_batches.batch_id%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
3: PROCEDURE update_manual_batch(
4: p_row_id IN VARCHAR2,
5: p_batch_id IN ar_batches.batch_id%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
4: p_row_id IN VARCHAR2,
5: p_batch_id IN ar_batches.batch_id%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
5: p_batch_id IN ar_batches.batch_id%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
7: p_batch_date IN ar_batches.batch_date%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
8: p_gl_date IN ar_batches.gl_date%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
9: p_deposit_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
11: p_comments IN ar_batches.comments%TYPE,
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
12: p_control_amount IN ar_batches.control_amount%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
13: p_control_count IN ar_batches.control_count%TYPE,
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
14: p_exchange_date IN ar_batches.exchange_date%TYPE,
15: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
16: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
19: p_remittance_bank_account_id
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
20: IN ar_batches.remit_bank_acct_use_id%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
21: p_remittance_bank_branch_id
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
22: IN ar_batches.remittance_bank_branch_id%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
23: p_attribute_category IN ar_batches.attribute_category%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
24: p_attribute1 IN ar_batches.attribute1%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
27: p_attribute4 IN ar_batches.attribute4%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
28: p_attribute5 IN ar_batches.attribute5%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
29: p_attribute6 IN ar_batches.attribute6%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
30: p_attribute7 IN ar_batches.attribute7%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
38: p_attribute15 IN ar_batches.attribute15%TYPE,
31: p_attribute8 IN ar_batches.attribute8%TYPE,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
38: p_attribute15 IN ar_batches.attribute15%TYPE,
39: p_module_name IN VARCHAR2,
32: p_attribute9 IN ar_batches.attribute9%TYPE,
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
38: p_attribute15 IN ar_batches.attribute15%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2 );
33: p_attribute10 IN ar_batches.attribute10%TYPE,
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
38: p_attribute15 IN ar_batches.attribute15%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2 );
41:
34: p_attribute11 IN ar_batches.attribute11%TYPE,
35: p_attribute12 IN ar_batches.attribute12%TYPE,
36: p_attribute13 IN ar_batches.attribute13%TYPE,
37: p_attribute14 IN ar_batches.attribute14%TYPE,
38: p_attribute15 IN ar_batches.attribute15%TYPE,
39: p_module_name IN VARCHAR2,
40: p_module_version IN VARCHAR2 );
41:
42: PROCEDURE update_remit_batch(
40: p_module_version IN VARCHAR2 );
41:
42: PROCEDURE update_remit_batch(
43: p_row_id IN VARCHAR2,
44: p_batch_id IN ar_batches.batch_id%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
41:
42: PROCEDURE update_remit_batch(
43: p_row_id IN VARCHAR2,
44: p_batch_id IN ar_batches.batch_id%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
42: PROCEDURE update_remit_batch(
43: p_row_id IN VARCHAR2,
44: p_batch_id IN ar_batches.batch_id%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
43: p_row_id IN VARCHAR2,
44: p_batch_id IN ar_batches.batch_id%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
44: p_batch_id IN ar_batches.batch_id%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
45: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
46: p_batch_date IN ar_batches.batch_date%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
47: p_gl_date IN ar_batches.gl_date%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
48: p_deposit_date IN ar_batches.batch_date%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
49: p_currency_code IN ar_batches.currency_code%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
50: p_comments IN ar_batches.comments%TYPE,
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
51: p_control_amount IN ar_batches.control_amount%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
52: p_control_count IN ar_batches.control_count%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
58: p_remittance_bank_account_id
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
59: IN ar_batches.remit_bank_acct_use_id%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
60: p_remittance_bank_branch_id
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
61: IN ar_batches.remittance_bank_branch_id%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
62: p_media_reference IN ar_batches.media_reference%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
63: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
66: p_attribute_category IN ar_batches.attribute_category%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
67: p_attribute1 IN ar_batches.attribute1%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
68: p_attribute2 IN ar_batches.attribute2%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
69: p_attribute3 IN ar_batches.attribute3%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
70: p_attribute4 IN ar_batches.attribute4%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
71: p_attribute5 IN ar_batches.attribute5%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
72: p_attribute6 IN ar_batches.attribute6%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
73: p_attribute7 IN ar_batches.attribute7%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
81: p_attribute15 IN ar_batches.attribute15%TYPE,
74: p_attribute8 IN ar_batches.attribute8%TYPE,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
81: p_attribute15 IN ar_batches.attribute15%TYPE,
82: p_module_name IN VARCHAR2,
75: p_attribute9 IN ar_batches.attribute9%TYPE,
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
81: p_attribute15 IN ar_batches.attribute15%TYPE,
82: p_module_name IN VARCHAR2,
83: p_module_version IN VARCHAR2 );
76: p_attribute10 IN ar_batches.attribute10%TYPE,
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
81: p_attribute15 IN ar_batches.attribute15%TYPE,
82: p_module_name IN VARCHAR2,
83: p_module_version IN VARCHAR2 );
84:
77: p_attribute11 IN ar_batches.attribute11%TYPE,
78: p_attribute12 IN ar_batches.attribute12%TYPE,
79: p_attribute13 IN ar_batches.attribute13%TYPE,
80: p_attribute14 IN ar_batches.attribute14%TYPE,
81: p_attribute15 IN ar_batches.attribute15%TYPE,
82: p_module_name IN VARCHAR2,
83: p_module_version IN VARCHAR2 );
84:
85: PROCEDURE update_auto_batch(
83: p_module_version IN VARCHAR2 );
84:
85: PROCEDURE update_auto_batch(
86: p_row_id IN VARCHAR2,
87: p_batch_id IN ar_batches.batch_id%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
84:
85: PROCEDURE update_auto_batch(
86: p_row_id IN VARCHAR2,
87: p_batch_id IN ar_batches.batch_id%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
85: PROCEDURE update_auto_batch(
86: p_row_id IN VARCHAR2,
87: p_batch_id IN ar_batches.batch_id%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
86: p_row_id IN VARCHAR2,
87: p_batch_id IN ar_batches.batch_id%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
87: p_batch_id IN ar_batches.batch_id%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
88: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
89: p_batch_date IN ar_batches.batch_date%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
90: p_gl_date IN ar_batches.gl_date%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
91: p_deposit_date IN ar_batches.batch_date%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
92: p_currency_code IN ar_batches.currency_code%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
93: p_comments IN ar_batches.comments%TYPE,
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
94: p_control_amount IN ar_batches.control_amount%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
95: p_control_count IN ar_batches.control_count%TYPE,
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
96: p_exchange_date IN ar_batches.exchange_date%TYPE,
97: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
98: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
101: p_remittance_bank_account_id
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
102: IN ar_batches.remit_bank_acct_use_id%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
103: p_remittance_bank_branch_id
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
104: IN ar_batches.remittance_bank_branch_id%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
105: p_media_reference IN ar_batches.media_reference%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
106: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
109: p_attribute_category IN ar_batches.attribute_category%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
110: p_attribute1 IN ar_batches.attribute1%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
111: p_attribute2 IN ar_batches.attribute2%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
112: p_attribute3 IN ar_batches.attribute3%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
113: p_attribute4 IN ar_batches.attribute4%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
114: p_attribute5 IN ar_batches.attribute5%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
115: p_attribute6 IN ar_batches.attribute6%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
116: p_attribute7 IN ar_batches.attribute7%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
124: p_attribute15 IN ar_batches.attribute15%TYPE,
117: p_attribute8 IN ar_batches.attribute8%TYPE,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
124: p_attribute15 IN ar_batches.attribute15%TYPE,
125: p_module_name IN VARCHAR2,
118: p_attribute9 IN ar_batches.attribute9%TYPE,
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
124: p_attribute15 IN ar_batches.attribute15%TYPE,
125: p_module_name IN VARCHAR2,
126: p_module_version IN VARCHAR2 );
119: p_attribute10 IN ar_batches.attribute10%TYPE,
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
124: p_attribute15 IN ar_batches.attribute15%TYPE,
125: p_module_name IN VARCHAR2,
126: p_module_version IN VARCHAR2 );
127: --
120: p_attribute11 IN ar_batches.attribute11%TYPE,
121: p_attribute12 IN ar_batches.attribute12%TYPE,
122: p_attribute13 IN ar_batches.attribute13%TYPE,
123: p_attribute14 IN ar_batches.attribute14%TYPE,
124: p_attribute15 IN ar_batches.attribute15%TYPE,
125: p_module_name IN VARCHAR2,
126: p_module_version IN VARCHAR2 );
127: --
128: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE );
124: p_attribute15 IN ar_batches.attribute15%TYPE,
125: p_module_name IN VARCHAR2,
126: p_module_version IN VARCHAR2 );
127: --
128: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE );
129: --
130: PROCEDURE check_unique_batch_name(
131: p_row_id IN VARCHAR2,
132: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
129: --
130: PROCEDURE check_unique_batch_name(
131: p_row_id IN VARCHAR2,
132: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
133: p_batch_name IN ar_batches.name%TYPE,
134: p_module_name IN VARCHAR2,
135: p_module_version IN VARCHAR2 );
136: --
137: PROCEDURE check_unique_batch_name(
136: --
137: PROCEDURE check_unique_batch_name(
138: p_row_id IN VARCHAR2,
139: p_batch_source_name IN ar_batch_sources.name%TYPE,
140: p_batch_name IN ar_batches.name%TYPE,
141: p_module_name IN VARCHAR2,
142: p_module_version IN VARCHAR2 );
143: --
144: PROCEDURE check_unique_media_ref(
142: p_module_version IN VARCHAR2 );
143: --
144: PROCEDURE check_unique_media_ref(
145: p_row_id IN VARCHAR2,
146: p_media_ref IN ar_batches.media_reference%TYPE,
147: p_module_name IN VARCHAR2,
148: p_module_version IN VARCHAR2 );
149: --
150: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
146: p_media_ref IN ar_batches.media_reference%TYPE,
147: p_module_name IN VARCHAR2,
148: p_module_version IN VARCHAR2 );
149: --
150: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
151: p_set_of_books_id IN
152: ar_batches.set_of_books_id%TYPE,
153: p_transmission_id IN
154: ar_batches.transmission_id%TYPE,
148: p_module_version IN VARCHAR2 );
149: --
150: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
151: p_set_of_books_id IN
152: ar_batches.set_of_books_id%TYPE,
153: p_transmission_id IN
154: ar_batches.transmission_id%TYPE,
155: p_batch_applied_status OUT NOCOPY
156: ar_batches.batch_applied_status%TYPE,
150: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
151: p_set_of_books_id IN
152: ar_batches.set_of_books_id%TYPE,
153: p_transmission_id IN
154: ar_batches.transmission_id%TYPE,
155: p_batch_applied_status OUT NOCOPY
156: ar_batches.batch_applied_status%TYPE,
157: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
158: p_module_name IN VARCHAR2,
152: ar_batches.set_of_books_id%TYPE,
153: p_transmission_id IN
154: ar_batches.transmission_id%TYPE,
155: p_batch_applied_status OUT NOCOPY
156: ar_batches.batch_applied_status%TYPE,
157: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
158: p_module_name IN VARCHAR2,
159: p_module_version IN VARCHAR2 );
160: --
153: p_transmission_id IN
154: ar_batches.transmission_id%TYPE,
155: p_batch_applied_status OUT NOCOPY
156: ar_batches.batch_applied_status%TYPE,
157: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
158: p_module_name IN VARCHAR2,
159: p_module_version IN VARCHAR2 );
160: --
161: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
157: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
158: p_module_name IN VARCHAR2,
159: p_module_version IN VARCHAR2 );
160: --
161: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
162: p_actual_amount_total OUT NOCOPY NUMBER,
163: p_actual_count_total OUT NOCOPY NUMBER,
164: p_unidentified_amount_total OUT NOCOPY NUMBER,
165: p_unidentified_count_total OUT NOCOPY NUMBER,
173: p_claim_count_total OUT NOCOPY NUMBER,
174: p_module_name IN VARCHAR2,
175: p_module_version IN VARCHAR2 );
176: --
177: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
178: p_actual_amount_total OUT NOCOPY NUMBER,
179: p_actual_count_total OUT NOCOPY NUMBER,
180: p_unidentified_amount_total OUT NOCOPY NUMBER,
181: p_unidentified_count_total OUT NOCOPY NUMBER,