[Home] [Help]
PACKAGE: APPS.AR_BILLS_MAINTAIN_PUB
Source
1 PACKAGE AR_BILLS_MAINTAIN_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARBRMAIS.pls 115.6 2002/11/15 01:57:17 anukumar ship $ */
3
4
5 PROCEDURE Complete_BR (
6
7 -- ***** Standard API parameters *****
8
9 p_api_version IN NUMBER ,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
12 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
13 x_return_status OUT NOCOPY VARCHAR2 ,
14 x_msg_count OUT NOCOPY NUMBER ,
15 x_msg_data OUT NOCOPY VARCHAR2 ,
16
17 -- ***** Input parameters *****
18
19 p_customer_trx_id IN NUMBER DEFAULT NULL ,
20
21
22 -- ***** Output parameters *****
23
24 p_trx_number OUT NOCOPY VARCHAR2 ,
25 p_doc_sequence_id OUT NOCOPY NUMBER ,
26 p_doc_sequence_value OUT NOCOPY NUMBER ,
27 p_old_trx_number OUT NOCOPY VARCHAR2 ,
28 p_status OUT NOCOPY VARCHAR2 );
29
30
31
32 PROCEDURE UnComplete_BR (
33
34 -- ***** Standard API parameters *****
35
36 p_api_version IN NUMBER ,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
40 x_return_status OUT NOCOPY VARCHAR2 ,
41 x_msg_count OUT NOCOPY NUMBER ,
42 x_msg_data OUT NOCOPY VARCHAR2 ,
43
44 -- ***** Input parameters *****
45
46 p_customer_trx_id IN NUMBER DEFAULT NULL ,
47
48 -- ***** Output parameters *****
49
50 p_status OUT NOCOPY VARCHAR2 );
51
52
53
54 PROCEDURE Accept_BR (
55
56 -- ***** Standard API parameters *****
57
58 p_api_version IN NUMBER ,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
62 x_return_status OUT NOCOPY VARCHAR2 ,
63 x_msg_count OUT NOCOPY NUMBER ,
64 x_msg_data OUT NOCOPY VARCHAR2 ,
65
66 -- ***** Input parameters *****
67
68 p_customer_trx_id IN NUMBER DEFAULT NULL ,
69 p_acceptance_date IN DATE DEFAULT NULL ,
70 p_acceptance_gl_date IN DATE DEFAULT NULL ,
71 p_acceptance_comments IN VARCHAR2 DEFAULT NULL ,
72
73 -- ***** Output parameters *****
74
75 p_status OUT NOCOPY VARCHAR2 );
76
77
78
79 PROCEDURE Hold_BR (
80
81 -- ***** Standard API parameters *****
82
83 p_api_version IN NUMBER ,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
87 x_return_status OUT NOCOPY VARCHAR2 ,
88 x_msg_count OUT NOCOPY NUMBER ,
89 x_msg_data OUT NOCOPY VARCHAR2 ,
90
91 -- ***** Input parameters *****
92
93 p_customer_trx_id IN NUMBER DEFAULT NULL ,
94
95 -- ***** Output parameters *****
96
97 p_status OUT NOCOPY VARCHAR2 );
98
99
100
101 PROCEDURE UnHold_BR (
102
103 -- ***** Standard API parameters *****
104
105 p_api_version IN NUMBER ,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
109 x_return_status OUT NOCOPY VARCHAR2 ,
110 x_msg_count OUT NOCOPY NUMBER ,
111 x_msg_data OUT NOCOPY VARCHAR2 ,
112
113 -- ***** Input parameters *****
114
115 p_customer_trx_id IN NUMBER DEFAULT NULL ,
116
117 -- ***** Output parameters *****
118
119 p_status OUT NOCOPY VARCHAR2 );
120
121
122
123 PROCEDURE Select_BR_Remit (
124
125 -- ***** Input parameters *****
126
127 p_batch_id IN NUMBER DEFAULT NULL ,
128 p_ps_id IN NUMBER DEFAULT NULL ,
129
130 -- ***** Output parameters *****
131
132 p_status OUT NOCOPY VARCHAR2 );
133
134
135
136 PROCEDURE DeSelect_BR_Remit (
137
138 -- ***** Input parameters *****
139
140 p_ps_id IN NUMBER DEFAULT NULL ,
141
142 -- ***** Output parameters *****
143
144 p_status OUT NOCOPY VARCHAR2 );
145
146
147
148 PROCEDURE Cancel_BR_Remit (
149
150 -- ***** Input parameters *****
151
152 p_ps_id IN NUMBER DEFAULT NULL );
153
154
155
156 PROCEDURE Approve_BR_Remit (
157
158 -- ***** Input parameters *****
159
160 p_batch_id IN ar_batches.batch_id%TYPE ,
161 p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
162
163 -- ***** Output parameters *****
164
165 p_status OUT NOCOPY VARCHAR2 );
166
167
168
169 PROCEDURE Cancel_BR (
170
171 -- ***** Standard API parameters *****
172
173 p_api_version IN NUMBER ,
174 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
175 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
176 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
177 x_return_status OUT NOCOPY VARCHAR2 ,
178 x_msg_count OUT NOCOPY NUMBER ,
179 x_msg_data OUT NOCOPY VARCHAR2 ,
180
181 -- ***** Input parameters *****
182
183 p_customer_trx_id IN NUMBER DEFAULT NULL ,
184 p_cancel_date IN DATE DEFAULT NULL ,
185 p_cancel_gl_date IN DATE DEFAULT NULL ,
186 p_cancel_comments IN VARCHAR2 DEFAULT NULL ,
187
188
189 -- ***** Output parameters *****
190
191 p_status OUT NOCOPY VARCHAR2 );
192
193
194
195 PROCEDURE Unpaid_BR (
196
197 -- ***** Standard API parameters *****
198
199 p_api_version IN NUMBER ,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
203 x_return_status OUT NOCOPY VARCHAR2 ,
204 x_msg_count OUT NOCOPY NUMBER ,
205 x_msg_data OUT NOCOPY VARCHAR2 ,
206
207
208 -- ***** Input parameters *****
209
210 p_customer_trx_id IN NUMBER DEFAULT NULL ,
211 p_unpaid_date IN DATE DEFAULT NULL ,
212 p_unpaid_gl_date IN DATE DEFAULT NULL ,
213 p_unpaid_reason IN VARCHAR2 DEFAULT NULL ,
214 p_unpaid_comments IN VARCHAR2 DEFAULT NULL ,
215
216 -- ***** Output parameters *****
217
218 p_status OUT NOCOPY VARCHAR2 );
219
220
221
222 PROCEDURE Endorse_BR (
223
224 -- ***** Standard API parameters *****
225
226 p_api_version IN NUMBER ,
227 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
228 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
229 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
230 x_return_status OUT NOCOPY VARCHAR2 ,
231 x_msg_count OUT NOCOPY NUMBER ,
232 x_msg_data OUT NOCOPY VARCHAR2 ,
233
234 -- ***** Input parameters *****
235
236 p_customer_trx_id IN NUMBER DEFAULT NULL ,
237 p_endorse_date IN DATE DEFAULT NULL ,
238 p_endorse_gl_date IN DATE DEFAULT NULL ,
239 p_adjustment_activity_id IN NUMBER DEFAULT NULL ,
240 p_endorse_comments IN VARCHAR2 DEFAULT NULL ,
241 p_recourse_flag IN VARCHAR2 DEFAULT NULL ,
242
243 -- ***** Output parameters *****
244
245 p_status OUT NOCOPY VARCHAR2 );
246
247
248
249 PROCEDURE Protest_BR (
250
251 -- ***** Standard API parameters *****
252
253 p_api_version IN NUMBER ,
254 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
255 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
256 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
257 x_return_status OUT NOCOPY VARCHAR2 ,
258 x_msg_count OUT NOCOPY NUMBER ,
259 x_msg_data OUT NOCOPY VARCHAR2 ,
260
261 -- ***** Input parameters *****
262
263 p_customer_trx_id IN NUMBER DEFAULT NULL ,
264 p_protest_date IN DATE DEFAULT NULL ,
265 p_protest_comments IN VARCHAR2 DEFAULT NULL ,
266
267 -- ***** Output parameters *****
268
269 p_status OUT NOCOPY VARCHAR2 );
270
271
272
273 PROCEDURE Restate_BR (
274
275 -- ***** Standard API parameters *****
276
277 p_api_version IN NUMBER ,
278 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
279 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
281 x_return_status OUT NOCOPY VARCHAR2 ,
282 x_msg_count OUT NOCOPY NUMBER ,
283 x_msg_data OUT NOCOPY VARCHAR2 ,
284
285
286 -- ***** Input parameters *****
287
288 p_customer_trx_id IN NUMBER DEFAULT NULL ,
289 p_restatement_date IN DATE DEFAULT NULL ,
290 p_restatement_gl_date IN DATE DEFAULT NULL ,
291 p_restatement_comments IN VARCHAR2 DEFAULT NULL ,
292
293
294 -- ***** Output parameters *****
295
296 p_status OUT NOCOPY VARCHAR2 );
297
298
299
300 PROCEDURE Recall_BR (
301
302 -- ***** Standard API parameters *****
303
304 p_api_version IN NUMBER ,
305 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
306 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
307 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
308 x_return_status OUT NOCOPY VARCHAR2 ,
309 x_msg_count OUT NOCOPY NUMBER ,
310 x_msg_data OUT NOCOPY VARCHAR2 ,
311
312 -- ***** Input parameters *****
313
314 p_customer_trx_id IN NUMBER DEFAULT NULL ,
315 p_recall_date IN DATE DEFAULT NULL ,
316 p_recall_gl_date IN DATE DEFAULT NULL ,
317 p_recall_comments IN VARCHAR2 DEFAULT NULL ,
318
319 -- ***** Output parameters *****
320
321 p_status OUT NOCOPY VARCHAR2 );
322
323
324
325 PROCEDURE Eliminate_Risk_BR (
326
327 -- ***** Standard API parameters *****
328
329 p_api_version IN NUMBER ,
330 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
331 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
332 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
333 x_return_status OUT NOCOPY VARCHAR2 ,
334 x_msg_count OUT NOCOPY NUMBER ,
335 x_msg_data OUT NOCOPY VARCHAR2 ,
336
337
338 -- ***** Input parameters *****
339
340 p_customer_trx_id IN NUMBER DEFAULT NULL ,
341 p_risk_eliminate_date IN DATE DEFAULT NULL ,
342 p_risk_eliminate_gl_date IN DATE DEFAULT NULL ,
343 p_risk_eliminate_comments IN VARCHAR2 DEFAULT NULL ,
344
345 -- ***** Output parameters *****
346
347 p_status OUT NOCOPY VARCHAR2 );
348
349
350
351 PROCEDURE UnEliminate_Risk_BR (
352
353 -- ***** Standard API parameters *****
354
355 p_api_version IN NUMBER ,
356 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
357 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
358 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
359 x_return_status OUT NOCOPY VARCHAR2 ,
360 x_msg_count OUT NOCOPY NUMBER ,
361 x_msg_data OUT NOCOPY VARCHAR2 ,
362
363 -- ***** Input parameters *****
364
365 p_customer_trx_id IN NUMBER DEFAULT NULL ,
366 p_risk_uneliminate_date IN DATE DEFAULT NULL ,
367 p_risk_uneliminate_gl_date IN DATE DEFAULT NULL ,
368 p_risk_uneliminate_comments IN VARCHAR2 DEFAULT NULL ,
369
370 -- ***** Output parameters *****
371
372 p_status OUT NOCOPY VARCHAR2 );
373
374
375
376 PROCEDURE Exchange_BR (
377
378 -- ***** Standard API parameters *****
379
380 p_api_version IN NUMBER ,
381 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
382 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
383 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
384 x_return_status OUT NOCOPY VARCHAR2 ,
385 x_msg_count OUT NOCOPY NUMBER ,
386 x_msg_data OUT NOCOPY VARCHAR2 ,
387
388 -- ***** Input parameters *****
389
390 p_customer_trx_id IN NUMBER DEFAULT NULL ,
391
392 -- ***** Output parameters *****
393
394 p_new_customer_trx_id OUT NOCOPY NUMBER ,
395 p_new_trx_number OUT NOCOPY VARCHAR2 );
396
397
398
399
400 FUNCTION revision
401 RETURN VARCHAR2;
402
403
404 END AR_BILLS_MAINTAIN_PUB;
405