[Home] [Help]
PACKAGE: APPS.OKL_LOAN_BAL_UPDATE_PVT
Source
1 PACKAGE OKL_LOAN_BAL_UPDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRLBUS.pls 120.2 2005/11/29 23:38:54 pjgomes noship $ */
3
4 ------------------------------------------------------------------------------
5 --Record Types
6 ------------------------------------------------------------------------------
7 TYPE khr_rec_type IS RECORD (
8 khr_id okc_k_headers_b.id%type,
9 contract_number okc_k_headers_b.contract_number%type,
10 status okc_k_headers_b.sts_code%type,
11 deal_type okl_product_parameters_v.deal_type%type,
12 interest_calculation_basis okl_product_parameters_v.interest_calculation_basis%type,
13 revenue_recognition_method okl_product_parameters_v.revenue_recognition_method%type);
14
15 SUBTYPE okl_cblv_rec is okl_cbl_pvt.cblv_rec_type;
16 SUBTYPE okl_cblv_tbl is okl_cbl_pvt.cblv_tbl_type;
17
18 ---------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ---------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LOAN_BAL_UPDATE_PVT';
22 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
23 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
24
25 ------------------------------------------------------------------------------
26 --Global Exception
27 ------------------------------------------------------------------------------
28 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
29
30 PROCEDURE get_loan_amounts(
31 p_api_version IN NUMBER
32 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
33 , x_return_status OUT NOCOPY VARCHAR2
34 , x_msg_count OUT NOCOPY NUMBER
35 , x_msg_data OUT NOCOPY VARCHAR2
36 , p_khr_rec IN khr_rec_type
37 , p_as_of_date IN DATE);
38
39 PROCEDURE calculate_loan_amounts(
40 errbuf OUT NOCOPY VARCHAR2
41 , retcode OUT NOCOPY NUMBER
42 , p_contract_number IN VARCHAR2
43 , p_as_of_date IN VARCHAR2 );
44
45 END OKL_LOAN_BAL_UPDATE_PVT; -- end of Spec