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