[Home] [Help]
PACKAGE: APPS.AR_BILLS_CREATION_PUB
Source
4
1 PACKAGE AR_BILLS_CREATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARBRCRES.pls 120.7 2006/02/16 12:30:00 ggadhams ship $ */
3
5 PROCEDURE Create_BR_Header (
6
7 -- ***** Standard API parameters *****
8 p_api_version IN NUMBER ,
9 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
10 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 x_msg_count OUT NOCOPY NUMBER ,
14 x_msg_data OUT NOCOPY VARCHAR2 ,
15
16 -- ***** BR Header information parameters *****
17 p_trx_number IN VARCHAR2 DEFAULT NULL ,
18 p_term_due_date IN DATE DEFAULT NULL ,
19 p_batch_source_id IN NUMBER DEFAULT NULL ,
20 p_cust_trx_type_id IN NUMBER DEFAULT NULL ,
21 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL ,
22 p_br_amount IN NUMBER DEFAULT NULL ,
23 p_trx_date IN DATE DEFAULT NULL ,
24 p_gl_date IN DATE DEFAULT NULL ,
25 p_drawee_id IN NUMBER DEFAULT NULL ,
26 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
27 p_drawee_contact_id IN NUMBER DEFAULT NULL ,
28 p_printing_option IN VARCHAR2 DEFAULT NULL ,
29 p_comments IN VARCHAR2 DEFAULT NULL ,
30 p_special_instructions IN VARCHAR2 DEFAULT NULL ,
31 p_drawee_bank_account_id IN NUMBER DEFAULT NULL ,
32 p_remittance_bank_account_id IN NUMBER DEFAULT NULL ,
33 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL ,
34 p_batch_id IN NUMBER DEFAULT NULL ,
35 p_doc_sequence_id IN NUMBER DEFAULT NULL ,
36 p_doc_sequence_value IN NUMBER DEFAULT NULL ,
37 p_created_from IN VARCHAR2 DEFAULT NULL ,
38
39 -- ***** Descriptive Flexfield parameters *****
40 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
41 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
42 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
43 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
44 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
45 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
46 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
47 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
48 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
49 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
50 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
51 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
52 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
53 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
54 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
55 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
56
57 -- ***** Legal Entity and SSA *****
58 p_le_id IN NUMBER DEFAULT NULL ,
59 p_org_id IN NUMBER DEFAULT NULL ,
60 p_payment_trxn_extn_id IN NUMBER DEFAULT NULL ,
61
62 -- ***** OUTPUT variables *****
63 p_customer_trx_id OUT NOCOPY NUMBER ,
64 p_new_trx_number OUT NOCOPY VARCHAR2 ,
65 p_status OUT NOCOPY VARCHAR2 ,
66 p_customer_reference IN VARCHAR2 DEFAULT NULL );
67
68
69
70 PROCEDURE Update_BR_Header (
71
72 -- ***** Standard API parameters *****
73 p_api_version IN NUMBER ,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT NOCOPY VARCHAR2 ,
78 x_msg_count OUT NOCOPY NUMBER ,
79 x_msg_data OUT NOCOPY VARCHAR2 ,
80
81 -- ***** BR Header information parameters *****
82 p_customer_trx_id IN NUMBER DEFAULT NULL ,
83 p_term_due_date IN DATE DEFAULT NULL ,
84 p_cust_trx_type_id IN NUMBER DEFAULT NULL ,
85 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL ,
86 p_br_amount IN NUMBER DEFAULT NULL ,
87 p_trx_date IN DATE DEFAULT NULL ,
88 p_gl_date IN DATE DEFAULT NULL ,
89 p_drawee_id IN NUMBER DEFAULT NULL ,
90 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
91 p_drawee_contact_id IN NUMBER DEFAULT NULL ,
92 p_printing_option IN VARCHAR2 DEFAULT NULL ,
93 p_comments IN VARCHAR2 DEFAULT NULL ,
94 p_special_instructions IN VARCHAR2 DEFAULT NULL ,
95 p_drawee_bank_account_id IN NUMBER DEFAULT NULL ,
96 p_remittance_bank_account_id IN NUMBER DEFAULT NULL ,
97 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL ,
98 p_doc_sequence_id IN NUMBER DEFAULT NULL ,
99 p_doc_sequence_value IN NUMBER DEFAULT NULL ,
100 p_created_from IN VARCHAR2 DEFAULT NULL ,
101
102 -- ***** Descriptive Flexfield parameters *****
103 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
104 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
105 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
109 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
106 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
107 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
108 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
110 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
111 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
112 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
113 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
114 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
115 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
116 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
117 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
118 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
119 p_customer_reference IN VARCHAR2 DEFAULT NULL ,
120 p_le_id IN NUMBER DEFAULT NULL ,
121 p_payment_trxn_extn_id IN NUMBER DEFAULT NULL);
122
123
124 PROCEDURE Delete_BR_Header (
125
126 -- ***** Standard API parameters *****
127 p_api_version IN NUMBER ,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 x_return_status OUT NOCOPY VARCHAR2 ,
132 x_msg_count OUT NOCOPY NUMBER ,
133 x_msg_data OUT NOCOPY VARCHAR2 ,
134
135 -- ***** Input parameters *****
136 p_customer_trx_id IN NUMBER DEFAULT NULL );
137
138
139
140 PROCEDURE Lock_BR_Header (
141
142 -- ***** Standard API parameters *****
148 x_msg_count OUT NOCOPY NUMBER ,
143 p_api_version IN NUMBER ,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 x_return_status OUT NOCOPY VARCHAR2 ,
149 x_msg_data OUT NOCOPY VARCHAR2 ,
150
151 -- ***** BR Header information parameters *****
152 p_customer_trx_id IN NUMBER DEFAULT NULL ,
153 p_term_due_date IN DATE DEFAULT NULL ,
154 p_cust_trx_type_id IN NUMBER DEFAULT NULL ,
155 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL ,
156 p_br_amount IN NUMBER DEFAULT NULL ,
157 p_trx_date IN DATE DEFAULT NULL ,
158 p_gl_date IN DATE DEFAULT NULL ,
159 p_drawee_id IN NUMBER DEFAULT NULL ,
160 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
161 p_drawee_contact_id IN NUMBER DEFAULT NULL ,
162 p_printing_option IN VARCHAR2 DEFAULT NULL ,
163 p_comments IN VARCHAR2 DEFAULT NULL ,
164 p_special_instructions IN VARCHAR2 DEFAULT NULL ,
165 p_drawee_bank_account_id IN NUMBER DEFAULT NULL ,
166 p_remittance_bank_account_id IN NUMBER DEFAULT NULL ,
167 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL ,
168 p_doc_sequence_id IN NUMBER DEFAULT NULL ,
169 p_doc_sequence_value IN NUMBER DEFAULT NULL ,
170 p_created_from IN VARCHAR2 DEFAULT NULL ,
171
172 -- ***** Descriptive Flexfield parameters *****
173 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
174 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
175 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
176 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
177 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
178 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
179 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
180 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
181 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
182 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
183 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
184 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
185 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
186 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
190
187 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
188 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
189 p_customer_reference IN VARCHAR2 DEFAULT NULL );
191
192 PROCEDURE Create_BR_Assignment (
193
194 -- ***** Standard API parameters *****
195 p_api_version IN NUMBER ,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199 x_return_status OUT NOCOPY VARCHAR2 ,
200 x_msg_count OUT NOCOPY NUMBER ,
201 x_msg_data OUT NOCOPY VARCHAR2 ,
202
203 -- ***** BR Assignment information parameters *****
204 p_customer_trx_id IN NUMBER DEFAULT NULL ,
205 p_br_ref_payment_schedule_id IN NUMBER DEFAULT NULL ,
206 p_assigned_amount IN NUMBER DEFAULT NULL ,
207
208 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
209 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
210 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
211 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
212 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
213 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
214 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
215 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
216 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
217 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
218 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
219 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
220 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
221 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
222 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
223 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
224
225 -- ***** SSA *****
226 p_org_id IN NUMBER DEFAULT NULL ,
227
228 -- ***** OUT NOCOPY variables *****
229 p_customer_trx_line_id OUT NOCOPY NUMBER );
230
231
232
233 PROCEDURE Update_BR_Assignment (
234
235 -- ***** Standard API parameters *****
236 p_api_version IN NUMBER ,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
239 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240 x_return_status OUT NOCOPY VARCHAR2 ,
241 x_msg_count OUT NOCOPY NUMBER ,
242 x_msg_data OUT NOCOPY VARCHAR2 ,
243
244 -- ***** BR Assignment information parameters *****
245 p_customer_trx_id IN NUMBER DEFAULT NULL ,
246 p_customer_trx_line_id IN NUMBER DEFAULT NULL ,
247 p_br_ref_payment_schedule_id IN NUMBER DEFAULT NULL ,
248 p_assigned_amount IN NUMBER DEFAULT NULL ,
249
250 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
251 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
252 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
253 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
254 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
255 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
256 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
257 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
258 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
259 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
260 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
261 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
262 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
263 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
264 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
265 p_attribute15 IN VARCHAR2 DEFAULT NULL );
266
267
268 PROCEDURE Delete_BR_Assignment (
269
270 -- ***** Standard API parameters *****
271 p_api_version IN NUMBER ,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
273 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
274 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 x_return_status OUT NOCOPY VARCHAR2 ,
276 x_msg_count OUT NOCOPY NUMBER ,
277 x_msg_data OUT NOCOPY VARCHAR2 ,
278
279 -- ***** BR Assignment info. parameters *****
280 p_customer_trx_id IN NUMBER DEFAULT NULL ,
281 p_customer_trx_line_id IN NUMBER DEFAULT NULL );
282
286 -- ***** Standard API parameters *****
283
284 PROCEDURE Lock_BR_Assignment (
285
287 p_api_version IN NUMBER ,
288 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
289 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
293 x_msg_data OUT NOCOPY VARCHAR2 ,
290 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291 x_return_status OUT NOCOPY VARCHAR2 ,
292 x_msg_count OUT NOCOPY NUMBER ,
294
295 -- ***** BR Assignment info. parameters *****
296 p_customer_trx_id IN NUMBER DEFAULT NULL ,
297 p_customer_trx_line_id IN NUMBER DEFAULT NULL ,
298 p_br_ref_payment_schedule_id IN NUMBER DEFAULT NULL ,
299 p_assigned_amount IN NUMBER DEFAULT NULL ,
300
301 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
302 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
303 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
304 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
305 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
306 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
307 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
308 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
309 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
310 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
311 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
312 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
313 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
314 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
315 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
316 p_attribute15 IN VARCHAR2 DEFAULT NULL );
317
318
319
320 FUNCTION revision RETURN VARCHAR2;
321
322 PROCEDURE Create_BR_Trxn_Extension(
323
324 -- ***** Standard API parameters *****
325 p_api_version IN NUMBER ,
326 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
327 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
328 x_return_status OUT NOCOPY VARCHAR2 ,
329 x_msg_count OUT NOCOPY NUMBER ,
330 x_msg_data OUT NOCOPY VARCHAR2 ,
331
332 -- ***** BR Header information parameters *****
333 p_customer_trx_id IN NUMBER DEFAULT NULL ,
334 p_trx_number IN VARCHAR2 DEFAULT NULL ,
335 p_org_id IN NUMBER DEFAULT NULL ,
336 p_drawee_id IN NUMBER DEFAULT NULL ,
337 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
338 p_payment_channel IN VARCHAR2 DEFAULT NULL ,
339 p_instrument_assign_id IN NUMBER DEFAULT NULL ,
340 -- ***** OUTPUT variables *****
341 p_payment_trxn_extn_id OUT NOCOPY NUMBER );
342
343 PROCEDURE Update_BR_Trxn_Extension(
344
345 -- ***** Standard API parameters *****
346 p_api_version IN NUMBER ,
347 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
348 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
349 x_return_status OUT NOCOPY VARCHAR2 ,
350 x_msg_count OUT NOCOPY NUMBER ,
351 x_msg_data OUT NOCOPY VARCHAR2 ,
352
353 -- ***** BR Header information parameters *****
354 p_customer_trx_id IN NUMBER DEFAULT NULL ,
355 p_trx_number IN VARCHAR2 DEFAULT NULL ,
356 p_org_id IN NUMBER DEFAULT NULL ,
357 p_drawee_id IN NUMBER DEFAULT NULL ,
358 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
359 p_payment_channel IN VARCHAR2 DEFAULT NULL ,
360 p_instrument_assign_id IN NUMBER DEFAULT NULL ,
361 p_payment_trxn_extn_id IN iby_trxn_extensions_v.trxn_extension_id %type );
362
363
364 PROCEDURE Delete_BR_Trxn_Extension(
365
366 -- ***** Standard API parameters *****
367 p_api_version IN NUMBER ,
368 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
369 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
370 x_return_status OUT NOCOPY VARCHAR2 ,
371 x_msg_count OUT NOCOPY NUMBER ,
372 x_msg_data OUT NOCOPY VARCHAR2 ,
373
374 -- ***** BR Header information parameters *****
375 p_customer_trx_id IN NUMBER DEFAULT NULL ,
376 p_trx_number IN VARCHAR2 DEFAULT NULL ,
377 p_org_id IN NUMBER DEFAULT NULL ,
378 p_drawee_id IN NUMBER DEFAULT NULL ,
379 p_drawee_site_use_id IN NUMBER DEFAULT NULL ,
380 p_payment_channel IN VARCHAR2 DEFAULT NULL ,
381 p_instrument_assign_id IN NUMBER DEFAULT NULL ,
382 p_payment_trxn_extn_id IN iby_trxn_extensions_v.trxn_extension_id %type );
383
384
385 END AR_BILLS_CREATION_PUB;
386