[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_REV_REC_NO_UPDATE CONSTANT VARCHAR2(200) := 'OKL_REV_REC_NO_UPDATE';
SELECT
ID,
OBJECT_VERSION_NUMBER,
PDQ_ID,
PDT_ID,
QVE_ID,
FROM_DATE,
TO_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Pdt_Pqy_Vals_V
WHERE okl_pdt_pqy_vals_v.id = p_id;
l_pqvv_rec.LAST_UPDATED_BY,
l_pqvv_rec.LAST_UPDATE_DATE,
l_pqvv_rec.LAST_UPDATE_LOGIN;
SELECT FROM_DATE,
TO_DATE
FROM Okl_products_V pdtv
WHERE pdtv.id = p_pdt_id;
SELECT '1' FROM okl_k_headers_v khdr
WHERE khdr.pdt_id = p_pdt_id;
SELECT '1'
FROM Okl_products_V pdt
WHERE pdt.ID = p_pdt_id
AND NVL(pdt.TO_DATE, p_date) < p_date;
SELECT '1'
FROM Okl_Pqy_Values_V qve
WHERE qve.ID = p_qve_id
AND ((qve.FROM_DATE > p_from_date OR
p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
NVL(qve.TO_DATE, p_to_date) < p_to_date);
SELECT '1'
FROM okl_pdt_pqy_vals_v
WHERE pdt_id = p_pdt_id
AND pdq_id = p_pdq_id
AND id <> NVL(p_pqvv_rec.id,-9999);
SELECT pqy.id pqy_id,pqy.name name,
qve.id qve_id,qve.value value
FROM okl_pdt_pqy_vals_v pqv,
okl_pqy_values_v qve,
okl_pdt_qualitys_v pqy
WHERE pqv.pdt_id = cp_pdt_id
AND pqy.ID = qve.PQY_ID
AND qve.ID = pqv.QVE_ID
AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER','INTEREST_CALCULATION_BASIS','REVENUE_RECOGNITION_METHOD');
SELECT pqy.id pqy_id,pqy.name name,
qve.id qve_id,qve.value value
FROM okl_pdt_pqy_vals_v pqv,
okl_pqy_values_v qve,
okl_pdt_qualitys_v pqy
WHERE pqv.pdt_id = cp_pdt_id
AND pqy.ID = qve.PQY_ID
AND qve.ID = pqv.QVE_ID
AND pqy.name IN ('REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');
SELECT a.deal_type,a. REVENUE_RECOGNITION_METHOD,A.INTEREST_CALCULATION_BASIS
FROM okl_product_parameters_v a
WHERE a.id = p_pdt_id;
SELECT pqy.name
FROM okl_pdt_qualitys pqy,
okl_pdt_pqys pdq
WHERE pdq.id = p_pdq_id
and pqy.id = pdq.pqy_id;
SELECT DISTINCT C.deal_type
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
SELECT DISTINCT decode (C.deal_type, 'SALE','SECURITIZATION','SYNDICATION','SYNDICATION') DEAL_TYPE
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
SELECT DISTINCT C.TAX_OWNER
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
SELECT DISTINCT C.INTEREST_CALC_METH_CODE
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
SELECT DISTINCT C.REVENUE_RECOG_METH_CODE
FROM okl_products_v a,
okl_ae_tmpt_sets_v b,
OKL_ST_GEN_TMPT_SETS c
WHERE a.aes_id = b.id
AND b.gts_id = c.id
AND a.id = p_pdt_id
intersect
select value from okl_pqy_values qve
where qve.id = p_qve_id;
Cursor csr_rev_rec_no_update(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE) IS
SELECT '1'
FROM okl_product_parameters_v pdt
where reporting_pdt_id = p_pdt_id;
l_REV_REC_NO_UPDATE VARCHAR2(1);
OPEN csr_rev_rec_no_update(p_pqvv_rec.pdt_id);
FETCH csr_rev_rec_no_update INTO l_REV_REC_NO_UPDATE;
IF csr_rev_rec_no_update%FOUND AND p_pqvv_rec.qve_id <> p_db_pqvv_rec.qve_id then
Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
p_msg_name => G_REV_REC_NO_UPDATE);
CLOSE csr_rev_rec_no_update;
SELECT COUNT(b.id)
INTO l_leaseop_lessee_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LESSEE'
AND b.name = 'TAXOWNER';
SELECT COUNT(b.id)
INTO l_leaseop_lessee_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LEASEOP'
AND b.name = 'LEASE';
SELECT COUNT(b.id)
INTO l_FLT_FAC_loan_rev_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LOAN-REVOLVING'
AND b.name = 'LEASE';
SELECT COUNT(b.id)
INTO l_FLT_FAC_loan_rev_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'FLOAT_FACTORS'
AND b.name = 'INTEREST_CALCULATION_BASIS';
SELECT COUNT(b.id)
INTO l_FLT_FAC_EST_BILL_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'FLOAT_FACTORS'
AND b.name = 'INTEREST_CALCULATION_BASIS';
SELECT COUNT(b.id)
INTO l_FLT_FAC_EST_BILL_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'ESTIMATED_AND_BILLED'
AND b.name = 'REVENUE_RECOGNITION_METHOD';
SELECT COUNT(b.id)
INTO l_loan_lessor_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LESSOR'
AND b.name = 'TAXOWNER';
SELECT COUNT(b.id)
INTO l_leaseop_lessee_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LOAN'
AND b.name = 'LEASE';
SELECT COUNT(b.id)
INTO l_loanrev_lessor_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LESSOR'
AND b.name = 'TAXOWNER';
SELECT COUNT(b.id)
INTO l_leaseop_lessee_mismatch
FROM OKL_pdt_pqy_vals_V a,
okl_pdt_qualitys_v b,
okl_pqy_values_v c
WHERE a.pdt_ID = p_pqvv_rec.pdt_id
AND b.id = c.pqy_id
AND c.id = p_pqvv_rec.qve_id
AND c.value = 'LOAN-REVOLVING'
AND b.name = 'LEASE';
SELECT '1'
FROM okl_pqy_values_v
WHERE okl_pqy_values_v.id = p_id;
PROCEDURE insert_pqvalues(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pqyv_rec IN pqyv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
p_pqvv_rec IN pqvv_rec_type,
x_pqvv_rec OUT NOCOPY pqvv_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_pqvalues';
/* public api to insert pqyvalues */
-- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.insert_pqy_values
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
Okl_Pqy_Values_Pub.insert_pqy_values(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_pqvv_rec => l_pqvv_rec,
x_pqvv_rec => x_pqvv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.insert_pqy_values ');
END insert_pqvalues;
PROCEDURE update_pqvalues(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pqyv_rec IN pqyv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
p_pqvv_rec IN pqvv_rec_type,
x_pqvv_rec OUT NOCOPY pqvv_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
/* public api to update pqyvalues */
-- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.update_pqy_values
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
Okl_Pqy_Values_Pub.update_pqy_values(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_pqvv_rec => l_pqvv_rec,
x_pqvv_rec => x_pqvv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSUVB.pls call Okl_Pqy_Values_Pub.update_pqy_values ');
END update_pqvalues;
PROCEDURE update_pqvalues(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pqyv_rec IN pqyv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
p_pqvv_tbl IN pqvv_tbl_type,
x_pqvv_tbl OUT NOCOPY pqvv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
update_pqvalues(
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_pqyv_rec => p_pqyv_rec,
p_pdtv_rec => p_pdtv_rec,
p_pqvv_rec => p_pqvv_tbl(i),
x_pqvv_rec => x_pqvv_tbl(i)
);
END update_pqvalues;
PROCEDURE insert_pqvalues(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pqyv_rec IN pqyv_rec_type,
p_pdtv_rec IN pdtv_rec_type,
p_pqvv_tbl IN pqvv_tbl_type,
x_pqvv_tbl OUT NOCOPY pqvv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_pqvalues';
insert_pqvalues(
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_pqyv_rec => p_pqyv_rec,
p_pdtv_rec => p_pdtv_rec,
p_pqvv_rec => p_pqvv_tbl(i),
x_pqvv_rec => x_pqvv_tbl(i)
);
END insert_pqvalues;