The following lines contain the word 'select', 'insert', 'update' or 'delete':
select *
from AK_AM_PARAMETER_REGISTRY
where APPLICATIONMODULE_DEFN_NAME = param_query_code
order by APPLICATIONMODULE_DEFN_NAME;
l_databuffer_tbl.delete;
select APPLICATIONMODULE_DEFN_NAME
from ak_am_parameter_registry
where APPLICATION_ID = appl_id_parm;
FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
select 1
from ak_am_parameter_registry
where APPLICATIONMODULE_DEFN_NAME = appmodule_defn_name_param
and PARAM_NAME = param_name_param
and param_source = param_value_param;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login);
insert into AK_AM_PARAMETER_REGISTRY (
APPLICATIONMODULE_DEFN_NAME,
PARAM_NAME,
PARAM_SOURCE,
APPLICATION_ID
) values (
p_applicationmodule_defn_name,
p_param_name,
p_param_value,
p_application_id);
PROCEDURE UPDATE_AMPARAM_REGISTRY(
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number IN NUMBER,
p_init_msg_tbl IN BOOLEAN := FALSE,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
p_return_status OUT NOCOPY VARCHAR2,
p_applicationmodule_defn_name IN VARCHAR2,
p_param_name IN VARCHAR2,
p_param_value IN VARCHAR2,
p_application_id IN NUMBER,
p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
p_pass IN NUMBER := 2
) IS
cursor l_get_amparam_registry_csr is
select *
from AK_AM_PARAMETER_REGISTRY
where APPLICATIONMODULE_DEFN_NAME = p_applicationmodule_defn_name
for update of APPLICATION_ID;
l_api_name CONSTANT varchar2(30) := 'Update_AmPara_Registry';
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
savepoint start_update_amparam;
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login);
update AK_AM_PARAMETER_REGISTRY set
application_id = l_amparam_reg_rec.application_id
where applicationmodule_defn_name = p_applicationmodule_defn_name
and param_name = p_param_name
and param_source = p_param_value;
FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');
FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_UPDATED');
rollback to start_update_amparam;
FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_NOT_UPDATED');
rollback to start_update_amparam;
rollback to start_update_amparam;
END UPDATE_AMPARAM_REGISTRY;
if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
AK_AMPARAM_REGISTRY_PVT.UPDATE_AMPARAM_REGISTRY(
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_applicationmodule_defn_name => l_amparam_rec.applicationmodule_defn_name,
p_param_name => l_amparam_rec.param_name,
p_param_value => l_amparam_rec.param_source,
p_application_id => l_amparam_rec.application_id,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass);