DBA Data[Home] [Help]

APPS.OKL_EXECUTE_FORMULA_PVT dependencies on OKL_OPERANDS_V

Line 146: ,p_dsf_id IN okl_operands_v.dsf_id%TYPE

142: ,x_return_status OUT NOCOPY VARCHAR2
143:
144: ,x_msg_count OUT NOCOPY NUMBER
145: ,x_msg_data OUT NOCOPY VARCHAR2
146: ,p_dsf_id IN okl_operands_v.dsf_id%TYPE
147: ,p_ctx_parameter_tbl IN ctxt_parameter_tbl_type
148: ,p_contract_id IN okl_k_headers_v.id%TYPE
149: ,p_line_id IN okl_k_lines_v.id%TYPE
150: ,x_value OUT NOCOPY NUMBER

Line 481: l_operand_name okl_operands_v.name%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;
481: l_operand_name okl_operands_v.name%TYPE;
482:
483: -- Exception declarations
484: NO_OPERAND_FOUND EXCEPTION;
485: NO_FORMULA_OPERAND_FOUND EXCEPTION;

Line 497: CURSOR operand_csr(cp_operand_id IN okl_operands_v.id%TYPE) IS

493: ,opd_id
494: FROM okl_fmla_oprnds_v
495: WHERE fma_id = cp_fma_id;
496:
497: CURSOR operand_csr(cp_operand_id IN okl_operands_v.id%TYPE) IS
498: SELECT fma_id
499: ,dsf_id
500: ,name
501: ,source

Line 504: FROM okl_operands_v

500: ,name
501: ,source
502: ,opd_type
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