[Home] [Help]
PACKAGE: APPS.AR_RECEIPT_API_COVER
Source
1 Package AR_RECEIPT_API_COVER AS
2 /* $Header: ARXRCCVS.pls 120.2 2003/08/12 17:48:47 jbeckett noship $ */
3 --Start of comments
4 --API name : Receipt API cover routine
5 --Type : Public.
6 --Function : Create , apply, unapply and reverse Receipts
7 --Pre-reqs :
8 --
9 -- Notes : Note text
10 --
11 -- Modification History
12 -- Date Name Description
13 -- 20-MAY-2003 Jon Beckett Created to ensure backward compatibility for Trade
14 -- Management. This version compatible with 11.5.10+
15 -- AR installations.
16 -- End of comments
17
18
19 PROCEDURE Create_cash(
20 -- Standard API parameters.
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE,
24 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 -- Receipt info. parameters
29 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
30 p_currency_code IN VARCHAR2 DEFAULT NULL,
31 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
32 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
33 p_exchange_rate IN NUMBER DEFAULT NULL,
34 p_exchange_rate_date IN DATE DEFAULT NULL,
35 p_amount IN NUMBER DEFAULT NULL,
36 p_factor_discount_amount IN NUMBER DEFAULT NULL,
37 p_receipt_number IN VARCHAR2 DEFAULT NULL,
38 p_receipt_date IN DATE DEFAULT NULL,
39 p_gl_date IN DATE DEFAULT NULL,
40 p_maturity_date IN DATE DEFAULT NULL,
41 p_postmark_date IN DATE DEFAULT NULL,
42 p_customer_id IN NUMBER DEFAULT NULL,
43 p_customer_name IN VARCHAR2 DEFAULT NULL,
44 p_customer_number IN VARCHAR2 DEFAULT NULL,
45 p_customer_bank_account_id IN NUMBER DEFAULT NULL,
46 p_customer_bank_account_num IN VARCHAR2 DEFAULT NULL,
47 p_customer_bank_account_name IN VARCHAR2 DEFAULT NULL,
48 p_location IN VARCHAR2 DEFAULT NULL,
49 p_customer_site_use_id IN NUMBER DEFAULT NULL,
50 p_customer_receipt_reference IN VARCHAR2 DEFAULT NULL,
51 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL,
52 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
53 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
54 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
55 p_deposit_date IN DATE DEFAULT NULL,
56 p_receipt_method_id IN NUMBER DEFAULT NULL,
57 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
58 p_doc_sequence_value IN NUMBER DEFAULT NULL,
59 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
60 p_anticipated_clearing_date IN DATE DEFAULT NULL,
61 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
62 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
63 -- ******* Global Flexfield parameters *******
64 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
65 p_comments IN VARCHAR2 DEFAULT NULL,
66 -- *** Notes Receivable Additional Information ***
67 p_issuer_name IN VARCHAR2 DEFAULT NULL,
68 p_issue_date IN DATE DEFAULT NULL,
69 p_issuer_bank_branch_id IN NUMBER DEFAULT NULL,
70 -- ** OUT NOCOPY variables
71 p_cr_id OUT NOCOPY NUMBER
72 );
73
74 PROCEDURE Apply(
75 -- Standard API parameters.
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 -- Receipt application parameters.
84 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
85 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
86 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
87 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
88 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
89 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
90 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
91 -- this is the allocated receipt amount
92 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
99 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
100 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
101 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
102 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
103 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
104 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
105 -- ******* Global Flexfield parameters *******
106 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
116 );
117
118 PROCEDURE Unapply(
119 -- Standard API parameters.
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 x_return_status OUT NOCOPY VARCHAR2 ,
125 x_msg_count OUT NOCOPY NUMBER ,
126 x_msg_data OUT NOCOPY VARCHAR2 ,
127 -- *** Receipt Info. parameters *****
128 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
129 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
130 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
131 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
132 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
133 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
134 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
135 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
136 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
137 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y'
138 );
139
140 PROCEDURE Create_and_apply(
141 -- Standard API parameters.
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 -- Receipt info. parameters
150 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156 p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161 p_maturity_date IN DATE DEFAULT NULL,
162 p_postmark_date IN DATE DEFAULT NULL,
163 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
164 p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
165 p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
166 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
167 p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
168 p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169 p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173 p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174 p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175 p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178 p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179 p_doc_sequence_value IN NUMBER DEFAULT NULL,
180 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
182 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
183 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
184 -- ******* Global Flexfield parameters *******
185 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
186 p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187 -- *** Notes Receivable Additional Information ***
188 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189 p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191 -- ** OUT NOCOPY variables for Creating receipt
192 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193 -- Receipt application parameters
194 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
195 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
196 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
197 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
198 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
199 -- this is the allocated receipt amount
200 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
208 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
209 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
210 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
211 app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
212 -- ******* Global Flexfield parameters *******
213 app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
214 app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
215 -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
216 -- processor such as iPayments
217 p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE
218
219 -- OUT NOCOPY parameter for the Application
220 );
221
222 PROCEDURE Reverse(
223 -- Standard API parameters.
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226 p_commit IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 -- Receipt reversal related parameters
232 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234 p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235 p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238 p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239 p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
242 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
243 --p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type_upd DEFAULT ar_receipt_api_pub.global_attribute_rec_upd_cons
244 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const ,
245 p_cancel_claims_flag IN VARCHAR2 DEFAULT 'Y'
246 );
247
248 PROCEDURE Apply_on_account(
249 -- Standard API parameters.
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252 p_commit IN VARCHAR2 := FND_API.G_FALSE,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 -- Receipt application parameters.
258 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
259 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
260 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
261 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
262 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
263 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
264 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265 -- ******* Global Flexfield parameters *******
266 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
268 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
269 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
270 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
271 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
272 );
273
274 PROCEDURE Unapply_on_account(
275 -- Standard API parameters.
276 p_api_version IN NUMBER,
277 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278 p_commit IN VARCHAR2 := FND_API.G_FALSE,
279 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280 x_return_status OUT NOCOPY VARCHAR2 ,
281 x_msg_count OUT NOCOPY NUMBER ,
282 x_msg_data OUT NOCOPY VARCHAR2 ,
283 -- *** Receipt Info. parameters *****
284 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
285 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
286 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
287 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL
288 );
289
290 PROCEDURE Activity_application(
291 -- Standard API parameters.
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294 p_commit IN VARCHAR2 := FND_API.G_FALSE,
295 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 -- Receipt application parameters.
300 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
301 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
302 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
303 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
304 p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
305 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
306 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
307 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
308 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
310 -- ******* Global Flexfield parameters *******
311 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
312 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
313 p_application_ref_type IN OUT NOCOPY
314 ar_receivable_applications.application_ref_type%TYPE,
315 p_application_ref_id IN OUT NOCOPY
316 ar_receivable_applications.application_ref_id%TYPE,
317 p_application_ref_num IN OUT NOCOPY
318 ar_receivable_applications.application_ref_num%TYPE,
319 p_secondary_application_ref_id IN OUT NOCOPY
320 ar_receivable_applications.secondary_application_ref_id%TYPE,
321 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
323 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
324 p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
325 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
326 );
327
328 PROCEDURE Activity_unapplication(
329 -- Standard API parameters.
330 p_api_version IN NUMBER,
331 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332 p_commit IN VARCHAR2 := FND_API.G_FALSE,
333 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334 x_return_status OUT NOCOPY VARCHAR2 ,
335 x_msg_count OUT NOCOPY NUMBER ,
336 x_msg_data OUT NOCOPY VARCHAR2 ,
337 -- *** Receipt Info. parameters *****
338 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
339 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
340 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
341 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
342 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
343 );
344
345 PROCEDURE Apply_other_account(
346 -- Standard API parameters.
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349 p_commit IN VARCHAR2 := FND_API.G_FALSE,
350 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351 x_return_status OUT NOCOPY VARCHAR2,
352 x_msg_count OUT NOCOPY NUMBER,
353 x_msg_data OUT NOCOPY VARCHAR2,
354 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
355 -- Receipt application parameters.
356 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
357 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
358 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
359 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
360 p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
361 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
362 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365 p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366 p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367 p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370 -- ******* Global Flexfield parameters *******
371 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
374 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
375 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
376 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
377 );
378
379 PROCEDURE Unapply_other_account(
380 -- Standard API parameters.
381 p_api_version IN NUMBER,
382 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
383 p_commit IN VARCHAR2 := FND_API.G_FALSE,
384 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385 x_return_status OUT NOCOPY VARCHAR2 ,
386 x_msg_count OUT NOCOPY NUMBER ,
387 x_msg_data OUT NOCOPY VARCHAR2 ,
388 -- *** Receipt Info. parameters *****
389 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
390 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
391 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
392 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
393 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
394 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
395 );
396
397 PROCEDURE create_misc(
398 -- Standard API parameters.
399 p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401 p_commit IN VARCHAR2 := FND_API.G_FALSE,
402 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403 x_return_status OUT NOCOPY VARCHAR2 ,
404 x_msg_count OUT NOCOPY NUMBER ,
405 x_msg_data OUT NOCOPY VARCHAR2 ,
406 -- Misc Receipt info. parameters
407 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
408 p_currency_code IN VARCHAR2 DEFAULT NULL,
409 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
410 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
411 p_exchange_rate IN NUMBER DEFAULT NULL,
412 p_exchange_rate_date IN DATE DEFAULT NULL,
413 p_amount IN NUMBER,
414 p_receipt_number IN OUT NOCOPY VARCHAR2,
415 p_receipt_date IN DATE DEFAULT NULL,
416 p_gl_date IN DATE DEFAULT NULL,
417 p_receivables_trx_id IN NUMBER DEFAULT NULL,
418 p_activity IN VARCHAR2 DEFAULT NULL,
419 p_misc_payment_source IN VARCHAR2 DEFAULT NULL,
420 p_tax_code IN VARCHAR2 DEFAULT NULL,
421 p_vat_tax_id IN VARCHAR2 DEFAULT NULL,
422 p_tax_rate IN NUMBER DEFAULT NULL,
423 p_tax_amount IN NUMBER DEFAULT NULL,
424 p_deposit_date IN DATE DEFAULT NULL,
425 p_reference_type IN VARCHAR2 DEFAULT NULL,
426 p_reference_num IN VARCHAR2 DEFAULT NULL,
427 p_reference_id IN NUMBER DEFAULT NULL,
428 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
429 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
430 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
431 p_receipt_method_id IN NUMBER DEFAULT NULL,
432 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
433 p_doc_sequence_value IN NUMBER DEFAULT NULL,
434 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
435 p_anticipated_clearing_date IN DATE DEFAULT NULL,
436 p_attribute_record IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
437 p_global_attribute_record IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
438 p_comments IN VARCHAR2 DEFAULT NULL,
439 p_misc_receipt_id OUT NOCOPY NUMBER);
440
441 PROCEDURE Apply_Open_Receipt(
442 -- Standard API parameters.
443 p_api_version IN NUMBER,
444 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
445 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
446 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
447 x_return_status OUT NOCOPY VARCHAR2,
448 x_msg_count OUT NOCOPY NUMBER,
449 x_msg_data OUT NOCOPY VARCHAR2,
450 -- Receipt application parameters.
451 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454 p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455 p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456 p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
457 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
458 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
459 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
460 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
461 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
462 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
463 -- ******* Global Flexfield parameters *******
464 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
465 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
466 x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
467 x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
468 x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
469 );
470
471 PROCEDURE Unapply_Open_Receipt(
472 -- Standard API parameters.
473 p_api_version IN NUMBER,
474 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
475 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
476 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
477 x_return_status OUT NOCOPY VARCHAR2 ,
478 x_msg_count OUT NOCOPY NUMBER ,
479 x_msg_data OUT NOCOPY VARCHAR2 ,
480 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
481 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
482 p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT');
483
484 END AR_RECEIPT_API_COVER;