The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
OBJECT_VERSION_NUMBER,
ORL_ID,
OVE_ID,
COPY_OR_ENTER_FLAG,
CONTEXT_INTENT,
CONTEXT_ORG,
CONTEXT_INV_ORG,
CONTEXT_ASSET_BOOK,
NVL(INDIVIDUAL_INSTRUCTIONS,Okl_Api.G_MISS_CHAR) INDIVIDUAL_INSTRUCTIONS,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
FROM Okl_Opv_Rules_V
WHERE Okl_Opv_Rules_V.id = p_id;
l_ovdv_rec.LAST_UPDATED_BY,
l_ovdv_rec.LAST_UPDATE_DATE,
l_ovdv_rec.LAST_UPDATE_LOGIN;
SELECT '1'
FROM Okl_Opt_Values_V ove,
Okl_Opt_Rules_V orl,
Okl_Lse_Scs_Rules_V lsr
WHERE orl.ID = p_orl_id
AND ove.ID = p_ove_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 > ove.FROM_DATE OR
NVL(lsr.END_DATE, NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE)) < NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE));
SELECT '1'
FROM Okl_Pdt_Opt_Vals_V pov,
Okl_Slctd_Optns_V csp
WHERE pov.OVE_ID = p_ove_id
AND csp.POV_ID = pov.ID;
SELECT '1'
FROM Okl_opt_values_V ove
WHERE ove.ID = p_ove_id
AND NVL(ove.TO_DATE, p_date) < p_date;
SELECT '1'
FROM Okl_Ovd_Rul_Tmls_V ovt
WHERE ovt.OVD_ID = p_ovd_id;
SELECT '1'
FROM okl_opv_rules_v
WHERE orl_id = p_orl_id
AND ove_id = p_ove_id
AND context_intent = p_context_intent
AND (context_org IS NULL OR context_org = p_context_org)
AND (context_inv_org IS NULL OR context_inv_org = p_context_inv_org)
AND (context_asset_book IS NULL OR context_asset_book = p_context_asset_book);
SELECT '1'
FROM okl_opt_rules_v
WHERE okl_opt_rules_v.id = p_id;
PROCEDURE insert_overules(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,
p_ovdv_rec IN ovdv_rec_type,
x_ovdv_rec OUT NOCOPY ovdv_rec_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_overules';
/* public api to insert option value rules */
Okl_Option_Rules_Pub.create_option_val_rules(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_ovdv_rec => l_ovdv_rec,
x_ovdv_rec => x_ovdv_rec);
END insert_overules;
PROCEDURE delete_overules(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,
p_ovdv_tbl IN ovdv_tbl_type
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'delete_overules';
/* public api to delete option value rules */
Okl_Option_Rules_Pub.delete_option_val_rules(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_ovdv_tbl => l_ovdv_tbl);
END delete_overules;