[Home] [Help]
PACKAGE: APPS.OKL_ACCOUNT_BALANCES_PVT
Source
1 PACKAGE OKL_ACCOUNT_BALANCES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRACBS.pls 120.2 2005/10/30 03:37:28 appldev noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNT_REP_PVT' ;
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
5 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
7 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
8 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
14 G_EXCEPTION_ERROR EXCEPTION;
15 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
16 SUBTYPE error_message_type IS Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
17 -- This API should be called for calculation of Periodic Interest for the contracts which
18 -- have capitalization flag = ''N'
19
20 PROCEDURE Get_Account_Balances(p_errbuf OUT NOCOPY VARCHAR2,
21 p_retcode OUT NOCOPY NUMBER,
22 p_contract_number IN VARCHAR2,
23 p_account_from IN VARCHAR2,
24 p_account_to IN VARCHAR2,
25 p_period_from IN VARCHAR2,
26 p_period_to IN VARCHAR2,
27 p_format IN VARCHAR2 );
28
29
30 FUNCTION Submit_Account_Balances(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_contract_number IN VARCHAR2,
37 p_account_from IN VARCHAR2,
38 p_account_to IN VARCHAR2,
39 p_period_from IN VARCHAR2,
40 p_period_to IN VARCHAR2,
41 p_format IN VARCHAR2 )
42 RETURN NUMBER;
43
44 END OKL_ACCOUNT_BALANCES_PVT;