DBA Data[Home] [Help]

PACKAGE: APPS.OKL_FORMULAEVALUATE_PUB

Source


1 PACKAGE OKL_FORMULAEVALUATE_PUB AUTHID CURRENT_USER AS
2   /* $Header: OKLPEVAS.pls 115.2 2002/02/06 20:28:34 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_FORMULAEVALUATE_PUB';
13 
14 
15   G_EXCEPTION_HALT_PROCESSING EXCEPTION;
16 
17   --  Type Declarations
18 
19   SUBTYPE ctxparameter_tbl IS okl_formulaevaluate_pvt.ctxparameter_tbl;
20   SUBTYPE function_tbl IS okl_formulaevaluate_pvt.function_tbl;
21 
22   PROCEDURE EVA_GetParameterValues(p_api_version   IN  NUMBER
23                    ,p_init_msg_list IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
24                    ,x_return_status OUT NOCOPY VARCHAR2
25                    ,x_msg_count     OUT NOCOPY NUMBER
26                    ,x_msg_data      OUT NOCOPY VARCHAR2
27                    ,p_fma_id  IN  okl_formulae_v.id%TYPE
28                    ,p_contract_id   IN  okl_k_headers_v.id%TYPE
29                    ,x_ctx_parameter_tbl         OUT NOCOPY ctxparameter_tbl
30                    ,p_line_id       IN  okl_k_lines_v.id%TYPE DEFAULT NULL );
31 
32   PROCEDURE EVA_GetFunctionValue(p_api_version      IN  NUMBER
33                    ,p_init_msg_list    IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
34                    ,x_return_status    OUT NOCOPY VARCHAR2
35                    ,x_msg_count        OUT NOCOPY NUMBER
36                    ,x_msg_data         OUT NOCOPY VARCHAR2
37                    ,p_fma_id     IN  okl_formulae_v.id%TYPE
38                    ,p_contract_id      IN  okl_k_headers_v.id%TYPE
39                    ,p_line_id          IN  okl_k_lines_v.id%TYPE
40                    ,p_ctx_parameter_tbl  IN ctxparameter_tbl
41                    ,x_function_tbl            OUT NOCOPY function_tbl
42                    );
43 
44 END OKL_FORMULAEVALUATE_PUB;