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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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:
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(
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 ,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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 (
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 ,
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 ,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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(
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,
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);
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);
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:
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;