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_FORMULAE_V

Line 37: l_evaluated_string okl_formulae_v.formula_string%TYPE;

33: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
34: l_return_status VARCHAR2(1);
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;

Line 173: l_formula_id okl_formulae_v.id%TYPE;

169: PRAGMA EXCEPTION_INIT(NO_DML_EXCEPTION,-14551);
170: PRAGMA EXCEPTION_INIT(FUNCTION_DOES_NOT_EXIST,-904);
171:
172: -- Local Variable Declarations
173: l_formula_id okl_formulae_v.id%TYPE;
174: l_contract_id okl_k_headers_v.id%TYPE;
175: l_line_id okl_k_lines_v.id%TYPE;
176: l_value NUMBER;
177: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

Line 181: l_formula_string okl_formulae_v.formula_string%TYPE;

177: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
178: l_return_status VARCHAR2(1);
179: l_msg_count NUMBER;
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;

Line 182: l_evaluated_string okl_formulae_v.formula_string%TYPE;

178: l_return_status VARCHAR2(1);
179: l_msg_count NUMBER;
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;

Line 183: l_evaluated_string2 okl_formulae_v.formula_string%TYPE;

179: l_msg_count NUMBER;
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;

Line 450: ,p_formula_id IN okl_formulae_v.id%TYPE

446: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,x_return_status OUT NOCOPY VARCHAR2
448: ,x_msg_count OUT NOCOPY NUMBER
449: ,x_msg_data OUT NOCOPY VARCHAR2
450: ,p_formula_id IN okl_formulae_v.id%TYPE
451: ,p_formula_string IN okl_formulae_v.formula_string%TYPE
452: ,p_contract_id IN okl_k_headers_v.id%TYPE
453: ,p_line_id IN okl_k_lines_v.id%TYPE
454: ,p_ctx_parameter_tbl IN ctxt_parameter_tbl_type

Line 451: ,p_formula_string IN okl_formulae_v.formula_string%TYPE

447: ,x_return_status OUT NOCOPY VARCHAR2
448: ,x_msg_count OUT NOCOPY NUMBER
449: ,x_msg_data OUT NOCOPY VARCHAR2
450: ,p_formula_id IN okl_formulae_v.id%TYPE
451: ,p_formula_string IN okl_formulae_v.formula_string%TYPE
452: ,p_contract_id IN okl_k_headers_v.id%TYPE
453: ,p_line_id IN okl_k_lines_v.id%TYPE
454: ,p_ctx_parameter_tbl IN ctxt_parameter_tbl_type
455: ,x_operand_val_tbl OUT NOCOPY operand_val_tbl_type

Line 464: l_formula_id okl_formulae_v.id%TYPE;

460: -- Local Variable Declarations
461: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
462: l_operand_val_tbl operand_val_tbl_type;
463: l_operand_val_tbl_null operand_val_tbl_type;
464: l_formula_id okl_formulae_v.id%TYPE;
465: l_formula_name okl_formulae_v.name%TYPE;
466: l_contract_id okl_k_headers_v.id%TYPE;
467: l_line_id okl_k_lines_v.id%TYPE;
468: l_value NUMBER;

Line 465: l_formula_name okl_formulae_v.name%TYPE;

461: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
462: l_operand_val_tbl operand_val_tbl_type;
463: l_operand_val_tbl_null operand_val_tbl_type;
464: l_formula_id okl_formulae_v.id%TYPE;
465: l_formula_name okl_formulae_v.name%TYPE;
466: l_contract_id okl_k_headers_v.id%TYPE;
467: l_line_id okl_k_lines_v.id%TYPE;
468: l_value NUMBER;
469: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

Line 473: l_formula_string okl_formulae_v.formula_string%TYPE;

469: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
470: l_return_status VARCHAR2(1);
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(2000);
473: l_formula_string okl_formulae_v.formula_string%TYPE;
474: l_temp_string okl_formulae_v.formula_string%TYPE DEFAULT NULL;
475: l_temp_string1 okl_formulae_v.formula_string%TYPE DEFAULT NULL;
476: l_evaluated_string okl_formulae_v.formula_string%TYPE;
477: i NUMBER DEFAULT 1;

Line 474: l_temp_string okl_formulae_v.formula_string%TYPE DEFAULT NULL;

470: l_return_status VARCHAR2(1);
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(2000);
473: l_formula_string okl_formulae_v.formula_string%TYPE;
474: l_temp_string okl_formulae_v.formula_string%TYPE DEFAULT NULL;
475: l_temp_string1 okl_formulae_v.formula_string%TYPE DEFAULT NULL;
476: l_evaluated_string okl_formulae_v.formula_string%TYPE;
477: i NUMBER DEFAULT 1;
478: l_api_version CONSTANT NUMBER := 1.0;

Line 475: l_temp_string1 okl_formulae_v.formula_string%TYPE DEFAULT NULL;

471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(2000);
473: l_formula_string okl_formulae_v.formula_string%TYPE;
474: l_temp_string okl_formulae_v.formula_string%TYPE DEFAULT NULL;
475: l_temp_string1 okl_formulae_v.formula_string%TYPE DEFAULT NULL;
476: l_evaluated_string okl_formulae_v.formula_string%TYPE;
477: i NUMBER DEFAULT 1;
478: l_api_version CONSTANT NUMBER := 1.0;
479: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';

Line 476: l_evaluated_string okl_formulae_v.formula_string%TYPE;

472: l_msg_data VARCHAR2(2000);
473: l_formula_string okl_formulae_v.formula_string%TYPE;
474: l_temp_string okl_formulae_v.formula_string%TYPE DEFAULT NULL;
475: l_temp_string1 okl_formulae_v.formula_string%TYPE DEFAULT NULL;
476: l_evaluated_string okl_formulae_v.formula_string%TYPE;
477: i NUMBER DEFAULT 1;
478: l_api_version CONSTANT NUMBER := 1.0;
479: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';
480: l_flag BOOLEAN DEFAULT FALSE;

Line 507: CURSOR formula_csr(cp_formula_id IN okl_formulae_v.id%TYPE) IS

503:
504: FROM okl_operands_v
505: WHERE id = cp_operand_id;
506:
507: CURSOR formula_csr(cp_formula_id IN okl_formulae_v.id%TYPE) IS
508: SELECT name
509: ,formula_string
510: FROM okl_formulae_v
511:

Line 510: FROM okl_formulae_v

506:
507: CURSOR formula_csr(cp_formula_id IN okl_formulae_v.id%TYPE) IS
508: SELECT name
509: ,formula_string
510: FROM okl_formulae_v
511:
512: WHERE id = cp_formula_id;
513:
514: BEGIN

Line 818: ,p_formula_name IN okl_formulae_v.name%TYPE

814:
815: ,x_return_status OUT NOCOPY VARCHAR2
816: ,x_msg_count OUT NOCOPY NUMBER
817: ,x_msg_data OUT NOCOPY VARCHAR2
818: ,p_formula_name IN okl_formulae_v.name%TYPE
819: ,p_contract_id IN okl_k_headers_v.id%TYPE
820: ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
821: ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
822: ,x_value OUT NOCOPY NUMBER

Line 832: l_formula_id okl_formulae_v.id%TYPE;

828: -- Local Variable Declarations
829: l_ctxt_value_tbl ctxt_val_tbl_type;
830: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
831: l_operand_val_tbl operand_val_tbl_type;
832: l_formula_id okl_formulae_v.id%TYPE;
833: l_formula_string okl_formulae_v.formula_string%TYPE;
834: l_formula_name okl_formulae_v.name%TYPE;
835:
836: l_contract_id okl_k_headers_v.id%TYPE;

Line 833: l_formula_string okl_formulae_v.formula_string%TYPE;

829: l_ctxt_value_tbl ctxt_val_tbl_type;
830: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
831: l_operand_val_tbl operand_val_tbl_type;
832: l_formula_id okl_formulae_v.id%TYPE;
833: l_formula_string okl_formulae_v.formula_string%TYPE;
834: l_formula_name okl_formulae_v.name%TYPE;
835:
836: l_contract_id okl_k_headers_v.id%TYPE;
837: l_line_id okl_k_lines_v.id%TYPE;

Line 834: l_formula_name okl_formulae_v.name%TYPE;

830: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
831: l_operand_val_tbl operand_val_tbl_type;
832: l_formula_id okl_formulae_v.id%TYPE;
833: l_formula_string okl_formulae_v.formula_string%TYPE;
834: l_formula_name okl_formulae_v.name%TYPE;
835:
836: l_contract_id okl_k_headers_v.id%TYPE;
837: l_line_id okl_k_lines_v.id%TYPE;
838: l_value NUMBER;

Line 848: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS

844: l_api_version CONSTANT NUMBER := 1.0;
845: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
846:
847: -- Cursor Declarations
848: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS
849: SELECT id
850: ,formula_string
851: FROM okl_formulae_v
852: WHERE name = cp_formula_name

Line 851: FROM okl_formulae_v

847: -- Cursor Declarations
848: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS
849: SELECT id
850: ,formula_string
851: FROM okl_formulae_v
852: WHERE name = cp_formula_name
853: AND start_date <= sysdate
854: AND (end_date IS NULL OR end_date >= sysdate);
855: BEGIN

Line 995: ,p_formula_name IN okl_formulae_v.name%TYPE

991: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
992: ,x_return_status OUT NOCOPY VARCHAR2
993: ,x_msg_count OUT NOCOPY NUMBER
994: ,x_msg_data OUT NOCOPY VARCHAR2
995: ,p_formula_name IN okl_formulae_v.name%TYPE
996: ,p_contract_id IN okl_k_headers_v.id%TYPE
997: ,p_line_id IN okl_k_lines_v.id%TYPE DEFAULT NULL
998: ,p_additional_parameters IN ctxt_val_tbl_type DEFAULT g_additional_parameters_null
999: ,x_operand_val_tbl OUT NOCOPY operand_val_tbl_type

Line 1010: l_formula_id okl_formulae_v.id%TYPE;

1006: -- Local Variable Declarations
1007: l_ctxt_value_tbl ctxt_val_tbl_type;
1008: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
1009: l_operand_val_tbl operand_val_tbl_type;
1010: l_formula_id okl_formulae_v.id%TYPE;
1011: l_formula_string okl_formulae_v.formula_string%TYPE;
1012: l_formula_name okl_formulae_v.name%TYPE;
1013: l_contract_id okl_k_headers_v.id%TYPE;
1014: l_line_id okl_k_lines_v.id%TYPE;

Line 1011: l_formula_string okl_formulae_v.formula_string%TYPE;

1007: l_ctxt_value_tbl ctxt_val_tbl_type;
1008: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
1009: l_operand_val_tbl operand_val_tbl_type;
1010: l_formula_id okl_formulae_v.id%TYPE;
1011: l_formula_string okl_formulae_v.formula_string%TYPE;
1012: l_formula_name okl_formulae_v.name%TYPE;
1013: l_contract_id okl_k_headers_v.id%TYPE;
1014: l_line_id okl_k_lines_v.id%TYPE;
1015: l_value NUMBER;

Line 1012: l_formula_name okl_formulae_v.name%TYPE;

1008: l_ctxt_parameter_tbl ctxt_parameter_tbl_type;
1009: l_operand_val_tbl operand_val_tbl_type;
1010: l_formula_id okl_formulae_v.id%TYPE;
1011: l_formula_string okl_formulae_v.formula_string%TYPE;
1012: l_formula_name okl_formulae_v.name%TYPE;
1013: l_contract_id okl_k_headers_v.id%TYPE;
1014: l_line_id okl_k_lines_v.id%TYPE;
1015: l_value NUMBER;
1016: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

Line 1025: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS

1021: l_api_version CONSTANT NUMBER := 1.0;
1022: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE';
1023:
1024: -- Cursor Declarations
1025: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS
1026: SELECT id
1027: ,formula_string
1028:
1029: FROM okl_formulae_v

Line 1029: FROM okl_formulae_v

1025: CURSOR formula_csr(cp_formula_name IN okl_formulae_v.name%TYPE) IS
1026: SELECT id
1027: ,formula_string
1028:
1029: FROM okl_formulae_v
1030: WHERE name = cp_formula_name
1031: AND start_date <= sysdate
1032: AND (end_date IS NULL OR end_date >= sysdate);
1033: BEGIN