The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_EXCEPTION_CANNOT_UPDATE exception;
SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
WHERE rate_template_id IN
(SELECT std_rate_tmpl_ver_id FROM okl_fe_std_rt_tmp_vers WHERE adj_mat_version_id=p_version_id);
SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
WHERE rate_template_id in
(SELECT std_rate_tmpl_ver_id from okl_fe_std_rt_tmp_vers where adj_mat_version_id=p_version_id);
SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
WHERE rate_card_id IN
(SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);
SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
WHERE rate_card_id IN
(SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);
SELECT effective_from_date, effective_to_date FROM okl_fe_adj_mat_versions where adj_mat_id= p_adj_mat_id
and version_number= p_ver_number-1;
SELECT max(effective_from_date)
FROM okl_fe_criteria_set ech
,okl_fe_criteria ecl
WHERE ecl.criteria_set_id = ech.criteria_set_id
AND ech.source_id = p_version_id AND source_object_code = 'PAM';
SELECT CRITERIA_SET_ID,
OBJECT_VERSION_NUMBER,
SOURCE_ID,
SOURCE_OBJECT_CODE,
MATCH_CRITERIA_CODE,
VALIDATION_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_FE_CRITERIA_SET WHERE SOURCE_ID= p_source_id AND SOURCE_OBJECT_CODE= p_source_object;
SELECT CRITERIA_ID,
OBJECT_VERSION_NUMBER,
MATCH_CRITERIA_CODE,
CRITERIA_SET_ID,
CRIT_CAT_DEF_ID,
Effective_From_DATE,
Effective_To_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_FE_CRITERIA WHERE CRITERIA_SET_ID= p_criteria_set_id;
SELECT CRITERION_VALUE_ID,
OBJECT_VERSION_NUMBER,
CRITERIA_ID,
OPERATOR_CODE,
CRIT_CAT_VALUE1,
CRIT_CAT_VALUE2,
ADJUSTMENT_FACTOR,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_FE_CRITERION_VALUES WHERE CRITERIA_ID = p_criteria_id;
SELECT DATA_TYPE_CODE,
VALUE_TYPE_CODE
FROM OKL_FE_CRIT_CAT_DEF_V where CRIT_CAT_DEF_ID = criteria_def_id;
x_ech_rec.LAST_UPDATED_BY := cat_hdr_rec.LAST_UPDATED_BY;
x_ech_rec.LAST_UPDATE_DATE := cat_hdr_rec.LAST_UPDATE_DATE;
x_ech_rec.LAST_UPDATE_LOGIN := cat_hdr_rec.LAST_UPDATE_LOGIN;
x_ecv_tbl(j).LAST_UPDATED_BY:= cat_values_rec.LAST_UPDATED_BY;
x_ecv_tbl(j).LAST_UPDATE_DATE:= cat_values_rec.LAST_UPDATE_DATE;
x_ecv_tbl(j).LAST_UPDATE_LOGIN:= cat_values_rec.LAST_UPDATE_LOGIN;
x_ecl_tbl(i).LAST_UPDATED_BY := cat_lines_rec.LAST_UPDATED_BY;
x_ecl_tbl(i).LAST_UPDATE_DATE := cat_lines_rec.LAST_UPDATE_DATE;
x_ecl_tbl(i).LAST_UPDATE_LOGIN := cat_lines_rec.LAST_UPDATE_LOGIN;
SELECT ADJ_MAT_ID,
ADJ_MAT_NAME,
ADJ_MAT_DESC,
OBJECT_VERSION_NUMBER,
ORG_ID,
CURRENCY_CODE,
ADJ_MAT_TYPE_CODE,
ORIG_ADJ_MAT_ID,
STS_CODE,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_FE_ADJ_MAT_V WHERE ADJ_MAT_ID= p_adj_mat_id;
SELECT ADJ_MAT_VERSION_ID,
VERSION_NUMBER,
OBJECT_VERSION_NUMBER,
ADJ_MAT_ID,
STS_CODE,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN FROM OKL_FE_ADJ_MAT_VERSIONS
WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER= p_version_number;
x_pamv_rec.LAST_UPDATED_BY := cat_hdr_rec.LAST_UPDATED_BY;
x_pamv_rec.LAST_UPDATE_DATE := cat_hdr_rec.LAST_UPDATE_DATE;
x_pamv_rec.LAST_UPDATE_LOGIN := cat_hdr_rec.LAST_UPDATE_LOGIN;
x_pal_rec.LAST_UPDATED_BY := cat_version_rec.LAST_UPDATED_BY;
x_pal_rec.LAST_UPDATE_DATE := cat_version_rec.LAST_UPDATE_DATE;
x_pal_rec.LAST_UPDATE_LOGIN := cat_version_rec.LAST_UPDATE_LOGIN;
SELECT max(version_number) FROM
OKL_FE_ADJ_MAT_VERSIONS WHERE ADJ_MAT_ID=p_adj_mat_id;
PROCEDURE INSERT_ADJ_MAT(
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_pamv_rec IN okl_pamv_rec,
p_pal_rec IN okl_pal_rec,
x_pamv_rec OUT NOCOPY okl_pamv_rec,
x_pal_rec OUT NOCOPY okl_pal_rec
) IS
l_pamv_rec okl_pamv_rec := p_pamv_rec;
l_api_name VARCHAR2(40):='INSERT_ADJ_MAT';
SELECT 'x'
FROM okl_fe_adj_mat_v
WHERE adj_mat_name = p_name;
okl_pam_pvt.insert_row( l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pamv_rec
,x_pamv_rec);
okl_pal_pvt.insert_row( l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
END INSERT_ADJ_MAT;
PROCEDURE UPDATE_ADJ_MAT(
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_pal_rec IN okl_pal_rec,
x_pal_rec OUT NOCOPY okl_pal_rec
) IS
l_pamv_rec okl_pamv_rec;
l_api_name VARCHAR2(40):='UPDATE_ADJ_MAT';
SELECT effective_from_date, effective_to_date
FROM okl_fe_adj_mat_versions
WHERE adj_mat_id= l_adj_mat_id AND version_number=l_version_number -1;
SELECT max(effective_from_date)
FROM okl_fe_criteria_set ech
,okl_fe_criteria ecl
WHERE ecl.criteria_set_id = ech.criteria_set_id
AND ech.source_id = p_version_id AND source_object_code = 'PAM';
okl_pam_pvt.update_row(l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pamv_rec
,x_pamv_rec);
okl_pal_pvt.update_row( l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
okl_pal_pvt.update_row( l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
END UPDATE_ADJ_MAT;
l_api_name VARCHAR2(40):='UPDATE_ADJ_MAT';
okl_pam_pvt.update_row(l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pamv_rec
,x_pamv_rec);
okl_pal_pvt.insert_row( l_api_version
,l_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
l_api_name VARCHAR2(40):='UPDATE_ADJ_MAT';
okl_pal_pvt.update_row( l_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
SELECT ADJ_MAT_ID,
VERSION_NUMBER,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE
FROM okl_fe_adj_mat_versions
WHERE ADJ_MAT_VERSION_ID = p_version_id;
SELECT ADJ_MAT_VERSION_ID,
EFFECTIVE_TO_DATE FROM okl_fe_adj_mat_versions
WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER = p_version_number;
SELECT max(VERSION_NUMBER) FROM OKL_FE_ADJ_MAT_VERSIONS
WHERE ADJ_MAT_ID = p_adj_mat_id;
select max(effective_from_date) from okl_fe_std_rt_tmp_vers
where adj_mat_version_id=p_version_id;
okl_pal_pvt.update_row( l_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
okl_pal_pvt.update_row( l_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_pal_rec
,x_pal_rec);
okl_pam_pvt.update_row( l_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_pamv_rec
,x_pamv_rec);
SELECT vers.std_rate_tmpl_ver_id ID,hdr.template_name NAME ,vers.version_number VERSION_NUMBER
FROM okl_fe_std_rt_tmp_vers vers, okl_fe_std_rt_tmp_v hdr
WHERE vers.std_rate_tmpl_id = hdr.std_rate_tmpl_id AND vers.adj_mat_version_id=p_version_id
AND vers.STS_CODE='ACTIVE';
SELECT vers.RATE_SET_VERSION_ID ID,hdr.name NAME,vers.version_number VERSION_NUMBER
FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr
WHERE vers.rate_set_id = hdr.id AND vers.adj_mat_version_id=p_version_id
AND vers.STS_CODE='ACTIVE';
SELECT vers.rate_set_version_id id
,hdr.name name
,vers.version_number version_number
FROM okl_fe_rate_set_versions vers
,okl_ls_rt_fctr_sets_v hdr
WHERE vers.rate_set_id = hdr.id
AND vers.std_rate_tmpl_ver_id = p_version_id
AND vers.sts_code = 'ACTIVE';