DBA Data[Home] [Help]

APPS.OKL_ORL_PVT dependencies on OKL_OPTIONS_V

Line 344: FROM okl_options_v

340: ,x_return_status OUT NOCOPY VARCHAR2)
341: IS
342: CURSOR okl_optv_pk_csr (p_id IN NUMBER) IS
343: SELECT '1'
344: FROM okl_options_v
345: WHERE okl_options_v.id = p_id;
346:
347: l_opt_status VARCHAR2(1);
348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 345: WHERE okl_options_v.id = p_id;

341: IS
342: CURSOR okl_optv_pk_csr (p_id IN NUMBER) IS
343: SELECT '1'
344: FROM okl_options_v
345: WHERE okl_options_v.id = p_id;
346:
347: l_opt_status VARCHAR2(1);
348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
349: l_row_notfound BOOLEAN := TRUE;