324: FROM Okc_K_Groups_V
325: WHERE okc_K_groups_v.id = p_id;
326: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
327: SELECT 'x'
328: FROM Okc_K_Headers_V
329: WHERE okc_k_headers_v.id = p_id;
330: l_okc_cgpv_dummy VARCHAR2(1);
331: l_okc_chrv_dummy VARCHAR2(1);
332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
325: WHERE okc_K_groups_v.id = p_id;
326: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
327: SELECT 'x'
328: FROM Okc_K_Headers_V
329: WHERE okc_k_headers_v.id = p_id;
330: l_okc_cgpv_dummy VARCHAR2(1);
331: l_okc_chrv_dummy VARCHAR2(1);
332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
333: l_row_notfound BOOLEAN := TRUE;
2044: IF g_qry_clause IS NOT NULL THEN
2045: l_qry := 'select chrv.id, chrv.contract_number || ' ||
2046: 'decode(chrv.contract_number_modifier, null, null,' ||
2047: ''' ('' || chrv.contract_number_modifier || '')'') contract_number' ||
2048: ' from okc_k_headers_v chrv where ' || g_qry_clause ||
2049: ' and chrv.id not in (select included_chr_id from okc_k_grpings' ||
2050: ' where cgp_parent_id = :1' ||
2051: ' and included_chr_id is not null)' ||
2052: ' order by 2';