The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
OBJECT_VERSION_NUMBER,
OPT_ID,
VALUE,
NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
FROM_DATE,
NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
FROM Okl_Opt_Values_V
WHERE okl_opt_values_v.id = p_id;
l_ovev_rec.LAST_UPDATED_BY,
l_ovev_rec.LAST_UPDATE_DATE,
l_ovev_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
RGP_ID,
NVL(OBJECT1_ID1, Okl_Api.G_MISS_CHAR) OBJECT1_ID1,
NVL(OBJECT2_ID1, Okl_Api.G_MISS_CHAR) OBJECT2_ID1,
NVL(OBJECT3_ID1, Okl_Api.G_MISS_CHAR) OBJECT3_ID1,
NVL(OBJECT1_ID2, Okl_Api.G_MISS_CHAR) OBJECT1_ID2,
NVL(OBJECT2_ID2, Okl_Api.G_MISS_CHAR) OBJECT2_ID2,
NVL(OBJECT3_ID2, Okl_Api.G_MISS_CHAR) OBJECT3_ID2,
NVL(JTOT_OBJECT1_CODE, Okl_Api.G_MISS_CHAR) JTOT_OBJECT1_CODE,
NVL(JTOT_OBJECT2_CODE, Okl_Api.G_MISS_CHAR) JTOT_OBJECT2_CODE,
NVL(JTOT_OBJECT3_CODE, Okl_Api.G_MISS_CHAR) JTOT_OBJECT3_CODE,
NVL(DNZ_CHR_ID, Okl_Api.G_MISS_NUM) DNZ_CHR_ID,
STD_TEMPLATE_YN,
--TEMPLATE_YN,
-- removing dependincies from okc_rules_tl
--COMMENTS,
WARN_YN,
NVL(PRIORITY, Okl_Api.G_MISS_NUM) PRIORITY,
OBJECT_VERSION_NUMBER,
NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
RULE_INFORMATION_CATEGORY,
NVL(RULE_INFORMATION1, Okl_Api.G_MISS_CHAR) RULE_INFORMATION1,
NVL(RULE_INFORMATION2, Okl_Api.G_MISS_CHAR) RULE_INFORMATION2,
NVL(RULE_INFORMATION3, Okl_Api.G_MISS_CHAR) RULE_INFORMATION3,
NVL(RULE_INFORMATION4, Okl_Api.G_MISS_CHAR) RULE_INFORMATION4,
NVL(RULE_INFORMATION5, Okl_Api.G_MISS_CHAR) RULE_INFORMATION5,
NVL(RULE_INFORMATION6, Okl_Api.G_MISS_CHAR) RULE_INFORMATION6,
NVL(RULE_INFORMATION7, Okl_Api.G_MISS_CHAR) RULE_INFORMATION7,
NVL(RULE_INFORMATION8, Okl_Api.G_MISS_CHAR) RULE_INFORMATION8,
NVL(RULE_INFORMATION9, Okl_Api.G_MISS_CHAR) RULE_INFORMATION9,
NVL(RULE_INFORMATION10, Okl_Api.G_MISS_CHAR) RULE_INFORMATION10,
NVL(RULE_INFORMATION11, Okl_Api.G_MISS_CHAR) RULE_INFORMATION11,
NVL(RULE_INFORMATION12, Okl_Api.G_MISS_CHAR) RULE_INFORMATION12,
NVL(RULE_INFORMATION13, Okl_Api.G_MISS_CHAR) RULE_INFORMATION13,
NVL(RULE_INFORMATION14, Okl_Api.G_MISS_CHAR) RULE_INFORMATION14,
NVL(RULE_INFORMATION15, Okl_Api.G_MISS_CHAR) RULE_INFORMATION15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
-- removed references to okc_rules_tl
FROM Okc_Rules_b
WHERE okc_rules_b.id = p_id;
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN;
SELECT FROM_DATE,
TO_DATE
FROM Okl_Options_V opt
WHERE opt.id = p_opt_id;
SELECT '1'
FROM Okl_Options_V opt
WHERE opt.ID = p_opt_id
AND ((opt.FROM_DATE > p_from_date OR
p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
NVL(opt.TO_DATE, p_to_date) < p_to_date);
SELECT '1'
FROM Okl_Opv_Rules_V ovd,
Okl_Opt_Rules_V orl,
Okl_Lse_Scs_Rules_V lsr
WHERE ovd.OVE_ID = p_ove_id
AND orl.ID = ovd.ORL_ID
AND ((orl.LRG_LSE_ID IS NOT NULL
AND lsr.LSE_ID = orl.LRG_LSE_ID
AND lsr.SRD_ID = orl.LRG_SRD_ID)
OR
(orl.LRG_LSE_ID IS NULL
AND lsr.LSE_ID IS NULL
AND lsr.SRD_ID = orl.SRD_ID_FOR))
AND lsr.RULE_GROUP = orl.RGR_RGD_CODE
AND lsr.RULE = orl.RGR_RDF_CODE
AND ((lsr.START_DATE > p_from_date OR
P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
NVL(lsr.END_DATE, p_to_date) < p_to_date);
SELECT '1'
FROM Okl_Pdt_Opt_Vals_V pov
WHERE pov.OVE_ID = p_ove_id
AND (pov.FROM_DATE < p_from_date OR
NVL(pov.TO_DATE, pov.FROM_DATE) > p_to_date);
SELECT '1'
FROM OKL_OPT_VALUES_V
WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND
OKL_OPT_VALUES_V.VALUE = p_unique2;
SELECT ovt.RUL_ID RUL_ID,
ovd.CONTEXT_INTENT CONTEXT_INTENT,
orl.RGR_RGD_CODE RGR_RGD_CODE,
orl.RGR_RDF_CODE RGR_RDF_CODE,
ovt.SEQUENCE_NUMBER SEQUENCE_NUMBER
FROM Okl_Opt_Rules_V orl,
Okl_Opv_Rules_V ovd,
Okl_Ovd_Rul_Tmls_V ovt
WHERE ovd.OVE_ID = p_ove_id
AND orl.ID = ovd.ORL_ID
AND ovt.OVD_ID = ovd.ID;
SELECT '1'
FROM OKC_Rule_Def_Sources_V rds
WHERE rds.RGR_RGD_CODE = p_rgd_code
AND rds.RGR_RDF_CODE = p_rdf_code
AND rds.OBJECT_ID_NUMBER = p_object_id_number
AND rds.JTOT_OBJECT_CODE = p_jtot_object_code
AND rds.BUY_OR_SELL = p_buy_or_sell
AND (rds.START_DATE > p_from_date OR
NVL(rds.END_DATE, p_to_date) < p_to_date);
PROCEDURE check_updates (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
p_upd_ovev_rec IN ovev_rec_type,
p_db_ovev_rec IN ovev_rec_type,
p_ovev_rec IN ovev_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_ovev_rec ovev_rec_type;
END check_updates;
PROCEDURE insert_optvalues(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_optv_rec IN optv_rec_type,
p_ovev_rec IN ovev_rec_type,
x_ovev_rec OUT NOCOPY ovev_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_optvalues';
END insert_optvalues;
PROCEDURE update_optvalues(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_optv_rec IN optv_rec_type,
p_ovev_rec IN ovev_rec_type,
x_ovev_rec OUT NOCOPY ovev_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_optvalues';
/* public api to update options */
Okl_Options_Pub.update_option_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_ovev_rec => l_upd_ovev_rec,
x_ovev_rec => x_ovev_rec);
check_updates(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_upd_ovev_rec => l_upd_ovev_rec,
p_db_ovev_rec => l_db_ovev_rec,
p_ovev_rec => l_ovev_rec,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
/* public api to update options */
Okl_Options_Pub.update_option_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_ovev_rec => l_upd_ovev_rec,
x_ovev_rec => x_ovev_rec);
END update_optvalues;