[Home] [Help]
PACKAGE: APPS.OKL_STREAM_GENERATOR_PUB
Source
1 PACKAGE OKL_STREAM_GENERATOR_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSGPS.pls 115.9 2003/10/15 21:37:01 ssiruvol noship $ */
3
4 -----------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STREAM_GENERATOR_PUB';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_API_TYPE CONSTANT VARCHAR2(4) := '_PUB';
10 G_API_VERSION CONSTANT NUMBER := 1;
11 G_FALSE CONSTANT VARCHAR2(30) := OKL_API.G_FALSE;
12
13
14 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
15 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
16 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
19
20 ---------------------------------------------------------------------------
21 -- PROGRAM UNITS
22 ---------------------------------------------------------------------------
23
24 PROCEDURE generate_streams( p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 p_khr_id IN NUMBER,
27 p_compute_rates IN VARCHAR2 DEFAULT OKL_API.G_TRUE,
28 p_generation_type IN VARCHAR2 DEFAULT 'FULL',
29 p_reporting_book_class IN VARCHAR2 DEFAULT NULL,
30 x_contract_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2);
34
35 PROCEDURE generate_streams( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
37 p_khr_id IN NUMBER,
38 p_compute_irr IN VARCHAR2 DEFAULT OKL_API.G_TRUE,
39 p_generation_type IN VARCHAR2 DEFAULT 'FULL',
40 p_reporting_book_class IN VARCHAR2 DEFAULT NULL,
41 x_pre_tax_irr OUT NOCOPY NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2);
45
46 PROCEDURE GEN_VAR_INT_SCHEDULE( p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2,
48 p_khr_id IN NUMBER,
49 p_purpose_code IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54 END okl_stream_generator_pub;