APPS.AK_AMPARAM_REGISTRY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

select *
from AK_AM_PARAMETER_REGISTRY
where APPLICATIONMODULE_DEFN_NAME = param_query_code
order by APPLICATIONMODULE_DEFN_NAME;

Line: 103

l_databuffer_tbl.delete;

Line: 198

select APPLICATIONMODULE_DEFN_NAME
from ak_am_parameter_registry
where APPLICATION_ID = appl_id_parm;

Line: 227

FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

Line: 374

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;

Line: 457

l_last_update_date        date;

Line: 458

l_last_update_login       number;

Line: 459

l_last_updated_by         number;

Line: 500

p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login);

Line: 505

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);

Line: 586

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;

Line: 607

l_api_name                CONSTANT varchar2(30) := 'Update_AmPara_Registry';

Line: 611

l_last_update_date        date;

Line: 612

l_last_update_login       number;

Line: 613

l_last_updated_by         number;

Line: 629

savepoint start_update_amparam;

Line: 664

p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login);

Line: 669

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;

Line: 677

FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');

Line: 684

FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_UPDATED');

Line: 702

rollback to start_update_amparam;

Line: 709

FND_MESSAGE.SET_NAME('AK','AK_AMPARAM_REG_NOT_UPDATED');

Line: 714

rollback to start_update_amparam;

Line: 720

rollback to start_update_amparam;

Line: 731

END UPDATE_AMPARAM_REGISTRY;

Line: 1053

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);