[Home] [Help]
PACKAGE: APPS.OKL_GENERATE_STREAMS_PVT
Source
1 PACKAGE OKL_GENERATE_STREAMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRGSMS.pls 115.5 2002/04/21 23:46:13 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
7 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
8 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
9 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
10 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
14
15 ---------------------------------------------------------------------------
16 -- GLOBAL RETURN STATUSES
17 ---------------------------------------------------------------------------
18 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
20 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21
22 ---------------------------------------------------------------------------
23 -- GLOBAL EXCEPTION
24 ---------------------------------------------------------------------------
25 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
26 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
27 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
28 G_EXCEPTION_ERROR EXCEPTION;
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL NAMES
32 ---------------------------------------------------------------------------
33 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_GENERATE_STREAMS_PVT' ;
34 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
35
36 ---------------------------------------------------------------------------
37 -- GLOBAL CODES
38 ---------------------------------------------------------------------------
39 G_ORP_CODE_AUTH CONSTANT VARCHAR2(4) := 'AUTH';
40 G_ORP_CODE_RBOK CONSTANT VARCHAR2(4) := 'RBOK';
41 G_ORP_CODE_QUOT CONSTANT VARCHAR2(4) := 'QUOT';
42 G_ORP_CODE_TERM CONSTANT VARCHAR2(4) := 'TERM';
43
44 ---------------------------------------------------------------------------
45 -- OTHER GLOBALS
46 ---------------------------------------------------------------------------
47 G_FALSE CONSTANT VARCHAR(1) := OKL_API.G_FALSE;
48 G_TRUE CONSTANT VARCHAR(1) := OKL_API.G_TRUE;
49 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
50 G_EXC_NAME_RET_STS_ERR CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
51 G_EXC_NAME_RET_STS_UNEXP_ERR CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
52 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
53
54 ---------------------------------------------------------------------------
55 -- SUBTYPES
56 ---------------------------------------------------------------------------
57 SUBTYPE sifv_rec_type IS OKL_STREAM_INTERFACES_PUB.sifv_rec_type;
58
59
60 PROCEDURE GENERATE_STREAMS(p_api_version IN NUMBER
61 ,p_init_msg_list IN VARCHAR2
62 ,p_khr_id IN NUMBER
63 ,p_generation_ctx_code IN VARCHAR2
64 ,x_trx_number OUT NOCOPY NUMBER
65 ,x_trx_status OUT NOCOPY VARCHAR2
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_msg_data OUT NOCOPY VARCHAR2);
69
70 PROCEDURE POPULATE_HEADER_DATA(p_api_version IN NUMBER
71 ,p_init_msg_list IN VARCHAR2
72 ,p_khr_id IN NUMBER
73 ,p_generation_ctx_code IN VARCHAR2
74 ,x_trx_number OUT NOCOPY NUMBER
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2);
78
79 PROCEDURE INVOKE_PRICING_ENGINE(p_api_version IN NUMBER
80 ,p_init_msg_list IN VARCHAR2
81 ,p_trx_number in NUMBER
82 ,x_trx_number OUT NOCOPY NUMBER
83 ,x_trx_status OUT NOCOPY VARCHAR2
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2);
87
88 END OKL_GENERATE_STREAMS_PVT;