APPS.OKL_EXECUTE_FORMULA_PUB dependencies on OKL_FORMULAE_V

Line 9: ,p_formula_name IN okl_formulae_v.name%TYPE

5: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
6: ,x_return_status OUT NOCOPY VARCHAR2
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_formula_name IN okl_formulae_v.name%TYPE
10: ,p_contract_id IN okl_k_headers_v.id%TYPE
11: ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
12: ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
13: ,x_value OUT NOCOPY NUMBER

Line 19: l_formula_id okl_formulae_v.id%TYPE;

15: l_msg_count NUMBER;
16: l_msg_data VARCHAR2(100);
17: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: l_formula_id okl_formulae_v.id%TYPE;
20: l_formula_string okl_formulae_v.formula_string%TYPE;
21: l_formula_name okl_formulae_v.name%TYPE;
22: l_contract_id okl_k_headers_v.id%TYPE;
23: l_line_id okl_k_lines_v.id%TYPE;

Line 20: l_formula_string okl_formulae_v.formula_string%TYPE;

16: l_msg_data VARCHAR2(100);
17: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: l_formula_id okl_formulae_v.id%TYPE;
20: l_formula_string okl_formulae_v.formula_string%TYPE;
21: l_formula_name okl_formulae_v.name%TYPE;
22: l_contract_id okl_k_headers_v.id%TYPE;
23: l_line_id okl_k_lines_v.id%TYPE;
24: l_additional_parameters ctxt_val_tbl_type;

Line 21: l_formula_name okl_formulae_v.name%TYPE;

17: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: l_formula_id okl_formulae_v.id%TYPE;
20: l_formula_string okl_formulae_v.formula_string%TYPE;
21: l_formula_name okl_formulae_v.name%TYPE;
22: l_contract_id okl_k_headers_v.id%TYPE;
23: l_line_id okl_k_lines_v.id%TYPE;
24: l_additional_parameters ctxt_val_tbl_type;
25: l_value NUMBER;

Line 102: ,p_formula_name IN okl_formulae_v.name%TYPE

98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,x_return_status OUT NOCOPY VARCHAR2
100: ,x_msg_count OUT NOCOPY NUMBER
101: ,x_msg_data OUT NOCOPY VARCHAR2
102: ,p_formula_name IN okl_formulae_v.name%TYPE
103: ,p_contract_id IN okl_k_headers_v.id%TYPE
104: ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
105: ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
106: ,x_operand_val_tbl OUT NOCOPY operand_val_tbl_type

Line 113: l_formula_id okl_formulae_v.id%TYPE;

109: l_msg_count NUMBER;
110: l_msg_data VARCHAR2(100);
111: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
112: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
113: l_formula_id okl_formulae_v.id%TYPE;
114: l_formula_string okl_formulae_v.formula_string%TYPE;
115: l_formula_name okl_formulae_v.name%TYPE;
116: l_contract_id okl_k_headers_v.id%TYPE;
117: l_line_id okl_k_lines_v.id%TYPE;

Line 114: l_formula_string okl_formulae_v.formula_string%TYPE;

110: l_msg_data VARCHAR2(100);
111: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
112: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
113: l_formula_id okl_formulae_v.id%TYPE;
114: l_formula_string okl_formulae_v.formula_string%TYPE;
115: l_formula_name okl_formulae_v.name%TYPE;
116: l_contract_id okl_k_headers_v.id%TYPE;
117: l_line_id okl_k_lines_v.id%TYPE;
118: l_operand_val_tbl operand_val_tbl_type;

Line 115: l_formula_name okl_formulae_v.name%TYPE;

111: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
112: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
113: l_formula_id okl_formulae_v.id%TYPE;
114: l_formula_string okl_formulae_v.formula_string%TYPE;
115: l_formula_name okl_formulae_v.name%TYPE;
116: l_contract_id okl_k_headers_v.id%TYPE;
117: l_line_id okl_k_lines_v.id%TYPE;
118: l_operand_val_tbl operand_val_tbl_type;
119: l_additional_parameters ctxt_val_tbl_type;