DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on AR_BATCHES

Line 7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,

3: --
4: PROCEDURE insert_manual_batch(
5: p_row_id IN OUT NOCOPY VARCHAR2,
6: p_batch_type IN VARCHAR2,
7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,

Line 8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,

4: PROCEDURE insert_manual_batch(
5: p_row_id IN OUT NOCOPY VARCHAR2,
6: p_batch_type IN VARCHAR2,
7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,

Line 9: p_batch_date IN ar_batches.batch_date%TYPE,

5: p_row_id IN OUT NOCOPY VARCHAR2,
6: p_batch_type IN VARCHAR2,
7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,

Line 10: p_currency_code IN ar_batches.currency_code%TYPE,

6: p_batch_type IN VARCHAR2,
7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,

Line 11: p_name IN OUT NOCOPY ar_batches.name%TYPE,

7: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,

Line 12: p_comments IN ar_batches.comments%TYPE,

8: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 13: p_control_amount IN ar_batches.control_amount%TYPE,

9: p_batch_date IN ar_batches.batch_date%TYPE,
10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 14: p_control_count IN ar_batches.control_count%TYPE,

10: p_currency_code IN ar_batches.currency_code%TYPE,
11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

Line 15: p_deposit_date IN ar_batches.deposit_date%TYPE,

11: p_name IN OUT NOCOPY ar_batches.name%TYPE,
12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,

Line 16: p_exchange_date IN ar_batches.exchange_date%TYPE,

12: p_comments IN ar_batches.comments%TYPE,
13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

13: p_control_amount IN ar_batches.control_amount%TYPE,
14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

14: p_control_count IN ar_batches.control_count%TYPE,
15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id

Line 19: p_gl_date IN ar_batches.gl_date%TYPE,

15: p_deposit_date IN ar_batches.deposit_date%TYPE,
16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

16: p_exchange_date IN ar_batches.exchange_date%TYPE,
17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id

Line 21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

17: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 23: IN ar_batches.remit_bank_acct_use_id%TYPE,

19: p_gl_date IN ar_batches.gl_date%TYPE,
20: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,

Line 25: IN ar_batches.remittance_bank_branch_id%TYPE,

21: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 26: p_attribute_category IN ar_batches.attribute_category%TYPE,

22: p_remittance_bank_account_id
23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 27: p_attribute1 IN ar_batches.attribute1%TYPE,

23: IN ar_batches.remit_bank_acct_use_id%TYPE,
24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 28: p_attribute2 IN ar_batches.attribute2%TYPE,

24: p_remittance_bank_branch_id
25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 29: p_attribute3 IN ar_batches.attribute3%TYPE,

25: IN ar_batches.remittance_bank_branch_id%TYPE,
26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 30: p_attribute4 IN ar_batches.attribute4%TYPE,

26: p_attribute_category IN ar_batches.attribute_category%TYPE,
27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 31: p_attribute5 IN ar_batches.attribute5%TYPE,

27: p_attribute1 IN ar_batches.attribute1%TYPE,
28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 32: p_attribute6 IN ar_batches.attribute6%TYPE,

28: p_attribute2 IN ar_batches.attribute2%TYPE,
29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 33: p_attribute7 IN ar_batches.attribute7%TYPE,

29: p_attribute3 IN ar_batches.attribute3%TYPE,
30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 34: p_attribute8 IN ar_batches.attribute8%TYPE,

30: p_attribute4 IN ar_batches.attribute4%TYPE,
31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 35: p_attribute9 IN ar_batches.attribute9%TYPE,

31: p_attribute5 IN ar_batches.attribute5%TYPE,
32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 36: p_attribute10 IN ar_batches.attribute10%TYPE,

32: p_attribute6 IN ar_batches.attribute6%TYPE,
33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 37: p_attribute11 IN ar_batches.attribute11%TYPE,

33: p_attribute7 IN ar_batches.attribute7%TYPE,
34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 38: p_attribute12 IN ar_batches.attribute12%TYPE,

34: p_attribute8 IN ar_batches.attribute8%TYPE,
35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,
42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

Line 39: p_attribute13 IN ar_batches.attribute13%TYPE,

35: p_attribute9 IN ar_batches.attribute9%TYPE,
36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,
42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
43: p_module_name IN VARCHAR2,

Line 40: p_attribute14 IN ar_batches.attribute14%TYPE,

36: p_attribute10 IN ar_batches.attribute10%TYPE,
37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,
42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
43: p_module_name IN VARCHAR2,
44: p_module_version IN VARCHAR2 );

Line 41: p_attribute15 IN ar_batches.attribute15%TYPE,

37: p_attribute11 IN ar_batches.attribute11%TYPE,
38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,
42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
43: p_module_name IN VARCHAR2,
44: p_module_version IN VARCHAR2 );
45: --

Line 42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

38: p_attribute12 IN ar_batches.attribute12%TYPE,
39: p_attribute13 IN ar_batches.attribute13%TYPE,
40: p_attribute14 IN ar_batches.attribute14%TYPE,
41: p_attribute15 IN ar_batches.attribute15%TYPE,
42: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
43: p_module_name IN VARCHAR2,
44: p_module_version IN VARCHAR2 );
45: --
46: PROCEDURE insert_auto_batch(

Line 48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,

44: p_module_version IN VARCHAR2 );
45: --
46: PROCEDURE insert_auto_batch(
47: p_row_id IN OUT NOCOPY VARCHAR2,
48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%TYPE,

Line 49: p_batch_date IN ar_batches.batch_date%TYPE,

45: --
46: PROCEDURE insert_auto_batch(
47: p_row_id IN OUT NOCOPY VARCHAR2,
48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 50: p_currency_code IN ar_batches.currency_code%TYPE,

46: PROCEDURE insert_auto_batch(
47: p_row_id IN OUT NOCOPY VARCHAR2,
48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%TYPE,
53: p_exchange_date IN ar_batches.exchange_date%TYPE,
54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 51: p_name IN OUT NOCOPY ar_batches.name%TYPE,

47: p_row_id IN OUT NOCOPY VARCHAR2,
48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%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_comments IN ar_batches.comments%TYPE,

48: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%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_gl_date IN ar_batches.gl_date%TYPE,

Line 53: p_exchange_date IN ar_batches.exchange_date%TYPE,

49: p_batch_date IN ar_batches.batch_date%TYPE,
50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,

Line 54: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

50: p_currency_code IN ar_batches.currency_code%TYPE,
51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

51: p_name IN OUT NOCOPY ar_batches.name%TYPE,
52: p_comments IN ar_batches.comments%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 56: p_gl_date IN ar_batches.gl_date%TYPE,

52: p_comments IN ar_batches.comments%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,

Line 57: p_media_reference IN ar_batches.media_reference%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,

Line 58: p_receipt_class_id IN ar_batches.receipt_class_id%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_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

55: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56: p_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 60: p_attribute_category IN ar_batches.attribute_category%TYPE,

56: p_gl_date IN ar_batches.gl_date%TYPE,
57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 61: p_attribute1 IN ar_batches.attribute1%TYPE,

57: p_media_reference IN ar_batches.media_reference%TYPE,
58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 62: p_attribute2 IN ar_batches.attribute2%TYPE,

58: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 63: p_attribute3 IN ar_batches.attribute3%TYPE,

59: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 64: p_attribute4 IN ar_batches.attribute4%TYPE,

60: p_attribute_category IN ar_batches.attribute_category%TYPE,
61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 65: p_attribute5 IN ar_batches.attribute5%TYPE,

61: p_attribute1 IN ar_batches.attribute1%TYPE,
62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 66: p_attribute6 IN ar_batches.attribute6%TYPE,

62: p_attribute2 IN ar_batches.attribute2%TYPE,
63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 67: p_attribute7 IN ar_batches.attribute7%TYPE,

63: p_attribute3 IN ar_batches.attribute3%TYPE,
64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 68: p_attribute8 IN ar_batches.attribute8%TYPE,

64: p_attribute4 IN ar_batches.attribute4%TYPE,
65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 69: p_attribute9 IN ar_batches.attribute9%TYPE,

65: p_attribute5 IN ar_batches.attribute5%TYPE,
66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 70: p_attribute10 IN ar_batches.attribute10%TYPE,

66: p_attribute6 IN ar_batches.attribute6%TYPE,
67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 71: p_attribute11 IN ar_batches.attribute11%TYPE,

67: p_attribute7 IN ar_batches.attribute7%TYPE,
68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 72: p_attribute12 IN ar_batches.attribute12%TYPE,

68: p_attribute8 IN ar_batches.attribute8%TYPE,
69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,

Line 73: p_attribute13 IN ar_batches.attribute13%TYPE,

69: p_attribute9 IN ar_batches.attribute9%TYPE,
70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,
77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

Line 74: p_attribute14 IN ar_batches.attribute14%TYPE,

70: p_attribute10 IN ar_batches.attribute10%TYPE,
71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,
77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
78: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,

Line 75: p_attribute15 IN ar_batches.attribute15%TYPE,

71: p_attribute11 IN ar_batches.attribute11%TYPE,
72: p_attribute12 IN ar_batches.attribute12%TYPE,
73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,
77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
78: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
79: p_module_name IN VARCHAR2,

Line 77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

73: p_attribute13 IN ar_batches.attribute13%TYPE,
74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,
77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
78: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
79: p_module_name IN VARCHAR2,
80: p_module_version IN VARCHAR2,
81: p_bank_account_low IN VARCHAR2,

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

74: p_attribute14 IN ar_batches.attribute14%TYPE,
75: p_attribute15 IN ar_batches.attribute15%TYPE,
76: p_call_conc_req IN VARCHAR2,
77: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
78: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
79: p_module_name IN VARCHAR2,
80: p_module_version IN VARCHAR2,
81: p_bank_account_low IN VARCHAR2,
82: p_bank_account_high IN VARCHAR2 );

Line 86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,

82: p_bank_account_high IN VARCHAR2 );
83: --
84: PROCEDURE insert_remit_batch(
85: p_row_id IN OUT NOCOPY VARCHAR2,
86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,

Line 87: p_batch_date IN ar_batches.batch_date%TYPE,

83: --
84: PROCEDURE insert_remit_batch(
85: p_row_id IN OUT NOCOPY VARCHAR2,
86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,

Line 88: p_currency_code IN ar_batches.currency_code%TYPE,

84: PROCEDURE insert_remit_batch(
85: p_row_id IN OUT NOCOPY VARCHAR2,
86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

Line 89: p_name IN OUT NOCOPY ar_batches.name%TYPE,

85: p_row_id IN OUT NOCOPY VARCHAR2,
86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

Line 90: p_comments IN ar_batches.comments%TYPE,

86: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,

Line 91: p_exchange_date IN ar_batches.exchange_date%TYPE,

87: p_batch_date IN ar_batches.batch_date%TYPE,
88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,

Line 92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

88: p_currency_code IN ar_batches.currency_code%TYPE,
89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,

Line 93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

89: p_name IN OUT NOCOPY ar_batches.name%TYPE,
90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

Line 94: p_gl_date IN ar_batches.gl_date%TYPE,

90: p_comments IN ar_batches.comments%TYPE,
91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

Line 95: p_media_reference IN ar_batches.media_reference%TYPE,

91: p_exchange_date IN ar_batches.exchange_date%TYPE,
92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id

Line 96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,

92: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,

93: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id

Line 98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,

94: p_gl_date IN ar_batches.gl_date%TYPE,
95: p_media_reference IN ar_batches.media_reference%TYPE,
96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,

Line 100: IN ar_batches.remit_bank_acct_use_id%TYPE,

96: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,

Line 102: IN ar_batches.remittance_bank_branch_id%TYPE,

98: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,

Line 103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,

99: p_remittance_bank_account_id
100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,

Line 104: p_attribute_category IN ar_batches.attribute_category%TYPE,

100: IN ar_batches.remit_bank_acct_use_id%TYPE,
101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,

Line 105: p_attribute1 IN ar_batches.attribute1%TYPE,

101: p_remittance_bank_branch_id
102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,

Line 106: p_attribute2 IN ar_batches.attribute2%TYPE,

102: IN ar_batches.remittance_bank_branch_id%TYPE,
103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,

Line 107: p_attribute3 IN ar_batches.attribute3%TYPE,

103: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,

Line 108: p_attribute4 IN ar_batches.attribute4%TYPE,

104: p_attribute_category IN ar_batches.attribute_category%TYPE,
105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,

Line 109: p_attribute5 IN ar_batches.attribute5%TYPE,

105: p_attribute1 IN ar_batches.attribute1%TYPE,
106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,

Line 110: p_attribute6 IN ar_batches.attribute6%TYPE,

106: p_attribute2 IN ar_batches.attribute2%TYPE,
107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,

Line 111: p_attribute7 IN ar_batches.attribute7%TYPE,

107: p_attribute3 IN ar_batches.attribute3%TYPE,
108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,

Line 112: p_attribute8 IN ar_batches.attribute8%TYPE,

108: p_attribute4 IN ar_batches.attribute4%TYPE,
109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,

Line 113: p_attribute9 IN ar_batches.attribute9%TYPE,

109: p_attribute5 IN ar_batches.attribute5%TYPE,
110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,

Line 114: p_attribute10 IN ar_batches.attribute10%TYPE,

110: p_attribute6 IN ar_batches.attribute6%TYPE,
111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,

Line 115: p_attribute11 IN ar_batches.attribute11%TYPE,

111: p_attribute7 IN ar_batches.attribute7%TYPE,
112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,

Line 116: p_attribute12 IN ar_batches.attribute12%TYPE,

112: p_attribute8 IN ar_batches.attribute8%TYPE,
113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,
120: p_auto_creation IN VARCHAR2,

Line 117: p_attribute13 IN ar_batches.attribute13%TYPE,

113: p_attribute9 IN ar_batches.attribute9%TYPE,
114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,
120: p_auto_creation IN VARCHAR2,
121: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

Line 118: p_attribute14 IN ar_batches.attribute14%TYPE,

114: p_attribute10 IN ar_batches.attribute10%TYPE,
115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,
120: p_auto_creation IN VARCHAR2,
121: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
122: p_module_name IN VARCHAR2,

Line 119: p_attribute15 IN ar_batches.attribute15%TYPE,

115: p_attribute11 IN ar_batches.attribute11%TYPE,
116: p_attribute12 IN ar_batches.attribute12%TYPE,
117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,
120: p_auto_creation IN VARCHAR2,
121: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
122: p_module_name IN VARCHAR2,
123: p_module_version IN VARCHAR2 );

Line 121: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

117: p_attribute13 IN ar_batches.attribute13%TYPE,
118: p_attribute14 IN ar_batches.attribute14%TYPE,
119: p_attribute15 IN ar_batches.attribute15%TYPE,
120: p_auto_creation IN VARCHAR2,
121: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
122: p_module_name IN VARCHAR2,
123: p_module_version IN VARCHAR2 );
124: --
125: PROCEDURE delete_batch(

Line 126: p_batch_id IN ar_batches.batch_id%TYPE );

122: p_module_name IN VARCHAR2,
123: p_module_version IN VARCHAR2 );
124: --
125: PROCEDURE delete_batch(
126: p_batch_id IN ar_batches.batch_id%TYPE );
127: --
128:
129: /*Bug3030995*/
130: