eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_SECURITY_PVT SQL Statements

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

Line: 36


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;

Line: 111


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;

Line: 191


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;

Line: 201


l_last_update_date       date;

Line: 202


l_last_update_login      number;

Line: 203


l_last_updated_by        number;

Line: 273


  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 277


  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 281


  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 295


  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;

Line: 308


select userenv('LANG') into l_lang
from dual;

Line: 311


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

Line: 434


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;

Line: 444


l_last_update_date       date;

Line: 445


l_last_update_login      number;

Line: 446


l_last_updated_by        number;

Line: 514


  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 518


  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 522


  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 534


  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;

Line: 547


select userenv('LANG') into l_lang
from dual;

Line: 550


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

Line: 691


l_databuffer_tbl.DELETE;

Line: 713


FND_LOAD_UTIL.OWNER_NAME(p_resp_sec_attr_rec.last_updated_by) || '"';

Line: 715


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

Line: 719


l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = ' ||
nvl(to_char(p_resp_sec_attr_rec.last_update_login),'""');

Line: 831


l_databuffer_tbl.DELETE;

Line: 853


FND_LOAD_UTIL.OWNER_NAME(p_excluded_rec.last_updated_by) || '"';

Line: 855


l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
to_char(p_excluded_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 859


l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = ' ||
nvl(to_char(p_excluded_rec.last_update_login),'""');

Line: 964


select *
from AK_EXCLUDED_ITEMS
where RESP_APPLICATION_ID = appl_id_parm;

Line: 968


select *
from AK_EXCLUDED_ITEMS
where RESP_APPLICATION_ID = appl_id_parm
and RESPONSIBILITY_ID = resp_id_parm;

Line: 979


l_select_by_appl_id       BOOLEAN;

Line: 1000


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

Line: 1033


l_select_by_appl_id := TRUE;

Line: 1035


l_select_by_appl_id := FALSE;

Line: 1042


if (l_select_by_appl_id) then
--
-- download by application ID
--
open l_get_resp_1_csr(p_application_id);

Line: 1182


select *
from AK_RESP_SECURITY_ATTRIBUTES
where RESP_APPLICATION_ID = appl_id_parm;

Line: 1186


select *
from AK_RESP_SECURITY_ATTRIBUTES
where RESP_APPLICATION_ID = appl_id_parm
and RESPONSIBILITY_ID = resp_id_parm;

Line: 1197


l_select_by_appl_id       BOOLEAN;

Line: 1217


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

Line: 1250


l_select_by_appl_id := TRUE;

Line: 1252


l_select_by_appl_id := FALSE;

Line: 1259


if (l_select_by_appl_id) then
--
-- download by application ID
--
open l_get_resp_1_csr(p_application_id);

Line: 1379


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;

Line: 1386


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

Line: 1425


end INSERT_ATTRIBUTE_PK_TABLE;

Line: 1697


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

Line: 1756


elsif (l_column = 'LAST_UPDATED_BY') then
l_excluded_items_rec.last_updated_by := to_number(l_token);

Line: 1760


l_excluded_items_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line: 1762


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

Line: 1766


elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_excluded_items_rec.last_update_login := to_number(l_token);

Line: 1810


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

Line: 1838


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

Line: 1958


elsif (l_column = 'LAST_UPDATED_BY') then
l_resp_sec_attr_rec.last_updated_by := to_number(l_token);

Line: 1962


l_resp_sec_attr_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line: 1964


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

Line: 1968


elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_resp_sec_attr_rec.last_update_login := to_number(l_token);

Line: 2012


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