DBA Data[Home] [Help]

APPS.OKC_K_ARTICLE_PVT dependencies on OKC_CVM_PVT

Line 42: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

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

Line 43: x_out_rec OKC_CVM_PVT.cvmv_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
47: from OKC_K_ARTICLES_B CAT,

Line 87: OKC_CVM_PVT.update_contract_version(

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,

Line 138: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

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

Line 139: x_out_rec OKC_CVM_PVT.cvmv_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
143: where id = p_catv_rec.id;

Line 169: OKC_CVM_PVT.update_contract_version(

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,

Line 209: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

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

Line 210: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

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;

Line 287: OKC_CVM_PVT.update_contract_version(

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,

Line 337: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

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,

Line 338: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

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,

Line 353: OKC_CVM_PVT.update_contract_version(

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,

Line 402: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

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

Line 403: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

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;

Line 429: OKC_CVM_PVT.update_contract_version(

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,