[Home] [Help]
PACKAGE: APPS.ARP_AUTOMATIC_CLEARING_PKG
Source
1 PACKAGE arp_automatic_clearing_pkg AS
2 /* $Header: ARRXACRS.pls 120.0.12010000.3 2008/11/18 18:04:58 aghoraka noship $ */
3 --
4 /*========================================================================+
5 | FUNCTION ar_auto_clearing_in_parallel |
6 | |
7 | DESCRIPTION |
8 | |
9 | This drives the parallelization of Automatic Clearance process. |
10 | This spawns the AUTOCLEAR( ar_automatic_clearing_parallel) program. |
11 | PSEUDO CODE/LOGIC |
12 | |
13 | PARAMETERS |
14 | |
15 | |
16 | KNOWN ISSUES |
17 | |
18 | NOTES |
19 | |
20 | |
21 | MODIFICATION HISTORY |
22 | Date Author Description of Changes |
23 | 19-FEB-2008 aghoraka Created |
24 *=========================================================================*/
25 function ar_auto_clearing_in_parallel
26 (
27 p_clr_remitted_receipts IN VARCHAR2,
28 p_clr_disc_receipts IN VARCHAR2,
29 p_eliminate_bank_risk IN VARCHAR2,
30 p_clear_date IN DATE,
31 p_gl_date IN DATE,
32 p_customer_name_low IN VARCHAR2,
33 p_customer_name_high IN VARCHAR2,
34 p_customer_number_low IN VARCHAR2,
35 p_customer_number_high IN VARCHAR2,
36 p_receipt_number_low IN VARCHAR2,
37 p_receipt_number_high IN VARCHAR2,
38 p_remittance_bank_account_id IN NUMBER,
39 p_payment_method_id IN NUMBER,
40 p_exchange_rate_type IN VARCHAR2,
41 p_batch_id IN NUMBER,
42 p_undo_clearing IN VARCHAR2,
43 P_total_workers IN NUMBER)
44 RETURN BOOLEAN;
45 --
46 procedure ar_automatic_clearing_parallel
47 ( P_ERRBUF OUT NOCOPY VARCHAR2,
48 P_RETCODE OUT NOCOPY NUMBER,
49 p_clr_remitted_receipts IN VARCHAR2,
50 p_clr_disc_receipts IN VARCHAR2,
51 p_eliminate_bank_risk IN VARCHAR2,
52 p_worker_number IN NUMBER DEFAULT 0,
53 p_request_id IN NUMBER DEFAULT 0);
54 --
55 function ar_automatic_clearing
56 (
57 p_clr_remitted_receipts IN VARCHAR2,
58 p_clr_disc_receipts IN VARCHAR2,
59 p_eliminate_bank_risk IN VARCHAR2,
60 p_clear_date IN DATE,
61 p_gl_date IN DATE,
62 p_customer_name_low IN VARCHAR2,
63 p_customer_name_high IN VARCHAR2,
64 p_customer_number_low IN VARCHAR2,
65 p_customer_number_high IN VARCHAR2,
66 p_receipt_number_low IN VARCHAR2,
67 p_receipt_number_high IN VARCHAR2,
68 p_remittance_bank_account_id IN NUMBER,
69 p_payment_method_id IN NUMBER,
70 p_exchange_rate_type IN VARCHAR2,
71 p_batch_id IN NUMBER,
72 p_undo_clearing IN VARCHAR2)
73 RETURN BOOLEAN;
74
75 --
76 END arp_automatic_clearing_pkg;