1 Package AR_DEPOSIT_VAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARXDEPVS.pls 115.2 2003/07/10 01:00:43 anukumar noship $*/
3
4 /*========================================================================
5 | PUBLIC PROCEDURE Validate_Deposit
6 |
7 | DESCRIPTION
8 | Enter a brief description of what the package procedure does.
9 | ----------------------------------------
10 | This procedure does the following ...... |
11 | Perform some of basic validation
12 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
13 | Enter a list of all local procedures and functions which
14 | are call this package.
15 |
16 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
17 | Enter a list of all local procedures and funtions which
18 | this package calls.
19 | Validate_deposit_Date
20 | Validate_batch_source'
21 | Validate_Gl_Date
22 | Validate_amount
23 | Validate_Exchange_Rate
24 | Is_currency_valid
25 | Validate_Currency
26 | arp_util.debug(
27 | FND_MESSAGE.SET_NAME
28 | FND_MSG_PUB.Add;
29 |
30 | PARAMETERS
31 | Parameter Type Description
32 | p_batch_source_id IN Batch source
33 | p_deposit_date IN Deposit date
34 | p_gl_date IN Gl Date
35 | p_doc_sequence_value IN Doc seq no value
36 | p_amount IN Deposit amount
37 | p_currency_code IN Currenct code
38 | p_exchange_rate_type IN Exchange type
39 | p_exchange_rate IN Exchange rate
40 | p_exchange_rate_date IN Exchange rate date
41 | p_printing_option IN Printing option
42 | p_status_trx IN Transaction status
43 | p_default_tax_exempt_flag IN Tax exempt flag
44 | p_financial_charges IN Financial Charges
45 | p_return_status OUT NOCOPY Return Status
46 |
47 | NOTES
48 | Any interesting aspect of the code in the package body which needs
49 | to be stated.
50 |
51 | MODIFICATION HISTORY
52 | Date Author Description of Changes
53 | 21-MAY-2001 Anuj Created
54 | DD-MON-YYYY Name Bug #####, modified amount ..
55 |
56 *=======================================================================*/
57
58
59 Procedure Validate_Deposit(
60 p_batch_source_id
61 IN ra_batch_sources.batch_source_id%type,
62 p_deposit_date IN date,
63 p_gl_date IN date,
64 p_doc_sequence_value
65 IN ra_customer_trx.doc_sequence_value%type,
66 p_amount IN ra_customer_trx_lines.extended_amount%type,
67 p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
68 p_exchange_rate_type
69 IN ra_customer_trx.exchange_rate_type%TYPE,
70 p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
71 p_exchange_rate_date
72 IN ra_customer_trx.exchange_date%TYPE,
73 p_printing_option
74 IN VARCHAR2,
75 p_status_trx IN VARCHAR2,
76 p_default_tax_exempt_flag
77 IN VARCHAR2,
78 p_financial_charges
79 IN VARCHAR2 default null ,
80 p_return_status OUT NOCOPY VARCHAR2);
81
82
83 END AR_DEPOSIT_VAL_PVT ; -- Package spec