The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ssv.id1,
ssv.id2,
ssv.name,
ssv.description
FROM okl_strmtyp_source_v ssv
WHERE ssv.status = 'A'
AND ssv.name = NVL(p_name,ssv.name)
AND ssv.id1 = NVL(p_id1,ssv.id1)
AND ssv.id2 = NVL(p_id2,ssv.id2)
ORDER BY ssv.name;
select cle.id ID1,
'#' ID2,
tl.name NAME,
tl.item_description DESCRIPTION
from OKC_K_LINES_B CLE,
OKC_K_LINES_TL TL,
OKC_LINE_STYLES_B LSE,
OKC_K_HEADERS_B CHR
where
cle.lse_id = lse.id
and lse.lty_code = 'USAGE'
and cle.chr_id = chr.id
and tl.id = cle.id
and tl.language = userenv('LANG')
and chr.scs_code = 'SERVICE'
and tl.name = nvl(p_name,tl.name)
and cle.id = nvl(p_id1,cle.id )
and '#' = nvl(p_id2,'#')
and cle.dnz_chr_id=p_chr_id
order by tl.name;
SELECT ulv.id1,
ulv.id2,
ulv.name,
ulv.description
FROM okl_usage_lines_v ulv
WHERE ulv.name = NVL(p_name,ulv.name)
AND ulv.id1 = NVL(p_id1,ulv.id1)
AND ulv.id2 = NVL(p_id2,ulv.id2)
ORDER BY ulv.name; */
SELECT asv.id1,
asv.id2,
asv.name,
asv.description
FROM okx_assets_v asv
WHERE asv.name = p_name --for performance issue bug#5484903
AND asv.id1 = NVL(p_id1,asv.id1)
AND asv.id2 = NVL(p_id2,asv.id2)
ORDER BY asv.name;
SELECT cas.id1,
cas.id2,
cas.name,
cas.description
FROM OKX_COVERED_ASSET_V cas
WHERE cas.okc_line_status NOT IN ('EXPIRED','TERMINATED','CANCELLED','ABANDONED')
AND cas.dnz_chr_id = p_dnz_chr_id -- included for bug#5484903
AND cas.name = NVL(p_name,cas.name)
AND cas.id1 = NVL(p_id1,cas.id1)
AND cas.id2 = NVL(p_id2,cas.id2)
ORDER BY cas.name;
SELECT itv.id1,
itv.id2,
itv.name,
itv.description
FROM OKX_INSTALL_ITEMS_V itv
WHERE itv.name =p_name --for performance issue bug#5484903
AND itv.id1 = NVL(p_id1,itv.id1)
AND itv.id2 = NVL(p_id2,itv.id2)
ORDER BY itv.name;
SELECT syi.id1,
syi.id2,
syi.name,
syi.description
FROM OKX_SYSTEM_ITEMS_V syi
WHERE syi.VENDOR_WARRANTY_FLAG='N'
AND syi.SERVICE_ITEM_FLAG='Y'
AND syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
AND syi.name = NVL(p_name,syi.name)
AND syi.id1 = NVL(p_id1,syi.id1)
AND syi.id2 = NVL(p_id2,syi.id2)
ORDER BY syi.NAME;
SELECT syi.id1,
syi.id2,
syi.name,
syi.description
FROM OKX_SYSTEM_ITEMS_V syi
WHERE syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
AND syi.name = NVL(p_name,syi.name)
AND syi.id1 = NVL(p_id1,syi.id1)
AND syi.id2 = NVL(p_id2,syi.id2)
ORDER BY syi.NAME;
Select AAT.attribute_label_long
FROM FND_APPLICATION_VL FAV ,
AK_ATTRIBUTES_TL AAT ,
AK_ATTRIBUTES AA
WHERE AA.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID
AND AA.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
AND AAT.LANGUAGE = USERENV('LANG')
AND AA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID
and aa.attribute_code = p_ak_attribute
and exists (select 'x' from ak_regions r
where r.region_code = p_ak_region)
and exists (select 'x' from ak_region_items ri
where ri.region_code = p_ak_region
and ri.attribute_code = aa.attribute_code );
SELECT a.attribute_label_long
FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
WHERE ri.region_code = r.region_code
AND ri.attribute_code = a.attribute_code
AND ri.region_code = p_ak_region
AND ri.attribute_code = p_ak_attribute; */
l_select_clause varchar2(2000) default null;
SELECT link_ast.id
from okl_k_lines_full_v sub_line, okc_k_items_v link_ast
where sub_line.id = link_ast.cle_id
and link_ast.object1_id1 = p_link_ast_id1
and link_ast.object1_id2 = p_link_ast_id2
and sub_line.cle_id = p_parent_cle_id
and sub_line.dnz_chr_id = p_chr_id;
SELECT lty_code
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE lse.lse_parent_id = cle.lse_id
AND cle.id = p_cle_id
AND cle.chr_id = p_chr_id;
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset from lov
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_REQUIRED'); -- duplicate values found; pl. select an asset
OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'OKL_LLA_ASSET_NUMBER'); -- duplicate values found; pl. select an asset
PROCEDURE delete_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_line_item_tbl IN line_item_tbl_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_line_item';
OKL_LLA_UTIL_PVT.check_line_update_allowed
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cle_id => p_line_item_tbl(i).cle_id);
delete_contract_line_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => lp_clev_tbl,
p_klev_tbl => lp_klev_tbl,
p_cimv_tbl => lp_cimv_tbl);
SELECT ID1, ID2
FROM OKL_LA_FEE_COVERED_ASSET_UV
WHERE DNZ_CHR_ID = p_chr_id
AND CLE_ID = p_cle_id
AND NAME = p_name;
SELECT ID1,id2
FROM OKL_LA_SRV_COV_AST_UV
WHERE CHR_ID = p_chr_id
and name = p_name;
select count(1)
from okc_k_rel_objs rel
where rel.cle_id = p_cle_id and
rel.rty_code = 'OKLSRV';
SELECT currency_code,sts_code
from okc_k_headers_v chr
where chr.id = p_chr_id;
select lse.id,lse.lty_code
from okc_line_styles_b lse
, okc_k_lines_b cle
where lse.lse_parent_id = cle.lse_id
and cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
select cle.fee_type
from okl_k_lines_full_v cle
where cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
select fee_type
from okl_k_lines kle
where kle.id = p_cle_id;
OKL_LLA_UTIL_PVT.check_line_update_allowed
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cle_id => p_line_item_tbl(i).parent_cle_id);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_fin_clev_rec,
p_klev_rec => l_fin_klev_rec,
x_clev_rec => lx_fin_clev_rec,
x_klev_rec => lx_fin_klev_rec);
PROCEDURE update_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_line_item_tbl IN line_item_tbl_type,
x_line_item_tbl OUT NOCOPY line_item_tbl_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_line_item';
SELECT ID1, ID2
FROM OKL_LA_FEE_COVERED_ASSET_UV
WHERE DNZ_CHR_ID = p_chr_id
AND CLE_ID = p_cle_id
AND NAME = p_name;
SELECT ID1,id2
FROM OKL_LA_SRV_COV_AST_UV
WHERE CHR_ID = p_chr_id
and name = p_name;
select count(1)
from okc_k_rel_objs rel
where rel.cle_id = p_cle_id and
rel.rty_code = 'OKLSRV';
SELECT currency_code,sts_code
from okc_k_headers_v chr
where chr.id = p_chr_id;
select lse.id,lse.lty_code
from okc_line_styles_b lse
, okc_k_lines_b cle
where lse.lse_parent_id = cle.lse_id
and cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
select fee_type
from okl_k_lines kle
where kle.id = p_cle_id;
select object1_id1, dnz_chr_id
from okc_k_items
where id = p_cim_id;
select cle.fee_type
from okl_k_lines_full_v cle
where cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
OKL_LLA_UTIL_PVT.check_line_update_allowed
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cle_id => p_line_item_tbl(i).cle_id);
UPDATE_CONTRACT_LINE_ITEM (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => lp_clev_tbl,
p_klev_tbl => lp_klev_tbl,
p_cimv_tbl => lp_cimv_tbl,
x_clev_tbl => lx_clev_tbl,
x_klev_tbl => lx_klev_tbl,
x_cimv_tbl => lx_cimv_tbl
);
okl_service_integration_pub.update_cov_asset_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => lp_clev_tbl,
p_klev_tbl => lp_klev_tbl,
p_cimv_tbl => lp_cimv_tbl,
p_cov_tbl => lp_srv_cov_tbl,
x_clev_tbl => lx_clev_tbl,
x_klev_tbl => lx_klev_tbl,
x_cimv_tbl => lx_cimv_tbl);
update_contract_line_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => lp_clev_tbl,
p_klev_tbl => lp_klev_tbl,
p_cimv_tbl => lp_cimv_tbl,
x_clev_tbl => lx_clev_tbl,
x_klev_tbl => lx_klev_tbl,
x_cimv_tbl => lx_cimv_tbl);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_fin_clev_rec,
p_klev_rec => l_fin_klev_rec,
x_clev_rec => lx_fin_clev_rec,
x_klev_rec => lx_fin_klev_rec);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => l_fin_clev_tbl,
p_klev_tbl => l_fin_klev_tbl,
x_clev_tbl => lx_fin_clev_tbl,
x_klev_tbl => lx_fin_klev_tbl);
select chr.start_date, chr.end_date
from okc_k_lines_b chr
where id = l_id;
select cle.fee_type
from okl_k_lines_full_v cle
where cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
PROCEDURE update_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_clev_rec IN clev_rec_type,
p_klev_rec IN klev_rec_type,
p_cimv_rec IN cimv_rec_type,
x_clev_rec OUT NOCOPY clev_rec_type,
x_klev_rec OUT NOCOPY klev_rec_type,
x_cimv_rec OUT NOCOPY cimv_rec_type) IS
l_clev_rec clev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_line_item';
select chr.start_date, chr.end_date
from okc_k_lines_b chr
where id = l_id;
select cle.fee_type
from okl_k_lines_full_v cle
where cle.id = p_cle_id
and cle.dnz_chr_id = p_chr_id;
SELECT cle.start_date
FROM okc_k_lines_b cle
WHERE cle.id = p_cle_id;
okl_contract_pvt.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec,
x_clev_rec => x_clev_rec,
x_klev_rec => x_klev_rec
);
okl_okc_migration_pvt.update_contract_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => x_cimv_rec);
OKL_LA_PAYMENTS_PVT.update_pymt_start_date
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => x_clev_rec.dnz_chr_id,
p_cle_id => x_clev_rec.id);
END update_contract_line_item;
PROCEDURE update_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_clev_tbl IN clev_tbl_type,
p_klev_tbl IN klev_tbl_type,
p_cimv_tbl IN cimv_tbl_type,
x_clev_tbl OUT NOCOPY clev_tbl_type,
x_klev_tbl OUT NOCOPY klev_tbl_type,
x_cimv_tbl OUT NOCOPY cimv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_line_item';
update_contract_line_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => p_clev_tbl(i),
p_klev_rec => l_klev_tbl(i),
p_cimv_rec => l_cimv_tbl(i),
x_clev_rec => x_clev_tbl(i),
x_klev_rec => x_klev_tbl(i),
x_cimv_rec => x_cimv_tbl(i));
END update_contract_line_item;
PROCEDURE delete_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_clev_rec IN clev_rec_type,
p_klev_rec IN klev_rec_type,
p_cimv_rec IN cimv_rec_type) IS
/*
-- vthiruva, 09/01/2004
-- START, Code change to enable Business Event
*/
--cursor to fetch the line style code for line style id of the record.
CURSOR lty_code_csr(p_id okc_k_lines_b.id%TYPE) IS
SELECT lse.lty_code lty_code, items.object1_id1 asset_id
FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items
WHERE lines.id = p_id
AND lse.id = lines.lse_id
AND items.cle_id = lines.id;
SELECT rlobj.object1_id1
FROM okc_k_rel_objs_v rlobj
WHERE rlobj.chr_id = p_chr_id
AND rlobj.cle_id = p_line_id
AND rlobj.rty_code = 'OKLSRV'
AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_serv_top_line_id;
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_line_item';
select cim.object1_id1,
cim.dnz_chr_id
from okc_k_items cim,
okc_k_lines_b lnk_fee_cleb,
okc_line_styles_b lnk_fee_lseb,
okc_k_lines_b fee_cleb,
okl_k_lines fee_kle
where cim.id = p_cim_id
and lnk_fee_cleb.id = p_cle_id
and cim.dnz_chr_id = lnk_fee_cleb.dnz_chr_id
and lnk_fee_cleb.lse_id = lnk_fee_lseb.id
and lnk_fee_lseb.lty_code = 'LINK_FEE_ASSET'
and fee_cleb.id = lnk_fee_cleb.cle_id
and fee_cleb.dnz_chr_id = lnk_fee_cleb.dnz_chr_id
and fee_kle.id = fee_cleb.id
and nvl(fee_kle.fee_type,'GENERAL') = 'CAPITALIZED';
Select 'Y' rbk_asst_flag
from okc_k_lines_b cleb,
okc_k_headers_b chrb
where chrb.id = cleb.dnz_chr_id
and chrb.scs_code = 'LEASE'
and chrb.orig_system_source_code = 'OKL_REBOOK'
and cleb.id = p_cle_id
and cleb.orig_system_id1 is not NULL
and exists (select '1'
from okc_k_headers_b orig_chrb,
okc_k_lines_b orig_cleb
where orig_chrb.id = chrb.orig_system_id1
and orig_cleb.id = cleb.orig_system_id1
and orig_cleb.sts_code <> 'ABANDONED'
and orig_cleb.dnz_chr_id = orig_chrb.id);
p_msg_name => 'OKL_LA_RBK_COV_ASSET_DELETE');
okl_okc_migration_pvt.delete_contract_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec);
okl_contract_pvt.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec
);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => l_fin_clev_tbl,
p_klev_tbl => l_fin_klev_tbl,
x_clev_tbl => lx_fin_clev_tbl,
x_klev_tbl => lx_fin_klev_tbl);
END delete_contract_line_item;
PROCEDURE delete_contract_line_item(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_clev_tbl IN clev_tbl_type,
p_klev_tbl IN klev_tbl_type,
p_cimv_tbl IN cimv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_line_item';
delete_contract_line_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => p_clev_tbl(i),
p_klev_rec => l_klev_tbl(i),
p_cimv_rec => l_cimv_tbl(i));
END delete_contract_line_item;