DBA Data[Home] [Help]

APPS.OKL_QTE_PVT dependencies on OKL_ASSET_RETURNS_V

Line 2443: FROM OKL_ASSET_RETURNS_V

2439:
2440: -- select the ID of the parent record from the parent
2441: CURSOR okl_artv_csr (p_art_id IN NUMBER) IS
2442: SELECT 'x'
2443: FROM OKL_ASSET_RETURNS_V
2444: WHERE ID = p_art_id;
2445:
2446: l_dummy_var VARCHAR2(1) := '?';
2447:

Line 2469: ,p_token3_value => 'OKL_ASSET_RETURNS_V');

2465: ,p_token1_value => 'art_id'
2466: ,p_token2 => G_CHILD_TABLE_TOKEN
2467: ,p_token2_value => 'OKL_TRX_QUOTES_V'
2468: ,p_token3 => G_PARENT_TABLE_TOKEN
2469: ,p_token3_value => 'OKL_ASSET_RETURNS_V');
2470:
2471: -- notify caller of an error
2472: x_return_status := OKC_API.G_RET_STS_ERROR;
2473:

Line 4277: FROM Okl_Asset_Returns_V

4273: CREATION_DATE,
4274: LAST_UPDATED_BY,
4275: LAST_UPDATE_DATE,
4276: LAST_UPDATE_LOGIN
4277: FROM Okl_Asset_Returns_V
4278: WHERE okl_asset_returns_v.id = p_id;
4279: l_okl_artv_pk okl_artv_pk_csr%ROWTYPE;
4280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4281: l_row_notfound BOOLEAN := TRUE;

Line 4278: WHERE okl_asset_returns_v.id = p_id;

4274: LAST_UPDATED_BY,
4275: LAST_UPDATE_DATE,
4276: LAST_UPDATE_LOGIN
4277: FROM Okl_Asset_Returns_V
4278: WHERE okl_asset_returns_v.id = p_id;
4279: l_okl_artv_pk okl_artv_pk_csr%ROWTYPE;
4280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4281: l_row_notfound BOOLEAN := TRUE;
4282: BEGIN