1 PACKAGE OKL_FORMULAEVALUATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLREVAS.pls 115.4 2002/12/18 12:47:20 kjinger noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
9 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
10 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
11 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
16 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLcode';
20 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
21 G_ONE_DOI CONSTANT VARCHAR2(200) := 'OKC_ONE_DOI';
22 G_FORMULA_NOT_FOUND CONSTANT VARCHAR2(200) := 'OKL_FMA_NOTFOUND';
23 G_EVALUATE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_EVALUATE_ERR';
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL VARIABLES
27 ---------------------------------------------------------------------------
28 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULAEVALUATE_PVT';
29 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
30
31 /** SBALASHA001 -
32 INFO: G_FNCT_PKG_NAME will hold a package name, and this
33 package will have all the parameter evaluator
34 functions written by an individual developer. **/
35 G_FNCT_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_FORMULAFUNCTION_PVT';
36 G_FNCT_PREFIX CONSTANT VARCHAR2(6) := 'GET_';
37 G_FNCT_SUFFIX CONSTANT VARCHAR2(6) := '_VALUE';
38
39 ---------------------------------------------------------------------------
40 -- GLOBAL EXCEPTION
41 ---------------------------------------------------------------------------
42 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
43
44
45 /** SBALASHA001 -
46 INFO: Record to hold parameter value, name and id.
47 This record is used to send the parameter id,
48 name and the value evaluated to the calling API.
49 **/
50 TYPE CtxParameter_rec IS RECORD (
51 parameter_id NUMBER,
52 parameter_name VARCHAR2(155),
53 parameter_value NUMBER
54 );
55
56 /** SBALASHA001 -
57 INFO: Table to hold CtxParameter_rec records
58 This table is used to send the parameter
59 and the value evaluated to the calling API
60 in the form of records.
61 **/
62
63 TYPE CtxParameter_tbl IS TABLE OF CtxParameter_rec INDEX BY BINARY_INTEGER;
64
65 /** SBALASHA001 -
66 INFO: Record to hold function id, name, source, code and value.
67 This record is used to send the evaluated operands,
68 name and the value evaluated to the calling API.
69 **/
70 TYPE Function_rec IS RECORD (
71 function_id NUMBER,
72 function_name VARCHAR2(150),
73 function_source VARCHAR2(720),
74 function_code VARCHAR2(30),
75 function_value NUMBER
76 );
77
78 /** SBALASHA001 -
79 INFO: Table to hold Function_rec records.
80 This table is used to send the operand
81 and the value evaluated to the calling API
82 in the form of records.
83 **/
84 TYPE Function_tbl IS TABLE OF Function_rec INDEX BY BINARY_INTEGER;
85
86 ---------------------------------------------------------------------------
87 -- Procedures and Functions
88 ---------------------------------------------------------------------------
89 FUNCTION EVA_GetParameterIDs( p_fma_id IN NUMBER,
90 p_ctx_parameter_tbl OUT NOCOPY CtxParameter_tbl )
91 RETURN NUMBER;
92
93
94 PROCEDURE EVA_GetParameterValues(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_fma_id IN NUMBER,
101 p_contract_id IN NUMBER,
102 x_ctx_parameter_tbl OUT NOCOPY CtxParameter_tbl,
103 p_line_id IN NUMBER DEFAULT NULL );
104
105
106 PROCEDURE EVA_GetFunctionValue(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_fma_id IN NUMBER,
113 p_contract_id IN NUMBER,
114 p_line_id IN NUMBER,
115 p_ctx_parameter_tbl IN CtxParameter_tbl,
116 x_function_tbl OUT NOCOPY Function_tbl);
117
118 END OKL_FORMULAEVALUATE_PVT;