APPS.OKC_COE_PVT dependencies on OKC_CONDITION_HEADERS_V

Line 385: FROM Okc_Condition_Headers_V

381: ) RETURN VARCHAR2 IS
382: item_not_found_error EXCEPTION;
383: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
384: SELECT '1'
385: FROM Okc_Condition_Headers_V
386: WHERE okc_condition_headers_v.id = p_id;
387: l_dummy_var VARCHAR2(1);
388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
389: l_row_notfound BOOLEAN := TRUE;

Line 386: WHERE okc_condition_headers_v.id = p_id;

382: item_not_found_error EXCEPTION;
383: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
384: SELECT '1'
385: FROM Okc_Condition_Headers_V
386: WHERE okc_condition_headers_v.id = p_id;
387: l_dummy_var VARCHAR2(1);
388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
389: l_row_notfound BOOLEAN := TRUE;
390: BEGIN

Line 575: FROM Okc_Condition_Headers_V

571: CREATION_DATE,
572: LAST_UPDATED_BY,
573: LAST_UPDATE_DATE,
574: LAST_UPDATE_LOGIN
575: FROM Okc_Condition_Headers_V
576: WHERE okc_condition_headers_v.id = p_id;
577: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
578: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
579: l_row_notfound BOOLEAN := TRUE;

Line 576: WHERE okc_condition_headers_v.id = p_id;

572: LAST_UPDATED_BY,
573: LAST_UPDATE_DATE,
574: LAST_UPDATE_LOGIN
575: FROM Okc_Condition_Headers_V
576: WHERE okc_condition_headers_v.id = p_id;
577: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
578: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
579: l_row_notfound BOOLEAN := TRUE;
580: BEGIN