[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT chr.contract_number
FROM okl_vp_associations assoc
,okc_k_headers_b chr
WHERE assoc.chr_id = p_vasv_rec.chr_id
AND assoc.assoc_object_id = chr.id
AND chr.scs_code = 'LEASE'
AND assoc.assoc_object_id = p_vasv_rec.assoc_object_id
AND assoc.assoc_object_type_code = p_vasv_rec.assoc_object_type_code
AND (assoc.id <> p_vasv_rec.id OR p_vasv_rec.id = OKL_API.G_MISS_NUM or p_vasv_rec.id IS NULL)
AND (
(trunc(p_vasv_rec.start_date) BETWEEN trunc(assoc.start_date) AND trunc(nvl(assoc.end_date,okl_api.g_miss_date))) OR
(trunc(assoc.start_date) BETWEEN trunc(p_vasv_rec.start_date) AND trunc(nvl(p_vasv_rec.end_date,okl_api.g_miss_date)))
);
SELECT start_date, end_date
FROM okc_k_headers_b
WHERE id = p_object_id
AND scs_code = 'LEASE'
AND template_yn= 'Y';
SELECT valid_from,
valid_to
FROM okl_leaseapp_templ_versions_v
WHERE leaseapp_template_id = p_object_id
AND version_status = 'ACTIVE'
AND version_number = p_version_number;
SELECT change_type_code
,chr_id
FROM okl_vp_change_requests
WHERE id = cp_crs_id;
SELECT id
FROM okl_k_headers
WHERE crs_id = cp_crs_id;
SELECT start_date
,end_date
,contract_number
FROM okc_k_headers_b
WHERE id = cp_chr_id;
SELECT '1'
FROM okl_vp_associations
WHERE chr_id = p_chr_id
AND assoc_object_id = p_assoc_obj_id
AND start_date <= p_start_date
AND nvl(end_date,sysdate) >= nvl(p_end_date,sysdate);
SELECT '1'
FROM okl_vp_associations
WHERE crs_id = p_crs_id
AND assoc_object_id = p_assoc_obj_id
AND start_date <= p_start_date
AND nvl(end_date,sysdate) >= nvl(p_end_date,sysdate);
SELECT -- application_type,
cust_credit_classification,
credit_review_purpose,
-- Change sic_code to industry_code
-- sic_code,
industry_code,
/* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */
-- reference_number
name
FROM OKL_LEASEAPP_TMPLS
WHERE id = cp_assoc_id;
SELECT 'X'
FROM OKL_LEASEAPP_TMPLS lat,
okl_vp_associations_v vpa
WHERE lat.id = vpa.assoc_object_id
AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
AND vpa.chr_id = cp_chr_id
AND lat.cust_credit_classification = cp_credit_class
AND lat.credit_review_purpose = cp_credit_review
AND (lat.industry_code = cp_sic_code OR cp_sic_code IS NULL);
SELECT 'X'
FROM OKL_LEASEAPP_TMPLS lat,
okl_vp_associations_v vpa
WHERE lat.id = vpa.assoc_object_id
AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
AND vpa.crs_id = cp_crs_id
-- Manu 02-Sep-2005 remove references to APPLICATION_TYPE
-- AND lat.application_type = cp_appl_type
AND lat.cust_credit_classification = cp_credit_class
AND lat.credit_review_purpose = cp_credit_review
-- Manu 01-Sep-2005 Change sic_code to industry_code
-- AND lat.sic_code = cp_sic_code;
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = cp_chr_id;
SELECT change_type_code
FROM okl_vp_change_requests
WHERE id = cp_crs_id;
SELECT chr.contract_number
FROM okc_k_headers_b chr,
okl_k_headers khr
WHERE chr.id = khr.id
AND khr.crs_id = cp_crs_id;
SELECT contract_number
FROM OKC_K_HEADERS_B okc,
OKL_VP_CHANGE_REQUESTS chr
WHERE chr.id = cp_crs_id
AND okc.id = chr.chr_id;
SELECT 'X'
FROM okl_vp_associations
WHERE chr_id = cp_chr_id
AND assoc_object_id = cp_object_id
AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
(trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
SELECT 'X'
FROM okl_vp_associations
WHERE crs_id = cp_crs_id
AND assoc_object_id = cp_object_id
AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
(trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
OKL_VAS_PVT.insert_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vasv_rec,
x_vasv_rec);
PROCEDURE delete_vp_associations(
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_vasv_rec IN vasv_rec_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_VP_ASSOCIATIONS';
SELECT chr_id
FROM okl_vp_associations
WHERE id = p_vasv_rec.id;
OKL_VAS_PVT.delete_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vasv_rec);
END delete_vp_associations;
PROCEDURE delete_vp_associations(
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_vasv_tbl IN vasv_tbl_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_VP_ASSOCIATIONS';
delete_vp_associations(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vasv_tbl(i));
END delete_vp_associations;
PROCEDURE update_vp_associations(
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_vasv_rec IN vasv_rec_type,
x_vasv_rec OUT NOCOPY vasv_rec_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VP_ASSOCIATIONS';
if (l_vasv_rec.last_updated_by is null) then
l_vasv_rec.last_updated_by := OKL_API.G_MISS_NUM;
if (l_vasv_rec.last_update_date is null) then
l_vasv_rec.last_update_date := OKL_API.G_MISS_DATE;
OKL_VAS_PVT.update_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_vasv_rec,
x_vasv_rec);
END update_vp_associations;
PROCEDURE update_vp_associations(
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_vasv_tbl IN vasv_tbl_type,
x_vasv_tbl OUT NOCOPY vasv_tbl_type
) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VP_ASSOCIATIONS';
update_vp_associations(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vasv_tbl(i),
x_vasv_tbl(i));
END update_vp_associations;
SELECT start_date,
end_date,
description,
assoc_object_type_code,
assoc_object_id,
assoc_object_version
FROM okl_vp_associations
WHERE id = p_id;
OKL_VAS_PVT.insert_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_vasv_rec,
x_vasv_rec);
SELECT start_date,
end_date,
description,
assoc_object_type_code,
assoc_object_id,
assoc_object_version
FROM okl_vp_associations
WHERE chr_id = p_chr_id
AND crs_id IS NULL;
OKL_VAS_PVT.insert_row(
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_vasv_tbl => l_vasv_tbl,
x_vasv_tbl => xl_vasv_tbl
);