[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_STREAMS_PUB
Source
1 PACKAGE OKL_PROCESS_STREAMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPSRS.pls 115.5 2002/06/14 17:00:43 pkm ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_PROCESS_STREAMS_PUB';
12
13 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
14 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
15 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
16 G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
17 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
19 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
20
21
22 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
23 G_EXCEPTION_ERROR EXCEPTION;
24 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
25
26
27 SUBTYPE selv_tbl_type IS Okl_Process_Streams_Pvt.selv_tbl_type;
28 SUBTYPE stmv_rec_type IS Okl_Process_Streams_Pvt.stmv_rec_type;
29 SUBTYPE stmv_tbl_type IS Okl_Process_Streams_Pvt.stmv_tbl_type;
30
31 PROCEDURE process_stream_results(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_transaction_number IN NUMBER
37 );
38
39 PROCEDURE PROCESS_REST_STRM_RESLTS(p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2
41 ,p_transaction_number IN NUMBER
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2);
45
46 END OKL_PROCESS_STREAMS_PUB;