DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_BATCHES dependencies on AR_BATCHES

Line 5: p_batch_date IN AR_BATCHES.batch_date%TYPE,

1: PACKAGE ARP_BR_REMIT_BATCHES AUTHID CURRENT_USER AS
2: /* $Header: ARBRRM1S.pls 120.2.12010000.2 2009/12/16 12:48:05 pbapna ship $*/
3:
4: PROCEDURE insert_remit(
5: p_batch_date IN AR_BATCHES.batch_date%TYPE,
6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 6: p_gl_date IN AR_BATCHES.gl_date%TYPE,

2: /* $Header: ARBRRM1S.pls 120.2.12010000.2 2009/12/16 12:48:05 pbapna ship $*/
3:
4: PROCEDURE insert_remit(
5: p_batch_date IN AR_BATCHES.batch_date%TYPE,
6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 7: p_currency_code IN AR_BATCHES.currency_code%TYPE,

3:
4: PROCEDURE insert_remit(
5: p_batch_date IN AR_BATCHES.batch_date%TYPE,
6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 8: p_comments IN AR_BATCHES.comments%TYPE,

4: PROCEDURE insert_remit(
5: p_batch_date IN AR_BATCHES.batch_date%TYPE,
6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

5: p_batch_date IN AR_BATCHES.batch_date%TYPE,
6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

6: p_gl_date IN AR_BATCHES.gl_date%TYPE,
7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

7: p_currency_code IN AR_BATCHES.currency_code%TYPE,
8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

8: p_comments IN AR_BATCHES.comments%TYPE,
9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

9: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

10: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

11: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

12: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

13: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

14: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

15: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 20: p_media_reference IN AR_BATCHES.media_reference%TYPE,

16: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

17: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

18: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

19: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

20: p_media_reference IN AR_BATCHES.media_reference%TYPE,
21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

21: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

22: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,

Line 27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

23: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,

Line 28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

24: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);

Line 29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

25: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
33:

Line 30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,

26: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
33:
34:

Line 31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,

27: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
33:
34:
35: PROCEDURE update_remit(

Line 32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);

28: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
29: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
30: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
31: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
32: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
33:
34:
35: PROCEDURE update_remit(
36: p_api_version IN NUMBER ,

Line 43: p_batch_id IN AR_BATCHES.batch_id%TYPE,

39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: x_return_status OUT NOCOPY VARCHAR2 ,
41: x_msg_count OUT NOCOPY NUMBER ,
42: x_msg_data OUT NOCOPY VARCHAR2 ,
43: p_batch_id IN AR_BATCHES.batch_id%TYPE,
44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

Line 44: p_status IN AR_BATCHES.status%TYPE,

40: x_return_status OUT NOCOPY VARCHAR2 ,
41: x_msg_count OUT NOCOPY NUMBER ,
42: x_msg_data OUT NOCOPY VARCHAR2 ,
43: p_batch_id IN AR_BATCHES.batch_id%TYPE,
44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,

Line 45: p_control_count IN AR_BATCHES.control_count%TYPE,

41: x_msg_count OUT NOCOPY NUMBER ,
42: x_msg_data OUT NOCOPY VARCHAR2 ,
43: p_batch_id IN AR_BATCHES.batch_id%TYPE,
44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 46: p_control_amount IN AR_BATCHES.control_amount%TYPE,

42: x_msg_data OUT NOCOPY VARCHAR2 ,
43: p_batch_id IN AR_BATCHES.batch_id%TYPE,
44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

Line 47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,

43: p_batch_id IN AR_BATCHES.batch_id%TYPE,
44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 48: p_comments IN AR_BATCHES.comments%TYPE,

44: p_status IN AR_BATCHES.status%TYPE,
45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 49: p_media_reference IN AR_BATCHES.media_reference%TYPE,

45: p_control_count IN AR_BATCHES.control_count%TYPE,
46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,

46: p_control_amount IN AR_BATCHES.control_amount%TYPE,
47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

47: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE,
48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);

Line 52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

48: p_comments IN AR_BATCHES.comments%TYPE,
49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
56:

Line 53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

49: p_media_reference IN AR_BATCHES.media_reference%TYPE,
50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
56:
57: PROCEDURE lock_remit (

Line 54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

50: p_operation_request_id IN AR_BATCHES.operation_request_id%TYPE,
51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
56:
57: PROCEDURE lock_remit (
58: p_api_version IN NUMBER ,

Line 55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);

51: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
52: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
53: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
54: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
55: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE);
56:
57: PROCEDURE lock_remit (
58: p_api_version IN NUMBER ,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

Line 66: p_batch_id IN AR_BATCHES.batch_id%TYPE,

62: x_return_status OUT NOCOPY VARCHAR2 ,
63: x_msg_count OUT NOCOPY NUMBER ,
64: x_msg_data OUT NOCOPY VARCHAR2 ,
65: p_rowid IN varchar2,
66: p_batch_id IN AR_BATCHES.batch_id%TYPE,
67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,

Line 67: p_batch_name IN AR_BATCHES.name%TYPE,

63: x_msg_count OUT NOCOPY NUMBER ,
64: x_msg_data OUT NOCOPY VARCHAR2 ,
65: p_rowid IN varchar2,
66: p_batch_id IN AR_BATCHES.batch_id%TYPE,
67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,

Line 68: p_status IN AR_BATCHES.status%TYPE,

64: x_msg_data OUT NOCOPY VARCHAR2 ,
65: p_rowid IN varchar2,
66: p_batch_id IN AR_BATCHES.batch_id%TYPE,
67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,

Line 69: p_batch_date IN AR_BATCHES.batch_date%TYPE,

65: p_rowid IN varchar2,
66: p_batch_id IN AR_BATCHES.batch_id%TYPE,
67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 70: p_gl_date IN AR_BATCHES.gl_date%TYPE,

66: p_batch_id IN AR_BATCHES.batch_id%TYPE,
67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 71: p_currency_code IN AR_BATCHES.currency_code%TYPE,

67: p_batch_name IN AR_BATCHES.name%TYPE,
68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 72: p_comments IN AR_BATCHES.comments%TYPE,

68: p_status IN AR_BATCHES.status%TYPE,
69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

69: p_batch_date IN AR_BATCHES.batch_date%TYPE,
70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

70: p_gl_date IN AR_BATCHES.gl_date%TYPE,
71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

71: p_currency_code IN AR_BATCHES.currency_code%TYPE,
72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

72: p_comments IN AR_BATCHES.comments%TYPE,
73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

73: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

74: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

75: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

76: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

77: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

78: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

79: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 84: p_media_reference IN AR_BATCHES.media_reference%TYPE,

80: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

81: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

82: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

83: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

84: p_media_reference IN AR_BATCHES.media_reference%TYPE,
85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

85: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

86: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);

Line 91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

87: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:

Line 92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

88: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:
96: PROCEDURE cancel_remit(

Line 93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

89: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:
96: PROCEDURE cancel_remit(
97: p_batch_id IN AR_BATCHES.batch_id%TYPE,

Line 94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);

90: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
91: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
92: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:
96: PROCEDURE cancel_remit(
97: p_batch_id IN AR_BATCHES.batch_id%TYPE,
98: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);

Line 97: p_batch_id IN AR_BATCHES.batch_id%TYPE,

93: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:
96: PROCEDURE cancel_remit(
97: p_batch_id IN AR_BATCHES.batch_id%TYPE,
98: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
99:
100: PROCEDURE update_br_remit_batch_to_crh(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
101: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE);

Line 98: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);

94: p_batch_applied_status IN AR_BATCHES.batch_applied_status%TYPE);
95:
96: PROCEDURE cancel_remit(
97: p_batch_id IN AR_BATCHES.batch_id%TYPE,
98: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
99:
100: PROCEDURE update_br_remit_batch_to_crh(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
101: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE);
102:

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

102:
103:
104:
105: PROCEDURE delete_remit(
106: p_batch_id IN ar_batches.batch_id%TYPE );
107:
108:
109:
110: FUNCTION revision RETURN VARCHAR2;