38: p_catv_rec IN catv_rec_type,
39: x_catv_rec OUT NOCOPY catv_rec_type) is
40: l_catv_rec catv_rec_type := p_catv_rec;
41: --V
42: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
43: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
44: --V
45: cursor l_std_art_exists_csr is
46: select STA.NAME
39: x_catv_rec OUT NOCOPY catv_rec_type) is
40: l_catv_rec catv_rec_type := p_catv_rec;
41: --V
42: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
43: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
44: --V
45: cursor l_std_art_exists_csr is
46: select STA.NAME
47: from OKC_K_ARTICLES_B CAT,
83: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
84: return;
85: end if;
86: l_cvmv_rec.chr_id := p_catv_rec.DNZ_CHR_ID;
87: OKC_CVM_PVT.update_contract_version(
88: p_api_version => p_api_version,
89: p_init_msg_list => OKC_API.G_FALSE,
90: x_return_status => x_return_status,
91: x_msg_count => x_msg_count,
134: p_catv_rec IN catv_rec_type,
135: x_catv_rec OUT NOCOPY catv_rec_type) is
136: l_catv_rec catv_rec_type := p_catv_rec;
137: --V
138: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
139: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
140: cursor dnz_csr is
141: select dnz_chr_id
142: from OKC_K_ARTICLES_B
135: x_catv_rec OUT NOCOPY catv_rec_type) is
136: l_catv_rec catv_rec_type := p_catv_rec;
137: --V
138: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
139: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
140: cursor dnz_csr is
141: select dnz_chr_id
142: from OKC_K_ARTICLES_B
143: where id = p_catv_rec.id;
165: end if;
166: open dnz_csr;
167: fetch dnz_csr into l_cvmv_rec.chr_id;
168: close dnz_csr;
169: OKC_CVM_PVT.update_contract_version(
170: p_api_version => p_api_version,
171: p_init_msg_list => OKC_API.G_FALSE,
172: x_return_status => x_return_status,
173: x_msg_count => x_msg_count,
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;
211: cursor dnz_csr is
212: select dnz_chr_id
213: from OKC_K_ARTICLES_B
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;
211: cursor dnz_csr is
212: select dnz_chr_id
213: from OKC_K_ARTICLES_B
214: where id = p_catv_rec.id;
283: x_return_status => x_return_status,
284: p_sccv_rec => l_sccv_rec);
285: end if;
286: end if;
287: OKC_CVM_PVT.update_contract_version(
288: p_api_version => p_api_version,
289: p_init_msg_list => OKC_API.G_FALSE,
290: x_return_status => x_return_status,
291: x_msg_count => x_msg_count,
333: x_msg_data OUT NOCOPY VARCHAR2,
334: p_atnv_rec IN atnv_rec_type,
335: x_atnv_rec OUT NOCOPY atnv_rec_type) is
336: --V
337: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
338: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
339: --V
340: begin
341: okc_atn_pvt.insert_row(p_api_version => p_api_version,
334: p_atnv_rec IN atnv_rec_type,
335: x_atnv_rec OUT NOCOPY atnv_rec_type) is
336: --V
337: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
338: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
339: --V
340: begin
341: okc_atn_pvt.insert_row(p_api_version => p_api_version,
342: p_init_msg_list => p_init_msg_list,
349: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
350: return;
351: end if;
352: l_cvmv_rec.chr_id := p_atnv_rec.DNZ_CHR_ID;
353: OKC_CVM_PVT.update_contract_version(
354: p_api_version => p_api_version,
355: p_init_msg_list => OKC_API.G_FALSE,
356: x_return_status => x_return_status,
357: x_msg_count => x_msg_count,
398: x_msg_count OUT NOCOPY NUMBER,
399: x_msg_data OUT NOCOPY VARCHAR2,
400: p_atnv_rec IN atnv_rec_type) is
401: --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
399: x_msg_data OUT NOCOPY VARCHAR2,
400: p_atnv_rec IN atnv_rec_type) is
401: --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;
425: --V
426: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
427: return;
428: end if;
429: OKC_CVM_PVT.update_contract_version(
430: p_api_version => p_api_version,
431: p_init_msg_list => OKC_API.G_FALSE,
432: x_return_status => x_return_status,
433: x_msg_count => x_msg_count,