The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from AK_EXCLUDED_ITEMS
where responsibility_id = p_responsibility_id
and resp_application_id = p_resp_application_id
and attribute_application_id = p_attribute_application_id
and attribute_code = p_attribute_code;
select 1
from AK_RESP_SECURITY_ATTRIBUTES
where responsibility_id = p_responsibility_id
and resp_application_id = p_resp_application_id
and attribute_application_id = p_attribute_application_id
and attribute_code = p_attribute_code;
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
) is
l_api_version_number CONSTANT number := 1.0;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_db_last_updated_by => null,
p_last_update_date => l_last_update_date,
p_db_last_update_date => null,
p_last_update_login => l_last_update_login,
p_create_or_update => 'CREATE') then
null;
select userenv('LANG') into l_lang
from dual;
insert into AK_EXCLUDED_ITEMS (
RESPONSIBILITY_ID,
RESP_APPLICATION_ID,
ATTRIBUTE_CODE,
ATTRIBUTE_APPLICATION_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_responsibility_id,
p_resp_application_id,
p_attribute_code,
p_attribute_application_id,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
) is
l_api_version_number CONSTANT number := 1.0;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_db_last_updated_by => null,
p_last_update_date => l_last_update_date,
p_db_last_update_date => null,
p_last_update_login => l_last_update_login,
p_create_or_update => 'CREATE') then
null;
select userenv('LANG') into l_lang
from dual;
insert into AK_RESP_SECURITY_ATTRIBUTES (
RESPONSIBILITY_ID,
RESP_APPLICATION_ID,
ATTRIBUTE_CODE,
ATTRIBUTE_APPLICATION_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_responsibility_id,
p_resp_application_id,
p_attribute_code,
p_attribute_application_id,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
l_databuffer_tbl.DELETE;
FND_LOAD_UTIL.OWNER_NAME(p_resp_sec_attr_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(p_resp_sec_attr_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
nvl(to_char(p_resp_sec_attr_rec.last_update_login),'""');
l_databuffer_tbl.DELETE;
FND_LOAD_UTIL.OWNER_NAME(p_excluded_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(p_excluded_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
nvl(to_char(p_excluded_rec.last_update_login),'""');
select *
from AK_EXCLUDED_ITEMS
where RESP_APPLICATION_ID = appl_id_parm;
select *
from AK_EXCLUDED_ITEMS
where RESP_APPLICATION_ID = appl_id_parm
and RESPONSIBILITY_ID = resp_id_parm;
l_select_by_appl_id BOOLEAN;
FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
l_select_by_appl_id := TRUE;
l_select_by_appl_id := FALSE;
if (l_select_by_appl_id) then
--
-- download by application ID
--
open l_get_resp_1_csr(p_application_id);
select *
from AK_RESP_SECURITY_ATTRIBUTES
where RESP_APPLICATION_ID = appl_id_parm;
select *
from AK_RESP_SECURITY_ATTRIBUTES
where RESP_APPLICATION_ID = appl_id_parm
and RESPONSIBILITY_ID = resp_id_parm;
l_select_by_appl_id BOOLEAN;
FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
l_select_by_appl_id := TRUE;
l_select_by_appl_id := FALSE;
if (l_select_by_appl_id) then
--
-- download by application ID
--
open l_get_resp_1_csr(p_application_id);
procedure INSERT_ATTRIBUTE_PK_TABLE (
p_return_status OUT NOCOPY VARCHAR2,
p_attribute_application_id IN NUMBER,
p_attribute_code IN VARCHAR2,
p_attribute_pk_tbl IN OUT NOCOPY AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
) is
l_api_version_number CONSTANT number := 1.0;
l_api_name CONSTANT varchar2(30) := 'Insert_Attribute_PK_Table';
end INSERT_ATTRIBUTE_PK_TABLE;
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_excluded_items_rec.last_updated_by := to_number(l_token);
l_excluded_items_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_excluded_items_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_excluded_items_rec.last_update_login := to_number(l_token);
p_last_updated_by => l_excluded_items_rec.last_updated_by,
p_last_update_date => l_excluded_items_rec.last_update_date,
p_last_update_login => l_excluded_items_rec.last_update_login,
p_loader_timestamp => p_loader_timestamp
);
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_resp_sec_attr_rec.last_updated_by := to_number(l_token);
l_resp_sec_attr_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_resp_sec_attr_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_resp_sec_attr_rec.last_update_login := to_number(l_token);
p_last_updated_by => l_resp_sec_attr_rec.last_updated_by,
p_last_update_date => l_resp_sec_attr_rec.lasT_update_date,
p_lasT_update_login => l_resp_sec_attr_rec.last_update_login,
p_loader_timestamp => p_loader_timestamp
);