252: WHERE transaction_type_id = c_trx_type;
253:
254: CURSOR l_wf_item_key_csr IS
255: SELECT okl_wf_item_s.NEXTVAL item_key
256: FROM dual;
257:
258: CURSOR l_trx_try_csr IS
259: SELECT id
260: FROM okl_trx_types_b
854: || '
855:
860: p_init_msg_list => l_init_msg_list,
861: x_return_status => l_return_status,
862: x_msg_count => l_msg_count,
863: x_msg_data => l_msg_data,
864: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',
865: p_contract_id => p_contract_id,
866: x_value => l_res_value);
867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565:
1566:
1567: CURSOR l_wf_item_key_csr IS
1568: SELECT okl_wf_item_s.NEXTVAL item_key
1569: FROM dual;
1570:
1571: l_key VARCHAR2(240);
1572: l_process VARCHAR2(30) := G_APPROVAL_PROCESS_WF;
1573: l_item_type VARCHAR2(10) := G_ITEM_TYPE_WF;