1 Package AR_DEPOSIT_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARXCDEPS.pls 120.14 2006/06/27 08:39:12 shveeram noship $ */
3 /*#
4 * Deposit APIs provide an extension to existing functionality of
5 * creating and manipulating deposits through the standard Oracle
6 * Receivables Transactions workbench.
7 * @rep:scope public
8 * @rep:metalink 236938.1 See OracleMetaLink note 236938.1
9 * @rep:product AR
10 * @rep:lifecycle active
11 * @rep:displayname Deposit
12 * @rep:category BUSINESS_ENTITY AR_DEPOSIT
13 */
14
15 TYPE attr_rec_type IS RECORD(
16 attribute_category VARCHAR2(30) DEFAULT NULL,
17 attribute1 VARCHAR2(150) DEFAULT NULL,
18 attribute2 VARCHAR2(150) DEFAULT NULL,
19 attribute3 VARCHAR2(150) DEFAULT NULL,
20 attribute4 VARCHAR2(150) DEFAULT NULL,
21 attribute5 VARCHAR2(150) DEFAULT NULL,
22 attribute6 VARCHAR2(150) DEFAULT NULL,
23 attribute7 VARCHAR2(150) DEFAULT NULL,
24 attribute8 VARCHAR2(150) DEFAULT NULL,
25 attribute9 VARCHAR2(150) DEFAULT NULL,
26 attribute10 VARCHAR2(150) DEFAULT NULL,
27 attribute11 VARCHAR2(150) DEFAULT NULL,
28 attribute12 VARCHAR2(150) DEFAULT NULL,
29 attribute13 VARCHAR2(150) DEFAULT NULL,
30 attribute14 VARCHAR2(150) DEFAULT NULL,
31 attribute15 VARCHAR2(150) DEFAULT NULL);
32
33 attr_cust_rec_const attr_rec_type;
34
35 attr_cust_lines_rec_const attr_rec_type;
36
37 TYPE global_attr_rec_type IS RECORD(
38 global_attribute_category VARCHAR2(30) DEFAULT NULL,
39 global_attribute1 VARCHAR2(150) DEFAULT NULL,
40 global_attribute2 VARCHAR2(150) DEFAULT NULL,
41 global_attribute3 VARCHAR2(150) DEFAULT NULL,
42 global_attribute4 VARCHAR2(150) DEFAULT NULL,
43 global_attribute5 VARCHAR2(150) DEFAULT NULL,
44 global_attribute6 VARCHAR2(150) DEFAULT NULL,
45 global_attribute7 VARCHAR2(150) DEFAULT NULL,
46 global_attribute8 VARCHAR2(150) DEFAULT NULL,
47 global_attribute9 VARCHAR2(150) DEFAULT NULL,
48 global_attribute10 VARCHAR2(150) DEFAULT NULL,
49 global_attribute11 VARCHAR2(150) DEFAULT NULL,
50 global_attribute12 VARCHAR2(150) DEFAULT NULL,
51 global_attribute13 VARCHAR2(150) DEFAULT NULL,
52 global_attribute14 VARCHAR2(150) DEFAULT NULL,
53 global_attribute15 VARCHAR2(150) DEFAULT NULL,
54 global_attribute16 VARCHAR2(150) DEFAULT NULL,
55 global_attribute17 VARCHAR2(150) DEFAULT NULL,
56 global_attribute18 VARCHAR2(150) DEFAULT NULL,
57 global_attribute19 VARCHAR2(150) DEFAULT NULL,
58 global_attribute20 VARCHAR2(150) DEFAULT NULL,
59 global_attribute21 VARCHAR2(150) DEFAULT NULL,
60 global_attribute22 VARCHAR2(150) DEFAULT NULL,
61 global_attribute23 VARCHAR2(150) DEFAULT NULL,
62 global_attribute24 VARCHAR2(150) DEFAULT NULL,
63 global_attribute25 VARCHAR2(150) DEFAULT NULL,
64 global_attribute26 VARCHAR2(150) DEFAULT NULL,
65 global_attribute27 VARCHAR2(150) DEFAULT NULL,
66 global_attribute28 VARCHAR2(150) DEFAULT NULL,
67 global_attribute29 VARCHAR2(150) DEFAULT NULL,
68 global_attribute30 VARCHAR2(150) DEFAULT NULL);
69
70 g_attr_cust_rec_const global_attr_rec_type;
71
72 g_attr_cust_lines_rec_const global_attr_rec_type;
73 /*========================================================================
74 | PUBLIC PROCEDURE CREATE_DEPOSIT
75 |
76 | DESCRIPTION
77 | Enter a brief description of what the package procedure does.
78 | ----------------------------------------
79 | This procedure does the following ......
80 | This routine is called to create deposit for the Transactions.
81 | This API routine has 8 output and 136 input parameters in total.
82 | As of some of the Out NOCOPY parameters, the API returns are Customer_trx_id ,
83 | Customer_trx_line_id, new trx_number, if generated during deposit
84 | creation.
85 |
86 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
87 | Enter a list of all local procedures and functions which
88 | are call this package.
89 | It will be used by ideposit UI's
90 |
91 |
92 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
93 | Enter a list of all local procedures and funtions which
94 | this package calls.
95 | arp_util.debug(
96 | FND_API.Compatible_API_Call
97 | FND_API.G_EXC_UNEXPECTED_ERROR
98 | FND_API.to_Boolean
99 | FND_MSG_PUB.initialize
100 | AR_DEPOSIT_LIB_PVT.Default_deposit_ids
101 | AR_DEPOSIT_LIB_PVT.Get_deposit_Defaults
102 | ar_deposit_val_pvt.Validate_Deposit
103 | Arp_trx_defaults.get_header_defaults
107 | FND_MSG_PUB.Count_And_Get
104 | ARP_TRX_VALIDATE.val_and_dflt_pay_mthd_and_bank
105 | ar_deposit_lib_pvt.Validate_Desc_Flexfield
106 | ar_deposit_lib_pvt.get_doc_seq
108 | arp_process_header_insrt_cover.insert_header_cover
109 | FND_MESSAGE.SET_NAME
110 | FND_MSG_PUB.Add;
111 | arp_process_header.post_commit
112 |
113 | PARAMETERS
114 | Parameter Type Description
115 | p_api_version IN Used to compare version numbers of
116 | incoming calls to its current version
117 | number.
118 |p_init_msg_list IN Allows API callers to request that the API does
119 | initialization of the
120 message list on their behalf.
121 |p_commit IN Used by API callers to ask the API to commit on
122 | their behalf.
123 |p_validation_level IN Not to be used currently as this is a public API .
124 |x_return_status OUT NOCOPY Represents the API overall return status.
125 |x_msg_count OUT NOCOPY Number of messages in the API message list
126 |x_msg_data OUT NOCOPY This is the message in encoded format
127 | if x_msg_count=1
128 |
129 |2. Parameters relevant to the deposit
130 |
131 |Parameter Type Description
132 |p_deposit_number IN The deposit number of the deposit to be created.
133 |p_deposit_date IN The Deposit date of the entered deposit.
134 |p_usr_currency_code IN The translated currency code.Used to derive the
135 | p_currency_code
136 | if it is not entered
137 |p_currency_code IN The actual currency code that gets stored in
138 | AR tables.
139 |p_usr_exchange_rate_type IN The translated exchange rate type.Used to derive
140 | the p_exchange_rate_type
141 | if it has not been entered.
142 |p_exchange_rate_type IN Exchange rate type stored in AR tables.
143 |p_exchange_rate IN The exchange rate between the receipt currency
144 | and the functional currency.
145 |p_exchange_rate_date IN The date on which the exchange rate is valid.
146 |p_batch_source_id IN Batch source identifier for the commitment
147 |p_batch_source_name IN Batch source name for the commitment
148 |p_cust_trx_type_id IN Transaction Type identifier
149 |p_cust_trx_type IN Transaction Type name
150 |p_class IN It is constant value = "DEP", for
151 | future enhancement.
152 |p_gl_date IN Date that this deposit will be posted to
153 | the General Ledger.
154 |
155 |p_bill_to_customer_id IN The customer_id for the bill
156 | to customer.
157 |p_bill_to_customer_name IN The name for the entered customer.
158 |p_bill_to_customer_number IN The number for the entered customer.
159 |p_bill_to_location IN The Location for the bill to customer.
160 |p_bill_to_contact_id IN The contact identifier for the bill
161 | to customer.
162 |p_bill_to_contact_first_name IN The first name of contact for the
163 | bill to customer.
164 |p_bill_to_contact_last_name IN The last name of contact for the
165 | bill to customer.
166 |p_ship_to_customer_id IN The customer_id for the ship
167 | to customer.
168 |p_ship_to_customer_name IN The name for the entered customer.
169 |p_ship_to_customer_number IN The number for the entered customer.
170 |p_ship_to_location IN The Location for the bill to customer.
171 |p_ship_to_contact_id IN The contact identifier for the bill
172 | to customer.
173 |p_ship_to_contact_first_name IN The first name of contact for the
174 | bill to customer.
175 |p_ship_to_contact_last_name IN The last name of contact for the bill
176 | to customer.
177 |p_term_id IN Payment terms identifier for the
178 | transactions.
179 |p_term_name IN Payment terms name for the transactions.
180 |p_salesrep_id IN Salesrep identifier for transactions.
181 |p_salesrep_name IN Salesrep name for the transactions.
182 |p_interface_header_context IN Interface header context
183 |p_interface_header_attribute1
184 |to
185 |p_interface_header_attribute15
186 | IN Interface header attribute
187 |p_attribute_category IN Descriptive Flexfield structure
188 | defining column
189 |p_attribute1top_attribute15 IN Descriptive Flexfield segment column
190 |
191 |p_global_attr_cust_rec IN This is a record type which contains
192 | all the 25 global descriptive
193 | flexfield segments and One global
194 | descriptive flexfield structure
195 | defining column.
196 |p_document_number IN Value assigned to document receipt.
197 |p_ussgl_transaction_code IN Code defined by Public Sec. accounting.
198 |p_printing_option IN Printing option for the invoice
199 |p_default_tax_exempt_flag IN Tax exempt flag.
200 |p_status_trx IN Status of the transaction
201 |p_financial_charges IN To indicate whether financial charges
202 | are calculated.
203 |p_agreement_id IN Agreement associated with transaction
204 | for the customer.
205 |p_special_instructions In Any special instruction for the
206 | transaction uptp 240 character.
207 |p_comments IN User comments
208 |p_purchase_order In Perchase order number
209 |p_purchase_order_revision In Perchase order revision number
210 |p_purchase_order_date In Perchase order date
211 |p_remit_to_address_id In Remit to address id for the customer
212 |p_sold_to_customer_id IN The customer_id for the sold to customer.
213 |p_sold_to_customer_name IN The name for the entered/defaulted
214 | sold to customer.
215 |p_sold_to_customer_number IN The number for the entered/defaulted
216 | sold to customer.
217 |p_paying_customer_id IN The customer_id associated with the
221 | paying customer
218 | customer bank account assigned
219 | to your transaction
220 |p_paying_customer_name IN The name for the entered/defaulted
222 |p_paying_customer_number IN The number for the entered/defaulted
223 | paying customer
224 |p_paying_location IN The Location for the paying customer
225 |p_receipt_method_name IN The Payment method name of transactions.
226 |p_cust_bank_account_id IN Customer bank account identifier.
227 |p_cust_bank_account_name IN Customer bank account name.
228 |p_cust_bank_account_number IN Customer bank account number.
229 |p_start_date_commitment IN Start date of commitment
230 |p_end_date_commitment IN End date of commitment
231 |p_amount IN Deposit amount
232 |p_inventory_id IN Item id of commitment,
233 | **** You can enter item id or Memo line id
234 |p_memo_line_id IN Memo line id
235 |p_memo_line_name IN Deposit amount
236 |p_description IN Description of deposit
237 |p_comm_interface_line_context IN Interface line context,for deposit
238 |p_comm_interface_line_attr1
239 |to
240 |p_comm_interface_line_attr15 In Interface line attribute value
241 |p_global_attr_cust_lines_rec In This is a record type which contains all
242 | the 25 global descriptive flexfield
243 | segments for deposit lines and
244 | One global descriptive flexfield
245 | structure defining column.
246 |p_owner_id In Id of the commitment owner
247 |p_owners_name In Name of the commitment owner
248 |X_new_trx_number Out NOCOPY New transaction no if generated
249 |X_new_customer_trx_id Out NOCOPY New customer_trx_id of the deposit
250 | being created
251 |X_new_customer_trx_line_id Out NOCOPY New customer_trx_line_id of the
252 | deposit being created
253 |X_new_rowid Out NOCOPY Rowid of the deposit being created
254 | KNOWN ISSUES
255 | Enter business functionality which was de-scoped as part of the
256 | implementation. Ideally this should never be used.
257 |
258 | NOTES
259 | Any interesting aspect of the code in the package body which needs
260 | to be stated.
261 |
262 | MODIFICATION HISTORY
263 | Date Author Description of Changes
264 | 21-MAY-2001 Anuj Created
265 | DD-MON-YYYY Name Bug #####, modified amount ..
266 |
267 *=======================================================================*/
268 /*#
269 * Use this procedure to create a deposit for Receivables transactions.
270 * @rep:scope public
271 * @rep:lifecycle active
272 * @rep:displayname Create Deposit
273 */
274
275 PROCEDURE CREATE_DEPOSIT(
276 -- Standard API parameters.
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_TRUE,
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 -- Commitment, deposit info. parameters
285 p_deposit_number IN VARCHAR2 DEFAULT NULL,
286 p_deposit_date IN DATE DEFAULT trunc(sysdate),
287 p_usr_currency_code IN VARCHAR2 DEFAULT NULL,
288 p_currency_code IN VARCHAR2 DEFAULT NULL,
289 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
290 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
291 p_exchange_rate IN NUMBER DEFAULT NULL,
292 p_exchange_rate_date IN DATE DEFAULT NULL,
293 p_batch_source_id IN NUMBER DEFAULT NULL,
294 p_batch_source_name IN VARCHAR2 DEFAULT NULL,
295 p_cust_trx_type_id IN NUMBER DEFAULT NULL,
296 p_cust_trx_type IN VARCHAR2 DEFAULT NULL,
297 p_class IN VARCHAR2 DEFAULT 'DEP',
298 p_gl_date IN DATE DEFAULT trunc(Sysdate),
299 p_bill_to_customer_id IN NUMBER DEFAULT NULL,
300 p_bill_to_customer_name IN VARCHAR2 DEFAULT NULL,
301 p_bill_to_customer_number IN VARCHAR2 DEFAULT NULL,
302 p_bill_to_location IN VARCHAR2 DEFAULT NULL,
303 p_bill_to_contact_id IN NUMBER DEFAULT NULL,
304 p_bill_to_contact_first_name IN VARCHAR2 DEFAULT NULL,
305 p_bill_to_contact_last_name IN VARCHAR2 DEFAULT NULL,
306 p_ship_to_customer_id IN NUMBER DEFAULT NULL,
307 p_ship_to_customer_name IN VARCHAR2 DEFAULT NULL,
308 p_ship_to_customer_number IN VARCHAR2 DEFAULT NULL,
309 p_ship_to_location IN VARCHAR2 DEFAULT NULL,
310 p_ship_to_contact_id IN NUMBER DEFAULT NULL,
311 p_ship_to_contact_first_name IN VARCHAR2 DEFAULT NULL,
312 p_ship_to_contact_last_name IN VARCHAR2 DEFAULT NULL,
313 p_term_id IN NUMBER DEFAULT NULL,
314 p_term_name IN VARCHAR2 DEFAULT NULL,
315 p_salesrep_id IN NUMBER DEFAULT NULL,
316 p_salesrep_name IN VARCHAR2 DEFAULT NULL,
317 --flexfeild for Header
318 p_interface_header_context IN VARCHAR2 DEFAULT NULL,
319 p_interface_header_attribute1 IN VARCHAR2 DEFAULT NULL,
320 p_interface_header_attribute2 IN VARCHAR2 DEFAULT NULL,
324 p_interface_header_attribute6 IN VARCHAR2 DEFAULT NULL,
321 p_interface_header_attribute3 IN VARCHAR2 DEFAULT NULL,
322 p_interface_header_attribute4 IN VARCHAR2 DEFAULT NULL,
323 p_interface_header_attribute5 IN VARCHAR2 DEFAULT NULL,
325 p_interface_header_attribute7 IN VARCHAR2 DEFAULT NULL,
326 p_interface_header_attribute8 IN VARCHAR2 DEFAULT NULL,
327 p_interface_header_attribute9 IN VARCHAR2 DEFAULT NULL,
328 p_interface_header_attribute10 IN VARCHAR2 DEFAULT NULL,
329 p_interface_header_attribute11 IN VARCHAR2 DEFAULT NULL,
330 p_interface_header_attribute12 IN VARCHAR2 DEFAULT NULL,
331 p_interface_header_attribute13 IN VARCHAR2 DEFAULT NULL,
332 p_interface_header_attribute14 IN VARCHAR2 DEFAULT NULL,
333 p_interface_header_attribute15 IN VARCHAR2 DEFAULT NULL,
334
335 p_attribute_category IN VARCHAR2 DEFAULT NULL,
336 p_attribute1 IN VARCHAR2 DEFAULT NULL,
337 p_attribute2 IN VARCHAR2 DEFAULT NULL,
338 p_attribute3 IN VARCHAR2 DEFAULT NULL,
339 p_attribute4 IN VARCHAR2 DEFAULT NULL,
340 p_attribute5 IN VARCHAR2 DEFAULT NULL,
341 p_attribute6 IN VARCHAR2 DEFAULT NULL,
342 p_attribute7 IN VARCHAR2 DEFAULT NULL,
343 p_attribute8 IN VARCHAR2 DEFAULT NULL,
344 p_attribute9 IN VARCHAR2 DEFAULT NULL,
345 p_attribute10 IN VARCHAR2 DEFAULT NULL,
346 p_attribute11 IN VARCHAR2 DEFAULT NULL,
347 p_attribute12 IN VARCHAR2 DEFAULT NULL,
348 p_attribute13 IN VARCHAR2 DEFAULT NULL,
349 p_attribute14 IN VARCHAR2 DEFAULT NULL,
350 p_attribute15 IN VARCHAR2 DEFAULT NULL,
351 -- ******* Global Flexfield parameters *******
352 p_global_attr_cust_rec IN global_attr_rec_type
353 DEFAULT g_attr_cust_rec_const,
354 p_document_number IN VARCHAR2 DEFAULT NULL,
355 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
356 p_printing_option IN VARCHAR2 DEFAULT 'PRI',
357 p_default_tax_exempt_flag IN VARCHAR2 DEFAULT 'S',
358 p_status_trx IN VARCHAR2 DEFAULT NULL,
359 p_financial_charges IN VARCHAR2 DEFAULT NULL,
360 p_agreement_id IN NUMBER DEFAULT NULL,
361 p_special_instructions IN VARCHAR2 DEFAULT NULL,
362 p_comments IN VARCHAR2 DEFAULT NULL,
363 p_purchase_order IN VARCHAR2 DEFAULT NULL,
364 p_purchase_order_revision IN VARCHAR2 DEFAULT NULL,
365 p_purchase_order_date IN DATE DEFAULT NULL,
366 p_remit_to_address_id IN NUMBER DEFAULT NULL,
367 p_sold_to_customer_id IN NUMBER DEFAULT NULL,
368 p_sold_to_customer_name IN VARCHAR2 DEFAULT NULL,
369 p_sold_to_customer_number IN VARCHAR2 DEFAULT NULL ,
370 p_paying_customer_id IN NUMBER DEFAULT NULL,
371 p_paying_customer_name IN VARCHAR2 DEFAULT NULL,
372 p_paying_customer_number IN VARCHAR2 DEFAULT NULL ,
373 p_paying_location IN VARCHAR2 DEFAULT NULL,
374 p_receipt_method_id IN NUMBER DEFAULT NULL,
375 p_receipt_method_name IN VARCHAR2 DEFAULT NULL ,
376 p_cust_bank_account_id IN NUMBER DEFAULT NULL,
377 p_cust_bank_account_name IN VARCHAR2 DEFAULT NULL ,
378 p_cust_bank_account_number IN VARCHAR2 DEFAULT NULL ,
379 p_start_date_commitment IN DATE DEFAULT NULL,
380 p_end_date_commitment IN DATE DEFAULT NULL,
381 p_amount IN NUMBER,
382 p_inventory_id IN NUMBER DEFAULT NULL,
383 p_memo_line_id IN NUMBER DEFAULT NULL,
384 p_memo_line_name IN VARCHAR2 DEFAULT NULL,
385 p_description IN VARCHAR2 DEFAULT NULL,
386 --flexfeild for Lines
387 p_comm_interface_line_context IN VARCHAR2 DEFAULT NULL,
388 p_comm_interface_line_attr1 IN VARCHAR2 DEFAULT NULL,
389 p_comm_interface_line_attr2 IN VARCHAR2 DEFAULT NULL,
390 p_comm_interface_line_attr3 IN VARCHAR2 DEFAULT NULL,
391 p_comm_interface_line_attr4 IN VARCHAR2 DEFAULT NULL,
392 p_comm_interface_line_attr5 IN VARCHAR2 DEFAULT NULL,
393 p_comm_interface_line_attr6 IN VARCHAR2 DEFAULT NULL,
394 p_comm_interface_line_attr7 IN VARCHAR2 DEFAULT NULL,
395 p_comm_interface_line_attr8 IN VARCHAR2 DEFAULT NULL,
396 p_comm_interface_line_attr9 IN VARCHAR2 DEFAULT NULL,
397 p_comm_interface_line_attr10 IN VARCHAR2 DEFAULT NULL,
398 p_comm_interface_line_attr11 IN VARCHAR2 DEFAULT NULL,
399 p_comm_interface_line_attr12 IN VARCHAR2 DEFAULT NULL,
400 p_comm_interface_line_attr13 IN VARCHAR2 DEFAULT NULL,
401 p_comm_interface_line_attr14 IN VARCHAR2 DEFAULT NULL,
402 p_comm_interface_line_attr15 IN VARCHAR2 DEFAULT NULL,
403
404 -- ******* Global Flexfield parameters *******
405 p_global_attr_cust_lines_rec
406 IN global_attr_rec_type
407 DEFAULT g_attr_cust_lines_rec_const,
408 p_org_id IN NUMBER DEFAULT NULL,
409 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL,
410 -- ** OUT NOCOPY variables
411 X_new_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
412 X_new_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
413 X_new_customer_trx_line_id
414 OUT NOCOPY
415 ra_customer_trx_lines.customer_trx_line_id%type,
416 X_new_rowid OUT NOCOPY VARCHAR2) ;
417 /*========================================================================
418 | PUBLIC PROCEDURE insert_non_rev_salescredit
419 |
420 | DESCRIPTION
421 | Enter a brief description of what the package procedure does.
422 | ----------------------------------------
423 | This routine is called to assign non revenue sales credit to
424 | salesreps of to deposit, commitment. You can create as many
425 | of the non-revenue credit assignment.
426 | This API routine has 4 output and 22 input parameters in total.
427 |
428 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
429 | Enter a list of all local procedures and functions which
430 | are call this package.
431 | AR_DEPOSIT_API_PUB.insert_non_rev_salescredit
432 | Parameter
433 | p_deposit_number
434 | p_customer_trx_id
435 | p_salesrep_number
436 | p_salesrep_id
437 | p_non_revenue_amount_split
438 | p_non_revenue_percent_split
439 | p_attribute_category
440 | p_attribute1 to p_attribute15
441 |
442 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
443 |
444 | PARAMETERS
445 |
446 | None
447 |
448 | KNOWN ISSUES
449 |
450 | NOTES
451 |
452 | MODIFICATION HISTORY
453 | Date Author Description of Changes
454 | 08-JUL-2003 Anuj Created
455 | DD-MON-YYYY Name Bug #####, modified amount ..
456 |
457 *=======================================================================*/
458
459 /*#
460 * Use this procedure to assign non revenue sales credit to salesreps
461 * for a deposit or commitment.
462 * @rep:scope public
463 * @rep:lifecycle active
464 * @rep:displayname Assign Sales Credit
465 */
466
467 PROCEDURE insert_non_rev_salescredit(
468 -- Standard API parameters.
469 p_api_version IN NUMBER,
470 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
471 p_commit IN VARCHAR2 := FND_API.G_TRUE,
472 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_msg_count OUT NOCOPY NUMBER,
475 x_msg_data OUT NOCOPY VARCHAR2,
476 p_deposit_number IN VARCHAR2 DEFAULT NULL,
477 p_customer_trx_id IN NUMBER DEFAULT NULL,
478 p_salesrep_number IN VARCHAR2 DEFAULT NULL,
479 p_salesrep_id IN NUMBER DEFAULT NULL,
480 p_non_revenue_amount_split IN NUMBER DEFAULT NULL,
481 p_non_revenue_percent_split IN NUMBER DEFAULT NULL,
482 p_attribute_category IN VARCHAR2 DEFAULT NULL ,
483 p_attribute1 IN VARCHAR2 DEFAULT NULL ,
484 p_attribute2 IN VARCHAR2 DEFAULT NULL ,
485 p_attribute3 IN VARCHAR2 DEFAULT NULL ,
486 p_attribute4 IN VARCHAR2 DEFAULT NULL ,
487 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
488 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
489 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
490 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
491 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
492 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
493 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
494 p_attribute12 IN VARCHAR2 DEFAULT NULL ,
495 p_attribute13 IN VARCHAR2 DEFAULT NULL ,
496 p_attribute14 IN VARCHAR2 DEFAULT NULL ,
497 p_attribute15 IN VARCHAR2 DEFAULT NULL ,
498 p_org_id IN NUMBER DEFAULT NULL ) ;
499
500
501 /*========================================================================
502 | PROCEDURE set_profile_for_testing
503 |
504 | DESCRIPTION
505 | Enter a brief description of what the package procedure does.
506 | ----------------------------------------
507 | This procedure does the following: Set the value of profile options
508 |
509 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
510 | Enter a list of all local procedures and functions which
511 | are call this package.
512 |
513 |
514 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
515 | Enter a list of all local procedures and funtions which
516 | this package calls.
517 | fnd_profile.value
518 |
519 | PARAMETERS
520 |
521 | None
522 |
523 | KNOWN ISSUES
524 |
525 | NOTES
526 |
527 | MODIFICATION HISTORY
528 | Date Author Description of Changes
529 | 21-MAY-2001 Anuj Created
530 | DD-MON-YYYY Name Bug #####, modified amount ..
531 |
532 *=======================================================================*/
533
534 PROCEDURE set_profile_for_testing(p_profile_batch_source NUMBER,
535 p_profile_doc_seq VARCHAR2,
536 p_profile_trxln_excpt VARCHAR2,
537 p_profile_enable_cc VARCHAR2,
538 p_profile_cc_rate_type VARCHAR2,
539 p_profile_dsp_inv_rate VARCHAR2,
540 p_profile_def_x_rate_type VARCHAR2
541 );
542 /*========================================================================
543 | PROCEDURE create_trxn_extension
544 |
545 | DESCRIPTION
546 | Enter a brief description of what the package procedure does.
547 | ----------------------------------------
548 | This procedure does the following: updates pmt_trx_extn
549 |
550 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
551 | Enter a list of all local procedures and functions which
552 | are call this package.
553 |
554 |
555 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
556 | Enter a list of all local procedures and funtions which
557 | this package calls.
558 | fnd_profile.value
559 |
560 | PARAMETERS
561 |
562 | None
563 |
564 | KNOWN ISSUES
565 |
566 | NOTES
567 |
568 | MODIFICATION HISTORY
569 | Date Author Description of Changes
570 | 26-sep-2005 bichatte created
571 |
572 *=======================================================================*/
573
574 PROCEDURE copy_trxn_extension( p_customer_trx_id IN NUMBER,
575 p_payment_trxn_extension_id IN NUMBER,
576 p_return_status OUT NOCOPY VARCHAR2 );
577
578 END AR_DEPOSIT_API_PUB;