[Home] [Help]
PACKAGE: APPS.CE_AUTO_BANK_CLEAR
Source
1 PACKAGE CE_AUTO_BANK_CLEAR AS
2 /* $Header: ceabrcrs.pls 120.5 2008/01/23 13:19:24 kbabu ship $ */
3 --
4 -- Global variables
5 --
6 G_exchange_date CE_STATEMENT_LINES.exchange_rate_date%TYPE;
7 G_exchange_rate_type CE_STATEMENT_LINES.exchange_rate_type%TYPE;
8 G_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;
9 G_spec_revision VARCHAR2(1000) := '$Revision: 120.5 $';
10
11 --
12 -- Variables required for determine manual clearing
13 --
14 yes_manual_clearing NUMBER DEFAULT 0;
15 yes_reverse_mode NUMBER DEFAULT 0;
16
17 --
18 -- Passed as parameters
19 --
20
21 G_org_id NUMBER;
22 G_legal_entity_id NUMBER;
23
24 --
25 -- Functions/Procedures required form SQL functions
26 --
27 FUNCTION spec_revision RETURN VARCHAR2;
28 FUNCTION body_revision RETURN VARCHAR2;
29 PROCEDURE set_manual_clearing;
30 PROCEDURE unset_manual_clearing;
31 PROCEDURE set_reverse_mode;
32 PROCEDURE unset_reverse_mode;
33
34 FUNCTION get_manual_clearing RETURN NUMBER;
35 PRAGMA RESTRICT_REFERENCES( get_manual_clearing, WNDS, WNPS );
36 FUNCTION get_reverse_mode RETURN NUMBER;
37 PRAGMA RESTRICT_REFERENCES( get_reverse_mode, WNDS, WNPS );
38
39 PROCEDURE reconcile_process;
40 PROCEDURE update_line_status(X_statement_line_id NUMBER,
41 X_status VARCHAR2);
42
43 FUNCTION calculate_clearing_amounts RETURN BOOLEAN;
44
45 FUNCTION trx_remain(
46 stmt_ln_list VARCHAR2,
47 trx_id_list VARCHAR2) RETURN NUMBER;
48
49 PROCEDURE reconcile_stmt(passin_mode VARCHAR2,
50 tx_type VARCHAR2,
51 trx_id NUMBER,
52 trx_status VARCHAR2,
53 receipt_type VARCHAR2,
54 exchange_rate_type VARCHAR2,
55 exchange_date DATE,
56 exchange_rate NUMBER,
57 amount_cleared NUMBER,
58 charges_amount NUMBER,
59 errors_amount NUMBER,
60 gl_date DATE,
61 value_date DATE,
62 cleared_date DATE,
63 ar_cash_receipt_id NUMBER,
64 X_bank_currency VARCHAR2,
65 X_statement_line_id IN OUT NOCOPY NUMBER,
66 X_statement_line_type VARCHAR2,
67 reference_status VARCHAR2,
68 trx_currency_type VARCHAR2,
69 auto_reconciled_flag VARCHAR2,
70 X_statement_header_id IN OUT NOCOPY NUMBER,
71 X_effective_date DATE DEFAULT NULL,
72 X_float_handling_flag VARCHAR2 DEFAULT NULL,
73 X_currency_code VARCHAR2 default NULL,
74 X_bank_trx_number VARCHAR2 default NULL,
75 X_reversed_receipt_flag VARCHAR2);
76 PROCEDURE reconcile_trx(
77 passin_mode VARCHAR2,
78 tx_type VARCHAR2,
79 trx_id NUMBER,
80 trx_status VARCHAR2,
81 receipt_type VARCHAR2,
82 exchange_rate_type VARCHAR2,
83 exchange_date DATE,
84 exchange_rate NUMBER,
85 amount_cleared NUMBER,
86 charges_amount NUMBER,
87 errors_amount NUMBER,
88 gl_date DATE,
89 value_date DATE,
90 cleared_date DATE,
91 ar_cash_receipt_id NUMBER,
92 X_bank_currency VARCHAR2,
93 X_statement_line_id IN OUT NOCOPY NUMBER,
94 X_statement_line_type VARCHAR2,
95 reference_status VARCHAR2,
96 trx_currency_type VARCHAR2,
97 auto_reconciled_flag VARCHAR2,
98 X_statement_header_id IN OUT NOCOPY NUMBER,
99 X_statement_header_date DATE DEFAULT NULL,
100 X_bank_trx_number VARCHAR2 DEFAULT NULL,
101 X_currency_code VARCHAR2 DEFAULT NULL,
102 X_original_amount NUMBER DEFAULT NULL,
103 X_effective_date DATE DEFAULT NULL,
104 X_float_handling_flag VARCHAR2 DEFAULT NULL,
105 X_reversed_receipt_flag VARCHAR2,
106 X_org_id NUMBER DEFAULT NULL,
107 X_legal_entity_id NUMBER DEFAULT NULL);
108
109 PROCEDURE reconcile_pay_eft( passin_mode VARCHAR2,
110 tx_type VARCHAR2,
111 trx_count NUMBER,
112 trx_group VARCHAR2,
113 cleared_trx_type VARCHAR2,
114 cleared_date DATE,
115 X_bank_currency VARCHAR2,
116 X_statement_line_id NUMBER,
117 X_statement_line_type VARCHAR2,
118 trx_currency_type VARCHAR2,
119 auto_reconciled_flag VARCHAR2,
120 X_statement_header_id NUMBER,
121 X_bank_trx_number VARCHAR2,
122 X_bank_account_id NUMBER,
123 X_payroll_payment_format VARCHAR2,
124 X_effective_date DATE,
125 X_float_handling_flag VARCHAR2);
126
127 PROCEDURE unclear_process (passin_mode VARCHAR2,
128 X_header_or_line VARCHAR2,
129 tx_type VARCHAR2,
130 clearing_trx_type VARCHAR2,
131 batch_id NUMBER,
132 trx_id NUMBER,
133 cash_receipt_id NUMBER,
134 trx_date DATE,
135 gl_date DATE,
136 cash_receipt_history_id IN OUT NOCOPY NUMBER,
137 stmt_line_id NUMBER,
138 status VARCHAR2,
139 cleared_date DATE,
140 transaction_amount NUMBER,
141 error_amount NUMBER,
142 charge_amount NUMBER,
143 currency_code VARCHAR2,
144 xtype VARCHAR2,
145 xdate DATE,
146 xrate NUMBER,
147 org_id NUMBER,
148 legal_entity_id NUMBER);
149
150 PROCEDURE DM_reversals
151 ( cash_receipt_id NUMBER,
152 cc_id NUMBER,
153 cust_trx_type_id NUMBER,
154 cust_trx_type VARCHAR2,
155 gl_date DATE,
156 reversal_date DATE,
157 reason VARCHAR2,
158 category VARCHAR2,
159 module_name VARCHAR2,
160 comment VARCHAR2,
161 document_number NUMBER,
162 doc_sequence_id NUMBER);
163
164 PROCEDURE reversals( cash_receipt_id NUMBER,
165 gl_date DATE,
166 reason VARCHAR2,
167 category VARCHAR2,
168 module_name VARCHAR2,
169 comment VARCHAR2);
170
171 PROCEDURE reconcile_pbatch (passin_mode VARCHAR2,
172 pbatch_id NUMBER,
173 statement_line_id IN OUT NOCOPY NUMBER,
174 gl_date DATE,
175 value_date DATE,
176 cleared_date DATE,
177 amount_to_clear NUMBER,
178 errors_amount NUMBER,
179 charges_amount NUMBER,
180 prorate_amount NUMBER,
181 exchange_rate_type VARCHAR2,
182 exchange_rate_date DATE,
183 exchange_rate NUMBER,
184 trx_currency_type VARCHAR2,
185 X_statement_header_id IN OUT NOCOPY NUMBER,
186 statement_header_date DATE DEFAULT NULL,
187 X_trx_type VARCHAR2 DEFAULT NULL,
188 X_bank_trx_number VARCHAR2 DEFAULT NULL,
189 X_currency_code VARCHAR2 DEFAULT NULL,
190 X_original_amount NUMBER DEFAULT NULL,
191 X_effective_date DATE DEFAULT NULL,
192 X_float_handling_flag VARCHAR2 DEFAULT NULL,
193 X_bank_currency_code VARCHAR2 DEFAULT NULL,
194 pgroup_id VARCHAR2 DEFAULT NULL); -- FOR SEPA ER 6700007
195
196 PROCEDURE reconcile_rbatch( passin_mode VARCHAR2,
197 rbatch_id NUMBER,
198 X_statement_line_id IN OUT NOCOPY NUMBER,
199 gl_date DATE,
200 value_date DATE,
201 bank_currency VARCHAR2,
202 exchange_rate_type VARCHAR2,
203 exchange_rate NUMBER,
204 exchange_rate_date DATE,
205 trx_currency_type VARCHAR2,
206 module VARCHAR2,
207 X_trx_number IN OUT NOCOPY VARCHAR2,
208 X_trx_date DATE,
209 X_deposit_date DATE,
210 X_amount NUMBER,
211 X_foreign_diff_amt NUMBER,
212 X_set_of_books_id NUMBER,
213 X_misc_currency_code VARCHAR2,
214 X_receipt_method_id NUMBER,
215 X_bank_account_id NUMBER,
216 X_activity_type_id NUMBER,
217 X_comments VARCHAR2,
218 X_reference_type VARCHAR2,
219 X_clear_currency_code VARCHAR2,
220 X_tax_id NUMBER,
221 X_tax_rate NUMBER,
222 X_cr_vat_tax_id VARCHAR2,
223 X_dr_vat_tax_id VARCHAR2,
224 X_trx_type VARCHAR2 DEFAULT NULL,
225 X_statement_header_id IN OUT NOCOPY NUMBER,
226 X_statement_date DATE DEFAULT NULL,
227 X_bank_trx_number VARCHAR2 DEFAULT NULL,
228 X_statement_amount NUMBER DEFAULT NULL,
229 X_original_amount NUMBER DEFAULT NULL,
230 X_effective_date DATE DEFAULT NULL,
231 X_float_handling_flag VARCHAR2 DEFAULT NULL);
232
233 PROCEDURE misc_receipt(
234 X_passin_mode VARCHAR2,
235 X_trx_number VARCHAR2,
236 X_doc_sequence_value VARCHAR2,
237 X_doc_sequence_id NUMBER,
238 X_gl_date DATE,
239 X_value_date DATE,
240 X_trx_date DATE,
241 X_deposit_date DATE,
242 X_amount NUMBER,
243 X_bank_account_amount NUMBER,
244 X_set_of_books_id NUMBER,
245 X_misc_currency_code VARCHAR2,
246 X_exchange_rate_date DATE,
247 X_exchange_rate_type VARCHAR2,
248 X_exchange_rate NUMBER,
249 X_receipt_method_id NUMBER,
250 X_bank_account_id NUMBER,
251 X_activity_type_id NUMBER,
252 X_comments VARCHAR2,
253 X_reference_type VARCHAR2,
254 X_reference_id NUMBER,
255 X_clear_currency_code VARCHAR2,
256 X_statement_line_id IN OUT NOCOPY NUMBER,
257 X_tax_id NUMBER,
258 X_tax_rate NUMBER,
259 X_paid_from VARCHAR2,
260 X_module_name VARCHAR2,
261 X_cr_vat_tax_id VARCHAR2,
262 X_dr_vat_tax_id VARCHAR2,
263 trx_currency_type VARCHAR2,
264 X_cr_id IN OUT NOCOPY NUMBER,
265 X_effective_date DATE,
266 X_org_id NUMBER );
267
268 END CE_AUTO_BANK_CLEAR;