DBA Data[Home] [Help]

APPS.OKC_K_ARTICLE_PVT dependencies on OKC_ARTICLE_TRANS_V

Line 206: FROM Okc_Article_Trans_V

202: from OKC_K_ARTICLES_B
203: where cat_id = p_catv_rec.id;
204: CURSOR l_atn_csr IS
205: SELECT '!'
206: FROM Okc_Article_Trans_V
207: WHERE cat_id = p_catv_rec.id;
208: --V
209: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
210: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

Line 249: p_token2_value => 'OKC_ARTICLE_TRANS_V');

245: p_msg_name => G_CHILD_RECORD_FOUND,
246: p_token1 => G_PARENT_TABLE_TOKEN,
247: p_token1_value => 'OKC_K_ARTICLES_V',
248: p_token2 => G_CHILD_TABLE_TOKEN,
249: p_token2_value => 'OKC_ARTICLE_TRANS_V');
250: x_return_status := OKC_API.G_RET_STS_ERROR;
251: return;
252: end if;
253: --V

Line 406: from OKC_ARTICLE_TRANS_V

402: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
403: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
404: cursor dnz_csr is
405: select dnz_chr_id
406: from OKC_ARTICLE_TRANS_V
407: where id = p_atnv_rec.id;
408: --V
409: begin
410: --V