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