DBA Data[Home] [Help]

PACKAGE: APPS.OKL_GENERATE_STREAMS_PUB

Source


1 PACKAGE OKL_GENERATE_STREAMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPGSMS.pls 115.5 2002/04/21 23:46:03 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 
11   G_APP_NAME		      CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
12   G_PKG_NAME                  CONSTANT VARCHAR2(30)  := 'OKL_GENERATE_STREAMS_PUB';
13 
14   ---------------------------------------------------------------------------
15   -- GLOBAL RETURN STATUSES
16   ---------------------------------------------------------------------------
17   G_RET_STS_SUCCESS		CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18   G_RET_STS_UNEXP_ERROR		CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
19   G_RET_STS_ERROR		CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
20 
21   ---------------------------------------------------------------------------
22   -- GLOBAL EXCEPTION
23   ---------------------------------------------------------------------------
24   G_EXCEPTION_HALT_VALIDATION  EXCEPTION;
25   G_EXCEPTION_HALT_PROCESSING EXCEPTION;
26   G_EXCEPTION_UNEXPECTED_ERROR	EXCEPTION;
27   G_EXCEPTION_ERROR		EXCEPTION;
28 
29   G_EXC_NAME_RET_STS_ERR	CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
30   G_EXC_NAME_RET_STS_UNEXP_ERR	CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
31   G_EXC_NAME_OTHERS	        CONSTANT VARCHAR2(6) := 'OTHERS';
32   G_API_TYPE	CONSTANT VARCHAR(4) := '_PUB';
33 
34   ---------------------------------------------------------------------------
35   -- SUBTYPES
36   ---------------------------------------------------------------------------
37   --SUBTYPE sif_vrec_type IS OKL_STREAM_INTERFACES_PUB.sifv_rec_type;
38 
39   PROCEDURE GENERATE_STREAMS(p_api_version          IN         NUMBER
40                              ,p_init_msg_list       IN         VARCHAR2
41                              ,p_khr_id              IN         NUMBER
42                              ,p_generation_ctx_code IN         VARCHAR2
43                              ,x_trx_number          OUT NOCOPY NUMBER
44                              ,x_trx_status          OUT NOCOPY VARCHAR2
45                              ,x_return_status       OUT NOCOPY VARCHAR2
46                              ,x_msg_count           OUT NOCOPY NUMBER
47                              ,x_msg_data            OUT NOCOPY VARCHAR2);
48 
49   PROCEDURE POPULATE_HEADER_DATA(p_api_version          IN         NUMBER
50                                  ,p_init_msg_list       IN         VARCHAR2
51                                  ,p_khr_id              IN         NUMBER
52                                  ,p_generation_ctx_code IN         VARCHAR2
53                                  ,x_trx_number          OUT NOCOPY NUMBER
54                                  ,x_return_status       OUT NOCOPY VARCHAR2
55                                  ,x_msg_count           OUT NOCOPY NUMBER
56                                  ,x_msg_data            OUT NOCOPY VARCHAR2);
57 
58   PROCEDURE INVOKE_PRICING_ENGINE(p_api_version          IN         NUMBER
59                                   ,p_init_msg_list       IN         VARCHAR2
60                                   ,p_trx_number          in  NUMBER
61                                   ,x_trx_number          OUT NOCOPY NUMBER
62                                   ,x_trx_status          OUT NOCOPY VARCHAR2
63                                   ,x_return_status       OUT NOCOPY VARCHAR2
64                                   ,x_msg_count           OUT NOCOPY NUMBER
65                                   ,x_msg_data            OUT NOCOPY VARCHAR2);
66 
67 END OKL_GENERATE_STREAMS_PUB;