[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
select id
from okc_k_headers_b k
where contract_number = p_contract_number
and scs_code = 'SERVICE';
Select id
from okc_class_operations
where cls_code = 'SERVICE'
and opn_code = 'CHECK_RULE';
select id
from okc_k_headers_b k
where contract_number = p_contract_number
and scs_code = 'SERVICE';
select to_number(cle_id)
from okl_la_link_service_uv
where contract_number = p_contract_number
and item_name = p_item_name;
select id1
from okx_vendors_v
where name = p_supplier_name;
select k.sts_code, sts.ste_code
from OKC_K_HEADERS_B K,
OKC_STATUSES_B STS
where STS.CODE = K.STS_CODE
and K.ID = p_chr_id;
SELECT sty_id
FROM okl_strm_tmpt_full_uv
WHERE STY_PURPOSE = 'SERVICE_PAYMENT'
and exists (SELECT 1
FROM OKC_K_HEADERS_B chr,
OKL_K_HEADERS khr
WHERE chr.id = khr.id
AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID
AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)
AND chr.id = p_chr_id)
and sty_name = p_item_name;
PROCEDURE update_contract_link_serv (
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_chr_id IN NUMBER,
p_cle_id IN NUMBER,
p_contract_number IN VARCHAR2,
p_item_name IN VARCHAR2,
p_supplier_name IN VARCHAR2,
x_cle_id OUT NOCOPY NUMBER ) IS
CURSOR l_serv_contract_csr IS
select id
from okc_k_headers_b k
where contract_number = p_contract_number
and scs_code = 'SERVICE';
Select id
from okc_class_operations
where cls_code = 'SERVICE'
and opn_code = 'CHECK_RULE';
select id
from okc_k_headers_b k
where contract_number = p_contract_number
and scs_code = 'SERVICE';
select to_number(cle_id)
from okl_la_link_service_uv
where contract_number = p_contract_number
and item_name = p_item_name;
select id1
from okx_vendors_v
where name = p_supplier_name;
l_api_name CONSTANT VARCHAR2(30) := 'update_contract_link_serv';
OKL_SERVICE_INTEGRATION_PUB.update_service_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_okl_chr_id => l_chr_id,
p_oks_chr_id => l_s_chr_id, -- Service Contract Header ID
p_oks_service_line_id => l_s_cle_id, -- Service Contract Service Top Line ID
p_supplier_id => l_supp_id,
p_clev_rec => lp_clev_rec,
p_klev_rec => lp_klev_rec,
x_okl_service_line_id => x_okl_cle_id -- Returns Contract Service TOP Line ID
);
END update_contract_link_serv;
select chr.start_date, chr.end_date
from okc_k_headers_b chr
where chr.id = l_id;
SELECT CAPITALIZE_YN
FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
WHERE OKL_STRMTYP.NAME = cap_yn
AND OKL_STRMTYP.STATUS = 'A';
select lty_code
from okc_line_styles_v
where id = lse_id;
PROCEDURE update_contract_top_line(
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,
p_cplv_rec IN cplv_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,
x_cplv_rec OUT NOCOPY cplv_rec_type) IS
l_clev_rec clev_rec_type := p_clev_rec;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_contract_top_line';
select chr.start_date, chr.end_date
from okc_k_headers_b chr
where chr.id = l_id;
SELECT CAPITALIZE_YN
FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
WHERE OKL_STRMTYP.NAME = cap_yn
AND OKL_STRMTYP.STATUS = 'A';
select lty_code
from okc_line_styles_v
where id = lse_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);
okl_okc_migration_pvt.update_k_party_role(
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_cplv_rec => l_cplv_rec,
x_cplv_rec => x_cplv_rec);
okl_okc_migration_pvt.delete_k_party_role(
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_cplv_rec => l_cplv_rec);
END update_contract_top_line;
PROCEDURE update_contract_top_line(
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,
p_cplv_tbl IN cplv_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,
x_cplv_tbl OUT NOCOPY cplv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_contract_top_line';
update_contract_top_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 => p_clev_tbl(i),
p_klev_rec => l_klev_tbl(i),
p_cimv_rec => l_cimv_tbl(i),
p_cplv_rec => l_cplv_tbl(i),
x_clev_rec => x_clev_tbl(i),
x_klev_rec => x_klev_tbl(i),
x_cimv_rec => x_cimv_tbl(i),
x_cplv_rec => x_cplv_tbl(i));
END update_contract_top_line;
PROCEDURE delete_contract_line(
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_chr_id IN number,
p_cle_id IN number) IS
lp_clev_rec OKL_SERVICE_INTEGRATION_PUB.clev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'delete_contract_line';
OKL_SERVICE_INTEGRATION_PUB.delete_service_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 => lp_clev_rec,
p_klev_rec => lp_klev_rec
);
END delete_contract_line;
PROCEDURE delete_contract_top_line(
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,
p_cplv_rec IN cplv_rec_type) IS
l_clev_rec clev_rec_type := p_clev_rec;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_contract_top_line';
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_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_okc_migration_pvt.delete_k_party_role(
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_cplv_rec => l_cplv_rec);
okl_k_party_roles_pvt.delete_k_party_role(
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_cplv_rec => l_cplv_rec,
p_kplv_rec => l_kplv_rec);
END delete_contract_top_line;
PROCEDURE delete_contract_top_line(
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,
p_cplv_tbl IN cplv_tbl_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_contract_top_line';
delete_contract_top_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 => p_clev_tbl(i),
p_klev_rec => l_klev_tbl(i),
p_cimv_rec => l_cimv_tbl(i),
p_cplv_rec => l_cplv_tbl(i)
);
END delete_contract_top_line;
SELECT line.start_date,
line.end_date,
line.amount,
line.capital_amount,
style.lty_code,
line.initial_direct_cost,
line.fee_type
FROM okc_k_headers_b head,
okl_k_lines_full_v line,
okc_line_styles_b style
WHERE head.id = line.dnz_chr_id
AND line.lse_id = style.id
AND head.id = p_chr_id
AND line.id = p_line_id;
SELECT head.scs_code
FROM okc_k_headers_b head
WHERE head.id = p_chr_id ;
SELECT stream.capitalize_yn
FROM okl_k_lines_full_v line,
okc_k_items_v item,
okl_strmtyp_source_v stream
WHERE line.id = p_line_id
AND line.dnz_chr_id = p_chr_id
AND line.id = item.cle_id
AND item.object1_id1 = stream.id1;
SELECT id1
FROM okl_time_units_v
WHERE name = p_frequency
AND status = 'A'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
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_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
);
SELECT style.lty_code
FROM okc_k_lines_b line,
okc_line_styles_b style
WHERE line.lse_id = style.id
AND line.id = p_line_id;
SELECT id1
FROM okx_payables_terms_v
WHERE (name = p_name
AND
p_name IS NOT NULL)
OR (id1 = p_id
AND
p_id IS NOT NULL)
AND status = 'A'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
SELECT id1
FROM okx_vendor_sites_v
WHERE (name = p_name
AND
p_name IS NOT NULL)
OR (id1 = p_id
AND
p_id IS NOT NULL)
AND status = 'A'
AND vendor_id = p_vendor_id
AND TRUNC(SYSDATE) >= NVL(TRUNC(start_date_active), TRUNC(SYSDATE));
SELECT lookup_code
FROM fnd_lookup_values
WHERE lookup_type = 'PAYMENT METHOD'
AND nvl(enabled_flag,'N') = 'Y'
AND lookup_code = p_code
AND trunc(nvl(start_date_active,sysdate)) <= trunc(sysdate)
AND trunc(nvl(end_date_active,sysdate+1)) > trunc(sysdate);