1 PACKAGE OKL_LOSS_PROV_PUB AS
2 /* $Header: OKLPLPVS.pls 120.3 2005/10/30 04:25:52 appldev noship $*/
3
4 SUBTYPE glpv_rec_type IS okl_loss_prov_pvt.glpv_rec_type;
5 SUBTYPE slpv_rec_type IS okl_loss_prov_pvt.slpv_rec_type;
6 SUBTYPE slpv_tbl_type IS okl_loss_prov_pvt.slpv_tbl_type;
7
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LOSS_PROV_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
15 ------------------------------------------------------------------------------
16
17 -- this function is used to calculate capital balance for a contract and deal type
18 FUNCTION calculate_capital_balance(p_cntrct_id IN NUMBER
19 ,p_deal_type IN VARCHAR2) RETURN NUMBER;
20
21 -- this function is used to calculate total reserve amt for a contract
22 FUNCTION calculate_cntrct_rsrv_amt (
23 p_cntrct_id IN NUMBER) RETURN NUMBER;
24
25 -- this function is used to calculate general loss provision and create a transaction
26 FUNCTION SUBMIT_GENERAL_LOSS(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_glpv_rec IN glpv_rec_type) RETURN NUMBER;
33
34 -- this procedure is used create a transaction for specific loss provision
35 PROCEDURE SPECIFIC_LOSS_PROVISION (
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,p_slpv_rec IN slpv_rec_type);
42
43 PROCEDURE SPECIFIC_LOSS_PROVISION (
44 p_api_version IN NUMBER
45 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,p_khr_id IN NUMBER
50 ,p_reverse_flag IN VARCHAR2
51 ,p_slpv_tbl IN slpv_tbl_type);
52
53 End OKL_LOSS_PROV_PUB;