eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_BATCHES

Line 5: p_batch_id IN ar_batches.batch_id%TYPE,

1: PACKAGE ARP_RW_BATCHES_CHECK_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARERBA1S.pls 120.5 2010/02/22 07:35:47 aghoraka 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,

Line 6: p_batch_source_id IN ar_batches.batch_source_id%TYPE,

2: /* $Header: ARERBA1S.pls 120.5 2010/02/22 07:35:47 aghoraka 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,

Line 7: p_batch_date IN ar_batches.batch_date%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,

Line 8: p_gl_date IN ar_batches.gl_date%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,

Line 9: p_deposit_date IN ar_batches.batch_date%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,

Line 10: p_currency_code IN ar_batches.currency_code%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,

Line 11: p_comments IN ar_batches.comments%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,

Line 12: p_control_amount IN ar_batches.control_amount%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,

Line 13: p_control_count IN ar_batches.control_count%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,

Line 14: p_exchange_date IN ar_batches.exchange_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,
18: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 15: p_exchange_rate IN ar_batches.exchange_rate%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

Line 16: p_exchange_rate_type IN ar_batches.exchange_rate_type%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
20: IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 17: p_receipt_class_id IN ar_batches.receipt_class_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

Line 18: p_receipt_method_id IN ar_batches.receipt_method_id%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
22: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 20: IN ar_batches.remit_bank_acct_use_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,

Line 22: IN ar_batches.remittance_bank_branch_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,
25: p_attribute2 IN ar_batches.attribute2%TYPE,
26: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 23: p_attribute_category IN ar_batches.attribute_category%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,

Line 24: p_attribute1 IN ar_batches.attribute1%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,

Line 25: p_attribute2 IN ar_batches.attribute2%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,

Line 26: p_attribute3 IN ar_batches.attribute3%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,

Line 27: p_attribute4 IN ar_batches.attribute4%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,

Line 28: p_attribute5 IN ar_batches.attribute5%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,

Line 29: p_attribute6 IN ar_batches.attribute6%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,

Line 30: p_attribute7 IN ar_batches.attribute7%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,

Line 31: p_attribute8 IN ar_batches.attribute8%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,

Line 32: p_attribute9 IN ar_batches.attribute9%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,

Line 33: p_attribute10 IN ar_batches.attribute10%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,

Line 34: p_attribute11 IN ar_batches.attribute11%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,

Line 35: p_attribute12 IN ar_batches.attribute12%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,

Line 36: p_attribute13 IN ar_batches.attribute13%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,
40: p_module_version IN VARCHAR2 );

Line 37: p_attribute14 IN ar_batches.attribute14%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 );
41:

Line 38: p_attribute15 IN ar_batches.attribute15%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:
42: PROCEDURE update_remit_batch(

Line 44: p_batch_id IN ar_batches.batch_id%TYPE,

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,

Line 45: p_batch_source_id IN ar_batches.batch_source_id%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,

Line 46: p_batch_date IN ar_batches.batch_date%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,

Line 47: p_gl_date IN ar_batches.gl_date%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,

Line 48: p_deposit_date IN ar_batches.batch_date%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,

Line 49: p_currency_code IN ar_batches.currency_code%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,

Line 50: p_comments IN ar_batches.comments%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,

Line 51: p_control_amount IN ar_batches.control_amount%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,

Line 52: p_control_count IN ar_batches.control_count%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,

Line 53: p_exchange_date IN ar_batches.exchange_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,
57: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 54: p_exchange_rate IN ar_batches.exchange_rate%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

Line 55: p_exchange_rate_type IN ar_batches.exchange_rate_type%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
59: IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 56: p_receipt_class_id IN ar_batches.receipt_class_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

Line 57: p_receipt_method_id IN ar_batches.receipt_method_id%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
61: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 59: IN ar_batches.remit_bank_acct_use_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,

Line 61: IN ar_batches.remittance_bank_branch_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,
64: p_request_id IN ar_batches.request_id%TYPE,
65: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

Line 62: p_media_reference IN ar_batches.media_reference%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,

Line 63: p_bank_deposit_number IN ar_batches.bank_deposit_number%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,

Line 64: p_request_id IN ar_batches.request_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,
68: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 65: p_operation_request_id IN ar_batches.operation_request_id%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,

Line 66: p_attribute_category IN ar_batches.attribute_category%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,

Line 67: p_attribute1 IN ar_batches.attribute1%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,

Line 68: p_attribute2 IN ar_batches.attribute2%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,

Line 69: p_attribute3 IN ar_batches.attribute3%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,

Line 70: p_attribute4 IN ar_batches.attribute4%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,

Line 71: p_attribute5 IN ar_batches.attribute5%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,

Line 72: p_attribute6 IN ar_batches.attribute6%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,

Line 73: p_attribute7 IN ar_batches.attribute7%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,

Line 74: p_attribute8 IN ar_batches.attribute8%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,

Line 75: p_attribute9 IN ar_batches.attribute9%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,

Line 76: p_attribute10 IN ar_batches.attribute10%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,

Line 77: p_attribute11 IN ar_batches.attribute11%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,

Line 78: p_attribute12 IN ar_batches.attribute12%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,

Line 79: p_attribute13 IN ar_batches.attribute13%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,
83: p_module_version IN VARCHAR2 );

Line 80: p_attribute14 IN ar_batches.attribute14%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 );
84:

Line 81: p_attribute15 IN ar_batches.attribute15%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:
85: PROCEDURE update_auto_batch(

Line 87: p_batch_id IN ar_batches.batch_id%TYPE,

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,

Line 88: p_batch_source_id IN ar_batches.batch_source_id%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,

Line 89: p_batch_date IN ar_batches.batch_date%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,

Line 90: p_gl_date IN ar_batches.gl_date%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,

Line 91: p_deposit_date IN ar_batches.batch_date%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,

Line 92: p_currency_code IN ar_batches.currency_code%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,

Line 93: p_comments IN ar_batches.comments%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,

Line 94: p_control_amount IN ar_batches.control_amount%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,

Line 95: p_control_count IN ar_batches.control_count%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,

Line 96: p_exchange_date IN ar_batches.exchange_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,
100: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 97: p_exchange_rate IN ar_batches.exchange_rate%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

Line 98: p_exchange_rate_type IN ar_batches.exchange_rate_type%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
102: IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 99: p_receipt_class_id IN ar_batches.receipt_class_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

Line 100: p_receipt_method_id IN ar_batches.receipt_method_id%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
104: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 102: IN ar_batches.remit_bank_acct_use_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,

Line 104: IN ar_batches.remittance_bank_branch_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,
107: p_request_id IN ar_batches.request_id%TYPE,
108: p_operation_request_id IN ar_batches.operation_request_id%TYPE,

Line 105: p_media_reference IN ar_batches.media_reference%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,

Line 106: p_bank_deposit_number IN ar_batches.bank_deposit_number%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,

Line 107: p_request_id IN ar_batches.request_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,
111: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 108: p_operation_request_id IN ar_batches.operation_request_id%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,

Line 109: p_attribute_category IN ar_batches.attribute_category%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,

Line 110: p_attribute1 IN ar_batches.attribute1%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,

Line 111: p_attribute2 IN ar_batches.attribute2%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,

Line 112: p_attribute3 IN ar_batches.attribute3%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,

Line 113: p_attribute4 IN ar_batches.attribute4%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,

Line 114: p_attribute5 IN ar_batches.attribute5%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,

Line 115: p_attribute6 IN ar_batches.attribute6%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,

Line 116: p_attribute7 IN ar_batches.attribute7%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,

Line 117: p_attribute8 IN ar_batches.attribute8%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,

Line 118: p_attribute9 IN ar_batches.attribute9%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,

Line 119: p_attribute10 IN ar_batches.attribute10%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,

Line 120: p_attribute11 IN ar_batches.attribute11%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,

Line 121: p_attribute12 IN ar_batches.attribute12%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,

Line 122: p_attribute13 IN ar_batches.attribute13%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,
126: p_module_version IN VARCHAR2 );

Line 123: p_attribute14 IN ar_batches.attribute14%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 );
127: --

Line 124: p_attribute15 IN ar_batches.attribute15%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: --
128: --Bug7194951

Line 129: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE,

125: p_module_name IN VARCHAR2,
126: p_module_version IN VARCHAR2 );
127: --
128: --Bug7194951
129: PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE,
130: p_called_from IN VARCHAR2 DEFAULT NULL );
131:
132: --
133: PROCEDURE check_unique_batch_name(

Line 136: p_batch_name IN ar_batches.name%TYPE,

132: --
133: PROCEDURE check_unique_batch_name(
134: p_row_id IN VARCHAR2,
135: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
136: p_batch_name IN ar_batches.name%TYPE,
137: p_module_name IN VARCHAR2,
138: p_module_version IN VARCHAR2 );
139: --
140: PROCEDURE check_unique_batch_name(

Line 143: p_batch_name IN ar_batches.name%TYPE,

139: --
140: PROCEDURE check_unique_batch_name(
141: p_row_id IN VARCHAR2,
142: p_batch_source_name IN ar_batch_sources.name%TYPE,
143: p_batch_name IN ar_batches.name%TYPE,
144: p_module_name IN VARCHAR2,
145: p_module_version IN VARCHAR2 );
146: --
147: PROCEDURE check_unique_media_ref(

Line 149: p_media_ref IN ar_batches.media_reference%TYPE,

145: p_module_version IN VARCHAR2 );
146: --
147: PROCEDURE check_unique_media_ref(
148: p_row_id IN VARCHAR2,
149: p_media_ref IN ar_batches.media_reference%TYPE,
150: p_module_name IN VARCHAR2,
151: p_module_version IN VARCHAR2 );
152: --
153: /* Added p_app_unearn_disc for ER 9288902 */

Line 154: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,

150: p_module_name IN VARCHAR2,
151: p_module_version IN VARCHAR2 );
152: --
153: /* Added p_app_unearn_disc for ER 9288902 */
154: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
155: p_set_of_books_id IN
156: ar_batches.set_of_books_id%TYPE,
157: p_transmission_id IN
158: ar_batches.transmission_id%TYPE,

Line 156: ar_batches.set_of_books_id%TYPE,

152: --
153: /* Added p_app_unearn_disc for ER 9288902 */
154: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
155: p_set_of_books_id IN
156: ar_batches.set_of_books_id%TYPE,
157: p_transmission_id IN
158: ar_batches.transmission_id%TYPE,
159: p_app_unearn_disc IN
160: VARCHAR2 DEFAULT 'N',

Line 158: ar_batches.transmission_id%TYPE,

154: PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
155: p_set_of_books_id IN
156: ar_batches.set_of_books_id%TYPE,
157: p_transmission_id IN
158: ar_batches.transmission_id%TYPE,
159: p_app_unearn_disc IN
160: VARCHAR2 DEFAULT 'N',
161: p_batch_applied_status OUT NOCOPY
162: ar_batches.batch_applied_status%TYPE,

Line 162: ar_batches.batch_applied_status%TYPE,

158: ar_batches.transmission_id%TYPE,
159: p_app_unearn_disc IN
160: VARCHAR2 DEFAULT 'N',
161: p_batch_applied_status OUT NOCOPY
162: ar_batches.batch_applied_status%TYPE,
163: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
164: p_module_name IN VARCHAR2,
165: p_module_version IN VARCHAR2 );
166: --

Line 163: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,

159: p_app_unearn_disc IN
160: VARCHAR2 DEFAULT 'N',
161: p_batch_applied_status OUT NOCOPY
162: ar_batches.batch_applied_status%TYPE,
163: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
164: p_module_name IN VARCHAR2,
165: p_module_version IN VARCHAR2 );
166: --
167: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,

Line 167: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,

163: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
164: p_module_name IN VARCHAR2,
165: p_module_version IN VARCHAR2 );
166: --
167: PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
168: p_actual_amount_total OUT NOCOPY NUMBER,
169: p_actual_count_total OUT NOCOPY NUMBER,
170: p_unidentified_amount_total OUT NOCOPY NUMBER,
171: p_unidentified_count_total OUT NOCOPY NUMBER,

Line 183: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,

179: p_claim_count_total OUT NOCOPY NUMBER,
180: p_module_name IN VARCHAR2,
181: p_module_version IN VARCHAR2 );
182: --
183: PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
184: p_actual_amount_total OUT NOCOPY NUMBER,
185: p_actual_count_total OUT NOCOPY NUMBER,
186: p_unidentified_amount_total OUT NOCOPY NUMBER,
187: p_unidentified_count_total OUT NOCOPY NUMBER,