DBA Data[Home] [Help]

APPS.OKL_KBK_APPROVALS_WF dependencies on DUAL

Line 260: FROM dual;

256: AND T.APPLICATION_NAME = c_trx_type;
257:
258: CURSOR l_wf_item_key_csr IS
259: SELECT okl_wf_item_s.NEXTVAL item_key
260: FROM dual;
261:
262: CURSOR l_trx_try_csr IS
263: SELECT id
264: FROM okl_trx_types_b

Line 884: -- Residual Value

880: || '
881: ' || G_CHAR_AMPERSAND || 'nbsp;
882: ';
883:
884: -- Residual Value
885: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => l_api_version,
886: p_init_msg_list => l_init_msg_list,
887: x_return_status => l_return_status,
888: x_msg_count => l_msg_count,

Line 890: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',

886: p_init_msg_list => l_init_msg_list,
887: x_return_status => l_return_status,
888: x_msg_count => l_msg_count,
889: x_msg_data => l_msg_data,
890: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',
891: p_contract_id => p_contract_id,
892: x_value => l_res_value);
893: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1711: FROM dual;

1707:
1708:
1709: CURSOR l_wf_item_key_csr IS
1710: SELECT okl_wf_item_s.NEXTVAL item_key
1711: FROM dual;
1712:
1713: l_key VARCHAR2(240);
1714: l_process VARCHAR2(30) := G_APPROVAL_PROCESS_WF;
1715: l_item_type VARCHAR2(10) := G_ITEM_TYPE_WF;