1 PACKAGE ARP_RW_BATCHES_CHECK_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARERBA1S.pls 120.5 2010/02/22 07:35:47 aghoraka ship $ */
3 PROCEDURE update_manual_batch(
4 p_row_id IN VARCHAR2,
5 p_batch_id IN ar_batches.batch_id%TYPE,
6 p_batch_source_id IN ar_batches.batch_source_id%TYPE,
7 p_batch_date IN ar_batches.batch_date%TYPE,
8 p_gl_date IN ar_batches.gl_date%TYPE,
9 p_deposit_date IN ar_batches.batch_date%TYPE,
10 p_currency_code IN ar_batches.currency_code%TYPE,
11 p_comments IN ar_batches.comments%TYPE,
12 p_control_amount IN ar_batches.control_amount%TYPE,
13 p_control_count IN ar_batches.control_count%TYPE,
14 p_exchange_date IN ar_batches.exchange_date%TYPE,
15 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
16 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
17 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
18 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
19 p_remittance_bank_account_id
20 IN ar_batches.remit_bank_acct_use_id%TYPE,
21 p_remittance_bank_branch_id
22 IN ar_batches.remittance_bank_branch_id%TYPE,
26 p_attribute3 IN ar_batches.attribute3%TYPE,
23 p_attribute_category IN ar_batches.attribute_category%TYPE,
24 p_attribute1 IN ar_batches.attribute1%TYPE,
25 p_attribute2 IN ar_batches.attribute2%TYPE,
27 p_attribute4 IN ar_batches.attribute4%TYPE,
28 p_attribute5 IN ar_batches.attribute5%TYPE,
29 p_attribute6 IN ar_batches.attribute6%TYPE,
30 p_attribute7 IN ar_batches.attribute7%TYPE,
31 p_attribute8 IN ar_batches.attribute8%TYPE,
32 p_attribute9 IN ar_batches.attribute9%TYPE,
33 p_attribute10 IN ar_batches.attribute10%TYPE,
34 p_attribute11 IN ar_batches.attribute11%TYPE,
35 p_attribute12 IN ar_batches.attribute12%TYPE,
36 p_attribute13 IN ar_batches.attribute13%TYPE,
37 p_attribute14 IN ar_batches.attribute14%TYPE,
38 p_attribute15 IN ar_batches.attribute15%TYPE,
39 p_module_name IN VARCHAR2,
40 p_module_version IN VARCHAR2 );
41
42 PROCEDURE update_remit_batch(
43 p_row_id IN VARCHAR2,
44 p_batch_id IN ar_batches.batch_id%TYPE,
45 p_batch_source_id IN ar_batches.batch_source_id%TYPE,
46 p_batch_date IN ar_batches.batch_date%TYPE,
47 p_gl_date IN ar_batches.gl_date%TYPE,
48 p_deposit_date IN ar_batches.batch_date%TYPE,
49 p_currency_code IN ar_batches.currency_code%TYPE,
50 p_comments IN ar_batches.comments%TYPE,
51 p_control_amount IN ar_batches.control_amount%TYPE,
52 p_control_count IN ar_batches.control_count%TYPE,
53 p_exchange_date IN ar_batches.exchange_date%TYPE,
54 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
57 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
58 p_remittance_bank_account_id
59 IN ar_batches.remit_bank_acct_use_id%TYPE,
60 p_remittance_bank_branch_id
61 IN ar_batches.remittance_bank_branch_id%TYPE,
62 p_media_reference IN ar_batches.media_reference%TYPE,
63 p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
64 p_request_id IN ar_batches.request_id%TYPE,
65 p_operation_request_id IN ar_batches.operation_request_id%TYPE,
66 p_attribute_category IN ar_batches.attribute_category%TYPE,
67 p_attribute1 IN ar_batches.attribute1%TYPE,
68 p_attribute2 IN ar_batches.attribute2%TYPE,
69 p_attribute3 IN ar_batches.attribute3%TYPE,
70 p_attribute4 IN ar_batches.attribute4%TYPE,
71 p_attribute5 IN ar_batches.attribute5%TYPE,
72 p_attribute6 IN ar_batches.attribute6%TYPE,
73 p_attribute7 IN ar_batches.attribute7%TYPE,
74 p_attribute8 IN ar_batches.attribute8%TYPE,
75 p_attribute9 IN ar_batches.attribute9%TYPE,
76 p_attribute10 IN ar_batches.attribute10%TYPE,
77 p_attribute11 IN ar_batches.attribute11%TYPE,
78 p_attribute12 IN ar_batches.attribute12%TYPE,
79 p_attribute13 IN ar_batches.attribute13%TYPE,
80 p_attribute14 IN ar_batches.attribute14%TYPE,
81 p_attribute15 IN ar_batches.attribute15%TYPE,
82 p_module_name IN VARCHAR2,
83 p_module_version IN VARCHAR2 );
84
85 PROCEDURE update_auto_batch(
86 p_row_id IN VARCHAR2,
87 p_batch_id IN ar_batches.batch_id%TYPE,
88 p_batch_source_id IN ar_batches.batch_source_id%TYPE,
89 p_batch_date IN ar_batches.batch_date%TYPE,
90 p_gl_date IN ar_batches.gl_date%TYPE,
91 p_deposit_date IN ar_batches.batch_date%TYPE,
92 p_currency_code IN ar_batches.currency_code%TYPE,
93 p_comments IN ar_batches.comments%TYPE,
94 p_control_amount IN ar_batches.control_amount%TYPE,
95 p_control_count IN ar_batches.control_count%TYPE,
96 p_exchange_date IN ar_batches.exchange_date%TYPE,
97 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
98 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
99 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
100 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
101 p_remittance_bank_account_id
102 IN ar_batches.remit_bank_acct_use_id%TYPE,
103 p_remittance_bank_branch_id
104 IN ar_batches.remittance_bank_branch_id%TYPE,
105 p_media_reference IN ar_batches.media_reference%TYPE,
106 p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
107 p_request_id IN ar_batches.request_id%TYPE,
108 p_operation_request_id IN ar_batches.operation_request_id%TYPE,
109 p_attribute_category IN ar_batches.attribute_category%TYPE,
110 p_attribute1 IN ar_batches.attribute1%TYPE,
111 p_attribute2 IN ar_batches.attribute2%TYPE,
112 p_attribute3 IN ar_batches.attribute3%TYPE,
113 p_attribute4 IN ar_batches.attribute4%TYPE,
114 p_attribute5 IN ar_batches.attribute5%TYPE,
115 p_attribute6 IN ar_batches.attribute6%TYPE,
116 p_attribute7 IN ar_batches.attribute7%TYPE,
117 p_attribute8 IN ar_batches.attribute8%TYPE,
118 p_attribute9 IN ar_batches.attribute9%TYPE,
119 p_attribute10 IN ar_batches.attribute10%TYPE,
120 p_attribute11 IN ar_batches.attribute11%TYPE,
121 p_attribute12 IN ar_batches.attribute12%TYPE,
122 p_attribute13 IN ar_batches.attribute13%TYPE,
123 p_attribute14 IN ar_batches.attribute14%TYPE,
124 p_attribute15 IN ar_batches.attribute15%TYPE,
125 p_module_name IN VARCHAR2,
126 p_module_version IN VARCHAR2 );
127 --
128 --Bug7194951
129 PROCEDURE update_batch_status( p_batch_id IN ar_batches.batch_id%TYPE,
130 p_called_from IN VARCHAR2 DEFAULT NULL );
131
132 --
133 PROCEDURE check_unique_batch_name(
134 p_row_id IN VARCHAR2,
135 p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
136 p_batch_name IN ar_batches.name%TYPE,
137 p_module_name IN VARCHAR2,
138 p_module_version IN VARCHAR2 );
139 --
140 PROCEDURE check_unique_batch_name(
141 p_row_id IN VARCHAR2,
142 p_batch_source_name IN ar_batch_sources.name%TYPE,
143 p_batch_name IN ar_batches.name%TYPE,
144 p_module_name IN VARCHAR2,
145 p_module_version IN VARCHAR2 );
146 --
147 PROCEDURE check_unique_media_ref(
148 p_row_id IN VARCHAR2,
149 p_media_ref IN ar_batches.media_reference%TYPE,
150 p_module_name IN VARCHAR2,
151 p_module_version IN VARCHAR2 );
152 --
153 /* Added p_app_unearn_disc for ER 9288902 */
154 PROCEDURE post_batch_conc_req( p_batch_id IN ar_batches.batch_id%TYPE,
155 p_set_of_books_id IN
156 ar_batches.set_of_books_id%TYPE,
157 p_transmission_id IN
158 ar_batches.transmission_id%TYPE,
159 p_app_unearn_disc IN
160 VARCHAR2 DEFAULT 'N',
161 p_batch_applied_status OUT NOCOPY
162 ar_batches.batch_applied_status%TYPE,
163 p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
164 p_module_name IN VARCHAR2,
165 p_module_version IN VARCHAR2 );
166 --
167 PROCEDURE get_quick_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
168 p_actual_amount_total OUT NOCOPY NUMBER,
169 p_actual_count_total OUT NOCOPY NUMBER,
170 p_unidentified_amount_total OUT NOCOPY NUMBER,
171 p_unidentified_count_total OUT NOCOPY NUMBER,
172 p_on_account_amount_total OUT NOCOPY NUMBER,
173 p_on_account_count_total OUT NOCOPY NUMBER,
174 p_unapplied_amount_total OUT NOCOPY NUMBER,
175 p_unapplied_count_total OUT NOCOPY NUMBER,
176 p_applied_amount_total OUT NOCOPY NUMBER,
177 p_applied_count_total OUT NOCOPY NUMBER,
178 p_claim_amount_total OUT NOCOPY NUMBER,
179 p_claim_count_total OUT NOCOPY NUMBER,
180 p_module_name IN VARCHAR2,
181 p_module_version IN VARCHAR2 );
182 --
183 PROCEDURE get_reg_amount_totals( p_batch_id IN ar_batches.batch_id%TYPE,
184 p_actual_amount_total OUT NOCOPY NUMBER,
185 p_actual_count_total OUT NOCOPY NUMBER,
186 p_unidentified_amount_total OUT NOCOPY NUMBER,
187 p_unidentified_count_total OUT NOCOPY NUMBER,
188 p_on_account_amount_total OUT NOCOPY NUMBER,
189 p_on_account_count_total OUT NOCOPY NUMBER,
190 p_returned_amount_total OUT NOCOPY NUMBER,
191 p_returned_count_total OUT NOCOPY NUMBER,
192 p_reversed_amount_total OUT NOCOPY NUMBER,
193 p_reversed_count_total OUT NOCOPY NUMBER,
194 p_unapplied_amount_total OUT NOCOPY NUMBER,
195 p_unapplied_count_total OUT NOCOPY NUMBER,
196 p_applied_amount_total OUT NOCOPY NUMBER,
197 p_applied_count_total OUT NOCOPY NUMBER,
198 p_claim_amount_total OUT NOCOPY NUMBER,
199 p_claim_count_total OUT NOCOPY NUMBER,
200 p_prepayment_amount_total OUT NOCOPY NUMBER,
201 p_prepayment_count_total OUT NOCOPY NUMBER,
202 p_misc_amount_total OUT NOCOPY NUMBER,
203 p_misc_count_total OUT NOCOPY NUMBER,
204 p_module_name IN VARCHAR2,
205 p_module_version IN VARCHAR2 );
206
207 END ARP_RW_BATCHES_CHECK_PKG;