1 PACKAGE LNS_INDEX_RATES_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_FLOATRATE_S.pls 120.0.12010000.1 2009/03/12 20:27:20 scherkas noship $ */
3
4 /*========================================================================
5 | PUBLIC PROCEDURE UPDATE_FLOATING_RATE_LOANS
6 |
7 | DESCRIPTION
8 | This procedure gets called from CM to mass update index rate for floating loans.
9 |
10 | PSEUDO CODE/LOGIC
11 |
12 | PARAMETERS
13 | ERRBUF OUT Returns errors to CM
14 | RETCODE OUT Returns error code to CM
15 | INDEX_RATE_ID IN Inputs index rate type
16 | INTEREST_RATE_LINE_ID IN Inputs index rate
17 |
18 | KNOWN ISSUES
19 | None
20 |
21 | NOTES
22 |
23 | MODIFICATION HISTORY
24 | Date Author Description of Changes
25 | 20-Feb-2009 scherkas Created
26 |
27 *=======================================================================*/
28 PROCEDURE UPDATE_FLOATING_RATE_LOANS(
29 ERRBUF OUT NOCOPY VARCHAR2,
30 RETCODE OUT NOCOPY VARCHAR2,
31 P_INDEX_RATE_ID IN NUMBER);
32
33 -- This api updates floating rates for single loan
34 PROCEDURE UPDATE_LOAN_FLOATING_RATE(
35 P_API_VERSION IN NUMBER,
36 P_INIT_MSG_LIST IN VARCHAR2,
37 P_COMMIT IN VARCHAR2,
38 P_VALIDATION_LEVEL IN NUMBER,
39 P_LOAN_ID IN NUMBER,
40 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
41 X_MSG_COUNT OUT NOCOPY NUMBER,
42 X_MSG_DATA OUT NOCOPY VARCHAR2);
43
44 END LNS_INDEX_RATES_PUB;