DBA Data[Home] [Help]

APPS.OKL_KBK_APPROVALS_WF dependencies on DUAL

Line 256: FROM dual;

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

Line 858: -- Residual Value

854: || '
855: ' || G_CHAR_AMPERSAND || 'nbsp;
856: ';
857:
858: -- Residual Value
859: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => l_api_version,
860: p_init_msg_list => l_init_msg_list,
861: x_return_status => l_return_status,
862: x_msg_count => l_msg_count,

Line 864: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',

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;

Line 1569: FROM dual;

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;