[Home] [Help]
PACKAGE: APPS.OKL_EXECUTE_FORMULA_PVT
Source
1 PACKAGE OKL_EXECUTE_FORMULA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRFMLS.pls 120.1 2005/06/13 23:58:52 sgorantl noship $ */
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_EXECUTE_FORMULA_PVT';
13 G_INVALID_FORMULA CONSTANT VARCHAR2(200) := 'OKL_INVALID_FORMULA';
14 G_FORMULAE_NO_DML CONSTANT VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
15 G_INVALID_FORMULA_OPERAND CONSTANT VARCHAR2(200) := 'OKL_INVALID_FORMULA_OPERAND';
16 G_INVALID_OPERAND CONSTANT VARCHAR2(200) := 'OKL_INVALID_OPERAND';
17 G_INVALID_FUNCTION CONSTANT VARCHAR2(200) := 'OKL_INVALID_FUNCTION';
18 G_NO_CONSTANT_OPERAND CONSTANT VARCHAR2(200) := 'OKL_NO_CONSTANT_FOR_OPERAND';
19 G_NO_CONSTANT_FUNCTION CONSTANT VARCHAR2(200) := 'OKL_NO_CONSTANT_FOR_FUNCTION';
20 G_INVALID_FMLA_IN_OPERAND CONSTANT VARCHAR2(200) := 'OKL_INVALID_FMLA_IN_OPERAND';
21 G_VALUE_ERROR CONSTANT VARCHAR2(200) := 'OKL_FORMULA_VALUE_ERROR';
22 G_FUNCTION_DATA_INVALID CONSTANT VARCHAR2(200) := 'OKL_FUNCTION_DATA_INVALID';
23 G_OPERAND_DATA_INVALID CONSTANT VARCHAR2(200) := 'OKL_OPERAND_DATA_INVALID';
24 G_FUNCTION_DOES_NOT_EXIST CONSTANT VARCHAR2(200) := 'OKL_FUNCTION_DOES_NOT_EXIST';
25 G_ERROR_IN_EVALUATE_PARAM CONSTANT VARCHAR2(200) := 'OKL_ERROR_IN_EVALUATE_PARAM';
26 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
27
28 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
29
30 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
31 G_EXCEPTION_ERROR EXCEPTION;
32
33 -- Type Declarations
34
35 TYPE operand_val_rec_type IS RECORD(id okl_operands_v.id%TYPE
36 ,label okl_fmla_oprnds.label%TYPE
37 ,value okl_fnctn_prmtrs_v.value%TYPE
38 );
39 TYPE operand_val_tbl_type IS TABLE OF operand_val_rec_type
40 INDEX BY BINARY_INTEGER;
41
42 TYPE ctxt_val_rec_type IS RECORD(name okl_context_groups_v.name%TYPE
43 ,value okl_fnctn_prmtrs_v.value%TYPE
44 );
45 TYPE ctxt_val_tbl_type IS TABLE OF ctxt_val_rec_type
46 INDEX BY BINARY_INTEGER;
47
48 G_ADDITIONAL_PARAMETERS ctxt_val_tbl_type;
49 G_ADDITIONAL_PARAMETERS_NULL ctxt_val_tbl_type;
50
51
52 SUBTYPE ctxt_parameter_tbl_type IS okl_formulaevaluate_pub.ctxparameter_tbl;
53
54 PROCEDURE execute(p_api_version IN NUMBER
55 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 ,p_formula_name IN okl_formulae_v.name%TYPE
60 ,p_contract_id IN okl_k_headers_v.id%TYPE
61 ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
62 ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
63 ,x_value OUT NOCOPY NUMBER
64 );
65
66 PROCEDURE execute(p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 ,p_formula_name IN okl_formulae_v.name%TYPE
72 ,p_contract_id IN okl_k_headers_v.id%TYPE
73 ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
74 ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
75 ,x_operand_val_tbl OUT NOCOPY operand_val_tbl_type
76 ,x_value OUT NOCOPY NUMBER
77 );
78
79 PROCEDURE execute_eligibility_Criteria(p_api_version IN NUMBER
80 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 ,p_function_name IN okl_data_src_fnctns_v.name%TYPE
85 ,x_value OUT NOCOPY NUMBER
86 );
87
88 END OKL_EXECUTE_FORMULA_PVT;