DBA Data[Home] [Help]

PACKAGE: APPS.LNS_INDEX_RATES_PUB

Source


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;