PACKAGE: APPS.OKL_DAILY_INTEREST_CALC_PVT

Source

1 PACKAGE OKL_DAILY_INTEREST_CALC_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRDICS.pls 120.2 2005/09/30 05:26:06 dkagrawa noship $ */
3  ------------------------------------------------------------------------------
4  -- Global Variables
5  ------------------------------------------------------------------------------
6  G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_DAILY_INTEREST_CALC_PVT';
7  G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
8  G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
9  G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
10  G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
11 
12  ------------------------------------------------------------------------------
13  -- Record Type
14  ------------------------------------------------------------------------------
15  SUBTYPE receipt_tbl_type IS OKL_VARIABLE_INTEREST_PVT.receipt_tbl_type;
16  SUBTYPE principal_balance_tbl_typ IS OKL_VARIABLE_INTEREST_PVT.principal_balance_tbl_typ;
17 
18  ---------------------------------------------------------------------------
19  -- Procedures and Functions
20  ---------------------------------------------------------------------------
21 
22  --procedure for calculating daily interest
23  --creates accrual streams for actual interest and actual principal
24  PROCEDURE daily_interest(p_api_version		IN  NUMBER
25   	,p_init_msg_list	IN  VARCHAR2	DEFAULT OKL_API.G_FALSE
26   	,x_return_status	OUT NOCOPY VARCHAR2
27   	,x_msg_count		OUT NOCOPY NUMBER
28   	,x_msg_data		    OUT NOCOPY VARCHAR2
29     ,p_khr_id IN NUMBER DEFAULT NULL);
30 
31  --returns cash applications towards loan payment, variable loan payment and unscheduled loan payment
32  PROCEDURE receipt_date_range(
33     p_api_version        IN  NUMBER,
34     p_init_msg_list      IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
35     x_return_status      OUT NOCOPY VARCHAR2,
36     x_msg_count          OUT NOCOPY NUMBER,
37     x_msg_data           OUT NOCOPY VARCHAR2,
38     p_contract_id        IN  NUMBER,
39     p_start_date         IN  DATE,
40     p_due_date           IN  DATE,
41     x_principal_balance  OUT NOCOPY NUMBER,
42     x_receipt_tbl        OUT NOCOPY receipt_tbl_type);
43 
44  --wrapper procedure for calculating daily interest will be called from Daily Interest Calculation CP
45  PROCEDURE calculate_daily_interest(
46     errbuf            OUT NOCOPY VARCHAR2,
47     retcode           OUT NOCOPY NUMBER,
48     p_contract_number IN VARCHAR2
49     );
50 
51 END OKL_DAILY_INTEREST_CALC_PVT;