[Home] [Help]
PACKAGE: APPS.OKL_VARIABLE_INTEREST_PUB
Source
1 PACKAGE OKL_VARIABLE_INTEREST_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPVARS.pls 120.1 2005/10/22 01:30:10 rseela noship $ */
3 ------------------------------------------------------------------------------
4 -- Global Variables
5 ------------------------------------------------------------------------------
6
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VARIABLE_INTEREST_PUB';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
12
13 ---------------------------------------------------------------------------
14 -- Procedures and Functions
15 ---------------------------------------------------------------------------
16
17 SUBTYPE csm_periodic_expenses_tbl_type IS okl_process_streams_pvt.srlv_tbl_type;
18 SUBTYPE csm_loan_level_tbl_type IS okl_create_streams_pvt.csm_loan_level_tbl_type;
19
20
21 PROCEDURE VARIABLE_INTEREST
22 (p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_contract_number VARCHAR2
28 ,P_to_date DATE);
29
30
31 PROCEDURE var_int_rent_level(
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_chr_id IN NUMBER,
38 p_trx_id IN NUMBER,
39 p_trx_status IN VARCHAR2,
40 p_rent_tbl IN csm_periodic_expenses_tbl_type);
41
42
43
44 PROCEDURE VARIABLE_INTEREST
45 (errbuf OUT NOCOPY VARCHAR2
46 ,retcode OUT NOCOPY NUMBER
47 ,p_contract_number IN VARCHAR2 DEFAULT NULL
48 ,p_to_date IN VARCHAR2 DEFAULT NULL);
49
50 /* 4682018 Redudant procedure
51 PROCEDURE initiate_request
52 (p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
54 p_contract_number IN VARCHAR2,
55 p_from_date IN DATE,
56 p_to_date IN DATE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_request_id OUT NOCOPY NUMBER,
61 x_trans_status OUT NOCOPY VARCHAR2);
62 */
63 END;
64