eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_EXECUTE_FORMULA_PVT dependencies on OKL_DATA_SRC_FNCTNS_V

Line 23: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE

19: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE
24: ,x_value OUT NOCOPY NUMBER
25: ) IS
26:
27: -- Exception declarations

Line 39: l_function_name okl_data_src_fnctns_v.name%TYPE;

35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(2000);
37: l_evaluated_string okl_formulae_v.formula_string%TYPE;
38: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
39: l_function_name okl_data_src_fnctns_v.name%TYPE;
40: l_function_source okl_data_src_fnctns_v.source%TYPE;
41: l_api_version CONSTANT NUMBER := 1.0;
42:
43: l_program_name CONSTANT VARCHAR2(30) := 'execute_eligibility_Criteria';

Line 40: l_function_source okl_data_src_fnctns_v.source%TYPE;

36: l_msg_data VARCHAR2(2000);
37: l_evaluated_string okl_formulae_v.formula_string%TYPE;
38: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
39: l_function_name okl_data_src_fnctns_v.name%TYPE;
40: l_function_source okl_data_src_fnctns_v.source%TYPE;
41: l_api_version CONSTANT NUMBER := 1.0;
42:
43: l_program_name CONSTANT VARCHAR2(30) := 'execute_eligibility_Criteria';
44: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 48: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)

44: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
45:
46: l_flag BOOLEAN DEFAULT FALSE;
47:
48: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)
49: IS
50: SELECT source
51: FROM okl_data_src_fnctns_v
52: WHERE name = cp_function_name

Line 51: FROM okl_data_src_fnctns_v

47:
48: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)
49: IS
50: SELECT source
51: FROM okl_data_src_fnctns_v
52: WHERE name = cp_function_name
53: AND fnctn_code = 'ELIGIBILITY_CRITERIA';
54:
55: BEGIN

Line 184: l_function_source okl_data_src_fnctns_v.source%TYPE;

180: l_msg_data VARCHAR2(2000);
181: l_formula_string okl_formulae_v.formula_string%TYPE;
182: l_evaluated_string okl_formulae_v.formula_string%TYPE;
183: l_evaluated_string2 okl_formulae_v.formula_string%TYPE;
184: l_function_source okl_data_src_fnctns_v.source%TYPE;
185: l_function_source2 okl_data_src_fnctns_v.source%TYPE;
186: l_function_source3 okl_data_src_fnctns_v.source%TYPE;
187: l_fnctn_prmtrs_val_tbl fnctn_prmtrs_val_tbl_type;
188: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';

Line 185: l_function_source2 okl_data_src_fnctns_v.source%TYPE;

181: l_formula_string okl_formulae_v.formula_string%TYPE;
182: l_evaluated_string okl_formulae_v.formula_string%TYPE;
183: l_evaluated_string2 okl_formulae_v.formula_string%TYPE;
184: l_function_source okl_data_src_fnctns_v.source%TYPE;
185: l_function_source2 okl_data_src_fnctns_v.source%TYPE;
186: l_function_source3 okl_data_src_fnctns_v.source%TYPE;
187: l_fnctn_prmtrs_val_tbl fnctn_prmtrs_val_tbl_type;
188: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
189: l_dsf_id okl_data_src_fnctns_v.id%TYPE;

Line 186: l_function_source3 okl_data_src_fnctns_v.source%TYPE;

182: l_evaluated_string okl_formulae_v.formula_string%TYPE;
183: l_evaluated_string2 okl_formulae_v.formula_string%TYPE;
184: l_function_source okl_data_src_fnctns_v.source%TYPE;
185: l_function_source2 okl_data_src_fnctns_v.source%TYPE;
186: l_function_source3 okl_data_src_fnctns_v.source%TYPE;
187: l_fnctn_prmtrs_val_tbl fnctn_prmtrs_val_tbl_type;
188: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
189: l_dsf_id okl_data_src_fnctns_v.id%TYPE;
190: i PLS_INTEGER DEFAULT 1;

Line 189: l_dsf_id okl_data_src_fnctns_v.id%TYPE;

185: l_function_source2 okl_data_src_fnctns_v.source%TYPE;
186: l_function_source3 okl_data_src_fnctns_v.source%TYPE;
187: l_fnctn_prmtrs_val_tbl fnctn_prmtrs_val_tbl_type;
188: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
189: l_dsf_id okl_data_src_fnctns_v.id%TYPE;
190: i PLS_INTEGER DEFAULT 1;
191: j PLS_INTEGER DEFAULT 1;
192: l_api_version CONSTANT NUMBER := 1.0;
193: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FUNCTION';

Line 195: l_function_name okl_data_src_fnctns_v.name%TYPE;

191: j PLS_INTEGER DEFAULT 1;
192: l_api_version CONSTANT NUMBER := 1.0;
193: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FUNCTION';
194: l_flag BOOLEAN DEFAULT FALSE;
195: l_function_name okl_data_src_fnctns_v.name%TYPE;
196: v1c varchar2(400);
197: v2c varchar2(400);
198: v3c varchar2(400);
199: v4c varchar2(400);

Line 202: CURSOR data_src_fnctns_csr(cp_dsf_id IN okl_data_src_fnctns_v.id%TYPE) IS

198: v3c varchar2(400);
199: v4c varchar2(400);
200: v5c varchar2(400);
201:
202: CURSOR data_src_fnctns_csr(cp_dsf_id IN okl_data_src_fnctns_v.id%TYPE) IS
203: SELECT fnctn_code
204: ,name
205: ,source
206: FROM okl_data_src_fnctns_v

Line 206: FROM okl_data_src_fnctns_v

202: CURSOR data_src_fnctns_csr(cp_dsf_id IN okl_data_src_fnctns_v.id%TYPE) IS
203: SELECT fnctn_code
204: ,name
205: ,source
206: FROM okl_data_src_fnctns_v
207: WHERE id = cp_dsf_id;
208:
209: CURSOR fnctn_prmtrs_csr(cp_dsf_id IN okl_fnctn_prmtrs_v.dsf_id%TYPE) IS
210: SELECT dsf_id