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,
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,
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,
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 ,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
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,
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
57 PROCEDURE lock_remit (
58 p_api_version IN NUMBER ,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
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,
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,
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,
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
103
104
105 PROCEDURE delete_remit(
106 p_batch_id IN ar_batches.batch_id%TYPE );
107
108
109
110 FUNCTION revision RETURN VARCHAR2;
111
112
113 END ARP_BR_REMIT_BATCHES;
114 --