4 /*========================================================================+
1 Package AR_AUTOREM_API AUTHID CURRENT_USER AS
2 /* $Header: ARATREMS.pls 120.8 2012/05/18 10:09:48 kgnanase ship $ */
3
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_remit_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE DEFAULT NULL, --bug12924584
181 p_batch_id OUT NOCOPY NUMBER
182 );
183
184 /*========================================================================+
185 | PROCEDURE create_and_update_remit_rec |
186 | |
187 | DESCRIPTION |
188 | |
189 | This procedure is used to select receipts to be remitted |
190 | update and insert records into the necessary tables. |
191 | PSEUDO CODE/LOGIC |
192 | |
193 | PARAMETERS |
194 | |
195 | |
196 | KNOWN ISSUES |
197 | |
198 | NOTES |
199 | |
200 | |
201 | MODIFICATION HISTORY |
202 | Date Author Description of Changes |
203 | 16-JUL-2005 bichatte Created |
204 *=========================================================================*/
205
206
207
208 PROCEDURE create_and_update_remit_rec(
212 /*========================================================================+
209 p_batch_id IN NUMBER,
210 p_return_status OUT NOCOPY VARCHAR2
211 );
213 | PROCEDURE create_and_update_remit_rec_pa |
214 | |
215 | DESCRIPTION |
216 | |
217 | This procedure is used to select receipts to be remitted |
218 | update and insert records into the necessary tables. |
219 | This procedure is called when the request is submitted through |
220 | 'Automatic Remittances Master program'. |
221 | PSEUDO CODE/LOGIC |
222 | |
223 | PARAMETERS |
224 | |
225 | |
226 | KNOWN ISSUES |
227 | |
228 | NOTES |
229 | |
230 | |
231 | MODIFICATION HISTORY |
232 | Date Author Description of Changes |
233 | 28-MAY-2008 AGHORAKA Created |
234 *=========================================================================*/
235
236
237
238 PROCEDURE create_and_update_remit_rec_pa(
239 p_batch_id IN NUMBER,
240 p_return_status OUT NOCOPY VARCHAR2
241 );
242 /*========================================================================+
243 | PROCEDURE select_and_update_rec |
244 | |
245 | DESCRIPTION |
246 | |
247 | This procedure is used to select receipts to be remitted |
248 | update and insert records into the necessary tables. |
249 | PSEUDO CODE/LOGIC |
250 | |
251 | PARAMETERS |
252 | |
253 | |
254 | KNOWN ISSUES |
255 | |
256 | NOTES |
257 | |
258 | |
259 | MODIFICATION HISTORY |
260 | Date Author Description of Changes |
261 | 16-JUL-2005 bichatte Created |
262 *=========================================================================*/
263
264 PROCEDURE select_update_rec(
265 p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
266 p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
267 p_customer_name_l IN hz_parties.party_name%type,
268 p_customer_name_h IN hz_parties.party_name%type,
269 p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
270 p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
271 p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
272 p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
273 p_due_date_l IN ar_payment_schedules.due_date%TYPE,
274 p_due_date_h IN ar_payment_schedules.due_date%TYPE,
275 p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
276 p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
277 p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
278 p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
279 p_batch_id IN ar_batches.batch_id%TYPE,
280 p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
281 p_currency_code IN ar_cash_receipts.currency_code%TYPE,
282 p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
283 p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
284 p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
285 p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
286 p_return_status OUT NOCOPY VARCHAR2
287 );
288
289
293 | DESCRIPTION |
290 /*========================================================================+
291 | PROCEDURE process_pay_receipt |
292 | |
294 | |
295 | This procedure is used to select receipts to be remitted |
296 | update and insert records into the necessary tables. |
297 | PSEUDO CODE/LOGIC |
298 | |
299 | PARAMETERS |
300 | |
301 | |
302 | KNOWN ISSUES |
303 | |
304 | NOTES |
305 | |
306 | |
307 | MODIFICATION HISTORY |
308 | Date Author Description of Changes |
309 | 16-JUL-2005 bichatte Created |
310 *=========================================================================*/
311
312 PROCEDURE process_pay_receipt(
313 p_batch_id IN NUMBER,
314 p_called_from IN VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 x_return_status OUT NOCOPY VARCHAR2
318 );
319 /*========================================================================+
320 | PROCEDURE process_pay_receipt_parallel |
321 | |
322 | DESCRIPTION |
323 | |
324 | This procedure is used to select receipts to be remitted |
325 | update and insert records into the necessary tables. |
326 | This procedure is called when the request is submitted through |
327 | 'Automatic Remittances Master program'. |
328 | PSEUDO CODE/LOGIC |
329 | |
330 | PARAMETERS |
331 | |
332 | |
333 | KNOWN ISSUES |
334 | |
335 | NOTES |
336 | |
337 | |
338 | MODIFICATION HISTORY |
339 | Date Author Description of Changes |
340 | 28-MAY-2008 AGHORAKA Created |
341 *=========================================================================*/
342
343 PROCEDURE process_pay_receipt_parallel(
344 p_batch_id IN NUMBER,
345 p_called_from IN VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 x_return_status OUT NOCOPY VARCHAR2
349 );
350
351 /*========================================================================+
352 | PROCEDURE insert_exceptions |
353 | |
354 | DESCRIPTION |
355 | |
356 | This procedure is used to insert the exception record when |
357 | |
358 | PSEUDO CODE/LOGIC |
359 | |
360 | PARAMETERS |
361 | |
362 | |
363 | KNOWN ISSUES |
364 | |
365 | NOTES |
366 | |
367 | |
368 | MODIFICATION HISTORY |
369 | Date Author Description of Changes |
370 | 16-JUL-2005 bichatte Created |
371 *=========================================================================*/
372 PROCEDURE insert_exceptions(
373 p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
374 p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
375 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
379 p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
376 p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
377 p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
378 p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
380 p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
381 p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
382 p_exception_code IN VARCHAR2,
383 p_additional_message IN VARCHAR2
384 );
385
386 /*========================================================================+
387 | PUBLIC PROCEDURE SUBMIT_REPORT |
388 | |
389 | DESCRIPTION |
390 | |
391 | This procedure is used to get the parameters from the Conc program |
392 | and convert them to the type reqd for processing. |
393 | |
394 | PSEUDO CODE/LOGIC |
395 | |
396 | PARAMETERS |
397 | |
398 | |
399 | KNOWN ISSUES |
400 | |
401 | NOTES |
402 | |
403 | |
404 | MODIFICATION HISTORY |
405 | Date Author Description of Changes |
406 | 16-JUL-2005 bichatte Created |
407 *=========================================================================*/
408
409 PROCEDURE SUBMIT_REPORT (
410 p_batch_id ar_batches.batch_id%TYPE,
411 p_request_id ar_cash_receipts.request_id%TYPE
412 );
413
414
415 PROCEDURE rec_reset ( p_request_id NUMBER
416 );
417
418
419
420
421
422
423
424 END AR_AUTOREM_API;
|
|
|