1 Package AR_AUTOREM_API AS
2 /* $Header: ARATREMS.pls 120.1.12010000.3 2008/11/19 18:00:13 aghoraka ship $ */
3
4 /*========================================================================+
5 | PUBLIC PROCEDURE GET_PARAMETERS |
6 | |
7 | DESCRIPTION |
8 | |
9 | This procedure is used to get the parameters from the Conc program |
10 | and convert them to the type reqd for processing. |
11 | |
12 | PSEUDO CODE/LOGIC |
13 | |
14 | PARAMETERS |
15 | |
16 | |
17 | KNOWN ISSUES |
18 | |
19 | NOTES |
20 | |
21 | |
22 | MODIFICATION HISTORY |
23 | Date Author Description of Changes |
24 | 16-JUL-2005 bichatte Created |
25 *=========================================================================*/
26
27
28
29 PROCEDURE get_parameters(
30 P_ERRBUF OUT NOCOPY VARCHAR2,
31 P_RETCODE OUT NOCOPY NUMBER,
32 p_process_type IN VARCHAR2,
33 p_batch_date IN VARCHAR2,
34 p_batch_gl_date IN VARCHAR2,
35 p_create_flag IN VARCHAR2,
36 p_approve_flag IN VARCHAR2,
37 p_format_flag IN VARCHAR2,
38 p_batch_id IN VARCHAR2,
39 p_debug_mode_on IN VARCHAR2,
40 p_batch_currency IN VARCHAR2,
41 p_exchange_date IN VARCHAR2,
42 p_exchange_rate IN VARCHAR2,
43 p_exchange_rate_type IN VARCHAR2,
44 p_remit_method_code IN VARCHAR2,
45 p_receipt_class_id IN VARCHAR2,
46 p_payment_method_id IN VARCHAR2,
47 p_media_reference IN VARCHAR2,
48 p_remit_bank_branch_id IN VARCHAR2,
49 p_remit_bank_account_id IN VARCHAR2,
50 p_remit_bank_deposit_number IN VARCHAR2,
51 p_comments IN VARCHAR2,
52 p_trx_date_l IN VARCHAR2,
53 p_trx_date_h IN VARCHAR2,
54 p_due_date_l IN VARCHAR2,
55 p_due_date_h IN VARCHAR2,
56 p_trx_num_l IN VARCHAR2,
57 p_trx_num_h IN VARCHAR2,
58 p_doc_num_l IN VARCHAR2,
59 p_doc_num_h IN VARCHAR2,
60 p_customer_number_l IN VARCHAR2,
61 p_customer_number_h IN VARCHAR2,
62 p_customer_name_l IN VARCHAR2,
63 p_customer_name_h IN VARCHAR2,
64 p_customer_id IN VARCHAR2,
65 p_site_l IN VARCHAR2,
66 p_site_h IN VARCHAR2,
67 p_site_id IN VARCHAR2,
68 p_remittance_total_from IN VARCHAR2,
69 p_Remittance_total_to IN VARCHAR2,
70 p_billing_number_l IN VARCHAR2,
71 p_billing_number_h IN VARCHAR2,
72 p_customer_bank_acc_num_l IN VARCHAR2,
73 p_customer_bank_acc_num_h IN VARCHAR2,
74 /* Changes for Parallelization */
75 p_worker_number IN NUMBER DEFAULT 0,
76 p_total_workers IN NUMBER DEFAULT 0
77 );
78 /*========================================================================+
79 | PROCEDURE submit_autorem_parallel |
80 | |
81 | DESCRIPTION |
82 | |
83 | Wraper to parallelize the Automatic Remittances creation program |
84 | PSEUDO CODE/LOGIC |
85 | |
86 | PARAMETERS |
87 | |
88 | |
89 | KNOWN ISSUES |
90 | |
91 | NOTES |
92 | |
93 | |
94 | MODIFICATION HISTORY |
95 | Date Author Description of Changes |
96 | 30-NOV-2007 aghoraka Created |
97 *=========================================================================*/
98 PROCEDURE submit_autorem_parallel(
99 P_ERRBUF OUT NOCOPY VARCHAR2,
100 P_RETCODE OUT NOCOPY NUMBER,
101 p_process_type IN VARCHAR2,
102 p_batch_date IN VARCHAR2,
103 p_batch_gl_date IN VARCHAR2,
104 p_create_flag IN VARCHAR2,
105 p_approve_flag IN VARCHAR2,
106 p_format_flag IN VARCHAR2,
107 p_batch_id IN VARCHAR2,
108 p_debug_mode_on IN VARCHAR2,
109 p_batch_currency IN VARCHAR2,
110 p_exchange_date IN VARCHAR2,
111 p_exchange_rate IN VARCHAR2,
112 p_exchange_rate_type IN VARCHAR2,
113 p_remit_method_code IN VARCHAR2,
114 p_receipt_class_id IN VARCHAR2,
115 p_payment_method_id IN VARCHAR2,
116 p_media_reference IN VARCHAR2,
117 p_remit_bank_branch_id IN VARCHAR2,
118 p_remit_bank_account_id IN VARCHAR2,
119 p_remit_bank_deposit_number IN VARCHAR2,
120 p_comments IN VARCHAR2,
121 p_trx_date_l IN VARCHAR2,
122 p_trx_date_h IN VARCHAR2,
123 p_due_date_l IN VARCHAR2,
124 p_due_date_h IN VARCHAR2,
125 p_trx_num_l IN VARCHAR2,
126 p_trx_num_h IN VARCHAR2,
127 p_doc_num_l IN VARCHAR2,
128 p_doc_num_h IN VARCHAR2,
129 p_customer_number_l IN VARCHAR2,
130 p_customer_number_h IN VARCHAR2,
131 p_customer_name_l IN VARCHAR2,
132 p_customer_name_h IN VARCHAR2,
133 p_customer_id IN VARCHAR2,
134 p_site_l IN VARCHAR2,
135 p_site_h IN VARCHAR2,
136 p_site_id IN VARCHAR2,
137 p_remittance_total_from IN VARCHAR2,
138 p_Remittance_total_to IN VARCHAR2,
139 p_billing_number_l IN VARCHAR2,
140 p_billing_number_h IN VARCHAR2,
141 p_customer_bank_acc_num_l IN VARCHAR2,
142 p_customer_bank_acc_num_h IN VARCHAR2,
143 p_total_workers IN NUMBER default 1 );
144
145 /*========================================================================+
146 | PROCEDURE insert_batch |
147 | |
148 | DESCRIPTION |
149 | |
150 | This procedure is used to insert the batch record when called from |
151 | srs. It also gets the other required parameters from sysparm |
152 | and conc program |
153 | PSEUDO CODE/LOGIC |
154 | |
155 | PARAMETERS |
156 | |
157 | |
158 | KNOWN ISSUES |
159 | |
160 | NOTES |
161 | |
162 | |
163 | MODIFICATION HISTORY |
164 | Date Author Description of Changes |
165 | 16-JUL-2005 bichatte Created |
166 *=========================================================================*/
167
168
169 PROCEDURE insert_batch(
170 p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
171 p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
172 p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173 p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
174 p_currency_code IN ar_batches.currency_code%TYPE,
175 p_remmitance_method IN ar_batches.remit_method_code%TYPE,
176 p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
177 p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
178 p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
179 p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
180 p_batch_id OUT NOCOPY NUMBER
181 );
182
183 /*========================================================================+
184 | PROCEDURE create_and_update_remit_rec |
185 | |
186 | DESCRIPTION |
187 | |
188 | This procedure is used to select receipts to be remitted |
189 | update and insert records into the necessary tables. |
190 | PSEUDO CODE/LOGIC |
191 | |
192 | PARAMETERS |
193 | |
194 | |
195 | KNOWN ISSUES |
196 | |
197 | NOTES |
198 | |
199 | |
200 | MODIFICATION HISTORY |
201 | Date Author Description of Changes |
202 | 16-JUL-2005 bichatte Created |
203 *=========================================================================*/
204
205
206
207 PROCEDURE create_and_update_remit_rec(
208 p_batch_id IN NUMBER,
209 p_return_status OUT NOCOPY VARCHAR2
210 );
211 /*========================================================================+
212 | PROCEDURE create_and_update_remit_rec_pa |
213 | |
214 | DESCRIPTION |
215 | |
216 | This procedure is used to select receipts to be remitted |
217 | update and insert records into the necessary tables. |
218 | This procedure is called when the request is submitted through |
219 | 'Automatic Remittances Master program'. |
220 | PSEUDO CODE/LOGIC |
221 | |
222 | PARAMETERS |
223 | |
224 | |
225 | KNOWN ISSUES |
226 | |
227 | NOTES |
228 | |
229 | |
230 | MODIFICATION HISTORY |
231 | Date Author Description of Changes |
232 | 28-MAY-2008 AGHORAKA Created |
233 *=========================================================================*/
234
235
236
237 PROCEDURE create_and_update_remit_rec_pa(
238 p_batch_id IN NUMBER,
239 p_return_status OUT NOCOPY VARCHAR2
240 );
241 /*========================================================================+
242 | PROCEDURE select_and_update_rec |
243 | |
244 | DESCRIPTION |
245 | |
246 | This procedure is used to select receipts to be remitted |
247 | update and insert records into the necessary tables. |
248 | PSEUDO CODE/LOGIC |
249 | |
250 | PARAMETERS |
251 | |
252 | |
253 | KNOWN ISSUES |
254 | |
255 | NOTES |
256 | |
257 | |
258 | MODIFICATION HISTORY |
259 | Date Author Description of Changes |
260 | 16-JUL-2005 bichatte Created |
261 *=========================================================================*/
262
263 PROCEDURE select_update_rec(
264 p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
265 p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
266 p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267 p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
268 p_due_date_l IN ar_payment_schedules.due_date%TYPE,
269 p_due_date_h IN ar_payment_schedules.due_date%TYPE,
270 p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
271 p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
272 p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
273 p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
274 p_batch_id IN ar_batches.batch_id%TYPE,
275 p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
276 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
277 p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
278 p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
279 p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
280 p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
281 p_return_status OUT NOCOPY VARCHAR2
282 );
283
284
285 /*========================================================================+
286 | PROCEDURE process_pay_receipt |
287 | |
288 | DESCRIPTION |
289 | |
290 | This procedure is used to select receipts to be remitted |
291 | update and insert records into the necessary tables. |
292 | PSEUDO CODE/LOGIC |
293 | |
294 | PARAMETERS |
295 | |
296 | |
297 | KNOWN ISSUES |
298 | |
299 | NOTES |
300 | |
301 | |
302 | MODIFICATION HISTORY |
303 | Date Author Description of Changes |
304 | 16-JUL-2005 bichatte Created |
305 *=========================================================================*/
306
307 PROCEDURE process_pay_receipt(
308 p_batch_id IN NUMBER,
309 p_called_from IN VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2
313 );
314 /*========================================================================+
315 | PROCEDURE process_pay_receipt_parallel |
316 | |
317 | DESCRIPTION |
318 | |
319 | This procedure is used to select receipts to be remitted |
320 | update and insert records into the necessary tables. |
321 | This procedure is called when the request is submitted through |
322 | 'Automatic Remittances Master program'. |
323 | PSEUDO CODE/LOGIC |
324 | |
325 | PARAMETERS |
326 | |
327 | |
328 | KNOWN ISSUES |
329 | |
330 | NOTES |
331 | |
332 | |
333 | MODIFICATION HISTORY |
334 | Date Author Description of Changes |
335 | 28-MAY-2008 AGHORAKA Created |
336 *=========================================================================*/
337
338 PROCEDURE process_pay_receipt_parallel(
339 p_batch_id IN NUMBER,
340 p_called_from IN VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2,
343 x_return_status OUT NOCOPY VARCHAR2
344 );
345
346 /*========================================================================+
347 | PROCEDURE insert_exceptions |
348 | |
349 | DESCRIPTION |
350 | |
351 | This procedure is used to insert the exception record when |
352 | |
353 | PSEUDO CODE/LOGIC |
354 | |
355 | PARAMETERS |
356 | |
357 | |
358 | KNOWN ISSUES |
359 | |
360 | NOTES |
361 | |
362 | |
363 | MODIFICATION HISTORY |
364 | Date Author Description of Changes |
365 | 16-JUL-2005 bichatte Created |
366 *=========================================================================*/
367 PROCEDURE insert_exceptions(
368 p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
369 p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
370 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
371 p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
372 p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
373 p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
374 p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
375 p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
376 p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
377 p_exception_code IN VARCHAR2,
378 p_additional_message IN VARCHAR2
379 );
380
381 /*========================================================================+
382 | PUBLIC PROCEDURE SUBMIT_REPORT |
383 | |
384 | DESCRIPTION |
385 | |
386 | This procedure is used to get the parameters from the Conc program |
387 | and convert them to the type reqd for processing. |
388 | |
389 | PSEUDO CODE/LOGIC |
390 | |
391 | PARAMETERS |
392 | |
393 | |
394 | KNOWN ISSUES |
395 | |
396 | NOTES |
397 | |
398 | |
399 | MODIFICATION HISTORY |
400 | Date Author Description of Changes |
401 | 16-JUL-2005 bichatte Created |
402 *=========================================================================*/
403
404 PROCEDURE SUBMIT_REPORT (
405 p_batch_id ar_batches.batch_id%TYPE,
406 p_request_id ar_cash_receipts.request_id%TYPE
407 );
408
409
410 PROCEDURE rec_reset ( p_request_id NUMBER
411 );
412
413
414
415
416
417
418
419 END AR_AUTOREM_API;
|
|
|