[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select object_id
into v_object_id
from fnd_objects
where obj_name=p_object_name;
SELECT GNT.INSTANCE_PK1_VALUE, GNT.INSTANCE_PK2_VALUE, GNT.INSTANCE_PK3_VALUE
FROM fnd_grants gnt, fnd_responsibility fr
WHERE GNT.object_id = p_object_id AND
(((GNT.grantee_type = 'USER' AND
GNT.grantee_key = ''||p_owner_name||'') OR (GNT.grantee_type = 'GROUP' AND
GNT.grantee_key in (select role_name from wf_user_roles wur where wur.user_name = fnd_global.user_name()
and wur.user_orig_system = 'PER' and
wur.user_orig_system_id = fnd_global.employee_id() and
(start_date is NULL or start_date <= SYSDATE) and
(expiration_date is NULL or expiration_date >= SYSDATE))))) AND
(GNT.ctx_secgrp_id = -1 OR GNT.ctx_secgrp_id = FND_GLOBAL.SECURITY_GROUP_ID) AND
(GNT.ctx_resp_id = -1 OR GNT.ctx_resp_id = FND_GLOBAL.RESP_ID) AND
(GNT.ctx_resp_appl_id = -1 OR GNT.ctx_resp_appl_id = FND_GLOBAL.RESP_APPL_ID) AND
(GNT.ctx_org_id = -1 OR GNT.ctx_org_id = FND_PROFILE.VALUE('ORG_ID')) AND
GNT.start_date <= sysdate AND
(GNT.end_date IS NULL OR GNT.end_date >= sysdate) AND
((GNT.INSTANCE_TYPE = 'INSTANCE')
AND fr.responsibility_id = GNT.INSTANCE_PK1_VALUE
AND fr.application_id = GNT.INSTANCE_PK2_VALUE
AND trunc(sysdate) between trunc(fr.start_date) and nvl(fr.end_date, trunc(sysdate)));
insert into per_responsibility_owner(responsibility_id,
application_id,
security_group_id)
values (l_resp_owner_table(I).responsibility_id
,l_resp_owner_table(I).application_id
,l_resp_owner_table(I).security_group_id);
'per.plsql.'||gv_package||'.populate_respowner_temp_table', 'Rows Inserted : '||to_char(I));
select hr_api_transactions_s.nextval from dual;
INSERT INTO REVOKE_ACCESS_TABLE (EVENT_KEY,
EVENT_NAME,
RESP_ID,
RESP_APPL_ID,
SECURITY_GROUP_ID,
USERID_COUNT,
MESSAGE,
USER_NAME)
VALUES(p_event.getEventKey,
p_event.getEventName,
to_number(p_event.GetValueForParameter('RESP_ID')),
to_number(p_event.GetValueForParameter('RESP_APPL_ID')),
to_number(p_event.GetValueForParameter('SECURITY_GROUP_ID')),
usrIdCnt,
p_event.GetValueForParameter('MESSAGE'),
p_event.GetValueForParameter('USER_NAME'||to_char(I)));