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_AM_CALCULATE_QUOTE_PVT dependencies on OKL_FORMULAE_V

Line 1423: l_formula_name okl_formulae_v.name%TYPE;

1419: x_return_status OUT NOCOPY VARCHAR2) IS
1420:
1421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1422: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1423: l_formula_name okl_formulae_v.name%TYPE;
1424: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
1425: l_proration_fraction NUMBER := 0;
1426: l_tbl_ind NUMBER;
1427: l_cle_amt NUMBER;

Line 1424: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;

1420:
1421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1422: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1423: l_formula_name okl_formulae_v.name%TYPE;
1424: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
1425: l_proration_fraction NUMBER := 0;
1426: l_tbl_ind NUMBER;
1427: l_cle_amt NUMBER;
1428:

Line 2679: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;

2675: x_return_status OUT NOCOPY VARCHAR2) IS
2676:
2677: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2678: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2679: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
2680: l_operand_value NUMBER;
2681: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_non_rule_operand_value';
2682: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2683: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 4328: l_formula_id okl_formulae_v.id%TYPE := NULL;

4324: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4325: l_operand_total NUMBER;
4326: l_formula_total NUMBER := 0;
4327: l_curr_char VARCHAR2(1);
4328: l_formula_id okl_formulae_v.id%TYPE := NULL;
4329: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4330: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4331: l_operand_name okl_operands_v.name%TYPE;
4332: l_dummy_value NUMBER;

Line 4329: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;

4325: l_operand_total NUMBER;
4326: l_formula_total NUMBER := 0;
4327: l_curr_char VARCHAR2(1);
4328: l_formula_id okl_formulae_v.id%TYPE := NULL;
4329: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4330: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4331: l_operand_name okl_operands_v.name%TYPE;
4332: l_dummy_value NUMBER;
4333:

Line 4330: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;

4326: l_formula_total NUMBER := 0;
4327: l_curr_char VARCHAR2(1);
4328: l_formula_id okl_formulae_v.id%TYPE := NULL;
4329: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4330: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4331: l_operand_name okl_operands_v.name%TYPE;
4332: l_dummy_value NUMBER;
4333:
4334: -- Extract evaluation string for a formula

Line 4336: (cp_formula_name IN okl_formulae_v.name%TYPE) IS

4332: l_dummy_value NUMBER;
4333:
4334: -- Extract evaluation string for a formula
4335: CURSOR l_formula_csr
4336: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
4337: SELECT f.id, f.formula_string
4338: FROM okl_formulae_v f
4339: WHERE f.name = cp_formula_name
4340: AND f.start_date <= SYSDATE

Line 4338: FROM okl_formulae_v f

4334: -- Extract evaluation string for a formula
4335: CURSOR l_formula_csr
4336: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
4337: SELECT f.id, f.formula_string
4338: FROM okl_formulae_v f
4339: WHERE f.name = cp_formula_name
4340: AND f.start_date <= SYSDATE
4341: AND NVL (f.end_date, sysdate) >= SYSDATE;
4342:

Line 4345: cp_formula_id IN okl_formulae_v.id%TYPE,

4341: AND NVL (f.end_date, sysdate) >= SYSDATE;
4342:
4343: -- Extract operand name
4344: CURSOR l_operand_csr (
4345: cp_formula_id IN okl_formulae_v.id%TYPE,
4346: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4347: SELECT o.name
4348: FROM okl_formulae_v f,
4349: okl_fmla_oprnds_v l,

Line 4348: FROM okl_formulae_v f,

4344: CURSOR l_operand_csr (
4345: cp_formula_id IN okl_formulae_v.id%TYPE,
4346: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4347: SELECT o.name
4348: FROM okl_formulae_v f,
4349: okl_fmla_oprnds_v l,
4350: okl_operands_v o
4351: WHERE f.id = cp_formula_id
4352: AND l.fma_id = f.id

Line 4591: l_formula_id okl_formulae_v.id%TYPE := NULL;

4587: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4588: l_operand_total NUMBER;
4589: l_formula_total NUMBER := 0;
4590: l_curr_char VARCHAR2(1);
4591: l_formula_id okl_formulae_v.id%TYPE := NULL;
4592: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4593: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4594: l_operand_name okl_operands_v.name%TYPE;
4595: l_dummy_value NUMBER;

Line 4592: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;

4588: l_operand_total NUMBER;
4589: l_formula_total NUMBER := 0;
4590: l_curr_char VARCHAR2(1);
4591: l_formula_id okl_formulae_v.id%TYPE := NULL;
4592: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4593: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4594: l_operand_name okl_operands_v.name%TYPE;
4595: l_dummy_value NUMBER;
4596:

Line 4593: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;

4589: l_formula_total NUMBER := 0;
4590: l_curr_char VARCHAR2(1);
4591: l_formula_id okl_formulae_v.id%TYPE := NULL;
4592: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4593: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4594: l_operand_name okl_operands_v.name%TYPE;
4595: l_dummy_value NUMBER;
4596:
4597: -- Extract evaluation string for a formula

Line 4599: (cp_formula_name IN okl_formulae_v.name%TYPE) IS

4595: l_dummy_value NUMBER;
4596:
4597: -- Extract evaluation string for a formula
4598: CURSOR l_formula_csr
4599: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
4600: SELECT f.id, f.formula_string
4601: FROM okl_formulae_v f
4602: WHERE f.name = cp_formula_name
4603: AND f.start_date <= SYSDATE

Line 4601: FROM okl_formulae_v f

4597: -- Extract evaluation string for a formula
4598: CURSOR l_formula_csr
4599: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
4600: SELECT f.id, f.formula_string
4601: FROM okl_formulae_v f
4602: WHERE f.name = cp_formula_name
4603: AND f.start_date <= SYSDATE
4604: AND NVL (f.end_date, sysdate) >= SYSDATE;
4605:

Line 4608: cp_formula_id IN okl_formulae_v.id%TYPE,

4604: AND NVL (f.end_date, sysdate) >= SYSDATE;
4605:
4606: -- Extract operand name
4607: CURSOR l_operand_csr (
4608: cp_formula_id IN okl_formulae_v.id%TYPE,
4609: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4610: SELECT o.name
4611: FROM okl_formulae_v f,
4612: okl_fmla_oprnds_v l,

Line 4611: FROM okl_formulae_v f,

4607: CURSOR l_operand_csr (
4608: cp_formula_id IN okl_formulae_v.id%TYPE,
4609: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4610: SELECT o.name
4611: FROM okl_formulae_v f,
4612: okl_fmla_oprnds_v l,
4613: okl_operands_v o
4614: WHERE f.id = cp_formula_id
4615: AND l.fma_id = f.id